GAPS/Portal/System/IQD/Belege/Aufbau/Kontenrahmen/Kostenstellen fehlt_dere09.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,O_21_9
DATASOURCENAME,C:\Gaps\Portal\System\IQD\Belege\Aufbau\Kontenrahmen\Kostenstellen fehlt_dere09.imr
TITLE,Kostenstellen fehlt_dere09.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 "dere09"."dbo"."ACCOUNT_INFO" T1
where (((T1."TYPE_ACCTT" = '2') and ((od_left(T1."ACCT_NR",1)) <> '2')) and (T1."DEPT_SPLIT" = 0))

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