Project Plan - Consultant Table Formats (RPConsultant)

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