DW_AR_REVENUE_AMT_CF

This aggregate table contains the transaction amount and line amount

Details

Module: Receivables

Key Columns

CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CUSTOMER_TRX_ID NUMBER 38 0 True Customer Transaction Id
CUSTOMER_TRX_LINE_ID NUMBER 38 0 True Custoemr Transaction Line ID
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Source record identifier. Value is same as the payment schedule identifier.
LINE_NUMBER NUMBER 38 0 Invoice Line Number
LEDGER_ID NUMBER 38 0 General Ledger Id (only one supported per organization)
TRANSACTION_CURRENCY_CODE VARCHAR2 16 Transaction Currency Code
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger Currency Code
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global Currency code
GLOBAL_CURRENCY_EXCH_RATE NUMBER Global currency conversion rate.
TRX_LINE_TRX_AMOUNT NUMBER Transaction Line amount in transaction currency.
TRX_LINE_LEDGER_AMOUNT NUMBER Transaction Line amount inLedger currency.
TRX_LINE_GLOBAL_AMOUNT NUMBER Transaction Line amount in global currency.
TRX_TOTAL_TRX_AMOUNT NUMBER Total Invoice amount in transaction currency.
TRX_TOTAL_LEDGER_AMOUNT NUMBER Total Invoice amount in Ledger currency.
TRX_TOTAL_GLOBAL_AMOUNT NUMBER Total Invoice amount in Global currency.
CONTRACT_LINE_ID NUMBER 38 0 Contract line identifier.
PROJECT_ID NUMBER 38 0 Project identifier.
TASK_ID NUMBER 38 0 Task identifier.
CONTRACT_HEADER_ID NUMBER 38 0 Contract header identifier.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.