vrpt_PartInventoryList

Updated January 05, 2026 17:49

Field Name	Field Description	Data Type	FK Join
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
cst_pk	Account Id	int	vr_account
fp_code	Part Type Code	nvarchar
fp_pk	Part Type Id	int	vr_PartType
fps_code	Part Sub Type Code	nvarchar
fps_pk	Part Sub Type Id	int
Id	Part Inventory Id	int
inv_active	Indicates Whether the Part Inventory is Active or Not	bit
inv_averagecost	Part Inventory Average Cost	decimal
inv_barCoded	Indicates if the Part Inventory is barcoded	bit
inv_binLabel	Part Inventory Bin Label	nvarchar
inv_clnt_fk	Obsolete Column (No Longer Used)	int
inv_createdDate	Record Creation Date	datetime
inv_creator_fk	User Id (Record Creator)	int	vr_users
inv_critical	Indicates if the Part Inventory is critical	bit
inv_curr_fk	Currency Id	int	vrpt_Currency
inv_deleted	Indicates if the Part Inventory is deleted	bit
inv_exch_date	Currency Exchange Date	datetime
inv_exch_fk	Currency Exchange Id	int
inv_excludefromreordercalc	Indicates if the Record is excluded from Reorder Calculations	bit
inv_markup	Part Inventory Markup	decimal
inv_maximumLevel	Part Inventory Maximum Level	int
inv_minimumLevel	Part Inventory Minimum Level	int
inv_modifiedDate	Last Modified Date	datetime
inv_modifier_fk	User Id (Record Modifier)	int	vr_users
inv_pa_fk	Part Id	int	vr_Part
inv_pk	Part Inventory Id	int
inv_preferedVendor_ven_fk	Preferred Vendor Id	int	vr_Vendor
inv_ps_fk	Antiquated column that is no longer in use	int
inv_quantityOnHand	Part Inventory Quantity on Hand	int
inv_record_code	Part Inventory Record Code	nvarchar
inv_reordepointpercent	Part Inventory Reorder Point Percent	decimal
inv_reorderPoint	Part Inventory Reorder Point	int
inv_reorderQuantity	Part Inventory Reorder Quantity	int
inv_reviewComment	Part Inventory Review Comment	nvarchar
inv_reviewPart	Indicates if the Part Inventory is marked as review Part	bit
inv_standardcost	Part Inventory Standard Cost	decimal
inv_value	Part Inventory Value	decimal
inv_wh_fk	Warehouse Id	int	vr_warehouse
inv_wk_fk	Technician Id	int	vrpt_Technician
isPartKit	Indicates if the part record is from part kit	int
lastUnitPrice	Last Unit Price	decimal
mfg_code	Manufacturer Code	nvarchar
mfg_name	Manufacturer Name	nvarchar
OverStock	OverStock	int
pa_active	Indicates Whether the Part is Active or Not	bit
pa_alternateCode	Part Alternate Code	nvarchar
PA_AverageCost	Part Average Cost	decimal
pa_code	Part Code	nvarchar
pa_description	Part Description	nvarchar
pa_excludeFromPurchase	Indicates if the part record is excluded from Purchase Orders	bit
pa_excludefromRequestor	Indicates if the part record is excluded from Requestors	bit
pa_fp_fk	Part Type Id	int	vr_PartType
pa_manufacturerNumber	Part Manufacturer Number	nvarchar
pa_orderUnit	Part Order Unit	nvarchar
pa_orderUnitQuantity	Part Order Unit Quantity	int
pa_pk	Part Id	int	vr_Part
pa_serialized	Indicates if the part record is serialized	bit
pa_taxPurchases	Indicates if the part record is eligible for tax on purhcases	bit
pa_taxSales	Indicates if the part record is eligible for tax on sales	bit
pa_unitofMeasure	Part Unit of Measure	nvarchar
PartAvailable	Part Available	int
PartCost	Part Cost	decimal
PartCostNoMarkup	Part Cost no markup	decimal
quantityOnOrder	Quantity on order	decimal
serialized	Indicates if the part record is serialized	bit
serializedInt	Serialized (number format)	int
StockPartAvailable	Stock Part Available	int
stockQtyOnHand	Stock Quantity on Hand	int
Understock	Understock	int
unitcostforPO	Unit Cost for Purchase Orders	decimal
unitcostforSRWPO	Unit Cost for Stock Replenishment Wizard Purchase Orders	decimal
ven_active	Indicates Whether the Vendor is Active or Not	bit
ven_code	Vendor Code	nvarchar
ven_isVendor	Is Vendor	bit
ven_name	Vendor Name	nvarchar
ven_pk	Vendor Id	int	vr_Vendor
WH_active	Indicates if the Warehouse is Active or Not	bit
WH_autoPOAcctCst_FK	Account Id	int	vr_account
wh_billTo_fk	Bill To Id	int	vrpt_BillToLocation
wh_billToType_fk	Bill To Type Id	int
WH_CODE	Warehouse Code	nvarchar
WH_CST_FK	Account Id	int	vr_account
wh_deliveryInstruction	Delivery Instructions	nvarchar
wh_mostItemTaxable	Indicates if most item's are taxable	bit
WH_NAME	Warehouse Name	nvarchar
WH_PK	Warehouse Id	int	vr_warehouse
wh_shipTo_fk	Ship To Id	int	vrpt_ShipToLocation
wh_shipToType_fk	Ship To Type Id	int
wh_tax_fk	Tax Rate Id	int	vr_TaxRate
wk_id	Technician Record Id	nvarchar
wk_name	Technician Name	nvarchar

Articles in this section