eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AR_HCUSTOMER_PROFILES

Product:	AR - Receivables
Description:	Customer credit information
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CUST_ACCOUNT_PROFILE_ID /* CUSTOMER_PROFILE_ID */
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, CUST_ACCOUNT_ID /* CUSTOMER_ID */
, STATUS
, COLLECTOR_ID
, CREDIT_CHECKING
, TOLERANCE
, DISCOUNT_TERMS
, DUNNING_LETTERS
, INTEREST_CHARGES
, SEND_STATEMENTS
, CREDIT_BALANCE_STATEMENTS
, CREDIT_HOLD
, PROFILE_CLASS_ID
, SITE_USE_ID
, NULL /* CREDIT_LIMIT_EXPIRATION_DATE (NO LONGER USED) */
, TO_NUMBER(NULL) /* REVIEW_CYCLE_DAYS (NO LONGER USED) */
, CREDIT_RATING
, RISK_CODE
, NULL /* OUTSIDE_REPORTING (NO LONGER USED) */
, STANDARD_TERMS
, OVERRIDE_TERMS
, NULL /* UNIQUE_TERMS (NO LONGER USED) */
, TO_NUMBER(NULL) /* AUTO_DUNNING_DAYS (NO LONGER USED) */
, DUNNING_LETTER_SET_ID
, NULL /* COMBINE_DUNNING_LETTERS (NO LONGER USED) */
, INTEREST_PERIOD_DAYS
, TO_NUMBER(NULL) /* PRIMARY_AUTO_CASH_METHOD (NO LONGER USED) */
, 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
FROM HZ_CUSTOMER_PROFILES

Columns

Name
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