|
Contact Customer Service About Any Questions
Welcome to the developer documentation for our CSV File Download feature. If you have questions or would like the CSV File Download enabled for your account, please call (888) 411-9661 between 9:00 AM and 6:00 PM EST Monday through Friday. Access to this feature is disabled by default. It is only available to Carrier411 customers with an active account, and it is not available for trial accounts. This optional add-on feature can be enabled for an additional $49.00 per month. We reserve the right to allow access to the CSV File Download feature.
If you monitor thousands of carriers, then you know how time-consuming it can be to update records in your transportation software. Consider the consequences if you overlook updating certain carriers. Integration with Carrier411 using our CSV File Download feature can automate the update process, save you valuable time, improve efficiency, and help protect your business from using the wrong carriers.
As an alternative to our more robust Web Services Interface, we can provide access to a comma-separated values (CSV) file that gets created on demand. Compared to accessing data with our Web Services Interface, our CSV File Download feature provides an easier (but more limited) way to access information about companies monitored by your Carrier411 account. Carrier411 CSV file data provides the current authority status, insurance, carrier safety ratings and SMS BASIC information for you to integrate with your transportation software. Again, it provides information for all companies being monitored by your Carrier411 account.
In simple terms, your server communicates with our server. By scheduling one daily request to our CSV File Download feature, your software system can keep its database up-to-date automatically within a matter of seconds. You can also obtain information about the companies you monitor that have FreightGuard Reports using our FreightGuard Reports CSV File Download. Learn more about our integrated FreightGuard Reporting System.
CSV File Download Change Log
How to Initiate CSV File Download
You must have an active Carrier411 account, and the CSV File Download feature must be enabled for your account. When your server invokes the following URL string, a CSV file will be created at that moment. It will begin downloading automatically. CSV file creation may take between 5 seconds and 30 seconds, depending on the number of companies monitored by your Carrier411 account.
Information about FreightGuard Reports can be downloaded separately using our FreightGuard Reports CSV File Download.
URL String |
https://www.carrier411.com/createcsvfile.cfm?username=xxx&password=yyy
Substitute xxx with your Carrier411 username and yyy with your password.
Unless &header=0 (optional parameter) is specified in the above URL string, a file header row will be included in the CSV file by default.
|
Schedule |
Schedule your server to invoke the above URL string one time only in the morning, between 7:45 AM and 9:00 AM EST. Schedule this event every Monday through Friday morning. Do not download in the evening or night, because data is updated in the early morning. |
Purpose |
Creates comma-separated values (CSV) file upon request. Includes data (detailed below) for all the companies monitored by your Carrier411 account. |
Errors |
Any errors will produce a FaultCode when the URL string is invoked.
FaultCode 1: Username and password not provided.
FaultCode 2: Username not provided.
FaultCode 3: Password not provided.
FaultCode 4: Invalid username or password.
FaultCode 5: Account inactive.
FaultCode 6: Account suspended.
FaultCode 7: Trial accounts cannot download CSV files.
FaultCode 8: CSV file download not activated for account.
|
Parameters |
username -- Carrier411 username (Required).
password -- Carrier411 password (Required).
header -- 1 or 0 (Optional). Include &header=0 for no header row.
oos -- 1 or 0 (Optional). Include &oos=1 for out of service data.
census -- 1 or 0 (Optional). Include &census=1 for additional census data.
smartway -- 1 or 0 (Optional). Include &smartway=1 for SmartWay indicator.
carb -- 1 or 0 (Optional). Include &carb=1 for CARB TRU compliance indicator.
Please refer to the Optional URL Parameters and Possible Values section for more information.
|
CSV File Fields and Possible Values
The following 56 fields and possible values are contained in the CSV file. View Sample CSV File with Header Row.
1. DOCKET |
CHAR 8 |
Motor carrier (MC) number for the company. It may also be an FF or MX number for freight forwarders or Mexican carriers. |
2. USDOT |
NUMERIC 9 |
USDOT number for the carrier. Values may include 0 or NULL. |
3. LEGALNAME |
VARCHAR 120 |
Legal name of the company. |
4. DBANAME |
VARCHAR 60 |
Doing-Business-As (DBA) name for the company. |
5. ADDRESS |
VARCHAR 50 |
Business address for the company. |
6. CITY |
VARCHAR 30 |
City for the business address specified in ADDRESS. |
7. STATE |
CHAR 2 |
2-character state for the business address specified in ADDRESS. |
8. ZIP |
VARCHAR 10 |
Zip code for the business address specified in ADDRESS. Most zip codes are 5 digits. Some are zip plus 4. Others are international postal codes. |
9. PHONE |
VARCHAR 14 |
10-digit business phone number if provided. The value may be NULL. |
10. FAX |
VARCHAR 14 |
10-digit business fax number if provided. The value may be NULL. |
11. EMAIL |
VARCHAR 80 |
Possible Values: NULL or text. Email address for the company. |
12. TRUCKS |
VARCHAR 6 |
Possible Values: NULL or numeric value. Total number of "Power Units" operated by the carrier. |
13. COMMON |
CHAR 1 |
Common carrier authority status. Possible values: "A" for active common authority, "I" for inactive common authority or "N" for no common authority. |
14. CONTRACT |
CHAR 1 |
Contract carrier authority status. Possible values: "A" for active contract authority, "I" for inactive contract authority or "N" for no contract authority. |
15. BROKER |
CHAR 1 |
Broker authority status. Possible values: "A" for active broker authority, "I" for inactive broker authority or "N" for no broker authority. |
16. PENDCOMMON |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the company is applying for common carrier authority and is in the process of receiving it. |
17. PENDCONTRACT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the company is applying for contract carrier authority and is in the process of receiving it. |
18. PENDBROKER |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the company is applying for broker authority and is in the process of receiving it. |
19. REVCOMMON |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the company is pending revocation of its common carrier authority. It may soon lose authority. Yes does not mean they have lost their common carrier authority. Yes usually indicates the company is within 30 days of its insurance premium being due, and it remains unpaid. However, there are other reasons this warning flag may get raised. |
20. REVCONTRACT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the company is pending revocation of its contract carrier authority. It may soon lose authority. Yes usually indicates the company is within 30 days of its insurance premium being due, and it remains unpaid. However, there are other reasons this warning flag may get raised. |
21. REVBROKER |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the company is pending revocation of its broker authority. It may soon lose authority. Yes usually indicates the company is within 30 days of the premium being due for its broker bond, and it remains unpaid. However, there are other reasons this warning flag may get raised. |
22. BIPDREQ |
VARCHAR 10 |
BIPD is bodily injury property damage, more commonly known as liability insurance. If BIPD is required by the FMCSA, the minimum dollar amount of required coverage will be specified. If required, the minimum amount is usually 750000 ($750,000.00), but it could be higher. It could also be 0 (zero), if BIPD is not required. FMCSA requires companies with contract authority to have BIPD insurance. |
23. BIPDFILED |
VARCHAR 10 |
Indicates the dollar amount of liability insurance on file for the company, as reported to the FMCSA by insurance underwriters. Even though BIPD insurance may not be required, some companies will maintain a BIPD insurance policy. |
24. CARGOREQ |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the FMCSA requires the company to have cargo insurance. |
25. CARGOFILED |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether cargo insurance is on file for the company, as reported to the FMCSA by insurance underwriters. Even though cargo insurance may not be required, some companies will maintain a cargo insurance policy. |
26. BONDREQ |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the FMCSA requires the company to have a bond. FMCSA requires companies with broker authority to maintain a bond. |
27. BONDFILED |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether a broker bond is on file for the company, as reported to the FMCSA by insurance underwriters. |
28. INSAUTHUPDATED |
DATETIME |
Date formatted as mm/dd/yyyy indicates the date insurance and authority information about the company was last updated in our database. |
29. RATING |
CHAR 1 |
Possible Values: NULL or single letter. Indicates carrier safety rating. Possible safety ratings: U = Unsatisfactory, C = Conditional, S = Satisfactory. The safety rating was issued on the date specified in RATEDATE. |
30. RATEDATE |
DATETIME |
Possible Values: NULL or date. If the carrier has a carrier safety rating value specified in RATING, this is the date the carrier safety rating was issued formatted as mm/dd/yyyy. If the carrier has no safety rating, the value will be NULL. |
31. INSPTOTAL |
NUMERIC 9 |
Possible Values: NULL or number. Total number of inspections for the 24-month measurement period. |
32. DRIVINSPTOTAL |
NUMERIC 9 |
Possible Values: NULL or number. Number of driver inspections. |
33. DRIVOOSINSPTOTAL |
NUMERIC 9 |
Possible Values: NULL or number. Number of driver inspections with at least one driver out-of-service violation. |
34. VEHINSPTOTAL |
NUMERIC 9 |
Possible Values: NULL or number. Number of vehicle inspections. |
35. VEHOOSINSPTOTAL |
NUMERIC 9 |
Possible Values: NULL or number. Number of vehicle inspections with at least one vehicle out-of-service violation. |
36. UNSAFEDRIVPCT |
REAL 4 |
Possible Values: NULL or number. Unsafe Driving BASIC score percentile. Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4. |
37. UNSAFEDRIVRDALERT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the UNSAFEDRIVPCT score is over the threshold. |
38. UNSAFEDRIVSV |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the carrier has acute/critical violations from investigation for unsafe driving within the past 12 months. |
39. UNSAFEDRIVBASICALERT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the UNSAFEDRIVPCT score is over the threshold and/or if there are acute/critical violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category. |
40. HOSCOMPPCT |
REAL 4 |
Possible Values: NULL or number. HOS Compliance BASIC score percentile. Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4. |
41. HOSCOMPRDALERT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the HOSCOMPPCT score is over the threshold. |
42. HOSCOMPSV |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the carrier has acute/critical violations from investigation for HOS Compliance within the past 12 months. |
43. HOSCOMPBASICALERT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the HOSCOMPPCT score is over the threshold and/or if there are acute/critical violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category. |
44. DRIVFITPCT |
REAL 4 |
Possible Values: NULL or number. Driver Fitness BASIC score percentile. Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4. |
45. DRIVFITRDALERT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the DRIVFITPCT score is over the threshold. |
46. DRIVFITSV |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the carrier has acute/critical violations from investigation for driver fitness within the past 12 months. |
47. DRIVFITBASICALERT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the DRIVFITPCT score is over the threshold and/or if there are acute/critical violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category. |
48. CONTRSUBSTPCT |
REAL 4 |
Possible Values: NULL or number. Controlled Substances BASIC score percentile. Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4. |
49. CONTRSUBSTRDALERT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the CONTRSUBSTPCT score is over the threshold. |
50. CONTRSUBSTSV |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the carrier has acute/critical violations from investigation for controlled substances within the past 12 months. |
51. CONTRSUBSTBASICALERT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the CONTRSUBSTPCT score is over the threshold and/or if there are acute/critical violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category. |
52. VEHMAINTPCT |
REAL 4 |
Possible Values: NULL or number. Vehicle Maintenance BASIC score percentile. Numeric values range from 0 to 100. Scores may have one decimal place, such as 85.4. |
53. VEHMAINTRDALERT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the VEHMAINTPCT score is over the threshold. |
54. VEHMAINTSV |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the carrier has acute/critical violations from investigation for vehicle maintenance within the past 12 months. |
55. VEHMAINTBASICALERT |
CHAR 1 |
Possible values: "Y" for yes or "N" for no. Indicates whether the VEHMAINTPCT score is over the threshold and/or if there are acute/critical violations within the past 12 months. If value is "Y" the carrier has a BASIC alert for this category. |
56. CREATED |
DATETIME |
Date formatted as mm/dd/yyyy indicates the date CSV file was created. |
Optional URL Parameters and Possible Values
The following fields and possible values are contained in the CSV file depending on whether optional paramaters are included in the URL string.
URL String |
https://www.carrier411.com/createcsvfile.cfm?username=xxx&password=yyy&header=1&oos=1&census=1&smartway=1&carb=1
Substitute xxx with your Carrier411 username and yyy with your password.
|
Parameters |
header -- 1 or 0 (Optional). Include &header=0 for no header row.
oos -- 1 or 0 (Optional). Include &oos=1 for out of service data.
census -- 1 or 0 (Optional). Include &census=1 for additional census data.
smartway -- 1 or 0 (Optional). Include &smartway=1 for SmartWay indicator.
carb -- 1 or 0 (Optional). Include &carb=1 for CARB TRU compliance indicator.
|
OOSORDER |
CHAR 1 |
OOSORDER field is returned when &oos=1 is included in the URL string. Possible values: "Y" for yes or "N" for no. Indicates whether carrier has an Out of Service (OOS) Order. When an Out of Service (OOS) Order is issued by the FMCSA, the carrier is ordered to cease all motor vehicle operations regardless of operating authority status. Any carrier that has an Out of Service (OOS) Order should not be used until the FMCSA rescinds the OOS order. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file. |
OOSORDERDATE |
DATETIME |
OOSORDERDATE field is returned when &oos=1 is included in the URL string. Possible Values: NULL or date. If the carrier has an Out of Service (OOS) Order, this is the out of service "date" formatted as mm/dd/yyyy. The OOS date indicates when our system detected the order and is not necessarily the date the order was issued. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file. |
CENSUSTOTDRS |
VARCHAR 6 |
CENSUSTOTDRS field is returned when &census=1 is included in the URL string. Possible Values: NULL or numeric value. This value indicates the total number of "Drivers" working for the carrier. |
CENSUSMCS150DATE |
DATETIME |
CENSUSMCS150DATE field is returned when &census=1 is included in the URL string. Possible Values: NULL or Date formatted as mm/dd/yyyy. This is the date the carrier filed its most recent MCS-150 form with the FMCSA. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file. |
CENSUSMCS150MILEAGEYEAR |
INTEGER 4 |
CENSUSMCS150MILEAGEYEAR field is returned when &census=1 is included in the URL string. Possible Values: NULL or 4-digit year. This is the year for reported "Mileage" on the MCS-150 form. Even though there is census data and a year value exists for CENSUSMCS150DATE, this field may be NULL. This value is associated with the "Mileage" indicated in CENSUSMLG150. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file. |
CENSUSMLG150 |
INTEGER 4 |
CENSUSMLG150 field is returned when &census=1 is included in the URL string. Possible Values: NULL or number. This is reported "Mileage" on the MCS-150 form. Even though there is census data and a year value exists for CENSUSMCS150DATE, this field may be NULL. This value is associated with the CENSUSMCS150MILEAGEYEAR value. This field will be located between VEHMAINTBASICALERT and CREATED at the end of the CSV file. |
SMARTWAY |
CHAR 1 |
SMARTWAY field is returned when &smartway=1 is included in the URL string. Possible values: "Y" for yes or "N" for no. Indicates whether company is a SmartWay Transport Partner. |
CARBTRU |
CHAR 1 |
CARBTRU field is returned when &carb=1 is included in the URL string. Possible values: "Y" for yes or "N" for no. Indicates whether carrier is compliant with the CARB regulation for Transport Refrigeration Units. |
FreightGuard Reports CSV File Download
In addition to downloading information about the companies you monitor using the CSV File Download feature (documented above), you can also obtain and maintain information about the companies you monitor that have FreightGuard Reports.
The Carrier411 website has an integrated FreightGuard Reporting System that lets members report companies (carriers, brokers, freight forwarders) for performance issues based on a variety of designated criteria:
- • In-transit agreement modification
- • Operates under alias
- • Cancelled after accepting load
- • Persistent cancelling
- • Unresolved claim issues
- • Unethical or deceptive business practices
- • Repeated pickup or delivery service failures
- • Fraudulent activity
|
|
- • Held load hostage
- • Operates without bond or trust fund
- • Brokers freight without broker or FF authority
- • Payment issues
- • No show and no call
- • Unauthorized re-brokering of shipment
- • Back-solicited shipper
- • Theft or unjustified loss of freight
|
FreightGuard Report information can be obtained and maintained using the FreightGuard Reports CSV File Download. Information provided in FreightGuard Reports are solely the opinions of members and not necessarily the opinions of Carrier411.
The FreightGuard Reports CSV File identifies all companies monitored by your Carrier411 account that have FreightGuard Reports. To maintain accurate information in your TMS software database about companies with FreightGuard Reports, initiate the FreightGuard Reports CSV File Download one time each day in the morning.
Before you process data returned by the FreightGuard Reports CSV File Download, we suggest you reset or clear all FreightGuard Report information in your TMS Software database for all companies that previously had FreightGuard Reports; then you can process the data returned by the FreightGuard Reports CSV File Download. Because FreightGuard Reports are submitted, released, edited, updated, and deleted every day, clearing any existing FreightGuard Report information before processing data returned by the FreightGuard Reports CSV File Download is the only way you can maintain accurate FreightGuard Report information.
How to Initiate FreightGuard Reports CSV File Download
You must have an active Carrier411 account, and the CSV File Download feature must be enabled. When your server invokes the following URL string, a CSV file will be created at that moment. It will begin downloading automatically. CSV file creation may take between 5 seconds and 30 seconds, depending on the number of companies monitored by your Carrier411 account.
URL String |
https://www.carrier411.com/createfgcsvfile.cfm?username=xxx&password=yyy
Substitute xxx with your Carrier411 username and yyy with your password.
Unless &header=0 (optional parameter) is specified in the above URL string, a file header row will be included in the CSV file by default.
|
Schedule |
Schedule your server to invoke the above URL string one time only in the morning, between 7:45 AM and 9:00 AM EST. |
Purpose |
Creates comma-separated values (CSV) file upon request. Includes data (detailed below) for all the companies monitored by your Carrier411 account that have FreightGuard Reports submitted about them. |
Errors |
Any errors will produce a FaultCode when the URL string is invoked.
FaultCode 1: Username and password not provided.
FaultCode 2: Username not provided.
FaultCode 3: Password not provided.
FaultCode 4: Invalid username or password.
FaultCode 5: Account inactive.
FaultCode 6: Account suspended.
FaultCode 7: Trial accounts cannot download CSV files.
FaultCode 8: CSV file download not activated for account.
FaultCode 9: No registered companies have FreightGuard Reports.
|
Parameters |
username -- Carrier411 username (Required).
password -- Carrier411 password (Required).
header -- 1 or 0 (Optional). Include &header=0 for no header row.
|
FreightGuard Reports CSV File Fields and Possible Values
The following 35 fields and possible values are contained in the FreightGuard Reports CSV file. View Sample FreightGuard Reports CSV File with Header Row.
1. DOCKET |
CHAR 8 |
This is the motor carrier (MC) number for the company. It may also be an FF or MX number for freight forwarders or Mexican carriers. |
2. AGREEMENT |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "In-transit agreement modification". |
3. AGREEMENTCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "In-transit agreement modification" based on all FreightGuard Reports submitted about company. |
4. ALIAS |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Operates under alias". |
5. ALIASCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Operates under alias" based on all FreightGuard Reports submitted about company. |
6. CANCELLED |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Cancelled after accepting load". |
7. CANCELLEDCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Cancelled after accepting load" based on all FreightGuard Reports submitted about company. |
8. CANCELLING |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Persistent cancelling". |
9. CANCELLINGCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Persistent cancelling" based on all FreightGuard Reports submitted about company. |
10. CLAIMS |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Unresolved claim issues". |
11. CLAIMSCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Unresolved claim issues" based on all FreightGuard Reports submitted about company. |
12. ETHICS |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Unethical or deceptive business practices". |
13. ETHICSCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Unethical or deceptive business practices" based on all FreightGuard Reports submitted about company. |
14. FAILURES |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Repeated pickup or delivery service failures". |
15. FAILURESCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Repeated pickup or delivery service failures" based on all FreightGuard Reports submitted about company. |
16. FRAUD |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Fraudulent activity". |
17. FRAUDCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Fraudulent activity" based on all FreightGuard Reports submitted about company. |
18. HOSTAGE |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Held load hostage". |
19. HOSTAGECOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Held load hostage" based on all FreightGuard Reports submitted about company. |
20. NOBOND |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Operates without bond or trust fund". |
21. NOBONDCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Operates without bond or trust fund" based on all FreightGuard Reports submitted about company. |
22. NOLICENSE |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Brokers freight without broker or FF authority". |
23. NOLICENSECOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Brokers freight without broker or FF authority" based on all FreightGuard Reports submitted about company. |
24. NONPAYMENT |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Payment issues". |
25. NONPAYMENTCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Payment issues" based on all FreightGuard Reports submitted about company. |
26. NOSHOW |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "No show and no call". |
27. NOSHOWCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "No show and no call" based on all FreightGuard Reports submitted about company. |
28. REBROKER |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Unauthorized re-brokering of shipment". |
29. REBROKERCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Unauthorized re-brokering of shipment" based on all FreightGuard Reports submitted about company. |
30. REPORTS |
NUMERIC 9 |
Possible Values: Numeric value representing total number of FreightGuard Reports submitted about company. |
31. SOLICITED |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Back-solicited shipper". |
32. SOLICITEDCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Back-solicited shipper" based on all FreightGuard Reports submitted about company. |
33. THEFT |
CHAR 1 |
Possible Values: "Y" for yes or "N" for no. Indicates whether company has ever been reported for "Theft or unjustified loss of freight". |
34. THEFTCOUNT |
NUMERIC 9 |
Possible Values: Numeric value representing total number of times company has been reported for "Theft or unjustified loss of freight" based on all FreightGuard Reports submitted about company. |
35. CREATED |
DATETIME |
Date formatted as mm/dd/yyyy indicates the date CSV file was created. |
|
|