WorkOrdersWorkOrderMaterialWorkOrderMaterialExceptionCount
Tracks exceptions related to materials during operations, aiding in quality management.
Columns
| Name | Type | SupportedFinders | Description |
| WorkOrdersWorkOrderId [KEY] | Long | The unique identifier for a specific work order in the WorkOrders table. This identifier links the current material exception count to the parent work order, ensuring all material activities and exceptions are tied back to the appropriate manufacturing process. | |
| WorkordermaterialWorkOrderOperationMaterialId [KEY] | Long | The unique identifier for a material associated with a specific operation in a work order. This identifier ensures traceability of material usage for a specific operation step within the manufacturing workflow. | |
| WorkOrderMaterialExceptionCount | Long | The count of exceptions or discrepancies related to the material used in this work order. This metric helps track issues such as shortages, damaged materials, or substitutions, providing insight into production quality and supply chain reliability. | |
| WorkOrderOperationMaterialId [KEY] | Long | The unique identifier for the specific material linked to an operation in the work order. This identifier field ensures material accountability during the execution of operational tasks. | |
| BackToBackFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | Indicates whether this work order is part of a back-to-back order process. Back-to-back orders directly tie the demand (customer order) to supply (purchase or manufacturing), streamlining fulfillment and reducing inventory overhead. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Identifies whether the work order is outsourced to a contract manufacturer. This flag helps track outsourced production activities and facilitates coordination with external vendors. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | The number of days remaining until the planned completion or delivery of the material or operation within the work order. This metric supports scheduling and timeline monitoring for timely production execution. |
| Finder | String | An internal search identifier or key used to locate specific materials, work orders, or related records within the system, improving efficiency in large datasets. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Specifies whether the material requirement or work order is firm-planned, meaning it is confirmed and not subject to changes. This flag is used in planning and resource allocation processes. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | The unique identifier of the inventory item associated with this work order material. This identifier ensures proper linkage between the work order and the inventory system, enabling accurate stock tracking. |
| ItemNumber | String | WorkOrderB2BCM | The unique item number assigned to the material, providing a clear and consistent reference across procurement, inventory, and manufacturing systems. |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | The date and time when the record was last updated. These metrics help track the recency of changes and ensures data integrity for auditing purposes. |
| MaterialItemId | Long | WorkOrderByComponent | The unique identifier for the material item associated with this work order. This identifier connects specific materials to their corresponding work orders, enabling precise tracking of material usage. |
| 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. This identifier supports multi-organization operations by distinguishing work orders by their ownership or production site. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The date when the material or operation within the work order is scheduled to be completed. This metric is critical for production planning and meeting delivery deadlines. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The planned start date for the execution of this work order material or operation. This metric helps align resource availability and production schedules. |
| ProductSerialId | Long | WorkOrderBySerial | The unique serial number identifier for the finished product associated with the work order. This serial number ensures traceability of the end product through manufacturing and supply chain processes. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | The unique identifier for the resource (for example, 'machine', 'tool', or 'personnel') allocated to this work order. This identifier supports capacity planning and resource-use tracking. |
| SerialNumber | String | WorkOrderBySerialNumber | The serial number of the material or product, enabling traceability and compliance with quality assurance requirements. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | A reference identifier for the original order or demand from which this work order was created (for example, 'sales order' or 'master production schedule'). This identifier ensures traceability back to the source of demand. |
| SourceHeaderRefId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternate reference identifier for the source header. This identifier erves as a compatibility field for integrations or legacy systems. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The reference identifier for the specific line item in the source document (for example, 'sales-order line') associated with this work order. This identifier connects material requirements to the originating demand line item. |
| SourceLineRefId | Long | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | An alternate reference for the source line identifier. This identifier is often used in systems that require additional compatibility for integrations. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The identifier for the external system from which the data for this work order originates. This identifier is crucial for multi-system integrations and data traceability. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | The allowable deviation or tolerance limit for the material in this work order. This metric helps ensure that the manufacturing process meets quality standards without unnecessary rework. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The project number associated with this work order. This number connects the work order to a broader project management framework, aiding in cost allocation and progress tracking. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | The identifier for the specific work area where the work order is being executed, such as an assembly line or workstation. This identifier helps allocate resources and monitor production efficiency. |
| WorkCenterId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | The identifier for the work center responsible for completing the work order. Work centers group resources like machines or operators into units for better planning and execution. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | The unique identifier for the work order itself. This identifier is essential for connecting all related material and operations to a single production job. |
| WorkOrderNumber | String | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | A user-friendly number assigned to the work order, often used in operational reports, production schedules, and worker instructions. |
| WorkOrderStatusId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | The identifier for the current status of the work order (for example, 'planned', 'in-progress', 'completed'). This identifier supports workflow tracking and production monitoring. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | The specific task number within the work order. This number is used to define and track individual steps or sub-processes within the overall production process. |