Project Expenses Table Formats (ProjectExpense)

Follow Vantagepoint 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 Vantagepoint.
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.