# DW_AC_IEX_DELINQUENCIES_CF (Preview)

This table requires activation of Advanced Collections functional area. Stores all invoices and only receipts with unapplied or on-account amounts at the payment schedule level alonging with related delinquency details for Advanced Collections.

## Details

Module: Advanced Collections

## Key Columns

PAYMENT_SCHEDULE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PAYMENT_SCHEDULE_ID | NUMBER | 38 | 0 | True | Payment schedule identifier. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
CUSTOMER_TRX_ID | NUMBER | 38 | 0 |  | Customer transaction identifier. |  |
TRANSACTION_NUMBER | VARCHAR2 | 32 |  |  | Transaction or receipt number. |  |
CASH_RECEIPT_ID | NUMBER | 38 | 0 |  | Cash receipt identifier. |  |
TRANSACTION_DATE | DATE |  |  |  | Transaction or receipt date. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
PURCHASE_ORDER_NUMBER | VARCHAR2 | 64 |  |  | Purchase order number. |  |
SALES_ORDER_NUMBER | VARCHAR2 | 64 |  |  | Sales order number. |  |
COMMENTS | VARCHAR2 | 999 |  |  | Transaction comments. |  |
BATCH_SOURCE_SEQ_ID | NUMBER | 38 | 0 |  | Batch source sequence identifier. | DW_AR_TRX_BATCH_SOURCES_D | BATCH_SOURCE_SEQ_ID
TRANSACTION_SOURCE_TYPE | VARCHAR2 | 32 |  |  | Source type such as INVOICE or RECEIPT. |  |
TRANSACTION_CLASS_CODE | VARCHAR2 | 32 |  |  | Transaction class code. | DW_AR_TRANSACTION_CLASS_LKP_TL | AR_TRANSACTION_CLASS_CODE
TRANSACTION_TYPE_DESCRIPTION | VARCHAR2 | 128 |  |  | Transaction type description. |  |
TRANSACTION_TYPE_NAME | VARCHAR2 | 64 |  |  | Transaction type name. |  |
PAYMENT_SCHEDULE_STATUS_CODE | VARCHAR2 | 32 |  |  | Payment schedule status code. | DW_AR_PAY_SCH_STATUS_LKP_TL | PAYMENT_SCHEDULE_STATUS_CODE
PAYMENT_DUE_DATE | DATE |  |  |  | Payment due date. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
INSTALLMENT_SEQUENCE_NUMBER | NUMBER | 38 | 0 |  | Installment sequence number. |  |
NUMBER_OF_DUE_DATES | NUMBER | 38 | 0 |  | Number of due dates for the payment schedule. |  |
PAYMENT_TERMS_ID | NUMBER | 38 | 0 |  | Payment terms identifier. | DW_AR_PAYMENT_TERMS_D | PAYMENT_TERM_ID
DELINQUENCY_ID | NUMBER | 38 | 0 |  | Delinquency identifier. |  |
DELINQUENCY_STATUS | VARCHAR2 | 32 |  |  | Delinquency status. | DW_AC_IEX_DELINQUENCY_STATUS_TL | IEX_DELINQUENCY_STATUS_CODE
UNPAID_REASON_CODE | VARCHAR2 | 256 |  |  | Unpaid reason code. | DW_AC_IEX_UNPAID_REASON_TL | IEX_UNPAID_REASON_CODE
LATEST_RESEND_STATUS_CODE | VARCHAR2 | 32 |  |  | Latest resend status code. | DW_AC_IEX_LATEST_RESEND_STATUS_TL | IEX_LATEST_RESEND_STATUS_CODE
DUNNING_SENT_INDICATOR | VARCHAR2 | 16 |  |  | Indicates whether dunning was sent. | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 |  | Object version number. |  |
DELINQUENCY_CREATION_DATE | TIMESTAMP |  |  |  | Delinquency creation timestamp. |  |
DELINQUENCY_CREATION_DATE_1 | DATE |  |  |  | Delinquency creation date in DATE format. |  |
DELINQUENCY_LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Delinquency last update timestamp. |  |
DELINQUENCY_LAST_UPDATE_DATE_1 | DATE |  |  |  | Delinquency last update date in DATE format. |  |
SCHEDULE_CREATION_DATE | TIMESTAMP |  |  |  | Schedule creation timestamp. |  |
SCHEDULE_CREATION_DATE_1 | DATE |  |  |  | Schedule creation date in DATE format. |  |
SCHEDULE_LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Schedule last update timestamp. |  |
SCHEDULE_LAST_UPDATE_DATE_1 | DATE |  |  |  | Schedule last update date in DATE format. |  |
SCHEDULE_ACTUAL_CLOSED_DATE | DATE |  |  |  | Actual date when the schedule was closed. |  |
GL_DATE | DATE |  |  |  | General ledger date for the payment schedule. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
FOLLOW_UP_DATE_LAST | DATE |  |  |  | Date of the most recent follow-up. | DW_FISCAL_DAY_D | FISCAL_DAY_DATE
CUSTOMER_ID | NUMBER | 38 | 0 |  | Customer identifier. | DW_PARTY_D | PARTY_ID
CUSTOMER_ACCOUNT_ID | NUMBER | 38 | 0 |  | Customer account identifier. | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
CUSTOMER_SITE_USE_ID | NUMBER | 38 | 0 |  | Customer site use identifier. | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID
SHIP_TO_SITE_USE_ID | NUMBER | 38 | 0 |  | Ship-to site use identifier. | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID
CUSTOMER_LOCATION_ID | NUMBER | 38 | 0 |  | Customer location identifier. | DW_CUSTOMER_LOCATION_D | CUSTOMER_LOCATION_ID
SHIP_TO_CONTACT_ID | NUMBER | 38 | 0 |  | Ship-to contact identifier. | DW_PARTY_D | PARTY_ID
CUSTOMER_COLLECTOR_ID | NUMBER | 38 | 0 |  | Collector identifier. | DW_AC_AR_COLLECTORS_D | COLLECTOR_ID
CUST_ACCOUNT_PROFILE_ID | NUMBER | 38 | 0 |  | Customer profile identifier. | DW_AC_HZ_CUSTOMER_PROFILES_F_D |
SALESPERSON_PARTY_ID | NUMBER | 38 | 0 |  | Primary sales representative party identifier. | DW_PARTY_D | PARTY_ID
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 |  | Receivables business unit organization identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
FISCAL_PERIOD_NAME | VARCHAR2 | 64 |  |  | Accounting period name. | DW_FISCAL_DAY_D | FISCAL_PERIOD_NAME
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
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Ledger currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
LEDGER_CURRENCY_EXCH_RATE | NUMBER |  |  |  | Ledger exchange rate. |  |
LEDGER_CURRENCY_EXCH_RATE_TYPE | VARCHAR2 | 32 |  |  | Ledger exchange rate type. |  |
LEDGER_CURRENCY_EXCH_DATE | DATE |  |  |  | Ledger exchange rate date. |  |
TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Transaction 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. |  |
RESOLVED_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the delinquency is resolved (Y/N). | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
AMOUNT_DUE_ORIGINAL | NUMBER |  |  |  | Original amount due in transaction currency. |  |
AMOUNT_DUE_REMAINING | NUMBER |  |  |  | Remaining amount due in transaction currency. |  |
AMOUNT_APPLIED | NUMBER |  |  |  | Applied amount in transaction currency. |  |
AMOUNT_ADJUSTED | NUMBER |  |  |  | Adjusted amount in transaction currency. |  |
AMOUNT_CREDITED | NUMBER |  |  |  | Credited amount in transaction currency. |  |
AMOUNT_IN_DISPUTE | NUMBER |  |  |  | Disputed amount in transaction currency. |  |
AMOUNT_ON_ACCOUNT | NUMBER |  |  |  | On-account amount in transaction currency. |  |
AMOUNT_OTHER_ACCOUNT | NUMBER |  |  |  | Other-account amount in transaction currency. |  |
RECEIVABLES_CHARGES_REMAINING | NUMBER |  |  |  | Remaining receivables charges. |  |
AMOUNT_ADJUSTED_PENDING | NUMBER |  |  |  | Pending adjusted amount. |  |
LEDGER_AMOUNT_DUE_ORIGINAL | NUMBER |  |  |  | Original amount due in ledger currency. |  |
LEDGER_AMOUNT_DUE_REMAINING | NUMBER |  |  |  | Remaining amount due in ledger currency. |  |
LEDGER_AMOUNT_APPLIED | NUMBER |  |  |  | Applied amount in ledger currency. |  |
LEDGER_AMOUNT_ADJUSTED | NUMBER |  |  |  | Adjusted amount in ledger currency. |  |
LEDGER_AMOUNT_CREDITED | NUMBER |  |  |  | Credited amount in ledger currency. |  |
LEDGER_AMOUNT_IN_DISPUTE | NUMBER |  |  |  | Disputed amount in ledger currency. |  |
LEDGER_AMOUNT_ON_ACCOUNT | NUMBER |  |  |  | On-account amount in ledger currency. |  |
LEDGER_AMOUNT_OTHER_ACCOUNT | NUMBER |  |  |  | Other-account amount in ledger currency. |  |
LEDGER_RECEIVABLES_CHARGES_REMAINING | NUMBER |  |  |  | Remaining receivables charges in ledger currency. |  |
LEDGER_AMOUNT_ADJUSTED_PENDING | NUMBER |  |  |  | Pending adjusted amount in ledger currency. |  |
GLOBAL_AMOUNT_DUE_ORIGINAL | NUMBER |  |  |  | Original amount due in global currency. |  |
GLOBAL_AMOUNT_DUE_REMAINING | NUMBER |  |  |  | Remaining amount due in global currency. |  |
GLOBAL_AMOUNT_APPLIED | NUMBER |  |  |  | Applied amount in global currency. |  |
GLOBAL_AMOUNT_ADJUSTED | NUMBER |  |  |  | Adjusted amount in global currency. |  |
GLOBAL_AMOUNT_CREDITED | NUMBER |  |  |  | Credited amount in global currency. |  |
GLOBAL_AMOUNT_IN_DISPUTE | NUMBER |  |  |  | Disputed amount in global currency. |  |
GLOBAL_AMOUNT_ON_ACCOUNT | NUMBER |  |  |  | On-account amount in global currency. |  |
GLOBAL_AMOUNT_OTHER_ACCOUNT | NUMBER |  |  |  | Other-account amount in global currency. |  |
GLOBAL_RECEIVABLES_CHARGES_REMAINING | NUMBER |  |  |  | Remaining receivables charges in global currency. |  |
GLOBAL_AMOUNT_ADJUSTED_PENDING | NUMBER |  |  |  | Pending adjusted amount in global currency. |  |

Copyright Â© 2019, 2026, Oracle and/or its affiliates.