vrpt_MeterLastReading

Updated December 24, 2025 13:21

Field Name	Field Description	Data Type	FK Join
Id	Meter Reading Id	int
LastMeterReading_pk	Last Meter Reading Id	int
meter_createdDate	Record Creation Date	datetime
meter_creator_fk	User Id (Record Creator)	int	vr_users
meter_description	Meter Description	nvarchar
meter_digits	Meter Digits	int
meter_item_fk	Item Id	int
meter_itemType_fk	Item Type Id	int
meter_modifiedDate	Last Modified Date	datetime
meter_modifier_fk	User Id (Record Modifier)	int
meter_name	Meter Name	nvarchar
meter_nonOriginalRollovers	Meter Non Original Rollovers	int
meter_odometer	meter Odometer	bit
meter_originalRollover	Meter Original Rollover	int
meter_originalValue	Meter Original Value	decimal
meter_pk	Meter Id	int	vr_meter
meterReading_createdDate	Record Creation Date	datetime
meterReading_creator_fk	User Id (Record Creator)	int	vr_users
meterReading_date	Meter Reading Date	datetime
meterReading_meter_fk	Meter Id	int	vr_meter
meterReading_modified_fk	User Id (Record Modifier)	int	vr_users
meterReading_modifiedDate	Last Modified Date	datetime
meterReading_pk	Meter Reading Id	int
meterReading_rollover	Meter Reading Rollover	bit
meterReading_user_fk	User Id	int	vr_users
meterReading_value	Meter Reading Value	decimal
meterReading_wk_fk	Meter Reading Technician Id	int	vrpt_Technician
NumRollOvers	Calculated field Meter Original Rollover + Meter Non Original Rollovers	int
wk_displayName	Display Name	nvarchar
wk_id	Technician Record Id	nvarchar
wk_name	Technician Name	nvarchar
wk_pk	Technicain Id	int	vrpt_Technician