dbo.FactInternetSales - AdventureWorksDW

Sample Data Warehouse Documentation

- AdventureWorksDW
  - Modules
  - Tables

Documentation	AdventureWorksDW
Schema	dbo
Name	FactInternetSales
Module	Internet Sales

Columns

		Name	Data type	References
	1	ProductKey	int	dbo.DimProduct
References: dbo.DimProduct
	2	OrderDateKey	int	dbo.DimDate
References: dbo.DimDate
	3	DueDateKey	int	dbo.DimDate
References: dbo.DimDate
	4	ShipDateKey	int	dbo.DimDate
References: dbo.DimDate
	5	CustomerKey	int	dbo.DimCustomer
References: dbo.DimCustomer
	6	PromotionKey	int	dbo.DimPromotion
References: dbo.DimPromotion
	7	CurrencyKey	int	dbo.DimCurrency
References: dbo.DimCurrency
	8	SalesTerritoryKey	int	dbo.DimSalesTerritory
References: dbo.DimSalesTerritory
	9	SalesOrderNumber	nvarchar(20)
	10	SalesOrderLineNumber	tinyint
	11	RevisionNumber	tinyint
	12	OrderQuantity	smallint
	13	UnitPrice	money
	14	ExtendedAmount	money
	15	UnitPriceDiscountPct	float
	16	DiscountAmount	float
	17	ProductStandardCost	money
	18	TotalProductCost	money
	19	SalesAmount	money
	20	TaxAmt	money
	21	Freight	money
	22	CarrierTrackingNumber	nvarchar(25)
	23	CustomerPONumber	nvarchar(25)
	24	OrderDate	datetime
	25	DueDate	datetime
	26	ShipDate	datetime

Relations

Foreign table	Primary table	Join	Title / Name / Description
dbo.FactInternetSales	dbo.DimCurrency	dbo.FactInternetSales.CurrencyKey = dbo.DimCurrency.CurrencyKey	FK_FactInternetSales_DimCurrency
dbo.FactInternetSales.CurrencyKey = dbo.DimCurrency.CurrencyKey Name: FK_FactInternetSales_DimCurrency
dbo.FactInternetSales	dbo.DimCustomer	dbo.FactInternetSales.CustomerKey = dbo.DimCustomer.CustomerKey	FK_FactInternetSales_DimCustomer
dbo.FactInternetSales.CustomerKey = dbo.DimCustomer.CustomerKey Name: FK_FactInternetSales_DimCustomer
dbo.FactInternetSales	dbo.DimDate	dbo.FactInternetSales.OrderDateKey = dbo.DimDate.DateKey	FK_FactInternetSales_DimDate
dbo.FactInternetSales.OrderDateKey = dbo.DimDate.DateKey Name: FK_FactInternetSales_DimDate
dbo.FactInternetSales	dbo.DimDate	dbo.FactInternetSales.DueDateKey = dbo.DimDate.DateKey	FK_FactInternetSales_DimDate1
dbo.FactInternetSales.DueDateKey = dbo.DimDate.DateKey Name: FK_FactInternetSales_DimDate1
dbo.FactInternetSales	dbo.DimDate	dbo.FactInternetSales.ShipDateKey = dbo.DimDate.DateKey	FK_FactInternetSales_DimDate2
dbo.FactInternetSales.ShipDateKey = dbo.DimDate.DateKey Name: FK_FactInternetSales_DimDate2
dbo.FactInternetSales	dbo.DimProduct	dbo.FactInternetSales.ProductKey = dbo.DimProduct.ProductKey	FK_FactInternetSales_DimProduct
dbo.FactInternetSales.ProductKey = dbo.DimProduct.ProductKey Name: FK_FactInternetSales_DimProduct
dbo.FactInternetSales	dbo.DimPromotion	dbo.FactInternetSales.PromotionKey = dbo.DimPromotion.PromotionKey	FK_FactInternetSales_DimPromotion
dbo.FactInternetSales.PromotionKey = dbo.DimPromotion.PromotionKey Name: FK_FactInternetSales_DimPromotion
dbo.FactInternetSales	dbo.DimSalesTerritory	dbo.FactInternetSales.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey	FK_FactInternetSales_DimSalesTerritory
dbo.FactInternetSales.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey Name: FK_FactInternetSales_DimSalesTerritory
dbo.FactInternetSalesReason	dbo.FactInternetSales	dbo.FactInternetSalesReason.SalesOrderLineNumber = dbo.FactInternetSales.SalesOrderLineNumber dbo.FactInternetSalesReason.SalesOrderNumber = dbo.FactInternetSales.SalesOrderNumber	FK_FactInternetSalesReason_FactInternetSales
dbo.FactInternetSalesReason.SalesOrderLineNumber = dbo.FactInternetSales.SalesOrderLineNumber dbo.FactInternetSalesReason.SalesOrderNumber = dbo.FactInternetSales.SalesOrderNumber Name: FK_FactInternetSalesReason_FactInternetSales

Unique keys

	Key name	Columns	Description
	PK_FactInternetSales_SalesOrderNumber_SalesOrderLineNumber	SalesOrderNumber, SalesOrderLineNumber

Uses

Name
dbo.FactInternetSales
dbo.DimCurrency
dbo.DimCustomer
dbo.DimDate
dbo.DimDate
dbo.DimDate
dbo.DimProduct
dbo.DimPromotion
dbo.DimSalesTerritory

Used by

Name
dbo.FactInternetSales
dbo.vDMPrep
dbo.vAssocSeqLineItems
dbo.vAssocSeqOrders
dbo.vTargetMail
dbo.vTimeSeries
dbo.FactInternetSalesReason

Exported: 2019-02-04 22:31, Last imported: 2019-02-04 21:58