---
title: MaterialLossBonus
alias: dataplatform-dataset-materiallossbonus
docsync: true
description: "This dataset contains fields related to material loss adjustments"
---

# 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