VIEW: JA.JAI_ST_INVOICE_REVERSAL#

Source

View Text - Preformatted

select REVERSAL_ID REVERSAL_ID, INVOICE_ID INVOICE_ID, LINE_NUM LINE_NUM, BATCH_ID BATCH_ID, BATCH_NAME BATCH_NAME, SOURCE SOURCE, MATCH_TYPE MATCH_TYPE, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, ACCOUNTING_DATE ACCOUNTING_DATE, ORIGINAL_LINE_AMT ORIGINAL_LINE_AMT, RCV_SVC_TAX RCV_SVC_TAX, PARTY_ID PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, MAX_CLAIM_PAYMENT_ID MAX_CLAIM_PAYMENT_ID, TAX_TO_BE_ADJUSTED TAX_TO_BE_ADJUSTED, REVERSAL_AMOUNT REVERSAL_AMOUNT, OPEN_AMT OPEN_AMT, DATE_OF_REVERSAL DATE_OF_REVERSAL, REFUND_TYPE REFUND_TYPE, AUTHORIZATION_DATE AUTHORIZATION_DATE, AUTHORIZATION_DETAILS AUTHORIZATION_DETAILS, REMARKS REMARKS, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, REVERSAL_SETUP_FLAG REVERSAL_SETUP_FLAG from "JA"."JAI_ST_INVOICE_REVERSAL"

View Text - HTML Formatted

SELECT REVERSAL_ID REVERSAL_ID
, INVOICE_ID INVOICE_ID
, LINE_NUM LINE_NUM
, BATCH_ID BATCH_ID
, BATCH_NAME BATCH_NAME
, SOURCE SOURCE
, MATCH_TYPE MATCH_TYPE
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, ACCOUNTING_DATE ACCOUNTING_DATE
, ORIGINAL_LINE_AMT ORIGINAL_LINE_AMT
, RCV_SVC_TAX RCV_SVC_TAX
, PARTY_ID PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, MAX_CLAIM_PAYMENT_ID MAX_CLAIM_PAYMENT_ID
, TAX_TO_BE_ADJUSTED TAX_TO_BE_ADJUSTED
, REVERSAL_AMOUNT REVERSAL_AMOUNT
, OPEN_AMT OPEN_AMT
, DATE_OF_REVERSAL DATE_OF_REVERSAL
, REFUND_TYPE REFUND_TYPE
, AUTHORIZATION_DATE AUTHORIZATION_DATE
, AUTHORIZATION_DETAILS AUTHORIZATION_DETAILS
, REMARKS REMARKS
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, REVERSAL_SETUP_FLAG REVERSAL_SETUP_FLAG
FROM "JA"."JAI_ST_INVOICE_REVERSAL"