CostResolutions DataSet#
Source: ODS
Fields#
The CostResolutions Data Set has the following fields:
| Field | Description | DataType | Field Type |
|---|---|---|---|
| Step_Index | Integer | Metric | |
| Step_Name | String | Dimension | |
| Product_Name | String | Dimension | |
| Product_MajorRevision | String | Dimension | |
| Material_Name | String | Dimension | |
| Product_InitialUnitCost | Standard Initial Product unit cost. | Decimal | Metric |
| Product_FinishedUnitCost | Standard Finished Product unit cost. | Decimal | Metric |
| Step_CostPerUnit | Standard cost per unit for the step. | Decimal | Metric |
| Step_CostPerHour | Standard cost per hour for the step. | Decimal | Metric |
| Step_FixedCost | Standard fixed cost for the step. | Decimal | Metric |
| Step_LaborCostPerHour | Standard labor cost per hour for the step. | Decimal | Metric |
| Step_ResourceCostPerHour | Standard resource cost per hour for the step. | Decimal | Metric |
| Step_ResourceCostPerUnit | Standard resource cost per unit for the step. | Decimal | Metric |
| Step_ResourceFixedCost | Standard resource fixed cost for the step. | Decimal | Metric |
| Step_PrimaryUnits | String | Dimension | |
| Step_Yield | Yield of this step. Defaults to 1 if not defined. | Decimal | Metric |
| Product_Yield | Cumulative yield of all steps up to and including this one. | Decimal | Metric |
| CurrencySymbol | String | Dimension | |
| InQuantity | Decimal | Metric | |
| OutQuantity | Output quantity produced by this step (InQuantity * Step_Yield). | Decimal | Metric |
| Step_TotalCycleTime | Total time to process all units in the step (in hours). | Decimal | Metric |
| Material_Cost | Decimal | Metric | |
| BOM_Name | String | Dimension | |
| BOM_BaseQuantity | Decimal | Metric | |
| BOMItem_Quantity | Decimal | Metric | |
| BOMItem_Units | String | Dimension | |
| BOMItem_ProductName | String | Dimension | |
| BOMItem_ProductMajorRevision | String | Dimension | |
| BOMItem_Product_FinishedUnitCost | Finished unit cost of the BOM item. | Decimal | Metric |
| BOMItem_TotalQuantity | Total quantity of this BOM item consumed in the step, based on input quantity. | Decimal | Metric |
| BOMItem_TotalCost | Total cost of BOM items used in the step. | Decimal | Metric |
| Step_TotalCosts | Total processing costs for the step. | Decimal | Metric |
| Resource_TotalCosts | Total resource costs for the step. | Decimal | Metric |
| Labor_TotalCosts | Total labor costs for the step. | Decimal | Metric |
| BOM_TotalCosts | Total costs of all BOM items used in this step. | Decimal | Metric |
| Step_Cost | Sum of step, resource, labor, and BOM costs. | Decimal | Metric |
| Material_TotalCost | Total material cost at this step. | Decimal | Metric |
| Product_Cost | Cumulative total product cost at this step, including initial unit cost and all step costs so far. | Decimal | Metric |
Table: CostResolutions fields