C11/System/LOCOSOFT/IQD/Belege/kontenrahmen_gc_struct_skr.sql

select T1."KONTO_NR" as "Konto Nr",
	   T1."KONTO_BEZEICHNUNG" as "Konto Bezeichnung",
	   T1."KONTO_ART" as "Konto Art_ori",
	   T1."KOSTENSTELLE" as "Kostenstelle",
	   T1."STK" as "Stk",
	   T1."KONTO_1" as "Konto 1",
	   T1."KONTO_2" as "Konto 2",
	   T1."KONTO_3" as "Konto 3",
	   T1."KONTO_4" as "Konto 4",
	   T1."KONTO_5" as "Konto 5",
	   T1."EBENE1" as "Ebene1",
	   T1."EBENE2" as "Ebene2",
	   T1."EBENE3" as "Ebene3",
	   T1."EBENE4" as "Ebene4",
	   T1."EBENE5" as "Ebene5",
	   T1."EBENE6" as "Ebene6",
	   T1."EBENE7" as "Ebene7",
	   T1."EBENE8" as "Ebene8",
	   T1."EBENE9" as "Ebene9",
	   T1."EBENE10" as "Ebene10",
	   T1."EBENE11" as "Ebene11",
	   T1."EBENE12" as "Ebene12",
	   T1."EBENE13" as "Ebene13",
	   T1."EBENE14" as "Ebene14",
	   T1."EBENE15" as "Ebene15",
	   T1."EBENE16" as "Ebene16",
	   T1."EBENE17" as "Ebene17",
	   T1."EBENE18" as "Ebene18",
	   T1."EBENE19" as "Ebene19",
	   T1."EBENE20" as "Ebene20",
	   T1."EBENE21" as "Ebene21",
	   T1."EBENE22" as "Ebene22",
	   T1."EBENE23" as "Ebene23",
	   T1."EBENE24" as "Ebene24",
	   T1."EBENE25" as "Ebene25",
	   T1."EBENE26" as "Ebene26",
	   T1."EBENE27" as "Ebene27",
	   T1."EBENE28" as "Ebene28",
	   T1."EBENE29" as "Ebene29",
	   T1."EBENE30" as "Ebene30",
	   T1."EBENE31" as "Ebene31",
	   T1."EBENE32" as "Ebene32",
	   T1."EBENE33" as "Ebene33",
	   T1."EBENE34" as "Ebene34",
	   T1."EBENE35" as "Ebene35",
	   T1."EBENE36" as "Ebene36",
	   T1."EBENE37" as "Ebene37",
	   T1."EBENE38" as "Ebene38",
	   T1."EBENE39" as "Ebene39",
	   T1."EBENE40" as "Ebene40",
	   T1."EBENE41" as "Ebene41",
	   T1."EBENE42" as "Ebene42",
	   T1."EBENE43" as "Ebene43",
	   T1."EBENE44" as "Ebene44",
	   T1."EBENE45" as "Ebene45",
	   T1."EBENE46" as "Ebene46",
	   T1."EBENE47" as "Ebene47",
	   T1."EBENE48" as "Ebene48",
	   T1."EBENE49" as "Ebene49",
	   T1."EBENE50" as "Ebene50",
	   T1."EBENE51" as "Ebene51",
	   T1."EBENE52" as "Ebene52",
	   T1."EBENE53" as "Ebene53",
	   T1."EBENE54" as "Ebene54",
	   T1."EBENE55" as "Ebene55",
	   T1."EBENE56" as "Ebene56",
	   T1."EBENE57" as "Ebene57",
	   T1."EBENE58" as "Ebene58",
	   T1."EBENE59" as "Ebene59",
	   T1."EBENE60" as "Ebene60",
	   T1."EBENE61" as "Ebene61",
	   T1."EBENE62" as "Ebene62",
	   T1."EBENE63" as "Ebene63",
	   T1."EBENE64" as "Ebene64",
	   T1."EBENE65" as "Ebene65",
	   T1."EBENE66" as "Ebene66",
	   T1."EBENE67" as "Ebene67",
	   T1."EBENE68" as "Ebene68",
	   T1."EBENE69" as "Ebene69",
	   T1."EBENE70" as "Ebene70",
	   T1."EBENE71" as "Ebene71",
	   T1."EBENE72" as "Ebene72",
	   T1."EBENE73" as "Ebene73",
	   T1."EBENE74" as "Ebene74",
	   T1."EBENE75" as "Ebene75",
	   T1."EBENE76" as "Ebene76",
	   T1."EBENE77" as "Ebene77",
	   T1."EBENE78" as "Ebene78",
	   T1."EBENE79" as "Ebene79",
	   T1."EBENE80" as "Ebene80",
	   T1."EBENE81" as "Ebene81",
	   T1."EBENE82" as "Ebene82",
	   T1."EBENE83" as "Ebene83",
	   T1."EBENE84" as "Ebene84",
	   T1."EBENE85" as "Ebene85",
	   T1."EBENE86" as "Ebene86",
	   T1."EBENE87" as "Ebene87",
	   T1."EBENE88" as "Ebene88",
	   T1."EBENE89" as "Ebene89",
	   T1."EBENE90" as "Ebene90",
	   (len(T1."KONTO_NR" + 'Z') - 1) as "Anzahl Stellen_Konto_Nr",
	   T1."KONTO_ART" as "Konto Art",
	   T1."KONTO_ART" as "GuV_Bilanz",
	   T1."KONTO_NR" as "Acct Nr",
	   T1."KONTO_NR" + ' - ' + T1."KONTO_BEZEICHNUNG" as "Konto",
	   (left(T1."KONTO_NR",1)) as "Susa"
from "Kontenrahmen.csv" T1
where (((left(T1."KONTO_NR",1))) <> '9')