This table requires activation of Advanced Collections functional area. Stores adjustment details for Advanced Collections.
Module: Advanced Collections
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 | This column is for Oracle Internal use only. Source record identifier. | ||||
| PAYMENT_SCHEDULE_ID | NUMBER | 38 | 0 | Payment schedule identifier. | |||
| LEGAL_ENTITY_ID | NUMBER | 38 | 0 | Legal entity identifier. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID | |
| LEDGER_ID | NUMBER | 38 | 0 | Ledger identifier. | DW_LEDGER_D | LEDGER_ID | |
| ORG_ID | NUMBER | 38 | 0 | Business unit organization identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID | |
| REASON_CODE | VARCHAR2 | 128 | Reason code for the adjustment. | DW_AR_ADJ_REASON_LKP_TL | AR_ADJ_REASON_LKP_CODE | ||
| TYPE | VARCHAR2 | 64 | Adjustment type. | DW_AR_ADJUSTMENT_TYPES_LKP_TL | AR_ADJUSTMENT_TYPES_LKP_CODE | ||
| ACTIVITY_NAME | VARCHAR2 | 64 | Receivables activity name. | ||||
| APPLY_DATE | DATE | Date the adjustment is applied. | |||||
| STATUS | VARCHAR2 | 128 | Adjustment status. | DW_ADJUSTMENT_STATUS_LKP_TL | ADJUSTMENT_STATUS_CODE | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 16 | Invoice currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| LEDGER_CURRENCY_CODE | VARCHAR2 | 16 | Ledger currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| GLOBAL_CURRENCY_EXCH_RATE | NUMBER | Global currency exchange rate. | |||||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||||
| CREATION_DATE_1 | DATE | Who column date in DATE format. | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | |||||
| LAST_UPDATE_DATE_1 | DATE | Last update date in DATE format. | |||||
| FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 | Accounting calendar name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME | ||
| FISCAL_PERIOD_TYPE | VARCHAR2 | 16 | Accounting period type. | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE | ||
| FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| D_CUSTOMER_TRX_ID | NUMBER | 38 | 0 | Delinquency customer transaction identifier. | |||
| D_TRANSACTION_NUMBER | VARCHAR2 | 32 | Delinquency transaction number. | ||||
| D_TRANSACTION_DATE | DATE | Delinquency transaction date. | |||||
| D_PURCHASE_ORDER_NUMBER | VARCHAR2 | 64 | Delinquency purchase order number. | ||||
| D_SALES_ORDER_NUMBER | VARCHAR2 | 64 | Delinquency sales order number. | ||||
| D_COMMENTS | VARCHAR2 | 999 | Delinquency comments. | ||||
| D_BATCH_SOURCE_SEQ_ID | NUMBER | 38 | 0 | Delinquency batch source sequence identifier. | DW_AR_TRX_BATCH_SOURCES_D | BATCH_SOURCE_SEQ_ID | |
| D_TRANSACTION_CLASS_CODE | VARCHAR2 | 32 | Delinquency transaction class code. | DW_AR_TRANSACTION_CLASS_LKP_TL | AR_TRANSACTION_CLASS_CODE | ||
| D_TRANSACTION_TYPE_DESCRIPTION | VARCHAR2 | 128 | Delinquency transaction type description. | ||||
| D_TRANSACTION_TYPE_NAME | VARCHAR2 | 64 | Delinquency transaction type name. | ||||
| D_PAYMENT_SCHEDULE_STATUS_CODE | VARCHAR2 | 32 | Delinquency payment schedule status code. | DW_AR_PAY_SCH_STATUS_LKP_TL | PAYMENT_SCHEDULE_STATUS_CODE | ||
| D_PAYMENT_DUE_DATE | DATE | Delinquency payment due date. | |||||
| D_INSTALLMENT_SEQUENCE_NUMBER | NUMBER | 38 | 0 | Delinquency installment sequence number. | |||
| D_NUMBER_OF_DUE_DATES | NUMBER | 38 | 0 | Delinquency number of due dates. | |||
| D_PAYMENT_TERMS_ID | NUMBER | 38 | 0 | Delinquency payment terms identifier. | DW_AR_PAYMENT_TERMS_D | PAYMENT_TERM_ID | |
| D_DELINQUENCY_ID | NUMBER | 38 | 0 | Delinquency identifier from context record. | |||
| D_DELINQUENCY_STATUS | VARCHAR2 | 32 | Delinquency status. | DW_AC_IEX_DELINQUENCY_STATUS_TL | IEX_DELINQUENCY_STATUS_CODE | ||
| D_UNPAID_REASON_CODE | VARCHAR2 | 256 | Delinquency unpaid reason code. | DW_AC_IEX_UNPAID_REASON_TL | IEX_UNPAID_REASON_CODE | ||
| D_LATEST_RESEND_STATUS_CODE | VARCHAR2 | 32 | Delinquency latest resend status code. | DW_AC_IEX_LATEST_RESEND_STATUS_TL | IEX_LATEST_RESEND_STATUS_CODE | ||
| D_DUNNING_SENT_INDICATOR | VARCHAR2 | 16 | Indicates whether dunning was sent for the delinquency. | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE | ||
| D_OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 | Delinquency object version number. | |||
| D_DELINQUENCY_CREATION_DATE | TIMESTAMP | Delinquency creation timestamp. | |||||
| D_DELINQUENCY_CREATION_DATE_1 | DATE | Delinquency creation date in DATE format. | |||||
| D_DELINQUENCY_LAST_UPDATE_DATE | TIMESTAMP | Delinquency last update timestamp. | |||||
| D_DELINQUENCY_LAST_UPDATE_DATE_1 | DATE | Delinquency last update date in DATE format. | |||||
| D_SCHEDULE_CREATION_DATE | TIMESTAMP | Delinquency schedule creation timestamp. | |||||
| D_SCHEDULE_CREATION_DATE_1 | DATE | Delinquency schedule creation date in DATE format. | |||||
| D_SCHEDULE_LAST_UPDATE_DATE | TIMESTAMP | Delinquency schedule last update timestamp. | |||||
| D_SCHEDULE_LAST_UPDATE_DATE_1 | DATE | Delinquency schedule last update date in DATE format. | |||||
| D_SCHEDULE_ACTUAL_CLOSED_DATE | DATE | Delinquency schedule actual closed date. | |||||
| D_GL_DATE | DATE | Delinquency general ledger date. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| D_FOLLOW_UP_DATE_LAST | DATE | Delinquency last follow-up date. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE | |||
| D_CUSTOMER_ID | NUMBER | 38 | 0 | Delinquency customer identifier. | DW_PARTY_D | PARTY_ID | |
| D_CUSTOMER_ACCOUNT_ID | NUMBER | 38 | 0 | Delinquency customer account identifier. | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID | |
| D_CUSTOMER_SITE_USE_ID | NUMBER | 38 | 0 | Delinquency customer site use identifier. | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID | |
| D_SHIP_TO_SITE_USE_ID | NUMBER | 38 | 0 | Delinquency ship-to site use identifier. | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID | |
| D_CUSTOMER_LOCATION_ID | NUMBER | 38 | 0 | Delinquency customer location identifier. | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID | |
| D_SHIP_TO_CONTACT_ID | NUMBER | 38 | 0 | Delinquency ship-to contact identifier. | DW_PARTY_D | PARTY_ID | |
| D_CUSTOMER_COLLECTOR_ID | NUMBER | 38 | 0 | Delinquency collector identifier. | DW_AC_AR_COLLECTORS_D | COLLECTOR_ID | |
| D_CUST_ACCOUNT_PROFILE_ID | NUMBER | 38 | 0 | Delinquency customer profile identifier. | DW_AC_HZ_CUSTOMER_PROFILES_F_D | ||
| D_SALESPERSON_PARTY_ID | NUMBER | 38 | 0 | Delinquency salesperson party identifier. | DW_PARTY_D | PARTY_ID | |
| D_FISCAL_PERIOD_NAME | VARCHAR2 | 64 | Delinquency accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME | ||
| D_LEDGER_CURRENCY_EXCH_RATE | NUMBER | Delinquency ledger exchange rate. | |||||
| D_LEDGER_CURRENCY_EXCH_RATE_TYPE | VARCHAR2 | 32 | Delinquency ledger exchange rate type. | ||||
| D_LEDGER_CURRENCY_EXCH_DATE | DATE | Delinquency ledger exchange rate date. | |||||
| D_RESOLVED_FLAG | VARCHAR2 | 16 | Indicates whether the related delinquency is resolved (Y/N). | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE | ||
| AMOUNT | NUMBER | Adjustment amount in transaction currency. | |||||
| LEDGER_AMOUNT | NUMBER | Adjustment amount in ledger currency. | |||||
| GLOBAL_AMOUNT | NUMBER | Adjustment amount in global currency. |
Copyright © 2019, 2026, Oracle and/or its affiliates.