| orderId |
orders.id |
query
|
|
String
|
| proNbr |
freight_group.pro_nbr |
query
|
|
String
|
| status |
orders.status |
query
|
|
String
|
| blnum |
orders.blnum |
query
|
|
String
|
| consigneeRefno |
orders.consignee_refno |
query
|
|
String
|
| referenceNumber |
reference_number.reference_number (subselected on all stops for the order) |
query
|
|
String
|
| tractorId |
tractor.id (joined on final move) |
query
|
|
String
|
| trailerId |
trailer.id (joined on final move) |
query
|
|
String
|
| driverId |
driver.id (joined on final move) |
query
|
|
String
|
| shipperLocationId |
stop.location_id (joined on orders.shipper_stop_id) |
query
|
|
String
|
| shipperCity |
stop.city_name (joined on orders.shipper_stop_id) |
query
|
|
String
|
| shipperState |
stop.state (joined on orders.shipper_stop_id) |
query
|
|
String
|
| shipperZip |
stop.zip_code (joined on orders.shipper_stop_id) |
query
|
|
String
|
| shipperStartDate |
stop.sched_arrive_early (joined on orders.shipper_stop_id) |
query
|
|
Date
|
| shipperEndDate |
stop.sched_arrive_early (joined on orders.shipper_stop_id) |
query
|
|
Date
|
| consigneeLocationId |
stop.location_id (joined on orders.consignee_stop_id) |
query
|
|
String
|
| consigneeCity |
stop.city_name (joined on orders.consignee_stop_id) |
query
|
|
String
|
| consigneeState |
stop.state (joined on orders.consignee_stop_id) |
query
|
|
String
|
| consigneeZip |
stop.zip (joined on orders.consignee_stop_id) |
query
|
|
String
|
| consigneeStartDate |
stop.sched_arrive_early (joined on orders.consignee_stop_id) |
query
|
|
Date
|
| consigneeEndDate |
stop.sched_arrive_early (joined on orders.consignee_stop_id) |
query
|
|
Date
|