Sales.SalesTerritory

Field Name Data Type Size Original Type Default Nullable Description Check

TerritoryID int identity int Not null Primary key for SalesTerritory records.

Name Name nvarchar(50) Not null Sales territory description

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 19,4 decimal(19,4) (0.00) Not null Sales in the territory year to date. ([SalesYTD]>=(0.00))

SalesLastYear money 19,4 decimal(19,4) (0.00) Not null Sales in the territory the previous year. ([SalesLastYear]>=(0.00))

CostYTD money 19,4 decimal(19,4) (0.00) Not null Business costs in the territory year to date. ([CostYTD]>=(0.00))

CostLastYear money 19,4 decimal(19,4) (0.00) Not null Business costs in the territory the previous year. ([CostLastYear]>=(0.00))

rowguid uniqueidentifier newid() Not null ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
TerritoryID	int identity		int		Not null	Primary key for SalesTerritory records.
Name	Name		nvarchar(50)		Not null	Sales territory description
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	19,4	decimal(19,4)	(0.00)	Not null	Sales in the territory year to date.	([SalesYTD]>=(0.00))
SalesLastYear	money	19,4	decimal(19,4)	(0.00)	Not null	Sales in the territory the previous year.	([SalesLastYear]>=(0.00))
CostYTD	money	19,4	decimal(19,4)	(0.00)	Not null	Business costs in the territory year to date.	([CostYTD]>=(0.00))
CostLastYear	money	19,4	decimal(19,4)	(0.00)	Not null	Business costs in the territory the previous year.	([CostLastYear]>=(0.00))
rowguid	uniqueidentifier			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SalesTerritory'

Primary Key Name Field Name

PK_SalesTerritory_TerritoryID TerritoryID

There are no Foreign Keys for this table.

Primary Key Name	Field Name
PK_SalesTerritory_TerritoryID	TerritoryID

Indexes for table 'Sales.SalesTerritory', 3 items

Index Name Description Clustered Unique Fields

PK_SalesTerritory_TerritoryID Clustered index created by a primary key constraint. Yes Yes TerritoryID

AK_SalesTerritory_Name Unique nonclustered index. No Yes Name

AK_SalesTerritory_rowguid Unique nonclustered index. Used to support replication samples. No Yes rowguid

Index Name	Description	Clustered	Unique	Fields
PK_SalesTerritory_TerritoryID	Clustered index created by a primary key constraint.	Yes	Yes	TerritoryID
AK_SalesTerritory_Name	Unique nonclustered index.	No	Yes	Name
AK_SalesTerritory_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid

Triggers for table 'Sales.SalesTerritory', 1 item

Name Description Type Enabled

uSalesTerritory AFTER UPDATE trigger setting the ModifiedDate column in the SalesTerritory table to the current date. after Update Yes

Name	Description	Type	Enabled
uSalesTerritory	AFTER UPDATE trigger setting the ModifiedDate column in the SalesTerritory table to the current date.	after Update	Yes

Dependencies for table 'Sales.SalesTerritory', 8 items

Object Name Type Field Name

Sales.CK_SalesTerritory_CostLastYear check cns N/A

Sales.CK_SalesTerritory_CostYTD check cns N/A

Sales.CK_SalesTerritory_SalesLastYear check cns N/A

Sales.CK_SalesTerritory_SalesYTD check cns N/A

Sales.uSalesOrderHeader trigger N/A

Sales.uSalesTerritory trigger N/A

Sales.vSalesPerson view N/A

Sales.vSalesPersonSalesByFiscalYears view N/A