This document is the master map for our integration with Revenova as it relates to our premium Trucking Visibility product.
For questions or additional context around a specific field, please contact us at [email protected].
Trucking Field Mapping
Logixboard | Revenova | Notes / Logic |
Job ID | Load Number |
|
Order Number | PO Number |
|
Bill of Lading | -- | This ID is generated automatically by the Revenova BOL document generator. |
PRO Number | Pickup/Delivery Number | Not yet shown in LXB UI |
Lane Cost | Customer Quote Total | Not yet shown in LXB UI |
Est. Pickup | Expected Date & Appt Time | From first Pickup stop |
Arrived at Pickup Location | Arrival Date && Arrival Time | From first Pickup stop |
Actual Pickup | Departure Date && Departure Time | From first Pickup stop |
Est. Delivery | Expected Date & Appt Time | From last Delivery stop |
Arrived at Delivery Location | Arrival Date && Arrival Time | From last Delivery stop |
Actual Delivery | Departure Date && Departure Time | From last Delivery stop |
Pickup Address / Location | Stop Details | From first Pickup stop |
Delivery Address / Location | Stop Details | From last Delivery stop |
Carrier | Carrier |
|
Shipper | Stop Location Account | From first Pickup stop |
Consignee | Stop Location Account | From last Delivery stop |
Local Client | Customer |
|
Job Type | Mode |
|
Truck Type | Equipment Type | See mapping below |
Weight | Total Weight & Weight Units |
|
Volume | Total Volume & Volume Units |
|
Goods Description | Cargo Summary |
|
Estimated Mileage | Distance (Miles) |
|
Map Tracking Location | Tracking Log Reported Location |
|
N/A | Load Status | Loads in 'Canceled', 'Declined', or 'Expired' status in Revenova are not visible in the Logixboard system. |
Truck Type Mapping
Revenova equipment types are mapped into LXB as follows:
Van → “Dry Van” in LXB
Flatbed → “Flatbed” in LXB
Reefer → “Reefer” in LXB
Ocean/Intermodal → “Container Chassis” in LXB
All others → “Other” in LXB
Status Calculations
Logixboard Field | Status Name | Rules |
Status | Awaiting Dispatch | Default status when no Actual Pickup or Delivery data has been received |
Status | Pickup in Progress | Arrived at Pickup Location is populated and Actual Pickup is not populated |
Status | In Transit | Actual Pickup is populated and neither Arrived at Delivery Location nor Actual Delivery are populated |
Status | Delivery in Progress | Arrived at Delivery Location is populated and Actual Delivery is not populated |
Status | Delivered | Actual Delivery is populated |
Pickup Status | Awaiting Pickup | Estimated Pickup is in the future and neither Actual Pickup nor Actual Delivery are populated |
Pickup Status | Pickup Delayed | Estimated Pickup is in the past and neither Actual Pickup nor Actual Delivery are populated |
Pickup Status | Picked Up as Scheduled | Actual Pickup date is equal to Estimated Pickup date |
Pickup Status | Picked Up Late | Actual Pickup date is one or more days after Estimated Pickup date |
Pickup Status | Picked Up | Estimated Pickup is not populated and Actual Pickup is populated, or Actual Pickup is not populated and Actual Delivery is populated |
Delivery Status | Awaiting Delivery | Estimated Delivery is in the future and Actual Delivery is not populated |
Delivery Status | Delivery Delayed | Estimated Delivery is in the past and Actual Delivery is not populated |
Delivery Status | Delivered as Scheduled | Actual Delivery date is equal to Estimated Delivery date |
Delivery Status | Delivered Late | Actual Delivery date is one or more days after Estimated Delivery date |
Delivery Status | Delivered | Actual Delivery date is populated or POD is uploaded. |