{"format":"Stratum-Liegenschaftspaket","version":1,"erstellt":"2026-10-07 15:14:32","liegenschaft":{"nummer":1,"name":"Beispielhaus Lindenweg 7"},"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":[]},"Bankkonto":{"columns":["Id","LiegenschaftNr","Bezeichnung","IBAN","Bankname","KontoInhaber","Aktiv","KontoNodeId","Version"],"rows":[[1,1,"Mietzinskonto","CH4431999123000889012","Beispielbank","Beispielhaus Lindenweg 7",1,4,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":[[2,1,1,2,"2026-01-01","2026-01-01","1","NK-Akonto Januar 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,20,300,"Sollstellung-Schl\u00FCssel: MV1:2026-01:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,2000,0,0,0,null,1,null],[3,1,1,3,"2026-01-01","2026-01-01","2","Mietzins Januar 2026 \u2013 1.01 Lukas Meier",83,69,1650,"Sollstellung-Schl\u00FCssel: MV2:2026-01:O17d4f83632894eb5823511a68c46dc81:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,3000,0,0,0,null,1,null],[5,1,1,5,"2026-01-01","2026-01-01","3","Mietzins Januar 2026 \u2013 1.02 Fatma Yilmaz",84,69,1350,"Sollstellung-Schl\u00FCssel: MV3:2026-01:O5f4497821dcd483f959784e7f5234730:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,5000,0,0,0,null,1,null],[6,1,1,6,"2026-01-01","2026-01-01","3","NK-Akonto Januar 2026 \u2013 1.02 Fatma Yilmaz",84,20,180,"Sollstellung-Schl\u00FCssel: MV3:2026-01:O5f4497821dcd483f959784e7f5234730:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,6000,0,0,0,null,1,null],[7,1,1,7,"2026-01-01","2026-01-01","4","Mietzins Januar 2026 \u2013 2.01 Thomas Keller",85,69,1700,"Sollstellung-Schl\u00FCssel: MV4:2026-01:Oe1ed7e51acef4367b8635c4c191f96bc:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,7000,0,0,0,null,1,null],[8,1,1,8,"2026-01-01","2026-01-01","4","NK-Akonto Januar 2026 \u2013 2.01 Thomas Keller",85,20,220,"Sollstellung-Schl\u00FCssel: MV4:2026-01:Oe1ed7e51acef4367b8635c4c191f96bc:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,8000,0,0,0,null,1,null],[9,1,1,9,"2026-01-01","2026-01-01","5","Mietzins Januar 2026 \u2013 2.02 Peter Huber",86,69,1340,"Sollstellung-Schl\u00FCssel: MV5:2026-01:O0207bbb7e119410eb302e0cfbadad93f:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,9000,0,0,0,null,1,null],[10,1,1,10,"2026-01-01","2026-01-01","5","NK-Akonto Januar 2026 \u2013 2.02 Peter Huber",86,20,180,"Sollstellung-Schl\u00FCssel: MV5:2026-01:O0207bbb7e119410eb302e0cfbadad93f:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,10000,0,0,0,null,1,null],[11,1,1,11,"2026-01-01","2026-01-01","6","Mietzins Januar 2026 \u2013 3.01 Sandra Brunner",87,69,2250,"Sollstellung-Schl\u00FCssel: MV6:2026-01:Oa3fb7d17191b4f778b9741b34cbf24d9:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,11000,0,0,0,null,1,null],[12,1,1,12,"2026-01-01","2026-01-01","6","NK-Akonto Januar 2026 \u2013 3.01 Sandra Brunner",87,20,260,"Sollstellung-Schl\u00FCssel: MV6:2026-01:Oa3fb7d17191b4f778b9741b34cbf24d9:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,12000,0,0,0,null,1,null],[13,1,1,13,"2026-01-01","2026-01-01","6","Mietzins Januar 2026 \u2013 P1 Sandra Brunner",87,71,130,"Sollstellung-Schl\u00FCssel: MV6:2026-01:O5fe4c8ab8c0d42138887a70b2b339d19:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,13000,0,0,0,null,1,null],[14,1,1,14,"2026-02-01","2026-02-01","20","Mietzins Februar 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,70,2400,"Sollstellung-Schl\u00FCssel: MV1:2026-02:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,14000,0,0,0,null,1,null],[15,1,1,15,"2026-02-01","2026-02-01","20","NK-Akonto Februar 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,20,300,"Sollstellung-Schl\u00FCssel: MV1:2026-02:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,15000,0,0,0,null,1,null],[16,1,1,16,"2026-02-01","2026-02-01","21","Mietzins Februar 2026 \u2013 1.01 Lukas Meier",83,69,1650,"Sollstellung-Schl\u00FCssel: MV2:2026-02:O17d4f83632894eb5823511a68c46dc81:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,16000,0,0,0,null,1,null],[17,1,1,17,"2026-02-01","2026-02-01","21","NK-Akonto Februar 2026 \u2013 1.01 Lukas Meier",83,20,220,"Sollstellung-Schl\u00FCssel: MV2:2026-02:O17d4f83632894eb5823511a68c46dc81:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,17000,0,0,0,null,1,null],[19,1,1,19,"2026-02-01","2026-02-01","22","NK-Akonto Februar 2026 \u2013 1.02 Fatma Yilmaz",84,20,180,"Sollstellung-Schl\u00FCssel: MV3:2026-02:O5f4497821dcd483f959784e7f5234730:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,19000,0,0,0,null,1,null],[20,1,1,20,"2026-02-01","2026-02-01","23","Mietzins Februar 2026 \u2013 2.01 Thomas Keller",85,69,1700,"Sollstellung-Schl\u00FCssel: MV4:2026-02:Oe1ed7e51acef4367b8635c4c191f96bc:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,20000,0,0,0,null,1,null],[21,1,1,21,"2026-02-01","2026-02-01","23","NK-Akonto Februar 2026 \u2013 2.01 Thomas Keller",85,20,220,"Sollstellung-Schl\u00FCssel: MV4:2026-02:Oe1ed7e51acef4367b8635c4c191f96bc:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,21000,0,0,0,null,1,null],[22,1,1,22,"2026-02-01","2026-02-01","24","Mietzins Februar 2026 \u2013 2.02 Peter Huber",86,69,1340,"Sollstellung-Schl\u00FCssel: MV5:2026-02:O0207bbb7e119410eb302e0cfbadad93f:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,22000,0,0,0,null,1,null],[23,1,1,23,"2026-02-01","2026-02-01","24","NK-Akonto Februar 2026 \u2013 2.02 Peter Huber",86,20,180,"Sollstellung-Schl\u00FCssel: MV5:2026-02:O0207bbb7e119410eb302e0cfbadad93f:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,23000,0,0,0,null,1,null],[24,1,1,24,"2026-02-01","2026-02-01","25","Mietzins Februar 2026 \u2013 3.01 Sandra Brunner",87,69,2250,"Sollstellung-Schl\u00FCssel: MV6:2026-02:Oa3fb7d17191b4f778b9741b34cbf24d9:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,24000,0,0,0,null,1,null],[25,1,1,25,"2026-02-01","2026-02-01","25","NK-Akonto Februar 2026 \u2013 3.01 Sandra Brunner",87,20,260,"Sollstellung-Schl\u00FCssel: MV6:2026-02:Oa3fb7d17191b4f778b9741b34cbf24d9:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,25000,0,0,0,null,1,null],[26,1,1,26,"2026-02-01","2026-02-01","25","Mietzins Februar 2026 \u2013 P1 Sandra Brunner",87,71,130,"Sollstellung-Schl\u00FCssel: MV6:2026-02:O5fe4c8ab8c0d42138887a70b2b339d19:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,26000,0,0,0,null,1,null],[27,1,1,27,"2026-03-01","2026-03-01","33","Mietzins M\u00E4rz 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,70,2400,"Sollstellung-Schl\u00FCssel: MV1:2026-03:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,27000,0,0,0,null,1,null],[28,1,1,28,"2026-03-01","2026-03-01","33","NK-Akonto M\u00E4rz 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,20,300,"Sollstellung-Schl\u00FCssel: MV1:2026-03:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,28000,0,0,0,null,1,null],[29,1,1,29,"2026-03-01","2026-03-01","34","Mietzins M\u00E4rz 2026 \u2013 1.01 Lukas Meier",83,69,1650,"Sollstellung-Schl\u00FCssel: MV2:2026-03:O17d4f83632894eb5823511a68c46dc81:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,29000,0,0,0,null,1,null],[31,1,1,31,"2026-03-01","2026-03-01","35","Mietzins M\u00E4rz 2026 \u2013 1.02 Fatma Yilmaz",84,69,1350,"Sollstellung-Schl\u00FCssel: MV3:2026-03:O5f4497821dcd483f959784e7f5234730:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,31000,0,0,0,null,1,null],[34,1,1,34,"2026-03-01","2026-03-01","36","NK-Akonto M\u00E4rz 2026 \u2013 2.01 Thomas Keller",85,20,220,"Sollstellung-Schl\u00FCssel: MV4:2026-03:Oe1ed7e51acef4367b8635c4c191f96bc:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,34000,0,0,0,null,1,null],[35,1,1,35,"2026-03-01","2026-03-01","37","Mietzins M\u00E4rz 2026 \u2013 2.02 Peter Huber",86,69,1340,"Sollstellung-Schl\u00FCssel: MV5:2026-03:O0207bbb7e119410eb302e0cfbadad93f:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,35000,0,0,0,null,1,null],[38,1,1,38,"2026-03-01","2026-03-01","38","NK-Akonto M\u00E4rz 2026 \u2013 3.01 Sandra Brunner",87,20,260,"Sollstellung-Schl\u00FCssel: MV6:2026-03:Oa3fb7d17191b4f778b9741b34cbf24d9:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,38000,0,0,0,null,1,null],[43,1,1,43,"2026-04-01","2026-04-01","47","NK-Akonto April 2026 \u2013 1.01 Lukas Meier",83,20,220,"Sollstellung-Schl\u00FCssel: MV2:2026-04:O17d4f83632894eb5823511a68c46dc81:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,43000,0,0,0,null,1,null],[44,1,1,44,"2026-04-01","2026-04-01","48","Mietzins April 2026 \u2013 1.02 Fatma Yilmaz",84,69,1350,"Sollstellung-Schl\u00FCssel: MV3:2026-04:O5f4497821dcd483f959784e7f5234730:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,44000,0,0,0,null,1,null],[47,1,1,47,"2026-04-01","2026-04-01","49","NK-Akonto April 2026 \u2013 2.01 Thomas Keller",85,20,220,"Sollstellung-Schl\u00FCssel: MV4:2026-04:Oe1ed7e51acef4367b8635c4c191f96bc:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,47000,0,0,0,null,1,null],[48,1,1,48,"2026-04-01","2026-04-01","50","Mietzins April 2026 \u2013 2.02 Peter Huber",86,69,1340,"Sollstellung-Schl\u00FCssel: MV5:2026-04:O0207bbb7e119410eb302e0cfbadad93f:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,48000,0,0,0,null,1,null],[51,1,1,51,"2026-04-01","2026-04-01","51","NK-Akonto April 2026 \u2013 3.01 Sandra Brunner",87,20,260,"Sollstellung-Schl\u00FCssel: MV6:2026-04:Oa3fb7d17191b4f778b9741b34cbf24d9:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,51000,0,0,0,null,1,null],[54,1,1,54,"2026-05-01","2026-05-01","58","NK-Akonto Mai 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,20,300,"Sollstellung-Schl\u00FCssel: MV1:2026-05:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,54000,0,0,0,null,1,null],[55,1,1,55,"2026-05-01","2026-05-01","59","Mietzins Mai 2026 \u2013 1.01 Lukas Meier",83,69,1650,"Sollstellung-Schl\u00FCssel: MV2:2026-05:O17d4f83632894eb5823511a68c46dc81:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,55000,0,0,0,null,1,null],[58,1,1,58,"2026-05-01","2026-05-01","60","NK-Akonto Mai 2026 \u2013 1.02 Fatma Yilmaz",84,20,180,"Sollstellung-Schl\u00FCssel: MV3:2026-05:O5f4497821dcd483f959784e7f5234730:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,58000,0,0,0,null,1,null],[59,1,1,59,"2026-05-01","2026-05-01","61","Mietzins Mai 2026 \u2013 2.01 Thomas Keller",85,69,1700,"Sollstellung-Schl\u00FCssel: MV4:2026-05:Oe1ed7e51acef4367b8635c4c191f96bc:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,59000,0,0,0,null,1,null],[62,1,1,62,"2026-05-01","2026-05-01","62","NK-Akonto Mai 2026 \u2013 2.02 Peter Huber",86,20,180,"Sollstellung-Schl\u00FCssel: MV5:2026-05:O0207bbb7e119410eb302e0cfbadad93f:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,62000,0,0,0,null,1,null],[63,1,1,63,"2026-05-01","2026-05-01","63","Mietzins Mai 2026 \u2013 3.01 Sandra Brunner",87,69,2250,"Sollstellung-Schl\u00FCssel: MV6:2026-05:Oa3fb7d17191b4f778b9741b34cbf24d9:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,63000,0,0,0,null,1,null],[65,1,1,65,"2026-05-01","2026-05-01","63","Mietzins Mai 2026 \u2013 P1 Sandra Brunner",87,71,130,"Sollstellung-Schl\u00FCssel: MV6:2026-05:O5fe4c8ab8c0d42138887a70b2b339d19:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,65000,0,0,0,null,1,null],[67,1,1,67,"2026-06-01","2026-06-01","71","NK-Akonto Juni 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,20,300,"Sollstellung-Schl\u00FCssel: MV1:2026-06:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,67000,0,0,0,null,1,null],[68,1,1,68,"2026-06-01","2026-06-01","72","Mietzins Juni 2026 \u2013 1.01 Lukas Meier",83,69,1650,"Sollstellung-Schl\u00FCssel: MV2:2026-06:O17d4f83632894eb5823511a68c46dc81:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,68000,0,0,0,null,1,null],[71,1,1,71,"2026-06-01","2026-06-01","73","NK-Akonto Juni 2026 \u2013 1.02 Fatma Yilmaz",84,20,180,"Sollstellung-Schl\u00FCssel: MV3:2026-06:O5f4497821dcd483f959784e7f5234730:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,71000,0,0,0,null,1,null],[75,1,1,75,"2026-06-01","2026-06-01","75","NK-Akonto Juni 2026 \u2013 2.02 Peter Huber",86,20,180,"Sollstellung-Schl\u00FCssel: MV5:2026-06:O0207bbb7e119410eb302e0cfbadad93f:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,75000,0,0,0,null,1,null],[76,1,1,76,"2026-06-01","2026-06-01","76","Mietzins Juni 2026 \u2013 3.01 Sandra Brunner",87,69,2250,"Sollstellung-Schl\u00FCssel: MV6:2026-06:Oa3fb7d17191b4f778b9741b34cbf24d9:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,76000,0,0,0,null,1,null],[78,1,1,78,"2026-06-01","2026-06-01","76","Mietzins Juni 2026 \u2013 P1 Sandra Brunner",87,71,130,"Sollstellung-Schl\u00FCssel: MV6:2026-06:O5fe4c8ab8c0d42138887a70b2b339d19:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,78000,0,0,0,null,1,null],[80,1,1,80,"2026-07-01","2026-07-01","83","NK-Akonto Juli 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,20,300,"Sollstellung-Schl\u00FCssel: MV1:2026-07:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,80000,0,0,0,null,1,null],[81,1,1,81,"2026-07-01","2026-07-01","84","Mietzins Juli 2026 \u2013 1.01 Lukas Meier",83,69,1650,"Sollstellung-Schl\u00FCssel: MV2:2026-07:O17d4f83632894eb5823511a68c46dc81:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,81000,0,0,0,null,1,null],[84,1,1,84,"2026-07-01","2026-07-01","85","NK-Akonto Juli 2026 \u2013 1.02 Fatma Yilmaz",84,20,180,"Sollstellung-Schl\u00FCssel: MV3:2026-07:O5f4497821dcd483f959784e7f5234730:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,84000,0,0,0,null,1,null],[85,1,1,85,"2026-07-01","2026-07-01","86","Mietzins Juli 2026 \u2013 2.01 Thomas Keller",85,69,1700,"Sollstellung-Schl\u00FCssel: MV4:2026-07:Oe1ed7e51acef4367b8635c4c191f96bc:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,85000,0,0,0,null,1,null],[33,1,1,33,"2026-03-01","2026-03-01","36","Mietzins M\u00E4rz 2026 \u2013 2.01 Thomas Keller",85,69,1700,"Sollstellung-Schl\u00FCssel: MV4:2026-03:Oe1ed7e51acef4367b8635c4c191f96bc:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,33000,0,0,0,null,1,null],[36,1,1,36,"2026-03-01","2026-03-01","37","NK-Akonto M\u00E4rz 2026 \u2013 2.02 Peter Huber",86,20,180,"Sollstellung-Schl\u00FCssel: MV5:2026-03:O0207bbb7e119410eb302e0cfbadad93f:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,36000,0,0,0,null,1,null],[37,1,1,37,"2026-03-01","2026-03-01","38","Mietzins M\u00E4rz 2026 \u2013 3.01 Sandra Brunner",87,69,2250,"Sollstellung-Schl\u00FCssel: MV6:2026-03:Oa3fb7d17191b4f778b9741b34cbf24d9:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,37000,0,0,0,null,1,null],[39,1,1,39,"2026-03-01","2026-03-01","38","Mietzins M\u00E4rz 2026 \u2013 P1 Sandra Brunner",87,71,130,"Sollstellung-Schl\u00FCssel: MV6:2026-03:O5fe4c8ab8c0d42138887a70b2b339d19:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,39000,0,0,0,null,1,null],[41,1,1,41,"2026-04-01","2026-04-01","46","NK-Akonto April 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,20,300,"Sollstellung-Schl\u00FCssel: MV1:2026-04:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,41000,0,0,0,null,1,null],[45,1,1,45,"2026-04-01","2026-04-01","48","NK-Akonto April 2026 \u2013 1.02 Fatma Yilmaz",84,20,180,"Sollstellung-Schl\u00FCssel: MV3:2026-04:O5f4497821dcd483f959784e7f5234730:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,45000,0,0,0,null,1,null],[46,1,1,46,"2026-04-01","2026-04-01","49","Mietzins April 2026 \u2013 2.01 Thomas Keller",85,69,1700,"Sollstellung-Schl\u00FCssel: MV4:2026-04:Oe1ed7e51acef4367b8635c4c191f96bc:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,46000,0,0,0,null,1,null],[49,1,1,49,"2026-04-01","2026-04-01","50","NK-Akonto April 2026 \u2013 2.02 Peter Huber",86,20,180,"Sollstellung-Schl\u00FCssel: MV5:2026-04:O0207bbb7e119410eb302e0cfbadad93f:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,49000,0,0,0,null,1,null],[50,1,1,50,"2026-04-01","2026-04-01","51","Mietzins April 2026 \u2013 3.01 Sandra Brunner",87,69,2250,"Sollstellung-Schl\u00FCssel: MV6:2026-04:Oa3fb7d17191b4f778b9741b34cbf24d9:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,50000,0,0,0,null,1,null],[52,1,1,52,"2026-04-01","2026-04-01","51","Mietzins April 2026 \u2013 P1 Sandra Brunner",87,71,130,"Sollstellung-Schl\u00FCssel: MV6:2026-04:O5fe4c8ab8c0d42138887a70b2b339d19:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,52000,0,0,0,null,1,null],[53,1,1,53,"2026-05-01","2026-05-01","58","Mietzins Mai 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,70,2400,"Sollstellung-Schl\u00FCssel: MV1:2026-05:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,53000,0,0,0,null,1,null],[56,1,1,56,"2026-05-01","2026-05-01","59","NK-Akonto Mai 2026 \u2013 1.01 Lukas Meier",83,20,220,"Sollstellung-Schl\u00FCssel: MV2:2026-05:O17d4f83632894eb5823511a68c46dc81:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,56000,0,0,0,null,1,null],[57,1,1,57,"2026-05-01","2026-05-01","60","Mietzins Mai 2026 \u2013 1.02 Fatma Yilmaz",84,69,1350,"Sollstellung-Schl\u00FCssel: MV3:2026-05:O5f4497821dcd483f959784e7f5234730:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,57000,0,0,0,null,1,null],[60,1,1,60,"2026-05-01","2026-05-01","61","NK-Akonto Mai 2026 \u2013 2.01 Thomas Keller",85,20,220,"Sollstellung-Schl\u00FCssel: MV4:2026-05:Oe1ed7e51acef4367b8635c4c191f96bc:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,60000,0,0,0,null,1,null],[61,1,1,61,"2026-05-01","2026-05-01","62","Mietzins Mai 2026 \u2013 2.02 Peter Huber",86,69,1340,"Sollstellung-Schl\u00FCssel: MV5:2026-05:O0207bbb7e119410eb302e0cfbadad93f:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,61000,0,0,0,null,1,null],[64,1,1,64,"2026-05-01","2026-05-01","63","NK-Akonto Mai 2026 \u2013 3.01 Sandra Brunner",87,20,260,"Sollstellung-Schl\u00FCssel: MV6:2026-05:Oa3fb7d17191b4f778b9741b34cbf24d9:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,64000,0,0,0,null,1,null],[66,1,1,66,"2026-06-01","2026-06-01","71","Mietzins Juni 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,70,2400,"Sollstellung-Schl\u00FCssel: MV1:2026-06:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,66000,0,0,0,null,1,null],[69,1,1,69,"2026-06-01","2026-06-01","72","NK-Akonto Juni 2026 \u2013 1.01 Lukas Meier",83,20,220,"Sollstellung-Schl\u00FCssel: MV2:2026-06:O17d4f83632894eb5823511a68c46dc81:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,69000,0,0,0,null,1,null],[70,1,1,70,"2026-06-01","2026-06-01","73","Mietzins Juni 2026 \u2013 1.02 Fatma Yilmaz",84,69,1350,"Sollstellung-Schl\u00FCssel: MV3:2026-06:O5f4497821dcd483f959784e7f5234730:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,70000,0,0,0,null,1,null],[74,1,1,74,"2026-06-01","2026-06-01","75","Mietzins Juni 2026 \u2013 2.02 Peter Huber",86,69,1340,"Sollstellung-Schl\u00FCssel: MV5:2026-06:O0207bbb7e119410eb302e0cfbadad93f:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,74000,0,0,0,null,1,null],[77,1,1,77,"2026-06-01","2026-06-01","76","NK-Akonto Juni 2026 \u2013 3.01 Sandra Brunner",87,20,260,"Sollstellung-Schl\u00FCssel: MV6:2026-06:Oa3fb7d17191b4f778b9741b34cbf24d9:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,77000,0,0,0,null,1,null],[79,1,1,79,"2026-07-01","2026-07-01","83","Mietzins Juli 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,70,2400,"Sollstellung-Schl\u00FCssel: MV1:2026-07:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,79000,0,0,0,null,1,null],[82,1,1,82,"2026-07-01","2026-07-01","84","NK-Akonto Juli 2026 \u2013 1.01 Lukas Meier",83,20,220,"Sollstellung-Schl\u00FCssel: MV2:2026-07:O17d4f83632894eb5823511a68c46dc81:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,82000,0,0,0,null,1,null],[83,1,1,83,"2026-07-01","2026-07-01","85","Mietzins Juli 2026 \u2013 1.02 Fatma Yilmaz",84,69,1350,"Sollstellung-Schl\u00FCssel: MV3:2026-07:O5f4497821dcd483f959784e7f5234730:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,83000,0,0,0,null,1,null],[86,1,1,86,"2026-07-01","2026-07-01","86","NK-Akonto Juli 2026 \u2013 2.01 Thomas Keller",85,20,220,"Sollstellung-Schl\u00FCssel: MV4:2026-07:Oe1ed7e51acef4367b8635c4c191f96bc:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,86000,0,0,0,null,1,null],[87,1,1,87,"2026-07-01","2026-07-01","87","Mietzins Juli 2026 \u2013 3.01 Sandra Brunner",87,69,2250,"Sollstellung-Schl\u00FCssel: MV6:2026-07:Oa3fb7d17191b4f778b9741b34cbf24d9:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,87000,0,0,0,null,1,null],[149,1,1,149,"2026-01-02","2026-01-01","10","Zahlung Miete 01.2026",4,87,2640,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:29",null,0,149000,0,0,0,null,1,null],[134,1,1,134,"2026-01-29","2026-02-01","15","Zahlung Miete 02.2026",4,82,2700,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:29",null,0,134000,0,0,0,null,1,null],[150,1,1,150,"2026-01-29","2026-02-01","17","Zahlung Miete 02.2026",4,87,2640,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,150000,0,0,0,null,1,null],[135,1,1,135,"2026-02-26","2026-03-01","28","Zahlung Miete 03.2026",4,82,2700,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,135000,0,0,0,null,1,null],[136,1,1,136,"2026-03-29","2026-04-01","40","Zahlung Miete 04.2026",4,82,2700,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,136000,0,0,0,null,1,null],[152,1,1,152,"2026-03-29","2026-04-01","42","Zahlung Miete 04.2026",4,87,2640,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,152000,0,0,0,null,1,null],[137,1,1,137,"2026-04-28","2026-05-01","53","Zahlung Miete 05.2026",4,82,2700,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,137000,0,0,0,null,1,null],[153,1,1,153,"2026-04-28","2026-05-01","55","Zahlung Miete 05.2026",4,87,2640,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,153000,0,0,0,null,1,null],[138,1,1,138,"2026-05-29","2026-06-01","66","Zahlung Miete 06.2026",4,82,2700,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,138000,0,0,0,null,1,null],[154,1,1,154,"2026-05-29","2026-06-01","68","Zahlung Miete 06.2026",4,87,2640,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,154000,0,0,0,null,1,null],[155,1,1,155,"2026-06-28","2026-07-01","79","Zahlung Miete 07.2026",4,87,2640,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,155000,0,0,0,null,1,null],[88,1,1,88,"2026-07-01","2026-07-01","87","NK-Akonto Juli 2026 \u2013 3.01 Sandra Brunner",87,20,260,"Sollstellung-Schl\u00FCssel: MV6:2026-07:Oa3fb7d17191b4f778b9741b34cbf24d9:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,88000,0,0,0,null,1,null],[140,1,1,140,"2026-07-29","2026-08-01","90","Zahlung Miete 08.2026",4,82,2700,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,140000,0,0,0,null,1,null],[92,1,1,92,"2026-08-01","2026-08-01","95","Mietzins August 2026 \u2013 1.01 Lukas Meier",83,69,1650,"Sollstellung-Schl\u00FCssel: MV2:2026-08:O17d4f83632894eb5823511a68c46dc81:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,92000,0,0,0,null,1,null],[95,1,1,95,"2026-08-01","2026-08-01","96","NK-Akonto August 2026 \u2013 1.02 Fatma Yilmaz",84,20,180,"Sollstellung-Schl\u00FCssel: MV3:2026-08:O5f4497821dcd483f959784e7f5234730:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,95000,0,0,0,null,1,null],[96,1,1,96,"2026-08-01","2026-08-01","97","Mietzins August 2026 \u2013 2.01 Thomas Keller",85,69,1700,"Sollstellung-Schl\u00FCssel: MV4:2026-08:Oe1ed7e51acef4367b8635c4c191f96bc:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,96000,0,0,0,null,1,null],[99,1,1,99,"2026-08-01","2026-08-01","98","NK-Akonto August 2026 \u2013 3.01 Sandra Brunner",87,20,260,"Sollstellung-Schl\u00FCssel: MV6:2026-08:Oa3fb7d17191b4f778b9741b34cbf24d9:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,99000,0,0,0,null,1,null],[141,1,1,141,"2026-08-29","2026-09-01","100","Zahlung Miete 09.2026",4,82,2700,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,141000,0,0,0,null,1,null],[101,1,1,101,"2026-09-01","2026-09-01","103","Mietzins September 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,70,2400,"Sollstellung-Schl\u00FCssel: MV1:2026-09:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,101000,0,0,0,null,1,null],[104,1,1,104,"2026-09-01","2026-09-01","104","NK-Akonto September 2026 \u2013 1.01 Lukas Meier",83,20,220,"Sollstellung-Schl\u00FCssel: MV2:2026-09:O17d4f83632894eb5823511a68c46dc81:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,104000,0,0,0,null,1,null],[105,1,1,105,"2026-09-01","2026-09-01","105","Mietzins September 2026 \u2013 1.02 Fatma Yilmaz",84,69,1350,"Sollstellung-Schl\u00FCssel: MV3:2026-09:O5f4497821dcd483f959784e7f5234730:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,105000,0,0,0,null,1,null],[108,1,1,108,"2026-09-01","2026-09-01","106","NK-Akonto September 2026 \u2013 2.01 Thomas Keller",85,20,220,"Sollstellung-Schl\u00FCssel: MV4:2026-09:Oe1ed7e51acef4367b8635c4c191f96bc:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,108000,0,0,0,null,1,null],[109,1,1,109,"2026-09-01","2026-09-01","107","Mietzins September 2026 \u2013 3.01 Sandra Brunner",87,69,2250,"Sollstellung-Schl\u00FCssel: MV6:2026-09:Oa3fb7d17191b4f778b9741b34cbf24d9:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,109000,0,0,0,null,1,null],[111,1,1,111,"2026-09-01","2026-09-01","107","Mietzins September 2026 \u2013 P1 Sandra Brunner",87,71,130,"Sollstellung-Schl\u00FCssel: MV6:2026-09:O5fe4c8ab8c0d42138887a70b2b339d19:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,111000,0,0,0,null,1,null],[142,1,1,142,"2026-09-28","2026-10-01","110","Zahlung Miete 10.2026",4,82,2700,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,142000,0,0,0,null,1,null],[115,1,1,115,"2026-10-01","2026-10-01","113","NK-Akonto Oktober 2026 \u2013 1.01 Lukas Meier",83,20,220,"Sollstellung-Schl\u00FCssel: MV2:2026-10:O17d4f83632894eb5823511a68c46dc81:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,115000,0,0,0,null,1,null],[116,1,1,116,"2026-10-01","2026-10-01","114","Mietzins Oktober 2026 \u2013 1.02 Fatma Yilmaz",84,69,1350,"Sollstellung-Schl\u00FCssel: MV3:2026-10:O5f4497821dcd483f959784e7f5234730:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,116000,0,0,0,null,1,null],[119,1,1,119,"2026-10-01","2026-10-01","115","NK-Akonto Oktober 2026 \u2013 2.01 Thomas Keller",85,20,220,"Sollstellung-Schl\u00FCssel: MV4:2026-10:Oe1ed7e51acef4367b8635c4c191f96bc:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,119000,0,0,0,null,1,null],[120,1,1,120,"2026-10-01","2026-10-01","116","Mietzins Oktober 2026 \u2013 3.01 Sandra Brunner",87,69,2250,"Sollstellung-Schl\u00FCssel: MV6:2026-10:Oa3fb7d17191b4f778b9741b34cbf24d9:Mietzins",0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,120000,0,0,0,null,1,null],[122,1,1,122,"2026-10-01","2026-10-01","116","Mietzins Oktober 2026 \u2013 P1 Sandra Brunner",87,71,130,"Sollstellung-Schl\u00FCssel: MV6:2026-10:O5fe4c8ab8c0d42138887a70b2b339d19:Mietzins",0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,122000,0,0,0,null,1,null],[143,1,1,143,"2026-01-02","2026-01-01","9","Zahlung Miete 01.2026",4,86,1520,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:29",null,0,143000,0,0,0,null,1,null],[158,1,1,158,"2026-01-02","2026-01-01","11","Zahlung Miete 01.2026",4,84,1530,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:29",null,0,158000,0,0,0,null,1,null],[124,1,1,124,"2026-01-29","2026-02-01","14","Zahlung Miete 02.2026",4,83,1870,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:29",null,0,124000,0,0,0,null,1,null],[159,1,1,159,"2026-01-29","2026-02-01","18","Zahlung Miete 02.2026",4,84,1530,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,159000,0,0,0,null,1,null],[125,1,1,125,"2026-02-26","2026-03-01","27","Zahlung Miete 03.2026",4,83,1870,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,125000,0,0,0,null,1,null],[145,1,1,145,"2026-02-26","2026-03-01","29","Zahlung Miete 03.2026",4,86,1520,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,145000,0,0,0,null,1,null],[160,1,1,160,"2026-02-26","2026-03-01","31","Zahlung Miete 03.2026",4,84,1530,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,160000,0,0,0,null,1,null],[126,1,1,126,"2026-03-29","2026-04-01","39","Zahlung Miete 04.2026",4,83,1870,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,126000,0,0,0,null,1,null],[146,1,1,146,"2026-03-29","2026-04-01","41","Zahlung Miete 04.2026",4,86,1520,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,146000,0,0,0,null,1,null],[147,1,1,147,"2026-04-28","2026-05-01","54","Zahlung Miete 05.2026",4,86,1520,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,147000,0,0,0,null,1,null],[128,1,1,128,"2026-05-29","2026-06-01","65","Zahlung Miete 06.2026",4,83,1870,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,128000,0,0,0,null,1,null],[148,1,1,148,"2026-05-29","2026-06-01","67","Zahlung Miete 06.2026",4,86,1520,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,148000,0,0,0,null,1,null],[129,1,1,129,"2026-06-28","2026-07-01","77","Zahlung Miete 07.2026",4,83,1870,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,129000,0,0,0,null,1,null],[130,1,1,130,"2026-07-29","2026-08-01","89","Zahlung Miete 08.2026",4,83,1870,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,130000,0,0,0,null,1,null],[90,1,1,90,"2026-08-01","2026-08-01","94","Mietzins August 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,70,2400,"Sollstellung-Schl\u00FCssel: MV1:2026-08:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,90000,0,0,0,null,1,null],[93,1,1,93,"2026-08-01","2026-08-01","95","NK-Akonto August 2026 \u2013 1.01 Lukas Meier",83,20,220,"Sollstellung-Schl\u00FCssel: MV2:2026-08:O17d4f83632894eb5823511a68c46dc81:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,93000,0,0,0,null,1,null],[94,1,1,94,"2026-08-01","2026-08-01","96","Mietzins August 2026 \u2013 1.02 Fatma Yilmaz",84,69,1350,"Sollstellung-Schl\u00FCssel: MV3:2026-08:O5f4497821dcd483f959784e7f5234730:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,94000,0,0,0,null,1,null],[97,1,1,97,"2026-08-01","2026-08-01","97","NK-Akonto August 2026 \u2013 2.01 Thomas Keller",85,20,220,"Sollstellung-Schl\u00FCssel: MV4:2026-08:Oe1ed7e51acef4367b8635c4c191f96bc:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,97000,0,0,0,null,1,null],[98,1,1,98,"2026-08-01","2026-08-01","98","Mietzins August 2026 \u2013 3.01 Sandra Brunner",87,69,2250,"Sollstellung-Schl\u00FCssel: MV6:2026-08:Oa3fb7d17191b4f778b9741b34cbf24d9:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,98000,0,0,0,null,1,null],[100,1,1,100,"2026-08-01","2026-08-01","98","Mietzins August 2026 \u2013 P1 Sandra Brunner",87,71,130,"Sollstellung-Schl\u00FCssel: MV6:2026-08:O5fe4c8ab8c0d42138887a70b2b339d19:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,100000,0,0,0,null,1,null],[131,1,1,131,"2026-08-29","2026-09-01","99","Zahlung Miete 09.2026",4,83,1870,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,131000,0,0,0,null,1,null],[102,1,1,102,"2026-09-01","2026-09-01","103","NK-Akonto September 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,20,300,"Sollstellung-Schl\u00FCssel: MV1:2026-09:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,102000,0,0,0,null,1,null],[103,1,1,103,"2026-09-01","2026-09-01","104","Mietzins September 2026 \u2013 1.01 Lukas Meier",83,69,1650,"Sollstellung-Schl\u00FCssel: MV2:2026-09:O17d4f83632894eb5823511a68c46dc81:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,103000,0,0,0,null,1,null],[107,1,1,107,"2026-09-01","2026-09-01","106","Mietzins September 2026 \u2013 2.01 Thomas Keller",85,69,1700,"Sollstellung-Schl\u00FCssel: MV4:2026-09:Oe1ed7e51acef4367b8635c4c191f96bc:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,107000,0,0,0,null,1,null],[110,1,1,110,"2026-09-01","2026-09-01","107","NK-Akonto September 2026 \u2013 3.01 Sandra Brunner",87,20,260,"Sollstellung-Schl\u00FCssel: MV6:2026-09:Oa3fb7d17191b4f778b9741b34cbf24d9:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,110000,0,0,0,null,1,null],[132,1,1,132,"2026-09-28","2026-10-01","109","Zahlung Miete 10.2026",4,83,1870,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,132000,0,0,0,null,1,null],[113,1,1,113,"2026-10-01","2026-10-01","112","NK-Akonto Oktober 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,20,300,"Sollstellung-Schl\u00FCssel: MV1:2026-10:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,113000,0,0,0,null,1,null],[114,1,1,114,"2026-10-01","2026-10-01","113","Mietzins Oktober 2026 \u2013 1.01 Lukas Meier",83,69,1650,"Sollstellung-Schl\u00FCssel: MV2:2026-10:O17d4f83632894eb5823511a68c46dc81:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,114000,0,0,0,null,1,null],[117,1,1,117,"2026-10-01","2026-10-01","114","NK-Akonto Oktober 2026 \u2013 1.02 Fatma Yilmaz",84,20,180,"Sollstellung-Schl\u00FCssel: MV3:2026-10:O5f4497821dcd483f959784e7f5234730:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,117000,0,0,0,null,1,null],[118,1,1,118,"2026-10-01","2026-10-01","115","Mietzins Oktober 2026 \u2013 2.01 Thomas Keller",85,69,1700,"Sollstellung-Schl\u00FCssel: MV4:2026-10:Oe1ed7e51acef4367b8635c4c191f96bc:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,118000,0,0,0,null,1,null],[121,1,1,121,"2026-10-01","2026-10-01","116","NK-Akonto Oktober 2026 \u2013 3.01 Sandra Brunner",87,20,260,"Sollstellung-Schl\u00FCssel: MV6:2026-10:Oa3fb7d17191b4f778b9741b34cbf24d9:NK-Akonto",0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,121000,0,0,0,null,1,null],[166,1,1,166,"2026-01-02","2026-01-01","12","Zahlung Miete 01.2026",4,85,1920,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:29",null,0,166000,0,0,0,null,1,null],[181,1,1,181,"2026-01-20","2026-01-20","13","Geb\u00E4udeversicherung 2026",48,4,2380,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:29",null,0,181000,0,0,0,null,1,null],[167,1,1,167,"2026-01-29","2026-02-01","19","Zahlung Miete 02.2026",4,85,1920,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,167000,0,0,0,null,1,null],[175,1,1,175,"2026-02-12","2026-02-12","26","Heiz\u00F6l Lieferung 6\u0027000 l",55,4,6840,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,175000,0,0,0,null,1,null],[168,1,1,168,"2026-02-26","2026-03-01","32","Zahlung Miete 03.2026",4,85,1920,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,168000,0,0,0,null,1,null],[169,1,1,169,"2026-03-29","2026-04-01","44","Zahlung Miete 04.2026",4,85,1920,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,169000,0,0,0,null,1,null],[177,1,1,177,"2026-03-31","2026-03-31","45","Hauswartung Q1",37,4,1200,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,177000,0,0,0,null,1,null],[170,1,1,170,"2026-04-28","2026-05-01","57","Zahlung Miete 05.2026",4,85,1920,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,170000,0,0,0,null,1,null],[180,1,1,180,"2026-05-15","2026-05-15","64","Wasser/Abwasser 1. Halbjahr",57,4,1460,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,180000,0,0,0,null,1,null],[171,1,1,171,"2026-05-29","2026-06-01","70","Zahlung Miete 06.2026",4,85,1920,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,171000,0,0,0,null,1,null],[172,1,1,172,"2026-06-28","2026-07-01","81","Zahlung Miete 07.2026",4,85,1920,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,172000,0,0,0,null,1,null],[178,1,1,178,"2026-06-30","2026-06-30","82","Hauswartung Q2",37,4,1200,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,178000,0,0,0,null,1,null],[182,1,1,182,"2026-07-08","2026-07-08","88","Reparatur Storen 2.02 (Mieterwechsel)",46,4,640,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,182000,0,0,0,null,1,null],[156,1,1,156,"2026-07-29","2026-08-01","91","Zahlung Miete 08.2026",4,87,2640,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,156000,0,0,0,null,1,null],[173,1,1,173,"2026-07-29","2026-08-01","93","Zahlung Miete 08.2026",4,85,1920,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,173000,0,0,0,null,1,null],[157,1,1,157,"2026-08-29","2026-09-01","101","Zahlung Miete 09.2026",4,87,2640,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,157000,0,0,0,null,1,null],[174,1,1,174,"2026-08-29","2026-09-01","102","Zahlung Miete 09.2026",4,85,1920,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,174000,0,0,0,null,1,null],[176,1,1,176,"2026-09-24","2026-09-24","108","Heiz\u00F6l Lieferung 3\u0027000 l",55,4,3510,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,176000,0,0,0,null,1,null],[179,1,1,179,"2026-09-30","2026-09-30","111","Hauswartung Q3",37,4,1200,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,179000,0,0,0,null,1,null],[1,1,1,1,"2026-01-01","2026-01-01","1","Mietzins Januar 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,70,2400,"Sollstellung-Schl\u00FCssel: MV1:2026-01:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,1000,0,0,0,null,1,null],[4,1,1,4,"2026-01-01","2026-01-01","2","NK-Akonto Januar 2026 \u2013 1.01 Lukas Meier",83,20,220,"Sollstellung-Schl\u00FCssel: MV2:2026-01:O17d4f83632894eb5823511a68c46dc81:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:29",null,0,4000,0,0,0,null,1,null],[123,1,1,123,"2026-01-02","2026-01-01","7","Zahlung Miete 01.2026",4,83,1870,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:29",null,0,123000,0,0,0,null,1,null],[133,1,1,133,"2026-01-02","2026-01-01","8","Zahlung Miete 01.2026",4,82,2700,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:29",null,0,133000,0,0,0,null,1,null],[144,1,1,144,"2026-01-29","2026-02-01","16","Zahlung Miete 02.2026",4,86,1520,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:29",null,0,144000,0,0,0,null,1,null],[18,1,1,18,"2026-02-01","2026-02-01","22","Mietzins Februar 2026 \u2013 1.02 Fatma Yilmaz",84,69,1350,"Sollstellung-Schl\u00FCssel: MV3:2026-02:O5f4497821dcd483f959784e7f5234730:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,18000,0,0,0,null,1,null],[151,1,1,151,"2026-02-26","2026-03-01","30","Zahlung Miete 03.2026",4,87,2640,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,151000,0,0,0,null,1,null],[30,1,1,30,"2026-03-01","2026-03-01","34","NK-Akonto M\u00E4rz 2026 \u2013 1.01 Lukas Meier",83,20,220,"Sollstellung-Schl\u00FCssel: MV2:2026-03:O17d4f83632894eb5823511a68c46dc81:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,30000,0,0,0,null,1,null],[32,1,1,32,"2026-03-01","2026-03-01","35","NK-Akonto M\u00E4rz 2026 \u2013 1.02 Fatma Yilmaz",84,20,180,"Sollstellung-Schl\u00FCssel: MV3:2026-03:O5f4497821dcd483f959784e7f5234730:NK-Akonto",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,32000,0,0,0,null,1,null],[161,1,1,161,"2026-03-29","2026-04-01","43","Zahlung Miete 04.2026",4,84,1530,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,161000,0,0,0,null,1,null],[40,1,1,40,"2026-04-01","2026-04-01","46","Mietzins April 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,70,2400,"Sollstellung-Schl\u00FCssel: MV1:2026-04:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,40000,0,0,0,null,1,null],[42,1,1,42,"2026-04-01","2026-04-01","47","Mietzins April 2026 \u2013 1.01 Lukas Meier",83,69,1650,"Sollstellung-Schl\u00FCssel: MV2:2026-04:O17d4f83632894eb5823511a68c46dc81:Mietzins",0,"2026-10-07 15:14:27","2026-10-07 15:14:30",null,0,42000,0,0,0,null,1,null],[127,1,1,127,"2026-04-28","2026-05-01","52","Zahlung Miete 05.2026",4,83,1870,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,127000,0,0,0,null,1,null],[162,1,1,162,"2026-04-28","2026-05-01","56","Zahlung Miete 05.2026",4,84,1530,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,162000,0,0,0,null,1,null],[163,1,1,163,"2026-05-29","2026-06-01","69","Zahlung Miete 06.2026",4,84,1530,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:30",null,0,163000,0,0,0,null,1,null],[72,1,1,72,"2026-06-01","2026-06-01","74","Mietzins Juni 2026 \u2013 2.01 Thomas Keller",85,69,1700,"Sollstellung-Schl\u00FCssel: MV4:2026-06:Oe1ed7e51acef4367b8635c4c191f96bc:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,72000,0,0,0,null,1,null],[73,1,1,73,"2026-06-01","2026-06-01","74","NK-Akonto Juni 2026 \u2013 2.01 Thomas Keller",85,20,220,"Sollstellung-Schl\u00FCssel: MV4:2026-06:Oe1ed7e51acef4367b8635c4c191f96bc:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:30",null,0,73000,0,0,0,null,1,null],[139,1,1,139,"2026-06-28","2026-07-01","78","Zahlung Miete 07.2026",4,82,2700,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,139000,0,0,0,null,1,null],[164,1,1,164,"2026-06-28","2026-07-01","80","Zahlung Miete 07.2026",4,84,1530,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,164000,0,0,0,null,1,null],[89,1,1,89,"2026-07-01","2026-07-01","87","Mietzins Juli 2026 \u2013 P1 Sandra Brunner",87,71,130,"Sollstellung-Schl\u00FCssel: MV6:2026-07:O5fe4c8ab8c0d42138887a70b2b339d19:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,89000,0,0,0,null,1,null],[165,1,1,165,"2026-07-29","2026-08-01","92","Zahlung Miete 08.2026",4,84,1530,null,0,"2026-10-07 15:14:29","2026-10-07 15:14:31",null,0,165000,0,0,0,null,1,null],[91,1,1,91,"2026-08-01","2026-08-01","94","NK-Akonto August 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,20,300,"Sollstellung-Schl\u00FCssel: MV1:2026-08:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,91000,0,0,0,null,1,null],[106,1,1,106,"2026-09-01","2026-09-01","105","NK-Akonto September 2026 \u2013 1.02 Fatma Yilmaz",84,20,180,"Sollstellung-Schl\u00FCssel: MV3:2026-09:O5f4497821dcd483f959784e7f5234730:NK-Akonto",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,106000,0,0,0,null,1,null],[112,1,1,112,"2026-10-01","2026-10-01","112","Mietzins Oktober 2026 \u2013 0.01 B\u00E4ckerei Frei GmbH",82,70,2400,"Sollstellung-Schl\u00FCssel: MV1:2026-10:Odb4be2cd6f3b4fb8a7ecea4fc57dcc91:Mietzins",0,"2026-10-07 15:14:28","2026-10-07 15:14:31",null,0,112000,0,0,0,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":[]},"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",100,"Fl\u00FCssige Mittel","100","",null,null,10,0,"",10,"","",1,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[3,1,2,"account",1000,"Kasse","1000","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[4,1,2,"account",1020,"Bank Mietzinskonto","1020","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[5,1,1,"group",109,"Transferkonto","109","",null,null,10,0,"",10,"","",1,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[6,1,5,"account",1099,"Abrechnungskonto Nebenkosten","1099","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[7,1,1,"group",110,"Mieterkonten","110","",null,null,10,0,"",10,"","",1,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[8,1,1,"group",null,"Wertberichtigung Forderungen","110W","",null,null,10,0,"",10,"","",1,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[9,1,8,"account",1109,"Wertberichtigung Mieterforderungen","1109","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[10,1,1,"group",130,"Aktive Rechnungsabgrenzung","130","",null,null,10,0,"",10,"","",1,0,0,null,0,4,0,0,0,0,"",1,null,0,null],[11,1,10,"account",1300,"Aktive Rechnungsabgrenzung (TA)","1300","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[12,1,1,"group",160,"Immobile Sachanlagen","160","",null,null,10,0,"",10,"","",1,0,0,null,0,5,0,0,0,0,"",1,null,0,null],[13,1,12,"account",1600,"Liegenschaft","1600","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[14,1,12,"account",1609,"Wertberichtigung Liegenschaft","1609","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[15,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],[16,1,15,"group",200,"Verbindlichkeiten aus Lieferungen und Leistungen","200","",null,null,10,0,"",10,"","",1,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[17,1,16,"account",2000,"Kreditoren","2000","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[18,1,15,"group",203,"Mieter: Vorauszahlungen und Akonti","203","",null,null,10,0,"",10,"","",1,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[19,1,18,"account",2030,"Vorausbezahlte Mietzinse","2030","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[20,1,18,"account",2035,"Akonto Nebenkosten Mieter","2035","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[21,1,18,"account",2040,"Mietkautionen (auf Konto der Liegenschaft)","2040","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[22,1,15,"group",230,"Passive Rechnungsabgrenzung","230","",null,null,10,0,"",10,"","",1,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[23,1,22,"account",2300,"Passive Rechnungsabgrenzung (TP)","2300","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[24,1,15,"group",245,"Langfristige Verbindlichkeiten","245","",null,null,10,0,"",10,"","",1,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[25,1,24,"account",2451,"Hypothek","2451","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[26,1,15,"group",260,"R\u00FCckstellungen","260","",null,null,10,0,"",10,"","",1,0,0,null,0,4,0,0,0,0,"",1,null,0,null],[27,1,26,"account",2600,"R\u00FCckstellungen","2600","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[28,1,15,"group",280,"Eigenkapital","280","",null,null,10,0,"",10,"","",1,0,0,null,0,5,0,0,0,0,"",1,null,0,null],[29,1,28,"account",2800,"Eigenkapital","2800","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[30,1,28,"account",2850,"Privat (Ein- und Auszahlungen Eigent\u00FCmer)","2850","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[31,1,28,"account",2860,"Kontokorrent Eigent\u00FCmer (Aussch\u00FCttungen)","2860","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[32,1,28,"account",2970,"Gewinn- / Verlustvortrag","2970","",null,null,10,0,"",10,"","",0,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[33,1,15,"calculated",null,"GEWINN / VERLUST","","",null,null,24,0,"",10,"","",1,0,0,null,0,6,0,0,0,0,"",1,null,0,null],[34,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],[35,1,34,"group",60,"Hauswartung, Betrieb, STWEG-Beitr\u00E4ge","60","",null,null,10,0,"",10,"","",1,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[36,1,35,"account",6010,"Beitr\u00E4ge an die STWEG (Akonto)","6010","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[38,1,35,"account",6042,"Reinigung und Hauswartmaterial","6042","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[39,1,35,"account",6045,"Schneer\u00E4umung","6045","",null,null,10,0,"",10,"","",0,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[40,1,35,"account",6047,"Lift Betrieb und Service-Abonnement","6047","",null,null,10,0,"",10,"","",0,0,0,null,0,4,0,0,0,0,"",1,null,0,null],[41,1,34,"group",61,"Unterhalt und Reparaturen","61","",null,null,10,0,"",10,"","",1,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[42,1,41,"account",6100,"Unterhalt und Reparaturen Geb\u00E4ude","6100","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[43,1,41,"account",6105,"Unterhalt und Reparaturen Lift","6105","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[44,1,41,"account",6110,"Unterhalt und Reparaturen Heizung","6110","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[45,1,41,"account",6120,"Unterhalt und Reparaturen Umgebung","6120","",null,null,10,0,"",10,"","",0,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[46,1,41,"account",6130,"Mieterwechsel / Instandstellung Wohnungen","6130","",null,null,10,0,"",10,"","",0,0,0,null,0,4,0,0,0,0,"",1,null,0,null],[47,1,34,"group",63,"Versicherungen und Abgaben","63","",null,null,10,0,"",10,"","",1,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[49,1,47,"account",6360,"Abgaben, Geb\u00FChren, Bewilligungen","6360","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[50,1,47,"account",6370,"Liegenschaftssteuer","6370","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[51,1,34,"group",64,"Energie, Wasser, Entsorgung","64","",null,null,10,0,"",10,"","",1,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[52,1,51,"account",6400,"Elektrizit\u00E4t Allgemein","6400","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[48,1,47,"account",6300,"Sachversicherungen","6300","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,1,0,0,"",1,null,1,null],[53,1,51,"account",6401,"Betriebsstrom Heizung","6401","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[54,1,51,"account",6410,"Gas","6410","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[56,1,51,"account",6425,"Kaminfeger / Feuerungskontrolle","6425","",null,null,10,0,"",10,"","",0,0,0,null,0,4,0,0,0,0,"",1,null,0,null],[58,1,51,"account",6460,"Entsorgung und Kehrichtgeb\u00FChren","6460","",null,null,10,0,"",10,"","",0,0,0,null,0,6,0,0,0,0,"",1,null,0,null],[59,1,34,"group",65,"Verwaltung und Vermietung","65","",null,null,10,0,"",10,"","",1,0,0,null,0,4,0,0,0,0,"",1,null,0,null],[60,1,59,"account",6500,"Verwaltungsaufwand","6500","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[61,1,59,"account",6570,"Vermietungskosten (Inserate)","6570","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[62,1,34,"group",68,"Abschreibungen","68","",null,null,10,0,"",10,"","",1,0,0,null,0,5,0,0,0,0,"",1,null,0,null],[63,1,62,"account",6800,"Abschreibung Liegenschaft","6800","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[64,1,34,"group",69,"Finanzaufwand","69","",null,null,10,0,"",10,"","",1,0,0,null,0,6,0,0,0,0,"",1,null,0,null],[65,1,64,"account",6900,"Bankspesen","6900","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[66,1,64,"account",6940,"Hypothekarzinsen","6940","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[67,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],[68,1,67,"group",34,"Mietertrag","34","",null,null,10,0,"",10,"","",1,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[69,1,68,"account",3400,"Mietzinse Wohnungen","3400","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[70,1,68,"account",3410,"Mietzinse Gesch\u00E4ftsr\u00E4ume","3410","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[71,1,68,"account",3420,"Mietzinse Einstell- und Parkpl\u00E4tze","3420","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[72,1,68,"account",3430,"Mietzinse Nebenr\u00E4ume","3430","",null,null,10,0,"",10,"","",0,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[73,1,68,"account",3450,"Nebenkostenpauschalen","3450","",null,null,10,0,"",10,"","",0,0,0,null,0,4,0,0,0,0,"",1,null,0,null],[74,1,68,"account",3460,"Weiterverrechnete Nebenkosten","3460","",null,null,10,0,"",10,"","",0,0,0,null,0,5,0,0,0,0,"",1,null,0,null],[75,1,67,"group",36,"\u00DCbrige Erl\u00F6se","36","",null,null,10,0,"",10,"","",1,0,0,null,0,1,0,0,0,0,"",1,null,0,null],[76,1,75,"account",3600,"Nebenerl\u00F6se (Waschk\u00FCche, Verwaltungsaufwand NK)","3600","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[77,1,67,"group",38,"Erl\u00F6sminderungen","38","",null,null,10,0,"",10,"","",1,0,0,null,0,2,0,0,0,0,"",1,null,0,null],[78,1,77,"account",3805,"Mietzinsausf\u00E4lle (uneinbringlich)","3805","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[79,1,67,"group",695,"Finanzertrag","695","",null,null,10,0,"",10,"","",1,0,0,null,0,3,0,0,0,0,"",1,null,0,null],[80,1,79,"account",6950,"Finanzertrag (Zinsertrag)","6950","",null,null,10,0,"",10,"","",0,0,0,null,0,0,0,0,0,0,"",1,null,0,null],[81,1,null,"calculated",null,"BILANZDIFFERENZ","","",null,null,25,0,"",10,"","",1,0,0,null,0,4,0,0,0,0,"",1,null,0,null],[55,1,51,"account",6420,"Brennstoffe / Heizmaterial","6420","",null,null,10,0,"",10,"","",0,0,0,null,0,3,0,1,0,0,"",1,null,1,null],[37,1,35,"account",6040,"Hauswartung (Auftrag an Dritte)","6040","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,1,0,0,"",1,null,1,null],[57,1,51,"account",6430,"Wasser und Abwasser","6430","",null,null,10,0,"",10,"","",0,0,0,null,0,5,0,1,0,0,"",1,null,1,null],[82,1,7,"account",11001,"Mieter 0.01 B\u00E4ckerei Frei GmbH","11001","",null,null,10,0,"",10,"","",0,0,0,null,0,1,0,0,0,0,"",1,null,0,1],[83,1,7,"account",11002,"Mieter 1.01 Lukas Meier","11002","",null,null,10,0,"",10,"","",0,0,0,null,0,2,0,0,0,0,"",1,null,0,2],[84,1,7,"account",11003,"Mieter 1.02 Fatma Yilmaz","11003","",null,null,10,0,"",10,"","",0,0,0,null,0,3,0,0,0,0,"",1,null,0,3],[85,1,7,"account",11004,"Mieter 2.01 Thomas Keller","11004","",null,null,10,0,"",10,"","",0,0,0,null,0,4,0,0,0,0,"",1,null,0,4],[86,1,7,"account",11005,"Mieter 2.02 Peter Huber","11005","",null,null,10,0,"",10,"","",0,0,0,null,0,5,0,0,0,0,"",1,null,0,5],[87,1,7,"account",11006,"Mieter 3.01 Sandra Brunner","11006","",null,null,10,0,"",10,"","",0,0,0,null,0,6,0,0,0,0,"",1,null,0,6]]},"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,"Beispielhaus Lindenweg 7","Lindenweg","7","4153","Reinach","BL","CH",null,null,null,0,null,0,0,20,6,1,null,null,null,"Miete",1,"Auftrag",5,3000,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,"Inkasso","2019-04-01",null,null,"",0,6,"03-31;06-30;09-30",7200,"Mietkautionskonto","Beispielbank","","2019-03-18",null,0,3,"","2026-10-07 15:14:26",0,null,""],[2,0,1,null,"Inkasso","2018-10-01",null,null,"",0,3,"03-31;06-30;09-30",4800,"Mietkautionskonto","Beispielbank","","2018-09-17",null,0,3,"","2026-10-07 15:14:26",0,null,""],[3,0,1,null,"Inkasso","2022-02-01",null,null,"",0,3,"03-31;06-30;09-30",4050,"Mietkautionskonto","Beispielbank","","2022-01-18",null,0,3,"","2026-10-07 15:14:26",0,null,""],[4,1,1,null,"Inkasso","2023-06-01","2027-03-31","2026-09-18","Mieter",0,3,"03-31;06-30;09-30",5100,"Mietkautionskonto","Beispielbank","","2023-05-18",null,0,3,"","2026-10-07 15:14:26",0,null,""],[5,1,1,null,"Inkasso","2020-04-01","2026-06-30","2026-03-20","Mieter",0,3,"03-31;06-30;09-30",4020,"Mietkautionskonto","Beispielbank","","2020-03-18",null,0,3,"","2026-10-07 15:14:26",0,null,""],[6,0,1,null,"Inkasso","2021-07-01",null,null,"",1,3,"03-31;06-30;09-30",7140,"Mietkautionskonto","Beispielbank","","2021-06-17",null,0,3,"","2026-10-07 15:14:26",0,null,""]]},"mietverhaeltnis_mieter":{"columns":["id","mietverhaeltnis_id","person_nr","reihenfolge"],"rows":[[1,1,2,0],[2,2,3,0],[3,3,4,0],[4,4,5,0],[5,5,6,0],[6,6,7,0],[7,6,8,1]]},"mietverhaeltnis_nk":{"columns":["id","mietverhaeltnis_id","verteiler_id"],"rows":[[1,1,1],[2,1,2],[3,1,3],[4,2,1],[5,2,2],[6,2,3],[7,3,1],[8,3,2],[9,3,3],[10,4,1],[11,4,2],[12,4,3],[13,5,1],[14,5,2],[15,5,3],[16,6,1],[17,6,2],[18,6,3]]},"mietverhaeltnis_objekt":{"columns":["id","mietverhaeltnis_id","objekt_id","ist_hauptobjekt"],"rows":[[1,1,"Odb4be2cd6f3b4fb8a7ecea4fc57dcc91",1],[2,2,"O17d4f83632894eb5823511a68c46dc81",1],[3,3,"O5f4497821dcd483f959784e7f5234730",1],[4,4,"Oe1ed7e51acef4367b8635c4c191f96bc",1],[5,5,"O0207bbb7e119410eb302e0cfbadad93f",1],[6,6,"Oa3fb7d17191b4f778b9741b34cbf24d9",1],[7,6,"O5fe4c8ab8c0d42138887a70b2b339d19",0]]},"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,"2019-04-01","Beginn",1.5,101.7,"2019-02-01","2019-04-01","",2015],[2,2,"2018-10-01","Beginn",1.5,101.8,"2018-08-01","2018-10-01","",2015],[3,2,"2024-04-01","Anpassung",1.75,107.1,"2024-02-01","2024-04-01","Anpassung Referenzzins 1.50 \u2192 1.75 %",2020],[4,3,"2022-02-01","Beginn",1.25,101.5,"2021-12-01","2022-02-01","",2020],[5,4,"2023-06-01","Beginn",1.5,106,"2023-04-01","2023-06-01","",2020],[6,5,"2020-04-01","Beginn",1.25,101.6,"2020-02-01","2020-04-01","",2015],[7,6,"2021-07-01","Beginn",1.25,101,"2021-05-01","2021-07-01","",2020]]},"mietzins_zeile":{"columns":["id","mietzins_stand_id","objekt_id","netto","nk_akonto","nk_pauschale","nk_positionen"],"rows":[[1,1,"Odb4be2cd6f3b4fb8a7ecea4fc57dcc91",2400,300,0,""],[2,2,"O17d4f83632894eb5823511a68c46dc81",1600,220,0,""],[3,3,"O17d4f83632894eb5823511a68c46dc81",1650,220,0,""],[4,4,"O5f4497821dcd483f959784e7f5234730",1350,180,0,""],[5,5,"Oe1ed7e51acef4367b8635c4c191f96bc",1700,220,0,""],[6,6,"O0207bbb7e119410eb302e0cfbadad93f",1340,180,0,""],[7,7,"Oa3fb7d17191b4f778b9741b34cbf24d9",2250,260,0,""],[8,7,"O5fe4c8ab8c0d42138887a70b2b339d19",130,0,0,""]]},"Objekt":{"columns":["ObjektId","ObjektNr","LiegenschaftNr","Typ","Bezeichnung","Stockwerk","Zimmer","Flaeche","Promille","EWID","NichtAbrechnen","Version","SollNetto","SollNk"],"rows":[["Odb4be2cd6f3b4fb8a7ecea4fc57dcc91","0.01",1,"Gewerbe","Laden","EG",0,95,0,null,0,0,2400,300],["O17d4f83632894eb5823511a68c46dc81","1.01",1,"Wohnung",null,"1. OG",3.5,82,0,null,0,0,1650,220],["O5f4497821dcd483f959784e7f5234730","1.02",1,"Wohnung",null,"1. OG",2.5,61,0,null,0,0,1350,180],["Oe1ed7e51acef4367b8635c4c191f96bc","2.01",1,"Wohnung",null,"2. OG",3.5,82,0,null,0,0,1700,220],["O0207bbb7e119410eb302e0cfbadad93f","2.02",1,"Wohnung",null,"2. OG",2.5,61,0,null,0,0,1380,180],["Oa3fb7d17191b4f778b9741b34cbf24d9","3.01",1,"Wohnung",null,"Attika",4.5,110,0,null,0,0,2250,260],["O5fe4c8ab8c0d42138887a70b2b339d19","P1",1,"Einstellplatz",null,"UG",0,0,0,null,0,0,130,0],["Ob1083868b4ca460780541ad20ae2a396","P2",1,"Einstellplatz",null,"UG",0,0,0,null,0,0,130,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":[]},"ObjektVerteilerWert":{"columns":["Id","VerteilerId","ObjektId","GeschaeftsjahrId","Wert","PersonNr"],"rows":[[1,1,"Odb4be2cd6f3b4fb8a7ecea4fc57dcc91",1,95,null],[2,2,"Odb4be2cd6f3b4fb8a7ecea4fc57dcc91",1,1,null],[3,3,"Odb4be2cd6f3b4fb8a7ecea4fc57dcc91",1,1,null],[4,4,"Odb4be2cd6f3b4fb8a7ecea4fc57dcc91",1,95,null],[5,1,"O17d4f83632894eb5823511a68c46dc81",1,82,null],[6,2,"O17d4f83632894eb5823511a68c46dc81",1,1,null],[7,3,"O17d4f83632894eb5823511a68c46dc81",1,1,null],[8,4,"O17d4f83632894eb5823511a68c46dc81",1,82,null],[9,1,"O5f4497821dcd483f959784e7f5234730",1,61,null],[10,2,"O5f4497821dcd483f959784e7f5234730",1,1,null],[11,3,"O5f4497821dcd483f959784e7f5234730",1,1,null],[12,4,"O5f4497821dcd483f959784e7f5234730",1,61,null],[13,1,"Oe1ed7e51acef4367b8635c4c191f96bc",1,82,null],[14,2,"Oe1ed7e51acef4367b8635c4c191f96bc",1,1,null],[15,3,"Oe1ed7e51acef4367b8635c4c191f96bc",1,1,null],[16,4,"Oe1ed7e51acef4367b8635c4c191f96bc",1,82,null],[17,1,"O0207bbb7e119410eb302e0cfbadad93f",1,61,null],[18,2,"O0207bbb7e119410eb302e0cfbadad93f",1,1,null],[19,3,"O0207bbb7e119410eb302e0cfbadad93f",1,1,null],[20,4,"O0207bbb7e119410eb302e0cfbadad93f",1,61,null],[21,1,"Oa3fb7d17191b4f778b9741b34cbf24d9",1,110,null],[22,2,"Oa3fb7d17191b4f778b9741b34cbf24d9",1,1,null],[23,3,"Oa3fb7d17191b4f778b9741b34cbf24d9",1,1,null],[24,4,"Oa3fb7d17191b4f778b9741b34cbf24d9",1,110,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,0,0,0,0,0,null,null,"Anna","Beispiel",null,null,0,null,null,null,null,null,null,null,null,"anna.beispiel@example.ch",null,null,null,null,null,"Rosenweg 3",null,"4144","Arlesheim","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,0,null,null,null,null],[2,0,0,0,0,0,null,null,"B\u00E4ckerei Frei","GmbH",null,null,0,null,null,null,null,null,null,null,null,"info@baeckerei-frei.example.ch",null,null,null,null,null,"Lindenweg 7",null,"4153","Reinach","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,1,null,null,null,null],[3,0,0,0,0,0,null,null,"Lukas","Meier",null,null,0,null,null,null,null,null,null,null,null,"lukas.meier@example.ch",null,null,null,null,null,"Lindenweg 7",null,"4153","Reinach","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,1,null,null,null,null],[4,0,0,0,0,0,null,null,"Fatma","Yilmaz",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lindenweg 7",null,"4153","Reinach","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,1,null,null,null,null],[5,0,0,0,0,0,null,null,"Thomas","Keller",null,null,0,null,null,null,null,null,null,null,null,"t.keller@example.ch",null,null,null,null,null,"Lindenweg 7",null,"4153","Reinach","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,1,null,null,null,null],[6,0,0,0,0,0,null,null,"Peter","Huber",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Birkenweg 12",null,"4142","M\u00FCnchenstein","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,1,null,null,null,null],[7,0,0,0,0,0,null,null,"Sandra","Brunner",null,null,0,null,null,null,null,null,null,null,null,"sandra.brunner@example.ch",null,null,null,null,null,"Lindenweg 7",null,"4153","Reinach","Schweiz",null,"[\u00DCbung] Erfundene Person der \u00DCbungsliegenschaft",3,0,1,null,null,null,null],[8,0,0,0,0,0,null,null,"Marco","Brunner",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lindenweg 7",null,"4153","Reinach","Schweiz",null,"[\u00DCbung] Erfundene Person 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,574,"Heizung","Objekt",null,0,null,"MANUELL",1,1,"Heizung","EINHEIT",0,1,0,null,null,null,null,null],[2,1,512,"Hauswartung","Objekt",null,0,null,"MANUELL",1,1,"Hauswartung","EINHEIT",0,1,0,null,null,null,null,null],[3,1,511,"Wasser / Abwasser","Objekt",null,0,null,"MANUELL",1,1,"Wasser / Abwasser","EINHEIT",0,1,0,null,null,null,null,null],[4,1,520,"Sachversicherung","Objekt",null,0,null,"MANUELL",1,1,"Sachversicherung","EINHEIT",0,1,0,null,null,null,null,null]]},"verteiler_vermietung":{"columns":["verteiler_id","umlage","wechsel"],"rows":[]},"VerteilerBuchhaltungZuordnung":{"columns":["Id","VerteilerId","ZuordnungsTyp","KontoNodeId","Sortierung"],"rows":[[1,1,"Konto",55,0],[2,2,"Konto",37,0],[3,3,"Konto",57,0],[4,4,"Konto",48,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":[]}}}