COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\serv_teile\Service_Rechnungsausgangsbuch_Monteur_4.imr
TITLE,Service_Rechnungsausgangsbuch_Monteur_4.imr
BEGIN SQL
select T1."Vorgangsnummer" as c1,
	   (cdatetime(T1."Rechnungsdatum")) as c2,
	   T1."RechArt" as c3,
	   ((cdatetime(T1."Rechnungsdatum"))) as c4,
	   T2."Positionskennzeichen" as c5,
	   T2."Positionsnummer" as c6,
	   T2."MonteurID1" as c7,
	   CASE WHEN (T1."RechArt" = 'Gutschrift                                        ') THEN (T2."MengeMonteurID1" * -1) ELSE (T2."MengeMonteurID1") END as c8,
	   T2."MonteurID2" as c9,
	   CASE WHEN (T1."RechArt" = 'Gutschrift                                        ') THEN (T2."MengeMonteurID2" * -1) ELSE (T2."MengeMonteurID2") END as c10,
	   T2."MonteurID3" as c11,
	   CASE WHEN (T1."RechArt" = 'Gutschrift                                        ') THEN (T2."MengeMonteurID3" * -1) ELSE (T2."MengeMonteurID3") END as c12,
	   T3."SplitNr" as c13,
	   T2."MonteurID4" as c14,
	   (((cdatetime(T1."Rechnungsdatum")))) as c15,
	   (CASE WHEN (T1."RechArt" = 'Gutschrift                                        ') THEN (T2."MengeMonteurID4" * -1) ELSE (T2."MengeMonteurID4") END) / 10 * (T2."RE_Prozent" / 100) as c16,
	   T3."SplitNr" as c17,
	   T3."Filial_ID" as c18,
	   T2."MonteurID4" as c19,
	   CASE WHEN (T1."RechArt" = 'Gutschrift                                        ') THEN (T2."MengeMonteurID4" * -1) ELSE (T2."MengeMonteurID4") END as c20,
	   T2."MonteurID5" as c21,
	   CASE WHEN (T1."RechArt" = 'Gutschrift                                        ') THEN (T2."MengeMonteurID5" * -1) ELSE (T2."MengeMonteurID5") END as c22
from "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."Vorgposi" T2,
	("\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."REAUBUCH" T1 left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."VORGANG" T3 on T3."Vorgangsnummer" = T1."Vorgangsnummer")
where ((T3."Vorgangsnummer" = T2."Vorgangsnummer") and (T3."SplitNr" = T2."SplitNr"))
and (((((((T2."MonteurID4" IS NOT NULL) and ((T3."Vorgangsart" IN ('Barverkauf          ','Garantie            ','Service             ')) or ((T3."Vorgangsart" = 'Verkauf        ') and (T1."RechArt" IN ('Gutschrift                                        ','Service                                           ','Verkauf                                           '))))) and (T1."Name" <> 'Storniert')) and (not T2."Positionskennzeichen" IN ('T ','TB'))) and (not T2."KostRechMerkKostenstelle" BETWEEN '10' AND '29')) and (not T2."Kostenstelle" BETWEEN '10' AND '29')) and (not T2."Erloeskonto" LIKE '4%'))
order by c1 asc

END SQL
COLUMN,0,Vorgangsnummer
COLUMN,1,Rechnungsdatum
COLUMN,2,Rechart
COLUMN,3,Invoice Date
COLUMN,4,Positionskennzeichen
COLUMN,5,Positionsnummer
COLUMN,6,Monteurid1
COLUMN,7,Mengemonteurid1
COLUMN,8,Monteurid2
COLUMN,9,Mengemonteurid2
COLUMN,10,Monteurid3
COLUMN,11,Mengemonteurid3
COLUMN,12,Splitnr
COLUMN,13,Monteurnr
COLUMN,14,Datum
COLUMN,15,verr. Zeit
COLUMN,16,Order Number
COLUMN,17,Filial Id
COLUMN,18,Monteurid4
COLUMN,19,Mengemonteurid4
COLUMN,20,Monteurid5
COLUMN,21,Mengemonteurid5