GAPS/Portal/System/IQD/Belege/Kontenrahmen/Kontenrahmen_deaf01.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\gaps\Portal\System\IQD\Belege\Kontenrahmen\Kontenrahmen_deaf01.imr
TITLE,Kontenrahmen_deaf01.imr
BEGIN SQL
select T1."ACCT_NR" as c1,
	   T1."LEDGER_ACCTS_NAME" as c2,
	   T1."LEDGER_ACCTS_NAME2" as c3,
	   T1."DEPT_SPLIT" as c4,
	   T1."TYPE_ACCTT" as c5,
	   (database()) as c6
from "deaf01"."dbo"."ACCOUNT_INFO" T1

END SQL
COLUMN,0,Acct Nr
COLUMN,1,Ledger Accts Name
COLUMN,2,Ledger Accts Name2
COLUMN,3,Dept Split
COLUMN,4,Type Acctt
COLUMN,5,Mandant