DBA Data[Home] [Help] [Dependency Information]

TABLE: AR.HZ_CUST_PROFILE_CLASSES

Object Details
Object Name: HZ_CUST_PROFILE_CLASSES
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.HZ_CUST_PROFILE_CLASSES
Subobject Name:
Status: VALID


The HZ_CUST_PROFILE_CLASSES table stores information about the credit characteristics that are common across a group of customer accounts. The characteristics specified in this table can be used as default characteristics for similar customer accounts. For example, you can create a profile class called Large Independent Retail Stores and can specify several attributes that describe this class of customer. In the future, you can assign new customers to this class so that the new customer inherits the characteristics of the class.
.
The primary key for this table is PROFILE_CLASS_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_CUST_PROFILE_CLASSES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROFILE_CLASS_ID
Columns
Name Datatype Length Mandatory Comments
PROFILE_CLASS_ID NUMBER (15) Yes Identifier of the customer profile class
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
PROGRAM_APPLICATION_ID NUMBER (15)
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 (15)
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 (15) Yes Identifier of the collector associated with this customer profile class
CREDIT_ANALYST_ID NUMBER (15)
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
PREF_FUNCTIONAL_CURRENCY VARCHAR2 (30)
No longer used
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.
DUNNING_LETTER_SET_ID NUMBER (15)
Identifier of the dunning letter set associated with this customer profile class
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 (15)
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 (15)
Identifier of the statement cycle associated with this customer profile
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
COPY_METHOD VARCHAR2 (9)
Indicates whether modified customer profiles are changed when this class is changed
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
AUTO_REC_INCL_DISPUTED_FLAG VARCHAR2 (1) Yes Indicates if disputed transactions are included. Y for including disputed transacitons, 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 (15)
Identifier for grouping rule name
JGZZ_ATTRIBUTE_CATEGORY VARCHAR2 (30)
JG Descriptive Flexfield segment definition
JGZZ_ATTRIBUTE1 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE2 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE3 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE4 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE5 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE6 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE7 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE8 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE9 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE10 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE11 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE12 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE13 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE14 VARCHAR2 (150)
JG Descriptive Flexfield
JGZZ_ATTRIBUTE15 VARCHAR2 (150)
JG Descriptive Flexfield
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality
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 (15)
Identifies AutoCash rule set for unapplied amount in Post QuickCash
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)
Credit Classification
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

Used internally for locking mechanism
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROFILE_CLASS_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      PROGRAM_APPLICATION_ID
,      NAME
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      STATUS
,      WH_UPDATE_DATE
,      COLLECTOR_ID
,      CREDIT_ANALYST_ID
,      CREDIT_CHECKING
,      TOLERANCE
,      DISCOUNT_TERMS
,      DUNNING_LETTERS
,      INTEREST_CHARGES
,      PREF_FUNCTIONAL_CURRENCY
,      STATEMENTS
,      CREDIT_BALANCE_STATEMENTS
,      DESCRIPTION
,      REVIEW_CYCLE_DAYS
,      OUTSIDE_REPORTING
,      STANDARD_TERMS
,      OVERRIDE_TERMS
,      DUNNING_LETTER_SET_ID
,      COMBINE_DUNNING_LETTERS
,      INTEREST_PERIOD_DAYS
,      AUTOCASH_HIERARCHY_ID
,      PAYMENT_GRACE_DAYS
,      DISCOUNT_GRACE_DAYS
,      STATEMENT_CYCLE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      REQUEST_ID
,      COPY_METHOD
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      AUTO_REC_INCL_DISPUTED_FLAG
,      TAX_PRINTING_OPTION
,      CHARGE_ON_FINANCE_CHARGE_FLAG
,      GROUPING_RULE_ID
,      JGZZ_ATTRIBUTE_CATEGORY
,      JGZZ_ATTRIBUTE1
,      JGZZ_ATTRIBUTE2
,      JGZZ_ATTRIBUTE3
,      JGZZ_ATTRIBUTE4
,      JGZZ_ATTRIBUTE5
,      JGZZ_ATTRIBUTE6
,      JGZZ_ATTRIBUTE7
,      JGZZ_ATTRIBUTE8
,      JGZZ_ATTRIBUTE9
,      JGZZ_ATTRIBUTE10
,      JGZZ_ATTRIBUTE11
,      JGZZ_ATTRIBUTE12
,      JGZZ_ATTRIBUTE13
,      JGZZ_ATTRIBUTE14
,      JGZZ_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      CONS_INV_FLAG
,      CONS_INV_TYPE
,      AUTOCASH_HIERARCHY_ID_FOR_ADR
,      LOCKBOX_MATCHING_OPTION
,      REVIEW_CYCLE
,      CREDIT_CLASSIFICATION
,      CONS_BILL_LEVEL
,      LATE_CHARGE_CALCULATION_TRX
,      CREDIT_ITEMS_FLAG
,      DISPUTED_TRANSACTIONS_FLAG
,      LATE_CHARGE_TYPE
,      LATE_CHARGE_TERM_ID
,      INTEREST_CALCULATION_PERIOD
,      HOLD_CHARGED_INVOICES_FLAG
,      MESSAGE_TEXT_ID
,      MULTIPLE_INTEREST_RATES_FLAG
,      CHARGE_BEGIN_DATE
,      OBJECT_VERSION_NUMBER
FROM AR.HZ_CUST_PROFILE_CLASSES;

Dependencies

[top of page]

AR.HZ_CUST_PROFILE_CLASSES does not reference any database object

AR.HZ_CUST_PROFILE_CLASSES is referenced by following:

SchemaAPPS
SynonymHZ_CUST_PROFILE_CLASSES