vrpt_MostExpensiveAsset

Updated January 05, 2026 17:02

Field Name	Field Description	Data Type	FK Join
id	Asset Id	int	vr_asset
itemType_name	Item Type Name	nvarchar
itemType_pk	Item Type Id	int
p_description	Asset Description	nvarchar
p_lifeExpectancy	Asset Life Expectancy	int
p_originalCost	Asset Original Cost	decimal
p_pk	Asset Id	int	vr_asset
p_purchaseDate	Asset Purchase Date	datetime
p_tagNumber	Asset 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