C11/System/AUTOLINE/IQD/Belege/Kontenrahmen_Service_Erfolgsrechnung.iqd

COGNOS QUERY
STRUCTURE,1,1
DATABASE,GCStruct
DATASOURCENAME,C:\GlobalCube\System\Autoline\IQD\belege\Kontenrahmen_Service_Erfolgsrechnung.imr
TITLE,Kontenrahmen_Service_Erfolgsrechnung.imr
BEGIN SQL
select T1."KONTO_NR" as c1,
	   T1."KONTO_BEZEICHNUNG" as c2,
	   T1."KONTO_ART" 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
from "Kontenrahmen.csv" T1
where ((T1."EBENE1" IN ('Ersatzteilhandel','Werkstatt')) and (T1."KONTO_1" IN ('Umsatzerlöse','Einsatzwerte')))

END SQL
COLUMN,0,Konto Nr
COLUMN,1,Konto Bezeichnung
COLUMN,2,Konto Art
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