SalesTerritoryHistory Table (AdventureWorks)
Tracks the transfer of sales representatives to other sales territories.
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. |
