[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
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 |
Name | Datatype | Length | Mandatory | 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 |
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;
ISC.ISC_EDW_BACKLOGS_FSTG does not reference any database object
ISC.ISC_EDW_BACKLOGS_FSTG is referenced by following:
|
|
|