Labor Budgets Table Formats (LaborBudgets)
Follow Vision specifications for preparing a file containing labor budgets.
Field Name | Data Type | Length | Notes |
---|---|---|---|
WBS1 |
varchar | ||
WBS2 |
varchar | ||
WBS3 |
varchar | ||
LaborCode |
varchar | Required. The labor code for which you are entering budget information. This code must be a valid labor code in Vision. | |
ReportedPctComplete |
decimal | Optional. The job-to-date percent complete for this labor code | |
BudgetedCostRate |
decimal | Optional. The budgeted amount per hour for labor charged to this labor code. | |
Hours |
decimal | Optional. The total number of hours budgeted for this labor code. | |
CostAmount |
decimal | Optional. The total amount budgeted for this labor code. | |
BillingAmount |
decimal | Optional. The total amount budgeted to be billed for this labor code. | |
StartDate |
datetime | Optional. The planned start date for work performed under this labor code. | |
EndDate |
datetime | Optional. The planned end date for work performed under this labor code. | |
EstimateToCompleteHours |
decimal | Optional. The estimated number of hours remaining to be worked under this labor code. | |
EstimateToCompleteAmount |
decimal | Optional. The estimated amount of money remaining to be spent under this labor code. | |
EstimateAtCompleteHours |
decimal | Optional. The estimated total number of hours that will have been worked at the completion of the project for this labor code: Actual hours + Estimate to complete hours. | |
EstimateAtCompleteAmount |
decimal | Optional. The estimated total monetary amount that will have been expended at the completion of the project for this labor code. | |
EstimateToCompleteBillingAmount |
decimal | Optional. The estimated additional monetary amount for labor that is required to complete the work, calculated at billing rates. | |
EstimateAtCompleteBillingAmount |
decimal | Optional. The estimated total monetary amount that will have been spent for labor at the completion of the project, calculated at billing rates. |