[Home] [Help] [Dependency Information]
Object Name: | ISC_EDW_BOOK_SUM1_F |
---|---|
Object Type: | TABLE |
Owner: | ISC |
FND Design Data: | ISC.ISC_EDW_BOOK_SUM1_F |
Subobject Name: | |
Status: | VALID |
This summary table holds Booking Summary information
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_EDW_BOOK_SUM1_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | BOOKINGS_PK |
ISC_EDW_BOOK_SUM1_F_N1 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | INSTANCE_FK_KEY |
ISC_EDW_BOOK_SUM1_F_N2 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | DATE_BOOKED_FK_KEY |
ISC_EDW_BOOK_SUM1_F_N3 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | BILL_TO_CUST_FK_KEY |
ISC_EDW_BOOK_SUM1_F_N4 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | SET_OF_BOOKS_FK_KEY |
ISC_EDW_BOOK_SUM1_F_N5 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | OPERATING_UNIT_FK_KEY |
ISC_EDW_BOOK_SUM1_F_N6 | BITMAP | NONUNIQUE | APPS_TS_SUMMARY | CURRENCY_BASE_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOOKINGS_PK | VARCHAR2 | (240) | Unique Identifier | |
BOOKINGS_PK_KEY | NUMBER | System generated unique identifier | ||
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
INSTANCE_FK_KEY | NUMBER | System generated foreign key to the Instance dimension | ||
INSTANCE | VARCHAR2 | (40) | Instance | |
DATE_BOOKED_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Date Booked) | ||
BILL_TO_CUST_FK_KEY | NUMBER | System generated foreign key to the Trading Partner dimension (Bill-to Site) | ||
SET_OF_BOOKS_FK_KEY | NUMBER | System generated foreign key to the Set of Books dimension (GL Set of Book) | ||
OPERATING_UNIT_FK_KEY | NUMBER | System generated foreign key to the Internal Organization dimension (Operating Unit) where the order was booked | ||
CURRENCY_BASE_FK_KEY | NUMBER | System generated foreign key to the Currency dimension (Base Currency) | ||
BOOKED_LIST_AMT_B | NUMBER | Total amount of bookings in list price in Base Currency | ||
BOOKED_LIST_AMT_G | NUMBER | Total amount of bookings in list price in Warehouse Currency | ||
BOOKED_AMT_B | NUMBER | Total amount of bookings in Base Currency | ||
BOOKED_AMT_G | NUMBER | Total amount of bookings in Warehouse Currency | ||
SHIPPED_AMT_B | NUMBER | Total amount shipped in Base Currency | ||
SHIPPED_AMT_G | NUMBER | Total amount shipped in Warehouse Currency | ||
INVOICED_AMT_B | NUMBER | Total amount invoiced in Base Currency | ||
INVOICED_AMT_G | NUMBER | Total amount invoiced in Warehouse Currency | ||
FULFILLED_AMT_B | NUMBER | Total amount fulfilled in Base Currency | ||
FULFILLED_AMT_G | NUMBER | Total amount fulfilled in Warehouse Currency | ||
DATE_BOOKED | DATE | Date Booked | ||
DATE_ORDERED | DATE | Date Ordered | ||
DATE_LATEST_SHIP | DATE | Date Latest Ship | ||
DATE_LATEST_FULFILLED | DATE | Date Latest Fulfilled | ||
ORDER_NUMBER | VARCHAR2 | (80) | Sales Order Number in the source system | |
HEADER_ID | VARCHAR2 | (80) | Sales Order Header Identifier in the source system | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE6 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE7 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE8 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE9 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE10 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE11 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE12 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE13 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE14 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE15 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE16 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE17 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE18 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE19 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE20 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE21 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE22 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE23 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE24 | VARCHAR2 | (240) | User defined attribute | |
USER_ATTRIBUTE25 | VARCHAR2 | (240) | User defined attribute | |
USER_FK1_KEY | NUMBER | System generated foreign key to user defined dimension | ||
USER_FK2_KEY | NUMBER | System generated foreign key to user defined dimension | ||
USER_FK3_KEY | NUMBER | System generated foreign key to user defined dimension | ||
USER_FK4_KEY | NUMBER | System generated foreign key to user defined dimension | ||
USER_FK5_KEY | NUMBER | System generated foreign key to user defined dimension | ||
USER_MEASURE1 | NUMBER | User defined measure | ||
USER_MEASURE2 | NUMBER | User defined measure | ||
USER_MEASURE3 | NUMBER | User defined measure | ||
USER_MEASURE4 | NUMBER | User defined measure | ||
USER_MEASURE5 | NUMBER | User defined measure |
Cut, paste (and edit) the following text to query this object:
SELECT BOOKINGS_PK
, BOOKINGS_PK_KEY
, CREATION_DATE
, LAST_UPDATE_DATE
, INSTANCE_FK_KEY
, INSTANCE
, DATE_BOOKED_FK_KEY
, BILL_TO_CUST_FK_KEY
, SET_OF_BOOKS_FK_KEY
, OPERATING_UNIT_FK_KEY
, CURRENCY_BASE_FK_KEY
, BOOKED_LIST_AMT_B
, BOOKED_LIST_AMT_G
, BOOKED_AMT_B
, BOOKED_AMT_G
, SHIPPED_AMT_B
, SHIPPED_AMT_G
, INVOICED_AMT_B
, INVOICED_AMT_G
, FULFILLED_AMT_B
, FULFILLED_AMT_G
, DATE_BOOKED
, DATE_ORDERED
, DATE_LATEST_SHIP
, DATE_LATEST_FULFILLED
, ORDER_NUMBER
, HEADER_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_ATTRIBUTE16
, USER_ATTRIBUTE17
, USER_ATTRIBUTE18
, USER_ATTRIBUTE19
, USER_ATTRIBUTE20
, USER_ATTRIBUTE21
, USER_ATTRIBUTE22
, USER_ATTRIBUTE23
, USER_ATTRIBUTE24
, USER_ATTRIBUTE25
, USER_FK1_KEY
, USER_FK2_KEY
, USER_FK3_KEY
, USER_FK4_KEY
, USER_FK5_KEY
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
FROM ISC.ISC_EDW_BOOK_SUM1_F;
ISC.ISC_EDW_BOOK_SUM1_F does not reference any database object
ISC.ISC_EDW_BOOK_SUM1_F is referenced by following:
|
|
|