vrpt_PartExtraInfo

Updated January 05, 2026 17:47

Field Name	Field Description	Data Type	FK Join
Id	Part Id	int	vr_Part
inventoryValue	Inventory Value	decimal
lastAdjustment	Last Adjustment	decimal
lastPO_ven_code	Last Purchase Order Vendor Code	nvarchar
lastPO_ven_name	Last Purchase Order Vendor Name	nvarchar
lastPODate	Last Purchase Order Date	datetime
lastPONumber	Last Purchase Order Number	nvarchar
lastPOVenFK	Last Purchase Order Vendor Id	int	vr_Vendor
lastUnitPrice	Last Unit Price	decimal
maximumLevel	Maximum Level	int
minimumLevel	Minimum Level	int
obsolete_ven_isBroker	Obsolete Column (No Longer Used)	bit
obsolete_ven_isTenant	Obsolete Column (No Longer Used)	bit
pa_fk	Part Id	int	vr_Part
quantityAvailable	Quantity Available	int
quantityOnHand	Quantity On Hand	int
quantityOnOrder	Quantity On Order	decimal
receivedMTD	Received Month to Date	int
receivedYTD	Recieved Year to Date	int
usedMTD	Used Month to Date	int
usedYTD	Used Year to Date	int
ven_active	Indicates Whether the Vendor is Active or Not	bit
ven_allowChangePersonalInfo	Indicates Whether the Vendor record allows change of personal info	bit
ven_alternateID	Vendor Alternate Id	nvarchar
ven_code	Vendor Code	nvarchar
ven_comment	Vendor Comments	nvarchar
ven_companySize	Vendor Company Size	int
ven_contact	Vendor Contact	nvarchar
ven_createdDate	Record Creation Date	datetime
ven_creator_fk	Vendor User Id (Record Creator)	int	vr_users
ven_creditLimit	Vendor Credit Limit	decimal
ven_cst_fk	Vendor Account Id	int	vr_account
ven_curr_fk	Vendor Currency Id	int	vrpt_Currency
ven_customerNumber	Vendor Customer Number	nvarchar
ven_discountDay	Vendor Discount Day	int
ven_discountPercentage	Vendor Discount Percentage	decimal
ven_ECRICode	Vendor ECRI Code	int
ven_email	Vendor Email	nvarchar
ven_exch_date	Vendor Currency Exchange Date	datetime
ven_exch_fk	Vendor Currency Exchange Id	int
ven_hourlyRate	Vendor Hourly Rate	decimal
ven_insuranceAmount	Vendor Insurance Amount	decimal
ven_insuranceExpiration	Vendor Insurance Expiration	datetime
ven_isConsultant	Indicates if the Vendor Is a Consultant Record	bit
ven_isContractor	Indicates if the Vendor Is a Contractor Record	bit
ven_isManufacturer	Indicates if the Vendor Is a Manufacturer Record	bit
ven_isVendor	Indicates if the Vendor Is a Vendor Record	bit
ven_lastPO_fk	Vendor Last Purchase Order Id	int	vr_PurchaseOrder
ven_modifiedDate	Last Modified Date	datetime
ven_modifier_fk	Vendor User Id (Record Modifier)	int	vr_users
ven_name	Vendor Name	nvarchar
ven_organizationUnit	Vendor Organization Unit	nvarchar
ven_OTPTaxable	Indicates if this Vendor's one time purchases are taxable	bit
ven_pcardblock	Indicates if this Vendor's blocked from purchase card transactions	bit
ven_pk	Vendor Id	int	vr_Vendor
ven_rating	Vendor Rating	nvarchar
ven_siccode	Vendor SIC Code	nvarchar
ven_taxCode	Vendor Tax Code	nvarchar
ven_taxID	Vendor Tax Id	nvarchar
ven_term	Vendor Term	nvarchar
ven_url	Vendor Website URL	nvarchar
ven_vc_fk	Vendor Type Id	int	vr_VendorType
ven_vcs_fk	Vendor SubType Id	int

Articles in this section