DW_AR_ADJ_DISTRIBUTIONS_EN

Table stores the accounting distributions for adjustments and few adjustment 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_ADJUSTMENT_ID NUMBER 38 0   Adjustment identifier    
H_ADJUSTMENT_NUMBER VARCHAR2 128     Adjustment number automatically generated from AR_ADJUSTMENT_NUMBER_S    
H_COMMENTS VARCHAR2 2048     User-entered comments about the adjustment.    
H_STATUS VARCHAR2 128     Approval status, A for approve, U for unaccrued adjustments, R for rejected, and any other code for unapproved    
H_REASON_CODE VARCHAR2 128     Identifier of reason for this adjustment    
H_ORG_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row.    
H_GL_DATE DATE       Accounting date    
H_APPLY_DATE DATE       Date adjustment applied to payment    
H_TYPE VARCHAR2 64     Lookup code for adjustment type in AR_LOOKUPS    
H_APPROVED_BY VARCHAR2 128     Identifier of user approving the adjustment    
H_GL_POSTED_DATE DATE       Date adjustment posted to General Ledger    
H_PAYMENT_SCHEDULE_ID NUMBER 38 0   Identifies the payment schedule    
H_CUSTOMER_TRX_ID NUMBER 38 0   Transaction identifier.