ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Production.Location_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | Production.Location |- valign="top" | '''Description''' | Product inventory and manufacturing locations. |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | LocationID | smallint | not null | | Primary key for Location records. |- valign="top" | Name | dbo.Name | not null | | Location description. |- valign="top" | CostRate | smallmoney | not null | ((0.00)) | Standard hourly cost of the manufacturing location. |- valign="top" | Availability | decimal(8, 2) | not null | ((0.00)) | Work capacity (in hours) of the manufacturing location. |- valign="top" | ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | PK_Location_LocationID | LocationID |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | AK_Location_Name | Unique | Name |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''Expression''' | '''Description''' |- valign="top" | CK_Location_Availability | ([Availability]>=(0.00)) | Check constraint [Availability] >= (0.00) |- valign="top" | CK_Location_CostRate | ([CostRate]>=(0.00)) | Check constraint [CostRate] >= (0.00) |} === Detail Tables === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- valign="top" | [[Production.ProductInventory_(table)|Production.ProductInventory]] | LocationID | LocationID |- valign="top" | [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]] | LocationID | LocationID |} === References === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- valign="top" | Data Type | Type | [[dbo.Name_(type)|dbo.Name]] |- valign="top" | Schema | Schema | [[Production_(schema)|Production]] |} == wikivalues == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table Values''' | Production.Location |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''LocationID''' | '''Name''' | '''CostRate''' | '''Availability''' |- valign="top" | 1 | Tool Crib | 0.00 | 0.00 |- valign="top" | 2 | Sheet Metal Racks | 0.00 | 0.00 |- valign="top" | 3 | Paint Shop | 0.00 | 0.00 |- valign="top" | 4 | Paint Storage | 0.00 | 0.00 |- valign="top" | 5 | Metal Storage | 0.00 | 0.00 |- valign="top" | 6 | Miscellaneous Storage | 0.00 | 0.00 |- valign="top" | 7 | Finished Goods Storage | 0.00 | 0.00 |- valign="top" | 10 | Frame Forming | 22.50 | 96.00 |- valign="top" | 20 | Frame Welding | 25.00 | 108.00 |- valign="top" | 30 | Debur and Polish | 14.50 | 120.00 |- valign="top" | 40 | Paint | 15.75 | 120.00 |- valign="top" | 45 | Specialized Paint | 18.00 | 80.00 |- valign="top" | 50 | Subassembly | 12.25 | 120.00 |- valign="top" | 60 | Final Assembly | 12.25 | 120.00 |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | Production.Location |- valign="top" | '''Description''' | Product inventory and manufacturing locations. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | LocationID | smallint | not null | | Primary key for Location records.<br />PK_Location_LocationID |- | Name | Name | not null | | Location description.<br />AK_Location_Name |- | CostRate | smallmoney | not null | (0.00) | Standard hourly cost of the manufacturing location.<br /> |- | Availability | decimal(8, 2) | not null | (0.00) | Work capacity (in hours) of the manufacturing location.<br /> |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- | [[Production.ProductInventory_(table)|Production.ProductInventory]] | LocationID | LocationID |- | [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]] | LocationID | LocationID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Data Type | Type | [[dbo.Name_(type)|dbo.Name]] |- | Schema | Schema | [[Production_(schema)|Production]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.