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.157 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 400

50 matchende rijen · offset 400 · limiet 50Vorige Volgende

dossier_id	key	value_json	updated_at
1966ed7e-f705-4eb5-b247-ae065bbbb9d4	_sources	{ "inventarisatie.onderpand_adres": { "source": "Logscan: Onderpandadres uit 2026 - Uniforme verbouwingsspecificatie.pdf (Adres)", "updated_at": "2026-06-03T23:32:36.803Z" }, "inventarisatie.onderpand_huisnummer": { "source": "Logscan: Huisnummer uit 2026 - Uniforme verbouwingsspecificatie.pdf (Adres)", "updated_at": "2026-06-03T23:32:36.803Z" }, "inventarisatie.onderpand_woonplaats": { "source": "Logscan: Plaats uit NotaAankoop79119_22201269.pdf (Plaats onderpand)", "updated_at": "2026-06-04T10:51:01.650Z" } }	1780570261692
2b45f125-4056-428d-aa11-e92bd06485de	_sources	{ "inventarisatie.soort_aanvraag": { "source": "Logscan: Aanvraagsoort uit Inventarisatie Logscan (Logtekst, dossierlog)", "updated_at": "2026-06-03T23:02:49.226Z" }, "inventarisatie.onderpand_adres": { "source": "Logscan: Onderpandadres uit 2026 - Koopovereenkomst.pdf (Onderpand adres)", "updated_at": "2026-06-04T08:35:06.940Z" }, "inventarisatie.onderpand_soort": { "source": "Logscan: Woningtype uit 2026 - Koopovereenkomst.pdf (Woningtype)", "updated_at": "2026-06-04T10:47:46.724Z" }, "inventarisatie.aanvraag_hoofdsom": { "source": "Logscan: Gewenste hypotheek / hoofdsom uit Hypotheekakte Schermer 26 ING.pdf (Hoofdsom)", "updated_at": "2026-06-04T08:35:06.940Z" }, "inventarisatie.onderpand_bouwjaar": { "source": "Logscan: Bouwjaar uit 2026 - Koopovereenkomst.pdf (Bouwjaar)", "updated_at": "2026-06-04T10:47:46.724Z" }, "inventarisatie.onderpand_postcode": { "source": "Logscan: Postcode uit 2026 - Koopovereenkomst.pdf (Postcode onderpand)", "updated_at": "2026-06-04T08:35:06.940Z" }, "inventarisatie.onderpand_huisnummer": { "source": "Logscan: Huisnummer uit 2026 - Koopovereenkomst.pdf (Onderpand adres)", "updated_at": "2026-06-04T08:35:06.940Z" }, "inventarisatie.onderpand_woonplaats": { "source": "Logscan: Plaats uit 2026 - Koopovereenkomst.pdf (Plaa ... [afgekapt: 597 tekens]	1780570066778
2f118f6f-05da-462f-8d39-dd947dbdb1fd	aanvraagproces-stukken	{ "log": [ { "at": "2026-06-04T08:55:43.737932Z", "result": "Legitimatiebewijs A1/A2 gekoppeld aan privacy-safe visueel geverifieerde ID-documentbestanden; hypotheekaanvraagfallback verwijderd.", "command": "hermes-link-real-id-documents" }, { "at": "2026-06-01T21:01:58.984Z", "result": "+0 stukken, 26 bestand(en) gekoppeld", "command": "auto-detect" }, { "at": "2026-05-23T00:00:00.000Z", "result": "inkomensdocumenten opnieuw 1-op-1 gekoppeld per aanvrager", "command": "manual-correct-after-autodetect" }, { "at": "2026-05-23T19:05:27.894Z", "result": "+0 stukken, 4 bestand(en) gekoppeld", "command": "auto-detect" }, { "at": "2026-05-23T15:48:27Z", "result": "Werkgeversverklaringen en salarisstroken per aanvrager gecorrigeerd; geen klantverzending.", "command": "hermes-correct-upload3-links" }, { "at": "2026-05-23T15:44:34.926Z", "result": "+0 stukken, 4 bestand(en) gekoppeld", "command": "auto-detect" }, { "at": "2026-05-23T15:44:19.838Z", "result": "+11 stukken, 4 bestand(en) gekoppeld", "command": "auto-detect" } ], "stukken": [ { "id": "c6f5f2e3-f4d7-4149-ba85-a18b5031934d", "type": "id_bewijs", "label": "Legitimatiebewijs aanvrage ... [afgekapt: 15823 tekens]	1780563343813
6b20b045-17cc-4125-8e3e-f2145726b84a	hdn_dossier	{ "schema": "adviestool.hdn_like", "bronnen": { "partijen.p1.contact.email": [ { "at": 1780561967792, "value": "jeroendegraaf2015@hotmail.com", "context": "inventarisatie.a1.email", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "hypotheken.aangevraagd.nhg": [ { "at": 1780561967792, "value": "NHG", "context": "base_import.products[].norm", "confidence": 0.68, "sourceKind": "extractie" } ], "partijen.p1.woonadres.plaats": [ { "at": 1780561967792, "value": "Lelystad", "context": "inventarisatie.a1.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.plaats": [ { "at": 1780561967792, "value": "Lelystad", "context": "inventarisatie.a2.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p1.woonadres.postcode": [ { "at": 1780561967792, "value": "8231 EA", "context": "inventarisatie.a1.postcode", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.postcode": [ { "at": 1780561967792, "value": "8231 EA", "context": "i ... [afgekapt: 6377 tekens]	1780561967895
6b20b045-17cc-4125-8e3e-f2145726b84a	_sources	{ "inventarisatie.data.aanvraag_nhg": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.nhg", "updated_at": "2026-06-04T08:32:47.724Z" }, "inventarisatie.data.aanvraag_hoofdsom": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.hoofdsom", "updated_at": "2026-06-04T08:32:47.724Z" }, "inventarisatie.data.aanvraag_productnaam": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.aflossingsvorm", "updated_at": "2026-06-04T08:32:47.724Z" }, "inventarisatie.data.aanvraag_geldverstrekker": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.geldverstrekker", "updated_at": "2026-06-04T08:32:47.724Z" } }	1780561967870
6b20b045-17cc-4125-8e3e-f2145726b84a	inventarisatie	{ "a1": { "naam": "Graaf, Jeroen de (J)", "adres": "Kempenaar 05 22", "email": "jeroendegraaf2015@hotmail.com", "postcode": "8231 EA", "woonplaats": "Lelystad", "telefoon_prive": "0610770109" }, "a2": { "adres": "Kempenaar 05 22", "postcode": "8231 EA", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "157500.00", "status": "Lopend", "artikel": "Merius annuiteitenhypotheek, Merius aflossingsvrije hypotheek", "tekendatum": "25569", "productnaam": "Merius annuiteitenhypotheek, Merius aflossingsvrije hypotheek", "maatschappij": "Merius Hypotheken", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3011318", "passeeringangsdatum": "2019-03-11" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "tekendatum": "25569", "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair", "maatschappij": "TAF", "productsoort": "Ov ... [afgekapt: 435 tekens]	1780561967843
cef57c94-7077-466a-8e57-7f0a86dd560f	hdn_dossier	{ "schema": "adviestool.hdn_like", "bronnen": { "partijen.p1.contact.email": [ { "at": 1780561966268, "value": "rdzwarthoff@gmail.com", "context": "inventarisatie.a1.email", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p1.woonadres.plaats": [ { "at": 1780561966268, "value": "Lelystad", "context": "inventarisatie.a1.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.plaats": [ { "at": 1780561966268, "value": "Lelystad", "context": "inventarisatie.a2.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p1.woonadres.postcode": [ { "at": 1780561966268, "value": "8243 HV", "context": "inventarisatie.a1.postcode", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.postcode": [ { "at": 1780561966268, "value": "8243 HV", "context": "inventarisatie.a2.postcode", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "hypotheken.aangevraagd.hoofdsom": [ { "at": 1780561966268, "value": "0.00", "context": ... [afgekapt: 5863 tekens]	1780561966375
cef57c94-7077-466a-8e57-7f0a86dd560f	_sources	{ "inventarisatie.data.aanvraag_hoofdsom": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.hoofdsom", "updated_at": "2026-06-04T08:32:46.207Z" }, "inventarisatie.data.aanvraag_productnaam": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.aflossingsvorm", "updated_at": "2026-06-04T08:32:46.207Z" }, "inventarisatie.data.aanvraag_geldverstrekker": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.geldverstrekker", "updated_at": "2026-06-04T08:32:46.207Z" } }	1780561966347
cef57c94-7077-466a-8e57-7f0a86dd560f	inventarisatie	{ "a1": { "naam": "Zwarthoff, Rogier (R.D.)", "adres": "Stadseiland 98", "email": "rdzwarthoff@gmail.com", "postcode": "8243 HV", "woonplaats": "Lelystad", "telefoon_prive": "06-47458845" }, "a2": { "adres": "Stadseiland 98", "postcode": "8243 HV", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair", "tekendatum": "25569", "productnaam": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair", "maatschappij": "TAF", "productsoort": "Overlijdensrisicoverzekering", "factuurbedrag": "", "offertenummer": "2375534", "passeeringangsdatum": "2017-04-01" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Overlijdensrisicoverzekering", "tekendatum": "25569", "productnaam": "Overlijdensrisicoverzekering", "maatschappij": "Brand New Day", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", " ... [afgekapt: 4142 tekens]	1780561966319
f5e4e84a-9466-4ade-bd16-e3318382b45d	hdn_dossier	{ "schema": "adviestool.hdn_like", "bronnen": { "partijen.p1.contact.email": [ { "at": 1780561965810, "value": "sietsejp@hotmail.com", "context": "inventarisatie.a1.email", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.contact.email": [ { "at": 1780561965810, "value": "samanthaluking@gmail.com", "context": "inventarisatie.a2.email", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "hypotheken.aangevraagd.nhg": [ { "at": 1780561965810, "value": "NHG", "context": "base_import.products[].norm", "confidence": 0.68, "sourceKind": "extractie" } ], "partijen.p1.woonadres.plaats": [ { "at": 1780561965802, "value": "Almere", "context": "inventarisatie.a1.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.plaats": [ { "at": 1780561965810, "value": "Almere", "context": "inventarisatie.a2.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p1.woonadres.postcode": [ { "at": 1780561965802, "value": "1338 XL", "context": "inven ... [afgekapt: 6799 tekens]	1780561965933
f5e4e84a-9466-4ade-bd16-e3318382b45d	_sources	{ "inventarisatie.data.aanvraag_nhg": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.nhg", "updated_at": "2026-06-04T08:32:45.737Z" }, "inventarisatie.data.aanvraag_hoofdsom": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.hoofdsom", "updated_at": "2026-06-04T08:32:45.737Z" }, "inventarisatie.data.aanvraag_productnaam": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.aflossingsvorm", "updated_at": "2026-06-04T08:32:45.737Z" }, "inventarisatie.data.aanvraag_geldverstrekker": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.geldverstrekker", "updated_at": "2026-06-04T08:32:45.737Z" } }	1780561965906
f5e4e84a-9466-4ade-bd16-e3318382b45d	inventarisatie	{ "a1": { "naam": "Luking, Pietersma (S.)", "adres": "Lathyruspad 10", "email": "sietsejp@hotmail.com", "postcode": "1338 XL", "woonplaats": "Almere", "telefoon_prive": "0620794006" }, "a2": { "adres": "Lathyruspad 10", "email": "samanthaluking@gmail.com", "postcode": "1338 XL", "woonplaats": "Almere" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "321094.00", "status": "Dossier compleet naar MIJ", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2025-12-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "310000.00", "status": "Aanvraag aanvullen (vanuit maatschappij)", "artikel": "Woonnu Annuïtair", "tekendatum": "25569", "productnaam": "Woonnu Annuïtair", "maatschappij": "Woonnu", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3587 ... [afgekapt: 321 tekens]	1780561965882
c6406b9a-7e46-4796-8d98-9f789737f132	hdn_dossier	{ "schema": "adviestool.hdn_like", "bronnen": { "partijen.p1.contact.email": [ { "at": 1780561961816, "value": "hnaushad50@yahoo.com", "context": "inventarisatie.a1.email", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.contact.email": [ { "at": 1780561961816, "value": "samiyakhanum123@yahoo.com", "context": "inventarisatie.a2.email", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p1.woonadres.plaats": [ { "at": 1780561961816, "value": "Utrecht", "context": "inventarisatie.a1.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.plaats": [ { "at": 1780561961816, "value": "Utrecht", "context": "inventarisatie.a2.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p1.woonadres.postcode": [ { "at": 1780561961816, "value": "3523 HX", "context": "inventarisatie.a1.postcode", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.postcode": [ { "at": 1780561961816, "value": "3523 HX", "c ... [afgekapt: 6373 tekens]	1780561961941
c6406b9a-7e46-4796-8d98-9f789737f132	_sources	{ "inventarisatie.data.aanvraag_hoofdsom": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.hoofdsom", "updated_at": "2026-06-04T08:32:41.742Z" }, "inventarisatie.data.aanvraag_geldverstrekker": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.geldverstrekker", "updated_at": "2026-06-04T08:32:41.742Z" } }	1780561961911
c6406b9a-7e46-4796-8d98-9f789737f132	inventarisatie	{ "a1": { "naam": "Ali (S.H.N.)", "adres": "Ridderplantsoen 21", "email": "hnaushad50@yahoo.com", "postcode": "3523 HX", "woonplaats": "Utrecht", "telefoon_prive": "0657118539" }, "a2": { "naam": "Khanum (S.)", "adres": "Ridderplantsoen 21", "email": "samiyakhanum123@yahoo.com", "postcode": "3523 HX", "woonplaats": "Utrecht" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2025-08-26" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2025-08-26" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "265000.00", " ... [afgekapt: 626 tekens]	1780561961882
eec8ad9e-b509-4cc3-898e-70e82feac4a9	hdn_dossier	{ "schema": "adviestool.hdn_like", "bronnen": { "partijen.p1.contact.email": [ { "at": 1780561960233, "value": "h.kuipers@solcon.nl", "context": "inventarisatie.a1.email", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "hypotheken.aangevraagd.nhg": [ { "at": 1780561960234, "value": "Geldverstrekker", "context": "base_import.products[].norm", "confidence": 0.68, "sourceKind": "extractie" } ], "partijen.p1.woonadres.plaats": [ { "at": 1780561960233, "value": "Dronten", "context": "inventarisatie.a1.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.plaats": [ { "at": 1780561960233, "value": "Dronten", "context": "inventarisatie.a2.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p1.woonadres.postcode": [ { "at": 1780561960233, "value": "8251 NN", "context": "inventarisatie.a1.postcode", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.postcode": [ { "at": 1780561960233, "value": "8251 NN", "context": "i ... [afgekapt: 6353 tekens]	1780561960358
eec8ad9e-b509-4cc3-898e-70e82feac4a9	_sources	{ "inventarisatie.data.aanvraag_nhg": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.nhg", "updated_at": "2026-06-04T08:32:40.166Z" }, "inventarisatie.data.aanvraag_hoofdsom": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.hoofdsom", "updated_at": "2026-06-04T08:32:40.166Z" }, "inventarisatie.data.aanvraag_productnaam": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.aflossingsvorm", "updated_at": "2026-06-04T08:32:40.166Z" }, "inventarisatie.data.aanvraag_geldverstrekker": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.geldverstrekker", "updated_at": "2026-06-04T08:32:40.166Z" } }	1780561960327
eec8ad9e-b509-4cc3-898e-70e82feac4a9	inventarisatie	{ "a1": { "naam": "Kuipers, Kuipers Hiddo (H)", "adres": "Zomer 40 40", "email": "h.kuipers@solcon.nl", "postcode": "8251 NN", "woonplaats": "Dronten", "telefoon_prive": "0321381303" }, "a2": { "adres": "Zomer 40 40", "postcode": "8251 NN", "woonplaats": "Dronten" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "300000.00", "status": "Gepasseerd", "artikel": "Delta Lloyd Fixe / Aflossingsvrij (Delta Lloyd Budget Hypotheek), Delta Lloyd Annuiteit (Delta Lloyd Budget Hypotheek)", "tekendatum": "25569", "productnaam": "Delta Lloyd Fixe / Aflossingsvrij (Delta Lloyd Budget Hypotheek), Delta Lloyd Annuiteit (Delta Lloyd Budget Hypotheek)", "maatschappij": "Delta Lloyd", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "1595560", "passeeringangsdatum": "2017-06-26" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "349582.00", "status": "Offerte/renteaanbod ontvangen", "artikel": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloy ... [afgekapt: 1649 tekens]	1780561960299
b6e86ce0-b42c-40a6-a841-21c827ec4a0b	hdn_dossier	{ "schema": "adviestool.hdn_like", "bronnen": { "partijen.p1.contact.email": [ { "at": 1780561959744, "value": "avrin.vanderlaan@gmail.com", "context": "inventarisatie.a1.email", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.contact.email": [ { "at": 1780561959744, "value": "avrin.vanderlaan@merial.com", "context": "inventarisatie.a2.email", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p1.woonadres.plaats": [ { "at": 1780561959744, "value": "Lelystad", "context": "inventarisatie.a1.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.plaats": [ { "at": 1780561959744, "value": "Lelystad", "context": "inventarisatie.a2.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p1.woonadres.postcode": [ { "at": 1780561959744, "value": "8219 DB", "context": "inventarisatie.a1.postcode", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.postcode": [ { "at": 1780561959744, "value": "8219 DB", ... [afgekapt: 6472 tekens]	1780561959877
b6e86ce0-b42c-40a6-a841-21c827ec4a0b	_sources	{ "inventarisatie.data.aanvraag_hoofdsom": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.hoofdsom", "updated_at": "2026-06-04T08:32:39.677Z" }, "inventarisatie.data.aanvraag_geldverstrekker": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.geldverstrekker", "updated_at": "2026-06-04T08:32:39.677Z" } }	1780561959849
b6e86ce0-b42c-40a6-a841-21c827ec4a0b	inventarisatie	{ "a1": { "naam": "Laan, Avrin van der (A.A.)", "adres": "Groenendaal 55", "email": "avrin.vanderlaan@gmail.com", "postcode": "8219 DB", "woonplaats": "Lelystad", "telefoon_prive": "06-23102539" }, "a2": { "naam": "Riemersma, Priscilla (P.C.)", "adres": "Groenendaal 55", "email": "avrin.vanderlaan@merial.com", "postcode": "8219 DB", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-10-04" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "ORV Annuitair dalend", "tekendatum": "25569", "productnaam": "ORV Annuitair dalend", "maatschappij": "Reaal schadeverzekeringen", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "1300336094", "passeeringangsdatu ... [afgekapt: 1334 tekens]	1780561959823
4f8bd6a0-aa1a-426b-bd44-693f19213fb5	hdn_dossier	{ "schema": "adviestool.hdn_like", "bronnen": { "partijen.p1.contact.email": [ { "at": 1780561955401, "value": "tupacyigit@hotmail.com", "context": "inventarisatie.a1.email", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p1.woonadres.plaats": [ { "at": 1780561955400, "value": "LELYSTAD", "context": "inventarisatie.a1.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.plaats": [ { "at": 1780561955401, "value": "LELYSTAD", "context": "inventarisatie.a2.woonplaats", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p1.woonadres.postcode": [ { "at": 1780561955400, "value": "8245 CV", "context": "inventarisatie.a1.postcode", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "partijen.p2.woonadres.postcode": [ { "at": 1780561955401, "value": "8245 CV", "context": "inventarisatie.a2.postcode", "confidence": 0.55, "sourceKind": "inventarisatie" } ], "hypotheken.aangevraagd.hoofdsom": [ { "at": 1780561955401, "value": "0.00", "context": ... [afgekapt: 5852 tekens]	1780561955503
4f8bd6a0-aa1a-426b-bd44-693f19213fb5	_sources	{ "inventarisatie.data.aanvraag_hoofdsom": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.hoofdsom", "updated_at": "2026-06-04T08:32:35.329Z" }, "inventarisatie.data.aanvraag_geldverstrekker": { "source": "HDN-dossierlaag", "hdn_path": "hypotheken.aangevraagd.geldverstrekker", "updated_at": "2026-06-04T08:32:35.329Z" } }	1780561955476
4f8bd6a0-aa1a-426b-bd44-693f19213fb5	inventarisatie	{ "a1": { "naam": "Koyuncu, Hülya (H.)", "adres": "Rijnland 39", "email": "tupacyigit@hotmail.com", "postcode": "8245 CV", "woonplaats": "LELYSTAD", "telefoon_prive": "0684980549" }, "a2": { "naam": "Koyuncu, Mustafa (M)", "adres": "Rijnland 39", "postcode": "8245 CV", "woonplaats": "LELYSTAD" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering voor Particulieren, Doorlopende Reis en/of Annulering, Basis Verzekerd, Particuliere Autoverzekering, Pechhulp, Particuliere Autoverzekering, Auto", "tekendatum": "25569", "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering voor Particulieren, Doorlopende Reis en/of Annulering, Basis Verzekerd, Particuliere Autoverzekering, Pechhulp, Particuliere Autoverzekering, Auto", "maatschappij": "Risk Assuradeuren", "productsoort": "Aansprakelijkheid, Inboedel, Motorrijtuigen, Opstal, Personenauto, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies", "factuurbedrag": "", "offertenummer": "5369PK-*********", ... [afgekapt: 3524 tekens]	1780561955451
009b5118-80f0-4b2a-a476-6224e9099fd9	upload2_document_intake	{ "version": 1, "documents": { "0238a7dc-237a-4a8a-8cd7-3cfae92a6699": { "mime": "application/pdf", "model": "regels", "fileId": "0238a7dc-237a-4a8a-8cd7-3cfae92a6699", "status": "needs_review", "scanRuns": [], "template": "Onbekend", "applicant": 2, "ocrEngine": "auto", "pageCount": null, "updatedAt": "2026-06-03T18:00:48.315Z", "confidence": 0.05, "firstSeenAt": "2026-06-03T17:24:31.366Z", "documentName": "Verzekeringsbericht uwv Peter de Jong.pdf", "documentType": "263 UWV Verzekeringsbericht", "fieldReviews": {}, "profileLabel": "Onbekend document", "profileTypeId": "unknown", "learningEvents": [ { "at": "2026-06-03T18:00:48.315Z", "to": "263 UWV Verzekeringsbericht", "from": "Onbekend", "kind": "document_type_changed", "actor": "user", "field": "documentType", "confidence": 0.05, "profileLabel": "Onbekend document", "profileTypeId": "unknown" }, { "at": "2026-06-03T18:00:48.315Z", "to": 2, "from": null, "kind": "applicant_changed", "actor": "user", "field": "applicant", "confidence": 0.05, "profileLabel": "Onbekend document", ... [afgekapt: 10150 tekens]	1780509656735
ee0b7fdb-7769-4e54-92cd-0a2d2cba1b4c	_sources	{}	1780507927177
d9ef447d-61d5-4170-b668-ba92f1f20e7c	_sources	{}	1780507927177
4f8bd6a0-aa1a-426b-bd44-693f19213fb5	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T16:31:29.350Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780504289350
c6406b9a-7e46-4796-8d98-9f789737f132	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T16:31:29.278Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780504289278
cef57c94-7077-466a-8e57-7f0a86dd560f	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T16:31:29.265Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780504289265
ee0b7fdb-7769-4e54-92cd-0a2d2cba1b4c	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T16:31:29.246Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780504289246
6b20b045-17cc-4125-8e3e-f2145726b84a	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T16:31:29.235Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780504289236
f5e4e84a-9466-4ade-bd16-e3318382b45d	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T15:15:49.160Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780499749161
b6e86ce0-b42c-40a6-a841-21c827ec4a0b	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T15:15:49.136Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780499749136
cc191942-3ceb-43f1-9447-d01d148bfc6a	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T15:15:49.111Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780499749112
2b45f125-4056-428d-aa11-e92bd06485de	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T15:15:49.104Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780499749104
1966ed7e-f705-4eb5-b247-ae065bbbb9d4	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T15:15:49.096Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780499749096
eec8ad9e-b509-4cc3-898e-70e82feac4a9	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T15:15:49.081Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780499749081
d9ef447d-61d5-4170-b668-ba92f1f20e7c	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T15:15:49.046Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780499749047
hermes-e2e-advies-2026-05-24	_sources	{ "klantprofiel": [ { "at": "2026-05-24T19:30:13.681Z", "kind": "simulated", "label": "Gemini customer-profile simulation" } ], "financieringsopzet": [ { "at": "2026-05-24T19:30:13.681Z", "kind": "manual", "label": "Hermes E2E seed op basis van documentfeiten" } ], "aanvraagproces.history": { "source": "Eigen invoer", "updated_at": "2026-05-27T15:25:35.104Z" }, "inventarisatie.a1.naam": [ { "kind": "document", "label": "sandbox salarisstrook", "fileId": "hermes-e2e-salarisstrook-a1" } ], "financieringsopzet.activeId": { "source": "Eigen invoer", "updated_at": "2026-06-03T12:34:38.636Z" }, "financieringsopzet.voorstellen": { "source": "Eigen invoer", "updated_at": "2026-06-03T12:44:26.958Z" }, "inventarisatie.a1.geboortedatum": [ { "kind": "document", "label": "sandbox legitimatie", "fileId": "hermes-e2e-legitimatie-a1" } ], "financieringsopzet.selectedProposalId": { "source": "Eigen invoer", "updated_at": "2026-06-03T12:34:38.636Z" }, "inventarisatie.data.onderpand_koopsom": [ { "kind": "document", "label": "sandbox koopovereenkomst", "fileId": "hermes-e2e-koopovereenkomst" } ], "inventarisatie.inc1.fields.ww_dagloon": { "label": "WW dagloo ... [afgekapt: 8033 tekens]	1780490667011
hermes-e2e-advies-2026-05-24	financieringsopzet	{ "activeId": "ecb537d9-3683-4186-a305-3fcdb7f5636d", "voorstellen": [ { "id": "voorstel-hermes-e2e-1", "naam": "Hermes E2E voorstel 1 — aankoop met NHG indicatief", "kosten": { "nhg": "1800", "totaal": "356700", "koopsom": "350000", "notaris": "1200", "taxatie": "750", "kadaster": "", "meerwerk": "", "boeterente": "", "verbouwing": "", "bankgarantie": "", "nhgBorgtocht": "", "overigKosten": "", "roerendeZaken": "", "aankoopmakelaar": "", "hypotheekadvies": "2950", "aflossingBestaand": "", "bouwkundigeKeuring": "", "notarisHypotheekakte": "", "notarisLeveringsakte": "", "overdrachtsbelasting": "0" }, "status": "draft", "notitie": "Sandbox E2E: indicatief voorstel voor browserdoorloop; geen echte aanvraag of acceptatie.", "leningdelen": [ { "id": "ld-hermes-e2e-1", "box": "1", "nhg": "Ja", "rente": "4,00", "hoofdsom": "300000", "aflosvorm": "Annuiteit", "aftrekPct": "100", "box1Bedrag": "", "box3Bedrag": "", "productnaam": "", "restverschil": "", "looptijdJaren": "30", "brutoMaandlast": "1432", ... [afgekapt: 7963 tekens]	1780490666958
hermes-e2e-advies-2026-05-24	berekeningen_v1	{ "version": 1, "updatedAt": "2026-06-03T12:34:38.824Z", "calculations": [ { "id": "calc-hermes-e2e-aankoop", "title": "Hermes E2E aankoopberekening", "source": "manual", "status": "converted_to_application", "purpose": "aankoop_bestaande_bouw", "summary": "Indicatieve sandboxberekening met geselecteerd voorstel en interne aanvraagkoppeling.", "createdAt": "2026-05-24T19:30:13.681Z", "dossierId": "hermes-e2e-advies-2026-05-24", "updatedAt": "2026-06-03T12:34:38.824Z", "proposalIds": [ "voorstel-hermes-e2e-1", "ecb537d9-3683-4186-a305-3fcdb7f5636d", "fe89f95f-7653-4b6b-84b2-84162a43e987" ], "applicationId": "aanvraag-hermes-e2e-intern", "applicantScope": "applicant_1", "selectedProposalId": "ecb537d9-3683-4186-a305-3fcdb7f5636d" } ], "activeCalculationId": "calc-hermes-e2e-aankoop" }	1780490078824
100de351-22d4-46ef-9117-86f768363636	_sources	{ "aov.value": { "source": "Eigen invoer", "updated_at": "2026-06-02T12:01:44.613Z" }, "orv.value": { "source": "Eigen invoer", "updated_at": "2026-06-02T09:35:17.818Z" }, "orv.polissen": { "source": "Eigen invoer", "updated_at": "2026-06-02T17:48:16.067Z" }, "aov.producten": { "source": "Eigen invoer", "updated_at": "2026-06-02T12:29:48.107Z" }, "inventarisatie.data": { "source": "Eigen invoer", "updated_at": "2026-06-02T07:52:27.642Z" }, "aanvraagproces.value": { "source": "Eigen invoer", "updated_at": "2026-06-02T11:01:33.430Z" }, "advies-motivering.value": { "source": "Eigen invoer", "updated_at": "2026-06-02T11:01:31.187Z" }, "advies-onderwerpen.value": { "source": "Eigen invoer", "updated_at": "2026-06-02T11:01:31.355Z" }, "financieringsopzet.value": { "source": "Eigen invoer", "updated_at": "2026-06-02T07:51:58.014Z" }, "hypotheek-algemeen.value": { "source": "Eigen invoer", "updated_at": "2026-06-02T07:50:44.235Z" }, "financieringsopzet.activeId": { "source": "Eigen invoer", "updated_at": "2026-06-02T18:18:06.659Z" }, "inventarisatie.inc1.salaris": { "source": "Eigen invoer", "updated_at": "2026-06-02T07:52:27.642Z" }, "inventarisatie.inc2.salaris": { "source": "Eigen invoer", "upd ... [afgekapt: 11282 tekens]	1780481744728
100de351-22d4-46ef-9117-86f768363636	financieringsopzet	{ "activeId": "0f80d3d1-45ed-474a-a41f-1dba285c19ad", "voorstellen": [ { "id": "88cde811-613e-4c27-9580-192bee2e94c2", "naam": "Voorstel 2", "kosten": { "koopsom": "", "taxatie": "", "kadaster": "", "meerwerk": "", "boeterente": "", "verbouwing": "", "bankgarantie": "", "nhgBorgtocht": "", "overigKosten": "", "roerendeZaken": "", "aankoopmakelaar": "", "hypotheekadvies": "", "aflossingBestaand": "", "bouwkundigeKeuring": "", "notarisHypotheekakte": "", "notarisLeveringsakte": "", "overdrachtsbelasting": "" }, "status": "draft", "notitie": "", "leningdelen": [], "financiering": { "bouwdepot": "", "schenking": "", "hypotheek1": "", "hypotheek2": "", "eigenMiddelen": "", "verkoopopbrengst": "", "overigFinanciering": "", "overbruggingskrediet": "" }, "vergelijking": { "box3": "", "wozWaarde": "", "overwaarde": "", "statusOfferte": "", "verkoopwaarde": "", "verkoopCourtage": "", "verlengingNodig": "", "huidigeHypotheek": "", "overdrachtsdatum": "", "renteaanbodDatum": "", "bankgarantiedatum": "", ... [afgekapt: 5256 tekens]	1780481744670
9679b483-de37-463a-982e-e600fecfcc84	aanvraagproces	{ "status": "nieuw", "history": [], "notitie": "" }	1780479145358
009b5118-80f0-4b2a-a476-6224e9099fd9	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T08:57:07.518Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780477027518
9679b483-de37-463a-982e-e600fecfcc84	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-06-03T08:00:20.199Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1780473620202
hermes-e2e-2026-05-24	_sources	{ "klantprofiel": [ { "at": "2026-05-24T13:05:02.152Z", "kind": "simulated", "label": "Gemini customer-profile simulation" } ], "financieringsopzet": [ { "at": "2026-05-24T13:05:02.152Z", "kind": "manual", "label": "Hermes E2E seed op basis van documentfeiten" } ], "aanvraagproces.history": { "source": "Eigen invoer", "updated_at": "2026-06-03T05:06:38.954Z" }, "inventarisatie.a1.naam": [ { "kind": "document", "label": "sandbox salarisstrook", "fileId": "hermes-e2e-salarisstrook-a1" } ], "financieringsopzet.activeId": { "source": "Eigen invoer", "updated_at": "2026-06-02T07:32:39.471Z" }, "financieringsopzet.voorstellen": { "source": "Eigen invoer", "updated_at": "2026-06-03T05:33:30.906Z" }, "inventarisatie.a1.geboortedatum": [ { "kind": "document", "label": "sandbox legitimatie", "fileId": "hermes-e2e-legitimatie-a1" } ], "financieringsopzet.selectedProposalId": { "source": "Eigen invoer", "updated_at": "2026-06-02T07:32:39.471Z" }, "inventarisatie.data.onderpand_koopsom": [ { "kind": "document", "label": "sandbox koopovereenkomst", "fileId": "hermes-e2e-koopovereenkomst" } ], "inventarisatie.inc1.fields.ww_dagloon": { "label": "WW dagloo ... [afgekapt: 8033 tekens]	1780464810975
hermes-e2e-2026-05-24	financieringsopzet	{ "activeId": "d9eb7e0f-b40d-4c2e-8f62-c9b9d212389f", "voorstellen": [ { "id": "voorstel-hermes-e2e-1", "naam": "Hermes E2E voorstel 1 — aankoop met NHG indicatief", "kosten": { "nhg": "1800", "totaal": "356700", "koopsom": "350000", "notaris": "1200", "taxatie": "750", "kadaster": "", "meerwerk": "", "boeterente": "", "verbouwing": "", "bankgarantie": "", "nhgBorgtocht": "", "overigKosten": "", "roerendeZaken": "", "aankoopmakelaar": "", "hypotheekadvies": "2950", "aflossingBestaand": "", "bouwkundigeKeuring": "", "notarisHypotheekakte": "", "notarisLeveringsakte": "", "overdrachtsbelasting": "0" }, "status": "draft", "notitie": "Sandbox E2E: indicatief voorstel voor browserdoorloop; geen echte aanvraag of acceptatie.", "leningdelen": [ { "id": "ld-hermes-e2e-1", "box": "1", "nhg": "Ja", "rente": "4,00", "hoofdsom": "300000", "aflosvorm": "Annuiteit", "aftrekPct": "100", "box1Bedrag": "", "box3Bedrag": "", "productnaam": "", "restverschil": "", "looptijdJaren": "30", "brutoMaandlast": "1432", ... [afgekapt: 5057 tekens]	1780464810906
hermes-e2e-2026-05-24	advies-motivering	{}	1780463227267

Raw JSON details

Rij 401

{
  "dossier_id": "1966ed7e-f705-4eb5-b247-ae065bbbb9d4",
  "key": "_sources",
  "value_json": {
    "inventarisatie.onderpand_adres": {
      "source": "Logscan: Onderpandadres uit 2026 - Uniforme verbouwingsspecificatie.pdf (Adres)",
      "updated_at": "2026-06-03T23:32:36.803Z"
    },
    "inventarisatie.onderpand_huisnummer": {
      "source": "Logscan: Huisnummer uit 2026 - Uniforme verbouwingsspecificatie.pdf (Adres)",
      "updated_at": "2026-06-03T23:32:36.803Z"
    },
    "inventarisatie.onderpand_woonplaats": {
      "source": "Logscan: Plaats uit NotaAankoop79119_22201269.pdf (Plaats onderpand)",
      "updated_at": "2026-06-04T10:51:01.650Z"
    }
  },
  "updated_at": 1780570261692
}

Rij 402

{
  "dossier_id": "2b45f125-4056-428d-aa11-e92bd06485de",
  "key": "_sources",
  "value_json": {
    "inventarisatie.soort_aanvraag": {
      "source": "Logscan: Aanvraagsoort uit Inventarisatie Logscan (Logtekst, dossierlog)",
      "updated_at": "2026-06-03T23:02:49.226Z"
    },
    "inventarisatie.onderpand_adres": {
      "source": "Logscan: Onderpandadres uit 2026 - Koopovereenkomst.pdf (Onderpand adres)",
      "updated_at": "2026-06-04T08:35:06.940Z"
    },
    "inventarisatie.onderpand_soort": {
      "source": "Logscan: Woningtype uit 2026 - Koopovereenkomst.pdf (Woningtype)",
      "updated_at": "2026-06-04T10:47:46.724Z"
    },
    "inventarisatie.aanvraag_hoofdsom": {
      "source": "Logscan: Gewenste hypotheek / hoofdsom uit Hypotheekakte Schermer 26 ING.pdf (Hoofdsom)",
      "updated_at": "2026-06-04T08:35:06.940Z"
    },
    "inventarisatie.onderpand_bouwjaar": {
      "source": "Logscan: Bouwjaar uit 2026 - Koopovereenkomst.pdf (Bouwjaar)",
      "updated_at": "2026-06-04T10:47:46.724Z"
    },
    "inventarisatie.onderpand_postcode": {
      "source": "Logscan: Postcode uit 2026 - Koopovereenkomst.pdf (Postcode onderpand)",
      "updated_at": "2026-06-04T08:35:06.940Z"
    },
    "inventarisatie.onderpand_huisnummer": {
      "source": "Logscan: Huisnummer uit 2026 - Koopovereenkomst.pdf (Onderpand adres)",
      "updated_at": "2026-06-04T08:35:06.940Z"
    },
    "inventarisatie.onderpand_woonplaats": {
      "source": "Logscan: Plaats uit 2026 - Koopovereenkomst.pdf (Plaats onderpand)",
      "updated_at": "2026-06-04T08:35:06.940Z"
    },
    "inventarisatie.aanvraag_offertedatum": {
      "source": "Logscan: Offertedatum uit 2026 - Koopovereenkomst.pdf (Offertedatum)",
      "updated_at": "2026-06-04T10:47:46.724Z"
    },
    "inventarisatie.onderpand_marktwaarde": {
      "source": "Logscan: Marktwaarde / taxatiewaarde uit 2026 - Koopovereenkomst.pdf (Marktwaarde)",
      "updated_at": "2026-06-04T08:35:06.940Z"
    },
    "inventarisatie.aanvraag_geldverstrekker": {
      "source": "Logscan: Geldverstrekker uit Hypotheekakte Schermer 26 ING.pdf (Geldverstrekker)",
      "updated_at": "2026-06-04T08:35:06.940Z"
    }
  },
  "updated_at": 1780570066778
}

Rij 403

{
  "dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
  "key": "aanvraagproces-stukken",
  "value_json": {
    "log": [
      {
        "at": "2026-06-04T08:55:43.737932Z",
        "result": "Legitimatiebewijs A1/A2 gekoppeld aan privacy-safe visueel geverifieerde ID-documentbestanden; hypotheekaanvraagfallback verwijderd.",
        "command": "hermes-link-real-id-documents"
      },
      {
        "at": "2026-06-01T21:01:58.984Z",
        "result": "+0 stukken, 26 bestand(en) gekoppeld",
        "command": "auto-detect"
      },
      {
        "at": "2026-05-23T00:00:00.000Z",
        "result": "inkomensdocumenten opnieuw 1-op-1 gekoppeld per aanvrager",
        "command": "manual-correct-after-autodetect"
      },
      {
        "at": "2026-05-23T19:05:27.894Z",
        "result": "+0 stukken, 4 bestand(en) gekoppeld",
        "command": "auto-detect"
      },
      {
        "at": "2026-05-23T15:48:27Z",
        "result": "Werkgeversverklaringen en salarisstroken per aanvrager gecorrigeerd; geen klantverzending.",
        "command": "hermes-correct-upload3-links"
      },
      {
        "at": "2026-05-23T15:44:34.926Z",
        "result": "+0 stukken, 4 bestand(en) gekoppeld",
        "command": "auto-detect"
      },
      {
        "at": "2026-05-23T15:44:19.838Z",
        "result": "+11 stukken, 4 bestand(en) gekoppeld",
        "command": "auto-detect"
      }
    ],
    "stukken": [
      {
        "id": "c6f5f2e3-f4d7-4149-ba85-a18b5031934d",
        "type": "id_bewijs",
        "label": "Legitimatiebewijs aanvrager 1",
        "status": "ontvangen",
        "fileIds": [
          "65854f44-332b-4ec4-861c-744745bb45f7"
        ],
        "history": [
          {
            "at": "2026-06-01T21:01:58.984Z",
            "who": "auto",
            "status": "ontvangen"
          },
          {
            "at": "2026-06-04T08:55:43.737932Z",
            "who": "hermes",
            "status": "ontvangen",
            "notitie": "Hermes privacy-safe visuele classificatie: Nederlands ID-document, voor- en achterzijde zichtbaar; gekoppeld als legitimatiebewijs A1."
          }
        ],
        "notitie": "Correct gekoppeld: echt legitimatie-/ID-document visueel privacy-safe geverifieerd; oude generieke hypotheekaanvraagfallback verwijderd.",
        "persoon": "a1",
        "required": true,
        "createdAt": "2026-05-23T15:44:19.838Z",
        "bevindingen": [],
        "documentLinks": [
          {
            "role": "primary",
            "fileId": "65854f44-332b-4ec4-861c-744745bb45f7",
            "linkedAt": "2026-06-04T08:55:43.737932Z",
            "linkedBy": "hermes",
            "matchReason": "privacy-safe visuele ID-classificatie + aanvrager-match; geen OCR-autodetect fallback"
          }
        ]
      },
      {
        "id": "638f0c2d-8ebb-4145-9762-caa242466021",
        "type": "id_bewijs",
        "label": "Legitimatiebewijs aanvrager 2",
        "status": "ontvangen",
        "fileIds": [
          "05a85546-8078-46f4-bb56-e7d195300e7a"
        ],
        "history": [
          {
            "at": "2026-06-04T08:55:43.737932Z",
            "who": "hermes",
            "status": "ontvangen",
            "notitie": "Hermes privacy-safe visuele classificatie: Nederlands ID-document/verblijfsdocument, voor- en achterzijde zichtbaar; gekoppeld als legitimatiebewijs A2."
          }
        ],
        "notitie": "Correct gekoppeld: echt legitimatie-/ID-document visueel privacy-safe geverifieerd; oude generieke hypotheekaanvraagfallback verwijderd.",
        "persoon": "a2",
        "required": true,
        "createdAt": "2026-05-23T15:44:19.838Z",
        "bevindingen": [],
        "documentLinks": [
          {
            "role": "primary",
            "fileId": "05a85546-8078-46f4-bb56-e7d195300e7a",
            "linkedAt": "2026-06-04T08:55:43.737932Z",
            "linkedBy": "hermes",
            "matchReason": "privacy-safe visuele ID-classificatie + aanvrager-match; geen OCR-autodetect fallback"
          }
        ]
      },
      {
        "id": "b2b73992-5ce2-4048-b25b-68e54659d37c",
        "type": "werkgeversverklaring",
        "label": "Werkgeversverklaring A1",
        "status": "ontvangen",
        "fileIds": [
          "9685cdb7-47a0-47fb-9976-259de59f9f34",
          "d8394448-871d-4dbd-9e68-b8d2922fbb56",
          "a1a08b95-3f90-44da-9f86-e49dafc2f858",
          "dbbadf0c-623b-44ac-aea6-2f691488d5d7",
          "1e494708-0798-4e20-b572-ea5a61fa1803",
          "799e046a-1527-4548-bf76-54118985eee6",
          "77ab0cfb-3f04-4d72-97f1-b618f9e6e8ab",
          "ceefabcf-cfc1-4853-bfa1-5dd5bd6255ee",
          "3a665afb-68c4-4170-b326-14678c48e01f",
          "406a4ee0-74d6-454f-95c7-88c1b5d463b0",
          "0caf5250-810f-458e-863d-5956cf91d714"
        ],
        "history": [
          {
            "at": "2026-05-23T15:48:27Z",
            "who": "user",
            "status": "ontvangen",
            "notitie": "Correct gekoppeld document ontvangen"
          },
          {
            "at": "2026-05-23T15:44:19.838Z",
            "who": "auto",
            "status": "ontvangen"
          }
        ],
        "notitie": "Correct gekoppeld: documenttype en aanvrager gecontroleerd. Auto-detect duplicate/cross-link bug gecorrigeerd.",
        "pairKey": "income-a1",
        "persoon": "a1",
        "required": true,
        "createdAt": "2026-05-23T15:44:19.838Z",
        "bevindingen": [],
        "documentLinks": [
          {
            "role": "primary",
            "fileId": "0caf5250-810f-458e-863d-5956cf91d714",
            "linkedAt": "2026-06-01T21:01:58.984Z",
            "linkedBy": "auto",
            "matchReason": "werkgeversverklaring"
          },
          {
            "role": "primary",
            "fileId": "406a4ee0-74d6-454f-95c7-88c1b5d463b0",
            "linkedAt": "2026-06-01T21:01:58.984Z",
            "linkedBy": "auto",
            "matchReason": "werkgeversverklaring" ... [afgekapt: 12413 tekens]

Rij 404

{
  "dossier_id": "6b20b045-17cc-4125-8e3e-f2145726b84a",
  "key": "hdn_dossier",
  "value_json": {
    "schema": "adviestool.hdn_like",
    "bronnen": {
      "partijen.p1.contact.email": [
        {
          "at": 1780561967792,
          "value": "jeroendegraaf2015@hotmail.com",
          "context": "inventarisatie.a1.email",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.nhg": [
        {
          "at": 1780561967792,
          "value": "NHG",
          "context": "base_import.products[].norm",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "partijen.p1.woonadres.plaats": [
        {
          "at": 1780561967792,
          "value": "Lelystad",
          "context": "inventarisatie.a1.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.plaats": [
        {
          "at": 1780561967792,
          "value": "Lelystad",
          "context": "inventarisatie.a2.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.postcode": [
        {
          "at": 1780561967792,
          "value": "8231 EA",
          "context": "inventarisatie.a1.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.postcode": [
        {
          "at": 1780561967792,
          "value": "8231 EA",
          "context": "inventarisatie.a2.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.hoofdsom": [
        {
          "at": 1780561967792,
          "value": "157500.00",
          "context": "base_import.products[].inhoud",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "partijen.p1.woonadres.adresregel": [
        {
          "at": 1780561967792,
          "value": "Kempenaar 05 22",
          "context": "inventarisatie.a1.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.adresregel": [
        {
          "at": 1780561967792,
          "value": "Kempenaar 05 22",
          "context": "inventarisatie.a2.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.contact.telefoonPrive": [
        {
          "at": 1780561967792,
          "value": "0610770109",
          "context": "inventarisatie.a1.telefoon_prive",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.natuurlijkPersoon.naam": [
        {
          "at": 1780561967792,
          "value": "Graaf, Jeroen de (J)",
          "context": "inventarisatie.a1.naam",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.aflossingsvorm": [
        {
          "at": 1780561967792,
          "value": "Aflossingsvrij, Annuitair",
          "context": "base_import.products[].productsoort",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "hypotheken.aangevraagd.geldverstrekker": [
        {
          "at": 1780561967792,
          "value": "Merius Hypotheken",
          "context": "base_import.products[].maatschappij",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ]
    },
    "version": 1,
    "inkomens": {
      "inkomen1": {
        "soort": "loondienst",
        "partyId": "p1"
      },
      "inkomen2": {
        "soort": "loondienst",
        "partyId": "p2"
      }
    },
    "objecten": {
      "teFinancieren": {
        "soort": "te_financieren_object"
      },
      "vorigeWoning1": {
        "soort": "vorige_woning"
      },
      "huidigeWoning1": {
        "soort": "huidige_woning"
      }
    },
    "partijen": {
      "p1": {
        "rol": "aanvrager",
        "contact": {
          "email": "jeroendegraaf2015@hotmail.com",
          "telefoonPrive": "0610770109"
        },
        "woonadres": {
          "plaats": "Lelystad",
          "postcode": "8231 EA",
          "adresregel": "Kempenaar 05 22"
        },
        "volgnummer": 1,
        "natuurlijkPersoon": {
          "naam": "Graaf, Jeroen de (J)"
        }
      },
      "p2": {
        "rol": "aanvrager",
        "woonadres": {
          "plaats": "Lelystad",
          "postcode": "8231 EA",
          "adresregel": "Kempenaar 05 22"
        },
        "volgnummer": 2
      }
    },
    "dossierId": "6b20b045-17cc-4125-8e3e-f2145726b84a",
    "rebuiltAt": 1780561967724,
    "documenten": [],
    "hypotheken": {
      "bestaand1": {
        "soort": "bestaande_hypotheek",
        "objectId": "huidigeWoning1"
      },
      "aangevraagd": {
        "nhg": "NHG",
        "soort": "aangevraagde_hypotheek",
        "hoofdsom": "157500.00",
        "objectId": "teFinancieren",
        "aflossingsvorm": "Aflossingsvrij, Annuitair",
        "geldverstrekker": "Merius Hypotheken"
      }
    },
    "statistiek": {
      "documenten": 0,
      "extracties": 0,
      "gelezenItems": 0,
      "gemapteWaarden": 13,
      "overgeslagenItems": 0,
      "projectieWijzigingen": 4
    },
    "gekozenBron": {
      "partijen.p1.contact.email": {
        "at": 1780561967792,
        "value": "jeroendegraaf2015@hotmail.com",
        "context": "inventarisatie.a1.email",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "hypotheken.aangevraagd.nhg": {
        "at": 1780561967792,
        "value": "NHG",
        "context": "base_import.products[].norm",
        "confidence": 0.68,
        "sourceKind": "extractie"
      },
      "partijen.p1.woonadres.plaats": {
        "at": 1780561967792,
        "value": "Lelystad",
        "context": "inventa ... [afgekapt: 2488 tekens]

Rij 405

{
  "dossier_id": "6b20b045-17cc-4125-8e3e-f2145726b84a",
  "key": "_sources",
  "value_json": {
    "inventarisatie.data.aanvraag_nhg": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.nhg",
      "updated_at": "2026-06-04T08:32:47.724Z"
    },
    "inventarisatie.data.aanvraag_hoofdsom": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.hoofdsom",
      "updated_at": "2026-06-04T08:32:47.724Z"
    },
    "inventarisatie.data.aanvraag_productnaam": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.aflossingsvorm",
      "updated_at": "2026-06-04T08:32:47.724Z"
    },
    "inventarisatie.data.aanvraag_geldverstrekker": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.geldverstrekker",
      "updated_at": "2026-06-04T08:32:47.724Z"
    }
  },
  "updated_at": 1780561967870
}

Rij 406

{
  "dossier_id": "6b20b045-17cc-4125-8e3e-f2145726b84a",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Graaf, Jeroen de (J)",
      "adres": "Kempenaar 05 22",
      "email": "jeroendegraaf2015@hotmail.com",
      "postcode": "8231 EA",
      "woonplaats": "Lelystad",
      "telefoon_prive": "0610770109"
    },
    "a2": {
      "adres": "Kempenaar 05 22",
      "postcode": "8231 EA",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "157500.00",
          "status": "Lopend",
          "artikel": "Merius annuiteitenhypotheek, Merius aflossingsvrije hypotheek",
          "tekendatum": "25569",
          "productnaam": "Merius annuiteitenhypotheek, Merius aflossingsvrije hypotheek",
          "maatschappij": "Merius Hypotheken",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3011318",
          "passeeringangsdatum": "2019-03-11"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "tekendatum": "25569",
          "productnaam": "Credit Life International Overlijdensrisicoverzekering - Annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2683537",
          "passeeringangsdatum": "2019-03-01"
        }
      ],
      "aanvraag_nhg": "NHG",
      "crmdossier_id": "184299",
      "dossiernummer": "184299",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht",
      "aanvraag_hoofdsom": "157500.00",
      "aanvraag_productnaam": "Aflossingsvrij, Annuitair",
      "aanvraag_geldverstrekker": "Merius Hypotheken"
    }
  },
  "updated_at": 1780561967843
}

Rij 407

{
  "dossier_id": "cef57c94-7077-466a-8e57-7f0a86dd560f",
  "key": "hdn_dossier",
  "value_json": {
    "schema": "adviestool.hdn_like",
    "bronnen": {
      "partijen.p1.contact.email": [
        {
          "at": 1780561966268,
          "value": "rdzwarthoff@gmail.com",
          "context": "inventarisatie.a1.email",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.plaats": [
        {
          "at": 1780561966268,
          "value": "Lelystad",
          "context": "inventarisatie.a1.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.plaats": [
        {
          "at": 1780561966268,
          "value": "Lelystad",
          "context": "inventarisatie.a2.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.postcode": [
        {
          "at": 1780561966268,
          "value": "8243 HV",
          "context": "inventarisatie.a1.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.postcode": [
        {
          "at": 1780561966268,
          "value": "8243 HV",
          "context": "inventarisatie.a2.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.hoofdsom": [
        {
          "at": 1780561966268,
          "value": "0.00",
          "context": "base_import.products[].inhoud",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "partijen.p1.woonadres.adresregel": [
        {
          "at": 1780561966268,
          "value": "Stadseiland 98",
          "context": "inventarisatie.a1.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.adresregel": [
        {
          "at": 1780561966268,
          "value": "Stadseiland 98",
          "context": "inventarisatie.a2.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.contact.telefoonPrive": [
        {
          "at": 1780561966268,
          "value": "06-47458845",
          "context": "inventarisatie.a1.telefoon_prive",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.natuurlijkPersoon.naam": [
        {
          "at": 1780561966268,
          "value": "Zwarthoff, Rogier (R.D.)",
          "context": "inventarisatie.a1.naam",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.aflossingsvorm": [
        {
          "at": 1780561966268,
          "value": "Dienst BTW vrij",
          "context": "base_import.products[].productsoort",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "hypotheken.aangevraagd.geldverstrekker": [
        {
          "at": 1780561966268,
          "value": "Eigen kantoor",
          "context": "base_import.products[].maatschappij",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ]
    },
    "version": 1,
    "inkomens": {
      "inkomen1": {
        "soort": "loondienst",
        "partyId": "p1"
      },
      "inkomen2": {
        "soort": "loondienst",
        "partyId": "p2"
      }
    },
    "objecten": {
      "teFinancieren": {
        "soort": "te_financieren_object"
      },
      "vorigeWoning1": {
        "soort": "vorige_woning"
      },
      "huidigeWoning1": {
        "soort": "huidige_woning"
      }
    },
    "partijen": {
      "p1": {
        "rol": "aanvrager",
        "contact": {
          "email": "rdzwarthoff@gmail.com",
          "telefoonPrive": "06-47458845"
        },
        "woonadres": {
          "plaats": "Lelystad",
          "postcode": "8243 HV",
          "adresregel": "Stadseiland 98"
        },
        "volgnummer": 1,
        "natuurlijkPersoon": {
          "naam": "Zwarthoff, Rogier (R.D.)"
        }
      },
      "p2": {
        "rol": "aanvrager",
        "woonadres": {
          "plaats": "Lelystad",
          "postcode": "8243 HV",
          "adresregel": "Stadseiland 98"
        },
        "volgnummer": 2
      }
    },
    "dossierId": "cef57c94-7077-466a-8e57-7f0a86dd560f",
    "rebuiltAt": 1780561966207,
    "documenten": [],
    "hypotheken": {
      "bestaand1": {
        "soort": "bestaande_hypotheek",
        "objectId": "huidigeWoning1"
      },
      "aangevraagd": {
        "soort": "aangevraagde_hypotheek",
        "hoofdsom": "0.00",
        "objectId": "teFinancieren",
        "aflossingsvorm": "Dienst BTW vrij",
        "geldverstrekker": "Eigen kantoor"
      }
    },
    "statistiek": {
      "documenten": 0,
      "extracties": 0,
      "gelezenItems": 0,
      "gemapteWaarden": 12,
      "overgeslagenItems": 0,
      "projectieWijzigingen": 3
    },
    "gekozenBron": {
      "partijen.p1.contact.email": {
        "at": 1780561966268,
        "value": "rdzwarthoff@gmail.com",
        "context": "inventarisatie.a1.email",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p1.woonadres.plaats": {
        "at": 1780561966268,
        "value": "Lelystad",
        "context": "inventarisatie.a1.woonplaats",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p2.woonadres.plaats": {
        "at": 1780561966268,
        "value": "Lelystad",
        "context": "inventarisatie.a2.woonplaats",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p1.woonadres.postcode": {
        "at": 1780561966268,
        "value": "8243 HV",
        "context": "inventarisatie.a1.postcode",
        "confidence": 0.55,
        "sourceKind": "inventar ... [afgekapt: 1940 tekens]

Rij 408

{
  "dossier_id": "cef57c94-7077-466a-8e57-7f0a86dd560f",
  "key": "_sources",
  "value_json": {
    "inventarisatie.data.aanvraag_hoofdsom": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.hoofdsom",
      "updated_at": "2026-06-04T08:32:46.207Z"
    },
    "inventarisatie.data.aanvraag_productnaam": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.aflossingsvorm",
      "updated_at": "2026-06-04T08:32:46.207Z"
    },
    "inventarisatie.data.aanvraag_geldverstrekker": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.geldverstrekker",
      "updated_at": "2026-06-04T08:32:46.207Z"
    }
  },
  "updated_at": 1780561966347
}

Rij 409

{
  "dossier_id": "cef57c94-7077-466a-8e57-7f0a86dd560f",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Zwarthoff, Rogier (R.D.)",
      "adres": "Stadseiland 98",
      "email": "rdzwarthoff@gmail.com",
      "postcode": "8243 HV",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06-47458845"
    },
    "a2": {
      "adres": "Stadseiland 98",
      "postcode": "8243 HV",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
          "tekendatum": "25569",
          "productnaam": "TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
          "maatschappij": "TAF",
          "productsoort": "Overlijdensrisicoverzekering",
          "factuurbedrag": "",
          "offertenummer": "2375534",
          "passeeringangsdatum": "2017-04-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Overlijdensrisicoverzekering",
          "tekendatum": "25569",
          "productnaam": "Overlijdensrisicoverzekering",
          "maatschappij": "Brand New Day",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "52455593",
          "passeeringangsdatum": "2013-12-01"
        },
        {
          "norm": "",
          "type": "Dienst",
          "inhoud": "0.00",
          "status": "Dienstverlening afgenomen",
          "artikel": "Advies nieuwe Hypotheek/Doorstromer",
          "tekendatum": "2022-08-30",
          "productnaam": "Advies nieuwe Hypotheek/Doorstromer",
          "maatschappij": "Eigen kantoor",
          "productsoort": "Dienst BTW vrij",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2022-08-30"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-12-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-12-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2024-08-19"
        },
        {
          "norm": "",
          "type": "Verkoopdienst",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen makelaardij",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2020-07-08"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "tekendatum": "25569",
          "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
          "maatschappij": "Voogd & Voogd",
          "productsoort": "Aansprakelijkheid, Inboedel, Opstal",
          "factuurbedrag": "",
          "offertenummer": "116254565385",
          "passeeringangsdatum": "2013-12-17"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal",
          "tekendatum": "25569",
          "productnaam": "Opstal",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Opstal",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-07-28"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "109850.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2023-08-01"
        }
      ],
      "crmdossier_id": "96122",
      "dossiernummer": "96122",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht",
      "aanvraag_hoofdsom": "0.00",
      "aanvraag_productnaam": "Dienst BTW vrij",
      "aanvraag_geldverstrekker": "Eigen kan ... [afgekapt: 10 tekens]

Rij 410

{
  "dossier_id": "f5e4e84a-9466-4ade-bd16-e3318382b45d",
  "key": "hdn_dossier",
  "value_json": {
    "schema": "adviestool.hdn_like",
    "bronnen": {
      "partijen.p1.contact.email": [
        {
          "at": 1780561965810,
          "value": "sietsejp@hotmail.com",
          "context": "inventarisatie.a1.email",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.contact.email": [
        {
          "at": 1780561965810,
          "value": "samanthaluking@gmail.com",
          "context": "inventarisatie.a2.email",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.nhg": [
        {
          "at": 1780561965810,
          "value": "NHG",
          "context": "base_import.products[].norm",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "partijen.p1.woonadres.plaats": [
        {
          "at": 1780561965802,
          "value": "Almere",
          "context": "inventarisatie.a1.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.plaats": [
        {
          "at": 1780561965810,
          "value": "Almere",
          "context": "inventarisatie.a2.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.postcode": [
        {
          "at": 1780561965802,
          "value": "1338 XL",
          "context": "inventarisatie.a1.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.postcode": [
        {
          "at": 1780561965810,
          "value": "1338 XL",
          "context": "inventarisatie.a2.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.hoofdsom": [
        {
          "at": 1780561965810,
          "value": "321094.00",
          "context": "base_import.products[].inhoud",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "partijen.p1.woonadres.adresregel": [
        {
          "at": 1780561965802,
          "value": "Lathyruspad 10",
          "context": "inventarisatie.a1.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.adresregel": [
        {
          "at": 1780561965810,
          "value": "Lathyruspad 10",
          "context": "inventarisatie.a2.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.contact.telefoonPrive": [
        {
          "at": 1780561965802,
          "value": "0620794006",
          "context": "inventarisatie.a1.telefoon_prive",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.natuurlijkPersoon.naam": [
        {
          "at": 1780561965802,
          "value": "Luking, Pietersma (S.)",
          "context": "inventarisatie.a1.naam",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.aflossingsvorm": [
        {
          "at": 1780561965810,
          "value": "Annuitair",
          "context": "base_import.products[].productsoort",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "hypotheken.aangevraagd.geldverstrekker": [
        {
          "at": 1780561965810,
          "value": "ING Bank",
          "context": "base_import.products[].maatschappij",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ]
    },
    "version": 1,
    "inkomens": {
      "inkomen1": {
        "soort": "loondienst",
        "partyId": "p1"
      },
      "inkomen2": {
        "soort": "loondienst",
        "partyId": "p2"
      }
    },
    "objecten": {
      "teFinancieren": {
        "soort": "te_financieren_object"
      },
      "vorigeWoning1": {
        "soort": "vorige_woning"
      },
      "huidigeWoning1": {
        "soort": "huidige_woning"
      }
    },
    "partijen": {
      "p1": {
        "rol": "aanvrager",
        "contact": {
          "email": "sietsejp@hotmail.com",
          "telefoonPrive": "0620794006"
        },
        "woonadres": {
          "plaats": "Almere",
          "postcode": "1338 XL",
          "adresregel": "Lathyruspad 10"
        },
        "volgnummer": 1,
        "natuurlijkPersoon": {
          "naam": "Luking, Pietersma (S.)"
        }
      },
      "p2": {
        "rol": "aanvrager",
        "contact": {
          "email": "samanthaluking@gmail.com"
        },
        "woonadres": {
          "plaats": "Almere",
          "postcode": "1338 XL",
          "adresregel": "Lathyruspad 10"
        },
        "volgnummer": 2
      }
    },
    "dossierId": "f5e4e84a-9466-4ade-bd16-e3318382b45d",
    "rebuiltAt": 1780561965737,
    "documenten": [],
    "hypotheken": {
      "bestaand1": {
        "soort": "bestaande_hypotheek",
        "objectId": "huidigeWoning1"
      },
      "aangevraagd": {
        "nhg": "NHG",
        "soort": "aangevraagde_hypotheek",
        "hoofdsom": "321094.00",
        "objectId": "teFinancieren",
        "aflossingsvorm": "Annuitair",
        "geldverstrekker": "ING Bank"
      }
    },
    "statistiek": {
      "documenten": 0,
      "extracties": 0,
      "gelezenItems": 0,
      "gemapteWaarden": 14,
      "overgeslagenItems": 0,
      "projectieWijzigingen": 4
    },
    "gekozenBron": {
      "partijen.p1.contact.email": {
        "at": 1780561965810,
        "value": "sietsejp@hotmail.com",
        "context": "inventarisatie.a1.email",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p2.contact.email": {
        "at": 1780561965810,
        "value" ... [afgekapt: 2948 tekens]

Rij 411

{
  "dossier_id": "f5e4e84a-9466-4ade-bd16-e3318382b45d",
  "key": "_sources",
  "value_json": {
    "inventarisatie.data.aanvraag_nhg": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.nhg",
      "updated_at": "2026-06-04T08:32:45.737Z"
    },
    "inventarisatie.data.aanvraag_hoofdsom": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.hoofdsom",
      "updated_at": "2026-06-04T08:32:45.737Z"
    },
    "inventarisatie.data.aanvraag_productnaam": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.aflossingsvorm",
      "updated_at": "2026-06-04T08:32:45.737Z"
    },
    "inventarisatie.data.aanvraag_geldverstrekker": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.geldverstrekker",
      "updated_at": "2026-06-04T08:32:45.737Z"
    }
  },
  "updated_at": 1780561965906
}

Rij 412

{
  "dossier_id": "f5e4e84a-9466-4ade-bd16-e3318382b45d",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Luking, Pietersma (S.)",
      "adres": "Lathyruspad 10",
      "email": "sietsejp@hotmail.com",
      "postcode": "1338 XL",
      "woonplaats": "Almere",
      "telefoon_prive": "0620794006"
    },
    "a2": {
      "adres": "Lathyruspad 10",
      "email": "samanthaluking@gmail.com",
      "postcode": "1338 XL",
      "woonplaats": "Almere"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "321094.00",
          "status": "Dossier compleet naar MIJ",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2025-12-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "310000.00",
          "status": "Aanvraag aanvullen (vanuit maatschappij)",
          "artikel": "Woonnu Annuïtair",
          "tekendatum": "25569",
          "productnaam": "Woonnu Annuïtair",
          "maatschappij": "Woonnu",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "3587585",
          "passeeringangsdatum": "2025-12-01"
        }
      ],
      "aanvraag_nhg": "NHG",
      "crmdossier_id": "293585",
      "dossiernummer": "293585",
      "dossierstatus": "Nieuw",
      "producten_bron": "Excel klantenoverzicht",
      "aanvraag_hoofdsom": "321094.00",
      "aanvraag_productnaam": "Annuitair",
      "aanvraag_geldverstrekker": "ING Bank"
    }
  },
  "updated_at": 1780561965882
}

Rij 413

{
  "dossier_id": "c6406b9a-7e46-4796-8d98-9f789737f132",
  "key": "hdn_dossier",
  "value_json": {
    "schema": "adviestool.hdn_like",
    "bronnen": {
      "partijen.p1.contact.email": [
        {
          "at": 1780561961816,
          "value": "hnaushad50@yahoo.com",
          "context": "inventarisatie.a1.email",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.contact.email": [
        {
          "at": 1780561961816,
          "value": "samiyakhanum123@yahoo.com",
          "context": "inventarisatie.a2.email",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.plaats": [
        {
          "at": 1780561961816,
          "value": "Utrecht",
          "context": "inventarisatie.a1.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.plaats": [
        {
          "at": 1780561961816,
          "value": "Utrecht",
          "context": "inventarisatie.a2.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.postcode": [
        {
          "at": 1780561961816,
          "value": "3523 HX",
          "context": "inventarisatie.a1.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.postcode": [
        {
          "at": 1780561961816,
          "value": "3523 HX",
          "context": "inventarisatie.a2.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.hoofdsom": [
        {
          "at": 1780561961816,
          "value": "0.00",
          "context": "base_import.products[].inhoud",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "partijen.p1.woonadres.adresregel": [
        {
          "at": 1780561961815,
          "value": "Ridderplantsoen 21",
          "context": "inventarisatie.a1.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.adresregel": [
        {
          "at": 1780561961816,
          "value": "Ridderplantsoen 21",
          "context": "inventarisatie.a2.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.contact.telefoonPrive": [
        {
          "at": 1780561961816,
          "value": "0657118539",
          "context": "inventarisatie.a1.telefoon_prive",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.natuurlijkPersoon.naam": [
        {
          "at": 1780561961815,
          "value": "Ali (S.H.N.)",
          "context": "inventarisatie.a1.naam",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.natuurlijkPersoon.naam": [
        {
          "at": 1780561961816,
          "value": "Khanum (S.)",
          "context": "inventarisatie.a2.naam",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.geldverstrekker": [
        {
          "at": 1780561961816,
          "value": "Eigen kantoor",
          "context": "base_import.products[].maatschappij",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ]
    },
    "version": 1,
    "inkomens": {
      "inkomen1": {
        "soort": "loondienst",
        "partyId": "p1"
      },
      "inkomen2": {
        "soort": "loondienst",
        "partyId": "p2"
      }
    },
    "objecten": {
      "teFinancieren": {
        "soort": "te_financieren_object"
      },
      "vorigeWoning1": {
        "soort": "vorige_woning"
      },
      "huidigeWoning1": {
        "soort": "huidige_woning"
      }
    },
    "partijen": {
      "p1": {
        "rol": "aanvrager",
        "contact": {
          "email": "hnaushad50@yahoo.com",
          "telefoonPrive": "0657118539"
        },
        "woonadres": {
          "plaats": "Utrecht",
          "postcode": "3523 HX",
          "adresregel": "Ridderplantsoen 21"
        },
        "volgnummer": 1,
        "natuurlijkPersoon": {
          "naam": "Ali (S.H.N.)"
        }
      },
      "p2": {
        "rol": "aanvrager",
        "contact": {
          "email": "samiyakhanum123@yahoo.com"
        },
        "woonadres": {
          "plaats": "Utrecht",
          "postcode": "3523 HX",
          "adresregel": "Ridderplantsoen 21"
        },
        "volgnummer": 2,
        "natuurlijkPersoon": {
          "naam": "Khanum (S.)"
        }
      }
    },
    "dossierId": "c6406b9a-7e46-4796-8d98-9f789737f132",
    "rebuiltAt": 1780561961742,
    "documenten": [],
    "hypotheken": {
      "bestaand1": {
        "soort": "bestaande_hypotheek",
        "objectId": "huidigeWoning1"
      },
      "aangevraagd": {
        "soort": "aangevraagde_hypotheek",
        "hoofdsom": "0.00",
        "objectId": "teFinancieren",
        "geldverstrekker": "Eigen kantoor"
      }
    },
    "statistiek": {
      "documenten": 0,
      "extracties": 0,
      "gelezenItems": 0,
      "gemapteWaarden": 13,
      "overgeslagenItems": 0,
      "projectieWijzigingen": 2
    },
    "gekozenBron": {
      "partijen.p1.contact.email": {
        "at": 1780561961816,
        "value": "hnaushad50@yahoo.com",
        "context": "inventarisatie.a1.email",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p2.contact.email": {
        "at": 1780561961816,
        "value": "samiyakhanum123@yahoo.com",
        "context": "inventarisatie.a2.email",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p1.woonadres.plaats": {
        "at": 1780561961816,
        "value ... [afgekapt: 2492 tekens]

Rij 414

{
  "dossier_id": "c6406b9a-7e46-4796-8d98-9f789737f132",
  "key": "_sources",
  "value_json": {
    "inventarisatie.data.aanvraag_hoofdsom": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.hoofdsom",
      "updated_at": "2026-06-04T08:32:41.742Z"
    },
    "inventarisatie.data.aanvraag_geldverstrekker": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.geldverstrekker",
      "updated_at": "2026-06-04T08:32:41.742Z"
    }
  },
  "updated_at": 1780561961911
}

Rij 415

{
  "dossier_id": "c6406b9a-7e46-4796-8d98-9f789737f132",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Ali (S.H.N.)",
      "adres": "Ridderplantsoen 21",
      "email": "hnaushad50@yahoo.com",
      "postcode": "3523 HX",
      "woonplaats": "Utrecht",
      "telefoon_prive": "0657118539"
    },
    "a2": {
      "naam": "Khanum (S.)",
      "adres": "Ridderplantsoen 21",
      "email": "samiyakhanum123@yahoo.com",
      "postcode": "3523 HX",
      "woonplaats": "Utrecht"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2025-08-26"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2025-08-26"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "265000.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
          "maatschappij": "ABN AMRO",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2025-10-01"
        }
      ],
      "crmdossier_id": "291749",
      "dossiernummer": "291749",
      "dossierstatus": "Nieuw",
      "producten_bron": "Excel klantenoverzicht",
      "aanvraag_hoofdsom": "0.00",
      "aanvraag_geldverstrekker": "Eigen kantoor"
    }
  },
  "updated_at": 1780561961882
}

Rij 416

{
  "dossier_id": "eec8ad9e-b509-4cc3-898e-70e82feac4a9",
  "key": "hdn_dossier",
  "value_json": {
    "schema": "adviestool.hdn_like",
    "bronnen": {
      "partijen.p1.contact.email": [
        {
          "at": 1780561960233,
          "value": "h.kuipers@solcon.nl",
          "context": "inventarisatie.a1.email",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.nhg": [
        {
          "at": 1780561960234,
          "value": "Geldverstrekker",
          "context": "base_import.products[].norm",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "partijen.p1.woonadres.plaats": [
        {
          "at": 1780561960233,
          "value": "Dronten",
          "context": "inventarisatie.a1.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.plaats": [
        {
          "at": 1780561960233,
          "value": "Dronten",
          "context": "inventarisatie.a2.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.postcode": [
        {
          "at": 1780561960233,
          "value": "8251 NN",
          "context": "inventarisatie.a1.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.postcode": [
        {
          "at": 1780561960233,
          "value": "8251 NN",
          "context": "inventarisatie.a2.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.hoofdsom": [
        {
          "at": 1780561960234,
          "value": "300000.00",
          "context": "base_import.products[].inhoud",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "partijen.p1.woonadres.adresregel": [
        {
          "at": 1780561960233,
          "value": "Zomer 40 40",
          "context": "inventarisatie.a1.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.adresregel": [
        {
          "at": 1780561960233,
          "value": "Zomer 40 40",
          "context": "inventarisatie.a2.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.contact.telefoonPrive": [
        {
          "at": 1780561960233,
          "value": "0321381303",
          "context": "inventarisatie.a1.telefoon_prive",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.natuurlijkPersoon.naam": [
        {
          "at": 1780561960233,
          "value": "Kuipers, Kuipers Hiddo (H)",
          "context": "inventarisatie.a1.naam",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.aflossingsvorm": [
        {
          "at": 1780561960234,
          "value": "Aflossingsvrij, Annuitair",
          "context": "base_import.products[].productsoort",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "hypotheken.aangevraagd.geldverstrekker": [
        {
          "at": 1780561960234,
          "value": "Delta Lloyd",
          "context": "base_import.products[].maatschappij",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ]
    },
    "version": 1,
    "inkomens": {
      "inkomen1": {
        "soort": "loondienst",
        "partyId": "p1"
      },
      "inkomen2": {
        "soort": "loondienst",
        "partyId": "p2"
      }
    },
    "objecten": {
      "teFinancieren": {
        "soort": "te_financieren_object"
      },
      "vorigeWoning1": {
        "soort": "vorige_woning"
      },
      "huidigeWoning1": {
        "soort": "huidige_woning"
      }
    },
    "partijen": {
      "p1": {
        "rol": "aanvrager",
        "contact": {
          "email": "h.kuipers@solcon.nl",
          "telefoonPrive": "0321381303"
        },
        "woonadres": {
          "plaats": "Dronten",
          "postcode": "8251 NN",
          "adresregel": "Zomer 40 40"
        },
        "volgnummer": 1,
        "natuurlijkPersoon": {
          "naam": "Kuipers, Kuipers Hiddo (H)"
        }
      },
      "p2": {
        "rol": "aanvrager",
        "woonadres": {
          "plaats": "Dronten",
          "postcode": "8251 NN",
          "adresregel": "Zomer 40 40"
        },
        "volgnummer": 2
      }
    },
    "dossierId": "eec8ad9e-b509-4cc3-898e-70e82feac4a9",
    "rebuiltAt": 1780561960166,
    "documenten": [],
    "hypotheken": {
      "bestaand1": {
        "soort": "bestaande_hypotheek",
        "objectId": "huidigeWoning1"
      },
      "aangevraagd": {
        "nhg": "Geldverstrekker",
        "soort": "aangevraagde_hypotheek",
        "hoofdsom": "300000.00",
        "objectId": "teFinancieren",
        "aflossingsvorm": "Aflossingsvrij, Annuitair",
        "geldverstrekker": "Delta Lloyd"
      }
    },
    "statistiek": {
      "documenten": 0,
      "extracties": 0,
      "gelezenItems": 0,
      "gemapteWaarden": 13,
      "overgeslagenItems": 0,
      "projectieWijzigingen": 4
    },
    "gekozenBron": {
      "partijen.p1.contact.email": {
        "at": 1780561960233,
        "value": "h.kuipers@solcon.nl",
        "context": "inventarisatie.a1.email",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "hypotheken.aangevraagd.nhg": {
        "at": 1780561960234,
        "value": "Geldverstrekker",
        "context": "base_import.products[].norm",
        "confidence": 0.68,
        "sourceKind": "extractie"
      },
      "partijen.p1.woonadres.plaats": {
        "at": 1780561960233,
        "value": "Dronten",
        "context": "inventarisatie.a1.woon ... [afgekapt: 2464 tekens]

Rij 417

{
  "dossier_id": "eec8ad9e-b509-4cc3-898e-70e82feac4a9",
  "key": "_sources",
  "value_json": {
    "inventarisatie.data.aanvraag_nhg": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.nhg",
      "updated_at": "2026-06-04T08:32:40.166Z"
    },
    "inventarisatie.data.aanvraag_hoofdsom": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.hoofdsom",
      "updated_at": "2026-06-04T08:32:40.166Z"
    },
    "inventarisatie.data.aanvraag_productnaam": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.aflossingsvorm",
      "updated_at": "2026-06-04T08:32:40.166Z"
    },
    "inventarisatie.data.aanvraag_geldverstrekker": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.geldverstrekker",
      "updated_at": "2026-06-04T08:32:40.166Z"
    }
  },
  "updated_at": 1780561960327
}

Rij 418

{
  "dossier_id": "eec8ad9e-b509-4cc3-898e-70e82feac4a9",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Kuipers, Kuipers Hiddo (H)",
      "adres": "Zomer 40 40",
      "email": "h.kuipers@solcon.nl",
      "postcode": "8251 NN",
      "woonplaats": "Dronten",
      "telefoon_prive": "0321381303"
    },
    "a2": {
      "adres": "Zomer 40 40",
      "postcode": "8251 NN",
      "woonplaats": "Dronten"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "300000.00",
          "status": "Gepasseerd",
          "artikel": "Delta Lloyd Fixe / Aflossingsvrij (Delta Lloyd Budget Hypotheek), Delta Lloyd Annuiteit (Delta Lloyd Budget Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Delta Lloyd Fixe / Aflossingsvrij (Delta Lloyd Budget Hypotheek), Delta Lloyd Annuiteit (Delta Lloyd Budget Hypotheek)",
          "maatschappij": "Delta Lloyd",
          "productsoort": "Aflossingsvrij, Annuitair",
          "factuurbedrag": "",
          "offertenummer": "1595560",
          "passeeringangsdatum": "2017-06-26"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "349582.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek",
          "tekendatum": "25569",
          "productnaam": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek",
          "maatschappij": "Lloyds Bank",
          "productsoort": "Aflossingsvrij",
          "factuurbedrag": "",
          "offertenummer": "2314894",
          "passeeringangsdatum": "2025-12-30"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "58350.00",
          "status": "Aanvraag aanvullen (vanuit maatschappij)",
          "artikel": "NN Aflossingsvrije hypotheek (Reguliere Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "NN Aflossingsvrije hypotheek (Reguliere Hypotheek)",
          "maatschappij": "Nationale Nederlanden",
          "productsoort": "Aflossingsvrij",
          "factuurbedrag": "",
          "offertenummer": "8070358",
          "passeeringangsdatum": "2025-11-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Akkoord",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2021-03-18"
        }
      ],
      "aanvraag_nhg": "Geldverstrekker",
      "crmdossier_id": "150045",
      "dossiernummer": "150045",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht",
      "aanvraag_hoofdsom": "300000.00",
      "aanvraag_productnaam": "Aflossingsvrij, Annuitair",
      "aanvraag_geldverstrekker": "Delta Lloyd"
    }
  },
  "updated_at": 1780561960299
}

Rij 419

{
  "dossier_id": "b6e86ce0-b42c-40a6-a841-21c827ec4a0b",
  "key": "hdn_dossier",
  "value_json": {
    "schema": "adviestool.hdn_like",
    "bronnen": {
      "partijen.p1.contact.email": [
        {
          "at": 1780561959744,
          "value": "avrin.vanderlaan@gmail.com",
          "context": "inventarisatie.a1.email",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.contact.email": [
        {
          "at": 1780561959744,
          "value": "avrin.vanderlaan@merial.com",
          "context": "inventarisatie.a2.email",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.plaats": [
        {
          "at": 1780561959744,
          "value": "Lelystad",
          "context": "inventarisatie.a1.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.plaats": [
        {
          "at": 1780561959744,
          "value": "Lelystad",
          "context": "inventarisatie.a2.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.postcode": [
        {
          "at": 1780561959744,
          "value": "8219 DB",
          "context": "inventarisatie.a1.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.postcode": [
        {
          "at": 1780561959744,
          "value": "8219 DB",
          "context": "inventarisatie.a2.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.hoofdsom": [
        {
          "at": 1780561959745,
          "value": "0.00",
          "context": "base_import.products[].inhoud",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "partijen.p1.woonadres.adresregel": [
        {
          "at": 1780561959744,
          "value": "Groenendaal 55",
          "context": "inventarisatie.a1.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.adresregel": [
        {
          "at": 1780561959744,
          "value": "Groenendaal 55",
          "context": "inventarisatie.a2.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.contact.telefoonPrive": [
        {
          "at": 1780561959744,
          "value": "06-23102539",
          "context": "inventarisatie.a1.telefoon_prive",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.natuurlijkPersoon.naam": [
        {
          "at": 1780561959744,
          "value": "Laan, Avrin van der (A.A.)",
          "context": "inventarisatie.a1.naam",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.natuurlijkPersoon.naam": [
        {
          "at": 1780561959744,
          "value": "Riemersma, Priscilla (P.C.)",
          "context": "inventarisatie.a2.naam",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.geldverstrekker": [
        {
          "at": 1780561959745,
          "value": "Eigen kantoor",
          "context": "base_import.products[].maatschappij",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ]
    },
    "version": 1,
    "inkomens": {
      "inkomen1": {
        "soort": "loondienst",
        "partyId": "p1"
      },
      "inkomen2": {
        "soort": "loondienst",
        "partyId": "p2"
      }
    },
    "objecten": {
      "teFinancieren": {
        "soort": "te_financieren_object"
      },
      "vorigeWoning1": {
        "soort": "vorige_woning"
      },
      "huidigeWoning1": {
        "soort": "huidige_woning"
      }
    },
    "partijen": {
      "p1": {
        "rol": "aanvrager",
        "contact": {
          "email": "avrin.vanderlaan@gmail.com",
          "telefoonPrive": "06-23102539"
        },
        "woonadres": {
          "plaats": "Lelystad",
          "postcode": "8219 DB",
          "adresregel": "Groenendaal 55"
        },
        "volgnummer": 1,
        "natuurlijkPersoon": {
          "naam": "Laan, Avrin van der (A.A.)"
        }
      },
      "p2": {
        "rol": "aanvrager",
        "contact": {
          "email": "avrin.vanderlaan@merial.com"
        },
        "woonadres": {
          "plaats": "Lelystad",
          "postcode": "8219 DB",
          "adresregel": "Groenendaal 55"
        },
        "volgnummer": 2,
        "natuurlijkPersoon": {
          "naam": "Riemersma, Priscilla (P.C.)"
        }
      }
    },
    "dossierId": "b6e86ce0-b42c-40a6-a841-21c827ec4a0b",
    "rebuiltAt": 1780561959677,
    "documenten": [],
    "hypotheken": {
      "bestaand1": {
        "soort": "bestaande_hypotheek",
        "objectId": "huidigeWoning1"
      },
      "aangevraagd": {
        "soort": "aangevraagde_hypotheek",
        "hoofdsom": "0.00",
        "objectId": "teFinancieren",
        "geldverstrekker": "Eigen kantoor"
      }
    },
    "statistiek": {
      "documenten": 0,
      "extracties": 0,
      "gelezenItems": 0,
      "gemapteWaarden": 13,
      "overgeslagenItems": 0,
      "projectieWijzigingen": 2
    },
    "gekozenBron": {
      "partijen.p1.contact.email": {
        "at": 1780561959744,
        "value": "avrin.vanderlaan@gmail.com",
        "context": "inventarisatie.a1.email",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p2.contact.email": {
        "at": 1780561959744,
        "value": "avrin.vanderlaan@merial.com",
        "context": "inventarisatie.a2.email",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "pa ... [afgekapt: 2591 tekens]

Rij 420

{
  "dossier_id": "b6e86ce0-b42c-40a6-a841-21c827ec4a0b",
  "key": "_sources",
  "value_json": {
    "inventarisatie.data.aanvraag_hoofdsom": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.hoofdsom",
      "updated_at": "2026-06-04T08:32:39.677Z"
    },
    "inventarisatie.data.aanvraag_geldverstrekker": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.geldverstrekker",
      "updated_at": "2026-06-04T08:32:39.677Z"
    }
  },
  "updated_at": 1780561959849
}

Rij 421

{
  "dossier_id": "b6e86ce0-b42c-40a6-a841-21c827ec4a0b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Laan, Avrin van der (A.A.)",
      "adres": "Groenendaal 55",
      "email": "avrin.vanderlaan@gmail.com",
      "postcode": "8219 DB",
      "woonplaats": "Lelystad",
      "telefoon_prive": "06-23102539"
    },
    "a2": {
      "naam": "Riemersma, Priscilla (P.C.)",
      "adres": "Groenendaal 55",
      "email": "avrin.vanderlaan@merial.com",
      "postcode": "8219 DB",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-10-04"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "ORV Annuitair dalend",
          "tekendatum": "25569",
          "productnaam": "ORV Annuitair dalend",
          "maatschappij": "Reaal schadeverzekeringen",
          "productsoort": "Annuitair Dalende Risicoverzekeringen",
          "factuurbedrag": "",
          "offertenummer": "1300336094",
          "passeeringangsdatum": "2018-12-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "132345.00",
          "status": "Offerte/renteaanbod ontvangen",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2025-10-01"
        },
        {
          "norm": "Geldverstrekker",
          "type": "Hypotheek",
          "inhoud": "241082.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "*********",
          "passeeringangsdatum": "2019-01-25"
        }
      ],
      "crmdossier_id": "181128",
      "dossiernummer": "181128",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht",
      "aanvraag_hoofdsom": "0.00",
      "aanvraag_geldverstrekker": "Eigen kantoor"
    }
  },
  "updated_at": 1780561959823
}

Rij 422

{
  "dossier_id": "4f8bd6a0-aa1a-426b-bd44-693f19213fb5",
  "key": "hdn_dossier",
  "value_json": {
    "schema": "adviestool.hdn_like",
    "bronnen": {
      "partijen.p1.contact.email": [
        {
          "at": 1780561955401,
          "value": "tupacyigit@hotmail.com",
          "context": "inventarisatie.a1.email",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.plaats": [
        {
          "at": 1780561955400,
          "value": "LELYSTAD",
          "context": "inventarisatie.a1.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.plaats": [
        {
          "at": 1780561955401,
          "value": "LELYSTAD",
          "context": "inventarisatie.a2.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.postcode": [
        {
          "at": 1780561955400,
          "value": "8245 CV",
          "context": "inventarisatie.a1.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.postcode": [
        {
          "at": 1780561955401,
          "value": "8245 CV",
          "context": "inventarisatie.a2.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.hoofdsom": [
        {
          "at": 1780561955401,
          "value": "0.00",
          "context": "base_import.products[].inhoud",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "partijen.p1.woonadres.adresregel": [
        {
          "at": 1780561955400,
          "value": "Rijnland 39",
          "context": "inventarisatie.a1.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.adresregel": [
        {
          "at": 1780561955401,
          "value": "Rijnland 39",
          "context": "inventarisatie.a2.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.contact.telefoonPrive": [
        {
          "at": 1780561955400,
          "value": "0684980549",
          "context": "inventarisatie.a1.telefoon_prive",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.natuurlijkPersoon.naam": [
        {
          "at": 1780561955400,
          "value": "Koyuncu, Hülya (H.)",
          "context": "inventarisatie.a1.naam",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.natuurlijkPersoon.naam": [
        {
          "at": 1780561955401,
          "value": "Koyuncu, Mustafa (M)",
          "context": "inventarisatie.a2.naam",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.geldverstrekker": [
        {
          "at": 1780561955401,
          "value": "Eigen kantoor",
          "context": "base_import.products[].maatschappij",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ]
    },
    "version": 1,
    "inkomens": {
      "inkomen1": {
        "soort": "loondienst",
        "partyId": "p1"
      },
      "inkomen2": {
        "soort": "loondienst",
        "partyId": "p2"
      }
    },
    "objecten": {
      "teFinancieren": {
        "soort": "te_financieren_object"
      },
      "vorigeWoning1": {
        "soort": "vorige_woning"
      },
      "huidigeWoning1": {
        "soort": "huidige_woning"
      }
    },
    "partijen": {
      "p1": {
        "rol": "aanvrager",
        "contact": {
          "email": "tupacyigit@hotmail.com",
          "telefoonPrive": "0684980549"
        },
        "woonadres": {
          "plaats": "LELYSTAD",
          "postcode": "8245 CV",
          "adresregel": "Rijnland 39"
        },
        "volgnummer": 1,
        "natuurlijkPersoon": {
          "naam": "Koyuncu, Hülya (H.)"
        }
      },
      "p2": {
        "rol": "aanvrager",
        "woonadres": {
          "plaats": "LELYSTAD",
          "postcode": "8245 CV",
          "adresregel": "Rijnland 39"
        },
        "volgnummer": 2,
        "natuurlijkPersoon": {
          "naam": "Koyuncu, Mustafa (M)"
        }
      }
    },
    "dossierId": "4f8bd6a0-aa1a-426b-bd44-693f19213fb5",
    "rebuiltAt": 1780561955329,
    "documenten": [],
    "hypotheken": {
      "bestaand1": {
        "soort": "bestaande_hypotheek",
        "objectId": "huidigeWoning1"
      },
      "aangevraagd": {
        "soort": "aangevraagde_hypotheek",
        "hoofdsom": "0.00",
        "objectId": "teFinancieren",
        "geldverstrekker": "Eigen kantoor"
      }
    },
    "statistiek": {
      "documenten": 0,
      "extracties": 0,
      "gelezenItems": 0,
      "gemapteWaarden": 12,
      "overgeslagenItems": 0,
      "projectieWijzigingen": 2
    },
    "gekozenBron": {
      "partijen.p1.contact.email": {
        "at": 1780561955401,
        "value": "tupacyigit@hotmail.com",
        "context": "inventarisatie.a1.email",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p1.woonadres.plaats": {
        "at": 1780561955400,
        "value": "LELYSTAD",
        "context": "inventarisatie.a1.woonplaats",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p2.woonadres.plaats": {
        "at": 1780561955401,
        "value": "LELYSTAD",
        "context": "inventarisatie.a2.woonplaats",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p1.woonadres.postcode": {
        "at": 1780561955400,
        "value": "8245 CV",
        "context": "inventarisatie.a1.postcode",
        "confidence": 0.55,
        "sourceKind" ... [afgekapt: 1933 tekens]

Rij 423

{
  "dossier_id": "4f8bd6a0-aa1a-426b-bd44-693f19213fb5",
  "key": "_sources",
  "value_json": {
    "inventarisatie.data.aanvraag_hoofdsom": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.hoofdsom",
      "updated_at": "2026-06-04T08:32:35.329Z"
    },
    "inventarisatie.data.aanvraag_geldverstrekker": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.geldverstrekker",
      "updated_at": "2026-06-04T08:32:35.329Z"
    }
  },
  "updated_at": 1780561955476
}

Rij 424

{
  "dossier_id": "4f8bd6a0-aa1a-426b-bd44-693f19213fb5",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Koyuncu, Hülya (H.)",
      "adres": "Rijnland 39",
      "email": "tupacyigit@hotmail.com",
      "postcode": "8245 CV",
      "woonplaats": "LELYSTAD",
      "telefoon_prive": "0684980549"
    },
    "a2": {
      "naam": "Koyuncu, Mustafa (M)",
      "adres": "Rijnland 39",
      "postcode": "8245 CV",
      "woonplaats": "LELYSTAD"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Lopend",
          "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering voor Particulieren, Doorlopende Reis en/of Annulering, Basis Verzekerd, Particuliere Autoverzekering, Pechhulp, Particuliere Autoverzekering, Auto",
          "tekendatum": "25569",
          "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering voor Particulieren, Doorlopende Reis en/of Annulering, Basis Verzekerd, Particuliere Autoverzekering, Pechhulp, Particuliere Autoverzekering, Auto",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Motorrijtuigen, Opstal, Personenauto, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-05-01"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Auto, Motorrijtuigen, Auto",
          "tekendatum": "25569",
          "productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Auto, Motorrijtuigen, Auto",
          "maatschappij": "Risk Assuradeuren",
          "productsoort": "Aansprakelijkheid, Inboedel, Motorrijtuigen, Opstal, Personenauto, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
          "factuurbedrag": "",
          "offertenummer": "5369PK-*********",
          "passeeringangsdatum": "2023-05-01"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-F52C6AC0-2646-4A22-9B2E-3FDC51B43EE1|829(1)",
          "passeeringangsdatum": "2019-06-01"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2018-12-03"
        },
        {
          "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": "7001175919",
          "passeeringangsdatum": "2019-05-30"
        },
        {
          "norm": "",
          "type": "Verkoopdienst",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen makelaardij",
          "productsoort": "",
          "factuurbedrag": "1983.47",
          "offertenummer": "",
          "passeeringangsdatum": "2019-01-22"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "225025.00",
          "status": "Lopend",
          "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "tekendatum": "25569",
          "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
          "maatschappij": "ING Bank",
          "productsoort": "Annuitair",
          "factuurbedrag": "2250.00",
          "offertenummer": "*********",
          "passeeringangsdatum": "2019-05-24"
        }
      ],
      "crmdossier_id": "182123",
      "dossiernummer": "182123",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht",
      "aanvraag_hoofdsom": "0.00",
      "aanvraag_geldverstrekker": "Eigen kantoor"
    }
  },
  "updated_at": 1780561955451
}

Rij 425

{
  "dossier_id": "009b5118-80f0-4b2a-a476-6224e9099fd9",
  "key": "upload2_document_intake",
  "value_json": {
    "version": 1,
    "documents": {
      "0238a7dc-237a-4a8a-8cd7-3cfae92a6699": {
        "mime": "application/pdf",
        "model": "regels",
        "fileId": "0238a7dc-237a-4a8a-8cd7-3cfae92a6699",
        "status": "needs_review",
        "scanRuns": [],
        "template": "Onbekend",
        "applicant": 2,
        "ocrEngine": "auto",
        "pageCount": null,
        "updatedAt": "2026-06-03T18:00:48.315Z",
        "confidence": 0.05,
        "firstSeenAt": "2026-06-03T17:24:31.366Z",
        "documentName": "Verzekeringsbericht uwv Peter de Jong.pdf",
        "documentType": "263 UWV Verzekeringsbericht",
        "fieldReviews": {},
        "profileLabel": "Onbekend document",
        "profileTypeId": "unknown",
        "learningEvents": [
          {
            "at": "2026-06-03T18:00:48.315Z",
            "to": "263 UWV Verzekeringsbericht",
            "from": "Onbekend",
            "kind": "document_type_changed",
            "actor": "user",
            "field": "documentType",
            "confidence": 0.05,
            "profileLabel": "Onbekend document",
            "profileTypeId": "unknown"
          },
          {
            "at": "2026-06-03T18:00:48.315Z",
            "to": 2,
            "from": null,
            "kind": "applicant_changed",
            "actor": "user",
            "field": "applicant",
            "confidence": 0.05,
            "profileLabel": "Onbekend document",
            "profileTypeId": "unknown"
          }
        ]
      },
      "123b0b5e-45ac-4361-9fd3-252bb50970da": {
        "mime": "application/pdf",
        "model": "regels",
        "fileId": "123b0b5e-45ac-4361-9fd3-252bb50970da",
        "status": "needs_review",
        "scanRuns": [],
        "template": "Onbekend",
        "applicant": 1,
        "ocrEngine": "auto",
        "pageCount": null,
        "updatedAt": "2026-06-03T18:00:50.971Z",
        "confidence": 0.05,
        "firstSeenAt": "2026-06-03T17:24:33.078Z",
        "documentName": "Pensioenoverzicht-09-04-2026 Sdj.pdf",
        "documentType": "029 Bewijsstukken pensioen",
        "fieldReviews": {},
        "profileLabel": "Onbekend document",
        "profileTypeId": "unknown",
        "learningEvents": [
          {
            "at": "2026-06-03T18:00:50.971Z",
            "to": "029 Bewijsstukken pensioen",
            "from": "Onbekend",
            "kind": "document_type_changed",
            "actor": "user",
            "field": "documentType",
            "confidence": 0.05,
            "profileLabel": "Onbekend document",
            "profileTypeId": "unknown"
          },
          {
            "at": "2026-06-03T18:00:50.971Z",
            "to": 1,
            "from": null,
            "kind": "applicant_changed",
            "actor": "user",
            "field": "applicant",
            "confidence": 0.05,
            "profileLabel": "Onbekend document",
            "profileTypeId": "unknown"
          }
        ]
      },
      "5122f4f7-2c06-4cd1-a789-487a41a0670e": {
        "mime": "application/pdf",
        "model": "regels",
        "fileId": "5122f4f7-2c06-4cd1-a789-487a41a0670e",
        "status": "needs_review",
        "scanRuns": [],
        "template": "Onbekend",
        "applicant": 1,
        "ocrEngine": "auto",
        "pageCount": null,
        "updatedAt": "2026-06-03T18:00:52.165Z",
        "confidence": 0.05,
        "firstSeenAt": "2026-06-03T17:24:37.140Z",
        "documentName": "Jaaropgaaf 2025 uwv sdj.pdf",
        "documentType": "016 Bewijsstukken uitkering",
        "fieldReviews": {},
        "profileLabel": "Onbekend document",
        "profileTypeId": "unknown",
        "learningEvents": [
          {
            "at": "2026-06-03T18:00:52.165Z",
            "to": "016 Bewijsstukken uitkering",
            "from": "Onbekend",
            "kind": "document_type_changed",
            "actor": "user",
            "field": "documentType",
            "confidence": 0.05,
            "profileLabel": "Onbekend document",
            "profileTypeId": "unknown"
          },
          {
            "at": "2026-06-03T18:00:52.165Z",
            "to": 1,
            "from": null,
            "kind": "applicant_changed",
            "actor": "user",
            "field": "applicant",
            "confidence": 0.05,
            "profileLabel": "Onbekend document",
            "profileTypeId": "unknown"
          }
        ]
      },
      "63ef9eff-7ce0-41c5-b61d-4e104842988c": {
        "mime": "application/pdf",
        "model": "regels",
        "fileId": "63ef9eff-7ce0-41c5-b61d-4e104842988c",
        "status": "needs_review",
        "scanRuns": [],
        "template": "Onbekend",
        "applicant": 1,
        "ocrEngine": "auto",
        "pageCount": null,
        "updatedAt": "2026-06-03T18:00:48.482Z",
        "confidence": 0.05,
        "firstSeenAt": "2026-06-03T17:24:34.389Z",
        "documentName": "Verzekeringsbericht SdeJong uwv.pdf",
        "documentType": "263 UWV Verzekeringsbericht",
        "fieldReviews": {},
        "profileLabel": "Onbekend document",
        "profileTypeId": "unknown",
        "learningEvents": [
          {
            "at": "2026-06-03T18:00:48.482Z",
            "to": "263 UWV Verzekeringsbericht",
            "from": "Onbekend",
            "kind": "document_type_changed",
            "actor": "user",
            "field": "documentType",
            "confidence": 0.05,
            "profileLabel": "Onbekend document",
            "profileTypeId": "unknown"
          },
          {
            "at": "2026-06-03T18:00:48.482Z",
            "to": 1,
            "from": null,
            "kind": "applicant_changed",
            "actor": "user",
            "field": "applicant",
            "confidence": 0.05,
            "profileLabel": "Onbekend document",
            "profileTypeId": " ... [afgekapt: 6413 tekens]

Rij 426

{
  "dossier_id": "ee0b7fdb-7769-4e54-92cd-0a2d2cba1b4c",
  "key": "_sources",
  "value_json": {},
  "updated_at": 1780507927177
}

Rij 427

{
  "dossier_id": "d9ef447d-61d5-4170-b668-ba92f1f20e7c",
  "key": "_sources",
  "value_json": {},
  "updated_at": 1780507927177
}

Rij 428

{
  "dossier_id": "4f8bd6a0-aa1a-426b-bd44-693f19213fb5",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T16:31:29.350Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780504289350
}

Rij 429

{
  "dossier_id": "c6406b9a-7e46-4796-8d98-9f789737f132",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T16:31:29.278Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780504289278
}

Rij 430

{
  "dossier_id": "cef57c94-7077-466a-8e57-7f0a86dd560f",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T16:31:29.265Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780504289265
}

Rij 431

{
  "dossier_id": "ee0b7fdb-7769-4e54-92cd-0a2d2cba1b4c",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T16:31:29.246Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780504289246
}

Rij 432

{
  "dossier_id": "6b20b045-17cc-4125-8e3e-f2145726b84a",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T16:31:29.235Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780504289236
}

Rij 433

{
  "dossier_id": "f5e4e84a-9466-4ade-bd16-e3318382b45d",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T15:15:49.160Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780499749161
}

Rij 434

{
  "dossier_id": "b6e86ce0-b42c-40a6-a841-21c827ec4a0b",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T15:15:49.136Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780499749136
}

Rij 435

{
  "dossier_id": "cc191942-3ceb-43f1-9447-d01d148bfc6a",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T15:15:49.111Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780499749112
}

Rij 436

{
  "dossier_id": "2b45f125-4056-428d-aa11-e92bd06485de",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T15:15:49.104Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780499749104
}

Rij 437

{
  "dossier_id": "1966ed7e-f705-4eb5-b247-ae065bbbb9d4",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T15:15:49.096Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780499749096
}

Rij 438

{
  "dossier_id": "eec8ad9e-b509-4cc3-898e-70e82feac4a9",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T15:15:49.081Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780499749081
}

Rij 439

{
  "dossier_id": "d9ef447d-61d5-4170-b668-ba92f1f20e7c",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T15:15:49.046Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780499749047
}

Rij 440

{
  "dossier_id": "hermes-e2e-advies-2026-05-24",
  "key": "_sources",
  "value_json": {
    "klantprofiel": [
      {
        "at": "2026-05-24T19:30:13.681Z",
        "kind": "simulated",
        "label": "Gemini customer-profile simulation"
      }
    ],
    "financieringsopzet": [
      {
        "at": "2026-05-24T19:30:13.681Z",
        "kind": "manual",
        "label": "Hermes E2E seed op basis van documentfeiten"
      }
    ],
    "aanvraagproces.history": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-27T15:25:35.104Z"
    },
    "inventarisatie.a1.naam": [
      {
        "kind": "document",
        "label": "sandbox salarisstrook",
        "fileId": "hermes-e2e-salarisstrook-a1"
      }
    ],
    "financieringsopzet.activeId": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-03T12:34:38.636Z"
    },
    "financieringsopzet.voorstellen": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-03T12:44:26.958Z"
    },
    "inventarisatie.a1.geboortedatum": [
      {
        "kind": "document",
        "label": "sandbox legitimatie",
        "fileId": "hermes-e2e-legitimatie-a1"
      }
    ],
    "financieringsopzet.selectedProposalId": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-03T12:34:38.636Z"
    },
    "inventarisatie.data.onderpand_koopsom": [
      {
        "kind": "document",
        "label": "sandbox koopovereenkomst",
        "fileId": "hermes-e2e-koopovereenkomst"
      }
    ],
    "inventarisatie.inc1.fields.ww_dagloon": {
      "label": "WW dagloon A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_iva_pct": {
      "label": "IVA percentage",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_iva_pct": {
      "label": "IVA percentage",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_ao_klasse": {
      "label": "AO klasse scenario",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_ao_klasse": {
      "label": "AO klasse scenario",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.orv_inkomen_nu": {
      "label": "ORV inkomen nu A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.ww_sv_maandloon": {
      "label": "WW SV maandloon A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_wia_maandloon": {
      "label": "AOV WIA maandloon A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_lgu_daarna_pct": {
      "label": "WGA LGU daarna",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_lgu_daarna_pct": {
      "label": "WGA LGU daarna",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.ww_arbeidsuren_per_week": {
      "label": "WW arbeidsuren A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [
        "inc1.fields.uren_per_week"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.ww_urenverlies_per_week": {
      "label": "WW urenverlies A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [
        "inc1.fields.uren_per_week"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.totaal_bruto_jaarinkomen": [
      {
        "kind": "document",
        "label": "sandbox werkgeversverklaring/salarisstrook",
        "fileId": "hermes-e2e-salarisstrook-a1"
      }
    ],
    "inventarisatie.inc1.fields.ww_huidig_bruto_jaarinkomen": {
      "label": "WW bruto jaarinkomen A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.ww_maximumdagloon_toepassen": {
      "label": "WW maximumdagloon toepassen",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-05-24T19:30:37.564Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.ww_maximumdagloon_toepassen": {
      "label": "WW maximumdagloon toepassen",
      "source": "Afgeleid",
      "confidence": 0.62, ... [afgekapt: 4171 tekens]

Rij 441

{
  "dossier_id": "hermes-e2e-advies-2026-05-24",
  "key": "financieringsopzet",
  "value_json": {
    "activeId": "ecb537d9-3683-4186-a305-3fcdb7f5636d",
    "voorstellen": [
      {
        "id": "voorstel-hermes-e2e-1",
        "naam": "Hermes E2E voorstel 1 — aankoop met NHG indicatief",
        "kosten": {
          "nhg": "1800",
          "totaal": "356700",
          "koopsom": "350000",
          "notaris": "1200",
          "taxatie": "750",
          "kadaster": "",
          "meerwerk": "",
          "boeterente": "",
          "verbouwing": "",
          "bankgarantie": "",
          "nhgBorgtocht": "",
          "overigKosten": "",
          "roerendeZaken": "",
          "aankoopmakelaar": "",
          "hypotheekadvies": "2950",
          "aflossingBestaand": "",
          "bouwkundigeKeuring": "",
          "notarisHypotheekakte": "",
          "notarisLeveringsakte": "",
          "overdrachtsbelasting": "0"
        },
        "status": "draft",
        "notitie": "Sandbox E2E: indicatief voorstel voor browserdoorloop; geen echte aanvraag of acceptatie.",
        "leningdelen": [
          {
            "id": "ld-hermes-e2e-1",
            "box": "1",
            "nhg": "Ja",
            "rente": "4,00",
            "hoofdsom": "300000",
            "aflosvorm": "Annuiteit",
            "aftrekPct": "100",
            "box1Bedrag": "",
            "box3Bedrag": "",
            "productnaam": "",
            "restverschil": "",
            "looptijdJaren": "30",
            "brutoMaandlast": "1432",
            "rentevastJaren": "10",
            "einddatumAftrek": "",
            "geldverstrekker": "Sandbox Bank",
            "besparingPerMaand": "",
            "maandlastNaAflossing": "",
            "restschuldNaAflossing": "",
            "aflossingBijOverbrugging": "",
            "restschuldBijOverbrugging": ""
          }
        ],
        "financiering": {
          "totaal": "356700",
          "bouwdepot": "",
          "schenking": "",
          "hypotheek1": "300000",
          "hypotheek2": "",
          "eigenMiddelen": "56700",
          "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": ""
        },
        "selectedProductCodes": [
          "hypotheek"
        ]
      },
      {
        "id": "ecb537d9-3683-4186-a305-3fcdb7f5636d",
        "naam": "Voorstel 2",
        "kosten": {
          "nhg": "1800",
          "totaal": "356700",
          "koopsom": "350000",
          "notaris": "1200",
          "taxatie": "750",
          "kadaster": "",
          "meerwerk": "",
          "boeterente": "",
          "verbouwing": "",
          "bankgarantie": "",
          "nhgBorgtocht": "",
          "overigKosten": "",
          "roerendeZaken": "",
          "aankoopmakelaar": "",
          "hypotheekadvies": "2950",
          "aflossingBestaand": "",
          "bouwkundigeKeuring": "",
          "notarisHypotheekakte": "",
          "notarisLeveringsakte": "",
          "overdrachtsbelasting": "0"
        },
        "status": "selected",
        "notitie": "",
        "leningdelen": [
          {
            "id": "4ff767f5-8efa-422f-99c5-4d45fcfaa7bd",
            "box": "1",
            "nhg": "Nee",
            "rente": "4,01",
            "hoofdsom": "713.400",
            "aflosvorm": "Annuiteit",
            "aftrekPct": "100",
            "box1Bedrag": "",
            "box3Bedrag": "",
            "productnaam": "",
            "restverschil": "",
            "looptijdJaren": "30",
            "brutoMaandlast": "€ 3.410",
            "rentevastJaren": "10",
            "einddatumAftrek": "",
            "geldverstrekker": "",
            "besparingPerMaand": "",
            "maandlastNaAflossing": "",
            "restschuldNaAflossing": "",
            "aflossingBijOverbrugging": "",
            "restschuldBijOverbrugging": ""
          }
        ],
        "financiering": {
          "totaal": "356700",
          "bouwdepot": "",
          "schenking": "",
          "hypotheek1": "300000",
          "hypotheek2": "",
          "eigenMiddelen": "56700",
          "verkoopopbrengst": "",
          "overigFinanciering": "",
          "overbruggingskrediet": ""
        },
        "vergelijking": {
          "box3": "",
          "wozWaarde": "",
          "overwaarde": "",
          "statusOfferte": "",
          "verkoopwaarde": "",
          "verkoopCourtage": "",
          "verlengingNodig": "",
          "huidigeHypotheek": "",
          "overdrachtsdatum": "",
          "renteaanbodDatum": "",
          "bankgarantiedatum": "",
          "geldDatOverblijft": "",
          "overbruggingRente": "",
          "resterendVerschil": "",
          "eigenwoningforfait" ... [afgekapt: 4109 tekens]

Rij 442

{
  "dossier_id": "hermes-e2e-advies-2026-05-24",
  "key": "berekeningen_v1",
  "value_json": {
    "version": 1,
    "updatedAt": "2026-06-03T12:34:38.824Z",
    "calculations": [
      {
        "id": "calc-hermes-e2e-aankoop",
        "title": "Hermes E2E aankoopberekening",
        "source": "manual",
        "status": "converted_to_application",
        "purpose": "aankoop_bestaande_bouw",
        "summary": "Indicatieve sandboxberekening met geselecteerd voorstel en interne aanvraagkoppeling.",
        "createdAt": "2026-05-24T19:30:13.681Z",
        "dossierId": "hermes-e2e-advies-2026-05-24",
        "updatedAt": "2026-06-03T12:34:38.824Z",
        "proposalIds": [
          "voorstel-hermes-e2e-1",
          "ecb537d9-3683-4186-a305-3fcdb7f5636d",
          "fe89f95f-7653-4b6b-84b2-84162a43e987"
        ],
        "applicationId": "aanvraag-hermes-e2e-intern",
        "applicantScope": "applicant_1",
        "selectedProposalId": "ecb537d9-3683-4186-a305-3fcdb7f5636d"
      }
    ],
    "activeCalculationId": "calc-hermes-e2e-aankoop"
  },
  "updated_at": 1780490078824
}

Rij 443

{
  "dossier_id": "100de351-22d4-46ef-9117-86f768363636",
  "key": "_sources",
  "value_json": {
    "aov.value": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T12:01:44.613Z"
    },
    "orv.value": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T09:35:17.818Z"
    },
    "orv.polissen": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T17:48:16.067Z"
    },
    "aov.producten": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T12:29:48.107Z"
    },
    "inventarisatie.data": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:52:27.642Z"
    },
    "aanvraagproces.value": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T11:01:33.430Z"
    },
    "advies-motivering.value": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T11:01:31.187Z"
    },
    "advies-onderwerpen.value": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T11:01:31.355Z"
    },
    "financieringsopzet.value": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:51:58.014Z"
    },
    "hypotheek-algemeen.value": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:50:44.235Z"
    },
    "financieringsopzet.activeId": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T18:18:06.659Z"
    },
    "inventarisatie.inc1.salaris": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:52:27.642Z"
    },
    "inventarisatie.inc2.salaris": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:52:27.642Z"
    },
    "inventarisatie.inc1.payrolls": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T11:57:40.325Z"
    },
    "inventarisatie.inc2.payrolls": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T11:57:40.325Z"
    },
    "inventarisatie.data.hypotheek": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T11:57:40.325Z"
    },
    "financieringsopzet.voorstellen": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-03T10:15:44.670Z"
    },
    "hypotheek-algemeen.bijleen.woningen": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T09:36:31.211Z"
    },
    "financieringsopzet.selectedProposalId": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T18:18:06.659Z"
    },
    "inventarisatie.inc1.fields.ww_dagloon": {
      "label": "WW dagloon A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-02T08:03:51.749Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.ww_dagloon": {
      "label": "WW dagloon A2",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-02T08:03:51.749Z",
      "derived_from": [
        "inc2.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_iva_pct": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:52:27.642Z"
    },
    "inventarisatie.inc2.fields.aov_iva_pct": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:52:27.642Z"
    },
    "hypotheek-algemeen.maxHypotheek.analyse": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T08:03:49.304Z"
    },
    "hypotheek-algemeen.maxHypotheek.flTabel": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T09:36:31.211Z"
    },
    "inventarisatie.inc1.fields.aov_ao_klasse": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:52:27.642Z"
    },
    "inventarisatie.inc2.fields.aov_ao_klasse": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:52:27.642Z"
    },
    "hypotheek-algemeen.maxHypotheek.situaties": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T09:36:31.211Z"
    },
    "inventarisatie.inc1.fields.orv_inkomen_nu": {
      "label": "ORV inkomen nu A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-02T08:03:51.749Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.orv_inkomen_nu": {
      "label": "ORV inkomen nu A2",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-02T08:03:51.749Z",
      "derived_from": [
        "inc2.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.ww_sv_maandloon": {
      "label": "WW SV maandloon A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-02T08:03:51.749Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.ww_sv_maandloon": {
      "label": "WW SV maandloon A2",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-02T08:03:51.749Z",
      "derived_from": [
        "inc2.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "hypotheek-algemeen.maxHypotheek.leningdelen": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T09:36:31.211Z"
    },
    "hypotheek-algemeen.maxHypotheek.ltvMaximaal": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:52:47.473Z"
    },
    "hypotheek-algemeen.eerste.huidigToetsinkomen": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T08:03:53.032Z"
    },
    "hypotheek-algemeen.tweede.huidigToetsinkomen": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T08:03:53.032Z"
    },
    "inventarisatie.inc1.fields.aov_wia_maandloon": {
      "label": "AOV WIA maandloon A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-02T08:03:51.749Z", ... [afgekapt: 7612 tekens]

Rij 444

{
  "dossier_id": "100de351-22d4-46ef-9117-86f768363636",
  "key": "financieringsopzet",
  "value_json": {
    "activeId": "0f80d3d1-45ed-474a-a41f-1dba285c19ad",
    "voorstellen": [
      {
        "id": "88cde811-613e-4c27-9580-192bee2e94c2",
        "naam": "Voorstel 2",
        "kosten": {
          "koopsom": "",
          "taxatie": "",
          "kadaster": "",
          "meerwerk": "",
          "boeterente": "",
          "verbouwing": "",
          "bankgarantie": "",
          "nhgBorgtocht": "",
          "overigKosten": "",
          "roerendeZaken": "",
          "aankoopmakelaar": "",
          "hypotheekadvies": "",
          "aflossingBestaand": "",
          "bouwkundigeKeuring": "",
          "notarisHypotheekakte": "",
          "notarisLeveringsakte": "",
          "overdrachtsbelasting": ""
        },
        "status": "draft",
        "notitie": "",
        "leningdelen": [],
        "financiering": {
          "bouwdepot": "",
          "schenking": "",
          "hypotheek1": "",
          "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": ""
        },
        "selectedProductCodes": [
          "hypotheek"
        ]
      },
      {
        "id": "d9ba1aa4-31d9-4ef4-ace9-56a76968d587",
        "naam": "Voorstel 3",
        "kosten": {
          "koopsom": "",
          "taxatie": "",
          "kadaster": "",
          "meerwerk": "",
          "boeterente": "",
          "verbouwing": "",
          "bankgarantie": "",
          "nhgBorgtocht": "",
          "overigKosten": "",
          "roerendeZaken": "",
          "aankoopmakelaar": "",
          "hypotheekadvies": "",
          "aflossingBestaand": "",
          "bouwkundigeKeuring": "",
          "notarisHypotheekakte": "",
          "notarisLeveringsakte": "",
          "overdrachtsbelasting": ""
        },
        "status": "draft",
        "notitie": "",
        "leningdelen": [],
        "financiering": {
          "bouwdepot": "",
          "schenking": "",
          "hypotheek1": "",
          "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": ""
        },
        "selectedProductCodes": [
          "hypotheek"
        ]
      },
      {
        "id": "0f80d3d1-45ed-474a-a41f-1dba285c19ad",
        "naam": "Voorstel 4",
        "kosten": {
          "koopsom": "",
          "taxatie": "",
          "kadaster": "",
          "meerwerk": "",
          "boeterente": "",
          "verbouwing": "",
          "bankgarantie": "",
          "nhgBorgtocht": "",
          "overigKosten": "",
          "roerendeZaken": "",
          "aankoopmakelaar": "",
          "hypotheekadvies": "",
          "aflossingBestaand": "",
          "bouwkundigeKeuring": "",
          "notarisHypotheekakte": "",
          "notarisLeveringsakte": "",
          "overdrachtsbelasting": ""
        },
        "status": "selected",
        "notitie": "",
        "leningdelen": [],
        "financiering": {
          "bouwdepot": "",
          "schenking": "",
          "hypotheek1": "",
          "hypotheek2": "",
          "eigenMiddelen": "",
          "verkoopopbrengst": "",
          "overigFinanciering": "",
          "overbruggingskrediet": ""
        },
        "vergelijking": {
          "box3": "",
          "wozWaarde": "",
          "overwaarde": "",
          "statusOfferte": ... [afgekapt: 1242 tekens]

Rij 445

{
  "dossier_id": "9679b483-de37-463a-982e-e600fecfcc84",
  "key": "aanvraagproces",
  "value_json": {
    "status": "nieuw",
    "history": [],
    "notitie": ""
  },
  "updated_at": 1780479145358
}

Rij 446

{
  "dossier_id": "009b5118-80f0-4b2a-a476-6224e9099fd9",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T08:57:07.518Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780477027518
}

Rij 447

{
  "dossier_id": "9679b483-de37-463a-982e-e600fecfcc84",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-03T08:00:20.199Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1780473620202
}

Rij 448

{
  "dossier_id": "hermes-e2e-2026-05-24",
  "key": "_sources",
  "value_json": {
    "klantprofiel": [
      {
        "at": "2026-05-24T13:05:02.152Z",
        "kind": "simulated",
        "label": "Gemini customer-profile simulation"
      }
    ],
    "financieringsopzet": [
      {
        "at": "2026-05-24T13:05:02.152Z",
        "kind": "manual",
        "label": "Hermes E2E seed op basis van documentfeiten"
      }
    ],
    "aanvraagproces.history": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-03T05:06:38.954Z"
    },
    "inventarisatie.a1.naam": [
      {
        "kind": "document",
        "label": "sandbox salarisstrook",
        "fileId": "hermes-e2e-salarisstrook-a1"
      }
    ],
    "financieringsopzet.activeId": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:32:39.471Z"
    },
    "financieringsopzet.voorstellen": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-03T05:33:30.906Z"
    },
    "inventarisatie.a1.geboortedatum": [
      {
        "kind": "document",
        "label": "sandbox legitimatie",
        "fileId": "hermes-e2e-legitimatie-a1"
      }
    ],
    "financieringsopzet.selectedProposalId": {
      "source": "Eigen invoer",
      "updated_at": "2026-06-02T07:32:39.471Z"
    },
    "inventarisatie.data.onderpand_koopsom": [
      {
        "kind": "document",
        "label": "sandbox koopovereenkomst",
        "fileId": "hermes-e2e-koopovereenkomst"
      }
    ],
    "inventarisatie.inc1.fields.ww_dagloon": {
      "label": "WW dagloon A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_iva_pct": {
      "label": "IVA percentage",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_iva_pct": {
      "label": "IVA percentage",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_ao_klasse": {
      "label": "AO klasse scenario",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_ao_klasse": {
      "label": "AO klasse scenario",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.orv_inkomen_nu": {
      "label": "ORV inkomen nu A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.ww_sv_maandloon": {
      "label": "WW SV maandloon A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_wia_maandloon": {
      "label": "AOV WIA maandloon A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_lgu_daarna_pct": {
      "label": "WGA LGU daarna",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_lgu_daarna_pct": {
      "label": "WGA LGU daarna",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.ww_arbeidsuren_per_week": {
      "label": "WW arbeidsuren A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [
        "inc1.fields.uren_per_week"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.ww_urenverlies_per_week": {
      "label": "WW urenverlies A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [
        "inc1.fields.uren_per_week"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.totaal_bruto_jaarinkomen": [
      {
        "kind": "document",
        "label": "sandbox werkgeversverklaring/salarisstrook",
        "fileId": "hermes-e2e-salarisstrook-a1"
      }
    ],
    "inventarisatie.inc1.fields.ww_huidig_bruto_jaarinkomen": {
      "label": "WW bruto jaarinkomen A1",
      "source": "Afgeleid",
      "confidence": 0.68,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [
        "inc1.fields.totaal_bruto_jaarinkomen"
      ],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.ww_maximumdagloon_toepassen": {
      "label": "WW maximumdagloon toepassen",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-01T20:44:41.115Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.ww_maximumdagloon_toepassen": {
      "label": "WW maximumdagloon toepassen",
      "source": "Afgeleid",
      "confidence": 0.62,
      "upda ... [afgekapt: 4164 tekens]

Rij 449

{
  "dossier_id": "hermes-e2e-2026-05-24",
  "key": "financieringsopzet",
  "value_json": {
    "activeId": "d9eb7e0f-b40d-4c2e-8f62-c9b9d212389f",
    "voorstellen": [
      {
        "id": "voorstel-hermes-e2e-1",
        "naam": "Hermes E2E voorstel 1 — aankoop met NHG indicatief",
        "kosten": {
          "nhg": "1800",
          "totaal": "356700",
          "koopsom": "350000",
          "notaris": "1200",
          "taxatie": "750",
          "kadaster": "",
          "meerwerk": "",
          "boeterente": "",
          "verbouwing": "",
          "bankgarantie": "",
          "nhgBorgtocht": "",
          "overigKosten": "",
          "roerendeZaken": "",
          "aankoopmakelaar": "",
          "hypotheekadvies": "2950",
          "aflossingBestaand": "",
          "bouwkundigeKeuring": "",
          "notarisHypotheekakte": "",
          "notarisLeveringsakte": "",
          "overdrachtsbelasting": "0"
        },
        "status": "draft",
        "notitie": "Sandbox E2E: indicatief voorstel voor browserdoorloop; geen echte aanvraag of acceptatie.",
        "leningdelen": [
          {
            "id": "ld-hermes-e2e-1",
            "box": "1",
            "nhg": "Ja",
            "rente": "4,00",
            "hoofdsom": "300000",
            "aflosvorm": "Annuiteit",
            "aftrekPct": "100",
            "box1Bedrag": "",
            "box3Bedrag": "",
            "productnaam": "",
            "restverschil": "",
            "looptijdJaren": "30",
            "brutoMaandlast": "1432",
            "rentevastJaren": "10",
            "einddatumAftrek": "",
            "geldverstrekker": "Sandbox Bank",
            "besparingPerMaand": "",
            "maandlastNaAflossing": "",
            "restschuldNaAflossing": "",
            "aflossingBijOverbrugging": "",
            "restschuldBijOverbrugging": ""
          }
        ],
        "financiering": {
          "totaal": "356700",
          "bouwdepot": "",
          "schenking": "",
          "hypotheek1": "300000",
          "hypotheek2": "",
          "eigenMiddelen": "56700",
          "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": ""
        },
        "selectedProductCodes": [
          "hypotheek"
        ]
      },
      {
        "id": "d9eb7e0f-b40d-4c2e-8f62-c9b9d212389f",
        "naam": "Hermes E2E voorstel 2 — hoger bedrag/rente test",
        "kosten": {
          "nhg": "1800",
          "totaal": "376700",
          "koopsom": "350000",
          "notaris": "1200",
          "taxatie": "750",
          "kadaster": "",
          "meerwerk": "",
          "boeterente": "",
          "verbouwing": "",
          "bankgarantie": "",
          "nhgBorgtocht": "",
          "overigKosten": "",
          "roerendeZaken": "",
          "aankoopmakelaar": "",
          "hypotheekadvies": "2950",
          "aflossingBestaand": "",
          "bouwkundigeKeuring": "",
          "notarisHypotheekakte": "",
          "notarisLeveringsakte": "",
          "overdrachtsbelasting": "0"
        },
        "status": "selected",
        "notitie": "Sandbox E2E: indicatief voorstel voor browserdoorloop; geen echte aanvraag of acceptatie.",
        "leningdelen": [
          {
            "id": "5a668951-746d-4af1-aea0-96984036b414",
            "box": "1",
            "nhg": "Ja",
            "rente": "4,50",
            "hoofdsom": "320000",
            "aflosvorm": "Annuiteit",
            "aftrekPct": "100",
            "box1Bedrag": "",
            "box3Bedrag": "",
            "productnaam": "",
            "restverschil": "",
            "looptijdJaren": "30",
            "brutoMaandlast": "1621",
            "rentevastJaren": "10",
            "einddatumAftrek": "",
            "geldverstrekker": "Sandbox Bank",
            "besparingPerMaand": "",
            "maandlastNaAflossing": "",
            "restschuldNaAflossing": "",
            "aflossingBijOverbrugging": "",
            "restschuldBijOverbrugging": ""
          }
        ],
        "financiering": {
          "totaal": "376700",
          "bouwdepot": "",
          "schenking": "",
          "hypotheek1": "320000",
          "hypotheek2": "",
          "eigenMiddelen": "56700",
          "verkoopopbrengst": "",
          "overigFinanciering": "",
          "overbruggingskrediet": ""
        },
        "vergelijking": {
          "box3": "",
          "wozWaarde": "",
          "overwaarde": "",
          "statusOfferte": "",
          "verkoopwaarde": "",
          "verkoopCourtage": "",
          "verlengingNodig": "",
          "huidigeHypotheek": "",
          "overdrachtsdatum": "",
          "renteaanbodDatum": "",
          "bankgarantiedatum": "", ... [afgekapt: 994 tekens]

Rij 450

{
  "dossier_id": "hermes-e2e-2026-05-24",
  "key": "advies-motivering",
  "value_json": {},
  "updated_at": 1780463227267
}

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)