FWRouteHistory

Attribute Name	Type	Field Size	Description	Required
RouteHistID	int	4	Unique internal DB Identifier of the Route History record.	Required
RouteID	int	4	Unique internal DB Identifier of the Route record. Must exist on the FWRoute table.	Required
StopID	int	4	Unique internal DB Identifier of the Stop record. Must exist on the FWStop table.
Latitude	float	8	Reported GPS Latitidue. In conjunction with Longitude attribute, provides geographic position of address. For use with non-geocodable addresses, or in long haul situations where the map does not support geocoding.
Longitude	float	8	Reported GPS Longitude In conjunction with Latitude attribute, provides geographic position of address. For use with non-geocodable addresses, or in long haul situations where the map does not support geocoding.
MessageDate	datetime	8	Time stamp of message
Status	tinyint	1	Status reported
ActualMeasure1-9	float	8	Actual Measure 1..9 reported in status messages
TrailerKey	nvarchar	50	Trailer Key reported in Status message
TractorKey	nvarchar	50	Tractor key reported in status message
DriverKey	nvarchar	50	Driver Key reported in Status message
Comment	nvarchar	500	See Comment.
UDFString1-9	nvarchar	500	UDF String 1..9 reported in the Status message
UDFInteger1-3	int	4	UDF Integer 1..3 reported in the status message
UDFNumber1-3	float	8	UDF Number 1..3 reported in the status message
ModifiedBy	int	4	See ModifiedBy.
ModifyDate	datetime	8	See ModifyDate.
OrderLineID	int	4	Foreign Key. Links this record with an order line
ActualQuantity	float	8	This fields will hold the actual quantity reported by mobile devices
Source	int	4	Source of the status message. Either UI or wireless devices
ProductTypeKey	nvarchar	50	Product Type Key for which the status is reported
AlertID	int	4	Internal ID to link this record with an alert ID when custom alerts are reported during actuals
ActualTotalMeasure1-9	float	8	Actual total measure reported
ScannedIndActualMeasure1-9	bit	1	Indicate that actual measure is scanned in
ScannedIndDriverKey	bit	1	Indicate the driverKey is scanned in
ScannedIndTruckKey	bit	1	Indicate the truckKey is scanned in
ScannedIndTrailerKey	bit	1	Indicate the TrailerKey is scanned in
ScannedIndTractorKey	bit	1	Indicate the TractorKey is scanned in
ScannedIndUDFString1-9	bit	1	Indicate the UDFString is scanned in
ScannedIndUDFInteger1-3	bit	1	Indicate the UDFInteger is scanned in
ScannedIndUDFNumber1-3	bit	1	Indicate the UdfNumber is scanned in
ScannedIndActualQuantity	bit	1	Indicate the Actual Quantity is scanned in
ScannedIndProductTypeKey	bit	1	Indicate the ProductTypeKey is scanned in
ScannedIndProductKey	bit	1	Indicate the ProductKey is scanned in
ScannedIndOrderKey	bit	1	Indicate the Orderkey is scanned in
ScannedIndLocationKey	bit	1	Indicate the LocationKey is scanned in
StartDate	datetime		Start date of the event
EndDate	datetime		End date of the event
MsgID	int	4	Associated message record ID
LastReportedTimeZone			Time zone of last reported time
MessageDateUTC	datetime	8	Time stamp of message (Coordinated Universal Time)
StatusDesc	nvarchar	50
TruckKey	nvarchar	50	This field holds the TruckKey used to report this status update
WirelessSource	nvarchar	20	Allows wGLN to detect whether the submitted status information was sent by driver, black box or ASU
CreatedDate	datetime	8	See CreatedDate.