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())

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.