{"text_format":"2","workbook":"xls","n_sheets":23,"sheets":["Allgemeines","Einzelbuchung","Kapitel","Titel","Titelgruppe","Projekt","Kostenstelle","Kostenart","TitelKostenart","Finanzart","ProjektGeldgeber","ProjektKostenstelle","ProjektGeldgeberNotiz","Geldgeber","Mahnung","Zahlungspartner","ZahungspartnerAusland","Finanzstatistik","BetriebGewerblicherArt","MehrwertsteuerArt","Untertitel","Sachbearbeiter","Dauerauftrag"],"not_rendered":{"charts":0,"images":323,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Allgemeines","index":0,"n_rows":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":false,"merged":[[36,0,36,8],[37,0,37,8],[38,0,38,8]],"flags":["formulas_cached_only"]}
["CEUS-FHs - Lokales Data-Warehouse-System der bayerischen Hochschulen für angewandte Wissenschafften"]
["Domäne Finanzcontrolling"]
["Stand 04.07.2019"]
[]
["Allgemeine Vorgaben zur File-Generierung:"]
[]
["Fileformat","csv, mit Spaltenüberschriften"]
["Zeichensatz","ANSI"]
["Feldtrenner",";"]
["Zeilentrenner","{CR}{LF} (Linefeed)"]
["Texttrenner","\"","Beispiel: \"Dies ist ein Datenfeld; deswegen in Anführungszeichen!\""]
["Zahlenformat",999999.99,"(Decimal 15,2)"]
["Dezimaltrenner",","]
[]
["Filenamen","<Vorsystemkürzel>_<Mandant>_<Satzart>_<Extraktionsdatum>.txt"]
[]
[null,"Vorsystemkürzel","H","HIS-FSV (evtl. HIS-COB)"]
[null,null,"I","LfF-IHV"]
[]
[" ","Mandant","7240","HS München"]
[null,"(Hochschulnummer)","7250","HS Nürnberg"]
[null,null,"7260","HS Regensburg"]
[null,null,"7310","HS Weihenstephan-Triesdorf"]
[null,null,"7540","HS Ingolstadt"]
[null,null,"7570","HS Neu-Ulm"]
[null,null,"…"]
[]
[null,"Satzart","gemäß Bezeichnung des Arbeitsblatts"]
[]
[null,"Extraktionsdatum","JJJJMMTT"]
[]
[null,"Beispiel:","H_7250_Titel_20120502.txt"]
[]
[]
["Anmerkungen:"]
[]
["Die vorgegebene Reihenfolge der Felder muss für alle Satzarten eingehalten werden!"]
[]
["Falls zu einem Feld keine Daten geliefert werden können, muss trotzdem das Feld mit der vorgegebenen Spaltenüberschrift in der Satzart enthalten sein. In diesem Fall muss also eine leere Spalte mit der entsprechenden Spaltenüberschrift geliefert werden."]
[]
[]
["Änderungsverfolgung (nur für intern):"]
[]
["2012-06-19","\"Minuszeichen\" aus den Tabellennamen entfernt"]
["2012-07-04","ZahlungspartnerAusland: zpa.zp_name2 (statt zpa.name2)"]
["2012-07-18","Projekt: Aktenzeichen_KURZBEZ (statt Aktenzeichen_KURBEZ)"]
["2012-07-30","Semantik des Semesters in den Einzelbuchungen definiert (analog zu HIS-SOS)"]
["2012-07-30","Feldtrenner | (senkrechter Strich, Pipe)"]
["2012-08-23","Bezeichnung \"Finanzstatistik\" statt \"Finanzstatistikschluessel\""]
["2012-08-23","Bezeichnung \"BetriebGewerblicherArt\" statt \"BgA\""]
["2012-08-23","Bezeichnung \"MehrwertsteuerArt\" statt \"MWStArt\""]
["2012-08-23","Tabelle \"Mehrwertsteuer\" in \"MehrwertsteuerArt\" geändert"]
["2012-09-27","Feldtrenner ; (Semikolon)"]
["2012-09-27","Feld \"cobrel\" (COB-Relevanz) bei Kostenarten, Geldgeber und Projekt ergänzt"]
["2012-09-27","Feld \"mbsrel\" (MBS-Relevanz) bei Kostenarten, Geldgeber und Projekt ergänzt"]
["2012-10-11","Bezeichnung \"WirtschaftlicheTaetigkeit_KNZ\" statt \"WirtschftlicheTaetigkeit_KNZ\" bei Projekt"]
["2013-02-18","Feld \"kokl\" (Kontenklassenzugehörigkeit) bei Kostenarten ergänzt"]
["2013-03-01","Feld \"Budgetrelevant_KNZ\" bei den Einzelbuchungen ergänzt"]
["2013-07-02","Feld \"Finanzstatistikschlüssel\" (tit.finz_stat) bei Titel ergänzt"]
["2013-08-20","Feld \"Kostenstelle_KNZ\" bei den Einzelbuchungen in \"Sonderbudgetstelle_KNZ\" umbenannt; Feld \"Budgetkostenstelle_KNZ\" bei den Einzelbuchungen in \"Budgetstelle_KNZ\" umbenannt; "]
["2016-04-21","Feld \"Auswertungskennzeichen_KNZ\" und \"ExternerSchlüssel_KNZ\" bei Projekt und Kostenstelle hinzugefügt"]
["2019-07-04","Screenshots der Masken aus dem HIS-Quellsystem an den aktuellen Stand angepasst; diverse Felder, welche im lauf der Zeit hinzugefügt wurden, ergänzt"]
["2023-04-14","In der zwischenzeit hinzugekommene Felder ergänzt"]
["2023-05-17","Screenshots der FSV Masken durch aktuelle ersetzt"]

{"sheet":"Einzelbuchung","index":1,"n_rows":31,"n_cols":82,"rows_kept":31,"cut":false,"hidden":false,"merged":[[66,0,66,3],[6,11,6,16],[11,11,11,16]],"flags":["formulas_cached_only"]}
["Mandant","Haushaltsjahr","Kapitel_KNZ","Titel_KNZ","Titelgruppe_KNZ","Titelgruppe2_KNZ","HuelNr","HuelUnterNr","Buchungsschluessel_KNZ","Buchungskennzeichen_KNZ","Untertitel_KNZ","Projekt_KNZ","Budgetstelle_KNZ","Sonderbudgetstelle_KNZ","Ausgabeart_KNZ","OrgEinheit_KNZ","Semester","Betrag","Restbetrag","Waehrung_KNZ","Vertragsbetrag","Vertragswaehrung_KNZ","MWStBetrag","MWStSatz","MehrwertsteuerArt_KNZ","MWStTyp_KNZ","BetriebGewerblicherArt_KNZ","Verwendungszweck1_KURZBEZ","Verwendungszweck2_KURZBEZ","Verwendungszweck3_KURZBEZ","Verwendungszweck4_KURZBEZ","Verwendungszweck5_KURZBEZ","Rechnungsnummer","SteuerID","Geldgeber_KNZ","Feststeller_KURZBEZ","Kassenzeichen","Importdatei_KURZBEZ","Anordnungsart_KNZ","Buchungsdatum","Rechnungsdatum","Faelligkeitsdatum","ZPNr_KNZ","ZPName_KURZBEZ","ZPVorname_KURZBEZ","ZPPLZ_KURZBEZ","ZPOrt_KURZBEZ","ZPKundennummer_KURZBEZ","ReferenzBuchungskennzeichen_KNZ","SonstigeAnordnung_KURZBEZ","ReferenzHuelNr","ReferenzHuelUnterNr","Uebernahme_KNZ","Overheadsatz","OffenerPosten_KNZ","Storniert_KNZ","IstKassenzeichen_KURZBEZ","Sachbearbeiter_KNZ","AuswahlKennzeichen_KURZBEZ","AuftragsnummerIntern_KURZBEZ","Auftragsnummer","JoinNummer","IMBYNummer","COBKostenart_KNZ","COBKostenstelle_KNZ","COBKostentraeger_KNZ","COBGueltigVon","COBGueltigBis","COBNummer","Mahnschluessel_KNZ","Auswertungskennzeichen6_KURZBEZ","Budgetrelevant_KNZ","NichtBudgetPersonal_KNZ","SyfHist_KNZ","FinzStatHist_KNZ","Storniert_durch_JoinNummer_KNZ","DMS_KNZ","Titelzusatz_KNZ","Journalnummer_KNZ","Personalauftragsnummer_KNZ","Exportdatei_KURZBEZ","Anordnungsstelle_KNZ"]
["7250","2012","1540","42885","85",null,"12582","0",301,"F","428","1234567","1234567","1234567","821","12","20121","24,25",2.15,"EUR",null,null,0,0,"66","V","Auftragf","Fahrkarte","Fahrkarte","Fahrkarte","Fahrkarte","Fahrkarte","08-55928            ","FR27512466913","105 ","Müller","154001234567","KLIB1112","N","31.12.2012","31.12.2012","31.12.2012","FRRED15","Graf","Thomas",80462,"Ort",1360031684,"F",null,"4176","1","U","345,32",0,1,"123456789012","zv3003  ","AL45","mustmax_198410120001",9808028701,702532,"1234567890","087000","060001   ","02010243","2012-05-01","2012-12-31","9000015","11",6265,0,0,null,null,null,"OTH00001312",992011]
[7250,"2012","1549","22222","22","23","2635","23",501,"H","222","1234567","1234567","1234567","846","1234567","20122","08,15",null,null,"53,12","GBP",3.18,"-19",null,null,"Dientl","Hotel","Hotel","Hotel","Hotel","Hotel",2511056,"FR27512466913","208 ","Meier","154001234567","KLIB1112","K","31.12.2012","31.12.2012","31.12.2012","ITT01  ","Meier","Wolfgang",12544,"Ort",962802370,"H",null,"860","2",null,"334,34",1,0,"123456789012","zv0815","AL45","mustmax_198410120001",9830310601,722351,"1234567890",500600,"510201    ","32115092  ","2012-01-01","2012-12-31",null,"14","Max23 ",1,1,null,null,null,"OTH00004123","000261"]
["…"]
[]
[]
["Beschreibung:",{"$nulls":10},"Harmonisierung der Buchungsstrukturen 1. - 4. Ebene:"]
["Hochschule","Haushaltsjahr","Kapitel","Titel","Titelgruppe","Weitere Titelgruppe/DR2","HÜL-Nummer","HÜL-Unter-Nummer","Buchungsschlüssel","Buchungskennzeichen","Untertitel","Kostenträger / Projekt","Budgetstelle","Sonderbudgetstelle ","Ausgabeart","Organisationseinheit","Semester aus Buchungsstruktur","Buchungsbetrag","Restbetrag","Buchungswährung für Betrag","Vertrags-/Rechnungsbetrag, besonders bei Auslandszahlung","Vertrags-/Rechnungswährung für Vertragsbetrag","Umsatzsteuer-Betrag (USt/VSt)","Prozent Umsatzsteuer","Umsatzsteuerart","Mehrwertsteuertyp","Betrieb gewerblicher Art","Verwendungszweck 1","Verwendungszweck 2","Verwendungszweck 3","Verwendungszweck 4","Verwendungszweck 5","Rechnungsnummer","USt-ID des Zp der Buchung","Geldgebernummer","Feststeller","Kassenzeichen","Importdatei","Anordnungsart","Buchungsdatum","Rechnungsdatum","Fälligkeitsdatum","Zahlungspartner-Nummer","Zahlungspartner-Name","Zahlungspartner-Vorname","Zahlungspartner-PLZ","Zahlungspartner-Ort","Zahlungspartner-Kundennummer","Buchungskennzeichen der Referenzbuchung","Sonstige Anordnung","HÜL-Nummer der Referenz","HÜL-Unternummer der Referenz","Übernahmekennzeichen","Overheadsatz","Kennzeichen offener Posten","Kennzeichen Storno","Referenzkassenzeichen","Anmeldekennung des buchenden Sachbearbeiters","Eigene Auswertungen","BKZ Umbuchung / Auftragsnummer intern","Auftragsnummer","Join-Nummer","Immobilien Nummer","COB Kostenart","COB Kostenstelle","COB Kostentraeger","COB Gültigkeitsdatum von","COB Gültigkeitsdatum bis","COB-Nummer","Mahnschlüssel","Auswertungskennzeichen","Kennzeichen für budgetrelevante Personalkosten","Kennzeichnung für nicht budgetrelevante Personalbuchungen",null,null,"Gibt die Joinnumeer an, durch die die Buchung storniert wurde","Dokumentennummer zur Rechnung aus dem Dokumentenmangementsystem (falls vorhanden)"," ",null,"PersonalA.Nr. Aus Reiter Buchungskennzeichen 3","Export-Date-Nr. Aus Buchungsmaske","Hochschulabhängig wird hier die Anordnungsstellennummer abgezogen, welche seit 2022 gebucht werden muss"]
[{"$nulls":12},"(geldgebende Kostenstelle)","(Sonderfinanzierungsstelle) "]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"huel.jahr","huel.kap","huel.tit","huel.dr","huel.dr2","huel.huel","huel.u_nr","huel.buchungsschluessel","huel.kz","huel.ut","huel.fb; huel.ins; huel.ins2, huel.ins3; huel.kst_nr; huel.ktr_nr",{"$nulls":5},"huel.betrag","huel.rbetrag","huel.bwbezk","huel.vbetrag","huel.vwbezk","huel.mw_betrag","huel.mw_kz","huel.mw_art","huel.mw_typ","huel.bga","huel.grund1","huel.grund2","huel.grund3","huel.grund4","huel.grund5","huel.r_nr","huel.steuerid","huel.ggnr","huel.feststel","huel.bkz","huel.impdatei","huel.ao_kz","huel.b_dat","huel.r_dat","huel.fael","huel.z_nr","huel.z_name","huel.vorname","huel.z_plz","huel.z_ort","huel.kunden_nr","huel.ref_kz","huel.aw2","huel.ref_h","huel.ref_u","huel.art","huel.ov_satz","huel.op_kz","huel.st_kz","huel.ref_bkz","huel.sach","huel.aw","huel.buisy_a_nr","huel.a_nr","huel.join_nr","huel.imby_nr","huel.koa_nr","huel.kst_nr","huel.ktr_nr","huel.kperanf","huel.kperend","huel.cob_nr","huel.mahnschl","huel.aw6","kein Feld (geht aus Kapitel/Titelkombinationen hervor)","kein Feld (geht aus Kapitel/Titelkombinationen hervor)","huel.syf","huel.finz_stat","kein Feld (geht aus Stornobuchung hervor)","huel.dms_id","huel.aw4","huel.j_nr","huel.buisy_a_nr","huel.dta_nr","kein Feld"]
[]
["Anmerkungen:"]
["Allgemein: ","Einzelbuchungen aus der HÜL (Haushaltsüberwachungsliste)"]
["Buchungsschluessel","3-stellig"]
["Haushaltsjahr","4-stellig"]
["Kapitel_KNZ","4-stellig (ggf. ohne führende \"Null\")"]
["Titel_KNZ","5-stellig (ggf. mit führender \"Null\")"]
["Untertitel_KNZ","3-stellig (ggf. mit führender \"Null\")"]
["Waehrung_KNZ","EUR=Euro"]
["Buchungsdatum","TT.MM.JJJJ"]
["Rechnungsdatum","TT.MM.JJJJ"]
["Faelligkeitsdatum","TT.MM.JJJJ"]
["OffenerPosten_KNZ","1=offener Posten; 0=kein offener Posten"]
["Storniert_KNZ","1=storniert; 0=nicht storniert"]
["Semester","analog zu HIS-SOS (20121=SS2012; 20122=WS 12/13)"]
["Budgetrelevant_KNZ","0=Stellengehälter, nicht budgetrelevant; 1=budgetrelevante Personalkosten (oder sontige Buchungen)"]
["NichtBudgetPersonal_KNZ","0=budgetrelevante Personalkosten (z.B. Projektstellengehälter); 1=nicht budgetrelevante Personalkosten (feste Stellengehälter)"]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Kapitel","index":2,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Kapitel_KNZ","Kapitel_KURZBEZ","Kapitel_LANGBEZ","Haushaltsjahr","Geldgeber_KNZ"]
[7250,"1549","Sammelansätze FH","Sammelansätze für die Fachhochschulen","2012","999"]
[7250,"1540","HS Nürnberg","Hochschule Nürnberg","2012"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Kapitel","Bezeichnung","Langtext","Haushaltsjahr","Geldgeber"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"kap.kap","kap.kapbez","kap.lkapbez","kap.jahr","kap.ggnr"]
[]
[]
["Anmerkungen:"]
["Kapitel_KNZ","4-stellig (ggf. ohne führende \"Null\")"]
["Haushaltsjahr","4-stellig"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Titel","index":3,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Titel_KNZ","Titel_KURZBEZ","Titel_LANGBEZ","Haushaltsjahr","Kapitel_KNZ","Titelgruppe_KNZ","Titelgruppe2_KNZ","Pruefziffer_KNZ","DrittmittelTitelgruppe_KNZ","ZugehoerigerTitel_KNZ","ZugehoerigeTitelgruppe_KNZ","Verstaerkung_KNZ","Finanzstatistik_KNZ"]
[7250,"42773","Vergütung Lehraufträge","Vergütungen für Lehraufträge","2012","1540","73",null,"2","0",null,null,"N","180"]
[7250,"28272","Zusch. für lfd. Zwecke","Zuschüsse für laufende Zwecke","2012","1540","72",null,"6","1",null,"72","J","420"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Titel","Bezeichnung","Langtext","Haushaltsjahr","Kapitel","Titelgruppe","Weitere Titelgruppe / Weiterer DR","Prüfziffer","Drittmittel Titelgruppe","Zugehöriger Titel","Zugehörige Titelgruppe","Kennzeichen Verstärkung","Finanzstatistikschlüssel (HFinSt)"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"tit.tit","tit.titbez","tit.ltitbez","tit.jahr","tit.kap","tit.dr","tit.dr2","tit.pruef","tit.dtgr","tit.titkor","tit.drkor","tit.korrkz","tit.finz_stat"]
[]
[]
["Anmerkungen:"]
["Titel_KNZ","5-stellig (ggf. mit führender \"Null\")"]
["Haushaltsjahr","4-stellig"]
["Kapitel_KNZ","4-stellig (ggf. ohne führende \"Null\")"]
["DrittmittelTitelgruppe_KNZ","0=Nicht-Drittmittel; 1=Drittmittel"]
["Verstaerkung_KNZ","J=Ja; N=Nein"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Titelgruppe","index":4,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Titelgruppe_KNZ","Titelgruppe_KURZBEZ","Haushaltsjahr","Kapitel_KNZ","DrittmittelTitelgruppe_KNZ"]
[7250,"73","Unvorhergesehene Ausgaben jeder Art/Verstärkungsmittel","2012","1549","0"]
[7250,"51","Ausgaben aus der Inanspruchnahme freier Stellengehälter","2012","1540","1"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Titelgruppe","Bezeichnung","Haushaltsjahr","Kapitel","Drittmittel Titelgruppe"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"titdr.dr","titdr.titdrbez","titdr.jahr","titdr.kap","titdr.dtgr"]
[]
[]
["Anmerkungen:"]
["Titelgruppe_KNZ","2-stellig"]
["Haushaltsjahr","4-stellig"]
["Kapitel_KNZ","4-stellig (ggf. ohne führende \"Null\")"]
["DrittmittelTitelgruppe_KNZ","0=Nicht-Drittmittel; 1=Drittmittel"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Projekt","index":5,"n_rows":27,"n_cols":33,"rows_kept":27,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Projekt_KNZ","Projekt_KURZBEZ","ProjektBezeichnung1_LANGBEZ","ProjektBezeichnung2_LANGBEZ","UebergeordnetesProjekt_KNZ","Aktenzeichen_KURZBEZ","Projektleiter1_LANGBEZ","Projektleiter2_LANGBEZ","Projektleiter3_LANGBEZ","OverheadsatzDrittmittel","Finanzstatistik_KNZ","Klassifikationsmerkmal1_KURZBEZ","Klassifikationsmerkmal2_KURZBEZ","Klassifikationsmerkmal3_KURZBEZ","Klassifikationsmerkmal4_KURZBEZ","Laufzeitbeginn","Laufzeitende","Bewilligungsdatum1","Bewilligungsdatum2","ProjektGruppe_KNZ","ProjektArt_KNZ","Mehrwertsteuerpflicht_KNZ","Koerperschaftssteuerpflicht_KNZ","WirtschaftlicheTaetigkeit_KNZ","COBRelevant_KNZ","MBSRelevant_KNZ","ExternerSchluessel_KNZ","Auswertungskennzeichen_KNZ","Summenprojekt_KNZ","IstSummenProjekt_KNZ","IVSRelevant_KNZ","Zusatzfeld01_KURZBEZ bis Zusatzfeld10_KURZBEZ"]
[7250,"85046112","S-Projekt","S-Projekt an der HS","S-Projekt an der HS","SFB","D-4711","Müller","Müller","Müller","344,34","180","kfm","kfm","kfm","kfm","01.05.2012","31.04.2013","01.01.2012",null,"F","0","J","J",0,0,0,"beh","MZ","10046112",0,0,"freitext"]
[7250,"85364819","Q-Projekt","Q-Projekt an der HS","Q-Projekt an der HS","P_02","D-4712","Meier","Meier","Meier","34,23","420","kfm","kfm","kfm","kfm","31.12.2012","31.12.2099",null,null,"D",1,"N","N",1,1,1,"bisch","MT","10364819",1,1]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Kostenträger / Projektnummer","Bezeichnung","Bezeichnung1","Bezeichnung2","Bereich / Übergeondeter Kostenträger oder Projekt","Aktenzeichen","Projektleiter / Bearbeiter 1","Projektleiter / Bearbeiter 2","Projektleiter / Bearbeiter 3","Overheadsatz bei Drittmitteleinnahmen","Finanzstatistikschlüssel (HFinSt)","freies Klassifikationsmerkmal 1","freies Klassifikationsmerkmal 2","freies Klassifikationsmerkmal 3","freies Klassifikationsmerkmal 4","Laufzeitbeginn","Laufzeitende / Gültigkeit des Kostenträgers","Datum der 1. Bewilligung","Datum der 2. Bewilligung","Projekt- / Kostenträgergruppe","Projekt- / Kostenträgerart","Mehrwertsteuerpflichtiges Projekt","Körperschaftssteuerpflicht","Wirtschaftliche Tätigkeit","relevant fuer COB","Relevant für MBS","Externer Schlüssel 2","Auswertungskennz.","Projektnummer","Haken bei Summernprojekt","Haken bei IVS Relevant","Zusatzfelder aus der Kostenstellenmaske"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"proj.projnr","proj.ktext","proj.ltxt1","proj.ltxt2","proj.ueberkey","proj.az","proj.pjlname1","proj.pjlname2","proj.pjlname3","proj.ov_satz","proj.fins","proj.spklnr1","proj.spklnr2","proj.spklnr3","proj.spklnr4","proj.laufzeitbeginn","proj.bewabl","proj.bewdat1","proj.bewdat2","proj.art1","proj.art2","proj.mwpf","proj.ksteuerpf","proj.wirtschaftlich","proj.cobrel","proj.mbsrel","proj.key_ext","proj.lehr","proj.sum_projekt","proj.sum_pro_kz","proj.ivsrel","pro.freitext01, proj.freitext02 … proj.freitext_10"]
[]
[]
["Anmerkungen:"]
["Laufzeitbeginn/-ende","TT.MM.JJJJ"]
["Bewilligungsdatum 1 / 2","TT.MM.JJJJ"]
["ProjektGruppe_KNZ","Beispiel: F=Forschung; D=Dienstleistung; M=Management; S=Sonstige KoTr/Proj; L=Lehre; N=Förderung wissenschaftlichen Nachwuchses"]
["ProjektArt_KNZ","Beispiel: 1=Bereichsprojekt; 0=Einzelprojekt"]
["Mehrwertsteuerpflicht_KNZ","J=Umsatzsteuerpflichtiges Projekt"]
["Koerperschaftssteuerpflicht_KNZ","J=Körperschaftssteuerpflicht"]
["WirtschaftlicheTaetigkeit_KNZ","0=Nein; 1=Ja"]
["COBRelevant_KNZ","0=Nein; 1=Ja"]
["MBSRelevant_KNZ","0=Nein; 1=Ja"]
["IstSummenprojekt_KNZ","0=Nein; 1=Ja"]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Kostenstelle","index":6,"n_rows":21,"n_cols":21,"rows_kept":21,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Kostenstelle_KNZ","Kostenstelle_KURZBEZ","KostenstelleBezeichnung1_LANGBEZ","KostenstelleBezeichnung2_LANGBEZ","Kostenstelle_DRUCKBEZ","UebergeordneteKostenstelle_KNZ","Finanzstatistik_KNZ","Organisationsstruktur_KNZ","GueltigVon","GueltigBis","IMBYNummer","COBRelevant_KNZ","MBSRelevant_KNZ","BESBearbeiter_KURZBEZ","IVSBearbeiter_KURZBEZ","ExternerSchluessel_KNZ","Auswertungskennzeichen_KNZ","SVARelevant_KNZ","Bemerkung_KURZBEZ","Zusatzfeld01_KURZBEZ bis Zusatzfeld10_KURZBEZ"]
[7250,"01003100","Lehrstuhl 1","Lehrstuhl 1","Lehrstuhl 1","Lehrstuhl 1","0100","030",20,"2012-05-01","2012-12-31","1234567890",1,0,"Meier","Müller","ble","MB",1,"freitext","freitext"]
[7250,"01010111","Professur A","Professur A","Professur A","Professur A","010101","880",60,"2012-01-01","2012-12-31","1234567890",0,1,"Müller","Meier","bra","MT",0]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Kostenstellennummer","Bezeichnung","Langtext 1","Langtext 2","Drucktext","Übergeondete Kostenstelle","Finanzstatistikschlüssel (HFinSt)","Organisationsstruktur","Gültigkeitsdatum von","Gültigkeitsdatum bis","Immobilien Nummer","Relevant für COB","Relevant für MBS","BES Bearbeiter","IVS Bearbeiter","Externer Schlüssel","Auswertungskennzeichen","Haken bei SVA Relevant","Feld Bemerkung aus Kostenstellenmaske","Zusatzfelder01 bis 10 aus der Kostenstellenmaske"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"inst.inst_nr","inst.kname","inst.lname1","inst.lname2","inst.dname","inst.uebinst_nr","inst.fins","inst.orgstruktur","inst.key_von","inst.key_bis","inst.imby_nr","inst.cobrel","inst.mbsrel","inst.bes_pers","inst.ivs_pers","inst.key_ext","inst.lehr","inst.svarel","inst.bemerkung","inst.freitext01, inst.freitext02 … inst.freitext10"]
[]
[]
["Anmerkungen:"]
["GueltigVon","TT.MM.JJJJ"]
["GueltigBis","TT.MM.JJJJ"]
["COBRelevant_KNZ","0=Nein; 1=Ja"]
["MBSRelevant_KNZ","0=Nein; 1=Ja"]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Kostenart","index":7,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Kostenart_KNZ","Kostenart_KURZBEZ","Kostenart_LANGBEZ","UebergeordneteKostenart_KNZ","Finanzart_KNZ","GueltigVon","GueltigBis","COBRelevant_KNZ","MBSRelevant_KNZ","Kontenklasse_KNZ"]
[7250,"0250","Fuhrpark  ","Fuhrpark  ","025","22","2012-05-01","2012-12-31",0,0,"A"]
[7250,"02500","Werkzeuge","Werkzeuge","0250","456","2012-01-01","2012-12-31",1,1,"E"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Schlüssel der Kostenart","Bezeichnung","Langtext","Übergeondete Kostenart","Systematik der Finanzarten","Gültigkeitsdatum von","Gültigkeitsdatum bis","Relevant fuer COB","Relevant für MBS","Kontenklassenzugehörigkeit"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"fikr.key","fikr.kbez","fikr.lbez","fikr.ueberg","fikr.syf","fikr.key_von","fikr.key_bis","fikr.cobrel","fikr.mbsrel","fikr.kokl"]
[]
[]
["Anmerkungen:"]
["GueltigVon","TT.MM.JJJJ"]
["GueltigBis","TT.MM.JJJJ"]
["COBRelevant_KNZ","0=Nein; 1=Ja"]
["MBSRelevant_KNZ","0=Nein; 1=Ja"]
["Kontenklasse_KNZ","K=Kosten; E=Erlöse; A=Ausgabe; N=Neutral; S=Sekundär"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"TitelKostenart","index":8,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Titel_KNZ","Kapitel_KNZ","Kostenart_KNZ"]
[7250,"42885","1549",12345]
[7250,"54773","1540",12345]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Titel","Kapitel","Kostenart"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"titkoa.tit","titkoa.kap","titkoa.koa_nr"]
[]
[]
["Anmerkungen:"]
["Titel_KNZ","5-stellig (ggf. mit führender \"Null\")"]
["Kapitel_KNZ","4-stellig (ggf. ohne führende \"Null\")"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Finanzart","index":9,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Finanzart_KNZ","Finanzart_KURZBEZ","Finanzart_LANGBEZ","Finanzart_DRUCKBEZ","UebergeordneteFinanzart_KNZ","GueltigVon","GueltigBis"]
[7250,"11","Personalausgaben","Personalausgaben","Personalausgaben","1","2012-05-01","2012-12-31"]
[7250,"111","Personalausgaben","Personalausgaben","Personalausgaben","11","2012-01-01","2012-12-31"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Schlüssel der Finanzart","Bezeichnung","Langtext","Drucktext","Übergeondete Finanzart","Gültigkeitsdatum von","Gültigkeitsdatum bis"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"k_syf.key_syf","k_syf.kurz_syf","k_syf.text_syf","k_syf.druck_syf","k_syf.ueberkey","k_syf.key_von","k_syf.key_bis"]
[]
[]
["Anmerkungen:"]
["GueltigVon","TT.MM.JJJJ"]
["GueltigBis","TT.MM.JJJJ"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"ProjektGeldgeber","index":10,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Projekt_KNZ","Geldgeber_KNZ","FoerderKennzeichen_KNZ","Hauptgeldgeber_KNZ","ProjektGeldgeberInfo1_KURZBEZ","ProjektGeldgeberInfo2_KURZBEZ","ProjektGeldgeberInfo3_KURZBEZ"]
[7250,"06060251  ","899 ","48431/123/43    ","0","Informationstext","Informationstext","Informationstext"]
[7250,"06060288","101","DT 202/11-9","1","Informationstext","Informationstext","Informationstext"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Kostenträger / Projektnummer","Geldgebernummer","FoerderKennzeichen","Kennzeichen für Hauptgeldgeber","Informationen zu der Beziehung","Informationen zu der Beziehung","Informationen zu der Beziehung"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"prge.projnr","prge.ggnr","prge.foerd_kz","prge.fo_kz","prge.info1","prge.info2","prge.info3"]
[]
[]
["Anmerkungen:"]
["Hauptgeldgeber_KNZ","1=Kennzeichen für Hauptgeldgeber; 0=kein Hauptgeldgeber (HIS: * / leer)"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"ProjektKostenstelle","index":11,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Projekt_KNZ","Kostenstelle_KNZ","Hauptbetreung_KNZ","Aktiv_KNZ"]
[7250,"02413114","020531","1","0"]
[7250,"06060288","060902","0","1"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Kostenträger / Projektnummer","Kostenstelle","Kennzeichen Hauptbetreuung","Kennzeichen zur Deaktivierung der Beziehung"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"proj_to_inst.projnr","proj_to_inst.inst_nr","proj_to_inst.haupt_kst_kz","proj_to_inst.aktiv"]
[]
[]
["Anmerkungen:"]
["Hauptbetreung_KNZ","1=HauptbetreuungsKostenstelle; 0=keine"]
["Aktiv_KNZ","1=Aktiv; 0=Deaktiv"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"ProjektGeldgeberNotiz","index":12,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Projekt_KNZ","Geldgeber_KNZ","Datum","Betrag","Notiz_KURZBEZ","Erledigt_KURZBEZ"]
[7250,"06060251  ","899 ","01.05.2012","235000","Notiztext","ja"]
[7250,"06060288","101","31.12.2012","180000","Notiztext"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Kostenträger / Projektnummer","Geldgebernummer","Datum","Betrag","Notiz","Erledigt"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"prgn.projnr","prgn.ggnr","prgn.n_dat","prgn.n_betrag","prgn.notiz","prgn.n_vwbezk"]
[]
[]
["Anmerkungen:"]
["Datum","TT.MM.JJJJ"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Geldgeber","index":13,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Geldgeber_KNZ","Geldgeber_KURZBEZ","GeldgeberName1_LANGBEZ","GeldgeberName2_LANGBEZ","GeldgeberName3_LANGBEZ","Geldgeber_DRUCKBEZ","UebergeordneterGeldgeber_KNZ","GueltigVon","GueltigBis","Drittmittelart_KURZBEZ","Finanzierung_KURZBEZ","Mittelherkunft_KURZBEZ","COBRelevant_KNZ","MBSRelevant_KNZ"]
[7250,"105 ","Sonst. Stiftung","Sonst. Stiftung","Sonst. Stiftung","Sonst. Stiftung","Sonst. Stiftung","C","2012-05-01","2012-12-31","Text","Text","Text",0,0]
[7250,"208 ","Firma A","Firma A","Firma A","Firma A","Firma A","K","2012-01-01","2012-12-31",null,null,null,1,1]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Geldgebernummer","Bezeichnung"," GeldgeberName 1"," GeldgeberName 2"," GeldgeberName 3","Drucktext","Übergeondeter Geldgeber","Gültigkeitsdatum von","Gültigkeitsdatum bis","Finanzstatistik-Einnahmen","Schluessel fuer Bundesstatistik für Personal","Kennzeichen fuer Geldgebergruppierung (KLR)","relevant fuer COB","Relevant für MBS"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"gege.ggnr","gege.ggkurz","gege.ggname1","gege.ggname2","gege.ggname3","gege.ggdruck","gege.ueberkey","gege.key_von","gege.key_bis","gege.fikey","gege.bund_geldgeber","gege.klr_geldgeber","gege.cobrel","gege.mbsrel"]
[]
[]
["Anmerkungen:"]
["GueltigVon","TT.MM.JJJJ"]
["GueltigBis","TT.MM.JJJJ"]
["COBRelevant_KNZ","0=Nein; 1=Ja"]
["MBSRelevant_KNZ","0=Nein; 1=Ja"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Mahnung","index":14,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Mahnung_KNZ","Mahnung_KURZBEZ"]
[7250,"11","Mahn. Vollstr. (ö)"]
[7250,"23","Mitteil. (p)"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Mahnschlüssel","Bezeichnung"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"mahn.mahn","mahn.bez"]
[]
[]
["Anmerkungen:"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Zahlungspartner","index":15,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Zahlungspartnernummer","Anrede_KURZBEZ","Geschlecht_KNZ","Name_KURZBEZ","Vorname_KURZBEZ","Niederlassung_KURZBEZ","Abteilung_KURZBEZ","Land_KNZ","PLZ_KURZBEZ","Ort_KURZBEZ","Strasse_KURZBEZ","Kundennummer","Personalnummer","Kennzeichnung_KURZBEZ","Finanzamt_KNZ","Steuernummer","MBSRelevant_KNZ","ZPIntern_KNZ"]
[7250,"ZAHLP01","Herr","m","Müller","Josef",null,null,"D",80431,"München","Gärtnerweg 1                                      ",null,95465774,"P",9244,8072638272,0,"P"]
[7250,"ZAHLP02","Firma               ",null,"Siemens",null,"A-45/5648","Personal",{"$nulls":4},1108227,null,8,null,null,1,0]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Zahlungspartnernummer","Anrede","Geschlecht","Name","Vorname","Niederlassung","Abteilung","Land","Postleitzahl","Ort","Straße","Kundennummer","Personalnummer","freie Kennzeichnung","Schlüssel des Finanzamts","SteuerSteuerId Finanzamt","Relevant fuer MBS","interner Zahlungspartner"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"zp.zp_nr","zp.anrede","zp.geschlecht","zp.zp_name","zp.rufname","zp.zp_niederlassung","zp.zp_abteilung","zp.land","zp.plz","zp.ort","zp.str","zp.kunden_nr","zp.pers_nr","zp.kennzeichnung","zp.finanzamt","zp.steuerid","zp.mbsrel","zp.mbs_kenn"]
[]
[]
["Anmerkungen:"]
["Geschlecht_KNZ","m=männlich; w=weiblich"]
["MBSRelevant_KNZ","0=nicht relevant; 1=relevant für MBS"]
["ZPIntern_KNZ","P=interner Zahlungspartner; leer=externer Zahlungspartner"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"ZahungspartnerAusland","index":16,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
["Mandant","Zahlungspartnernummer","Name1_KURZBEZ","Name2_KURZBEZ","Land_KNZ","PLZ_KURZBEZ","Ort_KURZBEZ","Strasse_KURZBEZ"]
[7250,"ZAHLP01","English","May","USA",8740,"New York","Long Street 1"]
[7250,"ZAHLP02","John","Fitch"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Zahlungspartnernummer","Name1","Name2","Land","Postleitzahl","Ort","Straße"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"zpa.zp_key","zpa.zp_name1","zpa.zp_name2","zpa.land","zpa.plz","zpa.ort","zpa.str"]
[]
[]
["Anmerkungen:"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Finanzstatistik","index":17,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Finanzstatistik_KNZ","Finanzstatistik_KURZBEZ","FinanzstatistikGruppe_KNZ"]
[7250,"410","Geowissenschaften","400"]
[7250,"800","Zentralbibliothek","990"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Finanzstatistik-Schlüssel","Bezeichnung","Finanzstatistik-Gruppe-Schlüssel"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"fins.fins_key","fins.fins_lbez","fins.fins_keygrp"]
[]
[]
["Anmerkungen:"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"BetriebGewerblicherArt","index":18,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":9}
["Mandant","BetriebGewerblicherArt_KNZ","BetriebGewerblicherArt_KURZBEZ","BetriebGewerblicherArt_LANGBEZ","BetriebGewerblicherArt_DRUCKBEZ","GueltigVon","GueltigBis"]
[7250,"AUFTRAGF","Auftragsforschung","Auftragsforschung","Auftragsforschung","2012-05-01","2012-12-31"]
[7250,"DIENSTL","Dienstleistungen","Dienstleistungen","Dienstleistungen","2012-01-01","2012-12-31"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Schlüssel","Bezeichnung","Langtext","Drucktext","Gültigkeitsdatum von","Gültigkeitsdatum bis"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"k_bga.key_bga","k_bga.kurz_bga","k_bga.text_bga","k_bga.druck_bga","k_bga.key_von","k_bga.key_bis"]
[]
[]
["Anmerkungen:"]
["GueltigVon","TT.MM.JJJJ"]
["GueltigBis","TT.MM.JJJJ"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"MehrwertsteuerArt","index":19,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","MehrwertsteuerArt_KNZ","MehrwertsteuerArt_KURZBEZ","MehrwertsteuerArt_LANGBEZ","MehrwertsteuerArt_DRUCKBEZ","Kostenart_KNZ","MWStTyp_KNZ","MWStVorzeichen_KNZ","MWStSteuersatz"]
[7250,"66","(A)VSt Rechn and. Untern","(A)VSt Rechn and. Untern","(A)VSt Rechn and. Untern",12345,"V","-","19"]
[7250,"00","steuerfrei","steuerfrei","steuerfrei",null,"N","+","0"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Schlüssel","Bezeichnung","Langtext","Drucktext","Kostenart","Typ der MWSt","Vorzeichen","Steuersatz"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"k_mw_art.key_mw_art","k_mw_art.kurz_mw_art","k_mw_art.text_mw_art","k_mw_art.druck_mw_art","k_mw_art.koa_nr","k_mw_art.mw_typ","k_mw_art.mw_vorz","k_mw_art.mw_kz"]
[]
[]
["Anmerkungen:"]
["GueltigVon","TT.MM.JJJJ"]
["GueltigBis","TT.MM.JJJJ"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Untertitel","index":20,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Untertitel_KNZ","Untertitel_KURZBEZ","Haushaltsjahr","Kapitel_KNZ","Titel_KNZ","Titelgruppe_KNZ","Titelgruppe2_KNZ","ZugehoerigerUntertitel_KNZ","ZugehoerigerTitel_KNZ","ZugehoerigeTitelgruppe_KNZ","Finanzstatistik_KNZ","Art_KNZ"]
[7250,"428","Personalausgaben","2012","1540","01330","85",{"$nulls":4},808,"P"]
[7250,"222","Einnahme","2012","1549","09999","22","23","33333","33333","33",108,"I"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Titel","Bezeichnung","Haushaltsjahr","Kapitel","Titel","Titelgruppe","Weiterer Titelgruppe / Weiterer DR","Zugehöriger Untertitel","Zugehöriger Titel","Zugehörige Titelgruppe","Finanzstatistik-Schlüssel","art"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"ut.ut","ut.utbez","ut.jahr","ut.kap","ut.tit","ut.dr","ut.dr2","ut.utkor","ut.titkor","ut.drkor","ut.finz_stat","ut.art"]
[]
[]
["Anmerkungen:"]
["Untertitel_KNZ","3-stellig (ggf. mit führender \"Null\")"]
["Kapitel_KNZ","4-stellig (ggf. ohne führende \"Null\")"]
["Titel_KNZ","5-stellig (ggf. mit führender \"Null\")"]
["Haushaltsjahr","4-stellig"]
["Art_KNZ","P/I"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Sachbearbeiter","index":21,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Sachbearbeiter_KNZ","Name_KURZBEZ","Vorname_KURZBEZ","Kuerzel_KURZBEZ","Geschlecht_KNZ","Email_KURZBEZ","Telefon_KURZBEZ","Fax_KURZBEZ","Funktion_KURZBEZ"]
[7250,"zv3003  ","Müller","Josef","MU","M","Adresse","0911","0911","Leiter"]
[7250,"zv0815","Meier","Maria","ME","W"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Sachbearbeiter-Schlüssel","Name","Vorname","Kürzel","Geschlecht","E-Mail","Telefon","Fax","Funktion"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"db_sachbearbeiter.login","db_sachbearbeiter.name","db_sachbearbeiter.vorname","db_sachbearbeiter.kuerzel","db_sachbearbeiter.geschlecht","db_sachbearbeiter.email","db_sachbearbeiter.telefon","db_sachbearbeiter.fax","db_sachbearbeiter.funktion"]
[]
[]
["Anmerkungen:"]
["Geschlecht_KNZ","M=männlich; W=weiblich"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Dauerauftrag","index":22,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Haushaltsjahr","Kapitel_KNZ","Titel_KNZ","HuelNr","Buchungskennzeichen_KNZ","Festlegungstag","Festlegungsbetrag","Gezahlt_KNZ"]
[7250,"2012","1540","42885","12582","FD","2012-05-01",34.56,"J"]
[7250,"2012","1549","22222","2635","FD","2012-05-01",34.56,"N"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Haushaltsjahr","Kapitel","Titel","HÜL-Nummer","Buchungskennzeichen","Festlegungstag","Festlegungsbetrag","Gezahlt"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"dau.jahr","dau.kap","dau.tit","dau.huel","dau.kz","dau.ftag","dau.fbetrag","dau.zkz"]
[]
[]
["Anmerkungen:"]
["Haushaltsjahr","4-stellig"]
["Kapitel_KNZ","4-stellig (ggf. ohne führende \"Null\")"]
["Titel_KNZ","5-stellig (ggf. mit führender \"Null\")"]
["Gezahlt_KNZ","J=Ja, N=Nein"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]
{"$rows_empty":12}
["Es werden über die Schnittstelle folgende Datenfelder geladen: „Haushaltsjahr“, „Kapitel“,  „Titel“, „HÜL-Nummer“, „Buchungskennzeichen“, „Festlegungstag“, „Festlegungsbetrag“, „Gezahlt“."]