Controlpanel / Database
Database Explorer
Read-only SQL/JSON werkbank. Open een databron, kies een tabel, zoek in echte rijen en inspecteer data als ruwe JSON. Geen vrije SQL, geen writes, geen export.
6 bronnen66 tabellen/stores257.140 rijen/items22 domeincontainers
Zoeken
Tabelzoeker zoekt in de gekozen tabel; dossierzoeker zoekt klant/dossierlocaties over bekende dossierstores.
Rijen: postgres-main.dossier_data
Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.
Read-only query
WITH _statement_timeout AS (SELECT set_config('statement_timeout', '1500ms', true)) SELECT t.* FROM public."dossier_data" t CROSS JOIN _statement_timeout ORDER BY updated_at DESC LIMIT 50 OFFSET 100| dossier_id | key | value_json | updated_at |
|---|---|---|---|
| supplier-syntrus-achmea | dossier_meta | { "type": "supplier", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "supplier_id": "syntrus-achmea", "supplier_name": "Syntrus Achmea", "allowed_modules": [ "documenten", "mail" ], "supplier_category": "geldverstrekker" } | 1781718783600 |
| supplier-tellius-hypotheken | supplier_profile | { "id": "supplier-tellius-hypotheken", "name": "Tellius Hypotheken", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "aliases": [ "Tellius Hypotheken", "Tellius", "Tellius ToekomstVast Hypotheek" ], "domains": [ "tellius.nl" ], "category": "geldverstrekker" } | 1781718783600 |
| supplier-onderlinge-nederland | dossier_meta | { "type": "supplier", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "supplier_id": "onderlinge-nederland", "supplier_name": "Onderlinge Nederland", "allowed_modules": [ "documenten", "mail" ], "supplier_category": "geldverstrekker" } | 1781718783600 |
| supplier-vista | supplier_profile | { "id": "supplier-vista", "name": "Vista", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "aliases": [ "Vista", "Vista Hypotheken" ], "domains": [ "vistahypotheken.nl" ], "category": "geldverstrekker" } | 1781718783600 |
| supplier-florius | dossier_meta | { "type": "supplier", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "supplier_id": "florius", "supplier_name": "Florius", "allowed_modules": [ "documenten", "mail" ], "supplier_category": "geldverstrekker" } | 1781718783600 |
| supplier-lloyds-bank | supplier_profile | { "id": "supplier-lloyds-bank", "name": "Lloyds Bank", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "aliases": [ "Lloyds Bank", "Lloyds" ], "domains": [ "lloydsbank.nl" ], "category": "geldverstrekker" } | 1781718783600 |
| supplier-impact | supplier_profile | { "id": "supplier-impact", "name": "Impact", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "aliases": [ "Impact", "Impact Hypotheken" ], "domains": [ "impacthypotheken.nl" ], "category": "geldverstrekker" } | 1781718783600 |
| supplier-uw-garantiestelling | dossier_meta | { "type": "supplier", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "supplier_id": "uw-garantiestelling", "supplier_name": "Uw Garantiestelling", "allowed_modules": [ "documenten", "mail" ], "supplier_category": "waarborg" } | 1781718783600 |
| supplier-clarian-wonen | dossier_meta | { "type": "supplier", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "supplier_id": "clarian-wonen", "supplier_name": "Clarian Wonen", "allowed_modules": [ "documenten", "mail" ], "supplier_category": "geldverstrekker" } | 1781718783600 |
| supplier-florius | supplier_profile | { "id": "supplier-florius", "name": "Florius", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "aliases": [ "Florius" ], "domains": [ "florius.nl" ], "category": "geldverstrekker" } | 1781718783600 |
| supplier-bijbouwe | supplier_profile | { "id": "supplier-bijbouwe", "name": "bijBouwe", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "aliases": [ "bijBouwe", "bij Bouwe" ], "domains": [ "bijbouwe.nl" ], "category": "geldverstrekker" } | 1781718783600 |
| supplier-neo-hypotheken | supplier_profile | { "id": "supplier-neo-hypotheken", "name": "Neo Hypotheken", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "aliases": [ "Neo Hypotheken", "N26 NEO Hypotheken", "N26 Hypotheken" ], "domains": [ "neohypotheken.nl", "n26.com" ], "category": "geldverstrekker" } | 1781718783600 |
| supplier-bnp-paribas-personal-finance | supplier_profile | { "id": "supplier-bnp-paribas-personal-finance", "name": "BNP Paribas Personal Finance", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "aliases": [ "BNP Paribas Personal Finance", "BNP Paribas Hypotheek", "BNP Paribas" ], "domains": [ "bnpparibas-pf.nl" ], "category": "geldverstrekker" } | 1781718783600 |
| supplier-onderlinge-nederland | supplier_profile | { "id": "supplier-onderlinge-nederland", "name": "Onderlinge Nederland", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "aliases": [ "Onderlinge Nederland", "Onderlinge 's-Gravenhage", "Onderlinge Gravenhage", "ZilverHuis Hypotheek", "ZilverHuis" ], "domains": [ "onderlingenederland.nl", "onderlinge.info", "ogmail.nl" ], "category": "geldverstrekker" } | 1781718783600 |
| supplier-nhg | dossier_meta | { "type": "supplier", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "supplier_id": "nhg", "supplier_name": "NHG", "allowed_modules": [ "documenten", "mail" ], "supplier_category": "waarborg" } | 1781718783600 |
| supplier-bnp-paribas-personal-finance | dossier_meta | { "type": "supplier", "source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md", "supplier_id": "bnp-paribas-personal-finance", "supplier_name": "BNP Paribas Personal Finance", "allowed_modules": [ "documenten", "mail" ], "supplier_category": "geldverstrekker" } | 1781718783600 |
| 009b5118-80f0-4b2a-a476-6224e9099fd9 | financieringsopzet | { "activeId": "proposal-d18d1d45-2b26-4e07-97e1-d06fbef17fde", "voorstellen": [ { "id": "d8135949-817f-4280-bce6-761b5616df67", "naam": "Voorstel 1", "kosten": { "koopsom": "", "taxatie": "", "kadaster": "", "meerwerk": "", "boeterente": "", "verbouwing": "", "bankgarantie": "", "nhgBorgtocht": "", "overigKosten": "", "roerendeZaken": "", "aankoopmakelaar": "", "hypotheekadvies": "", "uitkoopExPartner": "", "aflossingBestaand": "", "bouwkundigeKeuring": "", "notarisHypotheekakte": "", "notarisLeveringsakte": "", "overdrachtsbelasting": "" }, "status": "draft", "notitie": "", "leningdelen": [ { "id": "inventarisatie-nieuw", "box": "1", "nhg": "Ja", "type": "Nieuw", "rente": "4.05", "hoofdsom": "253966.00", "aflosvorm": "Annuiteit", "aftrekPct": "100", "einddatum": "", "box1Bedrag": "", "box3Bedrag": "", "deelBox1Pct": "", "deelBox3Pct": "", "productnaam": "", "ingangsdatum": "", "leningnummer": "", "rentevariant": "Rentevast", "restverschil": "", "arrangeme ... [afgekapt: 7514 tekens] | 1781647222366 |
| 009b5118-80f0-4b2a-a476-6224e9099fd9 | hdn_dossier | { "schema": "adviestool.hdn_like", "bronnen": { "partijen.p1.contact.email": [ { "at": 1781647194538, "value": "sylvia@famdejong.net", "context": "inventarisatie.a1.email", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "hypotheken.aangevraagd.nhg": [ { "at": 1781647194539, "value": "NHG", "context": "inventarisatie.data.aanvraag_nhg", "confidence": 0.55, "sourceKind": "inventarisatie" }, { "at": 1781647194539, "value": "NHG", "context": "base_import.products[].norm", "confidence": 0.68, "sourceKind": "extractie" }, { "at": 1780494316520, "value": "Nee", "context": "hdn_download_inbox.threads.object:langevelderslag808223pelelystad:pdejong.offer.nhg", "confidence": 0.88, "sourceKind": "hdn_download" } ], "hypotheken.aangevraagd.rente": [ { "at": 1781647194539, "value": "4.05", "context": "inventarisatie.data.aanvraag_rente", "confidence": 0.55, "sourceKind": "inventarisatie" }, { "at": 1780494316520, "value": "4.05", "context": "hdn_download_inbox.threads.object:langevelderslag808223pelelystad:pdejong.offer.rentePct", ... [afgekapt: 414067 tekens] | 1781647218389 |
| 009b5118-80f0-4b2a-a476-6224e9099fd9 | _sources | { "aov.value": { "source": "Eigen invoer", "updated_at": "2026-06-11T04:51:43.805Z" }, "orv.value": { "source": "Eigen invoer", "updated_at": "2026-06-11T04:51:35.662Z" }, "aov.producten": { "source": "Eigen invoer", "updated_at": "2026-06-16T12:53:07.861Z" }, "upload3-trash.value": { "source": "Eigen invoer", "updated_at": "2026-06-10T10:59:14.985Z" }, "aanvraagproces.value": { "source": "Eigen invoer", "updated_at": "2026-06-03T08:57:05.471Z" }, "aanvraagproces.status": { "source": "Eigen invoer", "updated_at": "2026-06-10T16:53:42.220Z" }, "aanvraagproces.history": { "source": "Eigen invoer", "updated_at": "2026-06-13T14:33:32.627Z" }, "advies-motivering.value": { "source": "Eigen invoer", "updated_at": "2026-06-04T09:49:45.385Z" }, "inventarisatie.products": { "source": "Eigen invoer", "updated_at": "2026-06-10T15:16:43.136Z" }, "advies-onderwerpen.value": { "source": "Eigen invoer", "updated_at": "2026-06-04T09:49:45.237Z" }, "financieringsopzet.value": { "source": "Eigen invoer", "updated_at": "2026-06-03T17:14:55.650Z" }, "hypotheek-algemeen.value": { "source": "Eigen invoer", "updated_at": "2026-06-11T04:51:10.896Z" }, "inventarisatie.a1.straat": { "source": "Logscan: Straatnaam uit Ja ... [afgekapt: 16011 tekens] | 1781647214454 |
| 009b5118-80f0-4b2a-a476-6224e9099fd9 | inventarisatie | { "a1": { "naam": "Graaf, Sylvia van der (S)", "adres": "Stadseiland 100", "email": "sylvia@famdejong.net", "straat": "Stadseiland", "postcode": "8243 HV", "whatsapp": "06-45782733", "huisnummer": "100", "woonplaats": "Lelystad", "telefoon_prive": "0622375220", "legitimatiebewijs": "Paspoort" }, "a2": { "naam": "Jong, Peter de (P)", "adres": "Stadseiland 100", "postcode": "8243 HV", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": { "0": { "norm": "NHG", "type": "Hypotheek", "inhoud": "253966.00", "status": "Lopend", "artikel": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek", "maatschappij": "Merius Hypotheken", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3013205", "passeeringangsdatum": "2019-09-18" }, "1": { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij" ... [afgekapt: 6556 tekens] | 1781647210486 |
| 009b5118-80f0-4b2a-a476-6224e9099fd9 | aov | { "producten": [] } | 1781614387861 |
| 6cdf1a8b-d6b0-4881-b6ca-2c7fb45c4771 | financieringsopzet | { "activeId": "voorstel-oha-uitkoop", "voorstellen": [ { "id": "voorstel-oha-uitkoop", "naam": "OHA + uitkoop ex-partner (ING)", "kosten": { "koopsom": "", "taxatie": "600", "kadaster": "200", "meerwerk": "", "boeterente": "", "verbouwing": "", "bankgarantie": "", "nhgBorgtocht": "", "overigKosten": "", "roerendeZaken": "", "aankoopmakelaar": "", "hypotheekadvies": "2.500", "uitkoopExPartner": "160.551", "aflossingBestaand": "", "bouwkundigeKeuring": "", "notarisHypotheekakte": "750", "notarisLeveringsakte": "750", "overdrachtsbelasting": "" }, "status": "selected", "notitie": "AANNAMES (12-06-2026, concept): uitkoopsom 160.551 = helft overwaarde 115.179 (590.000 - 359.642,49 convenant) + helft bankspaarsaldo 45.372 (90.744,36 per 18-12-2025) — definitieve bedragen per leveringsdatum. Verhogingsdeel 165.000 annuïtair @4,00% 10jr RVP = aanname marktconforme ING-rente; kosten geschat (notaris/advies/taxatie/kadaster). Bestaande drie delen lopen door met behoud condities; na OHA alleen aanvrager schuldenaar. LTV na verhoging ±89% (524.729/590.000); netto na bankspaarsaldo ±74%. Aandachtspunt: aflossingsvrij deel was in 2010 'deels consumptief' — box 1/3-verde ... [afgekapt: 8914 tekens] | 1781610354396 |
| 6cdf1a8b-d6b0-4881-b6ca-2c7fb45c4771 | hdn_dossier | { "schema": "adviestool.hdn_like", "bronnen": { "hypotheken.bestaand1.nhg": [ { "at": 1781247205075, "label": "Nationale Hypotheek Garantie", "value": "Ja", "fileId": "f642254a-3666-4737-81da-9d3e674316fa", "context": "hypotheken.bestaand1.nhg", "accepted": false, "fileName": "Hypotheekofferte ing Westhoven 2010.pdf", "itemIndex": 7, "confidence": 0.7, "sourceKind": "extractie", "sourceText": "NHG-status uit offerte.", "sourceBoxes": [], "canonicalKey": "mortgage_nhg" } ], "hypotheken.aangevraagd.nhg": [ { "at": 1781610333654, "value": "Ja", "context": "inventarisatie.data.aanvraag_nhg", "confidence": 0.55, "sourceKind": "inventarisatie" }, { "at": 1781265695212, "label": "Nationale Hypotheek Garantie", "value": "Ja", "fileId": "ocrexp-449f115310fd", "context": "hypotheken.aangevraagd.nhg", "accepted": false, "fileName": "2147483647 2.pdf", "itemIndex": 5, "confidence": 0.65, "sourceKind": "extractie", "sourceText": "Nationale Hypotheek Garantie ja", "sourceBoxes": [ { "h": 12.999935999999934, "w": 239.057051, "x": ... [afgekapt: 164790 tekens] | 1781610350605 |
| 6cdf1a8b-d6b0-4881-b6ca-2c7fb45c4771 | _sources | { "klantprofiel.value": { "source": "Eigen invoer", "updated_at": "2026-06-12T07:40:46.365Z" }, "aanvraagproces.value": { "source": "Eigen invoer", "updated_at": "2026-06-12T07:24:35.055Z" }, "inventarisatie.value": { "source": "Eigen invoer", "updated_at": "2026-06-12T07:08:40.998Z" }, "inventarisatie.inc1.id": { "source": "Eigen invoer", "updated_at": "2026-06-12T13:55:09.259Z" }, "inventarisatie.inc2.id": { "source": "Eigen invoer", "updated_at": "2026-06-12T09:08:55.063Z" }, "advies-motivering.value": { "source": "Eigen invoer", "updated_at": "2026-06-12T07:09:33.137Z" }, "klantprofiel.aanleiding": { "source": "Eigen invoer", "updated_at": "2026-06-12T07:42:28.333Z" }, "advies-onderwerpen.value": { "source": "Eigen invoer", "updated_at": "2026-06-12T07:10:31.006Z" }, "inventarisatie.inc1.type": { "source": "Eigen invoer", "updated_at": "2026-06-12T13:55:09.259Z" }, "inventarisatie.incomes.A2": { "source": "Eigen invoer", "updated_at": "2026-06-12T09:08:55.063Z" }, "financieringsopzet.activeId": { "source": "Eigen invoer", "updated_at": "2026-06-12T07:22:42.159Z" }, "inventarisatie.inc1.payrolls": { "source": "Eigen invoer", "updated_at": "2026-06-12T09:08:55.063Z" }, "inventarisatie.inc2.payro ... [afgekapt: 34030 tekens] | 1781610346695 |
| 6cdf1a8b-d6b0-4881-b6ca-2c7fb45c4771 | inventarisatie | { "a1": { "naam": "Hoek, Robert van den (R.)", "adres": "Westhoven 38", "straat": "Westhoven", "geslacht": "M", "postcode": "8219 AH", "huisnummer": "38", "woonplaats": "LELYSTAD", "geboorteland": "Nederland", "geboortedatum": "07-11-1967", "nationaliteit": "Nederlandse", "burgerlijke_staat": "Gescheiden (huwelijk ontbonden 03-06-2026, inschrijving 's-Gravenhage)" }, "a2": { "rol": "Vertrekkende partner — te ontslaan uit hoofdelijke aansprakelijkheid", "naam": "Veldhuisen, Saskia (S.)", "adres": "Westhoven 38", "geslacht": "V", "postcode": "8219 AH", "woonplaats": "LELYSTAD", "geboortedatum": "30-04-1973" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "orv_actie": "Bij OHA: polis aanpassen — verzekerde/begunstigde ex-partner eraf of nieuwe polis op alleen aanvrager; verpanding ING continueren", "orv_polis": "a.s.r. (v/h Fortis ASR) polis 70521797, gelijkblijvend EUR 200.000 op beide levens, verpand aan ING (inpandgeving 28-01-2010)", "aanvraag_nhg": "Ja", "dossierstatus": "Actief", "aanvraag_rente": "3,64%", "soort_aanvraag": "Ontslag hoofdelijke aansprakelijkheid + uitkoop ex-partner", "bankspaar_saldo": "90.744,36 (S 157-25326 per 18-12-2025, doelkapitaal 225.000)", "convenant_datum": ... [afgekapt: 12085 tekens] | 1781610342904 |
| test-state-dossier-1 | workflow_v1 | { "flags": [], "actions": [], "intentApprovedAt": "b", "intentProposedAt": "a", "uitvraagReminders": [] } | 1781586460261 |
| 0fa132bb-baef-44fd-b4df-cf56ac8932c5 | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2024-02-26", "chatId": "31619308755@s.whatsapp.net", "chatNaam": "+31 *********", "bestandsnaam": "Salarisspecificatie 2024-02-26 132250.pdf" } ], "updatedAt": "2026-06-14T20:23:38.851Z" } | 1781468618851 |
| a5afc05f-85c8-43d2-9b6f-a56a9c6a6cf9 | whatsapp_doc_signalen | { "items": [ { "van": "adviseur", "datum": "2024-08-12", "chatId": "120363142544714854@g.us", "chatNaam": "Hyp: Mentopawiro & Gaskin", "bestandsnaam": "Offerte (53)-samengevoegd (1).pdf" } ], "updatedAt": "2026-06-14T20:23:38.801Z" } | 1781468618801 |
| c04a3284-7183-4164-a21a-79b732cfd412 | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2024-11-04", "chatId": "31622954416@s.whatsapp.net", "chatNaam": "Danny Rasmussen", "bestandsnaam": "*********.pdf" } ], "updatedAt": "2026-06-14T20:23:38.748Z" } | 1781468618748 |
| 2e8bae07-270e-41b1-a35a-e76a5ee8b526 | whatsapp_doc_signalen | { "items": [ { "van": "adviseur", "datum": "2024-11-13", "chatId": "31641391358@s.whatsapp.net", "chatNaam": "Stephan van der Dussen", "bestandsnaam": "40034436-Polisblad (tp).pdf" } ], "updatedAt": "2026-06-14T20:23:38.699Z" } | 1781468618699 |
| 85fc19d8-cac4-497e-947e-43d549eb733c | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2025-01-21", "chatId": "31626960634@s.whatsapp.net", "chatNaam": "Gert-jan Otterlo", "bestandsnaam": "Levering Wijngaard 2.pdf" } ], "updatedAt": "2026-06-14T20:23:38.653Z" } | 1781468618653 |
| b1a869b8-f5f3-4d05-a09b-a1eff6f89a7d | whatsapp_doc_signalen | { "items": [ { "van": "adviseur", "datum": "2025-12-11", "chatId": "31647458845-1571075946@g.us", "chatNaam": "Hyp: Ubels & Ootes", "bestandsnaam": "InspectieFormulier - Germanenlaan 190, 7312 JD APELDOORN.pdf" } ], "updatedAt": "2026-06-14T20:23:38.603Z" } | 1781468618603 |
| 8af06f3e-4db7-46c4-be6e-f9a7bb25b576 | whatsapp_doc_signalen | { "items": [ { "van": "adviseur", "datum": "2026-02-05", "chatId": "31631141853@s.whatsapp.net", "chatNaam": "Dario Pozderski", "bestandsnaam": "Voorwaarden 5369PP-*********.pdf" } ], "updatedAt": "2026-06-14T20:23:38.555Z" } | 1781468618555 |
| cc191942-3ceb-43f1-9447-d01d148bfc6a | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-02-22", "chatId": "31618252371@s.whatsapp.net", "chatNaam": "Luis Diaz", "bestandsnaam": "Certificado_de_titularidad_y_posiciones_FW8M2UC2_22_02_2026.pdf" }, { "van": "klant", "datum": "2026-02-19", "chatId": "31618252371@s.whatsapp.net", "chatNaam": "Luis Diaz", "bestandsnaam": "Koopovereenkomst_Waalstraat_151_1316_EW_ALMERE_AE101463_18-02-2026-14_30_14 (1).pdf" }, { "van": "klant", "datum": "2026-02-17", "chatId": "31618252371@s.whatsapp.net", "chatNaam": "Luis Diaz", "bestandsnaam": "2 .pdf" }, { "van": "klant", "datum": "2026-02-17", "chatId": "31618252371@s.whatsapp.net", "chatNaam": "Luis Diaz", "bestandsnaam": "Report Waalstraat 151.pdf" }, { "van": "klant", "datum": "2026-02-17", "chatId": "31618252371@s.whatsapp.net", "chatNaam": "Luis Diaz", "bestandsnaam": "Bouwkundige Data-analyse.pdf" } ], "updatedAt": "2026-06-14T20:23:38.507Z" } | 1781468618507 |
| fa02ee41-b27f-4497-ba8f-153bf28e1a05 | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-03-04", "chatId": "31628572303@s.whatsapp.net", "chatNaam": "Remco", "bestandsnaam": "financieel-jaaroverzicht-2025-000000006107259-2026-01-21.pdf" } ], "updatedAt": "2026-06-14T20:23:38.456Z" } | 1781468618456 |
| da3a52d9-8459-4a75-9d69-4306cd572b35 | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-04-16", "chatId": "31650557793@s.whatsapp.net", "chatNaam": "Mohammed Shahata Via Raul Soto", "bestandsnaam": "Zorgovereenkomst_20260226-1459.pdf" }, { "van": "klant", "datum": "2026-04-16", "chatId": "31650557793@s.whatsapp.net", "chatNaam": "Mohammed Shahata Via Raul Soto", "bestandsnaam": "Zorgovereenkomst_20260416-1353.pdf" }, { "van": "klant", "datum": "2026-02-26", "chatId": "31650557793@s.whatsapp.net", "chatNaam": "Mohammed Shahata Via Raul Soto", "bestandsnaam": "Zorgovereenkomst_20260226-1459.pdf" } ], "updatedAt": "2026-06-14T20:23:38.409Z" } | 1781468618409 |
| b8fb12b0-5dfd-4453-b787-4d2d51da21bf | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-02-28", "chatId": "31646104432@s.whatsapp.net", "chatNaam": "Vince", "bestandsnaam": "Risk schoener.PDF" } ], "updatedAt": "2026-06-14T20:23:38.362Z" } | 1781468618362 |
| 5efa3b6c-6a51-4314-a025-c044b671ecd3 | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-04-01", "chatId": "31613777941@s.whatsapp.net", "chatNaam": "Ferry", "bestandsnaam": "Jaaropgave 2025 Amber.pdf" } ], "updatedAt": "2026-06-14T20:23:38.315Z" } | 1781468618315 |
| a6ef41e2-8780-4dd6-baac-3f5126fe8e44 | whatsapp_doc_signalen | { "items": [ { "van": "adviseur", "datum": "2026-04-17", "chatId": "31683434664@s.whatsapp.net", "chatNaam": "Gerwin Bonestroo", "bestandsnaam": "Hypotheeklasten.pdf" }, { "van": "klant", "datum": "2026-03-25", "chatId": "31683434664@s.whatsapp.net", "chatNaam": "Gerwin Bonestroo", "bestandsnaam": "inkomensverklaring-5367303-bonestroo.pdf" } ], "updatedAt": "2026-06-14T20:23:38.267Z" } | 1781468618267 |
| 849de268-12c6-4df6-b466-6b60ca2610b4 | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-03-26", "chatId": "120363306202703034@g.us", "chatNaam": "Hyp: Kopen & Guothova", "bestandsnaam": "Jaaropgave_2025_1003147.pdf" }, { "van": "klant", "datum": "2026-03-26", "chatId": "120363306202703034@g.us", "chatNaam": "Hyp: Kopen & Guothova", "bestandsnaam": "att.o6FBKxFzuP0QPPPbkiS-sDFM8ldEHmCN5I4lj9qP2zk.pdf" } ], "updatedAt": "2026-06-14T20:23:38.220Z" } | 1781468618220 |
| 69d7416b-85b9-4447-8cdb-74e5e91d3b97 | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-04-22", "chatId": "31639782455@s.whatsapp.net", "chatNaam": "+31 *********", "bestandsnaam": "2025-12.pdf" }, { "van": "klant", "datum": "2026-04-22", "chatId": "31639782455@s.whatsapp.net", "chatNaam": "+31 *********", "bestandsnaam": "jaar opgave Y Riebeek 2025.pdf" }, { "van": "klant", "datum": "2026-04-22", "chatId": "31639782455@s.whatsapp.net", "chatNaam": "+31 *********", "bestandsnaam": "43 - Originele factuur - 12264273737071 (1).pdf" }, { "van": "klant", "datum": "2026-04-22", "chatId": "31639782455@s.whatsapp.net", "chatNaam": "+31 *********", "bestandsnaam": "40 - Originele factuur - 12276549450071 (2).pdf" }, { "van": "klant", "datum": "2026-04-22", "chatId": "31639782455@s.whatsapp.net", "chatNaam": "+31 *********", "bestandsnaam": "43 - Originele factuur - 72266068009071 (2).pdf" } ], "updatedAt": "2026-06-14T20:23:38.171Z" } | 1781468618171 |
| 03945c59-260f-45c4-8294-c4bab4ad2e29 | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-05-08", "chatId": "31647458845-1611572640@g.us", "chatNaam": "Hyp: A. Kewalbansing", "bestandsnaam": "pdf_download_05756D6F-87B4-445B-AE4E-F8DE4923147A.pdf" }, { "van": "klant", "datum": "2026-05-08", "chatId": "31647458845-1611572640@g.us", "chatNaam": "Hyp: A. Kewalbansing", "bestandsnaam": "58B8DF4F2B5F43E4A662B4577A1A772D(1).PDF" }, { "van": "adviseur", "datum": "2026-05-08", "chatId": "31647458845-1611572640@g.us", "chatNaam": "Hyp: A. Kewalbansing", "bestandsnaam": "Aangifte_inkomstenbelasting_2025_08-05-2026_13.18u.pdf" } ], "updatedAt": "2026-06-14T20:23:38.121Z" } | 1781468618121 |
| 2b45f125-4056-428d-aa11-e92bd06485de | whatsapp_doc_signalen | { "items": [ { "van": "adviseur", "datum": "2026-05-08", "chatId": "133251461033994@lid", "chatNaam": "Bjorn", "bestandsnaam": "Aangifte_inkomstenbelasting_2025_08-05-2026_13.41u.pdf" } ], "updatedAt": "2026-06-14T20:23:38.074Z" } | 1781468618074 |
| 2f118f6f-05da-462f-8d39-dd947dbdb1fd | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-05-27", "chatId": "85323971309792@lid", "chatNaam": "Raymon Mollink", "bestandsnaam": "versturen stukken aan koper 27-05-2026 08_25_03.pdf" }, { "van": "klant", "datum": "2026-05-27", "chatId": "85323971309792@lid", "chatNaam": "Raymon Mollink", "bestandsnaam": "nota van afrekening koper.pdf" }, { "van": "klant", "datum": "2026-05-27", "chatId": "85323971309792@lid", "chatNaam": "Raymon Mollink", "bestandsnaam": "ontwerp akte van levering.pdf" }, { "van": "klant", "datum": "2026-02-22", "chatId": "31623473839@s.whatsapp.net", "chatNaam": "Raymon Mollink", "bestandsnaam": "20260216 Werkgeversverklaring Raymon Mollink.pdf" }, { "van": "klant", "datum": "2026-02-22", "chatId": "31623473839@s.whatsapp.net", "chatNaam": "Raymon Mollink", "bestandsnaam": "Rotaform (variabel) 2026-01-26 155620.pdf" } ], "updatedAt": "2026-06-14T20:23:38.027Z" } | 1781468618027 |
| 7fced6ad-d4e3-428b-9577-2e38fb3460a5 | whatsapp_doc_signalen | { "items": [ { "van": "adviseur", "datum": "2025-03-14", "chatId": "120363158287384168@g.us", "chatNaam": "HYP: Haverdings - de Ruiter", "bestandsnaam": "Aangifte_inkomstenbelasting_2024_14-03-2025_13.08u.pdf" } ], "updatedAt": "2026-06-14T20:23:37.978Z" } | 1781468617978 |
| 03c102b5-16de-45da-958e-1201eb3da19e | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-06-04", "chatId": "158909646000228@lid", "chatNaam": "Jaleesa Toppin 🤎", "bestandsnaam": "Werkgeversverklaring - J.P.O. Toppin.pdf" }, { "van": "klant", "datum": "2026-06-04", "chatId": "158909646000228@lid", "chatNaam": "Jaleesa Toppin 🤎", "bestandsnaam": "5608EFACD60E44839C1B8080E4D71256.pdf" }, { "van": "klant", "datum": "2026-06-04", "chatId": "158909646000228@lid", "chatNaam": "Jaleesa Toppin 🤎", "bestandsnaam": "1099B549DD8A4BF1BAEDB0B9676CE464.pdf" } ], "updatedAt": "2026-06-14T20:23:37.931Z" } | 1781468617931 |
| 009b5118-80f0-4b2a-a476-6224e9099fd9 | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-06-10", "chatId": "265025403015373@lid", "chatNaam": "Sylvia De Jong", "bestandsnaam": "Betaalspecificatie WIA 11 mei 2026 kopie.pdf" }, { "van": "klant", "datum": "2026-06-10", "chatId": "265025403015373@lid", "chatNaam": "Sylvia De Jong", "bestandsnaam": "Verzekeringsbericht pdj juni 26.pdf" }, { "van": "klant", "datum": "2026-06-10", "chatId": "265025403015373@lid", "chatNaam": "Sylvia De Jong", "bestandsnaam": "ABN AMRO spaar Rekeningafschrift-Volgnr20260005.pdf" }, { "van": "klant", "datum": "2026-06-10", "chatId": "265025403015373@lid", "chatNaam": "Sylvia De Jong", "bestandsnaam": "INg spaarrekening A58767916_09-03-2026_09-06-2026.pdf" }, { "van": "klant", "datum": "2026-06-10", "chatId": "265025403015373@lid", "chatNaam": "Sylvia De Jong", "bestandsnaam": "ING betaal rekening NL05INGB0003061153_09-03-2026_09-06-2026.pdf" }, { "van": "klant", "datum": "2026-06-10", "chatId": "265025403015373@lid", "chatNaam": "Sylvia De Jong", "bestandsnaam": "Amro spaar rekening 3maanden overzicht mutov577872397_10032026-09062026.pdf" }, { "van": "klant", "datum" ... [afgekapt: 566 tekens] | 1781468617883 |
| d1d96ea8-3a18-41f4-ae78-8e24c0cce484 | whatsapp_doc_signalen | { "items": [ { "van": "klant", "datum": "2026-05-18", "chatId": "245672196497634@lid", "chatNaam": "Iza", "bestandsnaam": "FORV.511983.pdf" }, { "van": "klant", "datum": "2026-05-18", "chatId": "245672196497634@lid", "chatNaam": "Iza", "bestandsnaam": "Jaaropgave.pdf" }, { "van": "klant", "datum": "2026-05-26", "chatId": "245672196497634@lid", "chatNaam": "Iza", "bestandsnaam": "Getekende offerte Persoonlijke Lening(1).pdf" }, { "van": "klant", "datum": "2026-05-26", "chatId": "245672196497634@lid", "chatNaam": "Iza", "bestandsnaam": "Getekende offerte Persoonlijke Lening(2).pdf" }, { "van": "klant", "datum": "2026-04-30", "chatId": "31687087430@s.whatsapp.net", "chatNaam": "Iza", "bestandsnaam": "rapport_8245ER_34_29-04-2026.pdf" }, { "van": "klant", "datum": "2026-04-29", "chatId": "31687087430@s.whatsapp.net", "chatNaam": "Iza", "bestandsnaam": "Statements.pdf" }, { "van": "klant", "datum": "2026-04-29", "chatId": "31687087430@s.whatsapp.net", "chatNaam": "Iza", "bestandsnaam": "Salarisstrook-988623-2026-3.pdf" }, { "van": "klant", "datum": "2026-04-29", ... [afgekapt: 1687 tekens] | 1781468617810 |
| 77e67854-ec33-4481-aebf-b5211210863d | workflow_v1 | { "flags": [], "actions": [], "lastDerived": { "at": "2026-06-14T19:50:43.209Z", "phase": "F00_lead" }, "uitvraagReminders": [] } | 1781466643210 |
| 9711d808-3b75-4d54-8f0b-8d56072af018 | workflow_v1 | { "flags": [], "actions": [], "lastDerived": { "at": "2026-06-14T19:50:43.204Z", "phase": "F00_lead" }, "uitvraagReminders": [] } | 1781466643204 |
Raw JSON details
Rij 101
{
"dossier_id": "supplier-syntrus-achmea",
"key": "dossier_meta",
"value_json": {
"type": "supplier",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"supplier_id": "syntrus-achmea",
"supplier_name": "Syntrus Achmea",
"allowed_modules": [
"documenten",
"mail"
],
"supplier_category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 102
{
"dossier_id": "supplier-tellius-hypotheken",
"key": "supplier_profile",
"value_json": {
"id": "supplier-tellius-hypotheken",
"name": "Tellius Hypotheken",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"aliases": [
"Tellius Hypotheken",
"Tellius",
"Tellius ToekomstVast Hypotheek"
],
"domains": [
"tellius.nl"
],
"category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 103
{
"dossier_id": "supplier-onderlinge-nederland",
"key": "dossier_meta",
"value_json": {
"type": "supplier",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"supplier_id": "onderlinge-nederland",
"supplier_name": "Onderlinge Nederland",
"allowed_modules": [
"documenten",
"mail"
],
"supplier_category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 104
{
"dossier_id": "supplier-vista",
"key": "supplier_profile",
"value_json": {
"id": "supplier-vista",
"name": "Vista",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"aliases": [
"Vista",
"Vista Hypotheken"
],
"domains": [
"vistahypotheken.nl"
],
"category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 105
{
"dossier_id": "supplier-florius",
"key": "dossier_meta",
"value_json": {
"type": "supplier",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"supplier_id": "florius",
"supplier_name": "Florius",
"allowed_modules": [
"documenten",
"mail"
],
"supplier_category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 106
{
"dossier_id": "supplier-lloyds-bank",
"key": "supplier_profile",
"value_json": {
"id": "supplier-lloyds-bank",
"name": "Lloyds Bank",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"aliases": [
"Lloyds Bank",
"Lloyds"
],
"domains": [
"lloydsbank.nl"
],
"category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 107
{
"dossier_id": "supplier-impact",
"key": "supplier_profile",
"value_json": {
"id": "supplier-impact",
"name": "Impact",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"aliases": [
"Impact",
"Impact Hypotheken"
],
"domains": [
"impacthypotheken.nl"
],
"category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 108
{
"dossier_id": "supplier-uw-garantiestelling",
"key": "dossier_meta",
"value_json": {
"type": "supplier",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"supplier_id": "uw-garantiestelling",
"supplier_name": "Uw Garantiestelling",
"allowed_modules": [
"documenten",
"mail"
],
"supplier_category": "waarborg"
},
"updated_at": 1781718783600
}Rij 109
{
"dossier_id": "supplier-clarian-wonen",
"key": "dossier_meta",
"value_json": {
"type": "supplier",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"supplier_id": "clarian-wonen",
"supplier_name": "Clarian Wonen",
"allowed_modules": [
"documenten",
"mail"
],
"supplier_category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 110
{
"dossier_id": "supplier-florius",
"key": "supplier_profile",
"value_json": {
"id": "supplier-florius",
"name": "Florius",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"aliases": [
"Florius"
],
"domains": [
"florius.nl"
],
"category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 111
{
"dossier_id": "supplier-bijbouwe",
"key": "supplier_profile",
"value_json": {
"id": "supplier-bijbouwe",
"name": "bijBouwe",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"aliases": [
"bijBouwe",
"bij Bouwe"
],
"domains": [
"bijbouwe.nl"
],
"category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 112
{
"dossier_id": "supplier-neo-hypotheken",
"key": "supplier_profile",
"value_json": {
"id": "supplier-neo-hypotheken",
"name": "Neo Hypotheken",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"aliases": [
"Neo Hypotheken",
"N26 NEO Hypotheken",
"N26 Hypotheken"
],
"domains": [
"neohypotheken.nl",
"n26.com"
],
"category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 113
{
"dossier_id": "supplier-bnp-paribas-personal-finance",
"key": "supplier_profile",
"value_json": {
"id": "supplier-bnp-paribas-personal-finance",
"name": "BNP Paribas Personal Finance",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"aliases": [
"BNP Paribas Personal Finance",
"BNP Paribas Hypotheek",
"BNP Paribas"
],
"domains": [
"bnpparibas-pf.nl"
],
"category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 114
{
"dossier_id": "supplier-onderlinge-nederland",
"key": "supplier_profile",
"value_json": {
"id": "supplier-onderlinge-nederland",
"name": "Onderlinge Nederland",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"aliases": [
"Onderlinge Nederland",
"Onderlinge 's-Gravenhage",
"Onderlinge Gravenhage",
"ZilverHuis Hypotheek",
"ZilverHuis"
],
"domains": [
"onderlingenederland.nl",
"onderlinge.info",
"ogmail.nl"
],
"category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 115
{
"dossier_id": "supplier-nhg",
"key": "dossier_meta",
"value_json": {
"type": "supplier",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"supplier_id": "nhg",
"supplier_name": "NHG",
"allowed_modules": [
"documenten",
"mail"
],
"supplier_category": "waarborg"
},
"updated_at": 1781718783600
}Rij 116
{
"dossier_id": "supplier-bnp-paribas-personal-finance",
"key": "dossier_meta",
"value_json": {
"type": "supplier",
"source": "C:/Users/rdzwa/OneDrive/PC-Rogier/Hypotheek/Database/DATABASE_INDEX.md",
"supplier_id": "bnp-paribas-personal-finance",
"supplier_name": "BNP Paribas Personal Finance",
"allowed_modules": [
"documenten",
"mail"
],
"supplier_category": "geldverstrekker"
},
"updated_at": 1781718783600
}Rij 117
{
"dossier_id": "009b5118-80f0-4b2a-a476-6224e9099fd9",
"key": "financieringsopzet",
"value_json": {
"activeId": "proposal-d18d1d45-2b26-4e07-97e1-d06fbef17fde",
"voorstellen": [
{
"id": "d8135949-817f-4280-bce6-761b5616df67",
"naam": "Voorstel 1",
"kosten": {
"koopsom": "",
"taxatie": "",
"kadaster": "",
"meerwerk": "",
"boeterente": "",
"verbouwing": "",
"bankgarantie": "",
"nhgBorgtocht": "",
"overigKosten": "",
"roerendeZaken": "",
"aankoopmakelaar": "",
"hypotheekadvies": "",
"uitkoopExPartner": "",
"aflossingBestaand": "",
"bouwkundigeKeuring": "",
"notarisHypotheekakte": "",
"notarisLeveringsakte": "",
"overdrachtsbelasting": ""
},
"status": "draft",
"notitie": "",
"leningdelen": [
{
"id": "inventarisatie-nieuw",
"box": "1",
"nhg": "Ja",
"type": "Nieuw",
"rente": "4.05",
"hoofdsom": "253966.00",
"aflosvorm": "Annuiteit",
"aftrekPct": "100",
"einddatum": "",
"box1Bedrag": "",
"box3Bedrag": "",
"deelBox1Pct": "",
"deelBox3Pct": "",
"productnaam": "",
"ingangsdatum": "",
"leningnummer": "",
"rentevariant": "Rentevast",
"restverschil": "",
"arrangementCd": "1",
"looptijdJaren": "30",
"uwBemiddeling": "Ja",
"brutoMaandlast": "1220",
"einddatumRente": "",
"rentevastJaren": "10",
"einddatumAftrek": "",
"geldverstrekker": "Merius",
"looptijdMaanden": "",
"automRentedaling": true,
"beginRenteaftrek": "",
"extraAflossingen": "",
"maatschappijCode": "ME",
"besparingPerMaand": "",
"schuldenaarPartner": false,
"waarvanConsumptief": "",
"tussenpersoonnummer": "",
"maandlastNaAflossing": "",
"schuldenaarAanvrager": true,
"restschuldNaAflossing": "",
"fiscaalEigenaarPartner": false,
"aflossingBijOverbrugging": "",
"fiscaalEigenaarAanvrager": true,
"restschuldBijOverbrugging": ""
}
],
"financiering": {
"bouwdepot": "",
"schenking": "",
"hypotheek1": "253966.00",
"hypotheek2": "",
"eigenMiddelen": "",
"verkoopopbrengst": "",
"overigFinanciering": "",
"overbruggingskrediet": ""
},
"vergelijking": {
"box3": "",
"wozWaarde": "",
"overwaarde": "",
"statusOfferte": "",
"verkoopwaarde": "",
"verkoopCourtage": "",
"verlengingNodig": "",
"huidigeHypotheek": "",
"overdrachtsdatum": "",
"renteaanbodDatum": "",
"bankgarantiedatum": "",
"geldDatOverblijft": "",
"overbruggingRente": "",
"resterendVerschil": "",
"eigenwoningforfait": "",
"ontbindenVoorwaarden": "",
"resterendeOverwaarde": "",
"doorlopendeHypotheken": "",
"eigenwoningschuldBox1": "",
"geldigTotNaVerlenging": "",
"geldigheidAanbodWeken": "2",
"overbruggingMaandlast": "",
"bemiddelingsvergoeding": "",
"bindendeOfferteMaanden": "3",
"overbruggingPercentage": "90",
"overbruggingMarktwaarde": "",
"huidigOnderpandMaandlast": "",
"verlengingOfferteMaanden": "3",
"bereidstellingsprovisiePct": "0,20",
"huidigOnderpandMarktwaarde": "",
"overbruggingLooptijdMaanden": "24",
"bereidstellingskostenIndicatie": ""
},
"arrangementCd": "1",
"geldverstrekker": "Merius",
"maatschappijCode": "ME",
"selectedProductCodes": [
"hypotheek"
],
"seededFromInventarisatie": true
},
{
"id": "hdn-aangevraagd-8huh9j",
"naam": "Aangevraagd uit HDN",
"kosten": {
"koopsom": "586200",
"verbouwing": "0.00"
},
"status": "draft",
"notitie": "Bron: HDN aangevraagd. Automatisch als apart voorstel vastgelegd en breed gevuld uit de HDN-aanvraag/objectgegevens zodat gewijzigde bedragen of voorwaarden als nieuw aangevraagd-voorstel vergelijkbaar blijven.",
"leningdelen": [
{
"id": "hdn-aangevraagd-leningdeel-nhu5wm-1",
"box": "1",
"nhg": "NHG",
"type": "Nieuw",
"rente": "4.05",
"hoofdsom": "253966.00",
"aflosvorm": "Aflossingsvrij, Annuitair",
"looptijdJaren": "30",
"rentevastJaren": "10",
"geldverstrekker": "Merius Hypotheken"
}
],
"financiering": {
"hypotheek1": "253966.00"
},
"vergelijking": {},
"arrangementCd": "",
"geldverstrekker": "Merius Hypotheken",
"maatschappijCode": "",
"selectedProductCodes": [
"hypotheek"
]
},
{
"id": "proposal-d18d1d45-2b26-4e07-97e1-d06fbef17fde",
"naam": "Aankoop bestaande bouw (automatisch klaargezet) - voorstel 1",
"kosten": {
"koopsom": "586200",
"taxatie": "",
"kadaster": "",
"meerwerk": "",
"boeterente": "",
"verbouwing": "",
"bankgarantie": "",
"nhgBorgtocht": "",
"overigKosten": "",
"roerendeZaken": "",
"aankoopmakelaar": "",
"hypotheekadvies": "",
"uitkoopExPartner": "",
"a ... [afgekapt: 3622 tekens]Rij 118
{
"dossier_id": "009b5118-80f0-4b2a-a476-6224e9099fd9",
"key": "hdn_dossier",
"value_json": {
"schema": "adviestool.hdn_like",
"bronnen": {
"partijen.p1.contact.email": [
{
"at": 1781647194538,
"value": "sylvia@famdejong.net",
"context": "inventarisatie.a1.email",
"confidence": 0.55,
"sourceKind": "inventarisatie"
}
],
"hypotheken.aangevraagd.nhg": [
{
"at": 1781647194539,
"value": "NHG",
"context": "inventarisatie.data.aanvraag_nhg",
"confidence": 0.55,
"sourceKind": "inventarisatie"
},
{
"at": 1781647194539,
"value": "NHG",
"context": "base_import.products[].norm",
"confidence": 0.68,
"sourceKind": "extractie"
},
{
"at": 1780494316520,
"value": "Nee",
"context": "hdn_download_inbox.threads.object:langevelderslag808223pelelystad:pdejong.offer.nhg",
"confidence": 0.88,
"sourceKind": "hdn_download"
}
],
"hypotheken.aangevraagd.rente": [
{
"at": 1781647194539,
"value": "4.05",
"context": "inventarisatie.data.aanvraag_rente",
"confidence": 0.55,
"sourceKind": "inventarisatie"
},
{
"at": 1780494316520,
"value": "4.05",
"context": "hdn_download_inbox.threads.object:langevelderslag808223pelelystad:pdejong.offer.rentePct",
"confidence": 0.88,
"sourceKind": "hdn_download"
}
],
"partijen.p1.woonadres.plaats": [
{
"at": 1781647194537,
"value": "Lelystad",
"context": "inventarisatie.a1.woonplaats",
"confidence": 0.55,
"sourceKind": "inventarisatie"
},
{
"at": 1780509082625,
"label": "Adres werknemer",
"value": "Lelystad",
"fileId": "7995727e-1386-4f6d-b7b3-c9a9bd1c6113",
"context": "partijen.p1.woonadres.adresregel",
"accepted": false,
"fileName": "Koopovereenkomst_-_Langevelderslag_80.pdf",
"itemIndex": 15,
"confidence": 0.7799999999999999,
"sourceKind": "extractie",
"sourceText": "",
"sourceBoxes": [],
"canonicalKey": "employee_address"
}
],
"partijen.p2.woonadres.plaats": [
{
"at": 1781647194538,
"value": "Lelystad",
"context": "inventarisatie.a2.woonplaats",
"confidence": 0.55,
"sourceKind": "inventarisatie"
}
],
"partijen.p1.woonadres.postcode": [
{
"at": 1781647194537,
"value": "8243 HV",
"context": "inventarisatie.a1.postcode",
"confidence": 0.55,
"sourceKind": "inventarisatie"
},
{
"at": 1780509082625,
"label": "Adres werknemer",
"value": "8243 HV",
"fileId": "7995727e-1386-4f6d-b7b3-c9a9bd1c6113",
"context": "partijen.p1.woonadres.adresregel",
"accepted": false,
"fileName": "Koopovereenkomst_-_Langevelderslag_80.pdf",
"itemIndex": 15,
"confidence": 0.7799999999999999,
"sourceKind": "extractie",
"sourceText": "",
"sourceBoxes": [],
"canonicalKey": "employee_address"
}
],
"partijen.p2.woonadres.postcode": [
{
"at": 1781647194538,
"value": "8243 HV",
"context": "inventarisatie.a2.postcode",
"confidence": 0.55,
"sourceKind": "inventarisatie"
}
],
"hypotheken.aangevraagd.hoofdsom": [
{
"at": 1781647194538,
"value": "253966.00",
"context": "inventarisatie.data.aanvraag_hoofdsom",
"confidence": 0.55,
"sourceKind": "inventarisatie"
},
{
"at": 1781647194539,
"value": "253966.00",
"context": "base_import.products[].inhoud",
"confidence": 0.68,
"sourceKind": "extractie"
},
{
"at": 1780494316520,
"value": "33520000",
"context": "hdn_download_inbox.threads.object:langevelderslag808223pelelystad:pdejong.offer.hypotheekBedrag",
"confidence": 0.88,
"sourceKind": "hdn_download"
},
{
"at": 1781265847385,
"label": "Hoofdsom",
"value": "375000",
"fileId": "ocrexp-fd1995bbcdbf",
"context": "hypotheken.aangevraagd.hoofdsom",
"accepted": false,
"fileName": "Kifid-2025-0562-verhuisregeling.pdf",
"itemIndex": 2,
"confidence": 0.7,
"sourceKind": "extractie",
"sourceText": "",
"sourceBoxes": [],
"canonicalKey": "mortgage_principal_amount"
},
{
"at": 1781265824906,
"label": "Hoofdsom",
"value": "504531",
"fileId": "ocrexp-e031a1b1f598",
"context": "hypotheken.aangevraagd.hoofdsom",
"accepted": false,
"fileName": "Kifid-2024-0479-meeneemrente.pdf",
"itemIndex": 2,
"confidence": 0.7,
"sourceKind": "extractie",
"sourceText": "",
"sourceBoxes": [],
"canonicalKey": "mortgage_principal_amount"
},
{
"at": 1781265818029,
"label": "Hoofdsom",
"value": "504531",
"fileId": "ocrexp-d93e2adf1485",
"context": "hypotheken.aangevraagd.hoofdsom",
"accepted": false,
"fileName": "Kifid-2024-0479-meeneemrente_ocred-compressed.pdf",
"itemIndex": 2,
"confidence": 0.7,
"sourceKind": "extractie",
"sourceText": "",
"sourceBoxes": [],
"canonicalKey": "mo ... [afgekapt: 434264 tekens]Rij 119
{
"dossier_id": "009b5118-80f0-4b2a-a476-6224e9099fd9",
"key": "_sources",
"value_json": {
"aov.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-11T04:51:43.805Z"
},
"orv.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-11T04:51:35.662Z"
},
"aov.producten": {
"source": "Eigen invoer",
"updated_at": "2026-06-16T12:53:07.861Z"
},
"upload3-trash.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-10T10:59:14.985Z"
},
"aanvraagproces.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-03T08:57:05.471Z"
},
"aanvraagproces.status": {
"source": "Eigen invoer",
"updated_at": "2026-06-10T16:53:42.220Z"
},
"aanvraagproces.history": {
"source": "Eigen invoer",
"updated_at": "2026-06-13T14:33:32.627Z"
},
"advies-motivering.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-04T09:49:45.385Z"
},
"inventarisatie.products": {
"source": "Eigen invoer",
"updated_at": "2026-06-10T15:16:43.136Z"
},
"advies-onderwerpen.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-04T09:49:45.237Z"
},
"financieringsopzet.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-03T17:14:55.650Z"
},
"hypotheek-algemeen.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-11T04:51:10.896Z"
},
"inventarisatie.a1.straat": {
"source": "Logscan: Straatnaam uit Jaaropgaaf 2025 uwv sdj.pdf (Adres werknemer)",
"updated_at": "2026-06-07T08:06:03.462Z"
},
"inventarisatie.a1.whatsapp": {
"source": "Eigen invoer",
"updated_at": "2026-06-11T14:22:38.815Z"
},
"financieringsopzet.activeId": {
"source": "Eigen invoer",
"updated_at": "2026-06-16T11:48:23.261Z"
},
"inventarisatie.passeerdatum": {
"source": "Logscan: Passeerdatum / transportdatum uit Koopovereenkomst_-_Langevelderslag_80.pdf (Tekstpatroon)",
"updated_at": "2026-06-03T19:27:49.628Z"
},
"inventarisatie.toetsinkomen": {
"source": "Logscan: Toetsinkomen / jaarinkomen uit Jaaropgaaf 2025 uwv sdj.pdf (Bruto jaarsalaris)",
"updated_at": "2026-06-07T08:06:03.462Z"
},
"inventarisatie.a1.huisnummer": {
"source": "Logscan: Huisnummer uit Jaaropgaaf 2025 uwv sdj.pdf (Adres werknemer)",
"updated_at": "2026-06-07T08:06:03.462Z"
},
"inventarisatie.inc1.payrolls": {
"source": "Eigen invoer",
"updated_at": "2026-06-11T17:57:16.493Z"
},
"inventarisatie.inc2.payrolls": {
"source": "Eigen invoer",
"updated_at": "2026-06-11T17:57:16.493Z"
},
"inventarisatie.onderpand_woz": {
"source": "Logscan: WOZ-waarde uit Aangifte_inkomstenbelasting_2025 gezamelijk_04-03-2026_11.26u.pdf (WOZ-waarde)",
"updated_at": "2026-06-05T14:40:46.016Z"
},
"inventarisatie.soort_aanvraag": {
"source": "Logscan: Aanvraagsoort uit Koopovereenkomst_-_Langevelderslag_80.pdf (Tekstpatroon)",
"updated_at": "2026-06-03T19:27:49.628Z"
},
"financieringsopzet.voorstellen": {
"source": "Eigen invoer",
"updated_at": "2026-06-16T12:00:51.057Z"
},
"inventarisatie.onderpand_adres": {
"source": "Logscan: Straat onderpand uit Koopovereenkomst_-_Langevelderslag_80.pdf (Betreft)",
"updated_at": "2026-06-03T19:27:49.628Z"
},
"inventarisatie.onderpand_soort": {
"source": "Logscan: Woningtype uit Koopovereenkomst_-_Langevelderslag_80.pdf (Woningtype)",
"updated_at": "2026-06-05T14:40:46.016Z"
},
"inventarisatie.a1.geboortedatum": {
"source": "Eigen invoer",
"updated_at": "2026-06-11T17:57:16.493Z"
},
"aanvraagproces.aanvraagOverrides": {
"source": "Eigen invoer",
"updated_at": "2026-06-05T10:49:38.401Z"
},
"inventarisatie.a1.geboorteplaats": {
"source": "Eigen invoer",
"updated_at": "2026-06-11T17:57:16.493Z"
},
"inventarisatie.data.aanvraag_nhg": {
"source": "HDN-dossierlaag",
"hdn_path": "hypotheken.aangevraagd.nhg",
"updated_at": "2026-06-03T18:35:43.715Z"
},
"inventarisatie.onderpand_koopsom": {
"source": "Logscan: Koopsom uit Koopovereenkomst_-_Langevelderslag_80.pdf (Koopsom)",
"updated_at": "2026-06-03T19:27:49.628Z"
},
"inventarisatie.onderpand_postcode": {
"source": "Logscan: Postcode uit Koopovereenkomst_-_Langevelderslag_80.pdf (Betreft)",
"updated_at": "2026-06-03T19:39:42.015Z"
},
"aanvraagproces.selectedAanvraagKey": {
"source": "Eigen invoer",
"updated_at": "2026-06-13T14:33:32.627Z"
},
"inventarisatie.data.aanvraag_rente": {
"source": "HDN-dossierlaag",
"hdn_path": "hypotheken.aangevraagd.rente",
"updated_at": "2026-06-04T12:24:53.928Z"
},
"inventarisatie.a1.legitimatiebewijs": {
"source": "Logscan: Legitimatiebewijs uit Koopovereenkomst_-_Langevelderslag_80.pdf (Legitimatiebewijs)",
"updated_at": "2026-06-03T19:27:49.628Z"
},
"inventarisatie.onderpand_huisnummer": {
"source": "Logscan: Huisnummer uit Koopovereenkomst_-_Langevelderslag_80.pdf (Betreft)",
"updated_at": "2026-06-03T19:27:49.628Z"
},
"inventarisatie.onderpand_woonplaats": {
"source": "Logscan: Plaats uit Koopovereenkomst_-_Langevelderslag_80.pdf (Betreft)",
"updated_at": "2026-06-03T19:39:42.015Z"
},
"inventarisatie.aanvraag_bankgarantie": {
"source": "Logscan: Bankgarantie/waarborgsom uit Koopovereenkomst_-_Langevelderslag_80.pdf (Bankgarantie/waarborgsom)",
"updated_at": "2026-06-05T14:40:46.016Z"
},
"financieringsopzet.selectedProposalId": {
"source": "Eigen invoer",
"updated_at": "2026-06-16T11:48:23.261Z"
},
"inventarisatie.data.aanvraag_hoofdsom": {
"source": "HDN-dossierlaag",
"hdn_ ... [afgekapt: 12481 tekens]Rij 120
{
"dossier_id": "009b5118-80f0-4b2a-a476-6224e9099fd9",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Graaf, Sylvia van der (S)",
"adres": "Stadseiland 100",
"email": "sylvia@famdejong.net",
"straat": "Stadseiland",
"postcode": "8243 HV",
"whatsapp": "06-45782733",
"huisnummer": "100",
"woonplaats": "Lelystad",
"telefoon_prive": "0622375220",
"legitimatiebewijs": "Paspoort"
},
"a2": {
"naam": "Jong, Peter de (P)",
"adres": "Stadseiland 100",
"postcode": "8243 HV",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": {
"0": {
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "253966.00",
"status": "Lopend",
"artikel": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
"maatschappij": "Merius Hypotheken",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "3013205",
"passeeringangsdatum": "2019-09-18"
},
"1": {
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2019-07-11"
},
"2": {
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
"tekendatum": "25569",
"productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
"maatschappij": "Credit Life",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "7001195018",
"passeeringangsdatum": "2019-09-01"
}
},
"aanvraag_nhg": "NHG",
"passeerdatum": "2026-11-02",
"toetsinkomen": 20323,
"crmdossier_id": "197890",
"dossiernummer": "197890",
"dossierstatus": "Actief",
"onderpand_woz": "422000",
"aanvraag_rente": "4.05",
"producten_bron": "Excel klantenoverzicht",
"soort_aanvraag": "Bestaande bouw",
"onderpand_adres": "Langevelderslag",
"onderpand_soort": "eengezinswoning",
"aanvraag_hoofdsom": "253966.00",
"aanvraag_looptijd": "360",
"onderpand_koopsom": 586200,
"onderpand_postcode": "8223 PE",
"aanvraag_productnaam": "Aflossingsvrij, Annuitair",
"onderpand_huisnummer": "80",
"onderpand_woonplaats": "Lelystad",
"aanvraag_bankgarantie": "58620,00",
"onderpand_marktwaarde": "282352",
"aanvraag_geldverstrekker": "Merius Hypotheken",
"aanvraag_rentevastperiode": "120",
"ontbindende_voorwaarden_tot": "2026-06-18",
"aanvraag_bedrag_inschrijving": "253966.00"
},
"inc1": {
"id": "inc1",
"type": "loondienst",
"fields": {
"ww_dagloon": "78",
"aov_iva_pct": "75",
"aov_ao_klasse": "65",
"orv_inkomen_nu": "20.323",
"ww_sv_maandloon": "1.694",
"aov_wia_maandloon": "1.694",
"bruto_jaarsalaris": "20323",
"aov_lgu_daarna_pct": "70",
"vakantiegeld_analyse": "Onzeker",
"dienstverband_analyse": "Nee of onvoldoende bewijs",
"twk_correctie_analyse": "Nee, niet herkend",
"dga_ondernemer_analyse": "Onzeker",
"salarisperiode_analyse": "Onzeker",
"totaal_bruto_jaarinkomen": "20.323",
"variabel_inkomen_analyse": "Nee, niet herkend op deze salarisstrook",
"netto_inhoudingen_analyse": "Geen standaardinhoudingen herkend",
"ww_huidig_bruto_jaarinkomen": "20.323",
"ww_maximumdagloon_toepassen": "Ja",
"aov_huidig_bruto_jaarinkomen": "20.323",
"aov_lgu_eerste_2_maanden_pct": "75",
"ww_huidig_netto_maandinkomen": "1.152",
"aov_huidig_netto_maandinkomen": "1.152",
"aov_loondoorbetaling_jaar1_pct": "70",
"aov_loondoorbetaling_jaar2_pct": "70",
"reiskosten_toetsinkomen_analyse": "Niet van toepassing op deze strook",
"aov_loongerelateerd_duur_maanden": "24"
},
"salaris": {
"netto_loon": "1.256,16",
"loonheffing": "293,75",
"bruto_periode": "1.549,91"
},
"payrolls": []
},
"inc2": {
"id": "inc2",
"type": "loondienst",
"fields": {
"aov_iva_pct": "75",
"aov_ao_klasse": "65",
"aov_lgu_daarna_pct": "70",
"ww_maximumdagloon_toepassen": "Ja",
"aov_lgu_eerste_2_maanden_pct": "75",
"aov_loondoorbetaling_jaar1_pct": "70",
"aov_loondoorbetaling_jaar2_pct": "70",
"aov_loongerelateerd_duur_maanden": "24"
},
"payrolls": []
},
"incomes": {
"A1": {
"inc1": {
"id": "inc1",
"type": "loondienst",
"fields": {
"aov_iva_pct": "75",
"aov_ao_klasse": "65",
"bruto_jaarsalaris": "20323",
"aov_lgu_daarna_pct": "70",
"vakantiegeld_analyse": "Onzeker",
"dienstverband_analyse": "Nee of onvoldoende bewijs",
"twk_correctie_analyse": "Nee, niet herkend",
"dga_ondernemer_analyse": "Onzeker",
"salarisperiode_analyse": "Onzeker",
"variabel_inkomen_analyse": "Nee, niet herkend op deze salarisstrook",
"netto_inhoudingen_analyse": "Geen standaardinhoudingen herkend",
"ww_maximumd ... [afgekapt: 2562 tekens]Rij 121
{
"dossier_id": "009b5118-80f0-4b2a-a476-6224e9099fd9",
"key": "aov",
"value_json": {
"producten": []
},
"updated_at": 1781614387861
}Rij 122
{
"dossier_id": "6cdf1a8b-d6b0-4881-b6ca-2c7fb45c4771",
"key": "financieringsopzet",
"value_json": {
"activeId": "voorstel-oha-uitkoop",
"voorstellen": [
{
"id": "voorstel-oha-uitkoop",
"naam": "OHA + uitkoop ex-partner (ING)",
"kosten": {
"koopsom": "",
"taxatie": "600",
"kadaster": "200",
"meerwerk": "",
"boeterente": "",
"verbouwing": "",
"bankgarantie": "",
"nhgBorgtocht": "",
"overigKosten": "",
"roerendeZaken": "",
"aankoopmakelaar": "",
"hypotheekadvies": "2.500",
"uitkoopExPartner": "160.551",
"aflossingBestaand": "",
"bouwkundigeKeuring": "",
"notarisHypotheekakte": "750",
"notarisLeveringsakte": "750",
"overdrachtsbelasting": ""
},
"status": "selected",
"notitie": "AANNAMES (12-06-2026, concept): uitkoopsom 160.551 = helft overwaarde 115.179 (590.000 - 359.642,49 convenant) + helft bankspaarsaldo 45.372 (90.744,36 per 18-12-2025) — definitieve bedragen per leveringsdatum. Verhogingsdeel 165.000 annuïtair @4,00% 10jr RVP = aanname marktconforme ING-rente; kosten geschat (notaris/advies/taxatie/kadaster). Bestaande drie delen lopen door met behoud condities; na OHA alleen aanvrager schuldenaar. LTV na verhoging ±89% (524.729/590.000); netto na bankspaarsaldo ±74%. Aandachtspunt: aflossingsvrij deel was in 2010 'deels consumptief' — box 1/3-verdeling verifiëren. Toetsinkomen standaardmethodiek 11.834 ontoereikend voor verhoging — inkomensverklaring rekenexpert vereist (zie Motivering).",
"leningdelen": [
{
"id": "deel-bankspaar",
"box": "1",
"nhg": "Ja",
"type": "Doorlopend",
"rente": "3,64",
"hoofdsom": "225.000",
"aflosvorm": "Bankspaar",
"aftrekPct": "100",
"einddatum": "01-03-2040",
"box1Bedrag": "",
"box3Bedrag": "",
"deelBox1Pct": "",
"deelBox3Pct": "",
"productnaam": "ING Bankspaarhypotheek (D 090-812655 deel 1)",
"ingangsdatum": "02-02-2010",
"leningnummer": "D 090-812655.1",
"rentevariant": "Rentevast",
"restverschil": "",
"arrangementCd": "",
"looptijdJaren": "",
"uwBemiddeling": "Ja",
"brutoMaandlast": "683",
"einddatumRente": "01-03-2032",
"rentevastJaren": "",
"einddatumAftrek": "",
"geldverstrekker": "ING",
"looptijdMaanden": "",
"automRentedaling": true,
"beginRenteaftrek": "",
"extraAflossingen": "",
"maatschappijCode": "",
"besparingPerMaand": "",
"schuldenaarPartner": false,
"waarvanConsumptief": "",
"tussenpersoonnummer": "",
"maandlastNaAflossing": "",
"schuldenaarAanvrager": true,
"restschuldNaAflossing": "",
"fiscaalEigenaarPartner": false,
"aflossingBijOverbrugging": "",
"fiscaalEigenaarAanvrager": true,
"restschuldBijOverbrugging": ""
},
{
"id": "deel-aflossingsvrij",
"box": "1",
"nhg": "Ja",
"type": "Doorlopend",
"rente": "1,19",
"hoofdsom": "100.000",
"aflosvorm": "Aflossingsvrij",
"aftrekPct": "100",
"einddatum": "01-03-2040",
"box1Bedrag": "",
"box3Bedrag": "",
"deelBox1Pct": "",
"deelBox3Pct": "",
"productnaam": "ING Aflossingsvrij (D 090-812655 deel 2)",
"ingangsdatum": "02-02-2010",
"leningnummer": "D 090-812655.2",
"rentevariant": "Rentevast",
"restverschil": "",
"arrangementCd": "",
"looptijdJaren": "",
"uwBemiddeling": "Ja",
"brutoMaandlast": "99",
"einddatumRente": "01-02-2031",
"rentevastJaren": "",
"einddatumAftrek": "",
"geldverstrekker": "ING",
"looptijdMaanden": "",
"automRentedaling": true,
"beginRenteaftrek": "",
"extraAflossingen": "",
"maatschappijCode": "",
"besparingPerMaand": "",
"schuldenaarPartner": false,
"waarvanConsumptief": "",
"tussenpersoonnummer": "",
"maandlastNaAflossing": "",
"schuldenaarAanvrager": true,
"restschuldNaAflossing": "",
"fiscaalEigenaarPartner": false,
"aflossingBijOverbrugging": "",
"fiscaalEigenaarAanvrager": true,
"restschuldBijOverbrugging": ""
},
{
"id": "deel-annuitair",
"box": "1",
"nhg": "Nee",
"type": "Doorlopend",
"rente": "1,79",
"hoofdsom": "34.728,60",
"aflosvorm": "Annuiteit",
"aftrekPct": "100",
"einddatum": "01-04-2052",
"box1Bedrag": "",
"box3Bedrag": "",
"deelBox1Pct": "",
"deelBox3Pct": "",
"productnaam": "ING Annuïteitenhypotheek (L 105-949929)",
"ingangsdatum": "30-03-2022",
"leningnummer": "L 105-949929",
"rentevariant": "Rentevast",
"restverschil": "",
"arrangementCd": "",
"looptijdJaren": "",
"uwBemiddeling": "Ja",
"brutoMaandlast": "125",
"einddatumRente": "01-04-2032",
"rentevastJaren": "",
"einddatumAftrek": "",
"geldverstrekker": "ING",
"looptijdMaanden": "",
"automRentedaling": true,
"beginRenteaftrek": "", ... [afgekapt: 5042 tekens]Rij 123
{
"dossier_id": "6cdf1a8b-d6b0-4881-b6ca-2c7fb45c4771",
"key": "hdn_dossier",
"value_json": {
"schema": "adviestool.hdn_like",
"bronnen": {
"hypotheken.bestaand1.nhg": [
{
"at": 1781247205075,
"label": "Nationale Hypotheek Garantie",
"value": "Ja",
"fileId": "f642254a-3666-4737-81da-9d3e674316fa",
"context": "hypotheken.bestaand1.nhg",
"accepted": false,
"fileName": "Hypotheekofferte ing Westhoven 2010.pdf",
"itemIndex": 7,
"confidence": 0.7,
"sourceKind": "extractie",
"sourceText": "NHG-status uit offerte.",
"sourceBoxes": [],
"canonicalKey": "mortgage_nhg"
}
],
"hypotheken.aangevraagd.nhg": [
{
"at": 1781610333654,
"value": "Ja",
"context": "inventarisatie.data.aanvraag_nhg",
"confidence": 0.55,
"sourceKind": "inventarisatie"
},
{
"at": 1781265695212,
"label": "Nationale Hypotheek Garantie",
"value": "Ja",
"fileId": "ocrexp-449f115310fd",
"context": "hypotheken.aangevraagd.nhg",
"accepted": false,
"fileName": "2147483647 2.pdf",
"itemIndex": 5,
"confidence": 0.65,
"sourceKind": "extractie",
"sourceText": "Nationale Hypotheek Garantie ja",
"sourceBoxes": [
{
"h": 12.999935999999934,
"w": 239.057051,
"x": 72,
"y": 661.501557,
"page": 1,
"text": "Nationale Hypotheek Garantie ja",
"words": [
{
"text": "Nationale",
"xMax": 115.379787,
"xMin": 72
},
{
"text": "Hypotheek",
"xMax": 166.619536,
"xMin": 117.879775
},
{
"text": "Garantie",
"xMax": 207.679335,
"xMin": 169.119524
},
{
"text": "ja",
"xMax": 311.057051,
"xMin": 303.02709
}
],
"pageWidth": 595.27559,
"pageHeight": 841.88976
}
],
"canonicalKey": "mortgage_nhg"
},
{
"at": 1781247206458,
"label": "Nationale Hypotheek Garantie",
"value": "Ja",
"fileId": "e46b5fbf-90c3-410a-b65a-c4e0f27eebdc",
"context": "hypotheken.aangevraagd.nhg",
"accepted": false,
"fileName": "2147483647 2.pdf",
"itemIndex": 5,
"confidence": 0.65,
"sourceKind": "extractie",
"sourceText": "Nationale Hypotheek Garantie ja",
"sourceBoxes": [
{
"h": 12.999935999999934,
"w": 239.057051,
"x": 72,
"y": 661.501557,
"page": 1,
"text": "Nationale Hypotheek Garantie ja",
"words": [
{
"text": "Nationale",
"xMax": 115.379787,
"xMin": 72
},
{
"text": "Hypotheek",
"xMax": 166.619536,
"xMin": 117.879775
},
{
"text": "Garantie",
"xMax": 207.679335,
"xMin": 169.119524
},
{
"text": "ja",
"xMax": 311.057051,
"xMin": 303.02709
}
],
"pageWidth": 595.27559,
"pageHeight": 841.88976
}
],
"canonicalKey": "mortgage_nhg"
}
],
"bijleenregeling.verkoopprijs": [
{
"at": 1781610333654,
"value": "285000,00",
"context": "inventarisatie.data.bijleen_verkoopprijs",
"confidence": 0.55,
"sourceKind": "inventarisatie"
},
{
"at": 1781247205949,
"label": "Bijleenregeling - verkoopprijs",
"value": "285000,00",
"fileId": "2a059130-d282-4417-baff-1031bec5728d",
"context": "bijleenregeling.verkoopprijs",
"accepted": false,
"fileName": "nota Van den Hoek, 29-01-2009.pdf",
"itemIndex": 0,
"confidence": 0.7,
"sourceKind": "extractie",
"sourceText": "Verkoopprijs/opbrengst uit document.",
"sourceBoxes": [],
"canonicalKey": "bijleen_sale_price"
},
{
"at": 1781247205839,
"label": "Bijleenregeling - verkoopprijs",
"value": "285000,00",
"fileId": "37c4fc74-25f5-42cb-8a64-fa8ec0969f81",
"context": "bijleenregeling.verkoopprijs",
"accepted": false,
"fileName": "Afrekening notaris.pdf",
"itemIndex": 0,
"confidence": 0.7,
"sourceKind": "extractie",
"sourceText": "Verkoopprijs/opbrengst uit document.",
"sourceBoxes": [],
"canonicalKey": "bijleen_sale_price"
},
{
"at": 1781247205075,
"label": "Bijleenregeling - verkoopprijs",
"value": "285000,00",
"fileId": "f642254a-3666-4737-81da-9d3e674316fa",
"context": "bijleenregeling.verkoopprijs",
"accepted": false,
"fileName": "Hypotheekofferte ing Westhoven 2010.pdf",
"itemIndex": 9,
"confidence": 0.7,
"sourceKind": "extractie",
"sourceText": "Verkoopprijs/opbrengst uit document.",
"sourceBoxes": [],
"canonicalKey": "bijleen_sale_price"
}
],
"hypotheken.aangevraagd.rente": [
{ ... [afgekapt: 170863 tekens]Rij 124
{
"dossier_id": "6cdf1a8b-d6b0-4881-b6ca-2c7fb45c4771",
"key": "_sources",
"value_json": {
"klantprofiel.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:40:46.365Z"
},
"aanvraagproces.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:24:35.055Z"
},
"inventarisatie.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:08:40.998Z"
},
"inventarisatie.inc1.id": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T13:55:09.259Z"
},
"inventarisatie.inc2.id": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T09:08:55.063Z"
},
"advies-motivering.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:09:33.137Z"
},
"klantprofiel.aanleiding": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:42:28.333Z"
},
"advies-onderwerpen.value": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:10:31.006Z"
},
"inventarisatie.inc1.type": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T13:55:09.259Z"
},
"inventarisatie.incomes.A2": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T09:08:55.063Z"
},
"financieringsopzet.activeId": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:22:42.159Z"
},
"inventarisatie.inc1.payrolls": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T09:08:55.063Z"
},
"inventarisatie.inc2.payrolls": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T09:08:55.063Z"
},
"inventarisatie.data.orv_actie": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:23:34.568Z"
},
"inventarisatie.data.orv_polis": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:23:34.568Z"
},
"klantprofiel.hypotheek_doelen": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:42:28.333Z"
},
"financieringsopzet.voorstellen": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:48:31.004Z"
},
"inventarisatie.incomes.A1.inc1": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T14:17:05.326Z"
},
"inventarisatie.incomes.A1.ond2": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T14:33:57.365Z"
},
"klantprofiel.financiele_doelen": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:42:28.333Z"
},
"advies-motivering.overlijden_a1": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:23:35.351Z"
},
"advies-motivering.overlijden_a2": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:23:35.351Z"
},
"inventarisatie.inc1.jaarcijfers": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T13:46:18.313Z"
},
"inventarisatie.inc1.payrollYear": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T09:08:55.063Z"
},
"inventarisatie.data.aanvraag_nhg": {
"source": "HDN-dossierlaag",
"hdn_path": "hypotheken.aangevraagd.nhg",
"updated_at": "2026-06-12T13:52:46.529Z"
},
"klantprofiel.wijziging_werkgever": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:42:28.333Z"
},
"inventarisatie.data.aanvraag_rente": {
"source": "HDN-dossierlaag",
"hdn_path": "hypotheken.aangevraagd.rente",
"updated_at": "2026-06-12T13:52:46.529Z"
},
"inventarisatie.inc1.fields.branche": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T09:08:55.063Z"
},
"inventarisatie.incomes.A1.ond1.cao": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T09:08:55.063Z"
},
"inventarisatie.incomes.A1.ond2.cao": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T14:47:39.589Z"
},
"inventarisatie.inc1.beoordelingstijl": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T09:08:55.063Z"
},
"inventarisatie.inc1.jaarcijfers.2022": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T13:46:20.516Z"
},
"inventarisatie.inc1.jaarcijfers.2023": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T13:46:23.979Z"
},
"inventarisatie.inc1.jaarcijfers.2024": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T13:46:30.370Z"
},
"inventarisatie.inc1.jaarcijfers.2025": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T14:48:33.949Z"
},
"financieringsopzet.selectedProposalId": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T07:22:42.159Z"
},
"inventarisatie.data.aanvraag_hoofdsom": {
"source": "HDN-dossierlaag",
"hdn_path": "hypotheken.aangevraagd.hoofdsom",
"updated_at": "2026-06-12T13:52:46.529Z"
},
"inventarisatie.inc1.fields.rechtsvorm": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T09:08:55.063Z"
},
"inventarisatie.inc1.fields.aandeel_pct": {
"source": "Eigen invoer",
"updated_at": "2026-06-12T14:47:39.589Z"
},
"inventarisatie.inc1.fields.aov_iva_pct": {
"label": "IVA percentage",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-06-12T07:10:28.518Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc2.fields.aov_iva_pct": {
"label": "IVA percentage",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-06-12T07:10:28.518Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.data.woning1_marktwaarde": {
"source": "HDN-dossierlaag",
"hdn_path": "objecten.huidigeWoning1.waarde.marktwaarde",
"updated_at": "2026-06-12T13:52:46.529Z"
},
"inventarisatie.inc1.fields.winst_jaar_1": {
"source": "Eigen invoer", ... [afgekapt: 31594 tekens]Rij 125
{
"dossier_id": "6cdf1a8b-d6b0-4881-b6ca-2c7fb45c4771",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Hoek, Robert van den (R.)",
"adres": "Westhoven 38",
"straat": "Westhoven",
"geslacht": "M",
"postcode": "8219 AH",
"huisnummer": "38",
"woonplaats": "LELYSTAD",
"geboorteland": "Nederland",
"geboortedatum": "07-11-1967",
"nationaliteit": "Nederlandse",
"burgerlijke_staat": "Gescheiden (huwelijk ontbonden 03-06-2026, inschrijving 's-Gravenhage)"
},
"a2": {
"rol": "Vertrekkende partner — te ontslaan uit hoofdelijke aansprakelijkheid",
"naam": "Veldhuisen, Saskia (S.)",
"adres": "Westhoven 38",
"geslacht": "V",
"postcode": "8219 AH",
"woonplaats": "LELYSTAD",
"geboortedatum": "30-04-1973"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"orv_actie": "Bij OHA: polis aanpassen — verzekerde/begunstigde ex-partner eraf of nieuwe polis op alleen aanvrager; verpanding ING continueren",
"orv_polis": "a.s.r. (v/h Fortis ASR) polis 70521797, gelijkblijvend EUR 200.000 op beide levens, verpand aan ING (inpandgeving 28-01-2010)",
"aanvraag_nhg": "Ja",
"dossierstatus": "Actief",
"aanvraag_rente": "3,64%",
"soort_aanvraag": "Ontslag hoofdelijke aansprakelijkheid + uitkoop ex-partner",
"bankspaar_saldo": "90.744,36 (S 157-25326 per 18-12-2025, doelkapitaal 225.000)",
"convenant_datum": "11-02-2026 (getekend); beschikking 15-05-2026; ontbinding huwelijk 03-06-2026",
"incomeSelection": {
"A1": {
"primaryIncomeId": "ond1"
}
},
"onderpand_adres": "Westhoven 38",
"onderpand_soort": "Eengezinswoning (kadastraal Lelystad P 5110, 3a 86ca)",
"uitkoop_afspraak": "Helft overwaarde + helft bankspaarsaldo aan ex-partner bij levering (convenant art. 2.8/2.10); indicatief 115.179 + 45.372 = 160.551",
"aanvraag_hoofdsom": "34728.6",
"onderpand_koopsom": "285.000",
"onderpand_postcode": "8219 AH",
"woning1_eigen_huur": "Eigen woning (ieder 1/2, toedeling aan aanvrager per convenant)",
"bestaande_aktedatum": "02-02-2010",
"woning1_marktwaarde": "375000",
"aanvraag_productnaam": "Aflossingsvrij",
"bijleen_verkoopprijs": "285000,00",
"onderpand_huisnummer": "38",
"onderpand_woonplaats": "Lelystad",
"onderpand_marktwaarde": "590.000",
"aanvraag_geldverstrekker": "ING",
"bestaande_hypotheek_bank": "ING",
"bestaande_hypotheek_delen": "D 090-812655 deel 1 bankspaar 225.000 @3,64% RVP tot 01-03-2032 (NHG) | D 090-812655 deel 2 aflossingsvrij 100.000 @1,19% RVP tot 01-02-2031 (NHG) | L 105-949929 annuitair 34.728,60 @1,79% RVP tot 01-04-2032 (geen NHG)",
"bestaande_hypotheek_restant": "359.728,60 (saldo-opgaven ING 18-12-2025; convenant: 359.642,49 per 30-01-2026)",
"bijleen_afgeloste_hypotheek": "337500,00",
"bestaande_hypotheek_maandlast": "1.250,68 (1.112,77 + 137,91) excl. bankspaarinleg 331,10"
},
"inc1": {
"id": "ond1",
"type": "ondernemer",
"fields": {
"branche": "Systeemmontage / afbouw (badkamers)",
"rechtsvorm": "Eenmanszaak",
"aandeel_pct": "100",
"aov_iva_pct": "75",
"winst_jaar_1": "69.053",
"winst_jaar_2": "50.376",
"winst_jaar_3": "11.834",
"aov_ao_klasse": "65",
"startersaftrek": "Nee",
"naam_onderneming": "Van der Hoek Systeemmontage",
"aov_lgu_daarna_pct": "70",
"boekjaren_toelichting": "jaar_1=2022, jaar_2=2023, jaar_3=2024; winst uit onderneming vóór ondernemersaftrek (IB-aangiftes). 2024 gedrukt door desinvesteringsbijtelling 11.480 en hogere afschrijvingen/lease. BTW-omzet 2025 ±350k; per 02-02-2026 tevens vennoot V.o.f. van Leeuwen-van den Hoek (KvK 99675978).",
"toetsinkomen_verklaring": "19.799",
"ww_maximumdagloon_toepassen": "Ja",
"aov_lgu_eerste_2_maanden_pct": "75",
"berekeningswijze_toetsinkomen": "verklaring",
"aov_loondoorbetaling_jaar1_pct": "70",
"aov_loondoorbetaling_jaar2_pct": "70",
"aov_loongerelateerd_duur_maanden": "24"
},
"jaarcijfers": {
"2021": {
"brutomarge": "102.889",
"netto_omzet": "225.845",
"afschrijvingen": "13.084",
"eigen_vermogen": "32.571",
"kostprijs_omzet": "-122.956",
"liquide_middelen": "22.780",
"bedrijfsresultaat": "54.267",
"som_bedrijfskosten": "48.622",
"prive_onttrekkingen": "-48.509",
"financiele_baten_lasten": "-1.057",
"resultaat_voor_belastingen": "53.210"
},
"2022": {
"brutomarge": "123.712",
"netto_omzet": "241.315",
"afschrijvingen": "12.607",
"eigen_vermogen": "50.276",
"kostprijs_omzet": "-117.603",
"verzamelinkomen": "46.077",
"belastbare_winst": "53.958",
"liquide_middelen": "26.670",
"mkb_vrijstelling": "8.785",
"personeelskosten": "10.800",
"vlottende_activa": "275.654",
"bedrijfsresultaat": "69.871",
"som_bedrijfskosten": "53.841",
"prive_onttrekkingen": "-51.350",
"saldo_fiscale_winst": "69.053",
"zelfstandigenaftrek": "6.310",
"winst_uit_onderneming": "53.958",
"financiele_baten_lasten": "-816",
"resultaat_voor_belastingen": "69.055"
},
"2023": {
"brutomarge": "123.268",
"netto_omzet": "290.050",
"afschrijvingen": "13.204",
"eigen_vermogen": "39.083",
"kostprijs_omzet": "-166.782",
"verzamelinkomen": "42.640",
"winstcorrecties": "-13.819",
"belastbare_winst": "38.997",
"liquide_middelen": "28.649",
"mkb_vr ... [afgekapt: 8285 tekens]Rij 126
{
"dossier_id": "test-state-dossier-1",
"key": "workflow_v1",
"value_json": {
"flags": [],
"actions": [],
"intentApprovedAt": "b",
"intentProposedAt": "a",
"uitvraagReminders": []
},
"updated_at": 1781586460261
}Rij 127
{
"dossier_id": "0fa132bb-baef-44fd-b4df-cf56ac8932c5",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2024-02-26",
"chatId": "31619308755@s.whatsapp.net",
"chatNaam": "+31 *********",
"bestandsnaam": "Salarisspecificatie 2024-02-26 132250.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.851Z"
},
"updated_at": 1781468618851
}Rij 128
{
"dossier_id": "a5afc05f-85c8-43d2-9b6f-a56a9c6a6cf9",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "adviseur",
"datum": "2024-08-12",
"chatId": "120363142544714854@g.us",
"chatNaam": "Hyp: Mentopawiro & Gaskin",
"bestandsnaam": "Offerte (53)-samengevoegd (1).pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.801Z"
},
"updated_at": 1781468618801
}Rij 129
{
"dossier_id": "c04a3284-7183-4164-a21a-79b732cfd412",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2024-11-04",
"chatId": "31622954416@s.whatsapp.net",
"chatNaam": "Danny Rasmussen",
"bestandsnaam": "*********.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.748Z"
},
"updated_at": 1781468618748
}Rij 130
{
"dossier_id": "2e8bae07-270e-41b1-a35a-e76a5ee8b526",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "adviseur",
"datum": "2024-11-13",
"chatId": "31641391358@s.whatsapp.net",
"chatNaam": "Stephan van der Dussen",
"bestandsnaam": "40034436-Polisblad (tp).pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.699Z"
},
"updated_at": 1781468618699
}Rij 131
{
"dossier_id": "85fc19d8-cac4-497e-947e-43d549eb733c",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2025-01-21",
"chatId": "31626960634@s.whatsapp.net",
"chatNaam": "Gert-jan Otterlo",
"bestandsnaam": "Levering Wijngaard 2.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.653Z"
},
"updated_at": 1781468618653
}Rij 132
{
"dossier_id": "b1a869b8-f5f3-4d05-a09b-a1eff6f89a7d",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "adviseur",
"datum": "2025-12-11",
"chatId": "31647458845-1571075946@g.us",
"chatNaam": "Hyp: Ubels & Ootes",
"bestandsnaam": "InspectieFormulier - Germanenlaan 190, 7312 JD APELDOORN.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.603Z"
},
"updated_at": 1781468618603
}Rij 133
{
"dossier_id": "8af06f3e-4db7-46c4-be6e-f9a7bb25b576",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "adviseur",
"datum": "2026-02-05",
"chatId": "31631141853@s.whatsapp.net",
"chatNaam": "Dario Pozderski",
"bestandsnaam": "Voorwaarden 5369PP-*********.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.555Z"
},
"updated_at": 1781468618555
}Rij 134
{
"dossier_id": "cc191942-3ceb-43f1-9447-d01d148bfc6a",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-02-22",
"chatId": "31618252371@s.whatsapp.net",
"chatNaam": "Luis Diaz",
"bestandsnaam": "Certificado_de_titularidad_y_posiciones_FW8M2UC2_22_02_2026.pdf"
},
{
"van": "klant",
"datum": "2026-02-19",
"chatId": "31618252371@s.whatsapp.net",
"chatNaam": "Luis Diaz",
"bestandsnaam": "Koopovereenkomst_Waalstraat_151_1316_EW_ALMERE_AE101463_18-02-2026-14_30_14 (1).pdf"
},
{
"van": "klant",
"datum": "2026-02-17",
"chatId": "31618252371@s.whatsapp.net",
"chatNaam": "Luis Diaz",
"bestandsnaam": "2 .pdf"
},
{
"van": "klant",
"datum": "2026-02-17",
"chatId": "31618252371@s.whatsapp.net",
"chatNaam": "Luis Diaz",
"bestandsnaam": "Report Waalstraat 151.pdf"
},
{
"van": "klant",
"datum": "2026-02-17",
"chatId": "31618252371@s.whatsapp.net",
"chatNaam": "Luis Diaz",
"bestandsnaam": "Bouwkundige Data-analyse.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.507Z"
},
"updated_at": 1781468618507
}Rij 135
{
"dossier_id": "fa02ee41-b27f-4497-ba8f-153bf28e1a05",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-03-04",
"chatId": "31628572303@s.whatsapp.net",
"chatNaam": "Remco",
"bestandsnaam": "financieel-jaaroverzicht-2025-000000006107259-2026-01-21.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.456Z"
},
"updated_at": 1781468618456
}Rij 136
{
"dossier_id": "da3a52d9-8459-4a75-9d69-4306cd572b35",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-04-16",
"chatId": "31650557793@s.whatsapp.net",
"chatNaam": "Mohammed Shahata Via Raul Soto",
"bestandsnaam": "Zorgovereenkomst_20260226-1459.pdf"
},
{
"van": "klant",
"datum": "2026-04-16",
"chatId": "31650557793@s.whatsapp.net",
"chatNaam": "Mohammed Shahata Via Raul Soto",
"bestandsnaam": "Zorgovereenkomst_20260416-1353.pdf"
},
{
"van": "klant",
"datum": "2026-02-26",
"chatId": "31650557793@s.whatsapp.net",
"chatNaam": "Mohammed Shahata Via Raul Soto",
"bestandsnaam": "Zorgovereenkomst_20260226-1459.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.409Z"
},
"updated_at": 1781468618409
}Rij 137
{
"dossier_id": "b8fb12b0-5dfd-4453-b787-4d2d51da21bf",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-02-28",
"chatId": "31646104432@s.whatsapp.net",
"chatNaam": "Vince",
"bestandsnaam": "Risk schoener.PDF"
}
],
"updatedAt": "2026-06-14T20:23:38.362Z"
},
"updated_at": 1781468618362
}Rij 138
{
"dossier_id": "5efa3b6c-6a51-4314-a025-c044b671ecd3",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-04-01",
"chatId": "31613777941@s.whatsapp.net",
"chatNaam": "Ferry",
"bestandsnaam": "Jaaropgave 2025 Amber.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.315Z"
},
"updated_at": 1781468618315
}Rij 139
{
"dossier_id": "a6ef41e2-8780-4dd6-baac-3f5126fe8e44",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "adviseur",
"datum": "2026-04-17",
"chatId": "31683434664@s.whatsapp.net",
"chatNaam": "Gerwin Bonestroo",
"bestandsnaam": "Hypotheeklasten.pdf"
},
{
"van": "klant",
"datum": "2026-03-25",
"chatId": "31683434664@s.whatsapp.net",
"chatNaam": "Gerwin Bonestroo",
"bestandsnaam": "inkomensverklaring-5367303-bonestroo.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.267Z"
},
"updated_at": 1781468618267
}Rij 140
{
"dossier_id": "849de268-12c6-4df6-b466-6b60ca2610b4",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-03-26",
"chatId": "120363306202703034@g.us",
"chatNaam": "Hyp: Kopen & Guothova",
"bestandsnaam": "Jaaropgave_2025_1003147.pdf"
},
{
"van": "klant",
"datum": "2026-03-26",
"chatId": "120363306202703034@g.us",
"chatNaam": "Hyp: Kopen & Guothova",
"bestandsnaam": "att.o6FBKxFzuP0QPPPbkiS-sDFM8ldEHmCN5I4lj9qP2zk.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.220Z"
},
"updated_at": 1781468618220
}Rij 141
{
"dossier_id": "69d7416b-85b9-4447-8cdb-74e5e91d3b97",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-04-22",
"chatId": "31639782455@s.whatsapp.net",
"chatNaam": "+31 *********",
"bestandsnaam": "2025-12.pdf"
},
{
"van": "klant",
"datum": "2026-04-22",
"chatId": "31639782455@s.whatsapp.net",
"chatNaam": "+31 *********",
"bestandsnaam": "jaar opgave Y Riebeek 2025.pdf"
},
{
"van": "klant",
"datum": "2026-04-22",
"chatId": "31639782455@s.whatsapp.net",
"chatNaam": "+31 *********",
"bestandsnaam": "43 - Originele factuur - 12264273737071 (1).pdf"
},
{
"van": "klant",
"datum": "2026-04-22",
"chatId": "31639782455@s.whatsapp.net",
"chatNaam": "+31 *********",
"bestandsnaam": "40 - Originele factuur - 12276549450071 (2).pdf"
},
{
"van": "klant",
"datum": "2026-04-22",
"chatId": "31639782455@s.whatsapp.net",
"chatNaam": "+31 *********",
"bestandsnaam": "43 - Originele factuur - 72266068009071 (2).pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.171Z"
},
"updated_at": 1781468618171
}Rij 142
{
"dossier_id": "03945c59-260f-45c4-8294-c4bab4ad2e29",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-05-08",
"chatId": "31647458845-1611572640@g.us",
"chatNaam": "Hyp: A. Kewalbansing",
"bestandsnaam": "pdf_download_05756D6F-87B4-445B-AE4E-F8DE4923147A.pdf"
},
{
"van": "klant",
"datum": "2026-05-08",
"chatId": "31647458845-1611572640@g.us",
"chatNaam": "Hyp: A. Kewalbansing",
"bestandsnaam": "58B8DF4F2B5F43E4A662B4577A1A772D(1).PDF"
},
{
"van": "adviseur",
"datum": "2026-05-08",
"chatId": "31647458845-1611572640@g.us",
"chatNaam": "Hyp: A. Kewalbansing",
"bestandsnaam": "Aangifte_inkomstenbelasting_2025_08-05-2026_13.18u.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.121Z"
},
"updated_at": 1781468618121
}Rij 143
{
"dossier_id": "2b45f125-4056-428d-aa11-e92bd06485de",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "adviseur",
"datum": "2026-05-08",
"chatId": "133251461033994@lid",
"chatNaam": "Bjorn",
"bestandsnaam": "Aangifte_inkomstenbelasting_2025_08-05-2026_13.41u.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.074Z"
},
"updated_at": 1781468618074
}Rij 144
{
"dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-05-27",
"chatId": "85323971309792@lid",
"chatNaam": "Raymon Mollink",
"bestandsnaam": "versturen stukken aan koper 27-05-2026 08_25_03.pdf"
},
{
"van": "klant",
"datum": "2026-05-27",
"chatId": "85323971309792@lid",
"chatNaam": "Raymon Mollink",
"bestandsnaam": "nota van afrekening koper.pdf"
},
{
"van": "klant",
"datum": "2026-05-27",
"chatId": "85323971309792@lid",
"chatNaam": "Raymon Mollink",
"bestandsnaam": "ontwerp akte van levering.pdf"
},
{
"van": "klant",
"datum": "2026-02-22",
"chatId": "31623473839@s.whatsapp.net",
"chatNaam": "Raymon Mollink",
"bestandsnaam": "20260216 Werkgeversverklaring Raymon Mollink.pdf"
},
{
"van": "klant",
"datum": "2026-02-22",
"chatId": "31623473839@s.whatsapp.net",
"chatNaam": "Raymon Mollink",
"bestandsnaam": "Rotaform (variabel) 2026-01-26 155620.pdf"
}
],
"updatedAt": "2026-06-14T20:23:38.027Z"
},
"updated_at": 1781468618027
}Rij 145
{
"dossier_id": "7fced6ad-d4e3-428b-9577-2e38fb3460a5",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "adviseur",
"datum": "2025-03-14",
"chatId": "120363158287384168@g.us",
"chatNaam": "HYP: Haverdings - de Ruiter",
"bestandsnaam": "Aangifte_inkomstenbelasting_2024_14-03-2025_13.08u.pdf"
}
],
"updatedAt": "2026-06-14T20:23:37.978Z"
},
"updated_at": 1781468617978
}Rij 146
{
"dossier_id": "03c102b5-16de-45da-958e-1201eb3da19e",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-06-04",
"chatId": "158909646000228@lid",
"chatNaam": "Jaleesa Toppin 🤎",
"bestandsnaam": "Werkgeversverklaring - J.P.O. Toppin.pdf"
},
{
"van": "klant",
"datum": "2026-06-04",
"chatId": "158909646000228@lid",
"chatNaam": "Jaleesa Toppin 🤎",
"bestandsnaam": "5608EFACD60E44839C1B8080E4D71256.pdf"
},
{
"van": "klant",
"datum": "2026-06-04",
"chatId": "158909646000228@lid",
"chatNaam": "Jaleesa Toppin 🤎",
"bestandsnaam": "1099B549DD8A4BF1BAEDB0B9676CE464.pdf"
}
],
"updatedAt": "2026-06-14T20:23:37.931Z"
},
"updated_at": 1781468617931
}Rij 147
{
"dossier_id": "009b5118-80f0-4b2a-a476-6224e9099fd9",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-06-10",
"chatId": "265025403015373@lid",
"chatNaam": "Sylvia De Jong",
"bestandsnaam": "Betaalspecificatie WIA 11 mei 2026 kopie.pdf"
},
{
"van": "klant",
"datum": "2026-06-10",
"chatId": "265025403015373@lid",
"chatNaam": "Sylvia De Jong",
"bestandsnaam": "Verzekeringsbericht pdj juni 26.pdf"
},
{
"van": "klant",
"datum": "2026-06-10",
"chatId": "265025403015373@lid",
"chatNaam": "Sylvia De Jong",
"bestandsnaam": "ABN AMRO spaar Rekeningafschrift-Volgnr20260005.pdf"
},
{
"van": "klant",
"datum": "2026-06-10",
"chatId": "265025403015373@lid",
"chatNaam": "Sylvia De Jong",
"bestandsnaam": "INg spaarrekening A58767916_09-03-2026_09-06-2026.pdf"
},
{
"van": "klant",
"datum": "2026-06-10",
"chatId": "265025403015373@lid",
"chatNaam": "Sylvia De Jong",
"bestandsnaam": "ING betaal rekening NL05INGB0003061153_09-03-2026_09-06-2026.pdf"
},
{
"van": "klant",
"datum": "2026-06-10",
"chatId": "265025403015373@lid",
"chatNaam": "Sylvia De Jong",
"bestandsnaam": "Amro spaar rekening 3maanden overzicht mutov577872397_10032026-09062026.pdf"
},
{
"van": "klant",
"datum": "2026-06-10",
"chatId": "265025403015373@lid",
"chatNaam": "Sylvia De Jong",
"bestandsnaam": "DeGiro aandelen Jaaropgave 2025.pdf"
},
{
"van": "adviseur",
"datum": "2026-05-15",
"chatId": "120363408184732198@g.us",
"chatNaam": "Sylvia De Jong",
"bestandsnaam": "Vergelijkend hypotheeklasten.pdf"
},
{
"van": "adviseur",
"datum": "2026-04-17",
"chatId": "31645782733@s.whatsapp.net",
"chatNaam": "Sylvia De Jong",
"bestandsnaam": "Lijst_van_zaken-21.pdf"
}
],
"updatedAt": "2026-06-14T20:23:37.883Z"
},
"updated_at": 1781468617883
}Rij 148
{
"dossier_id": "d1d96ea8-3a18-41f4-ae78-8e24c0cce484",
"key": "whatsapp_doc_signalen",
"value_json": {
"items": [
{
"van": "klant",
"datum": "2026-05-18",
"chatId": "245672196497634@lid",
"chatNaam": "Iza",
"bestandsnaam": "FORV.511983.pdf"
},
{
"van": "klant",
"datum": "2026-05-18",
"chatId": "245672196497634@lid",
"chatNaam": "Iza",
"bestandsnaam": "Jaaropgave.pdf"
},
{
"van": "klant",
"datum": "2026-05-26",
"chatId": "245672196497634@lid",
"chatNaam": "Iza",
"bestandsnaam": "Getekende offerte Persoonlijke Lening(1).pdf"
},
{
"van": "klant",
"datum": "2026-05-26",
"chatId": "245672196497634@lid",
"chatNaam": "Iza",
"bestandsnaam": "Getekende offerte Persoonlijke Lening(2).pdf"
},
{
"van": "klant",
"datum": "2026-04-30",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "rapport_8245ER_34_29-04-2026.pdf"
},
{
"van": "klant",
"datum": "2026-04-29",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "Statements.pdf"
},
{
"van": "klant",
"datum": "2026-04-29",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "Salarisstrook-988623-2026-3.pdf"
},
{
"van": "klant",
"datum": "2026-04-29",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "Salarisstrook-988623-2026-1.pdf"
},
{
"van": "klant",
"datum": "2026-04-29",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "Salarisstrook-988623-2026-2.pdf"
},
{
"van": "klant",
"datum": "2026-04-29",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "Salarisstrook-988623-2026-4.pdf"
},
{
"van": "klant",
"datum": "2026-04-29",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "ee727927-2d0b-4ab5-bf02-df90be374346.pdf"
},
{
"van": "klant",
"datum": "2026-04-29",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "37b4ec0a-c06c-4e3a-8ae5-8c9c30ecc5d5.pdf"
},
{
"van": "klant",
"datum": "2026-04-29",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "631c585d-6e7d-4ab6-a34a-a7b99c3a8ef2.pdf"
},
{
"van": "klant",
"datum": "2026-04-29",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "bf0699d0-076a-4a1a-be8e-7c28f571181a.pdf"
},
{
"van": "klant",
"datum": "2026-04-27",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "Verzekeringsbericht.pdf"
},
{
"van": "klant",
"datum": "2026-04-20",
"chatId": "31687087430@s.whatsapp.net",
"chatNaam": "Iza",
"bestandsnaam": "Verzekeringsbericht.pdf"
}
],
"updatedAt": "2026-06-14T20:23:37.810Z"
},
"updated_at": 1781468617810
}Rij 149
{
"dossier_id": "77e67854-ec33-4481-aebf-b5211210863d",
"key": "workflow_v1",
"value_json": {
"flags": [],
"actions": [],
"lastDerived": {
"at": "2026-06-14T19:50:43.209Z",
"phase": "F00_lead"
},
"uitvraagReminders": []
},
"updated_at": 1781466643210
}Rij 150
{
"dossier_id": "9711d808-3b75-4d54-8f0b-8d56072af018",
"key": "workflow_v1",
"value_json": {
"flags": [],
"actions": [],
"lastDerived": {
"at": "2026-06-14T19:50:43.204Z",
"phase": "F00_lead"
},
"uitvraagReminders": []
},
"updated_at": 1781466643204
}Andere domeindatabases
Gefilterde containerinventaris. Niet alle containers hebben al een veilige connector.
| Container | Image | Status |
|---|---|---|
| adviestool-web | adviestool-web:latest | Up 9 minutes |
| adviestool-whatsapp | adviestool-whatsapp:latest | Up About an hour |
| adviestool-ocr | adviestool-ocr:latest | Up About an hour (healthy) |
| adviestool-web-preview | adviestool-web-preview:latest | Up 3 days |
| adviestool-preview-ocr | 9e5e9933f3ab | Up 3 days (healthy) |
| adviestool-postgres-test | postgres:17-alpine | Up 3 days (healthy) |
| adviestool-postgres | postgres:17-alpine | Up 5 days (healthy) |
| boekhouding-uw-zekerheid-mssql-1 | mcr.microsoft.com/mssql/server:2022-latest | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-arq-worker-1 | boekhouding-uw-zekerheid-arq-worker | Up 6 days |
| boekhouding-uw-zekerheid-api-1 | boekhouding-uw-zekerheid-api | Up 6 days |
| boekhouding-uw-zekerheid-web-1 | boekhouding-uw-zekerheid-web | Up 6 days |
| boekhouding-uw-zekerheid-caddy-1 | caddy:2-alpine | Up 6 days |
| boekhouding-uw-zekerheid-otel-collector-1 | otel/opentelemetry-collector:0.136.0 | Up 6 days |
| boekhouding-uw-zekerheid-redis-1 | redis:7-alpine | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-postgres-1 | pgvector/pgvector:pg16 | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-minio-1 | minio/minio:RELEASE.2025-09-07T16-13-09Z | Up 6 days |
| adviseursite | adviseursite-adviseursite | Up 7 days (healthy) |
| hypotheek-gate | hypotheek-gate:latest | Up 7 days (healthy) |
| dash | dash-uw-zekerheid:latest | Up 7 days (healthy) |
| adviesbox-windows | dockurr/windows | Up 7 days |
| klantportaal | klantportaal:latest | Up 7 days (healthy) |
| uwpaleis-test | uwpaleis-website:latest | Up 7 days (healthy) |