This table contains adjustment related details
Module: Receivables
ADJUSTMENT_ID
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 |