WorkOrdersWorkOrderStatus
Tracks the status of work orders, providing visibility into their progression and completion.
Columns
| Name | Type | 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 | Indicates whether this work order is part of a back-to-back supply process, ensuring seamless procurement tracking. |
| ContractMfgFlag | String | Indicates whether the work order is associated with contract manufacturing. This flag supports tracking of outsourced operations. |
| DueDays | Int | 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 | Indicates whether the work order planning is firm, preventing schedule changes and modifications. |
| InventoryItemId | Long | The unique identifier for the inventory item associated with this work order status. This identifier supports inventory tracking. |
| ItemNumber | String | The item number associated with this work order status. This number is used for reference in manufacturing and inventory workflows. |
| LastUpdateDate | Datetime | The timestamp of the last update to this work order status. This timestamp ensures accurate versioning of status history. |
| MaterialItemId | Long | The unique identifier for the material associated with this work order status. This identifier helps track material readiness for production. |
| OrganizationId | Long | The unique identifier for the organization responsible for this work order. This identifier supports multi-organization tracking. |
| PlannedCompletionDate | Datetime | The planned completion date for the work order based on its status. This metric helps align with production schedules. |
| PlannedStartDate | Datetime | The planned start date for the work order based on its status. This metric ensures alignment with manufacturing execution plans. |
| ProductSerialId | Long | The unique identifier linking this work order status to a specific serialized product. This identifier supports serialization tracking. |
| ResourceId | Long | The unique identifier for the resource handling this work order. This identifier helps allocate workforce and machine resources. |
| SerialNumber | String | The serial number assigned to the product or material associated with this work order. This serial number supports traceability. |
| SourceHeaderReferenceId | Long | 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 | Alternative reference identifier for the source document header. This identifier ensures compatibility with external tracking systems. |
| SourceLineReferenceId | Long | Reference identifier linking this work order status to a specific line item in the source document. This identifier supports detailed traceability. |
| SourceLineRefId | Long | Alternative reference identifier for the source line. This identifier ensures smooth integration with external systems. |
| SourceSystemId | Long | The unique identifier for the external system from which this work order status data originates. This identifier supports ERP and SCM integration. |
| Tolerance | Int | The permissible variation before triggering an exception in work order execution. This metric ensures quality control. |
| WoProjectNumber | String | The project number associated with this work order status. This number links it to broader project management tracking efforts. |
| WorkAreaId | Long | The unique identifier for the work area associated with this work order status. This identifier helps track production zones. |
| WorkCenterId | Long | The unique identifier for the work center handling this work order. This identifier supports operational tracking. |
| WorkOrderId | Long | The unique identifier for the work order associated with this status. This identifier supports lifecycle tracking of manufacturing orders. |
| WorkOrderNumber | String | A human-readable work-order number for easy identification of the order in production workflows. |
| WorkOrderStatusId | Long | The status identifier representing the current state of the work order (for example, 'Planned', 'In Progress,' or 'Completed'). |
| WoTaskNumber | String | The task number associated with this work order status. This number helps track specific tasks within the work order. |