vr_ChangeOrder

Updated November 18, 2025 16:33

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

Articles in this section