Table stores the accounting records for revenue, unearned revenue, and unbilled receivables for each invoice or credit memo line
Module: Receivables
CUST_TRX_LINE_GL_DIST_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
CUST_TRX_LINE_GL_DIST_ID | NUMBER | 38 | 0 | True | Revenue distribution identifier | ||
SOURCE_RECORD_ID | VARCHAR2 | 256 | Source record identifier. Value is same as receipt application distribution line identifier. | ||||
SUBLEDGER_LINKAGE_DST_ENTITY_ID | VARCHAR2 | 256 | Subledger Linkage Distribution Entity Id | ||||
CUSTOMER_TRX_ID | NUMBER | 38 | 0 | Transaction identifier | |||
ACCOUNT_CLASS | VARCHAR2 | 32 | Freight, Receivable, Revenue, AutoInvoice Clearing, Tax, Unbilled Receivable, Unearned Revenue, or Charges account type | ||||
CUSTOMER_TRX_LINE_ID | NUMBER | 38 | 0 | Transaction line identifier. | |||
SET_OF_BOOKS_ID | NUMBER | 38 | 0 | Identifies the ledger associated with the distribution line. | |||
CODE_COMBINATION_ID | NUMBER | 38 | 0 | General Ledger account identifier. | |||
COMMENTS | VARCHAR2 | 256 | Comment about the revenue distribution | ||||
GL_DATE | DATE | Accounting date. | |||||
GL_POSTED_DATE | DATE | Date posted | |||||
AMOUNT | NUMBER | Amount of this record in the foreign currency | |||||
ACCTD_AMOUNT | NUMBER | Amount of this record in the functional currency | |||||
CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||||
LATEST_REC_FLAG | VARCHAR2 | 16 | This column identifies the latest record in this table with an ACCOUNT_CLASS of REC. It can have the following values: Y-latest REC record, N-not the latest REC record, or null-not a REC record. One Y exists for each CUSTOMER_TRX_ID. | ||||
ACCOUNT_SET_FLAG | VARCHAR2 | 16 | Indicates if this is an account set record. Y for yes, N otherwise. | ||||
EVENT_ID | NUMBER | 38 | 0 | Subledger accounting event identifier. | |||
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. | |||||
L_LINE_NUMBER | NUMBER | 38 | 0 | Transaction line number. | |||
LL_LINE_NUMBER | NUMBER | 38 | 0 | Transaction line number. | |||
L_INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Inventory item identifier. Mutually exclusive with the column MEMO_LINE_ID. | |||
L_DESCRIPTION | VARCHAR2 | 256 | Line description | ||||
L_TAX_CLASSIFICATION_CODE | VARCHAR2 | 32 | Tax determining attribute used at transaction line level. | ||||
L_UOM_CODE | VARCHAR2 | 16 | Unit of Measure Code | ||||
L_ACCOUNTING_RULE_ID | NUMBER | 38 | 0 | Accounting rule identifier | |||
L_RULE_START_DATE | DATE | First GL date of the invoice. Only used for invoice with rules | |||||
L_RULE_END_DATE | DATE | Last GL date of the invoice. Only used for invoice | |||||
L_EXTENDED_AMOUNT | NUMBER | Transaction line amount | |||||
L_QUANTITY_INVOICED | NUMBER | Quantity of invoice line | |||||
L_QUANTITY_CREDITED | NUMBER | Quantity credited | |||||
L_SALES_ORDER | VARCHAR2 | 64 | Sales order | ||||
L_CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
L_LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
LL_CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
LL_LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
M_MEMO_LINE_ID | NUMBER | 38 | 0 | Memo line identifier. | |||
M_SET_ID | NUMBER | 38 | 0 | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. | |||
M_CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
M_LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
T_PURCHASE_ORDER | VARCHAR2 | 64 | Purchase order number. | ||||
T_TRX_NUMBER | VARCHAR2 | 32 | Transaction number. | ||||
T_INTERFACE_HEADER_CONTEXT | VARCHAR2 | 32 | Interface header context. | ||||
T_INTERFACE_HEADER_ATTRIBUTE1 | VARCHAR2 | 32 | Interface header attribute 1. | ||||
T_COMMENTS | VARCHAR2 | 2048 | Transaction Comments | ||||
T_SPECIAL_INSTRUCTIONS | VARCHAR2 | 256 | Special instructions that can print on invoice. | ||||
T_LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier. | |||
T_BILL_TO_CUSTOMER_ID | NUMBER | 38 | 0 | Bill to customer identifier. | |||
T_SHIP_TO_PARTY_CONTACT_ID | NUMBER | 38 | 0 | Identifier of the ship-to party contact. | |||
T_TERM_ID | NUMBER | 38 | 0 | Payment term identifier. | |||
T_TRX_DATE | DATE | Transaction date. | |||||
T_INVOICE_CURRENCY_CODE | VARCHAR2 | 32 | Invoice currency code. | ||||
T_CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||||
T_BILL_TO_CONTACT_ID | NUMBER | 38 | 0 | Bill to customer contact identifier. | |||
T_SOLD_TO_SITE_USE_ID | NUMBER | 38 | 0 | Sold to customer site use identifier. | |||
T_PAYING_SITE_USE_ID | NUMBER | 38 | 0 | Paying customer site use identifier. | |||
T_SHIP_TO_PARTY_SITE_USE_ID | NUMBER | 38 | 0 | Identifier of the ship-to party site use. | |||
T_CUST_TRX_TYPE_SEQ_ID | NUMBER | 38 | 0 | Transaction type sequence identifier. | |||
T_PRIMARY_RESOURCE_SALESREP_ID | NUMBER | 38 | 0 | Primary sales person identifier. | |||
T_RECEIPT_METHOD_ID | NUMBER | 38 | 0 | Receipt method identifier. | |||
T_COMPLETE_FLAG | VARCHAR2 | 32 | Indicates if transaction is complete. | ||||
T_ORG_ID | NUMBER | 38 | 0 | Indicates the identifier of the business unit associated to the row. | |||
T_BILL_TO_SITE_USE_ID | NUMBER | 38 | 0 | Bill to customer site use identifier. | |||
T_CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
T_REASON_CODE | VARCHAR2 | 32 | Transaction Comments | ||||
T_CT_REFERENCE | VARCHAR2 | 32 | Derived Reference Field is derived from Interface Header attribute based on the batch source. | ||||
T_INVOICING_RULE_ID | NUMBER | 38 | 0 | Invoicing rule identifier. | |||
T_INTERCOMPANY_FLAG | VARCHAR2 | 32 | Indicates if invoice is intercompany. | ||||
T_SOURCE_DOCUMENT_ID | NUMBER | 38 | 0 | Source Document Identifier | |||
T_SOLD_TO_CUSTOMER_ID | NUMBER | 38 | 0 | Sold to customer identifier. | |||
T_DOC_SEQUENCE_VALUE | NUMBER | 38 | 0 | Document sequence value. | |||
T_LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
T_LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | ||||
T_PRIOR_IED_FLAG | VARCHAR2 | 16 | Populate as Y for the OPEN flow and N fow the after IED flow | ||||
TT_TYPE | VARCHAR2 | 32 | Transaction class, such as INV, CM, DM, or CB | ||||
TT_DESCRIPTION | VARCHAR2 | 128 | Transaction type description | ||||
TT_NAME | VARCHAR2 | 32 | Transaction type name | ||||
TT_LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of transaction type. | |||||
TT_CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of transaction type. | |||||
T_BATCH_SOURCE_SEQ_ID | NUMBER | 38 | 0 | Batch source sequence identifier. | |||
L_WAREHOUSE_ID | NUMBER | 38 | 0 | The warehouse identifies the ship-from location and can be used to control taxation. | |||
T_SOLD_TO_PARTY_ID | NUMBER | 38 | 0 | Identifier of the sold-to party. | |||
T_FIRST_PTY_REG_ID | NUMBER | 38 | 0 | Deploying company's Tax Registration number | |||
T_THIRD_PTY_REG_ID | NUMBER | 38 | 0 | Bill-to Customer Tax Registration Number | |||
L_TAX_LINE_ID | NUMBER | 38 | 0 | Identifies the detail tax line in ZX_LINES table that corresponds to this tax line. | |||
UPDATED_BY | VARCHAR2 | 128 | Indicates the user who last updated the row | ||||
T_SHIP_TO_PARTY_ID | NUMBER | 38 | 0 | Identifier of the ship-to party | |||
T_PAYING_CUSTOMER_ID | NUMBER | 38 | 0 | Paying customer identifier. | |||
L_INTERFACE_LINE_CONTEXT | VARCHAR2 | 32 | Interface line context | ||||
L_INTERFACE_LINE_ATTRIBUTE5 | VARCHAR2 | 32 | Interface line attribute value |