[Home] [Help]
View: ISC_EDW_BACKLOGS_F_FCV
Product: | ISC - Supply Chain Intelligence (Obsolete) |
Description: | This is the collection view for the Backlog Snapshot fact table |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT BACKLOGS_PK
, BASE_UOM_FK
, BILL_TO_CUST_FK
, BILL_TO_LOCATION_FK
, CUSTOMER_FK
, DATE_BALANCE_FK
, DEMAND_CLASS_FK
, GL_BOOK_FK
, INSTANCE_FK
, INV_ORG_FK
, ITEM_ORG_FK
, OPERATING_UNIT_FK
, ORDER_CATEGORY_FK
, ORDER_SOURCE_FK
, ORDER_TYPE_FK
, SALES_CHANNEL_FK
, SALES_PERSON_FK
, SHIP_TO_CUST_FK
, SHIP_TO_LOCATION_FK
, TASK_FK
, TOP_MODEL_ITEM_FK
, TRX_CURRENCY_FK
, 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
, 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
, INSTANCE
, LAST_UPDATE_DATE
, SEQ_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, 'NA_EDW'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM ISCBV_BACKLOGS_FCV
Columns
Name |
BACKLOGS_PK |
BASE_UOM_FK |
BILL_TO_CUST_FK |
BILL_TO_LOCATION_FK |
CUSTOMER_FK |
DATE_BALANCE_FK |
DEMAND_CLASS_FK |
GL_BOOK_FK |
INSTANCE_FK |
INV_ORG_FK |
ITEM_ORG_FK |
OPERATING_UNIT_FK |
ORDER_CATEGORY_FK |
ORDER_SOURCE_FK |
ORDER_TYPE_FK |
SALES_CHANNEL_FK |
SALES_PERSON_FK |
SHIP_TO_CUST_FK |
SHIP_TO_LOCATION_FK |
TASK_FK |
TOP_MODEL_ITEM_FK |
TRX_CURRENCY_FK |
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 |
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 |
INSTANCE |
LAST_UPDATE_DATE |
SEQ_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_FK2 |
USER_FK3 |
USER_FK4 |
USER_FK5 |
USER_MEASURE1 |
USER_MEASURE2 |
USER_MEASURE3 |
USER_MEASURE4 |
USER_MEASURE5 |