Project Plan - Assignment Table Formats (RPAssignment)
Follow Vision specifications for preparing a file containing project plan-assignment associations.
Field Name | Data Type | Length | Notes |
---|---|---|---|
PlanNumber |
varchar | 30 | Required field; must exist in RPPlan |
OutlineNumber |
varchar | 255 | Required field |
ResourceID |
varchar | 32 | Required field; must exist in EM |
AssignmentID |
varchar | 32 | |
GenericResourceID |
varchar | 20 | RPAssignment.GenericResourceID needs to be joined to GR.Code |
ActivityID |
varchar | 32 | Null or must exist in Activity |
StartDate |
datetime | 8 | Must exist in RPCalendarInterval |
EndDate |
datetime | 8 | Must exist in RPCalendarInterval |
CostRate |
decimal | 9 | |
BillingRate |
decimal | 9 |