This document is the master map for our integration with CargoWise One as it relates to our premium Trucking Visibility product.
For questions or additional context around a specific field, please contact us at [email protected].
Domestic Trucking Field Mapping
Logixboard | CargoWise One T-Jobs | CargoWise One TB-Files | CargoWise One S-Files | Notes / Logic |
Job ID | Job ID | Booking ID | Shipment ID |
|
Order Number | Details -> Reference # | Additional Details -> ORD Reference Number | Basic Registration -> Job Management Links ->Order Refs |
|
Bill of Lading | References -> MAB Reference Number | References -> MAB Reference Number | N/A |
|
Est. Pickup | Details -> Est. Pickup | Details -> Pic. Estimated (from first Pickup) | Pickup -> Estimated Pickup |
|
Arrived at Pickup Location | Port Transport Legs -> Pickup In | N/A | N/A |
|
Actual Pickup | Port Transport Legs -> Pickup Out | Details -> Pic. Actual (from first Pickup) | Pickup -> Actual Pickup |
|
Est. Delivery | Details -> Est. Delivery | Details -> Dlv. Estimated (from last Delivery) | Delivery -> Estimated Delivery |
|
Arrived at Delivery Location | Port Transport Legs -> Delivery In | N/A | N/A |
|
Actual Delivery | Port Transport Legs -> Delivery Out | Details -> Dlv. Actual (from last Delivery) | Delivery -> Actual Delivery |
|
Pickup Address / Location | Details -> Pickup Org Address | Details -> Pickup Org Address | Pickup -> Pickup From | For T-Jobs, CW1 field name is variable based on job type |
Delivery Address / Location | Details -> Delivery Org Address | Details -> Delivery Org Address | Delivery -> Delivery To | For T-Jobs, CW1 field name is variable based on job type |
Carrier | Port Transport Legs -> Transport Company | Details -> Transport Company | Delivery -> Delivery Transport Company |
|
Waybill | Details -> Waybill # | Details -> Waybill Number | Basic Registration -> Housebill |
|
Consignee | Details -> Consignee | Details -> Consignee | Basic Registration -> Consignee |
|
Local Client | Details -> Local Client | Details -> Billing Party | Basic Registration -> Local Client |
|
Job Type | Details -> Job Type | Details -> Template | Basic Registration -> Container Mode | For T-Jobs, see the Job Types table below for mapping from CW1 Job Type value to LXB value (FTL, LTL, Containerized, or Other) |
Weight | Details -> Total Goods Weight | Details -> Weight | Basic Registration -> Weight |
|
Volume | Details -> Total Goods Volume | Details -> Volume | Basic Registration -> Vol |
|
Goods Description | Details -> Description | Details -> Goods Description | Basic Registration -> Description |
|
Signatory | Port Transport Legs -> Goods Received By | Details -> Signed By (from last Delivery) | Delivery -> Confirmations -> Goods Signed By |
|
Estimated Job Mileage | Port Transport Legs -> P/C Dist. | N/A | N/A |
|
Time to Destination | N/A | N/A | N/A | Difference between Estimated or Actual Pickup and Estimated or Actual Delivery |
T-Job Job Type Mapping
Note: LXB supports mapping of custom Job Types to FTL, LTL, Containerized, or Other. Please provide your custom Job Type codes and the desired mapping to your CSM or Support representative.
FTL | LTL | Containerized | Other |
DOMESTIC LOOSE DELIVERY (DRLC) LINE HAUL FTL CFS TO CFS (HRTF) DOMESTIC LOOSE PICKUP (ORLC) | WAREHOUSE LOOSE DELIVERY (DRLW) AIR EXPORT LOOSE CFS TO CTO (EALL) AIR IMPORT LOOSE CTO TO CFS (IALL) AIR EXPORT (EALF) AIR IMPORT (IALC) | WAREHOUSE CONTAINERIZED DELIVERY (DRCW) DOMESTIC CONTAINERIZED DELIVERY (DRFC) AIR EXPORT ULD CFS TO CTO( EAFF) FCL EXPORT PACK (ESCF) FCL EXPORT TO SHP (ESCS) FCL CYD TO SHP(WAIT) TO CTO (ESCW) EMPTY CYD TO CFS (ESEF) EMPTY CYD TO SHP (ESES) FCL CFS TO CTO (ESFF) FCL SHP TO CTO (ESFS) LCL EXPORT (ESLF) FCL PACK, LOOSE FROM SHP (ESMY) AIR IMPORT ULD CTO TO CFS (IAFF) STAGING CTO CFS CNE CYD (ISC3) FCL IMPORT TO CNE (ISCC) FCL IMPORT UNPACK (ISCF) FCL CTO TO CNE(WAIT) TO CYD (ISCW) EMPTY CNE TO CYD (ISEC) EMPTY CFS TO CYD (ISEF) FCL CTO TO CNE (ISFC) FCL CTO TO CFS (ISFF) LCL IMPORT (ISLC) FCL UNPACK, LOOSE TO CNE (ISMY) DOMESTIC CONTAINERIZED PICKUP (ORFC) | RETURNED CFS TO SHP (ERLR) MILK RUN (LRLN) |
TB-Files Template Mapping
LXB supports mapping of custom Job Templates to FTL, LTL, Containerized, or Other. Please provide your custom Job Template codes and the desired mapping to your CSM or Support representative.
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 |