vrpt_QuoteDistrib

Updated January 19, 2026 16:39

Field Name	Field Description	Data Type	FK Join
cst_code	Account Code	nvarchar
cst_name	Account Name	nvarchar
fo_code	Task Code	nvarchar
fo_description	Task Description	nvarchar
Id	Quote Distribution Id	int
isOTP	Indicates if this record is an one time purchase	bit
itemType_name	Item Type Name	nvarchar
ItemTypeId	Item Type Id	int
orderedinvidualqty	Ordered Individual Quantity	int
qd_actualQuantity	Actual Quantity	decimal
QD_Balance	Balance	decimal
QD_COMMENT	Comment	nvarchar
QD_CREATEDDATE	Record Creation Date	datetime
QD_CREATOR_FK	User Id (Record Creator)	int	vr_users
QD_CST_FK	Account Id	int	vr_account
QD_EMAIL	Email	nvarchar
QD_ModifiedDate	Last Modified Date	datetime
QD_MODIFIER_FK	User Id (Record Modifier)	int	vr_users
QD_PK	Quote Distribution Id	int
QD_QL_FK	Quote Item Id	int	vrpt_QuoteItem
qd_qt_fk	Quote Id	int	vrpt_Quote
QD_Quantity	Quantity	decimal
QD_WOTask_FK	Work Order Task Id	int	vr_WorkOrderTask
ql_detailcode	Quote Item Detail Code	nvarchar
ql_detaildescription	Quote Item Detail Description	nvarchar
ql_fulldetail	Quote Item Full Detail	nvarchar
ql_otpCode	One Time Purchase Code	nvarchar
ql_pa_fk	Part Id	int	vr_Part
ql_qt_fk	Quote Id	int	vrpt_Quote
ql_qv_fk	Quote Vendor Id	int	vrpt_QuoteVendor
quantitywithunitorder	Quantity With Unit Order	nvarchar
tagNumber	Tag Number	nvarchar
wo_fulldescription	Full Description	nvarchar
wo_number	Work Order Number	nvarchar
wo_pk	Work Order Id	int	vr_WorkOrder