--- title: "DAT Freight & Analytics" slug: "dat" tags: ["Compiled from User Guide", "DAT", "Load Posting", "Admin"] updated: 2026-06-19T18:00:27Z published: 2026-06-19T18:00:27Z canonical: "documents.revenova.com/dat" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.revenova.com/llms.txt > Use this file to discover all available pages before exploring further. # DAT Freight & Analytics The Revenova integration with DAT provides access to Load Board, Truck Postings, and Market Rate information directly in the TMS. Information from DAT is available in the [Carrier Match](/v1/docs/carrier-match-2) Lightning Web Component (LWC), the [Load Posting](/v1/docs/load-posting) LWC, and the [RateIQ](/v1/docs/rateiq) LWC. > [!NOTE] > **Note**: With the Revenova Winter ‘25 release, the DAT integration now calls their updated REST endpoints. In order to enable this functionality, contact DAT to acquire new credentials for these endpoints. Enter these credentials on the DAT 2 [credentials](/v1/docs/credentials-1) card. Individual user passwords may be updated with the Mass Import Credentials function. Automatically send load and rate information to DAT using the [DAT Contribute API](/v1/docs/dat#dat-contribute-api) when shipments are completed. > [!WARNING] > **Caution**: If you’re transitioning from the custom flat file integration to DAT Contribute, contact Revenova Support to turn off that custom integration and email [dataops@dat.com](mailto:dataops@dat.com) to inform DAT of the transition. ## Setup Configure and assign all available Platform Caches for TMS use. Complete the following steps. 1. Navigate to Setup → Platform Cache. 2. Click the *Edit* link for the **rtms** record. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Installation Guide - 3.jpg) 3. From the *Org Cache Allocation* section, find the **Organization** field. 1. Enter *3*. If necessary, enter *0* in **Provider Free**. 2. Click **Save**. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Installation Guide - 4.jpg) 4. Confirm all available platform cache is assigned to *tms*. The image below shows all available platform cache assigned to *tms*. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Setup - Platform Cache - 1(1).jpg) > [!WARNING] > **Caution:** Customer orgs may have multiple Salesforce packages installed that require platform cache. In these cases, allocate as much as possible of the platform cache to the TMS. ### **Enter Credentials** > [!NOTE] > **Note**: DAT credentials are required for both organization-wide and user-specific. Clone the original record and select new users, as needed, to enter additional DAT credentials. See also the [Mass Import](/v1/docs/credentials-1) feature to bulk add users and DAT credentials. #### **Organization-Wide Credentials** Enable the DAT integration by completing the following steps. 1. Navigate to **TMS Admin → Credentials**. 2. Select the **Global Services** tab. 3. Find DAT 2 in the list, then open the card by selecting its name. 4. Check the **Enabled** box for the DAT 2 card. 1. Check the [**DAT Contribute API**](/v1/docs/dat#dat-contribute-api) box to use the feature if desired. 5. Enter the **User ID** and **Password 1** into the text fields. 6. Click the **Save** button when finished. | User ID | Password 1 | Password 2 | Customer Number | | --- | --- | --- | --- | | Required; Revenova Service Account | Required; Password | | | #### **Individual Credentials** 1. From **TMS Admin → Credentials**, navigate to the **Authorized Users** tab. 2. Select the user to open the individual integration credentials. 3. Check the **Enabled** box and the appropriate **Load Posting**, **Truck Posting Search**, or **Truck Rates** boxes. 4. Enter the individual user credentials in the **User ID** and **Password1** fields. 5. Click **Save** when finished. Clone the original record and, as needed, select new users to enter additional DAT credentials. See also the [Mass Import](/v1/docs/credentials-1) feature to bulk add users and DAT credentials. | User ID | Password 1 | Password 2 | Customer Number | | --- | --- | --- | --- | | Required; Login Username from DAT account | Required; Password from DAT API (Connexion login credentials) | | | > [!NOTE] > **Note**: The Connexion **Login Username** and password is NOT the same as the email address/username used to log in to the DAT portal. ### **Remote Site Settings** Upgrading from previous versions of the TMS may have outdated information. Check that the Remote Site Settings for the DAT integration URL are up to date. 1. Click the **Setup** gear icon in the top right corner. 2. From the drop-down, click **Setup**. 3. In the Quick Find Toolbar type *Remote Site Settings* and click the link. 4. From the list of remote sites find *DATREST* and click the **Edit** link for each of the 8 URLs. 5. Set the following **Service URLs** to the following if necessary. 1. DATREST Analytics: https://analytics.api.dat.com. 2. DATREST Freight: https://freight.api.dat.com. 3. DATREST Identity: https://identity.api.dat.com. 4. DATREST Network: https://network.api.dat.com. 6. Set the following **Test Service URLs** to the following if necessary. 1. DATREST Analytics Test: https://analytics.api.staging.dat.com. 2. DATREST Freight Test: https://freight.api.staging.dat.com. 3. DATREST Identity Test: https://identity.api.staging.dat.com. 4. DATREST Network Test: https://network.api.dat.com. ### **DAT Portal Settings** Manage user profiles and login/password through the [DAT Portal](http://account.dat.com). 1. Log in to the [DAT Portal](http://account.dat.com) website. 1. Only Full Authority contacts have access to User Management. 2. Manage users, reset passwords, set the Preferred Contact Method, and perform related tasks. The Preferred Contact Method must be set in the DAT Portal and in the TMS. 1. After setting or uploading individual user credentials, the **Preferred Contact Method** (*Email*, *Primary Phone*, *Alternative Phone*) must be set on each user credential card. The default selection is *Email*. Users will need the API (**Connexion**) license that allows access to the DAT API. To view and manage integration credentials, see [DAT support](https://one.support.dat.com/9-resources-52e74931/resources-d9762e92/transportation-management-system-tms-bded76fa/how-to-view-and-manage-integration-credentials-2981fddf). ## Using DAT in Revenova TMS > [!WARNING] > **Caution**: The DAT integration does **not** support multiple stops for the same Account location. Visibility to truck postings, load to truck ratios, and historical spot rates. [**Carrier Match**](/v1/docs/carrier-match-2) LWC: View truck postings. - Request quotes from one to many in-network Carriers. - Initiate your Carrier setup process with out-of-network Carriers. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Carrier%20Match%20LWC%20-%20Blurred.png) [**RateIQ**](/v1/docs/rateiq) LWC: Visibility to DAT with Average Spot Rates. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Rate%20IQ%20Market%20Rates.png) > [!NOTE] > **Note**: Web service calls for current and historical rates are cached to reduce usage charges. - **Carrier Rate History:** Visibility to average monthly rates. [**Load Posting**](/v1/docs/load-posting) LWC: Add or remove Load postings on a Load by Load basis. Required fields: **Origin** and **Destination Postal Codes** for locations, **Expected Ship** and **Expected Delivery Dates**. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/DAT Freight - Load Posting - 1.jpg) The following fields are sent to DAT when posting a Load. - LTL or Truckload Mode - Description (70 character limit) - Equipment Type - Ship From Address - Posting City/Actual City - Posting State/Actual State - Postal Code - Country - Offer Rate (if included on the Load) - Offer Rate Type (if Offer Rate is entered. Default Offer Rate Type is per mile.) - Truck Length - Weight in lbs - Expected Ship Date (availability/earliest element) > [!NOTE] > **Note**: Updates to the Load Board posting are controlled by the **Load Posting Refresh Interval (Minutes)** field under TMS Admin → Configuration. This field is the time period for refreshing and sending updates to the Load Board. ### **Load Posting Defaults** After Equipment Type records are created, set the default values when posting Loads to various Load Boards. A Visualforce Page on the Equipment Type record allows for setting default values when posting Loads to DAT. ![](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Load Posting Defaults - 1.jpg) Enter the default values in to the fields and click **Save**. Note that the default values saved are formatted to send to DAT. ## DAT Contribute API The DAT Contribute API integration allows users to send completed shipments from the TMS to DAT, contributing their rate information to the DAT platform and receiving credits. ### Mode Configuration Set the **DAT Mode** field for each mode that should be sent to the DAT Contribute API in TMS Admin → [Modes](/v1/docs/mode-setup). > [!WARNING] > **Caution**: If a mode does not have a value in the **DAT Mode** field, then the load and rate information is not sent to DAT for Loads using that mode. For the modes packaged in the TMS, the **DAT Mode** field is set by default as shown in the following table. | Mode Name | DAT Mode Value | | --- | --- | | Truckload | TL | | LTL | LTL | | Intermodal | INTERMODAL | | Drayage | DRAYAGE | | Ocean FCL | OCEAN | | Ocean LCL | OCEAN | | Air Freight | AIR | | Flatbed | TL | | Bulk | TL | | Parcel | PARCEL | If you want to change these values from the default or set the **DAT Mode** to something more accurate for custom Modes, additional options include: - PARTIAL - OVERWEIGHT - RAIL - BARGE - CPU (short for Customer Pickup) - DEDICATED (dedicated shipper or broker) - FULL ### Currency Setup The DAT Contribute API integration can only send rate information in USD. To use this feature, ensure that the **USD - U.S. Dollar** is an active currency in the org by going to Setup → Manage Currencies and selecting the **Manage Currencies** button. > [!WARNING] > If USD is a deactivated currency in an org, currency exchange rates are used to convert the Load currency to USD. The USD value is sent to DAT. ![Settings page for managing currencies, highlighting U.S. Dollar and conversion rates.](https://cdn.document360.io/b89abf73-101a-4754-a781-084aef8f68dd/Images/Documentation/Setup Manage Currencies USD.png) ### Using DAT Contribute Load and rate information are sent to DAT when the **Load Status** moves to *Completed*. The following are conditions that need to be met in order for the TMS to process information before sending it to DAT: - The Load has a **Mode** - The Load has an **accepted** Carrier Quote - The Load is **not** a Customer Load in a [Freight Plan](/v1/docs/getting-started-with-freight-plans#freight-plan-definitions) Refer to the [API Field Mapping](/v1/docs/dat#api-field-mapping) section in this article to see what fields are required to send in order to successfully submit rate information to DAT. Once the load and rate information are sent to DAT, the **Contribution APIs Sent To** field on the Load record includes the *DAT* value. ### Exclude Loads from DAT Contribute To exclude Loads that have a **Mode** that also has a value in the **DAT Mode** field, *Check* the **Exclude From Rate Contribution** field on the Load record. > [!TIP] > **Tip**: Create a custom flow or workflow process to automatically *Check* this field based on specific criteria. ### Example Request | TMS Operation | DAT Contribute Endpoint | Request Type | Response | | --- | --- | --- | --- | | Load Status moves to *Completed* | Broker Contributions | POST | 201: Success 400: Bad Request 401: Authentication Error 403: Authorization Error 500: Internal Server Error | **Sample Payload** ```json {    "loadId": "L-10",    "charges": {        "totalAmountPaidByBrokerUsd": 808.9,        "linehaulAmountPaidUsd": 965.2,        "linehaulAmountPaidByCustomerUsd": 200.2,        "fuelSurchargeAmountPaidUsd": 145.25,        "fuelSurchargeAmountPaidByCustomerUsd": 145.25    },    "loadDetails": {        "equipmentTypeBrief": "FLATBED",        "mode": "TL",        "freightValueUsd": 18000,        "hazmat": false,        "piecesOrPallets": 16,        "weightPounds": 18000,        "freightClass": 50,        "cubicFeet": 1800,        "linearFeet": 24    },    "pickupSchedule": {        "actualPickupDate": "2026-04-25"    },    "deliverySchedule": {        "actualDeliveryDate": "2026-04-27"    },    "origin": {        "city": "Denver",        "stateOrProvince": "CO",        "zip": 80014    },    "destination": {        "city": "Seattle",        "stateOrProvince": "WA",        "zip": 98101    },    "order": {        "spotMarket": true,        "orderBookDate": "2026-04-15",        "practicalMiles": 1300,        "totalPickups": 1,        "totalDrops": 1    } } ``` ### API Field Mapping | TMS Object | TMS Field | DAT Field | Required | **Notes** | | --- | --- | --- | --- | --- | | Load | Name | loadId | ✅ Yes | | | Carrier Quote | (Carrier Quote Total - Accessorial Charges) | charges.totalAmountPaidByBrokerUsd | ✅ Yes | | | Carrier Quote | Net Line Haul | charges.linehaulAmountPaidUsd | ❌ No | | | Customer Quote | Net Line Haul | charges.linehaulAmountPaidByCustomerUsd | ❌ No | | | Carrier Quote | Fuel Surcharge | charges.fuelSurchargeAmountPaidUsd | ❌ No | | | Customer Quote | Fuel Surcharge | charges.fuelSurchargeAmountPaidByCustomerUsd | ❌ No | | | Equipment Type | Category | loadDetails.equipmentTypeBrief | ✅ Yes | If the Equipment Type on the Load or the **Category** field is blank, the value sent to DAT is *VAN*. | | Mode | DAT Mode | loadDetails.mode | ✅ Yes | This value is taken from the **Mode** field on the Load record. | | Load | Cargo Value | loadDetails.freightValueUsd | ❌ No | | | Load | Hazardous Materials | loadDetails.hazmat | ❌ No | | | Line Item | Packaging Unit Count | loadDetails.piecesOrPallets | ❌ No | Calculated as a rollup of the Handling Unit Count on all Line Items. | | Load | Total Weight | loadDetails.weightPounds | ❌ No | See [LTL and PARTIAL Required Fields](/v1/docs/dat#ltl-and-partial-required-fields) | | Line Item | NMFC Class | loadDetails.freightClass | ❌ No | See [LTL and PARTIAL Required Fields](/v1/docs/dat#ltl-and-partial-required-fields) | | Line Item | Volume | loadDetails.cubicFeet | ❌ No | See [LTL and PARTIAL Required Fields](/v1/docs/dat#ltl-and-partial-required-fields) | | Load | Linear Feet | loadDetails.linearFeet | ❌ No | See [LTL and PARTIAL Required Fields](/v1/docs/dat#ltl-and-partial-required-fields) | | Load | Expected Ship Date | pickupSchedule.actualPickupDate | ✅ Yes | | | (Last) Stop | Arrival Date | deliverySchedule.actualDeliveryDate | ❌ No | | | (First) Stop | City Index | origin.city | ✅ Yes | | | (First) Stop | State Index | origin.stateOrProvince | ✅ Yes | | | (First) Stop | Postal Code | origin.zip | ❌ No | | | (Last) Stop | City Index | destination.city | ✅ Yes | | | (Last) Stop | State Index | destination.stateOrProvince | ✅ Yes | | | (Last) Stop | Postal Code | destination.zip | ❌ No | | | Carrier Quote | Rate Entry | order.spotMarket | ✅ Yes | If the **Rate Entry** field is populated, the data is sent with the value *true*. Otherwise, *false*. | | Load | Tender Accepted Date | order.orderBookDate | ❌ No | | | Load | Distance Miles | order.practicalMiles | ❌ No | | | Load | | order.totalPickups | ❌ No | Calculated as a rollup of Pickup Stops. | | Load | | order.totalDrops | ❌ No | Calculated as a rollup of Dropoff Stops. | #### LTL and PARTIAL Required Fields Depending on the **DAT Mode** field on the Mode record (either LTL or PARTIAL), additional fields, beyond those in the previous table, are **required** to successfully send data to DAT. | DAT Mode | TMS Object | TMS Field | DAT Field | Notes | | --- | --- | --- | --- | --- | | LTL | Load | Total Weight | loadDetails.weightPounds | The TMS converts the **Total Weight** value to pounds if the **Weight Units** is not *lbs*. | | Line Item | NMFC Class | loadDetails.freightClass | This field takes the **first** Line Item that has an NMFC Class. If **no** Line Items have an NMFC Class, DAT does not process the data received. | | PARTIAL | Line Item | Volume | loadDetails.cubicFeet | This field assumes the volume is calculated in cubic feet. Check the **Auto-Calculate Area and Volume** field in the Line Item record to automatically calculate the volume in cubic feet. | | Load | Linear Feet | loadDetails.linearFeet | This field is auto-calculated for Line Items when configuring a Load that has these values: - Length - Width - Height - Equipment Type If multiple Line Items have a **Linear Feet** value, the Load field takes the **sum** of those values. | ## **DAT Error Messages** User triggers the following error: > [!CAUTION] > **Error** DAT:Message from Load Board: Error: 101000010 - Authentication failure This error may occur when attempting to setup DAT credentials. This error is sent by DAT because the user does not have a valid Connexion license within DAT. This error is usually resolved once the license is in place. > [!NOTE] > **Note**: The credentials for logging in to DAT may be different from the Load board credentials entered in the TMS. Confirm with DAT that your organization has a Connexion license set up. If no direct DAT contact is available, email [customer.solutions@dat.com](mailto:customer.solutions@dat.com). A feature in Salesforce that enhances the user experience by providing interactive and customizable components within Salesforce applications. Revenova uses Lightning Web Components to deliver features that can be tailored to suit your specific needs and preferences.