WorkOrdersWorkOrderOperationWorkOrderOperationExceptionCount
Tracks the count of exceptions that occurred during specific work order operations for analysis and troubleshooting.
Columns
| Name | Type | SupportedFinders | 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 | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | 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 | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Indicates whether this work order operation involves contract manufacturing. This flag helps track exceptions related to outsourced production activities. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | 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 | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | 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 | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | 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 | WorkOrderB2BCM | 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 | WorkOrderByModifiedDate | 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 | WorkOrderByComponent | The unique identifier for the material assigned to this work order operation. This identifier ensures traceability of materials affected by exceptions. |
| OrganizationId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | 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 | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The scheduled completion date for the work order operation. Exceptions can impact this timeline, requiring adjustments to production schedules. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The planned start date for the work order operation. Exceptions such as material shortages or delays can affect adherence to this schedule. |
| ProductSerialId | Long | WorkOrderBySerial | 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 | WorkOrderByResource, WorkOrderBySerial | 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 | WorkOrderBySerialNumber | 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 | WorkOrderByWorkAreaWorkCenter | 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 | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternate reference identifier for the source header, often used for legacy system compatibility or integrations. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | 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 | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | An alternate reference identifier for the source line. This identifier supports integration with external systems. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | 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 | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | The allowable tolerance for variations in material usage or production specifications. Exceptions might occur if deviations exceed these predefined tolerances. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | 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 | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | The unique identifier for the work area where the operation is executed. This identifier helps localize exceptions to specific areas of production. |
| WorkCenterId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | 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 | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | 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 | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | 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 | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | 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 | FindByProjectNumberTaskNumber | The specific task number within the work order operation. This number helps track exceptions at the task level, ensuring visibility into sub-process inefficiencies. |