Sales.SalesTaxRate (table) - Revision history

Bot at 08:56, 27 August 2011

2011-08-27T08:56:33Z

Bot at 22:17, 23 June 2010

2010-06-23T22:17:46Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:59Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:22Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:06Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:29Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:43Z

Bot at 23:13, 26 November 2009

2009-11-26T23:13:33Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:57Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:10Z

@@ Line 80: / Line 80: @@
 | '''Columns
 |- valign="top"
 | AK_SalesTaxRate_StateProvinceID_TaxType
 | Unique
 | StateProvinceID, TaxType
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.SalesTaxRate
@@ Line 8: / Line 8: @@
 | '''Description
 | Tax rate lookup table.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | SalesTaxRateID
@@ Line 70: / Line 68: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_SalesTaxRate_SalesTaxRateID
 | SalesTaxRateID
@@ Line 81: / Line 79: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_SalesTaxRate_StateProvinceID_TaxType
 | Unique
 | StateProvinceID, TaxType
-|-
+|- valign="top"
 | AK_SalesTaxRate_rowguid
 | Unique
@@ Line 98: / Line 96: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_SalesTaxRate_TaxType
 | ([TaxType]>=(1) AND [TaxType]<=(3))
@@ Line 111: / Line 109: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Person.StateProvince_(table)|Person.StateProvince]]
 | StateProvinceID
@@ Line 125: / Line 123: @@
 | '''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 SalesTaxRate records.<br />PK_SalesTaxRate_SalesTaxRateID
+| Primary key for SalesTaxRate records.
 |- valign="top"
 | StateProvinceID
@@ Line 31: / Line 32: @@
 | not null
+|
-| State, province, or country/region the sales tax applies to.<br />AK_SalesTaxRate_StateProvinceID_TaxType
+| State, province, or country/region the sales tax applies to.
 |- valign="top"
 | TaxType
@@ Line 37: / Line 38: @@
 | not null
+|
-| 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.<br />AK_SalesTaxRate_StateProvinceID_TaxType
+| 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.
 |- valign="top"
 | TaxRate
@@ Line 43: / Line 44: @@
 | not null
 | ((0.00))
-| Tax rate amount.<br />
+| Tax rate amount.
 |- valign="top"
 | Name
@@ Line 49: / Line 50: @@
 | not null
+|
-| Tax rate description.<br />
+| Tax rate description.
 |- valign="top"
 | rowguid
@@ Line 55: / Line 56: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SalesTaxRate_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 61: / Line 62: @@
 | 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 78: / Line 118: @@
 |}
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 89: / Line 129: @@
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Sales.SalesTaxRate
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | SalesTaxRateID
 | int
 | not null
+|
-| PK_SalesTaxRate_SalesTaxRateID
+| Primary key for SalesTaxRate records.<br />PK_SalesTaxRate_SalesTaxRateID
+|- valign="top"
 | StateProvinceID
 | int
 | not null
+|
+| State, province, or country/region the sales tax applies to.<br />AK_SalesTaxRate_StateProvinceID_TaxType
-| AK_SalesTaxRate_StateProvinceID_TaxType
+|- valign="top"
 | TaxType
 | tinyint
 | not null
+|
+| 1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions.<br />AK_SalesTaxRate_StateProvinceID_TaxType
-| AK_SalesTaxRate_StateProvinceID_TaxType
+|- valign="top"
 | TaxRate
 | smallmoney
 | not null
 | ((0.00))
+| Tax rate amount.<br />
+|- valign="top"
 | Name
 | dbo.Name
 | not null
+|
+| Tax rate description.<br />
+|- valign="top"
 | rowguid
 | uniqueidentifier
 | not null
 | (newid())
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SalesTaxRate_rowguid
-| AK_SalesTaxRate_rowguid
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 82: / Line 77: @@
 | StateProvinceID
 |}
 == automatically generated ==

@@ Line 89: / Line 89: @@
 | Sales.SalesTaxRate
 |- valign="top"
 | '''Description
 | Tax rate lookup table.
 |-
 |}

@@ Line 169: / Line 169: @@
 | '''Object Type
 | '''Dependency Type
-−
 |-
 | [[dbo.Name_(type)|dbo.Name]]
 | Type
 | Data Type
 |}