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 bronnen73 tabellen/stores299.863 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 1100| dossier_id | key | value_json | updated_at |
|---|---|---|---|
| e51eea36-c801-4ba2-aa5c-572a93ec7d3e | workflow_v1 | { "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:37.034Z", "phase": "F00_lead" }, "uitvraagReminders": [] } | 1778414857034 |
| 616f67de-d4f6-43aa-ba94-eb1e779d3c56 | workflow_v1 | { "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:37.031Z", "phase": "F00_lead" }, "uitvraagReminders": [] } | 1778414857031 |
| 2e098bed-a67d-4934-97eb-9acfbeb3ef13 | workflow_v1 | { "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:37.027Z", "phase": "F00_lead" }, "uitvraagReminders": [] } | 1778414857027 |
| 25501a81-4d82-400f-9fc9-c60bf6fb1a50 | workflow_v1 | { "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:37.014Z", "phase": "F00_lead" }, "uitvraagReminders": [] } | 1778414857015 |
| f2cc62b1-4d88-4eff-8ac0-3d15b7536ae6 | workflow_v1 | { "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:37.011Z", "phase": "F00_lead" }, "uitvraagReminders": [] } | 1778414857012 |
| 38217877-40af-4dc9-9aaa-a2f88154991f | workflow_v1 | { "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:37.001Z", "phase": "F00_lead" }, "uitvraagReminders": [] } | 1778414857002 |
| b1a25305-031f-4c74-9fa3-58038271ce95 | cm_sign | { "jobs": [], "fields": [], "locale": "nl-NL", "archive": false, "signers": [ { "id": "a1", "name": "Raymon Luciën MOLLINK", "email": "", "label": "Aanvrager 1", "phone": "", "locale": "nl-NL", "channel": "email", "enabled": true, "tagDate": "{date1}", "position": 1, "readOnly": false, "reference": "", "redirectUrl": "", "tagInitials": "{initials1}", "tagRequired": true, "tagSignature": "{signature1}", "customMessage": "", "notifications": [], "reminderInDays": 7, "inviteExpiresInDays": 30, "authenticationMethods": [], "identificationMethods": [] }, { "id": "a2", "name": "C. Baljé", "email": "", "label": "Aanvrager 2", "phone": "", "locale": "nl-NL", "channel": "email", "enabled": true, "tagDate": "{date2}", "position": 1, "readOnly": false, "reference": "", "redirectUrl": "", "tagInitials": "{initials2}", "tagRequired": true, "tagSignature": "{signature2}", "customMessage": "", "notifications": [], "reminderInDays": 7, "inviteExpiresInDays": 30, "authenticationMethods": [], "identificationMethods": [] } ], "timezone": "Europe/Amsterdam", "updatedAt" ... [afgekapt: 496 tekens] | 1778413673796 |
| 38217877-40af-4dc9-9aaa-a2f88154991f | advies-onderwerpen | {} | 1778391504860 |
| 38217877-40af-4dc9-9aaa-a2f88154991f | advies-motivering | {} | 1778391504796 |
| 38217877-40af-4dc9-9aaa-a2f88154991f | _sources | { "klantprofiel.value": { "source": "Eigen invoer", "updated_at": "2026-05-08T11:12:02.800Z" }, "aanvraagproces.value": { "source": "Eigen invoer", "updated_at": "2026-05-08T11:12:09.914Z" }, "inventarisatie.value": { "source": "Eigen invoer", "updated_at": "2026-05-08T11:11:42.854Z" }, "aanvraagproces.history": { "source": "Eigen invoer", "updated_at": "2026-05-09T16:41:15.850Z" }, "advies-motivering.value": { "source": "Eigen invoer", "updated_at": "2026-05-08T11:12:08.335Z" }, "advies-onderwerpen.value": { "source": "Eigen invoer", "updated_at": "2026-05-08T11:12:08.039Z" }, "inventarisatie.inc1.payrolls": { "source": "Eigen invoer", "updated_at": "2026-05-10T05:38:19.812Z" }, "inventarisatie.inc2.payrolls": { "source": "Eigen invoer", "updated_at": "2026-05-10T05:38:19.812Z" }, "inventarisatie.inc1.caoResults": { "source": "Eigen invoer", "updated_at": "2026-05-10T05:38:19.812Z" }, "inventarisatie.inc2.caoResults": { "source": "Eigen invoer", "updated_at": "2026-05-10T05:38:19.812Z" }, "inventarisatie.inc1.extraIncomeTypes": { "source": "Eigen invoer", "updated_at": "2026-05-10T05:38:19.812Z" }, "inventarisatie.inc2.extraIncomeTypes": { "source": "Eigen invoer", "updated_at": "2026-05-10T05:38:19. ... [afgekapt: 4133 tekens] | 1778391503981 |
| 38217877-40af-4dc9-9aaa-a2f88154991f | inventarisatie | { "a1": {}, "a2": {}, "data": {}, "inc1": { "cao": {}, "type": "loondienst", "fields": { "aov_iva_pct": "75", "aov_ao_klasse": "65", "aov_lgu_daarna_pct": "70", "ww_maximumdagloon_toepassen": "Ja", "aov_lgu_eerste_2_maanden_pct": "75", "aov_loondoorbetaling_jaar1_pct": "70", "aov_loondoorbetaling_jaar2_pct": "70", "aov_loongerelateerd_duur_maanden": "24" }, "payrolls": [], "caoResults": [], "payrollYear": "2026", "extraIncomeTypes": [] }, "inc2": { "cao": {}, "type": "loondienst", "fields": { "aov_iva_pct": "75", "aov_ao_klasse": "65", "aov_lgu_daarna_pct": "70", "ww_maximumdagloon_toepassen": "Ja", "aov_lgu_eerste_2_maanden_pct": "75", "aov_loondoorbetaling_jaar1_pct": "70", "aov_loondoorbetaling_jaar2_pct": "70", "aov_loongerelateerd_duur_maanden": "24" }, "payrolls": [], "caoResults": [], "payrollYear": "2026", "extraIncomeTypes": [] } } | 1778391503960 |
| 38217877-40af-4dc9-9aaa-a2f88154991f | aanvraagproces-stukken | { "log": [], "stukken": [], "templateId": "nhg-loondienst-koop" } | 1778344913603 |
| 38217877-40af-4dc9-9aaa-a2f88154991f | aanvraagproces | { "status": "nieuw", "history": [], "notitie": "" } | 1778344875850 |
| 38217877-40af-4dc9-9aaa-a2f88154991f | klantprofiel | { "woonduur": "10 jaar", "aanleiding": [ "Aankoop bestaande woning" ], "aov_periode": "Minstens 10 jaar", "verduurzaming": "Nee", "aflossingsvorm": "Annuïtair", "aov_motivering": "€ 45.000 nog over uit een erfenis na overdracht", "aov_verzekeren": "Zeer beperkt", "grote_uitgaven": "Nee", "rentevast_wens": "6 tot 10 jaar", "productvoorkeur": "Minder risico/veilig rendement", "wijziging_gezin": "Nee", "hypotheek_doelen": [ "Een woning kopen | prioriteit 1", "Stabiele maandlasten lange periode | prioriteit 2" ], "financiele_doelen": [ "Zekerheid van voldoende inkomsten in alle situaties" ], "hypotheek_koopsom": "€ 401.000", "risico_acceptatie": "Gokje mag, geen grote risico's", "verantwoord_lenen": [ "Niet meer dan volgens GHF-toetsing verantwoord is", "Lening op basis van Nationale Hypotheek Garantie" ], "ww_inkomensniveau": "Niet van toepassing", "ww_wensen_partner": [ "Niets verzekeren" ], "aov_inkomensniveau": "90%", "aov_wensen_partner": [ "Inkomensaanvulling" ], "inbreng_eigen_geld": "Verlagen hypotheek", "overlijden_periode": "Tijdelijk", "fiscale_aftrek_wens": "Consumptieve besteding meefinancieren", "uitgaven_bijstellen": "Besparen op levensonderhoud", "wijziging_werkgever": "Nee", "ww_wensen_aanvrager": [ "Niets verzekeren" ], "zek ... [afgekapt: 677 tekens] | 1778238722800 |
| e009fdc6-5896-443d-90f0-d486822002f1 | base_import | { "adres": "Westhoven 68", "klant": "Duinen, Marco van (J.R.M.), Harmsen, Suzanne (S)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8219 AG", "products": [ { "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": "2617483", "passeeringangsdatum": "2018-03-01" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "323431.00", "status": "Gepasseerd", "artikel": "Woongenot Annuïteit, Woongenot Annuïteit", "tekendatum": "25569", "productnaam": "Woongenot Annuïteit, Woongenot Annuïteit", "maatschappij": "Centraal Beheer (voormalig Woonfonds)", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3058261", "passeeringangsdatum": "2018-06-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artike ... [afgekapt: 1123 tekens] | 1778230486535 |
| 41b76f8c-e0c1-43ec-aacf-51e903f0224b | inventarisatie | { "a1": { "naam": "Nguyen, Phuong (TP)", "adres": "Kempenaar 05 34", "email": "[email]", "postcode": "8231 EA", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Kempenaar 05 34", "postcode": "8231 EA", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "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": "2452410", "passeeringangsdatum": "2017-09-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2017-07-27" }, { "norm": "NHG ... [afgekapt: 1661 tekens] | 1778230486535 |
| e009fdc6-5896-443d-90f0-d486822002f1 | inventarisatie | { "a1": { "naam": "Duinen, Marco van (J.R.M.)", "adres": "Westhoven 68", "email": "[email]", "postcode": "8219 AG", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Harmsen, Suzanne (S)", "adres": "Westhoven 68", "postcode": "8219 AG", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "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": "2617483", "passeeringangsdatum": "2018-03-01" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "323431.00", "status": "Gepasseerd", "artikel": "Woongenot Annuïteit, Woongenot Annuïteit", "tekendatum": "25569", "productnaam": "Woongenot Annuïteit, Woongenot Annuïteit", "maatschappij": "Centraal Beheer (voormalig Woonfonds)", "product ... [afgekapt: 638 tekens] | 1778230486535 |
| 01c1072c-d3e9-42dc-a6ab-c7d4c73698d5 | base_import | { "adres": "Langezand 118", "klant": "Hamchout, Nabil (N)", "plaats": "LELYSTAD", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8223 WJ", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-01-30" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "163467", "Hamchout, Nabil (N)", "Langezand 118", "8223 WJ", "LELYSTAD", "[email]", "[telefoon]", "Eigen kantoor", "Hypotheekadvies" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "163467", "dossiernummer": "163467", "dossierstatus": "Vervallen", "email_partner": "", "telefoonnummer": "[telefoon]", "email_aanvrager": "[email]" } | 1778230486535 |
| 01c1072c-d3e9-42dc-a6ab-c7d4c73698d5 | inventarisatie | { "a1": { "naam": "Hamchout, Nabil (N)", "adres": "Langezand 118", "email": "[email]", "postcode": "8223 WJ", "woonplaats": "LELYSTAD", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Langezand 118", "postcode": "8223 WJ", "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-01-30" } ], "crmdossier_id": "163467", "dossiernummer": "163467", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| 21f40268-9212-46e9-8bcc-3510b245e5c8 | base_import | { "adres": "Galjoen 19 29", "klant": "Husslage, Maria (MS), Karper, Lambartes (LN)", "plaats": "LELYSTAD", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 LX", "products": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-08-21", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-08-21" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "126410", "Husslage, Maria (MS), Karper, Lambartes (LN)", "Galjoen 19 29", "8243 LX", "LELYSTAD", "[email]", "[telefoon]", "Eigen kantoor", "Dienst", "Advies nieuwe Hypotheek/Doorstromer", "Dienst BTW vrij" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "126410", "dossiernummer": "126410", "dossierstatus": "Vervallen", "email_partner": "[email]", "telefoonnummer": "[telefoon]", "email_aanvrager": "[email]" } | 1778230486535 |
| a91a1675-5264-4d67-9edd-f4c7bace8b3c | base_import | { "adres": "Voorstraat 508", "klant": "Dijk, van (MG), Dijk, van (Y)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8226 KG", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "121198.00", "status": "Lopend", "artikel": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek", "tekendatum": "25569", "productnaam": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Aflossingsvrij", "factuurbedrag": "", "offertenummer": "2058189", "passeeringangsdatum": "2022-05-01" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "246099", "Dijk, van (MG), Dijk, van (Y)", "Voorstraat 508", "8226 KG", "Lelystad", "[email]", "[telefoon]", "2058189", "Lloyds Bank", "Hypotheek", "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek", "Aflossingsvrij" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.x ... [afgekapt: 151 tekens] | 1778230486535 |
| a91a1675-5264-4d67-9edd-f4c7bace8b3c | inventarisatie | { "a1": { "naam": "Dijk, van (MG)", "adres": "Voorstraat 508", "email": "[email]", "postcode": "8226 KG", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Dijk, van (Y)", "adres": "Voorstraat 508", "postcode": "8226 KG", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "121198.00", "status": "Lopend", "artikel": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek", "tekendatum": "25569", "productnaam": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Aflossingsvrij", "factuurbedrag": "", "offertenummer": "2058189", "passeeringangsdatum": "2022-05-01" } ], "crmdossier_id": "246099", "dossiernummer": "246099", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| d4fbf[telefoon]c-8adc-d4ae53e4fa10 | base_import | { "adres": "Kogge 05 3", "klant": "Nagel, Eddy (E)", "plaats": "LELYSTAD", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 AT", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair", "tekendatum": "25569", "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair", "maatschappij": "Dazure", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "ISW-6CF8C52D-8DA1-4606-ADE5-E59007FED0BC(1)", "passeeringangsdatum": "2016-11-01" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "134334", "Nagel, Eddy (E)", "Kogge 05 3", "8242 AT", "LELYSTAD", "[email]", "[telefoon]", "ISW-6CF8C52D-8DA1-4606-ADE5-E59007FED0BC(1)", "Dazure", "Levensverzekering", "GewoonIdee Nabestaandenverzekering - Annuitair", "Annuitair Dalende Risicoverzekeringen" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "134334", "dossiernummer": "134334", "dossierstatus": "Ve ... [afgekapt: 61 tekens] | 1778230486535 |
| d4fbf[telefoon]c-8adc-d4ae53e4fa10 | inventarisatie | { "a1": { "naam": "Nagel, Eddy (E)", "adres": "Kogge 05 3", "email": "[email]", "postcode": "8242 AT", "woonplaats": "LELYSTAD", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Kogge 05 3", "postcode": "8242 AT", "woonplaats": "LELYSTAD" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair", "tekendatum": "25569", "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair", "maatschappij": "Dazure", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "ISW-6CF8C52D-8DA1-4606-ADE5-E59007FED0BC(1)", "passeeringangsdatum": "2016-11-01" } ], "crmdossier_id": "134334", "dossiernummer": "134334", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| 59f2bde0-7b74-403a-a008-78a6e18a10a4 | base_import | { "adres": "Kogge 11 61", "klant": "Schukelaar, Kitty (K.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 AE", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "127200.00", "status": "Lopend", "artikel": "Argenta Annuiteit (Argenta Hypotheek)", "tekendatum": "25569", "productnaam": "Argenta Annuiteit (Argenta Hypotheek)", "maatschappij": "Argenta hypotheken", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "2436612", "passeeringangsdatum": "2013-01-17" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "95234", "Schukelaar, Kitty (K.)", "Kogge 11 61", "8243 AE", "Lelystad", "[email]", "06 - 46 31 38 03", "2436612", "Argenta hypotheken", "Hypotheek", "Argenta Annuiteit (Argenta Hypotheek)", "Annuitair" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "95234", "dossiernummer": "95234", "dossierstatus": "Actief", "email_partner": "[email]", "telefoonnummer": "06 - 46 31 38 03", "email_aanvrager": "" } | 1778230486535 |
| 59f2bde0-7b74-403a-a008-78a6e18a10a4 | inventarisatie | { "a1": { "naam": "Schukelaar, Kitty (K.)", "adres": "Kogge 11 61", "postcode": "8243 AE", "woonplaats": "Lelystad", "telefoon_prive": "06 - 46 31 38 03" }, "a2": { "adres": "Kogge 11 61", "email": "[email]", "postcode": "8243 AE", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "127200.00", "status": "Lopend", "artikel": "Argenta Annuiteit (Argenta Hypotheek)", "tekendatum": "25569", "productnaam": "Argenta Annuiteit (Argenta Hypotheek)", "maatschappij": "Argenta hypotheken", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "2436612", "passeeringangsdatum": "2013-01-17" } ], "crmdossier_id": "95234", "dossiernummer": "95234", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| ecca24d3-e4ea-4c4b-a264-1dd277457127 | base_import | { "adres": "Bongerd 41", "klant": "IJsebrands, Keven (K)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8212 BB", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "GoedIdee Nabestaandenverzekering Annuïtair", "tekendatum": "25569", "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair", "maatschappij": "Dazure", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "GINV.408733", "passeeringangsdatum": "2014-11-01" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "95074", "IJsebrands, Keven (K)", "Bongerd 41", "8212 BB", "Lelystad", "[email]", "[telefoon]", "GINV.408733", "Dazure", "Levensverzekering", "GoedIdee Nabestaandenverzekering Annuïtair", "Annuitair Dalende Risicoverzekeringen" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "95074", "dossiernummer": "95074", "dossierstatus": "Vervallen", "email_partner": "", "telefoonnummer": "[telefoon]", "email_aanvrager": "[email]" } | 1778230486535 |
| ecca24d3-e4ea-4c4b-a264-1dd277457127 | inventarisatie | { "a1": { "naam": "IJsebrands, Keven (K)", "adres": "Bongerd 41", "email": "[email]", "postcode": "8212 BB", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Bongerd 41", "postcode": "8212 BB", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "GoedIdee Nabestaandenverzekering Annuïtair", "tekendatum": "25569", "productnaam": "GoedIdee Nabestaandenverzekering Annuïtair", "maatschappij": "Dazure", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "GINV.408733", "passeeringangsdatum": "2014-11-01" } ], "crmdossier_id": "95074", "dossiernummer": "95074", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| 41b76f8c-e0c1-43ec-aacf-51e903f0224b | base_import | { "adres": "Kempenaar 05 34", "klant": "Nguyen, Phuong (TP)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8231 EA", "products": [ { "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": "2452410", "passeeringangsdatum": "2017-09-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2017-07-27" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "146289.00", "status": "Gepasseerd", "artikel": "Merius annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Merius annuiteitenhypotheek", "maatschappij": "Merius Hypotheken", ... [afgekapt: 2336 tekens] | 1778230486535 |
| c6aa966c-9484-45d3-8118-854a0c5b76f1 | inventarisatie | { "a1": { "naam": "Chaoui (N.R.)", "adres": "Diopter 31", "email": "[email]", "postcode": "1025 MR", "woonplaats": "AMSTERDAM", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Jong, de (L.N.)", "adres": "Diopter 31", "email": "[email]", "postcode": "1025 MR", "woonplaats": "AMSTERDAM" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Offerte aangevraagd", "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair", "tekendatum": "25569", "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair", "maatschappij": "Dazure", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "ISW-E6D355EA-973A-4D66-A058-1FC9674DED5A(1)", "passeeringangsdatum": "2017-05-01" } ], "crmdossier_id": "145444", "dossiernummer": "145444", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| c6aa966c-9484-45d3-8118-854a0c5b76f1 | base_import | { "adres": "Diopter 31", "klant": "Chaoui (N.R.), Jong, de (L.N.)", "plaats": "AMSTERDAM", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "1025 MR", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Offerte aangevraagd", "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair", "tekendatum": "25569", "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair", "maatschappij": "Dazure", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "ISW-E6D355EA-973A-4D66-A058-1FC9674DED5A(1)", "passeeringangsdatum": "2017-05-01" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "145444", "Chaoui (N.R.), Jong, de (L.N.)", "Diopter 31", "1025 MR", "AMSTERDAM", "[email]", "[email]", "[telefoon]", "ISW-E6D355EA-973A-4D66-A058-1FC9674DED5A(1)", "Dazure", "Levensverzekering", "GewoonIdee Nabestaandenverzekering - Annuitair", "Annuitair Dalende Risicoverzekeringen" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "145444", ... [afgekapt: 120 tekens] | 1778230486535 |
| 9370bf61-e2bd-4aa1-b296-b60509b8d863 | base_import | { "adres": "Horst 26 09", "klant": "Bos, Thea (MC)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8225 PA", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "114400.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2015-02-16" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "95189", "Bos, Thea (MC)", "Horst 26 09", "8225 PA", "Lelystad", "[telefoon]", "*********", "ING Bank", "Hypotheek", "ING Annuiteitenhypotheek (Reguliere hypotheek)", "Annuitair" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "95189", "dossiernummer": "95189", "dossierstatus": "Vervallen", "email_partner": "", "telefoonnummer": "[telefoon]", "email_aanvrager": "" } | 1778230486535 |
| 9acff048-ed80-4b37-9dd8-a7ce04bf43c1 | base_import | { "adres": "Sluiswachtershoeve 701", "klant": "Flipse, Lia (C.C.), Koukolis (E.)", "plaats": "Apeldoorn", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "7326 ZJ", "products": [ { "norm": "", "type": "Consumptief krediet", "inhoud": "0.00", "status": "Lopend", "artikel": "Interbank Persoonlijke Lening", "tekendatum": "25569", "productnaam": "Interbank Persoonlijke Lening", "maatschappij": "InterBank NV", "productsoort": "Persoonlijke lening", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2017-11-09" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "153872", "Flipse, Lia (C.C.), Koukolis (E.)", "Sluiswachtershoeve 701", "7326 ZJ", "Apeldoorn", "[email]", "*********", "InterBank NV", "Consumptief krediet", "Interbank Persoonlijke Lening", "Persoonlijke lening" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "153872", "dossiernummer": "153872", "dossierstatus": "Actief", "email_partner": "[email]", "telefoonnummer": "", "email_aanvrager": "" } | 1778230486535 |
| 9acff048-ed80-4b37-9dd8-a7ce04bf43c1 | inventarisatie | { "a1": { "naam": "Flipse, Lia (C.C.)", "adres": "Sluiswachtershoeve 701", "postcode": "7326 ZJ", "woonplaats": "Apeldoorn" }, "a2": { "naam": "Koukolis (E.)", "adres": "Sluiswachtershoeve 701", "email": "[email]", "postcode": "7326 ZJ", "woonplaats": "Apeldoorn" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Consumptief krediet", "inhoud": "0.00", "status": "Lopend", "artikel": "Interbank Persoonlijke Lening", "tekendatum": "25569", "productnaam": "Interbank Persoonlijke Lening", "maatschappij": "InterBank NV", "productsoort": "Persoonlijke lening", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2017-11-09" } ], "crmdossier_id": "153872", "dossiernummer": "153872", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| e5e995df-d6f6-4a9a-b6a3-40fc21a22c87 | base_import | { "adres": "Jol 17 67", "klant": "Komarov (M.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 GE", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "209899.00", "status": "Gepasseerd", "artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Bankspaar", "factuurbedrag": "", "offertenummer": "K 090-849518", "passeeringangsdatum": "2010-10-01" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "100537", "Komarov (M.)", "Jol 17 67", "8243 GE", "Lelystad", "06 - 19 85 70 41", "K 090-849518", "ING Bank", "Hypotheek", "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek)", "Bankspaar" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "100537", "dossiernummer": "100537", "dossierstatus": "Actief", "email_partner": "", "telefoonnummer": "06 - 19 85 70 41", "email_aanvrager": "" } | 1778230486535 |
| e5e995df-d6f6-4a9a-b6a3-40fc21a22c87 | inventarisatie | { "a1": { "naam": "Komarov (M.)", "adres": "Jol 17 67", "postcode": "8243 GE", "woonplaats": "Lelystad", "telefoon_prive": "06 - 19 85 70 41" }, "a2": { "adres": "Jol 17 67", "postcode": "8243 GE", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "209899.00", "status": "Gepasseerd", "artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Bankspaar", "factuurbedrag": "", "offertenummer": "K 090-849518", "passeeringangsdatum": "2010-10-01" } ], "crmdossier_id": "100537", "dossiernummer": "100537", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| e9b6143b-e266-4ccb-b4a7-3b97821ce9cf | base_import | { "adres": "Langezand 59", "klant": "Broekhuis (E.J.F.), Kemmer (D.B.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8223 WE", "products": [ { "norm": "", "type": "Consumptief krediet", "inhoud": "0.00", "status": "Lopend", "artikel": "DK", "tekendatum": "25569", "productnaam": "DK", "maatschappij": "Voordeelbank B.V.", "productsoort": "Doorlopend krediet", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2010-12-06" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "150656", "Broekhuis (E.J.F.), Kemmer (D.B.)", "Langezand 59", "8223 WE", "Lelystad", "*********", "Voordeelbank B.V.", "Consumptief krediet", "DK", "Doorlopend krediet" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "150656", "dossiernummer": "150656", "dossierstatus": "Actief", "email_partner": "", "telefoonnummer": "", "email_aanvrager": "" } | 1778230486535 |
| 141924d5-75c4-48db-84d7-c84a2ae7fef0 | base_import | { "adres": "van der Duyn van Maesdamstraat 17", "klant": "Homan (L.), Yigitalp, Mehmet (M)", "plaats": "Twello", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "7391 VH", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-07-24" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "173077", "Homan (L.), Yigitalp, Mehmet (M)", "van der Duyn van Maesdamstraat 17", "7391 VH", "Twello", "[email]", "[email]", "[telefoon]", "Eigen kantoor", "Hypotheekadvies" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "173077", "dossiernummer": "173077", "dossierstatus": "Vervallen", "email_partner": "[email]", "telefoonnummer": "[telefoon]", "email_aanvrager": "[email]" } | 1778230486535 |
| 141924d5-75c4-48db-84d7-c84a2ae7fef0 | inventarisatie | { "a1": { "naam": "Homan (L.)", "adres": "van der Duyn van Maesdamstraat 17", "email": "[email]", "postcode": "7391 VH", "woonplaats": "Twello", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Yigitalp, Mehmet (M)", "adres": "van der Duyn van Maesdamstraat 17", "email": "[email]", "postcode": "7391 VH", "woonplaats": "Twello" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-07-24" } ], "crmdossier_id": "173077", "dossiernummer": "173077", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| 1ec6af73-7121-4896-a89a-fb833f988e55 | base_import | { "adres": "Sowetostraat 10", "klant": "Zijlstra, Carmen (CT), Zijlstra, Roy (R)", "plaats": "HAARLEM", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "2033 CV", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "55198.00", "status": "Hypotheekaanbod aan klant verzonden", "artikel": "Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1896623", "passeeringangsdatum": "2025-03-28" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-01-31" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "242269.00", "status": "Gepasseerd", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", ... [afgekapt: 1636 tekens] | 1778230486535 |
| 1ec6af73-7121-4896-a89a-fb833f988e55 | inventarisatie | { "a1": { "naam": "Zijlstra, Carmen (CT)", "adres": "Sowetostraat 10", "email": "[email]", "postcode": "2033 CV", "woonplaats": "HAARLEM", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Zijlstra, Roy (R)", "adres": "Sowetostraat 10", "email": "[email]", "postcode": "2033 CV", "woonplaats": "HAARLEM" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "55198.00", "status": "Hypotheekaanbod aan klant verzonden", "artikel": "Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1896623", "passeeringangsdatum": "2025-03-28" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-01-31" }, { "nor ... [afgekapt: 1154 tekens] | 1778230486535 |
| 0921674e-ee46-4c59-8453-52511f1ac818 | base_import | { "adres": "Biesbosstraat 90", "klant": "Patricio, J (JB)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8226 ED", "products": [ { "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": "2298118", "passeeringangsdatum": "2016-09-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "166570.00", "status": "Gepasseerd", "artikel": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)", "tekendatum": "25569", "productnaam": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)", "maatschappij": "Rabobank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "28226605", "passeeringangsdatum": "2018-04-10" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvra ... [afgekapt: 1658 tekens] | 1778230486535 |
| 0921674e-ee46-4c59-8453-52511f1ac818 | inventarisatie | { "a1": { "naam": "Patricio, J (JB)", "adres": "Biesbosstraat 90", "email": "[email]", "postcode": "8226 ED", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Biesbosstraat 90", "postcode": "8226 ED", "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": "2298118", "passeeringangsdatum": "2016-09-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "166570.00", "status": "Gepasseerd", "artikel": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)", "tekendatum": "25569", "productnaam": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)", "maatschappij": "Rabobank", ... [afgekapt: 1103 tekens] | 1778230486535 |
| c5487cfc-5d09-4396-962a-84c807e83447 | inventarisatie | { "a1": { "naam": "Santing, Martijn (M)", "adres": "Schieveen 41", "email": "[email]", "postcode": "8219 CH", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Schieveen 41", "postcode": "8219 CH", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "226803.00", "status": "Offerte/renteaanbod ontvangen", "artikel": "Clarian Wonen Annuitair, Clarian Wonen Aflossingsvrij, Clarian Wonen Annuitair, Clarian Wonen Aflossingsvrij", "tekendatum": "25569", "productnaam": "Clarian Wonen Annuitair, Clarian Wonen Aflossingsvrij, Clarian Wonen Annuitair, Clarian Wonen Aflossingsvrij", "maatschappij": "Clarian Wonen", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3568679", "passeeringangsdatum": "2025-09-01" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "240437.00", "status": "Lopend", "artikel": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Merius aflossingsvrije ... [afgekapt: 1282 tekens] | 1778230486535 |
| 3126a04b-27e5-453b-abd0-2d401ad74c34 | base_import | { "adres": "Archipel 15 45", "klant": "Apeldoorn, Jan (JA)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8224 GD", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Overlijdensrisicoverzekering", "tekendatum": "25569", "productnaam": "Overlijdensrisicoverzekering", "maatschappij": "Argenta hypotheken", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "[telefoon]-18", "passeeringangsdatum": "2018-02-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2017-11-21" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "196950.00", "status": "Gepasseerd", "artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Aflossingsvrij (Argenta Special Line Hypotheek)", "tekendatum": "25569", "productnaam": "Argenta Annuiteit (Argenta Special Line ... [afgekapt: 1165 tekens] | 1778230486535 |
| 7cab7326-17a1-4b69-a661-b8d7088a680b | inventarisatie | { "a1": { "naam": "Pruim, Jaap (J.A.)", "adres": "Majoraan 64", "email": "[email]", "postcode": "8252 BB", "woonplaats": "Dronten", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Stoop, Lotte (L.L.)", "adres": "Majoraan 64", "postcode": "8252 BB", "woonplaats": "Dronten" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Beeindigd", "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair", "tekendatum": "25569", "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair", "maatschappij": "Dazure", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "GEWI.607002", "passeeringangsdatum": "2015-06-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "182500.00", "status": "Gepasseerd", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offe ... [afgekapt: 191 tekens] | 1778230486535 |
| 7cab7326-17a1-4b69-a661-b8d7088a680b | base_import | { "adres": "Majoraan 64", "klant": "Pruim, Jaap (J.A.), Stoop, Lotte (L.L.)", "plaats": "Dronten", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8252 BB", "products": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Beeindigd", "artikel": "GewoonIdee Nabestaandenverzekering - Annuitair", "tekendatum": "25569", "productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair", "maatschappij": "Dazure", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "GEWI.607002", "passeeringangsdatum": "2015-06-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "182500.00", "status": "Gepasseerd", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2016-11-28" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "103725", "Pruim, Jaap (J.A.), Stoop, Lotte (L.L.)", "Majo ... [afgekapt: 626 tekens] | 1778230486535 |
| 9284d523-95cb-4791-ae51-493ed0a75f51 | inventarisatie | { "a1": { "naam": "Abadi (M.)", "adres": "Botter 11 02", "email": "[email]", "postcode": "8232 JL", "woonplaats": "Lelystad", "telefoon_prive": "06 - 81 63 40 37" }, "a2": { "adres": "Botter 11 02", "postcode": "8232 JL", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "156847.00", "status": "Gepasseerd", "artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Aflossingsvrij, Bankspaar", "factuurbedrag": "", "offertenummer": "Z 090-859858", "passeeringangsdatum": "2010-10-25" } ], "crmdossier_id": "100639", "dossiernummer": "100639", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| 3126a04b-27e5-453b-abd0-2d401ad74c34 | inventarisatie | { "a1": { "naam": "Apeldoorn, Jan (JA)", "adres": "Archipel 15 45", "email": "[email]", "postcode": "8224 GD", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Archipel 15 45", "postcode": "8224 GD", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Overlijdensrisicoverzekering", "tekendatum": "25569", "productnaam": "Overlijdensrisicoverzekering", "maatschappij": "Argenta hypotheken", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "[telefoon]-18", "passeeringangsdatum": "2018-02-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2017-11-21" }, { "norm": "NHG", "type": "Hypotheek", "inhoud" ... [afgekapt: 672 tekens] | 1778230486535 |
| d06b3bcf-43f9-4577-985f-6781e3bba4bd | base_import | { "adres": "J. Kammingastraat 115", "klant": "Schelling, Anoushka (A.S.), Schelling, Zobraakanya (ZIS)", "plaats": "Wildervank", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "9648 KL", "products": [ { "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": "2605308", "passeeringangsdatum": "2018-01-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2017-12-19" }, { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "Woonhuisverzekering, Aansprakelijkheidsverzekering Particulieren", "tekendatum": "25569", "p ... [afgekapt: 1849 tekens] | 1778230486535 |
Raw JSON details
Rij 1101
{
"dossier_id": "e51eea36-c801-4ba2-aa5c-572a93ec7d3e",
"key": "workflow_v1",
"value_json": {
"flags": [],
"actions": [],
"lastDerived": {
"at": "2026-05-10T12:07:37.034Z",
"phase": "F00_lead"
},
"uitvraagReminders": []
},
"updated_at": 1778414857034
}Rij 1102
{
"dossier_id": "616f67de-d4f6-43aa-ba94-eb1e779d3c56",
"key": "workflow_v1",
"value_json": {
"flags": [],
"actions": [],
"lastDerived": {
"at": "2026-05-10T12:07:37.031Z",
"phase": "F00_lead"
},
"uitvraagReminders": []
},
"updated_at": 1778414857031
}Rij 1103
{
"dossier_id": "2e098bed-a67d-4934-97eb-9acfbeb3ef13",
"key": "workflow_v1",
"value_json": {
"flags": [],
"actions": [],
"lastDerived": {
"at": "2026-05-10T12:07:37.027Z",
"phase": "F00_lead"
},
"uitvraagReminders": []
},
"updated_at": 1778414857027
}Rij 1104
{
"dossier_id": "25501a81-4d82-400f-9fc9-c60bf6fb1a50",
"key": "workflow_v1",
"value_json": {
"flags": [],
"actions": [],
"lastDerived": {
"at": "2026-05-10T12:07:37.014Z",
"phase": "F00_lead"
},
"uitvraagReminders": []
},
"updated_at": 1778414857015
}Rij 1105
{
"dossier_id": "f2cc62b1-4d88-4eff-8ac0-3d15b7536ae6",
"key": "workflow_v1",
"value_json": {
"flags": [],
"actions": [],
"lastDerived": {
"at": "2026-05-10T12:07:37.011Z",
"phase": "F00_lead"
},
"uitvraagReminders": []
},
"updated_at": 1778414857012
}Rij 1106
{
"dossier_id": "38217877-40af-4dc9-9aaa-a2f88154991f",
"key": "workflow_v1",
"value_json": {
"flags": [],
"actions": [],
"lastDerived": {
"at": "2026-05-10T12:07:37.001Z",
"phase": "F00_lead"
},
"uitvraagReminders": []
},
"updated_at": 1778414857002
}Rij 1107
{
"dossier_id": "b1a25305-031f-4c74-9fa3-58038271ce95",
"key": "cm_sign",
"value_json": {
"jobs": [],
"fields": [],
"locale": "nl-NL",
"archive": false,
"signers": [
{
"id": "a1",
"name": "Raymon Luciën MOLLINK",
"email": "",
"label": "Aanvrager 1",
"phone": "",
"locale": "nl-NL",
"channel": "email",
"enabled": true,
"tagDate": "{date1}",
"position": 1,
"readOnly": false,
"reference": "",
"redirectUrl": "",
"tagInitials": "{initials1}",
"tagRequired": true,
"tagSignature": "{signature1}",
"customMessage": "",
"notifications": [],
"reminderInDays": 7,
"inviteExpiresInDays": 30,
"authenticationMethods": [],
"identificationMethods": []
},
{
"id": "a2",
"name": "C. Baljé",
"email": "",
"label": "Aanvrager 2",
"phone": "",
"locale": "nl-NL",
"channel": "email",
"enabled": true,
"tagDate": "{date2}",
"position": 1,
"readOnly": false,
"reference": "",
"redirectUrl": "",
"tagInitials": "{initials2}",
"tagRequired": true,
"tagSignature": "{signature2}",
"customMessage": "",
"notifications": [],
"reminderInDays": 7,
"inviteExpiresInDays": 30,
"authenticationMethods": [],
"identificationMethods": []
}
],
"timezone": "Europe/Amsterdam",
"updatedAt": "2026-05-10T11:47:53.796Z",
"ownerEmail": "",
"dossierName": "Ondertekening hypotheekdossier",
"sendInvites": true,
"reassignable": false,
"expiresInDays": 30,
"reminderInDays": 7,
"usePrepareMode": false,
"selectedFileIds": [
"2255af5e-4f59-42b5-a948-b9e903cc2aa7",
"563a1b5b-225c-4cc1-bbee-a4c8390839c2",
"e30a3802-c1ca-408a-974d-8234685fec18",
"0cb940bb-a6bc-41eb-a84f-e6ec90e728a4",
"9b23c59c-13ce-4c3b-a17f-73263687f975"
],
"prepareReturnUrl": "",
"fieldPlacementMode": "coordinates"
},
"updated_at": 1778413673796
}Rij 1108
{
"dossier_id": "38217877-40af-4dc9-9aaa-a2f88154991f",
"key": "advies-onderwerpen",
"value_json": {},
"updated_at": 1778391504860
}Rij 1109
{
"dossier_id": "38217877-40af-4dc9-9aaa-a2f88154991f",
"key": "advies-motivering",
"value_json": {},
"updated_at": 1778391504796
}Rij 1110
{
"dossier_id": "38217877-40af-4dc9-9aaa-a2f88154991f",
"key": "_sources",
"value_json": {
"klantprofiel.value": {
"source": "Eigen invoer",
"updated_at": "2026-05-08T11:12:02.800Z"
},
"aanvraagproces.value": {
"source": "Eigen invoer",
"updated_at": "2026-05-08T11:12:09.914Z"
},
"inventarisatie.value": {
"source": "Eigen invoer",
"updated_at": "2026-05-08T11:11:42.854Z"
},
"aanvraagproces.history": {
"source": "Eigen invoer",
"updated_at": "2026-05-09T16:41:15.850Z"
},
"advies-motivering.value": {
"source": "Eigen invoer",
"updated_at": "2026-05-08T11:12:08.335Z"
},
"advies-onderwerpen.value": {
"source": "Eigen invoer",
"updated_at": "2026-05-08T11:12:08.039Z"
},
"inventarisatie.inc1.payrolls": {
"source": "Eigen invoer",
"updated_at": "2026-05-10T05:38:19.812Z"
},
"inventarisatie.inc2.payrolls": {
"source": "Eigen invoer",
"updated_at": "2026-05-10T05:38:19.812Z"
},
"inventarisatie.inc1.caoResults": {
"source": "Eigen invoer",
"updated_at": "2026-05-10T05:38:19.812Z"
},
"inventarisatie.inc2.caoResults": {
"source": "Eigen invoer",
"updated_at": "2026-05-10T05:38:19.812Z"
},
"inventarisatie.inc1.extraIncomeTypes": {
"source": "Eigen invoer",
"updated_at": "2026-05-10T05:38:19.812Z"
},
"inventarisatie.inc2.extraIncomeTypes": {
"source": "Eigen invoer",
"updated_at": "2026-05-10T05:38:19.812Z"
},
"inventarisatie.inc1.fields.aov_iva_pct": {
"label": "IVA percentage",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc2.fields.aov_iva_pct": {
"label": "IVA percentage",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"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-10T05:38:23.633Z",
"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-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc1.fields.aov_lgu_daarna_pct": {
"label": "WGA LGU daarna",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"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-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc1.fields.ww_maximumdagloon_toepassen": {
"label": "WW maximumdagloon toepassen",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc2.fields.ww_maximumdagloon_toepassen": {
"label": "WW maximumdagloon toepassen",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc1.fields.aov_lgu_eerste_2_maanden_pct": {
"label": "WGA LGU eerste 2 maanden",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc2.fields.aov_lgu_eerste_2_maanden_pct": {
"label": "WGA LGU eerste 2 maanden",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc1.fields.aov_loondoorbetaling_jaar1_pct": {
"label": "AOV loondoorbetaling jaar 1",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc1.fields.aov_loondoorbetaling_jaar2_pct": {
"label": "AOV loondoorbetaling jaar 2",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc2.fields.aov_loondoorbetaling_jaar1_pct": {
"label": "AOV loondoorbetaling jaar 1",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc2.fields.aov_loondoorbetaling_jaar2_pct": {
"label": "AOV loondoorbetaling jaar 2",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc1.fields.aov_loongerelateerd_duur_maanden": {
"label": "WGA LGU duur",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossier-context"
},
"inventarisatie.inc2.fields.aov_loongerelateerd_duur_maanden": {
"label": "WGA LGU duur",
"source": "Afgeleid",
"confidence": 0.62,
"updated_at": "2026-05-10T05:38:23.633Z",
"derived_from": [],
"normalized_by": "dossie ... [afgekapt: 15 tekens]Rij 1111
{
"dossier_id": "38217877-40af-4dc9-9aaa-a2f88154991f",
"key": "inventarisatie",
"value_json": {
"a1": {},
"a2": {},
"data": {},
"inc1": {
"cao": {},
"type": "loondienst",
"fields": {
"aov_iva_pct": "75",
"aov_ao_klasse": "65",
"aov_lgu_daarna_pct": "70",
"ww_maximumdagloon_toepassen": "Ja",
"aov_lgu_eerste_2_maanden_pct": "75",
"aov_loondoorbetaling_jaar1_pct": "70",
"aov_loondoorbetaling_jaar2_pct": "70",
"aov_loongerelateerd_duur_maanden": "24"
},
"payrolls": [],
"caoResults": [],
"payrollYear": "2026",
"extraIncomeTypes": []
},
"inc2": {
"cao": {},
"type": "loondienst",
"fields": {
"aov_iva_pct": "75",
"aov_ao_klasse": "65",
"aov_lgu_daarna_pct": "70",
"ww_maximumdagloon_toepassen": "Ja",
"aov_lgu_eerste_2_maanden_pct": "75",
"aov_loondoorbetaling_jaar1_pct": "70",
"aov_loondoorbetaling_jaar2_pct": "70",
"aov_loongerelateerd_duur_maanden": "24"
},
"payrolls": [],
"caoResults": [],
"payrollYear": "2026",
"extraIncomeTypes": []
}
},
"updated_at": 1778391503960
}Rij 1112
{
"dossier_id": "38217877-40af-4dc9-9aaa-a2f88154991f",
"key": "aanvraagproces-stukken",
"value_json": {
"log": [],
"stukken": [],
"templateId": "nhg-loondienst-koop"
},
"updated_at": 1778344913603
}Rij 1113
{
"dossier_id": "38217877-40af-4dc9-9aaa-a2f88154991f",
"key": "aanvraagproces",
"value_json": {
"status": "nieuw",
"history": [],
"notitie": ""
},
"updated_at": 1778344875850
}Rij 1114
{
"dossier_id": "38217877-40af-4dc9-9aaa-a2f88154991f",
"key": "klantprofiel",
"value_json": {
"woonduur": "10 jaar",
"aanleiding": [
"Aankoop bestaande woning"
],
"aov_periode": "Minstens 10 jaar",
"verduurzaming": "Nee",
"aflossingsvorm": "Annuïtair",
"aov_motivering": "€ 45.000 nog over uit een erfenis na overdracht",
"aov_verzekeren": "Zeer beperkt",
"grote_uitgaven": "Nee",
"rentevast_wens": "6 tot 10 jaar",
"productvoorkeur": "Minder risico/veilig rendement",
"wijziging_gezin": "Nee",
"hypotheek_doelen": [
"Een woning kopen | prioriteit 1",
"Stabiele maandlasten lange periode | prioriteit 2"
],
"financiele_doelen": [
"Zekerheid van voldoende inkomsten in alle situaties"
],
"hypotheek_koopsom": "€ 401.000",
"risico_acceptatie": "Gokje mag, geen grote risico's",
"verantwoord_lenen": [
"Niet meer dan volgens GHF-toetsing verantwoord is",
"Lening op basis van Nationale Hypotheek Garantie"
],
"ww_inkomensniveau": "Niet van toepassing",
"ww_wensen_partner": [
"Niets verzekeren"
],
"aov_inkomensniveau": "90%",
"aov_wensen_partner": [
"Inkomensaanvulling"
],
"inbreng_eigen_geld": "Verlagen hypotheek",
"overlijden_periode": "Tijdelijk",
"fiscale_aftrek_wens": "Consumptieve besteding meefinancieren",
"uitgaven_bijstellen": "Besparen op levensonderhoud",
"wijziging_werkgever": "Nee",
"ww_wensen_aanvrager": [
"Niets verzekeren"
],
"zekerheid_rendement": "Zekerheid",
"aov_wachttijd_risico": "Niet van toepassing",
"aov_wensen_aanvrager": [
"Inkomensaanvulling"
],
"financiele_meevaller": "Nee",
"risico_rentestijging": "Beperkt",
"overlijden_motivering": "€ 45.000 nog over uit een erfenis na overdracht",
"inkomen_a1_ontwikkeling": "Stijgend",
"inkomen_a2_ontwikkeling": "Stijgend",
"aov_alternatief_vermogen": "Ja",
"overlijden_inkomensniveau": "90%",
"overlijden_wensen_partner": [
"Partner verzorgd achterlaten"
],
"overlijden_doel_voorziening": [
"Eenmalige uitkering bij overlijden"
],
"overlijden_wensen_aanvrager": [
"Partner verzorgd achterlaten"
],
"overlijden_alternatief_vermogen": "Ja"
},
"updated_at": 1778238722800
}Rij 1115
{
"dossier_id": "e009fdc6-5896-443d-90f0-d486822002f1",
"key": "base_import",
"value_json": {
"adres": "Westhoven 68",
"klant": "Duinen, Marco van (J.R.M.), Harmsen, Suzanne (S)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8219 AG",
"products": [
{
"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": "2617483",
"passeeringangsdatum": "2018-03-01"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "323431.00",
"status": "Gepasseerd",
"artikel": "Woongenot Annuïteit, Woongenot Annuïteit",
"tekendatum": "25569",
"productnaam": "Woongenot Annuïteit, Woongenot Annuïteit",
"maatschappij": "Centraal Beheer (voormalig Woonfonds)",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3058261",
"passeeringangsdatum": "2018-06-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2018-02-07"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 3,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"163913",
"Duinen, Marco van (J.R.M.), Harmsen, Suzanne (S)",
"Westhoven 68",
"8219 AG",
"Lelystad",
"[email]",
"[telefoon]",
"2617483",
"TAF",
"Levensverzekering",
"Credit Life International Overlijdensrisicoverzekering - Annuitair",
"Overlijdensrisicoverzekering",
"3058261",
"Centraal Beheer (voormalig Woonfonds)",
"Hypotheek",
"Woongenot Annuïteit, Woongenot Annuïteit",
"Annuitair",
"Eigen kantoor",
"Hypotheekadvies"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "163913",
"dossiernummer": "163913",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1116
{
"dossier_id": "41b76f8c-e0c1-43ec-aacf-51e903f0224b",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Nguyen, Phuong (TP)",
"adres": "Kempenaar 05 34",
"email": "[email]",
"postcode": "8231 EA",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Kempenaar 05 34",
"postcode": "8231 EA",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"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": "2452410",
"passeeringangsdatum": "2017-09-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2017-07-27"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "146289.00",
"status": "Gepasseerd",
"artikel": "Merius annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Merius annuiteitenhypotheek",
"maatschappij": "Merius Hypotheken",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3003564",
"passeeringangsdatum": "2017-10-31"
},
{
"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": "161289585385",
"passeeringangsdatum": "2017-10-31"
},
{
"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-08-01"
}
],
"crmdossier_id": "155094",
"dossiernummer": "155094",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1117
{
"dossier_id": "e009fdc6-5896-443d-90f0-d486822002f1",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Duinen, Marco van (J.R.M.)",
"adres": "Westhoven 68",
"email": "[email]",
"postcode": "8219 AG",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Harmsen, Suzanne (S)",
"adres": "Westhoven 68",
"postcode": "8219 AG",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"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": "2617483",
"passeeringangsdatum": "2018-03-01"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "323431.00",
"status": "Gepasseerd",
"artikel": "Woongenot Annuïteit, Woongenot Annuïteit",
"tekendatum": "25569",
"productnaam": "Woongenot Annuïteit, Woongenot Annuïteit",
"maatschappij": "Centraal Beheer (voormalig Woonfonds)",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3058261",
"passeeringangsdatum": "2018-06-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2018-02-07"
}
],
"crmdossier_id": "163913",
"dossiernummer": "163913",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1118
{
"dossier_id": "01c1072c-d3e9-42dc-a6ab-c7d4c73698d5",
"key": "base_import",
"value_json": {
"adres": "Langezand 118",
"klant": "Hamchout, Nabil (N)",
"plaats": "LELYSTAD",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8223 WJ",
"products": [
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2018-01-30"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"163467",
"Hamchout, Nabil (N)",
"Langezand 118",
"8223 WJ",
"LELYSTAD",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Hypotheekadvies"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "163467",
"dossiernummer": "163467",
"dossierstatus": "Vervallen",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1119
{
"dossier_id": "01c1072c-d3e9-42dc-a6ab-c7d4c73698d5",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Hamchout, Nabil (N)",
"adres": "Langezand 118",
"email": "[email]",
"postcode": "8223 WJ",
"woonplaats": "LELYSTAD",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Langezand 118",
"postcode": "8223 WJ",
"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-01-30"
}
],
"crmdossier_id": "163467",
"dossiernummer": "163467",
"dossierstatus": "Vervallen",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1120
{
"dossier_id": "21f40268-9212-46e9-8bcc-3510b245e5c8",
"key": "base_import",
"value_json": {
"adres": "Galjoen 19 29",
"klant": "Husslage, Maria (MS), Karper, Lambartes (LN)",
"plaats": "LELYSTAD",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8243 LX",
"products": [
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe Hypotheek/Doorstromer",
"tekendatum": "2020-08-21",
"productnaam": "Advies nieuwe Hypotheek/Doorstromer",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-08-21"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"126410",
"Husslage, Maria (MS), Karper, Lambartes (LN)",
"Galjoen 19 29",
"8243 LX",
"LELYSTAD",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Dienst",
"Advies nieuwe Hypotheek/Doorstromer",
"Dienst BTW vrij"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "126410",
"dossiernummer": "126410",
"dossierstatus": "Vervallen",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1121
{
"dossier_id": "a91a1675-5264-4d67-9edd-f4c7bace8b3c",
"key": "base_import",
"value_json": {
"adres": "Voorstraat 508",
"klant": "Dijk, van (MG), Dijk, van (Y)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8226 KG",
"products": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "121198.00",
"status": "Lopend",
"artikel": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek",
"tekendatum": "25569",
"productnaam": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek",
"maatschappij": "Lloyds Bank",
"productsoort": "Aflossingsvrij",
"factuurbedrag": "",
"offertenummer": "2058189",
"passeeringangsdatum": "2022-05-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"246099",
"Dijk, van (MG), Dijk, van (Y)",
"Voorstraat 508",
"8226 KG",
"Lelystad",
"[email]",
"[telefoon]",
"2058189",
"Lloyds Bank",
"Hypotheek",
"Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek",
"Aflossingsvrij"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "246099",
"dossiernummer": "246099",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1122
{
"dossier_id": "a91a1675-5264-4d67-9edd-f4c7bace8b3c",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Dijk, van (MG)",
"adres": "Voorstraat 508",
"email": "[email]",
"postcode": "8226 KG",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Dijk, van (Y)",
"adres": "Voorstraat 508",
"postcode": "8226 KG",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "121198.00",
"status": "Lopend",
"artikel": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek",
"tekendatum": "25569",
"productnaam": "Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek, Lloyds Aflossingsvrije Hypotheek",
"maatschappij": "Lloyds Bank",
"productsoort": "Aflossingsvrij",
"factuurbedrag": "",
"offertenummer": "2058189",
"passeeringangsdatum": "2022-05-01"
}
],
"crmdossier_id": "246099",
"dossiernummer": "246099",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1123
{
"dossier_id": "d4fbf[telefoon]c-8adc-d4ae53e4fa10",
"key": "base_import",
"value_json": {
"adres": "Kogge 05 3",
"klant": "Nagel, Eddy (E)",
"plaats": "LELYSTAD",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8242 AT",
"products": [
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
"tekendatum": "25569",
"productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "ISW-6CF8C52D-8DA1-4606-ADE5-E59007FED0BC(1)",
"passeeringangsdatum": "2016-11-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"134334",
"Nagel, Eddy (E)",
"Kogge 05 3",
"8242 AT",
"LELYSTAD",
"[email]",
"[telefoon]",
"ISW-6CF8C52D-8DA1-4606-ADE5-E59007FED0BC(1)",
"Dazure",
"Levensverzekering",
"GewoonIdee Nabestaandenverzekering - Annuitair",
"Annuitair Dalende Risicoverzekeringen"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "134334",
"dossiernummer": "134334",
"dossierstatus": "Vervallen",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1124
{
"dossier_id": "d4fbf[telefoon]c-8adc-d4ae53e4fa10",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Nagel, Eddy (E)",
"adres": "Kogge 05 3",
"email": "[email]",
"postcode": "8242 AT",
"woonplaats": "LELYSTAD",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Kogge 05 3",
"postcode": "8242 AT",
"woonplaats": "LELYSTAD"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
"tekendatum": "25569",
"productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "ISW-6CF8C52D-8DA1-4606-ADE5-E59007FED0BC(1)",
"passeeringangsdatum": "2016-11-01"
}
],
"crmdossier_id": "134334",
"dossiernummer": "134334",
"dossierstatus": "Vervallen",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1125
{
"dossier_id": "59f2bde0-7b74-403a-a008-78a6e18a10a4",
"key": "base_import",
"value_json": {
"adres": "Kogge 11 61",
"klant": "Schukelaar, Kitty (K.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8243 AE",
"products": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "127200.00",
"status": "Lopend",
"artikel": "Argenta Annuiteit (Argenta Hypotheek)",
"tekendatum": "25569",
"productnaam": "Argenta Annuiteit (Argenta Hypotheek)",
"maatschappij": "Argenta hypotheken",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "2436612",
"passeeringangsdatum": "2013-01-17"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"95234",
"Schukelaar, Kitty (K.)",
"Kogge 11 61",
"8243 AE",
"Lelystad",
"[email]",
"06 - 46 31 38 03",
"2436612",
"Argenta hypotheken",
"Hypotheek",
"Argenta Annuiteit (Argenta Hypotheek)",
"Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "95234",
"dossiernummer": "95234",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "06 - 46 31 38 03",
"email_aanvrager": ""
},
"updated_at": 1778230486535
}Rij 1126
{
"dossier_id": "59f2bde0-7b74-403a-a008-78a6e18a10a4",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Schukelaar, Kitty (K.)",
"adres": "Kogge 11 61",
"postcode": "8243 AE",
"woonplaats": "Lelystad",
"telefoon_prive": "06 - 46 31 38 03"
},
"a2": {
"adres": "Kogge 11 61",
"email": "[email]",
"postcode": "8243 AE",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "127200.00",
"status": "Lopend",
"artikel": "Argenta Annuiteit (Argenta Hypotheek)",
"tekendatum": "25569",
"productnaam": "Argenta Annuiteit (Argenta Hypotheek)",
"maatschappij": "Argenta hypotheken",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "2436612",
"passeeringangsdatum": "2013-01-17"
}
],
"crmdossier_id": "95234",
"dossiernummer": "95234",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1127
{
"dossier_id": "ecca24d3-e4ea-4c4b-a264-1dd277457127",
"key": "base_import",
"value_json": {
"adres": "Bongerd 41",
"klant": "IJsebrands, Keven (K)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8212 BB",
"products": [
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
"tekendatum": "25569",
"productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "GINV.408733",
"passeeringangsdatum": "2014-11-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"95074",
"IJsebrands, Keven (K)",
"Bongerd 41",
"8212 BB",
"Lelystad",
"[email]",
"[telefoon]",
"GINV.408733",
"Dazure",
"Levensverzekering",
"GoedIdee Nabestaandenverzekering Annuïtair",
"Annuitair Dalende Risicoverzekeringen"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "95074",
"dossiernummer": "95074",
"dossierstatus": "Vervallen",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1128
{
"dossier_id": "ecca24d3-e4ea-4c4b-a264-1dd277457127",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "IJsebrands, Keven (K)",
"adres": "Bongerd 41",
"email": "[email]",
"postcode": "8212 BB",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Bongerd 41",
"postcode": "8212 BB",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "GoedIdee Nabestaandenverzekering Annuïtair",
"tekendatum": "25569",
"productnaam": "GoedIdee Nabestaandenverzekering Annuïtair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "GINV.408733",
"passeeringangsdatum": "2014-11-01"
}
],
"crmdossier_id": "95074",
"dossiernummer": "95074",
"dossierstatus": "Vervallen",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1129
{
"dossier_id": "41b76f8c-e0c1-43ec-aacf-51e903f0224b",
"key": "base_import",
"value_json": {
"adres": "Kempenaar 05 34",
"klant": "Nguyen, Phuong (TP)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8231 EA",
"products": [
{
"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": "2452410",
"passeeringangsdatum": "2017-09-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2017-07-27"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "146289.00",
"status": "Gepasseerd",
"artikel": "Merius annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Merius annuiteitenhypotheek",
"maatschappij": "Merius Hypotheken",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3003564",
"passeeringangsdatum": "2017-10-31"
},
{
"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": "161289585385",
"passeeringangsdatum": "2017-10-31"
},
{
"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-08-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 5,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"155094",
"Nguyen, Phuong (TP)",
"Kempenaar 05 34",
"8231 EA",
"Lelystad",
"[email]",
"[telefoon]",
"2452410",
"TAF",
"Levensverzekering",
"Credit Life International Overlijdensrisicoverzekering - Annuitair",
"Overlijdensrisicoverzekering",
"Eigen kantoor",
"Hypotheekadvies",
"3003564",
"Merius Hypotheken",
"Hypotheek",
"Merius annuiteitenhypotheek",
"Annuitair",
"161289585385",
"Voogd & Voogd",
"Schadeverzekering",
"Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren",
"Aansprakelijkheid, Inboedel, Opstal",
"5369PK-*********",
"Risk Assuradeuren",
"Opstal, Inboedel, Aansprakelijkheid"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "155094",
"dossiernummer": "155094",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1130
{
"dossier_id": "c6aa966c-9484-45d3-8118-854a0c5b76f1",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Chaoui (N.R.)",
"adres": "Diopter 31",
"email": "[email]",
"postcode": "1025 MR",
"woonplaats": "AMSTERDAM",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Jong, de (L.N.)",
"adres": "Diopter 31",
"email": "[email]",
"postcode": "1025 MR",
"woonplaats": "AMSTERDAM"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Offerte aangevraagd",
"artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
"tekendatum": "25569",
"productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "ISW-E6D355EA-973A-4D66-A058-1FC9674DED5A(1)",
"passeeringangsdatum": "2017-05-01"
}
],
"crmdossier_id": "145444",
"dossiernummer": "145444",
"dossierstatus": "Vervallen",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1131
{
"dossier_id": "c6aa966c-9484-45d3-8118-854a0c5b76f1",
"key": "base_import",
"value_json": {
"adres": "Diopter 31",
"klant": "Chaoui (N.R.), Jong, de (L.N.)",
"plaats": "AMSTERDAM",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "1025 MR",
"products": [
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Offerte aangevraagd",
"artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
"tekendatum": "25569",
"productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "ISW-E6D355EA-973A-4D66-A058-1FC9674DED5A(1)",
"passeeringangsdatum": "2017-05-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"145444",
"Chaoui (N.R.), Jong, de (L.N.)",
"Diopter 31",
"1025 MR",
"AMSTERDAM",
"[email]",
"[email]",
"[telefoon]",
"ISW-E6D355EA-973A-4D66-A058-1FC9674DED5A(1)",
"Dazure",
"Levensverzekering",
"GewoonIdee Nabestaandenverzekering - Annuitair",
"Annuitair Dalende Risicoverzekeringen"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "145444",
"dossiernummer": "145444",
"dossierstatus": "Vervallen",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1132
{
"dossier_id": "9370bf61-e2bd-4aa1-b296-b60509b8d863",
"key": "base_import",
"value_json": {
"adres": "Horst 26 09",
"klant": "Bos, Thea (MC)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8225 PA",
"products": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "114400.00",
"status": "Lopend",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2015-02-16"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"95189",
"Bos, Thea (MC)",
"Horst 26 09",
"8225 PA",
"Lelystad",
"[telefoon]",
"*********",
"ING Bank",
"Hypotheek",
"ING Annuiteitenhypotheek (Reguliere hypotheek)",
"Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "95189",
"dossiernummer": "95189",
"dossierstatus": "Vervallen",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": ""
},
"updated_at": 1778230486535
}Rij 1133
{
"dossier_id": "9acff048-ed80-4b37-9dd8-a7ce04bf43c1",
"key": "base_import",
"value_json": {
"adres": "Sluiswachtershoeve 701",
"klant": "Flipse, Lia (C.C.), Koukolis (E.)",
"plaats": "Apeldoorn",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "7326 ZJ",
"products": [
{
"norm": "",
"type": "Consumptief krediet",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Interbank Persoonlijke Lening",
"tekendatum": "25569",
"productnaam": "Interbank Persoonlijke Lening",
"maatschappij": "InterBank NV",
"productsoort": "Persoonlijke lening",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2017-11-09"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"153872",
"Flipse, Lia (C.C.), Koukolis (E.)",
"Sluiswachtershoeve 701",
"7326 ZJ",
"Apeldoorn",
"[email]",
"*********",
"InterBank NV",
"Consumptief krediet",
"Interbank Persoonlijke Lening",
"Persoonlijke lening"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "153872",
"dossiernummer": "153872",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "",
"email_aanvrager": ""
},
"updated_at": 1778230486535
}Rij 1134
{
"dossier_id": "9acff048-ed80-4b37-9dd8-a7ce04bf43c1",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Flipse, Lia (C.C.)",
"adres": "Sluiswachtershoeve 701",
"postcode": "7326 ZJ",
"woonplaats": "Apeldoorn"
},
"a2": {
"naam": "Koukolis (E.)",
"adres": "Sluiswachtershoeve 701",
"email": "[email]",
"postcode": "7326 ZJ",
"woonplaats": "Apeldoorn"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Consumptief krediet",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Interbank Persoonlijke Lening",
"tekendatum": "25569",
"productnaam": "Interbank Persoonlijke Lening",
"maatschappij": "InterBank NV",
"productsoort": "Persoonlijke lening",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2017-11-09"
}
],
"crmdossier_id": "153872",
"dossiernummer": "153872",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1135
{
"dossier_id": "e5e995df-d6f6-4a9a-b6a3-40fc21a22c87",
"key": "base_import",
"value_json": {
"adres": "Jol 17 67",
"klant": "Komarov (M.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8243 GE",
"products": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "209899.00",
"status": "Gepasseerd",
"artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Bankspaar",
"factuurbedrag": "",
"offertenummer": "K 090-849518",
"passeeringangsdatum": "2010-10-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"100537",
"Komarov (M.)",
"Jol 17 67",
"8243 GE",
"Lelystad",
"06 - 19 85 70 41",
"K 090-849518",
"ING Bank",
"Hypotheek",
"ING Bankspaarhypotheek variant 1 (Reguliere hypotheek)",
"Bankspaar"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "100537",
"dossiernummer": "100537",
"dossierstatus": "Actief",
"email_partner": "",
"telefoonnummer": "06 - 19 85 70 41",
"email_aanvrager": ""
},
"updated_at": 1778230486535
}Rij 1136
{
"dossier_id": "e5e995df-d6f6-4a9a-b6a3-40fc21a22c87",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Komarov (M.)",
"adres": "Jol 17 67",
"postcode": "8243 GE",
"woonplaats": "Lelystad",
"telefoon_prive": "06 - 19 85 70 41"
},
"a2": {
"adres": "Jol 17 67",
"postcode": "8243 GE",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "209899.00",
"status": "Gepasseerd",
"artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Bankspaar",
"factuurbedrag": "",
"offertenummer": "K 090-849518",
"passeeringangsdatum": "2010-10-01"
}
],
"crmdossier_id": "100537",
"dossiernummer": "100537",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1137
{
"dossier_id": "e9b6143b-e266-4ccb-b4a7-3b97821ce9cf",
"key": "base_import",
"value_json": {
"adres": "Langezand 59",
"klant": "Broekhuis (E.J.F.), Kemmer (D.B.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8223 WE",
"products": [
{
"norm": "",
"type": "Consumptief krediet",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "DK",
"tekendatum": "25569",
"productnaam": "DK",
"maatschappij": "Voordeelbank B.V.",
"productsoort": "Doorlopend krediet",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2010-12-06"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"150656",
"Broekhuis (E.J.F.), Kemmer (D.B.)",
"Langezand 59",
"8223 WE",
"Lelystad",
"*********",
"Voordeelbank B.V.",
"Consumptief krediet",
"DK",
"Doorlopend krediet"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "150656",
"dossiernummer": "150656",
"dossierstatus": "Actief",
"email_partner": "",
"telefoonnummer": "",
"email_aanvrager": ""
},
"updated_at": 1778230486535
}Rij 1138
{
"dossier_id": "141924d5-75c4-48db-84d7-c84a2ae7fef0",
"key": "base_import",
"value_json": {
"adres": "van der Duyn van Maesdamstraat 17",
"klant": "Homan (L.), Yigitalp, Mehmet (M)",
"plaats": "Twello",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "7391 VH",
"products": [
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2018-07-24"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"173077",
"Homan (L.), Yigitalp, Mehmet (M)",
"van der Duyn van Maesdamstraat 17",
"7391 VH",
"Twello",
"[email]",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Hypotheekadvies"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "173077",
"dossiernummer": "173077",
"dossierstatus": "Vervallen",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1139
{
"dossier_id": "141924d5-75c4-48db-84d7-c84a2ae7fef0",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Homan (L.)",
"adres": "van der Duyn van Maesdamstraat 17",
"email": "[email]",
"postcode": "7391 VH",
"woonplaats": "Twello",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Yigitalp, Mehmet (M)",
"adres": "van der Duyn van Maesdamstraat 17",
"email": "[email]",
"postcode": "7391 VH",
"woonplaats": "Twello"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2018-07-24"
}
],
"crmdossier_id": "173077",
"dossiernummer": "173077",
"dossierstatus": "Vervallen",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1140
{
"dossier_id": "1ec6af73-7121-4896-a89a-fb833f988e55",
"key": "base_import",
"value_json": {
"adres": "Sowetostraat 10",
"klant": "Zijlstra, Carmen (CT), Zijlstra, Roy (R)",
"plaats": "HAARLEM",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "2033 CV",
"products": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "55198.00",
"status": "Hypotheekaanbod aan klant verzonden",
"artikel": "Lloyds Annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Lloyds Annuiteitenhypotheek",
"maatschappij": "Lloyds Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "1896623",
"passeeringangsdatum": "2025-03-28"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2018-01-31"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "242269.00",
"status": "Gepasseerd",
"artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"maatschappij": "Lloyds Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "1.664.103",
"passeeringangsdatum": "2018-03-29"
},
{
"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": "2615631",
"passeeringangsdatum": "2018-03-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 4,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"163549",
"Zijlstra, Carmen (CT), Zijlstra, Roy (R)",
"Sowetostraat 10",
"2033 CV",
"HAARLEM",
"[email]",
"[email]",
"[telefoon]",
"1896623",
"Lloyds Bank",
"Hypotheek",
"Lloyds Annuiteitenhypotheek",
"Annuitair",
"Eigen kantoor",
"Hypotheekadvies",
"1.664.103",
"Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"2615631",
"TAF",
"Levensverzekering",
"Credit Life International Overlijdensrisicoverzekering - Annuitair",
"Overlijdensrisicoverzekering"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "163549",
"dossiernummer": "163549",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1141
{
"dossier_id": "1ec6af73-7121-4896-a89a-fb833f988e55",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Zijlstra, Carmen (CT)",
"adres": "Sowetostraat 10",
"email": "[email]",
"postcode": "2033 CV",
"woonplaats": "HAARLEM",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Zijlstra, Roy (R)",
"adres": "Sowetostraat 10",
"email": "[email]",
"postcode": "2033 CV",
"woonplaats": "HAARLEM"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "55198.00",
"status": "Hypotheekaanbod aan klant verzonden",
"artikel": "Lloyds Annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Lloyds Annuiteitenhypotheek",
"maatschappij": "Lloyds Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "1896623",
"passeeringangsdatum": "2025-03-28"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2018-01-31"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "242269.00",
"status": "Gepasseerd",
"artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"maatschappij": "Lloyds Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "1.664.103",
"passeeringangsdatum": "2018-03-29"
},
{
"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": "2615631",
"passeeringangsdatum": "2018-03-01"
}
],
"crmdossier_id": "163549",
"dossiernummer": "163549",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1142
{
"dossier_id": "0921674e-ee46-4c59-8453-52511f1ac818",
"key": "base_import",
"value_json": {
"adres": "Biesbosstraat 90",
"klant": "Patricio, J (JB)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8226 ED",
"products": [
{
"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": "2298118",
"passeeringangsdatum": "2016-09-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "166570.00",
"status": "Gepasseerd",
"artikel": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)",
"tekendatum": "25569",
"productnaam": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)",
"maatschappij": "Rabobank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "28226605",
"passeeringangsdatum": "2018-04-10"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2017-12-06"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "TAF Woonlasten beschermer",
"tekendatum": "25569",
"productnaam": "TAF Woonlasten beschermer",
"maatschappij": "TAF",
"productsoort": "Woonlastenverzekering",
"factuurbedrag": "",
"offertenummer": "40024906",
"passeeringangsdatum": "2018-03-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 4,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"161070",
"Patricio, J (JB)",
"Biesbosstraat 90",
"8226 ED",
"Lelystad",
"[email]",
"[telefoon]",
"2298118",
"TAF",
"Levensverzekering",
"TAF Personal Overlijdensrisicoverzekering Chubb Life - annuitair",
"Overlijdensrisicoverzekering",
"28226605",
"Rabobank",
"Hypotheek",
"Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)",
"Annuitair",
"Eigen kantoor",
"Hypotheekadvies",
"40024906",
"Inkomensverzekering",
"TAF Woonlasten beschermer",
"Woonlastenverzekering"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "161070",
"dossiernummer": "161070",
"dossierstatus": "Actief",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1143
{
"dossier_id": "0921674e-ee46-4c59-8453-52511f1ac818",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Patricio, J (JB)",
"adres": "Biesbosstraat 90",
"email": "[email]",
"postcode": "8226 ED",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Biesbosstraat 90",
"postcode": "8226 ED",
"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": "2298118",
"passeeringangsdatum": "2016-09-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "166570.00",
"status": "Gepasseerd",
"artikel": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)",
"tekendatum": "25569",
"productnaam": "Annuiteiten Hypotheek (Rabo Basishypotheek), Annuiteiten Hypotheek (Rabo Basishypotheek)",
"maatschappij": "Rabobank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "28226605",
"passeeringangsdatum": "2018-04-10"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2017-12-06"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "TAF Woonlasten beschermer",
"tekendatum": "25569",
"productnaam": "TAF Woonlasten beschermer",
"maatschappij": "TAF",
"productsoort": "Woonlastenverzekering",
"factuurbedrag": "",
"offertenummer": "40024906",
"passeeringangsdatum": "2018-03-01"
}
],
"crmdossier_id": "161070",
"dossiernummer": "161070",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1144
{
"dossier_id": "c5487cfc-5d09-4396-962a-84c807e83447",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Santing, Martijn (M)",
"adres": "Schieveen 41",
"email": "[email]",
"postcode": "8219 CH",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Schieveen 41",
"postcode": "8219 CH",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "226803.00",
"status": "Offerte/renteaanbod ontvangen",
"artikel": "Clarian Wonen Annuitair, Clarian Wonen Aflossingsvrij, Clarian Wonen Annuitair, Clarian Wonen Aflossingsvrij",
"tekendatum": "25569",
"productnaam": "Clarian Wonen Annuitair, Clarian Wonen Aflossingsvrij, Clarian Wonen Annuitair, Clarian Wonen Aflossingsvrij",
"maatschappij": "Clarian Wonen",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "3568679",
"passeeringangsdatum": "2025-09-01"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "240437.00",
"status": "Lopend",
"artikel": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Merius aflossingsvrije hypotheek, Merius annuiteitenhypotheek",
"maatschappij": "Merius Hypotheken",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "3008045",
"passeeringangsdatum": "2018-11-22"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2018-08-02"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "243480.00",
"status": "Lopend",
"artikel": "Clarian Wonen Aflossingsvrij, Clarian Wonen Annuitair",
"tekendatum": "25569",
"productnaam": "Clarian Wonen Aflossingsvrij, Clarian Wonen Annuitair",
"maatschappij": "Clarian Wonen",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "3281972-01",
"passeeringangsdatum": "2021-10-01"
}
],
"crmdossier_id": "160956",
"dossiernummer": "160956",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1145
{
"dossier_id": "3126a04b-27e5-453b-abd0-2d401ad74c34",
"key": "base_import",
"value_json": {
"adres": "Archipel 15 45",
"klant": "Apeldoorn, Jan (JA)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8224 GD",
"products": [
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Overlijdensrisicoverzekering",
"tekendatum": "25569",
"productnaam": "Overlijdensrisicoverzekering",
"maatschappij": "Argenta hypotheken",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "[telefoon]-18",
"passeeringangsdatum": "2018-02-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2017-11-21"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "196950.00",
"status": "Gepasseerd",
"artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Aflossingsvrij (Argenta Special Line Hypotheek)",
"tekendatum": "25569",
"productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Aflossingsvrij (Argenta Special Line Hypotheek)",
"maatschappij": "Argenta hypotheken",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "3046578",
"passeeringangsdatum": "2018-01-15"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 3,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"160393",
"Apeldoorn, Jan (JA)",
"Archipel 15 45",
"8224 GD",
"Lelystad",
"[email]",
"[telefoon]",
"[telefoon]-18",
"Argenta hypotheken",
"Levensverzekering",
"Overlijdensrisicoverzekering",
"Annuitair Dalende Risicoverzekeringen",
"Eigen kantoor",
"Hypotheekadvies",
"3046578",
"Hypotheek",
"Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Aflossingsvrij (Argenta Special Line Hypotheek)",
"Aflossingsvrij, Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "160393",
"dossiernummer": "160393",
"dossierstatus": "Actief",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1146
{
"dossier_id": "7cab7326-17a1-4b69-a661-b8d7088a680b",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Pruim, Jaap (J.A.)",
"adres": "Majoraan 64",
"email": "[email]",
"postcode": "8252 BB",
"woonplaats": "Dronten",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Stoop, Lotte (L.L.)",
"adres": "Majoraan 64",
"postcode": "8252 BB",
"woonplaats": "Dronten"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Beeindigd",
"artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
"tekendatum": "25569",
"productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "GEWI.607002",
"passeeringangsdatum": "2015-06-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "182500.00",
"status": "Gepasseerd",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2016-11-28"
}
],
"crmdossier_id": "103725",
"dossiernummer": "103725",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1147
{
"dossier_id": "7cab7326-17a1-4b69-a661-b8d7088a680b",
"key": "base_import",
"value_json": {
"adres": "Majoraan 64",
"klant": "Pruim, Jaap (J.A.), Stoop, Lotte (L.L.)",
"plaats": "Dronten",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8252 BB",
"products": [
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Beeindigd",
"artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
"tekendatum": "25569",
"productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "GEWI.607002",
"passeeringangsdatum": "2015-06-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "182500.00",
"status": "Gepasseerd",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2016-11-28"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 2,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"103725",
"Pruim, Jaap (J.A.), Stoop, Lotte (L.L.)",
"Majoraan 64",
"8252 BB",
"Dronten",
"[email]",
"[telefoon]",
"GEWI.607002",
"Dazure",
"Levensverzekering",
"GewoonIdee Nabestaandenverzekering - Annuitair",
"Annuitair Dalende Risicoverzekeringen",
"*********",
"ING Bank",
"Hypotheek",
"ING Annuiteitenhypotheek (Reguliere hypotheek)",
"Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "103725",
"dossiernummer": "103725",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1148
{
"dossier_id": "9284d523-95cb-4791-ae51-493ed0a75f51",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Abadi (M.)",
"adres": "Botter 11 02",
"email": "[email]",
"postcode": "8232 JL",
"woonplaats": "Lelystad",
"telefoon_prive": "06 - 81 63 40 37"
},
"a2": {
"adres": "Botter 11 02",
"postcode": "8232 JL",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "156847.00",
"status": "Gepasseerd",
"artikel": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Bankspaarhypotheek variant 1 (Reguliere hypotheek), ING Aflossingsvrije Hypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Aflossingsvrij, Bankspaar",
"factuurbedrag": "",
"offertenummer": "Z 090-859858",
"passeeringangsdatum": "2010-10-25"
}
],
"crmdossier_id": "100639",
"dossiernummer": "100639",
"dossierstatus": "Vervallen",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1149
{
"dossier_id": "3126a04b-27e5-453b-abd0-2d401ad74c34",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Apeldoorn, Jan (JA)",
"adres": "Archipel 15 45",
"email": "[email]",
"postcode": "8224 GD",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Archipel 15 45",
"postcode": "8224 GD",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Overlijdensrisicoverzekering",
"tekendatum": "25569",
"productnaam": "Overlijdensrisicoverzekering",
"maatschappij": "Argenta hypotheken",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "[telefoon]-18",
"passeeringangsdatum": "2018-02-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2017-11-21"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "196950.00",
"status": "Gepasseerd",
"artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Aflossingsvrij (Argenta Special Line Hypotheek)",
"tekendatum": "25569",
"productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Aflossingsvrij (Argenta Special Line Hypotheek)",
"maatschappij": "Argenta hypotheken",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "3046578",
"passeeringangsdatum": "2018-01-15"
}
],
"crmdossier_id": "160393",
"dossiernummer": "160393",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1150
{
"dossier_id": "d06b3bcf-43f9-4577-985f-6781e3bba4bd",
"key": "base_import",
"value_json": {
"adres": "J. Kammingastraat 115",
"klant": "Schelling, Anoushka (A.S.), Schelling, Zobraakanya (ZIS)",
"plaats": "Wildervank",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "9648 KL",
"products": [
{
"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": "2605308",
"passeeringangsdatum": "2018-01-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2017-12-19"
},
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "Woonhuisverzekering, Aansprakelijkheidsverzekering Particulieren",
"tekendatum": "25569",
"productnaam": "Woonhuisverzekering, Aansprakelijkheidsverzekering Particulieren",
"maatschappij": "Voogd & Voogd",
"productsoort": "Aansprakelijkheid, Opstal",
"factuurbedrag": "",
"offertenummer": "168336115385",
"passeeringangsdatum": "2018-03-16"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "103000.00",
"status": "Gepasseerd",
"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": "700.442.933",
"passeeringangsdatum": "2018-03-16"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 4,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"161283",
"Schelling, Anoushka (A.S.), Schelling, Zobraakanya (ZIS)",
"J. Kammingastraat 115",
"9648 KL",
"Wildervank",
"[email]",
"[telefoon]",
"2605308",
"TAF",
"Levensverzekering",
"Credit Life International Overlijdensrisicoverzekering - Annuitair",
"Overlijdensrisicoverzekering",
"Eigen kantoor",
"Hypotheekadvies",
"168336115385",
"Voogd & Voogd",
"Schadeverzekering",
"Woonhuisverzekering, Aansprakelijkheidsverzekering Particulieren",
"Aansprakelijkheid, Opstal",
"700.442.933",
"ABN AMRO",
"Hypotheek",
"ABN AMRO Annuïteiten hypotheek (ABN AMRO Budget Hypotheek)",
"Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "161283",
"dossiernummer": "161283",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}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) |