vrpt_PurchaseOrderTotalPerBatch

Updated January 13, 2026 15:52

Field Name	Field Description	Data Type	FK Join
authorized	Authorized	int
batchID	Batch Id	int
Id	Purchase Order Id	int	vr_PurchaseOrder
lastBatchID	Last Batch Id	int
po_actualFreightCost	Actual Freight Cost	decimal
po_attention	Attention	nvarchar
po_authorizationDate	Authorization Date	datetime
po_authorizationValue	Authorization Value	decimal
po_authorized	Indicates if the purchase order record is authorized	bit
po_billTo_fk	Bill To Id	int	vrpt_BillToLocation
po_billToType_fk	Bill To Type Id	int
po_blanket	Indicates if the purchase order record is a blanket purchase order	bit
po_blanketOrderBalance	Blanket Order Balance	decimal
po_blanketOrderLimit	Blanket Order Limit	decimal
po_buyer_fk	Buyer Id	int	vrpt_Technician
po_closed	Indicates if the purchase order record is closed	bit
po_closeddate	Closed Date	datetime
po_comment	Comment	nvarchar
po_createdDate	Record Creation Date	datetime
po_creator_fk	User Id (Record Creator)	int	vr_users
po_date	Date	datetime
po_dp_fk	Department Id	int	vr_Department
po_email	Email	nvarchar
po_freightAmount	Freight Amount	decimal
po_invoicing	Indicates if the purchase order record includes invoicing	bit
po_lastPrintDate	Last Print Date	datetime
po_modifiedDate	Last Modified Date	datetime
po_modifier_fk	User Id (Record Modifier)	int	vr_users
po_number	Purchase Order Number	nvarchar
po_pk	Purchase Order Id	int	vr_PurchaseOrder
po_pot_fk	Purchase Order Type	int
po_proj_fk	Project Id	int	vr_Project
po_PromisedDate	Promised Date	datetime
po_qt_fk	Quote Id	int	vrpt_Quote
po_rc_fk	Repair Center Id	int	vr_RepairCenter
po_referenceNumber	Requestor Number	nvarchar
po_requestorName	Requestor Name	nvarchar
po_requestorPhone	Requestor Phone	nvarchar
po_requiredDate	Required Date	datetime
po_seer_fk	Seer Id	int	vr_Seer
po_shipMethod	Ship Method	nvarchar
po_shipTo_fk	Ship To Id	int	vrpt_ShipToLocation
po_shipToDeliveryNote	Ship To Delivery Note	nvarchar
po_shipToType_fk	Ship To Type Id	int
po_status	Status	nvarchar
po_subtotal	SubTotal	decimal
po_tax_fk	Tax Id	int	vr_TaxRate
po_taxAmount	Tax Amount	decimal
po_taxAmount1	Tax Amount 1	decimal
po_taxAmount2	Tax Amount 2	decimal
po_taxCompound	Indicates if the record utilizes tax compound	bit
po_taxRate	Tax Rate	decimal
po_taxRate2	Tax Rate 2	decimal
po_totalAmount	Total Amount	decimal
po_trackingNumber	Tracking Number	nvarchar
po_user_fk	User Id	int	vr_users
po_ven_fk	Vendor Id	int	vr_Vendor
po_venaddr_fk	Vendor Address Id	int	vr_VendorAddress
po_wh_fk	Warehouse Id	int	vr_warehouse
pr_number	Purchase Requisition Number	nvarchar
receivedDate	Received Date	datetime
WH_CODE	Warehouse Code	nvarchar
WH_NAME	Warehouse Name	nvarchar

Articles in this section