Project Plan - Consultant Table Formats (RPConsultant)

Follow DPS specifications for preparing a file containing consultant expenses for project plans.

Field Name	Data Type	Length	Notes
PlanNumber	varchar	30	Required field; must exist in RPPlan
OutlineNumber	varchar	255	Required field
Account	varchar	13	Required field; must exist in CA
ConsultantID	varchar	32
Vendor	varchar	20	Required field; must exist in VE
StartDate	datetime	8	Must exist in RPCalendarInterval
EndDate	datetime	8	Must exist in RPCalendarInterval
ConBillRate	decimal	9
SortSeq	smallint	2