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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,CIS_Daten
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\CIS_8.imr
TITLE,CIS_8.imr
BEGIN SQL
select T1."Acct_Nr" as c1,
	   T1."Betrieb_ori" as c2,
	   CASE WHEN (T1."Acct_Nr" LIKE '2%') THEN ('07') WHEN (T1."Betrieb_ori" IS NULL) THEN ('07') ELSE ('0' || T1."Betrieb_ori") END as c3,
	   T1."Ledger_Accts_Name" as c4,
	   T1."Tabelle" as c5,
	   T1."Int_Voucher_No" as c6,
	   T1."Bookkeep_Date" as c7,
	   T1."Beleg" as c8,
	   T1."Comment" as c9,
	   T1."Summe" as c10,
	   CASE WHEN (T1."Acct_Nr" LIKE '8%') THEN (T1."Summe" * -1) ELSE (T1."Summe") END as c11,
	   T1."KST1" as c12,
	   T1."KST2" as c13,
	   T1."KST3" as c14,
	   T1."KST4" as c15,
	   T1."KST5" as c16,
	   T1."KST6" as c17,
	   T1."KST7" as c18,
	   T1."KST8" as c19,
	   T1."KST9" as c20,
	   CASE WHEN (((od_left(T1."Acct_Nr",2)) IN ('70','80','71','81')) or ((od_left(T1."Acct_Nr",3)) IN ('770','780','870','880'))) THEN ('1') WHEN ((od_left(T1."Acct_Nr",2)) IN ('72','82')) THEN ('2') WHEN (((od_left(T1."Acct_Nr",2)) IN ('73','83')) or ((od_left(T1."Acct_Nr",3)) IN ('773','783','786','873','883','886'))) THEN ('6') WHEN ((od_left(T1."Acct_Nr",3)) IN ('740','743','747','748','749','774','784','840','843','847','848','849','874','884')) THEN ('3') WHEN ((od_left(T1."Acct_Nr",3)) IN ('741','742','841','842')) THEN ('4') WHEN ((od_left(T1."Acct_Nr",2)) IN ('75','85')) THEN ('5') WHEN ((od_left(T1."Acct_Nr",2)) IN ('76','86')) THEN ('7') WHEN ((od_left(T1."Acct_Nr",1)) = '2') THEN ('0') WHEN (T1."Acct_Nr" IN ('8870','7870')) THEN ('0') ELSE ('prüfen') END as c21,
	   'G.V.O.' as c22,
	   CASE WHEN ((od_left(T1."Acct_Nr",2)) IN ('77','87')) THEN ('Y') WHEN ((od_left(T1."Acct_Nr",3)) IN ('780','783','880','883')) THEN ('S') WHEN ((od_left(T1."Acct_Nr",3)) IN ('784','786','787','884','886','887')) THEN ('H') ELSE ('O') END as c23,
	   '109900 - AZ' as c24
from "s_AZWest_8" T1

END SQL
COLUMN,0,Acct Nr
COLUMN,1,Betrieb Ori
COLUMN,2,Betrieb
COLUMN,3,Ledger Accts Name
COLUMN,4,Tabelle
COLUMN,5,Int Voucher No
COLUMN,6,Bookkeep Date
COLUMN,7,Beleg
COLUMN,8,Comment
COLUMN,9,Summe
COLUMN,10,Betrag
COLUMN,11,Kst1
COLUMN,12,Kst2
COLUMN,13,Kst3
COLUMN,14,Kst4
COLUMN,15,Kst5
COLUMN,16,Kst6
COLUMN,17,Kst7
COLUMN,18,Kst8
COLUMN,19,Kst9
COLUMN,20,Kostenstelle
COLUMN,21,Rechtseinheit
COLUMN,22,Marke
COLUMN,23,Mandant