DW_RA_CUST_TRX_LINE_GL_DIST_EN

Table stores the accounting records for revenue, unearned revenue, and unbilled receivables for each invoice or credit memo line

Details

Module: Receivables

Key Columns

CUST_TRX_LINE_GL_DIST_ID

Columns

Columns
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