Microsoft Dynamics AX Mappings

Plant Mappings

A plant represents a physical production facility and can be optimized independently if there are no inter-plant constraints.

* = Required

Property Description Type Select From Field AX Element
ExternalId* Unique identifier. String APS_Plants PlantID dbo.InventSite.SITEID
Name* Display text that identifies the Plant. String APS_Plants PlantName dbo.InventSite.NAME

Department Mappings

A department contains a set of resources that can be viewed together

* = Required

Property Description Type Select From Field AX Element
ExternalId* Unique identifier. String APS_Departments DeptID dbo.WrkCtrTableGroupView.WRKCTRID
Name* Display text that identifies the Department. String APS_Departments DeptName dbo.WrkCtrTableGroupView.WRKCTRID
PlantExternalId* Unique identifier for specific Plant. String APS_Departments PlantID dbo.WrkCtrTableGroupView.SITEID
Description Text for describing the object. String APS_Departments DeptDesc dbo.WrkCtrTableGroupView.NAME

Resource Mappings

Resource are the entities required to perform work in the factory.  They may represent people, machines, workstations, tools, or some other equipment that is needed to perform work.

* = Required

Property Description Type Select From Field AX Element
PlantExternalId* Unique identifier for the Plant. String APS_Resources PlantID  dbo.WrkCtrResourceAndGroupView.SITEID
DepartmentExternalId* Unique identifier for the Department. String APS_Resources DeptID  dbo.WrkCtrResourceAndGroupView.WRKCTRIDGROUP
ExternalId* Unique identifier. String APS_Resources ResourceID  dbo.WrkCtrResourceAndGroupView.WRKCTRID
Name* Display text that identifies the Resource. String APS_Resources ResourceName  dbo.WrkCtrResourceAndGroupView.WRKCTRID
Description Text for describing the object. String APS_Resources ResourceDesc  dbo.WrkCtrResourceAndGroupView.NAME

Capability Mappings

Capabilities indicate the types of work that can be performed by each of your resources.  They may correspond to your ERP system’s operation types.

* = Required

Property Description Type Select From Field AX Element
PlantExternalId* Unique identifier for the Plant. String APS_Resources PlantID  dbo.WrkCtrResourceAndGroupView.SITEID
DepartmentExternalId* Unique identifier for the Department. String APS_Resources DeptID  
ExternalId* Unique identifier. String APS_Resources ResourceID  
Name* Display text that identifies the Resource. String APS_Resources ResourceName  
Description Text for describing the object. String APS_Resources ResourceDesc  

Capability Assignment Mappings

Specify which capabilities are assigned to which resources.

* = Required

Property Description Type Select From Field AX Element
CapabilityExternalId* Unique identification for Capability. String APS_CapabilityAssignments CapabilityID  
PlantExternalId* Unique identification for Plant. String APS_CapabilityAssignments PlantID  
DepartmentExternalId* Unique identification for Department. String APS_CapabilityAssignments DeptID  
ResourceExternalId* Unique identification for Resource. String APS_CapabilityAssignments ResourceID  

Required Capabilities Mappings

Each Resource Requirement specifies one or more Required Capabilities indicating which Resources can satisfy the requirement.

* = Required

Property Description Type Select From Field AX Element
JobExternalId* Unique identifier for the Job. String APS_RequiredCapabilities JobID  
MoExternalId* Unique identifier for the Manufacturing Order. String APS_RequiredCapabilities MOID  
OpExternalId* Unique identifier for the Operations. String APS_RequiredCapabilities OpID  
ResourceRequirementExternalId* Unique identifier for the Resource Requirement. String APS_RequiredCapabilities RRExternalID  
ExternalId* Unique identifier. String APS_RequiredCapabilities CapabililtyID  

Warehouse Mappings

Warehouses are used to store inventories for use by Stocked Materials and Products.

* = Required

Property Description Type Select From Field AX Element
ExternalId* Unique identifier. String APS_Warehouses WarehouseID  
Name* Display text that identifies the Warehouse. String APS_Warehouses WarehouseName  
Description Text for describing the object. String APS_Warehouses WarehouseDesc  

Plant Warehouse Mappings

* = Required

Property Description Type Select From Field AX Element
PlantExternalId* Unique identification for the Plant. String APS_PlantWarehouses WarehouseID  
WarehouseExternalId* Unique identification for the Warehouse. String APS_PlantWarehouses PlantID  

Item Mappings

Items are products and intermediates whose inventory is tracked.  An item is required in order to have a Stocked Material Requirement or Product in a Job that corresponds.

* = Required

