Dimension.Payment Method - WideWorldImportersDW

WideWorldImportersDW

- WideWorldImportersDW

Documentation	WideWorldImportersDW
Schema	Dimension
Name	Payment Method
Modules	Purchase, Transaction

PaymentMethod dimension

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		Payment Method Key	int		Default: NEXT VALUE FOR [Sequences].[PaymentMethodKey]		DW key for the payment method dimension
DW key for the payment method dimension Default: NEXT VALUE FOR [Sequences].[PaymentMethodKey]
	2		WWI Payment Method ID	int				Numeric ID for the payment method in the WWI database
Numeric ID for the payment method in the WWI database
	3		Payment Method	nvarchar(50)				Payment method name
Payment method name
	4		Valid From	datetime2(7)				Valid from this date and time
Valid from this date and time
	5		Valid To	datetime2(7)				Valid until this date and time
Valid until this date and time
	6		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.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

Unique keys

	Key name	Columns	Description
	PK_Dimension_Payment_Method	Payment Method Key	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Used by

Name
Dimension.Payment Method
Fact.Transaction

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