COGNOS QUERY
STRUCTURE,1,1
DATABASE,Navision2
DATASOURCENAME,C:\GAPS_BMW\Portal\System\IQD\Zeit\fakt_Stunden_neu.imr
TITLE,fakt_Stunden_neu.imr
BEGIN SQL
select T1."Entry No_" as c1,
	   T1."Corrected" as c2,
	   T1."Document No_" as c3,
	   T1."Document Date" as c4,
	   T1."Document Type" as c5,
	   T1."Service Document Type" as c6,
	   T1."Service Document No_" as c7,
	   T1."Service Document Line No_" as c8,
	   T1."Ass_ Serv_ Ledger Entry No_" as c9,
	   T1."Customer No_" as c10,
	   T1."Resource No_" as c11,
	   T1."Portion %" as c12,
	   T1."Rated Qty_ (Ind_ time)" as c13,
	   T1."Qty_ (Hour)" as c14,
	   T1."Clock In_Out Date" as c15,
	   T1."Service Job No_" as c16,
	   T1."No_" as c17,
	   T1."Make Code" as c18,
	   T1."VIN" as c19,
	   T1."Invoiced Time (Ind_ time)" as c20,
	   T1."Standard Time (Ind_ time)" as c21,
	   T1."Labor per Hour" as c22,
	   T1."Labor Split Rate" as c23,
	   T1."Standard Time (hrs_)" as c24,
	   T1."Standard Time labor" as c25,
	   T1."Efficiency % Position" as c26,
	   T1."Efficiency % Resource" as c27,
	   T1."Work Type" as c28,
	   T1."Invoiced Time Exported" as c29,
	   T1."Split Rate (hrs_)" as c30,
	   T1."Labor Standard Time Type" as c31,
	   (od_left(T1."Split Rate (hrs_)",1)) as c32,
	   (cast_float(T1."Invoiced Time (Ind_ time)")) as c33,
	   RSUM(((cast_float(T1."Invoiced Time (Ind_ time)")))) as c34,
	   (cast_float(T1."Labor Split Rate")) as c35,
	   T1."Document Date" as c36,
	   '1' as c37,
	   'LBS' as c38,
	   T2."No_" as c39,
	   T2."Last Name" as c40,
	   T2."First Name" as c41,
	   T2."First Name" || ' ' || T2."Last Name" as c42,
	   T1."Service Document No_" as c43
from ("DMS1"."dbo"."Automag GmbH$Clock In_Out Split LedgEntry" T1 left outer join "DMS1"."dbo"."Automag GmbH$Employee_T" T2 on T1."Resource No_" = T2."No_")

END SQL
COLUMN,0,Entry No
COLUMN,1,Corrected
COLUMN,2,Document No
COLUMN,3,Document Date
COLUMN,4,Document Type
COLUMN,5,Service Document Type
COLUMN,6,Service Document No
COLUMN,7,Service Document Line No
COLUMN,8,Ass Serv Ledger Entry No
COLUMN,9,Customer No
COLUMN,10,Resource No
COLUMN,11,Portion %
COLUMN,12,Rated Qty (ind Time)
COLUMN,13,Qty (hour)
COLUMN,14,Clock In Out Date
COLUMN,15,Service Job No
COLUMN,16,No
COLUMN,17,Make Code
COLUMN,18,Vin
COLUMN,19,Invoiced Time (ind Time)
COLUMN,20,Standard Time (ind Time)
COLUMN,21,Labor Per Hour
COLUMN,22,Labor Split Rate
COLUMN,23,Standard Time (hrs )
COLUMN,24,Standard Time Labor
COLUMN,25,Efficiency % Position
COLUMN,26,Efficiency % Resource
COLUMN,27,Work Type
COLUMN,28,Invoiced Time Exported
COLUMN,29,Split Rate (hrs )
COLUMN,30,Labor Standard Time Type
COLUMN,31,Stunde
COLUMN,32,fakt. Stunden
COLUMN,33,Summe  (Inv Time) Nr.1
COLUMN,34,Labor Split Rate_Zeit
COLUMN,35,Datum
COLUMN,36,Hauptbetrieb
COLUMN,37,Standort
COLUMN,38,No
COLUMN,39,Last Name
COLUMN,40,First Name
COLUMN,41,Monteur
COLUMN,42,Order Number