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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,CIS_Daten
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\CIS_4.imr
TITLE,CIS_4.imr
BEGIN SQL
select T1."Acct_Nr" as c1,
	   T1."Betrieb_ori" as c2,
	   CASE 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."Betrag" as c10,
	   T1."Summe" as c11,
	   T1."Kst" as c12,
	   CASE WHEN (T1."Kst" IN ('8','9')) THEN ('0') WHEN (T1."Kst" = '3') THEN ('6') WHEN (T1."Kst" = '4') THEN ('3') WHEN (T1."Kst" = '5') THEN ('4') WHEN (T1."Kst" = '6') THEN ('5') ELSE (T1."Kst") END as c13,
	   'G.V.O.' as c14,
	   CASE WHEN (((CASE WHEN (T1."Betrieb_ori" IS NULL) THEN ('07') ELSE ('0' || T1."Betrieb_ori") END) IN ('07','01','02','03','04','05')) and (T1."Kst" = '8')) THEN ('Y') WHEN (((CASE WHEN (T1."Betrieb_ori" IS NULL) THEN ('07') ELSE ('0' || T1."Betrieb_ori") END) IN ('07','01','02','03','04','05')) and (T1."Kst" = '9')) THEN ('H') WHEN (((CASE WHEN (T1."Betrieb_ori" IS NULL) THEN ('07') ELSE ('0' || T1."Betrieb_ori") END) = '06') and (T1."Kst" = '8')) THEN ('P') WHEN (((CASE WHEN (T1."Betrieb_ori" IS NULL) THEN ('07') ELSE ('0' || T1."Betrieb_ori") END) = '06') and (T1."Kst" = '9')) THEN ('S') ELSE ('O') END as c15,
	   '109900 - AZ' as c16,
	   CASE WHEN ((CASE WHEN (T1."Kst" IN ('8','9')) THEN ('0') WHEN (T1."Kst" = '3') THEN ('6') WHEN (T1."Kst" = '4') THEN ('3') WHEN (T1."Kst" = '5') THEN ('4') WHEN (T1."Kst" = '6') THEN ('5') ELSE (T1."Kst") END) = '0') THEN (T1."Acct_Nr" || '0') ELSE (T1."Acct_Nr") END as c17
from "s_AZWest_4_Tabelle" T1

END SQL
COLUMN,0,Acct Nr_ori
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,Betrag
COLUMN,10,Summe
COLUMN,11,Kst
COLUMN,12,Kostenstelle
COLUMN,13,Rechtseinheit
COLUMN,14,Marke
COLUMN,15,Mandant
COLUMN,16,Acct Nr