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.