Table: po_item_line

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	po_item_line_key	decimal(15)
2.		po_item_line_descriptor_key	decimal(15)		po_item_line_descriptor	fk_po_item_line1
3.		po_key	decimal(15)		purchase_order	fk_po_item_line2
4.		begin_date	datetime
5.		end_date	datetime
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)
11.		vi_overage	char(1)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
po_item_line_descriptor_key	po_item_line_descriptor	po_item_line_descriptor_key	fk_po_item_line1
po_key	purchase_order	po_key	fk_po_item_line2

Referenced from
Table	Column	Foreign Key Name
po_item_line_attachment_ref	po_item_line_key	fk_po_item_line_att_ref2

Check Constraints
Name	Definition
cc_poil_begin_date	([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31')
cc_poil_end_date	([end_date]>='1900-01-01' AND [end_date]<='2099-12-31')
cc_poil_req_date	([required_by_date]>='1900-01-01' AND [required_by_date]<='2099-12-31')
cc_poil_vi_overage	([vi_overage]='F' OR [vi_overage]='D' OR [vi_overage]='L')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_po_item_line	true	po_item_line_key	Asc
idx_po_item_line2	true	po_key	Asc
		po_item_line_descriptor_key
idx_po_item_line1	false	po_item_line_descriptor_key	Asc

Dependent Views
View Name
po_item_consol_all_view
po_item_consol_approved_view
po_item_consol_view