WorkOrdersWorkOrderStatus
Tracks the status of work orders, providing visibility into their progression and completion.
Columns
| Name | Type | SupportedFinders | Description |
| WorkOrdersWorkOrderId [KEY] | Long | The unique identifier for the work order associated with this status. This identifier is used for tracking work order lifecycle. | |
| SeededFlag | Bool | Indicates whether this status is predefined (seeded) by the system. A value of 'True' is for system-defined statuses; a value of 'false' is for for custom statuses. | |
| WoStatusCode | String | A code that uniquely identifies the work order status. This code is used for categorization and workflow automation. | |
| WoStatusDescription | String | A detailed description of the work order status. This description provides context on the current stage in the work order lifecycle. | |
| WoStatusId [KEY] | Long | The unique identifier for the work order status. This identifier ensures consistency across work order status tracking. | |
| WoStatusName | String | The Human-readable name of the work order status. This name supports user-friendly status visibility. | |
| WoSystemStatusCode | String | A system-generated code representing the work order's internal system status. This code is used for backend processing and automation. | |
| InactiveDate | Date | The date when this work order status becomes inactive. This metric helps manage phase-out of outdated statuses. | |
| BackToBackFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | Indicates whether this work order is part of a back-to-back supply process, ensuring seamless procurement tracking. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Indicates whether the work order is associated with contract manufacturing. This flag supports tracking of outsourced operations. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | The number of days remaining before the work order reaches its due date. This metric helps with scheduling and priority setting. |
| Finder | String | A searchable reference for locating this specific work order status record within the system. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Indicates whether the work order planning is firm, preventing schedule changes and modifications. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | The unique identifier for the inventory item associated with this work order status. This identifier supports inventory tracking. |
| ItemNumber | String | WorkOrderB2BCM | The item number associated with this work order status. This number is used for reference in manufacturing and inventory workflows. |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | The timestamp of the last update to this work order status. This timestamp ensures accurate versioning of status history. |
| MaterialItemId | Long | WorkOrderByComponent | The unique identifier for the material associated with this work order status. This identifier helps track material readiness for production. |
| OrganizationId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | The unique identifier for the organization responsible for this work order. This identifier supports multi-organization tracking. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The planned completion date for the work order based on its status. This metric helps align with production schedules. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The planned start date for the work order based on its status. This metric ensures alignment with manufacturing execution plans. |
| ProductSerialId | Long | WorkOrderBySerial | The unique identifier linking this work order status to a specific serialized product. This identifier supports serialization tracking. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | The unique identifier for the resource handling this work order. This identifier helps allocate workforce and machine resources. |
| SerialNumber | String | WorkOrderBySerialNumber | The serial number assigned to the product or material associated with this work order. This serial number supports traceability. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | Reference identifier linking this work order status to the header of an external source document, such as a purchase order or transfer order. |
| SourceHeaderRefId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | Alternative reference identifier for the source document header. This identifier ensures compatibility with external tracking systems. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | Reference identifier linking this work order status to a specific line item in the source document. This identifier supports detailed traceability. |
| SourceLineRefId | Long | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | Alternative reference identifier for the source line. This identifier ensures smooth integration with external systems. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The unique identifier for the external system from which this work order status data originates. This identifier supports ERP and SCM integration. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | The permissible variation before triggering an exception in work order execution. This metric ensures quality control. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The project number associated with this work order status. This number links it to broader project management tracking efforts. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | The unique identifier for the work area associated with this work order status. This identifier helps track production zones. |
| WorkCenterId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | The unique identifier for the work center handling this work order. This identifier supports operational tracking. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | The unique identifier for the work order associated with this status. This identifier supports lifecycle tracking of manufacturing orders. |
| WorkOrderNumber | String | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | A human-readable work-order number for easy identification of the order in production workflows. |
| WorkOrderStatusId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | The status identifier representing the current state of the work order (for example, 'Planned', 'In Progress,' or 'Completed'). |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | The task number associated with this work order status. This number helps track specific tasks within the work order. |