Project Plan - Baseline Consultant Table Formats (RPBaselineConsultant)
Follow Vision specifications for preparing a file containing baseline 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 |