WorkOrdersWorkOrderOperationWorkOrderOperationMaterial
Manages materials required for work order operations, including material specifications and quantities.
Columns
| Name | Type | Description |
| WorkOrdersWorkOrderId [KEY] | Long | The unique identifier for the work order associated with this operation material record. This identifier ensures correct linkage between the work order and the materials used in production. |
| WorkorderoperationWorkOrderOperationId [KEY] | Long | The unique identifier for the work order operation associated with this material. This identifier links materials to specific operation steps within the work order. |
| OrganizationId | Long | The identifier for the organization or business unit responsible for this work order operation material. This identifier supports multi-organization inventory and production tracking. |
| WorkOrderId | Long | The unique identifier for the work order. This identifier ensures accurate tracking of materials allocated to the work order operations. |
| WorkOrderOperationId | Long | The unique identifier for the work order operation. This identifierallows materials to be accurately assigned to a specific operation step in the work order process. |
| OperationSequenceNumber | Decimal | The sequence number that determines the order in which operations are performed within a work order. This number ensures that materials are allocated to the correct operation in the sequence. |
| OperationName | String | The name of the operation to which this material is assigned. This name helps in identifying where and how the material is used in the manufacturing process. |
| StandardOperationId | Long | The unique identifier for the standard operation referenced in the work order. Standard operations ensure repeatability and efficiency in manufacturing processes. |
| StandardOperationCode | String | A short code representing the standard operation. This code simplifies reference and integration with production workflows. |
| WorkAreaId | Long | The unique identifier for the work area where the operation is performed. This identifier helps in organizing material allocation based on production zones. |
| WorkAreaName | String | The name of the work area associated with this operation material. This name is useful for tracking where materials are consumed in the manufacturing process. |
| WorkCenterId | Long | The unique identifier for the work center responsible for executing this work order operation. Work centers are essential for production capacity planning. |
| WorkCenterName | String | The name of the work center where the operation is performed. This name helps ensure materials are assigned to the correct workstations. |
| WorkOrderOperationMaterialId [KEY] | Long | The unique identifier for the material assigned to this work order operation. This identifier enables tracking of specific components used in production. |
| MaterialSequenceNumber | Decimal | The sequence number assigned to the component within the operation, ensuring correct processing order of materials. |
| MaterialType | String | The type of material used in the work order operation. Common types include COMPONENT (raw materials) and PRIMARY_PRODUCT (final assembly). |
| InventoryItemId | Long | The unique identifier for the inventory item related to this operation. This identifier links materials used in the operation to inventory records for accurate stock tracking. |
| ItemNumber | String | The specific item number assigned to the material. If the material type is COMPONENT, the item number represents a raw material. If the material type is PRIMARY_PRODUCT, it represents the finished assembly. |
| ItemDescription | String | A brief description of the item assigned to this work order operation, providing additional details about its purpose and usage. |
| ItemRevision | String | The revision number of the item, indicating the version of the component or product being used in the manufacturing process. |
| QuantityPERProduct | Decimal | The quantity of this material required to manufacture each unit of the final product. This metric ensures accurate bill of materials (BOM) calculations. |
| BasisType | String | Specifies whether the material quantity is fixed (for example, 'per lot produced') or variable (for example, 'per unit produced'). Accepted values are defined in the EGP_BOM_BASIS_TYPE lookup table. |
| Quantity | Decimal | The total quantity of this material required for the work order operation, based on planned production volumes. |
| InverseQuantity | Decimal | The allocated component quantity, helping track consumption against work order requirements. |
| UOMCode | String | The unit of measure (UOM) code for the material quantity (for example, 'EA' for each or 'KG' for kilograms). |
| UnitOfMeasure | String | The full description of the unit of measure. This description ensures consistency in material tracking and consumption. |
| RequiredDate | Datetime | The date when the plant requires the material for the operation. The required date must be within the operation’s start and completion dates. |
| YieldFactor | Decimal | A factor used to adjust material requirements to account for process waste. A value between 0 and 1 accounts for expected losses, while values greater than 1 account for additional material needs. |
| IncludeInPlanningFlag | Bool | Indicates whether the material is included in supply planning. If the value is 'true', the material is considered in material requirement planning (MRP); if the value is 'false', it is excluded. |
| SupplyType | String | The supply type used for the work order operation material. Accepted values are defined in the lookup types EGP_WIP_SUP_TYPE and ORA_WIE_WO_SUPPLY_TYPE, determining how materials are sourced for production. |
| SupplyTypeDescription | String | A description of the supply type used for the work order operation material. This description explains how the material is provided to the operation (for example, 'push', 'pull', or 'manual issue'). |
| SupplySubinventory | String | The default subinventory location from which materials are drawn during assembly or operation pull. This field helps in inventory control and replenishment planning. |
| SupplyLocatorId | Long | The unique identifier for the inventory locator within the supply subinventory. This identifier ensures precise tracking of material movement within storage locations. |
| SupplyLocator | String | The specific locator within the subinventory used to withdraw material during assembly or operation pull. This locator helps manage stock at a granular level. |
| ReservedQuantity | Decimal | The quantity of material that has been reserved for this work order operation but not yet issued. This metric ensures materials are available when needed. |
| IssuedQuantity | Decimal | The total quantity of material that has been issued to this work order operation. This metric reflects actual material consumption. |
| ProducedQuantity | Decimal | The quantity of the final product that has been produced using the allocated materials for this work order operation. |
| AllocatedQuantity | Decimal | The total quantity of material allocated to this work order operation. This metric represents the planned material commitment before issuing. |
| PickedQuantity | Decimal | The total quantity of material picked from inventory for this work order operation but not yet issued or consumed. |
| RemainingAllocatedQuantity | Decimal | The remaining quantity of allocated material that has not yet been picked or issued, indicating outstanding material requirements. |
| CreatedBy | String | The username or identifier of the individual who created this work order operation material record. This identifier ensures accountability and traceability. |
| CreationDate | Datetime | The date and time when this work order operation material record was created. These metrics support audit tracking and compliance. |
| LastUpdateDate | Datetime | The date and time when this work order operation material record was last updated. These metrics help track changes in material usage and planning. |
| LastUpdatedBy | String | The username or identifier of the individual who last updated this work order operation material record, ensuring accountability for modifications. |
| SubstituteFlag | Bool | Indicates whether this material has an approved substitute. If the value is 'true', alternate materials can be used if the primary material is unavailable. |
| BackToBackFlag | String | Indicates whether this work order operation material is linked to a back-to-back order. This flag ensures direct fulfillment of demand from procurement or manufacturing. |
| ContractMfgFlag | String | Indicates whether the work order operation involves contract manufacturing. This flag support tracking of materials used in outsourced production processes. |
| DueDays | Int | The number of days remaining until the work order operation material is required. This metric helps in scheduling and inventory planning. |
| Finder | String | A search key or identifier used to quickly locate this work order operation material record in the system. |
| FirmPlannedFlag | String | Indicates whether this material requirement is firm planned, meaning it is locked and not subject to rescheduling or changes. |
| MaterialItemId | Long | The unique identifier for the material item associated with this work order operation. This identifier ensures proper tracking of material consumption. |
| PlannedCompletionDate | Datetime | The planned date and time for completing the work order operation. These metrics ensure alignment between material availability and production timelines. |
| PlannedStartDate | Datetime | The planned date and time for starting the work order operation. These metrics help in ensuring materials are available at the right time. |
| ProductSerialId | Long | The unique identifier for the serialized product associated with this work order operation material. This identifier ensures traceability in manufacturing. |
| ResourceId | Long | The unique identifier for the resource (for example, 'machine', 'tool', or 'labor') allocated to this work order operation. This identifier helps link material requirements to resource planning. |
| SerialNumber | String | The serial number assigned to the material or product being used in this operation. This serial number supports traceability in production and quality assurance. |
| SourceHeaderReferenceId | Long | The reference identifier linking this work order operation material to the source document's header (for example, a purchase order or sales order). |
| SourceHeaderRefId | Long | An alternate reference identifier for the source header. This identifier ensures compatibility with external systems or legacy integrations. |
| SourceLineReferenceId | Long | The reference identifier linking this work order operation material to a specific line item in the source document, such as a purchase-order line. |
| SourceLineRefId | Long | An alternate reference identifier for the source line. This identifier supports integration with external systems and historical tracking. |
| SourceSystemId | Long | The identifier for the external system from which this work order operation material data originates. This identifier ensures data synchronization across integrated platforms. |
| Tolerance | Int | The allowable tolerance for deviations in material usage for this work order operation. This metric helps maintain quality standards while reducing waste. |
| WoProjectNumber | String | The project number associated with this work order operation material. This number links materials to broader project tracking for cost management and reporting. |
| WorkOrderNumber | String | The unique work-order number associated with this operation material. This number provides a user-friendly reference for tracking work orders. |
| WorkOrderStatusId | Long | The current status identifier of the work order (for example, 'Planned,' 'In Progress,' or 'Completed'). This identifier ensures material allocation aligns with production progress. |
| WoTaskNumber | String | The specific task number within the work order operation that this material is assigned to. This number enables task-level tracking and material allocation. |