| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| authorized | Authorized | int | |
| est_billFixedCost | Estimate Bill Fixed Cost | bit | |
| est_date | Estimate Date | datetime | |
| est_log_fk | Request Log Id | int | vr_Request |
| est_number | Estimate Number | nvarchar | |
| est_overage_cst_fk | Overage Account Id | int | vr_account |
| est_pk | Estimate Id | int | vr_Estimate |
| est_proj_fk | Project Id | int | vr_Project |
| est_referenceType | Estimate Reference Type | nvarchar | |
| est_requestorName | Estimate Requestor Name | nvarchar | |
| est_wo_fk | Work Order Id | int | vr_WorkOrder |
| id | Estimate Id | int | vr_Estimate |
| totalAMount | Total Amount | decimal | |
| totalHours | Total Hours | decimal | |
| totalLabor | Total Labor Cost | decimal | |
| totalMaterial | Total Material Cost | decimal | |
| totalOther | Total Other Cost | decimal | |
| wk_id | Technician Record Id | nvarchar | |
| wk_name | Technician Name | nvarchar |