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

TABLE: AR.HZ_CUSTOMER_PROFILES

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


The HZ_CUSTOMER_PROFILES table stores information about the credit
characteristics of a single customer account or a customer account
site or a party. A profile class defined in the
HZ_CUSTOMER_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
account defined in this table.
The primary key for this table is CUST_ACCOUNT_PROFILE_ID


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_CUSTOMER_PROFILES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_PROFILE_ID
HZ_CUSTOMER_PROFILES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
ColumnCUST_ACCOUNT_ID
ColumnSITE_USE_ID
HZ_CUSTOMER_PROFILES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_ID
HZ_CUSTOMER_PROFILES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSITE_USE_ID
HZ_CUSTOMER_PROFILES_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROFILE_CLASS_ID
Columns
Name Datatype Length Mandatory Comments
CUST_ACCOUNT_PROFILE_ID NUMBER (15) Yes Unique identifier of this customer profile
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.
CUST_ACCOUNT_ID NUMBER (15) Yes Identifier for the Customer Account. Foreign key to the HZ_CUST_ACCOUNTS table
STATUS VARCHAR2 (1) Yes Indicates whether the profile is active or inactive
COLLECTOR_ID NUMBER (15) Yes Identifier of the collector associated with this customer profile
CREDIT_ANALYST_ID NUMBER (15)
Identifier of the credit analyst associated with this customer profile
CREDIT_CHECKING VARCHAR2 (1) Yes Indicates whether a credit check is to be carried out
NEXT_CREDIT_REVIEW_DATE DATE

The next date that credit will be reviewed
TOLERANCE NUMBER
Yes Percentage over credit limit that this customer can exceed before action is taken
DISCOUNT_TERMS VARCHAR2 (1) Yes 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) 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. Default value is Y.
INTEREST_CHARGES VARCHAR2 (1) Yes Indicates if late charges are enabled
PREF_FUNCTIONAL_CURRENCY VARCHAR2 (30)
No longer used
SEND_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 customers credit balances receive statements. Y for statements are sent, N for no statements. Default value is Y.
CREDIT_HOLD VARCHAR2 (1) Yes 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 (15)
Identifier of the customer profile class associated with this customer profile
SITE_USE_ID NUMBER (15)
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
RISK_CODE VARCHAR2 (30)
List of values choices
STANDARD_TERMS NUMBER (15)
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
DUNNING_LETTER_SET_ID NUMBER (15)
No Longer Used.
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 (15)
Identifier of the statement cycle associated with this customer profile
ACCOUNT_STATUS VARCHAR2 (30)
User-defined 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 (15)
Identifier of the autocash hierarchy 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
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).
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).
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).
WH_UPDATE_DATE DATE

Date when the record was entered or changed in a data warehouse
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 transactions, N for not excluding disputed transactions.
TAX_PRINTING_OPTION VARCHAR2 (30)
Tax printing option
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)
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)
JG Descriptive Flexfield
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
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 (30)
Lockbox matching option (typically INVOICE, SALES_ORDER, PURCHASE_ORDER)
OBJECT_VERSION_NUMBER NUMBER

This column is used for locking purposes
CREATED_BY_MODULE VARCHAR2 (150)
TCA Who column
APPLICATION_ID NUMBER

TCA Who column
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 (15)
Party identifier that profile is associated with
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 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.
AUTOMATCH_SET_ID NUMBER (15)
AutoMatch Rule Set identifier (Foreign Key to AR_CASH_AUTO_RULE_SETS.AUTOMATCH_SET_ID)
Query Text

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


SELECT CUST_ACCOUNT_PROFILE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      CUST_ACCOUNT_ID
,      STATUS
,      COLLECTOR_ID
,      CREDIT_ANALYST_ID
,      CREDIT_CHECKING
,      NEXT_CREDIT_REVIEW_DATE
,      TOLERANCE
,      DISCOUNT_TERMS
,      DUNNING_LETTERS
,      INTEREST_CHARGES
,      PREF_FUNCTIONAL_CURRENCY
,      SEND_STATEMENTS
,      CREDIT_BALANCE_STATEMENTS
,      CREDIT_HOLD
,      PROFILE_CLASS_ID
,      SITE_USE_ID
,      CREDIT_RATING
,      RISK_CODE
,      STANDARD_TERMS
,      OVERRIDE_TERMS
,      DUNNING_LETTER_SET_ID
,      INTEREST_PERIOD_DAYS
,      PAYMENT_GRACE_DAYS
,      DISCOUNT_GRACE_DAYS
,      STATEMENT_CYCLE_ID
,      ACCOUNT_STATUS
,      PERCENT_COLLECTABLE
,      AUTOCASH_HIERARCHY_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      WH_UPDATE_DATE
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      AUTO_REC_INCL_DISPUTED_FLAG
,      TAX_PRINTING_OPTION
,      CHARGE_ON_FINANCE_CHARGE_FLAG
,      GROUPING_RULE_ID
,      CLEARING_DAYS
,      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
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
,      REVIEW_CYCLE
,      LAST_CREDIT_REVIEW_DATE
,      PARTY_ID
,      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
,      AUTOMATCH_SET_ID
FROM AR.HZ_CUSTOMER_PROFILES;

Dependencies

[top of page]

AR.HZ_CUSTOMER_PROFILES does not reference any database object

AR.HZ_CUSTOMER_PROFILES is referenced by following:

SchemaAR
ViewHZ_CUSTOMER_PROFILES#