DW_AR_RCV_APPLICATIONS_CF

The table stores all the records related to creditmemo applications

Details

Module: Receivables

Key Columns

RECEIVABLE_APPLICATION_ID

Columns

Columns
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     This column is for Oracle Internal use only. 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, 2024, Oracle and/or its affiliates.