Expense Budgets Table Formats (ExpenseBudgets)

Follow Vision specifications for preparing a file containing expense budgets.

Field Name Data Type Length Notes

WBS1

varchar

WBS2

varchar

WBS3

varchar

Account

varchar

Required. The account for which you are entering budget information. The account must be a valid account number in Vision.

All overhead projects must reference indirect expense accounts. All regular projects must reference direct and reimbursable expense accounts.

Vendor

varchar Vendor with budget.

ReportedPctComplete

decimal Optional. The job-to-date percent complete for this account number.

CostAmount

decimal Optional. The total amount of money budgeted for this account.

BillingAmount

decimal Optional. The total amount of money budgeted to be billed for this account.

StartDate

datetime Optional. The planned start date for expenses incurred under this account number.

EndDate

datetime Optional. The planned end date for expenses incurred under this account number.

EstimateToCompleteAmount

decimal Optional. The estimated amount of money remaining to be spent under this account number.

EstimateAtCompleteAmount

decimal Optional. The estimated total monetary amount that will have been spent for expenses under this account number at the completion of the project.

EstimateToCompleteBillingAmount

decimal Optional. The estimated amount of money remaining to be spent under this account number, calculated at billing rates.

EstimateAtCompleteBillingAmount

decimal Optional. The estimated total monetary amount that will have been spent for expenses under this account number at the completion of the project, calculated at billing rates.