FS
FSRouteDocument
PX.Objects.FS57 of 57 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RefNbr | nvarchar(15) | Route Nbr. | - | |
Description:No description available | ||||
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 | EPEmployeeFSRouteEmployee | |
Description:No description available | ||||
AdditionalVehicleID1 | int | Additional Vehicle 1 | FSEquipment | |
Description:No description available | ||||
AdditionalVehicleID2 | int | Additional Vehicle 2 | FSEquipment | |
Description:No description available | ||||
AntiFreeze | int | Anti-freeze | - | |
Description:No description available | ||||
ApproximateValuesLabelNonexistent in DB | nvarchar(MAX) | - | ||
Description:No description available | ||||
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 | ||||
Date | datetime | Schedule Start Date | - | |
Description:No description available | ||||
DEF | int | DEF | - | |
Description:No description available | ||||
DriverID | int | Driver | EPEmployeeFSRouteEmployee | |
Description:No description available | ||||
FuelQty | int | Fuel Qty. | - | |
Description:No description available | ||||
FuelType | char(1) | Fuel Type | - | |
Description:No description available | ||||
GeneratedBySystem | bit | Generated by System | - | |
Description:No description available | ||||
GPSLatitudeComplete | decimal(9, 6) | Latitude | - | |
Description:No description available | ||||
GPSLatitudeLongitudeNonexistent in DB | nvarchar(255) | GPS Latitude Longitude | - | |
Description:No description available | ||||
GPSLatitudeStart | decimal(9, 6) | Latitude | - | |
Description:No description available | ||||
GPSLongitudeComplete | decimal(9, 6) | Longitude | - | |
Description:No description available | ||||
GPSLongitudeStart | decimal(9, 6) | Longitude | - | |
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 | nvarchar(MAX) | Additional Driver Name | - | |
Description:No description available | ||||
MemBusinessDateTimeNonexistent in DB | datetime | - | ||
Description:No description available | ||||
Miles | int | Miles | - | |
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 | ||||
RouteCD | nchar(15) | RouteCD | - | |
Description:No description available | ||||
RouteDocumentID | int | RouteDocumentID | - | |
Description:No description available | ||||
RouteID | int | Route | FSRoute | |
Description:No description available | ||||
RouteNumberingIDNonexistent in DB | nvarchar(10) | Route Numbering ID | - | |
Description:No description available | ||||
RouteStatsUpdated | bit | Route Stats Updated | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | 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(19, 4) | - | ||
Description:No description available | ||||
TotalDistanceFriendly | nvarchar(50) | 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 | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VehicleID | int | Vehicle | FSEquipment | |
Description:No description available | ||||
Weight | int | Weight | - | |
Description:No description available | ||||