Import Data
The Import Data function allows you to import a new set of Carrier and Service, Equipment and Rates and Lanes data. The upload format for this file is an Excel workbook with three separate spreadsheets “Carrier and Service”, “Equipment” and “Rates and Lanes.” The data format for each of these spreadsheets is as follows:
Carrier and Service
|
Field Name |
Description |
Required |
|---|---|---|
|
Carrier |
TM Carrier Code |
Yes |
|
Service |
TM Service Code (TL, LTL, IM or EXPT) |
Yes |
|
Type |
Tariff type indicator (TL-Flat, TL-Dist+Stop, LTL-Pallet, LTL-Weight, IM, Exception, or LTL-Czar |
Yes |
|
Effective Date |
Effective Date (MM/DD/YYYY) |
Yes |
|
Expiry Date |
Expiration Date (MM/DD/YYYY) |
Yes |
|
Send Tender via Email |
Send Tender via Email Boolean indicate (Y or N) |
Yes |
|
Respect Drivers Hours |
Respect Driver Hours Boolean indicator (Y or N) |
Required only for TL services |
|
SMC Version Code |
TM External Rating Engine Version |
Required only for LTL-Czar tariff types |
|
Dimensional Weight Factor |
Dimensional Weight |
Required only for LTL-Weight tariff types |
|
Max Stops |
Maximum Stops allowed (0,1 or 2) |
Required only for TL-Dist+Stop |
|
Cost per Stop |
Cost per Stop |
Required only for TL-Dist+Stop |
Equipment
|
Field Name |
Description |
Required |
|---|---|---|
|
Equipment ID |
TM Equipment Type Code |
Yes |
|
Max Weight |
Maximum Weight |
Yes |
|
Max Volume |
Maximum Volume |
Yes |
|
Max Pallet |
Maximum Pallet |
Yes |
|
Priority |
Equipment priority |
Yes |
Rates and Lanes
|
Field Name |
Description |
Required |
|---|---|---|
|
Carrier |
TM Carrier Code |
Yes |
|
Service |
TM Service Code (TL, LTL, IM or EXPT) |
Yes |
|
Origin Zone |
TM Origin Zone |
Yes |
|
Destination Zone |
TM Destination Zone |
Yes |
|
Transit Time |
Transit Time |
Required only for LTL and IM |
|
Equipment Type |
TM Equipment Type Code |
Yes |
|
Range To |
Maximum units for rate |
Required for all tariff types except LTL-Czar |
|
Charge Type |
Type of units for rate |
Yes |
|
Rate |
Rate |
Required for all tariff types except LTL-Czar |
|
MinRate |
Minimum Rate |
No, it is optional for all tariff types except IM, Exception and TL-Flat for which it should not be entered. |
|
Czar Discount |
Czar Discount |
Required for LTL-Czar tariff types |
See Also