Excel Integration Mappings

Resources * = Required Field Name: Description: Data Type: Accepted Values: ResourceId* Machine Name or ID String CapabilityId* Controls which operations can schedule on the Resource. String StandardHourlyCost Cost of running this machine during normal hours of operation per hour Decimal OvertimeHourlyCost Cost of running this machine overtime per hour Decimal HeadStartSpanHours How early a […]

Read More

Successor Manufacturing Order Mappings

Red = Can be Imported * = Required Successor Manufacturing Orders Name Description Type Values AlternatePath NULL if the successor path wasn’t found. This may be the case if the path wasn’t found, if the successor operation was finished, cancelled, never existed, or the path wasn’t specified. AlternatePathExternalId The alternate path that is constrained. The […]

Read More

Alternate Path & Node Mappings

Red = Can be Imported * = Required Alternate Paths Name Description Type Values AlternateNodeHash The set of nodes that define this alternate path. Keys are the node’s associated operation external id. Analysis If overridden in a parent class, returns a string containing analysis about the object. Else returns an empty string.(Inherited from BaseIdObject.) AutoBuildLinearPath […]

Read More

Product Mappings

Red = Can be Imported * = Required Products Name Description Type Values Analysis If overridden in a parent class, returns a string containing analysis about the object. Else returns an empty string.(Inherited from BaseIdObject.) CustomFlagsList Flags that are created with a customization. These values are stored. This value is initially null. To add a […]

Read More

Material Requirement Mappings

Red = Can be Imported * = Required Material Requirements Name Description Type Values AllocationRule Int64 Analysis (Overrides BaseIdObject..::.Analysis.) Available True if Issued Complete or if the any unissued quantity has been allocated on-hand inventory (which requires that the Operation is scheduled). Boolean AvailableDateTime When the material is expected to be available for use in […]

Read More

Required Capability Mappings

Red = Can be Imported * = Required Required Capabilities Name Description Type Values JobExternalId* String MoExternalId* String OpExternalId* String ResourceRequirementExternalId* String CapabilityExternalId* String

Read More

Resource Requirement Mappings

Red = Can be Imported * = Required Resource Requirements Name Description Type Values Analysis (Overrides BaseIdObject..::.Analysis.) AttentionPercent The percent of the Resource’s attention consumed by this Resource Requirement. For example, two Operations with Attention Percents of 60% and 40% could schedule “stacked” on each other in the Gantt — running simultaneously. A maximum of […]

Read More

Activity Mappings

Red = Can be Imported * = Required Activities Name Description Type Values Analysis Special summary or troubleshooting information. Anchor If true then Optimizations will attempt to start the Activity as close as possible to the AnchorStartDate. If manually moved or Expedited, Anchored Activities are re-anchored to their new Start Date. If moved with in […]

Read More

Operation Mappings

Red = Can be Imported * = Required Operations Name Description Type Values Activities A portion of the Operation to be completed. There is one Activity per Operation unless it is Split into multiple Activities.(Inherited from InternalOperation.) AlternatePathNode (Inherited from BaseOperation.) Analysis Special summary or troubleshooting information.(Overrides BaseIdObject..::.Analysis.) Anchored Anchored Activities cannot be moved (in […]

Read More

Manufacturing Order Mappings

Red = Can be Imported * = Required Manufacturing Orders Name Description Type Values AlternatePathSelection Controls how alternate paths are used. String AutoJoinGroup String AutoSplitMinQty When using Manufacturing Order Auto-splitting, this prevents Manufacturing Orders from being created (the original MO or the splits) with a Required Qty less than this value. If ’0′ then no […]

Read More