WorkOrdersWorkOrderOperationWorkOrderOperationExceptionCount
Tracks the count of exceptions that occurred during specific work order operations for analysis and troubleshooting.
Columns
| Name | Type | Description |
| WorkOrdersWorkOrderId [KEY] | Long | The unique identifier for the work order associated with this exception count. This identifier ensures proper linkage between the work order and recorded exceptions. |
| WorkorderoperationWorkOrderOperationId [KEY] | Long | The unique identifier for the work order operation associated with this exception count. This identifier links exceptions to specific operation steps within the work order. |
| WorkOrderOperationExceptionCount | Long | The total number of exceptions recorded for this work order operation. This metric tracks anomalies such as delays, material shortages, or quality issues affecting production. |
| WorkOrderOperationId [KEY] | Long | The unique identifier for the work order operation. This identifier ensures proper tracking and alignment of exception counts with the respective manufacturing processes. |
| BackToBackFlag | String | Indicates whether the work order operation is part of a back-to-back order process, where demand directly triggers supply alignment to optimize inventory and production. |
| ContractMfgFlag | String | Indicates whether this work order operation involves contract manufacturing. This flag helps track exceptions related to outsourced production activities. |
| DueDays | Int | The number of days remaining until the planned completion of this work order operation. This metric assists in monitoring deadlines and identifying exceptions impacting timelines. |
| Finder | String | A search key or identifier used to quickly locate specific work order operations and associated exceptions in the system. |
| FirmPlannedFlag | String | Indicates whether the work order operation is firm-planned, meaning it is locked and not subject to changes or rescheduling, which can impact how exceptions are handled. |
| InventoryItemId | Long | The unique identifier for the inventory item associated with this work order operation. This identifier links exceptions to specific materials used in production. |
| ItemNumber | String | The unique item number assigned to the material used in the work order operation. This number enables precise identification and tracking of materials linked to exceptions. |
| LastUpdateDate | Datetime | The date and time when this exception record was last updated. These metrics help track the most recent modifications for audit and resolution purposes. |
| MaterialItemId | Long | The unique identifier for the material assigned to this work order operation. This identifier ensures traceability of materials affected by exceptions. |
| OrganizationId | Long | The identifier for the organization or business unit responsible for this work order operation. This identifier supports multi-organization reporting of operational exceptions. |
| PlannedCompletionDate | Datetime | The scheduled completion date for the work order operation. Exceptions can impact this timeline, requiring adjustments to production schedules. |
| PlannedStartDate | Datetime | The planned start date for the work order operation. Exceptions such as material shortages or delays can affect adherence to this schedule. |
| ProductSerialId | Long | The unique identifier for the serialized product associated with this work order operation. This identifier ensures traceability of serialized products affected by exceptions. |
| ResourceId | Long | The unique identifier for the resource (for example, 'machine', 'tool', or 'labor') assigned to this work order operation. This identifier helps track exceptions related to resource failures or inefficiencies. |
| SerialNumber | String | The serial number of the material or product associated with the work order operation. This serial number supports traceability, especially in cases where exceptions involve quality issues. |
| SourceHeaderReferenceId | Long | The reference identifier linking this work order operation to the source document header (for example, a sales order or production request). This identifier ensures exceptions can be traced to their origin. |
| SourceHeaderRefId | Long | An alternate reference identifier for the source header, often used for legacy system compatibility or integrations. |
| SourceLineReferenceId | Long | The reference identifier linking this work order operation to a specific line item in the source document. This identifier ensures exceptions are tracked at the line-item level. |
| SourceLineRefId | Long | An alternate reference identifier for the source line. This identifier supports integration with external systems. |
| SourceSystemId | Long | The identifier for the external system from which this work order operation and exception data originates. This identifier ensures traceability across integrated systems. |
| Tolerance | Int | The allowable tolerance for variations in material usage or production specifications. Exceptions might occur if deviations exceed these predefined tolerances. |
| WoProjectNumber | String | The project number associated with the work order operation. This number links the exception count to broader project tracking for cost analysis and reporting. |
| WorkAreaId | Long | The unique identifier for the work area where the operation is executed. This identifier helps localize exceptions to specific areas of production. |
| WorkCenterId | Long | The unique identifier for the work center associated with the work order operation. This identifier ensures exceptions are accurately linked to the production unit responsible. |
| WorkOrderId | Long | The unique identifier for the work order associated with this operation. This identifier connects all relevant exception counts to the overarching production job. |
| WorkOrderNumber | String | The user-friendly number assigned to the work order. This number helps reference the work order and its associated exceptions in reports and workflows. |
| WorkOrderStatusId | Long | The identifier for the current status of the work order, such as 'Planned,' 'In Progress,' or 'Completed.' Exceptions might impact the progression of work order statuses. |
| WoTaskNumber | String | The specific task number within the work order operation. This number helps track exceptions at the task level, ensuring visibility into sub-process inefficiencies. |