Work Order Operation Start Stop
The Work Order Operation Start Stop view object contains information about the start time and stop time of work order operations. If the operation is serial controlled, then the start time and stop times of the work order operation are stored for individual product serials.
Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOOperationStartStopExtractPVO
Primary Keys : WOOpStartStopPEOOperationStartTime, WOOpStartStopPEOWoOperationId, WOOpStartStopPEOWoProductSerialId
Initial Extract Date : WOOpStartStopPEOCreationDate
Incremental Extract Date : WOOpStartStopPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
WOOpStartStopPEOCreatedBy | User who created the operation start or stop record. |
WOOpStartStopPEOCreationDate | Date and time when the operation start or stop record was created. |
WOOpStartStopPEOJobDefinitionName | Indicates the name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
WOOpStartStopPEOJobDefinitionPackage | Indicates the package name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
WOOpStartStopPEOLastUpdateDate | Date and time when the user last updated the operation start or stop record. |
WOOpStartStopPEOLastUpdateLogin | Session login associated with the user who last updated the operation start or stop record. |
WOOpStartStopPEOLastUpdatedBy | User who last updated the operation start or stop record. |
WOOpStartStopPEOObjectVersionNumber | 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. |
WOOpStartStopPEOOperationStartTime | Date and time when the work order operation started. |
WOOpStartStopPEOOperationStopTime | Date and time when the work order operation stopped. |
WOOpStartStopPEOOrganizationId | Value that uniquely identifies the manufacturing plant where the operation start and stop times are reported for a work order operation. |
WOOpStartStopPEORequestId | Indicates the request ID of the job that created or last updated the row. This is populated through Enterprise Service Scheduler. |
WOOpStartStopPEOWoOpStartStopId | Value that uniquely identities the work order operation start stops. This is the primary key of the Work Order Operation Start Stop view object. |
WOOpStartStopPEOWoOperationId | Value that uniquely identifies the work order operation for which the operation start or stop is reported. This is a foreign key to the Work Order Operation view object. |
WOOpStartStopPEOWoProductSerialId | Value that uniquely identifies the product serial in the work order view object for which the operation start or stop times are reported. This is a foreign key to the Work Order Product Serial view object. |