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.