vr_UtilityService

Updated November 28, 2025 13:12

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
Active	Indicates if the Record is Active or Not	bit
AverageCost	Average Cost	decimal
Code	Utility Service Code	nvarchar
Conversion	Conversion	decimal
ConversionEmission	Conversion Emission	decimal
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
Description	Utility Service Description	nvarchar
FreeUnitMeasure	Free Unit of Measure	nvarchar
Id	Utility Service Id	int
LastDate	Last Date	datetime
LastMeter	Last Meter	nvarchar
LastReading	Last Reading	decimal
LTDUsage	Life To Date Usage	decimal
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
MTDUsage	Month to Date Usage	decimal
ServiceType	Service Type	nvarchar
Unit	Unit	nvarchar
UnitDemand	Unit Demand	nvarchar
UnitMeasureCode	Unit Measure Code	nvarchar
UnitMeasureId	Unit of Measure Id	int	vr_UnitMeasure
UtilityServiceTypeCode	Service Type Code	nvarchar
UtilityServiceTypeDescription	Service Type Description	nvarchar
UtilityServiceTypeId	Service Type Id	int
Year1Usage	Year 1 Usage	decimal
Year2Usage	Year 2 Usage	decimal
Year3Usage	Year 3 Usage	decimal
Year4Usage	Year 4 Usage	decimal
YTDUsage	Year to Date Usage	decimal