This table contains invoice, debit memo, bills receivable, and credit memo header information.
Module: Receivables
CUSTOMER_TRX_ID
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. |