FWTruck

Attribute Name	Type	Field Size	Description	Required
TruckID	int	4	Unique internal DB Identifier of the truck record.	Required
TruckKey	nvarchar	50	Business key to identify the activity this Truck refers to.
FinalLocationID	int	4	Defines the initial station at which the truck should go back at the end of a journey.
InitialLocationID	int	4	Defines the initial station at which the truck should start its journey.
Comment	nvarchar	500	See Comment.
Company	nvarchar	50	The company name of the truck.
ModifiedBy	int	4	See ModifiedBy.
ModifyDate	datetime	8	See ModifyDate.
Measure1-9	float	8	Capacity x in units of Measure x of this truck. Amount of single-dimension measure X.
Measure(1-9)Factor	float	8	Factor for single-dimension measure X. Typically used to convert Measure[X]. Amount attribute to a different unit of measure.
Measure(1-9)RechargeRate	float	8	Specifies how quickly a truck can deliver a Measure.
Name	nvarchar	255	Name of the truck.
PartialFullPenalty	float	8	Penalty applied to a route that has one or more measures filled more than the FullThreshold percentage, and one or more measures filled less than the FullThreshold percentage.
Requirements	nvarchar	255	Capabilities of the truck.
ServiceDuration	float	8	This time will be incurred at every stop.
RechargeDuration	int	4	Time to do a recharge.
Territory	nvarchar	50	The territory for the truck.
Commodities	nvarchar	255	Commodities that the trailer can handle. Expressed in a string format (i.e. AA BB).
DiscountInitialLeg	float	8	Field to define whether or not to discount the initial leg of the journey off the total cost of the route.
DiscountFinalLeg	float	8	Field to define whether or not to discount the final leg of the journey off the total cost of the route.
UDFString(1-9)	nvarchar	500	User defined field string (1-9)
UDFInteger(1-3)	int	4	User defined field integer (1-3)
UDFNumber(1-3)	float	8	User defined field number (1-3)
DynamicZoningDistance	float	8	Dynamic zoning distance in meters.
LicenseNumber	nvarchar	50	The license number of the trailer.
LicenseIssueDate	datetime	8	The issue date of the license.
LicenseExpDate	datetime	8	The expiration date of the license.
CostProfileID	int	4	Field to identify the cost profile for the trailer.
MobileNumber	nvarchar	50	The mobile number for the trailer.
DriverID	int	4	Unique internal DB Identifer of the Driver record. Must exist on the FWDriver table.
TrailerID	int	4	Unique internal DB Identifier of the Trailer record. Must exist on the FWTrailer table.
Owner	nvarchar	250	The owner of the trailer.
VehicleType	nvarchar	50	Free text identifying the vehicle type. User specified.
FirstStopTimeThreshold	float	8	If early rests are allowed, prior to serving the first job on a route, if either of the clocks (elapsed or driving) have higher utilization that this threshold, an EarlyRest is inserted, possibly backing up the initial departure time.
FullThreshold	float	8	Percentage of full capacity that is acceptable for applying CompleteFullBonus and PartialFullPenalty.
WaitTimePenalty	float	8	This attribute field is currently not used, but is a place holder for future use.
MaxDistance	float	8	This attribute field is currently not used, but is a place holder for future use.
MaxStops	smallint	2	Maximum number of stops the resource can perform. For this attribute to be applied, the schedule’s CountStops setting must be set to true (1). If two jobs are in close proximity they are counted as one stop. You can also set a maximum number of jobs
TerritoryID	int	4	Unique internal DB identifier of the Territory record. Must exist on the FWTerritory table. Used to identify the assets territory.
Height	float	8	Asset Height
Length	float	8	Asset Length
Width	float	8	Asset Width
HeightLoadCapacity	float	8	Asset Type
WidthLoadCapacity	float	8	Asset Height Load Capacity
wGLNSyncInd	bit		Can be set to true or false depending on the response from wGLN. 0 – Failure. wGLN does not have the latest changes. 1 – wGLN is in sync with Route Planner.
wGLNResponse	nvarchar		Response from wGLN
LengthLoadCapacity	float	8	Asset Width Load Capacity
TareWeight	int	4	Tare weight of the truck
MaxWeight	int	4	Maximum weight of the truck
TotalWeight	int	4	Total weight of the truck
Cooler	bit	1	Indicate the truck has a cooler
Lift	bit	1	Indicate the truck has a lift
OnBoardComputer	bit	1	Indicate the truck has an onboard computer
OnBoardComputerKey	nvarchar	50	Business key for the onboard computer
OnBoardComputerActive	bit	1	Indicate the onboard computer is active/inactive
ExtDocControlID	nvarchar	250	External business documentation ID
RequirementSetID	int	4	Asset Length Load Capacity