vrpt_MostExpensiveITEquipment

Updated January 05, 2026 17:12

Field Name	Field Description	Data Type	FK Join
depr_lifeInMonths	Depreciation Life in Months	int
depr_originalCost	Depreciation Original Cost	decimal
id	IT Equipment Id	int	vr_ITEquipment
itemType_name	Item Type Name	nvarchar
itemType_pk	Item Type Id	int
itfm_acquisitionCost	Acquistion Cost	decimal
itfm_description	IT Equipment Description	nvarchar
itfm_lifeExpectancy	Life Expectancy	int
itfm_pk	IT Equipment Id	int	vr_ITEquipment
itfm_purchaseDate	Purchase Date	datetime
itfm_tagNumber	IT Equipment Tag Number	nvarchar
totalcontractor	Total Contractor Cost	decimal
totalcost	Total Cost	decimal
totalhours	Total Hours	decimal
totallabor	Total Labor Cost	decimal
totalother	Total Other Cost	decimal
totalparts	Total Parts (Materials) Cost	decimal
wocount	Work Order Count	int