This table requires activation of Advanced Collections functional area. Stores customer profile amount attributes sourced from HZ_CUST_PROFILE_AMTS_F.
Module: Advanced Collections
EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, CUST_ACCT_PROFILE_AMT_ID
| 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.