Project Plan - Baseline Expense Table Formats (RPBaselineExpenses)
Follow DPS specifications for preparing a file containing baseline 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 |