ProcessWorkOrdersProcessWorkOrderMaterial
Tracks and manages materials consumed during operations to process work orders, ensuring accurate material planning.
Columns
| Name | Type | SupportedFinders | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier linking the process work order to the material requirements. It acts as a reference to associate specific materials with the work order they support, enabling detailed tracking of material usage. | |
| OrganizationId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | The unique identifier for the organization (for example, a plant or a warehouse) where the materials are stored and consumed. This identifier helps differentiate between various operational facilities. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | The unique identifier for the work order that outlines the production or maintenance task requiring the material. This key is critical for associating materials to specific jobs. |
| WorkOrderOperationId | Long | The unique identifier for the specific operation within the work order that uses the material. This identifier allows materials to be linked to individual steps or processes in the production workflow. | |
| OperationSequenceNumber | Decimal | Defines the order in which operations are performed within the work order. This number indicates when the associated material is required in the sequence of operations. | |
| OperationName | String | The name of the operation that consumes the material (for example, 'Cutting,' 'Assembling,' or 'Packaging'). It provides context about where the material is being used. | |
| StandardOperationId | Long | The unique identifier for a predefined standard operation template that the work order operation is based on. Standard operations are reusable definitions of tasks. | |
| StandardOperationCode | String | A short code or abbreviation representing the standard operation, such as 'WELD' for 'Welding' or 'ASSY' for 'Assembly.' This code helps in quick identification. | |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | The unique identifier for the work area where the operation using the material is performed. A work area represents a group of resources (for example, machines or workers) allocated to specific tasks. |
| WorkAreaName | String | The name of the work area where the material is consumed, providing an easily identifiable label for operational purposes, such as 'Welding Bay' or 'Packaging Station.' | |
| WorkCenterId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | The unique identifier for the work center where the operation requiring the material takes place. A work center is a physical or logical grouping of equipment or resources. |
| WorkCenterName | String | The name of the work center where the material is used (for example, 'Lathe Area' or 'Paint Booth'). This name helps in tracking material use at specific locations. | |
| WorkOrderOperationMaterialId [KEY] | Long | The unique identifier for the specific material requirement within an operation. This identifier enables precise tracking and management of each material needed for the operation. | |
| MaterialSequenceNumber | Decimal | Indicates the order in which materials are consumed within an operation. For example, material with sequence number 1 is used before material with sequence number 2. | |
| MaterialType | String | Specifies the type of material, such as 'Component' (raw materials), 'Consumable' (for example, lubricants), or 'Tooling' (equipment used for production). | |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | The unique identifier for the material item in the inventory system, used to track material availability, location, and status. |
| ItemNumber | String | WorkOrderB2BCM | A system-generated or user-defined number that uniquely identifies the material item, allowing for quick reference in inventory and production systems. |
| ItemDescription | String | A detailed description of the material item, including its characteristics, specifications, or purpose (for example, '1-inch steel bolt' or 'High-temperature adhesive'). | |
| ItemRevision | String | Specifies the revision level of the material item, indicating changes or updates made to the item's design or specifications over time. | |
| BasisType | String | Defines the basis for determining material consumption. Common types include 'Per Operation' (used once per operation) or 'Per Unit' (used for each unit produced). | |
| Quantity | Decimal | The required amount of the material needed for the operation, expressed in the specified unit of measure. | |
| UOMCode | String | The unit of measure (UOM) code for the material, such as 'EA' (Each), 'KG' (Kilogram), or 'MTR' (Meter). The UOM helps standardize material tracking. | |
| UnitOfMeasure | String | The full name of the unit of measure associated with the material (for example, 'Each,' 'Kilograms,' or 'Meters'). | |
| RequiredDate | Datetime | The specific date and time when the material is required for the operation. This value ensures timely availability of resources for production. | |
| YieldFactor | Decimal | Represents the expected percentage or ratio of material consumed without loss during production. A yield factor of 0.95 indicates 95% efficiency, with 5% anticipated loss. | |
| IncludeInPlanningFlag | Bool | Indicates whether the material is included in planning calculations. If the value is 'true', the material is considered in supply-and-demand planning processes. | |
| SupplyType | String | Specifies how the material is supplied to the operation. Options include 'Push' (delivered ahead of time), 'Pull' (provided on-demand), or 'Backflush' (automatically deducted after use). | |
| SupplyTypeDescription | String | Detailed description of the supply type, explaining how and when the material is made available to the operation. | |
| SupplySubinventory | String | The specific subinventory (for example, a storage location) from which the material is supplied (for example, 'Raw Materials' or 'Finished Goods'). | |
| SupplyLocatorId | Long | The unique identifier for the locator within the subinventory where the material is stored. Locators represent precise storage positions such as shelves or bins. | |
| SupplyLocator | String | The name or code for the locator within the subinventory (for example, 'Bin A1' or 'Shelf B3'). This code helps pinpoint the material's location. | |
| ReservedQuantity | Decimal | The quantity of the material reserved specifically for this operation or work order. Reserved materials are allocated and unavailable for other tasks. | |
| IssuedQuantity | Decimal | The quantity of material that has already been issued to the operation. This value helps track material usage against the requirement. | |
| ProducedQuantity | Decimal | The quantity of finished goods or outputs produced using the material, enabling monitoring of production efficiency. | |
| AllocatedQuantity | Decimal | The quantity of material allocated to the work order. Allocated materials are reserved specifically for this task, ensuring availability when needed. | |
| PickedQuantity | Decimal | The quantity of material picked from inventory and delivered to the work center for use in the operation. | |
| RemainingAllocatedQuantity | Decimal | The portion of the allocated quantity that has not yet been picked or consumed by the operation. | |
| CreatedBy | String | The name or identifier of the user who created the material record associated with the work order. | |
| CreationDate | Datetime | The date and time when the material record was created in the system. | |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | The date and time when the material record was last updated. |
| LastUpdatedBy | String | The name or identifier of the user who last updated the material record associated with the work order. | |
| SecondaryQuantity | Decimal | The quantity of the material required in a secondary unit of measure, such as a different size or configuration of the material. | |
| SecondaryUOMCode | String | The unit of measure code used for the secondary quantity of the material (for example, 'LBS' for pounds or 'GAL' for gallons). | |
| SubstituteFlag | Bool | Indicates whether a substitute material can be used in place of the original material. A value of 'true' means substitution is allowed. | |
| BackToBackFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | Indicates whether the material is part of a back-to-back manufacturing process. This value directly connects the supply of this material to specific demand from the customer. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Indicates whether the material is associated with contract manufacturing, where production is outsourced to an external manufacturer. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | The number of days remaining until the material is required for the operation or work order. |
| Finder | String | Represents the search mechanism or criteria to locate and identify the material record within the system. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Indicates whether the material allocation or requirement is firm planned, preventing changes by planning or scheduling processes. |
| MaterialItemId | Long | WorkOrderByComponent | The unique identifier for the material item in the inventory system, used to track availability and usage. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The planned date and time when the operation or work order consuming the material is scheduled to be completed. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The planned date and time when the operation or work order consuming the material is scheduled to begin. |
| ProductSerialId | Long | WorkOrderBySerial | The unique identifier for the product serial number associated with the material. This identifier enables serialized tracking of materials. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | The unique identifier for the resource (for example, machine or personnel) associated with the operation requiring the material. |
| SerialNumber | String | WorkOrderBySerialNumber | The serial number assigned to the material item, allowing for tracking and traceability in the manufacturing process. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The unique identifier for the source header that links the material record to its originating transaction or external system. |
| SourceHeaderRefId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | An alternate unique identifier for the source header reference associated with the material record. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The unique identifier for the source line that links the material record to a specific line item in the source document. |
| SourceLineRefId | Long | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | An alternate unique identifier for the source line reference associated with the material record. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The unique identifier for the source system from which the material record or related data originates. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | The allowable tolerance level for the material, such as acceptable variances in quantity or quality during the operation. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The project number associated with the work order material, used for project-specific tracking and reporting. |
| WorkOrderNumber | String | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | The unique number assigned to the work order associated with the material. This number helps track the material usage in relation to the work order. |
| WorkOrderStatusId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | The unique identifier for the current status of the work order associated with the material. Statuses indicate whether the work order is open, in progress, or completed. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | The task number associated with the work order material, used for tracking material usage at the task level. |