| Column | Data Type | Nullable | Default | Description / PK / Index |
| TerritoryID | int | not null | | Primary key for SalesTerritory records.
PK_SalesTerritory_TerritoryID |
| Name | dbo.Name | not null | | Sales territory description
AK_SalesTerritory_Name |
| CountryRegionCode | nvarchar(3) | not null | | ISO 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 | ((0.00)) | Sales in the territory year to date.
|
| SalesLastYear | money | not null | ((0.00)) | Sales in the territory the previous year.
|
| CostYTD | money | not null | ((0.00)) | Business costs in the territory year to date.
|
| CostLastYear | money | not null | ((0.00)) | Business costs in the territory the previous year.
|
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_SalesTerritory_rowguid |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated.
|