GAPS/Portal/System/IQD/Belege/Aufbau Kontenrahmen/Kontenrahmen_op01_Bilanzkonten.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O21
DATASOURCENAME,C:\GAPS\Portal\System\IQD\Belege\Aufbau Kontenrahmen\Kontenrahmen_op01_Bilanzkonten.imr
TITLE,Kontenrahmen_op01_Bilanzkonten.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 "deop01"."dbo"."ACCOUNT_INFO" T1
where (T1."TYPE_ACCTT" = '1')

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