vr_Entity

Updated November 21, 2025 17:26

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
ACIActualPercent	ACI Actual Percent	decimal
ACIReplaceCost	ACI Replace Cost	decimal
ACITargetPercent	ACI Target Percent	decimal
Active	Indicates if the Record is Active or Not	bit
ActiveComputed	Active Computed	bit
AdditionalDescription	Addtional Description	nvarchar
AreaPopupMessage	Area Popup Message	nvarchar
AssignedTechnicianCode	Assigned Technician Code	nvarchar
AssignedTechnicianId	Assigned Technician Id	int	vrpt_Technician
AssignedTechnicianName	Technician Name	nvarchar
BuildingPopupMessage	Building Popup Message	nvarchar
Code	Entity Code	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	Entity Description	nvarchar
Disposed	Indicates if this Entity has been Disposed or Not	bit
DistrictCode	District Code	nvarchar
DistrictId	District Id	int	vr_district
DistrictName	District Name	nvarchar
DivisionCode	Division Code	nvarchar
DivisionId	Division Id	int
DivisionName	Division Name	nvarchar
EntitySubTypeCode	Entity Sub Type Code	nvarchar
EntitySubTypeDescription	Entity Sub Type Description	nvarchar
EntitySubTypeId	Entity Sub Type Id	int
EntityTypeCode	Entity Type Code	nvarchar
EntityTypeDescription	Entity Type Description	nvarchar
EntityTypeId	Entity Type Id	int	vr_EntityType
FacilityActive	Indicates if the Facility is Active or Not	bit
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FloorPopupMessage	Floor Popup Message	nvarchar
GISFeatureClassId	GIS Feature Class Id	int
GISUniqueId	GIS Unique Id	nvarchar
HasCyclicRenewal	Indicates if the Entity is tied to a Cyclic Renewal or Not	bit
HasPopupMessage	Indicates if the Entity has a Popup Message or Not	int
Id	Entity Id	int
Image	Image	nvarchar
InstallDate	Install Date	datetime
Latitude	Latitude	float
Location	Location	nvarchar
LockoutCode	Lockout Code	nvarchar
LockoutId	Lockout Id	int
LockoutName	Lockout Name	nvarchar
Longitude	Longitude	float
ModelNumber	Model Number	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Entity Name	nvarchar
Notes	Notes	nvarchar
Occupancy	Occupancy	int
ParentCode	Entity Parent Code	nvarchar
ParentId	Entity Parent Id	int	vr_Entity
ParentName	Entity Parent Name	nvarchar
PopupMessage	Popup Message	nvarchar
PreferredRepairCenter	Preferred Repair Center Id	int	vr_RepairCenter
PreventArchival	Prevent Archival	bit
PurchaseDate	Purchase Date	datetime
PurchasePrice	Purchase Price	decimal
RegionCode	Region Code	nvarchar
RegionId	Region Id	int	vr_region
RegionName	Region Name	nvarchar
RegisteredDate	Registered Date	datetime
SerialNumber	Serial Number	nvarchar
SpacePermit	Space Permit	smallint
SubLocation	Sub Location	nvarchar
TagNumber	Tag Number	nvarchar
UsageFlatRate	Usage Flat Rate	decimal
UsageUnit	Usage Unit	nvarchar
UsageUnitCost	Usage Unit Cost	decimal
WarrantyDate	Warranty Date	datetime

Articles in this section