Generated using SQL Data Dictionary demo version.

Table Sales.OrderLines (231,412 rows)

Detail lines from customer orders

  Column Data Type Identity 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()



Used by: