vr_Part

Updated February 04, 2026 16:49

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
AlternateCode	Alternate Part Code	nvarchar
AverageCost	Average Price	decimal
CFC	Indicates if the part record is chlorofluorocarbon (refrigerant)	bit
Code	Part Code	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DateIn	Date In	datetime
Deleted	Indicates if the Part has Been Deleted or Not	bit
Description	Part Description	nvarchar
ExcludeFromPurchase	Indicates if the Exclude From Purchase Checkbox is Checked or Not	bit
ExcludeFromReorderCalc	Indicates if the Record is excluded from Reorder Calculations	bit
ExcludeFromRequestor	Indicates if the Exclude From Requestor Checkbox is Checked or Not	bit
Hazardous	Indicates if the Part is Hazardous or Not	bit
Id	Part Id	int
Image	Image	nvarchar
IsSerialized	Indicates if the Part is Serialized or Not	bit
KeyNoun	Key Noun	nvarchar
Kit	Indicates if the Kit Checkbox is Checked or Not	bit
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerId	Manufacturer Id	int	vr_Vendor
ManufacturerName	Manufacturer Name	nvarchar
ManufacturerNumber	Manufacturer Number	nvarchar
MarkUp	Markup	decimal
ModelNumber	Model Number	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
OrderUnit	Order Unit	nvarchar
OrderUnitMeasureCode	Order Unit Measure Code	nvarchar
OrderUnitMeasureId	Order Unit of Measure Id	int	vr_UnitMeasure
OrderUnitQuantity	Order Unit Quantity	int
pa_creator_fk	User Id (Record Creator)	int	vr_Users
pa_modifier_fk	User Id (Record Modifier)	int	vr_users
ParentCode	Parent Part Code	nvarchar
ParentDescription	Parent Part Description	nvarchar
ParentId	Parent Part Id	int	vr_Part
PartAverageCost	Average Price	decimal
PartQuantityOnHand	Quantity On Hand	int
PartStandardCost	Standard Price	decimal
PartSubtypeCode	Part SubType Code	nvarchar
PartSubtypeDescription	Part SubType Description	nvarchar
PartSubtypeId	Part SubType Id	int	vr_PartSubType
PartTypeCode	Part Type Code	nvarchar
PartTypeDescription	Part Type Description	nvarchar
PartTypeId	Part Type Id	int	vr_PartType
PriceUsed	Determines Which Price Field will be Used (Standard Price is NULL then Average Price)	decimal
PurgeDate	Purge Date	datetime
QuantityAvailable	Quantity Available	int
QuantityOnHand	Quantity On Hand	int
QuantityWithUnitOrder	Unit Order Quantity + Unit of Measure (i.e. 1/EA)	nvarchar
ReorderPoint	Reorder Point	int
ReorderPointPercent	Reorder Point Percentage	decimal
ReorderQuantity	Reorder Quantity	int
RepairCenterId	Repair Center Id	int	vr_RepairCenter
Serialized	Indicates if the Part is Serialized or Not	bit
ShelfLife	Shelf Life	datetime
SICCode	Standard Industrial Classification Code	nvarchar
Specification	Specifications	nvarchar
StandardCost	Standard Price	decimal
SupplyItem	Indicates if the Supply Item Checkbox is Checked or Not	bit
TaxPurchases	Indicates if the Tax Purchases Checkbox is Checked or Not	bit
TaxSales	Indicates if the Tax Sales Checkbox is Checked or Not	bit
UnitMeasureCode	Unit of Measure Code	nvarchar
UnitMeasureId	Unit of Measure Id	int	vr_UnitMeasure
UOMOrderUnitQuantity	Unit of Measure + Order Quantity (i.e. EA (*1 Parts))	nvarchar
Weight	Weight	decimal
WeightUnit	Weight Unit	nvarchar

Articles in this section