vrpt_MostExpensiveEquipment

Updated January 05, 2026 17:08

Field Name	Field Description	Data Type	FK Join
fm_acquisitionCost	Equipment Acquisition Cost	decimal
fm_description	Equipment Description	nvarchar
fm_lifeExpectancy	Equipment Life Expectancy	int
fm_pk	Equipment Id	int	vr_equipment
fm_purchaseDate	Equipment Purchase Date	datetime
fm_tagNumber	Equipment Tag Number	nvarchar
id	Equipment Id	int	vr_equipment
itemType_name	Item Type Name	nvarchar
itemType_pk	Item Type Id	int
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