Table stores one record for each receipt that you enter
Module: Receivables
CASH_RECEIPT_ID
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 |