Sales.SalesTerritory (table) - Revision history

Bot at 08:56, 27 August 2011

2011-08-27T08:56:35Z

Bot at 22:18, 23 June 2010

2010-06-23T22:18:09Z

Bot at 22:17, 23 June 2010

2010-06-23T22:17:47Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:01Z

Bot at 22:27, 28 December 2009

2009-12-28T22:27:58Z

Bot at 22:25, 28 December 2009

2009-12-28T22:25:49Z

Bot at 22:13, 28 December 2009

2009-12-28T22:13:11Z

Show changes

Bot at 21:57, 28 December 2009

2009-12-28T21:57:49Z

Show changes

Bot at 21:55, 28 December 2009

2009-12-28T21:55:24Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:08Z

@@ Line 213: / Line 213: @@
 | uSalesOrderHeader
 |}
 == wikivalues ==

@@ Line 213: / Line 213: @@
 | uSalesOrderHeader
 |}
 == wikivalues ==
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table Values
 | Sales.SalesTerritory
 |}
 | '''TerritoryID
 | '''Name
 | '''CountryRegionCode
 | '''Group
-|-
+|- valign="top"
 |	1
-|	Northwest
+| 1
-|	US
+| Northwest
-|	North America
+| US
-|-
+| North America
-|	2
+|- valign="top"
 |	Northeast
-|	US
+| 2
-|	North America
+| Northeast
-|-
+| US
-|	3
+| North America
-|	Central
+|- valign="top"
 |	US
-|	North America
+| 3
-|-
+| Central
-|	4
+| US
-|	Southwest
+| North America
-|	US
+|- valign="top"
 |	North America
-|-
+| 4
-|	5
+| Southwest
-|	Southeast
+| US
-|	US
+| North America
-|	North America
+|- valign="top"
 |-
-|	6
+| 5
-|	Canada
+| Southeast
-|	CA
+| US
-|	North America
+| North America
-|-
+|- valign="top"
 |	7
-|	France
+| 6
-|	FR
+| Canada
-|	Europe
+| CA
-|-
+| North America
-|	8
+|- valign="top"
 |	Germany
-|	DE
+| 7
-|	Europe
+| France
-|-
+| FR
-|	9
+| Europe
-|	Australia
+|- valign="top"
 |	AU
-|	Pacific
+| 8
-|-
+| Germany
-|	10
+| DE
-|	United Kingdom
+| Europe
-|	GB
+|- valign="top"
 |	Europe
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.SalesTerritory
@@ Line 8: / Line 8: @@
 | '''Description
 | Sales territory lookup table.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | TerritoryID
@@ Line 88: / Line 86: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_SalesTerritory_TerritoryID
 | TerritoryID
@@ Line 99: / Line 97: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_SalesTerritory_Name
 | Unique
 | Name
-|-
+|- valign="top"
 | AK_SalesTerritory_rowguid
 | Unique
@@ Line 116: / Line 114: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_SalesTerritory_CostLastYear
 | ([CostLastYear]>=(0.00))
 | Check constraint [CostLastYear] >= (0.00)
-|-
+|- valign="top"
 | CK_SalesTerritory_CostYTD
 | ([CostYTD]>=(0.00))
 | Check constraint [CostYTD] >= (0.00)
-|-
+|- valign="top"
 | CK_SalesTerritory_SalesLastYear
 | ([SalesLastYear]>=(0.00))
 | Check constraint [SalesLastYear] >= (0.00)
-|-
+|- valign="top"
 | CK_SalesTerritory_SalesYTD
 | ([SalesYTD]>=(0.00))
@@ Line 141: / Line 139: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Sales.Customer_(table)|Sales.Customer]]
 | TerritoryID
 | TerritoryID
-|-
+|- valign="top"
 | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | TerritoryID
 | TerritoryID
-|-
+|- valign="top"
 | [[Sales.SalesPerson_(table)|Sales.SalesPerson]]
 | TerritoryID
 | TerritoryID
-|-
+|- valign="top"
 | [[Sales.SalesTerritoryHistory_(table)|Sales.SalesTerritoryHistory]]
 | TerritoryID
 | TerritoryID
-|-
+|- valign="top"
 | [[Person.StateProvince_(table)|Person.StateProvince]]
 | TerritoryID
@@ Line 171: / Line 169: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Data Type
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 193: / Line 191: @@
 | '''Child Object
-|-
+|- valign="top"
 | Select
 | View
@@ Line 200: / Line 198: @@
+|
+|
-|-
+|- valign="top"
 | Select
 | View
@@ Line 207: / Line 205: @@
+|
+|
-|-
+|- valign="top"
 | Update
 | Table

@@ 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 SalesTerritory records.<br />PK_SalesTerritory_TerritoryID
+| Primary key for SalesTerritory records.
 |- valign="top"
 | Name
@@ Line 31: / Line 32: @@
 | not null
+|
-| Sales territory description<br />AK_SalesTerritory_Name
+| Sales territory description
 |- valign="top"
 | CountryRegionCode
@@ Line 37: / Line 38: @@
 | not null
+|
-| ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. <br />
+| ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
 |- valign="top"
 | Group
@@ Line 43: / Line 44: @@
 | not null
+|
-| Geographic area to which the sales territory belong.<br />
+| Geographic area to which the sales territory belong.
 |- valign="top"
 | SalesYTD
@@ Line 49: / Line 50: @@
 | not null
 | ((0.00))
-| Sales in the territory year to date.<br />
+| Sales in the territory year to date.
 |- valign="top"
 | SalesLastYear
@@ Line 55: / Line 56: @@
 | not null
 | ((0.00))
-| Sales in the territory the previous year.<br />
+| Sales in the territory the previous year.
 |- valign="top"
 | CostYTD
@@ Line 61: / Line 62: @@
 | not null
 | ((0.00))
-| Business costs in the territory year to date.<br />
+| Business costs in the territory year to date.
 |- valign="top"
 | CostLastYear
@@ Line 67: / Line 68: @@
 | not null
 | ((0.00))
-| Business costs in the territory the previous year.<br />
+| Business costs in the territory the previous year.
 |- valign="top"
 | rowguid
@@ Line 73: / Line 74: @@
 | not null
 | (newid())
-| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SalesTerritory_rowguid
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 |- valign="top"
 | ModifiedDate
@@ Line 79: / Line 80: @@
 | 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 112: / Line 164: @@
 |}
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 123: / Line 175: @@
 | Type
 | [[dbo.Name_(type)|dbo.Name]]
 |}
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 158: / Line 215: @@
 | uSalesOrderHeader
 |}
 == wikivalues ==

@@ Line 158: / Line 158: @@
 | uSalesOrderHeader
 |}
 == wikivalues ==