Production.Location (table)

From dbscript Online Help
Jump to: navigation, search

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

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


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