SalesTerritoryHistory Table (AdventureWorks)

Tracks the transfer of sales representatives to other sales territories.

SalesTerritoryHistory Table Definition

The SalesTerritoryHistory table is contained in the Sales schema.

Column	Data type	Nullability	Description
SalesPersonID	int	Not null	Primary key.
TerritoryID	int	Not null	Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID.
StartDate	datetime	Not null	Date the sales representative started work in the territory.
EndDate	datetime	Null	Date the sales representative left work in the territory.
rowguid	uniqueidentifier	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	Not null	Date and time the row was last updated.