Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkOrdersWorkOrderMaterialWorkOrderOperationMaterialDFF

Stores descriptive flexfields for materials processed during work order operations, offering customizable details for material tracking.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long A unique identifier for the work order, linking materials, operations, and resources within the WorkOrdersWorkOrderMaterialWorkOrderOperationMaterialDFF table. This identifier ensures traceability and accurate tracking of production and maintenance activities.
WorkordermaterialWorkOrderOperationMaterialId [KEY] Long A unique identifier for the material assigned to a specific work order operation. This identifier ties materials to their respective work order steps, ensuring precise consumption tracking.
WoOperationMaterialId [KEY] Long The system-generated primary key for the material assigned to a work order operation. This primary key uniquely identifies each material entry and supports traceability throughout the production process.
_FLEX_Context String The descriptive flexfield (DFF) context name associated with work order operation materials. This field enables flexible data capture to support business-specific requirements.
_FLEX_Context_DisplayValue String The display value of the descriptive flexfield (DFF) context for work order operation materials. This value provides a user-friendly representation of the context.
BackToBackFlag String Indicates whether the material is part of a back-to-back fulfillment process, where demand from a sales order triggers direct procurement or manufacturing.
ContractMfgFlag String Specifies whether the material is involved in a contract manufacturing arrangement, where production is outsourced to a third-party manufacturer.
DueDays Int The number of days remaining before the material is due for use in the work order operation. This metric helps in scheduling and supply chain planning.
Finder String A searchable reference used to locate and retrieve work order material records within the system.
FirmPlannedFlag String Indicates whether the material allocation is firm planned, meaning that the quantity is locked and not subject to automated adjustments.
InventoryItemId Long The unique identifier for the inventory item associated with this work order operation. This identifier links the material to inventory tracking and stock management systems.
ItemNumber String A unique part number assigned to the inventory item used in the work order operation. This part number ensures consistency in material identification and tracking.
LastUpdateDate Datetime The timestamp of the last update made to the work order material record. This timestamp helps maintain audit trails and track changes over time.
MaterialItemId Long A unique identifier for the specific material item used in the work order operation. This identifier ties the material to its corresponding inventory record.
OrganizationId Long The identifier for the organization responsible for managing the work order and its associated materials. This identifier ensures materials are assigned to the correct business unit or plant.
PlannedCompletionDate Datetime The scheduled completion date for the work order operation involving this material. This metric supports production planning and ensures timely execution of tasks.
PlannedStartDate Datetime The scheduled start date for the work order operation where this material is used. This metric ensures materials are available before production begins.
ProductSerialId Long The unique identifier for the serialized product associated with this work order material. This identifier supports traceability, warranty tracking, and regulatory compliance.
ResourceId Long The identifier linking the material to a specific resource, such as a machine, tool, or labor unit. This identifier aids in resource allocation and capacity planning.
SerialNumber String The unique serial number assigned to the material item, enabling individual tracking and traceability throughout the production lifecycle.
SourceHeaderReferenceId Long A reference identifier linking the material to an external source document, such as a purchase order or transfer order.
SourceHeaderRefId Long An alternative identifier referencing the source document that provided the material for the work order operation.
SourceLineReferenceId Long The unique identifier linking the material to a specific line item within the source document. This identifier ensures traceability of material sources.
SourceLineRefId Long An alternative identifier referencing the specific line item within the source document. This identifier helps maintain visibility into material transactions.
SourceSystemId Long The identifier for the external system that provided data for this work order material. This identifier is used in integrations and cross-system data reconciliation.
Tolerance Int Defines the allowable variance in material consumption for the work order operation. This setting ensures production flexibility while maintaining quality control.
WoProjectNumber String The project number associated with the work order. This number links the work order to broader project tracking and financial management processes.
WorkAreaId Long A unique identifier for the work area where the operation takes place. Work areas define logical or physical sections within a manufacturing plant or maintenance facility.
WorkCenterId Long The unique identifier for the work center responsible for executing the operation. Work centers group machines, labor resources, or production cells assigned to specific tasks.
WorkOrderId Long A unique identifier for the work order, linking the material records to the corresponding work order. This identifier ensures traceability and proper allocation of resources in the production or maintenance workflow.
WorkOrderNumber String The unique number assigned to the work order. This number facilitates tracking, reporting, and visibility into manufacturing or maintenance activities.
WorkOrderStatusId Long A unique identifier representing the current status of the work order (for example, 'Open', 'Released', 'Completed', or 'Canceled'). This status helps monitor work order progress and execution.
WoTaskNumber String The task number associated with the work order. This number links material usage to specific job tasks within a larger project or work breakdown structure. This aids in task-level tracking and accountability.

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