Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkOrdersWorkOrderDFF

Customizes tracking of work orders using descriptive flexfields, offering detailed order insights.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long The unique identifier linking the descriptive flexfield (DFF) to its associated work order. This identifier ensures DFF details are correctly mapped to the relevant work order for additional context.
WorkOrderId [KEY] Long The primary key uniquely identifying the work order. This primary key ensures traceability and accurate mapping of DFF attributes to specific work orders.
_FLEX_Context String The context name for the descriptive flexfield associated with the work order. This context name enables organizations to categorize and organize custom attributes based on their operational needs.
_FLEX_Context_DisplayValue String A user-friendly display value for the descriptive flexfield context, making it easier for users to interpret the custom attributes tied to work orders.
BackToBackFlag String Indicates whether the work order is part of a back-to-back process. This flag helps manage workflows that align production directly with customer orders.
ContractMfgFlag String Specifies whether the work order is part of a contract manufacturing process. This flag helps identify outsourced production activities.
DueDays Int The number of days remaining until the work order is due for completion. This metric helps prioritize tasks and track deadlines.
Finder String A utility field enabling advanced search and filtering capabilities for work orders with descriptive flexfields. This field helps users efficiently locate specific work order records.
FirmPlannedFlag String Indicates whether the work order is firm planned. If the value is 'true', the work order and its details are locked and not subject to changes from automated planning processes.
InventoryItemId Long The unique identifier for the inventory item associated with the work order. This identifier ensures accurate linkage between the work order and its corresponding inventory records.
ItemNumber String The unique number of the inventory item associated with the work order. This number provides a clear reference for identifying items or products.
LastUpdateDate Datetime The date and time when the descriptive flexfield details for the work order were last updated. These metrics ensure traceability and reflects recent changes.
MaterialItemId Long The unique identifier for the material item associated with the work order. This identifier ensures accurate linkage between materials and the work order.
OrganizationId Long The unique identifier for the inventory organization managing the work order. This identifier supports multi-organization workflows and ensures proper segmentation of work order records.
PlannedCompletionDate Datetime The scheduled completion date for the work order. This metric supports tracking progress and ensuring deadlines are met.
PlannedStartDate Datetime The scheduled start date for the work order. This metric helps ensure timely initiation of production or tasks.
ProductSerialId Long The unique identifier for the product serial number associated with the work order. This identifier supports detailed tracking of serialized products.
ResourceId Long The unique identifier for the resource associated with the work order. This identifier ensures proper allocation and monitoring of resources related to the work order.
SerialNumber String The serial number of the product associated with the work order. This serial number provides traceability for serialized items in the production process.
SourceHeaderReferenceId Long The unique identifier for the source header reference associated with the work order. This identifier ensures linkage to originating transactions or documents.
SourceHeaderRefId Long An alternative identifier for the source header reference. This identifier provides flexibility in integrating external systems.
SourceLineReferenceId Long The unique identifier for the source line reference associated with the work order. This identifier ensures accurate tracking of specific line items from the originating document.
SourceLineRefId Long An alternative identifier for the source line reference. This identifier supports flexible tracking and integration with external systems.
SourceSystemId Long The unique identifier for the source system that created the work order. This identifier ensures traceability across integrated systems.
Tolerance Int The allowed deviation (in days) for completing the work order. This metric defines acceptable thresholds for delays.
WoProjectNumber String The unique project number associated with the work order. This number ties work orders to specific projects for better tracking and reporting.
WorkAreaId Long The unique identifier for the work area associated with the work order. This identifier ensures proper segmentation and management of tasks by operational zones.
WorkCenterId Long The unique identifier for the work center associated with the work order. This identifier ensures proper allocation of tasks to the right work centers.
WorkOrderNumber String The unique number assigned to the work order. This number serves as a primary reference for identifying and tracking work orders in the system.
WorkOrderStatusId Long The unique identifier for the status of the work order. This identifier ensures alignment between the work order's overall status and its descriptive flexfields.
WoTaskNumber String The unique task number associated with the work order. This number provides detailed tracking of tasks within the work order.

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