| 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 |