Purchasing.Suppliers - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Purchasing
Name	Suppliers
Module	Purchasing

Main entity table for suppliers (organizations)

Columns

		Name	Data type	Attributes	References	Description
	1	SupplierID	int	Default: NEXT VALUE FOR [Sequences].[SupplierID]		Numeric ID used for reference to a supplier within the database
Numeric ID used for reference to a supplier within the database Default: NEXT VALUE FOR [Sequences].[SupplierID]
	2	SupplierName	nvarchar(100)			Supplier's full name (usually a trading name)
Supplier's full name (usually a trading name)
	3	SupplierCategoryID	int		Purchasing.SupplierCategories	Supplier's category
Supplier's category References: Purchasing.SupplierCategories
	4	PrimaryContactPersonID	int		Application.People	Primary contact
Primary contact References: Application.People
	5	AlternateContactPersonID	int		Application.People	Alternate contact
Alternate contact References: Application.People
	6	DeliveryMethodID	int		Application.DeliveryMethods	Standard delivery method for stock items received from this supplier
Standard delivery method for stock items received from this supplier References: Application.DeliveryMethods
	7	DeliveryCityID	int		Application.Cities	ID of the delivery city for this address
ID of the delivery city for this address References: Application.Cities
	8	PostalCityID	int		Application.Cities	ID of the mailing city for this address
ID of the mailing city for this address References: Application.Cities
	9	SupplierReference	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)
	10	BankAccountName	nvarchar(50)			Supplier's bank account name (ie name on the account)
Supplier's bank account name (ie name on the account)
	11	BankAccountBranch	nvarchar(50)			Supplier's bank branch
Supplier's bank branch
	12	BankAccountCode	nvarchar(20)			Supplier's bank account code (usually a numeric reference for the bank branch)
Supplier's bank account code (usually a numeric reference for the bank branch)
	13	BankAccountNumber	nvarchar(20)			Supplier's bank account number
Supplier's bank account number
	14	BankInternationalCode	nvarchar(20)			Supplier's bank's international code (such as a SWIFT code)
Supplier's bank's international code (such as a SWIFT code)
	15	PaymentDays	int			Number of days for payment of an invoice (ie payment terms)
Number of days for payment of an invoice (ie payment terms)
	16	InternalComments	nvarchar(MAX)			Internal comments (not exposed outside organization)
Internal comments (not exposed outside organization)
	17	PhoneNumber	nvarchar(20)			Phone number
Phone number
	18	FaxNumber	nvarchar(20)			Fax number
Fax number
	19	WebsiteURL	nvarchar(256)			URL for the website for this supplier
URL for the website for this supplier
	20	DeliveryAddressLine1	nvarchar(60)			First delivery address line for the supplier
First delivery address line for the supplier
	21	DeliveryAddressLine2	nvarchar(60)			Second delivery address line for the supplier
Second delivery address line for the supplier
	22	DeliveryPostalCode	nvarchar(10)			Delivery postal code for the supplier
Delivery postal code for the supplier
	23	DeliveryLocation	geography			Geographic location for the supplier's office/warehouse
Geographic location for the supplier's office/warehouse
	24	PostalAddressLine1	nvarchar(60)			First postal address line for the supplier
First postal address line for the supplier
	25	PostalAddressLine2	nvarchar(60)			Second postal address line for the supplier
Second postal address line for the supplier
	26	PostalPostalCode	nvarchar(10)			Postal code for the supplier when sending by mail
Postal code for the supplier when sending by mail
	27	LastEditedBy	int		Application.People
References: Application.People
	28	ValidFrom	datetime2(7)			Valid from this date and time
Valid from this date and time
	29	ValidTo	datetime2(7)			Valid until this date and time
Valid until this date and time

Relations

