CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkOrdersWorkOrderOperationWorkOrderOperationResourceWorkOrderOperationResourceDFF

Contains descriptive flexfields for resources, providing detailed resource attributes used in operations.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long The unique identifier for the work order associated with this resource descriptive flexfield (DFF) entry. This identifier identifier ensures proper tracking of custom attributes for work order resources.
WorkorderoperationWorkOrderOperationId [KEY] Long The unique identifier for the work order operation linked to this resource DFF entry. This identifier connects custom attributes to a specific operation step.
WorkorderoperationresourceWorkOrderOperationResourceId [KEY] Long The unique identifier for the work order operation resource to which this DFF entry is linked. This identifier ensures traceability of custom attributes to resources used in production.
WoOperationResourceId [KEY] Long The unique identifier for the resource used in the work order operation. This primary key is system-generated and ensures data integrity in resource tracking.
_FLEX_Context String The descriptive flexfield (DFF) context name that defines the custom attributes or segments available for work order operation resources.
_FLEX_Context_DisplayValue String The display value of the descriptive flexfield (DFF) context for work order operation resources. This field provides a user-friendly name for the applied context.
BackToBackFlag String Indicates whether this resource is part of a back-to-back order process, where demand directly triggers a supply response to maintain operational efficiency.
ContractMfgFlag String Indicates whether the resource is part of a contract manufacturing process. This flag helps track custom attributes related to outsourced production workflows.
DueDays Int The number of days remaining until the planned completion of the work order operation resource. This metric supports scheduling and tracking of resource readiness.
Finder String A search key or identifier used to quickly locate specific work order operation resource DFF entries in the system.
FirmPlannedFlag String Indicates whether the resource requirement is firm planned, meaning it is locked and not subject to rescheduling or changes.
InventoryItemId Long The unique identifier for the inventory item associated with the resource. This identifier helps link custom attributes to material tracking and usage.
ItemNumber String The specific item number assigned to the resource or material. This number ensures proper traceability in inventory and production processes.
LastUpdateDate Datetime The date and time when this resource DFF entry was last updated. These metrics ensure visibility into recent changes and supports audit tracking.
MaterialItemId Long The unique identifier for the material linked to this work order operation resource. This identifier ensures traceability of materials and their associated custom attributes.
OrganizationId Long The identifier for the organization or business unit responsible for the work order operation resource DFF entry. This identifier supports multi-organization tracking.
PlannedCompletionDate Datetime The planned date and time for completing the work order operation resource. Custom attributes might define specific milestones or requirements for resource completion.
PlannedStartDate Datetime The planned date and time for starting the work order operation resource. Custom attributes might define specific constraints or requirements for resource activation.
ProductSerialId Long The unique identifier for the serialized product associated with the work order operation resource. This identifier helps track serialized materials used in production.
ResourceId Long The unique identifier for the resource (for example, 'machine', 'tool', or 'labor') used in the work order operation. This identifier connects custom attributes to resource usage.
SerialNumber String The serial number assigned to the resource or product associated with this operation. This serial number supports traceability and compliance in serialized inventory tracking.
SourceHeaderReferenceId Long The reference identifier linking this work order operation resource DFF entry to the source document's header, such as a purchase order or project plan.
SourceHeaderRefId Long An alternate reference identifier for the source header. This identifier ensures compatibility with external systems or legacy applications.
SourceLineReferenceId Long The reference identifier linking this resource DFF entry to a specific line item in the source document, such as a purchase-order line.
SourceLineRefId Long An alternate reference identifier for the source line. This identifier supports integration with external systems and historical tracking.
SourceSystemId Long The identifier for the external system from which this work order operation resource DFF data originates. This identifier ensures proper synchronization across platforms.
Tolerance Int The allowable tolerance for variations in resource usage or operational parameters. Custom attributes might define acceptable limits or special handling instructions.
WoProjectNumber String The project number associated with the work order operation resource. This number links custom attributes to broader project tracking and reporting.
WorkAreaId Long The unique identifier for the work area associated with the work order operation resource. This identifier ensures proper tracking of resource-related custom attributes by location.
WorkCenterId Long The unique identifier for the work center where the resource is used. Custom attributes might define specific work center requirements or constraints.
WorkOrderId Long The unique identifier for the work order associated with this resource DFF entry. This identifier links all custom attributes to the overarching production job.
WorkOrderNumber String The user-friendly work-order number associated with this resource DFF entry. This number helps reference and retrieve custom attributes easily.
WorkOrderStatusId Long The identifier for the current status of the work order (for example, 'Planned,' 'In Progress,' or 'Completed'). Custom attributes might provide additional status-related details.
WoTaskNumber String The specific task number within the work order operation to which this resource DFF entry is linked. This number enables task-level tracking of custom attributes.

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