On this page you will find the specifications regarding the Model: Production Performance and Dimension Table: SHOP ORDER MATERIAL.
This model fact represents shop order material information and is based on the view FACT_SHOP_ORDER_MATERIAL_BI.
Note: Please refer to documentation of each model to find out about attributes used in referenced models.
| Attribute | Description (where applicable) |
| SO Material Status | Material line status for a record in the fact (STATE). |
| SO Material Supply Code | How is the material supplied? Invent Order, Project delivery etc. |
| SO Material Part Ownership | Ownership of material. Typically Company Owned, Customer owned. |
| SO Material Owner | Customer number owning the material. |
| SO Material Order No | Built as ORDER_NO + ' - ' + RELEASE_NO + ' - ' + SEQUENCE_NO + ' - ' + LINE_ITEM_NO (MATERIAL_ORD_REL_SEQ_LINE). |
| Model Name |
| Production Performance |
The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.
Additional information can be found in the online documentation of Information Sources.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| SHOP ORDER MATERIAL | FACT_SHOP_ORDER_MATERIAL_BI | FACT_SHOP_ORDER_MATERIAL | On Line |