vr_Tool

Updated November 28, 2025 12:40

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
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	Assigned Technician Id	int	vrpt_Technician
AssignedTechnicianName	Technician Name	nvarchar
BarCoded	Bar Coded	bit
BinLocation	Bin Location	nvarchar
BuildingActive	Indicates if the Building is Active or Not	bit
BuildingCode	Building Code	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CalibratedThrough	Calibrated Through	datetime
CheckInDate	Check In Date	datetime
CheckOutDate	Check Out Date	datetime
Code	Tool 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
CurrentJob	Current Job	nvarchar
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Tool Description	nvarchar
Disposed	Indicates if this Tool 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
DueDate	Due Date	datetime
FacilityActive	Indicates if the Facility is Active or Not	bit
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	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
FullLocation	Full Location	nvarchar
GISUniqueId	GIS Unique Id	nvarchar
HasPopupMessage	Indicates if this Tool has a popup message	int
Id	Tool Id	int
Image	Image	nvarchar
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
InventoryTechnicianLastFirst	Inventory Technician Last First	nvarchar
InventoryTechnicianName	Inventory Technician Name	nvarchar
LastCalibrationDate	Last Calibration Date	datetime
LastInventoryDate	Last Inventory Date	datetime
LastInventoryLocation	Last Inventory Location	nvarchar
Latitude	Latitude	float
Longitude	Longitude	float
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerId	Manufacturer Id	int	vr_Vendor
ManufacturerName	Manufacturer Name	nvarchar
ModelNumber	Model Number	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Name	Tool Name	nvarchar
NextCalibration	Next Calibration	datetime
PopupMessage	Popup Message	nvarchar
PreferredRepairCenterId	Repair Center Id	int	vr_RepairCenter
PreventArchival	Prevent Archival	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
RentRate	Rent Rate	float
RentUnit	Rent Unit	nvarchar
SerialNumber	Serial Number	nvarchar
ShopCode	Shop Code	nvarchar
ShopId	Shop Id	int	vr_Shop
ShopName	Shop Name	nvarchar
SpecialFunction	Special Function	nvarchar
SubLocation	Sub Location	nvarchar
TagNumber	Tag Number	nvarchar
TimeDueBack	Time Due Back	datetime
TimeIn	Time In	datetime
TimeOut	Time Out	datetime
ToolGroup	Tool Group	nvarchar
ToolSubTypeCode	Tool Sub Type Code	nvarchar
ToolSubTypeDescription	Tool Sub Type Description	nvarchar
ToolSubTypeId	Tool Sub Type Id	int
ToolTypeCode	Tool Type Code	nvarchar
ToolTypeDescription	Tool Type Description	nvarchar
ToolTypeId	Tool Type Id	int	vr_ToolType
UsageFlatRate	Usage Flat Rate	decimal
UsageUnit	Usage Unit	nvarchar
UsageUnitCost	Usage Unit Cost	decimal
VehicleActive	Indicates Whether the Vehicle is Active or Not	bit
VehicleDescription	Vehicle Description	nvarchar
VehicleId	Vehicle Id	int	vr_Vehicle
VehicleTagNumber	Vehicle Tag Number	nvarchar
VendorCode	Vendor Code	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar
WarrantyDate	Warranty Date	datetime

Articles in this section