ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkOrdersProjectDetailsDFF

Tracks project costing attributes for work orders using customizable descriptive flexfields.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long The unique identifier linking this descriptive flexfield (DFF) record to the associated work order in the WorkOrders schema. This identifier ensures all project details are correctly tied to the relevant work order.
WorkOrderId [KEY] Long The primary key uniquely identifying the work order. This primary key is system-generated when the work order is created and is associated with features that require specific opt-in, ensuring traceability and alignment with project workflows.
_FLEX_Context String The descriptive flexfield (DFF) context name for work order project details. This field categorizes custom attributes based on operational or project-specific needs, enabling flexible customization.
_FLEX_Context_DisplayValue String User-friendly display value for the descriptive flexfield context. This value makes it easier for users to interpret the context of custom attributes associated with work orders.
BackToBackFlag String Indicates whether the work order is tied to a back-to-back process. This flag is critical for identifying work orders that depend on direct supply or demand alignment, such as customer-driven production.
ContractMfgFlag String Specifies whether the work order involves contract manufacturing. This flag helps distinguish work orders managed internally from those executed by external contractors.
DueDays Int The number of days remaining until the work order is due. This metric helps prioritize work orders based on urgency, ensuring timely completion.
Finder String A utility field enabling advanced search and filtering capabilities for descriptive flexfield records linked to work orders. This field helps users quickly locate specific records based on custom attributes or other criteria.
FirmPlannedFlag String Indicates whether the work order is firm planned. A firm planned work order is 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 that materials or products are correctly tied to the work order.
ItemNumber String The unique item number associated with the work order. This number provides a clear reference to the item being manufactured or processed.
LastUpdateDate Datetime The date and time when the work order's descriptive flexfield attributes were last updated. These metrics ensure traceability and reflects the most recent changes.
MaterialItemId Long The unique identifier for the material item required by the work order. This identifier ensures that materials are properly linked to their respective work orders for accurate tracking and planning.
OrganizationId Long The unique identifier for the organization managing the work order. This identifier ensures that project details are segmented by organizational units, supporting multi-organization workflows.
PlannedCompletionDate Datetime The scheduled completion date for the work order. This date is critical for tracking progress and ensuring that deadlines are met.
PlannedStartDate Datetime The scheduled start date for the work order. This date helps in aligning resources and materials to kick off the production or project on time.
ProductSerialId Long The unique identifier for the product serial number associated with the work order. This identifier ensures traceability of serialized products throughout the production process.
ResourceId Long The unique identifier for the resource associated with the work order (for example, 'machine', 'tool', or 'personnel'). This identifier supports resource planning and allocation.
SerialNumber String The serial number associated with the work order. This serial number provides detailed tracking for serialized items, especially in industries with strict traceability requirements.
SourceHeaderReferenceId Long The unique identifier for the source header reference associated with the work order. This identifier helps in linking work orders to their originating documents or transactions.
SourceHeaderRefId Long An alternative identifier for the source header reference, providing flexibility in tracking and integration with external systems.
SourceLineReferenceId Long The unique identifier for the source line reference associated with the work order. This identifier ensures accurate linking to specific line items from the originating document.
SourceLineRefId Long An alternative identifier for the source line reference, supporting flexible tracking of work order origins.
SourceSystemId Long The unique identifier for the source system that created the work order. This identifier supports integration with external systems and ensures traceability across platforms.
Tolerance Int The allowed deviation (in days) for the work order's planned completion date. This metric ensures that delays within the tolerance range are considered acceptable.
WoProjectNumber String The unique project number associated with the work order. This project 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 identifierproper segmentation of work orders by operational zones.
WorkCenterId Long The unique identifier for the work center where the work order is executed. This identifier helps allocate and monitor resources at the work center level.
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 field tracks whether the work order is active, completed, on hold, or canceled.
WoTaskNumber String The unique task number associated with the work order. This number ensures detailed tracking of tasks within a work order for better project management.

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