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 |
