select distinct T1."invoice_type" as "Invoice Type",
	   T1."invoice_number" as "Invoice Number",
	   T2."order_taking_employee_no" as "Order Taking Employee No",
	   T2."order_delivery_employee_no" as "Order Delivery Employee No",
	   T1."invtype_invnr" as "Invoice_Type_Invoice_Number",
	   T3."employee_number" as "Employee Number_Employees",
	   T3."name" as "Name_Employees",
	   (substring((convert(varchar(50), T3."employee_number")), 1, 4)) + ' - ' + T3."name" as "Serviceberater"
from (("LOCOSOFT"."dbo"."order_positions" T2 left outer join "dbo"."invoices" T1 on T2."order_number" = T1."order_number") left outer join "LOCOSOFT"."dbo"."employees" T3 on T2."order_taking_employee_no" = T3."employee_number")
where ((T1."invoice_type" BETWEEN 2 AND 6) and (T2."order_date" >= convert(datetime, '2019-01-01 00:00:00.000')))
-- order by "Invoice_Type_Invoice_Number" asc,"Invoice Number" asc