Welcome Guest, you are in: <root> • Login

Page History: Production Location (table)

Compare Page Revisions

5 4 3 2 1 0 Current 5 4 3 2 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2010/06/24 01:10

wikibot ¶

Table	Production.Location
Description	Product inventory and manufacturing locations.

Columns ¶

Column	Data Type	Nullable	Default	Description
LocationID	smallint	not null		Primary key for Location records.
Name	dbo.Name	not null		Location description.
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.

Primary Key ¶

Primary Key	Columns
PK_Location_LocationID	LocationID

Indexes ¶

Index	Type	Columns
AK_Location_Name	Unique	Name

Check Constraints ¶

Check Constraint	Expression	Description
CK_Location_Availability	(Availability>=(0.00))	Check constraint Availability >= (0.00)
CK_Location_CostRate	(CostRate>=(0.00))	Check constraint CostRate >= (0.00)

Detail Tables ¶

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

References ¶

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

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