Project Expenses Table Formats (ProjectExpense)

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

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 (2009) and PP is the two-digit period (01).

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 only. NEEDS INFO

AmountBillingCurrency

decimal 9 Multicurrency only. NEEDS INFO