Generated using SQL Data Dictionary demo version.


Table Sales.InvoiceLines (228,265 rows)


Detail lines from customer invoices


  Column Data Type Identity Nullable Default
PK InvoiceLineID int NEXT VALUE FOR [Sequences].[InvoiceLineID]
Numeric ID used for reference to a line on an invoice within the database
FK InvoiceID int
Invoice that this line is associated with
FK StockItemID int
Stock item for this invoice line
Description nvarchar(100)
Description of the item supplied (Usually the stock item name but can be overridden)
FK PackageTypeID int
Type of package supplied
Quantity int
Quantity supplied
UnitPrice decimal(18,2) X
Unit price charged
TaxRate decimal(18,3)
Tax rate to be applied
TaxAmount decimal(18,2)
Tax amount calculated
LineProfit decimal(18,2)
Profit made on this line item at current cost price
ExtendedPrice decimal(18,2)
Extended line price charged
FK LastEditedBy int
LastEditedWhen datetime2 sysdatetime()

Indexes:


References:


Used by: