shipment_id = 127854085:
| shipment_id | 127854085 |
| status | Delivered |
| bill_to_organization_id | 711759 |
| customer_name | BAKER COMPANY |
| origin_city | SANFORD |
| origin_state | ME |
| origin_zip | 04073 |
| dest_city | LOS ANGELES |
| dest_state | CA |
| dest_zip | 90048 |
| pickup_date | 2026-02-25 07:00:00 |
| delivery_date | 2026-03-05 05:00:00 |
| total_charges | 3970.00 |
| linehaul_carrier_name | TEAM EXPRESS INCORPORATED |
| carrier_scac | NULL |
| carrier_mc | 854193 |
| mileage | 3119.84 |
| trailer_type | 53 ft Van | Dry |
| custom_reference_number | 201346 |
| lsp_name | New Hampshire |
| total_stop_count | 3 |
| raw_payload | {"stops": [{"fax": null, "city": "SANFORD", "email": null, "notes": null, "phone": "+12073248773", "state": "ME", "country": "USA", "zipCode": "04073", "stopType": "First Pickup",… |
| created_at | 2026-06-01 16:09:26 |
| updated_at | 2026-06-01 16:09:26 |
| booked_by_user_id | NULL |
| booked_rate | NULL |
| booked_carrier_name | NULL |
| booked_rate_request_id | NULL |
| booked_at | NULL |
| reconcile_status | NULL |
| reconcile_checked_at | NULL |
| last_seen_in_source_at | NULL |
| posted_dat | NULL |
| posted_ts | NULL |
| Child table | FK column | Rows referencing this shipment_id |
|---|---|---|
| carrier_crm_v6_activity | shipment_id |
1 |
| carrier_crm_v6_load_locks | shipment_id |
0 |
| carrier_crm_v6_call_log | shipment_id |
0 |
| carrier_crm_v6_rate_requests | shipment_id |
0 |
| carrier_crm_v6_capacity | shipment_id |
0 |
You're testing CarrierCRM in dev mode. Two tools are available to help you give feedback and review the app from any role.
Find a bug, have an idea, or notice a confusing label? Use the feedback button to file it. Your submission is attributed to you, even if you're acting as a different role in the role switcher below.
The dark bar at the bottom of every page lets you take on a teammate's identity to see what their role would see. Pick a rep, manager, or admin from the dropdown — the page reloads as that person. Feedback you file while impersonating still records you as the submitter, with a note about the role you were testing.
