vr_Vehicle

Updated February 05, 2026 15:52

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
ACIActualPercent	Asset Condition Index Actual Percent	decimal
ACIReplaceCost	Asset Condition Index Replace Cost	decimal
ACITargetPercent	Asset Condition Index Target Percent	decimal
AcquisitionDate	Acquistion Date	datetime
Active	Indicates if the Record is Active or Not	bit
ActiveComputed	Active Computed	bit
AreaActive	Indicates if the Area is Active or Not	bit
AreaDescription	Area Description	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
AssignedTechnicianCode	Assigned Technician Code	nvarchar
AssignedTechnicianId	Technician Id	int	vrpt_Technician
AssignedTechnicianName	Technician Name	nvarchar
BarCoded	Bar Coded	bit
BeginningMileage	Beginning Mileage	decimal
BodyType	Vehicle Body Type	nvarchar
BuildingActive	Indicates if the Building is Active or Not	bit
BuildingCode	Building Code	nvarchar
BuildingDescription	Building Description	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CalibratedThrough	Calibrated Through	datetime
Comment	Comments	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
DeliveryDate	Delivery Date	datetime
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Vehicle Description	nvarchar
Disposed	Indicates if this Vehicle 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
EngineCubicInches	Engine Cubic Inches	decimal
EngineLitres	Engine Litres	decimal
EngineType	Engine Type	nvarchar
FAAPaperworkRequired	FAA Paperwork Required	bit
FacilityActive	Indicates if the Facility is Active or Not	bit
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FleetNumber	Fleet Number	nvarchar
FloorActive	Indicates if the Floor is Active or Not	bit
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
FloorId	Floor Id	int	vr_floor
FuelTypeDescription	Fuel Type Description	nvarchar
FuelTypeId	Fuel Type Id	int	vr_FuelType
FullLocation	Full Location	nvarchar
FundType	Fund Type	nvarchar
GISUniqueId	GIS Unique Id	uniqueidentifier
HasPopupMessage	Indicates if this Vehicle has a popup message	int
HourMeter	Hour Meter	decimal
Id	Vehicle Id	int
Image	Image	nvarchar
InstitueId	Institue Id	nvarchar
Insured	Insured	bit
InventoryConditionCode	Inventory Condition Code	nvarchar
InventoryConditionDescription	Inventory Condition Description	nvarchar
InventoryConditionId	Inventory Condition Id	int
InventoryTechnicianCode	Inventory Technician Code	nvarchar
InventoryTechnicianId	Inventory Technician Id	int	vrpt_Technician
InventoryTechnicianName	Inventory Technician Name	nvarchar
LastCalibrationDate	Last Calibration Date	datetime
LastEmissionTestDate	Last Emission Test Date	datetime
LastInventoryDate	Last Inventory Date	datetime
LastInventoryLocation	Last Inventory Location	nvarchar
LastSafety	Last Safety	datetime
LastTuneUp	Last Tune Up	datetime
Latitude	Latitude	float
LifeTimeRepair	Life Time Repair	decimal
Location	Location	nvarchar
Longitude	Longitude	float
Make	Make	nvarchar
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerId	Manufacturer Id	int	vr_Vendor
ManufacturerName	Manufacturer Name	nvarchar
ModelNumber	Model Number	nvarchar
ModelYear	Model Year	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
NextEmissionTestDate	Next Emission Test Date	datetime
NextSafety	Next Safety Date	datetime
NumberCylinders	Number of Cylinders	nvarchar
NumberPassengers	Number of Passengers	float
Odometer	Odometer	decimal
OdometerDigits	Odometer Digits	int
OutOfService	Indicates if this Vehicle is out of service	bit
Ownership	Ownership	nvarchar
ParentId	Parent Id	int
PopupMessage	Popup Message	nvarchar
PreferredRepairCenterId	Repair Center Id	int	vr_RepairCenter
PreventArchival	Indicates if this Vehicle is prevented from being archived	bit
PurchaseCost	Purchase Cost	decimal
PurchaseDate	Purchase Date	datetime
RegionCode	Region Code	nvarchar
RegionId	Region Id	int	vr_region
RegionName	Region Name	nvarchar
RegisteredDate	Registered Date	datetime
ReplacementCost	Replacement Cost	decimal
ScheduledReplacement	Scheduled Replacement	datetime
SerialNumber	Serial Number	nvarchar
StateTag	State Tag	nvarchar
SubLocation	Sub Location	nvarchar
TagNumber	Tag Number	nvarchar
TireSize	Tire Size	nvarchar
Transmission	Transmission	nvarchar
TuneupMileage	Tuneup Mileage	int
Usage	Usage	nvarchar
UsageFlatRate	Usage Rate	decimal
UsageUnit	Usage Unit	nvarchar
UsageUnitCost	Usage Cost	decimal
Use	Use	nvarchar
VehicleFunctionId	Vehilce Function Id	int
VehicleFunctionName	Vehicle Function	nvarchar
VehicleSubTypeCode	Vehicle SubType Code	nvarchar
VehicleSubTypeDescription	Vehicle SubType Description	nvarchar
VehicleSubTypeId	Vehicle SubType Id	int
VehicleTypeCode	Vehicle Type Code	nvarchar
VehicleTypeDescription	Vehicle Type Description	nvarchar
VehicleTypeId	Vehicle Type Id	int	vr_VehicleType
VendorCode	Vendor Code	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar
VIN	VIN Number	nvarchar
WarrantyDate	Warranty Date	datetime
WarrantyMileage	Warranty Mileage	int

Articles in this section