Inventory Serial Numbers

The Inventory Serial Numbers view object contains information about inventory serial numbers.

Data Store Key : FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InvSerialNumbersExtractPVO

Primary Keys : InventoryItemId, SerialNumber, CurrentOrganizationId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
Attribute1	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute10	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute11	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute12	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute13	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute14	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute15	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute16	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute17	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute18	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute19	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute2	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute20	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute3	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute4	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute5	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute6	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute7	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute8	Segment for the Manage Serial Numbers descriptive flexfield.
Attribute9	Segment for the Manage Serial Numbers descriptive flexfield.
AttributeCategory	Context name for the Manage Serial Numbers descriptive flexfield.
AttributeDate1	Date segment for the Manage Serial Numbers descriptive flexfield.
AttributeDate2	Date segment for the Manage Serial Numbers descriptive flexfield.
AttributeDate3	Date segment for the Manage Serial Numbers descriptive flexfield.
AttributeDate4	Date segment for the Manage Serial Numbers descriptive flexfield.
AttributeDate5	Date segment for the Manage Serial Numbers descriptive flexfield.
AttributeNumber1	Number segment for the Manage Serial Numbers descriptive flexfield.
AttributeNumber10	Number segment for the Manage Serial Numbers descriptive flexfield.
AttributeNumber2	Number segment for the Manage Serial Numbers descriptive flexfield.
AttributeNumber3	Number segment for the Manage Serial Numbers descriptive flexfield.
AttributeNumber4	Number segment for the Manage Serial Numbers descriptive flexfield.
AttributeNumber5	Number segment for the Manage Serial Numbers descriptive flexfield.
AttributeNumber6	Number segment for the Manage Serial Numbers descriptive flexfield.
AttributeNumber7	Number segment for the Manage Serial Numbers descriptive flexfield.
AttributeNumber8	Number segment for the Manage Serial Numbers descriptive flexfield.
AttributeNumber9	Number segment for the Manage Serial Numbers descriptive flexfield.
AttributeTimestamp1	Date and time segment for the Manage Serial Numbers descriptive flexfield.
AttributeTimestamp2	Date and time segment for the Manage Serial Numbers descriptive flexfield.
AttributeTimestamp3	Date and time segment for the Manage Serial Numbers descriptive flexfield.
AttributeTimestamp4	Date and time segment for the Manage Serial Numbers descriptive flexfield.
AttributeTimestamp5	Date and time segment for the Manage Serial Numbers descriptive flexfield.
AvailabilityType	Code that identifies the type of availability.
CAttribute1	Segment for the Serial Attributes descriptive flexfield.
CAttribute10	Segment for the Serial Attributes descriptive flexfield.
CAttribute11	Segment for the Serial Attributes descriptive flexfield.
CAttribute12	Segment for the Serial Attributes descriptive flexfield.
CAttribute13	Segment for the Serial Attributes descriptive flexfield.
CAttribute14	Segment for the Serial Attributes descriptive flexfield.
CAttribute15	Segment for the Serial Attributes descriptive flexfield.
CAttribute16	Segment for the Serial Attributes descriptive flexfield.
CAttribute17	Segment for the Serial Attributes descriptive flexfield.
CAttribute18	Segment for the Serial Attributes descriptive flexfield.
CAttribute19	Segment for the Serial Attributes descriptive flexfield.
CAttribute2	Segment for the Serial Attributes descriptive flexfield.
CAttribute20	Segment for the Serial Attributes descriptive flexfield.
CAttribute3	Segment for the Serial Attributes descriptive flexfield.
CAttribute4	Segment for the Serial Attributes descriptive flexfield.
CAttribute5	Segment for the Serial Attributes descriptive flexfield.
CAttribute6	Segment for the Serial Attributes descriptive flexfield.
CAttribute7	Segment for the Serial Attributes descriptive flexfield.
CAttribute8	Segment for the Serial Attributes descriptive flexfield.
CAttribute9	Segment for the Serial Attributes descriptive flexfield.
CategoryId	Unique identifier for the item category.
CompletionDate	Date when the unit is completed.
CountryOfOriginCode	Code that identifies the country of origin associated to this serial number.
CreatedBy	User who created the serial number.
CreationDate	Date when the serial number was created.
CurrentLocatorId	Value that uniquely identifies the locator for this serial number.
CurrentOrganizationId	Value that uniquely identifies the inventory organization for this serial number.
CurrentStatus	Code that identifies the current state of the serial. For example, defined but not used, in stores, or issued out of stores.
CurrentSubinventoryCode	Code that identifies the current subinventory where the serial number is present.
CyclesSinceMark	Number of cycles completed from the time a serial number is marked for an item in the manufacturing, repair, and overhaul industry.
CyclesSinceNew	Number of cycles completed from the time a new item is created in the manufacturing, repair, and overhaul industry.
CyclesSinceOverhaul	Number of cycles completed from the time an item is overhauled in the manufacturing, repair, and overhaul industry.
CyclesSinceRepair	Number of cycles completed from the time an item is repaired in the manufacturing, repair, and overhaul industry.
CyclesSinceVisit	Number of cycles completed from the time an item is visited in the manufacturing, repair, and overhaul industry.
DAttribute1	Segment for the Serial Attributes descriptive flexfield.
DAttribute10	Segment for the Serial Attributes descriptive flexfield.
DAttribute2	Segment for the Serial Attributes descriptive flexfield.
DAttribute3	Segment for the Serial Attributes descriptive flexfield.
DAttribute4	Segment for the Serial Attributes descriptive flexfield.
DAttribute5	Segment for the Serial Attributes descriptive flexfield.
DAttribute6	Segment for the Serial Attributes descriptive flexfield.
DAttribute7	Segment for the Serial Attributes descriptive flexfield.
DAttribute8	Segment for the Serial Attributes descriptive flexfield.
DAttribute9	Segment for the Serial Attributes descriptive flexfield.
GenObjectId	Value that uniquely identifies the genealogy object.
GroupMarkId	Value that identifies that the serial number is allocated to a transaction group and not available for others.
InitializationDate	Date that the unit is initialized.
InspectionStatus	Code that indicates if the serial has been accepted or rejected after receiving inspection.
InvReservedAttribute1	Segment for the Inventory Attributes descriptive flexfield.
InvReservedAttribute2	Segment for the Inventory Attributes descriptive flexfield.
InvStripingCategory	Context name for the Inventory Attributes descriptive flexfield.
InvUserDefAttribute1	Segment for the Inventory Attributes descriptive flexfield.
InvUserDefAttribute10	Segment for the Inventory Attributes descriptive flexfield.
InvUserDefAttribute2	Segment for the Inventory Attributes descriptive flexfield.
InvUserDefAttribute3	Segment for the Inventory Attributes descriptive flexfield.
InvUserDefAttribute4	Segment for the Inventory Attributes descriptive flexfield.
InvUserDefAttribute5	Segment for the Inventory Attributes descriptive flexfield.
InvUserDefAttribute6	Segment for the Inventory Attributes descriptive flexfield.
InvUserDefAttribute7	Segment for the Inventory Attributes descriptive flexfield.
InvUserDefAttribute8	Segment for the Inventory Attributes descriptive flexfield.
InvUserDefAttribute9	Segment for the Inventory Attributes descriptive flexfield.
InventoryAtpCode	Segment for the Inventory Attributes descriptive flexfield.
InventoryItemId	Value that uniquely identifies the inventory item.
JobDefinitionName	Name of the scheduled process that created or last updated the record.
JobDefinitionPackage	Value that identifies the package name of the scheduled process that created or most recently updated the record.
LastReceiptIssueType	Code that indicates if the last transaction performed on the serial is a receipt or an issue.
LastTransactionId	Value that uniquely identifies the latest inventory transaction that included this serial number.
LastTxnSourceId	Value that uniquely identifies the source of the latest inventory transaction that included this serial number.
LastTxnSourceName	Value that identifies the source name of the latest inventory transaction that included this serial number.
LastTxnSourceTypeId	Value that uniquely identifies the source type of the latest inventory transaction that included this serial number.
LastUpdateDate	Date when the serial number was most recently updated.
LastUpdateLogin	Session login associated with the user who most recently updated the serial number.
LastUpdatedBy	User who most recently updated the serial number.
LineMarkId	Value that uniquely identifies the transaction line to which the serial number is allocated.
LotLineMarkId	Value that uniquely identifies the transaction lot line to which the serial number is allocated.
LotNumber	Value that identifies an inventory lot.
NAttribute1	Segment for the Serial Attributes descriptive flexfield.
NAttribute10	Segment for the Serial Attributes descriptive flexfield.
NAttribute2	Segment for the Serial Attributes descriptive flexfield.
NAttribute3	Segment for the Serial Attributes descriptive flexfield.
NAttribute4	Segment for the Serial Attributes descriptive flexfield.
NAttribute5	Segment for the Serial Attributes descriptive flexfield.
NAttribute6	Segment for the Serial Attributes descriptive flexfield.
NAttribute7	Segment for the Serial Attributes descriptive flexfield.
NAttribute8	Segment for the Serial Attributes descriptive flexfield.
NAttribute9	Segment for the Serial Attributes descriptive flexfield.
NumberOfRepairs	Number of repairs of an item in the manufacturing, repair, and overhaul industry.
ObjectVersionNumber	Number of times the object row has been updated. This attribute is used to implement optimistic locking. This number is incremented every time that 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.
OnhandQuantitiesId	Value that uniquely identifies the on-hand balances row. The value for this attribute is generated by the application.
OperationSeqNum	Number that identifies the work order operation sequence that transacted this serial number.
OriginalUnitVendorId	Unique identifier of the supplier who shipped the original unit.
OriginalWipEntityId	Unique identifier of the original work order transaction.
OriginationDate	Date when the warehouse created the serial number.
OwningOrganizationId	Value that uniquely identifies the owning party associated with the consigned inventory.
OwningTpType	Value that identifies the type of owning party associated with the consigned inventory.
ParentItemId	Value that uniquely identifies the parent item.
ParentLotNumber	Value that identifies the parent lot.
ParentSerialNumber	Value that identifies the parent serial number.
PlanningOrganizationId	Value that uniquely identifies the planning organization.
PlanningTpType	Value that identifies the type of planning trading partner.
PreviousStatus	Code that identifies the previous state of the serial. For example, defined but not used, in stores, or issued out of stores.
ProjectId	Value that uniquely identifies the project used to strip inventory transactions and serial numbers.
RequestId	Value that uniquely identifies the request ID of the scheduled process that created or most recently updated the row.
ReservableType	Code that identifies hard reservation eligibility.
ReservationId	Unique identifier of the inventory reservation.
Revision	Value that identifies the version of the item.
SerialAttributeCategory	Context name for the Serial Attribute descriptive flexfield.
SerialNumber	Number that uniquely identifies a single piece that will never be repeated for similar pieces.
ShipDate	Date that the serial number was issued out of the warehouse.
StatusId	Value that uniquely identifies the material status of the serial number.
TAttribute1	Segment for the Serial Attributes descriptive flexfield.
TAttribute2	Segment for the Serial Attributes descriptive flexfield.
TAttribute3	Segment for the Serial Attributes descriptive flexfield.
TAttribute4	Segment for the Serial Attributes descriptive flexfield.
TAttribute5	Segment for the Serial Attributes descriptive flexfield.
TaskId	Value that uniquely identifies the inventory task.
TerritoryCode	Code that identifies the country of origin of the serial.
TimeSinceMark	Value that identifies the time as calculated from the time a serial number is marked for an item in the manufacturing, repair, and overhaul industry.
TimeSinceNew	Value that identifies the time as calculated from the time an item is marked as new in the manufacturing, repair, and overhaul industry.
TimeSinceOverhaul	Value that identifies the time as calculated from the time an item is marked for overhaul in the manufacturing, repair, and overhaul industry.
TimeSinceRepair	Value that identifies the time as calculated from the time an item is marked for repair in the manufacturing, repair, and overhaul industry.
TimeSinceVisit	Value that identifies the time as calculated from the time an item is visited in the manufacturing, repair, and overhaul industry.
UniqueDeviceIdentifier	Value that uniquely identifies the device.
VendorLotNumber	Value that identifies the supplier lot number.
VendorSerialNumber	Value that identifies the supplier serial number.
WipEntityId	Value that uniquely identifies the original work order transaction.