Share via


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.