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) |
|
