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 |
CUST_ACCT_PROFILE_AMT_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
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 | Yes | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
CUST_ACCOUNT_PROFILE_ID | NUMBER | 18 | Yes | Identifier of the customer account's profile | ||
CURRENCY_CODE | VARCHAR2 | 15 | Yes | 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. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Customer Profile Amounts (AR_CUSTOMER_PROFILE_AMOUNTS_HZ) | ||
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 | Yes | 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 | Yes | 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. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
HZ_CUST_PROFILE_AMTS_F | hz_customer_profiles_f | CUST_ACCOUNT_PROFILE_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE |
HZ_CUST_PROFILE_AMTS_F | hz_cust_accounts | CUST_ACCOUNT_ID |
HZ_CUST_PROFILE_AMTS_F | hz_cust_site_uses_all | SITE_USE_ID |
HZ_CUST_PROFILE_AMTS_F | gl_daily_conversion_types | EXCHANGE_RATE_TYPE |
HZ_CUST_PROFILE_AMTS_F | ar_charge_schedules | INTEREST_SCHEDULE_ID |
HZ_CUST_PROFILE_AMTS_F | ar_charge_schedules | PENALTY_SCHEDULE_ID |
ar_interest_headers_all | hz_cust_profile_amts_f | CUST_ACCT_PROFILE_AMT_ID, CREATION_DATE, LAST_UPDATE_DATE |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
HZ_CUST_PROFILE_AMTS_N1 | Non Unique | Default | CUST_ACCOUNT_PROFILE_ID | Obsolete |
HZ_CUST_PROFILE_AMTS_N2 | Non Unique | Default | SITE_USE_ID | |
HZ_CUST_PROFILE_AMTS_N3 | Non Unique | Default | CUST_ACCOUNT_ID | |
HZ_CUST_PROFILE_AMTS_U1 | Unique | Default | CUST_ACCT_PROFILE_AMT_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE | |
HZ_CUST_PROFILE_AMTS_U2 | Unique | Default | CUST_ACCOUNT_PROFILE_ID, CURRENCY_CODE, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE |