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 |