vr_Trip

Updated November 28, 2025 12:55

Field Name	Field Description	Data Type	FK Join
BatchJobId	Batch Job Id	int	vr_BatchJob
Comments	Comments	nvarchar
ConvoyNumber	Convoy Number	nvarchar
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
DateCompleted	Date Completed	datetime
DateRequested	Date Requested	datetime
DateScheduled	Date Scheduled	datetime
DepartmentCode	Department Code	nvarchar
DepartmentId	Department Id	int	vr_Department
DepartmentName	Department Name	nvarchar
Description	Trip Description	nvarchar
Destination	Trip Destination	nvarchar
Direction	Direction	nvarchar
DispatchRouteCode	Dispatch Route Code	nvarchar
DispatchRouteDescription	Dispatch Route Description	nvarchar
DispatchRouteId	Dispatch Route Id	int
FuelCost	Fuel Cost	decimal
Id	Trip Id	int
IsConvoy	Indicates if the trip record is a convoy	bit
LastPrintDate	Last Print Date	datetime
Location	Trip Location	nvarchar
Miles	Miles	decimal
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
NotifyMe	Indicates Whether the Notify Me Box is Checked	bit
OverrideDriver	Override Driver	bit
OverrideVehicle	Override Vehicle	bit
RejectedByFullName	Rejected By Full Name	nvarchar
RejectedById	Rejected By Id	int	vr_users
RejectedDate	Rejected Date	datetime
RejectReason	Reject Reason	nvarchar
RequestorCode	Requestor Code	nvarchar
RequestorEmail	Requestor Email	nvarchar
RequestorFullName	Requestor Full Name	nvarchar
RequestorId	Requestor Id	int	vr_Requestor
RequestorName	Requestor Name	nvarchar
RequestorPhone	Requestor Phone	nvarchar
ScheduledByFullName	Scheduled By Full Name	nvarchar
ScheduledById	Scheduled By Id	int	vr_users
ScheduledEnd	Scheduled End	datetime
Standing	Standing	bit
TechnicianCode	Technician Code	nvarchar
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
TotalCost	Total Cost	decimal
TripNumber	Trip Number	int
TripScheduleId	Trip Schedule Id	int
TripTypeCode	Trip Type Code	nvarchar
TripTypeDescription	Trip Type Description	nvarchar
TripTypeId	Trip Type Id	int	vrpt_travelTripType
VehicleDescription	Vehicle Description	nvarchar
VehicleId	Vehicle Id	int	vr_Vehicle
VehicleTagNumber	Vehicle Tag Number	nvarchar

Articles in this section