Sales.SalesTerritory (table)

wikibot

Table

Sales.SalesTerritory

Column	Data Type	Nullable	Default	PK	Index
TerritoryID	int	not null		PK_SalesTerritory_TerritoryID
Name	dbo.Name	not null			AK_SalesTerritory_Name
CountryRegionCode	nvarchar(3)	not null
Group	nvarchar(50)	not null
SalesYTD	money	not null	((0.00))
SalesLastYear	money	not null	((0.00))
CostYTD	money	not null	((0.00))
CostLastYear	money	not null	((0.00))
rowguid	uniqueidentifier	not null	(newid())		AK_SalesTerritory_rowguid
ModifiedDate	datetime	not null	(getdate())

Detail Table	Column	Referencing Column
Sales.Customer	TerritoryID	TerritoryID
Sales.SalesOrderHeader	TerritoryID	TerritoryID
Sales.SalesPerson	TerritoryID	TerritoryID
Sales.SalesTerritoryHistory	TerritoryID	TerritoryID
Person.StateProvince	TerritoryID	TerritoryID

wikivalues

Table Values

Sales.SalesTerritory

TerritoryID	Name	CountryRegionCode	Group
1	Northwest	US	North America
2	Northeast	US	North America
3	Central	US	North America
4	Southwest	US	North America
5	Southeast	US	North America
6	Canada	CA	North America
7	France	FR	Europe
8	Germany	DE	Europe
9	Australia	AU	Pacific
10	United Kingdom	GB	Europe