vr_Estimate

Updated November 24, 2025 15:58

Field Name	Field Description	Data Type	FK Join
ActualEnd	Actual End	datetime
ActualStart	Actual Start	datetime
ApprovalDate	Approval Date	datetime
ApprovedBy	Approved By	nvarchar
ApprovedDate	Approved 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
BillFixedCost	Indicates if the record is fixed bill cost	bit
Comments	Comments	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	Estimate Date	datetime
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Details	Details	nvarchar
Email	Email	nvarchar
EstimatedEnd	Estimated End Date	datetime
EstimatedStart	Estimated Start Date	datetime
Id	Estimate Id	int
IsAuthorized	Indicates if the Estimate is Authorizied or Not	bit
ItemId	Item Id	int
ItemNumber	Item Number	nvarchar
ItemTypeId	Item Type Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Estimate Number	nvarchar
OverageAccountCode	Overage Account Code	nvarchar
OverageAccountId	Overage Account Id	int	vr_account
OverageAccountName	Overage Account Name	nvarchar
ProjectId	Project Id	int	vr_project
ProjectTaskId	Project Task Id	int	vrpt_ProjectTask
Quotation	Indicates if the record is a quote	bit
ReferenceNumber	Reference Number	nvarchar
ReferenceType	Reference Type	nvarchar
RequestLogId	Request Log Id	int	vr_request
RequestorName	Requestor Name	nvarchar
RequestorPhone	Requestor Phone	nvarchar
RequestorRequestorId	Requestor Id	int	vr_Requestor
RequestorRequestorName	Requestor Name	nvarchar
RSMeans	Indicates if the record is using RSMeans (RSMeans is a database of current construction cost estimates)	bit
StatusAllowNote	Indicates if this record allows a status note	bit
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
TotalAmount	Total Amount	decimal
TotalHours	Total Hours	decimal
TotalLabor	Total Labor Cost	decimal
TotalOther	Total Other Cost	decimal
TotalPart	Total Part	decimal
UseSig	Use Signature	bit
WorkOrderId	Work Order Id	int	vr_WorkOrder

Articles in this section