Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Sales SalesTerritory (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 18:04


wikibot

TableSales.SalesTerritory
DescriptionSales territory lookup table.

ColumnData TypeNullableDefaultDescription / PK / Index
TerritoryIDintnot null Primary key for SalesTerritory records.
PK_SalesTerritory_TerritoryID
Namedbo.Namenot null Sales territory description
AK_SalesTerritory_Name
CountryRegionCodenvarchar(3)not null ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
Groupnvarchar(50)not null Geographic area to which the sales territory belong.
SalesYTDmoneynot null((0.00))Sales in the territory year to date.
SalesLastYearmoneynot null((0.00))Sales in the territory the previous year.
CostYTDmoneynot null((0.00))Business costs in the territory year to date.
CostLastYearmoneynot null((0.00))Business costs in the territory the previous year.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_SalesTerritory_rowguid
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



Detail TableColumnReferencing Column
Sales.CustomerTerritoryIDTerritoryID
Sales.SalesOrderHeaderTerritoryIDTerritoryID
Sales.SalesPersonTerritoryIDTerritoryID
Sales.SalesTerritoryHistoryTerritoryIDTerritoryID
Person.StateProvinceTerritoryIDTerritoryID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name

Reference TypeObject TypeReferencing ObjectChild TypeChild Object
SelectViewSales.vSalesPerson
SelectViewSales.vSalesPersonSalesByFiscalYears
UpdateTableSales.SalesOrderHeaderTriggeruSalesOrderHeader

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