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.