Model: Production Performance - Specifications for Dimension Table: SHOP ORDER MATERIAL
Attributes
| Attribute |
Description (where applicable) |
| SO Material Order No |
Built as ORDER_NO + ' - ' + RELEASE_NO + ' - ' + SEQUENCE_NO + ' - ' +
LINE_ITEM_NO (MATERIAL_ORD_REL_SEQ_LINE). |
| SO Material Owner |
Customer number owning the material. |
| SO Material Part Ownership |
Ownership of material. Typically Company Owned, Customer owned. |
| 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. |
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 MATERIAL |
FACT_SHOP_ORDER_MATERIAL_TM |
FACT_SHOP_ORDER_MATERIAL_BI |
FACT_SHOP_ORDER_MATERIAL |
Data Mart |