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

TABLE: OSM.AS_SALES_CREDITS

Object Details
Object Name: AS_SALES_CREDITS
Object Type: TABLE
Owner: OSM
FND Design Data: TableAS.AS_SALES_CREDITS
Subobject Name:
Status: VALID


AS_SALES_CREDITS stores the sales credit information for
various sales credit types for a line in AS_LEAD_LINES_ALL.
The credit_type_id is foreign key into oe_sales_credit_types table.
The revenue credit type id (forecast credits) is set in profile option
OS: Forecast Credit Type. The non revenue credit type id (quota credits)
is set in profile option OS: Quota Credit Type
A sales credit record can be associated with either a salesforce
partner or a salesforce employee. Either the person_id column or the
partner columns (partner_customer_id and partner_address_id) will be
populated, but not both.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AS_SALES_CREDITS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSALES_CREDIT_ID
AS_SALES_CREDITS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEAD_ID
ColumnLEAD_LINE_ID
AS_SALES_CREDITS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
AS_SALES_CREDITS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSALESFORCE_ID
ColumnLEAD_ID
AS_SALES_CREDITS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSALESGROUP_ID
AS_SALES_CREDITS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTNER_ADDRESS_ID
AS_SALES_CREDITS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEAD_LINE_ID
ColumnSALESFORCE_ID
ColumnPARTNER_ADDRESS_ID
AS_SALES_CREDITS_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTNER_CUSTOMER_ID
Columns
Name Datatype Length Mandatory Comments
SALES_CREDIT_ID NUMBER
Yes Sales credit identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
REQUEST_ID NUMBER

Request identifier of last concurrent program to update record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update record
PROGRAM_ID NUMBER

Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE DATE

Last date concurrent program updated record
LEAD_ID NUMBER
Yes Lead identifier
LEAD_LINE_ID NUMBER
Yes Lead line identifier
SALESFORCE_ID NUMBER
Yes Salesforce member identifier who has credit on this purchase item
PERSON_ID NUMBER (9)
Employee identifier of this salesforce
SALESGROUP_ID NUMBER

Sales group identifier which the sales rep belongs to
PARTNER_CUSTOMER_ID NUMBER

Customer identifier for a partner
PARTNER_ADDRESS_ID NUMBER

Account Identifier of a partner
REVENUE_AMOUNT NUMBER

Obsolete
REVENUE_PERCENT NUMBER

Obsolete
QUOTA_CREDIT_AMOUNT NUMBER

Obsolete
QUOTA_CREDIT_PERCENT NUMBER

Obsolete
MANAGER_REVIEW_FLAG VARCHAR2 (1)
Obsolete
MANAGER_REVIEW_DATE DATE

Obsolete
ORIGINAL_SALES_CREDIT_ID NUMBER

Obsolete column
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_TYPE_ID NUMBER

Credit Type identifier of the sales credit, from OE_SALES_CREDIT_TYPES
CREDIT_PERCENT NUMBER

Credit percentage (0 - 100) with the credit type defined by column CREDIT_TYPE
CREDIT_AMOUNT NUMBER

Credit amount with the credit type defined by the column CREDIT_TYPE
SECURITY_GROUP_ID NUMBER

Subscriber id, for CRM Online Services use
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
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
DEFAULTED_FROM_OWNER_FLAG VARCHAR2 (1)
Flag to indicate if Forecast Owner should be defaulted from Opportunity Owner
Query Text

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


SELECT SALES_CREDIT_ID
,      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
,      REVENUE_AMOUNT
,      REVENUE_PERCENT
,      QUOTA_CREDIT_AMOUNT
,      QUOTA_CREDIT_PERCENT
,      MANAGER_REVIEW_FLAG
,      MANAGER_REVIEW_DATE
,      ORIGINAL_SALES_CREDIT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREDIT_TYPE_ID
,      CREDIT_PERCENT
,      CREDIT_AMOUNT
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      OPP_WORST_FORECAST_AMOUNT
,      OPP_FORECAST_AMOUNT
,      OPP_BEST_FORECAST_AMOUNT
,      DEFAULTED_FROM_OWNER_FLAG
FROM OSM.AS_SALES_CREDITS;

Dependencies

[top of page]

OSM.AS_SALES_CREDITS does not reference any database object

OSM.AS_SALES_CREDITS is referenced by following:

SchemaOSM
ViewAS_SALES_CREDITS#