{"text_format":"2","workbook":"xls","n_sheets":15,"sheets":["Allgemeines","Inventar","Abgangsdaten","Abschreibungen","Splitdaten","Klassifikation","Steuerabschreibung","Gebaeude","Geschoss","Raum","Zahlungspartner","Geldgeber","Kostenstelle","Kapitel","Titel"],"not_rendered":{"charts":0,"images":80,"macros":1,"external_links":1,"defined_names":1,"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":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[37,0,37,8],[38,0,38,8],[36,0,36,8]],"flags":["formulas_cached_only"]}
["CEUS-Lokal - Lokales Data-Warehouse-System der bayerischen Hochschulen für angewandte Wissenschafften"]
["Domäne Finanzcontrolling - Inventardaten"]
["Stand 03.02.2015"]
[]
["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):"]

{"sheet":"Inventar","index":1,"n_rows":402,"n_cols":55,"rows_kept":402,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","InventarID","Inventarnummer_KNZ","Anzahl","Status_KNZ","Inventarisierungsdatum","Klassifikation_KNZ","Inventar_KURZBEZ","Bemerkung_KURZBEZ","Geraeteart_KNZ","Hauptgeraet_Inventarnummer_KNZ","Hersteller_KNZ","Hersteller_KURZBEZ","Seriennummer","Typ","Baujahr","Inventurdatum1","Inventurdatum2","Lieferant_KNZ","Lieferant_KURZBEZ","Auftragsnummer","Auftragsdatum","Rechnungsnummer","Rechnungsdatum","Geldgeber_KNZ","Erwerbsart_KNZ","Erwerbsart_KURZBEZ","Mietendedatum","Organisationseinheit_KNZ","Gebaude_KNZ","Geschoss_KNZ","Raum_KNZ","Bereichsbezeichnung_KURZBEZ","Nutzer_KURZBEZ","Ausleiher_KURZBEZ","Beschaffungsbeauftragter_KURZBEZ","Auswertungskennzeichen","Inbetriebnahmedatum","Garantiebeginndatum","Garantiedauer","Garantiendedatum","Gewaehrleistungsbeginndatum","Gewaehrleistungsdauer","Gewaehrleistungsendedatum","Sachbearbeiter_KURZBEZ","Aenderungsdatum","Anschaffungskosten","Restwert","Nutzungsdauer","Abschreibung_KNZ","Haushaltsjahr","Kapitel_KNZ","Titel_KNZ","HuelNr","Zusatztext_LANGBEZ"]
["7250","6443","NF0001162","2","90","22.05.2001","5650","Optischer Lichtzerhacker","Einzelnachweisung Nr.2065","Z","0017123","ZAHLP01","Jobin Yvon GmbH   ","DH 10 IR  ","DH 10 IR    ",2001,"31.12.2012","31.12.2013","ZAHLP01","Jobin Yvon GmbH   ","POFACNF0106      ","30.01.2001","101214   ","10.05.2001","01","01","Kauf","31.12.2012","641001","0045","00",2750,"Untergeschoss","Gerhard Reus","Hr. Meier","Prof.Dr.Poisel     ","ND296     ","18.05.2001","10.05.2001","12","09.05.2002","10.05.2001","12","09.05.2002","smarzykcl      ","20.06.2011","10254,67","0","96","J","2001","01312","81281     ","152"]
[7250,"16145","0017123","1","90","24.05.2011","0000","Spektraler Dämpfungsmessplatz       ","Dummy","H",null,"ZAHLP02","Labsphere     ","SIN 7197    ","CA-07174-000","2010",null,null,"ZAHLP02","Labsphere     ","POFACNF0138   ","13.03.2001","R-01-05-0149/1","30.05.2001","12","04","Leihe","31.12.2012","641001","0039","00",2750,"Untergeschoss","Hr. Bloos  ",null,"Prof.Dr.Poisel     ","WBW133564","30.05.2001","30.05.2001","0","29.05.2002","30.05.2001","0","29.05.2002",null,"29.06.2011","23972,29","23972,29","120","N","2001","01312","81281     ","160","NF0001164,POFAC0002,NF0001162"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","InventarID","Inventarnummer","Anzahl","Status","Inventarisierungsdatum","Klassifikation","Bezeichnung","Bemerkung","Geräteart","Inventarnummer Hauptgerät","Hersteller","Hersteller Name","Seriennummer","Typ","Baujahr","Inventurdatum1","Inventurdatum2","Lieferant","Lieferanten Name","Auftragsnummer","Auftragsdatum","Rechnungsnummer","Rechnungsdatum","Geldgeber","Erwerbsart","Erwerbsartbezeichnung","Ende Miete/Leasing","Organisationseinheit","Gebaude","Geschoss","Raum","Bereichsbezeichnung","Nutzer","Ausleiher","Beschaffungsbeauftragter","Auswertungskennzeichen","Inbetriebnahmedatum","Garantiebeginn","Garantiedauer","Garantiende","Gewaehrleistungsbeginn","Gewaehrleistungsdauer","Gewaehrleistungsende","Sachbearbeiter","Aenderungsdatum","Anschaffungskosten","Restbuchwert","Nutzungsdauer","Abschreibung","Haushaltsjahr","Kapitel","Titel","HÜL-Nummer","Text"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"ivst.ivst_id","ivst.ivst_invnr","ivst.ivst_anzahl","ivst.ivst_status","ivst.ivst_invdat","ivst.ivst_klass","ivst.ivst_gerbez","ivst.ivst_bem","ivst.ivst_geraet","ivst.ivst_invnrhg","ivst.ivst_herst","ivst.ivst_herst_name","ivst.ivst_sernr","ivst.ivst_typ","ivst.ivst_bauj","ivst.ivst_inventurdt1","ivst.ivst_inventurdt2","ivst.ivst_lief","ivst.ivst_lief_name","ivst.ivst_auftnr","ivst.ivst_aufdatum","ivst.ivst_rechnr","ivst.ivst_rechdatum","ivst.ivst_finart","ivst.ivst_erwb","erwb.erwbtext","ivst.ivst_mietende","ivst.ivst_inst","ivst.ivst_geb","ivst.ivst_gesch","ivst.ivst_raum","ivst.ivst_bereichsbez","ivst.ivst_nutzer","ivst.ivst_ausleiher","ivst.ivst_beschbeauft","ivst.ivst_kst","ivst.ivst_betrdat","ivst.ivst_garantbeginn","ivst.ivst_garant","ivst.ivst_garantende","ivst.ivst_gewaehrbeginn","ivst.ivst_gewaehr","ivst.ivst_gewaehrende","ivst.ivst_sblogin","ivst.ivst_aenddat","ivst.ivst_preis","ivst.ivst_restwert","ivst.ivst_nutzd","ivst.ivst_abschreibung","ivst.ivst_hh_j","ivst.ivst_kap","ivst.ivst_titel","ivst.ivst_huel","ivst.ivst_text"]
[]
[]
["Anmerkungen:"]
["Haushaltsjahr","4-stellig"]
["Kapitel_KNZ","4-stellig (ggf. ohne führende \"Null\")"]
["Titel_KNZ","5-stellig (ggf. mit führender \"Null\")"]
["Inventarisierungsdatum","TT.MM.JJJJ"]
["Baujahr","JJJJ"]
["Inventurdatum1","TT.MM.JJJJ"]
["Inventurdatum2","TT.MM.JJJJ"]
["Auftragsdatum","TT.MM.JJJJ"]
["Rechnungsdatum","TT.MM.JJJJ"]
["Mietendedatum","TT.MM.JJJJ"]
["Inbetriebnahmedatum","TT.MM.JJJJ"]
["Garantiebeginndatum","TT.MM.JJJJ"]
["Garantieendedatum","TT.MM.JJJJ"]
["Gewaehrleistungsbeginndatum","TT.MM.JJJJ"]
["Gewaehrleistungsendedatum","TT.MM.JJJJ"]
["Aenderungsdatum","TT.MM.JJJJ"]
["Geraeteart_KNZ","H=Hauptgerät; Z=Zubehör"]
["Abschreibung_KNZ","J=Abschreiben; N=Nicht Abnutzbar"]
["Status_KNZ","90=Gültig; 91=Vorinventarisiert; 92=Ausgemustert"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]
{"$rows_empty":364}
[null,null,"[InventarID]","[Inventarnummer_KNZ]","[Anzahl]","[Status_KNZ]","[Inventarisierungsdatum]","[Klassifikation_KNZ]","[Inventar_KURZBEZ]","[Bemerkung_KURZBEZ]","[Geraeteart_KNZ]",{"$error":"#REF!"},"[Hersteller_KNZ]","[Hersteller_KURZBEZ]","[Seriennummer]","[Typ]","[Baujahr]","[Inventurdatum1]","[Inventurdatum2]","[Lieferant_KNZ]"]

{"sheet":"Abgangsdaten","index":2,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Inventarnummer_KNZ","LaufNr","Anzahl","Abgangsdatum","Abgangsgrund_KNZ","Abgangsgrund_KURZBEZ","Bemerkung_LANGTEXT","COB_Kostenart_KNZ"]
[7250,"NF0001162","1","2","20.01.2012","02","Diebstahl","Siehe Abgangsverfügung Nr. 6821!!!      ","5800        "]
[7250,"0017123","1","1","01.08.2014","03","Verschrottung","Siehe Abgangsverfügung Nr. 6747!!!       ","5811      "]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Inventarnummer","Laufende Nummer","Anzahl","Abgangsdatum","Abgangsgrund","Abgangsgrundbezeichnung","Bemerkung","Kostenart KLR"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"ivab.ivab_invnr","ivab.ivab_lfdnr","ivab.ivab_anzahl","ivab.ivab_abdat","ivab.ivab_abnr","abga.abtext","ivab.ivab_bemerkung","ivab.ivab_kostenart"]
[]
[]
["Anmerkungen:"]
["Abgangsdatum","TT.MM.JJJJ"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Abschreibungen","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","InventarID","Inventarnummer_KNZ","Haushaltsjahr","Haushaltsmonat","Abschreibungsbetrag"]
[7250,"6443","NF0001162","2012","5","11,36"]
[7250,"16145","0017123","2012","12","2,82"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","InventarID","Inventarnummer","Haushaltsjahr","Haushaltsmonat","Abschreibungsbetrag"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"ivaf.invnr_id","ivaf.inventarnr","ivaf.haushaltsjahr","ivaf.monat","ivaf.betrag"]
[]
[]
["Anmerkungen:"]
["Haushaltsjahr","JJJJ"]
["Haushaltsmonat","MM"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Splitdaten","index":4,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Inventarnummer_KNZ","LaufNr","Splitart_KNZ","Splitanteil","Keywert_KNZ","Status_KNZ","Kostenstelle_KNZ","Kostentraeger_KNZ","Kostenart_KNZ","InventarID"]
[7250,"NF0001162","1","0","100",null,"1","01003100","85046112","0250","6443"]
[7250,"0017123","1","1","50","8148652","0","01010111","85364819","02500","16145"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Inventarnummer","Laufende Nummer","Splitart","Splitanteil","Keywert","Status","Kostenstelle","Kostentraeger","Kostenart","InventarID"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"ivsplit.ivsplit_invnr","ivsplit.ivsplit_lfdnr","ivsplit.ivsplit_art","ivsplit.ivsplit_anteil","ivsplit.ivsplit_keywert","ivsplit.ivsplit_status","ivsplit.ivsplit_kost","ivsplit.ivsplit_kotr","ivsplit.ivsplit_koa_nr","ivsplit.ivsplit_ivst_id"]
[]
[]
["Anmerkungen:"]

{"sheet":"Klassifikation","index":5,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Klassifikationsschluessel_KNZ","Klassifikationsschluessel_KURZBEZ","Nutzungsdauer","Kostenart_KNZ","Fundstelle_KNZ","FundstelleNutzungsdauer","KlassifikationAktiv_KNZ"]
[7250,"7070","Arbeitsplatzrechner, Personalcomputer","36","5800","6.14.3.2","36","1"]
[7250,"5790","Sonstige Laser und Zubehör","72","5800","6.14.3.2","12","0"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Klassifikationsschlüssel","Klassifikationbsbezeichnung","Nutzungsdauer","Kostenart","Fundstelle für steuerliche Nutzungsdauer","steuerliche Nutzungsdauer","Aktivschalter Klassifikation"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"klas.klas_key","klas.klas_bez","klas.klas_nutzd","klas.klas_koa_nr","klas.klas_fundstelle","klass.klas_nutzd_st","klas.klas_aktiv"]
[]
[]
["Anmerkungen:"]
["Aktiv_KNZ","1=Aktiv; 0=Inaktiv"]
["Nutzungsdauer","MM"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Steuerabschreibung","index":6,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Fundstelle_KNZ","FundstelleAnlagegueter_KURZBEZ","FundstelleNutzungsdauer","FundstelleAktiv_KNZ"]
[7250,"6.14.3.2","Workstation, Personalcomputer, Notebooks","3","1"]
[7250,"6.14.3.2","Workstation, Personalcomputer, Notebooks","5","0"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Fundstelle für steuerliche Abschreibung lt. lt. AfA-Tabelle","Anlagegüter lt. AfA-Tabelle","Nutzungsdauer lt. AfA-Tabelle","Aktivschalter Fundstelle"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"k_nutzd_st.fundstelle","k_nutzd_st.anlagegueter","k_nutzd_st.nutzungsdauer","k_nutzd_st.aktiv"]
[]
[]
["Anmerkungen:"]
["FundstelleAktiv_KNZ","1=Aktiv; 0=Inaktiv"]
["FundstelleNutzungsdauer","JJ"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Gebaeude","index":7,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Gebaeude_KNZ","Gebaeude1_KURZBEZ","Gebaeude2_KURZBEZ"]
[7250,"0045","KA-Gebäude  ","Keßlerplatz 12"]
[7250,"0039","SP Kesslerstraße 1  ","Postbank      "]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Gebäude","Bezeichnung 1","Bezeichnung 2"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"geb.geb_nr","geb.geb","geb.geb2"]
[]
[]
["Anmerkungen:"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Geschoss","index":8,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Gebaeude_KNZ","Geschoss_KNZ","Geschoss_KURZBEZ"]
[7250,"0045","00","Erdgeschoss"]
[7250,"0039","01","1.Obergeschoss"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Gebäude","Geschoss","Bezeichnung"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"ges.geb_nr","ges.ges_nr","ges.ges"]
[]
[]
["Anmerkungen:"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Raum","index":9,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Mandant","Gebaeude_KNZ","Geschoss_KNZ","RaumID","Raum_KNZ","Raum_KURZBEZ","Flaeche"]
[7250,"0045","00","0054","A206","Dozentenzimmer","34"]
[7250,"0039","01","0136","A604","CAD-Labor","20,50"]
["…"]
[]
[]
["Beschreibung:"]
["Hochschule","Gebäude","Geschoss","Raum ID","Raum","Bezeichnung","Fläche"]
[]
[]
["Vorschlag Tabellenfelder im Quellsystem HIS:"]
[null,"stamm.geb_nr","stamm.ges_nr","stamm.raumid","stamm.raumnr","stamm.bez","stamm.flaeche"]
[]
[]
["Anmerkungen:"]
[]
[]
["Screenshot aus dem Quellsystem HIS:"]

{"sheet":"Zahlungspartner","index":10,"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":"Geldgeber","index":11,"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":"Kostenstelle","index":12,"n_rows":22,"n_cols":16,"rows_kept":22,"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"]
[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"]
[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"]
["…"]
[]
[]
["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"]
[]
[]
["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"]
[]
[]
["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":"Kapitel","index":13,"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":14,"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:"]