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

automatically generated

Table	Sales.SalesTerritoryHistory
Description	Sales representative transfers to other sales territories.

Column	Data Type	Nullable	Default	Description / PK / Index
SalesPersonID	int	not null		Primary key for SalesTerritoryHistory records. PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
TerritoryID	int	not null		Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID. PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
StartDate	datetime	not null		Date the sales representive started work in the territory. PK_SalesTerritoryHistory_SalesPersonID_StartDate_TerritoryID
EndDate	datetime	null		Date the sales representative left work in the territory.
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. AK_SalesTerritoryHistory_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

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