select T5."actual_departure", case when T2."loaded" = 'E' then T2."move_distance" else NULL end
from "dbo"."stop" T5 LEFT OUTER JOIN ("dbo"."stop" T4 LEFT OUTER JOIN ((("dbo"."orders" T1 LEFT OUTER JOIN "dbo"."movement_order" T6 on T1."id" = T6."order_id") LEFT OUTER JOIN "dbo"."movement" T2 on T6."movement_id" = T2."id") LEFT OUTER JOIN "stop" T3 on T1."consignee_stop_id" = T3."id" and T1."shipper_stop_id" = T3."id") on T4."id" = T1."shipper_stop_id") on T5."id" = T1."consignee_stop_id"
where T2."status" = 'D' and T1."company_id" = 'TMS ' and T1."equipment_type_id" = 'FLAT' and T1."revenue_code_id" = '10'
select T5."actual_departure", T1."id", T4."zone_id", {fn MONTH(T5."actual_departure")}, T1."company_id", T4."actual_departure", T1."total_charge", T1."bill_distance", T1."freight_charge", case when T4."zone_id" = '1' then 'Jim' when T4."zone_id" = '2' then 'Jackie' when T4."zone_id" = '3' then 'Larry' when T4."zone_id" = '4' then 'Jan' when T4."zone_id" = '5' then 'Erin' else NULL end , CAST(T1."freight_charge" AS FLOAT) / (T1."bill_distance" + .00000001), T3."actual_departure", T2."move_distance", T1."rate", T1."extra_deliveries" + T1."extra_pickups", case when T2."loaded" = 'E' then T2."move_distance" else NULL end , T1."status", T1."otherchargetotal", T1."equipment_type_id", T1."extra_pickups", T1."extra_deliveries", T2."loaded", T2."fuel_distance"
from "dbo"."stop" T5 LEFT OUTER JOIN ("dbo"."stop" T4 LEFT OUTER JOIN ((("dbo"."orders" T1 LEFT OUTER JOIN "dbo"."movement_order" T6 on T1."id" = T6."order_id") LEFT OUTER JOIN "dbo"."movement" T2 on T6."movement_id" = T2."id") LEFT OUTER JOIN "stop" T3 on T1."consignee_stop_id" = T3."id" and T1."shipper_stop_id" = T3."id") on T4."id" = T1."shipper_stop_id") on T5."id" = T1."consignee_stop_id"
where T2."status" = 'D' and T1."company_id" = 'TMS ' and T1."equipment_type_id" = 'FLAT' and T1."revenue_code_id" = '10'
select T5."actual_departure", {fn MONTH(T5."actual_departure")}, T4."zone_id", T1."id", case when T2."loaded" = 'E' then T2."move_distance" else NULL end
from "dbo"."stop" T5 LEFT OUTER JOIN ("dbo"."stop" T4 LEFT OUTER JOIN ((("dbo"."orders" T1 LEFT OUTER JOIN "dbo"."movement_order" T6 on T1."id" = T6."order_id") LEFT OUTER JOIN "dbo"."movement" T2 on T6."movement_id" = T2."id") LEFT OUTER JOIN "stop" T3 on T1."consignee_stop_id" = T3."id" and T1."shipper_stop_id" = T3."id") on T4."id" = T1."shipper_stop_id") on T5."id" = T1."consignee_stop_id"
where T2."status" = 'D' and T1."company_id" = 'TMS ' and T1."equipment_type_id" = 'FLAT' and T1."revenue_code_id" = '10'
select T5."actual_departure", {fn MONTH(T5."actual_departure")}, T4."zone_id", case when T2."loaded" = 'E' then T2."move_distance" else NULL end
from "dbo"."stop" T5 LEFT OUTER JOIN ("dbo"."stop" T4 LEFT OUTER JOIN ((("dbo"."orders" T1 LEFT OUTER JOIN "dbo"."movement_order" T6 on T1."id" = T6."order_id") LEFT OUTER JOIN "dbo"."movement" T2 on T6."movement_id" = T2."id") LEFT OUTER JOIN "stop" T3 on T1."consignee_stop_id" = T3."id" and T1."shipper_stop_id" = T3."id") on T4."id" = T1."shipper_stop_id") on T5."id" = T1."consignee_stop_id"
where T2."status" = 'D' and T1."company_id" = 'TMS ' and T1."equipment_type_id" = 'FLAT' and T1."revenue_code_id" = '10'
select T5."actual_departure", {fn MONTH(T5."actual_departure")}, T4."zone_id", T1."id"
from "dbo"."stop" T5 LEFT OUTER JOIN ("dbo"."stop" T4 LEFT OUTER JOIN ((("dbo"."orders" T1 LEFT OUTER JOIN "dbo"."movement_order" T6 on T1."id" = T6."order_id") LEFT OUTER JOIN "dbo"."movement" T2 on T6."movement_id" = T2."id") LEFT OUTER JOIN "stop" T3 on T1."consignee_stop_id" = T3."id" and T1."shipper_stop_id" = T3."id") on T4."id" = T1."shipper_stop_id") on T5."id" = T1."consignee_stop_id"
where T2."status" = 'D' and T1."company_id" = 'TMS ' and T1."equipment_type_id" = 'FLAT' and T1."revenue_code_id" = '10'
select T5."actual_departure", {fn MONTH(T5."actual_departure")}, case when T2."loaded" = 'E' then T2."move_distance" else NULL end
from "dbo"."stop" T5 LEFT OUTER JOIN ("dbo"."stop" T4 LEFT OUTER JOIN ((("dbo"."orders" T1 LEFT OUTER JOIN "dbo"."movement_order" T6 on T1."id" = T6."order_id") LEFT OUTER JOIN "dbo"."movement" T2 on T6."movement_id" = T2."id") LEFT OUTER JOIN "stop" T3 on T1."consignee_stop_id" = T3."id" and T1."shipper_stop_id" = T3."id") on T4."id" = T1."shipper_stop_id") on T5."id" = T1."consignee_stop_id"
where T2."status" = 'D' and T1."company_id" = 'TMS ' and T1."equipment_type_id" = 'FLAT' and T1."revenue_code_id" = '10'