TMS 7.12 Carrier Monitoring API Field Mapping

  • Updated on Oct 29, 2024
  • Published on Mar 21, 2023
  • 4 minute(s) read
Prev Next

Overview

Integrations with SaferWatch, RMIS, and MyCarrierPackets allow for real-time Carrier monitoring within the TMS. The table below describes field value changes based on the integration.

Table Guide

The following fields are inserted/updated by the Carrier Monitoring APIs as follows:

I – Insert

U – Update

(1) => update if the global setting “Allow Carrier Address Updates” is checked OR the value in the TMS field is null

(2) – update if the value in the TMS field is null

(3) – update if there is a value in the response

(4) – update if there is a value in the response AND the value in the TMS field is null

(5) – update if the global setting “Carrier Remit To Sync” is checked AND the response has factor company information

(6) – update to ‘Pending’ if RMIS Certified is not ‘Yes’

(7) – set to ‘Pending’ by the TMS

Carrier Address Updates

Enable this functionality by navigating to TMS Admin and then selecting Configuration. Check the box for "Allow Carrier Address Updates" in the list of Global Settings. When checked, the shipping and billing addresses for the Carrier will update continuously.
 
Note that this functionality is only supported by RMIS and MyCarrierPackets, NOT SaferWatch.

Object

Field

SaferWatch

RMIS

MyCarrierPackets

Account

BillingStreet

I 

I / U (1)

I / U (1)

Account

BillingCity

I

I / U (1)

I / U (1)

Account

BillingStateCode

I

I / U (1)

I / U (1)

Account

BillingPostalCode

I

I / U (1)

I / U (1)

Account

BillingCountryCode

I

I / U (1)

I / U (1)

Account

Currency

I

I

I

Account 

DBA Name

I / U (2)

I / U (2)

I / U (2)

Account

Fax

I / U (2)

I / U (2)

I / U (2)

Account 

Name

I

I

I

Account

Phone

I / U (2)

I / U (2)

I / U (2)

Account

ShippingStreet

I

I / U (1)

I / U (1)

Account

ShippingCity

I

I / U (1)

I / U (1)

Account

ShippingStateCode

I

I / U (1)

I / U (1)

Account

ShippingPostalCode

I

I / U (1)

I / U (1)

Account

ShippingCountryCode

I

I / U (1)

I / U (1)

Carrier Service

Name

I

I

I

Carrier Service

Currency

I

I

I

Carrier Service

Mode

 

I

I

Carrier Service

Quote Contact

I

I

I

Carrier Service

Tender Contact

I

I

I

Carrier Service

Status Contact

I

I

I

Contact

First Name

I

I

I

Contact

Last Name

I

I

I

Contact

Email

I

I

I

Contact

Fax

 

I

I

Contact

Mobile Phone

 

I

I

Contact

Phone

I

I

I

Contact

Title

 

I

 

Contact

Transportation Role

I

I

I

Insurance Policy

Name

I

I

I

Insurance Policy

Currency

I

I

I

Insurance Policy

Address

I

I

I

Insurance Policy

Agent Company

I

I

I

Insurance Policy

Agent Email

I

I

I

Insurance Policy

Agent Phone

I

I

I

Insurance Policy

Cancel Date

 

I

 

Insurance Policy

City

I

I

I

Insurance Policy

Coverage Amount

I

I

I

Insurance Policy

Effective Date

 

I

 

Insurance Policy

Expiry Date

I

I

I

Insurance Policy

Fax

I

I

I

Insurance Policy

Insurance Company

I

I

I

Insurance Policy

Phone

I

I

I

Insurance Policy

Postal Code

I

I

I

Insurance Policy

Reefer Breakdown Coverage

I

 

 

Insurance Policy

Reefer Breakdown Deductible

I

 

 

Insurance Policy

Deductible

I

 

I

Insurance Policy

Source

I

I

I

Insurance Policy

State/Province

I

I

I

Insurance Policy

Type

I

I

I

Transportation Profile

Agreement Date

 

 

I

Transportation Profile

Agreement Signed By

 

 

I

Transportation Profile

Agreement Status

 

 

I

Transportation Profile

Authority Granted Date

I / U

I / U

I / U

Transportation Profile

Authority Points

 

 

I / U

Transportation Profile

Authority Risk

I / U

I (7)

I / U

Transportation Profile

