vrpt_MostExpensiveItems

Updated January 05, 2026 17:10

Field Name	Field Description	Data Type	FK Join
AcquisitionDate	Acquistion Date	datetime
ContractorCost	Contractor Cost	decimal
hours	Hours	decimal
Id	Work Order Id	int	vr_WorkOrder
ItemId	Item Id	int
ItemTypeId	Item Type Id	int
ItemTypeName	Item Type Name	varchar
LaborCost	Labor Cost	decimal
LifeExpectancy	Life Expectancy	int
OtherCost	Total Other Cost	decimal
PartCost	Part Cost	decimal
PurchasePrice	Purchase Price	decimal
TagDescription	Tag Description	nvarchar
TagNumber	Tag Number	nvarchar
TotalCost	Total Cost	decimal
WOCount	Work Order Count	int