CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstanceWOOperationResourceInstanceDFF

Stores customizable descriptive flexfields for detailed information about resource instances in operations.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long The unique identifier for the work order associated with this resource instance. This identifier ensures accurate tracking of work orders in the system.
WorkorderresourceWorkOrderOperationResourceId [KEY] Long The unique identifier linking this resource instance to a specific operation within a work order. This identifier helps manage and allocate resources effectively.
WorkorderoperationresourceinstanceWorkOrderOperationResourceInstanceId [KEY] Long The unique identifier for a specific resource instance used within a work order operation. This identifier tracks the utilization of individual resource instances.
WoOpResourceInstanceId [KEY] Long A primary key that uniquely identifies the resource instance for the work order operation. This primary key is essential for tracking specific instances of work resources.
_FLEX_Context String Descriptive flexfield context name for work order operation resource instances. This field provides flexibility for additional attributes.
_FLEX_Context_DisplayValue String A user-friendly display value for the descriptive flexfield context. This value improves readability in user interfaces.
BackToBackFlag String Indicates whether this resource instance is part of a back-to-back manufacturing process. This flag ensures supply-demand synchronization.
ContractMfgFlag String Indicates whether this resource instance is used in contract manufacturing operations. This flag ensures proper tracking of outsourced production resources.
DueDays Int The number of days remaining before the planned due date of the operation associated with this resource instance.
Finder String A search key or identifier for locating this specific work order resource instance in the system.
FirmPlannedFlag String Indicates whether the resource planning is firm and locked from changes. This flag ensures stability in scheduling.
InventoryItemId Long The unique identifier for the inventory item associated with this resource instance. This identifier supports accurate tracking of inventory-related operations.
ItemNumber String Identifies the specific item associated with this resource instance, providing better traceability in work orders.
LastUpdateDate Datetime A timestamp indicating when this resource instance record was last modified. This timestamp ensures auditability.
MaterialItemId Long The unique identifier for the material linked to this resource instance. This identifier ensures accurate allocation in work orders.
OrganizationId Long The identifier for the organization managing this resource instance. This identifier supports multi-organization setups and resource allocation.
PlannedCompletionDate Datetime The scheduled completion date for the operation using this resource instance. This metric helps in production scheduling.
PlannedStartDate Datetime The scheduled start date for the operation utilizing this resource instance. This metric ensures alignment with production planning.
ProductSerialId Long The unique identifier for the serialized product associated with this resource instance. This identifier supports serialization tracking.
ResourceId Long The unique identifier for the resource linked to this instance. This identifier is essential for accurate tracking of work order resources.
SerialNumber String The serial number of the product or material assigned to this resource instance. This serial number ensures traceability of serialized items.
SourceHeaderReferenceId Long A reference identifier linking this resource instance to the source document header, such as a purchase order or production plan.
SourceHeaderRefId Long An alternative reference identifier for the source document header. This identifier ensures system compatibility.
SourceLineReferenceId Long A reference identifier linking this resource instance to a specific line item in the source document. This identifier ensures traceability at a granular level.
SourceLineRefId Long An alternative reference identifier for the source line. This identifier ensures seamless integration with external systems.
SourceSystemId Long The unique identifier for the external system from which this resource instance data originates. This identifier supports data synchronization between platforms.
Tolerance Int The permissible variation in resource allocation for this instance. This metric ensures flexibility in operations while maintaining quality.
WoProjectNumber String The project number associated with this resource instance, linking it to broader project tracking efforts.
WorkAreaId Long The unique identifier for the work area where this resource instance is used. This identifier helps in resource allocation within production zones.
WorkCenterId Long The unique identifier for the work center linked to this resource instance. This identifier is essential for managing and optimizing resource assignments.
WorkOrderId Long The unique identifier for the work order associated with this resource instance. This identifier ensures proper linkage between resources and production jobs.
WorkOrderNumber String A user-friendly identifier for the work order associated with this resource instance. This identifier simplifies production tracking.
WorkOrderStatusId Long A status identifier representing the current state of the work order linked to this resource instance (for example, 'Planned' or 'In Progress').
WoTaskNumber String The specific task number within the work order associated with this resource instance. This number links resources to detailed tasks within the operation.

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