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

COGNOS QUERY
STRUCTURE,1,1
DATABASE,CIS_Daten
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\CIS_4_Honda.imr
TITLE,CIS_4_Honda.imr
BEGIN SQL
select T1."Acct_Nr" as c1,
	   T1."Betrieb_ori" as c2,
	   CASE WHEN (T1."Betrieb_ori" IS NULL) THEN ('01') 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,
	   'G.V.O.' as c13,
	   'H' as c14,
	   '100200 - H' as c15
from "s_Honda_4_Tabelle" 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,Betrag
COLUMN,10,Summe
COLUMN,11,Kst
COLUMN,12,Rechtseinheit
COLUMN,13,Marke
COLUMN,14,Mandant