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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,CIS_Daten
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\CIS_8_Peug.imr
TITLE,CIS_8_Peug.imr
BEGIN SQL
select T1."Acct_Nr" as c1,
	   T1."Betrieb_ori" as c2,
	   CASE WHEN ((T1."Betrieb_ori" IS NULL) and (T1."Acct_Nr" LIKE '2%')) THEN ('07') WHEN (T1."Betrieb_ori" IS NULL) THEN ('06') 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."Summe_KST" as c16,
	   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 ((od_left(T1."Acct_Nr",1)) = '4') THEN ('0') ELSE ('prüfen') END as c17,
	   'G.V.O.' as c18,
	   'P' as c19,
	   '100300 - P' as c20
from "s_Peogeot_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,Summe Kst
COLUMN,16,Kostenstelle
COLUMN,17,Rechtseinheit
COLUMN,18,Marke
COLUMN,19,Mandant