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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GDP
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\GDPDU_Bilanz.imr
TITLE,GDPDU_Bilanz.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,
	   T1."Betrag" 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 ('0','1','3')) 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