Materials Import
Here you will find definitions for all mapping options in Phenix’s Materials Import. Here you will find all imports related to creating the master data for the materials, the products to be produced.
For more information on materials in Phenix, see Maintain Materials.
Definitions
Material Identifier: The code by which the material is referred.
Description: The plain words description of the material.
Default Line Identifier: The default line the material is produced on. Can also be specified in Material Line Data Import.
Material Type: The category of item the material is, i.e. a “Frozen” item, or a “Paper” item. Defines what attributes a material has. Material Types and Attributes are created in Materials, under Setup in Phenix’s left-hand menu.
Order Amount Minimum Value: The minimum amount of the material produced when run.
Order Amount Minimum Unit: The unit of the minimum amount of the material produced when run.
Order Amount Increment Value: The lot size of the material.
Order Amount Increment Unit: The lot size unit of the material.
Dependent Requirements: Advanced. Affects behavior when this material is used in the BOM of another material. Typically not needed.
Max Inventory Value: The maximum amount of the material that can be stored at one time.
Max Inventory Unit: The unit of the maximum amount of the material that can be stored at one time.
Safety Inventory Value: The value of the amount of inventory of the material that should be kept on hand at all times.
Safety Inventory Unit: The unit of the amount of inventory that should be kept on hand at all times.
Inventory Carrying Cost Percent Annually (100 = 100%): The cost of holding and storing the material, as a percentage of the total inventory annually. Use this option if the Carrying Cost in the import file is given as an integer, where 100 means 100%.
Inventory Carrying Cost Percent Annually (1 = 100%): The cost of holding and storing the material, as a percentage of the total inventory annually. Use this option if the Carrying Cost in the import file is given as a number with a decimal, where 1 means 100%.
Forecast Value: Average forecast over the forecast period.
Forecast Unit: The unit of the forecasted material (cases, pallets, etc.)
Forecast Period: The time period of the forecast (week, month, etc.)
Forecast CV Percent (100 = 100%): The coefficient of variability (CV) of the forecast. The CV is the standard deviation divided by the mean. Use this option if the Forecast CV in the import file is given as an integer, where 100 means 100%.
Forecast CV Percent (1 = 100%): The coefficient of variability (CV) of the forecast. The CV is the standard deviation divided by the mean. Use this option if the Forecast CV in the import file is given as a number with a decimal, where 1 means 100%.
Forecast CV Period: The time period of the forecast CV. Generally the same as the forecast period.
COGS Value: The cost of goods sold (COGS). The direct cost of producing the material. Also sometimes known as “cost of sales”.
COGS Unit: The Unit of the cost of good sold.
Customer Order Lead Time: Time between when a customer places an order to when they receive the material, in days.
Planning Lead Time: The time between when an order of the material is received to when it’s scheduled to be manufactured, in days.
Plant Shelf Life: The amount of time an item can be held at the production plant before it can no longer be sold.
Target Fill Rate Percent (100 = 100%): The target percentage of orders of the material that are fulfilled completely and on time. Use this option if the Target Fill Rate in the import file is given as an integer, where 100 means 100%.
Target Fill Rate Percent (1 = 100%): The target percentage of orders of the material that are fulfilled completely and on time. Use this option if the Target Fill Rate in the import file is given as a number with a decimal, where 1 means 100%.
Goods Receipt Processing Time: The time between the production of the material and it’s availability in stock.
Manufacturing Variation Percent: The percent difference between the intended amount of the material to be produced, and the actual amount produced. Given as an integer between 0 and 100.
Component Item 1 Material Id: Depreciated. Former method of how Phenix handled BOM items. BOM items are now imported used the “Consumption Rules: BOM Items” import option under “Master Data” on the Import page.