pur.shipments - Purchase Orders

Box Inc - Enterprise Data Catalog

Documentation	Procurement
Schema	pur
Name	shipments
Module	Purchase Orders

Supplier may ship purchase orders in packages (shipments), Each is tracked in separate document. This table hold one row per shipment. Shipment contains of one or more items shipped - held in shipment_lines table.

Columns

		Name	Data type	Attributes	References	Description
	1	shipment_id	int	Identity		Shipment header id
Shipment header id Identity
	2	po_id	int		pur.purchase_orders	Purchase order of this shimpment
Purchase order of this shimpment References: pur.purchase_orders
	3	date_delivered	date			Date shipment arrived at our location
Date shipment arrived at our location
	4	transport_type	nchar(10)			Free hand transport form
Free hand transport form
	5	attribute1	nvarchar(150)			Unused
Unused
	6	attribute2	nvarchar(150)			Unused
Unused
	7	attribute3	nvarchar(150)			Unused
Unused
	8	attribute4	nvarchar(150)			Unused
Unused
	9	attribute5	nvarchar(150)			Unused
Unused

Relations

Foreign table	Primary table	Join	Title / Name / Description
pur.shipments	pur.purchase_orders	pur.shipments.po_id = pur.purchase_orders.po_id	FK_shipments_purchase_orders
pur.shipments.po_id = pur.purchase_orders.po_id Name: FK_shipments_purchase_orders
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_shipments	shipment_id

Uses

Name
pur.shipments
pur.purchase_orders

Used by

Name
pur.shipments
pur.shipment_lines

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