vr_PartInventory

Updated March 24, 2026 15:16

Field Name	Field Description	Data Type	FK Join
Id	Part Inventory Id	int
BinLabel	Bin Label	nvarchar
MinimumLevel	Minimum Level	int
MaximumLevel	Maximum Level	int
ReorderPoint	Reorder Point	int
ReorderQuantity	Reorder Quantity	int
Deleted	Indicates if the record is deleted	bit
Active	Indicates if the record is active	bit
InventoryActive	Indicates if the inventory record is active	bit
Critical	Indicates if the record is critical	bit
BarCoded	Indicates if the record is barcoded	bit
AverageCost	Average Cost	decimal
StandardCost	Standard Cost	decimal
Markup	Markup	decimal
ReorderedPointPercent	Reordered Point Percent	decimal
ExcludeFromReorderCalc	Indicates if this record is excluded from the reorder calculations.	bit
ReviewPart	Review Part	bit
ReviewComment	Review Comment	nvarchar
CreatorId	User Id (Record Creator)	int	vr_users
CreatedDate	Record Creation Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
ModifiedDate	Last Modified Date	datetime
CurrencyId	Currency Id	int	vrpt_Currency
CurrencyExchangeId	Currency Exchange Id	int
CurrencyExchangeDate	Currency Exchange Date	datetime
PartId	Part Id	int	vr_Part
PartCode	Part Code	nvarchar
PartDescription	Part Description	nvarchar
PartOrderUnit	Part Order Unit	nvarchar
PartTypeId	Part Type Id	int	vr_PartType
ExcludeFromRequestor	Indicates if the record is to be excluded from the requestor	bit
VendorId	Vendor Id	int	vr_Vendor
VendorCode	Vendor Code	nvarchar
VendorName	Vendor Name	nvarchar
PreferredVendorCode	Preferred Vendor Code	nvarchar
PreferredVendorName	Preferred Vendor Name	nvarchar
WarehouseId	Warehouse Id	int	vr_warehouse
WarehouseCode	Warehouse Code	nvarchar
WarehouseName	Warehouse Name	nvarchar
WarehouseAccountId	Warehouse Account Id	int
WarehouseActive	Indicates if the warehouse is active	bit
WarehouseVirtual	Indicates if the warehouse is virtual	bit
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianCode	Technician Code	nvarchar
TechnicianName	Technician Name	nvarchar
SKUCode	SKU Code	nvarchar
TagNumber	Tag Number	nvarchar
QuantityOnHand	Quantity On Hand	int
StockQuantityOnHand	Stock Quantity On Hand	int
SKUQuantityOnHand	SKU Quantity On Hand	int
PartAvailable	Part Available	int
StockAvailable	Stock Available	int
Serialized	Indicates if the record is serialized	bit
PartSerialized	Indicates if the part is serialized	bit
OrderUnitDesc	Order Unit Description	nvarchar
InventoryValue	Inventory Value	decimal
SKUInventoryValue	SKU Inventory Value	decimal
WholeSaleCost	Wholesale Cost	decimal
PartCost	Part Cost	decimal
QuantityOnOrder	Quantity On Order	decimal
OverStock	Overstock	int
Understock	Understock	int

Articles in this section