Material Requirement Mappings

* = Required

Name	Description	Type	Values
AllocationRule		Int64
AllowedLotCode	Can specify which material lots are allowed to supply the material requirement.	String
AllowPartialSupply	If true, MRP will consider any supply that is able to satisfy the demand in full.	Boolean
Available	True if the issue of materials is complete or if any unissued quantity has been allocated by on-hand inventory. This requires that the Operation is scheduled.	Boolean
AvailableDateTime	The date and time when the material is expected to be available for use in production. The usage of this depends on the setting for Constraint Type. This is calculated automatically during reschedules for Material Requirements for stocked Items. This can be set externally for buy-direct materials.	DateTime
ConstraintType	Indicates whether the Material Requirment should prevent its Operation from starting before the material arrives. NonConstraint: Doesn’t have any affect on its Operation. ConstrainedByEarlierOfLeadTimeOrAvailableDate: In the case where there is no Item associated with the MaterialRequirement: The Operation can’t start until the earlier of the Material’s AvailableDate and Clock+LeadTimeSpan. In the case where there is an Item associated with the MaterialRequirement. The AvailableDate is determined by Inventory levels not the AvailableDate field within this class. So it’s the earlier of what can be supplied through inventory or the lead-time. ConstrainedByAvailableDate: In the case where there is no Item associated with the MaterialRequirement: Operation can’t start until the AvailableDate defined within this MaterialRequirement. In the case where there is an Item associated with the MaterialRequirement: Wait on Inventory. If no material becomes available before PurchaseToStocks and Tasks run out then use the LeadTime.	String	NonConstraint ConstrainedByEarlierOfLeadTimeOrAvailableDate ConstrainedByAvailableDate
ExternalId*	The external identifier for the material requirement.	String
FixedQty	If true, specifies that the required quantity is a fixed number.	Boolean
IssuedQty	Quantity of material that has been issued to the operation by physically removing the material from storage and delivering it to the floor for production.	Double
ItemExternalId	The external identification of the item to be used as a material for the operation.	String
JobExternalId*	The external identifier for the job associated with this material requirement.	String
LeadTimeHrs	Minimum number of hours needed to procure the material. If the Constraint Type is ConstrainedByEarlierOfLeadTimeOrAvailableDate then the minimum of Available Date and Now + Lead Time is used as the constraint date. If the Constraint Type is ConstrainedByAvailableDate then the Available Date is used instead and Lead Time is only used if at the end of the scheduling process there is no supply.	Double
MaterialDescription	Description of the required material. This is the description of the item for stocked Items. For buy-direct Material Requirements this can be set externally.	String
MaterialName	Name of the required material. This is the Name of the item for stocked Items. For buy-direct Material Requirements this can be set externally.	String
MaxEligibleWearAmount	This specified the maximum number of times that a material can be used.	Int32
MinRemainingShelfLifeHrs	The minimum number of hours that are remaining for the material's shelf life for it to be used as a material. If the remaining shelf0life hours are less than this amount, the material cannot be used as it is considered expired.	Double
MoExternalId*	The external identifier for the manufacturing order associated with this material requirement.	String
MultipleWarehouseSupplyAllowed	If true, the materials required for the operation can be supplied by multiple warehouses. If false, all required materials must be supplied from the same warehouse.	Boolean
OpExternalId*	The external identifier for the operation associated with this material requirement.	String
PlannedScrapQty	This is used to specify the number of scrap items that are expected to be produced.	Decimal
ProdutRelease		String
RequirementType	Whether the material is being directly purchased for this requirement. In this case the material has no effect on Inventory and Inventory has no effect on when this MR is satisfied.	String	BuyDirect FromStock
Source	Used to describe where this material is coming from. (‘Purchase Order XYZ’ or ‘from stock’, etc.) For stocked items, this is set automatically. For buy-direct materials, this can be set externally.	String
TankStorageReleaseTiming	If the material is drawn from a Tank Resource, these values can be used to indicate the timing of when the Tank is empty NotTank – Not expected to be drawn from a tank. AtActivityStart – Release the tank when the activity consuming the material starts. AtEndOfActivitySetup – Release the tank when the activity consuming the material has finished being setup. AtEndOfProcessing – Release the tank when the activity consuming the material has finished processing. AtEndOfPostProcessing – Release the tank when the activity consuming the material in the tanks has finished its post-processing.	String	NotTank AtActivityStart AtEndOfActivitySetup AtEndOfProcessing AtEndofPostProcessing
TotalCost	Used in KPIs and simulation rules to calculate WIP cost.	Decimal
TotalRequiredQty	The quantity of material to be consumed by the Operation for this requirement. The full quantity is required at the beginning of each activity for it to be able to schedule to start. (If constraining by materials.)	Double
UOM	The measuring unit in which the quantity fields are specified. For information only.	String
UsabilityRequirement		Int32
UseOverlapActivities	Whether to allow this Material Requirement to depend on material from other manufacturing orders that haven’t completed yet but whose material is projected to arrive in stock in time to satisfy the cycles of the operation. This may allow the operation and other operations to start earlier. If this is not checked then this Material Requirement may end up waiting until the expected completion of manufacturing orders whose material is needed.	Boolean
UseOverlapPurchases	Whether to allow this Material Requirement to depend on material from purchase orders that haven’t arrived yet but whose material is projected to arrive in stock in time to satisfy the cycles of the operation. This may allow the operation and other operations to start earlier. If this is not checked then this Material Requirement may end up waiting until the expected receive date of purchase order whose material is needed.	Boolean
WarehouseExternalId	The Warehouse from which this material must be supplied. If omitted, then the Material Requirement can be satisfied from any Warehouse accessible by the Plant of the Primary Resource performing the work.	String