Location Table (AdventureWorks)
Is a lookup table that contains the product inventory and manufacturing locations.
Location Table Definition
The Location table is contained in the Production schema.
Column |
Data type |
Nullability |
Description |
---|---|---|---|
LocationID |
int |
Not null |
Primary key for Location records. |
Name |
Name (user-defined type) nvarchar(50) |
Not null |
Location description. |
CostRate |
smallmoney |
Not null |
Standard hourly cost of the manufacturing location. |
Availability |
decimal(8,2) |
Not null |
Work capacity (in hours) of the manufacturing location. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also