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