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

VIEW: APPS.JTF_CUSTOMER_PROFILES_V

Object Details
Object Name: JTF_CUSTOMER_PROFILES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJTF.JTF_CUSTOMER_PROFILES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


JTF_CUSTOMER_PROFILES_V retrieves credit information for your customer accounts and customer account sites.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
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 Customer Account identifier. FK to HZ_CUST_ACCOUNTS_ALL
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 on which 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 Discount Term
DUNNING_LETTERS VARCHAR2 (1) Yes Indicates whether to send dunning letters to this customer when invoices, debit memos or chargebacks become past due. The default value is ''Y'' (Yes).
INTEREST_CHARGES VARCHAR2 (1) Yes Indicates whether to charge this customer interest. The default value is ''Y'' (Yes).
PREF_FUNCTIONAL_CURRENCY VARCHAR2 (30)
Customer''s preferred functional currency
SEND_STATEMENTS VARCHAR2 (1) Yes Indicates whether to send this customer statements. The default value is ''Y'' (Yes).
CREDIT_BALANCE_STATEMENTS VARCHAR2 (1) Yes Indicates whether to send statements that have a credit balance. The default value is ''Y'' (Yes).
CREDIT_HOLD VARCHAR2 (1) Yes Indicates whether to put a hold on this customers credit
PROFILE_CLASS_ID NUMBER (15)
Profile Class Id
SITE_USE_ID NUMBER (15)
Identifier of the site use record associated with this customer profile. FK to HZ_CUST_SITE_USES_ALL
CREDIT_RATING VARCHAR2 (30)
List of values choice (CREDIT_RATING)
RISK_CODE VARCHAR2 (30)
List of values choice (RISK_CODE)
STANDARD_TERMS NUMBER (15)
User defined payment terms
OVERRIDE_TERMS VARCHAR2 (1)
Indicates whether to allow override of standard terms
DUNNING_LETTER_SET_ID NUMBER (15)
Identifer of the dunning letter set associated with this customer profile
INTEREST_PERIOD_DAYS NUMBER

Number of days that the interest rate refers to
PAYMENT_GRACE_DAYS NUMBER

Payment Grace Days
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

Warehouse update date when record was recorded or 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 whether to include disputed transactions. Values include Y or N.
TAX_PRINTING_OPTION VARCHAR2 (30)
Tax printing option
CHARGE_ON_FINANCE_CHARGE_FLAG VARCHAR2 (1)
Indicates whether to compount finance charges for this customer or site. Values include Y or N.
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 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 (30)
Lockbox matching option (typically INVOICE, SALES_ORDER, PURCHASE_ORDER)
Query Text

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


SELECT ROW_ID
,      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
FROM APPS.JTF_CUSTOMER_PROFILES_V;

Dependencies

[top of page]

APPS.JTF_CUSTOMER_PROFILES_V references the following:

SchemaAPPS
SynonymHZ_CUSTOMER_PROFILES
APPS.JTF_CUSTOMER_PROFILES_V is referenced by following:

SchemaAPPS
Package BodyIEX_ROUTING_PVT - show dependent code
PL/SQL PackageIEX_ROUTING_PVT - show dependent code