This table requires activation of Advanced Collections functional area. Stores customer profile usage attributes sourced from HZ_CUSTOMER_PROFILES_F.
Module: Advanced Collections
CUST_ACCOUNT_PROFILE_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CUST_ACCOUNT_PROFILE_ID | NUMBER | 38 | 0 | True | Unique identifier of this customer profile. | ||
| EFFECTIVE_END_DATE | DATE | True | End date through which the profile row is effective. | ||||
| EFFECTIVE_START_DATE | DATE | True | Start date from which the profile row is effective. | ||||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Source record identifier. | ||||
| COLLECTOR_ID | NUMBER | 38 | 0 | Collector associated with this customer profile. | DW_AC_AR_COLLECTORS_D | COLLECTOR_ID | |
| CREATED_BY | VARCHAR2 | 64 | Who column: user who created the row. | ||||
| CREATION_DATE | TIMESTAMP | Who column: timestamp when the row was created. | |||||
| CUST_ACCOUNT_ID | NUMBER | 38 | 0 | Customer account identifier (FK to HZ_CUST_ACCOUNTS). | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID | |
| LAST_UPDATE_DATE | TIMESTAMP | Who column: timestamp of the last update. | |||||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: session login for the last update. | ||||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: user who last updated the row. | ||||
| PROGRAM_UPDATE_DATE | DATE | Concurrent program who column capturing last program update. | |||||
| SITE_USE_ID | NUMBER | 38 | 0 | Site use identifier (FK to HZ_CUST_SITE_USES_ALL). | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID | |
| PREF_CONTACT_METHOD | VARCHAR2 | 32 | Preferred contact method for this customer profile. | DW_AC_AR_CUST_PREF_CONTACT_METHOD_TL | AR_CUST_PREF_CONTACT_METHOD_CODE | ||
| CREDIT_LIMIT | NUMBER | Maximum credit amount allowed for the account. | |||||
| CREDIT_CURRENCY_CODE | VARCHAR2 | 16 | Currency code associated with the customer credit limit. | 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. | |||||
| GLOBAL_CREDIT_LIMIT | NUMBER | Credit limit converted to the global currency at effective start date. | |||||
| CREDIT_CLASSIFICATION | VARCHAR2 | 32 | Measure of customer credit worthiness. | DW_AC_AR_CMGT_CREDIT_CLASSIFICATION_TL | AR_CMGT_CREDIT_CLASSIFICATION_CODE | ||
| CREDIT_RATING | VARCHAR2 | 32 | Credit rating assigned to the account. | DW_AC_CREDIT_RATING_TL | CREDIT_RATING_CODE | ||
| CREDIT_HOLD | VARCHAR2 | 16 | Indicates whether a credit hold exists (Y/N). | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE | ||
| DUNNING_LETTERS | VARCHAR2 | 16 | Indicates whether dunning letters are sent (Y/N). | DW_AC_IEX_YES_NO_TL | IEX_YES_NO_CODE | ||
| STATEMENT_CYCLE_ID | NUMBER | 38 | 0 | Identifier of the statement cycle. | |||
| STATEMENT_CYCLE_NAME | VARCHAR2 | 32 | Name of the statement cycle. | ||||
| STATEMENT_CYCLE_DESCRIPTION | VARCHAR2 | 256 | Description of the statement cycle. | ||||
| STANDARD_TERMS | NUMBER | 38 | 0 | Payment terms identifier applied to the account. | DW_AR_PAYMENT_TERMS_D | PAYMENT_TERM_ID | |
| ACCOUNT_STATUS | VARCHAR2 | 32 | User-defined account status. | DW_AC_ACCOUNT_STATUS_TL | ACCOUNT_STATUS_CODE | ||
| CREDIT_REVIEW_CYCLE | VARCHAR2 | 32 | Review cycle frequency for the credit profile. | ||||
| LAST_CREDIT_REVIEW_DATE | DATE | Date of the most recent credit review. | |||||
| DISCOUNT_GRACE_DAYS | NUMBER | Number of grace days allowed for discounts. | |||||
| PAYMENT_GRACE_DAYS | NUMBER | Number of grace days allowed for payments. | |||||
| PROFILE_CLASS_ID | NUMBER | 38 | 0 | Identifier of the profile class associated with this customer profile. |
Copyright © 2019, 2026, Oracle and/or its affiliates.