Project Plan - Consultant Table Formats (RPConsultant)

Follow Deltek 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