TDI field mapping tables - Carrier

Before starting an upload, be sure to review the information in the Introduction to TDI and Importing data with TDI articles and follow the provided guidance.

Mandatory file:

Optional files:

Prerequisites:

We recommend uploading the Parent, Users, and Factor entities first. Some columns within the Carrier entity’s fields reference IDs found in these entities. If they are not uploaded first, these fields will be left blank and you will need to link Carrier accounts to their respective parent and user accounts from within the Turvo UI at a later time. An entity cannot reference information from another entity if that entity has not already been uploaded.

Note: If you have a single contact that is assigned to multiple Carrier accounts, uploading the Contact entity prior to uploading the Carrier entity will provide the contact IDs necessary for the primaryContact column in carrier.csv. If this is not the case, uploading the Contact entity later and assigning contacts to Carrier accounts at that time is recommended.

Important note: Fields bolded and marked with an asterisk (*) are mandatory.

Filename: carrier.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

Unique system ID for the Carrier entity. This ID is used anytime to make updates or to associate additional details to the Carrier using TDI. 

If you do not have an existing ID to use in this field, you will need to create one.

Required.

Important note: The ID in this field must be the Carrier DOT #. This ensures the carrier data integrations sync properly.

IDs cannot not contain spaces or special characters.

name*

The Carrier’s name.

-

Required.

No character restrictions.

parentAccount

Enter the Parent account ID if you would like to associate the Carrier with a Parent account.

Parent Account IDs can be found in the ID column of the parent.csv upload sheet. 

-

Must match the Parent account's ID exactly, if entered.

dot

The Carrier’s DOT number.

-

Either a DOT or MC number is needed to create a carrier.

Must be unique for each carrier.

mc

The Carrier’s MC number.

-

Either a DOT or MC number is needed to create a carrier.

Must be unique for each carrier.

arb

The Carrier’s California Air Resources Board (CARB) certification number.

-

-

No character restrictions.

taxid

The unique tax ID for the Carrier account.

-

-

No character restrictions.

scac

The SCAC number(s) associated with the Carrier.

-

Provide all SCACs. Each will be unique to the carrier.

List all SCAC IDs, separated by commas with no spaces, closed in brackets. 

Format: [scac1,scac2]

addressLine1

The first line of the Carrier’s primary address.

-

-

No character restrictions.

addressLine2

The second line of Carrier’s primary address, such as a unit number (if applicable).

-

-

No character restrictions.

addressCity

The name of the carrier address's city.

-

Required if entering an address.

No character restrictions.

addressState

The name or abbreviation of the carrier address's state/province.

-

Required if entering an address.

No character restrictions.

addressZip

The zip code or postal code in the carrier’s primary address.

-

Required if entering an address.

No character restrictions. Must be a valid zip code.

Examples:
72748
72748-9067
M5V 3T4

addressCountry

The country name in the carrier’s primary address.

Enter the name of the country, not the country code.

-

No character restrictions

phone

The primary phone number for the carrier. This will appear under the Carrier account’s Details tab > General > Profile segment.

-

-

Integers only. No dashes or parentheses.

Example: 3135551500

phoneExt

The extension of the phone number, if required.

-

Only applicable if adding a phone number.

Numbers only. No dashes or other characters.

phoneCountry

The phone number’s country code.

Enter the two-letter country code found in the Country codes table.

Required if adding a  phone number.

Examples:

US

CA

email

The primary contact email for the carrier.

-

 

No character restrictions.

primaryContact

The Contact ID for the Carrier’s primary contact.

If the Contact entity was uploaded before the Carrier entity, contact IDs can be found in the ID column of the contact.csv spreadsheet. 

If the Contact entity was not uploaded before the Carrier entity, leave blank.

Must match the Contact account's ID exactly, if entered.

url

The Carrier’s website.

-

-

No character restrictions.

commonAuthority

Indicates whether the Carrier has common operating authority.

  • Active
  • Inactive
  • None

-

Enter the appropriate value from the Value/codes column.

contractAuthority

Indicates whether the Carrier has contract operating authority.

  • Active
  • Inactive
  • None

-

Enter the appropriate value from the Value/codes column.

brokerAuthority

Indicates whether the Carrier has broker operating authority. 

  • Active
  • Inactive
  • None

-

Enter the appropriate value from the Value/codes column.

billingPhone

The phone number for billing-related work. This will appear under the Details tab > Billing contact section.

-

-

Numbers only. No dashes or parentheses.

Example: 3135551500

billingPhoneExt

The extension of the phone number, if required.

-

Only applicable  if adding a Billing phone number.

Numbers only. No dashes or other characters.

billingPhoneCountry

The phone number’s country code.

Enter the two-letter country code found in the Country codes table.

Required if adding a Billing phone number.

Examples:

US

CA

billingFax

The fax number for billing-related work. This appears under the Details tab > Billing contact section.

-

-

Numbers only. No dashes or other characters.

billingEmail

The email for billing-related work. This appears under the Details tab > Billing contact section.

-

-

Standard email address format.

billingContact

The Contact ID for the Carrier’s billing contact. This appears under the Details tab > Billing contact section.

If the Contact entity was uploaded before the Carrier entity, contact IDs can be found in the ID column of the contact.csv spreadsheet. 

If the Contact entity was not uploaded before the Carrier entity, leave blank.

Must match the Contact account's ID exactly, if entered.

claimsPhone

The Carrier’s phone number for claims-related work. This will appear under the Details tab > Claims contact section.

-

-

Numbers only. No dashes or parentheses.

Example: 3135551500

claimsPhoneExt

The extension of the phone number, if required.

-

Only applicable  if adding a Claims phone number.

Numbers only. No dashes or other characters.

claimsPhoneCountry

The country associated with the carrier’s claims-related phone number.

Enter the two-letter country code found in the Country codes table.

Required if adding a Claims phone number.

Examples:

US

CA

claimsFax

The fax number for claims-related work. This will appear under the Details tab > Claims contact section.

-

-

Numbers only. No dashes or other characters.

claimsEmail

The carrier’s email for claims-related work. This will appear under the Details tab > Claims contact section.

-

-

No character restrictions.

claimsContact

The Contact ID for the carrier’s claims contact. This will appear under the Details tab > Claims contact section.

If the Contact entity was uploaded before the Carrier entity, contact IDs can be found in the ID column within the contact.csv spreadsheet. 

If the Contact entity was not uploaded before the Carrier entity, leave blank.

Must match the Contact account's ID exactly, if entered.

status

The Carrier’s account status.

Created: 2250

Active: 2252

Inactive: 2253

Suspended: 2254

-

Enter the appropriate four-digit code, as listed in the Value/codes column.

notes

Enter any notes on the status of the account.

-

-

No character restrictions.

transportationMode*

The primary mode that this Carrier supports.

  • Rail
  • Ocean
  • Air
  • TL
  • Drayage
  • LTL
  • Parcel
  • Intermodal

Required.

Any additional transportation modes supported by the Carrier will be configured in the transportation.csv file.

Enter the name of the primary mode supported by the Carrier as listed in the Values/codes column.

serviceType*

The primary service type offered by the Carrier (such as TL - Standard, TL - Expedited, etc.).

Service types/Transportation types by mode table

Required. Additional service types will be configured in the service.csv file.

Enter the name of the primary service type offered by the Carrier using the table linked in the Values/codes column.

equipmentType

The primary equipment type used by the Carrier.

Equipment type codes

Additional equipment types will be configured in the equipment.csv file.

Enter the four or five-digit code for the Carrier’s primary equipment type using the table linked in the Value/codes column.

equipmentSize

The size of the primary equipment used by the Carrier.

Equipment size codes

Sizes for additional equipment types will be configured in the equipment.csv file.

Enter the corresponding four-digit code for the size of the carrier’s primary equipment type using the table linked in the Value/codes column.

equipmentQty

The quantity of the Carrier’s primary equipment type.

-

If multiple equipment types are used, the quantities for each will be configured in the equipment.csv file.

Numbers only. 

equipmentService

The equipment service the Carrier supports (such as Hazmat, Drop Trailer, etc.).

Equipment service codes

Important note: Only one equipment service can be added in this field. Because no equipment services field is available in the equipment.csv optional file, additional services need to be manually added to the Carrier at this time.

Find and enter the corresponding five-digit code for the equipment service using the table linked in the Value/codes column.

 

paymentMethod

The Carrier’s primary payment method. 

Paper check: 1700

COMCHEK: 1701

ACH: 1702

Factoring company: 1703

EFS: 1704

Wire: 1705

Additional payment methods will need to be configured in the payment_method.csv file.

Enter the four-digit code for the Carrier’s primary payment method as listed in the Value/codes column to the left.

payTo

The name the payment is addressed to.

-

When payment is done through a factoring company, use the factoring company’s name.

Applicable to payment methods: ACH, Paper check, Wire, ACH-1-Day

No character restrictions.


 

bankName

The name of the bank the payment is sent to.

-

Required if the p

Required if the paymentMethod field contains the code for ACH.

Applicable to payment methods: ACH, Wire, ACH-1-Day 

No character restrictions.

routingNumber

The routing number for the bank account the payment is sent to.

-

Required if the paymentMethod field contains the code for ACH.

Applicable to payment methods: ACH, Wire, ACH-1-Day 

No character restrictions.

accountNumber

The account number for the bank account the payment is sent to.

-

Required if the paymentMethod field contains the code for ACH.

Applicable to payment methods: ACH, Wire, ACH-1-Day 

No character restrictions.

factoringCompany

If the payTo column indicates a factoring company, enter the corresponding Factor ID.

Find and enter the reference ID for the Factor in the ID column of the factor.csv upload sheet.

-

Must match the Factor account's ID exactly, if entered.

bankAccountType

The type of bank account the payment is sent to.

Applicable to payment methods: ACH, Wire, ACH-1-Day

Savings: 1751

Checking: 1752

-

Enter the appropriate code from the Value/codes column.

paymentAddress.line1

The first line of the payment address.

-

Required if the paymentMethod field contains the code for Paper check.

Additional payment methods and payment addresses will need to be configured in the payment_method.csv file. 

No character restrictions.

paymentAddress.line2

The second line of the payment address (if applicable).

-

-

No character restrictions.

paymentAddress.city

The name of the city in the payment address.

-

Required if the paymentMethod field contains the code for Paper check.

No character restrictions.

paymentAddress.state

The name or abbreviation of the state/province in the carrier’s payment address.

-

Required if the paymentMethod field contains the code for Paper check.

No character restrictions.

paymentAddress.zip

The zip code or postal code in the payment address.

-

Required if the paymentMethod field contains the code for Paper check.

No character restrictions. Must be a valid zip code.

Examples:
72748
72748-9067
M5V 3T4

paymentAddress.country

The country name in the payment address.

Enter the name of the country, not the country code.

Required if the paymentMethod field contains the code for Paper check.

No character restrictions. 

paymentTerm

The payment term used for the Carrier. 

Standard28days: 7000

5daysquickpay: 7001

1dayquickpay: 7002

Important note: If your tenant has custom payment terms (or terms that do not match the standard codes in the previous column), your codes will be tenant-specific. Contact your Turvo representative for your codes.

Enter the corresponding four-digit code for the Carrier’s payment term as listed in the Values/Codes column to the left.

 

advancesAllowed

Indicate whether advances are allowed for the Carrier.

True/False

-

Enter True if advances are allowed or False if they are not.

dispatchersPermitted

Indicate whether dispatchers are allowed to receive advances. 

True/False

-

Enter True if dispatchers are allowed to receive advances or False if they are not.

driversPermitted

Indicate whether drivers are allowed to receive advances. 

True/False

-

Enter True if drivers are allowed to receive advances or False if they are not.

accountingSystem

The accounting system used by the Carrier.

Xero: 14000

Netsuite: 14003

CARMS: 14005

QuickBooks Online: 14006

Dynamics GP: 14007

-

Enter the appropriate five-digit code for the accounting system as listed in the Value/codes column to the left.

accounting.type

The ID type for the accounting system.

