eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ISC.ISC_EDW_BOOK_SUM1_F

Object Details

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

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

ISC.ISC_EDW_BOOK_SUM1_F does not reference any database object

ISC.ISC_EDW_BOOK_SUM1_F is referenced by following:

APPS: ISC_EDW_BOOK_SUM1_F