MaterialGenealogy (IoT Event Definition) DataSet#
Source: IoT Event Definition
Fields#
The MaterialGenealogy (IoT Event Definition) Data Set has the following fields:
| Field | Description | DataType | Field Type | Order |
|---|---|---|---|---|
| Header_CorrelationId | _ | IoTSchema_String | _ | 1 |
| Header_Operation | _ | IoTSchema_String | _ | 1 |
| Header_DateTime | _ | IoTSchema_DateTime | _ | 1 |
| Header_StartDateTime | _ | IoTSchema_DateTime | _ | 1 |
| Header_Application | _ | IoTSchema_String | _ | 1 |
| Header_CDMVersion | _ | IoTSchema_String | _ | 1 |
| Header_Service | _ | IoTSchema_String | _ | 1 |
| Header_DataGroupRefs | _ | IoTSchema_String | _ | 1 |
| Header_DataGroups | _ | 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 |
| SourceMaterials_UID | _ | IoTSchema_String | _ | 1 |
| SourceMaterials_Name | _ | IoTSchema_String | _ | 1 |
| SourceMaterials_UniversalState | _ | IoTSchema_String | _ | 1 |
| SourceMaterials_DateEnteredStep | _ | IoTSchema_DateTime | _ | 1 |
| SourceMaterials_Location | _ | IoTSchema_String | _ | 1 |
| SourceMaterials_PrimaryQuantityBefore | _ | IoTSchema_Decimal | _ | 1 |
| SourceMaterials_PrimaryQuantityAfter | _ | IoTSchema_Decimal | _ | 1 |
| SourceMaterials_PrimaryUnits | _ | IoTSchema_String | _ | 1 |
| SourceMaterials_AssembledPrimaryQuantity | _ | IoTSchema_Decimal | _ | 1 |
| SourceMaterials_SecondaryQuantityBefore | _ | IoTSchema_Decimal | _ | 1 |
| SourceMaterials_SecondaryQuantityAfter | _ | IoTSchema_Decimal | _ | 1 |
| SourceMaterials_SecondaryUnits | _ | IoTSchema_String | _ | 1 |
| SourceMaterials_AssembledSecondaryQuantity | _ | IoTSchema_Decimal | _ | 1 |
| SourceMaterials_SubMaterialsPrimaryQuantityBefore | _ | IoTSchema_Decimal | _ | 1 |
| SourceMaterials_SubMaterialsPrimaryQuantityAfter | _ | IoTSchema_Decimal | _ | 1 |
| SourceMaterials_SubMaterialsPrimaryUnits | _ | IoTSchema_String | _ | 1 |
| SourceMaterials_SubMaterialsSecondaryQuantityBefore | _ | IoTSchema_Decimal | _ | 1 |
| SourceMaterials_SubMaterialsSecondaryQuantityAfter | _ | IoTSchema_Decimal | _ | 1 |
| SourceMaterials_SubMaterialsSecondaryUnits | _ | IoTSchema_String | _ | 1 |
| SourceMaterials_FlowPath | _ | IoTSchema_String | _ | 1 |
| SourceMaterials_Flow_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Flow_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Flow_MajorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Flow_MinorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Step_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Step_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Resource_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Resource_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Resource_DisplayOrder | __ | IoTSchema_IoTSchema_Integer | __ | 1 |
| SourceMaterials_Area_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Area_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Area_DisplayOrder | __ | IoTSchema_IoTSchema_Integer | __ | 1 |
| SourceMaterials_ParentResource_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_ParentResource_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_ParentResource_DisplayOrder | __ | IoTSchema_IoTSchema_Integer | __ | 1 |
| SourceMaterials_ParentMaterial_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_ParentMaterial_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_ProductionOrder_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_ProductionOrder_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Product_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Product_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Product_MajorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Product_MinorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Product_Type | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_Product_Description | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_ProductGroup_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_ProductGroup_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_ProductGroup_MajorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_ProductGroup_MinorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| SourceMaterials_ProductGroup_Type | __ | IoTSchema_IoTSchema_String | __ | 1 |
| Operation | String | 1 | ||
| Operation | String | 1 | ||
| IdentifierMaterial | String | 1 | ||
| IdentifierMaterial | String | 1 | ||
| OperationDate | DateTime | 1 | ||
| OperationDate | DateTime | 1 | ||
| OperationId | String | 1 | ||
| OperationId | String | 1 | ||
| OperationComment | String | 1 | ||
| OperationComment | String | 1 | ||
| BillOfMaterials_UID | _ | IoTSchema_String | _ | 1 |
| BillOfMaterials_Name | _ | IoTSchema_String | _ | 1 |
| BillOfMaterials_MajorRevision | _ | IoTSchema_String | _ | 1 |
| BillOfMaterials_MinorRevision | _ | IoTSchema_String | _ | 1 |
| TargetMaterials_UID | _ | IoTSchema_String | _ | 1 |
| TargetMaterials_Name | _ | IoTSchema_String | _ | 1 |
| TargetMaterials_UniversalState | _ | IoTSchema_String | _ | 1 |
| TargetMaterials_DateEnteredStep | _ | IoTSchema_DateTime | _ | 1 |
| TargetMaterials_Location | _ | IoTSchema_String | _ | 1 |
| TargetMaterials_PrimaryQuantityBefore | _ | IoTSchema_Decimal | _ | 1 |
| TargetMaterials_PrimaryQuantityAfter | _ | IoTSchema_Decimal | _ | 1 |
| TargetMaterials_PrimaryUnits | _ | IoTSchema_String | _ | 1 |
| TargetMaterials_AssembledPrimaryQuantity | _ | IoTSchema_Decimal | _ | 1 |
| TargetMaterials_SecondaryQuantityBefore | _ | IoTSchema_Decimal | _ | 1 |
| TargetMaterials_SecondaryQuantityAfter | _ | IoTSchema_Decimal | _ | 1 |
| TargetMaterials_SecondaryUnits | _ | IoTSchema_String | _ | 1 |
| TargetMaterials_AssembledSecondaryQuantity | _ | IoTSchema_Decimal | _ | 1 |
| TargetMaterials_SubMaterialsPrimaryQuantityBefore | _ | IoTSchema_Decimal | _ | 1 |
| TargetMaterials_SubMaterialsPrimaryQuantityAfter | _ | IoTSchema_Decimal | _ | 1 |
| TargetMaterials_SubMaterialsPrimaryUnits | _ | IoTSchema_String | _ | 1 |
| TargetMaterials_SubMaterialsSecondaryQuantityBefore | _ | IoTSchema_Decimal | _ | 1 |
| TargetMaterials_SubMaterialsSecondaryQuantityAfter | _ | IoTSchema_Decimal | _ | 1 |
| TargetMaterials_SubMaterialsSecondaryUnits | _ | IoTSchema_String | _ | 1 |
| TargetMaterials_FlowPath | _ | IoTSchema_String | _ | 1 |
| TargetMaterials_Flow_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Flow_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Flow_MajorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Flow_MinorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Step_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Step_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Resource_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Resource_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Resource_DisplayOrder | __ | IoTSchema_IoTSchema_Integer | __ | 1 |
| TargetMaterials_Area_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Area_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Area_DisplayOrder | __ | IoTSchema_IoTSchema_Integer | __ | 1 |
| TargetMaterials_ParentResource_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_ParentResource_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_ParentResource_DisplayOrder | __ | IoTSchema_IoTSchema_Integer | __ | 1 |
| TargetMaterials_ParentMaterial_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_ParentMaterial_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_ProductionOrder_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_ProductionOrder_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Product_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Product_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Product_MajorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Product_MinorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Product_Type | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_Product_Description | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_ProductGroup_UID | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_ProductGroup_Name | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_ProductGroup_MajorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_ProductGroup_MinorRevision | __ | IoTSchema_IoTSchema_String | __ | 1 |
| TargetMaterials_ProductGroup_Type | __ | IoTSchema_IoTSchema_String | __ | 1 |
Table: MaterialGenealogy (IoT Event Definition) fields