vrpt_UtilityMeter

Updated January 20, 2026 16:29

Field Name	Field Description	Data Type	FK Join
charge_code	Charge Account Code	nvarchar
charge_name	Charge Account Name	nvarchar
credit_code	Credit Account Code	nvarchar
credit_name	Credit Account Name	nvarchar
dist_pk	District Id	int	vr_district
dvsn_pk	Division Id	int
et_code	Utility Service Code	nvarchar
et_description	Utility Service Description	nvarchar
et_unit	Utility Service unit	nvarchar
fb_name	Building Name	nvarchar
fb_pk	Building Id	int	vr_building
fd_name	Facility Name	nvarchar
fd_pk	Facility Id	int	vr_Facility
ff_code	Floor Code	nvarchar
ff_description	Floor Description	nvarchar
ff_pk	Floor Id	int	vr_floor
fu_roomNumber	Area Room Number	nvarchar
fu_unitID	Area Location Id	nvarchar
Id	Utility Meter Id	int
parent_code	Utility Meter Parent Code	nvarchar
rg_pk	Region Id	int	vr_region
rs_code	Rate Schedule Code	nvarchar
rs_name	Rate Schedule Name	nvarchar
tn_code	Transformer Code	nvarchar
tn_description	Transformer Name	nvarchar
umeter_active	Indicates if the Record is Active or Not	bit
umeter_adjForServiceCharge	Indicates if the utility meter record has an adjustment for a service charge	bit
umeter_amountApr	April Amount	decimal
umeter_amountAug	August Amount	decimal
umeter_amountDec	December Amount	decimal
umeter_amountFeb	February Amount	decimal
umeter_amountJan	January Amount	decimal
umeter_amountJul	July Amount	decimal
umeter_amountJun	June Amount	decimal
umeter_amountMar	March Amount	decimal
umeter_amountMay	May Amount	decimal
umeter_amountNov	November Amount	decimal
umeter_amountOct	October Amount	decimal
umeter_amountSep	September Amount	decimal
umeter_billingMethod	Billing Method	int
umeter_bldgRollup	Indicates if the record rolls up and is included in the building costs	bit
umeter_Charge	Utility Meter Charge	int
umeter_cn_fk	Obsolete column	int
umeter_code	Utility Meter Code	nvarchar
umeter_comment	Comment	nvarchar
umeter_conversionemission	Conversion Emission	decimal
umeter_convertCommonUnits	Indicates if the utility meter record converts common units	bit
umeter_createdDate	Record Creation Date	datetime
umeter_creator_fk	User Id (Record Creator)	int	vr_users
umeter_cst_fk	Account Id	int	vr_account
umeter_curr_fk	Currency Id	int	vrpt_Currency
umeter_currentReading	Current Reading	decimal
umeter_demandTracked	Indicates if the utility meter record's demand is tracked	bit
umeter_description	Utility Meter Description	nvarchar
umeter_digits	Digits	int
umeter_emsNode	Indicates if the utility meter record is on an energy management system node	bit
umeter_entireBldg	Indicates if the utility meter record is for the entire building	bit
umeter_et_fk	Utility Service Id	int	vr_UtilityService
umeter_exch_date	Currency Exchange Date	datetime
umeter_exch_fk	Currency Exchange Id	int
umeter_fb_fk	Building Id	int	vr_building
umeter_fd_fk	Facility Id	int	vr_Facility
umeter_ff_fk	Floor Record Id	int	vr_floor
umeter_fu_fk	Area Record Id	int	vr_area
umeter_highAllowed	High Allowed	int
umeter_lastReading	Last Reading	datetime
umeter_location	Location	nvarchar
umeter_loopId	Loop Id	nvarchar
umeter_loopNumber	Loop Number	int
umeter_modelNumber	Model Number	int
umeter_modifiedDate	Last Modified Date	datetime
umeter_modifier_fk	User Id (Record Modifier)	int	vr_users
umeter_multiLayerLocation	Multi Layer Location	nvarchar
umeter_ns_fk	Entity Id	int	vr_Entity
umeter_parent_fk	Parent Id	int
umeter_PK	Utility Meter Id	int
umeter_prodDependent	Indicates if the utility meter record is production dependent	bit
umeter_readEntered	Indicates if the utility meter record reading is entered	bit
umeter_recCst_fk	Account Id	int	vr_account
umeter_rechargeRate	Recharge Rate	decimal
umeter_rescheduleFactor	Reschedule Factor	int
umeter_rollOverCount	Roll Over Count	int
umeter_rs_fk	Rate Schedule Id	int	vr_rateSchedule
umeter_serialNumber	Serial Number	int
umeter_subMeter	Indicates if the utility meter record is a sub meter	bit
umeter_summerAdjCode	Summer Adjustment Code	int
umeter_summerAdjName	Summer Adjustment Name	nvarchar
umeter_tax_fk	Tax Rate Id	int	vr_TaxRate
umeter_Taxable	Indicates if this utility meter is taxable	bit
umeter_tn_fk	Transformer Id	int	vr_UtilityTransformer
umeter_type	Utility Meter Type	int
umeter_ven_fk	Vendor Id	int	vr_Vendor
umeter_virtualMeter_fk	Virtual Meter Id	int
umeter_virtualMeterPercentage	Virtual Meter Percentage	decimal
umeter_virtualMeterType	Virtual Meter Type	int
umeter_virtualSquareFootage	Virtual Meter Square Footage	int
umeter_virtualSquareFootageCost	Virtual Meter Square Footage Cost	decimal
umeter_winterAdjCode	Winter Adjustment Code	int
umeter_winterAdjName	Winter Adjustment Name	nvarchar
ven_code	Vendor Code	nvarchar
ven_name	Vendor Name	nvarchar
virtualMeter	Virtual Meter	nvarchar
wt_description	Weather Station Description	nvarchar

Articles in this section