LTL Rating - Rate File Format

Home Products Carriers LTL LTL Rating Software LTL Rate File Format


For over 25 years, Malvern Systems has developed affordable, integrated, multi-carrier parcel shipping solutions for small to medium-sized companies across a wide variety of industries.


LTL Rate File Format

 

With Malvern's LTL Rating Module, users can load their own LTL rate tables. The input format is a very simple comma-delimited (csv) or fixed-positioning text file. Fuel surcharges and accessorial fees such as liftgate service, inside delivery, and residential fee are configured separately.

 

Column Description

1

not in use
2 Carrier SCAC Code (or 3-4 character identifier)
3 not in use
4 Origin Zipcode (5 Digits)
5 Origin State (2 Characters)
6 Destination Zipcode (5-Digit Start of Range) E.g., 19100
7 Destionation Zipcode (2-Digit End of Range) E.g., 99  
8 not in use
9 not in use
10 Freight Class (e.g., 55,60,100, etc)
11 (Optional) Minimum Charge in cents e.g., enter $200.00 as 20000
12 not in use
13 not in use
14 not in use
15 L5C Rate (up to 500 lb rate with 4 implied decimal places e.g., enter $0.8038 /lb as 8038)
16 M5C Rate (500-999 lb rate)
17 M1M Rate (1,000 - 1,999 lb rate)
18 M2M Rate (2,000 - 4,999 lb rate)
19 M5M Rate (5,000 - 9,999 lb rate)
20 M10M Rate (10,000 - 19,999 lb rate)
21 M20M Rate (20,000 - 29,999 lb rate)
22 M30M Rate (30,000 - 39,999 lb rate)
22 M40M Rate (Greater than 40,000 lb rate)

 

 

In the Press

Shopping Carts Internet Postage LTL Time-in-Transit Address Correction

Malvern Shipping Software ProductsOrder Thermal Shipping LabelsCall, Email or Schedule an Online DemoAbout Malvern Systems

2013 Malvern Systems, Inc.

All rights reserved

(800) 296-9642

Our Blog

Home