Difference between revisions of "Production.Location (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.Location |- |} {| border="1" cellpadding="5" cellspacing="0" styl...)
 
Line 71: Line 71:
 
| LocationID
 
| LocationID
 
| LocationID
 
| LocationID
 +
|}
 +
 +
== wikivalues ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table Values
 +
| Production.Location
 +
|-
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0"  style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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
 
|}
 
|}

Revision as of 15:53, 3 January 2009

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
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.Location_(table)&oldid=302"