Table stores the accounting distributions for receipt applications and few receipt header attributes
Module: Receivables
LINE_ID
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 |