This table requires activation of Advanced Collections functional area. Stores delinquency summary metrics for Advanced Collections.
Module: Advanced Collections
DEL_SUMMARY_ID
| 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.