Difference between revisions of "Sales.SalesTerritory (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.SalesTerritory |- |} {| border="1" cellpadding="5" cellspacing="0" sty...) |
|||
Line 118: | Line 118: | ||
| TerritoryID | | TerritoryID | ||
| TerritoryID | | TerritoryID | ||
+ | |} | ||
+ | |||
+ | == wikivalues == | ||
+ | |||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- | ||
+ | | '''Table Values | ||
+ | | Sales.SalesTerritory | ||
+ | |- | ||
+ | |} | ||
+ | |||
+ | |||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
+ | | '''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 | ||
|} | |} |
Revision as of 14:53, 3 January 2009
wikibot
Table | Sales.SalesTerritory |
Column | Data Type | Nullable | Default | PK | Index |
TerritoryID | int | not null | PK_SalesTerritory_TerritoryID | ||
Name | dbo.Name | not null | AK_SalesTerritory_Name | ||
CountryRegionCode | nvarchar(3) | not null | |||
Group | nvarchar(50) | not null | |||
SalesYTD | money | not null | ((0.00)) | ||
SalesLastYear | money | not null | ((0.00)) | ||
CostYTD | money | not null | ((0.00)) | ||
CostLastYear | money | not null | ((0.00)) | ||
rowguid | uniqueidentifier | not null | (newid()) | AK_SalesTerritory_rowguid | |
ModifiedDate | datetime | not null | (getdate()) |
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 |
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 |