DW_RA_CUSTOMER_TRX_EN

This table contains invoice, debit memo, bills receivable, and credit memo header information.

Details

Module: Receivables

Key Columns

CUSTOMER_TRX_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CUSTOMER_TRX_ID NUMBER 38 0 True Transaction identifier.    
SOURCE_RECORD_ID VARCHAR2 64     Source Record Identifier for AR_Transactions    
SUBLEDGER_LINKAGE_HDR_ENTITY_ID VARCHAR2 64     Subledger Linkage Header Entity ID    
INTERCOMPANY_FLAG VARCHAR2 16     Indicates if invoice is intercompany.    
LAST_UPDATE_DATE TIMESTAMP       Who column: indicates the date and time of the last update of the row.    
LAST_UPDATED_BY VARCHAR2 128     Who column: indicates the user who last updated the row.    
CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
CREATED_BY VARCHAR2 128     Who column: indicates the user who created the row.    
TRX_NUMBER VARCHAR2 32     Transaction number.    
TRX_DATE DATE       Transaction date.    
BILL_TO_CONTACT_ID NUMBER 38 0   Bill to customer contact identifier.    
SOLD_TO_CUSTOMER_ID NUMBER 38 0   Sold to customer identifier.    
SOLD_TO_SITE_USE_ID NUMBER 38 0   Sold to customer site use identifier.    
BILL_TO_CUSTOMER_ID NUMBER 38 0   Bill to customer identifier.    
BILL_TO_SITE_USE_ID NUMBER 38 0   Bill to customer site use identifier.    
TERM_ID NUMBER 38 0   Payment term identifier.    
PURCHASE_ORDER VARCHAR2 64     Purchase order number.    
COMMENTS VARCHAR2 2048     Comments for AR Transactions.    
INVOICE_CURRENCY_CODE VARCHAR2 16     Invoice currency code.    
COMPLETE_FLAG VARCHAR2 16     Indicates if transaction is complete.    
RECEIPT_METHOD_ID NUMBER 38 0   Receipt method identifier.    
INVOICING_RULE_ID NUMBER 38 0   Invoicing rule identifier.    
INTERFACE_HEADER_ATTRIBUTE1 VARCHAR 32     Interface header attribute 1.    
INTERFACE_HEADER_CONTEXT VARCHAR2 32     Interface header context.    
DOC_SEQUENCE_VALUE NUMBER 38 0   Document sequence value.    
PAYING_SITE_USE_ID NUMBER 38 0   Paying customer site use identifier.    
ORG_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row.    
SPECIAL_INSTRUCTIONS VARCHAR2 256     Special instructions that can print on invoice.    
CT_REFERENCE VARCHAR2 32     Derived Reference Field is derived from Interface Header attribute based on the batch source.    
LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier.    
CUST_TRX_TYPE_SEQ_ID NUMBER 38 0   Transaction type sequence identifier.    
PRIMARY_RESOURCE_SALESREP_ID NUMBER 38 0   Primary sales person identifier.    
SOURCE_DOCUMENT_ID NUMBER 38 0   Source Document Identifier    
TRX_CLASS VARCHAR2 32     Class of the transaction.    
SHIP_TO_PARTY_CONTACT_ID NUMBER 38 0   Identifier of the ship-to party contact.    
SHIP_TO_PARTY_SITE_USE_ID NUMBER 38 0   Identifier of the ship-to party site use.    
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    
PRIOR_IED_FLAG VARCHAR2 16     Determines the dataset based on IED    
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.    
BATCH_SOURCE_SEQ_ID NUMBER 38 0   Batch source sequence identifier.    
REASON_CODE VARCHAR2 32     Reason code identifier    
SOLD_TO_PARTY_ID NUMBER 38 0   Identifier of the sold-to party.    
FIRST_PTY_REG_ID NUMBER 38 0   Deploying company's Tax Registration number    
THIRD_PTY_REG_ID NUMBER 38 0   Bill-to Customer Tax Registration Number    
SHIP_TO_PARTY_ID NUMBER 38 0   Identifier of the ship-to party    
PAYING_CUSTOMER_ID NUMBER 38 0   Paying customer identifier.