GAPS/Portal/System/IQD/Belege/GDPDU.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GDP
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\GDPDU.imr
TITLE,GDPDU.imr
BEGIN SQL
select T1."Acct_Nr" as c1,
	   (od_left(T1."Acct_Nr",4)) as c2,
	   '0' || ((substring(T1."Acct_Nr" from 5 for 1))) as c3,
	   CASE WHEN (('0' || ((substring(T1."Acct_Nr" from 5 for 1)))) = '0') THEN ('07') ELSE (('0' || ((substring(T1."Acct_Nr" from 5 for 1))))) END as c4,
	   T1."Ledger_Accts_Name" as c5,
	   T1."Feld4" as c6,
	   T1."Feld5" as c7,
	   T1."Feld6" as c8,
	   T1."Feld7" as c9,
	   T1."Betrag" as c10,
	   CASE WHEN (((od_left(T1."Acct_Nr",4))) LIKE '8%') THEN (T1."Betrag" * -1) ELSE (T1."Betrag") END as c11,
	   T1."Feld9" as c12,
	   T1."Feld10" as c13,
	   T1."Feld11" as c14,
	   T1."Feld12" as c15,
	   T1."Feld13" as c16,
	   T1."Feld14" as c17,
	   T1."Feld15" as c18,
	   T1."Feld16" as c19,
	   'G.V.O.' as c20,
	   CASE WHEN (((od_left(((od_left(T1."Acct_Nr",4))),2)) IN ('70','80','71','81')) or ((od_left(((od_left(T1."Acct_Nr",4))),3)) IN ('770','780','870','880'))) THEN ('1') WHEN ((od_left(((od_left(T1."Acct_Nr",4))),2)) IN ('72','82')) THEN ('2') WHEN (((od_left(((od_left(T1."Acct_Nr",4))),2)) IN ('73','83')) or ((od_left(((od_left(T1."Acct_Nr",4))),3)) IN ('773','783','786','873','883','886'))) THEN ('6') WHEN ((od_left(((od_left(T1."Acct_Nr",4))),3)) IN ('740','743','747','748','749','774','784','840','843','847','848','849','874','884')) THEN ('3') WHEN ((od_left(((od_left(T1."Acct_Nr",4))),3)) IN ('741','742','841','842')) THEN ('4') WHEN ((od_left(((od_left(T1."Acct_Nr",4))),2)) IN ('75','85')) THEN ('5') WHEN ((od_left(((od_left(T1."Acct_Nr",4))),2)) IN ('76','86')) THEN ('7') WHEN ((od_left(((od_left(T1."Acct_Nr",4))),1)) = '2') THEN ('0') WHEN ((od_left(((od_left(T1."Acct_Nr",4))),1)) = '4') THEN ('0') ELSE ('prüfen') END as c21,
	   CASE WHEN ((od_left(((od_left(T1."Acct_Nr",4))),2)) IN ('77','87')) THEN ('Y') WHEN ((od_left(((od_left(T1."Acct_Nr",4))),3)) IN ('780','783','880','883')) THEN ('S') WHEN ((od_left(((od_left(T1."Acct_Nr",4))),3)) IN ('784','786','787','884','886','887')) THEN ('H') ELSE ('O') END as c22,
	   '109900 - AZ' as c23
from "GDPDU_AZWest" T1
where (((od_left(((od_left(T1."Acct_Nr",4))),1)) IN ('2','4','7','8')) and (T1."Feld4" = 2))

END SQL
COLUMN,0,Acct Nr_ori
COLUMN,1,Acct Nr
COLUMN,2,Betrieb_ori
COLUMN,3,Betrieb
COLUMN,4,Ledger Accts Name
COLUMN,5,Type Acctt
COLUMN,6,Feld5
COLUMN,7,Bookkeep Date
COLUMN,8,Feld7
COLUMN,9,Betrag_ori
COLUMN,10,Betrag
COLUMN,11,Comment
COLUMN,12,Feld10
COLUMN,13,Feld11
COLUMN,14,Feld12
COLUMN,15,Feld13
COLUMN,16,Feld14
COLUMN,17,Feld15
COLUMN,18,Feld16
COLUMN,19,Rechtseinheit
COLUMN,20,Kostenstelle
COLUMN,21,Marke
COLUMN,22,Mandant