Fact.Purchase - WideWorldImportersDW

Purchase fact table (stock purchases from suppliers)

Columns

		Name	Data type	Attributes	References	Description
	1	Purchase Key	bigint	Identity		DW key for a row in the Purchase fact
DW key for a row in the Purchase fact Identity
	2	Date Key	date		Dimension.Date	Purchase order date
Purchase order date References: Dimension.Date
	3	Supplier Key	int		Dimension.Supplier	Supplier for this purchase order
Supplier for this purchase order References: Dimension.Supplier
	4	Stock Item Key	int		Dimension.Stock Item	Stock item for this purchase order
Stock item for this purchase order References: Dimension.Stock Item
	5	WWI Purchase Order ID	int			Purchase order ID in source system
Purchase order ID in source system
	6	Ordered Outers	int			Quantity of outers (ordering packages)
Quantity of outers (ordering packages)
	7	Ordered Quantity	int			Quantity of inners (selling packages)
Quantity of inners (selling packages)
	8	Received Outers	int			Received outers (so far)
Received outers (so far)
	9	Package	nvarchar(50)			Package ordered
Package ordered
	10	Is Order Finalized	bit			Is this purchase order now finalized?
Is this purchase order now finalized?
	11	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.Purchase	Dimension.Date	Fact.Purchase.Date Key = Dimension.Date.Date	FK_Fact_Purchase_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Purchase.Date Key = Dimension.Date.Date Name: FK_Fact_Purchase_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Purchase	Dimension.Stock Item	Fact.Purchase.Stock Item Key = Dimension.Stock Item.Stock Item Key	FK_Fact_Purchase_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Purchase.Stock Item Key = Dimension.Stock Item.Stock Item Key Name: FK_Fact_Purchase_Stock_Item_Key_Dimension_Stock Item Foreign key constraint referencing Stock Item.Stock Item Key
Fact.Purchase	Dimension.Supplier	Fact.Purchase.Supplier Key = Dimension.Supplier.Supplier Key	FK_Fact_Purchase_Supplier_Key_Dimension_Supplier Foreign key constraint referencing Supplier.Supplier Key
Fact.Purchase.Supplier Key = Dimension.Supplier.Supplier Key Name: FK_Fact_Purchase_Supplier_Key_Dimension_Supplier Foreign key constraint referencing Supplier.Supplier Key

Unique keys

	Key name	Columns	Description
	PK_Fact_Purchase	Purchase Key, Date Key	Primary key (nonclustered) constraint.
Primary key (nonclustered) constraint.

Uses

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