1. Tables and Views for Financials
  2. HZ_CUSTOMER_PROFILES_F_

HZ_CUSTOMER_PROFILES_F_

The HZ_CUSTOMER_PROFILES_F table stores information about characteristics of a customer, customer account or site, such as creditworthiness, business volume, payment cycles, receipts matching, AutoInvoice grouping, statement cycles and dunning policies. A profile class defined in the HZ_CUST_PROFILE_CLASSES table can be used to provide default values for the attributes in this table. The default values copied into this table can be modified to more closely match the customer, customer account or site profile defined in this table. The primary key for this table is CUST_ACCOUNT_PROFILE_ID

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

HZ_CUSTOMER_PROFILES_PK_

LAST_UPDATE_DATE, CUST_ACCOUNT_PROFILE_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, LAST_UPDATED_BY

Columns

Name Datatype Length Precision Not-null Comments
CUST_ACCOUNT_PROFILE_ID NUMBER 18 Yes Unique identifier of this customer profile
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.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated 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_ID NUMBER 18 Identifier for the Customer Account. Foreign key to the HZ_CUST_ACCOUNTS table
STATUS VARCHAR2 1 Indicates whether the profile is active or inactive
COLLECTOR_ID NUMBER 18 Identifier of the collector associated with this customer profile
CREDIT_CHECKING VARCHAR2 1 Indicates whether a credit check is to be carried out
TOLERANCE NUMBER Percentage over credit limit that this customer can exceed before action is taken
DISCOUNT_TERMS VARCHAR2 1 Indicates if discount terms exist. Y for discount terms are allowed, N for no discount terms are allowed. The default value is Y.
DUNNING_LETTERS VARCHAR2 1 Indicates if dunning letters are sent to this customer when invoices, debit memos or chargebacks become past due. Y for dunning letters are sent, N for no dunning letters. Default value is Y.
INTEREST_CHARGES VARCHAR2 1 Indicates if late charges are enabled
SEND_STATEMENTS VARCHAR2 1 Indicates if statements are sent to this customer. Y for statements are sent, N for no statements. Default value is Y.
CREDIT_BALANCE_STATEMENTS VARCHAR2 1 Indicates if customers credit balances receive statements. Y for statements are sent, N for no statements. Default value is Y.
CREDIT_HOLD VARCHAR2 1 Indicates if a credit hold exists on this account. Y for a credit hold is in place, N for no credit hold.
PROFILE_CLASS_ID NUMBER 18 Identifier of the customer profile class associated with this customer profile
SITE_USE_ID NUMBER 18 Identifier of the site use record associated with this customer profile. Foreign key to the HZ_CUST_SITE_USES_ALL table.
CREDIT_RATING VARCHAR2 30 List of values choices for credit rating.
RISK_CODE VARCHAR2 30 List of values choices for risk code.
STANDARD_TERMS NUMBER 18 User-defined payment terms
OVERRIDE_TERMS VARCHAR2 1 Indicates if user can override standard terms. Y for overrides are allowed, N for no overrides of standard credit terms
INTEREST_PERIOD_DAYS NUMBER Number of days that the interest rate refers to
PAYMENT_GRACE_DAYS NUMBER Maximum number of overdue days allowed before action is taken
DISCOUNT_GRACE_DAYS NUMBER Number of days after discount term date that this customer can take discounts
STATEMENT_CYCLE_ID NUMBER 18 Identifier of the statement cycle associated with this customer profile
ACCOUNT_STATUS VARCHAR2 30 User defined customer account status.
PERCENT_COLLECTABLE NUMBER Percentage of this customer's account balance that you expect to collect on a regular basis
AUTOCASH_HIERARCHY_ID NUMBER 18 Identifier of the autocash hierarchy associated with this customer profile
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.
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).
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
WH_UPDATE_DATE DATE Date when the record was entered or changed in a data warehouse
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.
AUTO_REC_INCL_DISPUTED_FLAG VARCHAR2 1 Indicates if disputed transactions are included. Y for including disputed transactions, N for not excluding disputed transactions.
TAX_PRINTING_OPTION VARCHAR2 30 Options for printing taxes on invoices.
CHARGE_ON_FINANCE_CHARGE_FLAG VARCHAR2 1 Formula used to compute late charges.Possible values are simple, compound or flat rate. Validated against lookup type AR_FORMULAE.
GROUPING_RULE_ID NUMBER 18 Identifies the default invoice line grouping rule for the customer
CLEARING_DAYS NUMBER 5 This column is used to specify a value for the number of clearing days before receipts that belong to this customer (or site) can be cleared by the Automatic Clearing program. This overrides the value of the payment method / bank account.
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.
CONS_INV_FLAG VARCHAR2 1 Indicates if balance forward bill is generated and sent to customer. Y for yes, N or null
CONS_INV_TYPE VARCHAR2 30 Format of balance forward bill. SUMMARY, DETAIL, or IMPORTED. Validated against HZ_CONS_INV_TYPE lookup type
AUTOCASH_HIERARCHY_ID_FOR_ADR NUMBER 18 Identifies AutoCash Rule Set to be used for applying the remainder balance on a receipt for the customer during Post Batch processing.
LOCKBOX_MATCHING_OPTION VARCHAR2 30 Lockbox matching option (typically INVOICE, SALES_ORDER, PURCHASE_ORDER)
CREDIT_ANALYST_ID NUMBER 18 Identifier of the credit analyst associated with this customer profile
NEXT_CREDIT_REVIEW_DATE DATE The next date that credit will be reviewed
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: indenties the program that last updated this row.
APPLICATION_ID NUMBER Who column: indentifies the application that last updated this row.
REVIEW_CYCLE VARCHAR2 30 Review cycle of customer profile data
LAST_CREDIT_REVIEW_DATE DATE Date of last customer profile data review
PARTY_ID NUMBER 18 Party identifier that profile is associated with
CREDIT_CLASSIFICATION VARCHAR2 30 Measure of customer credit worthiness.
CONS_BILL_LEVEL VARCHAR2 30 Level at which balance forward billing is done, ACCOUNT or SITE. Validated against HZ_CONS_BILL_LEVEL lookup type.
LATE_CHARGE_CALCULATION_TRX VARCHAR2 30 Indicates whether late charges should be calculated on overdue invoices and or late payments. Validated against lookup type AR_MANDATORY_LATE_CHARGES.
CREDIT_ITEMS_FLAG VARCHAR2 1 Indicates if credit items such as unapplied or on-account receipts, can be offset against the overdue balance to reduce the amount liable for late charges.
DISPUTED_TRANSACTIONS_FLAG VARCHAR2 1 Indicates if late charges can be calculated on disputed transactions
LATE_CHARGE_TYPE VARCHAR2 30 Determines if late charges should be recorded as an adjustment, debit memo or interest invoice. Validated against lookup type AR_LATE_CHARGE_TYPE.
LATE_CHARGE_TERM_ID NUMBER Payment term used when an invoice or debit memo is created for late charges. Foreign key to RA_TERMS.PAYMENT_TERM_ID.
INTEREST_CALCULATION_PERIOD VARCHAR2 30 Indicates if interest calculation period for late charges is daily or monthly. Validated against lookup type AR_CALCULATION_PERIOD.
HOLD_CHARGED_INVOICES_FLAG VARCHAR2 1 Indicates if late charges can be calculated more than once for a transaction
MESSAGE_TEXT_ID NUMBER Message text printed on the late charge transaction. Applies only to late charges recorded as invoices or debit memos. Foreign key to AR_STANDARD_TEXT.STANDARD_TEXT_ID.
MULTIPLE_INTEREST_RATES_FLAG VARCHAR2 1 Indicates if interest and penalty charges can be calculated using multiple rates for a single late charge period
CHARGE_BEGIN_DATE DATE Optional value that indicates the date late charges begin.
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.
PREF_CONTACT_METHOD VARCHAR2 30 Preferred contact method
AUTOMATCH_RULE_ID NUMBER 18 AUTOMATCH_ID is the identifier of new setup entity AutoMatch, which will signify how automatic matching will be performed in AutoMatch Program.
MATCH_BY_AUTOUPDATE_FLAG VARCHAR2 1 MATCH_BY_AUTOUPDATE_FLAG indicates if Match Receipt By attribute should be updated at customer level (site and account profile)
EXCEPTION_RULE_ID NUMBER 18 Under/Over Payment Exception Rule Identifier
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER2 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER3 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER4 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_NUMBER5 NUMBER Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE1 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE2 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE3 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE4 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
GLOBAL_ATTRIBUTE_DATE5 DATE Global Descriptive Flexfield: segment of the global descriptive flexfield.
OFFSET_DAYS NUMBER 18 Number of days that used to calculate the expiration date of the authorization, default value is 5.
CREDIT_LIMIT NUMBER It is the maximum amount of credit defined in the single currency for the customer account.
EXCHANGE_RATE_TYPE VARCHAR2 30 It is the exchange conversion rate type associated with the authorization currency. Default value is ???Corporate???.
CREDIT_CURRENCY_CODE VARCHAR2 15 It is the currency code associated with the credit limit defined for this customer account.
CREDIT_REVIEW_CYCLE VARCHAR2 20 Indicates the period of a customer credit review cycle. It is based on a list of values from the Lookup to user defined values in AR_LOOKUPS table. Review Cycle must be predefined in the lookup type PERIODIC_REVIEW_CYCLE.
TXN_DELIVERY_METHOD VARCHAR2 30 Method of delivering transactions to the customer. Valid values are PRINT and XML.
B2B_TP_CODE VARCHAR2 80 Identifies the customer with a trading partner in a business-to-business relationship.
XML_INV_FLAG VARCHAR2 1 Option to send invoices to customers in XML format.
XML_CM_FLAG VARCHAR2 1 Option to send credit memos to customers in XML format.
XML_DM_FLAG VARCHAR2 1 Option to send debit memos to customers in XML format.
XML_CB_FLAG VARCHAR2 1 Option to send chargebacks to customers in XML format.
PRINTING_OPTION_CODE VARCHAR2 30 Code that indicates if customer receives printed transactions.
STMT_DELIVERY_METHOD VARCHAR2 30 Method of delivering statements to the customer. Valid values are E-Mail,PRINT and XML.
ORDER_AMOUNT_LIMIT NUMBER Maximum order amount defined in the credit currency for the customer account.
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_CUSTOMER_PROFILES_F_N1_ Non Unique CUST_ACCOUNT_PROFILE_ID
HZ_CUSTOMER_PROFILES_F_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, CUST_ACCOUNT_PROFILE_ID
HZ_CUSTOMER_PROFILES_U1_ Unique Default LAST_UPDATE_DATE, CUST_ACCOUNT_PROFILE_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, LAST_UPDATED_BY
HZ_CUSTOMER_PROFILES_U2_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, PARTY_ID, CUST_ACCOUNT_ID, SITE_USE_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE