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