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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Locosoft_GC
DATASOURCENAME,C:\GlobalCube\System\LOCOSOFT\IQD\zeit\Zeit_verk_Std.imr
TITLE,Zeit_verk_Std.imr
BEGIN SQL
select T1."order_number" as c1,
	   T1."order_position" as c2,
	   T1."labour_type" as c3,
	   T2."code" as c4,
	   T2."description" as c5,
	   T3."order_number" as c6,
	   T3."order_position" as c7,
	   T3."order_position_line" as c8,
	   '0' || (rtrim((cast_numberToString(cast_integer(T4."subsidiary"))))) as c9,
	   T3."is_invoiced" as c10,
	   T3."invoice_type" as c11,
	   T3."invoice_number" as c12,
	   T3."employee_no" as c13,
	   T3."mechanic_no" as c14,
	   T3."labour_operation_id" as c15,
	   T3."is_nominal" as c16,
	   T3."net_price_in_order" as c17,
	   T3."rebate_percent" as c18,
	   T3."goodwill_percent" as c19,
	   T3."charge_type" as c20,
	   T3."text_line" as c21,
	   10 as c22,
	   ((cast_float(T3."time_units"))) / 10 as c23,
	   'verk. Std.' as c24,
	   '' as c25,
	   T4."employee_number" as c26,
	   T4."name" as c27,
	   (rtrim((cast_numberToString(cast_integer(T4."employee_number"))))) || ' - ' || T4."name" as c28,
	   T5."invoice_number" as c29,
	   T5."invoice_date" as c30,
	   T5."invoice_date" as c31,
	   T3."time_units" as c32,
	   (cast_float(T3."time_units")) as c33
from ("dbo"."invoices" T5 left outer join ((("dbo"."order_positions" T1 left outer join "dbo"."labour_types" T2 on T1."labour_type" = T2."code") left outer join "dbo"."labours" T3 on T1."order_number" = T3."order_number") left outer 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 (((cast_float(T3."time_units"))) <> 0)
order by c1 asc,c2 asc

END SQL
COLUMN,0,Order Number
COLUMN,1,Order Position
COLUMN,2,Labour Type
COLUMN,3,Code_Labour_Types
COLUMN,4,Description_Labour_Types
COLUMN,5,Order Number_Labours
COLUMN,6,Order Position_Labours
COLUMN,7,Order Position Line_Labours
COLUMN,8,Subsidiary_Labours
COLUMN,9,Is Invoiced_Labours
COLUMN,10,Invoice Type_Labours
COLUMN,11,Invoice Number_Labours
COLUMN,12,Employee No_Labours
COLUMN,13,Mechanic No_Labours
COLUMN,14,Labour Operation Id_Labours
COLUMN,15,Is Nominal_Labours
COLUMN,16,Net Price In Order_Labours
COLUMN,17,Rebate Percent_Labours
COLUMN,18,Goodwill Percent_Labours
COLUMN,19,Charge Type_Labours
COLUMN,20,Text Line_Labours
COLUMN,21,AW/Std.
COLUMN,22,verk. Std.
COLUMN,23,Zeitkategorie
COLUMN,24,Zeitkategorie2
COLUMN,25,Employee Number_Employee
COLUMN,26,Name_Employee
COLUMN,27,Monteur
COLUMN,28,Invoice Number_Invoices
COLUMN,29,Invoice Date_Invoices
COLUMN,30,Datum
COLUMN,31,Time Units_Labours
COLUMN,32,Time_Units_Zahl