1. Tables and Views for Financials
  2. HZ_CUST_PROFILE_AMTS_F

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.
AUTOCASH_TOLERANCE_AMOUNT NUMBER Maximum amount in the business unit ledger currency to apply to the difference between the receipt amount and the open balance amount.

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