vrpt_PurchaseRequisition

Updated January 13, 2026 16:00

Field Name	Field Description	Data Type	FK Join
ArchiveProjectId	Archive Project Id	int
ArchiveQuoteId	Archive Quote Id	int
AuthorizationDate	Authorization Date	datetime
AuthorizationRequired	Authorization Required	bit
AuthorizationValue	Authorization Value	decimal
Authorized	Authorized	bit
AuthorizedSignature	Authorized Signature	nvarchar
AuthorizerId	User Id (Authorizer)	int	vr_users
AuthorizerName	Authorizer Name	nvarchar
Blanket	Indicates if the Record is a Blanket Purchase Requisition	bit
Closed	Closed	bit
Comment	Comments	nvarchar
Converted	Converted	int
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	Date	datetime
DepartmentId	Department Id	int	vr_Department
ExportRequest	Export Request	bit
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Purchase Requisition Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Purchase Requisition Number	nvarchar
pr_pk	Purchase Requisition Id	int
ProjectId	Project Id	int	vr_project
PRTaxCompound	Indicates if the record utilizes tax compound	bit
PRTaxRate	Tax Rate	decimal
PRTaxRate2	Tax Rate 2	decimal
PurchaseOrderNumber	Purchase Order Number	nvarchar
PurchaseOrderTypeId	Purchase Order Type Id	int	vr_PurchaseOrderType
QuoteId	Quote Id	int	vrpt_Quote
ReferenceNumber	Reference 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
ShipMethod	Ship Method	nvarchar
ShipToDeliveryNote	Ship To Delivery Note	nvarchar
ShipToLocationId	Ship To Location Id	int	vrpt_ShipToLocation
ShipToTypeId	Ship To Type Id	int
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
SubTotal	Sub Total	decimal
TaxAmount	Tax Amount	decimal
TaxAmount1	Tax Amount 1	decimal
TaxAmount2	Tax Amount 2	decimal
TaxlineSubTotal	Taxline Sub Total	decimal
TaxRateId	Tax Rate Id	int	vr_TaxRate
TechnicianId	Technician Id	int	vrpt_Technician
TotalAmount	Total Amount	decimal
UIExport	Indicates if the record is available for UI Export	bit
UseSignature	Use Signature	bit
VendorAddressId	Vendor Address Id	int	vr_VendorAddress
VendorId	Vendor Id	int	vr_Vendor
WarehouseId	Warehouse Id	int	vr_warehouse

Articles in this section