Project Plan - Task Table Formats (RPTask)

Follow Vision specifications for preparing a file containing project plan-task associations.

Field Name Data Type Length Notes

PlanNumber

varchar 30 Required field; must exist in RPPlan

OutlineNumber

varchar 255 Required field

Name

varchar 40 Required field

LaborCode

varchar 14 Null or must exist in CFGLCCodes

WBS1

varchar 30 Must exist in PR

WBS2

varchar 7 Must exist in PR

WBS3

varchar 7 Must exist in PR

WBSType

varchar 4

ParentOutlineNumber

varchar 255 Must exist in RPTask

ChildrenCount

int 4 Required field

OutlineLevel

int 4 Required field

Priority

int 4

OverheadPct

decimal 9

StartDate

datetime 8 Must exist in RPCalendarInterval

EndDate

datetime 8 Must exist in RPCalendarInterval

CostRate

decimal 9

BillingRate

decimal 9

ExpBillRate

decimal 9

ConBillRate

decimal 9