Export (0) Print
Expand All
Expand Minimize

Location Table (AdventureWorks)

Is a lookup table that contains the product inventory and manufacturing locations.

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.

Community Additions

ADD
Show:
© 2014 Microsoft