vr_PurchaseOrder

Updated November 27, 2025 12:57

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	bit
AuthorizedSignature	Authorized Signature	nvarchar
AuthorizerId	User Id (Authorizer)	int	vr_Users
AuthorizerName	Authorizer Name	nvarchar
BillToLocationAddress1	Bill To Location Address 1	nvarchar
BillToLocationAddress2B	Bill To Location Address 2B	nvarchar
BillToLocationCity	Bill To Location City	nvarchar
BillToLocationCode	Bill To Location Code	nvarchar
BillToLocationId	Bill To Location Id	int	vrpt_BillToLocation
BillToLocationName	Bill To Location Name	nvarchar
BillToLocationState	Bill To Location State	nvarchar
BillToLocationZip	Bill To Location Zip	nvarchar
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
BuyerCode	Buyer Code	nvarchar
BuyerId	Technician Id (Buyer)	int	vrpt_Technician
BuyerName	Technician Name	nvarchar
Closed	Closed	bit
ClosedDate	Closed Date	datetime
Comment	Comments	nvarchar
ComputedWarehouseId	Warehouse Id	int	vr_warehouse
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	Purchase Order Date	datetime
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
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_pk	Purchase Order 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
ProjectName	Project Name	nvarchar
ProjectNumber	Project Number	nvarchar
PromisedDate	Promised Date	datetime
PurchaseOrderTypeCode	Purchase Order Type Code	nvarchar
PurchaseOrderTypeDescription	Purchase Order Type Description	nvarchar
PurchaseOrderTypeId	Purchase Order Type Id	int	vr_PurchaseOrderType
PurchaseRequisitionId	Purchase Requisition Id	int	vrpt_PurchaseRequisition
PurchaseRequisitionNumber	Purchase Requisition Number	nvarchar
QuoteArchiveId	Archive Quote Id	int
QuoteId	Quote Id	int	vrpt_Quote
QuoteNumber	Quote Number	nvarchar
QuoteVendorArchiveId	Archive Quote Vendor Id	int
QuoteVendorId	Quote Vendor Id	int	vrpt_QuoteVendor
QuoteVendorStandingPurchaseOrder	Indicates if the record has a Quote Vendor Standing Purchase Order	bit
QuoteVendorStandingPurchaseOrderNumber	Quote Vendor Standing Purchase Order Number	nvarchar
ReferenceNumber	Reference Number	nvarchar
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterName	Repair Center Name	nvarchar
RequestorEmail	Requestor Email	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RequestorPhone	Requestor Phone	nvarchar
RequiredDate	Required Date	datetime
SeerBalance	Seer Balance	decimal
SeerId	Seer Id	int	vr_Seer
SeerNumber	Seer Number	nvarchar
SeerUsedAmount	Seer Used Amount	decimal
ShipMethod	Ship Method	nvarchar
ShipToDeliveryNote	Ship To Delivery Note	nvarchar
ShipToLocationAddress1	Ship To Location Address 1	nvarchar
ShipToLocationAddress2	Ship To Location Address 2	nvarchar
ShipToLocationCity	Ship To Location City	nvarchar
ShipToLocationCode	Ship To Location Code	nvarchar
ShipToLocationId	Ship To Location Id	int	vrpt_ShipToLocation
ShipToLocationName	Ship To Location Name	nvarchar
ShipToLocationState	Ship To Location State	nvarchar
ShipToLocationZip	Ship To Location Zip	nvarchar
ShipToTypeId	Ship To Type Id	int
StatusAllowNote	Indicates if this record allows a status note	bit
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
TaxRateId	Tax Rate Id	int	vr_TaxRate
TaxRateName	Tax Rate Name	nvarchar
TaxRatePurchase	Tax Rate Purchase	bit
TaxRateRate1	Tax Rate 1	decimal
TaxRateRate2	Tax Rate 2	decimal
TaxRateTax1Description	Tax Rate 1 Description	nvarchar
TaxRateTax2Description	Tax Rate 2 Description	nvarchar
TaxRateTaxCompound	Indicates if the record utilizes tax compound	bit
TotalAmount	Total Amount	decimal
TrackingNumber	Tracking Number	nvarchar
uiExport	Indicates if the record is available for UI Export	bit
VendorAddressAddress1	Vendor Address Line 1	nvarchar
VendorAddressAddress2	Vendor Address Line 2	nvarchar
VendorAddressCategory	Vendor Address Category	nvarchar
VendorAddressCity	Vendor City	nvarchar
VendorAddressContact	Vendor Contact	nvarchar
VendorAddressEmail	Vendor Email	nvarchar
VendorAddressFax	Vendor Fax #	nvarchar
VendorAddressId	Vendor Address Id	int	vr_VendorAddress
VendorAddressPhone	Vendor Phone #	nvarchar
VendorAddressPhoneExtension	Vendor Phone # Extension	nvarchar
VendorAddressState	Vendor State	nvarchar
VendorAddressZipCode	Vendor Zip Code	nvarchar
VendorCode	Vendor Code	nvarchar
VendorComment	Vendor Comments	nvarchar
VendorCustomerNumber	Vendor Customer Number	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar
VendorTerm	Vendor Term	nvarchar
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