vrpt_Quote

Updated January 19, 2026 16:03

Field Name	Field Description	Data Type	FK Join
BuyerId	Technician Id (Buyer)	int	vrpt_Technician
Comment	Comments	nvarchar
DepartmentId	Department Id	int	vr_Department
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Quote Id	int
lastPODate	Last Purchase Order Date	datetime
lastPRDate	Last Purchase Requisition Date	datetime
Number	Quote Number	nvarchar
PurchaseRequisitionId	Purchase Requisition Id	int	vrpt_PurchaseRequisition
qt_fromPR_fk	From Purchase Requisition Id	int	vrpt_PurchaseRequisition
qt_pk	Quote Id	int
qt_subtotal	Sub Total	decimal
qt_taxAmount	Tax Amount	decimal
qt_totalAmount	Total Amount	decimal
QuoteDate	Quote Date	datetime
QuoteNumber	Quote Number	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RequestorPhone	Requestor Phone	nvarchar
RequiredDate	Required Date	datetime
ShipToDeliveryNote	Ship To Delivery Note	nvarchar
ShipToId	Ship To Id	int	vrpt_ShipToLocation
ShipToTypeId	Ship To Type Id	int
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
TaxCompound	Indicates if the record utilizes Tax Compound	bit
TaxId	Tax Id	int	vr_TaxRate
TaxRate1	Tax Rate 1	decimal
TaxRate2	Tax Rate 2	decimal
WarehouseId	Warehouse Id	int	vr_warehouse