Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |
See Also
Reference
CountryRegion Table (AdventureWorks)
Employee Table (AdventureWorks)
SalesPerson Table (AdventureWorks)
SalesTerritory Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary