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
Reference
Product Table (AdventureWorks)
ProductInventory Table (AdventureWorks)
WorkOrderRouting Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary