Purchasing.PurchaseOrderLines - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Purchasing
Name	PurchaseOrderLines
Module	Purchasing

Detail lines from supplier purchase orders.

Columns

		Name	Data type	Attributes	References	Description
	1	PurchaseOrderLineID	int	Default: NEXT VALUE FOR [Sequences].[PurchaseOrderLineID]		Numeric ID used for reference to a line on a purchase order within the database
Numeric ID used for reference to a line on a purchase order within the database Default: NEXT VALUE FOR [Sequences].[PurchaseOrderLineID]
	2	PurchaseOrderID	int		Purchasing.PurchaseOrders	Purchase order that this line is associated with
Purchase order that this line is associated with References: Purchasing.PurchaseOrders
	3	StockItemID	int		Warehouse.StockItems	Stock item for this purchase order line
Stock item for this purchase order line References: Warehouse.StockItems
	4	OrderedOuters	int			Quantity of the stock item that is ordered
Quantity of the stock item that is ordered
	5	Description	nvarchar(100)			Description of the item to be supplied (Often the stock item name but could be supplier description)
Description of the item to be supplied (Often the stock item name but could be supplier description)
	6	ReceivedOuters	int			Total quantity of the stock item that has been received so far
Total quantity of the stock item that has been received so far
	7	PackageTypeID	int		Warehouse.PackageTypes	Type of package received
Type of package received References: Warehouse.PackageTypes
	8	ExpectedUnitPricePerOuter	decimal(18, 2)			The unit price that we expect to be charged
The unit price that we expect to be charged
	9	LastReceiptDate	date			The last date on which this stock item was received for this purchase order
The last date on which this stock item was received for this purchase order
	10	IsOrderLineFinalized	bit			Is this purchase order line now considered finalized? (Receipted quantities and weights are often not precise)
Is this purchase order line now considered finalized? (Receipted quantities and weights are often not precise)
	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.PurchaseOrderLines	Warehouse.PackageTypes	Purchasing.PurchaseOrderLines.PackageTypeID = Warehouse.PackageTypes.PackageTypeID	FK_Purchasing_PurchaseOrderLines_PackageTypeID_Warehouse_PackageTypes Foreign key constraint referencing PackageTypes.PackageTypeID
Purchasing.PurchaseOrderLines.PackageTypeID = Warehouse.PackageTypes.PackageTypeID Name: FK_Purchasing_PurchaseOrderLines_PackageTypeID_Warehouse_PackageTypes Foreign key constraint referencing PackageTypes.PackageTypeID
Purchasing.PurchaseOrderLines	Application.People	Purchasing.PurchaseOrderLines.LastEditedBy = Application.People.PersonID	FK_Purchasing_PurchaseOrderLines_Application_People Foreign key constraint referencing People.PersonID
Purchasing.PurchaseOrderLines.LastEditedBy = Application.People.PersonID Name: FK_Purchasing_PurchaseOrderLines_Application_People Foreign key constraint referencing People.PersonID
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
Purchasing.PurchaseOrderLines	Warehouse.StockItems	Purchasing.PurchaseOrderLines.StockItemID = Warehouse.StockItems.StockItemID	FK_Purchasing_PurchaseOrderLines_StockItemID_Warehouse_StockItems Foreign key constraint referencing StockItems.StockItemID
Purchasing.PurchaseOrderLines.StockItemID = Warehouse.StockItems.StockItemID Name: FK_Purchasing_PurchaseOrderLines_StockItemID_Warehouse_StockItems Foreign key constraint referencing StockItems.StockItemID

Unique keys

	Key name	Columns	Description
	PK_Purchasing_PurchaseOrderLines	PurchaseOrderLineID	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Uses

Name
Purchasing.PurchaseOrderLines
Application.People
Purchasing.PurchaseOrders
Warehouse.PackageTypes
Warehouse.StockItems

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