# DW_AC_IEX_DELINQ_SUMMARIES_CF (Preview)

This table requires activation of Advanced Collections functional area. Stores delinquency summary metrics for Advanced Collections.

## Details

Module: Advanced Collections

## Key Columns

DEL_SUMMARY_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
DEL_SUMMARY_ID | NUMBER | 38 | 0 | True | Delinquency summary identifier. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
PARTY_ID | NUMBER | 38 | 0 |  | Party identifier. | DW_PARTY_D | PARTY_ID
CUST_ACCOUNT_ID | NUMBER | 38 | 0 |  | Customer account identifier. | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
SITE_USE_ID | NUMBER | 38 | 0 |  | Customer 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
AGING_BUCKET_ID | NUMBER | 38 | 0 |  | Aging bucket identifier. | DW_AC_AR_AGING_BUCKETS_D | AGING_BUCKET_ID
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 |
CONTACT_PARTY_ID | NUMBER | 38 | 0 |  | Contact party identifier. | DW_PARTY_D | PARTY_ID
NUMBER_DELINQUENCIES | NUMBER | 38 | 0 |  | Number of delinquencies in the summary. |  |
STATUS_TYPE | VARCHAR2 | 32 |  |  | Status type of the summary. | DW_AC_IEX_DELINQ_RECORD_STATUS_TL | IEX_DELINQ_RECORD_STATUS_CODE
NEW_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the summary is new. | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
BUSINESS_LEVEL | VARCHAR2 | 32 |  |  | Business level associated with the summary. | DW_AC_IEX_BUSINESS_LVL_TL | IEX_BUSINESS_LVL_CODE
STRATEGY_ID | NUMBER | 38 | 0 |  | Strategy identifier. |  |
STRATEGY_TEMPLATE_ID | NUMBER | 38 | 0 |  | Strategy template identifier. | DW_AC_IEX_STRATEGY_TEMPLATES_TL | STRATEGY_TEMP_ID
PREDELINQ_STRATEGY_ID | NUMBER | 38 | 0 |  | Predelinquency strategy identifier. |  |
PREDELINQ_STRATEGY_TEMPLATE_ID | NUMBER | 38 | 0 |  | Predelinquency strategy template identifier. | DW_AC_IEX_STRATEGY_TEMPLATES_TL | STRATEGY_TEMP_ID
SCORE_VALUE | NUMBER |  |  |  | Score value associated with the summary. |  |
DISPLAY_NAME | VARCHAR2 | 512 |  |  | Display name of the customer or site. |  |
SITE_LOCATION | VARCHAR2 | 512 |  |  | Site location display value. |  |
OBJECT_VERSION_NUMBER | NUMBER | 38 | 0 |  | Object version number. |  |
WORKER_NUMBER | NUMBER | 38 | 0 |  | Worker number assigned to the summary. |  |
ORG_ID | NUMBER | 38 | 0 |  | Business unit organization identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_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
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
CREATION_DATE_1 | DATE |  |  |  | Creation date in DATE format. |  |
STATUS_DATE | DATE |  |  |  | Status date for the delinquency summary. |  |
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. |  |
FIRST_DUE_DATE | DATE |  |  |  | First due date across the summary items. |  |
LAST_PAYMENT_DATE | DATE |  |  |  | Last payment date across the summary items. |  |
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
CURRENCY | VARCHAR2 | 16 |  |  | Currency code of the country of customer. | 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. |  |
AGING_AMT_LINE_1 | NUMBER |  |  |  | Aging amount line 1. |  |
AGING_AMT_LINE_2 | NUMBER |  |  |  | Aging amount line 2. |  |
AGING_AMT_LINE_3 | NUMBER |  |  |  | Aging amount line 3. |  |
AGING_AMT_LINE_4 | NUMBER |  |  |  | Aging amount line 4. |  |
AGING_AMT_LINE_5 | NUMBER |  |  |  | Aging amount line 5. |  |
AGING_AMT_LINE_6 | NUMBER |  |  |  | Aging amount line 6. |  |
AGING_AMT_LINE_7 | NUMBER |  |  |  | Aging amount line 7. |  |
TOTAL_AMOUNT_DUE | NUMBER |  |  |  | Total amount due in transaction currency. |  |
GLOBAL_AGING_AMT_LINE_1 | NUMBER |  |  |  | Aging amount line 1 in global currency. |  |
GLOBAL_AGING_AMT_LINE_2 | NUMBER |  |  |  | Aging amount line 2 in global currency. |  |
GLOBAL_AGING_AMT_LINE_3 | NUMBER |  |  |  | Aging amount line 3 in global currency. |  |
GLOBAL_AGING_AMT_LINE_4 | NUMBER |  |  |  | Aging amount line 4 in global currency. |  |
GLOBAL_AGING_AMT_LINE_5 | NUMBER |  |  |  | Aging amount line 5 in global currency. |  |
GLOBAL_AGING_AMT_LINE_6 | NUMBER |  |  |  | Aging amount line 6 in global currency. |  |
GLOBAL_AGING_AMT_LINE_7 | NUMBER |  |  |  | Aging amount line 7 in global currency. |  |
GLOBAL_TOTAL_AMOUNT_DUE | NUMBER |  |  |  | Total amount due in global currency. |  |
OPEN_INVOICE_AMOUNT | NUMBER |  |  |  | Open invoice amount in transaction currency. |  |
OPEN_INVOICE_NUMBER | NUMBER |  |  |  | Number of open invoices. |  |
OPEN_DEBITMEMO_AMOUNT | NUMBER |  |  |  | Open debit memo amount in transaction currency. |  |
OPEN_DEBITMEMO_NUMBER | NUMBER |  |  |  | Number of open debit memos. |  |
OPEN_CHARBACK_AMOUNT | NUMBER |  |  |  | Open chargeback amount in transaction currency. |  |
OPEN_CHARGEBACK_NUMBER | NUMBER |  |  |  | Number of open chargebacks. |  |
OPEN_CREDITMEMO_AMOUNT | NUMBER |  |  |  | Open credit memo amount in transaction currency. |  |
OPEN_CREDITMEMO_NUMBER | NUMBER |  |  |  | Number of open credit memos. |  |
DISPUTED_INV_AMOUNT | NUMBER |  |  |  | Disputed invoice amount in transaction currency. |  |
DISPUTED_INV_NUMBER | NUMBER |  |  |  | Number of disputed invoices. |  |
GLOBAL_OPEN_INVOICE_AMOUNT | NUMBER |  |  |  | Open invoice amount in global currency. |  |
GLOBAL_OPEN_DEBITMEMO_AMOUNT | NUMBER |  |  |  | Open debit memo amount in global currency. |  |
GLOBAL_OPEN_CHARBACK_AMOUNT | NUMBER |  |  |  | Open chargeback amount in global currency. |  |
GLOBAL_OPEN_CREDITMEMO_AMOUNT | NUMBER |  |  |  | Open credit memo amount in global currency. |  |
GLOBAL_DISPUTED_INV_AMOUNT | NUMBER |  |  |  | Disputed invoice amount in global currency. |  |
TOTAL_UNAPP_ACCTD_AMOUNT | NUMBER |  |  |  | Total unapplied amount in accounting currency. |  |
TOTAL_ONACC_ACCTD_AMOUNT | NUMBER |  |  |  | Total on-account amount in accounting currency. |  |
TOTAL_UNAPP_GLOBAL_AMOUNT | NUMBER |  |  |  | Total unapplied amount in global currency. |  |
TOTAL_ONACC_GLOBAL_AMOUNT | NUMBER |  |  |  | Total on-account amount in global currency. |  |

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