⚠️ Note: The data shown below is illustrative, not real client or shipment information. It's meant to demonstrate how I structure data entry and real-time monitoring inside a TMS (Transportation Management System), the raw fields and workflow a job order actually moves through, not an active tracker.
🚛 Live snapshot of active job orders, pulled from my Logistics Order Tracker. Status flow: Pending → On-Site (Driver at Origin) → In-Transit → Delivered (POD received).
🔗 Full Logistics Order Tracker (Google Sheets)
| Job Order | Shipment Type | Pickup Location | Drop-Off Location | Pickup Date | Status | DG/Hazmat |
|---|---|---|---|---|---|---|
| 042426-001 | CBR | Cavite, PH | New York, US | Apr 24, 4:20 PM | ✅ Delivered | Yes — UN 3373, Class 6 |
| 042526-004 | Aero | Chicago, US | Cavite, PH | Apr 26, 11:30 PM | 🕓 Pending | Yes — UN 3480, Class 9 |
| 042526-007 | Drum Set | Shenzhen, CN | New York, US | Apr 25, 2:15 PM | 📍 On-Site | No — Standard Cargo |
| 042526-009 | 3PL | Chongqing, CN | Gen Trias, PH | Apr 25, 4:55 PM | 🚚 In-Transit | No — Standard Cargo |
| 042526-010 | Intel | New York, US | Bacoor, PH | Apr 26, 5:30 AM | 🕓 Pending | Yes — UN 3480, Class 9 |
| 042526-011 | Standard Cargo | New York, US | Bacoor, PH | Apr 25, 6:07 PM | ✅ Delivered | No — Standard Cargo |
Job Order #, Client, Shipment Type, Pickup Location, Drop-Off Location, Pickup Date & Time, Temperature Requirements, Piece Count, Dimensions, Weight, Container Type, Vehicle Requirement, Delivery Type, Dangerous Goods flag (UN Number, DG Class), Receiver Name, Delivered Time.