In this module we will see how to upload A-z Type Rate Table
To upload the Block List, Click on Routing → Rate Table
Below displayed window will appear.
Screenshot: Rate Table
Rate Table window will appear, Just click on any of the Rate Table's Name or Edit icon to edit the Rate Table.
Editing Rate Table window will appear.
Screenshot: Editing Rates
On Editing Rates Window, Click on Import Section, Import window will appear.
Screenshot: Import File
Rate Upload Template
You can select the predefined templates to upload the Rates.
Same Record exists in Rate Table
If the records with same codes exists in rate table, you can choose to
Same Records exists in File
If the records with same codes exists in File, you can choose to
Effective Date Format
Rate Effective Date Format in File.
i.e dd-mm-yyyy, yyyy-mm-dd etc.
Choose the code deck which will be applicable on the imported rates. like A-Z
Get Code Name From
You can choose from where you wants the destination code names i.e.
Enable Auto end Date for Previous Rates
Check this box if you want to Auto end effective date for Previous Rates and input the End Date.
File with Header
Check this box if you want to upload file with Header.
Download the Example file which shows format of the file to upload.
To Import the A-Z Rate File, Click on Import File and select the Fields with the help of above displayed data. After selecting all the Fields, click on Next button,
The File upload will get started. You can view the Upload status in Import Log window.
You can download the sample file by clicking on Show Example.
A-Z Rate file contains only Rate section.
Here is the Sample of the A-Z Rate File.
Screenshot: A-Z Rate File Sample
The File contains CODES with following rates as shown in the rate table.
For more information regarind Rate Tables, Please refer to Rate Table