GL Code: 9801

Cost center: 9802

Account: 9804

Xero ID: 9805

Netsuite ID: 9806

QuickBooks Online ID: 9807

Dynamics GP ID: 9808

-

Enter the appropriate four-digit code for the accounting ID type as listed in the Value/codes column to the left.

accounting.value

Enter the ID value for the Carrier’s Accounting system ID (EX: 123ABC). This will appear in the Details tab > Accounting section of the Carrier’s profile. 

-

-

No character restrictions.

accountOwner

The User ID for the account owner of the Carrier’s Turvo profile.

User IDs can be found in the ID column of the user.csv upload sheet.

-

Must match the account owner's User's ID exactly, if entered.

user

The User ID for the user who receives commissions for booking the carrier.

User IDs can be found in the ID column of the user.csv upload sheet.

-

Must match the user's ID exactly, if entered.

 

userCommission

The commission, in percentage, received by the user.

-

Required.

Enter the percentage as a decimal value.

Example: If the user's commission is 5%, enter 0.05.

Filename: communicaton_channel.csv

Note: If the carrier accounts added via the carrier.csv file only include one set of contact information for each column, this file is not required. If a carrier has multiple addresses, phone numbers, email addresses, etc., that need to be associated with it, treat this file as required.

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where a communication channel is connected to a Carrier account.

If you do not have an existing ID to use in this field, you will need to create one.

Required.

IDs cannot not contain spaces or special characters.

contextId*

This ID corresponds to the Carrier that this contact information should be associated with.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

email.type

The type of email used by the Carrier.

Main: 1080

Other: 1081

Billing: 1082

Claims: 1083

Offers: 1084

Required if entering an email.

Enter the appropriate code from the Value/codes column. 

email

The email for the Carrier.

-

-

Standard email address format. 

phone.type

The type of phone number (work, home, etc.).

Main: 1020

Fax: 1021

After hours: 1022

Other: 1023

Billing: 1025

Claims: 1026

Required if entering a phone number.

Enter the appropriate code from the Value/codes column.

phone

Phone number for the Carrier contact.

-

-

Numbers only. No dashes or parentheses.

Example: 3135551500

phone.extension

Extension for the phone number above.

-

-

Numbers only. No dashes or other characters.

phone.country

The country associated with the Carrier contact’s phone number.

Enter the two-letter country code found in the Country codes table.

-

Examples:

US

CA

address.type

Indicate the type of address for the contact.

Main: 1143

Other: 1144

Mailing: 1140

Physical: 1141

Billing: 1145

Claims: 1146

Required if entering an address.

Enter the appropriate code from the Value/codes column.

address.line1

The first line of the Carrier’s address.

-

-

No character restrictions.

address.line2

The second line of Carrier’s address, such as a unit number (if applicable).

-

-

No character restrictions.

address.city

The name of the carrier address's city.

-

Required if entering an address.

No character restrictions.

address.state

The name or abbreviation of the carrier address's state/province.

-

Required if entering an address.

No character restrictions.

Examples:

California

CA

address.zip

The zip code or postal code in the carrier’s address.

-

Required if entering an address.

No character restrictions. Must be a valid zip code.

Examples:
72748
72748-9067
M5V 3T4

address.country

The country name in the carrier’s primary address.

Enter the name of the country, not the country code.

-

No character restrictions. 

isPrimaryAddress

Indicates whether this is the primary address for the Carrier.

True/False

 

Enter True if the address is the primary or False if it is not.

isPrimaryEmail

Indicates whether this is the primary email address for the Carrier.

True/False

 

Enter True if the email address is the primary or False if it is not.

isPrimaryPhone

Indicates whether this is the primary phone number for the Carrier.

True/False

 

Enter True if the phone number is the primary or False if it is not.

Filename: insurance.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where a Carrier’s insurance details are added to a carrier account. This ID is used anytime you would like to make updates or when associate additional insurance details using TDI.

If you do not have an existing ID to use in this field, you will need to create one.

Required.

IDs cannot not contain spaces or special characters.

contextId*

The Carrier ID for the associated Carrier.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

type* 

