CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ProcessWorkOrdersProcessWorkOrderMaterialMaterialDFF

Enables detailed tracking of input materials with customizable descriptive flexfields for enhanced operational insights.

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long The unique identifier linking the process work order to its associated descriptive flexfield (DFF) attributes for materials. This identifier ensures that work order-specific custom attributes are accurately tracked and managed.
ProcessworkordermaterialWorkOrderOperationMaterialId [KEY] Long The unique identifier for the work order operation material record within the descriptive flexfield (DFF). This field links materials to work order processes for detailed tracking and reporting.
WoOperationMaterialId [KEY] Long A system-generated primary key uniquely identifying the material used in a work order operation. This primary key supports traceability and integration with inventory management.
_FLEX_Context String Specifies the descriptive flexfield (DFF) context, enabling organizations to define and capture additional attributes specific to their business processes within the work order framework.
_FLEX_Context_DisplayValue String A user-friendly display label for the descriptive flexfield (DFF) context, improving usability and making it easier to interpret custom attributes for work orders.
BackToBackFlag String Indicates whether the material is sourced through a back-to-back process, where customer demand directly triggers procurement or production to fulfill the order.
ContractMfgFlag String Specifies whether the material is managed under a contract manufacturing agreement, where external suppliers are responsible for production or assembly on behalf of the company.
DueDays Int Represents the number of days remaining before the material or work order reaches its scheduled due date. This metric supports production planning and task prioritization.
Finder String A system-generated search key facilitating quick retrieval of descriptive flexfield (DFF) records for work order materials within business applications.
FirmPlannedFlag String Indicates whether the material allocation in the work order is firm-planned, meaning it is locked from modifications by automated scheduling or planning processes.
InventoryItemId Long The unique identifier linking the material to the inventory master record. This identifier ensures accurate tracking and availability of materials in the supply chain.
ItemNumber String A structured identifier for the inventory item associated with the work order. This identifier is used for tracking, procurement, and inventory control.
LastUpdateDate Datetime The timestamp of the most recent update to the descriptive flexfield (DFF) record. This timestamp ensures auditability of changes in work order material records.
MaterialItemId Long The unique identifier for the material item recorded in the descriptive flexfield (DFF). This identifier supports detailed tracking of production components and raw materials.
OrganizationId Long The unique identifier of the organization or business unit responsible for executing the work order. This identifier ensures proper alignment of production and resource allocation.
PlannedCompletionDate Datetime The scheduled completion date and time for the work order or material-related task. These metrics ensure adherence to production timelines and fulfillment commitments.
PlannedStartDate Datetime The scheduled start date and time for the work order or material-related task. These metrics ensure timely allocation of resources and materials.
ProductSerialId Long The unique identifier linking the work order material to a serialized product This identifier supports traceability, warranty claims, and regulatory compliance.
ResourceId Long The unique identifier for the resource assigned to the work order material, such as the machinery, tools, or personnel required for production.
SerialNumber String A unique serial number assigned to the work order material. This serial number supports precise tracking and traceability of individual units in inventory and production.
SourceHeaderReferenceId Long A reference identifier linking the descriptive flexfield (DFF) record to an external transaction such as a purchase order, inventory transfer, or sales order.
SourceHeaderRefId Long An alternative reference identifier for the source transaction header associated with the descriptive flexfield (DFF) record. This identifier aids in external integrations and traceability.
SourceLineReferenceId Long The unique identifier linking the work order material to a specific line item in the source transaction (such as a purchase-order line, sales-order line, or inventory movement).
SourceLineRefId Long An alternative reference identifier for the source document line associated with the work order material. This identifier facilitates external integrations and reconciliation.
SourceSystemId Long The unique identifier for the external system that provided the work order material data. This identifier ensures traceability for integrations with third-party applications and legacy systems.
Tolerance Int Defines the permissible variance in material consumption or production for the work order. This metric allows for slight deviations in quantity or specifications during manufacturing.
WoProjectNumber String The project number associated with the work order material. This number enables project-based tracking and cost allocation within the production process.
WorkAreaId Long The unique identifier for the work area where the work order operation is executed. This identifier defines the physical or logical zones in the manufacturing facility.
WorkCenterId Long The unique identifier for the work center responsible for executing the work order operation. This identifier represents a group of machines, labor, or production cells dedicated to specific tasks.
WorkOrderId Long The system-generated identifier assigned to the work order. This identifier serves as the primary key for tracking production, maintenance, and resource planning.
WorkOrderNumber String A structured number assigned to the work order. This number is used for managing and tracking production, maintenance, and material consumption within the business workflow.
WorkOrderStatusId Long The unique identifier representing the current status of the work order, such as 'Open', 'Released', 'Completed', or 'Canceled'. This identifier ensures visibility into production progress.
WoTaskNumber String The specific task number associated with the work order. This number links material usage to individual steps in the manufacturing or maintenance workflow.

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