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 | 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, 2023, Oracle and/or its affiliates.