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_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, PROFILE_CLASS_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
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 | 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. | |||
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 | 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 | 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 | 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 | Indicates if credit must be checked. Y for required credit checking, N for optional credit checking | ||
TOLERANCE | NUMBER | Percentage over credit limit that this customer can exceed before collection action is taken | |||
DISCOUNT_TERMS | VARCHAR2 | 1 | Indicates if discount terms are allowed. Y for discount terms allowed, N for no discount terms. | ||
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. | ||
INTEREST_CHARGES | VARCHAR2 | 1 | Indicates if late charges are enabled | ||
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 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. | ||
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. | ||
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. | ||
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 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 | 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. | |||
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. | ||
AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
HZ_CUST_PROFILE_CLASSESN1_ | Non Unique | Default | PROFILE_CLASS_ID, LAST_UPDATE_DATE |
HZ_CUST_PROFILE_CLASSES_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, PROFILE_CLASS_ID |