COGNOS QUERY
STRUCTURE,1,1
DATABASE,GAPS_Audev
DATASOURCENAME,C:\GAPS_Audev\Portal\System\IQD\Belege\Kontenrahmen.imr
TITLE,Kontenrahmen.imr
BEGIN SQL
select T1."ACCOUNT_NR" as c1,
	   T1."DESCRIPTION" as c2,
	   T1."BALANCE_PAL" as c3,
	   T1."KOSTENSTELLE" as c4,
	   T1."STK" as c5,
	   T1."KONTO_1" as c6,
	   T1."KONTO_2" as c7,
	   T1."KONTO_3" as c8,
	   T1."KONTO_4" as c9,
	   T1."KONTO_5" as c10,
	   T1."EBENE1" as c11,
	   T1."EBENE2" as c12,
	   T1."EBENE3" as c13,
	   T1."EBENE4" as c14,
	   T1."EBENE5" as c15,
	   T1."EBENE6" as c16,
	   T1."EBENE7" as c17,
	   T1."EBENE8" as c18,
	   T1."EBENE9" as c19,
	   T1."EBENE10" as c20,
	   T1."EBENE11" as c21,
	   T1."EBENE12" as c22,
	   T1."EBENE13" as c23,
	   T1."EBENE14" as c24,
	   T1."EBENE15" as c25,
	   T1."EBENE16" as c26,
	   T1."EBENE17" as c27,
	   T1."EBENE18" as c28,
	   T1."EBENE19" as c29,
	   T1."EBENE20" as c30,
	   T1."EBENE21" as c31,
	   T1."EBENE22" as c32,
	   T1."EBENE23" as c33,
	   T1."EBENE24" as c34,
	   T1."EBENE25" as c35,
	   T1."EBENE26" as c36,
	   T1."EBENE27" as c37,
	   T1."EBENE28" as c38,
	   T1."EBENE29" as c39,
	   T1."EBENE30" as c40,
	   T1."EBENE31" as c41,
	   T1."EBENE32" as c42,
	   T1."EBENE33" as c43,
	   T1."EBENE34" as c44,
	   T1."EBENE35" as c45,
	   T1."EBENE36" as c46,
	   T1."EBENE37" as c47,
	   T1."EBENE38" as c48,
	   T1."EBENE39" as c49,
	   T1."EBENE40" as c50,
	   T1."EBENE41" as c51,
	   T1."EBENE42" as c52,
	   T1."EBENE43" as c53,
	   T1."EBENE44" as c54,
	   T1."EBENE45" as c55,
	   T1."EBENE46" as c56,
	   T1."EBENE47" as c57,
	   T1."EBENE48" as c58,
	   T1."EBENE49" as c59,
	   T1."EBENE50" as c60,
	   T1."EBENE51" as c61,
	   T1."EBENE52" as c62,
	   T1."EBENE53" as c63,
	   T1."EBENE54" as c64,
	   T1."EBENE55" as c65,
	   T1."EBENE56" as c66,
	   T1."EBENE57" as c67,
	   T1."EBENE58" as c68,
	   T1."EBENE59" as c69,
	   T1."EBENE60" as c70,
	   (length(T1."ACCOUNT_NR" || 'Z') - 1) as c71,
	   T1."ACCOUNT_NR" as c72,
	   CASE WHEN (((length(T1."ACCOUNT_NR" || 'Z') - 1)) < 6) THEN ('0') ELSE ((od_left(T1."ACCOUNT_NR",1))) END as c73,
	   T1."BALANCE_PAL" as c74,
	   T1."ACCOUNT_NR" || ' - ' || T1."DESCRIPTION" as c75
from "Kontenrahmen.txt" T1
where (((length(T1."ACCOUNT_NR" || 'Z') - 1)) <> 7)

END SQL
COLUMN,0,Account Nr
COLUMN,1,Description
COLUMN,2,Balance Pal
COLUMN,3,Kostenstelle
COLUMN,4,Stk
COLUMN,5,Konto 1
COLUMN,6,Konto 2
COLUMN,7,Konto 3
COLUMN,8,Konto 4
COLUMN,9,Konto 5
COLUMN,10,Ebene1
COLUMN,11,Ebene2
COLUMN,12,Ebene3
COLUMN,13,Ebene4
COLUMN,14,Ebene5
COLUMN,15,Ebene6
COLUMN,16,Ebene7
COLUMN,17,Ebene8
COLUMN,18,Ebene9
COLUMN,19,Ebene10
COLUMN,20,Ebene11
COLUMN,21,Ebene12
COLUMN,22,Ebene13
COLUMN,23,Ebene14
COLUMN,24,Ebene15
COLUMN,25,Ebene16
COLUMN,26,Ebene17
COLUMN,27,Ebene18
COLUMN,28,Ebene19
COLUMN,29,Ebene20
COLUMN,30,Ebene21
COLUMN,31,Ebene22
COLUMN,32,Ebene23
COLUMN,33,Ebene24
COLUMN,34,Ebene25
COLUMN,35,Ebene26
COLUMN,36,Ebene27
COLUMN,37,Ebene28
COLUMN,38,Ebene29
COLUMN,39,Ebene30
COLUMN,40,Ebene31
COLUMN,41,Ebene32
COLUMN,42,Ebene33
COLUMN,43,Ebene34
COLUMN,44,Ebene35
COLUMN,45,Ebene36
COLUMN,46,Ebene37
COLUMN,47,Ebene38
COLUMN,48,Ebene39
COLUMN,49,Ebene40
COLUMN,50,Ebene41
COLUMN,51,Ebene42
COLUMN,52,Ebene43
COLUMN,53,Ebene44
COLUMN,54,Ebene45
COLUMN,55,Ebene46
COLUMN,56,Ebene47
COLUMN,57,Ebene48
COLUMN,58,Ebene49
COLUMN,59,Ebene50
COLUMN,60,Ebene51
COLUMN,61,Ebene52
COLUMN,62,Ebene53
COLUMN,63,Ebene54
COLUMN,64,Ebene55
COLUMN,65,Ebene56
COLUMN,66,Ebene57
COLUMN,67,Ebene58
COLUMN,68,Ebene59
COLUMN,69,Ebene60
COLUMN,70,Anzahl_Stellen_Konto
COLUMN,71,Acct Nr
COLUMN,72,Susa
COLUMN,73,GuV_Bilanz
COLUMN,74,Konto