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. |