vr_Project

Updated February 04, 2026 16:52

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
Active	Indicates if the Record is Active or Not	bit
ActualCost	Actual Cost	decimal
ActualTime	Actual Time	decimal
ActualTotal	Actual Total	decimal
Agent	Agent	nvarchar
ArchiveEventId	Archive Event Id	int
ArchiveParentId	Archive Parent Id	int
AuthorizationDate	Authorization Date	datetime
AuthorizationRequired	Authorization Required	bit
AuthorizationValue	Authorization Value	decimal
Authorized	Authorized	bit
AuthorizerId	User Id (Authorizer)	int	vr_Users
AuthorizerName	Authorizer Name	nvarchar
BidContNo	Bid Count Number	nvarchar
BudgetAmount	Budget Amount	decimal
BuildingCode	Building Code	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CancelDate	Cancel Date	datetime
ClosedDate	Closed Date	datetime
Comments	Comments	nvarchar
Completion	Completion Date	datetime
ComputedAuthorized	Computed Authorized	int
ContractorActual	Contractor Actual	decimal
ContractorCode	Contractor Code	nvarchar
ContractorId	Contractor Id	int
ContractorName	Contractor Name	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Project Description	nvarchar
DueDate	Due Date	datetime
Email	Email	nvarchar
EntityCode	Entity Code	nvarchar
EntityId	Entity Id	int	vr_Entity
EntityName	Entity Name	nvarchar
EstimatedCost	Estimated Cost	decimal
EstimatedHours	Estimated Hours	decimal
EstimatedLabor	Estimated Labor	decimal
EstimatedMaterial	Estimated Material	decimal
EstimatedTime	Estimated Time	decimal
EventCode	Event Code	nvarchar
EventDescription	Event Description	nvarchar
EventId	Event Id	int	vr_Event
EventTemplate	Event Template	bit
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FiscalYear	Fiscal Year	int
FiscalYearEnd	Fiscal Year End	int
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
FundTypeCode	Fund Type Code	nvarchar
FundTypeDescription	Fund Type Description	nvarchar
FundTypeId	Fund Type Id	int
HoursActual	Actual Hours	decimal
HoursBudget	Budget Hours	decimal
HoursEstimated	Estimated Hours	decimal
Id	Project Id	int
ItemCode	Item Code	nvarchar
ItemId	Item Id	int
ItemName	Item Name	nvarchar
ItemTypeId	Item Type Id	int	vr_WebTMAItemTypes
LaborActual	Actual Labor Hours	decimal
LaborBudget	Budget Labor Hours	decimal
LaborEstimated	Estimated Labor Hours	decimal
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Project Name	nvarchar
noAttach	Indicates if the project record is not attached to a facility, building or entity	int
Number	Project Number	nvarchar
OpenProject	Indicates if the Project is Open or Not	int
OtherActual	Actual Other	decimal
OtherBudget	Budget Other	decimal
OtherEstimated	Estimated Other	decimal
ParentDescription	Project Parent Description	nvarchar
ParentId	Project Parent Id	int	vr_Project
ParentName	Project Parent Name	nvarchar
ParentNumber	Project Parent Number	nvarchar
ParentTag	Project Parent Tag #	nvarchar
PartActual	Actual Part Cost	decimal
PartBudget	Budget Part Cost	decimal
PartEstimated	Estimated Part Cost	decimal
PreferredRepairCenterId	Repair Center Id	int	vr_RepairCenter
PrepStartDate	Prep Start Date	datetime
Priority	Priority	nvarchar
ProjectCode	Project Code	nvarchar
ProjectNumber	Project Number	nvarchar
ProjectSubTypeCode	Project SubType Code	nvarchar
ProjectSubTypeDescription	Project SubType Description	nvarchar
ProjectSubTypeId	Project SubType Id	int
ProjectTypeCode	Project Type Code	nvarchar
ProjectTypeDescription	Project Type Description	nvarchar
ProjectTypeId	Project Type Id	int	vr_ProjectType
RequestDate	Request Date	datetime
RequestLogId	Request Log Id	int	vr_Request
RequestLogNumber	Request Log Number	nvarchar
RequestorCode	Requestor Code	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RequestorsPhone	Requestor Phone #	nvarchar
RequestTemplate	Indicates if the Project is a Request Template	bit
Reserved2	Reserved 2	decimal
Reserved3	Reserved 3	decimal
Reserved4	Reserved 4	decimal
ScheduledDate	Scheduled Date	datetime
Site	Site	nvarchar
StatusAllowNote	Indicates if this record allows a status note	bit
StatusDescription	Status Description	nvarchar
StatusId	Status Id	int	vr_Status
StatusNote	Status Note	nvarchar
SubsystemDescription	Sub System Description	nvarchar
Supervisor	Supervisor	nvarchar
SystemDescription	System Description	nvarchar
SystemSubTypeCode	System SubType Code	nvarchar
SystemSubTypeDescription	System SubType Description	nvarchar
SystemSubTypeId	System SubType Id	int
SystemTypeCode	System Type Code	nvarchar
SystemTypeDescription	System Type Description	nvarchar
SystemTypeId	System Type Id	int	vr_SystemType
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
TravelTripDescription	Travel Trip Description	nvarchar
TravelTripId	Travel Trip Id	int	vrpt_travelTrip
TravelTripNumber	Travel Trip Number	nvarchar
TripTemplate	Indicates if the Project is a Trip Template	bit
UseSig	Use Signature	bit
Warranty	Warranty Date	datetime

Articles in this section