CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ProcessWorkOrdersProcessWorkOrderOutputOutputDFF

Customizes tracking for output materials using descriptive flexfields, offering detailed insights into operational outcomes.

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long The unique identifier linking the process work order to its descriptive flexfield (DFF) attributes for operation outputs, enabling detailed customization and tracking.
ProcessworkorderoutputWorkOrderOperationOutputId [KEY] Long The unique identifier for the specific work order operation output that is linked to descriptive flexfield attributes. This identifier ensures accurate tracking of custom attributes for the output.
WoOperationOutputId [KEY] Long The unique identifier for an output of a work order operation. It serves as a primary key generated by the application to track the output.
_FLEX_Context String The name of the descriptive flexfield (DFF) context for work order operation outputs. This name is used to define custom attributes specific to the context.
_FLEX_Context_DisplayValue String The display value or label for the descriptive flexfield (DFF) context associated with the work order operation outputs.
BackToBackFlag String Indicates whether the output is part of a back-to-back manufacturing process, where production is directly linked to specific customer demand.
ContractMfgFlag String Indicates whether the output is associated with contract manufacturing, where production tasks are outsourced to external suppliers or partners.
DueDays Int The number of days remaining until the work order output is due for completion. This number helps monitor deadlines and production timelines.
Finder String Represents the search mechanism or criteria used to locate specific operation output records within the system.
FirmPlannedFlag String Indicates whether the operation output or work order is firm planned, restricting changes to its schedule or allocation.
InventoryItemId Long The unique identifier for the inventory item associated with the operation output. This identifier links the output to inventory records for tracking and reporting.
ItemNumber String The unique number assigned to the inventory item associated with the operation output. This number aids in identification and traceability of produced items.
LastUpdateDate Datetime The date and time when the operation output or its descriptive flexfield record was last updated. These metrics provide an audit trail for changes.
MaterialItemId Long The unique identifier for the material item associated with the operation output. This identifier links the material to the specific output for accurate tracking.
OrganizationId Long The unique identifier for the organization where the operation output is produced. This identifier represents a specific facility or manufacturing site.
PlannedCompletionDate Datetime The planned date and time for completing the operation output. These metrics help in scheduling and progress tracking.
PlannedStartDate Datetime The planned date and time for starting the operation that generates the output. These metrics ensure alignment with production timelines.
ProductSerialId Long The unique identifier for the product serial number associated with the operation output. This identifier enables serialized tracking of the output items.
ResourceId Long The unique identifier for the resource (for example, equipment or personnel) used in the operation that generates the output. This identifer tracks resource usage.
SerialNumber String The serial number of the output item, enabling precise tracking and traceability of serialized products.
SourceHeaderReferenceId Long The unique identifier for the source header linking the operation output to its originating transaction, such as a sales order or production request.
SourceHeaderRefId Long An alternate unique identifier for the source header associated with the operation output, providing additional linkage to its origin.
SourceLineReferenceId Long The unique identifier for the source line linking the operation output to a specific line item in the originating document, such as a sales order line.
SourceLineRefId Long An alternate unique identifier for the source line reference associated with the operation output, offering additional traceability.
SourceSystemId Long The unique identifier for the source system that provided the data related to the operation output. This identifer us useful for tracking integrations with external systems.
Tolerance Int Defines the allowable tolerance for the associated operation output, such as acceptable variances in quantity, quality, or timing.
WoProjectNumber String The project number associated with the work order output. This number links the output to project-specific deliverables or objectives.
WorkAreaId Long The unique identifier for the work area where the operation output is generated. This identifer helps in organizing outputs by production zones.
WorkCenterId Long The unique identifier for the work center where the operation output is produced. This identifer tracks outputs at the specific location.
WorkOrderId Long The unique identifier for the work order associated with the operation output. This identifer links the output to the broader production process.
WorkOrderNumber String The unique number assigned to the work order associated with the operation output. This number aids in tracking outputs within broader workflows.
WorkOrderStatusId Long The unique identifier for the status of the work order linked to the operation output. This identifer indicates whether the work order is open, in progress, or completed.
WoTaskNumber String The task number within the work order associated with the operation output. This attribute enables task-level tracking and customization.

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