Model: Production Performance - Specifications for Dimension Table: SHOP ORDER
Attributes
| Attribute |
Description (where applicable) |
| SO Cust Order No |
Corresponding customer order number for Shop Order. |
| SO Demand Code |
Demand Code Description, type of demand. |
| SO Material State |
Status of material on shop order. Typically Completely Issued, Not Reserved etc. |
| SO Multilevel Repair |
Is the shop order repair a part of the as built stricture ? True/False. |
| SO Operation State |
Status of Operation on shop order. Typically Reported, Not Reported. |
| SO Order Code |
Describing type of Shop order. Assembly, Repair, Manufacturing etc. |
| SO Order No |
Shop order number. |
| SO Product State |
Status of products on Shop Order. Received, Not Received etc. |
| SO State |
Status of shop order. Planned, Finished Closed etc. |
| SO Used Struc BOM Type |
Bill of Material Structure type used to build the shop order. |
| Shop Order |
Built up as OrderNo - ReleaseNo - SeqNo. |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data source contains a number of
transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View
Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| SHOP ORDER |
FACT_SHOP_ORDER_TM |
FACT_SHOP_ORDER_BI |
FACT_SHOP_ORDER |
Data Mart |