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