Broker Authority Pending

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Broker Authority Revocation

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Broker Authority Status

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Canada Province Coverage

 

I / U (4)

I / U (4)

Transportation Profile

CARB TRU Certificate Expiration Date

 

I / U

 

Transportation Profile

CARB TRU Compliant Vehicles Reported

 

I / U

 

Transportation Profile

CARB TRU Compliance Type

 

I / U

 

Transportation Profile

CARB TRU Non-Compliant Reason

 

I / U

 

Transportation Profile

Cargo Carried

 

 

I / U

Transportation Profile

Carrier Operation

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Carrier Pay To Name

 

I / U

 

Transportation Profile

Carrier Remit To

I

I / U (5)

I / U (5)

Transportation Profile

Carrier Review Status

I

I / U (6)

I

Transportation Profile

Common Authority Pending

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Common Authority Revocation

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Common Authority Status

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Company Risk

I

(7)

I

Transportation Profile

Contract Authority Pending

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Contract Authority Revocation

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Contract Authority Status

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Currency

I

I

I

Transportation Profile

D&B DUNS Number

 

 

I

Transportation Profile

Federal Tax ID

 

I / U (3)

I / U (3)

Transportation Profile

Fleet Size

 

I

I

Transportation Profile

FMCSA Insurance Cancellation Date

I / U

 

 

Transportation Profile

FMCSA Insurance Cancellation Type

I / U

 

 

Transportation Profile

Insurance Points

 

 

I / U

Transportation Profile

Insurance Risk

I / U

I (7)

I / U

Transportation Profile

Last Carrier Review Date

 

I / U

 

Transportation Profile

MC Number

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Mexico State Coverage

 

I / U (4)

 

Transportation Profile

Name

I

I

I

Transportation Profile

NSC Number

 

I / U (3)

 

Transportation Profile

NSC Safety Certificate Date

 

I / U (3)

 

Transportation Profile

Number of Drivers

 

I

I

Transportation Profile

Operation Points

 

 

I / U

Transportation Profile

Operation Risk

I / U

I (7)

I / U

Transportation Profile

Other Carrier Capabilities

 

I / U

I / U

Transportation Profile

Out of Service

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Out of Service Date

I / U (3)

I / U (3)

I / U (3)

Transportation Profile

Overall Points

 

 

I / U

Transportation Profile

Overall Risk

I / U

I (7)

I / U

Transportation Profile

Provincial Authority

 

I / U (3)

 

Transportation Profile

Provincial Permit Number

 

I / U (3)

 

Transportation Profile

RMIS Carrier Payment Option

 

I / U

 

Transportation Profile

RMIS Certified

 

I / U

 

Transportation Profile

RMIS ID

 

I / U (3)

 

Transportation Profile

RMIS Non-Certified Reason

 

I / U

 

Transportation Profile

Safety Points

 

 

I / U

Transportation Profile

Safety Rating

I / U

I / U

I / U

Transportation Profile

Safety Rating Date

I / U

I / U

 

Transportation Profile

Safety Risk

I / U

I (7)

I / U

Transportation Profile

SCAC

 

I / U (3)

 

Transportation Profile

State DOT Number

I / U (3)

I / U (3)

 

Transportation Profile

State DOT State

 

I

 

Transportation Profile

Total Power Units

I / U (3)

I / U (3)

I

Transportation Profile

Total US Vehicle Inspections

I / U (3)

I / U (3)

I

Transportation Profile

US DOT Number

I / U (3)

I / U (3)

I

Transportation Profile

US State Coverage

 

I / U (4)

I / U (4)

Transportation Profile

W9 Address

 

I / U

I

Transportation Profile

W9 City

 

I / U

 

Transportation Profile

W9 State

 

I / U

 

Transportation Profile

W9 Postal Code

 

I / U

 

Transportation Profile

W9 Validated

 

I / U

 

Transportation Profile

Watchdog Reports

I / U

 

I

Table Guide:

I – Insert

U – Update

(1) => update if the global setting “Allow Carrier Address Updates” is checked OR the value in the TMS field is null

(2) – update if the value in the TMS field is null

(3) – update if there is a value in the response

(4) – update if there is a value in the response AND the value in the TMS field is null

(5) – update if the global setting “Carrier Remit To Sync” is checked AND the response has factor company information

(6) – update to ‘Pending’ if RMIS Certified is not ‘Yes’

(7) – set to ‘Pending’ by the TMS