[Home] [Help] [Dependency Information]
Object Name: | AS_SALES_CREDITS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AS.AS_SALES_CREDITS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Unique identifier for Row | |
SALES_CREDIT_ID | NUMBER | Unique identifier for Sales Credit | ||
CREDIT_TYPE_ID | NUMBER | Unique identifier for Credit Type | ||
SALES_CREDIT_TYPE | VARCHAR2 | (240) | Sales Credit Type | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Last Updated By | ||
CREATION_DATE | DATE | Creation Date | ||
CREATED_BY | NUMBER | Created By | ||
LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
REQUEST_ID | NUMBER | Unique identifier for Request | ||
PROGRAM_APPLICATION_ID | NUMBER | Unique identifier for Program Application | ||
PROGRAM_ID | NUMBER | Unique identifier for Program | ||
PROGRAM_UPDATE_DATE | DATE | Program Update Date | ||
LEAD_ID | NUMBER | Unique identifier for Lead | ||
LEAD_LINE_ID | NUMBER | Unique identifier for Lead Line | ||
SALESFORCE_ID | NUMBER | Unique identifier for Salesforce | ||
PERSON_ID | NUMBER | (9) | Unique identifier for Person | |
SALESGROUP_ID | NUMBER | Unique identifier for Salesgroup | ||
PARTNER_CUSTOMER_ID | NUMBER | Unique identifier for Partner Customer | ||
PARTNER_ADDRESS_ID | NUMBER | Unique identifier for Partner Address | ||
DEFAULTED_FROM_OWNER_FLAG | VARCHAR2 | (1) | Flag to indicate if Forecast Owner should be defaulted from Opportunity Owner | |
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 | |
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 | |
CREDIT_PERCENT | NUMBER | Credit Percent | ||
CREDIT_AMOUNT | NUMBER | Credit Amount | ||
OPP_WORST_FORECAST_AMOUNT | NUMBER | Worst Forecast Amount for Opportunity | ||
OPP_FORECAST_AMOUNT | NUMBER | Forecast Amount for Opportunity | ||
OPP_BEST_FORECAST_AMOUNT | NUMBER | Best Forecast Amount for Opportunity | ||
FIRST_NAME | VARCHAR2 | (360) | First Name | |
LAST_NAME | VARCHAR2 | (360) | Last Name | |
FULL_NAME | VARCHAR2 | (360) | First Name | |
SUFFIX | VARCHAR2 | (0) | Suffix | |
GROUP_NAME | VARCHAR2 | (60) | Group Name | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
COUNTRY | VARCHAR2 | (60) | Country | |
ADDRESS1 | VARCHAR2 | (240) | Address1 | |
ADDRESS2 | VARCHAR2 | (240) | Address2 | |
ADDRESS3 | VARCHAR2 | (240) | Address3 | |
ADDRESS4 | VARCHAR2 | (240) | Address4 | |
CITY | VARCHAR2 | (60) | City | |
POSTAL_CODE | VARCHAR2 | (60) | Postal Code | |
STATE | VARCHAR2 | (60) | State | |
PROVINCE | VARCHAR2 | (60) | Province | |
COUNTY | VARCHAR2 | (60) | County |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, SALES_CREDIT_ID
, CREDIT_TYPE_ID
, SALES_CREDIT_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, LEAD_ID
, LEAD_LINE_ID
, SALESFORCE_ID
, PERSON_ID
, SALESGROUP_ID
, PARTNER_CUSTOMER_ID
, PARTNER_ADDRESS_ID
, DEFAULTED_FROM_OWNER_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREDIT_PERCENT
, CREDIT_AMOUNT
, OPP_WORST_FORECAST_AMOUNT
, OPP_FORECAST_AMOUNT
, OPP_BEST_FORECAST_AMOUNT
, FIRST_NAME
, LAST_NAME
, FULL_NAME
, SUFFIX
, GROUP_NAME
, CUSTOMER_NAME
, COUNTRY
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
FROM APPS.AS_SALES_CREDITS_V;
APPS.AS_SALES_CREDITS_V is not referenced by any database object
|
|
|