Inventory Lot Numbers
The Inventory Lot Numbers view object contains information for inventory lot numbers.
Data Store Key : FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.InvLotNumbersExtractPVO
Primary Keys : LotNumber, InventoryItemId, OrganizationId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| Age | Value that identifies the age of the lot in days after the creation date. |
| Attribute1 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute10 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute11 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute12 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute13 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute14 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute15 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute16 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute17 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute18 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute19 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute2 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute20 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute3 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute4 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute5 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute6 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute7 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute8 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| Attribute9 | Segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeCategory | Context name for the Maintain Lot Numbers descriptive flexfield. |
| AttributeDate1 | Date segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeDate2 | Date segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeDate3 | Date segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeDate4 | Date segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeDate5 | Date segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeNumber1 | Number segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeNumber10 | Number segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeNumber2 | Number segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeNumber3 | Number segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeNumber4 | Number segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeNumber5 | Number segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeNumber6 | Number segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeNumber7 | Number segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeNumber8 | Number segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeNumber9 | Number segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeTimestamp1 | Date and time segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeTimestamp2 | Date and time segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeTimestamp3 | Date and time segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeTimestamp4 | Date and time segment for the Maintain Lot Numbers descriptive flexfield. |
| AttributeTimestamp5 | Date and time segment for the Maintain Lot Numbers descriptive flexfield. |
| AvailabilityType | Code that identifies the type of availability. |
| BestByDate | Date on or before which the lot is best used. |
| CAttribute1 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute10 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute11 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute12 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute13 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute14 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute15 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute16 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute17 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute18 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute19 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute2 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute20 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute3 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute4 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute5 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute6 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute7 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute8 | Segment for the Lot Attributes descriptive flexfield. |
| CAttribute9 | Segment for the Lot Attributes descriptive flexfield. |
| ChangeDate | Date the inventory lot numbers record was modified. |
| Color | Value that identifies the name of the color. |
| CreatedBy | User who created the inventory lot numbers record. |
| CreationDate | Date and time when the inventory lot numbers record was created. |
| CurlWrinkleFold | Value that identifies potential problems when feeding the paper through machinery. |
| CyclesSinceMark | Number of cycles since mark. |
| CyclesSinceNew | Number of cycles since new. |
| CyclesSinceOverhaul | Number of cycles since overhaul. |
| CyclesSinceRepair | Number of cycles since repair. |
| CyclesSinceVisit | Number of cycles since visit. |
| DAttribute1 | Date segment for the Lot Attributes descriptive flexfield. |
| DAttribute10 | Date segment for the Lot Attributes descriptive flexfield. |
| DAttribute2 | Date segment for the Lot Attributes descriptive flexfield. |
| DAttribute3 | Date segment for the Lot Attributes descriptive flexfield. |
| DAttribute4 | Date segment for the Lot Attributes descriptive flexfield. |
| DAttribute5 | Date segment for the Lot Attributes descriptive flexfield. |
| DAttribute6 | Date segment for the Lot Attributes descriptive flexfield. |
| DAttribute7 | Date segment for the Lot Attributes descriptive flexfield. |
| DAttribute8 | Date segment for the Lot Attributes descriptive flexfield. |
| DAttribute9 | Date segment for the Lot Attributes descriptive flexfield. |
| DateCode | Code that identifies the date of packaging or assembly. |
| Description | Description for the lot number. |
| DisableFlag | Indicates whether the lot number is disabled. |
| ExpirationActionCode | Code that indicates the expiration action. |
| ExpirationActionDate | Date for the expiration action. |
| ExpirationDate | Date when the lot expires. |
| GenObjectId | Value that uniquely identifies the genealogy object. |
| GradeCode | Code that indicates the lot grade. |
| HoldDate | Date of the lot origination date plus hold days. |
| InventoryAtpCode | Code that identifies inventory available to promise. |
| InventoryItemId | Value that uniquely identifies the inventory item. |
| ItemSize | Value that identifies the size of the item. |
| JobDefinitionName | Name of the scheduled process that created or last updated the record. |
| JobDefinitionPackage | Package name of the scheduled process that created or most recently updated the record. |
| LastUpdateDate | Date when the inventory lot numbers record was last updated. |
| LastUpdateLogin | Session login associated with the user who last updated the inventory lot number record. |
| LastUpdatedBy | User who most recently updated the inventory lot numbers record. |
| LengthUom | Value that identifies the unit of measure for length of the item. |
| LotAttributeCategory | Context name for the Lot Attributes descriptive flexfield. |
| LotItemDisableFlag | Indicates whether the lot number is disabled for the item. |
| LotLength | Value that identifies the length of the lot. |
| LotNumber | Value that identifies an inventory lot. |
| LotThickness | Value that identifies the thickness of the lot. |
| LotVolume | Value that identifies the volume of the lot. |
| LotWidth | Value that identifies the width of the lot. |
| MaturityDate | Date when the item matures. |
| NAttribute1 | Number segment for the Lot Attributes descriptive flexfield. |
| NAttribute10 | Number segment for the Lot Attributes descriptive flexfield. |
| NAttribute2 | Number segment for the Lot Attributes descriptive flexfield. |
| NAttribute3 | Number segment for the Lot Attributes descriptive flexfield. |
| NAttribute4 | Number segment for the Lot Attributes descriptive flexfield. |
| NAttribute5 | Number segment for the Lot Attributes descriptive flexfield. |
| NAttribute6 | Number segment for the Lot Attributes descriptive flexfield. |
| NAttribute7 | Number segment for the Lot Attributes descriptive flexfield. |
| NAttribute8 | Number segment for the Lot Attributes descriptive flexfield. |
| NAttribute9 | Number segment for the Lot Attributes descriptive flexfield. |
| NumberOfRepairs | Value that identifies the number of repairs for the MRO industry. |
| ObjectVersionNumber | Value that identifies the 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. |
| OrganizationId | Value that uniquely identifies the inventory organization. |
| OriginationDate | Date of the lot creation. |
| OriginationType | Value that identifies the type of origination. |
| ParentLotNumber | Value that identifies the parent lot. |
| PlaceOfOrigin | Value that identifies the country of origin. |
| RecycledContent | Value that identifies the amount of content, usually expressed as a percentage, of the product that's made up of recycled materials. |
| RequestId | Value that uniquely identifies the scheduled process that created or last updated the record. |
| ReservableType | Code that identifies hard reservation eligibility. |
| RetestDate | Date the lot is due for retest. |
| SamplingEventId | Value that uniquely identifies the latest OPM Quality sampling event tested against the lot. |
| StatusId | Value that uniquely identifies the status of the lot. |
| SupplierLotNumber | Number that the supplier identifies the lot by for purchase order receipts. |
| TAttribute1 | Date and time segment for the Lot Attributes descriptive flexfield. |
| TAttribute2 | Date and time segment for the Lot Attributes descriptive flexfield. |
| TAttribute3 | Date and time segment for the Lot Attributes descriptive flexfield. |
| TAttribute4 | Date and time segment for the Lot Attributes descriptive flexfield. |
| TAttribute5 | Date and time segment for the Lot Attributes descriptive flexfield. |
| TerritoryCode | Value that identifies the code for the territory of the country of origin. |
| ThicknessUom | Value that identifies the unit of measure for thickness of the item. |
| TimeSinceMark | Value that identifies the time since the last mark. |
| TimeSinceRepair | Value that identifies the time since the last repair. |
| TimeSinceVisit | Value that identifies the time since the last visit. |
| UniqueDeviceIdentifier | Value that uniquely identifies the device. |
| VendorId | Value that uniquely identifies the supplier. |
| VendorName | Value that identifies the name of the supplier. |
| VolumeUom | Value that identifies the unit of measure for the volume of the item. |
| WidthUom | Value that identifies the unit of measure for the width of the item. |