pur.requisition_lines (Line) - Procurement

Box Inc - Enterprise Data Catalog

Documentation	Procurement
Schema	pur
Name	requisition_lines
Title	Line
Module	Requisitions

Table holds requisition lines (specific items).

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		requisition_line_id	int		Identity		Requisition line id
Requisition line id Identity
	2		requisition_id	int			pur.requisitions (Header)	Requisition header id
Requisition header id References: pur.requisitions (Header)
	3		line_no	nchar(10)				Line #
Line #
	4		item_id	int			pur.items	Item
Item References: pur.items
	5		quantity	numeric(18, 0)				Requested quantity
Requested quantity
	6		required_by_date	date				Expected delivery date
Expected delivery date

Relations

Foreign table		Primary table	Join	Title / Name / Description
pur.requisition_lines (Line)		pur.items	pur.requisition_lines.item_id = pur.items.item_id	FK_requisition_lines_items
pur.requisition_lines.item_id = pur.items.item_id Name: FK_requisition_lines_items
pur.requisition_lines (Line)		pur.requisitions (Header)	pur.requisition_lines.requisition_id = pur.requisitions.requisition_id	FK_requisition_lines_req
pur.requisition_lines.requisition_id = pur.requisitions.requisition_id Name: FK_requisition_lines_req
pur.rfq_lines (RFQ lines)		pur.requisition_lines (Line)	pur.rfq_lines.requisition_line_id = pur.requisition_lines.requisition_line_id	FK_rfq_lines_requisition_lines
pur.rfq_lines.requisition_line_id = pur.requisition_lines.requisition_line_id Name: FK_rfq_lines_requisition_lines

Unique keys

	Key name	Columns	Description
	PK_requisition_lines	requisition_line_id

	UK_requisition_lines_no	line_no, requisition_id

Uses

Name
pur.requisition_lines (Line)
pur.items
pur.requisitions (Header)

Used by

Name
pur.requisition_lines (Line)
pur.rfq_lines (RFQ lines)

Exported: 2019-02-04 23:17, Last imported: 2018-10-31 15:19