Page tree
Skip to end of metadata
Go to start of metadata

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

Column Name

Description

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

  • Reject Entire Import
  • Skip the Record
  • Overwrite Existing Record

Same Records exists in File

If the records with same codes exists in File, you can choose to

  • Reject Entire Import
  • Skip the Record
  • Overwrite Existing Record

Effective Date Format

Rate Effective Date Format in File.

i.e dd-mm-yyyy, yyyy-mm-dd etc.

Code Deck

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.

  • Import Rate File
  • System Code Deck Table

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.

Show Example

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

  • No labels