FS
FSRouteDocument
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ActualEndTime | datetime | Actual End Date | - | |
Description:No description available | ||||
ActualEndTimeUTC | datetime | Actual End Time | - | |
Description:No description available | ||||
ActualStartTime | datetime | Actual Start Date | - | |
Description:No description available | ||||
ActualStartTimeUTC | datetime | Actual Start Time | - | |
Description:No description available | ||||
AdditionalDriverID | int | Additional Driver | EPEmployee | |
Description:No description available | ||||
AdditionalVehicleID1 | int | Additional Vehicle 1 | FSVehicle | |
Description:No description available | ||||
AdditionalVehicleID2 | int | Additional Vehicle 2 | FSVehicle | |
Description:No description available | ||||
AntiFreeze | int | Anti-freeze | - | |
Description:No description available | ||||
ApproximateValuesLabelNonexistent in DB | string | - | ||
Description:No description available | ||||
AttributesNonexistent in DB | string | - | ||
Description:A service field, which is necessary for the dynamically added attributes defined at the Route screen level to function correctly. | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
DEF | int | DEF | - | |
Description:No description available | ||||
Date | datetime | Schedule Start Date | - | |
Description:No description available | ||||
DriverID | int | Driver | EPEmployee | |
Description:No description available | ||||
FormCaptionDescriptionNonexistent in DB | string | - | ||
Description:No description available | ||||
FuelQty | int | Fuel Qty. | - | |
Description:No description available | ||||
FuelType | char(1) | Fuel Type | - | |
Description:No description available | ||||
GPSLatitudeComplete | decimal | Latitude | - | |
Description:No description available | ||||
GPSLatitudeLongitudeNonexistent in DB | string | GPS Latitude Longitude | - | |
Description:No description available | ||||
GPSLatitudeStart | decimal | Latitude | - | |
Description:No description available | ||||
GPSLongitudeComplete | decimal | Longitude | - | |
Description:No description available | ||||
GPSLongitudeStart | decimal | Longitude | - | |
Description:No description available | ||||
GeneratedBySystem | bit | Generated by System | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
MemActualDurationNonexistent in DB | int? | Actual Duration | - | |
Description:No description available | ||||
MemAdditionalDriverNameNonexistent in DB | string | Additional Driver Name | - | |
Description:No description available | ||||
MemBusinessDateTimeNonexistent in DB | DateTime? | - | ||
Description:No description available | ||||
Miles | int | Miles | - | |
Description:No description available | ||||
MustRecalculateStatsNonexistent in DB | bool? | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | NoteID | - | |
Description:No description available | ||||
Oil | int | Oil | - | |
Description:No description available | ||||
Propane | int | Propane | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Route Nbr. | - | |
Description:No description available | ||||
RouteCDNonexistent in DB | string | - | ||
Description:No description available | ||||
RouteDocumentID | int | - | ||
Description:No description available | ||||
RouteID | int | Route | FSRoute | |
Description:No description available | ||||
RouteNumberingIDNonexistent in DB | string | Route Numbering ID | - | |
Description:No description available | ||||
RouteStatsUpdated | bit | Route Stats Updated | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
TimeBegin | datetime | Start Time | - | |
Description:No description available | ||||
TimeBeginUTC | datetime | Start Time | - | |
Description:No description available | ||||
TimeEnd | datetime | End Time | - | |
Description:No description available | ||||
TimeEndUTC | datetime | End Time | - | |
Description:No description available | ||||
TotalDistance | decimal | - | ||
Description:No description available | ||||
TotalDistanceFriendly | nvarchar | Total Distance | - | |
Description:No description available | ||||
TotalDuration | int | Total Driving Duration | - | |
Description:No description available | ||||
TotalNumAppointments | int | Number of Appointments | - | |
Description:No description available | ||||
TotalServices | int | Total Services | - | |
Description:No description available | ||||
TotalServicesDuration | int | Total Services Duration | - | |
Description:No description available | ||||
TotalTravelTime | int | Total Route Duration | - | |
Description:No description available | ||||
TripNbr | int | Trip Nbr. | - | |
Description:No description available | ||||
VehicleID | int | Vehicle | FSVehicle | |
Description:No description available | ||||
Weight | int | Weight | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||