vrpt_QuoteItem

Updated January 19, 2026 16:42

Field Name	Field Description	Data Type	FK Join
cst_code	Account Code	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Quote Item Id	int
ItemUnitOfMeasure	Item Unit Of Measure	nvarchar
mfg_code	Manufacturer Code	nvarchar
mfg_name	Manufacturer Name	nvarchar
pa_manufacturerNumber	Manufacturer Number	nvarchar
pa_orderUnitQuantity	Order Unit Quantity	int
PE_VenPartCode	Vendor Part Code	nvarchar
ql_comment	Comment	nvarchar
ql_detailcode	Detail Code	nvarchar
ql_detaildescription	Detail Description	nvarchar
ql_extendedPrice	Extended Price	decimal
ql_otpCode	One Time Purchase Code	nvarchar
ql_otpdescription	One Time Purchase Description	nvarchar
ql_pa_fk	Part Id	int	vr_Part
ql_pk	Quote Item Id	int
ql_qt_fk	Quote Id	int	vrpt_Quote
ql_quantity	Quantity	decimal
ql_qv_fk	Quote Vendor Id	int	vrpt_QuoteVendor
ql_taxable	Indicates if this Quote's Item is taxable	bit
ql_um_fk	Unit of Measure Id	int	vr_UnitMeasure
ql_unitcost	Unit Cost	decimal
StatusDescription	Status Description	nvarchar
StatusNote	Status Note	nvarchar
subtotalAmount	Subtotal Amount	decimal
tax1Amount	Tax 1 Amount	decimal
tax2Amount	Tax 2 Amount	decimal
ven_code	Vendor Code	nvarchar
ven_name	Vendor Name	nvarchar
ven_pk	Vendor Id	int	vr_Vendor