ProcessWorkOrdersOperation
Handles operations for processing manufacturing work orders, tracking resources and outputs.
Columns
| Name | Type | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier that links a specific process work order with its corresponding operations. This value establishes a relationship between the work order header and the operations within that order, allowing tracking and execution of the operations. |
| OrganizationId | Long | The unique identifier for the inventory organization where the operation is performed. The inventory organization represents a distinct manufacturing or storage facility within the enterprise, which is enabled for tracking operations, materials, and resources. |
| WorkOrderId | Long | The unique identifier generated by the application for the work order during its creation. This value serves as the primary key for referencing the work order across different tables and processes. |
| WorkOrderNumber | String | The unique, user-defined or system-generated number assigned to the work order. This number allows tracking and managing work orders within the organization. |
| WorkOrderOperationId [KEY] | Long | The unique identifier for each specific operation within the work order. This value helps differentiate between multiple operations under the same work order and serves as a reference for operation-specific details and tracking. |
| OperationSequenceNumber | Decimal | The sequence number indicating the order in which operations should be performed within the work order. This value ensures that operations are executed in the correct order as defined in the work order or work definition. |
| OperationName | String | The name assigned to the operation being performed in the work order, such as 'Cutting,' 'Assembling,' or 'Packaging.' This name helps identify the purpose and nature of the operation. |
| OperationDescription | String | A detailed explanation of the operation, including its purpose, inputs, and expected outputs (for example, 'Assembling components into finished goods, including inspection and quality checks.'). |
| OperationType | String | Defines the category or type of the operation being performed, such as manufacturing, inspection, or transportation. The accepted values are pre-defined in the lookup type ORA_WIS_OPERATION_TYPE. |
| OperationTypeDescription | String | A detailed description of the operation type, providing additional context about its function (for example, 'A manufacturing operation that includes assembly and quality inspection steps.'). |
| StandardOperationId | Long | The unique identifier for a predefined standard operation that is referenced in the work order. Standard operations are typically reusable templates for common tasks performed across work orders. |
| StandardOperationCode | String | Abbreviation or short code representing the standard operation (for example, 'ASSY' for 'Assembly' or 'INS' for 'Inspection'). |
| StandardOperationName | String | The full name of the standard operation referenced in the work order, such as 'Final Assembly' or 'Quality Inspection.' |
| WorkAreaId | Long | The unique identifier for the work area where the operation is performed. A work area is a logical grouping of resources within a manufacturing plant that supports specific operations. |
| WorkAreaCode | String | Code representing the work area, used as a shorthand reference for operations or reporting purposes (for example, 'WA-01' for 'Assembly Line 1'). |
| WorkAreaName | String | The name of the work area where the operation is carried out (for example, 'Assembly Line 1' or 'Painting Booth'). |
| WorkAreaDescription | String | A detailed description of the work area, including its purpose, layout, and any specific resources or capabilities available within the area. |
| WorkCenterId | Long | The unique identifier for the work center where the operation is performed. A work center is a physical or logical grouping of machines, tools, or personnel used to perform operations. |
| WorkCenterCode | String | Code representing the work center, often used for reporting or tracking purposes (for example, 'WC-01' for 'Welding Center 1'). |
| WorkCenterName | String | The name of the work center where the operation is performed (for example,'Welding Center' or 'Drilling Machine Area'). |
| WorkCenterDescription | String | A detailed description of the work center, including the types of machines, tools, or personnel present and the types of operations performed. |
| OSPItemId | Long | The unique identifier for the outside-processing (OSP) item associated with the operation. Outside-processing items are materials or parts sent to an external supplier for processing and returned for integration into the work order. |
| OSPItemNumber | String | The number assigned to the outside-processing item, used for tracking and managing these items within the system. |
| OSPItemDescription | String | A detailed description of the outside-processing item, including its characteristics, intended use, and the processing it undergoes at the supplier. |
| SupplierId | Long | The unique identifier for the supplier providing outside-processing services for the operation. This value allows tracking and associating specific operations with the corresponding supplier. |
| SupplierName | String | The name of the supplier providing outside-processing services (for example, 'ABC Metalworks' or 'Global Precision Parts'). |
| SupplierSiteId | Long | The unique identifier for the specific site of the supplier where the processing occurs. This identifier allows tracking of multi-site suppliers and the exact location of the service. |
| SupplierSiteCode | String | Code representing the supplier site, often used for quick reference or reporting purposes. |
| SupplierSiteDescription | String | A detailed description of the supplier site, including its location, capabilities, and any other relevant details about the site providing the outside-processing services. |
| FixedLeadTime | Decimal | The fixed amount of lead time required to perform this outside-processing operation, regardless of the quantity of items processed. |
| VariableLeadTime | Decimal | The lead time required to perform this outside-processing operation for each unit of the outside-processing item. This time is added to the fixed lead time to calculate the total processing duration. |
| LeadTimeUOM | String | Abbreviation that identifies the unit of measure for the lead time (for example, 'Days' or 'Hours'). |
| LeadTimeUnitOfMeasure | String | The unit of measure associated with the lead time, specifying how the time is quantified. |
| CountPointOperationFlag | Bool | Indicates whether this operation is a count-point operation. A value of 'true' means the operation must be completed manually. Count-point operations are used to track progress, and the last operation in a work order should always be a count-point operation. This attribute does not have a default value. |
| AutoTransactFlag | Bool | Indicates whether the operation is automatically reported. If the value is 'true', resources and materials are automatically charged based on predefined setups. If the value is 'false', the operation must be reported manually. The CountPointOperationFlag attribute and the AutoTransactFlag attribute cannot both be true simultaneously. |
| ResequenceFlag | Bool | Indicates whether the work order has resequenced operations. A value of 'true' means operations have been resequenced, while a value of 'false' indicates no resequencing. This feature requires opt-in configuration. |
| ExecutionSequence | Decimal | Specifies the sequence in which this operation is executed within the work order. |
| PORequestedQuantity | Decimal | The quantity of items requested in the purchase order associated with this outside-processing operation. |
| POApprovedQuantity | Decimal | The quantity of items approved in the purchase order associated with this outside-processing operation. |
| OverReceiptQuantity | Decimal | The quantity of items received in excess of the purchase order quantity for this outside-processing operation. |
| InProcessQuantity | Decimal | The quantity of items currently in process for this operation. |
| ReceivedQuantity | Decimal | The quantity of items received after completion of this operation. |
| ShippedQuantity | Decimal | The quantity of items shipped as part of this outside-processing operation. |
| ReadyQuantity | Decimal | The quantity of items that are ready to be processed in this operation. |
| CompletedQuantity | Decimal | The total quantity of items successfully completed during this operation. |
| ScrappedQuantity | Decimal | The quantity of items scrapped during this operation. |
| RejectedQuantity | Decimal | The quantity of items rejected during this operation due to quality or other issues. |
| UnitOfMeasure | String | The unit of measure for the items involved in this operation (for example,'Pieces' or 'Kilograms'). |
| PlannedStartDate | Datetime | The planned start date and time for the operation, as determined by the scheduling application. This date must fall within the work order's start and finish dates. |
| PlannedCompletionDate | Datetime | The planned completion date and time for the operation, as determined by the scheduling application. This date must fall within the work order's start and finish dates. |
| ActualStartDate | Datetime | The actual date and time when the operation began. |
| ActualCompletionDate | Datetime | The actual date and time when the operation was completed. |
| DelayStatus | Int | Indicates whether the operation is delayed. A numeric value represents the delay status, with higher values indicating more significant delays. |
| MaterialsCount | Int | The total number of material items associated with this operation. |
| ResourcesCount | Int | The total number of resources required for this operation. |
| SerialTrackingFlag | Bool | Indicates whether serial tracking is enabled for this operation. If the value is 'true', serial numbers are tracked for all items processed in this operation. |
| ShippingDocumentsFlag | Bool | Indicates whether shipping documents should be created for this outside-processing operation. A value of 'true' means shipping documents are generated, while a value of 'false' means they are not generated. |
| CreatedBy | String | The name or identifier of the user who created this operation. |
| CreationDate | Datetime | The date and time when this operation was created. |
| LastUpdateDate | Datetime | The date and time when this operation was last updated. |
| LastUpdatedBy | String | The name or identifier of the user who last updated the operation details. |
| AdditionalMaterialAtManualIssue | String | Defines whether a production operator is allowed to issue more than the required material quantity during manual material issue reporting. Options might include allowing additional issues without restriction, allowing with warnings, or preventing additional material issues entirely. |
| OperationCompletionWithOpenExceptions | String | Specifies whether an operation can be completed when open exceptions exist. Options might include unrestricted completion, completion with a warning, or preventing completion until exceptions are resolved. |
| OperationCompletionWithUnderIssue | String | Specifies whether an operation can be completed when less than the required quantity of materials has been issued. Options might include unrestricted completion, completion with a warning, or preventing completion until all required materials are issued. |
| BackToBackFlag | String | Indicates whether the operation is part of a back-to-back manufacturing process. This flag is often used for tracking direct supply chain dependencies. |
| ContractMfgFlag | String | Indicates whether the operation is part of a contract manufacturing process, where production is outsourced to a third-party manufacturer. |
| DueDays | Int | The number of days remaining until the operation or work order is due for completion. |
| Finder | String | Represents the search mechanism or criteria used to locate and identify the operation within the system. |
| FirmPlannedFlag | String | Specifies whether the operation is firm planned, meaning it is locked from changes by scheduling or planning processes. |
| InventoryItemId | Long | The unique identifier for the inventory item associated with the operation, used to track materials within the system. |
| ItemNumber | String | The unique number identifying the item associated with the operation. |
| MaterialItemId | Long | The unique identifier for the material item used in the operation. Typically, this identifier is used to track components or raw materials. |
| ProductSerialId | Long | The unique identifier for the product serial number associated with the operation, used for serialized tracking of finished or in-process items. |
| ResourceId | Long | The unique identifier for the resource associated with the operation (for example, personnel, equipment, or tools). |
| SerialNumber | String | The serial number assigned to the item or product being processed in the operation, used for tracking and traceability. |
| SourceHeaderReferenceId | Long | The unique identifier for the source header reference that links the operation to its originating data source. |
| SourceHeaderRefId | Long | Alternate unique identifier for the source header reference associated with the operation. |
| SourceLineReferenceId | Long | The unique identifier for the source line reference, linking the operation to specific line items in the source document. |
| SourceLineRefId | Long | Alternate unique identifier for the source line reference associated with the operation. |
| SourceSystemId | Long | The unique identifier for the source system from which the operation data is derived or integrated. |
| Tolerance | Int | The allowable tolerance level for the operation, such as acceptable variances in material usage, time, or quality. |
| WoProjectNumber | String | The project number associated with the work order, used for project-level tracking and reporting. |
| WorkOrderStatusId | Long | The unique identifier for the status of the work order to which the operation belongs. Statuses track the current stage, such as 'Open,' 'In Progress,' or 'Completed.' |
| WoTaskNumber | String | The task number associated with the work order operation, used to track specific tasks within the broader work order. |