Property Description Type Select From Field AX Element
ExternalId* Unique identifier. String INVENTTABLE ItemID  
Name* Display text that identifies the Items. String INVENTTABLE ItemName  
Description Text for describing the object. String INVENTTABLE ItemDesc  

Inventory Mappings

Inventory keeps track of the amount of each item that is currently in stock.

* = Required

Property Description Type Select From Field AX Element
ItemExternalId* Unique identification for the Item. String INVENTTABLE ItemID  
WarehouseExternalId* Unique identification for the Warehouse. String APS_Warehouse WarehouseID  

Purchase to Stock Mappings

Expected receipts of items that are being purchased to stock(as opposed to Buy-Direct which is specified in the Job objects).

* = Required

Property Description Type Select From Field AX Element
ExternalId* Unique identifier. String APS_PurchaseOrders POID  
ItemExternalId* Unique identifier for Item. String APS_PurchaseOrders ItemID  
Name* Display text that identifies the Purchase to Stock. String APS_PurchaseOrders POName  
QtyOrdered* The total qty for this Line Item Distribution on the order. This remains the same even if there is a partial shipment made. Double APS_PurchaseOrders OrderQuantity  
ScheduledReceiptDate*   DateTime APS_PurchaseOrders ScheduledDeliveryDate  
WarehouseExternalId* Unique identifier for Warehouse String APS_PurchaseOrders WarehouseID  

Sales Order Mappings

Customer orders that create demand for inventories.

* = Required

Property Description Type Select From Field AX Element
ExternalId* Unique identifier. String APS_SalesOrders SOID  
Name* Display text that identifies the Sales Order. String APS_SalesOrders SOName  
Description Text for describing the object. String APS_SalesOrders SODesc  
Customer The customer in which the sales order pertains. String APS_SalesOrders Customer  

Sales Order Line Mappings

* = Required

Property Description Type Select From Field AX Element
SalesOrderExternalId* Unique identification for Sales Order. String APS_SalesOrders_Lines SOID  
LineNumber* The line index of the sales order Int32 APS_SalesOrders_Lines SOLine  
ItemExternalId* The item being ordered. String APS_SalesOrders_Lines SOItemID  
Description Text for describing the object. String APS_SalesOrders_Lines SOLineDesc  

Sales Order Line Distribution Mappings

* = Required

Property Description Type Select From Field AX Element
SalesOrderExternalId* Unique identification for Sales Order. String APS_SalesOrders_Lines_Distributions SOID  
LineNumber* The line index of the sales order Int32 APS_SalesOrders_Lines_Distributions SOLine  
MustSupplyFromWarehouseExternalId* The demand must be satisfied by the specified Warehouse only. String APS_SalesOrders_Lines_Distributions WarehouseID  
QtyOpenToShip* This is the remaining qty that must be planned for. If a partial shipment is made then this is the QtyOrdered minus partial shipments. Double APS_SalesOrders_Lines_Distributions DeliveryQuantity  
RequiredAvailibleDate* The date when the material must be available in stock in order to reach the customer by the Promised Delivery Date. DateTime APS_SalesOrders_Lines_Distributions DeliveryDate  
QtyOrdered The total qty for this Line Item Distribution on the order. This remains the same even if there is a partial shipment made. Double APS_SalesOrders_Lines_Distributions OrderQuantity  

Job Mappings

Each Job represents a request to manufacture one or more products by a certain time.

* = Required

Property Description Type Select From Field AX Element
ExternalId* Unique identifier. String APS_Jobs JobID  
Name* Unique identifier for the Job. String APS_Jobs JobName  
Description Text for describing the object. String APS_Jobs JobDesc  
Notes Comments or special considerations pertaining to this object. String APS_Jobs JobNotes  
NeedDateTime When to finish by to be considered on-time. DateTime APS_Jobs NeedDate  
Priority Usually used to specify a combination of importance and urgency. Used in simulation algorithms. Int32 APS_Jobs Priority  
ColorCode A Color that can be used to distinguish the Job from other Jobs in the Gantt. String APS_Jobs JobColor  

Manufacturing Order Mappings

One Manufacturing Order must be created and added to a Job for each different product to be made for the job.

* = Required

