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. |
See Also
Reference
Location Table (AdventureWorks)
Product Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary