C11/System/LOCOSOFT/IQD/Zeit/Zeit_verk_Std.sql

SELECT T1."order_number" AS "Order Number",
	T1."order_position" AS "Order Position",
	T1."labour_type" AS "Labour Type",
	T2."code" AS "Code_Labour_Types",
	T2."description" AS "Description_Labour_Types",
	T3."order_number" AS "Order Number_Labours",
	T3."order_position" AS "Order Position_Labours",
	T3."order_position_line" AS "Order Position Line_Labours",
	'0' + (rtrim((((T4."subsidiary"))))) AS "Subsidiary_Labours",
	T3."is_invoiced" AS "Is Invoiced_Labours",
	T3."invoice_type" AS "Invoice Type_Labours",
	T3."invoice_number" AS "Invoice Number_Labours",
	T3."employee_no" AS "Employee No_Labours",
	T3."mechanic_no" AS "Mechanic No_Labours",
	T3."labour_operation_id" AS "Labour Operation Id_Labours",
	T3."is_nominal" AS "Is Nominal_Labours",
	T3."net_price_in_order" AS "Net Price In Order_Labours",
	T3."rebate_percent" AS "Rebate Percent_Labours",
	T3."goodwill_percent" AS "Goodwill Percent_Labours",
	T3."charge_type" AS "Charge Type_Labours",
	T3."text_line" AS "Text Line_Labours",
	10 AS "AW/Std.",
	((convert(FLOAT, T3."time_units"))) / 10 AS "verk. Std.",
	'verk. Std.' AS "Zeitkategorie",
	'' AS "Zeitkategorie2",
	T4."employee_number" AS "Employee Number_Employee",
	T4."name" AS "Name_Employee",
	(rtrim((((T4."employee_number"))))) + ' - ' + T4."name" AS "Monteur",
	T5."invoice_number" AS "Invoice Number_Invoices",
	T5."invoice_date" AS "Invoice Date_Invoices",
	T5."invoice_date" AS "Datum",
	T3."time_units" AS "Time Units_Labours",
	(convert(FLOAT, T3."time_units")) AS "Time_Units_Zahl"
FROM (
	"dbo"."invoices" T5 LEFT JOIN (
		(
			(
				"dbo"."order_positions" T1 LEFT JOIN "dbo"."labour_types" T2 ON T1."labour_type" = T2."code"
				) LEFT JOIN "dbo"."labours" T3 ON T1."order_number" = T3."order_number"
			) LEFT JOIN "dbo"."employees" T4 ON T3."mechanic_no" = T4."employee_number"
		) ON (T3."invoice_number" = T5."invoice_number")
		AND (T3."invoice_type" = T5."invoice_type")
	)
WHERE (((convert(FLOAT, T3."time_units"))) <> 0)
	-- order by "Order Number" asc,"Order Position" asc