Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ProcessWorkOrdersProcessWorkOrderMaterial

Tracks and manages materials consumed during operations to process work orders, ensuring accurate material planning.

Columns

Name Type 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 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 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 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 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 The unique identifier for the material item in the inventory system, used to track material availability, location, and status.
ItemNumber String 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 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 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 Indicates whether the material is associated with contract manufacturing, where production is outsourced to an external manufacturer.
DueDays Int 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 Indicates whether the material allocation or requirement is firm planned, preventing changes by planning or scheduling processes.
MaterialItemId Long The unique identifier for the material item in the inventory system, used to track availability and usage.
PlannedCompletionDate Datetime The planned date and time when the operation or work order consuming the material is scheduled to be completed.
PlannedStartDate Datetime The planned date and time when the operation or work order consuming the material is scheduled to begin.
ProductSerialId Long The unique identifier for the product serial number associated with the material. This identifier enables serialized tracking of materials.
ResourceId Long The unique identifier for the resource (for example, machine or personnel) associated with the operation requiring the material.
SerialNumber String The serial number assigned to the material item, allowing for tracking and traceability in the manufacturing process.
SourceHeaderReferenceId Long The unique identifier for the source header that links the material record to its originating transaction or external system.
SourceHeaderRefId Long An alternate unique identifier for the source header reference associated with the material record.
SourceLineReferenceId Long The unique identifier for the source line that links the material record to a specific line item in the source document.
SourceLineRefId Long An alternate unique identifier for the source line reference associated with the material record.
SourceSystemId Long The unique identifier for the source system from which the material record or related data originates.
Tolerance Int The allowable tolerance level for the material, such as acceptable variances in quantity or quality during the operation.
WoProjectNumber String The project number associated with the work order material, used for project-specific tracking and reporting.
WorkOrderNumber String 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 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 The task number associated with the work order material, used for tracking material usage at the task level.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175