Project Plan Table Formats (RPPlan)
Follow Vision specifications for preparing a file containing project plans.
Field Name | Data Type | Length | Notes |
---|---|---|---|
PlanName |
varchar | 255 | Required field |
PlanNumber |
varchar | 30 | Required field |
OpportunityID |
varchar | 32 | Primary key; must exist in Opportunity (OpportunityID/Opportunity) |
ClientID |
varchar | 32 | Required field; must exist in CL (ClientID/Client) |
ProjMgr |
varchar | 20 | Null or must exist in EM |
Principal |
varchar | 20 | Null or must exist in EM |
Supervisor |
varchar | 20 | Null or must exist in EM |
Org |
varchar | 14 | Null or must exist in Organization |
StartDate |
datetime | 8 | Required field |
EndDate |
datetime | 8 | Required field |
CostRtMethod |
smallint | 2 | |
BillingRtMethod |
smallint | 2 | |
CostRtTable |
smallint | 2 | |
BillingRtTable |
smallint | 2 | |
CompensationFee |
decimal | 9 | |
ConsultantFee |
decimal | 9 | |
ContingencyPct |
decimal | 9 | |
ContingencyAmt |
decimal | 9 | |
OverheadPct |
decimal | 9 | |
AvailableFlg |
varchar | 1 | Default 'N' |
GenResTable |
smallint | 2 | |
UnPostedFlg |
varchar | 1 | Default 'N' |
BudgetType |
varchar | 1 | Default 'C'; must be 'C', 'B', or 'A' |
PctCompleteFormula |
decimal | 9 | |
UtilizationIncludeFlg |
varchar | 1 | Default 'Y' |
ReimbAllowance |
decimal | 9 | |
Probability |
smallint | 2 | |
RevenueFormula |
smallint | 2 | |
Multiplier |
decimal | 9 | |
ProjectedMultiplier |
decimal | 9 | |
ProjectedRatio |
decimal | 9 |