CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ProcessWorkOrdersProjectDetailsDFF

Customizes project costing attributes for work orders using descriptive flexfields, supporting advanced project tracking.

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long The unique identifier for the process work order, linking it to the project details for reporting and tracking purposes.
WorkOrderId [KEY] Long The primary key generated by the application to uniquely identify the work order. This key is essential for linking project details and is part of an opt-in feature.
_FLEX_Context String The descriptive flexfield context name associated with the work order project details, allowing for customization and context-specific attributes.
_FLEX_Context_DisplayValue String A human-readable display value of the descriptive flexfield context for work order project details, enabling better user interpretation. This attribute requires opt-in.
BackToBackFlag String Indicates whether the work order is part of a back-to-back manufacturing or fulfillment process, directly tied to customer demand.
ContractMfgFlag String A flag that specifies if the work order involves contract manufacturing, where production is outsourced to external suppliers.
DueDays Int The number of days remaining until the work order is due for completion, assisting in production scheduling and deadline tracking.
Finder String A utility field used to locate or identify specific work order project details within the system.
FirmPlannedFlag String Indicates whether the work order is firmly planned, signaling its readiness for execution or inclusion in the production schedule.
InventoryItemId Long The unique identifier for the inventory item associated with the work order, linking project details to inventory management.
ItemNumber String The unique number or code assigned to the inventory item, used to identify the product or material associated with the work order.
LastUpdateDate Datetime The timestamp of the most recent update to the work order project details, ensuring that the latest information is reflected in the system.
MaterialItemId Long The identifier for the material item associated with the work order, allowing for accurate tracking of material usage.
OrganizationId Long The unique identifier for the organization responsible for managing the work order, aiding in organizational-level analysis and reporting.
PlannedCompletionDate Datetime The scheduled date and time for completing the work order, providing a timeline for project delivery.
PlannedStartDate Datetime The scheduled date and time for starting the work order, essential for resource allocation and project scheduling.
ProductSerialId Long The identifier for the serialized product being manufactured, ensuring traceability and quality control.
ResourceId Long The unique identifier for the resource (for example, 'tool', 'machine', or 'labor') used in the work order, tying it to project-specific details.
SerialNumber String The serial number of the resource or product associated with the work order, enabling detailed tracking and management.
SourceHeaderReferenceId Long The reference identifier for the source header (for example, 'sales order') linked to the work order, ensuring traceability across related documents.
SourceHeaderRefId Long An alternate reference for the source header, providing flexibility for integrations with external systems.
SourceLineReferenceId Long The reference identifier for the specific line in the source document (for example, 'sales-order line'), enabling detailed tracking of dependencies.
SourceLineRefId Long An alternate reference for the source line, supporting integration and reconciliation with external systems.
SourceSystemId Long The identifier for the external system generating or managing the work order, facilitating accurate data synchronization and traceability.
Tolerance Int Specifies the allowable tolerance for variations in resource usage or production quality, ensuring adherence to project standards.
WoProjectNumber String The project number associated with the work order, linking it to broader project tracking and costing structures.
WorkAreaId Long The unique identifier for the work area (for example, 'production floor' or 'department') where the work order is executed, aiding in resource allocation and reporting.
WorkCenterId Long The identifier for the work center (for example, a specific machine group or production unit) managing the work order operation, ensuring clarity in operations.
WorkOrderNumber String The unique number assigned to the work order for easy identification and tracking in the system.
WorkOrderStatusId Long The unique identifier for the current status of the work order, providing an accurate view of its progress within the workflow.
WoTaskNumber String The specific task number associated with the work order, breaking down the work into manageable and traceable steps.

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