CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ProcessWorkOrdersProcessWorkOrderResourceResourceDFF

Enhances resource tracking through customizable descriptive flexfields, supporting tailored data management.

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long The unique identifier linking the process work order to its descriptive flexfield (DFF) attributes for resources, enabling detailed customization and tracking.
ProcessworkorderresourceWorkOrderOperationResourceId [KEY] Long The unique identifier for the specific resource within the work order operation, associated with its descriptive flexfield (DFF) attributes.
WoOperationResourceId [KEY] Long The unique identifier for a resource of a work order operation. This identifier is a primary key generated by the application for accurate tracking of resources.
_FLEX_Context String The descriptive flexfield context name for work order operation resources, defining custom attributes relevant to the resource.
_FLEX_Context_DisplayValue String The display value or label for the descriptive flexfield context associated with the work order operation resource.
BackToBackFlag String Indicates whether the resource is part of a back-to-back process, where the resource allocation is tied directly to customer-specific demand.
ContractMfgFlag String Indicates whether the resource is associated with contract manufacturing, where operations are outsourced to external suppliers or partners.
DueDays Int The number of days remaining until the resource is required for the operation. This value supports scheduling and planning resource allocation effectively.
Finder String Represents the search mechanism or criteria used to locate specific work order operation resource records within the system.
FirmPlannedFlag String Indicates whether the resource allocation or its descriptive flexfield is firm planned, preventing changes by planning or scheduling tools.
InventoryItemId Long The unique identifier for the inventory item associated with the resource. This identifier links the inventory record to the resource for tracking and reporting.
ItemNumber String The unique number assigned to the inventory item associated with the resource. This number provides a simple reference for material tracking.
LastUpdateDate Datetime The date and time when the resource record or its descriptive flexfield was last updated. These metrics ensure traceability for changes.
MaterialItemId Long The unique identifier for the material item associated with the resource, allowing linkage between materials and their corresponding resources.
OrganizationId Long The unique identifier for the organization where the work order resource is used. This identifier represents the specific manufacturing or production facility.
PlannedCompletionDate Datetime The planned date and time for completing the operation involving the resource. These metrics help align resource usage with production schedules.
PlannedStartDate Datetime The planned date and time for starting the operation involving the resource. These metrics ensure timely allocation and usage of resources.
ProductSerialId Long The unique identifier for the product serial number associated with the resource. This identifier enables serialized tracking of items linked to the resource.
ResourceId Long The unique identifier for the resource associated with the descriptive flexfield. This identifier tracks which resource is linked to custom attributes.
SerialNumber String The serial number of the resource or item associated with the work order. This serial number provides precise tracking and traceability.
SourceHeaderReferenceId Long The unique identifier for the source header linking the resource or its descriptive flexfield to its originating transaction, such as a sales order.
SourceHeaderRefId Long An alternate unique identifier for the source header associated with the resource. This identifier provides additional traceability to upstream systems.
SourceLineReferenceId Long The unique identifier for the source line linking the resource or its descriptive flexfield to a specific line item in the originating transaction.
SourceLineRefId Long An alternate unique identifier for the source line associated with the resource. This identifier offers additional traceability for resource transactions.
SourceSystemId Long The unique identifier for the source system providing data related to the resource or its descriptive flexfield. This identifier is useful for tracking integrations.
Tolerance Int The allowable tolerance for the resource or its usage. This value helps manage acceptable variances in operations or scheduling.
WoProjectNumber String The project number associated with the work order resource. This number links the resource to specific project-related deliverables or objectives.
WorkAreaId Long The unique identifier for the work area where the resource is used. This identifier helps organize resources by physical or functional zones.
WorkCenterId Long The unique identifier for the work center where the resource is used. This identifier tracks resource usage within a specific production location.
WorkOrderId Long The unique identifier for the work order associated with the resource or its descriptive flexfield. This identifer links the resource to the overall production process.
WorkOrderNumber String The unique number assigned to the work order associated with the resource. This number aids in tracking resources within the broader workflow.
WorkOrderStatusId Long The unique identifier for the status of the work order linked to the resource. This identifier indicates whether the work order is 'Open,' 'In Progress,' or 'Completed.'
WoTaskNumber String The task number within the work order associated with the resource. This attribute enables task-level tracking of resource usage and customization.

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