Purchasing.PurchaseOrders - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Purchasing
Name	PurchaseOrders
Module	Purchasing

Details of supplier purchase orders.

Columns

		Name	Data type	Attributes	References	Description
	1	PurchaseOrderID	int	Default: NEXT VALUE FOR [Sequences].[PurchaseOrderID]		Numeric ID used for reference to a purchase order within the database
Numeric ID used for reference to a purchase order within the database Default: NEXT VALUE FOR [Sequences].[PurchaseOrderID]
	2	SupplierID	int		Purchasing.Suppliers	Supplier for this purchase order
Supplier for this purchase order References: Purchasing.Suppliers
	3	OrderDate	date			Date that this purchase order was raised
Date that this purchase order was raised
	4	DeliveryMethodID	int		Application.DeliveryMethods	How this purchase order should be delivered
How this purchase order should be delivered References: Application.DeliveryMethods
	5	ContactPersonID	int		Application.People	The person who is the primary contact for this purchase order
The person who is the primary contact for this purchase order References: Application.People
	6	ExpectedDeliveryDate	date			Expected delivery date for this purchase order
Expected delivery date for this purchase order
	7	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)
	8	IsOrderFinalized	bit			Is this purchase order now considered finalized?
Is this purchase order now considered finalized?
	9	Comments	nvarchar(MAX)			Any comments related this purchase order (comments sent to the supplier)
Any comments related this purchase order (comments sent to the supplier)
	10	InternalComments	nvarchar(MAX)			Any internal comments related this purchase order (comments for internal reference only and not sent to the supplier)
Any internal comments related this purchase order (comments for internal reference only and not sent to the supplier)
	11	LastEditedBy	int		Application.People
References: Application.People
	12	LastEditedWhen	datetime2(7)	Default: sysdatetime()		When this row was last edited
When this row was last edited Default: sysdatetime()

Relations

Foreign table	Primary table	Join	Title / Name / Description
Purchasing.PurchaseOrders	Application.DeliveryMethods	Purchasing.PurchaseOrders.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID	FK_Purchasing_PurchaseOrders_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID
Purchasing.PurchaseOrders.DeliveryMethodID = Application.DeliveryMethods.DeliveryMethodID Name: FK_Purchasing_PurchaseOrders_DeliveryMethodID_Application_DeliveryMethods Foreign key constraint referencing DeliveryMethods.DeliveryMethodID
Purchasing.PurchaseOrders	Application.People	Purchasing.PurchaseOrders.LastEditedBy = Application.People.PersonID	FK_Purchasing_PurchaseOrders_Application_People Foreign key constraint referencing People.PersonID
Purchasing.PurchaseOrders.LastEditedBy = Application.People.PersonID Name: FK_Purchasing_PurchaseOrders_Application_People Foreign key constraint referencing People.PersonID
Purchasing.PurchaseOrders	Application.People	Purchasing.PurchaseOrders.ContactPersonID = Application.People.PersonID	FK_Purchasing_PurchaseOrders_ContactPersonID_Application_People Foreign key constraint referencing People.PersonID
Purchasing.PurchaseOrders.ContactPersonID = Application.People.PersonID Name: FK_Purchasing_PurchaseOrders_ContactPersonID_Application_People Foreign key constraint referencing People.PersonID
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
Purchasing.PurchaseOrderLines	Purchasing.PurchaseOrders	Purchasing.PurchaseOrderLines.PurchaseOrderID = Purchasing.PurchaseOrders.PurchaseOrderID	FK_Purchasing_PurchaseOrderLines_PurchaseOrderID_Purchasing_PurchaseOrders Foreign key constraint referencing PurchaseOrders.PurchaseOrderID
Purchasing.PurchaseOrderLines.PurchaseOrderID = Purchasing.PurchaseOrders.PurchaseOrderID Name: FK_Purchasing_PurchaseOrderLines_PurchaseOrderID_Purchasing_PurchaseOrders Foreign key constraint referencing PurchaseOrders.PurchaseOrderID
Warehouse.StockItemTransactions	Purchasing.PurchaseOrders	Warehouse.StockItemTransactions.PurchaseOrderID = Purchasing.PurchaseOrders.PurchaseOrderID	FK_Warehouse_StockItemTransactions_PurchaseOrderID_Purchasing_PurchaseOrders Foreign key constraint referencing PurchaseOrders.PurchaseOrderID
Warehouse.StockItemTransactions.PurchaseOrderID = Purchasing.PurchaseOrders.PurchaseOrderID Name: FK_Warehouse_StockItemTransactions_PurchaseOrderID_Purchasing_PurchaseOrders Foreign key constraint referencing PurchaseOrders.PurchaseOrderID
Purchasing.SupplierTransactions	Purchasing.PurchaseOrders	Purchasing.SupplierTransactions.PurchaseOrderID = Purchasing.PurchaseOrders.PurchaseOrderID	FK_Purchasing_SupplierTransactions_PurchaseOrderID_Purchasing_PurchaseOrders Foreign key constraint referencing PurchaseOrders.PurchaseOrderID
Purchasing.SupplierTransactions.PurchaseOrderID = Purchasing.PurchaseOrders.PurchaseOrderID Name: FK_Purchasing_SupplierTransactions_PurchaseOrderID_Purchasing_PurchaseOrders Foreign key constraint referencing PurchaseOrders.PurchaseOrderID

Unique keys

	Key name	Columns	Description
	PK_Purchasing_PurchaseOrders	PurchaseOrderID	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Uses

Name
Purchasing.PurchaseOrders
Application.DeliveryMethods
Application.People
Application.People
Purchasing.Suppliers

Used by

Name
Purchasing.PurchaseOrders
Purchasing.PurchaseOrderLines
Purchasing.SupplierTransactions
Warehouse.StockItemTransactions

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