Work Order Product Lot

The Work Order Product Lot view object contains information about the lot numbers of product and output items that are preassigned in a work order.

Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOProductLotExtractPVO

Primary Keys : WorkOrderProductLotPEOWoProductLotId

Initial Extract Date : WorkOrderProductLotPEOCreationDate

Incremental Extract Date : WorkOrderProductLotPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
WorkOrderProductLotPEOCreatedBy User who created the work order product lot record.
WorkOrderProductLotPEOCreationDate Date and time when the user created the work order product lot record.
WorkOrderProductLotPEOInventoryItemId Value that uniquely identifies the primary product or output item in the inventory organization in the Work Order Product Lot view object.
WorkOrderProductLotPEOJobDefinitionName Indicates the name of the job that created or last updated the work order product lot record. This is populated through Enterprise Service Scheduler.
WorkOrderProductLotPEOJobDefinitionPackage Indicates the package name of the job that created or last updated the work order product lot record. This is populated through Enterprise Service Scheduler.
WorkOrderProductLotPEOLastUpdateDate Date and time when the user last updated the work order product lot record.
WorkOrderProductLotPEOLastUpdateLogin Session login associated with the user who last updated the work order product lot record.
WorkOrderProductLotPEOLastUpdatedBy User who last updated the work order product lot record.
WorkOrderProductLotPEOLotNumber Identifies the lot number of the product or output item that's preassigned in the work order.
WorkOrderProductLotPEOObjectVersionNumber 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.
WorkOrderProductLotPEOOrganizationId Value that uniquely identifies the manufacturing plant to which this work order product lot belongs.
WorkOrderProductLotPEORequestId Indicates the request ID of the job that created or last updated work order product lot record. This is populated through Enterprise Service Scheduler.
WorkOrderProductLotPEOWoOperationOutputId Value that uniquely identifies the output in the Work Order Operation Output view object. This is a foreign key to the Work Order Product Lot view object.
WorkOrderProductLotPEOWoProductLotId Value that uniquely identifies the work order product lot. This is the primary key of the Work Order Product Lot view object.
WorkOrderProductLotPEOWorkOrderId Value that uniquely identifies the work order in the Work Order view object. This is a foreign key to the Work Order Product Lot view object.