# DW_AC_HZ_CUST_PROFILE_AMTS_F_D (Preview)

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

## Details

Module: Advanced Collections

## Key Columns

EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, CUST_ACCT_PROFILE_AMT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
CUST_ACCT_PROFILE_AMT_ID | NUMBER | 38 | 0 | True | Profile amount identifier. |  |
EFFECTIVE_START_DATE | DATE |  |  | True | Start date from which the profile amount is effective. |  |
EFFECTIVE_END_DATE | DATE |  |  | True | End date through which the profile amount is effective. |  |
SOURCE_RECORD_ID | VARCHAR2 | 128 |  |  | This column is for Oracle Internal use only. Source record identifier. |  |
CUST_ACCOUNT_PROFILE_ID | NUMBER | 38 | 0 |  | Customer profile identifier. | DW_AC_HZ_CUSTOMER_PROFILES_F_D | CUST_ACCOUNT_PROFILE_ID
CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency code for the profile amounts. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
MIN_DUNNING_AMOUNT | NUMBER |  |  |  | Minimum dunning amount in transaction currency. |  |
MIN_DUNNING_INVOICE_AMOUNT | NUMBER |  |  |  | Minimum dunning invoice amount in transaction currency. |  |
CUST_ACCOUNT_ID | NUMBER | 38 | 0 |  | Customer account identifier. | DW_CUSTOMER_ACCOUNT_D | CUSTOMER_ACCOUNT_ID
SITE_USE_ID | NUMBER | 38 | 0 |  | Site use identifier. | DW_CUSTOMER_SITE_USES_D | CUSTOMER_SITE_USE_ID
CREATION_DATE | TIMESTAMP |  |  |  | Who column: timestamp when the row was created. |  |
CREATED_BY | VARCHAR2 | 64 |  |  | Who column: user who created the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: timestamp of the last update. |  |
LAST_UPDATED_BY | VARCHAR2 | 64 |  |  | Who column: user who last updated the row. |  |

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