BluJay Solutions Parcel 21.1.0 - User Guide
UCM Carrier Administration - Rate File Formats |
Scroll |
The following file formats are current supported for import of Rate information. This list will be expanded as the need arises for other formats.
Note: The rate file itself does not include Effective Date. You specify Effective Date for all rates in the file when importing the file in the Rate Import dialog.
Flat Rate based rating
This type of rate file is used with the Flat Rated rating method. The file must be Comma Separated format (CSV) and contain the following columns headers on the first row:
zone,weight,rate
Note that the zone column does need to be included (as a leading comma) even if you do not use zones with this rating method.
Note: This file format is identical to the format for weight-based rating. See the section "Weight based rating" for an example.
Freight Class based Rating
This type of rating is used with freight carriers (LTL and TL) using freight-class rating based on weight breaks. You define the weight range and corresponding rate in the Rates and Weight Break tables.
A freight-class based rate file has a Comma Separated format (CSV) and contains the following columns headers on the first row:
zone,weight,rate,freight_class,mincharge
Note: The zone and mincharge (minimum charge) columns are optional. The following example includes zone and mincharge.
Sample freight class based rate file with zone and mincharge
zone,weight,rate,freight_class,mincharge 1,500,50,50,10.00 2,1000,45,50,7.50 3,2000,40,50,7.50 4,5000,35,50,5.00 5,500,61,77.5,12.50 6,1000,56,77.5,10.00 7,2000,51,77.5,15.00 8,5000,46,77.5,20.00 9,500,72,80,15.00 10,1000,67,80,17.50 11,2000,62,80,20.00 12,5000,57,80,25.00 |
Volume based rating
This type of rate file is used with the Flat Rated rating method. The file must be Comma Separated format (CSV) and the column names must be formatted as follows:
zone,weight,rate
Note that the zone column does need to be included (as a leading comma) even if you do not use zones with this rating method.
Note: This file format is identical to the format for weight-based rating. See the following section for an example.
Weight Break based rating
This type of rate file is used with the Weight Break Rated rating method. The file must be Comma Separated format (CSV) and contain the following columns headers on the first row:
zone,weight,rate
Note that the zone column does need to be included (leading comma) even if you do not have zones for the rating method (see the following example).
Sample Weight Break based rate file
zone,weight,rate ,5,4.40 ,10,5.50 ,15,6.60 ,20,7.70 ,25,8.80 ,30,9.90 ,35,11.00 ,40,12.10 ,50,13.20 ,55,14.30 ,60,15.40 ,65,16.50 ,70,17.60 |
Piece Count based rating
This file format is used with the Piece Count Rated rating method. The "unit" column contains the number of pieces. The file must be Comma Separated format (CSV) and contain the following columns headers on the first row.
zone,unit,rate
Note that the zone column does need to be included (leading comma) even if you do not have zones for the rating method (see the following example).
Sample Unit Based Rate File
zone,unit,rate ,10,1.40 ,20,1.50 ,30,1.60 ,40,1.70 ,50,1.80 ,60,1.90 ,70,2.10 ,80,2.20 ,90,2.30 ,100,2.40 |
Distance based rating
This file format is used with the Distance Rated rating method. The file must be Comma Separated format (CSV) and contain the following columns headers on the first row:
unit,weight,rate
Sample Distance Based Rate File
unit,weight,rate 10,100,24.40 20,100,25.50 30,100,26.60 40,100,27.70 50,100,28.80 |
