Master Data Management

Owned by Mohit Shukla (Unlicensed)
Last updated: May 27, 2021
2 min read

 

Master data is maintained by Freight Tiger. You can submit your master data using this sheet.

Steps to Submit Master Data

  1. Open Master Data Submission Sheet

  2. Go to File → Download → Microsoft Excel

  3. Copy your master data in the sheet without changing the column names, etc

  4. Send the sheet to your Freight Tiger contact

Understanding Master Data

Add Master Data Into Freight Tiger

All the master data is provided for onboarding which will be referred to in the APIs:

  1. Your company & respective Admin & Branch users are onboarded in FT

  2. Your Master data is already uploaded in FT Integration/Sandbox environment:

    1. Known Places (Origin, Destinations) with RefCodes - ERP Code for reference to each Plant (loading) and Customer location/address (unloading) with exact lat/long or google address details. This can be a one-time activity to onboard all these locations for future reference with respective ERP code for geofencing exact location.

    2. RefCodes for all Branches/Plants (for Branch level bifurcation to trips and access/visibility to respective users)

    3. RefCodes for all related parties (shippers/transporters/consignees)

    4. Vehicle Types

    5. Material Types

    6. Routes (like delhi-mumbai, delhi-calcutta, etc). Rates for routes.

  3. Related party data is also uploaded in FT as applicable in FT Integration/Sandbox environment:

    1. List of Shippers

    2. List of Consignees/Receivers

    3. List of Transporters

  4. You have received JWT access token & login credentials (username & password) for every user in FT Integration/Sandbox environment

  5. You have received JWT access token & login credentials (username & password) for every user in FT production environment

 

Schemas for FT Master Data

This section describes the fields of FT master data objects. When master data integration is done, these fields are expected to be populated from ERP.

Currently the master data is uploaded using sheets. You can provide sheets to your FT contact who will upload them into the system.

Consignees

{ "id": 1, "code": "478630", "name": "L.G ELECTRONICS INDIA PVT. LTD", "number": null, "consigner_id": 1077, "lat": 18.6555, "long": 73.7951, "updated_at": null, "created_at": null, "status": "active", "extraContext": null, "address": "PLOT NO. A 5 MIDC, PUNE,", "email": null, "location": null, "postalcode": null, "userId": null }

 

Known Places

 {     "id": 5,     "address": "Shree Shyam Agency,plot no.426,Mouza-Gandarpur,Dist. Cuttack,NH-5,Orrissa-753003",     "latitude": 20.4705,     "longitude": 85.9023,     "region": null,     "area": "VOLVOLINE-CUTTACK",     "locationName": "VOLVOLINE-CUTTACK",     "companyId": 109,     "branchId": 1,     "departmentId": 1,     "masterBrokerId": null,     "masterConsignorId": 3,     "masterConsigneeId": null,     "masterTransporterId": null,     "created_at": "2018-02-21 12:42:46",     "updated_at": "2018-02-21 12:42:46",     "isDeleted": 0   }

Route

  • Loading Point

  • Unloading Point

  • Route Label

  • Route Code

  • Updated By

  • Array of Way points 

 

Route master (also called Freight Rate Master)

  • Transporter

  • Route

  • Vehicle Type

  • Material Type

  • Valid From

  • Freight Cost

Materials

FT stores only 2 fields for materials:

  • Material name : text

  • Ref code: Material ID in SAP

Vehicles

Following are the fields and sample data for vehicles.

Vehicle

Type

Deck

Length

Special

Features

Axle

Speed

Tyres

Deadweight

Capacity

Vehicle Type *

FT Vehicle Ref Code

Closed Truck

32

HQ

MXL

NEXP

 

15MT

Closed Truck (32FtMXLHQ 15MT)

cl32mxl15mt

Vehicle type : (Deck, Length/No of tyre, Dead weight Capacity)

API Integration for Master Data maintenance

Currently, the master data needs to be manually on-boarded in FT. See Steps to Submit Master Data. Developing of APIs to add/update master data is in our future roadmap.

 

Post your questions in the comment box to get answers from the experts who watch this page.

For engineering support: visit FT Support