DW_AR_ADJUSTMENTS_EN

This table contains adjustment related details

Details

Module: Receivables

Key Columns

ADJUSTMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ADJUSTMENT_ID NUMBER 38 0 True Adjustment identifier    
SOURCE_RECORD_ID VARCHAR2 64     System Generated    
SUBLEDGER_LINKAGE_HDR_ENTITY_ID VARCHAR2 64     Subledger Linkage Header Entity ID    
ADJUSTMENT_NUMBER VARCHAR2 128     Adjustment number automatically generated from AR_ADJUSTMENT_NUMBER_S    
COMMENTS VARCHAR2 2048     User-entered comments about the adjustment.    
STATUS VARCHAR2 128     Approval status, A for approve, U for unaccrued adjustments, R for rejected, and any other code for unapproved    
REASON_CODE VARCHAR2 128     Identifier of reason for this adjustment    
ORG_ID NUMBER 38 0   Indicates the identifier of the business unit associated to the row.    
SET_OF_BOOKS_ID NUMBER 38 0   General Ledger Set of Books used, only one currently supported    
GL_DATE DATE       Accounting date    
APPLY_DATE DATE       Date adjustment applied to payment    
CREATED_BY VARCHAR2 512     Who column: indicates the user who created the row.    
A_NAME VARCHAR2 64     Name of the receivables activity    
TYPE VARCHAR2 64     Lookup code for adjustment type in AR_LOOKUPS    
APPROVED_BY VARCHAR2 128     Identifier of user approving the adjustment    
GL_POSTED_DATE DATE       Date adjustment posted to General Ledger    
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    
A_CREATION_DATE TIMESTAMP       Who column indicates the date and time of the creation of the row    
A_LAST_UPDATE_DATE TIMESTAMP       Who column indicates the date and time of the last update of the row    
PAYMENT_SCHEDULE_ID NUMBER 38 0   Identifies the payment schedule    
CUSTOMER_TRX_ID NUMBER 38 0   Transaction identifier.    
EVENT_ID NUMBER 38 0   Accounting event identifier    
UPDATED_BY VARCHAR2 128     Indicates the user who last updated the row