| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| ApprovalDate | Approval Date | datetime | |
| Approver | Approver | nvarchar | |
| AuthorizationDate | Authorization Date | datetime | |
| AuthorizationValue | Authorization Value | decimal | |
| AuthorizedSignature | Authorized Signature | nvarchar | |
| AuthorizerId | User Id (Authorizer) | int | vr_users |
| AuthorizerName | Authorizer Name | nvarchar | |
| CreatedDate | Record Creation Date | datetime | |
| CreatorId | User Id (Record Creator) | int | vr_users |
| CurrencyExchangeDate | Currency Exchange Date | datetime | |
| CurrencyExchangeId | Currency Exchange Id | int | |
| CurrencyId | Currency Id | int | vrpt_Currency |
| Date | Change Order Date | datetime | |
| EstimateBillFixedCost | Estimate Bill Fixed Cost | bit | |
| EstimateComments | Estimate Comments | nvarchar | |
| EstimateDate | Estimate Date | datetime | |
| EstimateDepartmentCode | Estimate Department Code | nvarchar | |
| EstimateDepartmentId | Estimate Department Id | int | vr_Department |
| EstimateDepartmentName | Estimate Department Name | nvarchar | |
| EstimateDetails | Estimate Details | nvarchar | |
| EstimateEmail | Estimate Email | nvarchar | |
| EstimateId | Estimate Id | int | vr_Estimate |
| EstimateNumber | Estimate Number | nvarchar | |
| EstimateProjectId | Estimate Project Id | int | vr_project |
| EstimateReferenceNumber | Estimate Reference Number | nvarchar | |
| EstimateReferenceType | Estimate Reference Type | nvarchar | |
| EstimateRequestLogId | Estimate Request Log Id | int | vr_Request |
| EstimateRequestorId | Estimate Requestor Id | int | vr_Requestor |
| EstimateRequestorName | Estimate Requestor Name | nvarchar | |
| EstimateRequestorPhone | Estimate Requestor Phone | nvarchar | |
| EstimateWorkOrderId | Work Order Id | int | vr_WorkOrder |
| Id | Change Order Id | int | |
| isAuthorized | Indidicates if the Change Order is Authorized or Not | bit | |
| ModifiedDate | Last Modified Date | datetime | |
| ModifierId | User Id (Record Modifier) | int | vr_users |
| Number | Change Order Number | nvarchar | |
| OriginalHours | Original Hours | decimal | |
| OriginalLabor | Original Labor | decimal | |
| OriginalOther | Original Other | decimal | |
| OriginalPart | Original Part | decimal | |
| OriginalTotal | Original Total | decimal | |
| TechnicianCode | Technician Code | nvarchar | |
| TechnicianId | Technician Id | int | vrpt_Technician |
| TechnicianName | Technician Name | nvarchar | |
| TotalAmount | Total Amount | decimal | |
| UseSignature | Use Signature | bit |