pur.shipment_lines - Procurement

Box Inc - Enterprise Data Catalog

Documentation	Procurement
Schema	pur
Name	shipment_lines
Module	Purchase Orders

Items in one shipment (lines).

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		shipment_line_id	int		Identity		Shipment line id
Shipment line id Identity
	2		shipment_id	int			pur.shipments	Shipment header id
Shipment header id References: pur.shipments
	3		line_no	int				Line #
Line #
	4		item_id	int			pur.items	Item
Item References: pur.items
	5		po_line_id	int			pur.purchase_order_lines	Link of purchase order line this shipment line refers to
Link of purchase order line this shipment line refers to References: pur.purchase_order_lines

Relations

Foreign table		Primary table	Join	Title / Name / Description
pur.shipment_lines		pur.items	pur.shipment_lines.item_id = pur.items.item_id	FK_shipment_lines_items
pur.shipment_lines.item_id = pur.items.item_id Name: FK_shipment_lines_items
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
pur.shipment_lines		pur.shipments	pur.shipment_lines.shipment_id = pur.shipments.shipment_id	FK_shipment_lines_shipment
pur.shipment_lines.shipment_id = pur.shipments.shipment_id Name: FK_shipment_lines_shipment

Unique keys

	Key name	Columns	Description
	PK_shipment_lines	shipment_line_id

	UK_shipment_lines	line_no, shipment_id

Uses

Name
pur.shipment_lines
pur.items
pur.purchase_order_lines
pur.shipments

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