{"format":"Stratum-Liegenschaftspaket","version":1,"erstellt":"2026-10-07 15:14:51","liegenschaft":{"nummer":1,"name":"STWEG Musterweg 12"},"mitDateien":false,"hinweise":[],"tables":{"akonto_plan":{"columns":["Id","liegenschaft_nr","geschaeftsjahr_id","person_nr","objekt_id","intervall","jahresbetrag","ratenbetrag","von","bis","is_archived","bemerkung","Version"],"rows":[[1,1,1,1,"Oc1ab315946664d0c8c9ab37779453ab4",3,5424,1356,"2026-01-01","2026-12-31",0,"",0],[2,1,1,2,"Ob5c413580df546a7b00cf218866f61ad",3,6280,1570,"2026-01-01","2026-12-31",0,"",0],[3,1,1,3,"O327ec6554f4a4cdab9eb399cdea02375",3,2712,678,"2026-01-01","2026-06-30",0,"",0],[4,1,1,4,"O327ec6554f4a4cdab9eb399cdea02375",3,2712,678,"2026-07-01","2026-12-31",0,"",0],[5,1,1,5,"O63d3bb998ebb41ec85e67311a438f8b8",3,6280,1570,"2026-01-01","2026-12-31",0,"",0],[6,1,1,6,"Od6adc60f6db04d3ab5ab7e53fb432ea2",3,6996,1749,"2026-01-01","2026-12-31",0,"",0],[7,1,1,6,"Oef63c541aaeb4dfe9bb5db6cd82f9d29",3,856,214,"2026-01-01","2026-12-31",0,"",0],[8,1,1,7,"Oa1d42d28f71846a490abdfe0d3a91975",3,856,214,"2026-01-01","2026-12-31",0,"",0]]},"Bankkonto":{"columns":["Id","LiegenschaftNr","Bezeichnung","IBAN","Bankname","KontoInhaber","Aktiv","KontoNodeId","Version"],"rows":[[1,1,"Betriebskonto","CH4431999123000889012","Beispielbank","STWEG Musterweg 12",1,3,0]]},"BilanzLayoutZeile":{"columns":["Id","LiegenschaftNr","ParentNodeId","ReferenzNodeId","IstUnterhalb","ZeilenTyp","SortOrder","Text","Hoehe","BackColor","ForeColor","Bold","Italic","Center","Schriftgroesse","IsArchived","NichtDrucken","Version"],"rows":[]},"Buchung":{"columns":["Id","LiegenschaftNr","GeschaeftsjahrId","BuchungNr","BuchungsDatum","BelegDatum","BelegNr","BuchungsText","SollKontoNodeId","HabenKontoNodeId","Betrag","Notiz","IstStorniert","ErstelltAm","GeaendertAm","StornoZuBuchungId","IstLeerzeile","ZeilenSortierung","SteuerAbzugsfaehig","IstZinsertrag","IstAkonto","QuelleTemplateId","Version","Menge"],"rows":[[27,1,1,27,"2026-01-15","2026-01-15","1","Heiz\u00F6l Lieferung 5\u0027000 l",17,3,5650,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,27000,0,0,0,null,1,null],[1,1,1,1,"2026-01-20","2026-01-20","2","Akonto Q1 W1 \u2013 Ruth Ammann",3,47,1356,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,1000,0,0,1,null,1,null],[2,1,1,2,"2026-01-20","2026-01-20","3","Akonto Q1 W2 \u2013 Luca Bianchi",3,48,1570,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,2000,0,0,1,null,1,null],[3,1,1,3,"2026-01-20","2026-01-20","4","Akonto Q1 W3 \u2013 Hans Gerber",3,49,678,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,3000,0,0,1,null,1,null],[4,1,1,4,"2026-01-20","2026-01-20","5","Akonto Q1 W4 \u2013 Daniel Schmid",3,51,1570,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,4000,0,0,1,null,1,null],[5,1,1,5,"2026-01-20","2026-01-20","6","Akonto Q1 W5 \u2013 Monika Weber",3,52,1749,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,5000,0,0,1,null,1,null],[6,1,1,6,"2026-01-20","2026-01-20","7","Akonto Q1 G1 \u2013 Monika Weber",3,52,214,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,6000,0,0,1,null,1,null],[7,1,1,7,"2026-01-20","2026-01-20","8","Akonto Q1 G2 \u2013 Peter Kunz",3,53,214,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,7000,0,0,1,null,1,null],[28,1,1,28,"2026-02-10","2026-02-10","9","Geb\u00E4udeversicherung 2026",31,3,2860,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,28000,0,0,0,null,1,null],[29,1,1,29,"2026-03-31","2026-03-31","10","Hauswartung Q1",26,3,1200,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,29000,0,0,0,null,1,null],[32,1,1,32,"2026-04-12","2026-04-12","11","Allgemeinstrom 1. Halbjahr",28,3,540,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,32000,0,0,0,null,1,null],[8,1,1,8,"2026-04-18","2026-04-18","12","Akonto Q2 W1 \u2013 Ruth Ammann",3,47,1356,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,8000,0,0,1,null,1,null],[9,1,1,9,"2026-04-18","2026-04-18","13","Akonto Q2 W2 \u2013 Luca Bianchi",3,48,1570,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,9000,0,0,1,null,1,null],[10,1,1,10,"2026-04-18","2026-04-18","14","Akonto Q2 W3 \u2013 Hans Gerber",3,49,678,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,10000,0,0,1,null,1,null],[11,1,1,11,"2026-04-18","2026-04-18","15","Akonto Q2 W4 \u2013 Daniel Schmid",3,51,1570,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,11000,0,0,1,null,1,null],[12,1,1,12,"2026-04-18","2026-04-18","16","Akonto Q2 W5 \u2013 Monika Weber",3,52,1749,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,12000,0,0,1,null,1,null],[13,1,1,13,"2026-04-18","2026-04-18","17","Akonto Q2 G1 \u2013 Monika Weber",3,52,214,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,13000,0,0,1,null,1,null],[14,1,1,14,"2026-04-18","2026-04-18","18","Akonto Q2 G2 \u2013 Peter Kunz",3,53,214,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,14000,0,0,1,null,1,null],[33,1,1,33,"2026-05-20","2026-05-20","19","Wasser/Abwasser 1. Halbjahr",23,3,1180,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,33000,0,0,0,null,1,null],[34,1,1,34,"2026-06-05","2026-06-05","20","Reparatur Garagentor",32,3,780,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,34000,0,0,0,null,1,null],[30,1,1,30,"2026-06-30","2026-06-30","21","Hauswartung Q2",26,3,1200,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,30000,0,0,0,null,1,null],[35,1,1,35,"2026-06-30","2026-06-30","22","Verwaltungshonorar 1. Halbjahr",35,3,1800,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,35000,0,0,0,null,1,null],[38,1,1,38,"2026-06-30","2026-06-30","23","Einlage Erneuerungsfonds 1. Halbjahr",41,12,3000,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,38000,0,0,0,null,1,null],[39,1,1,39,"2026-07-02","2026-07-02","24","\u00DCbertrag auf Fondskonto",4,3,3000,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,39000,0,0,0,null,1,null],[15,1,1,15,"2026-07-21","2026-07-21","25","Akonto Q3 W1 \u2013 Ruth Ammann",3,47,1356,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,15000,0,0,1,null,1,null],[16,1,1,16,"2026-07-21","2026-07-21","26","Akonto Q3 W2 \u2013 Luca Bianchi",3,48,1570,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,16000,0,0,1,null,1,null],[17,1,1,17,"2026-07-21","2026-07-21","27","Akonto Q3 W3 \u2013 Claudia Frei",3,50,678,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,17000,0,0,1,null,1,null],[18,1,1,18,"2026-07-21","2026-07-21","28","Akonto Q3 W5 \u2013 Monika Weber",3,52,1749,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,18000,0,0,1,null,1,null],[19,1,1,19,"2026-07-21","2026-07-21","29","Akonto Q3 G1 \u2013 Monika Weber",3,52,214,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,19000,0,0,1,null,1,null],[20,1,1,20,"2026-07-21","2026-07-21","30","Akonto Q3 G2 \u2013 Peter Kunz",3,53,214,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,20000,0,0,1,null,1,null],[36,1,1,36,"2026-09-18","2026-09-18","31","Heiz\u00F6l Lieferung 2\u0027500 l",17,3,2890,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,36000,0,0,0,null,1,null],[31,1,1,31,"2026-09-30","2026-09-30","32","Hauswartung Q3",26,3,1200,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,31000,0,0,0,null,1,null],[37,1,1,37,"2026-09-30","2026-09-30","33","Bankspesen Q1\u2013Q3",37,3,45,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,37000,0,0,0,null,1,null],[21,1,1,21,"2026-10-02","2026-10-02","34","Akonto Q4 W1 \u2013 Ruth Ammann",3,47,1356,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,21000,0,0,1,null,1,null],[22,1,1,22,"2026-10-02","2026-10-02","35","Akonto Q4 W2 \u2013 Luca Bianchi",3,48,1570,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,22000,0,0,1,null,1,null],[23,1,1,23,"2026-10-02","2026-10-02","36","Akonto Q4 W3 \u2013 Claudia Frei",3,50,678,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,23000,0,0,1,null,1,null],[24,1,1,24,"2026-10-02","2026-10-02","37","Akonto Q4 W5 \u2013 Monika Weber",3,52,1749,null,0,"2026-10-07 15:14:50","2026-10-07 15:14:51",null,0,24000,0,0,1,null,1,null],[25,1,1,25,"2026-10-02","2026-10-02","38","Akonto Q4 G1 \u2013 Monika Weber",3,52,214,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,25000,0,0,1,null,1,null],[26,1,1,26,"2026-10-02","2026-10-02","39","Akonto Q4 G2 \u2013 Peter Kunz",3,53,214,null,0,"2026-10-07 15:14:51","2026-10-07 15:14:51",null,0,26000,0,0,1,null,1,null]]},"BuchungBeleg":{"columns":["Id","BuchungId","DateiPfad","Dateiname","Beschreibung","AngelegtAm","DateiGroesse","DateiInhalt","MigriertZuVerknId"],"rows":[]},"BuchungsTemplate":{"columns":["Id","LiegenschaftNr","Name","SollKontoNodeId","HabenKontoNodeId","BuchungsText","StandardBetrag","IstJahresstart","Sortierung","SteuerAbzugsfaehig","IstAkonto","Rhythmus","Zahltag","Version"],"rows":[]},"Budget":{"columns":["Id","GeschaeftsjahrId","KontoNodeId","Betrag"],"rows":[[1,1,17,9000],[2,1,23,2400],[3,1,26,4800],[4,1,28,1200],[5,1,31,3000],[6,1,32,2000],[7,1,35,3600],[8,1,37,120],[9,1,41,6000]]},"DebitorPosition":{"columns":["Id","RechnungId","Pos","Bezeichnung","Menge","Einheit","Einzelpreis"],"rows":[]},"DebitorRechnung":{"columns":["Id","LiegenschaftNr","RechnungNr","SchuldnerName","SchuldnerStrasse","SchuldnerHausNr","SchuldnerPlz","SchuldnerOrt","SchuldnerLand","Betrag","Waehrung","Betreff","Beschreibung","Fusstext","Referenz","ErtragKontoNodeId","Rechnungsdatum","Faelligkeit","Status","ErstelltAm","BezahltAm","BuchungId","Notiz","Version"],"rows":[]},"Dokument":{"columns":["Id","LiegenschaftNr","Kategorie","BankkontoId","GeschaeftsjahrId","OrdnerId","Datum","PeriodeText","Bemerkung","Dateiname","DateiGroesse","HochgeladenAm","GeloeschtAm","DateiInhalt","InhaltHash","Version"],"rows":[]},"DokumentOrdner":{"columns":["Id","LiegenschaftNr","Name","ParentId","KategorieSektion","GeschaeftsjahrId","Sortierung"],"rows":[]},"DokumentVerknuepfung":{"columns":["Id","DokumentId","KontextTyp","KontextId","AngelegtAm"],"rows":[]},"Erhaltungsplan":{"columns":["Id","LiegenschaftNr","Jahr","Monat","Massnahme","Kosten","Bemerkung","BauteilId"],"rows":[]},"Eroeffnungssaldo":{"columns":["Id","GeschaeftsjahrId","KontoNodeId","Betrag"],"rows":[]},"fahrplan_schritt":{"columns":["id","geschaeftsjahr_id","art","schluessel","erledigt_am","von_wem","notiz"],"rows":[]},"Geschaeftsjahr":{"columns":["Id","LiegenschaftNr","Von","Bis","Status","IsAktiv","AbgeschlossenAm","Version","HonorarProzent"],"rows":[[1,1,"2026-01-01","2026-12-31","Offen",1,null,1,null]]},"kontenplan_nodes":{"columns":["id","liegenschaft_nr","parent_id","node_type","nummer","bezeichnung","code","summiert_in_code","bklasse","summ_in","berechnungsart","anzeige_typ","anzeige_text","anzeige_hoehe","anzeige_backcolor","anzeige_forecolor","anzeige_bold","anzeige_italic","anzeige_center","anzeige_schriftgroesse","anzeige_nicht_drucken","sort_order","is_archived","ist_nk_relevant","ist_erneuerungsfonds","ist_mengenkonto","mengen_einheit","mengen_preis_basis","eigentuemer_person_nr","Version","mietverhaeltnis_id"],"rows":[[1,1,null,"section",1,"AKTIVEN","1","",1,null,10,0,"",10,"","",1,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[2,1,1,"group",10,"Umlaufverm\u00F6gen","10","",null,null,10,0,"",10,"","",1,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[3,1,2,"account",10020,"Betriebskonto","10020","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[5,1,2,"account",10300,"Aktive Rechnungsabgrenzung","10300","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[6,1,2,"account",10990,"Abrechnungskonto Nebenkosten","10990","",null,null,10,0,"",10,"","",0,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[7,1,null,"section",2,"PASSIVEN","2","",2,null,10,0,"",10,"","",1,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[8,1,7,"group",null,"Stockwerkeigent\u00FCmer","220P","",null,null,10,0,"",10,"","",1,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[9,1,7,"account",20000,"Kreditoren","20000","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[10,1,7,"account",20800,"R\u00FCckstellungen","20800","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[11,1,7,"account",20900,"Passive Rechnungsabgrenzung (TP)","20900","",null,null,10,0,"",10,"","",0,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[13,1,7,"account",29700,"Verteilung Jahresgewinn/Jahresverlust","29700","",null,null,10,0,"",10,"","",0,0,0,null,0,5,0,0,0,0,"",1,null,0,null],[14,1,7,"calculated",null,"GEWINN / VERLUST","","",null,null,24,0,"",10,"","",1,0,0,null,0,6,0,0,0,0,"",1,null,0,null],[15,1,null,"section",3,"AUFWAND","3","",3,null,10,0,"",10,"","",1,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[17,1,16,"account",50011,"Energie (\u00D6l, Gas, Fernw\u00E4rme, Strom)","50011","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[18,1,16,"account",50013,"Kaminfeger / Feuerungskontrolle","50013","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[19,1,16,"account",50015,"Betriebsstrom Heizung","50015","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[20,1,16,"account",50025,"Unterhalt / Reparatur Heizung","50025","",null,null,10,0,"",10,"","",0,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[23,1,22,"account",51010,"Wasser / Abwasser","51010","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[24,1,22,"account",51370,"Wasser- / Abwassergeb\u00FChren","51370","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[26,1,25,"account",51205,"Hauswart / Abwart","51205","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[27,1,25,"account",51206,"Reinigung Treppenhaus","51206","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[28,1,25,"account",51213,"Allgemeinstrom","51213","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[29,1,25,"account",51215,"Lift / Aufzug (Wartung, Notruf)","51215","",null,null,10,0,"",10,"","",0,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[30,1,25,"account",51217,"Kehricht- und Abfallgeb\u00FChren","51217","",null,null,10,0,"",10,"","",0,0,0,null,0,4,0,0,0,0,"",1,null,0,null],[31,1,25,"account",51220,"Versicherungen","51220","",null,null,10,0,"",10,"","",0,0,0,null,0,5,0,0,0,0,"",1,null,0,null],[32,1,25,"account",51230,"Unterhalt / Reparatur Geb\u00E4ude","51230","",null,null,10,0,"",10,"","",0,0,0,null,0,6,0,0,0,0,"",1,null,0,null],[33,1,25,"account",51240,"Unterhalt Garten / Umgebung","51240","",null,null,10,0,"",10,"","",0,0,0,null,0,7,0,0,0,0,"",1,null,0,null],[35,1,34,"account",51330,"Verwaltungs- und Revisorenhonorar","51330","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[37,1,36,"account",52085,"Bankspesen / \u00FCbriger Zinsaufwand","52085","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[39,1,38,"account",53050,"\u00DCbriger Aufwand","53050","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[41,1,40,"account",57000,"Einlage Erneuerungsfonds","57000","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[42,1,null,"section",4,"ERTRAG","4","",4,null,10,0,"",10,"","",1,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[44,1,43,"account",56010,"Zinsertrag","56010","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[45,1,43,"account",56030,"Einnahmen","","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[46,1,null,"calculated",null,"BILANZDIFFERENZ","","",null,null,25,0,"",10,"","",1,0,0,null,0,4,0,0,0,0,"",1,null,0,null],[21,1,15,"group",501,"Unterhaltskosten Individuell","501","",null,null,10,0,"",10,"","",1,0,0,null,0,1,0,0,0,0,"",1,null,1,null],[16,1,15,"group",500,"Heizkosten","500","",null,null,10,0,"",10,"","",1,0,0,null,0,0,0,1,0,0,"",1,null,2,null],[22,1,15,"group",510,"Wasser und Abwasser","510","",null,null,10,0,"",10,"","",1,0,0,null,0,2,0,1,0,0,"",1,null,2,null],[25,1,15,"group",512,"Hausnebenkosten","512","",null,null,10,0,"",10,"","",1,0,0,null,0,3,0,1,0,0,"",1,null,2,null],[36,1,15,"group",520,"Bankspesen","520","",null,null,10,0,"",10,"","",1,0,0,null,0,5,0,1,0,0,"",1,null,2,null],[38,1,15,"group",530,"\u00DCbriger Aufwand","530","",null,null,10,0,"",10,"","",1,0,0,null,0,6,0,1,0,0,"",1,null,2,null],[34,1,15,"group",513,"Honorar und Geb\u00FChren","513","",null,null,10,0,"",10,"","",1,0,0,null,0,4,0,1,0,0,"",1,null,2,null],[40,1,15,"group",570,"Einlage Erneuerungsfonds","570","",null,null,10,0,"",10,"","",1,0,0,null,0,7,0,1,0,0,"",1,null,2,null],[4,1,2,"account",10021,"Bankkonto Erneuerungsfonds","10021","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,1,0,"",1,null,1,null],[12,1,7,"account",25000,"Erneuerungsfonds","25000","",null,null,10,0,"",10,"","",0,0,0,null,0,4,0,0,1,0,"",1,null,1,null],[43,1,42,"group",560,"Einnahmen Zins \u0026 Parkpl\u00E4tze","560","",null,null,10,0,"",10,"","",1,0,0,null,0,0,0,1,0,0,"",1,null,2,null],[47,1,8,"account",90001,"STWEG Eigent\u00FCmerkonto Ruth Ammann","90001","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,1,0,null],[48,1,8,"account",90002,"STWEG Eigent\u00FCmerkonto Luca Bianchi","90002","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,2,0,null],[49,1,8,"account",90003,"STWEG Eigent\u00FCmerkonto Hans Gerber","90003","",null,null,10,0,"",10,"","",0,0,0,null,0,3,0,0,0,0,"",1,3,0,null],[50,1,8,"account",90004,"STWEG Eigent\u00FCmerkonto Claudia Frei","90004","",null,null,10,0,"",10,"","",0,0,0,null,0,4,0,0,0,0,"",1,4,0,null],[51,1,8,"account",90005,"STWEG Eigent\u00FCmerkonto Daniel Schmid","90005","",null,null,10,0,"",10,"","",0,0,0,null,0,5,0,0,0,0,"",1,5,0,null],[52,1,8,"account",90006,"STWEG Eigent\u00FCmerkonto Monika Weber","90006","",null,null,10,0,"",10,"","",0,0,0,null,0,6,0,0,0,0,"",1,6,0,null],[53,1,8,"account",90007,"STWEG Eigent\u00FCmerkonto Peter Kunz","90007","",null,null,10,0,"",10,"","",0,0,0,null,0,7,0,0,0,0,"",1,7,0,null]]},"KreditorRechnung":{"columns":["Id","LiegenschaftNr","EmpfaengerName","EmpfaengerAdresse","EmpfaengerPlzOrt","EmpfaengerStrasse","EmpfaengerHausNr","EmpfaengerPlz","EmpfaengerOrt","EmpfaengerLand","EmpfaengerIban","Betrag","Waehrung","Referenz","Mitteilung","AufwandKontoNodeId","Rechnungsdatum","Faelligkeit","Status","ErfasstAm","ExportiertAm","BezahltAm","BuchungId","Notiz","Buchungstext","Version","Menge","FreigegebenAm","FreigegebenVon"],"rows":[]},"Liegenschaft":{"columns":["LiegenschaftNr","Name","Strasse","Hausnummer","PLZ","Ort","Kanton","Land","EGID","MandatBeginn","MandatEnde","Archiviert","Bemerkung","KopfstimmeModus","Version","EinladungsfristTage","VersammlungFristMonate","EinfachesMehrNachKoepfen","Dachgeschoss","Obergeschosse","Untergeschosse","Art","AuftraggeberPersonNr","Mandat","MandatHonorarProzent","MandatReserve","MandatRhythmusMonate","UebergeordneteNr","IstUebung","UebungFassung"],"rows":[[1,"STWEG Musterweg 12","Musterweg","12","4242","Laufen","BL","CH",null,null,null,0,null,0,0,20,6,1,1,2,1,"STWEG",null,"Selbst",0,0,3,null,0,""]]},"LiegenschaftUnterhalt":{"columns":["Id","LiegenschaftNr","Datum","Kategorie","Beschreibung","Auftragnehmer","AuftragnehmerAdresse","Kosten","Notizen","Version","BauteilId","ErhaltungsplanId","GarantieBis","OffertBetrag","Quelle","Status","AuftragnehmerAdresse1","AuftragnehmerAdresse2","AuftragnehmerOrt","AuftragnehmerPlz"],"rows":[]},"LiegenschaftUnterhaltAnhang":{"columns":["Id","UnterhaltId","Dateiname","DateiPfad","DateiGroesse","HochgeladenAm","DateiInhalt","SchrittId"],"rows":[]},"mahnung":{"columns":["id","liegenschaft_nr","geschaeftsjahr_id","person_nr","objekt_id","stufe","datum","frist","offener_betrag","bemerkung","debitor_rechnung_id","mietverhaeltnis_id"],"rows":[]},"mengenkonto_lots":{"columns":["id","liegenschaft_nr","konto_node_id","geschaeftsjahr_id","datum","menge","preis_pro_einheit","beschreibung","Version","buchung_id"],"rows":[]},"mengenkonto_restbestand":{"columns":["liegenschaft_nr","konto_node_id","geschaeftsjahr_id","restmenge"],"rows":[]},"mietverhaeltnis":{"columns":["id","Version","liegenschaft_nr","vermieter_person_nr","umfang","beginn","ende","kuendigung_eingang","kuendigung_durch","familienwohnung","kuendigungsfrist_monate","kuendigungs_termine","kaution_betrag","kaution_art","kaution_bank","kaution_konto","kaution_hinterlegt_am","kaution_freigegeben_am","kaution_rueckbehalt","nk_verwaltung_prozent","bemerkung","erstellt_am","absender_vermieter","mietfrei_bis","zahlung_iban"],"rows":[]},"mietverhaeltnis_mieter":{"columns":["id","mietverhaeltnis_id","person_nr","reihenfolge"],"rows":[]},"mietverhaeltnis_nk":{"columns":["id","mietverhaeltnis_id","verteiler_id"],"rows":[]},"mietverhaeltnis_objekt":{"columns":["id","mietverhaeltnis_id","objekt_id","ist_hauptobjekt"],"rows":[]},"mietzins_anpassung":{"columns":["id","liegenschaft_nr","mietverhaeltnis_id","status","gueltig_ab","mitteilung","referenzzins","lik_stand","lik_datum","kostenstand","referenz_prozent","lik_prozent","kosten_prozent","begruendung","freigegeben_am","versandt_am","erstellt_am","lik_basis"],"rows":[]},"mietzins_anpassung_zeile":{"columns":["id","anpassung_id","objekt_id","netto_alt","netto_neu","nk_akonto","nk_pauschale","nk_positionen"],"rows":[]},"mietzins_stand":{"columns":["id","mietverhaeltnis_id","gueltig_ab","grund","referenzzins","lik_stand","lik_datum","kostenstand","bemerkung","lik_basis"],"rows":[]},"mietzins_zeile":{"columns":["id","mietzins_stand_id","objekt_id","netto","nk_akonto","nk_pauschale","nk_positionen"],"rows":[]},"Objekt":{"columns":["ObjektId","ObjektNr","LiegenschaftNr","Typ","Bezeichnung","Stockwerk","Zimmer","Flaeche","Promille","EWID","NichtAbrechnen","Version","SollNetto","SollNk"],"rows":[["Oc1ab315946664d0c8c9ab37779453ab4","W1",1,"Wohnung","Wohnung EG links","EG",3.5,86,165,null,0,0,0,0],["Ob5c413580df546a7b00cf218866f61ad","W2",1,"Wohnung","Wohnung EG rechts","EG",4.5,104,195,null,0,0,0,0],["O327ec6554f4a4cdab9eb399cdea02375","W3",1,"Wohnung","Wohnung 1. OG links","1. OG",3.5,86,165,null,0,0,0,0],["O63d3bb998ebb41ec85e67311a438f8b8","W4",1,"Wohnung","Wohnung 1. OG rechts","1. OG",4.5,104,195,null,0,0,0,0],["Od6adc60f6db04d3ab5ab7e53fb432ea2","W5",1,"Wohnung","Dachwohnung","DG",4.5,118,220,null,0,0,0,0],["Oef63c541aaeb4dfe9bb5db6cd82f9d29","G1",1,"Garage","Garage 1","UG",0,18,30,null,0,0,0,0],["Oa1d42d28f71846a490abdfe0d3a91975","G2",1,"Garage","Garage 2","UG",0,18,30,null,0,0,0,0]]},"objekt_plan":{"columns":["id","liegenschaft_nr","objekt_id","titel","reihenfolge","bild","breite","hoehe","meter_pro_pixel","zeichnung","erfasst_am"],"rows":[]},"ObjektEigentuemer":{"columns":["Id","ObjektId","PersonNr","AnteilPromille","IsAktiv","GueltigVon","GueltigBis","KontoNodeId"],"rows":[[1,"Oc1ab315946664d0c8c9ab37779453ab4",1,1000,1,null,null,null],[2,"Ob5c413580df546a7b00cf218866f61ad",2,1000,1,null,null,null],[3,"O327ec6554f4a4cdab9eb399cdea02375",3,1000,1,"2012-04-01","2026-06-30",null],[4,"O327ec6554f4a4cdab9eb399cdea02375",4,1000,1,"2026-07-01",null,null],[5,"O63d3bb998ebb41ec85e67311a438f8b8",5,1000,1,null,null,null],[6,"Od6adc60f6db04d3ab5ab7e53fb432ea2",6,1000,1,null,null,null],[7,"Oef63c541aaeb4dfe9bb5db6cd82f9d29",6,1000,1,null,null,null],[8,"Oa1d42d28f71846a490abdfe0d3a91975",7,1000,1,null,null,null]]},"ObjektVerteilerWert":{"columns":["Id","VerteilerId","ObjektId","GeschaeftsjahrId","Wert","PersonNr"],"rows":[[1,1,"Oef63c541aaeb4dfe9bb5db6cd82f9d29",1,30,null],[2,1,"Oa1d42d28f71846a490abdfe0d3a91975",1,30,null],[3,1,"Oc1ab315946664d0c8c9ab37779453ab4",1,165,null],[4,1,"Ob5c413580df546a7b00cf218866f61ad",1,195,null],[5,1,"O327ec6554f4a4cdab9eb399cdea02375",1,165,null],[6,1,"O63d3bb998ebb41ec85e67311a438f8b8",1,195,null],[7,1,"Od6adc60f6db04d3ab5ab7e53fb432ea2",1,220,null],[8,2,"Oef63c541aaeb4dfe9bb5db6cd82f9d29",1,30,null],[9,2,"Oa1d42d28f71846a490abdfe0d3a91975",1,30,null],[10,2,"Oc1ab315946664d0c8c9ab37779453ab4",1,165,null],[11,2,"Ob5c413580df546a7b00cf218866f61ad",1,195,null],[12,2,"O327ec6554f4a4cdab9eb399cdea02375",1,165,null],[13,2,"O63d3bb998ebb41ec85e67311a438f8b8",1,195,null],[14,2,"Od6adc60f6db04d3ab5ab7e53fb432ea2",1,220,null],[15,3,"Oef63c541aaeb4dfe9bb5db6cd82f9d29",1,30,null],[16,3,"Oa1d42d28f71846a490abdfe0d3a91975",1,30,null],[17,3,"Oc1ab315946664d0c8c9ab37779453ab4",1,165,null],[18,3,"Ob5c413580df546a7b00cf218866f61ad",1,195,null],[19,3,"O327ec6554f4a4cdab9eb399cdea02375",1,165,null],[20,3,"O63d3bb998ebb41ec85e67311a438f8b8",1,195,null],[21,3,"Od6adc60f6db04d3ab5ab7e53fb432ea2",1,220,null],[22,4,"Oc1ab315946664d0c8c9ab37779453ab4",1,1,null],[23,4,"Ob5c413580df546a7b00cf218866f61ad",1,1,null],[24,4,"O327ec6554f4a4cdab9eb399cdea02375",1,1,null],[25,4,"O63d3bb998ebb41ec85e67311a438f8b8",1,1,null],[26,4,"Od6adc60f6db04d3ab5ab7e53fb432ea2",1,1,null],[27,5,"Oef63c541aaeb4dfe9bb5db6cd82f9d29",1,30,null],[28,5,"Oa1d42d28f71846a490abdfe0d3a91975",1,30,null],[29,5,"Oc1ab315946664d0c8c9ab37779453ab4",1,165,null],[30,5,"Ob5c413580df546a7b00cf218866f61ad",1,195,null],[31,5,"O327ec6554f4a4cdab9eb399cdea02375",1,165,null],[32,5,"O63d3bb998ebb41ec85e67311a438f8b8",1,195,null],[33,5,"Od6adc60f6db04d3ab5ab7e53fb432ea2",1,220,null],[34,6,"Oef63c541aaeb4dfe9bb5db6cd82f9d29",1,30,null],[35,6,"Oa1d42d28f71846a490abdfe0d3a91975",1,30,null],[36,6,"Oc1ab315946664d0c8c9ab37779453ab4",1,165,null],[37,6,"Ob5c413580df546a7b00cf218866f61ad",1,195,null],[38,6,"O327ec6554f4a4cdab9eb399cdea02375",1,165,null],[39,6,"O63d3bb998ebb41ec85e67311a438f8b8",1,195,null],[40,6,"Od6adc60f6db04d3ab5ab7e53fb432ea2",1,220,null]]},"Person":{"columns":["PersonNr","IsStockwerkeigentuemer","IsLieferant","IsServicefirma","IsArchiviert","SteuerdomizilAusland","Anrede","Briefanrede","VornameFirma1","Nachname1","GebDatum1","Nation1","Optional2","Anrede2","VornameFirma2","Nachname2","GebDatum2","Nation2","TelPrivat","TelHandy","TelGeschaeft","Email","Website","TelPrivat2","TelHandy2","TelGeschaeft2","Email2","Adresse1","Adresse2","Plz","Ort","Land","Iban","Bemerkung","Zahlungsrhythmus","Version","IsMieter","NeuAdresse1","NeuAdresseAb","NeuOrt","NeuPlz"],"rows":[[1,1,0,0,0,0,null,null,"Ruth","Ammann",null,null,0,null,null,null,null,null,null,null,null,"ruth.ammann@example.ch",null,null,null,null,null,"Musterweg 12",null,"4242","Laufen","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,0,null,null,null,null],[2,1,0,0,0,0,null,null,"Luca","Bianchi",null,null,0,null,null,null,null,null,null,null,null,"luca.bianchi@example.ch",null,null,null,null,null,"Musterweg 12",null,"4242","Laufen","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,0,null,null,null,null],[3,1,0,0,0,0,null,null,"Hans","Gerber",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Musterweg 12",null,"4242","Laufen","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,0,null,null,null,null],[4,1,0,0,0,0,null,null,"Claudia","Frei",null,null,0,null,null,null,null,null,null,null,null,"claudia.frei@example.ch",null,null,null,null,null,"Musterweg 12",null,"4242","Laufen","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,0,null,null,null,null],[5,1,0,0,0,0,null,null,"Daniel","Schmid",null,null,0,null,null,null,null,null,null,null,null,"d.schmid@example.ch",null,null,null,null,null,"Musterweg 12",null,"4242","Laufen","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,0,null,null,null,null],[6,1,0,0,0,0,null,null,"Monika","Weber",null,null,0,null,null,null,null,null,null,null,null,"monika.weber@example.ch",null,null,null,null,null,"Hauptstrasse 4",null,"4242","Laufen","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,0,null,null,null,null],[7,1,0,0,0,0,null,null,"Peter","Kunz",null,null,0,null,null,null,null,null,null,null,null,"peter.kunz@example.ch",null,null,null,null,null,"Musterweg 12",null,"4242","Laufen","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,0,null,null,null,null]]},"Textbaustein":{"columns":["Id","LiegenschaftNr","Key","Text","Version"],"rows":[]},"uebergabe":{"columns":["id","liegenschaft_nr","mietverhaeltnis_id","art","datum","teilnehmer","bemerkung","quelle","zaehler_uebernommen","erstellt_am"],"rows":[]},"uebergabe_punkt":{"columns":["id","uebergabe_id","reihenfolge","raum","titel","zustand","bemerkung","zulasten_von","kosten","behoben","plan_x","plan_y"],"rows":[]},"uebergabe_schluessel":{"columns":["id","uebergabe_id","bezeichnung","anzahl"],"rows":[]},"uebergabe_zaehler":{"columns":["id","uebergabe_id","zaehler_id","stand"],"rows":[]},"unterhalt_bauteil":{"columns":["id","liegenschaft_nr","name","baujahr","lebensdauer_jahre","bemerkung","sortierung"],"rows":[]},"unterhalt_schritt":{"columns":["id","unterhalt_id","art","datum","betrag","notiz","kreditor_rechnung_id","traktandum_id","buchung_id","erstellt_am"],"rows":[]},"versammlung":{"columns":["Id","LiegenschaftNr","GeschaeftsjahrId","Datum","Ort","Art","Status","Bemerkung","Vorsitz","Protokollfuehrer","BeginnZeit","EndeZeit","GenehmigtBis","Version","Titel","SchonAufsHandy"],"rows":[[1,1,1,"2027-03-18","Restaurant R\u00F6ssli, Laufen",1,"Entwurf","","","","19:00","","",0,"Ordentliche Versammlung 2027",0]]},"versammlung_anwesenheit":{"columns":["VersammlungId","ParteiKey","Anwesend","VertretenDurch"],"rows":[]},"versammlung_stimme":{"columns":["TraktandumId","ParteiKey","Stimme"],"rows":[]},"versammlung_traktandum":{"columns":["Id","VersammlungId","Nr","Titel","Text","MitBeschluss","Antrag","Mehrheit","Protokoll","Ergebnis","JaKopf","NeinKopf","EnthaltungKopf","JaPromille","NeinPromille","Version"],"rows":[[1,1,1,"Begr\u00FCssung, Wahl der Stimmenz\u00E4hler","",0,"",1,"","",0,0,0,0,0,0],[2,1,2,"Protokoll der Versammlung 2026","",1,"Das Protokoll wird genehmigt.",1,"","",0,0,0,0,0,0],[3,1,3,"Jahresrechnung 2026 und Bericht der Revisorin","",1,"Die Jahresrechnung 2026 wird genehmigt, der Verwaltung Entlastung erteilt.",1,"","",0,0,0,0,0,0],[4,1,4,"Budget 2027 und Akonto","",1,"Das Budget 2027 wird genehmigt; die Akontozahlungen werden danach festgelegt.",1,"","",0,0,0,0,0,0],[5,1,5,"Ersatz der Heizung (Offerten)","",1,"Die Verwaltung holt bis zur n\u00E4chsten Versammlung drei Offerten ein.",2,"","",0,0,0,0,0,0],[6,1,6,"Verschiedenes","",0,"",1,"","",0,0,0,0,0,0]]},"versammlung_traktandum_anhang":{"columns":["Id","TraktandumId","MigriertZuVerknId"],"rows":[]},"Verteiler":{"columns":["Id","LiegenschaftNr","Nummer","Bezeichnung","Art","TotalSoll","IsArchived","ZaehlerId","DefaultQuelle","DefaultNurLeere","Aktiv","Name","Typ","Version","SummeErgibtSich","IstVerbrauch","AllgemeinNachVerteilerId","KostenAnteil","Teilung","TeilungArt","TeilungWert"],"rows":[[1,1,500,"Heizkosten","Objekt",1000,0,null,"MANUELL",1,1,"Heizkosten","EINHEIT",0,0,0,null,null,null,null,null],[2,1,510,"Wasser / Abwasser","Objekt",1000,0,null,"MANUELL",1,1,"Wasser / Abwasser","EINHEIT",0,0,0,null,null,null,null,null],[3,1,512,"Hausnebenkosten","Objekt",1000,0,null,"MANUELL",1,1,"Hausnebenkosten","EINHEIT",0,0,0,null,null,null,null,null],[4,1,513,"Honorar \u0026 Geb\u00FChren","Objekt",null,0,null,"MANUELL",1,1,"Honorar \u0026 Geb\u00FChren","EINHEIT",0,1,0,null,null,null,null,null],[5,1,570,"Einlage Erneuerungsfonds","Objekt",1000,0,null,"MANUELL",1,1,"Einlage Erneuerungsfonds","EINHEIT",0,0,0,null,null,null,null,null],[6,1,560,"Ertr\u00E4ge","Objekt",1000,0,null,"MANUELL",1,1,"Ertr\u00E4ge","EINHEIT",0,0,0,null,null,null,null,null]]},"verteiler_vermietung":{"columns":["verteiler_id","umlage","wechsel"],"rows":[]},"VerteilerBuchhaltungZuordnung":{"columns":["Id","VerteilerId","ZuordnungsTyp","KontoNodeId","Sortierung"],"rows":[[1,1,"Gruppe",16,0],[2,2,"Gruppe",22,0],[3,3,"Gruppe",25,0],[4,3,"Gruppe",36,1],[5,3,"Gruppe",38,2],[6,4,"Gruppe",34,0],[7,5,"Gruppe",40,0],[8,6,"Gruppe",43,0]]},"VerteilerObjektWert":{"columns":["Id","VerteilerId","ObjektId","GeschaeftsjahrId","Wert","Kommentar"],"rows":[]},"VerteilerZaehlerZuordnung":{"columns":["Id","VerteilerId","ZaehlerId","Sortierung"],"rows":[]},"WasserabrechnungKonto":{"columns":["LiegenschaftNr","Rolle","KontoNummer"],"rows":[]},"WasserabrechnungLauf":{"columns":["Id","LiegenschaftNr","GeschaeftsjahrId","WasserKostenTotal","TpBetrag","SalzKostenTotal","WasserGemeinde","AbwasserGemeinde","TpVorjahr","BillDatum","BillStand","BillEndStand","BillPreis","Status","BuchungIds","ErstelltAm"],"rows":[]},"WasserVerteilgruppe":{"columns":["Id","LiegenschaftNr","Sortierung","Name","IstRest","WasserKontoNummer","SalzKontoNummer"],"rows":[]},"WasserVerteilgruppeZaehler":{"columns":["GruppeId","ZaehlerId"],"rows":[]},"Zaehler":{"columns":["Id","LiegenschaftNr","Nummer","NummerCode","Bezeichnung","Art","Einheit","ObjektId","IstAllgemein","Zaehlernummer","IsAktiv","Bemerkung","SchluesselId","Rolle","Erfassungsart","Berechnungsart","BezugsZaehlerId","Version"],"rows":[]},"ZaehlerBerechnungsQuelle":{"columns":["Id","ZielZaehlerId","QuellZaehlerId"],"rows":[]},"Zaehlerstand":{"columns":["Id","ZaehlerId","Datum","Stand","Bemerkung"],"rows":[]}}}