# DW_AC_IEX_PROMISE_DETAILS_CF (Preview)

This table requires activation of Advanced Collections functional area. Stores promise detail records for Advanced Collections.

## Details

Module: Advanced Collections

## Key Columns

PROMISE_DETAIL_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PROMISE_DETAIL_ID | NUMBER | 38 | 0 | True | Promise detail identifier. |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
DELINQUENCY_ID | NUMBER | 38 | 0 |  | Promise delinquency identifier. |  |
CUST_ACCOUNT_ID | NUMBER | 38 | 0 |  | Customer account identifier. | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
ORG_ID | NUMBER | 38 | 0 |  | Business unit organization identifier. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
STATUS | VARCHAR2 | 32 |  |  | Promise status. | DW_AC_IEX_PROMISE_STATUSES_TL | IEX_PROMISE_STATUS_CODE
STATE | VARCHAR2 | 32 |  |  | Promise state. | DW_AC_IEX_PROMISE_STATES_TL | IEX_PROMISE_STATE_CODE
ACTIVE_PROMISE_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the promise is active/collectable (Y/N). | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
TERMINAL_PROMISE_STATUS_FLAG | VARCHAR2 | 16 |  |  | Indicates whether the promise is in terminal status (Y/N). | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE
CURRENCY_CODE | VARCHAR2 | 16 |  |  | Promise transaction currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
PROMISE_PAYMENT_METHOD | VARCHAR2 | 64 |  |  | Promise payment method. | DW_AR_RECEIPT_METHOD_LKP_TL | AR_RECEIPT_METHOD_LKP_CODE
CASE_FOLDER_ID | NUMBER | 38 | 0 |  | Case folder identifier. | DW_AC_IEX_CASE_FOLDERS_D | CASE_FOLDER_ID
ACCOUNT | VARCHAR2 | 64 |  |  | Promise Payment Account. |  |
PROMISE_ITEM_NUMBER | VARCHAR2 | 64 |  |  | Promise item number. |  |
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
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 |  |  |  | Promise creation timestamp. |  |
CREATION_DATE_1 | DATE |  |  |  | Promise creation date in DATE format. |  |
PROMISE_DATE | DATE |  |  |  | Promise date. |  |
BROKEN_ON_DATE | DATE |  |  |  | Promise broken date. |  |
CALLBACK_DATE | DATE |  |  |  | Promise callback date. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Promise last update timestamp. |  |
LAST_UPDATE_DATE_1 | DATE |  |  |  | Promise 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_PAYMENT_SCHEDULE_ID | NUMBER | 38 | 0 |  | Delinquency payment schedule identifier. |  |
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 transaction 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_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_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
D_TRANSACTION_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Delinquency transaction currency code. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
D_AMOUNT_DUE_REMAINING | NUMBER |  |  |  | Delinquency amount due remaining in transaction currency. |  |
D_LEDGER_AMOUNT_DUE_REMAINING | NUMBER |  |  |  | Delinquency amount due remaining in ledger currency. |  |
D_GLOBAL_AMOUNT_DUE_REMAINING | NUMBER |  |  |  | Delinquency amount due remaining in global currency. |  |
PROMISE_AMOUNT | NUMBER |  |  |  | Promise amount in transaction currency. |  |
LEDGER_PROMISE_AMOUNT | NUMBER |  |  |  | Promise amount in ledger currency. |  |
GLOBAL_PROMISE_AMOUNT | NUMBER |  |  |  | Promise amount in global currency. |  |
PROMISE_AMOUNT_DUE_REMAINING | NUMBER |  |  |  | Promise amount due remaining in transaction currency. |  |
LEDGER_PROMISE_AMOUNT_DUE_REMAINING | NUMBER |  |  |  | Promise amount due remaining in ledger currency. |  |
GLOBAL_PROMISE_AMOUNT_DUE_REMAINING | NUMBER |  |  |  | Promise amount due remaining in global currency. |  |

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