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