C11/System/WERWISO/IQD/Serv_Teile/Service_Rechnungsausgangsbuch_Monteur_1.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\serv_teile\Service_Rechnungsausgangsbuch_Monteur_1.imr
TITLE,Service_Rechnungsausgangsbuch_Monteur_1.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."MonteurID1" as c14,
	   (((cdatetime(T1."Rechnungsdatum")))) as c15,
	   (CASE WHEN (T1."RechArt" = 'Gutschrift                                        ') THEN (T2."MengeMonteurID1" * -1) ELSE (T2."MengeMonteurID1") END) / 10 * (T2."RE_Prozent" / 100) as c16,
	   T3."SplitNr" as c17,
	   T2."RE_Prozent" as c18,
	   T3."Filial_ID" as c19
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."MonteurID1" IS NOT NULL) or (T2."MonteurID2" IS NOT NULL)) or (T2."MonteurID3" 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,Re Prozent
COLUMN,18,Filial Id