Skip to content

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

Table: MaterialOperations (IoT Event Definition) fields