MaterialOperations (IoT Event Definition) DataSet#
Source: IoT Event Definition
Fields#
The MaterialOperations (IoT Event Definition) Data Set has the following fields:
| Field | Description | DataType | Field Type | Order |
|---|---|---|---|---|
| Header_CorrelationId | Header_ | IoTSchema_String | _ | 1 |
| Header_Operation | Header_ | IoTSchema_String | _ | 1 |
| Header_DateTime | Header_ | IoTSchema_DateTime | _ | 1 |
| Header_StartDateTime | Header_ | IoTSchema_DateTime | _ | 1 |
| Header_Application | Header_ | IoTSchema_String | _ | 1 |
| Header_CDMVersion | Header_ | IoTSchema_String | _ | 1 |
| Header_Service | Header_ | IoTSchema_String | _ | 1 |
| Header_DataGroupRefs | Header_ | IoTSchema_String | _ | 1 |
| Header_DataGroups | Header_ | IoTSchema_String | _ | 1 |
| Enterprise_UID | _ | IoTSchema_String | _ | 1 |
| Enterprise_Name | _ | IoTSchema_String | _ | 1 |
| Enterprise_DisplayOrder | _ | IoTSchema_Integer | _ | 1 |
| Site_UID | _ | IoTSchema_String | _ | 1 |
| Site_Name | _ | IoTSchema_String | _ | 1 |
| Site_DisplayOrder | _ | IoTSchema_Integer | _ | 1 |
| Facility_UID | _ | IoTSchema_String | _ | 1 |
| Facility_Name | _ | IoTSchema_String | _ | 1 |
| Facility_DisplayOrder | _ | IoTSchema_Integer | _ | 1 |
| Material_UID | _ | IoTSchema_String | _ | 1 |
| Material_Name | _ | IoTSchema_String | _ | 1 |
| Material_CreatedOn | _ | IoTSchema_DateTime | _ | 1 |
| Material_CreatedBy | _ | IoTSchema_String | _ | 1 |
| Material_ModifiedOn | _ | IoTSchema_DateTime | _ | 1 |
| Material_ModifiedBy | _ | IoTSchema_String | _ | 1 |
| Material_Type | _ | IoTSchema_String | _ | 1 |
| Material_DateEnteredStep | _ | IoTSchema_DateTime | _ | 1 |
| Material_Form | _ | IoTSchema_String | _ | 1 |
| Material_FlowPath | _ | IoTSchema_String | _ | 1 |
| Material_LogicalFlowPath | _ | IoTSchema_String | _ | 1 |
| Material_PrimaryQty | _ | IoTSchema_Decimal | _ | 1 |
| Material_PrimaryUnits | _ | IoTSchema_String | _ | 1 |
| Material_SecondaryQty | _ | IoTSchema_Decimal | _ | 1 |
| Material_SecondaryUnits | _ | IoTSchema_String | _ | 1 |
| Material_SubMaterialsPrimaryQty | _ | IoTSchema_Decimal | _ | 1 |
| Material_SubMaterialsSecondaryQty | _ | IoTSchema_Decimal | _ | 1 |
| Material_SubMaterialCount | _ | IoTSchema_Integer | _ | 1 |
| Material_ProcessingState | _ | IoTSchema_String | _ | 1 |
| Material_ReworkCount | _ | IoTSchema_Integer | _ | 1 |
| Material_HoldCount | _ | IoTSchema_Integer | _ | 1 |
| Material_IdealTimePerUnitInSecs | _ | IoTSchema_Decimal | _ | 1 |
| Material_ReferenceTimePerUnitInSecs | _ | IoTSchema_Decimal | _ | 1 |
| Material_DateEnteredFacility | _ | IoTSchema_DateTime | _ | 1 |
| ParentMaterial_UID | _ | IoTSchema_String | _ | 1 |
| ParentMaterial_Name | _ | IoTSchema_String | _ | 1 |
| ParentMaterial_CreatedOn | _ | IoTSchema_DateTime | _ | 1 |
| ParentMaterial_CreatedBy | _ | IoTSchema_String | _ | 1 |
| ParentMaterial_ModifiedOn | _ | IoTSchema_DateTime | _ | 1 |
| ParentMaterial_ModifiedBy | _ | IoTSchema_String | _ | 1 |
| ParentMaterial_Type | _ | IoTSchema_String | _ | 1 |
| ParentMaterial_DateEnteredStep | _ | IoTSchema_DateTime | _ | 1 |
| ParentMaterial_Form | _ | IoTSchema_String | _ | 1 |
| ParentMaterial_FlowPath | _ | IoTSchema_String | _ | 1 |
| ParentMaterial_LogicalFlowPath | _ | IoTSchema_String | _ | 1 |
| ParentMaterial_PrimaryQty | _ | IoTSchema_Decimal | _ | 1 |
| ParentMaterial_PrimaryUnits | _ | IoTSchema_String | _ | 1 |
| ParentMaterial_SecondaryQty | _ | IoTSchema_Decimal | _ | 1 |
| ParentMaterial_SecondaryUnits | _ | IoTSchema_String | _ | 1 |
| ParentMaterial_SubMaterialsPrimaryQty | _ | IoTSchema_Decimal | _ | 1 |
| ParentMaterial_SubMaterialsSecondaryQty | _ | IoTSchema_Decimal | _ | 1 |
| ParentMaterial_SubMaterialCount | _ | IoTSchema_Integer | _ | 1 |
| ParentMaterial_ProcessingState | _ | IoTSchema_String | _ | 1 |
| ParentMaterial_ReworkCount | _ | IoTSchema_Integer | _ | 1 |
| ParentMaterial_HoldCount | _ | IoTSchema_Integer | _ | 1 |
| Area_UID | _ | IoTSchema_String | _ | 1 |
| Area_Name | _ | IoTSchema_String | _ | 1 |
| Area_DisplayOrder | _ | IoTSchema_Integer | _ | 1 |
| Area_Type | _ | IoTSchema_String | _ | 1 |
| Resource_UID | _ | IoTSchema_String | _ | 1 |
| Resource_Name | _ | IoTSchema_String | _ | 1 |
| Resource_DisplayOrder | _ | IoTSchema_Integer | _ | 1 |
| Resource_ResourceType | _ | IoTSchema_String | _ | 1 |
| Resource_Position | _ | IoTSchema_Integer | _ | 1 |
| Resource_Model | _ | IoTSchema_String | _ | 1 |
| Resource_Service | _ | IoTSchema_String | _ | 1 |
| ParentResource_UID | _ | IoTSchema_String | _ | 1 |
| ParentResource_Name | _ | IoTSchema_String | _ | 1 |
| Flow_UID | _ | IoTSchema_String | _ | 1 |
| Flow_Name | _ | IoTSchema_String | _ | 1 |
| Flow_MajorRevision | _ | IoTSchema_String | _ | 1 |
| Flow_MinorRevision | _ | IoTSchema_String | _ | 1 |
| Flow_Type | _ | IoTSchema_String | _ | 1 |
| Step_UID | _ | IoTSchema_String | _ | 1 |
| Step_Name | _ | IoTSchema_String | _ | 1 |
| Step_DisplayOrder | _ | IoTSchema_Integer | _ | 1 |
| Step_Type | _ | IoTSchema_String | _ | 1 |
| Product_UID | _ | IoTSchema_String | _ | 1 |
| Product_Name | _ | IoTSchema_String | _ | 1 |
| Product_MajorRevision | _ | IoTSchema_String | _ | 1 |
| Product_MinorRevision | _ | IoTSchema_String | _ | 1 |
| Product_Type | _ | IoTSchema_String | _ | 1 |
| Product_Description | _ | IoTSchema_String | _ | 1 |
| ProductGroup_UID | _ | IoTSchema_String | _ | 1 |
| ProductGroup_Name | _ | IoTSchema_String | _ | 1 |
| ProductGroup_MajorRevision | _ | IoTSchema_String | _ | 1 |
| ProductGroup_MinorRevision | _ | IoTSchema_String | _ | 1 |
| ProductGroup_Type | _ | IoTSchema_String | _ | 1 |
| ProductionOrder_UID | _ | IoTSchema_String | _ | 1 |
| ProductionOrder_Name | _ | IoTSchema_String | _ | 1 |
| ProductionOrder_Quantity | _ | IoTSchema_Decimal | _ | 1 |
| ProductionOrder_Units | _ | IoTSchema_String | _ | 1 |
| ProductionOrder_DueDate | _ | IoTSchema_DateTime | _ | 1 |
| ProductionOrder_PlannedStartDate | _ | IoTSchema_DateTime | _ | 1 |
| ProductionOrder_PlannedEndDate | _ | IoTSchema_DateTime | _ | 1 |
| ProductionOrder_OrderNumber | _ | IoTSchema_String | _ | 1 |
| Calendar_Calendar | _ | IoTSchema_String | _ | 1 |
| Calendar_CD | _ | IoTSchema_String | _ | 1 |
| Calendar_Timezone | _ | IoTSchema_String | _ | 1 |
| Calendar_TZToUTCInMin | _ | IoTSchema_Integer | _ | 1 |
| Calendar_FY | _ | IoTSchema_Integer | _ | 1 |
| Calendar_FQ | _ | IoTSchema_Integer | _ | 1 |
| Calendar_FM | _ | IoTSchema_Integer | _ | 1 |
| Calendar_FW | _ | IoTSchema_Integer | _ | 1 |
| Calendar_Shift_ShiftDefinitionName | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Calendar_Shift_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Calendar_Shift_StartTime | __ | IoTSchema_IoTSchema_DateTime | __ | 1 |
| Calendar_Shift_EndTime | __ | IoTSchema_IoTSchema_DateTime | __ | 1 |
| DataCollection_UID | _ | IoTSchema_String | _ | 1 |
| DataCollection_Name | _ | IoTSchema_String | _ | 1 |
| DataCollection_MajorRevision | _ | IoTSchema_String | _ | 1 |
| DataCollection_MinorRevision | _ | IoTSchema_String | _ | 1 |
| BillOfMaterials_UID | _ | IoTSchema_String | _ | 1 |
| BillOfMaterials_Name | _ | IoTSchema_String | _ | 1 |
| BillOfMaterials_MajorRevision | _ | IoTSchema_String | _ | 1 |
| BillOfMaterials_MinorRevision | _ | IoTSchema_String | _ | 1 |
| BillOfTools_UID | _ | IoTSchema_String | _ | 1 |
| BillOfTools_Name | _ | IoTSchema_String | _ | 1 |
| BillOfTools_MajorRevision | _ | IoTSchema_String | _ | 1 |
| BillOfTools_MinorRevision | _ | IoTSchema_String | _ | 1 |
| Recipe_UID | _ | IoTSchema_String | _ | 1 |
| Recipe_Name | _ | IoTSchema_String | _ | 1 |
| Recipe_MajorRevision | _ | IoTSchema_String | _ | 1 |
| Recipe_MinorRevision | _ | IoTSchema_String | _ | 1 |
| Employee_UID | _ | IoTSchema_String | _ | 1 |
| Employee_Name | _ | IoTSchema_String | _ | 1 |
| Employee_Number | _ | IoTSchema_String | _ | 1 |
| Employee_Team | _ | IoTSchema_String | _ | 1 |
| Attributes_Names | _ | IoTSchema_String | _ | 1 |
| Attributes_Values | _ | IoTSchema_String | _ | 1 |
| Comments | String | 1 | ||
| Comments | String | 1 | ||
| Previous_Step_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Step_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Material_DateEnteredFacility | __ | IoTSchema_IoTSchema_DateTime | __ | 1 |
| Previous_Material_DateEnteredStep | __ | IoTSchema_IoTSchema_DateTime | __ | 1 |
| Previous_Material_PrimaryQty | __ | IoTSchema_IoTSchema_Decimal | __ | 1 |
| Previous_Material_PrimaryUnits | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Material_SecondaryQty | __ | IoTSchema_IoTSchema_Decimal | __ | 1 |
| Previous_Material_SecondaryUnits | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Material_SubMaterialsPrimaryQty | __ | IoTSchema_IoTSchema_Decimal | __ | 1 |
| Previous_Material_SubMaterialsSecondaryQty | __ | IoTSchema_IoTSchema_Decimal | __ | 1 |
| Previous_Material_SubMaterialCount | __ | IoTSchema_IoTSchema_Integer | __ | 1 |
| Previous_Material_FlowPath | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Material_Form | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Material_ReworkCount | __ | IoTSchema_IoTSchema_Integer | __ | 1 |
| Previous_Material_HoldCount | __ | IoTSchema_IoTSchema_Integer | __ | 1 |
| Previous_Product_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Product_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Product_MajorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Product_MinorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Product_Type | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Flow_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Flow_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Flow_MajorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Flow_MinorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Flow_Type | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Area_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Previous_Area_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Tools_UID | _ | IoTSchema_String | _ | 1 |
| Tools_Name | _ | IoTSchema_String | _ | 1 |
| Tools_Type | _ | IoTSchema_String | _ | 1 |
| Tools_Position | _ | IoTSchema_Integer | _ | 1 |
Table: MaterialOperations (IoT Event Definition) fields