Project Plan - Planned Consultant Table Formats (RPPlannedConsultant)

Follow Vision specifications for preparing a file containing planned 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

StartDate

datetime 8 Must exist in RPCalendarInterval

EndDate

datetime 8 Must exist in RPCalendarInterval

PeriodScale

varchar 1

PeriodCount

int 4

PeriodCost

decimal 9

PeriodBill

decimal 9

PeriodRev

decimal 9