The type of insurance held by the Carrier.

Cargo: 1800

Liability: 1801

Refrigeration breakdown: 1802

Worker's compensation: 1803

Required.

Enter the four-digit code for the insurance type as listed in the Value/codes column.

amount*

The dollar amount of insurance coverage on the policy.

-

Required.

Numbers only.  

expirationDate*

The insurance’s expiration date. 

-

Required.

Format: YYYY-MM-DD

provider*

The insurance provider.

-

Required.

No character restrictions. 

producer

The Agency/Agent that develops this insurance.

-

-

No character restrictions. 

notes

A free form text field where any notes on the insurance coverage should be added.

-

-

No character restrictions.

policyNo*

The insurance policy number.

-

Required.

No character restrictions. 

state

The insurance policy’s state of issue.

-

-

No character restrictions. 

hasReeferBreakdown

Indicates whether the policy has coverage for the breakdown of refrigerated equipment.

True/False

Only applicable if the type field's value is code for Cargo.

 

Enter True if the insurance has Reefer Breakdown coverage or False if it does not.

Filename: equipment.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where equipment details are added to a carrier account. This ID is used anytime you would like to make updates or associate additional equipment using TDI. 

If you do not have an existing ID to use in this field, you will need to create one.

Required.

IDs cannot not contain spaces or special characters.

contextId*

The Carrier ID for the Carrier associated with the equipment.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

equipment.type*

The type of equipment.

Equipment type codes

Required.

Find and enter the four- or five-digit code for the equipment type using the table linked in the Value/codes column.

equipment.size*

The size of the equipment.

Equipment size codes

Required.

Find and enter the four-digit code for the size of the equipment type using the table linked in the Value/codes column.

qty*

The quantity of the specified equipment type that the Carrier owns.

-

Required.

Numbers only. 

 

Filename: payment_method.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where payment methods are added to a carrier account. This ID is used anytime you would like to make updates or associate additional payment methods using TDI. 

If you do not have an existing ID to use in this field, you will need to create one.

Required.

IDs cannot not contain spaces or special characters.

contextId*

The Carrier ID for the Carrier associated with the payment method.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

type.code*

The Carrier’s payment method.

Paper check: 1700

COMCHEK: 1701

ACH: 1702

Factoring company: 1703

EFS: 1704

Wire: 1705

Required.

Enter the appropriate code from the Value/codes column.

payTo

The name the payment is addressed to.

-

Applicable if the typeCode field contains the code for ACH, Paper check, or Wire.

No character restrictions.

When payment is done through a factoring company, use the factoring company’s name. 

bankName

The name of the bank the payment is sent to.

-

Applicable if the typeCode field contains the code for ACH or Wire.

No character restrictions.

routingNumber

The routing number for the bank account the payment is sent to.

-

Applicable if the typeCode field contains the code for ACH or Wire.

No character restrictions.

accountNumber

The account number for the bank account the payment is sent to.

-

Applicable if the typeCode field contains the code for ACH or Wire.

No character restrictions.

factor.id

The Factor ID, if a factoring company is used for the payment method.

Factor IDs can be found in the ID column of the factor.csv upload sheet. 

-

No character restrictions.

accountType.code

The type of bank account the payment is sent to.

Savings: 1751

Checking: 1752

Applicable if the typeCode field contains the code for ACH or Wire.

Enter the appropriate code from the Value/codes column.

address.line1*

The first line of the payment address.

-

Required if the typeCode field contains the code for Paper check.

No character restrictions.

address.line2

The second line of payment address (if applicable).

-

-

No character restrictions.

address.city*

The name of the payment address city.

-

Required if the typeCode field contains the code for Paper check.

No character restrictions.

address.state*

The name or abbreviation of the payment address state/province.

-

Required if the typeCode field contains the code for Paper check.

No character restrictions.

Examples:

California

CA

address.zip*

The zip code or postal code.

-

Required if the typeCode field contains the code for Paper check.

No character restrictions. Must be a valid zip code.

Examples:
72748
72748-9067
M5V 3T4

address.country

Name of country.

Enter the name of the country, not the country code.

-

