- 29 Jul 2022
- 1 読む分
- 印刷する
- 闇光
- PDF
Master Table – WMC IB Users
- 更新日 29 Jul 2022
- 1 読む分
- 印刷する
- 闇光
- PDF
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.
- The Carrier_rate page displays details like Charge_code, Charge_type, Rate, etc.
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.
- The Fuel_rate_indicators page displays details like Mode, Class, Category, etc.
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.
- The Lane page displays details like Lane_id, Origin_location ID, Origin_location_name, etc.
Lane Master Table - Details
Transit Details
The TRANSIT DETAILS master table lists all the possible Transit permutations (Mode, Class, Service level) for Lanes.
- The TRANSIT DETAILS page displays details like Origin, Destination, Mode, Class, Service, etc.
Transit Details Master Table - Details
Accessing Master Table
- Click on the Master Table option in the Navigation Panel on the left-hand side of the screen.
- On the Master Table page, view the information of various master tables such as:
- Carrier Rate
- Fuel Rate Indicator
- Lane
- Transit Details
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.
- Click on the Master Table page from the Navigation Panel to view the list of all Master Tables.
- Click on the Eye icon to view the Lane master table.
Master Tables – Eye Icon
- 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.
Lane Details Page
- Click on the Download button to download the Lane details.
- Upon clicking on the Download button, a file is saved on your system, the file is a workbook grid which shows the relevant information.
Lane – Download button