| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| authorized | Authorized | int | |
| AuthorizedBy | Authorized By | nvarchar | |
| authorizedSignature | Authorized Signature | nvarchar | |
| cst_code | Account Code | nvarchar | |
| dp_code | Department Code | nvarchar | |
| dp_name | Department Name | nvarchar | |
| est_act_fk | Project Activity (Task) Id | int | vrpt_ProjectTask |
| est_actualEnd | Actual End | datetime | |
| est_actualStart | Actual Start | datetime | |
| est_approvalDate | Approval Date | datetime | |
| est_approvedBy | Approved By | nvarchar | |
| est_approvedDate | Approved Date | datetime | |
| est_approver | Approver | nvarchar | |
| est_authorizationDate | Authorization Date | datetime | |
| est_authorizationValue | Authorization Value | decimal | |
| est_authorized | Indicates Whether the record is Authorized or Not | bit | |
| est_billFixedCost | Bill Fixed Cost | bit | |
| est_clnt_fk | Obsolete Column (No Longer Used) | int | |
| est_comments | Comments | nvarchar | |
| est_createdDate | Record Creation Date | datetime | |
| est_creator_fk | User Id (Record Creator) | int | vr_Users |
| est_curr_fk | Currency Id | int | vrpt_Currency |
| est_date | Estimate Date | datetime | |
| est_details | Details | nvarchar | |
| est_dp_fk | Department Id | int | vr_Department |
| est_Email | nvarchar | ||
| est_estimatedEnd | Estimated End | datetime | |
| est_estimatedStart | Estimated Start | datetime | |
| est_exch_date | Currency Exchange Date | datetime | |
| est_exch_fk | Currency Exchange Id | int | |
| est_log_fk | Request Log Id | int | vr_Request |
| est_modifiedDate | Last Modified Date | datetime | |
| est_modifier_fk | User Id (Record Modifier) | int | vr_Users |
| est_number | Estimate Number | nvarchar | |
| est_overage_cst_fk | Account Id | int | vr_account |
| est_pk | Estimate Id | int | |
| est_proj_fk | Project Id | int | vr_Project |
| est_quotation | Quotation | bit | |
| est_referenceNumber | Reference Number | nvarchar | |
| est_referenceType | Reference Type | nvarchar | |
| est_requestorName | Reqeustor Name | nvarchar | |
| est_requestorPhone | Requestor Phone | nvarchar | |
| est_rq_fk | Requestor Id | int | vr_Requestor |
| est_RS_Means | RS Means | bit | |
| est_totalAmount | Total Amount | decimal | |
| est_totalHours | Total Hours | decimal | |
| est_totalLabor | Total Labor | decimal | |
| est_totalOther | Total Other | decimal | |
| est_totalPart | Total Part | decimal | |
| EST_USE_SIG | Use Singnature | bit | |
| est_user_fk | User Id | int | vr_Users |
| est_wk_fk | Technician Id | int | vrpt_Technician |
| est_wo_fk | Work Order Id | int | vr_WorkOrder |
| LOG_NUMBER | Reqeust Log Number | nvarchar | |
| proj_number | Project Number | nvarchar | |
| wk_id | Technician Record Id | nvarchar | |
| wk_name | Technician Name | nvarchar | |
| wo_number | Work Order Number | nvarchar |