Table: DimSalesTerritory

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   DimSalesTerritory 
 Friendly name   Sales Territory 
 Table name   dbo_DimSalesTerritory 
 Table type   Table 
 Is loaded    

Collapse image Query definition


No relationships exist

Collapse image Parent relations


No relationships exist

Collapse image Child relations


Relation name  Parent (primary key) columns  Child name  Child type  Child (foreign key) columns 
FK_FactResellerSales_DimSalesTerritory SalesTerritoryKey FactResellerSales Table SalesTerritoryKey
FK_FactInternetSales_DimSalesTerritory SalesTerritoryKey FactInternetSales Table SalesTerritoryKey
FK_DimGeography_DimSalesTerritory SalesTerritoryKey DimGeography Table SalesTerritoryKey
FK_DimEmployee_DimSalesTerritory SalesTerritoryKey DimEmployee Table SalesTerritoryKey
FactSalesSummary-DimSalesTerritory SalesTerritoryKey Sales Summary Facts View SalesTerritoryKey
Total: 5 child relationship(s)

Collapse image Columns


Name  Type  Computed column expression 
SalesTerritoryKey System.Int32  
SalesTerritoryAlternateKey System.Int32  
SalesTerritoryRegion System.String  
SalesTerritoryCountry System.String  
SalesTerritoryGroup System.String  
SalesTerritoryImage System.Byte[]  
Total: 6 column(s)

Collapse image See also


About this documentation