Fact.Transaction - WideWorldImportersDW

WideWorldImportersDW

- WideWorldImportersDW

Documentation	WideWorldImportersDW
Schema	Fact
Name	Transaction
Module	Transaction

Transaction fact table (financial transactions involving customers and supppliers)

Columns

		Name	Data type	Attributes	References	Description
	1	Transaction Key	bigint	Identity		DW key for a row in the Transaction fact
DW key for a row in the Transaction fact Identity
	2	Date Key	date		Dimension.Date	Transaction date
Transaction date References: Dimension.Date
	3	Customer Key	int		Dimension.Customer	Customer (if applicable)
Customer (if applicable) References: Dimension.Customer
	4	Bill To Customer Key	int		Dimension.Customer	Bill to customer (if applicable)
Bill to customer (if applicable) References: Dimension.Customer
	5	Supplier Key	int		Dimension.Supplier	Supplier (if applicable)
Supplier (if applicable) References: Dimension.Supplier
	6	Transaction Type Key	int		Dimension.Transaction Type	Type of transaction
Type of transaction References: Dimension.Transaction Type
	7	Payment Method Key	int		Dimension.Payment Method	Payment method (if applicable)
Payment method (if applicable) References: Dimension.Payment Method
	8	WWI Customer Transaction ID	int			Customer transaction ID in source system
Customer transaction ID in source system
	9	WWI Supplier Transaction ID	int			Supplier transaction ID in source system
Supplier transaction ID in source system
	10	WWI Invoice ID	int			Invoice ID in source system
Invoice ID in source system
	11	WWI Purchase Order ID	int			Purchase order ID in source system
Purchase order ID in source system
	12	Supplier Invoice Number	nvarchar(20)			Supplier invoice number (if applicable)
Supplier invoice number (if applicable)
	13	Total Excluding Tax	decimal(18, 2)			Total amount excluding tax
Total amount excluding tax
	14	Tax Amount	decimal(18, 2)			Total amount of tax
Total amount of tax
	15	Total Including Tax	decimal(18, 2)			Total amount including tax
Total amount including tax
	16	Outstanding Balance	decimal(18, 2)			Amount still outstanding for this transaction
Amount still outstanding for this transaction
	17	Is Finalized	bit			Has this transaction been finalized?
Has this transaction been finalized?
	18	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.Transaction	Dimension.Customer	Fact.Transaction.Bill To Customer Key = Dimension.Customer.Customer Key	FK_Fact_Transaction_Bill_To_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Transaction.Bill To Customer Key = Dimension.Customer.Customer Key Name: FK_Fact_Transaction_Bill_To_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Transaction	Dimension.Customer	Fact.Transaction.Customer Key = Dimension.Customer.Customer Key	FK_Fact_Transaction_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Transaction.Customer Key = Dimension.Customer.Customer Key Name: FK_Fact_Transaction_Customer_Key_Dimension_Customer Foreign key constraint referencing Customer.Customer Key
Fact.Transaction	Dimension.Date	Fact.Transaction.Date Key = Dimension.Date.Date	FK_Fact_Transaction_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Transaction.Date Key = Dimension.Date.Date Name: FK_Fact_Transaction_Date_Key_Dimension_Date Foreign key constraint referencing Date.Date
Fact.Transaction	Dimension.Payment Method	Fact.Transaction.Payment Method Key = Dimension.Payment Method.Payment Method Key	FK_Fact_Transaction_Payment_Method_Key_Dimension_Payment Method Foreign key constraint referencing Payment Method.Payment Method Key
Fact.Transaction.Payment Method Key = Dimension.Payment Method.Payment Method Key Name: FK_Fact_Transaction_Payment_Method_Key_Dimension_Payment Method Foreign key constraint referencing Payment Method.Payment Method Key
Fact.Transaction	Dimension.Supplier	Fact.Transaction.Supplier Key = Dimension.Supplier.Supplier Key	FK_Fact_Transaction_Supplier_Key_Dimension_Supplier Foreign key constraint referencing Supplier.Supplier Key
Fact.Transaction.Supplier Key = Dimension.Supplier.Supplier Key Name: FK_Fact_Transaction_Supplier_Key_Dimension_Supplier Foreign key constraint referencing Supplier.Supplier Key
Fact.Transaction	Dimension.Transaction Type	Fact.Transaction.Transaction Type Key = Dimension.Transaction Type.Transaction Type Key	FK_Fact_Transaction_Transaction_Type_Key_Dimension_Transaction Type Foreign key constraint referencing Transaction Type.Transaction Type Key
Fact.Transaction.Transaction Type Key = Dimension.Transaction Type.Transaction Type Key Name: FK_Fact_Transaction_Transaction_Type_Key_Dimension_Transaction Type Foreign key constraint referencing Transaction Type.Transaction Type Key

Unique keys

	Key name	Columns	Description
	PK_Fact_Transaction	Transaction Key, Date Key	Primary key (nonclustered) constraint.
Primary key (nonclustered) constraint.

Uses

Name
Fact.Transaction
Dimension.Customer
Dimension.Customer
Dimension.Date
Dimension.Payment Method
Dimension.Supplier
Dimension.Transaction Type

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