The table stores all the records related to creditmemo applications
Module: Receivables
RECEIVABLE_APPLICATION_ID
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 | 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 |
Copyright © 2019, 2023, Oracle and/or its affiliates.