Sales.SalesTerritoryHistory (table)

wikibot

Table

Sales.SalesTerritoryHistory

Column	Data Type	Nullable	Default	PK	Index
SalesPersonID	int	not null		PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
TerritoryID	int	not null		PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
StartDate	datetime	not null		PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
EndDate	datetime	null
rowguid	uniqueidentifier	not null	(newid())		AK_SalesTerritoryHistory_rowguid
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Sales.SalesPerson	SalesPersonID	SalesPersonID
Sales.SalesTerritory	TerritoryID	TerritoryID