Production.Location (table) - Revision history

Bot at 08:55, 27 August 2011

2011-08-27T08:55:17Z

Bot at 22:18, 23 June 2010

2010-06-23T22:18:16Z

Bot at 22:16, 23 June 2010

2010-06-23T22:16:33Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:57Z

Bot at 22:27, 28 December 2009

2009-12-28T22:27:54Z

Bot at 22:25, 28 December 2009

2009-12-28T22:25:08Z

Bot at 22:13, 28 December 2009

2009-12-28T22:13:07Z

Show changes

Bot at 21:57, 28 December 2009

2009-12-28T21:57:42Z

Show changes

Bot at 21:54, 28 December 2009

2009-12-28T21:54:42Z

Bot at 05:59, 30 November 2009

2009-11-30T05:59:26Z

← Older revision		Revision as of 08:55, 27 August 2011
Line 126:		Line 126:

	\|}		\|}
		+
		+
	== wikivalues ==		== wikivalues ==

@@ Line 126: / Line 126: @@
 |}
 == wikivalues ==
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table Values
 | Production.Location
 |}
 | '''LocationID
 | '''Name
 | '''CostRate
 | '''Availability
-|-
+|- valign="top"
 |	1
-|	Tool Crib
+| 1
-|	0.00
+| Tool Crib
-|	0.00
+| 0.00
-|-
+| 0.00
-|	2
+|- valign="top"
 |	Sheet Metal Racks
-|	0.00
+| 2
-|	0.00
+| Sheet Metal Racks
-|-
+| 0.00
-|	3
+| 0.00
-|	Paint Shop
+|- valign="top"
 |	0.00
-|	0.00
+| 3
-|-
+| Paint Shop
-|	4
+| 0.00
-|	Paint Storage
+| 0.00
-|	0.00
+|- valign="top"
 |	0.00
-|-
+| 4
-|	5
+| Paint Storage
-|	Metal Storage
+| 0.00
-|	0.00
+| 0.00
-|	0.00
+|- valign="top"
 |-
-|	6
+| 5
-|	Miscellaneous Storage
+| Metal Storage
-|	0.00
+| 0.00
-|	0.00
+| 0.00
-|-
+|- valign="top"
 |	7
-|	Finished Goods Storage
+| 6
-|	0.00
+| Miscellaneous Storage
-|	0.00
+| 0.00
-|-
+| 0.00
-|	10
+|- valign="top"
 |	Frame Forming
-|	22.50
+| 7
-|	96.00
+| Finished Goods Storage
-|-
+| 0.00
-|	20
+| 0.00
-|	Frame Welding
+|- valign="top"
 |	25.00
-|	108.00
+| 10
-|-
+| Frame Forming
-|	30
+| 22.50
-|	Debur and Polish
+| 96.00
-|	14.50
+|- valign="top"
 |	120.00
-|-
+| 20
-|	40
+| Frame Welding
-|	Paint
+| 25.00
-|	15.75
+| 108.00
-|	120.00
+|- valign="top"
 |-
-|	45
+| 30
-|	Specialized Paint
+| Debur and Polish
-|	18.00
+| 14.50
-|	80.00
+| 120.00
-|-
+|- valign="top"
 |	50
-|	Subassembly
+| 40
-|	12.25
+| Paint
-|	120.00
+| 15.75
-|-
+| 120.00
-|	60
+|- valign="top"
 |	Final Assembly
-|	12.25
+| 45
-|	120.00
+| Specialized Paint
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Production.Location
@@ Line 8: / Line 8: @@
 | '''Description
 | Product inventory and manufacturing locations.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | LocationID
@@ Line 58: / Line 56: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_Location_LocationID
 | LocationID
@@ Line 69: / Line 67: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_Location_Name
 | Unique
@@ Line 82: / Line 80: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_Location_Availability
 | ([Availability]>=(0.00))
 | Check constraint [Availability] >= (0.00)
-|-
+|- valign="top"
 | CK_Location_CostRate
 | ([CostRate]>=(0.00))
@@ Line 99: / Line 97: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Production.ProductInventory_(table)|Production.ProductInventory]]
 | LocationID
 | LocationID
-|-
+|- valign="top"
 | [[Production.WorkOrderRouting_(table)|Production.WorkOrderRouting]]
 | LocationID
@@ Line 117: / Line 115: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Data Type
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for Location records.<br />PK_Location_LocationID
+| Primary key for Location records.
 |- valign="top"
 | Name
@@ Line 31: / Line 32: @@
 | not null
+|
-| Location description.<br />AK_Location_Name
+| Location description.
 |- valign="top"
 | CostRate
@@ Line 37: / Line 38: @@
 | not null
 | ((0.00))
-| Standard hourly cost of the manufacturing location.<br />
+| Standard hourly cost of the manufacturing location.
 |- valign="top"
 | Availability
@@ Line 43: / Line 44: @@
 | not null
 | ((0.00))
-| Work capacity (in hours) of the manufacturing location.<br />
+| Work capacity (in hours) of the manufacturing location.
 |- valign="top"
 | ModifiedDate
@@ Line 49: / Line 50: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 70: / Line 110: @@
 |}
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 81: / Line 121: @@
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
 |}
 == wikivalues ==

← Older revision		Revision as of 22:27, 28 December 2009
Line 83:		Line 83:

	\|}		\|}
−
−
−
	== wikivalues ==		== wikivalues ==

← Older revision		Revision as of 22:25, 28 December 2009
Line 83:		Line 83:

	\|}		\|}
		+
		+
		+
	== wikivalues ==		== wikivalues ==