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. |