Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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