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 |