{"format":"Stratum-Liegenschaftspaket","version":1,"erstellt":"2026-10-07 15:15:10","liegenschaft":{"nummer":1,"name":"STWEG Sonnenrain 3"},"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,"Od819a1718a8f4a01b72d9605a7718baa",3,5376,1344,"2026-01-01","2026-12-31",0,"",0],[2,1,1,2,"O613f70d76e1d4a9a8053f82d3f64cbc7",3,5776,1444,"2026-01-01","2026-12-31",0,"",0],[3,1,1,3,"Ob45afa9d70504cdba351e8860971374c",3,2788,697,"2026-01-01","2026-12-31",0,"",0],[4,1,1,4,"Ob45afa9d70504cdba351e8860971374c",3,2788,697,"2026-01-01","2026-12-31",0,"",0],[5,1,1,5,"O0baa57c8dc71485582718af51da71b96",3,5576,1394,"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 Sonnenrain 3",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":[[21,1,1,21,"2026-01-12","2026-01-12","1","Heiz\u00F6l Lieferung 4\u0027000 l",17,3,4520,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:09",null,0,21000,0,0,0,null,1,null],[1,1,1,1,"2026-01-20","2026-01-20","2","Akonto Q1 W1 \u2013 Lea Graf",3,47,1344,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:09",null,0,1000,0,0,1,null,1,null],[2,1,1,2,"2026-01-20","2026-01-20","3","Akonto Q1 W2 \u2013 Remo Meister",3,48,1444,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,2000,0,0,1,null,1,null],[3,1,1,3,"2026-01-20","2026-01-20","4","Akonto Q1 W3 \u2013 Andrea Vogt",3,49,697,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,3000,0,0,1,null,1,null],[4,1,1,4,"2026-01-20","2026-01-20","5","Akonto Q1 W3 \u2013 Thomas Vogt",3,50,697,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,4000,0,0,1,null,1,null],[5,1,1,5,"2026-01-20","2026-01-20","6","Akonto Q1 W4 \u2013 Marc Steiner",3,51,1394,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,5000,0,0,1,null,1,null],[22,1,1,22,"2026-02-09","2026-02-09","7","Geb\u00E4udeversicherung 2026",31,3,2310,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,22000,0,0,0,null,1,null],[23,1,1,23,"2026-03-31","2026-03-31","8","Hauswartung Q1",26,3,900,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,23000,0,0,0,null,1,null],[6,1,1,6,"2026-04-18","2026-04-18","9","Akonto Q2 W1 \u2013 Lea Graf",3,47,1344,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,6000,0,0,1,null,1,null],[7,1,1,7,"2026-04-18","2026-04-18","10","Akonto Q2 W2 \u2013 Remo Meister",3,48,1444,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,7000,0,0,1,null,1,null],[8,1,1,8,"2026-04-18","2026-04-18","11","Akonto Q2 W3 \u2013 Andrea Vogt",3,49,697,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,8000,0,0,1,null,1,null],[9,1,1,9,"2026-04-18","2026-04-18","12","Akonto Q2 W3 \u2013 Thomas Vogt",3,50,697,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,9000,0,0,1,null,1,null],[10,1,1,10,"2026-04-18","2026-04-18","13","Akonto Q2 W4 \u2013 Marc Steiner",3,51,1394,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,10000,0,0,1,null,1,null],[26,1,1,26,"2026-05-15","2026-05-15","14","Wasser/Abwasser 1. Halbjahr",23,3,870,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,26000,0,0,0,null,1,null],[24,1,1,24,"2026-06-30","2026-06-30","15","Hauswartung Q2",26,3,900,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,24000,0,0,0,null,1,null],[27,1,1,27,"2026-06-30","2026-06-30","16","Allgemeinstrom 1. Halbjahr",28,3,410,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,27000,0,0,0,null,1,null],[28,1,1,28,"2026-06-30","2026-06-30","17","Verwaltungshonorar 1. Halbjahr",35,3,1200,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,28000,0,0,0,null,1,null],[29,1,1,29,"2026-06-30","2026-06-30","18","Einlage Erneuerungsfonds 1. Halbjahr",41,12,2000,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,29000,0,0,0,null,1,null],[11,1,1,11,"2026-07-21","2026-07-21","19","Akonto Q3 W1 \u2013 Lea Graf",3,47,1344,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,11000,0,0,1,null,1,null],[12,1,1,12,"2026-07-21","2026-07-21","20","Akonto Q3 W2 \u2013 Remo Meister",3,48,1444,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,12000,0,0,1,null,1,null],[13,1,1,13,"2026-07-21","2026-07-21","21","Akonto Q3 W3 \u2013 Andrea Vogt",3,49,697,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,13000,0,0,1,null,1,null],[14,1,1,14,"2026-07-21","2026-07-21","22","Akonto Q3 W3 \u2013 Thomas Vogt",3,50,697,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,14000,0,0,1,null,1,null],[15,1,1,15,"2026-07-21","2026-07-21","23","Akonto Q3 W4 \u2013 Marc Steiner",3,51,1394,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,15000,0,0,1,null,1,null],[25,1,1,25,"2026-09-30","2026-09-30","24","Hauswartung Q3",26,3,900,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,25000,0,0,0,null,1,null],[16,1,1,16,"2026-10-02","2026-10-02","25","Akonto Q4 W1 \u2013 Lea Graf",3,47,1344,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,16000,0,0,1,null,1,null],[17,1,1,17,"2026-10-02","2026-10-02","26","Akonto Q4 W2 \u2013 Remo Meister",3,48,1444,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,17000,0,0,1,null,1,null],[18,1,1,18,"2026-10-02","2026-10-02","27","Akonto Q4 W3 \u2013 Andrea Vogt",3,49,697,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,18000,0,0,1,null,1,null],[19,1,1,19,"2026-10-02","2026-10-02","28","Akonto Q4 W3 \u2013 Thomas Vogt",3,50,697,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,19000,0,0,1,null,1,null],[20,1,1,20,"2026-10-02","2026-10-02","29","Akonto Q4 W4 \u2013 Marc Steiner",3,51,1394,null,0,"2026-10-07 15:15:09","2026-10-07 15:15:10",null,0,20000,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,7200],[2,1,23,1800],[3,1,26,3600],[4,1,28,900],[5,1,31,2400],[6,1,35,2400],[7,1,41,4000]]},"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 Lea Graf","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 Remo Meister","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 Andrea Vogt","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 Thomas Vogt","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 Marc Steiner","90005","",null,null,10,0,"",10,"","",0,0,0,null,0,5,0,0,0,0,"",1,5,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 Sonnenrain 3","Sonnenrain","3","4153","Reinach","BL","CH",null,null,null,0,null,0,0,20,6,1,null,1,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":[[1,0,1,null,"NurNk","2026-04-01",null,null,"",0,3,"03-31;06-30;09-30",5100,"","","",null,null,0,0,"","2026-10-07 15:15:09",0,null,"CH56 0483 5012 3456 7800 9"]]},"mietverhaeltnis_mieter":{"columns":["id","mietverhaeltnis_id","person_nr","reihenfolge"],"rows":[[1,1,6,0]]},"mietverhaeltnis_nk":{"columns":["id","mietverhaeltnis_id","verteiler_id"],"rows":[[1,1,1],[2,1,2],[3,1,3],[4,1,6]]},"mietverhaeltnis_objekt":{"columns":["id","mietverhaeltnis_id","objekt_id","ist_hauptobjekt"],"rows":[[1,1,"Od819a1718a8f4a01b72d9605a7718baa",1]]},"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":[[1,1,"2026-04-01","Beginn",null,null,null,null,"",null]]},"mietzins_zeile":{"columns":["id","mietzins_stand_id","objekt_id","netto","nk_akonto","nk_pauschale","nk_positionen"],"rows":[[1,1,"Od819a1718a8f4a01b72d9605a7718baa",1700,180,0,""]]},"Objekt":{"columns":["ObjektId","ObjektNr","LiegenschaftNr","Typ","Bezeichnung","Stockwerk","Zimmer","Flaeche","Promille","EWID","NichtAbrechnen","Version","SollNetto","SollNk"],"rows":[["Od819a1718a8f4a01b72d9605a7718baa","W1",1,"Wohnung","Wohnung EG links","EG",3.5,84,240,null,0,0,0,0],["O613f70d76e1d4a9a8053f82d3f64cbc7","W2",1,"Wohnung","Wohnung EG rechts","EG",4.5,96,260,null,0,0,0,0],["Ob45afa9d70504cdba351e8860971374c","W3",1,"Wohnung","Wohnung OG links","OG",4.5,92,250,null,0,0,0,0],["O0baa57c8dc71485582718af51da71b96","W4",1,"Wohnung","Wohnung OG rechts","OG",4.5,92,250,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,"Od819a1718a8f4a01b72d9605a7718baa",1,1000,1,null,null,null],[2,"O613f70d76e1d4a9a8053f82d3f64cbc7",2,1000,1,null,null,null],[3,"Ob45afa9d70504cdba351e8860971374c",3,500,1,null,null,null],[4,"Ob45afa9d70504cdba351e8860971374c",4,500,1,null,null,null],[5,"O0baa57c8dc71485582718af51da71b96",5,1000,1,null,null,null]]},"ObjektVerteilerWert":{"columns":["Id","VerteilerId","ObjektId","GeschaeftsjahrId","Wert","PersonNr"],"rows":[[1,1,"Od819a1718a8f4a01b72d9605a7718baa",1,240,null],[2,1,"O613f70d76e1d4a9a8053f82d3f64cbc7",1,260,null],[3,1,"Ob45afa9d70504cdba351e8860971374c",1,250,null],[4,1,"O0baa57c8dc71485582718af51da71b96",1,250,null],[5,2,"Od819a1718a8f4a01b72d9605a7718baa",1,240,null],[6,2,"O613f70d76e1d4a9a8053f82d3f64cbc7",1,260,null],[7,2,"Ob45afa9d70504cdba351e8860971374c",1,250,null],[8,2,"O0baa57c8dc71485582718af51da71b96",1,250,null],[9,3,"Od819a1718a8f4a01b72d9605a7718baa",1,240,null],[10,3,"O613f70d76e1d4a9a8053f82d3f64cbc7",1,260,null],[11,3,"Ob45afa9d70504cdba351e8860971374c",1,250,null],[12,3,"O0baa57c8dc71485582718af51da71b96",1,250,null],[13,4,"Od819a1718a8f4a01b72d9605a7718baa",1,1,null],[14,4,"O613f70d76e1d4a9a8053f82d3f64cbc7",1,1,null],[15,4,"Ob45afa9d70504cdba351e8860971374c",1,1,null],[16,4,"O0baa57c8dc71485582718af51da71b96",1,1,null],[17,5,"Od819a1718a8f4a01b72d9605a7718baa",1,240,null],[18,5,"O613f70d76e1d4a9a8053f82d3f64cbc7",1,260,null],[19,5,"Ob45afa9d70504cdba351e8860971374c",1,250,null],[20,5,"O0baa57c8dc71485582718af51da71b96",1,250,null],[21,6,"Od819a1718a8f4a01b72d9605a7718baa",1,240,null],[22,6,"O613f70d76e1d4a9a8053f82d3f64cbc7",1,260,null],[23,6,"Ob45afa9d70504cdba351e8860971374c",1,250,null],[24,6,"O0baa57c8dc71485582718af51da71b96",1,250,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":[[2,1,0,0,0,0,null,null,"Remo","Meister",null,null,0,null,null,null,null,null,null,null,null,"remo.meister@example.ch",null,null,null,null,null,"Bahnhofstrasse 21",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,"Andrea","Vogt",null,null,0,null,null,null,null,null,null,null,null,"andrea.vogt@example.ch",null,null,null,null,null,"Sonnenrain 3",null,"4153","Reinach","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,0,null,null,null,null],[4,1,0,0,0,0,null,null,"Thomas","Vogt",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sonnenrain 3",null,"4153","Reinach","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,0,null,null,null,null],[5,1,0,0,0,0,null,null,"Marc","Steiner",null,null,0,null,null,null,null,null,null,null,null,"marc.steiner@example.ch",null,null,null,null,null,"Sonnenrain 3",null,"4153","Reinach","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,0,null,null,null,null],[1,1,0,0,0,0,null,null,"Lea","Graf",null,null,0,null,null,null,null,null,null,null,null,"lea.graf@example.ch",null,null,null,null,null,"Gartenweg 5",null,"4153","Reinach","Schweiz","CH56 0483 5012 3456 7800 9","[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,1,0,null,null,null,null],[6,0,0,0,0,0,null,null,"Pia","Lehmann",null,null,0,null,null,null,null,null,null,null,null,"pia.lehmann@example.ch",null,null,null,null,null,"Sonnenrain 3",null,"4153","Reinach","Schweiz",null,"[\u00DCbung] Erfundene Mieterin der \u00DCbungsliegenschaft",3,0,1,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":[]},"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":[]},"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":[]}}}