CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ProcessWorkOrdersProcessWorkOrderOutput

Oversees the outputs generated by operations within a process work order, supporting production tracking.

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long The unique identifier linking the process work order to its outputs. This identifier serves as the primary reference for tracking items produced during the work order.
OrganizationId Long The unique identifier for the organization where the work order output is created, representing a specific facility or production site.
WorkOrderOperationId Long The unique identifier for the operation within the work order that generates the output. This identifier tracks production at the operation level.
OperationSequenceNumber Decimal Defines the order in which operations are performed within the work order. This value ensures proper sequencing for output generation.
OperationName String The name of the operation producing the output, such as 'Assembly,' 'Packaging,' or 'Testing.'
OperationDescription String A detailed explanation of the operation, including its purpose and expected outputs.
WorkAreaId Long The unique identifier for the work area where the operation takes place, grouping related resources and activities.
WorkAreaName String The name of the work area associated with the operation producing the output, such as 'Machining Area' or 'Assembly Line 1.'
WorkAreaCode String A shorthand code for the work area, used for quick identification within the production facility.
WorkAreaDescription String A detailed description of the work area, highlighting its capabilities and resources.
WorkCenterId Long The unique identifier for the work center where the operation is performed. A work center represents a grouping of tools, machines, or personnel.
WorkCenterCode String The code assigned to the work center where the operation occurs, aiding in efficient resource management.
WorkCenterName String The name of the work center responsible for producing the output.
WorkCenterDescription String A detailed description of the work center, including its role in the production process and resources available.
OutputSequenceNumber Decimal Indicates the sequence in which outputs are generated during the operation. This value ensures outputs are tracked in the correct order.
WorkOrderOperationOutputId [KEY] Long The unique identifier for the specific output of an operation, enabling detailed tracking of production items.
InventoryItemId Long The unique identifier for the inventory item representing the output. This identifier links the production output to inventory records.
ItemNumber String The unique number assigned to the inventory item produced by the operation, aiding in identification and traceability.
ItemDescription String A detailed description of the output item, including its characteristics and intended use.
OutputType String Specifies the type of output, such as 'Primary' or 'By-Product,' to categorize production outputs effectively.
PrimaryFlag Bool Indicates whether the output is the primary product of the operation. A value of 'true' designates the output as the main item.
OutputQuantity Decimal The planned quantity of the item to be produced during the operation, used for production and planning purposes.
CompletedQuantity Decimal The actual quantity of the item completed during the operation. This value helps track production progress and efficiency.
UOMCode String The unit of measure (UOM) code for the output, such as 'EA' (Each) or 'KG' (Kilogram), indicating how the quantity is measured.
UnitOfMeasure String The full name of the unit of measure for the output, providing additional clarity for the UOM code.
CompletionType String Defines how the completion of the output is processed, such as 'Manual' or 'Automatic.' This value impacts how production is recorded.
ComplSubinventoryCode String The code representing the subinventory where the completed output is stored, such as 'Finished Goods' or 'Raw Materials.'
ComplLocatorId Long The unique identifier for the specific locator within the subinventory where the completed output is stored.
CompletionLocator String The name or code of the specific locator for storing the completed output, such as 'Bin A1' or 'Shelf 3.'
CostAllocationBasis String Specifies how production costs are allocated to the output, such as by 'Quantity' or 'Percentage.'
CostAllocationPercentage Decimal The percentage of costs allocated to the output. This value ensures accurate cost tracking and reporting.
CreatedBy String The name or identifier of the user who created the output record. This identifier supports audit tracking and accountability.
CreationDate Datetime The date and time when the output record was created, providing a historical reference for production activities.
LastUpdateDate Datetime The date and time when the output record was last updated, ensuring changes are tracked for accuracy.
LastUpdatedBy String The name or identifier of the user who last updated the output record. This identifier ensures accountability and traceability for changes.
SecondaryQuantity Decimal Specifies the quantity of the output measured in a secondary unit of measure. This value is often used for dual-unit tracking in complex production environments.
SecondaryUOMCode String The unit of measure (UOM) code for the secondary quantity, such as 'LBS' for pounds or 'GAL' for gallons, allowing for alternative measurements.
BackToBackFlag String Indicates whether the output is part of a back-to-back manufacturing process, where the supply 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 manufacturers.
DueDays Int The number of days remaining until the work order output is due for completion, helping to monitor deadlines and track delays.
Finder String Represents the search mechanism or criteria used to locate and identify specific output records within the system.
FirmPlannedFlag String Indicates whether the output or associated work order is firm planned, which prevents changes by planning or scheduling processes.
MaterialItemId Long The unique identifier for the material item associated with the output. This identifier links the output to the raw materials or components used in production.
PlannedCompletionDate Datetime The planned date and time for completing the work order output. This identifier is a key metric for production scheduling and progress tracking.
PlannedStartDate Datetime The planned date and time for starting the production of the output. It ensures timely resource allocation and operation scheduling.
ProductSerialId Long The unique identifier for the product serial number linked to the output. This identifier enables serialized tracking of items produced in the work order.
ResourceId Long The unique identifier for the resource (for example, equipment or personnel) used to produce the output. This identifier helps link outputs to specific resources.
SerialNumber String The serial number of the output item, enabling detailed tracking and traceability for serialized products.
SourceHeaderReferenceId Long The unique identifier for the source header that links the output record to its originating transaction, such as a sales order or production plan.
SourceHeaderRefId Long An alternate unique identifier for the source header associated with the output, providing additional linkage to its origin.
SourceLineReferenceId Long The unique identifier for the source line that links the output record 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 output record, offering additional traceability.
SourceSystemId Long The unique identifier for the source system that provided the data related to the output. This identifier is critical for tracking integrations with external systems.
Tolerance Int Specifies the allowable tolerance level for the output quantity or quality. Tolerance ensures flexibility while maintaining production standards.
WoProjectNumber String The project number associated with the work order output. This identifier links the output to project-specific tasks or deliverables.
WorkOrderId Long The unique identifier for the work order associated with the output. This identifier is essential for linking outputs to specific production efforts.
WorkOrderNumber String The unique number assigned to the work order associated with the output, aiding in tracking production within broader workflows.
WorkOrderStatusId Long The unique identifier for the current status of the work order associated with the output, such as 'Open,' 'In Progress,' or 'Completed.'
WoTaskNumber String The task number within the work order associated with the output. This number enables task-level tracking of production and output delivery.

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