vrpt_QuoteVendor

Updated April 06, 2026 15:27

Field Name	Field Description	Data Type	FK Join
pk	Quote Id	int	vrpt_Quote
qv_attention	Quote Vendor Attention	nvarchar
qv_createdDate	Record Creation Date	datetime
qv_creator_fk	User Id (Record Creator)	int	vr_users
qv_expirationDate	Quote Vendor Expiration Date	datetime
qv_modifiedDate	Last Modified Date	datetime
qv_modifier_fk	User Id (Record Modifier)	int	vr_users
qv_pk	Quote Vendor Id	int
qv_qt_fk	Quote Id	int	vrpt_Quote
qv_referenceNumber	Quote Vendor Reference Number	nvarchar
qv_shipmethod	Quote Vendor Ship Method	nvarchar
qv_spo	Indicates if the record is a standard purchase order	bit
qv_spoNumber	Standard Purchase Order Number	nvarchar
qv_ven_fk	Vendor Id	int	vr_Vendor
qv_venaddr_fk	Vendor Address Id	int	vr_VendorAddress
ven_code	Vendor Code	nvarchar
ven_customerNumber	Customer Number	nvarchar
ven_name	Vendor Name	nvarchar
ven_pk	Vendor Id	int	vr_Vendor
venaddr_address1	Vendor Address Line 1	nvarchar
venaddr_address2	Vendor Address Line 2	nvarchar
venaddr_category	Vendor Address Category	nvarchar
venaddr_city	Vendor City	nvarchar
venaddr_contact	Vendor Contact	nvarchar
venaddr_email	Vendor Email	nvarchar
venaddr_fax	Vendor Fax #	nvarchar
venaddr_phone	Vendor Phone #	nvarchar
venaddr_phoneExtension	Vendor Phone # Extension	nvarchar
venaddr_pk	Vendor Address Id	int	vr_VendorAddress
venaddr_state	Vendor State	nvarchar
venaddr_zipcode	Vendor Zip Code	nvarchar