pur.quotation_lines - Procurement

Table holds quotation lines. Together with quitations create a quotation document.

Columns

		Name	Data type	Attributes	References	Description
	1	quotation_line_id	int	Identity		Quotation line id
Quotation line id Identity
	2	quotation_id	int		pur.quotations	Quotation header id
Quotation header id References: pur.quotations
	3	line_no	int			Line #
Line #
	4	item_id	int		pur.items	Item
Item References: pur.items
	5	supplier_item_code	nvarchar(20)			Product code as provided by supplier
Product code as provided by supplier
	6	supplier_item_title	nvarchar(50)			Title of product as on supplier quotation
Title of product as on supplier quotation
	7	quantity	numeric(18, 0)			Quantity of product in quotation
Quantity of product in quotation
	8	item_price	numeric(18, 0)			Unit price
Unit price
	9	promised_delivery_date	date			Promised delivery date
Promised delivery date
	10	rfq_line_id	int		pur.rfq_lines (RFQ lines)	Linked RFQ line
Linked RFQ line References: pur.rfq_lines (RFQ lines)

Relations

Foreign table	Primary table	Join	Title / Name / Description
pur.quotation_lines	pur.items	pur.quotation_lines.item_id = pur.items.item_id	FK_quotation_lines_items
pur.quotation_lines.item_id = pur.items.item_id Name: FK_quotation_lines_items
pur.quotation_lines	pur.quotations	pur.quotation_lines.quotation_id = pur.quotations.quotation_id	FK_quotation_lines_quotations
pur.quotation_lines.quotation_id = pur.quotations.quotation_id Name: FK_quotation_lines_quotations
pur.quotation_lines	pur.rfq_lines (RFQ lines)	pur.quotation_lines.rfq_line_id = pur.rfq_lines.rfq_line_id	FK_quotation_lines_rfq_lines
pur.quotation_lines.rfq_line_id = pur.rfq_lines.rfq_line_id Name: FK_quotation_lines_rfq_lines
pur.purchase_order_lines	pur.quotation_lines	pur.purchase_order_lines.quotation_line_id = pur.quotation_lines.quotation_line_id	FK_purchase_order_lines_quotation_lines
pur.purchase_order_lines.quotation_line_id = pur.quotation_lines.quotation_line_id Name: FK_purchase_order_lines_quotation_lines

Unique keys

Uses

Used by

Name
pur.quotation_lines
pur.purchase_order_lines

Exported: 2019-02-04 23:17, Last imported: 2018-04-10 17:11