[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_CUSTOMER_PROFILES |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.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
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| HZ_CUSTOMER_PROFILES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CUST_ACCOUNT_PROFILE_ID
|
| HZ_CUSTOMER_PROFILES_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PARTY_ID
CUST_ACCOUNT_ID
SITE_USE_ID
|
| HZ_CUSTOMER_PROFILES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUST_ACCOUNT_ID
|
| HZ_CUSTOMER_PROFILES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SITE_USE_ID
|
| HZ_CUSTOMER_PROFILES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROFILE_CLASS_ID
|
| 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. |
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
FROM AR.HZ_CUSTOMER_PROFILES;
AR.HZ_CUSTOMER_PROFILES does not reference any database object
AR.HZ_CUSTOMER_PROFILES is referenced by following:
APPS
HZ_CUSTOMER_PROFILES
HZ_CUSTOMER_PROFILES_BRU
|
|
|
|