Table stores the accounting distributions for applied creditmemo and few creditmemo trx 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 | |||
H_CUSTOMER_TRX_ID | NUMBER | 38 | 0 | Transaction identifier | Attribute | ||
H_TRX_NUMBER | VARCHAR2 | 32 | Transaction number. | ||||
H_PURCHASE_ORDER | VARCHAR2 | 64 | Purchase order number. | ||||
H_COMMENTS | VARCHAR2 | 2048 | Transaction Comments | ||||
H_SPECIAL_INSTRUCTIONS | VARCHAR2 | 256 | Special instructions that can print on invoice. | ||||
H_LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier. | |||
H_BILL_TO_CUSTOMER_ID | NUMBER | 38 | 0 | Bill to customer identifier. | |||
H_SHIP_TO_PARTY_CONTACT_ID | NUMBER | 38 | 0 | Identifier of the ship-to party contact. | |||
H_TERM_ID | NUMBER | 38 | 0 | Payment term identifier. | |||
H_TRX_DATE | DATE | Transaction date. | |||||
H_INVOICE_CURRENCY_CODE | VARCHAR2 | 32 | Invoice currency code. | ||||
H_CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||||
H_BILL_TO_CONTACT_ID | NUMBER | 38 | 0 | Bill to customer contact identifier. | |||
H_SOLD_TO_SITE_USE_ID | NUMBER | 38 | 0 | Sold to customer site use identifier. | |||
H_PAYING_SITE_USE_ID | NUMBER | 38 | 0 | Paying customer site use identifier. | |||
H_SHIP_TO_PARTY_SITE_USE_ID | NUMBER | 38 | 0 | Identifier of the ship-to party site use. | |||
H_CUST_TRX_TYPE_SEQ_ID | NUMBER | 38 | 0 | Transaction type sequence identifier. | |||
H_PRIMARY_RESOURCE_SALESREP_ID | NUMBER | 38 | 0 | Primary sales person identifier. | |||
H_RECEIPT_METHOD_ID | NUMBER | 38 | 0 | Receipt method identifier. | |||
H_COMPLETE_FLAG | VARCHAR2 | 32 | Indicates if transaction is complete. | ||||
H_ORG_ID | NUMBER | 38 | 0 | Indicates the identifier of the business unit associated to the row. | |||
H_BILL_TO_SITE_USE_ID | NUMBER | 38 | 0 | Bill to customer site use identifier. | |||
H_CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
H_REASON_CODE | VARCHAR2 | 32 | Transaction Comments | ||||
H_CT_REFERENCE | VARCHAR2 | 32 | Derived Reference Field is derived from Interface Header attribute based on the batch source. | ||||
H_INVOICING_RULE_ID | NUMBER | 38 | 0 | Invoicing rule identifier. | |||
H_INTERCOMPANY_FLAG | VARCHAR2 | 32 | Indicates if invoice is intercompany. | ||||
H_SOURCE_DOCUMENT_ID | NUMBER | 38 | 0 | Source Document Identifier | |||
H_SOLD_TO_CUSTOMER_ID | NUMBER | 38 | 0 | Sold to customer identifier. | |||
H_DOC_SEQUENCE_VALUE | NUMBER | 38 | 0 | Document sequence value. | |||
H_LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
H_LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||||
H_BATCH_SOURCE_SEQ_ID | NUMBER | 38 | 0 | Batch source sequence identifier. | |||
H_SOLD_TO_PARTY_ID | NUMBER | 38 | 0 | Identifier of the sold-to party. | |||
H_FIRST_PTY_REG_ID | NUMBER | 38 | 0 | Deploying company's Tax Registration number | |||
H_THIRD_PTY_REG_ID | NUMBER | 38 | 0 | Bill-to Customer Tax Registration Number | |||
H_SHIP_TO_PARTY_ID | NUMBER | 38 | 0 | Identifier of the ship-to party | |||
H_PAYING_CUSTOMER_ID | NUMBER | 38 | 0 | Paying customer identifier. |