vrpt_ProjectRequisition

Updated January 13, 2026 15:42

Field Name	Field Description	Data Type	FK Join
id	Project Requisition Id	int
projreq_attention	Attention	nvarchar
projreq_bc_fk	Budget Code Id	int
projreq_billTo_fk	Bill To Id	int	vrpt_BillToLocation
projreq_billToType_fk	Bill To Type Id	int
projreq_charge	Indicates if the record is chargeable	bit
projreq_clnt_fk	Obsolete Column (No Longer Used)	int
projreq_closeDate	Close Date	datetime
projreq_comments	Comments	nvarchar
projreq_con_fk	Contract Id	int
projreq_createdDate	Record Creation Date	datetime
projreq_creator_fk	User Id (Record Creator)	int	vr_users
projreq_cst_fk	Account Id	int	vr_account
projreq_date	Date	datetime
projreq_dp_fk	Department Id	int	vr_Department
projreq_modifiedDate	Last Modified Date	datetime
projreq_modifier_fk	User Id (Record Modifier)	int	vr_users
projreq_number	Project Requisition Number	nvarchar
projreq_pk	Project Requisition Id	int
projreq_proj_fk	Project Id	int	vr_Project
projreq_prt_fk	Project Requisition Type Id	int
projreq_rc_fk	Repair Center Id	int	vr_RepairCenter
projreq_referenceNumber	Reference Number	nvarchar
projreq_shipTo_fk	Ship To Id	int	vrpt_ShipToLocation
projreq_shipToDeliveryNote	Ship To Delivery Note	nvarchar
projreq_shipToType_fk	Ship To Type Id	int
projreq_subtotal	SubTotal	decimal
projreq_tax_fk	Tax Id	int	vr_TaxRate
projreq_taxAmount	Tax Amount	decimal
projreq_taxAmount1	Tax Amount 1	decimal
projreq_taxAmount2	Tax Amount 2	decimal
projreq_taxCompound	Indicates if the record utilizes tax compound	bit
projreq_taxrate	Tax Rate	decimal
projreq_taxrate2	Tax Rate 2	decimal
projreq_totalAmount	Total Amount	decimal
projreq_ven_fk	Vendor Id	int	vr_Vendor
projreq_venaddr_fk	Vendor Address Id	int	vr_VendorAddress
projreq_warrantyExpires	Warranty Expires	datetime
projreq_wk_fk	Technician Id	int	vrpt_Technician

Articles in this section