vr_UtilityTicket

Updated November 28, 2025 13:14

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
AccountProgramCode	Account Program Code	nvarchar
AccountProgramId	Account Program Id	int
APInvoiceId	Invoice Id	int	vr_Invoice
APInvoiceNumber	Invoice Number	int
BatchJobId	Batch Job Id	int	vr_BatchJob
CalculatedUnitCost	Calculated Unit Cost	decimal
Charge	Indicates Whether the Utility Ticket is Chargeable	bit
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
CreditAccountName	Credit Account Name	nvarchar
Demand	Demand	decimal
DemandUoMCode	Demand Unit of Measure Code	nvarchar
DemandUoMId	Demand Unit of Measure Id	int	vr_unitOfMeasure
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
EndDate	End Date	datetime
Id	Utility Ticket Id	int
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Number	Utility Ticket Number	int
PeriodicCharge	Periodic Charge	decimal
PostDate	Post Date	datetime
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
SLPostDate	Sub Ledger Post Date	datetime
StartDate	Start Date	datetime
Tax1Description	Tax 1 Description	nvarchar
Tax2Description	Tax 2 Description	nvarchar
Taxable	Indicates if this Utility Ticket is taxable	bit
TaxAmount	Tax Amount	decimal
TaxAmount1	Tax Amount 1	decimal
TaxAmount2	Tax Amount 2	decimal
TaxCompound	Indicates if the record utilizes tax compound	bit
TaxId	Tax Id	int	vr_TaxRate
TaxName	Tax Name	nvarchar
TaxRate1	Tax Rate 1	decimal
TaxRate2	Tax Rate 2	decimal
TaxRateOne	Tax One	decimal
TaxRateTwo	Tax Two	decimal
TaxTax2OnTax1	Indicates if this Utility Ticket is compounding Tax 2 on Tax 1	bit
TicketDate	Ticket Date	datetime
TotalAmount	Total Amount	decimal
Usage	Utility Ticket Usage	decimal
UtilityMeterCode	Utility Meter Code	nvarchar
UtilityMeterDescription	Utility Meter Description	nvarchar
UtilityMeterId	Utility Meter Id	int	vrpt_UtilityMeter
UtilityServiceCode	Utility Service Code	nvarchar
UtilityServiceDescription	Utility Service Description	nvarchar
UtilityServiceId	Utility Service Id	int	vr_UtilityService
UtilityServiceUnit	Service Unit	nvarchar
VendorCode	Vendor Code	nvarchar
VendorId	Vendor Id	int	vr_Vendor
VendorName	Vendor Name	nvarchar
VendorUtilityAccountCode	Vendor Account Code	nvarchar
VendorUtilityAccountId	Vendor Account Id	int	vr_account
VendorUtilityAccountName	Vendor Account Name	nvarchar

Articles in this section