DW_AR_CASH_RECEIPTS_EN

Table stores one record for each receipt that you enter

Details

Module: Receivables

Key Columns

CASH_RECEIPT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CASH_RECEIPT_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_HDR_ENTITY_ID VARCHAR2 256     Subledger Linkage Header Entity 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    
STATUS VARCHAR2 32     Identifies whether the status of this payment entry is applied, unapplied, unidentified, insufficient funds, reverse payment or stop payment    
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    
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    
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.    
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