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:

carrier.csv

Optional files:

communication_channel.csv
insurance.csv
equipment.csv
payment_method.csv
payment_term.csv
service.csv
lane.csv
settings.csv
externalids.csv
account_distribution.csv
user_commissions.csv
transportation.csv

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 QuickBooks: 14001 Netsuite: 14003 Turvo: 14004 CARMS: 14005 QuickBooks Online: 14006	-	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.

TDI field mapping tables - Carrier

Mandatory file:

Optional files:

Prerequisites:

Filename: carrier.csv

Filename: communicaton_channel.csv

Filename: insurance.csv

Filename: equipment.csv

Filename: payment_method.csv

Filename: payment_term.csv

Filename: service.csv

Filename: lane.csv

Filename: settings.csv

Filename: externalids.csv

Filename: account_distribution.csv

Filename: user_commissions.csv

Filename: transportation.csv

Was this article helpful?

Sections in this article

<%= heading %>

<%= block.name %>

Featured Articles

Categories

Toggle navigation menu

Search

Mandatory file:

Optional files:

Prerequisites:

Filename: carrier.csv

Filename: communicaton_channel.csv

Filename: insurance.csv

Filename: equipment.csv

Filename: payment_method.csv

Filename: payment_term.csv

Filename: service.csv

Filename: lane.csv

Filename: settings.csv

Filename: externalids.csv

Filename: account_distribution.csv

Filename: user_commissions.csv

Filename: transportation.csv

Was this article helpful?

Sections in this article

<%= heading %>

<%= block.name %>

Featured Articles

Categories

Toggle navigation menu

Categories

Categories