vrpt_PurchaseOrderItems

Updated January 13, 2026 15:50

Field Name	Field Description	Data Type	FK Join
ClassCode	Class Code	nvarchar
CommodityCode	Commodity Code	nvarchar
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
DistributeBalance	Distribute Balance	decimal
fpo_backorder	Back Order	decimal
fpo_balance	Balance	decimal
fpo_batchID	Batch Id	int	vr_BatchJob
fpo_comment	Comment	nvarchar
fpo_cst_fk	Account Id	int	vr_account
fpo_detailcode	Detail Code	nvarchar
fpo_detaildescription	Detail Description	nvarchar
fpo_extendedcost	Extended Cost	decimal
fpo_item_fk	Item Id	int
fpo_itemCategory_fk	Item Category Id	int
fpo_itemCode	Item Code	nvarchar
fpo_itemDescription	Item Description	nvarchar
fpo_itemlocation_fk	Item Location Id	int
fpo_itemlocationtype_fk	Item Location Type Id	int
fpo_itemlocCode	Item Location Code	nvarchar
fpo_itemlocName	Item Location Name	nvarchar
fpo_itemRC_fk	Repair Center Id	int	vr_RepairCenter
fpo_itemType_fk	Item Type Id	int
fpo_itemtypeCode	Item Type Code	nvarchar
fpo_itemtypeDescription	Item Type Description	nvarchar
fpo_lineNumber	Line Number	smallint
fpo_otp_fk	One Time Purchase Id	int
fpo_otpCode	One Time Purchase Code	nvarchar
fpo_otpDescription	One Time Purchase Description	nvarchar
fpo_pa_fk	Part Id	int	vr_Part
fpo_partcode	Part Code	nvarchar
fpo_pk	Purchase Order Detail Id	int
fpo_po_fk	Purchase Order Id	int	vr_PurchaseOrder
fpo_prevreceived	Previous Received	decimal
fpo_prevReturned	Previous Returned	decimal
fpo_quantity	Quantity	decimal
fpo_referenceNumber	Reference Number	nvarchar
fpo_taxable	Indicates if this Puchase Order's Item is taxable	bit
fpo_um_fk	Unit Of Measure Id	int	vr_UnitMeasure
fpo_unitCost	Unit Cost	decimal
fpo_unitOfMeasure	Unit Of Measure	nvarchar
fpo_wh_fk	Warehouse Id	int	vr_warehouse
Id	Purchase Order Detail Id	int
isOTP	Indicates if the record is One Time Purchase	int
itemType_name	Item Type Name	nvarchar
lineUnitOfMeasure	Line Unit Of Measure	nvarchar
mfg_code	Manufacturer Code	nvarchar
mfg_name	Manufacturer Name	nvarchar
ON_ORDER	On Order	decimal
orderUnitAndQuantity	Order Unit and Quantity	nvarchar
otp_code	One Time Purchase Code	nvarchar
otp_description	One Time Purchase Description	nvarchar
pa_manufacturerNumber	Part Manufacturer Number	nvarchar
pa_orderUnit	Part Order Unit	nvarchar
pa_orderUnitQuantity	Part Order Unit Quantity	int
pa_specification	Part Specification	nvarchar
rc_code	Repair Center Code	nvarchar
rc_name	Repair Center Name	nvarchar
TotalCost	Total Cost	float
VendorPartCode	Vendor Part Code	nvarchar
WH_CODE	Warehouse Code	nvarchar
WH_NAME	Warehouse Name	nvarchar

Articles in this section