vrpt_ProjectFile

Updated February 04, 2026 15:40

Field Name	Field Description	Data Type	FK Join
Id	Project Id	int
proj_accountNumber	Account Number	nvarchar
proj_active	Indicates if the Project is Active or Not	bit
proj_actualCost	Actual Cost	decimal
proj_actualTime	Actual Time	decimal
proj_agent	Agent	nvarchar
proj_authorizationDate	Authorization Date	datetime
proj_authorizationRequired	Indicates if the project record requires authorization	bit
proj_authorizationValue	Authorization Value	decimal
proj_authorized	Indicates if the project record is authorized	bit
proj_BidContNo	Bid Contract Number	nvarchar
proj_budgetAmount	Budget Amount	decimal
proj_closedDate	Closed Date	datetime
proj_comments	Comments	nvarchar
proj_completion	Completion	datetime
proj_cont_fk	Contractor Id	int	vr_Vendor
proj_contractorActual	Contractor Actual	decimal
proj_createdDate	Record Creation Date	datetime
proj_creator_fk	User Id (Record Creator)	int	vr_users
proj_cst_fk	Account Id	int	vr_account
proj_description	Description	nvarchar
proj_dp_fk	Department Id	int	vr_Department
proj_dueDate	Due Date	datetime
proj_email	Email	nvarchar
proj_estimatedCost	Estimated Cost	decimal
proj_estimatedHours	Estimated Hours	decimal
proj_estimatedLabor	Estimated Labor	decimal
proj_estimatedMaterial	Estimated Material	decimal
proj_estimatedTime	Estimated Time	decimal
proj_ev_fk	Event Id	int	vr_Event
proj_eventTemplate	Indicates if the project record is from a event template	bit
proj_fb_fk	Building Id	int	vr_building
proj_fd_fk	Facility Id	int	vr_Facility
proj_fiscalYear	Fiscal Year	int
proj_fiscalYearEnd	Fiscal Year End	int
proj_fn_fk	Fund Type Id	int
proj_hoursActual	Hours Actual	decimal
proj_hoursBudget	Hours Budget	decimal
proj_hoursEstimated	Hours Estimated	decimal
proj_laborActual	Labor Actual	decimal
proj_laborBudget	Labor Budget	decimal
proj_laborEstimated	Labor Estimated	decimal
proj_manager	Manager	nvarchar
proj_modifiedDate	Last Modified Date	datetime
proj_modifier_fk	User Id (Record Modifier)	int	vr_users
proj_name	Name	nvarchar
proj_ns_fk	Entity Id	int	vr_Entity
proj_number	Project Number	nvarchar
proj_otherActual	Other Actual	decimal
proj_otherBudget	Other Budget	decimal
proj_otherEstimated	Other Estimated	decimal
proj_overdue	Indicates if the project record is overdue	bit
proj_parent_fk	Parent Project Id	int
proj_parentTag	Parent Tag	nvarchar
proj_partActual	Part Actual	decimal
proj_partBudget	Part Budget	decimal
proj_partEstimated	Part Estimated	decimal
proj_pk	Project Record Id	int	vr_Project
proj_prepStartDate	Prep Start Date	datetime
proj_priority	Priority	nvarchar
proj_projectID	Project Id	nvarchar
proj_pt_fk	Project Type Id	int	vr_ProjectType
proj_pts_fk	Project Sub Type Id	int
proj_requestDate	Request Date	datetime
proj_requestor	Requestor	nvarchar
proj_requestorPhone	Requestor Phone	nvarchar
proj_requesttemplate	Indicates if the project record is from a request template	bit
proj_reserved2	Reserved 2	decimal
proj_reserved3	Reserved 3	decimal
proj_reserved4	Reserved 4	decimal
proj_rq_fk	Requestor Id	int	vr_Requestor
proj_scheduledDate	Scheduled Date	datetime
proj_site	Site	nvarchar
proj_ss_fk	Status Id	int	vr_Status
proj_statusDescription	Status Description	nvarchar
proj_subsystemDescription	Sub System Description	nvarchar
proj_supervisor	Surpervisor	nvarchar
proj_systemDescription	System Description	nvarchar
proj_syt_fk	System Type Id	int	vr_SystemType
proj_syts_fk	System Sub Type Id	int
proj_traveltrp_fk	Travel Trip Id	int	vrpt_travelTrip
proj_tripTemplate	Indicates if the project record is from a trip template	bit
proj_type	Type	nvarchar
proj_user_fk	User Id	int	vr_users
proj_useSig	Indicates if the project record uses signatures	bit
proj_warranty	Warranty	datetime
proj_wk_fk	Technician Id	int	vrpt_Technician
SS_DESCRIPTION	Status Description	nvarchar

Articles in this section