Fact.Order - WideWorldImportersDW

WideWorldImportersDW

- WideWorldImportersDW

Documentation	WideWorldImportersDW
Schema	Fact
Name	Order
Module	Order

Order fact table (customer orders)

Columns

		Name	Data type	Attributes	References	Description
	1	Order Key	bigint	Identity		DW key for a row in the Order fact
DW key for a row in the Order fact Identity
	2	City Key	int		Dimension.City	City for this order
City for this order References: Dimension.City
	3	Customer Key	int		Dimension.Customer	Customer for this order
Customer for this order References: Dimension.Customer
	4	Stock Item Key	int		Dimension.Stock Item	Stock item for this order
Stock item for this order References: Dimension.Stock Item
	5	Order Date Key	date		Dimension.Date	Order date for this order
Order date for this order References: Dimension.Date
	6	Picked Date Key	date		Dimension.Date	Picked date for this order
Picked date for this order References: Dimension.Date
	7	Salesperson Key	int		Dimension.Employee	Salesperson for this order
Salesperson for this order References: Dimension.Employee
	8	Picker Key	int		Dimension.Employee	Picker for this order
Picker for this order References: Dimension.Employee
	9	WWI Order ID	int			OrderID in source system
OrderID in source system
	10	WWI Backorder ID	int			BackorderID in source system
BackorderID in source system
	11	Description	nvarchar(100)			Description of the item supplied (Usually the stock item name but can be overridden)
Description of the item supplied (Usually the stock item name but can be overridden)
	12	Package	nvarchar(50)			Type of package to be supplied
Type of package to be supplied
	13	Quantity	int			Quantity to be supplied
Quantity to be supplied
	14	Unit Price	decimal(18, 2)			Unit price to be charged
Unit price to be charged
	15	Tax Rate	decimal(18, 3)			Tax rate to be applied
Tax rate to be applied
	16	Total Excluding Tax	decimal(18, 2)			Total amount excluding tax
Total amount excluding tax
	17	Tax Amount	decimal(18, 2)			Total amount of tax
Total amount of tax
	18	Total Including Tax	decimal(18, 2)			Total amount including tax
Total amount including tax
	19	Lineage Key	int			Lineage Key for the data load for this row
Lineage Key for the data load for this row

Relations

Foreign table	Primary table	Join	Title / Name / Description
Fact.Order	Dimension.City	Fact.Order.City Key = Dimension.City.City Key	FK_Fact_Order_City_Key_Dimension_City Foreign key constraint referencing City.City Key
Fact.Order.City Key = Dimension.City.City Key Name: FK_Fact_Order_City_Key_Dimension_City Foreign key constraint referencing City.City Key
Fact.Order	Dimension.Customer	Fact.Order.Customer Key = Dimension.Customer.Customer Key	FK_Fact_Order_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Order.Customer Key = Dimension.Customer.Customer Key Name: FK_Fact_Order_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Order	Dimension.Date	Fact.Order.Order Date Key = Dimension.Date.Date	FK_Fact_Order_Order_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Order.Order Date Key = Dimension.Date.Date Name: FK_Fact_Order_Order_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Order	Dimension.Date	Fact.Order.Picked Date Key = Dimension.Date.Date	FK_Fact_Order_Picked_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Order.Picked Date Key = Dimension.Date.Date Name: FK_Fact_Order_Picked_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Order	Dimension.Employee	Fact.Order.Picker Key = Dimension.Employee.Employee Key	FK_Fact_Order_Picker_Key_Dimension_Employee Foreign key constraint referencing Employee.Employee Key
Fact.Order.Picker Key = Dimension.Employee.Employee Key Name: FK_Fact_Order_Picker_Key_Dimension_Employee Foreign key constraint referencing Employee.Employee Key
Fact.Order	Dimension.Employee	Fact.Order.Salesperson Key = Dimension.Employee.Employee Key	FK_Fact_Order_Salesperson_Key_Dimension_Employee Foreign key constraint referencing Employee.Employee Key
Fact.Order.Salesperson Key = Dimension.Employee.Employee Key Name: FK_Fact_Order_Salesperson_Key_Dimension_Employee Foreign key constraint referencing Employee.Employee Key
Fact.Order	Dimension.Stock Item	Fact.Order.Stock Item Key = Dimension.Stock Item.Stock Item Key	FK_Fact_Order_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Order.Stock Item Key = Dimension.Stock Item.Stock Item Key Name: FK_Fact_Order_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key

Unique keys

	Key name	Columns	Description
	PK_Fact_Order	Order Key, Order Date Key	Primary key (nonclustered) constraint.
Primary key (nonclustered) constraint.

Uses

Name
Fact.Order
Dimension.City
Dimension.Customer
Dimension.Date
Dimension.Date
Dimension.Employee
Dimension.Employee
Dimension.Stock Item

Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59