Project Expenses Table Formats (ProjectExpense)

Follow DPS specifications for preparing a file containing project expenses.

Field Name	Data Type	Length	Notes
WBS1	varchar
WBS2	varchar
WBS3	varchar
Account	varchar		Required. The account for this charge. The account must be a valid account number in DPS.
Vendor	varchar
TransDate	datetime		Required. The transaction date for this charge. If you do not specify a date, this field defaults to today’s date.
Period	integer		Required. The period in which this charge was posted. The period must be prior or equal to the active period. The default for overhead projects is YTD (year-to-date). The default for regular projects is 0. The format for this field is YYYYPP, where YYYY is the four-digit year and PP is the two-digit period.
Description	varchar		Optional. The description for this transaction.
Amount	decimal		Optional. The cost amount for this transaction.
BillExt	decimal		Optional. The billing amount for this transaction.
BillStatus	varchar		Required. The billing status for this transaction. B for billable, H for held, W for written-off, or N for nonbillable.
AmountProjectCurrency	decimal	9	Multicurrency feature only.
AmountBillingCurrency	decimal	9	Multicurrency feature only.