Welcome Guest, you are in: <root> • Login

Page History: Sales SalesTerritory (table)

Compare Page Revisions

5 4 3 2 1 0 Current 5 4 3 2 1 0

« Older Revision - Back to Page History - Current Revision

Page Revision: 2010/06/24 01:10

wikibot ¶

Table	Sales.SalesTerritory
Description	Sales territory lookup table.

Columns ¶

Column	Data Type	Nullable	Default	Description
TerritoryID	int	not null		Primary key for SalesTerritory records.
Name	dbo.Name	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	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.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key ¶

Primary Key	Columns
PK_SalesTerritory_TerritoryID	TerritoryID

Indexes ¶

Index	Type	Columns
AK_SalesTerritory_Name	Unique	Name
AK_SalesTerritory_rowguid	Unique	rowguid

Check Constraints ¶

Check Constraint	Expression	Description
CK_SalesTerritory_CostLastYear	(CostLastYear>=(0.00))	Check constraint CostLastYear >= (0.00)
CK_SalesTerritory_CostYTD	(CostYTD>=(0.00))	Check constraint CostYTD >= (0.00)
CK_SalesTerritory_SalesLastYear	(SalesLastYear>=(0.00))	Check constraint SalesLastYear >= (0.00)
CK_SalesTerritory_SalesYTD	(SalesYTD>=(0.00))	Check constraint SalesYTD >= (0.00)

Detail Tables ¶

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

References ¶

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Sales

Dependencies ¶

Reference Type	Object Type	Referencing Object	Child Type	Child Object
Select	View	Sales.vSalesPerson
Select	View	Sales.vSalesPersonSalesByFiscalYears
Update	Table	Sales.SalesOrderHeader	Trigger	uSalesOrderHeader

wikivalues ¶

Table Values

Sales.SalesTerritory

TerritoryID	Name	CountryRegionCode	Group
1	Northwest	US	North America
2	Northeast	US	North America
3	Central	US	North America
4	Southwest	US	North America
5	Southeast	US	North America
6	Canada	CA	North America
7	France	FR	Europe
8	Germany	DE	Europe
9	Australia	AU	Pacific
10	United Kingdom	GB	Europe