Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ProcessWorkOrdersProcessWorkOrderDFF

Manages detailed and customizable descriptive flexfields associated with process work orders, allowing tailored data tracking.

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long The unique identifier linking the process work order with its descriptive flexfield (DFF) attributes.
WorkOrderId [KEY] Long The unique identifier for the work order. This value is a primary key generated by the application when the work order is created.
_FLEX_Context String The name of the descriptive flexfield (DFF) context for work orders, used to group related flexfield segments.
_FLEX_Context_DisplayValue String The display value or label for the flexfield context segment associated with the work order.
BackToBackFlag String Indicates whether the work order is part of a back-to-back manufacturing process, directly connecting supply and demand.
ContractMfgFlag String Indicates whether the work order involves contract manufacturing, where production is outsourced to a third-party manufacturer.
DueDays Int The number of days remaining until the work order is due for completion.
Finder String Represents the search mechanism or criteria used to locate and identify the work order within the system.
FirmPlannedFlag String Indicates whether the work order is firm planned, meaning it is locked from changes by scheduling or planning processes.
InventoryItemId Long The unique identifier for the inventory item associated with the work order, used to track materials or finished goods.
ItemNumber String The unique number assigned to the inventory item associated with the work order.
LastUpdateDate Datetime The date and time when the descriptive flexfield or its attributes were last updated.
MaterialItemId Long The unique identifier for the material item used in the work order, typically representing raw materials or components.
OrganizationId Long The unique identifier for the organization where the work order is executed, representing a specific facility or inventory location.
PlannedCompletionDate Datetime The planned date and time for the work order's completion, as determined by the scheduling application.
PlannedStartDate Datetime The planned date and time for the work order's start, as determined by the scheduling application.
ProductSerialId Long The unique identifier for the product serial number associated with the work order, enabling serialized tracking of finished goods or components.
ResourceId Long The unique identifier for the resource (for example, equipment or personnel) associated with the work order.
SerialNumber String The serial number assigned to the product or component being tracked in the work order.
SourceHeaderReferenceId Long The unique identifier for the source header that links the work order to its originating transaction or external system.
SourceHeaderRefId Long Alternate unique identifier for the source header reference associated with the work order.
SourceLineReferenceId Long The unique identifier for the source line that links the work order to a specific line item in the source document.
SourceLineRefId Long Alternate unique identifier for the source line reference associated with the work order.
SourceSystemId Long The unique identifier for the source system from which the work order or related data originates.
Tolerance Int The allowable tolerance level for the work order, such as variances in material quantities or production time.
WoProjectNumber String The project number associated with the work order, used for project-specific tracking and reporting.
WorkAreaId Long The unique identifier for the work area where the work order is executed. Work areas group resources within the manufacturing facility.
WorkCenterId Long The unique identifier for the work center where work order operations occur. This identifier tracks the specific area or equipment used.
WorkOrderNumber String The unique number assigned to the work order. This number helps identify and track the work order within the organization.
WorkOrderStatusId Long The unique identifier for the status of the work order. Statuses indicate whether the work order is open, in progress, or completed.
WoTaskNumber String The task number associated with the work order, used to track specific tasks within the broader work order.

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