FWTrailer

Attribute Name	Type	Field Size	Description	Required
TrailerID	int	4	Unique internal DB Identifier of the trailer record.	Required
TrailerKey	nvarchar	50	Business key to identify the activity this Trailer refers to.
FinalLocationID	int	4	Defines the initial station at which the trailer should go back at the end of a journey.
InitialLocationID	int	4	Defines the initial station at which the trailer should start its journey.
ModifiedBy	int	4	See ModifiedBy.
ModifyDate	datetime	8	See ModifyDate.
Comment	nvarchar	500	See Comment.
Company	nvarchar	50	The company name of the trailer.
Measure1-9	float	8	Capacity x in units of Measure x of this trailer. 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	This attribute field is currently not used, but is a place holder for future use.
Name	nvarchar	255	Name of the trailer.
PreServiceDuration	int	4	Pre Service Duration in seconds for the trailer. This time will be incurred at every stop before it starts working on the job.
Requirements	nvarchar	255	Capabilities of the trailer.
ServiceDuration	float	8	This time will be incurred at every stop.
RechargeDuration	int	4	Time to do a recharge.
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)
Commodities	nvarchar	255	Commodities that the trailer can handle. Expressed in a string format (i.e. AA BB).
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	float	8	The mobile number for the trailer.
Owner	nvarchar	50	The owner of the trailer.
Height	float	8	Asset Height
Length	float	8	Asset Length
Width	float	8	Asset Width
VehicleType	nvarchar	50	Asset Type
HeightLoadCapacity	float	8	Asset Height Load Capacity
WidthLoadCapacity	float	8	Asset Width Load Capacity
LengthLoadCapacity	float	8	Asset Length 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		Holds the response from wGLN.
TareWeight	int	4	Tare weight trailer
MaxWeight	int	4	Maximum weight of the trailer
TotalWeight	int	4	Total weight of the trailer
Cooler	bit	1	Indicate the trailer has a cooler
Lift	bit	1	Indicate the trailer has a lift
ExtDocControlID	nvarchar	250	External business document ID
RequirementSetID	int	4	Requirements Set identifier for this asset