# DW_AR_REVENUE_AMT_CF

This aggregate table contains the transaction amount and line amount

## Details

Module: Receivables

## Key Columns

CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID

## Columns

Columns
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. |  |
CONTRACT_LINE_ID | NUMBER | 38 | 0 |  | Contract line identifier. |  |
PROJECT_ID | NUMBER | 38 | 0 |  | Project identifier. |  |
TASK_ID | NUMBER | 38 | 0 |  | Task identifier. |  |
CONTRACT_HEADER_ID | NUMBER | 38 | 0 |  | Contract header identifier. |  |
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. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.