DW_AR_BILLS_DISTRIBUTIONS_EN

Table stores the accounting distributions for bills receivable and few trx attributes

Details

Module: Receivables

Key Columns

LINE_ID

Columns

Columns
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    
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.