Represents a cube specific dimension based on the fact FACT_SHOP_ORDER. The dimension is based on a fact and there is no corresponding dimension in core.
Attribute | Hierarchy | Description |
Shop Order | NO | Key. Built up as OrderNo - ReleaseNo - SeqNo. |
SO - Last Loaded | NO | ETL process date. |
SO Cust Order No | NO | Corresponding customer order number for Shop Order. |
SO Demand Code | NO | Demand Code Description, type of demand. |
SO Material State | NO | Status of material on shop order. Typically Completely Issued, Not Reserved etc. |
SO Multilevel Repair | NO | Is the shop order repair a part of the as built stricture ? True/False. |
SO Operation State | NO | Status of Operation on shop order. Typically Reported, Not Reported. |
SO Order Code | NO | Describing type of Shop order. Assembly, Repair, Manufacturing etc. |
SO Order No | NO | Shop order number. |
SO Product State | NO | Status of products on Shop Order. Received, Not Received etc. |
SO State | NO | Status of shop order. Planned, Finished Closed etc. |
SO Used Struc BOM Type | NO | Bill of Material Structure type used to build the shop order. |
Cube Name |
MANUFACTURING |
BI Access View | BI Component | Recommended Source Type |
FACT_SHOP_ORDER_BI | SHPOFT | On Line |
ETL Step | File Name of SSIS Package | Table Name |
E - Stage | 1.2.025 Load IFSAppl_FACT_SHOP_ORDER_BI.dtsx | IFSAppl_FACT_SHOP_ORDER_BI |
T - DW | 2.2.025 Load Dw_FACT_SHOP_ORDER.dtsx | Dw_FACT_SHOP_ORDER |
L - DM | 3.2.025 Load Dm_FACT_SHOP_ORDER.dtsx | Dm_FACT_SHOP_ORDER |
Please refer to FACT_SHOP_ORDER