Sales.SalesTerritory

Table: 'Sales.SalesTerritory'

10 fields. 326 bytes.

Sales territory lookup table.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
TerritoryIDint identity int Not nullPrimary key for SalesTerritory records. 
NameName nvarchar(50) Not nullSales territory description 
CountryRegionCodenvarchar3  Not nullISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.  
Groupnvarchar50  Not nullGeographic area to which the sales territory belong. 
SalesYTDmoney19,4decimal(19,4)(0.00)Not nullSales in the territory year to date.([SalesYTD]>=(0.00))
SalesLastYearmoney19,4decimal(19,4)(0.00)Not nullSales in the territory the previous year.([SalesLastYear]>=(0.00))
CostYTDmoney19,4decimal(19,4)(0.00)Not nullBusiness costs in the territory year to date.([CostYTD]>=(0.00))
CostLastYearmoney19,4decimal(19,4)(0.00)Not nullBusiness costs in the territory the previous year.([CostLastYear]>=(0.00))
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.SalesTerritory'

Primary Key NameField Name
PK_SalesTerritory_TerritoryIDTerritoryID
There are no Foreign Keys for this table.

Indexes for table 'Sales.SalesTerritory', 3 items

Index NameDescriptionClusteredUniqueFields
PK_SalesTerritory_TerritoryIDClustered index created by a primary key constraint.YesYesTerritoryID
AK_SalesTerritory_NameUnique nonclustered index.NoYesName
AK_SalesTerritory_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid

Triggers for table 'Sales.SalesTerritory', 1 item

NameDescriptionTypeEnabled
uSalesTerritoryAFTER 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 NameTypeField Name
Sales.CK_SalesTerritory_CostLastYearcheck cnsN/A
Sales.CK_SalesTerritory_CostYTDcheck cnsN/A
Sales.CK_SalesTerritory_SalesLastYearcheck cnsN/A
Sales.CK_SalesTerritory_SalesYTDcheck cnsN/A
Sales.uSalesOrderHeadertriggerN/A
Sales.uSalesTerritorytriggerN/A
Sales.vSalesPersonviewN/A
Sales.vSalesPersonSalesByFiscalYearsviewN/A