Master Table – WMC IB Users
  • 29 Jul 2022
  • 1 読む分
  • PDF

Master Table – WMC IB Users

  • PDF

The content is currently unavailable in Ja - 日本語. You are viewing the default English version.
記事の要約

Master Table contains information about various accessorial claim loads. As a WMC IB user, view all the master tables.

Types of Master Tables

Carrier Rate

The carrier rate master table contains all the contracted accessorial rates that a carrier has with Walmart Canada.

  1. The Carrier_rate page displays details like Charge_code, Charge_type, Rate, etc.

IB_mastertable_007 - Carrier rate

Carrier rate Master Table - Details

Fuel Rate Indicators

The Fuel rate indicators master table showcases the different fuel types used by a carrier depending on the modality.

  1. The Fuel_rate_indicators page displays details like Mode, Class, Category, etc.

IB_mastertable_009 - Fuel rate indicators

Fuel_rate_indicators Master Table - Details

Lane

The Lane master table contains the listing of lanes (from an origin location to a destination location) that carriers ship for Walmart Canada.

  1. The Lane page displays details like Lane_id, Origin_location ID, Origin_location_name, etc.

IB_mastertable_006 - Lane

Lane Master Table - Details

Transit Details

The TRANSIT DETAILS master table lists all the possible Transit permutations (Mode, Class, Service level) for Lanes.

  1. The TRANSIT DETAILS page displays details like Origin, Destination, Mode, Class, Service, etc.

IB_mastertable_008 - Transit Details

Transit Details Master Table - Details

Accessing Master Table

  1. Click on the Master Table option in the Navigation Panel on the left-hand side of the screen.
  2. On the Master Table page, view the information of various master tables such as:
    1. Carrier Rate
    2. Fuel Rate Indicator
    3. Lane
    4. Transit Details

IB_mastertable_005 - Master Table List

Master Tables – Left Navigation Panel

View & Download Master Tables

Based on the access levels, a WMC IB user can:

  • View data on the master table.
  • Download data to the master table.

The following example illustrates the Lane Master Table, but the steps are similar for other Master Table.

  1. Click on the Master Table page from the Navigation Panel to view the list of all Master Tables.
  2. Click on the Eye icon to view the Lane master table.

IB_mastertable_005 - Master Table List - Copy(1)

Master Tables – Eye Icon

  1. The Lane page displays details like Origin_city, Origin_location_id, Origin_location_name, etc.

Each Master Table's details page will have a different set of column fields.

IB_mastertable_001

Lane Details Page

  1. Click on the Download button to download the Lane details.
  2. Upon clicking on the Download button, a file is saved on your system, the file is a workbook grid which shows the relevant information.

IB_mastertable_006 - Lane (2)

Lane – Download button


この記事は役に立ちましたか?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.