pur.purchase_order_lines - Procurement

Box Inc - Enterprise Data Catalog

Documentation	Procurement
Schema	pur
Name	purchase_order_lines
Module	Purchase Orders

Table holds purchase orders lines. Together with purchase_orders create a quotation document.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		po_line_id	int		Identity	pur.items	Purchase order line id
Purchase order line id Identity References: pur.items
	2		po_id	int			pur.purchase_orders	Purchase order heder id
Purchase order heder id References: pur.purchase_orders
	3		line_no	int				Line #
Line #
	4		supplier_item_code	nchar(10)				Product code as provided by supplier
Product code as provided by supplier
	5		supplier_item_title	nchar(10)				Title of product as on supplier quotation
Title of product as on supplier quotation
	6		quantity	numeric(18, 0)				Item quantity
Item quantity
	7		price	numeric(18, 0)				Unit price in currency (see header)
Unit price in currency (see header)
	8		delivery_date	date				Delivery date if different than on header
Delivery date if different than on header
	9		quotation_line_id	int			pur.quotation_lines	Linked quotation line
Linked quotation line References: pur.quotation_lines

Relations

Foreign table		Primary table	Join	Title / Name / Description
pur.purchase_order_lines		pur.items	pur.purchase_order_lines.po_line_id = pur.items.item_id	FK_purchase_order_lines_items
pur.purchase_order_lines.po_line_id = pur.items.item_id Name: FK_purchase_order_lines_items
pur.purchase_order_lines		pur.purchase_orders	pur.purchase_order_lines.po_id = pur.purchase_orders.po_id	FK_purchase_order_lines_purchase_orders
pur.purchase_order_lines.po_id = pur.purchase_orders.po_id Name: FK_purchase_order_lines_purchase_orders
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
pur.shipment_lines		pur.purchase_order_lines	pur.shipment_lines.po_line_id = pur.purchase_order_lines.po_line_id	FK_shipment_lines_purchase_order_lines
pur.shipment_lines.po_line_id = pur.purchase_order_lines.po_line_id Name: FK_shipment_lines_purchase_order_lines

Unique keys

	Key name	Columns	Description
	PK_purchase_order_lines	po_line_id

	UK_purchase_order_lines_no	line_no, po_id

Uses

Name
pur.purchase_order_lines
pur.items
pur.purchase_orders
pur.quotation_lines

Used by

Name
pur.purchase_order_lines
pur.shipment_lines

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