vr_FuelAndOil

Updated March 24, 2026 15:21

Field Name	Field Description	Data Type	FK Join
Id	Fuel and Oil Ticket Id	int
Number	Fuel and Oil Ticket Number	int
VehicleId	Vehicle Id	int	vr_Vehicle
VehicleTagNumber	Vehicle Tag Number	nvarchar
VehicleDescription	Vehicle Description	nvarchar
EquipmentId	Equipment Id	int	vr_equipment
EquipmentTagNumber	Equipment Tag Number	nvarchar
EquipmentDescription	Equipment Description	nvarchar
Date	Date	datetime
GasGallons	Gas in gallons	decimal
OilQuarts	Oil in quarts	decimal
TransmissionQuarts	Transmission fluid in quarts	decimal
CoolantGallons	Coolant in gallons	decimal
CurrentMileage	Current Mileage	decimal
Recipient	Recipient	nvarchar
GasPrice	Gas price	decimal
OilPrice	Oil price	decimal
TransmissionPrice	Transmission fluid price	decimal
CoolantPrice	Coolant price	decimal
BulkPrice	Bulk price	decimal
Charge	Indicates if the record is chargeable	bit
PostDate	Post Date	datetime
BatchJobId	Batch Job Id	int	vr_BatchJob
BeginningMileage	Beginning Mileage	decimal
DeltaMileage	Delta Mileage	decimal
DaysUsed	Days Used	decimal
FuelAndOilMonth	Month	smallint
FuelAndOilYear	Year	int
CreatedDate	Record Creation Date	datetime
ModifiedDate	Last Modified Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
ModifierId	User Id (Record Modifier)	int	vr_users
DepartmentId	Department Id	int	vr_Department
DepartmentCode	Department Code	nvarchar
DepartmentName	Department Name	nvarchar
SupplierId	Supplier Id	int	vr_Vendor
SupplierCode	Supplier Code	nvarchar
SupplierName	Supplier Name	nvarchar
MeterId	Meter Id	int	vr_meter
MeterName	Meter Name	nvarchar
MeterDescription	Meter Description	nvarchar
MeterDelta	Meter Delta	decimal
MeterMeterReadingId	Meter Reading Id	int
MeterMeterReadingValue	Meter Reading Value	decimal
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianCode	Technician Code	nvarchar
TechnicianName	Technician Name	nvarchar
SLPostdate	Sub Ledger Post Date	datetime
CurrencyId	Currency Id	int	vrpt_Currency
CurrencyExchangeId	Currency Exchange Id	int
CurrencyExchangeDate	Currency Exchange Date	datetime
BudgetCodeId	Budget Code Id	int
BudgetCodeCode	Budget Code	nvarchar
BudgetCodeDescription	Budget Code Description	nvarchar
FuelTypeId	Fuel Type Id	int	vr_FuelType
FuelTypeCode	Fuel Type Code	nvarchar
FuelTypeDescription	Fuel Type Description	nvarchar
AccountProgramId	Account Program Id	int
AccountProgramCode	Account Program Code	nvarchar
AccountProgramDescription	Account Program Description	nvarchar
RepairCenterId	Repair Center Id	int	vr_RepairCenter
RepairCenterCode	Repair Center Code	nvarchar
RepairCenterName	Repair Center Name	nvarchar
ChargeAccountId	Charge Account Id	int	vr_account
ChargeAccountCode	Charge Account Code	nvarchar
ChargeAccountName	Charge Account Name	nvarchar
CreditAccountId	Credit Account Id	int	vr_account
CreditAccountCode	Credit Account Code	nvarchar
CreditAccountName	Credit Account Name	nvarchar
ItemTypeId	Item Type Id	int	vr_WebTMAItemTypes
ItemId	Item Id	int
ItemTagNumber	Item Tag Number	nvarchar
ItemDescription	Item Description	nvarchar
GasExtended	Gas Extended	decimal
OilExtended	Oil Extended	decimal
TransmissionExtended	Transmission Extended	decimal
CoolantExtended	Coolant Extended	decimal
TicketTotal	Ticket Total	decimal

Articles in this section