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

TABLE: ISC.ISC_EDW_BACKLOGS_F

Object Details
Object Name: ISC_EDW_BACKLOGS_F
Object Type: TABLE
Owner: ISC
FND Design Data: TableISC.ISC_EDW_BACKLOGS_F
Subobject Name:
Status: VALID


This fact table stores the daily status of the Sales Order Backlog activity. It maintains
a history of measures by taking a daily snapshot of backlog situation. Using this fact
table, users can perform trend analysis on backlog balances. They can also analyze
potential margin due to backlog in billing or shipment. Data is retrieved from the
Sales Order Headers, Sales Order Lines, and Sales Order Line Details (Oracle Order
Entry) and is kept at the day + dimensions combination level. The measures
available in this fact table are Quantity, Cost, Value (at Sell Price), and Margin for
the Shipping Backlog (Booked not Shipped), the Delinquent Backlog (Scheduled but
not Shipped), the Unbilled Shipment Backlog (Shipped but not Billed), the Billing
Backlog (Booked but not Billed) expressed in Base UoM (Quantities), and both
original Transaction Currency and Global Warehouse Currency (monetary
amounts). Backlog measures can be aggregated by Item, Order Category, Trading
Partner, Geography, Project, Demand Class, Time, Internal Organization, Set of Books,
Order Source, Order Type, Sales Channel, Person, Unit of Measure, Instance, and Currency.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 30
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ISC_EDW_BACKLOGS_F_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnBACKLOGS_PK
ISC_EDW_BACKLOGS_F_N1 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORDER_TYPE_FK_KEY
ISC_EDW_BACKLOGS_F_N10 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnBASE_UOM_FK_KEY
ISC_EDW_BACKLOGS_F_N11 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnINV_ORG_FK_KEY
ISC_EDW_BACKLOGS_F_N12 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTASK_FK_KEY
ISC_EDW_BACKLOGS_F_N13 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnDATE_BALANCE_FK_KEY
ISC_EDW_BACKLOGS_F_N14 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnBILL_TO_CUST_FK_KEY
ISC_EDW_BACKLOGS_F_N15 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnCUSTOMER_FK_KEY
ISC_EDW_BACKLOGS_F_N17 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnGL_SET_OF_BOOKS_FK_KEY
ISC_EDW_BACKLOGS_F_N18 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnITEM_ORG_FK_KEY
ISC_EDW_BACKLOGS_F_N19 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTOP_MODEL_ITEM_FK_KEY
ISC_EDW_BACKLOGS_F_N2 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSHIP_TO_CUST_FK_KEY
ISC_EDW_BACKLOGS_F_N20 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSALES_CHANNEL_FK_KEY
ISC_EDW_BACKLOGS_F_N21 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnOPERATING_UNIT_FK_KEY
ISC_EDW_BACKLOGS_F_N22 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORDER_CATEGORY_FK_KEY
ISC_EDW_BACKLOGS_F_N3 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTRX_CURRENCY_FK_KEY
ISC_EDW_BACKLOGS_F_N4 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnDEMAND_CLASS_FK_KEY
ISC_EDW_BACKLOGS_F_N5 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnBILL_TO_LOCATION_FK_KEY
ISC_EDW_BACKLOGS_F_N6 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSHIP_TO_LOCATION_FK_KEY
ISC_EDW_BACKLOGS_F_N7 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnSALES_PERSON_FK_KEY
ISC_EDW_BACKLOGS_F_N8 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnINSTANCE_FK_KEY
ISC_EDW_BACKLOGS_F_N9 BITMAP NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORDER_SOURCE_FK_KEY
Columns
Name Datatype Length Mandatory Comments
BACKLOGS_PK VARCHAR2 (240)
Unique identifier
BACKLOGS_PK_KEY NUMBER

System generated unique identifier
BASE_UOM_FK_KEY NUMBER

System generated foreign key to the UoM dimension
BILL_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOCATION_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Bill-to Location)
DATE_BALANCE_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date of Snapshot)
DEMAND_CLASS_FK_KEY NUMBER

System generated foreign key to the Demand Class dimension
CUSTOMER_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Customer)
GL_SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (GL Set of Book)
INSTANCE_FK_KEY NUMBER

System generated foreign key to the Instance dimension
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_KEY NUMBER

System generated foreign key to the Organization Item dimension
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Operating Unit)
ORDER_CATEGORY_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Source)
ORDER_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Type)
SALES_CHANNEL_FK_KEY NUMBER

System generated foreign key to the Sales Channel dimension
SALES_PERSON_FK_KEY NUMBER

Reserved for future use
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_KEY NUMBER

System generated foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
TASK_FK_KEY NUMBER

System generated foreign key to the Project dimension (Project Task)
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_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
CREATION_DATE DATE

Standard Who column
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_T NUMBER

Delinquent Backlog Gross Margin in Transaction Currency
DLQT_BKLG_MRG_G NUMBER

Delinquent Backlog Gross Margin in Warehouse Currency
DLQT_BKLG_REV_G NUMBER

Delinquent Backlog Revenue in Warehouse Currency
DLQT_BKLG_REV_T NUMBER

Delinquent Backlog Revenue in Transaction Currency
INSTANCE VARCHAR2 (40)
Instance
LAST_UPDATE_DATE DATE

Standard Who column
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
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 Gross Margin in Transaction Currency
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 BACKLOGS_PK
,      BACKLOGS_PK_KEY
,      BASE_UOM_FK_KEY
,      BILL_TO_CUST_FK_KEY
,      BILL_TO_LOCATION_FK_KEY
,      DATE_BALANCE_FK_KEY
,      DEMAND_CLASS_FK_KEY
,      CUSTOMER_FK_KEY
,      GL_SET_OF_BOOKS_FK_KEY
,      INSTANCE_FK_KEY
,      INV_ORG_FK_KEY
,      ITEM_ORG_FK_KEY
,      OPERATING_UNIT_FK_KEY
,      ORDER_CATEGORY_FK_KEY
,      ORDER_SOURCE_FK_KEY
,      ORDER_TYPE_FK_KEY
,      SALES_CHANNEL_FK_KEY
,      SALES_PERSON_FK_KEY
,      SHIP_TO_CUST_FK_KEY
,      SHIP_TO_LOCATION_FK_KEY
,      TASK_FK_KEY
,      TOP_MODEL_ITEM_FK_KEY
,      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
,      CREATION_DATE
,      DLQT_BKLG_COST_G
,      DLQT_BKLG_COST_T
,      DLQT_BKLG_MRG_T
,      DLQT_BKLG_MRG_G
,      DLQT_BKLG_REV_G
,      DLQT_BKLG_REV_T
,      INSTANCE
,      LAST_UPDATE_DATE
,      QTY_BILL_BKLG_B
,      QTY_DLQT_BKLG_B
,      QTY_SHIP_BKLG_B
,      QTY_UNBILL_SHIP_B
,      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_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_F;

Dependencies

[top of page]

ISC.ISC_EDW_BACKLOGS_F does not reference any database object

ISC.ISC_EDW_BACKLOGS_F is referenced by following:

SchemaAPPS
SynonymISC_EDW_BACKLOGS_F