vr_UtilityBudget

Field NameField DescriptionData TypeFK Join
AccountChargeCodeAccount Charge Codenvarchar 
AccountChargeIdAccount Charge Idintvr_account
AccountCreditCodeAccount Credit Codenvarchar 
AccountCreditIdAccount Credit Idintvr_account
AreaIdArea Idintvr_area
AreaLocationCodeArea Location Code (Location Id)nvarchar 
BuildingIdBuilding Idintvr_building
BuildingNameBuilding Namenvarchar 
CalendarYearCalendar Yearint 
CreatedDateRecord Creation Datedatetime 
CreatorIdUser Id (Record Creator)intvr_users
FacilityIdFacility Idintvr_facility
FacilityNameFacility Namenvarchar 
FiscalYearFiscal Yearint 
IdUtility Budget Idint 
ModifiedDateLast Modified Datedatetime 
ModifierIdUser Id (Record Modifier)intvr_users
UtilityMeterCodeUtility Meter Codenvarchar 
UtilityMeterDescriptionUtility Meter Descriptionnvarchar 
UtilityMeterIdUtility Meter Idintvrpt_UtilityMeter
UtilityMeterLocationUtility Meter Locationnvarchar 
UtilityServiceCodeUtility Service Codenvarchar 
UtilityServiceDescriptionUtility Service Descriptionnvarchar 
UtilityServiceIdUtility Service Idintvr_UtilityService
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more
Announcing WebTMA + Workday Integration
To Learn More, Click Here!
2026 Webinar Training Schedule - Register now!
See the full list of web training events.
TMA Systems - TMA Connect 2026 Registration
Register Now by clicking here!