Share via


SalesTerritory Table (AdventureWorks)

Is a lookup table that contains the sales territories covered by the Adventure Works Cycles sales teams.

SalesTerritory Table Definition

The SalesTerritory table is contained in the Sales schema.

Column Data type Nullability Description

TerritoryID

int

Not null

Primary key.

Name

Name (user-defined type)

nvarchar(50)

Not null

Sales territory description

CountryRegionCode

nvarchar(3)

Not null

Standard country or region code. Foreign key to CountryRegion.CountryRegionCode.

Group

nvarchar(50)

Not null

Geographic area to which the sales territory belong.

SalesYTD

money

Not null

Sales in the territory year to date.

SalesLastYear

money

Not null

Sales in the territory the previous year.

CostYTD

money

Not null

Business costs for the territory year to-date.

CostLastYear

money

Not null

Business costs for the territory the previous year.

rowguid

uniqueidentifier

Not null

ROWGUIDCOL number uniquely identifying the row. 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)
SalesOrderHeader Table (AdventureWorks)
SalesPerson Table (AdventureWorks)
SalesTerritoryHistory Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance