Table: FactInternetSales

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   FactInternetSales 
 Friendly name   Internet Sales Facts 
 Table name   dbo_FactInternetSales 
 Table type   Table 
 Is loaded    

Collapse image Query definition


No relationships exist

Collapse image Parent relations


Relation name  Child (foreign key) columns  Parent name  Parent type  Parent (primary key) columns 
FK_FactInternetSales_DimSalesTerritory SalesTerritoryKey DimSalesTerritory Table SalesTerritoryKey
FK_FactInternetSales_DimPromotion PromotionKey DimPromotion Table PromotionKey
FK_FactInternetSales_DimProduct ProductKey DimProduct Table ProductKey
FK_FactInternetSales_DimCustomer CustomerKey DimCustomer Table CustomerKey
FK_FactInternetSales_DimDate2 ShipDateKey DimDate Table DateKey
FK_FactInternetSales_DimDate1 DueDateKey DimDate Table DateKey
FK_FactInternetSales_DimDate OrderDateKey DimDate Table DateKey
FK_FactInternetSales_DimCurrency CurrencyKey Currency View CurrencyKey
Total: 8 parent relationship(s)

Collapse image Child relations


Relation name  Parent (primary key) columns  Child name  Child type  Child (foreign key) columns 
FK_FactInternetSalesReason_FactInternetSales SalesOrderNumber, SalesOrderLineNumber FactInternetSalesReason Table SalesOrderNumber, SalesOrderLineNumber
Total: 1 child relationship(s)

Collapse image Columns


Name  Type  Computed column expression 
ProductKey System.Int32  
OrderDateKey System.Int32  
DueDateKey System.Int32  
ShipDateKey System.Int32  
CustomerKey System.Int32  
PromotionKey System.Int32  
CurrencyKey System.Int32  
SalesTerritoryKey System.Int32  
SalesOrderNumber System.String  
SalesOrderLineNumber System.Byte  
RevisionNumber System.Byte  
OrderQuantity System.Int16  
UnitPrice System.Decimal  
ExtendedAmount System.Decimal  
UnitPriceDiscountPct System.Double  
DiscountAmount System.Double  
ProductStandardCost System.Decimal  
TotalProductCost System.Decimal  
SalesAmount System.Decimal  
TaxAmt System.Decimal  
Freight System.Decimal  
CarrierTrackingNumber System.String  
CustomerPONumber System.String  
SalesOrderDesc System.String
CONVERT ( CHAR ( 10 ), SalesOrderNumber )  + 'Line '  + 
CONVERT ( CHAR ( 4 ), SalesOrderLineNumber )
OrderDate System.DateTime  
DueDate System.DateTime  
ShipDate System.DateTime  
Total: 27 column(s)

Collapse image See also


About this documentation