# DW_AC_HZ_CUSTOMER_PROFILES_F_D (Preview)

This table requires activation of Advanced Collections functional area. Stores customer profile usage attributes sourced from HZ_CUSTOMER_PROFILES_F.

## Details

Module: Advanced Collections

## Key Columns

CUST_ACCOUNT_PROFILE_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

## Columns

Columns
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.