Table: po_labor_line

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	po_labor_line_key	decimal(15)
2.		po_labor_line_descriptor_key	decimal(15)		po_labor_line_descriptor	fk_po_labor_line1
3.		po_key	decimal(15)		purchase_order	fk_po_labor_line2
4.		begin_date	datetime
5.		end_date	datetime
6.		hours	decimal(15,2)
7.		amount	decimal(18,2)
8.		internal_comments	varchar(2000)
9.		external_comments	varchar(2000)
10.		vi_overage	char(1)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
po_labor_line_descriptor_key	po_labor_line_descriptor	po_labor_line_descriptor_key	fk_po_labor_line1
po_key	purchase_order	po_key	fk_po_labor_line2

Referenced from
Table	Column	Foreign Key Name
po_labor_line_attachment_ref	po_labor_line_key	fk_po_labor_line_att_ref2

Check Constraints
Name	Definition
cc_poll_begin_date	([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31')
cc_poll_end_date	([end_date]>='1900-01-01' AND [end_date]<='2099-12-31')
cc_poll_vi_overage	([vi_overage]='F' OR [vi_overage]='D' OR [vi_overage]='L')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_po_labor_line	true	po_labor_line_key	Asc
idx_po_labor_line2	true	po_key	Asc
		po_labor_line_descriptor_key
idx_po_labor_line1	false	po_labor_line_descriptor_key	Asc

Dependent Views
View Name
po_labor_consol_all_view
po_labor_consol_approved_view
po_labor_consol_view