| 1234567891011 |
- 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",
- (left(((convert(varchar(50), T3."employee_number"))))) + ' - ' + 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
|
