Project Plan - Planned Expense Table Formats (RPPlannedExpenses)
Follow DPS specifications for preparing a file containing planned 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 |
| ExpenseID | varchar | 32 | |
| StartDate | datetime | 8 | Must exist in RPCalendarInterval |
| EndDate | datetime | 8 | Must exist in RPCalendarInterval |
| PeriodScale | varchar | 1 | |
| PeriodCount | int | 4 | |
| PeriodCost | decimal | 9 | |
| PeriodBill | decimal | 9 | |
| PeriodRev | decimal | 9 |