Sales.OrderLines

Generated using SQL Data Dictionary demo version.

Detail lines from customer orders

	Column	Data Type	Nullable	Default
PK	OrderLineID	int		NEXT VALUE FOR [Sequences].[OrderLineID]
Numeric ID used for reference to a line on an Order within the database
FK	OrderID	int
Order that this line is associated with
FK	StockItemID	int
Stock item for this order line (FK not indexed as separate index exists)
	Description	nvarchar(100)
Description of the item supplied (Usually the stock item name but can be overridden)
FK	PackageTypeID	int
Type of package to be supplied
	Quantity	int
Quantity to be supplied
	UnitPrice	decimal(18,2)	X
Unit price to be charged
	TaxRate	decimal(18,3)
Tax rate to be applied
	PickedQuantity	int
Quantity picked from stock
	PickingCompletedWhen	datetime2	X
When was picking of this line completed?
FK	LastEditedBy	int
	LastEditedWhen	datetime2		sysdatetime()

PK_Sales_OrderLines
- (Primary Key)
- (Clustered)
- (< 0.01% Selectivity)
- OrderLineID

FK_Sales_OrderLines_OrderID
- (< 0.01% Selectivity)
Auto-created to support a foreign key
- OrderID

FK_Sales_OrderLines_PackageTypeID
- (25% Selectivity)
Auto-created to support a foreign key
- PackageTypeID

IX_Sales_OrderLines_AllocatedStockItems
- (0.44% Selectivity)
Allows quick summation of stock item quantites already allocated to uninvoiced orders
- StockItemID
- PickedQuantity (Included)