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.