vrpt_MostExpensiveTool

Updated January 05, 2026 17:13

Field Name	Field Description	Data Type	FK Join
cr_code	Tool Code	nvarchar
cr_pk	Tool Id	int	vr_Tool
cr_purchaseCost	Tool Purchase Cost	decimal
cr_purchaseDate	Tool Purhcase Date	datetime
cr_toolName	Tool Name	nvarchar
depr_lifeInMonths	Depreciation Life in Months	int
id	Tool Id	int	vr_Tool
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