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

In this module we will see how to Upload US JD Rate File.

To upload US JD Rate File, 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 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.

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.

Auto Populate IJ Rate

Check this box if you want to Automatically Populate the IJ Rates. (US JD Rates)

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 US JD Rate File, Click on Import File and select the Fields with the help of above displayed data. After selecting all the Fields, click on Upload 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.

US JD Rate File contains 3 different rates i.e. INTER RATE, INTRA RATE & IJ RATE.

Here is the Sample of the US JD Rate File.

Screenshot: US JD Rate File Sample

The File contains CODES with following rates as shown in the rate table.

  • No labels