pur.purchase_orders - Procurement

Box Inc - Enterprise Data Catalog

Documentation	Procurement
Schema	pur
Name	purchase_orders
Module	Purchase Orders

Table holds purchase orders headers. Together with purchase_order_lines create a quotation document.

Columns

		Name	Data type	Attributes	References	Description	Data Owner	Sensitive
	1	po_id	int	Identity		Purchase order header id
Purchase order header id Identity
	2	supplier_id	int		pur.suppliers	Supplier
Supplier References: pur.suppliers
	3	po_ref	nvarchar(50)			Internal PO unique reference number
Internal PO unique reference number
	4	supplier_ref	nvarchar(50)			Supplier PO reference number
Supplier PO reference number
	5	employee	nvarchar(50)			Login of employee who entered PO to the system		Y
Login of employee who entered PO to the system Sensitive: Y
	6	created_date	date			Date document was created in the system
Date document was created in the system
	7	approved_date	date			Date document was approved
Date document was approved
	8	approved_flag	bit	Default: 0		1 - PO approved, 0 - otherwise
1 - PO approved, 0 - otherwise Default: 0
	9	payment_terms	nvarchar(50)			Payment terms in free text
Payment terms in free text
	10	currency	nvarchar(50)			PO currency (e.g. USD, EUR)
PO currency (e.g. USD, EUR)
	11	delivery_cost	numeric(18, 0)			Delivery cost	Procurement
Delivery cost Data Owner: Procurement
	12	delivery_date	date			Delivery date	Procurement
Delivery date Data Owner: Procurement
	13	supplier_contact	nvarchar(50)			Name of supplier contact person		Y
Name of supplier contact person Sensitive: Y
	14	supplier_contact_email	nvarchar(50)			Email of supplier contact		Y
Email of supplier contact Sensitive: Y
	15	supplier_contact_phone_no	nvarchar(50)			Supplier contact phone no		Y
Supplier contact phone no Sensitive: Y
	16	quotation_id	int		pur.quotations	Linked quotation document
Linked quotation document References: pur.quotations
	17	attribute1	nvarchar(150)			Unused
Unused
	18	attribute2	nvarchar(150)			Unused
Unused
	19	attribute3	nvarchar(150)			Unused
Unused
	20	attribute4	nvarchar(150)			Unused
Unused
	21	attribute5	nvarchar(150)			Login of employee who approved document		Y
Login of employee who approved document Sensitive: Y

Relations

Foreign table	Primary table	Join	Title / Name / Description
pur.purchase_orders	pur.quotations	pur.purchase_orders.quotation_id = pur.quotations.quotation_id	FK_purchase_orders_quotations
pur.purchase_orders.quotation_id = pur.quotations.quotation_id Name: FK_purchase_orders_quotations
pur.purchase_orders	pur.suppliers	pur.purchase_orders.supplier_id = pur.suppliers.supplier_id	FK_purchase_orders_suppliers
pur.purchase_orders.supplier_id = pur.suppliers.supplier_id Name: FK_purchase_orders_suppliers
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.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

Unique keys

	Key name	Columns	Description
	PK_purchase_orders	po_id

Uses

Name
pur.purchase_orders
pur.quotations
pur.suppliers

Used by

Name
pur.purchase_orders
pur.purchase_order_lines
pur.shipments

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