DW_AR_RCV_APPLICATIONS_CF
The table stores all the records related to creditmemo applications
Details
Module: Receivables
Key Columns
RECEIVABLE_APPLICATION_ID
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. |