Lot and Serial Numbers

The Lot and Serial Numbers view object that extracts lot and serial numbers from the sales orders.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.LotSerialExtractPVO

Primary Keys : LotSerialId

Initial Extract Date : LotSerialCreationDate

Incremental Extract Date : LotSerialLastUpdateDate

Attributes

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

Name	Description
LotSerialCreatedBy	User who created the lot and serial numbers row.
LotSerialCreationDate	Date when the lot and serial numbers row was created.
LotSerialDeltaType	Value that identifies the type of change, such as update, cancel, and so on. Order Management uses this value when processing change orders on the lot-serial row.
LotSerialFulfillLineId	Value that identifies the fulfillment line associated to the lot and serial numbers row. This is a foreign key to the Fulfillment Lines view object.
LotSerialId	Value that uniquely identifies the lot and serial number row. This is the primary key of the Lot and Serial Numbers view object.
LotSerialItemRevisionNumber	Value that identifies the item revision.
LotSerialItemSerialNumberFrom	Starting serial number of a range of serial numbers.
LotSerialItemSerialNumberTo	Ending serial number of a range of serial numbers.
LotSerialLastUpdateDate	Date when the lot and serial numbers row was last updated.
LotSerialLastUpdateLogin	Session login associated to the user who most recently updated the lot and serial numbers row.
LotSerialLastUpdatedBy	User who most recently updated the lot and serial numbers row.
LotSerialLineId	Value that identifies the sales order line associated to the lot and serial numbers row. This is a foreign key to the Sales Order Lines view object.
LotSerialLocatorId	Value that identifies locator where the item is shipped from or received into.
LotSerialLotNumber	A number assigned to quantity of items for identification purposes.
LotSerialModifiedFlag	Value that identifies whether the user modified the lot-serial row. If true, then the user modified the lot-serial row. If false, then the user didn't modify the lot-serial row.
LotSerialObjectVersionNumber	Number of times the lot and serial numbers row has been updated.
LotSerialOrigSysLotserialRef	Original reference for the lot and serial numbers from the source system.
LotSerialQuantity	Quantity of the item.
LotSerialReferenceLotSerialId	Value that identifies the previous lot-serial row. Order Management uses this value when processing change orders.
LotSerialSecondaryQuantity	Value that identifies the quantity of the lot for the item or service in the secondary unit of measure. This attribute is applicable when more than one unit of measure is used to measure and track the item.