GAPS/Portal/System/IQD/Belege/Komplett/STK_Uebernahme.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,STK_Uebernahme
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\STK_Uebernahme.imr
TITLE,STK_Uebernahme
BEGIN SQL
select T1."Acct Nr_ori" as c1,
	   T1."Kst neu" as c2,
	   T1."Bezeichnung" as c3,
	   T1."Betrag" as c4,
	   T1."Ebene1" as c5,
	   T1."Ebene2" as c6,
	   T1."Ebene3" as c7,
	   T1."Ebene4" as c8,
	   T1."Ebene5" as c9,
	   T1."Ebene6" as c10,
	   T1."Konto" as c11,
	   T1."Acct Nr" as c12,
	   T1."Marke" as c13,
	   T1."Mandant" as c14,
	   T1."Kostenstelle" as c15,
	   T1."Rechtseinheit" as c16,
	   T1."Betrieb" as c17,
	   T1."Text" as c18,
	   T1."Bookkeep Date" as c19
from "STK_Uebernahme" T1

END SQL
COLUMN,0,Acct Nr Ori
COLUMN,1,Kst Neu
COLUMN,2,Bezeichnung
COLUMN,3,Betrag
COLUMN,4,Ebene1
COLUMN,5,Ebene2
COLUMN,6,Ebene3
COLUMN,7,Ebene4
COLUMN,8,Ebene5
COLUMN,9,Ebene6
COLUMN,10,Konto
COLUMN,11,Acct Nr
COLUMN,12,Marke
COLUMN,13,Mandant
COLUMN,14,Kostenstelle
COLUMN,15,Rechtseinheit
COLUMN,16,Betrieb
COLUMN,17,Text
COLUMN,18,Bookkeep Date