MaterialLossBonus DataSet#
Source: DWH
Fields#
The MaterialLossBonus Data Set has the following fields:
| Field | Description | DataType | Field Type |
|---|---|---|---|
| Header_CorrelationId | String | Dimension | |
| Header_DateTime | DateTime | Timestamp | |
| Header_Service | String | Dimension | |
| Header_Operation | String | Dimension | |
| Header_StartDateTime | DateTime | Timestamp | |
| Header_CDMVersion | String | Dimension | |
| SysProperties_EventId | String | Dimension | |
| SysProperties_EnqueueTime | DateTime | Timestamp | |
| Calendar_Name | String | Dimension | |
| Calendar_Timezone | String | Dimension | |
| Calendar_TZToUTCInMin | Integer | Metric | |
| Calendar_FY | Integer | Metric | |
| Calendar_FQ | Integer | Metric | |
| Calendar_FM | Integer | Metric | |
| Calendar_FW | Integer | Metric | |
| Calendar_CD | DateTime | Timestamp | |
| Calendar_Shift | String | Dimension | |
| Calendar_ShiftName | String | Dimension | |
| Calendar_ShiftStart | DateTime | Timestamp | |
| Calendar_ShiftEnd | DateTime | Timestamp | |
| Material_Name | String | Dimension | |
| Material_Type | String | Dimension | |
| Material_Form | String | Dimension | |
| Material_PrimaryUnits | String | Dimension | |
| Material_PrimaryQty | Decimal | Metric | |
| Material_SecondaryUnits | String | Dimension | |
| Material_SecondaryQty | Decimal | Metric | |
| Material_DateEnteredStep | DateTime | Timestamp | |
| Material_CreatedOn | DateTime | Timestamp | |
| Material_CreatedBy | String | Dimension | |
| Material_SubMaterialsPrimaryQty | Decimal | Metric | |
| Material_SubMaterialsSecondaryQty | Decimal | Metric | |
| Material_SubMaterialCount | Integer | Metric | |
| Material_ProcessingState | String | Dimension | |
| Material_ReworkCount | Integer | Metric | |
| Material_HoldCount | Integer | Metric | |
| Material_ModifiedBy | String | Dimension | |
| Comments | String | Dimension | |
| Enterprise_Name | String | Dimension | |
| Enterprise_DisplayOrder | Integer | Metric | |
| Site_Name | String | Dimension | |
| Site_DisplayOrder | Integer | Metric | |
| Facility_Name | String | Dimension | |
| Facility_DisplayOrder | Integer | Metric | |
| Area_Name | String | Dimension | |
| Area_DisplayOrder | Integer | Metric | |
| Step_Name | String | Dimension | |
| Step_Type | String | Dimension | |
| Resource_Name | String | Dimension | |
| Product_Name | String | Dimension | |
| Product_MajorRevision | String | Dimension | |
| Product_MinorRevision | String | Dimension | |
| Product_Type | String | Dimension | |
| ProductGroup_Name | String | Dimension | |
| ProductGroup_MajorRevision | String | Dimension | |
| ProductGroup_MinorRevision | String | Dimension | |
| Flow_Name | String | Dimension | |
| Flow_MajorRevision | String | Dimension | |
| Flow_MinorRevision | String | Dimension | |
| Change_Type | String | Dimension | |
| Change_StepName | String | Dimension | |
| Change_StepType | String | Dimension | |
| Change_PrimaryQty | Decimal | Metric | |
| Change_PrimaryUnits | String | Dimension | |
| Change_SecondaryQty | Decimal | Metric | |
| Change_SecondaryUnits | String | Dimension | |
| MaterialHierarchy_Material_Name | StringArray | None | |
| Change_Reason | String | Dimension | |
| _created_at | DateTime | Timestamp | |
| run_id | String | Dimension | |
| AppProperties_DataSilo | String | Dimension |
Table: MaterialLossBonus fields