Before starting an upload, make sure you have read the information available in the Introduction to TDI and Importing data with TDI articles and followed the guidance provided.
Mandatory file:
Optional file:
- None
Prerequisites:
None required. However, because assets are typically associated with a carrier, we recommend uploading the Carrier entity first, as well as the entities that should be uploaded before Carrier.
Important note: Fields bolded and marked with an asterisk (*) are mandatory.
Filename: asset.csv
|
Field |
Description |
Values/codes |
Format/restrictions |
|
id* |
Unique system ID for the asset within the Asset entity. This ID is used anytime you would like to make updates or changes to the asset in TDI or when using TDI to associate additional details to the asset. If you do not have an existing ID to use in this field, you will need to create one. |
_ |
Important note: ID cannot contain any spaces. |
|
vehicle_type* |
Indicates the vehicle type. |
Use the table linked in the Value/codes column. Enter the corresponding four-digit code to designate the vehicle type. |
|
|
vin |
Vehicle Identification Number. |
_ |
No character restrictions. |
|
notes |
Notes or additional details about the asset. |
_ |
No character restrictions. |
|
account.id |
The Carrier ID for the carrier that the asset belongs to. |
_ |
No character restrictions. Carrier IDs can be found in the ID column of the carrier.csv upload sheet. |
|
license.number |
License plate number. |
_ |
No character restrictions. |
|
license.country |
License plate country. |
Examples: US: United States CA: Canada |
Enter the two-letter country code found in the Country codes table. |
|
license.state |
License plate state. |
_ |
No character restrictions. |
|
asset.number |
The asset number used to identify the asset. |
_ |
No character restrictions. Note: If you are configuring a telematics integration, this number may need to match the asset number in your telematics platform. |
|
make |
Vehicle make. |
_ |
No character restrictions. |
|
model |
Vehicle model. |
_ |
No character restrictions. |
|
size |
Trailer size. |
Enter the corresponding four-digit code to designate the asset’s size. Use the table linked in the Value/codes column. |
|
|
class |
Asset class. |
Enter the corresponding five-digit code to designate the asset’s class. Use the table linked in the Value/codes column. |
|
|
color |
Asset color. |
_ |
No character restrictions. |
|
weight |
Enter the weight of the asset. |
_ |
Integers only. Units of measure are automatically selected based on your tenant’s locale. |
|
status |
Indicates the asset’s availability status. Availability determines whether the asset can be booked on a shipment. |
AVAILABLE UNAVAILABLE |
Enter AVAILABLE to indicate it is available to be booked on shipments. Enter UNAVAILABLE to indicate it cannot be booked. |
|
sensor.provider |
If you have configured a telematics integration with a supported provider, the provider is indicated here. |
Enter the code that corresponds to the linked telematics provider. Only one telematics integration can exist per tenant. Use the table linked in the Value/codes column. |
|
|
sensor.deviceId |
A custom ID code that is generated and managed by Turvo for each sensor device. |
_ |
No character restrictions. |
|
sensor.customId |
Sensor ID of the telematics tracking device. |
_ |
No character restrictions. Note: This is not required for some integrations. See Connecting to telematics providers in Turvo to look up what is required for your provider. |
|
mode |
The mode of transport associated with the equipment. |
Rail Ocean Air TL Drayage LTL Parcel |
Enter the mode option that corresponds to the mode of transport for the shipment. If no mode is provided, the mode will default to TL. |
|
vesselName |
Indicates the name of the vessel for Ocean assets. |
- |
No character restrictions. |
|
mmsi |
Indicates the Maritime Mobile Service Identity (MMSI) associated with Ocean assets. |
- |
No character restrictions. |
|
imo |
Indicates the International Maritime Organization (IMO) number associated with Ocean assets. |
- |
No character restrictions. |
|
mbl |
Indicates the Master Bill of Lading number. |
- |
No character restrictions. |
|
containerNumber |
Indicates the container number associated with a container asset. |
- |
No character restrictions. |
<%= heading %>