Sales.InvoiceLines - WideWorldImporters

WideWorldImporters

- WideWorldImporters

Documentation	WideWorldImporters
Schema	Sales
Name	InvoiceLines
Module	Sales

Detail lines from customer invoices.

Columns

		Name	Data type	Attributes	References	Description
	1	InvoiceLineID	int	Default: NEXT VALUE FOR [Sequences].[InvoiceLineID]		Numeric ID used for reference to a line on an invoice within the database
Numeric ID used for reference to a line on an invoice within the database Default: NEXT VALUE FOR [Sequences].[InvoiceLineID]
	2	InvoiceID	int		Sales.Invoices	Invoice that this line is associated with
Invoice that this line is associated with References: Sales.Invoices
	3	StockItemID	int		Warehouse.StockItems	Stock item for this invoice line
Stock item for this invoice line References: Warehouse.StockItems
	4	Description	nvarchar(100)			Description of the item supplied (Usually the stock item name but can be overridden)
Description of the item supplied (Usually the stock item name but can be overridden)
	5	PackageTypeID	int		Warehouse.PackageTypes	Type of package supplied
Type of package supplied References: Warehouse.PackageTypes
	6	Quantity	int			Quantity supplied
Quantity supplied
	7	UnitPrice	decimal(18, 2)			Unit price charged
Unit price charged
	8	TaxRate	decimal(18, 3)			Tax rate to be applied
Tax rate to be applied
	9	TaxAmount	decimal(18, 2)			Tax amount calculated
Tax amount calculated
	10	LineProfit	decimal(18, 2)			Profit made on this line item at current cost price
Profit made on this line item at current cost price
	11	ExtendedPrice	decimal(18, 2)			Extended line price charged
Extended line price charged
	12	LastEditedBy	int		Application.People
References: Application.People
	13	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
Sales.InvoiceLines	Sales.Invoices	Sales.InvoiceLines.InvoiceID = Sales.Invoices.InvoiceID	FK_Sales_InvoiceLines_InvoiceID_Sales_Invoices Foreign key constraint referencing Invoices.InvoiceID
Sales.InvoiceLines.InvoiceID = Sales.Invoices.InvoiceID Name: FK_Sales_InvoiceLines_InvoiceID_Sales_Invoices Foreign key constraint referencing Invoices.InvoiceID
Sales.InvoiceLines	Warehouse.PackageTypes	Sales.InvoiceLines.PackageTypeID = Warehouse.PackageTypes.PackageTypeID	FK_Sales_InvoiceLines_PackageTypeID_Warehouse_PackageTypes Foreign key constraint referencing PackageTypes.PackageTypeID
Sales.InvoiceLines.PackageTypeID = Warehouse.PackageTypes.PackageTypeID Name: FK_Sales_InvoiceLines_PackageTypeID_Warehouse_PackageTypes Foreign key constraint referencing PackageTypes.PackageTypeID
Sales.InvoiceLines	Application.People	Sales.InvoiceLines.LastEditedBy = Application.People.PersonID	FK_Sales_InvoiceLines_Application_People Foreign key constraint referencing People.PersonID
Sales.InvoiceLines.LastEditedBy = Application.People.PersonID Name: FK_Sales_InvoiceLines_Application_People Foreign key constraint referencing People.PersonID
Sales.InvoiceLines	Warehouse.StockItems	Sales.InvoiceLines.StockItemID = Warehouse.StockItems.StockItemID	FK_Sales_InvoiceLines_StockItemID_Warehouse_StockItems Foreign key constraint referencing StockItems.StockItemID
Sales.InvoiceLines.StockItemID = Warehouse.StockItems.StockItemID Name: FK_Sales_InvoiceLines_StockItemID_Warehouse_StockItems Foreign key constraint referencing StockItems.StockItemID

Unique keys

	Key name	Columns	Description
	PK_Sales_InvoiceLines	InvoiceLineID	Primary key (clustered) constraint.
Primary key (clustered) constraint.

Uses

Name
Sales.InvoiceLines
Application.People
Sales.Invoices
Warehouse.PackageTypes
Warehouse.StockItems

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