Foreign table	Primary table	Join	Title / Name / Description
Purchasing.Suppliers	Application.Cities	Purchasing.Suppliers.DeliveryCityID = Application.Cities.CityID	FK_Purchasing_Suppliers_DeliveryCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Purchasing.Suppliers.DeliveryCityID = Application.Cities.CityID Name: FK_Purchasing_Suppliers_DeliveryCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Purchasing.Suppliers	Application.Cities	Purchasing.Suppliers.PostalCityID = Application.Cities.CityID	FK_Purchasing_Suppliers_PostalCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Purchasing.Suppliers.PostalCityID = Application.Cities.CityID Name: FK_Purchasing_Suppliers_PostalCityID_Application_Cities Foreign key constraint referencing Cities.CityID
Purchasing.Suppliers	Application.DeliveryMethods	Purchasing.Suppliers.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID	FK_Purchasing_Suppliers_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID
Purchasing.Suppliers.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID Name: FK_Purchasing_Suppliers_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID
Purchasing.Suppliers	Application.People	Purchasing.Suppliers.AlternateContactPersonID = Application.People.PersonID	FK_Purchasing_Suppliers_AlternateContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers.AlternateContactPersonID = Application.People.PersonID Name: FK_Purchasing_Suppliers_AlternateContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers	Application.People	Purchasing.Suppliers.LastEditedBy = Application.People.PersonID	FK_Purchasing_Suppliers_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers.LastEditedBy = Application.People.PersonID Name: FK_Purchasing_Suppliers_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers	Application.People	Purchasing.Suppliers.PrimaryContactPersonID = Application.People.PersonID	FK_Purchasing_Suppliers_PrimaryContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers.PrimaryContactPersonID = Application.People.PersonID Name: FK_Purchasing_Suppliers_PrimaryContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Purchasing.Suppliers	Purchasing.SupplierCategories	Purchasing.Suppliers.SupplierCategoryID = Purchasing.SupplierCategories.SupplierCategoryID	FK_Purchasing_Suppliers_SupplierCategoryID_Purchasing_SupplierCategories Foreign key constraint referencing SupplierCategories.SupplierCategoryID
Purchasing.Suppliers.SupplierCategoryID = Purchasing.SupplierCategories.SupplierCategoryID Name: FK_Purchasing_Suppliers_SupplierCategoryID_Purchasing_SupplierCategories Foreign key constraint referencing SupplierCategories.SupplierCategoryID
Purchasing.PurchaseOrders	Purchasing.Suppliers	Purchasing.PurchaseOrders.SupplierID = Purchasing.Suppliers.SupplierID	FK_Purchasing_PurchaseOrders_SupplierID_Purchasing_Suppliers Foreign key constraint referencing Suppliers.SupplierID
Purchasing.PurchaseOrders.SupplierID = Purchasing.Suppliers.SupplierID Name: FK_Purchasing_PurchaseOrders_SupplierID_Purchasing_Suppliers Foreign key constraint referencing Suppliers.SupplierID
Warehouse.StockItems	Purchasing.Suppliers	Warehouse.StockItems.SupplierID = Purchasing.Suppliers.SupplierID	FK_Warehouse_StockItems_SupplierID_Purchasing_Suppliers Foreign key constraint referencing Suppliers.SupplierID
Warehouse.StockItems.SupplierID = Purchasing.Suppliers.SupplierID Name: FK_Warehouse_StockItems_SupplierID_Purchasing_Suppliers Foreign key constraint referencing Suppliers.SupplierID
Warehouse.StockItemTransactions	Purchasing.Suppliers	Warehouse.StockItemTransactions.SupplierID = Purchasing.Suppliers.SupplierID	FK_Warehouse_StockItemTransactions_SupplierID_Purchasing_Suppliers Foreign key constraint referencing Suppliers.SupplierID
Warehouse.StockItemTransactions.SupplierID = Purchasing.Suppliers.SupplierID Name: FK_Warehouse_StockItemTransactions_SupplierID_Purchasing_Suppliers Foreign key constraint referencing Suppliers.SupplierID
Purchasing.SupplierTransactions	Purchasing.Suppliers	Purchasing.SupplierTransactions.SupplierID = Purchasing.Suppliers.SupplierID	FK_Purchasing_SupplierTransactions_SupplierID_Purchasing_Suppliers Foreign key constraint referencing Suppliers.SupplierID
Purchasing.SupplierTransactions.SupplierID = Purchasing.Suppliers.SupplierID Name: FK_Purchasing_SupplierTransactions_SupplierID_Purchasing_Suppliers Foreign key constraint referencing Suppliers.SupplierID

Unique keys

	Key name	Columns	Description
	PK_Purchasing_Suppliers	SupplierID	Primary key (clustered) constraint.
Primary key (clustered) constraint.
	UQ_Purchasing_Suppliers_SupplierName	SupplierName	Unique nonclustered index.
Unique nonclustered index.

Uses

Name
Purchasing.Suppliers
Application.Cities
Application.Cities
Application.DeliveryMethods
Application.People
Application.People
Application.People
Purchasing.SupplierCategories

Used by

Name
Purchasing.Suppliers
Purchasing.PurchaseOrders
Purchasing.SupplierTransactions
Warehouse.StockItems
Warehouse.StockItemTransactions

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