Dimension.Supplier - WideWorldImportersDW

Documentation	WideWorldImportersDW
Schema	Dimension
Name	Supplier
Modules	Movement, Purchase, Transaction

Supplier dimension

Columns

		Name	Data type	Attributes	Description
	1	Supplier Key	int	Default: NEXT VALUE FOR [Sequences].[SupplierKey]	DW key for the supplier dimension
DW key for the supplier dimension Default: NEXT VALUE FOR [Sequences].[SupplierKey]
	2	WWI Supplier ID	int		Numeric ID used for reference to a supplier within the WWI database
Numeric ID used for reference to a supplier within the WWI database
	3	Supplier	nvarchar(100)		Supplier's full name (usually a trading name)
Supplier's full name (usually a trading name)
	4	Category	nvarchar(50)		Supplier's category
Supplier's category
	5	Primary Contact	nvarchar(50)		Primary contact
Primary contact
	6	Supplier Reference	nvarchar(20)		Supplier reference for our organization (might be our account number at the supplier)
Supplier reference for our organization (might be our account number at the supplier)
	7	Payment Days	int		Number of days for payment of an invoice (ie payment terms)
Number of days for payment of an invoice (ie payment terms)
	8	Postal Code	nvarchar(10)		Delivery postal code for the supplier
Delivery postal code for the supplier
	9	Valid From	datetime2(7)		Valid from this date and time
Valid from this date and time
	10	Valid To	datetime2(7)		Valid until this date and time
Valid until this date and time
	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.Movement	Dimension.Supplier	Fact.Movement.Supplier Key = Dimension.Supplier.Supplier Key	FK_Fact_Movement_Supplier_Key_Dimension_Supplier Foreign key constraint referencing Supplier.Supplier Key
Fact.Movement.Supplier Key = Dimension.Supplier.Supplier Key Name: FK_Fact_Movement_Supplier_Key_Dimension_Supplier Foreign key constraint referencing Supplier.Supplier 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
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

Unique keys

	Key name	Columns	Description
	PK_Dimension_Supplier	Supplier Key	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Used by

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