This aggregate table contains the transaction amount and line amount
Module: Receivables
CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID
| 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. |
Copyright © 2019, 2024, Oracle and/or its affiliates.