[Home] [Help] [Dependency Information]
Object Name: | QPR_SR_CUSTOMER_HISTORY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Customer history measures
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUST_ACCOUNT_ID | NUMBER | (15) | Yes | Customer account |
PARTY_SITE_ID | NUMBER | (15) | Yes | Party id |
CURRENCY | VARCHAR2 | (4000) | Currency | |
CUSTOMER_NAME | VARCHAR2 | (240) | Name | |
ADDRESS | VARCHAR2 | (545) | Address | |
INDUSTRY | VARCHAR2 | (30) | Industry | |
ANNUAL_REVENUE | NUMBER | Annual revenue | ||
OVERALL_CREDIT_LIMIT | NUMBER | Overall credit limit | ||
TRANSACTION_CREDIT_LIMIT | NUMBER | Transaction credit limit | ||
RISK_CODE | VARCHAR2 | (30) | Risk code | |
ACCOUNT_STATUS | VARCHAR2 | (30) | Account status | |
AVAILABLE_CREDIT | NUMBER | Available credit | ||
PAST_DUE_TRANSACTIONS | NUMBER | Past due transactions | ||
AVERAGE_DAYS_LATE | NUMBER | Average days late | ||
RECEIPTS_AT_RISK_VALUE | NUMBER | Receipts at risk value |
Cut, paste (and edit) the following text to query this object:
SELECT CUST_ACCOUNT_ID
, PARTY_SITE_ID
, CURRENCY
, CUSTOMER_NAME
, ADDRESS
, INDUSTRY
, ANNUAL_REVENUE
, OVERALL_CREDIT_LIMIT
, TRANSACTION_CREDIT_LIMIT
, RISK_CODE
, ACCOUNT_STATUS
, AVAILABLE_CREDIT
, PAST_DUE_TRANSACTIONS
, AVERAGE_DAYS_LATE
, RECEIPTS_AT_RISK_VALUE
FROM APPS.QPR_SR_CUSTOMER_HISTORY_V;
APPS.QPR_SR_CUSTOMER_HISTORY_V is not referenced by any database object
|
|
|