DW_AR_RCV_APPLICATIONS_CF

The table stores all the records related to creditmemo applications

Details

Module: Receivables

Key Columns

RECEIVABLE_APPLICATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RECEIVABLE_APPLICATION_ID NUMBER 38 0 True Identifies the receivable application
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Source record identifier. Value is same as receipt application distribution line identifier.
LEDGER_ID NUMBER 38 0 General Ledger Id (only one supported per organization)
ORG_ID NUMBER 38 0 Indicates the identifier of the business unit associated to the row.
AMOUNT_APPLIED NUMBER For same currency applications, the total amount of the application in the currency of the receipt and transaction. For cross currency applications, the total amount of the application in the currency of the transaction.
LEDGER_CURRENCY_CODE VARCHAR2 16 Ledger Currency Code
ACCTD_AMOUNT_APPLIED_FROM NUMBER Receipt portion in functional currency, converted using the receipt rate
ACCTD_AMOUNT_APPLIED_TO NUMBER Amount allocated to the transaction in functional currency, converted using the transaction rate
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global Currency code
GLOBAL_CURRENCY_EXCH_RATE NUMBER Global currency Exchange Rate
GLOBAL_AMOUNT_APPLIED_FROM NUMBER Receipt portion in global currency
GLOBAL_AMOUNT_APPLIED_TO NUMBER Amount allocated to the transaction in global currency
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.