VIEW: JA.JAI_RGM_TRX_RECORDS#

Source

View Text - Preformatted

select REPOSITORY_ID REPOSITORY_ID, REGIME_CODE REGIME_CODE, TAX_TYPE TAX_TYPE, SOURCE SOURCE, SOURCE_TABLE_NAME SOURCE_TABLE_NAME, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID, SOURCE_TRX_TYPE SOURCE_TRX_TYPE, TRANSACTION_DATE TRANSACTION_DATE, TRX_CURRENCY TRX_CURRENCY, CURR_CONV_DATE CURR_CONV_DATE, CURR_CONV_RATE CURR_CONV_RATE, TRX_DEBIT_AMOUNT TRX_DEBIT_AMOUNT, TRX_CREDIT_AMOUNT TRX_CREDIT_AMOUNT, DEBIT_AMOUNT DEBIT_AMOUNT, CREDIT_AMOUNT CREDIT_AMOUNT, SETTLED_AMOUNT SETTLED_AMOUNT, SETTLED_FLAG SETTLED_FLAG, SETTLEMENT_ID SETTLEMENT_ID, ORGANIZATION_TYPE ORGANIZATION_TYPE, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, ACCOUNT_NAME ACCOUNT_NAME, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID, BALANCING_ACCOUNT_ID BALANCING_ACCOUNT_ID, INV_ORGANIZATION_ID INV_ORGANIZATION_ID, REFERENCE_ID REFERENCE_ID, TAX_RATE TAX_RATE, ASSESSABLE_VALUE ASSESSABLE_VALUE, 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, ATTRIBUTE_CONTEXT ATTRIBUTE_CONTEXT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, REGIME_PRIMARY_REGNO REGIME_PRIMARY_REGNO, INVOICE_NO INVOICE_NO, INVOICE_DATE INVOICE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SERVICE_TYPE_CODE SERVICE_TYPE_CODE, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, TRX_REFERENCE1 TRX_REFERENCE1, TRX_REFERENCE2 TRX_REFERENCE2, TRX_REFERENCE3 TRX_REFERENCE3, TRX_REFERENCE4 TRX_REFERENCE4, TRX_REFERENCE5 TRX_REFERENCE5, TRX_REFERENCE_CONTEXT TRX_REFERENCE_CONTEXT from "JA"."JAI_RGM_TRX_RECORDS"

View Text - HTML Formatted

SELECT REPOSITORY_ID REPOSITORY_ID
, REGIME_CODE REGIME_CODE
, TAX_TYPE TAX_TYPE
, SOURCE SOURCE
, SOURCE_TABLE_NAME SOURCE_TABLE_NAME
, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID
, SOURCE_TRX_TYPE SOURCE_TRX_TYPE
, TRANSACTION_DATE TRANSACTION_DATE
, TRX_CURRENCY TRX_CURRENCY
, CURR_CONV_DATE CURR_CONV_DATE
, CURR_CONV_RATE CURR_CONV_RATE
, TRX_DEBIT_AMOUNT TRX_DEBIT_AMOUNT
, TRX_CREDIT_AMOUNT TRX_CREDIT_AMOUNT
, DEBIT_AMOUNT DEBIT_AMOUNT
, CREDIT_AMOUNT CREDIT_AMOUNT
, SETTLED_AMOUNT SETTLED_AMOUNT
, SETTLED_FLAG SETTLED_FLAG
, SETTLEMENT_ID SETTLEMENT_ID
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, ACCOUNT_NAME ACCOUNT_NAME
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID
, BALANCING_ACCOUNT_ID BALANCING_ACCOUNT_ID
, INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, REFERENCE_ID REFERENCE_ID
, TAX_RATE TAX_RATE
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, 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
, ATTRIBUTE_CONTEXT ATTRIBUTE_CONTEXT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, REGIME_PRIMARY_REGNO REGIME_PRIMARY_REGNO
, INVOICE_NO INVOICE_NO
, INVOICE_DATE INVOICE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, TRX_REFERENCE1 TRX_REFERENCE1
, TRX_REFERENCE2 TRX_REFERENCE2
, TRX_REFERENCE3 TRX_REFERENCE3
, TRX_REFERENCE4 TRX_REFERENCE4
, TRX_REFERENCE5 TRX_REFERENCE5
, TRX_REFERENCE_CONTEXT TRX_REFERENCE_CONTEXT
FROM "JA"."JAI_RGM_TRX_RECORDS"