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_FSTG

Object Details

Object Name:	ISC_EDW_BOOK_SUM1_FSTG
Object Type:	TABLE
Owner:	ISC
FND Design Data:	ISC.ISC_EDW_BOOK_SUM1_FSTG
Subobject Name:
Status:	VALID

This is the interface table for the Booking Summary table

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_EDW_BOOK_SUM1_FSTG_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BOOKINGS_PK
ISC_EDW_BOOK_SUM1_FSTG_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	COLLECTION_STATUS

Columns

Name	Datatype	Length	Comments
BOOKINGS_PK	VARCHAR2	(240)	Unique Identifier
LAST_UPDATE_DATE	DATE		Standard Who column
COLLECTION_STATUS	VARCHAR2	(40)	Collection status code for the record
ERROR_CODE	VARCHAR2	(2000)	ode used to store error messages
OPERATION_CODE	VARCHAR2	(40)	Code used by the collection program to determine whether to insert/update/delete this record
REQUEST_ID	NUMBER		Identifier used by collection program
ROW_ID	ROWID	(10)	Row Id
INSTANCE	VARCHAR2	(40)	Instance
INSTANCE_FK	VARCHAR2	(240)	Foreign key to the Instance dimension
INSTANCE_FK_KEY	NUMBER		System generated foreign key to the Instance dimension
DATE_BOOKED_FK	VARCHAR2	(240)	Foreign key to the Time dimension (Date Booked)
DATE_BOOKED_FK_KEY	NUMBER		System generated foreign key to the Time dimension (Date Booked)
BILL_TO_CUST_FK	VARCHAR2	(320)	Foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_CUST_FK_KEY	NUMBER		System generated foreign key to the Trading Partner dimension (Bill-to Site)
SET_OF_BOOKS_FK	VARCHAR2	(240)	Foreign key to the Set of Books dimension (GL Set of Book)
SET_OF_BOOKS_FK_KEY	NUMBER		System generated foreign key to the Set of Books dimension (GL Set of Book)
OPERATING_UNIT_FK	VARCHAR2	(240)	Foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
OPERATING_UNIT_FK_KEY	NUMBER		System generated foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
CURRENCY_BASE_FK	VARCHAR2	(240)	Foreign key to the Currency dimension (Base Currency)
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	VARCHAR2	(240)	Foreign key to user defined dimension
USER_FK1_KEY	NUMBER		System generated foreign key to user defined dimension
USER_FK2	VARCHAR2	(240)	Foreign key to user defined dimension
USER_FK2_KEY	NUMBER		System generated foreign key to user defined dimension
USER_FK3	VARCHAR2	(240)	Foreign key to user defined dimension
USER_FK3_KEY	NUMBER		System generated foreign key to user defined dimension
USER_FK4	VARCHAR2	(240)	Foreign key to user defined dimension
USER_FK4_KEY	NUMBER		System generated foreign key to user defined dimension
USER_FK5	VARCHAR2	(240)	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
,      LAST_UPDATE_DATE
,      COLLECTION_STATUS
,      ERROR_CODE
,      OPERATION_CODE
,      REQUEST_ID
,      ROW_ID
,      INSTANCE
,      INSTANCE_FK
,      INSTANCE_FK_KEY
,      DATE_BOOKED_FK
,      DATE_BOOKED_FK_KEY
,      BILL_TO_CUST_FK
,      BILL_TO_CUST_FK_KEY
,      SET_OF_BOOKS_FK
,      SET_OF_BOOKS_FK_KEY
,      OPERATING_UNIT_FK
,      OPERATING_UNIT_FK_KEY
,      CURRENCY_BASE_FK
,      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
,      USER_FK1_KEY
,      USER_FK2
,      USER_FK2_KEY
,      USER_FK3
,      USER_FK3_KEY
,      USER_FK4
,      USER_FK4_KEY
,      USER_FK5
,      USER_FK5_KEY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
FROM ISC.ISC_EDW_BOOK_SUM1_FSTG;

Dependencies

[top of page]

ISC.ISC_EDW_BOOK_SUM1_FSTG does not reference any database object

ISC.ISC_EDW_BOOK_SUM1_FSTG is referenced by following:

APPS: ISC_EDW_BOOK_SUM1_FSTG