HZ_CUST_PROFILE_AMTS_F_
The HZ_CUST_PROFILE_AMTS table stores information about the credit limits specified for a customer profile in different currencies. This table is a child of the HZ_CUSTOMER_PROFILES table, which stores the profile information for customer accounts, customer account sites, or parties. Many of the values in the HZ_CUST_PROFILE_AMTS table can be defaulted from the HZ_CUST_PROF_CLASS_AMTS table, and then modified for a specified customer account, customer account site, or party. For example, the Large Independent Retail Stores profile class has an overall credit limit of 250,000 in Euro, but you can limit a new customer in this class to an overall credit limit of 50,000 in Euro.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
HZ_CUST_PROFILE_AMTS_PK_ |
LAST_UPDATE_DATE, CUST_ACCT_PROFILE_AMT_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, LAST_UPDATED_BY |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CUST_ACCT_PROFILE_AMT_ID | NUMBER | 18 | Yes | Unique identifier of profile amount row | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CUST_ACCOUNT_PROFILE_ID | NUMBER | 18 | Identifier of the customer account's profile | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Code defined for a currency | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| TRX_CREDIT_LIMIT | NUMBER | Credit limit for an order | |||
| OVERALL_CREDIT_LIMIT | NUMBER | The overall credit limit established for customer account. | |||
| MIN_DUNNING_AMOUNT | NUMBER | Dunning letter is not printed if account balance is below this amount. | |||
| MIN_DUNNING_INVOICE_AMOUNT | NUMBER | A dunning letter is not sent, if an invoice is less than this amount. | |||
| MAX_INTEREST_CHARGE | NUMBER | Threshold amount above which late charge must not be charged. | |||
| MIN_STATEMENT_AMOUNT | NUMBER | A statement is not printed if the total amount of the statement is below this amount. | |||
| AUTO_REC_MIN_RECEIPT_AMOUNT | NUMBER | Limits the minimum receipt amount for a currency | |||
| INTEREST_RATE | NUMBER | The same percentage interest will be charged consistently on overdue invoices. Used when interest type is percentage. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| MIN_FC_BALANCE_AMOUNT | NUMBER | Late charges should not be calculated if customer balance is below this threshold. | |||
| MIN_FC_INVOICE_AMOUNT | NUMBER | Late charges should not be calculated if individual transaction balance is below this threshold. | |||
| CUST_ACCOUNT_ID | NUMBER | 18 | Foreign key to the HZ_CUST_ACCOUNTS table | ||
| SITE_USE_ID | NUMBER | 18 | Foreign key to the HZ_CUST_SITE_USES_ALL table | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | 18 | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | |||
| WH_UPDATE_DATE | DATE | Date when the record was entered or changed in a data warehouse | |||
| JGZZ_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Country specific descriptive flexfield definition. | ||
| JGZZ_ATTRIBUTE1 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE2 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE3 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE4 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE5 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE6 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE7 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE8 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE9 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE10 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE11 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE12 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE13 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE14 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| JGZZ_ATTRIBUTE15 | VARCHAR2 | 150 | Country specific descriptive flexfield segment. | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Global Descriptive Flexfield: structure definition of the global descriptive flexfield. | ||
| EXPIRATION_DATE | DATE | Date on which this credit limit expires | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| CREATED_BY_MODULE | VARCHAR2 | 150 | Who column: indicates program that last updated this row. | ||
| APPLICATION_ID | NUMBER | Who column: indicates application that last updated this row. | |||
| EXCHANGE_RATE_TYPE | VARCHAR2 | 30 | Exchange rate type for late charges. Validated against the table GL_DAILY_CONVERSION_TYPES. The type USER is excluded. | ||
| MIN_FC_INVOICE_OVERDUE_TYPE | VARCHAR2 | 30 | Indicates whether the minimum invoice balance overdue is expressed as a fixed amount or a percentage | ||
| MIN_FC_INVOICE_PERCENT | NUMBER | Invoice balance threshold percentage below which late charges can not be charged | |||
| MIN_FC_BALANCE_OVERDUE_TYPE | VARCHAR2 | 30 | Indicates whether the minimum customer balance amount overdue is expressed as a fixed amount or a percentage | ||
| MIN_FC_BALANCE_PERCENT | NUMBER | Customer balance percentage threshold below which the late charge cannot be charged | |||
| INTEREST_TYPE | VARCHAR2 | 30 | Refers to the interest portion of the charge to be calculated on late invoices. Can be a fixed amount, a percentage or based on a charges schedule. Validated against lookup type AR_INTEREST_PENALTY_TYPE. | ||
| INTEREST_FIXED_AMOUNT | NUMBER | The flat amount to be charged on all overdue invoices. Used when interest type is fixed amount. | |||
| INTEREST_SCHEDULE_ID | NUMBER | 18 | Charge based on a tiered schedule. Used when interest type is charges schedule. Foreign key to | ||
| PENALTY_TYPE | VARCHAR2 | 30 | Refers to any additional penalties to be added to late charges. Can be a fixed amount, a percentage or based on a charges schedule. Validated against lookup type AR_INTEREST_PENALTY_TYPE. | ||
| PENALTY_RATE | NUMBER | The penalty will be calculated as a fixed percentage of the late charge. Used when penalty type is percentage. | |||
| MIN_INTEREST_CHARGE | NUMBER | Threshold amount below which late charge must not be charged. | |||
| PENALTY_FIXED_AMOUNT | NUMBER | The penalty will be a flat fee applied to the late charge. Used when penalty type is fixed amount. | |||
| PENALTY_SCHEDULE_ID | NUMBER | 18 | Charge based on a tiered schedule. Used when penalty type is charges schedule. Foreign key to AR_CHARGES_SCHEDULES.SCHEDULE_ID | ||
| EFFECTIVE_START_DATE | DATE | Yes | Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. | ||
| EFFECTIVE_END_DATE | DATE | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_CUST_PROFILE_AMTS_F_N1_ | Non Unique | Default | CUST_ACCT_PROFILE_AMT_ID |
| HZ_CUST_PROFILE_AMTS_F_U1_ | Unique | Default | LAST_UPDATE_DATE, CUST_ACCT_PROFILE_AMT_ID |
| HZ_CUST_PROFILE_AMTS_U1_ | Unique | Default | LAST_UPDATE_DATE, CUST_ACCT_PROFILE_AMT_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, LAST_UPDATED_BY |
| HZ_CUST_PROFILE_AMTS_U2_ | Unique | Default | LAST_UPDATE_DATE, CUST_ACCOUNT_PROFILE_ID, CURRENCY_CODE, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE |