Production.Location (table)

wikibot

Table

Production.Location

Column	Data Type	Nullable	Default	PK	Index
LocationID	smallint	not null		PK_Location_LocationID
Name	dbo.Name	not null			AK_Location_Name
CostRate	smallmoney	not null	((0.00))
Availability	decimal(8, 2)	not null	((0.00))
ModifiedDate	datetime	not null	(getdate())

Detail Table	Column	Referencing Column
Production.ProductInventory	LocationID	LocationID
Production.WorkOrderRouting	LocationID	LocationID

wikivalues

Table Values

Production.Location

LocationID	Name	CostRate	Availability
1	Tool Crib	0.00	0.00
2	Sheet Metal Racks	0.00	0.00
3	Paint Shop	0.00	0.00
4	Paint Storage	0.00	0.00
5	Metal Storage	0.00	0.00
6	Miscellaneous Storage	0.00	0.00
7	Finished Goods Storage	0.00	0.00
10	Frame Forming	22.50	96.00
20	Frame Welding	25.00	108.00
30	Debur and Polish	14.50	120.00
40	Paint	15.75	120.00
45	Specialized Paint	18.00	80.00
50	Subassembly	12.25	120.00
60	Final Assembly	12.25	120.00

automatically generated

Table	Production.Location
Description	Product inventory and manufacturing locations.

Column	Data Type	Nullable	Default	Description / PK / Index
LocationID	smallint	not null		Primary key for Location records. PK_Location_LocationID
Name	Name	not null		Location description. AK_Location_Name
CostRate	smallmoney	not null	(0.00)	Standard hourly cost of the manufacturing location.
Availability	decimal(8, 2)	not null	(0.00)	Work capacity (in hours) of the manufacturing location.
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Production.ProductInventory	LocationID	LocationID
Production.WorkOrderRouting	LocationID	LocationID

Referenced Object	Object Type	Dependency Type
dbo.Name	Type	Data Type