vrpt_PurchaseOrder

Updated January 13, 2026 15:48

Field Name	Field Description	Data Type	FK Join
ActualAmount	Actual Amount	decimal
ActualFreightCost	Actual Freight Cost	decimal
Attention	Attention	nvarchar
AuthorizationDate	Authorization Date	datetime
AuthorizationRequired	Authorization Required	bit
AuthorizationValue	Authorization Value	decimal
Authorized	Authorized	int
AuthorizedSignature	Authorized Signature	nvarchar
AuthorizerId	User Id (Authorizer)	int	vr_users
AuthorizerName	Authorizer Name	nvarchar
BillToLocationId	Bill To Location Id	int	vrpt_BillToLocation
BillToTypeId	Bill To Type Id	int
Blanket	Indicates if the record is a Blanket Purchase Order	bit
BlanketOrderBalance	Blanket Order Balance	decimal
BlanketOrderLimit	Blanket Order Limit	decimal
BuyerId	Technician Id (Buyer)	int	vrpt_Technician
Closed	Closed	bit
ClosedDate	Closed Date	datetime
Comment	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	Date	datetime
DepartmentId	Department Id	int	vr_Department
DistribTaxPassThruRate	Distribution Tax Pass Thru Rate	decimal
Email	Email	nvarchar
FreightAmount	Freight Amount	decimal
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
HasBeenReceived	Indicates if the record has been received	bit
Id	Purchase Order Id	int
Invoicing	Indicates if the record has invoicing	bit
IsAuthorized	Indicates if the record is authorized	bit
LastPrintDate	Last Print Date	datetime
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Purchase Order Number	nvarchar
po_billTo_fk	Bill To Id	int	vrpt_BillToLocation
po_billToType_fk	Bill To Type Id	int
POTaxCompound	Indicates if the record utilizes tax compound	bit
POTaxPassThruRate	Purchase Order Tax Pass Thru Rate	decimal
POTaxRate	Purchase Order Tax Rate	decimal
POTaxRate2	Purchase Order Tax Rate 2	decimal
ProjectId	Project Id	int	vr_project
PromisedDate	Promised Date	datetime
PurchaseOrderTypeId	Purchase Order Type Id	int	vr_PurchaseOrderType
PurchaseRequisitionId	Purchase Requisition Id	int	vrpt_PurchaseRequisition
PurchaseRequisitionNumber	Purchase Requisition Number	nvarchar
QuoteArchiveId	Quote Archive Id	int
QuoteId	Quote Id	int	vrpt_Quote
QuoteVendorArchiveId	Quote Vendor Archive Id	int
QuoteVendorId	Quote Vendor Id	int	vr_Vendor
receivedDate	Received Date	datetime
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
SeerId	Seer Id	int	vr_Seer
ShipMethod	Ship Method	nvarchar
ShipToDeliveryNote	Ship To Delivery Note	nvarchar
ShipToLocationId	Ship To Location Id	int	vrpt_ShipToLocation
ShipToTypeId	Ship To Type Id	int
StatusCode	Status Code	nvarchar
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
SubTotal	SubTotal	decimal
TaxAmount	Tax Amount	decimal
TaxAmount1	Tax Amount 1	decimal
TaxAmount2	Tax Amount 2	decimal
TaxlineSubTotal	Taxline SubTotal	decimal
TaxRateId	Tax Rate Id	int	vr_TaxRate
TotalAmount	Total Amount	decimal
TrackingNumber	Tracking Number	nvarchar
VendorAddressId	Vendor Address Id	int	vr_VendorAddress
VendorId	Vendor Id	int	vr_Vendor
WareHouseAccountId	Warehouse Account Id	int	vr_account
WarehouseCode	Warehouse Code	nvarchar
WarehouseDeliveryInstruction	Warehouse Delivery Instructions	nvarchar
WarehouseId	Warehouse Id	int	vr_warehouse
WarehouseName	Warehouse Name	nvarchar

Articles in this section