dbo.FactResellerSales - AdventureWorksDW

Sample Data Warehouse Documentation

- AdventureWorksDW
  - Modules
  - Tables

Documentation	AdventureWorksDW
Schema	dbo
Name	FactResellerSales
Module	Reseller 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	ResellerKey	int	dbo.DimReseller
References: dbo.DimReseller
	6	EmployeeKey	int	dbo.DimEmployee
References: dbo.DimEmployee
	7	PromotionKey	int	dbo.DimPromotion
References: dbo.DimPromotion
	8	CurrencyKey	int	dbo.DimCurrency
References: dbo.DimCurrency
	9	SalesTerritoryKey	int	dbo.DimSalesTerritory
References: dbo.DimSalesTerritory
	10	SalesOrderNumber	nvarchar(20)
	11	SalesOrderLineNumber	tinyint
	12	RevisionNumber	tinyint
	13	OrderQuantity	smallint
	14	UnitPrice	money
	15	ExtendedAmount	money
	16	UnitPriceDiscountPct	float
	17	DiscountAmount	float
	18	ProductStandardCost	money
	19	TotalProductCost	money
	20	SalesAmount	money
	21	TaxAmt	money
	22	Freight	money
	23	CarrierTrackingNumber	nvarchar(25)
	24	CustomerPONumber	nvarchar(25)
	25	OrderDate	datetime
	26	DueDate	datetime
	27	ShipDate	datetime

Relations

Foreign table	Primary table	Join	Title / Name / Description
dbo.FactResellerSales	dbo.DimCurrency	dbo.FactResellerSales.CurrencyKey = dbo.DimCurrency.CurrencyKey	FK_FactResellerSales_DimCurrency
dbo.FactResellerSales.CurrencyKey = dbo.DimCurrency.CurrencyKey Name: FK_FactResellerSales_DimCurrency
dbo.FactResellerSales	dbo.DimDate	dbo.FactResellerSales.OrderDateKey = dbo.DimDate.DateKey	FK_FactResellerSales_DimDate
dbo.FactResellerSales.OrderDateKey = dbo.DimDate.DateKey Name: FK_FactResellerSales_DimDate
dbo.FactResellerSales	dbo.DimDate	dbo.FactResellerSales.DueDateKey = dbo.DimDate.DateKey	FK_FactResellerSales_DimDate1
dbo.FactResellerSales.DueDateKey = dbo.DimDate.DateKey Name: FK_FactResellerSales_DimDate1
dbo.FactResellerSales	dbo.DimDate	dbo.FactResellerSales.ShipDateKey = dbo.DimDate.DateKey	FK_FactResellerSales_DimDate2
dbo.FactResellerSales.ShipDateKey = dbo.DimDate.DateKey Name: FK_FactResellerSales_DimDate2
dbo.FactResellerSales	dbo.DimEmployee	dbo.FactResellerSales.EmployeeKey = dbo.DimEmployee.EmployeeKey	FK_FactResellerSales_DimEmployee
dbo.FactResellerSales.EmployeeKey = dbo.DimEmployee.EmployeeKey Name: FK_FactResellerSales_DimEmployee
dbo.FactResellerSales	dbo.DimProduct	dbo.FactResellerSales.ProductKey = dbo.DimProduct.ProductKey	FK_FactResellerSales_DimProduct
dbo.FactResellerSales.ProductKey = dbo.DimProduct.ProductKey Name: FK_FactResellerSales_DimProduct
dbo.FactResellerSales	dbo.DimPromotion	dbo.FactResellerSales.PromotionKey = dbo.DimPromotion.PromotionKey	FK_FactResellerSales_DimPromotion
dbo.FactResellerSales.PromotionKey = dbo.DimPromotion.PromotionKey Name: FK_FactResellerSales_DimPromotion
dbo.FactResellerSales	dbo.DimReseller	dbo.FactResellerSales.ResellerKey = dbo.DimReseller.ResellerKey	FK_FactResellerSales_DimReseller
dbo.FactResellerSales.ResellerKey = dbo.DimReseller.ResellerKey Name: FK_FactResellerSales_DimReseller
dbo.FactResellerSales	dbo.DimSalesTerritory	dbo.FactResellerSales.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey	FK_FactResellerSales_DimSalesTerritory
dbo.FactResellerSales.SalesTerritoryKey = dbo.DimSalesTerritory.SalesTerritoryKey Name: FK_FactResellerSales_DimSalesTerritory

Unique keys

	Key name	Columns	Description
	PK_FactResellerSales_SalesOrderNumber_SalesOrderLineNumber	SalesOrderNumber, SalesOrderLineNumber

Uses

Name
dbo.FactResellerSales
dbo.DimCurrency
dbo.DimDate
dbo.DimDate
dbo.DimDate
dbo.DimEmployee
dbo.DimProduct
dbo.DimPromotion
dbo.DimReseller
dbo.DimSalesTerritory

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