No character restrictions. 

 

Filename: payment_term.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where payment terms are added to a carrier account. This ID is used anytime you would like to make updates or associate additional payment terms using TDI. 

If you do not have an existing ID to use in this field, you will need to create one.

Required.

IDs cannot not contain spaces or special characters.

contextId*

The Carrier ID for the Carrier associated with the payment method.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

paymentTerm*

The payment term used for the Carrier. 

Standard28days: 7000

5daysquickpay: 7001

1dayquickpay: 7002

Important note: If your tenant has custom payment terms (or terms that do not match the standard codes in the previous column), your codes will be tenant-specific. Contact your Turvo representative for your codes.

Enter the corresponding four-digit code for the Carrier’s payment terms as listed in the Values/Codes column.

 

isDefault

Indicates whether the payment term is the default. 

True/False

-

Enter True if the payment term is the default or False if it is not.

isActive*

Indicates whether the payment term is active. 

True/False

Required.

Enter True if the payment term is active or False if it is not.

paymentMethods*

All accepted payment methods for the payment term.

Paper check: 1700

COMCHEK: 1701

ACH: 1702

Factoring company: 1703

EFS: 1704

Wire: 1705

Required.

List all applicable codes from the Values/Codes column for the payment methods that are accepted for the payment term. List them inside brackets, separated by commas with no spaces.

Format: [ID1,ID2,ID3]

 

Filename: service.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where offered services are added to a carrier account. This ID is used anytime you would like to make updates or associate additional services using TDI. 

If you do not have an existing ID to use in this field, you will need to create one.

Required.

IDs cannot not contain spaces or special characters.

contextId*

The Carrier ID for the Carrier offering the service.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

 

service.code*

The type of service offered by the Carrier.

Carrier service codes

Required.

Only one service can be added to a carrier per row.

Use the table linked in the Value/codes column to find the service. Enter the corresponding four-digit code.

 

Filename: lane.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where lanes covered by the carrier are added to the carrier account. This ID is used anytime you would like to make updates or associate additional lanes using TDI. 

If you do not have an existing ID to use in this field, you will need to create one.

Required.

IDs cannot not contain spaces or special characters.

contextId*

The Carrier ID for the Carrier associated with the payment method.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

origin.city*

The name of the lane’s city of origin.

-

Required.

No character restrictions. 

origin.state*

The name of the lane’s state of origin.

-

Required.

No character restrictions. 

destination.city*

The name of the lane’s destination city. 

-

Required.

No character restrictions. 

destination.state*

The name of the lane’s destination state.  

-

Required.

No character restrictions. 

costType*

The type of cost associated with the lane.

Lane cost type codes

Required.

Enter one of the five-digit codes between 23000 and 23021 for the cost type associated with the lane using the table linked in the Value/codes column.

price*

The price of the cost associated with the lane.

-

Required.

Numbers with decimals allowed.

priority*

The priority of the lane.

Primary: 22200

Secondary: 22201

Backup: 22202

None: 22203

Required.

Enter the five-digit code for the lane's priority as listed in the Value/codes column.

 

Filename: settings.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where the capacity provider account code of the carrier in P44 VOC is set up in TDI.

If you do not have an existing ID to use in this field, you will need to create one.

Required.

IDs cannot not contain spaces or special characters.

contextId*

The Carrier ID for the Carrier associated with the P44 VOC Carrier credentials settings.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

entityId*

The Carrier or Customer ID for the entity with whom the Carrier uses P44 for LTL rating.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Customer IDs can be found in the ID column of the customer.csv upload sheet.

Required.

Must match the Carrier or Customer account's ID exactly.

entityType*

Indicates whether the entity named in the entityId column is a customer or carrier.

customer

carrier

Required.

Enter customer if the ID entered in entityId is a customer or carrier if a carrier.

accountId

The P44 account ID associated with the Customer or Carrier entity.

-

-

No character restrictions. 

role

The role of the entity identified in the entityId column within P44.

Shipper: 21500

Consignee: 21501

Third Party: 21502

-

Enter the appropriate code from the Value/codes column.

scac

The Carrier’s SCAC code.

