Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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.

Community Additions

ADD
Show:
© 2015 Microsoft