ProcessWorkOrdersOperationMaterialMaterialExceptionCount
ProcessWorkOrdersOperationMaterialMaterialExceptionCount
Columns
| Name | Type | SupportedFinders | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | Parent work order identifier (references process work order). | |
| OperationWorkOrderOperationId [KEY] | Long | Parent operation identifier for the work order. | |
| MaterialWorkOrderOperationMaterialId [KEY] | Long | Identifier of the material record within the operation (parent). | |
| WorkOrderMaterialExceptionCount | Long | Count of material exceptions for the work order. | |
| WorkOrderOperationMaterialId [KEY] | Long | Identifier of the work order operation material. | |
| BackToBackFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Indicates whether the work order is back-to-back. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Flag indicating contract manufacturing status. |
| DueDays | Int | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException | Number of days until (or past) the due date for the work order. |
| Finder | String | Finder identifier used to select specific finder logic or view. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | Flag indicating whether the work order is firm planned. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByModifiedDate, WorkOrderByWorkAreaWorkCenter | Identifier of the inventory item associated with the work order or material. |
| ItemNumber | String | WorkOrderB2BCM | Item number or SKU. |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | Date/time when this record was last updated (UTC). |
| MaterialItemId | Long | WorkOrderByComponent | Identifier of the material item used in the operation. |
| OrganizationId | Long | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderBySerialNumber, WorkOrderByWorkAreaWorkCenter, WorkOrderByWorkOrderNumber | Identifier of the organization responsible for the work order. |
| PlannedCompletionDate | Datetime | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Planned completion date/time for the work order (UTC). |
| PlannedStartDate | Datetime | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Planned start date/time for the work order (UTC). |
| ProductSerialId | Long | WorkOrderBySerial | Identifier for the product serial number associated with the work order. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | Identifier of the resource assigned to the operation/work order. |
| SerialNumber | String | WorkOrderBySerialNumber | Serial number of the product or component. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | Reference identifier for the source header associated with this record. |
| SourceHeaderRefId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | Reference identifier for the source header (alternate field). |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | Reference identifier for the source line associated with this record. |
| SourceLineRefId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | Reference identifier for the source line (alternate field). |
| SourceSystemId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Identifier of the source system that provided this record. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException | Tolerance value for the work order/material (units depend on context). |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | Project number associated with the work order. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkAreaWorkCenter | Identifier of the work area where the operation is scheduled. |
| WorkCenterId | Long | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkAreaWorkCenter | Identifier of the work center where the operation will be performed. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | Primary identifier of the work order. |
| WorkOrderNumber | String | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkOrderNumber | Human-readable work order number/code. |
| WorkOrderStatusId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Identifier representing the current status of the work order. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | Task number within the work order (if applicable). |