Property Description Type Select From Field AX Element
JobExternalId* Unique identifier for the Job. String APS_ManufacturingOrders JobID  
ExternalId* Unique identifier. String APS_ManufacturingOrders MOID  
Name* Unique identifier for the Manufacturing Order. String APS_ManufacturingOrders MOName  
ProductName Name of the product being made. String APS_ManufacturingOrders ProductID  
ProductDescription Description of the product being made. String APS_ManufacturingOrders ProductDesc  
RequiredQty The target quantity of good Product to be made. Double APS_ManufacturingOrders RequiredQuantity  
NeedDate The date and time when the M.O. should be finished to be considered on-time. If MoNeedDate is true then this is the value stored for the M.O.. Otherwise, this is the same as the Job Need Date. DateTime APS_ManufacturingOrders NeedDate  
UOM Unit of measure. For display and custom Algorithms. String APS_ManufacturingOrders UoM  

Resource Operation Mappings

An Operation specifies a step in the manufacturing process.  Each Manufacturing Order must contain at least one Operation.

* = Required

Property Description Type Select From Field AX Element
JobExternalId* Unique identifier for the Job. String APS_Operations JobID  
MoExternalId* Unique identifier for the Manufacturing Order. String APS_Operations MOID  
ExternalId* Unique identifier. String APS_Operations OpID  
Name* Unique identifier for the Resource Operation. String APS_Operations OpName  
Description Text for describing the object. String APS_Operations Description  
RequiredFinishedQty This is the quantity of good product that must be completed at this Operation. Double APS_Operations RequiredQuantity  
CycleHrs Time to perform one production cycle. Double APS_Operations RunRate  
QtyPerCycle The quantity of product produced during each production cycle. Double APS_Operations RunQty  
UOM   String APS_Operations UoM  

Resource Requirements Mappings

Each Operation has one or more resource requirements.

* = Required

Property Description Type Select From Field AX Element
JobExternalId* Unique identifier for the Job. String APS_ResourceRequirements JobID  
ExternalId* Unique identifier. String APS_ResourceRequirements RRExternalID  
MoExternalId* Unique identifier for the Manufacturing Order. String APS_ResourceRequirements MOID  
OpExternalId* Unique identifier for the Operations. String APS_ResourceRequirements OpID  

Activity Mappings

An Activity specifies the status of an Operation.  Each operation has one Activity unless it is split in which it has multiple activities.

* = Required

Property Description Type Select From Field AX Element
JobExternalId* Unique identifier for the Job. String APS_InternalActivities JobID  
MoExternalId* Unique identifier for the Manufacturing Order. String APS_InternalActivities MOID  
OpExternalId* Unique identifier for the Operations. String APS_InternalActivities OpID  
ExternalId* Unique identifier. String APS_InternalActivities ActivityID  
ReportedGoodQty   Double APS_InternalActivities ReportedGoodQuantity  
RequiredFinishQty   Double APS_InternalActivities RequiredQuantity  

Material Mappings

Material can be included with Jobs to provide constraints related to expected raw materials delivery times for a particular Operation.

* = Required

Property Description Type Select From Field AX Element
JobExternalId* Unique identifier for the Job. String APS_Materials JobID  
MoExternalId* Unique identifier for the Manufacturing Order. String APS_Materials MOID  
OpExternalId* Unique identifier for the Operations. String APS_Materials OpID  
ExternalId* Unique identifier. String APS_Materials ItemID  
ItemExternalId The External Id of the Item to be used. This must be a valid Item if Use Item Inventory is set to true. If not using Item Inventory then this field is for information only. String APS_Materials ItemID  
TotalRequiredQty The quantity of material to be consumed by the Operation for this requirement. For display only. Double APS_Materials TotalQtyRequired  
ConstraintType Indicates whether the Material Requirement should prevent its Operation from starting before the material arrives. NonConstraint: Doesn’t have any affect on its Operation. Constraint: Operation can’t start until the earlier of the Material’s AvailableDate and Clock+LeadTimeSpan. ConfirmedConstraint: Overrides Resource.CanPreEmptMaterials thus forcing the Operation to treat this as a constraint. String APS_Materials ConstraintType  

Product Mappings

Products can be included with Jobs to schedule production of finished goods or intermediate products produced by a particular Operation.

* = Required

Property Description Type Select From Field AX Element
JobExternalId* Unique identifier for the Job. String APS_Products JobID  
MoExternalId* Unique identifier for the Manufacturing Order. String APS_Products MOID  
OpExternalId* Unique identifier for the Operations. String APS_Products LastOpID  
ExternalId* Unique identifier. String APS_Products ProductID  
ItemExternalId The External Id of the Item to be used. This must be a valid Item if Use Item Inventory is set to true. If not using Item Inventory then this field is for information only. String APS_Products ProductID  
TotalOutputQty The total amount of the specified Item to be made by the Operation. Double APS_Products FinishQuantity  
WarehouseExternalId The Warehouse where the parts will be inventoried when complete. String APS_Products WarehouseID