DW_AR_RECEIPT_DISTRIBUTIONS_EN

Table stores the accounting distributions for receipt applications and few receipt header attributes

Details

Module: Receivables

Key Columns

LINE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LINE_ID NUMBER 38 0 True Uniquely identifier for rows in this table - primarily when these rows are passed to General Ledger    
SOURCE_RECORD_ID VARCHAR2 256     Uniquely identifier for rows in this table - primarily when these rows are passed to General Ledger    
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 256     Subledger linkage distribution entity ID    
CODE_COMBINATION_ID NUMBER 38 0   Foreign key to GL_CODE_COMBINATIONS.CODE_COMBINATION_ID. It is the account to create the journals for.    
AMOUNT_DR NUMBER       Distribution accounted debit amount.    
AMOUNT_CR NUMBER       Distribution accounted credit amount.    
ACCTD_AMOUNT_DR NUMBER       Journal entry accounted debit amount    
ACCTD_AMOUNT_CR NUMBER       Journal entry accounted credit amount    
SOURCE_TYPE VARCHAR2 32     Account type of transaction for which distribution is posted.    
FROM_AMOUNT_DR NUMBER       Debit amount in the currency of the cash receipt    
FROM_AMOUNT_CR NUMBER       credit amount in the currency of the cash receipt    
SOURCE_TABLE VARCHAR2 32     Possible values are CRH for the AR_CASH_RECEIPT_HISTORY_ALL table, RA for the AR_RECEIVABLE_APPLICATIONS_ALL table, ADJ for the AR_ADJUSTMENTS_ALL table, MCD for the AR_MISC_CASH_DISTRIBUTIONS_ALL table, or TH for the AR_TRANSACTION_HISTORY_ALL table.    
SOURCE_ID NUMBER 38 0   Identifier for record in SOURCE_TABLE that created this distribution.    
CURRENCY_CODE VARCHAR2 32     Code defined for a currency    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
REF_CUST_TRX_LINE_GL_DIST_ID NUMBER 38 0   transaction line distribution identifyer    
CASH_RECEIPT_ID NUMBER 38 0   Cash Receipt ID    
RECEIPT_METHOD_ID NUMBER 38 0   Identifies the payment method of the receipt    
RECEIPT_NUMBER VARCHAR2 32     Cash receipt number    
TYPE VARCHAR2 32     Identifies the category of the payment entry - either CASH or MISC; when coding, please use = 'MISC' or != 'MISC' (instead of = 'CASH') because of internal customization    
RECEIPT_APPLN_STATUS_CODE VARCHAR2 32     Identifies whether the status of this payment entry is applied, unapplied, unidentified, insufficient funds, reverse payment or stop payment    
RECEIPT_STATUS_CODE VARCHAR2 32     Receipt status. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=RECEIPT_CREATION_STATUS. Possible values are APPROVED, CLEARED, CONFIRMED, REMITTED, REVERSED, RISK_ELIMINATED    
REVERSAL_CATEGORY VARCHAR2 32     Identifies the reason why the payment entry was reversed    
REVERSAL_REASON_CODE VARCHAR2 32     Indicates reason for reversing receipt, defined by user    
BA_BANK_ACCOUNT_ID NUMBER 38 0   Uniquely identifies the bank account.    
LEGAL_ENTITY_ID NUMBER 38 0   Identifies the legal entity to receive this receipt    
ORG_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row.    
PAY_FROM_CUSTOMER NUMBER 38 0   Identifier of the customer associated with this payment entry    
DEPOSIT_DATE DATE       This will be a user column, and will have no significance within the system    
ANTICIPATED_CLEARING_DATE DATE       Date the receipt is expected to clear the bank    
RECEIPT_DATE DATE       This is the receipt date.    
REVERSAL_DATE DATE       Date payment entry reversed    
RECEIPT_CURRENCY_CODE VARCHAR2 32     Currency code of the payment batch associated with this payment entry    
AMOUNT NUMBER       Amount of the payment entry, denormalized from the history record to allow querying on amount    
EXCHANGE_RATE NUMBER       Exchange rate used to convert foreign amounts into functional currency    
DOC_SEQUENCE_VALUE NUMBER 38 0   Value assigned to document receipt    
CREATED_BY VARCHAR2 64     Who column: indicates the user who created the row.    
BU_BANK_ACCOUNT_NUM VARCHAR2 128     Account number    
BU_BANK_ID NUMBER 38 0   Identifier of the bank that the bank branch belong to    
BU_BRANCH_ID NUMBER 38 0   Identifier of the bank branch that this bank account belongs to    
SET_OF_BOOKS_ID NUMBER 38 0   General ledger set of books used. Only one is supported currently.    
CUSTOMER_BANK_ACCOUNT_ID NUMBER 38 0   Identifies the customer's bank account from where the receipt was paid    
RECEIPT_CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
RECEIPT_LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
VAT_TAX_ID NUMBER 38 0   VAT tax that this miscellaneous receipt is subject    
TAX_RATE NUMBER       The new tax rate entered when you override the rate for an ad hoc tax code    
CUSTOMER_SITE_USE_ID NUMBER 38 0   Identifies the customer's location    
REFERENCE_ID NUMBER 38 0   Foreign key to the AR_BATCHES, AR_CASH_RECEIPTS, or AP_CHECKS tables    
REFERENCE_TYPE VARCHAR2 32     Indicates if this Miscellaneous Receipts is a PAYMENT, RECEIPT, or REMITTANCE    
RECEIVABLES_TRX_ID NUMBER 38 0   Identifier of the transaction associated with this payment entry    
UPDATED_BY VARCHAR2 128     Indicates the user who last updated the row