1. Tables and Views for Financials
  2. HZ_CUST_PROFILE_CLASSES

HZ_CUST_PROFILE_CLASSES

Standard credit profile classes

Details

  • Schema: FUSION

  • Object owner: AR

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HZ_CUST_PROFILE_CLASSES_PK

PROFILE_CLASS_ID

Columns

Name Datatype Length Precision Not-null Comments Flexfield-mapping
PROFILE_CLASS_ID NUMBER 18 Yes Identifier of the customer profile class
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 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.
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).
NAME VARCHAR2 30 Yes Name of the customer profile class
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).
STATUS VARCHAR2 1 Yes Indicates if this customer profile class is active or inactive
WH_UPDATE_DATE DATE Date when the record was entered or changed in a data warehouse
COLLECTOR_ID NUMBER 18 Yes Identifier of the collector associated with this customer profile class
CREDIT_ANALYST_ID NUMBER 18 Identifier of credit analyst associated with this customer profile class
CREDIT_CHECKING VARCHAR2 1 Yes Indicates if credit must be checked. Y for required credit checking, N for optional credit checking
TOLERANCE NUMBER Yes Percentage over credit limit that this customer can exceed before collection action is taken
DISCOUNT_TERMS VARCHAR2 1 Yes Indicates if discount terms are allowed. Y for discount terms allowed, N for no discount terms.
DUNNING_LETTERS VARCHAR2 1 Yes 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.
INTEREST_CHARGES VARCHAR2 1 Yes Indicates if late charges are enabled
STATEMENTS VARCHAR2 1 Yes 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 Yes Indicates if statements with credit balances are sent to this customer. Y for statements are sent, N for no statements.
DESCRIPTION VARCHAR2 80 Description of the customer credit profile class
REVIEW_CYCLE_DAYS NUMBER Number of days between account reviews
OUTSIDE_REPORTING VARCHAR2 1 Indicates whether to report creditworthiness outside the company. Y for credit information is provided to third parties, N for no reporting to third parties about customer creditworthiness.
STANDARD_TERMS NUMBER User-defined payment terms
OVERRIDE_TERMS VARCHAR2 1 Indicates if the user is allowed to override standard terms. Y for allowing user to override stand terms. N for preventing users from overriding standard terms.
COMBINE_DUNNING_LETTERS VARCHAR2 1 Indicates whether to combine dunning letters for this customer profile. Y for combined dunning letters, N for separate dunning letters.
INTEREST_PERIOD_DAYS NUMBER Number of days that the interest rate applies to
AUTOCASH_HIERARCHY_ID NUMBER 18 Identifier of the autocash hierarchy associated with this customer profile class
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
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
COPY_METHOD VARCHAR2 9 Indicates whether modified customer profiles are changed when this class is changed
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Credit Profile Class (AR_CUSTOMER_PROFILE_CLASSES_HZ)
AUTO_REC_INCL_DISPUTED_FLAG VARCHAR2 1 Yes Indicates if disputed transactions are included. Y for including disputed transactions. N for not including disputed transactions.
TAX_PRINTING_OPTION VARCHAR2 30 Define rule for printing invoice. Defaults from System Options
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 Identifier for grouping rule name
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 for no.
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 20 Lockbox matching option (typically INVOICE, SALES_ORDER, or PURCHASE_ORDER)
REVIEW_CYCLE VARCHAR2 30 Review cycle of customer profile data
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.
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.
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.
PREF_CONTACT_METHOD VARCHAR2 30 Preferred contact method
AUTOMATCH_RULE_ID NUMBER 18 AUTOMATCH_RULE_ID is the identifier of new setup entity AutoMatch, which will signify how automatching 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 Exception Rule Identifier rule governs the rules for Over/Under Applications
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 used to calculate the expiration date of an authorization.
CREDIT_LIMIT NUMBER Maximum amount of credit defined in the single currency on the customer profile class.
EXCHANGE_RATE_TYPE VARCHAR2 30 Currency conversion rate type associated with the authorization currency. The default value is Corporate.
CREDIT_CURRENCY_CODE VARCHAR2 15 Currency code associated with the credit limit.
CREDIT_REVIEW_CYCLE VARCHAR2 20 Period of a customer credit review cycle based on a list of values from user-defined values in the AR_LOOKUPS table. Review cycle must be predefined in the PERIODIC_REVIEW_CYCLE lookup type.
STMT_DELIVERY_METHOD VARCHAR2 30 Method of delivering statements to the customer. Valid values are E-Mail,PRINT and XML.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORDER_AMOUNT_LIMIT NUMBER Maximum order amount defined in the credit currency on the customer profile class.
ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.
EXCEPTION_ADJ_REASON_CODE VARCHAR2 30 Reason for adjustment activity against a transaction during a receipt application.Reasons are configued as lookup codes of the ADJUST_REASON lookup type.
ENABLE_CONS_BILLING_FLAG VARCHAR2 1 Indicates whether a customer account is enabled for consolidated billing.
DRAFT_BILL_REVIEW_REQ_FLAG VARCHAR2 1 Indicates whether a draft consolidated invoice requires review before final billing.
CONS_BILLING_TERM_ID NUMBER 18 Consolidated billing terms identifier.

Foreign Keys

Table Foreign Table Foreign Key Column
HZ_CUST_PROFILE_CLASSES ar_app_exception_rules EXCEPTION_RULE_ID
HZ_CUST_PROFILE_CLASSES ar_statement_cycles STATEMENT_CYCLE_ID
HZ_CUST_PROFILE_CLASSES ar_autocash_hierarchies AUTOCASH_HIERARCHY_ID
HZ_CUST_PROFILE_CLASSES ra_grouping_rules GROUPING_RULE_ID
HZ_CUST_PROFILE_CLASSES ar_autocash_hierarchies AUTOCASH_HIERARCHY_ID_FOR_ADR
HZ_CUST_PROFILE_CLASSES ra_terms_b LATE_CHARGE_TERM_ID
HZ_CUST_PROFILE_CLASSES ar_standard_text_b MESSAGE_TEXT_ID
HZ_CUST_PROFILE_CLASSES ra_terms_b STANDARD_TERMS
HZ_CUST_PROFILE_CLASSES ar_automatch_rules AUTOMATCH_RULE_ID
hz_customer_profiles_f hz_cust_profile_classes PROFILE_CLASS_ID
hz_cust_prof_class_amts hz_cust_profile_classes PROFILE_CLASS_ID
hes_org_defaults_all_b hz_cust_profile_classes PROFILE_CLASS_ID

Indexes

Index Uniqueness Tablespace Columns
HZ_CUST_PROFILE_CLASSES_U1 Unique Default PROFILE_CLASS_ID, ORA_SEED_SET1
HZ_CUST_PROFILE_CLASSES_U11 Unique Default PROFILE_CLASS_ID, ORA_SEED_SET2