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