v_SimplestPartInventory

Updated November 13, 2025 16:27

Field Name	Field Description	Data Type	FK Join
clnt_pk	Obsolete Column (No Longer Used)	int
cst_code	Account Code	nvarchar
inv_active	Indicates if the Inventory Line is Active	bit
inv_averagecost	Average Cost	decimal
inv_binLabel	Bin Location	nvarchar
inv_deleted	Indicates if the Inventory was Deleted	bit
inv_maximumLevel	Maximum Level	int
inv_minimumLevel	Minimum	int
inv_pa_fk	Part Id	int	vr_Part
inv_pk	Part Inventory Id	int	vrpt_PartInventoryList
inv_quantityOnHand	Quantity On Hand	int
inv_record_code	Inventory Record Code	nvarchar
inv_reviewComment	Review Comment	nvarchar
inv_reviewPart	Review Part	bit
inv_standardcost	Standard Cost	decimal
inv_wh_fk	Warehouse Id	int	vr_warehouse
mfg_code	Manufacturer Code	nvarchar
mfg_name	Manufacturer Number	nvarchar
pa_active	Indicates if the Part is Active or Not	bit
pa_averagecost	Average Cost	decimal
pa_code	Part Code	nvarchar
pa_description	Part Description	nvarchar
pa_excludefromRequestor	Exclude from Requestor	bit
pa_manufacturerNumber	Manufacturer Number	nvarchar
pa_mfg_fk	Manufacturer Id	int	vr_Vendor
pa_orderUnitQuantity	Order Unit Quantity	int
pa_pk	Part Id	int	vr_Part
pa_serialized	Indicates if the Part is Serialized or Not	bit
pa_taxsales	Tax Sales	bit
PartAvailable	Part Available	int
PartCost	Part Cost	decimal
PartCostNoMarkup	Part Cost No Markup	decimal
partwholesaleCost	Part Wholesale Cost	decimal
serialized	Indicates if the Part is Serialized or Not	bit
serializedInt	Serialzed Int	int
StockPartAvailable	Stock Part Available	int
stockQtyOnHand	Quantity On Hand	int
WH_active	Indicates if the Warehouse is Active or Not	bit
WH_CODE	Warehouse Code	nvarchar
WH_CST_FK	Account Id	int	vr_account
wh_name	Warehouse Name	nvarchar

Articles in this section