Freightwatcher - List of Accepted Fields
The same fields are used interchangeably for loads and trucks.
*Some fields are not applicable to truck shipments but must still be included in the file as blank fields.
Field Names	Load Description	*Truck Description	Type	Format / Restrictions	Required
UserName	Freightwatcher.com Username	Freightwatcher.com Username	Alpha Numeric	Max length 20 characters; No spaces; Unique (must be created through Freightwatcher.com)	No
Action	LA = Add a Load Posting, LU = Update a Load Posting, LD = Delete a Load Posting	TA = Add a Truck Posting, TU = Update a Truck Posting, TD = Delete a Truck Posting	Alpha	Field must be "LA","LU", "LD","TA","TU","TD"	YES
PostingID	VarChar Field, no length restrictions, First two characters should be letters specific to your company.	VarChar Field, no length restrictions, First two characters should be letters specific to your company.	Alpha Numeric	Max length 25 characters; Must begin with unique prefix registered with Freightwatcher.com; No spaces	YES
Pickup_Date	Pickup Due Date	Truck Availability Date	Date	YYYY-MM-DD	NO
Delivery_Date	The Delivery Due Date; Date the posting becomes inactive	Truck Unavailability Date; Date the posting becomes inactive	Date	YYYY-MM-DD	NO
Origin_city	Load Origin City	Truck Origin City	Text		NO
Origin_Postal_Code	Load Origin City Zip Code	Truck Origin City Zip Code	Text		NO
Origin_State	Load Origin State	Truck Origin State	Text	Can be abbreviation or full name	NO
Destination_City	Load Destination City	Truck Destination City	Text		NO
Destination_Postal_Code	Load Destination City Zip Code	Truck Destination City Zip Code	Text		NO
Destination_State	Load Destination State	Truck Destination State	Text	Can be abbreviation or full name	NO
Hazardous_Materials	Indicates a hazardous shipment, "Y' for yes, or "N" for no	Indicates whether or not carrier will move a hazardous shipment	Alpha	Field must be "Y" or "N" if populated	NO
Equipment_Type	Type of Trailer, See Equipment File	Type of Trailer, See Equipment File	Alpha	Field must be abbreviation from equipment list	YES
Commodity	General description of freight	Leave blank	Text		NO
Load_Type	Indicates whether or not the shipment is a full truck load or a less than truck load	Indicates the capacity of the truck	Alpha	Field must be "LTL" for a less than truck load or "TL" for a full truck load	YES
Stops	Number of Stops	Leave blank	Integer		NO
Total_Payable	Total payment in US $ to carrier for providing service	Rate in US $ for the service	Number	Rate in US $.  Do not include "$" symbol.	NO
Quantity	Number of Pieces	Leave blank	Integer		NO
Weight	Number in Pounds	Leave blank	Integer	Do not include "#" or "lbs"	NO
Distance	Distance in Miles	Leave blank	Number	Do not include any text	NO
Comments	Miscellaneous comments	Miscellaneous comments	Text		NO
Telephone	Telephone Number of the contact who works with the carrier	Telephone Number of the contact for the carrier	Text		NO
Extension	Extension number of the telephone number	Extension number of the telephone number	Text
Contact_Name	The first and last name of the contact who works with the carrier.	The first and last name of the contact who will manage the truck posting	Text		NO
Email_Address	The email address of the contact who works with the carrier.	The email address of the contact who will manage the truck posting	Text		NO
Company	Poster's Company	Poster's Company	Text		NO
Company_Address	Poster's Address	Poster's Address	Text		NO
Company_City	Poster's City	Poster's City	Text		NO
Company_Postal_Code	Poster's Zip	Poster's Zip	Text		NO
Company_State	Poster's State	Poster's State	Text	Can be abbreviation or full name	NO
Company_Fax	Poster's Fax	Poster's Fax	Text		NO