Sales.SalesTerritoryHistory (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:49Z

Bot at 22:06, 2 February 2010

2010-02-02T22:06:08Z

Bot at 21:55, 28 December 2009

2009-12-28T21:55:26Z

Bot at 06:00, 30 November 2009

2009-11-30T06:00:10Z

Bot at 05:35, 30 November 2009

2009-11-30T05:35:32Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:47Z

Bot at 23:13, 26 November 2009

2009-11-26T23:13:36Z

Bot at 23:11, 26 November 2009

2009-11-26T23:11:00Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:13Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:25Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.SalesTerritoryHistory
@@ Line 8: / Line 8: @@
 | '''Description
 | Sales representative transfers to other sales territories.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | SalesPersonID
@@ Line 64: / Line 62: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
 | SalesPersonID, TerritoryID, StartDate
@@ Line 75: / Line 73: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_SalesTerritoryHistory_rowguid
 | Unique
@@ Line 88: / Line 86: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_SalesTerritoryHistory_EndDate
 | ([EndDate]>=[StartDate] OR [EndDate] IS NULL)
@@ Line 101: / Line 99: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Sales.SalesPerson_(table)|Sales.SalesPerson]]
 | SalesPersonID
 | SalesPersonID
-|-
+|- valign="top"
 | [[Sales.SalesTerritory_(table)|Sales.SalesTerritory]]
 | TerritoryID
@@ Line 119: / Line 117: @@
 | '''Referenced Object
-|-
+|- 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 SalesTerritoryHistory records.<br />PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
+| Primary key for SalesTerritoryHistory records.
 |- valign="top"
 | TerritoryID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.<br />PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
+| Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
 |- valign="top"
 | StartDate
@@ Line 37: / Line 38: @@
 | not null
+|
-| Date the sales representive started work in the territory.<br />PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
+| Date the sales representive started work in the territory.
 |- valign="top"
 | EndDate
@@ Line 43: / Line 44: @@
 | null
+|
-| Date the sales representative left work in the territory.<br />
+| Date the sales representative left work in the territory.
 |- 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_SalesTerritoryHistory_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 112: @@
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Sales.SalesTerritoryHistory
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | SalesPersonID
 | int
 | not null
+|
-| PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
+| Primary key for SalesTerritoryHistory records.<br />PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
+|- valign="top"
 | TerritoryID
 | int
 | not null
+|
-| PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
+| Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.<br />PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
+|- valign="top"
 | StartDate
 | datetime
 | not null
+|
-| PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
+| Date the sales representive started work in the territory.<br />PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
+|- valign="top"
 | EndDate
 | datetime
 | null
+|
+| Date the sales representative left work in the territory.<br />
+|- valign="top"
 | rowguid
 | uniqueidentifier
 | not null
 | (newid())
+| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_SalesTerritoryHistory_rowguid
-| AK_SalesTerritoryHistory_rowguid
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 79: / Line 75: @@
 | TerritoryID
 |}
 == automatically generated ==

@@ Line 86: / Line 86: @@
 | Sales.SalesTerritoryHistory
 |- valign="top"
 | '''Description
 | Sales representative transfers to other sales territories.
 |-
 |}

@@ Line 161: / Line 161: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}