C11/System/NAVISION/IQD/Belege/bankenspiegel.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,Struktur
DATASOURCENAME,C:\GlobalCube\System\NAVISION\IQD\belege\bankenspiegel.imr
TITLE,bankenspiegel.imr
BEGIN SQL
select T1."ID" as c1,
	   T1."Betrieb Nr" as c2,
	   T1."Bank" as c3,
	   T1."Stufe 1" as c4,
	   T1."Konto Nr" as c5,
	   T1."Bezeichnung" as c6,
	   T1."Bemerkung" as c7,
	   T1."Besicherung" as c8,
	   T1."Kreditlinie detailliert" as c9,
	   T1."Ist" * -1 as c10,
	   'LZ ' || T1."Laufzeit" as c11
from "Bankenspiegel" T1

END SQL
COLUMN,0,Id
COLUMN,1,Betrieb Nr
COLUMN,2,Bank
COLUMN,3,Stufe 1
COLUMN,4,Konto Nr
COLUMN,5,Bezeichnung
COLUMN,6,Bemerkung
COLUMN,7,Besicherung
COLUMN,8,Kreditlinie Detailliert
COLUMN,9,Ist
COLUMN,10,Laufzeit