-

-

No character restrictions. 

userName

The user name for the P44 LTL rating service account.

_

-

No character restrictions. 

password

The password for the P44 LTL rating service account.

_

-

No character restrictions. 

key

The API access token for the p44 carrier account. 

_

-

No character restrictions. 

 

Filename: externalids.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where an external ID is added to the Carrier account. This ID is used anytime you would like to make updates or associate additional External IDs using TDI. 

If you do not have an existing ID to use in this field, you will need to create one. 

Required.

IDs cannot not contain spaces or special characters.

contextId*

The Carrier ID for the carrier associated with the External ID.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

type*

The type of External ID.

CRM ID: crm_id

ERP ID: erp_id

Project ID: project_id

Contract ID: contract_id

Other: other_id

Required.

Enter the one of the values listed in the Values/Codes column to the right. If the type is CRM, enter "crm_id" (without quotations).

value*

The actual external ID to be added to the Carrier’s profile in Turvo. This allows you to see additional IDs in Turvo and easily use those to search in external databases.

-

Required.

No character restrictions

 

Filename: account_distribution.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where the Carrier’s account distribution details are configured. This ID is used anytime you would like to make updates or associate additional account distribution details using TDI. 

If you do not have an existing ID to use in this field, you will need to create one. 

Required.

IDs cannot not contain spaces or special characters.

contextId*

The Carrier ID for the carrier associated with the account.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

accountingSystem*

The accounting system used by the Carrier.

Xero: 14000 QuickBooks: 14001

Netsuite: 14003

Turvo: 14004

CARMS: 14005

QuickBooks Online: 14006

Required.

Enter the appropriate code from the Value/codes column.

accounting.id*

Indicates the Value/ID for the type selected in the accountingSystem column.

-

Required.

No character restrictions. 

accounting.type*

The ID type for the accounting system.

GL Code: 9801

Cost center: 9802

Account: 9804

Xero ID: 9805

Netsuite ID: 9806

QuickBooks Online ID: 9807

Dynamics GP ID: 9808

Required.

Enter the appropriate code from the Value/codes column.

accounting.value*

Indicates the Value/ID for the type selected in the accounting.type column.

-

Required.

No character restrictions.

 

Filename: user_commissions.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where the commission details for booking the Carrier are configured. This ID is used anytime you would like to make updates or associate additional commission details using TDI. 

If you do not have an existing ID to use in this field, you will need to create one.

Required.

IDs cannot not contain spaces or special characters.

contextId*

The Carrier ID for the carrier that the user receives commissions for booking.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

user*

The User ID for the user receiving commissions for shipments booked with the carrier.

User IDs can be found in the ID column of the user.csv upload sheet.

Required.

Must match the User's account ID exactly.

 

user.Commission*

The commission, in percentage, received by the user for shipments booked with the carrier.

-

Required.

Numbers with decimals allowed.

 

Filename: transportation.csv

Field

Description

Values/codes

Conditions

Format/restrictions

id*

This serves as the unique ID for the row in this upload sheet where the transportation type supported by the Carrier is configured. This ID is used anytime you would like to make updates or associate additional transportation types using TDI. 

If you do not have an existing ID to use in this field, you will need to create one.

Required.

IDs cannot not contain spaces or special characters.

contextId*

The Carrier ID associated with the transportation method.

Carrier IDs can be found in the ID column of the carrier.csv upload sheet.

Required.

Must match the Carrier account's ID exactly.

mode*

The mode that this Carrier supports.

  • Rail
  • Ocean
  • Air
  • TL
  • Drayage
  • LTL
  • Parcel
  • Intermodal
Required.

Enter the name of the mode supported by the Carrier from the listed modes in the Value/codes column.

type*

The service type offered by the Carrier.

Service types/Transportation types by mode

Required.

Enter the name of the service type associated with the mode that is offered by the Carrier using the table linked in the Value/codes column.

isPrimary

Indicates whether the transportation type in the type column is the primary for the Carrier.

True/False

-

Enter True if the type is the primary or False if they are not.

 

Was this article helpful?

0 out of 0 found this helpful