This document is the master map for our integration with BrokerWare 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 | BrokerWare | Notes / Logic |
Job ID | Load |
|
Order Number | Reference # |
|
Bill of Lading | BOL # |
|
PRO Number | Carrier Pro Number |
|
Est. Pickup | Pickup Date |
|
Actual Pickup | Shipment Notes > |
|
Est. Delivery | Est. Delivery |
|
Actual Delivery | Delivery Date |
|
Pickup Address / Location | Shipper Address |
|
Delivery Address / Location | Consignee Address |
|
Carrier | Carrier |
|
Shipper | Shipper |
|
Consignee | Consignee |
|
Local Client | Customer |
|
Job Type | Mode |
|
Truck Type | Equipment | See mapping below |
Weight | Weight | Sum of all commodities weights |
Goods Description | Product Description | Concatenated list from all commodities lines |
Estimated Mileage | Miles |
|
Truck Type Mapping
BrokerWare equipment types are mapped into LXB as follows:
BrokerWare Equipment Type | Logixboard Truck Type |
ContainerRefrigerated ContainerTrailer | Container |
BlanketWrapVan CurtainVan MovingVan OpenTopVan StraightVan Van VanAirRide VanDouble VanHazMat VanInsulated VanIntermodal VanLiftGate VanReefer VanwTeam | Dry Van |
Conestoga Flatbed FlatbedAirRide FlatbedHazMat FlatbedIntermodal FlatbedOrVentedVan FlatbedOverDimension FlatbedOverDimensionLoad FlatbedStepDeckOrVan FlatbedVanReefer FlatbedWithSides FlatbedwTarps FlatbedwTeam FlatOrStepDeck MaxiOrDoubleFlatTrailers StretchTrailersOrExtendableFlatbed Two24Or28FootFlats VanOrFlatbed VanorFlatbedwTarps | Flatbed |
AutoCarrier BoatHaulingTrailer HotShot | Hauler |
Boxcar CoveredHopper Flatcar Gondola HopperBottom NotSpecified Pneumatic PowerOnlyOrTowAway Tankcar TankerAluminum TankerIntermodal TankerSteel | Other |
Reefer ReeferAirRide ReeferDouble ReeferHazMat ReeferorVentedVan ReeferwTeam RefrigeratedCarrierReefer RefrigeratedIntermodal VanReeferDoubleDrop VentedInsulatedVanOrRefrigerated | Reefer |
DoubleDrop Lowboy LowboyOveerDimensionLoad LowboyOverDimensionLoad StepDeck StepDeckOverDimensionLoad | Step Deck |
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. |