COGNOS QUERY
STRUCTURE,1,1
DATABASE,GC_Navision
DATASOURCENAME,C:\GlobalCube\System\NAVISION\IQD\Serv_Teile\Service_Archiv_Rg_Ausgang_GWL.imr
TITLE,Service_Archiv_Rg_Ausgang_GWL.imr
BEGIN SQL
select distinct T1."No_" as c1,
	   T1."Posting Date" as c2,
	   T1."Document Date" as c3,
	   T2."Order No_" as c4,
	   CASE WHEN (T2."Source No_ (Payment)" LIKE 'INT%') THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END as c5
from "NAVISION"."import"."Archived_Service_Header" T1,
	"NAVISION"."import"."Service_Ledger_Entry" T2
where ((T1."No_" = T2."Order No_") and (T1."Client_DB" = T2."Client_DB"))
and ((((((T1."Document Type" <> 0) and ((extract(DAY FROM (now()) - T1."Posting Date")) <= 7)) and (T2."Entry Type" = 0)) and (T1."Gen_ Prod_ Posting Group" <> 'FEHLER')) and ((CASE WHEN (T1."Location Code" = 'MM') THEN ('10') WHEN (T1."Location Code" = 'VÖH') THEN ('20') WHEN (T1."Location Code" = 'KRU') THEN ('30') WHEN (T1."Location Code" = 'ULM') THEN ('40') WHEN (T1."Location Code" = 'LL') THEN ('50') ELSE null END) <> '20')) and ((CASE WHEN (T2."Source No_ (Payment)" LIKE 'INT%') THEN ('Intern') WHEN (T2."Source No_ (Payment)" LIKE 'GARA%') THEN ('GWL') ELSE ('Extern') END) = 'GWL'))
order by c1 asc

END SQL
COLUMN,0,No
COLUMN,1,Posting Date
COLUMN,2,Document Date
COLUMN,3,Order No
COLUMN,4,Umsatzart