Project Plan - Expense Table Formats (RPExpense)

Follow DPS specifications for preparing a file containing 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
Vendor	varchar	20	Required field; must exist in VE
StartDate	datetime	8	Must exist in RPCalendarInterval
EndDate	datetime	8	Must exist in RPCalendarInterval
ExpBillRate	decimal	9
SortSeq	smallint	2