DW_AR_REVENUE_AMT_CF

This aggregate table contains the transaction amount and line amount

Details

Module: Receivables

Key Columns

CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_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.    

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