Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TableProduction.Location
DescriptionProduct inventory and manufacturing locations.

Columns

ColumnData TypeNullableDefaultDescription
LocationIDsmallintnot null Primary key for Location records.
Namedbo.Namenot null Location description.
CostRatesmallmoneynot null((0.00))Standard hourly cost of the manufacturing location.
Availabilitydecimal(8, 2)not null((0.00))Work capacity (in hours) of the manufacturing location.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_Location_LocationIDLocationID

Indexes

IndexTypeColumns
AK_Location_NameUniqueName

Check Constraints

Check ConstraintExpressionDescription
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 TableColumnReferencing Column
Production.ProductInventoryLocationIDLocationID
Production.WorkOrderRoutingLocationIDLocationID

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaProduction

wikivalues

Table ValuesProduction.Location

LocationIDNameCostRateAvailability
1Tool Crib0.000.00
2Sheet Metal Racks0.000.00
3Paint Shop0.000.00
4Paint Storage0.000.00
5Metal Storage0.000.00
6Miscellaneous Storage0.000.00
7Finished Goods Storage0.000.00
10Frame Forming22.5096.00
20Frame Welding25.00108.00
30Debur and Polish14.50120.00
40Paint15.75120.00
45Specialized Paint18.0080.00
50Subassembly12.25120.00
60Final Assembly12.25120.00

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.