ProductInventory Table (AdventureWorks)

Contains the product inventory information.

ProductInventory Table Definition

The ProductInventory table is contained in the Production schema.

Column	Data type	Nullability	Description
ProductID	int	Not null	Product identification number. Foreign key to Product.ProductID.
LocationID	smallint	Not null	Inventory location identification number. Foreign key to Location.LocationID.
Shelf	nvarchar(10)	Not null	Storage compartment within an inventory location.
Bin	tinyint	Not null	Storage container on a shelf in an inventory location.
Quantity	smallint	Not Null	Quantity of products in the inventory location.
rowguid	uniqueidentifier ROWGUIDCOL	Not null	ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample.
ModifiedDate	datetime	Not null	Date and time the row was last updated.