Table: pr_item_line

Previous: pr_expense_line_descriptor

Unanet Data Model

Next: pr_item_line_attachment_ref

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	pr_item_line_key	decimal(15)
2.		pr_item_line_descriptor_key	decimal(15)		pr_item_line_descriptor	fk_pr_item_line1
3.		pr_key	decimal(15)		purchase_requisition	fk_pr_item_line2
4.		begin_date	datetime	('01/01/1900')
5.		end_date	datetime	('12/31/2099')
6.		required_by_date	datetime
7.		quantity	decimal(15,6)
8.		amount	decimal(18,2)
9.		internal_comments	varchar(2000)
10.		external_comments	varchar(2000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
pr_item_line_descriptor_key	pr_item_line_descriptor	pr_item_line_descriptor_key	fk_pr_item_line1
pr_key	purchase_requisition	pr_key	fk_pr_item_line2

Referenced from

Table	Column	Foreign Key Name
pr_item_line_attachment_ref	pr_item_line_key	fk_pr_item_line_att_ref2

Check Constraints

Name	Definition
cc_pri_line_begin_date	([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31')
cc_pri_line_end_date	([end_date]>='1900-01-01' AND [end_date]<='2099-12-31')
cc_pri_line_req_date	([required_by_date]>='1900-01-01' AND [required_by_date]<='2099-12-31')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_pr_item_line	true	pr_item_line_key	Asc
idx_pr_item_line2	true	pr_key	Asc
		pr_item_line_descriptor_key
idx_pr_item_line1	false	pr_item_line_descriptor_key	Asc

Dependent Views

View Name
pr_item_consol_all_view
pr_item_consol_approved_view