Application.PaymentMethods - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Application
Name	PaymentMethods
Module	Application

Ways that payments can be made (ie: cash, check, EFT, etc.)

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		PaymentMethodID	int		Default: NEXT VALUE FOR [Sequences].[PaymentMethodID]		Numeric ID used for reference to a payment type within the database
Numeric ID used for reference to a payment type within the database Default: NEXT VALUE FOR [Sequences].[PaymentMethodID]
	2		PaymentMethodName	nvarchar(50)				Full name of ways that customers can make payments or that suppliers can be paid
Full name of ways that customers can make payments or that suppliers can be paid
	3		LastEditedBy	int			Application.People
References: Application.People
	4		ValidFrom	datetime2(7)				Valid from this date and time
Valid from this date and time
	5		ValidTo	datetime2(7)				Valid until this date and time
Valid until this date and time

Relations

Foreign table		Primary table	Join	Title / Name / Description
Application.PaymentMethods		Application.People	Application.PaymentMethods.LastEditedBy = Application.People.PersonID	FK_Application_PaymentMethods_Application_People Foreign key constraint referencing People.PersonID
Application.PaymentMethods.LastEditedBy = Application.People.PersonID Name: FK_Application_PaymentMethods_Application_People Foreign key constraint referencing People.PersonID
Sales.CustomerTransactions		Application.PaymentMethods	Sales.CustomerTransactions.PaymentMethodID = Application.PaymentMethods.PaymentMethodID	FK_Sales_CustomerTransactions_PaymentMethodID_Application_PaymentMethods Foreign key constraint referencing PaymentMethods.PaymentMethodID
Sales.CustomerTransactions.PaymentMethodID = Application.PaymentMethods.PaymentMethodID Name: FK_Sales_CustomerTransactions_PaymentMethodID_Application_PaymentMethods Foreign key constraint referencing PaymentMethods.PaymentMethodID
Purchasing.SupplierTransactions		Application.PaymentMethods	Purchasing.SupplierTransactions.PaymentMethodID = Application.PaymentMethods.PaymentMethodID	FK_Purchasing_SupplierTransactions_PaymentMethodID_Application_PaymentMethods Foreign key constraint referencing PaymentMethods.PaymentMethodID
Purchasing.SupplierTransactions.PaymentMethodID = Application.PaymentMethods.PaymentMethodID Name: FK_Purchasing_SupplierTransactions_PaymentMethodID_Application_PaymentMethods Foreign key constraint referencing PaymentMethods.PaymentMethodID

Unique keys

	Key name	Columns	Description
	PK_Application_PaymentMethods	PaymentMethodID	Primary key (clustered) constraint.
Primary key (clustered) constraint.
	UQ_Application_PaymentMethods_PaymentMethodName	PaymentMethodName	Unique nonclustered index.
Unique nonclustered index.

Uses

Name
Application.PaymentMethods
Application.People

Used by

Name
Application.PaymentMethods
Purchasing.SupplierTransactions
Sales.CustomerTransactions

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