VIEW: JA.JAI_RGM_TRX_REFS#

Source

View Text - Preformatted

select REFERENCE_ID REFERENCE_ID, ORGANIZATION_ID ORGANIZATION_ID, SOURCE SOURCE, INVOICE_ID INVOICE_ID, LINE_ID LINE_ID, TAX_TYPE TAX_TYPE, TAX_ID TAX_ID, TAX_RATE TAX_RATE, TRX_TAX_AMOUNT TRX_TAX_AMOUNT, TRX_CURRENCY TRX_CURRENCY, CURR_CONV_DATE CURR_CONV_DATE, CURR_CONV_RATE CURR_CONV_RATE, TAX_AMOUNT TAX_AMOUNT, RECOVERED_AMOUNT RECOVERED_AMOUNT, DISCOUNTED_AMOUNT DISCOUNTED_AMOUNT, TAXABLE_BASIS TAXABLE_BASIS, RECOVERABLE_AMOUNT RECOVERABLE_AMOUNT, RECOVERABLE_PTG RECOVERABLE_PTG, PARTY_TYPE PARTY_TYPE, PARTY_ID PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, ITEM_LINE_ID ITEM_LINE_ID, ITEM_ID ITEM_ID, PARENT_REFERENCE_ID PARENT_REFERENCE_ID, REVERSAL_FLAG REVERSAL_FLAG, BATCH_ID BATCH_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_RGM_TRX_REFS"

View Text - HTML Formatted

SELECT REFERENCE_ID REFERENCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SOURCE SOURCE
, INVOICE_ID INVOICE_ID
, LINE_ID LINE_ID
, TAX_TYPE TAX_TYPE
, TAX_ID TAX_ID
, TAX_RATE TAX_RATE
, TRX_TAX_AMOUNT TRX_TAX_AMOUNT
, TRX_CURRENCY TRX_CURRENCY
, CURR_CONV_DATE CURR_CONV_DATE
, CURR_CONV_RATE CURR_CONV_RATE
, TAX_AMOUNT TAX_AMOUNT
, RECOVERED_AMOUNT RECOVERED_AMOUNT
, DISCOUNTED_AMOUNT DISCOUNTED_AMOUNT
, TAXABLE_BASIS TAXABLE_BASIS
, RECOVERABLE_AMOUNT RECOVERABLE_AMOUNT
, RECOVERABLE_PTG RECOVERABLE_PTG
, PARTY_TYPE PARTY_TYPE
, PARTY_ID PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, ITEM_LINE_ID ITEM_LINE_ID
, ITEM_ID ITEM_ID
, PARENT_REFERENCE_ID PARENT_REFERENCE_ID
, REVERSAL_FLAG REVERSAL_FLAG
, BATCH_ID BATCH_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_RGM_TRX_REFS"