COGNOS QUERY
STRUCTURE,1,1
DATABASE,werwiso
DATASOURCENAME,C:\GlobalCube\System\WERWISO\IQD\serv_teile\Service_intern_Rechnungsausgangsbuch_Monteur_1.imr
TITLE,Service_intern_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,
	   T2."MengeMonteurID1" as c8,
	   T2."MonteurID2" as c9,
	   T2."MengeMonteurID2" as c10,
	   T2."MonteurID3" as c11,
	   T2."MengeMonteurID3" as c12,
	   T3."SplitNr" as c13,
	   T2."MonteurID1" as c14,
	   (((cdatetime(T1."Rechnungsdatum")))) as c15,
	   T2."MengeMonteurID1" / 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"."INREBUCH" T1 left outer join "\\210.3.206.23\werwiso\wwsDaten\WerWiSoTabs\SuK\Mandant.add"."VORGANG" T3 on T1."Vorgangsnummer" = T3."Vorgangsnummer")
where ((T3."Vorgangsnummer" = T2."Vorgangsnummer") and (T3."SplitNr" = T2."SplitNr"))
and (((((((T2."MonteurID1" IS NOT NULL) and (T3."Vorgangsart" IN ('Barverkauf          ','Garantie            ','Service             ','Interne Rechnun'))) 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