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. |
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 |