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_BACKLOGS_FSTG

Object Details

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

This is the interface table for the Backlog Snapshot fact table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the fact table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_EDW_BACKLOGS_FSTG_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BACKLOGS_PK
ISC_EDW_BACKLOGS_FSTG_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	COLLECTION_STATUS

Columns

Name	Datatype	Length	Comments
BACKLOGS_PK	VARCHAR2	(240)	Unique identifier
BASE_UOM_FK	VARCHAR2	(240)	Foreign key to the UoM dimension
BASE_UOM_FK_KEY	NUMBER		System generated foreign key to the UoM dimension
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)
BILL_TO_LOCATION_FK	VARCHAR2	(240)	System generated foreign key to the Geography dimension (Bill-to Location)
BILL_TO_LOCATION_FK_KEY	NUMBER		System generated foreign key to the Geography dimension (Bill-to Location)
CUSTOMER_FK	VARCHAR2	(240)	Foreign key to the Trading Partner dimension (Customer)
CUSTOMER_FK_KEY	NUMBER		System generated foreign key to the Trading Partner dimension (Customer)
DATE_BALANCE_FK	VARCHAR2	(240)	Foreign key to the Time dimension (Date of Snapshot)
DATE_BALANCE_FK_KEY	NUMBER		System generated foreign key to the Time dimension (Date of Snapshot)
DEMAND_CLASS_FK	VARCHAR2	(240)	Foreign key to the Demand Class dimension
DEMAND_CLASS_FK_KEY	NUMBER		System generated foreign key to the Demand Class dimension
GL_BOOK_FK	VARCHAR2	(240)	Foreign key to the Set of Books dimension (GL Set of Book)
GL_BOOK_FK_KEY	NUMBER		System generated foreign key to the Set of Books dimension (GL Set of Book)
INSTANCE_FK	VARCHAR2	(240)	Foreign key to the Instance dimension
INSTANCE_FK_KEY	NUMBER		System generated foreign key to the Instance dimension
INV_ORG_FK	VARCHAR2	(240)	Foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
INV_ORG_FK_KEY	NUMBER		System generated foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
ITEM_ORG_FK	VARCHAR2	(320)	Foreign key to the Organization Item dimension
ITEM_ORG_FK_KEY	NUMBER		System generated foreign key to the Organization Item dimension
OPERATING_UNIT_FK	VARCHAR2	(240)	Foreign key to the Internal Organization dimension (Operating Unit)
OPERATING_UNIT_FK_KEY	NUMBER		System generated foreign key to the Internal Organization dimension (Operating Unit)
ORDER_CATEGORY_FK	VARCHAR2	(240)	Foreign key to the Lookup dimension (Sales Order Category)
ORDER_CATEGORY_FK_KEY	NUMBER		System generated foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK	VARCHAR2	(240)	Foreign key to the Sales Order Source dimension
ORDER_SOURCE_FK_KEY	NUMBER		System generated foreign key to the Lookup dimension (Sales Order Source)
ORDER_TYPE_FK	VARCHAR2	(240)	Foreign key to the Lookup dimension (Sales Order Type)
ORDER_TYPE_FK_KEY	NUMBER		System generated foreign key to the Lookup dimension (Sales Order Type)
SALES_CHANNEL_FK	VARCHAR2	(240)	Foreign key to the Sales Channel dimension
SALES_CHANNEL_FK_KEY	NUMBER		System generated foreign key to the Sales Channel dimension
SALES_PERSON_FK	VARCHAR2	(320)	Reserved for future use
SALES_PERSON_FK_KEY	NUMBER		Reserved for future use
SHIP_TO_CUST_FK	VARCHAR2	(320)	Foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_CUST_FK_KEY	NUMBER		System generated foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOCATION_FK	VARCHAR2	(320)	Foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
SHIP_TO_LOCATION_FK_KEY	NUMBER		System generated foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
TASK_FK	VARCHAR2	(240)	Foreign key to the Project dimension (Project Task)
TASK_FK_KEY	NUMBER		System generated foreign key to the Project dimension (Project Task)
TOP_MODEL_ITEM_FK	VARCHAR2	(320)	Foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
TOP_MODEL_ITEM_FK_KEY	NUMBER		System generated foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
TRX_CURRENCY_FK	VARCHAR2	(240)	Foreign key to the Currency dimension (Transaction Currency)
TRX_CURRENCY_FK_KEY	NUMBER		System generated foreign key to the Currency dimension (Transaction Currency)
BILL_BKLG_COST_G	NUMBER		Billing Backlog Cost in Warehouse Currency
BILL_BKLG_COST_T	NUMBER		Billing Backlog Cost in Transaction Currency
BILL_BKLG_MRG_G	NUMBER		Billing Backlog Gross Margin in Warehouse Currency
BILL_BKLG_MRG_T	NUMBER		Billing Backlog Gross Margin in Transaction Currency
BILL_BKLG_REV_G	NUMBER		Billing Backlog Revenue in Warehouse Currency
BILL_BKLG_REV_T	NUMBER		Billing Backlog Revenue in Transaction Currency
DLQT_BKLG_COST_G	NUMBER		Delinquent Backlog Cost in Warehouse Currency
DLQT_BKLG_COST_T	NUMBER		Delinquent Backlog Cost in Transaction Currency
DLQT_BKLG_MRG_G	NUMBER		Delinquent Backlog Gross Margin in Warehouse Currency
DLQT_BKLG_MRG_T	NUMBER		Delinquent Backlog Gross Margin in Transaction Currency
DLQT_BKLG_REV_G	NUMBER		Delinquent Backlog Revenue in Warehouse Currency
DLQT_BKLG_REV_T	NUMBER		Delinquent Backlog Revenue in Transaction Currency
EDW_COLLECTION_DATE	DATE		Date on which this row was collected
COLLECTION_STATUS	VARCHAR2	(40)	Collection status code for the record
ERROR_CODE	VARCHAR2	(2000)	Code used to store error messages
INSTANCE	VARCHAR2	(40)	Instance
LAST_UPDATE_DATE	DATE		Standard Who column
OPERATION_CODE	VARCHAR2	(40)	Code used by the collection program to determine whether to insert/update/delete this record
QTY_BILL_BKLG_B	NUMBER		Billing Backlog Quantity
QTY_DLQT_BKLG_B	NUMBER		Delinquent Backlog Quantity
QTY_SHIP_BKLG_B	NUMBER		Shipping Backlog Quantity
QTY_UNBILL_SHIP_B	NUMBER		Unbilled Shipments Backlog Quantity
REQUEST_ID	NUMBER		Identifier used by collection program
ROW_ID	ROWID	(10)	Row Id
SHIP_BKLG_COST_G	NUMBER		Shipping Backlog Cost in Warehouse Currency
SHIP_BKLG_COST_T	NUMBER		Shipping Backlog Cost in Transaction Currency
SHIP_BKLG_MRG_G	NUMBER		Shipping Backlog Gross Margin in Warehouse Currency
SHIP_BKLG_MRG_T	NUMBER		Shipping Backlog Gross Margin in Transaction Currency
SHIP_BKLG_REV_G	NUMBER		Shipping Backlog Revenue in Warehouse Currency
SHIP_BKLG_REV_T	NUMBER		Shipping Backlog Revenue in Transaction Currency
UNBILL_SHIP_COST_G	NUMBER		Unbilled Shipments Cost in Warehouse Currency
UNBILL_SHIP_COST_T	NUMBER		Unbilled Shipments Cost in Transaction Currency
UNBILL_SHIP_MRG_G	NUMBER		Unbilled Shipments Gross Margin in Warehouse Currency
UNBILL_SHIP_MRG_T	NUMBER		Unbilled Shipments Gross Margin in Transaction Currency
UNBILL_SHIP_REV_G	NUMBER		Unbilled Shipments Revenue in Warehouse Currency
UNBILL_SHIP_REV_T	NUMBER		Unbilled Shipments Revenue in Transaction Currency
USER_ATTRIBUTE1	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE2	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE3	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE4	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE5	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE6	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE7	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE8	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE9	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE10	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE11	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE12	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE13	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE14	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE15	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE16	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE17	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE18	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE19	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE20	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE21	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE22	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE23	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE24	VARCHAR2	(240)	User attribute
USER_ATTRIBUTE25	VARCHAR2	(240)	User attribute
USER_FK1	VARCHAR2	(240)	Foreign key to user defined dimension
USER_FK2	VARCHAR2	(240)	Foreign key to user defined dimension
USER_FK3	VARCHAR2	(240)	Foreign key to user defined dimension
USER_FK4	VARCHAR2	(240)	Foreign key to user defined dimension
USER_FK5	VARCHAR2	(240)	Foreign key to user defined dimension
USER_FK1_KEY	NUMBER		System generated key foreign key to user defined dimension
USER_FK2_KEY	NUMBER		System generated key foreign key to user defined dimension
USER_FK3_KEY	NUMBER		System generated key foreign key to user defined dimension
USER_FK4_KEY	NUMBER		System generated key foreign key to user defined dimension
USER_FK5_KEY	NUMBER		System generated key 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 BACKLOGS_PK
,      BASE_UOM_FK
,      BASE_UOM_FK_KEY
,      BILL_TO_CUST_FK
,      BILL_TO_CUST_FK_KEY
,      BILL_TO_LOCATION_FK
,      BILL_TO_LOCATION_FK_KEY
,      CUSTOMER_FK
,      CUSTOMER_FK_KEY
,      DATE_BALANCE_FK
,      DATE_BALANCE_FK_KEY
,      DEMAND_CLASS_FK
,      DEMAND_CLASS_FK_KEY
,      GL_BOOK_FK
,      GL_BOOK_FK_KEY
,      INSTANCE_FK
,      INSTANCE_FK_KEY
,      INV_ORG_FK
,      INV_ORG_FK_KEY
,      ITEM_ORG_FK
,      ITEM_ORG_FK_KEY
,      OPERATING_UNIT_FK
,      OPERATING_UNIT_FK_KEY
,      ORDER_CATEGORY_FK
,      ORDER_CATEGORY_FK_KEY
,      ORDER_SOURCE_FK
,      ORDER_SOURCE_FK_KEY
,      ORDER_TYPE_FK
,      ORDER_TYPE_FK_KEY
,      SALES_CHANNEL_FK
,      SALES_CHANNEL_FK_KEY
,      SALES_PERSON_FK
,      SALES_PERSON_FK_KEY
,      SHIP_TO_CUST_FK
,      SHIP_TO_CUST_FK_KEY
,      SHIP_TO_LOCATION_FK
,      SHIP_TO_LOCATION_FK_KEY
,      TASK_FK
,      TASK_FK_KEY
,      TOP_MODEL_ITEM_FK
,      TOP_MODEL_ITEM_FK_KEY
,      TRX_CURRENCY_FK
,      TRX_CURRENCY_FK_KEY
,      BILL_BKLG_COST_G
,      BILL_BKLG_COST_T
,      BILL_BKLG_MRG_G
,      BILL_BKLG_MRG_T
,      BILL_BKLG_REV_G
,      BILL_BKLG_REV_T
,      DLQT_BKLG_COST_G
,      DLQT_BKLG_COST_T
,      DLQT_BKLG_MRG_G
,      DLQT_BKLG_MRG_T
,      DLQT_BKLG_REV_G
,      DLQT_BKLG_REV_T
,      EDW_COLLECTION_DATE
,      COLLECTION_STATUS
,      ERROR_CODE
,      INSTANCE
,      LAST_UPDATE_DATE
,      OPERATION_CODE
,      QTY_BILL_BKLG_B
,      QTY_DLQT_BKLG_B
,      QTY_SHIP_BKLG_B
,      QTY_UNBILL_SHIP_B
,      REQUEST_ID
,      ROW_ID
,      SHIP_BKLG_COST_G
,      SHIP_BKLG_COST_T
,      SHIP_BKLG_MRG_G
,      SHIP_BKLG_MRG_T
,      SHIP_BKLG_REV_G
,      SHIP_BKLG_REV_T
,      UNBILL_SHIP_COST_G
,      UNBILL_SHIP_COST_T
,      UNBILL_SHIP_MRG_G
,      UNBILL_SHIP_MRG_T
,      UNBILL_SHIP_REV_G
,      UNBILL_SHIP_REV_T
,      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_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      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_BACKLOGS_FSTG;

Dependencies

[top of page]

ISC.ISC_EDW_BACKLOGS_FSTG does not reference any database object

ISC.ISC_EDW_BACKLOGS_FSTG is referenced by following:

APPS: ISC_EDW_BACKLOGS_FSTG