vr_Asset

Updated November 17, 2025 16:19

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
AcquiredDate	Acquired Date	datetime
Active	Indicates if the Record is Active or Not	bit
ActiveComputed	Active Computed	bit
AdditionalDescription1	Addtional Description 1	nvarchar
AdditionalDescription2	Addtional Description 2	nvarchar
AltTagNumber	Alternate Tag #	nvarchar
AreaDescription	Area Description	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
Arms	Arms	bit
ArtDepth	Art Depth	nvarchar
ArtDescription	Art Description	nvarchar
ArtHeight	Art Height	nvarchar
ArtistName	Artist Name	nvarchar
ArtType	Art Type	nvarchar
ArtWidth	Art Width	nvarchar
AssetSubTypeCode	Asset SubType Code	nvarchar
AssetSubTypeDescription	Asset SubType Description	nvarchar
AssetSubTypeId	Asset SubType Id	int
AssetTypeCode	Asset Type Code	nvarchar
AssetTypeDescription	Asset Type Description	nvarchar
AssetTypeId	Asset Type Id	int	vr_assetType
AssetTypeIsDoor	Asset Type Is Door	bit
AssignedTechnicianCode	Assigned Technician Code	nvarchar
AssignedTechnicianId	Assigned Technician Id	int	vrpt_Technician
AssignedTechnicianName	Technician Name	nvarchar
AssignedTo	Assigned Technician	nvarchar
BackColor	Back Color	nvarchar
BackMaterial	Back Material	nvarchar
BackTrim	Back Trim	nvarchar
BarCoded	Bar Coded	bit
BaseColor	Base Color	nvarchar
BaseMaterial	Base Material	nvarchar
BaseTrim	Base Trim	nvarchar
BaseType	Base Type	nvarchar
BuildingCode	Building Code	nvarchar
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CalibratedThrough	Calibrated Through	datetime
CasterGlides	Caster Glides	bit
Color	Color	nvarchar
CPSetupCode	Capital Setup Code	nvarchar
CPSetupDescription	Capital Setup Description	nvarchar
CPSetupId	Capital Setup Id	int	vrpt_cpSetup
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
DeletionDate	Deletion Date	datetime
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Depth	Depth	nvarchar
Description	Description	nvarchar
Disposed	Indicates if this Asset 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
DrawerCount	Drawer Count	decimal
FacilityCode	Facility Code	nvarchar
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
Finish	Finish	nvarchar
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
FloorId	Floor Id	int	vr_floor
FullLocation	Full Location	nvarchar
GISFeatureClassId	GIS Feature Class Id	int
GISUniqueId	GIS Unique Id	uniqueidentifier
HasCyclicRenewal	Has Cyclic Renewal	bit
HasPopupMessage	Has Popup Message	int
Height	Height	nvarchar
Id	Asset 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
InventoryTechnicianName	Inventory Technician Name	nvarchar
LastCalibrationDate	Last Calibration Date	datetime
LastInventoryDate	Last Inventory Date	datetime
LastInventoryLocation	Last Inventory Location	nvarchar
Latitude	Latitude	float
LifeExpectancy	Life Expectancy	int
Longitude	Longitude	float
ManufacturerCode	Manufacturer Code	nvarchar
ManufacturerId	Manufacturer Id	int	vr_Vendor
ManufacturerName	Manufacturer Name	nvarchar
MiscComments	Missellaneous Comments	nvarchar
ModelNumber	Model Number	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
NewLocation	New Location	nvarchar
OriginalCost	Original Cost	decimal
PaddedArms	Padded Arms	bit
ParentId	Parent Asset Id	int	vr_asset
ParentTagNumber	Parent Asset Tag Number	nvarchar
PopupMessage	Popup Message	nvarchar
PreferredRepairCenterId	Repair Center Id	int	vr_RepairCenter
PreventArchival	Prevent Archival	bit
PrintNumber	Print Number	nvarchar
PurchaseDate	Purchase Date	datetime
PurgeDate	Purge Date	datetime
Quantity	Quantity	int
ReceiverId	Receiver Id	nvarchar
RegionCode	Region Code	nvarchar
RegionId	Region Id	int	vr_Region
RegionName	Region Name	nvarchar
RegisteredDate	Registered Date	datetime
SeatColor	Seat Color	nvarchar
SeatMaterial	Seat Material	nvarchar
SeatTrim	Seat Trim	nvarchar
SerialNumber	Serial Number	nvarchar
ShippingWeight	Shipping Weight	decimal
SubLocation	Sub Location	nvarchar
SurfaceMaterial	Surface Material	nvarchar
SwivelChair	Swivel Chair	bit
TagNumber	Tag Number	nvarchar
TiltChair	Tilt Chair	bit
Trim	Trim	nvarchar
UsageFlatRate	Usage Flat Rate	decimal
UsageUnit	Usage Unit	nvarchar
UsageUnitCost	Usage Unit Cost	decimal
VehicleActive	Indicates Whether the Vehicle is Active or Not	bit
VehicleId	VehicleId	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
Width	Width	nvarchar

Articles in this section