[Home] [Help] [Dependency Information]
Object Name: | ISC_SALES_CREDITS_F |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
Base summary table for Product Revenue Bookings and Backlog Page. It is built on OE_SALES_CREDITS. It only contains the resource dimension. It contains the sales credit distribution amounts (as a percent) for each sales representative for each order line that appears in ISC_BOOK_SUM2_F. It also contains various sales credit attributes such as sales credit type and the sales group of the sales representative.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_SALES_CREDITS_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | PK |
ISC_SALES_CREDITS_F_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | LINE_ID |
ISC_SALES_CREDITS_F_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SALES_CREDIT_ID |
ISC_SALES_CREDITS_F_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | RESOURCE_ID |
ISC_SALES_CREDITS_F_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SALES_GRP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PK | VARCHAR2 | (240) | Primary Key | |
SALES_CREDIT_ID | NUMBER | System generated ID | ||
RESOURCE_ID | NUMBER | JTF Resource Identifier | ||
SALES_GRP_ID | NUMBER | JTF Resource Group Identifier | ||
HEADER_ID | NUMBER | Order Header Identifier | ||
LINE_ID | NUMBER | System Generated Line Identifier | ||
SALES_CREDIT_PERCENT | NUMBER | Value to indicate Sales Credit percent for a sales person | ||
SALES_CREDIT_TYPE_ID | NUMBER | Stores Foreign key to point to sales credit type | ||
CREATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT PK
, SALES_CREDIT_ID
, RESOURCE_ID
, SALES_GRP_ID
, HEADER_ID
, LINE_ID
, SALES_CREDIT_PERCENT
, SALES_CREDIT_TYPE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM ISC.ISC_SALES_CREDITS_F;
ISC.ISC_SALES_CREDITS_F does not reference any database object
ISC.ISC_SALES_CREDITS_F is referenced by following:
|
|
|