Work Order Operation
The Work Order Operation view object contains details about the operations required to execute the work order. It also stores the quantities reported against each operation during work execution.
Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOOperationExtractPVO
Primary Keys : WOOperationPEOWoOperationId
Initial Extract Date : WOOperationPEOCreationDate
Incremental Extract Date : WOOperationPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| WOOperationPEOActualCompletionDate | Actual finish date of the operation. |
| WOOperationPEOActualStartDate | Actual start date of the operation. |
| WOOperationPEOAddlMtlAtManualIssue | Value that controls whether a production operator can issue more than the required quantity while manually reporting material issues. A list of accepted values is defined in the lookup type ORA_WIS_ADDL_MANUAL_ISSUE_OPTS. |
| WOOperationPEOAttributeCategory | Context name for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar1 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar10 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar11 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar12 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar13 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar14 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar15 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar16 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar17 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar18 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar19 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar2 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar20 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar3 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar4 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar5 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar6 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar7 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar8 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeChar9 | Character segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeDate1 | Date segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeDate2 | Date segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeDate3 | Date segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeDate4 | Date segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeDate5 | Date segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeNumber1 | Number segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeNumber10 | Number segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeNumber2 | Number segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeNumber3 | Number segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeNumber4 | Number segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeNumber5 | Number segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeNumber6 | Number segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeNumber7 | Number segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeNumber8 | Number segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeNumber9 | Number segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeTimestamp1 | Date and Time segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeTimestamp2 | Date and Time segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeTimestamp3 | Date and Time segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeTimestamp4 | Date and Time segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAttributeTimestamp5 | Date and Time segment for the Work Order Operation descriptive flexfield. |
| WOOperationPEOAutoTransactFlag | Indicates whether the operation is automatically reported and its resources and materials are automatically charged based on the Supply Type or the Charge Type setups upon completion of the next count point operation. |
| WOOperationPEOCharOperationSeqNumber | Sequence to use when defining and executing the work order operations. |
| WOOperationPEOCompletedQuantity | Quantity completed so far in the operation. |
| WOOperationPEOCountPointOperationFlag | Indicates if this is a count point operation. If an operation is a count point operation, then you must manually report the operation quantities. |
| WOOperationPEOCreatedBy | User who created the work order operation record. |
| WOOperationPEOCreationDate | Date and time when the work order operation record was created. |
| WOOperationPEOCumulativeScrapQuantity | Total cumulative scrapped quantity up to the current operation, excluding the current operation. |
| WOOperationPEOExecutionSequence | Indicates the execution sequence number of the operation if the work order has resequence operations. |
| WOOperationPEOFixedLeadTime | Lead time to perform this supplier operation, independent of the quantity of the OSP item. |
| WOOperationPEOInProcessQuantity | Quantity completed so far at the prior count point operation, and that are awaiting delivery to the supplier operation. |
| WOOperationPEOJobDefinitionName | Indicates the name of the job that created or last updated the work order operation record. This is populated through Enterprise Service Scheduler. |
| WOOperationPEOJobDefinitionPackage | Indicates the package name of the job that created or last updated the work order operation record. This is populated through Enterprise Service Scheduler. |
| WOOperationPEOLanguage | Code of the language into which the contents of the translatable columns are translated. |
| WOOperationPEOLastUpdateDate | Date and time when the user last updated the work order operation record. |
| WOOperationPEOLastUpdateLogin | Session login associated with the user who last updated the work order operation record. |
| WOOperationPEOLastUpdatedBy | User who last updated the work order operation record. |
| WOOperationPEOLeadTimeUom | Represents the unit of measure for the fixed and variable lead time values of the supplier operation. |
| WOOperationPEOMntCompleteFlag | Indicates whether the maintenance work order operation is completed. Contains one of the following values: Y or N. |
| WOOperationPEONextCpOpSeqNum | Represents the sequence number of the next count point operation. |
| WOOperationPEOObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| WOOperationPEOOpComplWithOpenExceptions | Value that controls whether operation completion is allowed when open exceptions exist for an operation. You can complete an operation without any hindrance, allow with a warning, or prevent operation completion. A list of accepted values is defined in the lookup type ORA_WIS_OP_COMPLETION_VAL_OPTS.. |
| WOOperationPEOOpComplWithUnderIssue | Value that controls whether operation completion is allowed when less than the required quantity of material is issued. You can complete an operation without any hindrance, allow with a warning, or prevent operation completion. A list of accepted values is defined in the lookup type ORA_WIS_OP_COMPLETION_VAL_OPTS. |
| WOOperationPEOOperationSeqNumber | Sequence to use when defining and executing the work order operations. |
| WOOperationPEOOperationType | Value that specifies the type of the operation. A list of accepted values is defined in the lookup type ORA_WIS_OPERATION_TYPE. |
| WOOperationPEOOrganizationId | Value that uniquely identifies the manufacturing plant to which this work order operation belongs. This is a foreign key of the Organization view object |
| WOOperationPEOOspItemId | Value that uniquely identifies the outside processing item of a supplier operation in the Work Order Operation view object. |
| WOOperationPEOOverReceiptQuantity | Quantity received in excess of the expected quantity for a supplier operation. |
| WOOperationPEOPlannedCompletionDate | Planned date and time to complete the operation. The scheduling application generally sets this date. |
| WOOperationPEOPlannedStartDate | Planned date and time to start the operation. The scheduling application generally sets this date. |
| WOOperationPEOPoApprovedQuantity | Approved quantity on the purchase order created for this supplier operation. |
| WOOperationPEOPoRequestedQuantity | Quantity requested to create the purchase requisition for this supplier operation. |
| WOOperationPEOPreviousCpOpSeqNum | Represents the sequence number of the previous count point operation. |
| WOOperationPEOReadyQuantity | Quantity that's ready for execution in the operation. |
| WOOperationPEOReceivedQuantity | Quantity received for this supplier operation. |
| WOOperationPEORejectedQuantity | Quantity rejected so far in the operation. |
| WOOperationPEORequestId | It indicates the request ID of the job that created or last updated work order operation record. This is populated through Enterprise Service Scheduler. |
| WOOperationPEOResequenceFlag | Indicates if the operation can be resequenced during work execution. |
| WOOperationPEOScrappedQuantity | Quantity scrapped so far in the operation. |
| WOOperationPEOSerialTrackingFlag | Indicates if this operation is tracked by serial numbers. The valid values are Y and N. |
| WOOperationPEOShippedQuantity | Quantity shipped to the supplier for this supplier operation. |
| WOOperationPEOShippingDocumentsFlag | Indicates if the shipping documents need to be generated for a supplier operation. The valid values are Y and N. |
| WOOperationPEOStandardOperationId | Value that uniquely identifies the standard operation in the Work Order Operation view object. If an operation in the work order is created by referencing the standard operation, this column value is populated. This is a foreign key to the Standard Operations view object. |
| WOOperationPEOSupplierId | Value that uniquely identifies the suggested supplier of a supplier operation in the Work Order Operation view object. |
| WOOperationPEOSupplierSiteId | Value that uniquely identifies the suggested supplier site of a supplier operation in the Work Order Operation view object. |
| WOOperationPEOTollgateOpSeqNum | Value that identifies the toll gate operation sequence number of a resequence enabled operation. |
| WOOperationPEOVariableLeadTime | Lead time to perform this supplier operation for each unit of the OSP item. |
| WOOperationPEOWdOperationId | Value that uniquely identifies the work definition operation from which this operation was created in the Work Order Operation view object. This is a foreign key to the Work Definition Operation view object. |
| WOOperationPEOWoOperationId | Value that uniquely identifies the work order operation. This is the primary key of the Work Order Operation view object. |
| WOOperationPEOWorkCenterId | Value that uniquely identifies the work center of an operation in the Work Order Operation view object. This is the foreign key of the Work Center view object. |
| WOOperationPEOWorkOrderId | Value that uniquely identifies the work order in the work order operation view object. This is the foreign key of the Work Order view object. |
| WOOperationPEOYieldFactor | Indicates the yield factor of an operation that represents the percentage of the starting quantity that's yielded on completion of the operation. |
| WOOperationTLPEOCreatedBy | User who created the work order operation record. |
| WOOperationTLPEOCreationDate | Date and time when the work order operation record was created. |
| WOOperationTLPEOLanguage | Code of the language into which the contents of the translatable columns are translated. |
| WOOperationTLPEOLastUpdateDate | Date and time when the user last updated the work order operation record. |
| WOOperationTLPEOLastUpdateLogin | Session login associated with the user who last updated the work order operation record. |
| WOOperationTLPEOLastUpdatedBy | User who last updated the work order operation record. |
| WOOperationTLPEOObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| WOOperationTLPEOOperationDescription | Description of the operation. |
| WOOperationTLPEOOperationName | Name of the operation. |
| WOOperationTLPEOSourceLang | Code of the language in which the contents of the translatable columns were originally created. |
| WOOperationTLPEOWoOperationId | Value that uniquely identifies the work order operation. This is the primary key of the Work Order Operation view object. |