Purchasing.ShipMethod (table) - Revision history

Bot at 08:56, 27 August 2011

2011-08-27T08:56:02Z

Bot at 22:18, 23 June 2010

2010-06-23T22:18:12Z

Bot at 22:17, 23 June 2010

2010-06-23T22:17:16Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:02Z

Bot at 22:28, 28 December 2009

2009-12-28T22:28:03Z

Bot at 22:25, 28 December 2009

2009-12-28T22:25:55Z

Bot at 22:13, 28 December 2009

2009-12-28T22:13:16Z

WikiSysop: Undo revision 2000 by Bot (Talk)

2009-12-28T22:11:12Z

Undo revision 2000 by Bot (Talk)

Show changes

Bot at 21:57, 28 December 2009

2009-12-28T21:57:57Z

Show changes

Bot at 21:55, 28 December 2009

2009-12-28T21:55:30Z

← Older revision		Revision as of 08:56, 27 August 2011
Line 136:		Line 136:

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

@@ Line 136: / Line 136: @@
 |}
 == wikivalues ==
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table Values
 | Purchasing.ShipMethod
 |}
 | '''ShipMethodID
 | '''Name
 | '''ShipBase
 | '''ShipRate
-|-
+|- valign="top"
 |	1
-|	XRQ - TRUCK GROUND
+| 1
-|	3.95
+| XRQ - TRUCK GROUND
-|	0.99
+| 3.95
-|-
+| 0.99
-|	2
+|- valign="top"
 |	ZY - EXPRESS
-|	9.95
+| 2
-|	1.99
+| ZY - EXPRESS
-|-
+| 9.95
-|	3
+| 1.99
-|	OVERSEAS - DELUXE
+|- valign="top"
 |	29.95
-|	2.99
+| 3
-|-
+| OVERSEAS - DELUXE
-|	4
+| 29.95
-|	OVERNIGHT J-FAST
+| 2.99
-|	21.95
+|- valign="top"
 |	1.29
-|-
+| 4
-|	5
+| OVERNIGHT J-FAST
-|	CARGO TRANSPORT 5
+| 21.95
-|	8.99
+| 1.29
-|	1.49
+|- valign="top"
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Purchasing.ShipMethod
@@ Line 8: / Line 8: @@
 | '''Description
 | Shipping company lookup table.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | ShipMethodID
@@ Line 64: / Line 62: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_ShipMethod_ShipMethodID
 | ShipMethodID
@@ Line 75: / Line 73: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_ShipMethod_Name
 | Unique
 | Name
-|-
+|- valign="top"
 | AK_ShipMethod_rowguid
 | Unique
@@ Line 92: / Line 90: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_ShipMethod_ShipBase
 | ([ShipBase]>(0.00))
 | Check constraint [ShipBase] > (0.00)
-|-
+|- valign="top"
 | CK_ShipMethod_ShipRate
 | ([ShipRate]>(0.00))
@@ Line 109: / Line 107: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 | ShipMethodID
 | ShipMethodID
-|-
+|- valign="top"
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | ShipMethodID
@@ Line 127: / Line 125: @@
 | '''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 ShipMethod records.<br />PK_ShipMethod_ShipMethodID
+| Primary key for ShipMethod records.
 |- valign="top"
 | Name
@@ Line 31: / Line 32: @@
 | not null
+|
-| Shipping company name.<br />AK_ShipMethod_Name
+| Shipping company name.
 |- valign="top"
 | ShipBase
@@ Line 37: / Line 38: @@
 | not null
 | ((0.00))
-| Minimum shipping charge.<br />
+| Minimum shipping charge.
 |- valign="top"
 | ShipRate
@@ Line 43: / Line 44: @@
 | not null
 | ((0.00))
-| Shipping charge per pound.<br />
+| Shipping charge per pound.
 |- valign="top"
 | rowguid
@@ Line 49: / Line 50: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_ShipMethod_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 55: / Line 56: @@
 | 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 76: / Line 120: @@
 |}
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 87: / Line 131: @@
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
 |}
 == wikivalues ==

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

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

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

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

@@ Line 89: / Line 89: @@
 |}
 == wikivalues ==
@@ Line 134: / Line 131: @@
 |	1.49
 |}
 == automatically generated ==