[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AR_CUSTOMER_PROFILES |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.AR_CUSTOMER_PROFILES
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_ARCHIVE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AR_CUSTOMER_PROFILES_U1 | NORMAL | UNIQUE |
APPS_TS_ARCHIVE
|
 CUSTOMER_PROFILE_ID
|
| AR_CUSTOMER_PROFILES_U2 | NORMAL | UNIQUE |
APPS_TS_ARCHIVE
|
CUSTOMER_ID
SITE_USE_ID
|
| AR_CUSTOMER_PROFILES_N2 | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
CREATION_DATE
|
| AR_CUSTOMER_PROFILES_N3 | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
SITE_USE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CUSTOMER_PROFILE_ID | NUMBER | (15) | Yes | Identifier of the 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. | |
| CUSTOMER_ID | NUMBER | (15) | Yes | Identifier of the customer associated with this profile |
| 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_CHECKING | VARCHAR2 | (1) | Yes | Indicates whether a credit check is to be carried out |
| TOLERANCE | NUMBER | Yes | Percentage over credit limit that this customer can exceed before action is taken | |
| DISCOUNT_TERMS | VARCHAR2 | (1) | Yes | Indicates whether to allow discount terms |
| DUNNING_LETTERS | VARCHAR2 | (1) | Yes | Indicates whether to send dunning letters to this customer when invoices, debit memos or chargebacks become past due |
| INTEREST_CHARGES | VARCHAR2 | (1) | Yes | Indicates whether to charge this customer interest |
| STATEMENTS | VARCHAR2 | (1) | Yes | Indicates whether to send this customer statements |
| CREDIT_BALANCE_STATEMENTS | VARCHAR2 | (1) | Yes | Indicates whether to send statements that have a credit balance |
| CREDIT_HOLD | VARCHAR2 | (1) | Yes | Indicates whether to put a hold on this customer's credit |
| CUSTOMER_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 | |
| CREDIT_LIMIT_EXPIRATION_DATE | DATE | No longer used | ||
| REVIEW_CYCLE_DAYS | NUMBER | No longer used | ||
| CREDIT_RATING | VARCHAR2 | (30) | List of values choice (CREDIT_RATING) | |
| RISK_CODE | VARCHAR2 | (30) | List of values choice (RISK_CODE) | |
| OUTSIDE_REPORTING | VARCHAR2 | (1) | No longer used | |
| STANDARD_TERMS | NUMBER | (15) | User defined payment terms | |
| OVERRIDE_TERMS | VARCHAR2 | (1) | Indicates whether to allow override of standard terms | |
| UNIQUE_TERMS | VARCHAR2 | (1) | No longer used | |
| AUTO_DUNNING_DAYS | NUMBER | (15) | No longer used | |
| DUNNING_LETTER_SET_ID | NUMBER | (15) | Identifier of the dunning letter set associated with this customer profile | |
| COMBINE_DUNNING_LETTERS | VARCHAR2 | (1) | No longer used | |
| INTEREST_PERIOD_DAYS | NUMBER | Number of days to which the interest rate refers | ||
| PRIMARY_AUTO_CASH_METHOD | NUMBER | No longer used | ||
| 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 can be expected to be collected 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). | |
| 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 | Y means include disputed transactions; N means do not include disputed transactions |
| TAX_PRINTING_OPTION | VARCHAR2 | (30) | Tax printing option | |
| CHARGE_ON_FINANCE_CHARGE_FLAG | VARCHAR2 | (1) | Y to compound finance charges and N to not compound finance charges for this customer or site | |
| 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 | (35) | 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 Globalization Functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Reserved For Globalization Functionality | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved For Globalization Functionality | |
| CONS_INV_FLAG | VARCHAR2 | (1) | Y or N indicates whether customer will be sent a Consolidated Billing Invoice | |
| CONS_INV_TYPE | VARCHAR2 | (30) | Type of Consolidated Billing Invoice sent to customer (SUMMARY or DETAIL) | |
| 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, PURCHASE_ORDER) | |
| PREF_FUNCTIONAL_CURRENCY | VARCHAR2 | (30) | Customers preferred functional currency |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_PROFILE_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, CUSTOMER_ID
, STATUS
, COLLECTOR_ID
, CREDIT_CHECKING
, TOLERANCE
, DISCOUNT_TERMS
, DUNNING_LETTERS
, INTEREST_CHARGES
, STATEMENTS
, CREDIT_BALANCE_STATEMENTS
, CREDIT_HOLD
, CUSTOMER_PROFILE_CLASS_ID
, SITE_USE_ID
, CREDIT_LIMIT_EXPIRATION_DATE
, REVIEW_CYCLE_DAYS
, CREDIT_RATING
, RISK_CODE
, OUTSIDE_REPORTING
, STANDARD_TERMS
, OVERRIDE_TERMS
, UNIQUE_TERMS
, AUTO_DUNNING_DAYS
, DUNNING_LETTER_SET_ID
, COMBINE_DUNNING_LETTERS
, INTEREST_PERIOD_DAYS
, PRIMARY_AUTO_CASH_METHOD
, 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
, 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
, PREF_FUNCTIONAL_CURRENCY
FROM AR.AR_CUSTOMER_PROFILES;
AR.AR_CUSTOMER_PROFILES does not reference any database object
AR.AR_CUSTOMER_PROFILES is referenced by following:
AR
AR_CUSTOMER_PROFILES#
|
|
|
|