ScrewTurn Wiki

Navigation

Main Page

Quick Search

Advanced Search »

PoweredBy

PoweredBy

Discuss (0)View Page Code History

Sales.SalesTerritory_(table)

Modified: 2011/08/27 10:14 by wikibot - Uncategorized

» Sales.SalesTerritory_(table)

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

automatically generated

Table	Sales.SalesTerritory
Description	Sales territory lookup table.

Column	Data Type	Nullable	Default	Description / PK / Index
TerritoryID	int	not null		Primary key for SalesTerritory records. PK_SalesTerritory_TerritoryID
Name	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.

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

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

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

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.