vrpt_UtilityRouteItem

Updated January 26, 2026 17:53

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AreaDescription	Area Description	nvarchar
AreaId	Area Id	int	vr_area
AreaLocationCode	Area Location Code (Location Id)	nvarchar
AreaRoomNumber	Area Room Number	nvarchar
BudgetCodeCode	Budget Code Code	nvarchar
BudgetCodeId	Budget Code Id	int
BuildingId	Building Id	int	vr_building
BuildingName	Building Name	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CreditAccountCode	Credit Account Code	nvarchar
CreditAccountId	Credit Account Id	int	vr_account
CurrencyCode	Currency Code	nvarchar
CurrencyId	Currency Id	int	vrpt_Currency
CurrentReading	Current Reading	decimal
EntityCode	Entity Code	nvarchar
EntityId	Entity Id	int	vr_Entity
ExchangeDescription	Exchange Description	nvarchar
ExchangeId	Exchange Id	int
FacilityId	Facility Id	int	vr_facility
FacilityName	Facility Name	nvarchar
FloorCode	Floor Code	nvarchar
FloorDescription	Floor Description	nvarchar
FloorId	Floor Id	int	vr_floor
Id	Utility Route Item Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
ParentCode	Utility Meter Parent Code	nvarchar
ParentId	Utility Meter Parent Id	int	vrpt_UtilityMeter
Sequence	Sequence	int
TaxRateId	Tax Rate Id	int	vr_TaxRate
TaxRateName	Tax Rate Name	nvarchar
TransformerCode	Transformer Code	nvarchar
TransformerId	Transformer Id	int	vr_UtilityTransformer
UtilityMeterActive	Indicates if the Utility Meter is Active or Not	bit
UtilityMeterAdjustForServiceCharge	Indicates if the Utility Meter record adjusts for service charge	bit
UtilityMeterAmountApr	Utility Meter April Amount	decimal
UtilityMeterAmountAug	Utility Meter August Amount	decimal
UtilityMeterAmountDec	Utility Meter December Amount	decimal
UtilityMeterAmountFeb	Utility Meter February Amount	decimal
UtilityMeterAmountJan	Utility Meter January Amount	decimal
UtilityMeterAmountJul	Utility Meter July Amount	decimal
UtilityMeterAmountJun	Utility Meter June Amount	decimal
UtilityMeterAmountMar	Utility Meter March Amount	decimal
UtilityMeterAmountMay	Utility Meter May Amount	decimal
UtilityMeterAmountNov	Utility Meter November Amount	decimal
UtilityMeterAmountOct	Utility Meter October Amount	decimal
UtilityMeterAmountSep	Utility Meter September Amount	decimal
UtilityMeterBillingMethod	Utility Meter Billing Method	int
UtilityMeterBldgRollup	Indicates if the Utility Meter record costs rollup to building record	bit
UtilityMeterCharge	Utility Meter Charge	int
UtilityMeterCode	Utility Meter Code	nvarchar
UtilityMeterComment	Utility Meter Comment	nvarchar
UtilityMeterConversionEmission	Utility Meter Conversion Emission	decimal
UtilityMeterConvertCommonUnits	Utility Meter Convert Common Units	bit
UtilityMeterCreatedDate	Record Creation Date	datetime
UtilityMeterCreatorId	User Id (Record Creator)	int	vr_users
UtilityMeterDemandTracked	Indicates if the Utility Meter record demand is tracked	bit
UtilityMeterDescription	Utility Meter Description	nvarchar
UtilityMeterDigits	Utility Meter Digits	int
UtilityMeterEmsNode	Indicates if the Utility Meter record is on a energy management system node	bit
UtilityMeterEntireBldg	Indicates if the Utility Meter record is for the entire building	bit
UtilityMeterExchangeDate	Utility Meter Exchange Date	datetime
UtilityMeterHighAllowed	Utility Meter High Allowed	int
UtilityMeterId	Utility Meter Id	int	vrpt_UtilityMeter
UtilityMeterLastReading	Utility Meter Last Reading Date	datetime
UtilityMeterLocation	Utility Meter Location	nvarchar
UtilityMeterLoopId	Utility Meter Loop Id	nvarchar
UtilityMeterLoopNumber	Utility Meter Loop Number	int
UtilityMeterModifiedDate	Last Modified Date	datetime
UtilityMeterModifierId	User Id (Record Modifier)	int	vr_users
UtilityMeterProdDependent	Indicates if the Utility Meter record is production dependent	bit
UtilityMeterReadEntered	Indicates if the Utility Meter record's read is entered	bit
UtilityMeterRechargeRate	Utility Meter Recharge Rate	decimal
UtilityMeterRescheduleFactor	Utility Meter Reschedule Factor	int
UtilityMeterRollOverCount	Utility Meter Roll Over Count	int
UtilityMeterSubMeter	Indicates if the Utility Meter record is a sub meter	bit
UtilityMeterSummerAdjCode	Utility Meter Summer Adjustment Code	int
UtilityMeterSummerAdjName	Utility Meter Summer Adjustment Name	nvarchar
UtilityMeterTaxable	Indicates if this Utility Meter is taxable	bit
UtilityMeterType	Utility Meter Type	int
UtilityMeterWinterAdjCode	Utility Meter Winter Adjustment Code	int
UtilityMeterWinterAdjName	Utility Meter Winter Adjustment Name	nvarchar
UtilityRateScheduleCode	Rate Schedule Code	nvarchar
UtilityRateScheduleId	Rate Schedule Id	int	vr_rateSchedule
UtilityRouteId	Utility Route Id	int	vr_UtilityRoute
UtilityServiceActive	Indicates Whether the Utility Service is Active or Not	bit
UtilityServiceDescription	Utility Service Description	nvarchar
UtilityServiceId	Utility Service Id	int	vr_UtilityService
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar
VendorUtilityAccountCode	Vendor Account Code	nvarchar
VendorUtilityAccountId	Vendor Account Id	int	vr_account
VirtualMeterDescription	Virtual Meter Description	nvarchar
VirtualMeterId	Virtual Meter Id	int
VirtualMeterPercentage	Virtual Meter Percentage	decimal
VirtualMeterType	Virtual Meter Type	int
VirtualSquareFootage	Virtual Square Footage	int
VirtualSquareFootageCost	Virtual Square Footage Cost	decimal
WeatherStationCode	Weather Station Code	nvarchar
WeatherStationDescription	Weather Station Description	nvarchar
WeatherStationId	Weather Station Id	int	vrpt_Weather

Articles in this section