Macropoint Capacity

MacroPoint Capacity provides advanced carrier sourcing and capacity matching capabilities. With Descartes MacroPoint users can source carriers, and find carriers that fit their network, resulting in stronger more profitable relationships.

DSG_MP_Logo_Core

Integration Setup

Username

Password

Provided by MacroPoint. 

This gets converted on our end to a basic auth token. 

Testing = True would hit the test end-point

Shipment Sync (Load Import)

Initial Sync

The initial sync is a recurring job that runs every 15 minutes. We will store the InitialLoadSyncCompleted. If the value does not exist, it will run. This will pull all shipments in the delivered status created within the last year. This runs 5000 shipments at a time and will run until completion. Once completed, the value for InitialLoadSyncCompleted will be "true". 

Shipment Sync

This occurs in 3 different stages. When a shipment is created, updated, or shipment status is updated. Once updated, it will check the status. If greater than or equal to Committed and less than or equal to Delivered, it will attempt to import the load to MacroPoint Capacity. This will add an ApiActivityLog (for troubleshooting). We don't save anything on our end. 

Carrier Sync

Initial Sync 

Runs every 15 minutes. We will store the InitialCarrierSyncCompleted. If the value is false or does not exist, it will run. This will sync the full Broker Carrier list to MacroPoint. This runs 5000 carriers at a time and will run until completion.  Once completed, the value for InitialCarrierSyncCompleted will be "true". 

Carrier Sync

This occurs based on the modified date of the carrier. This runs every 15 minutes. Only runs if the Initial Sync is completed. The LastCarrierSyncDate is stored so that we only pull carriers where the modified date is greater than the LastCarrierSyncDate value. Once the job runs, we update this value. 

Find Power

The Find Power service can be accessed via a button on the Truckload Quoting page. This will pull back carriers from the MacroPoint capacity service and is specific to the shipment load data. We do have equipment type mapping including Flatbed, Reefer, Dry Van (dry van). If the equipment type on our end has Flatbed or Reefer in the name, we will submit it. 

Radius that is transmitted is based on the search criteria value that is set on the Truckload Quoting page. By default, we set it to a 100 mile radius. If the user selects Zip Code, State, or Any, we will default the radius to 50 miles (MacroPoints default). 

If there are any errors from MacroPoint capacity, they are exposed in the red toaster. This is displaying exactly what MacroPoint provides from their endpoint. 

Upon success, we take their DOT / MC Numbers and match the carrier from the Master Carrier DB and display carrier contact information. 

This will pull available carriers into the carrier quotes section denoted by MacroPoint. These are ordered based on MacroPoint's ordering system. The "best carrier available" would then float to the type. 

Single Carrier Statistics

In the Carrier Quotes section, next to the source (MacroPoint Logo), there will be an info circle icon that when clicked, will provide them with a modal that includes specific information for the load and carrier specific. This will provide carrier specific data viewed in the modal. 

  • flc: Number of Trucks (Forward Looking Capacity) this carrier has that are near your open load's pickup

    • These are determined by the origin.datetime, originMilesRadiusWindow, and timeWindowBeforeOriginAppointment

  • t: Number of total historical trips related in some way to this open load (either the pickup location or destination location)

    • These are determined by originMilesRadiusWindow, destinationMilesRadiusWindow, and monthWindowForHistoricalData

  • dh: Average deadhead miles for the FLC for this carrier (i.e. average number of miles from the truck locations to the origin's pickup)

    • These are determined by the origin.datetime, originMilesRadiusWindow, timeWindowBeforeOriginAppointment and timeWindowAfterOriginAppointment

  • l: Number of Lane Matches in this carrier's history (i.e. number of times this carrier ran the same Origin to Destination route)

    • These are determined by originMilesRadiusWindow, destinationMilesRadiusWindow, and monthWindowForHistoricalData

  • d: Number of times this carrier has stopped in this destination

    • These are determined by destinationMilesRadiusWindow and monthWindowForHistoricalData

  • rl: Number of Reverse Lane Matches in this carrier's history (i.e. number of this times this carrier ran a Destination to Origin route)

    • These are determined by originMilesRadiusWindow, destinationMilesRadiusWindow, and monthWindowForHistoricalData

  • o: Number of times this carrier has started in this origin

    • These are determined by originMilesRadiusWindow and monthWindowForHistoricalData

  • r: The average rate per mile (excluding fuel) charged for this lane, if it has lane matches