WorkOrders
Manages discrete work orders detailing item, quantity, operations, resources, and timelines for discrete manufacturing.
Columns
| Name | Type | Description |
| OrganizationId | Long | The unique identifier for the inventory organization that is enabled for manufacturing. This identifier ensures the work order is associated with the correct organization, supporting multi-organization workflows. |
| OrganizationCode | String | An abbreviation for the inventory organization. This abbreviation provides a shorthand reference for the organization in reports and interfaces. |
| OrganizationName | String | The name of the inventory organization. This name provides a user-friendly label for identifying the organization managing the work order. |
| WorkOrderId [KEY] | Long | The unique identifier for the work order. This identifier serves as the primary key for managing and tracking work orders in the system. |
| WorkOrderNumber | String | The unique number assigned to the work order. This number can be generated automatically or assigned manually, following the organization's numbering conventions. |
| WorkOrderDescription | String | A detailed description of the work order. This description provides context about the production or tasks to be performed. |
| WorkMethodId | Long | The unique identifier for the work method associated with the work order. This identifier ensures the correct manufacturing or assembly method is linked to the work order. |
| WorkOrderType | String | Specifies the type of work order (for example, 'Standard', 'Non-Standard', or 'Maintenance'). This categorization helps in organizing and reporting work orders. |
| WorkOrderTypeDescription | String | A detailed description of the work order type. This description provides additional context about the type of production or task being performed. |
| WorkOrderSubType | String | Specifies the subtype of work being performed (for example, 'Standard Production', 'Prototyping', or 'Repair'. This field helps refine categorization within the work order type. |
| WorkOrderSubTypeDescription | String | A detailed description of the work order subtype. This description provides additional clarity about the nature of the work being performed. |
| InventoryItemId | Long | The unique identifier for the inventory item associated with the work order. This identifier ensures that the work order is linked to the correct product, item, or assembly. |
| ItemNumber | String | The unique number for the inventory item that is the output of the work order. This number serves as a reference for tracking production results. |
| Description | String | A general description of the work order. This description provides additional context for users managing the work order. |
| ItemRevision | String | The revision number of the item associated with the work order. This number supports version control and ensures the correct specifications are used. |
| ItemStructureName | String | The name of the item structure used for the work order. This name defines the components and subassemblies needed for production. |
| TransformFromItemId | Long | The unique identifier for the item that will be transformed into the output item of the work order. This identifier supports transformation processes in manufacturing. |
| TransformFromItemNumber | String | The number of the item being transformed. This number provides a clear reference for tracking input materials or assemblies. |
| WorkDefinitionAsOfDate | Datetime | The date used to determine the applicable work definition version for the work order. This metric ensures the correct version is applied based on the production date. |
| WorkDefinitionId | Long | The unique identifier for the work definition associated with the work order. This identifier defines the sequence of operations and resources needed for production. |
| WorkDefinitionCode | String | An abbreviation for the work definition. This abbreviation provides a shorthand reference for identifying the work definition. |
| WorkDefinitionVersionId | Long | The unique identifier for the version of the work definition. This identifier ensures the correct version is applied to the work order. |
| WorkDefinitionVersionNumber | String | The version number of the work definition. This number supports version control and ensures accurate production specifications. |
| WorkDefinitionName | String | The name of the work definition associated with the work order. This name provides a descriptive reference for identifying the production process. |
| WorkOrderPriority | Decimal | The priority assigned to the work order. Higher priority work orders are scheduled and executed before lower priority orders. |
| WorkOrderStatusId | Long | The unique identifier for the current status of the work order. This identifier ensures accurate tracking and reporting of work order progress. |
| WorkOrderStatusName | String | The name of the current status of the work order. This name provides a descriptive reference for users monitoring the work order. |
| WorkOrderStatusCode | String | An abbreviation for the current status of the work order. This abbreviation provides a shorthand reference for identifying work order statuses. |
| WorkOrderSystemStatusCode | String | The system-assigned status code for the work order. This code reflects predefined workflow states such as 'Open,' 'In Progress,' or 'Closed.' |
| SchedulingMethod | String | The method used to schedule the work order (for example,DEFAULT_SCHEDULING or MANUAL_SCHEDULING). This method defines how production timelines are managed. |
| PlannedStartQuantity | Decimal | The planned production quantity for the work order. This metric represents the expected output quantity. |
| CompletedQuantity | Decimal | The total quantity of items completed for the work order. This metric provides visibility into production progress. |
| ScrappedQuantity | Decimal | The quantity of items scrapped during production. This metric supports quality control and waste analysis. |
| RejectedQuantity | Decimal | The quantity of items rejected during production. This metric tracks quality issues and helps identify areas for improvement. |
| NettableSupplyQuantityOverride | Decimal | The quantity that the planning system uses as a supply from the work order. This metric overrides the default quantity for planning calculations and ensures accurate supply-demand balancing. |
| UOMCode | String | The code representing the unit of measure (UOM) for the work order's item. This code is used for consistency in inventory and production calculations. |
| UnitOfMeasure | String | The full name of the unit of measure (for example, 'Pieces' or 'Kilograms') for the work order's item. This name ensures clarity in quantity-related calculations. |
| FirmPlannedFlag | Bool | Indicates whether the work order is firm planned. If the value is 'true', the work order is locked and excluded from rescheduling or re-planning. If the value is 'false', planning can suggest updates. The default value is 'false'. |
| PlannedStartDate | Datetime | The scheduled start date and time for the work order. These metrics define when production is expected to begin. |
| PlannedCompletionDate | Datetime | The scheduled completion date and time for the work order. These metrics define when production is expected to end. |
| ActualStartDate | Datetime | The actual date and time when the work order began production. These metrics provide insight into adherence to schedules. |
| ActualCompletionDate | Datetime | The actual date and time when the work order was completed. The metrics are used for performance tracking and reporting. |
| ReleasedDate | Datetime | The date when the work order was released for production. This metric indicates readiness to begin work. |
| ClosedDate | Datetime | The date when the work order was closed. This metric indicates the work order's lifecycle is complete. |
| CanceledDate | Datetime | The date when the work order was canceled. This metric tracks the cancellation date for historical and audit purposes. |
| DelayStatus | Int | An integer indicating the delay status of the work order. This field helps monitor whether the work order is on track, delayed, or overdue. |
| WorkOrderDate | Datetime | The date associated with the work order creation. This metric provides visibility into when the work order was initiated. |
| CanceledReason | String | The reason for canceling the work order. This field helps document why the work order was not completed. |
| OvercomplToleranceType | String | The type of tolerance allowed for over-completing the work order, such as a percentage or a fixed quantity. |
| OvercomplToleranceValue | Decimal | The percent or quantity by which the finished work can exceed the work order quantity. Ensures flexibility in production. |
| OvercomplToleranceTypeDescription | String | A description of the over-completion tolerance type, providing additional clarity about the allowed threshold. |
| UndercomplToleranceType | String | The type of tolerance allowed for under-completing the work order, such as a percentage or a fixed quantity. Requires opt-in for use. |
| UndercomplToleranceValue | Decimal | The percent or quantity by which the finished work can fall short of the work order quantity. This metric supports partial completions when necessary. |
| UndercomplToleranceTypeDescription | String | A description of the under-completion tolerance type, providing clarity about the allowed deviation. |
| UnderCompletedFlag | Bool | Indicates whether the work order was completed with an under-completion condition. This field helps track deviations from the planned quantity. |
| SupplyType | String | The default supply type for the work order components (for example, 'Push' or 'Pull'). This type determines how materials are managed during production. |
| SupplyTypeDescription | String | A description of the supply type, providing additional context for how materials are issued to the work order. |
| CompletionSubinventoryCode | String | The subinventory used by default for product completion. This field ensures that completed products are stored in the correct location. |
| CompletionLocatorId | Long | The unique identifier for the locator used for product completion. This identifier ensures accurate tracking of where finished goods are stored. |
| CompletionLocator | String | The specific locator used for product completion within the subinventory. This locator provides visibility into the physical location of finished products. |
| SerialTrackingFlag | Bool | Indicates whether serial tracking is enforced for the work order. If the value is 'true', serialized products are tracked individually. The default value is 'false'. |
| PreassignLotFlag | Bool | Indicates whether lot numbers can be preassigned to products in the work order. This flag supports lot control and traceability. Requires opt-in. |
| BackToBackFlag | Bool | Indicates whether the work order is part of a back-to-back process. This flag helps manage workflows tied to specific customer orders or demands. |
| ContractMfgFlag | Bool | Specifies whether the work order is part of a contract manufacturing process. This flag identifies outsourced production activities. |
| ResequenceFlag | Bool | Indicates whether the operations within the work order are resequenced. This flag helps track and manage changes to the operation order. |
| OrchestrationCode | String | The code representing the orchestration process for the work order. This code ensures alignment with orchestrated workflows in the manufacturing system. |
| InterfaceSourceCode | String | The code identifying the source of the interface through which the work order was created. This code supports integration tracking and troubleshooting. |
| ScoSupplyOrderId | Long | The unique identifier for the supply chain orchestration (SCO) supply order associated with the work order. This identifier links the work order to its supply chain context. |
| CmPOHeaderId | Long | The unique identifier for the purchase order (PO) header associated with contract manufacturing. This identifier ensures traceability to the contract manufacturing PO. |
| CmPOLineId | Long | The unique identifier for the purchase order line in contract manufacturing. This identifier links the work order to the specific line item in the contract manufacturing PO. |
| CmPOLineLocId | Long | The unique identifier for the purchase order line location in contract manufacturing. This identifier provides additional traceability for specific location-level details. |
| OrderLessFlag | Bool | Indicates whether the work order is orderless (not tied to a sales order). If the value is 'true', the work order operates independently of customer orders. |
| SourceSystemType | String | Specifies whether the source system for the work order is internal or external. This field helps categorize work orders based on their origin. |
| SourceSystemId | Long | The unique identifier for the source system that created the work order. This identifier ensures traceability across integrated systems. |
| SourceHeaderReference | String | Reference information for the header of the source document or transaction that initiated the work order. This field provides a direct link to the originating document. |
| SourceHeaderReferenceId | Long | The unique identifier for the header of the source document. This identifier supports precise mapping to the originating transaction. |
| SourceLineReference | String | Reference information for the line item in the source document associated with the work order. This field provides detailed traceability to the originating document. |
| SourceLineReferenceId | Long | The unique identifier for the line item in the source document. This identifier ensures accurate linkage between work orders and specific line items. |
| ProjectNumber | String | The unique project number associated with the work order. This identifier ties the work order to specific projects, enabling project-based production tracking. |
| TaskNumber | String | The task number associated with the project tied to the work order. This number helps track and manage project-specific tasks within the work order. |
| CreationDate | Datetime | The date and time when the work order was created. These metrics support audit trails and historical tracking. |
| LastUpdateDate | Datetime | The date and time when the work order was last updated. These metrics ensure traceability of changes and supports audit requirements. |
| CreatedBy | String | The username of the person who created the work order. This name provides accountability for work order creation. |
| LastUpdatedBy | String | The username of the person who last updated the work order. This name ensures traceability for modifications. |
| ExplosionFlag | Bool | Indicates whether the work order includes exploded operations, materials, and resources based on the work definition. If the value is 'true', these elements are created automatically; if 'false', they must be added manually. Default is false. |
| WorkMethodCode | String | The code representing the work method used for the work order. This code defines how production activities are performed. |
| DueDays | Int | The number of days remaining until the work order is due. This number supports prioritization and scheduling of production activities. |
| Finder | String | A utility field enabling advanced search and filtering capabilities for work orders. This field helps users efficiently locate specific records. |
| MaterialItemId | Long | The unique identifier for the material item associated with the work order. This identifier ensures accurate tracking of required materials. |
| ProductSerialId | Long | The unique identifier for the product serial number associated with the work order. This identifier supports serialized production tracking. |
| ResourceId | Long | The unique identifier for the resource associated with the work order. This identifier ensures proper allocation and tracking of production resources. |
| SerialNumber | String | The serial number of the product associated with the work order. This serial number supports traceability for serialized items in the production process. |
| SourceHeaderRefId | Long | An alternative identifier for the source header reference. This identifier provides flexibility in integration with external systems. |
| SourceLineRefId | Long | An alternative identifier for the source line reference. This identifier supports flexible tracking of source system integrations. |
| Tolerance | Int | The allowed deviation (in days) for completing the work order. This metric defines acceptable thresholds for delays. |
| WoProjectNumber | String | The unique project number associated with the work order. This number links the work order to specific projects for tracking and reporting. |
| WorkAreaId | Long | The unique identifier for the work area associated with the work order. This identifier ensures tasks are assigned to the correct operational zones. |
| WorkCenterId | Long | The unique identifier for the work center associated with the work order. This identifier ensures proper allocation of tasks to the correct work centers. |
| WoTaskNumber | String | The unique task number associated with the work order. This number provides detailed tracking of tasks within the work order. |