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/stores300.289 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 1850| dossier_id | key | value_json | updated_at |
|---|---|---|---|
| e4ceb87e-471f-4b5a-8e8a-1f9d2d35f7d1 | inventarisatie | { "a1": { "naam": "Hol, Marianne", "adres": "Aaf Bouberstraat 4", "email": "[email]", "postcode": "1065 LS", "woonplaats": "Amsterdam", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Aaf Bouberstraat 4", "postcode": "1065 LS", "woonplaats": "Amsterdam" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-08-25", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-08-25" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "325000.00", "status": "Lopend", "artikel": "Obvion Woon Hypotheek Annuitair", "tekendatum": "25569", "productnaam": "Obvion Woon Hypotheek Annuitair", "maatschappij": "Obvion", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "635689", "passeeringangsdatum": "2021-01-11" } ], ... [afgekapt: 106 tekens] | 1778230486535 |
| e4ceb87e-471f-4b5a-8e8a-1f9d2d35f7d1 | base_import | { "adres": "Aaf Bouberstraat 4", "klant": "Hol, Marianne", "plaats": "Amsterdam", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "1065 LS", "products": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-08-25", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-08-25" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "325000.00", "status": "Lopend", "artikel": "Obvion Woon Hypotheek Annuitair", "tekendatum": "25569", "productnaam": "Obvion Woon Hypotheek Annuitair", "maatschappij": "Obvion", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "635689", "passeeringangsdatum": "2021-01-11" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "221963", "Hol, Marianne", "Aaf Bouberstraat 4", "1065 LS", "Amsterdam", "[email]", "[telefoon]", "Eigen kantoor", ... [afgekapt: 457 tekens] | 1778230486535 |
| 601e6871-7671-43cf-b85e-0a7f28ad2720 | inventarisatie | { "a1": { "naam": "Touqan, Abdallah (AT)", "adres": "Jacques Veltmanstraat 39", "email": "[email]", "postcode": "1065 EG", "woonplaats": "AMSTERDAM", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Jacques Veltmanstraat 39", "postcode": "1065 EG", "woonplaats": "AMSTERDAM" }, "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": "2020-12-23" }, { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Inboedelverzekering, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Inboedel", "tekendatum": "25569", "productnaam": "Inboedelverzekering, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Inboedel", "maatschappij": "Risk Assuradeuren", "productsoort": "Aansprakelijkheid, Inboedel, Rechtsbijstand, Reis en annulerin ... [afgekapt: 1990 tekens] | 1778230486535 |
| b2fff362-28e9-474e-9b68-1146c9374631 | inventarisatie | { "a1": { "naam": "Dabrowska, Marta (MM)", "adres": "Beemster 10", "email": "[email]", "postcode": "8244 CA", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Urbanksi, Marek (M)", "adres": "Beemster 10", "email": "[email]", "postcode": "8244 CA", "woonplaats": "Lelystad" }, "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": "2020-05-19" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "163142.00", "status": "Lopend", "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "tekendatum": "25569", "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "31 ... [afgekapt: 177 tekens] | 1778230486535 |
| b2fff362-28e9-474e-9b68-1146c9374631 | base_import | { "adres": "Beemster 10", "klant": "Dabrowska, Marta (MM), Urbanksi, Marek (M)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8244 CA", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-05-19" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "163142.00", "status": "Lopend", "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "tekendatum": "25569", "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3190802-01", "passeeringangsdatum": "2020-07-01" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "212274", "Dabrowska, Marta (MM), Urbanksi, Marek (M)", "Beemster 10", "8244 CA", "Lelyst ... [afgekapt: 543 tekens] | 1778230486535 |
| c9723cec-4644-4e4f-af2b-313b14b8b856 | inventarisatie | { "a1": { "naam": "Dijk, Danielle van (DM)", "adres": "De Oeverloper 451", "email": "[email]", "postcode": "8251 HS", "woonplaats": "Dronten", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Dijk, Olaf van (O.F.J.)", "adres": "De Oeverloper 451", "email": "[email]", "postcode": "8251 HS", "woonplaats": "Dronten" }, "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": "2020-04-21" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "240000.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschapp ... [afgekapt: 287 tekens] | 1778230486535 |
| c9723cec-4644-4e4f-af2b-313b14b8b856 | base_import | { "adres": "De Oeverloper 451", "klant": "Dijk, Danielle van (DM), Dijk, Olaf van (O.F.J.)", "plaats": "Dronten", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8251 HS", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-04-21" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "240000.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2020-08-10" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ ... [afgekapt: 705 tekens] | 1778230486535 |
| 30fc24b1-abc3-4bad-a892-51fa5cbfad01 | inventarisatie | { "a1": { "naam": "Bioniarz, Gabriela Barbara (G)", "adres": "Gentenerf 10", "email": "[email]", "postcode": "3852 LX", "woonplaats": "Ermelo", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Gentenerf 10", "postcode": "3852 LX", "woonplaats": "Ermelo" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "TAF Woonlasten beschermer", "tekendatum": "25569", "productnaam": "TAF Woonlasten beschermer", "maatschappij": "TAF", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "ISW-3A9DFBD7-73D1-4AEC-9110-7BD3EF138367|1015(1)", "passeeringangsdatum": "2020-10-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Inkomensbeschermer", "tekendatum": "25569", "productnaam": "Inkomensbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-571E896E-DCF2-407A-AD95-BDD7C366D626|1015(1)", "passeeringangs ... [afgekapt: 2169 tekens] | 1778230486535 |
| 30fc24b1-abc3-4bad-a892-51fa5cbfad01 | base_import | { "adres": "Gentenerf 10", "klant": "Bioniarz, Gabriela Barbara (G)", "plaats": "Ermelo", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "3852 LX", "products": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "TAF Woonlasten beschermer", "tekendatum": "25569", "productnaam": "TAF Woonlasten beschermer", "maatschappij": "TAF", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "ISW-3A9DFBD7-73D1-4AEC-9110-7BD3EF138367|1015(1)", "passeeringangsdatum": "2020-10-01" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Inkomensbeschermer", "tekendatum": "25569", "productnaam": "Inkomensbeschermer", "maatschappij": "TAF", "productsoort": "Arbeidsongeschiktheidsverzekering", "factuurbedrag": "", "offertenummer": "ISW-571E896E-DCF2-407A-AD95-BDD7C366D626|1015(1)", "passeeringangsdatum": "2020-10-01" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Scherp & Slim ORV annuïtair dalend", "tekendatum": "25569", "productnaam": "Scherp ... [afgekapt: 3080 tekens] | 1778230486535 |
| 93210e0e-4e20-4e82-8c44-97c044d58598 | inventarisatie | { "a1": { "naam": "Gyebi, Nigel (NNA)", "adres": "Bouwen Ewoutstraat 35", "email": "[email]", "postcode": "4381 PP", "woonplaats": "Vlissingen", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Bouwen Ewoutstraat 35", "postcode": "4381 PP", "woonplaats": "Vlissingen" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "147500.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2021-01-18" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-09-17" } ], "crmdossier_id": "222986", "dossiernummer": "222986", ... [afgekapt: 41 tekens] | 1778230486535 |
| 93210e0e-4e20-4e82-8c44-97c044d58598 | base_import | { "adres": "Bouwen Ewoutstraat 35", "klant": "Gyebi, Nigel (NNA)", "plaats": "Vlissingen", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "4381 PP", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "147500.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2021-01-18" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-09-17" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "222986", "Gyebi, Nigel (NNA)", "Bouwen Ewoutstraat 35", "4381 PP", "Vlissingen", "[email]", "[telefoon]", "*********", "ING Bank", "Hypotheek", "ING Annuiteitenhypotheek (Reg ... [afgekapt: 349 tekens] | 1778230486535 |
| fe467b1b-4567-4add-8487-22c9e3f97e13 | inventarisatie | { "a1": { "naam": "Broek, Lisa van den (LWS)", "adres": "P.C. Hooftplein 29", "email": "[email]", "postcode": "3842 HC", "woonplaats": "Harderwijk", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "P.C. Hooftplein 29", "postcode": "3842 HC", "woonplaats": "Harderwijk" }, "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": "2021-11-02" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "175600.00", "status": "Lopend", "artikel": "Hypotrust Comfort Annuiteit (Hypotrust Standaard)", "tekendatum": "25569", "productnaam": "Hypotrust Comfort Annuiteit (Hypotrust Standaard)", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3196406-01", "passeeringangsdatum": "2020-07-30" }, { "norm": "", "type": "Inkomensver ... [afgekapt: 544 tekens] | 1778230486535 |
| 444a8ad7-21a2-44f5-a241-fb61c4454f50 | inventarisatie | { "a1": { "naam": "Wilpen, Berendina van (B)", "adres": "Hofstede 51", "email": "[email]", "postcode": "8212 WD", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Wilpen, John van (J)", "adres": "Hofstede 51", "postcode": "8212 WD", "woonplaats": "Lelystad" }, "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": "2020-10-27" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "212590.00", "status": "Lopend", "artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek", "tekendatum": "25569", "productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek", "maatschappij": "IQWOON", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3220087-01", ... [afgekapt: 163 tekens] | 1778230486535 |
| 10b2c088-2130-49cd-ad7c-5a36b134e1b4 | base_import | { "adres": "Kempenaar 01 16", "klant": "Kalloe (S.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 BA", "products": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-12", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "213447", "Kalloe (S.)", "Kempenaar 01 16", "8242 BA", "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": "213447", "dossiernummer": "213447", "dossierstatus": "Vervallen", "email_partner": "", "telefoonnummer": "[telefoon]", "email_aanvrager": "[email]" } | 1778230486535 |
| 1d24720c-9b97-49c9-b0d8-0073a147115c | inventarisatie | { "a1": { "naam": "Kooiman, Gemma (G.)", "adres": "Jol 18 16", "email": "[email]", "postcode": "8243 GG", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Jol 18 16", "postcode": "8243 GG", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-12", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" } ], "crmdossier_id": "213438", "dossiernummer": "213438", "dossierstatus": "Vervallen", ... [afgekapt: 11 tekens] | 1778230486535 |
| 1d24720c-9b97-49c9-b0d8-0073a147115c | base_import | { "adres": "Jol 18 16", "klant": "Kooiman, Gemma (G.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 GG", "products": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-12", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "213438", "Kooiman, Gemma (G.)", "Jol 18 16", "8243 GG", "Lelystad", "[email]", "[telefoon]", "Eigen kantoor", "Dienst", "Advies nieuwe Hypotheek/Doorstromer", "Dienst BTW vrij", "Hypotheeka ... [afgekapt: 279 tekens] | 1778230486535 |
| c930b574-88c3-4631-8b83-b23f579b8753 | inventarisatie | { "a1": { "naam": "Habekotte, Melissa (M)", "adres": "Tijm 14", "email": "[email]", "postcode": "8252 CP", "woonplaats": "Dronten", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Rolleman, Thijs (T.S.K.)", "adres": "Tijm 14", "email": "[email]", "postcode": "8252 CP", "woonplaats": "Dronten" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "175291.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2020-11-22" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "175291.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Regu ... [afgekapt: 3025 tekens] | 1778230486535 |
| c930b574-88c3-4631-8b83-b23f579b8753 | base_import | { "adres": "Tijm 14", "klant": "Habekotte, Melissa (M), Rolleman, Thijs (T.S.K.)", "plaats": "Dronten", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8252 CP", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "175291.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2020-11-22" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "175291.00", "status": "Lopend", "artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "tekendatum": "25569", "productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)", "maatschappij": "ING Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "*********", "passeeringangsdatum": "2020-11-22" }, { "norm": "", ... [afgekapt: 3480 tekens] | 1778230486535 |
| f235c68d-5854-465b-9477-058cd70d172c | base_import | { "adres": "Oostzeestraat 113", "klant": "Jankowski (J.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8226 BH", "products": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Offerte/renteaanbod ontvangen", "artikel": "Cardif Aflos Verzekering", "tekendatum": "25569", "productnaam": "Cardif Aflos Verzekering", "maatschappij": "Cardif", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "HAV00150650", "passeeringangsdatum": "2019-11-01" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Scherp & Slim ORV annuïtair dalend", "tekendatum": "25569", "productnaam": "Scherp & Slim ORV annuïtair dalend", "maatschappij": "Hera Life", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "HL0061798", "passeeringangsdatum": "2019-11-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "produc ... [afgekapt: 2654 tekens] | 1778230486535 |
| b075d90a-53d2-407a-80a9-89f1ae8fec96 | inventarisatie | { "a1": { "naam": "Raven, Jacqueline (J.M.C.)", "adres": "Zeepkruidstraat 131", "email": "[email]", "postcode": "8245 LH", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Reekers, Frans (F.M.)", "adres": "Zeepkruidstraat 131", "postcode": "8245 LH", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "500000.00", "status": "Lopend", "artikel": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair", "tekendatum": "25569", "productnaam": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair", "maatschappij": "Woonnu", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3216244-01", "passeeringangsdatum": "2020-11-23" }, { "norm": "", "type": "Consumptief krediet", "inhoud": "0.00", "status": "Lopend", "artikel": "Doorlopend krediet", "tekendatum": "25569", "productnaam": "Doorlopend krediet", "maatschappij": "Nationale-Nederlanden Leven", "productsoort": "Doorlopend ... [afgekapt: 1146 tekens] | 1778230486535 |
| b075d90a-53d2-407a-80a9-89f1ae8fec96 | base_import | { "adres": "Zeepkruidstraat 131", "klant": "Raven, Jacqueline (J.M.C.), Reekers, Frans (F.M.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8245 LH", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "500000.00", "status": "Lopend", "artikel": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair", "tekendatum": "25569", "productnaam": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair", "maatschappij": "Woonnu", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "3216244-01", "passeeringangsdatum": "2020-11-23" }, { "norm": "", "type": "Consumptief krediet", "inhoud": "0.00", "status": "Lopend", "artikel": "Doorlopend krediet", "tekendatum": "25569", "productnaam": "Doorlopend krediet", "maatschappij": "Nationale-Nederlanden Leven", "productsoort": "Doorlopend krediet", "factuurbedrag": "", "offertenummer": "2000121909", "passeeringangsdatum": "2015-11-17" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekenda ... [afgekapt: 1736 tekens] | 1778230486535 |
| 7065b590-ff03-4134-b2f2-40610817b5b7 | inventarisatie | { "a1": { "naam": "Honing, Raymon (R)", "adres": "Bergumermeerstraat 1", "email": "[email]", "postcode": "8226 JK", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Kist, Mariska (MA)", "adres": "Bergumermeerstraat 1", "postcode": "8226 JK", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "334325.00", "status": "Lopend", "artikel": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair", "tekendatum": "25569", "productnaam": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair", "maatschappij": "Centraal Beheer", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3298974-01", "passeeringangsdatum": "2022-01-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", ... [afgekapt: 253 tekens] | 1778230486535 |
| 7065b590-ff03-4134-b2f2-40610817b5b7 | base_import | { "adres": "Bergumermeerstraat 1", "klant": "Honing, Raymon (R), Kist, Mariska (MA)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8226 JK", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "334325.00", "status": "Lopend", "artikel": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair", "tekendatum": "25569", "productnaam": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair", "maatschappij": "Centraal Beheer", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3298974-01", "passeeringangsdatum": "2022-01-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-05-12" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "211912", ... [afgekapt: 664 tekens] | 1778230486535 |
| f235c68d-5854-465b-9477-058cd70d172c | inventarisatie | { "a1": { "naam": "Jankowski (J.)", "adres": "Oostzeestraat 113", "email": "[email]", "postcode": "8226 BH", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Oostzeestraat 113", "postcode": "8226 BH", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Offerte/renteaanbod ontvangen", "artikel": "Cardif Aflos Verzekering", "tekendatum": "25569", "productnaam": "Cardif Aflos Verzekering", "maatschappij": "Cardif", "productsoort": "Woonlastenverzekering", "factuurbedrag": "", "offertenummer": "HAV00150650", "passeeringangsdatum": "2019-11-01" }, { "norm": "", "type": "Levensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Scherp & Slim ORV annuïtair dalend", "tekendatum": "25569", "productnaam": "Scherp & Slim ORV annuïtair dalend", "maatschappij": "Hera Life", "productsoort": "Annuitair Dalende Risicoverzekeringen", "factuurbedrag": "", "offertenummer": "HL0061798", "passeeringangsdatum": "2019- ... [afgekapt: 1819 tekens] | 1778230486535 |
| e8442c1c-3339-4419-8a50-fc3ae4180fcf | inventarisatie | { "a1": { "naam": "Verhoef (C.W.E.)", "adres": "Punter 41 41", "email": "[email]", "postcode": "8242 GC", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Punter 41 41", "postcode": "8242 GC", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-06-23", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-23" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-23" } ], "crmdossier_id": "214031", "dossiernummer": "214031", "dossierstatus": "Verv ... [afgekapt: 22 tekens] | 1778230486535 |
| e8442c1c-3339-4419-8a50-fc3ae4180fcf | base_import | { "adres": "Punter 41 41", "klant": "Verhoef (C.W.E.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 GC", "products": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-06-23", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-23" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-23" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "214031", "Verhoef (C.W.E.)", "Punter 41 41", "8242 GC", "Lelystad", "[email]", "[telefoon]", "Eigen kantoor", "Dienst", "Advies nieuwe hypotheek starter/Aankoop", "Dienst BTW vrij", ... [afgekapt: 291 tekens] | 1778230486535 |
| 5ed6688b-c9da-4a4e-8248-bd1b1f6ffc9e | inventarisatie | { "a1": { "naam": "Duztas, Cemil (C.)", "adres": "Lagune 29", "email": "[email]", "postcode": "8224 CR", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Lagune 29", "postcode": "8224 CR", "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": "2020-06-22" }, { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-22", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-22" } ], "crmdossier_id": "213931", "dossiernummer": "213931", "dossierstatus": "Vervallen", ... [afgekapt: 10 tekens] | 1778230486535 |
| 5ed6688b-c9da-4a4e-8248-bd1b1f6ffc9e | base_import | { "adres": "Lagune 29", "klant": "Duztas, Cemil (C.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8224 CR", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-22" }, { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-22", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-22" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "213931", "Duztas, Cemil (C.)", "Lagune 29", "8224 CR", "Lelystad", "[email]", "[telefoon]", "Eigen kantoor", "Hypotheekadvies", "Dienst", "Advies nieuwe Hypotheek/Doorstromer", "Dienst BTW v ... [afgekapt: 277 tekens] | 1778230486535 |
| ec738fcd-419c-40e4-8c8e-de96b50d4b4b | inventarisatie | { "a1": { "naam": "Eijk, Melvin van (M.J.)", "adres": "Karveel 59 82", "email": "[email]", "postcode": "8242 WG", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Grondhuis (A)", "adres": "Karveel 59 82", "postcode": "8242 WG", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "16066.00", "status": "Lopend", "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "tekendatum": "25569", "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "maatschappij": "Centraal Beheer", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3172756-01", "passeeringangsdatum": "2022-07-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "229790.00", "status": "Lopend", "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "tekendatum": "25569", "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "maatschappij": ... [afgekapt: 1182 tekens] | 1778230486535 |
| ec738fcd-419c-40e4-8c8e-de96b50d4b4b | base_import | { "adres": "Karveel 59 82", "klant": "Eijk, Melvin van (M.J.), Grondhuis (A)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 WG", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "16066.00", "status": "Lopend", "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "tekendatum": "25569", "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "maatschappij": "Centraal Beheer", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3172756-01", "passeeringangsdatum": "2022-07-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "229790.00", "status": "Lopend", "artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "tekendatum": "25569", "productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)", "maatschappij": "Centraal Beheer", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3172756-01", "passeeringangsdatum": "2020-08-03" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "sta ... [afgekapt: 1723 tekens] | 1778230486535 |
| 479d116b-3b72-40a3-bb24-0ae34626cc9e | inventarisatie | { "a1": { "naam": "Marciniec , Piotr Antoni (PA)", "adres": "Schoener 45 9", "email": "[email]", "postcode": "8243 XG", "woonplaats": "Lelystad", "telefoon_prive": "*********" }, "a2": { "adres": "Schoener 45 9", "email": "[email]", "postcode": "8243 XG", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren", "tekendatum": "25569", "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren", "maatschappij": "Voogd & Voogd", "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand", "factuurbedrag": "", "offertenummer": "156722505385", "passeeringangsdatum": "2017-05-10" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "214380.00", "status": "Lopend", "artikel": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek", "tek ... [afgekapt: 2466 tekens] | 1778230486535 |
| 479d116b-3b72-40a3-bb24-0ae34626cc9e | base_import | { "adres": "Schoener 45 9", "klant": "Marciniec , Piotr Antoni (PA)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 XG", "products": [ { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren", "tekendatum": "25569", "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren", "maatschappij": "Voogd & Voogd", "productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand", "factuurbedrag": "", "offertenummer": "156722505385", "passeeringangsdatum": "2017-05-10" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "214380.00", "status": "Lopend", "artikel": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek", "tekendatum": "25569", "productnaam": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek", "maatschappij": "IQWOON", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3202655-01", ... [afgekapt: 3230 tekens] | 1778230486535 |
| 8c825e61-048c-4ca0-9b90-994b36c01bed | inventarisatie | { "a1": { "naam": "Weverling, Leslie (LG)", "adres": "Woudlaar 71", "email": "[email]", "postcode": "1359 KM", "woonplaats": "Almere", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Weverling-Gerezgiher, H (HK)", "adres": "Woudlaar 71", "postcode": "1359 KM", "woonplaats": "Almere" }, "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-05" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-04-24" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "253703.00", "status": "Lopend", "artikel": "Argenta ... [afgekapt: 1721 tekens] | 1778230486535 |
| 8c825e61-048c-4ca0-9b90-994b36c01bed | base_import | { "adres": "Woudlaar 71", "klant": "Weverling, Leslie (LG), Weverling-Gerezgiher, H (HK)", "plaats": "Almere", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "1359 KM", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2018-07-05" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-04-24" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "253703.00", "status": "Lopend", "artikel": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)", "tekendatum": "25569", "productnaam": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annui ... [afgekapt: 2336 tekens] | 1778230486535 |
| 656d3981-42a3-479f-ac53-179afc987d57 | inventarisatie | { "a1": { "naam": "Mahabier (P.)", "adres": "Botter 36 44", "email": "[email]", "postcode": "8243 KT", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Sewberath Misser (A.G.)", "adres": "Botter 36 44", "email": "[email]", "postcode": "8243 KT", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "325000.00", "status": "Lopend", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "2095590", "passeeringangsdatum": "2022-10-07" } ], "crmdossier_id": "251779", "dossiernummer": "251779", "dossierstatus": "Actief", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| 656d3981-42a3-479f-ac53-179afc987d57 | base_import | { "adres": "Botter 36 44", "klant": "Mahabier (P.), Sewberath Misser (A.G.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8243 KT", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "325000.00", "status": "Lopend", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "2095590", "passeeringangsdatum": "2022-10-07" } ], "deelnemer": "Uw Hypotheek", "row_count": 1, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "251779", "Mahabier (P.), Sewberath Misser (A.G.)", "Botter 36 44", "8243 KT", "Lelystad", "[email]", "[email]", "[telefoon]", "2095590", "Lloyds Bank", "Hypotheek", "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "Annuitair" ], "source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx", "crmdossier_id": "251779", " ... [afgekapt: 113 tekens] | 1778230486535 |
| 32c01726-52ab-4a79-8222-57b5b67ff66f | inventarisatie | { "a1": { "naam": "Driouech, Anouar", "adres": "Zilverschoonlaan 203", "email": "[email]", "postcode": "8245 KE", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Zilverschoonlaan 203", "postcode": "8245 KE", "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": "2020-07-06" }, { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-07-06", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-07-06" } ], "crmdossier_id": "214619", "dossiernummer": "214619", "dossi ... [afgekapt: 38 tekens] | 1778230486535 |
| 32c01726-52ab-4a79-8222-57b5b67ff66f | base_import | { "adres": "Zilverschoonlaan 203", "klant": "Driouech, Anouar", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8245 KE", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-07-06" }, { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe hypotheek starter/Aankoop", "tekendatum": "2020-07-06", "productnaam": "Advies nieuwe hypotheek starter/Aankoop", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-07-06" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "214619", "Driouech, Anouar", "Zilverschoonlaan 203", "8245 KE", "Lelystad", "[email]", "[telefoon]", "Eigen kantoor", "Hypotheekadvies", "Dienst", "Advies nieuwe hypotheek start ... [afgekapt: 307 tekens] | 1778230486535 |
| 7daae1ec-0ec0-44e2-bc8b-faf549585905 | inventarisatie | { "a1": { "naam": "Marel, van der (M.)", "email": "[email]", "woonplaats": "LELYSTAD", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Mikkers, Geert (G)", "woonplaats": "LELYSTAD" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "413741.00", "status": "Lopend", "artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek", "tekendatum": "25569", "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "1822482", "passeeringangsdatum": "2020-05-01" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "42100.00", "status": "Lopend", "artikel": "Munt Annuïteiten Hypotheek", "tekendatum": "25569", "productnaam": "Munt Annuïteiten Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1822482", "passeeringangsdatum" ... [afgekapt: 1044 tekens] | 1778230486535 |
| 7daae1ec-0ec0-44e2-bc8b-faf549585905 | base_import | { "adres": "", "klant": "Marel, van der (M.), Mikkers, Geert (G)", "plaats": "LELYSTAD", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "", "products": [ { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "413741.00", "status": "Lopend", "artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek", "tekendatum": "25569", "productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Aflossingsvrij, Annuitair", "factuurbedrag": "", "offertenummer": "1822482", "passeeringangsdatum": "2020-05-01" }, { "norm": "Geldverstrekker", "type": "Hypotheek", "inhoud": "42100.00", "status": "Lopend", "artikel": "Munt Annuïteiten Hypotheek", "tekendatum": "25569", "productnaam": "Munt Annuïteiten Hypotheek", "maatschappij": "Munt Hypotheken", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1822482", "passeeringangsdatum": "2022-06-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekenda ... [afgekapt: 1633 tekens] | 1778230486535 |
| db46b3e9-6a02-46b3-89d2-955f281ef755 | inventarisatie | { "a1": { "naam": "Kolodziej, Bob (BJ)", "adres": "Rozengaard 11 38", "email": "[email]", "postcode": "8212 DB", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Sztura, Kamila (K)", "adres": "Rozengaard 11 38", "postcode": "8212 DB", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "207000.00", "status": "Lopend", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1873452", "passeeringangsdatum": "2020-12-15" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": ... [afgekapt: 2106 tekens] | 1778230486535 |
| db46b3e9-6a02-46b3-89d2-955f281ef755 | base_import | { "adres": "Rozengaard 11 38", "klant": "Kolodziej, Bob (BJ), Sztura, Kamila (K)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8212 DB", "products": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "207000.00", "status": "Lopend", "artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "tekendatum": "25569", "productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek", "maatschappij": "Lloyds Bank", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "1873452", "passeeringangsdatum": "2020-12-15" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-22" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": ... [afgekapt: 2717 tekens] | 1778230486535 |
| ee0a6758-f99f-4562-ad38-c29bd212fade | base_import | { "adres": "Horst 29 42", "klant": "Jonge, Hendrik Jan de (HJ)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8225 MV", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-05-28" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-05-28" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "149989.00", "status": "Lopend", "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "tekendatum": "25569", "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3193518-01", ... [afgekapt: 2210 tekens] | 1778230486535 |
| bd1e37d6-6948-40ca-a38b-98902294907a | inventarisatie | { "a1": { "naam": "Encarnacion Montas, Junior (J.)", "adres": "Wijngaard 76", "email": "[email]", "postcode": "8212 CE", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Wijngaard 76", "postcode": "8212 CE", "woonplaats": "Lelystad" }, "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": "2019-12-04" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "152382.00", "status": "Lopend", "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "tekendatum": "25569", "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3148094-01", "passeeringangsdatum": "2020-01-06" } ], "crmdossier_id": "200053", "dossi ... [afgekapt: 66 tekens] | 1778230486535 |
| bd1e37d6-6948-40ca-a38b-98902294907a | base_import | { "adres": "Wijngaard 76", "klant": "Encarnacion Montas, Junior (J.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8212 CE", "products": [ { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Akkoord", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-12-04" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "152382.00", "status": "Lopend", "artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "tekendatum": "25569", "productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3148094-01", "passeeringangsdatum": "2020-01-06" } ], "deelnemer": "Uw Hypotheek", "row_count": 2, "imported_at": "2026-05-08T08:54:46.535Z", "match_terms": [ "200053", "Encarnacion Montas, Junior (J.)", "Wijngaard 76", "8212 CE", "Lelystad", "[email]", "[telefoon]", "Eigen kantoor", "Hypotheekadvies", ... [afgekapt: 405 tekens] | 1778230486535 |
| e6717098-2c09-41fb-852b-924dd7e33403 | inventarisatie | { "a1": { "naam": "Algera, Melanie (M)", "adres": "Rijnland 26", "email": "[email]", "postcode": "8245 CV", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Nolles, Dennis (D)", "adres": "Rijnland 26", "postcode": "8245 CV", "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": "2729759", "passeeringangsdatum": "2019-11-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-09-07" }, ... [afgekapt: 1498 tekens] | 1778230486535 |
| e6717098-2c09-41fb-852b-924dd7e33403 | base_import | { "adres": "Rijnland 26", "klant": "Algera, Melanie (M), Nolles, Dennis (D)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8245 CV", "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": "2729759", "passeeringangsdatum": "2019-11-01" }, { "norm": "", "type": "Hypotheekadvies", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "", "tekendatum": "25569", "productnaam": "", "maatschappij": "Eigen kantoor", "productsoort": "", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2019-09-07" }, { "norm": "", "type": "Inkomensverzekering", "inhoud": "0.00", "status": "Lopend", "artikel": "Maandlastbeschermer", "tekendatum": "25569", "productnaam": "Maandlastbeschermer", "maatschappij": "TAF", "products ... [afgekapt: 2024 tekens] | 1778230486535 |
| 21f82986-03d9-4fa3-94a5-61d4f72a95dd | inventarisatie | { "a1": { "naam": "Burer, Jeffrey (J)", "adres": "Punter 39 43", "email": "[email]", "postcode": "8242 EW", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "naam": "Verbeek, Claudia (C.)", "adres": "Punter 39 43", "postcode": "8242 EW", "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": "2757921", "passeeringangsdatum": "2020-03-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "191264.00", "status": "Lopend", "artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)", "tekendatum": "25569", "productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)", "maatschappij": "Hypotrust", "pr ... [afgekapt: 1610 tekens] | 1778230486535 |
| 10b2c088-2130-49cd-ad7c-5a36b134e1b4 | inventarisatie | { "a1": { "naam": "Kalloe (S.)", "adres": "Kempenaar 01 16", "email": "[email]", "postcode": "8242 BA", "woonplaats": "Lelystad", "telefoon_prive": "[telefoon]" }, "a2": { "adres": "Kempenaar 01 16", "postcode": "8242 BA", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "", "type": "Dienst", "inhoud": "0.00", "status": "Nieuw adviestraject", "artikel": "Advies nieuwe Hypotheek/Doorstromer", "tekendatum": "2020-06-12", "productnaam": "Advies nieuwe Hypotheek/Doorstromer", "maatschappij": "Eigen kantoor", "productsoort": "Dienst BTW vrij", "factuurbedrag": "", "offertenummer": "", "passeeringangsdatum": "2020-06-12" } ], "crmdossier_id": "213447", "dossiernummer": "213447", "dossierstatus": "Vervallen", "producten_bron": "Excel klantenoverzicht" } } | 1778230486535 |
| 21f82986-03d9-4fa3-94a5-61d4f72a95dd | base_import | { "adres": "Punter 39 43", "klant": "Burer, Jeffrey (J), Verbeek, Claudia (C.)", "plaats": "Lelystad", "source": "excel_klantenoverzicht", "adviseur": "Zwarthoff, Rogier (R.D.)", "postcode": "8242 EW", "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": "2757921", "passeeringangsdatum": "2020-03-01" }, { "norm": "NHG", "type": "Hypotheek", "inhoud": "191264.00", "status": "Lopend", "artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)", "tekendatum": "25569", "productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)", "maatschappij": "Hypotrust", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "3159460-01", "passeeringangsdatum": "2020-07-03" }, { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", ... [afgekapt: 2316 tekens] | 1778230486535 |
Raw JSON details
Rij 1851
{
"dossier_id": "e4ceb87e-471f-4b5a-8e8a-1f9d2d35f7d1",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Hol, Marianne",
"adres": "Aaf Bouberstraat 4",
"email": "[email]",
"postcode": "1065 LS",
"woonplaats": "Amsterdam",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Aaf Bouberstraat 4",
"postcode": "1065 LS",
"woonplaats": "Amsterdam"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe hypotheek starter/Aankoop",
"tekendatum": "2020-08-25",
"productnaam": "Advies nieuwe hypotheek starter/Aankoop",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-08-25"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "325000.00",
"status": "Lopend",
"artikel": "Obvion Woon Hypotheek Annuitair",
"tekendatum": "25569",
"productnaam": "Obvion Woon Hypotheek Annuitair",
"maatschappij": "Obvion",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "635689",
"passeeringangsdatum": "2021-01-11"
}
],
"crmdossier_id": "221963",
"dossiernummer": "221963",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1852
{
"dossier_id": "e4ceb87e-471f-4b5a-8e8a-1f9d2d35f7d1",
"key": "base_import",
"value_json": {
"adres": "Aaf Bouberstraat 4",
"klant": "Hol, Marianne",
"plaats": "Amsterdam",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "1065 LS",
"products": [
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe hypotheek starter/Aankoop",
"tekendatum": "2020-08-25",
"productnaam": "Advies nieuwe hypotheek starter/Aankoop",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-08-25"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "325000.00",
"status": "Lopend",
"artikel": "Obvion Woon Hypotheek Annuitair",
"tekendatum": "25569",
"productnaam": "Obvion Woon Hypotheek Annuitair",
"maatschappij": "Obvion",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "635689",
"passeeringangsdatum": "2021-01-11"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 2,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"221963",
"Hol, Marianne",
"Aaf Bouberstraat 4",
"1065 LS",
"Amsterdam",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Dienst",
"Advies nieuwe hypotheek starter/Aankoop",
"Dienst BTW vrij",
"635689",
"Obvion",
"Hypotheek",
"Obvion Woon Hypotheek Annuitair",
"Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "221963",
"dossiernummer": "221963",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1853
{
"dossier_id": "601e6871-7671-43cf-b85e-0a7f28ad2720",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Touqan, Abdallah (AT)",
"adres": "Jacques Veltmanstraat 39",
"email": "[email]",
"postcode": "1065 EG",
"woonplaats": "AMSTERDAM",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Jacques Veltmanstraat 39",
"postcode": "1065 EG",
"woonplaats": "AMSTERDAM"
},
"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": "2020-12-23"
},
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Inboedelverzekering, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Inboedel",
"tekendatum": "25569",
"productnaam": "Inboedelverzekering, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand, Inboedel",
"maatschappij": "Risk Assuradeuren",
"productsoort": "Aansprakelijkheid, Inboedel, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
"factuurbedrag": "",
"offertenummer": "5369PK-*********",
"passeeringangsdatum": "2023-04-01"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "500000.00",
"status": "Lopend",
"artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
"tekendatum": "25569",
"productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
"maatschappij": "Argenta hypotheken",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3237154-01",
"passeeringangsdatum": "2021-04-06"
},
{
"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": "2822303",
"passeeringangsdatum": "2021-02-01"
},
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"tekendatum": "25569",
"productnaam": "Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"maatschappij": "Risk Assuradeuren",
"productsoort": "Aansprakelijkheid, Inboedel, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
"factuurbedrag": "",
"offertenummer": "5369PK-*********",
"passeeringangsdatum": "2023-04-01"
}
],
"crmdossier_id": "226944",
"dossiernummer": "226944",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1854
{
"dossier_id": "b2fff362-28e9-474e-9b68-1146c9374631",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Dabrowska, Marta (MM)",
"adres": "Beemster 10",
"email": "[email]",
"postcode": "8244 CA",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Urbanksi, Marek (M)",
"adres": "Beemster 10",
"email": "[email]",
"postcode": "8244 CA",
"woonplaats": "Lelystad"
},
"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": "2020-05-19"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "163142.00",
"status": "Lopend",
"artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"tekendatum": "25569",
"productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"maatschappij": "Hypotrust",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3190802-01",
"passeeringangsdatum": "2020-07-01"
}
],
"crmdossier_id": "212274",
"dossiernummer": "212274",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1855
{
"dossier_id": "b2fff362-28e9-474e-9b68-1146c9374631",
"key": "base_import",
"value_json": {
"adres": "Beemster 10",
"klant": "Dabrowska, Marta (MM), Urbanksi, Marek (M)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8244 CA",
"products": [
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-05-19"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "163142.00",
"status": "Lopend",
"artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"tekendatum": "25569",
"productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"maatschappij": "Hypotrust",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3190802-01",
"passeeringangsdatum": "2020-07-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 2,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"212274",
"Dabrowska, Marta (MM), Urbanksi, Marek (M)",
"Beemster 10",
"8244 CA",
"Lelystad",
"[email]",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Hypotheekadvies",
"3190802-01",
"Hypotrust",
"Hypotheek",
"Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "212274",
"dossiernummer": "212274",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1856
{
"dossier_id": "c9723cec-4644-4e4f-af2b-313b14b8b856",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Dijk, Danielle van (DM)",
"adres": "De Oeverloper 451",
"email": "[email]",
"postcode": "8251 HS",
"woonplaats": "Dronten",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Dijk, Olaf van (O.F.J.)",
"adres": "De Oeverloper 451",
"email": "[email]",
"postcode": "8251 HS",
"woonplaats": "Dronten"
},
"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": "2020-04-21"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "240000.00",
"status": "Lopend",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2020-08-10"
}
],
"crmdossier_id": "205544",
"dossiernummer": "205544",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1857
{
"dossier_id": "c9723cec-4644-4e4f-af2b-313b14b8b856",
"key": "base_import",
"value_json": {
"adres": "De Oeverloper 451",
"klant": "Dijk, Danielle van (DM), Dijk, Olaf van (O.F.J.)",
"plaats": "Dronten",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8251 HS",
"products": [
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-04-21"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "240000.00",
"status": "Lopend",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2020-08-10"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 2,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"205544",
"Dijk, Danielle van (DM), Dijk, Olaf van (O.F.J.)",
"De Oeverloper 451",
"8251 HS",
"Dronten",
"[email]",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Hypotheekadvies",
"*********",
"ING Bank",
"Hypotheek",
"ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "205544",
"dossiernummer": "205544",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1858
{
"dossier_id": "30fc24b1-abc3-4bad-a892-51fa5cbfad01",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Bioniarz, Gabriela Barbara (G)",
"adres": "Gentenerf 10",
"email": "[email]",
"postcode": "3852 LX",
"woonplaats": "Ermelo",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Gentenerf 10",
"postcode": "3852 LX",
"woonplaats": "Ermelo"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "TAF Woonlasten beschermer",
"tekendatum": "25569",
"productnaam": "TAF Woonlasten beschermer",
"maatschappij": "TAF",
"productsoort": "Woonlastenverzekering",
"factuurbedrag": "",
"offertenummer": "ISW-3A9DFBD7-73D1-4AEC-9110-7BD3EF138367|1015(1)",
"passeeringangsdatum": "2020-10-01"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Inkomensbeschermer",
"tekendatum": "25569",
"productnaam": "Inkomensbeschermer",
"maatschappij": "TAF",
"productsoort": "Arbeidsongeschiktheidsverzekering",
"factuurbedrag": "",
"offertenummer": "ISW-571E896E-DCF2-407A-AD95-BDD7C366D626|1015(1)",
"passeeringangsdatum": "2020-10-01"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Scherp & Slim ORV annuïtair dalend",
"tekendatum": "25569",
"productnaam": "Scherp & Slim ORV annuïtair dalend",
"maatschappij": "Hera Life",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "HL0088891",
"passeeringangsdatum": "2020-10-01"
},
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"tekendatum": "25569",
"productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"maatschappij": "Risk Assuradeuren",
"productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
"factuurbedrag": "",
"offertenummer": "5369PK-*********",
"passeeringangsdatum": "2023-09-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "200000.00",
"status": "Lopend",
"artikel": "Hypotrust Annuiteit (Woon Bewust)",
"tekendatum": "25569",
"productnaam": "Hypotrust Annuiteit (Woon Bewust)",
"maatschappij": "Hypotrust",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3186715-01",
"passeeringangsdatum": "2020-09-15"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-05-05"
}
],
"crmdossier_id": "211611",
"dossiernummer": "211611",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1859
{
"dossier_id": "30fc24b1-abc3-4bad-a892-51fa5cbfad01",
"key": "base_import",
"value_json": {
"adres": "Gentenerf 10",
"klant": "Bioniarz, Gabriela Barbara (G)",
"plaats": "Ermelo",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "3852 LX",
"products": [
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "TAF Woonlasten beschermer",
"tekendatum": "25569",
"productnaam": "TAF Woonlasten beschermer",
"maatschappij": "TAF",
"productsoort": "Woonlastenverzekering",
"factuurbedrag": "",
"offertenummer": "ISW-3A9DFBD7-73D1-4AEC-9110-7BD3EF138367|1015(1)",
"passeeringangsdatum": "2020-10-01"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Inkomensbeschermer",
"tekendatum": "25569",
"productnaam": "Inkomensbeschermer",
"maatschappij": "TAF",
"productsoort": "Arbeidsongeschiktheidsverzekering",
"factuurbedrag": "",
"offertenummer": "ISW-571E896E-DCF2-407A-AD95-BDD7C366D626|1015(1)",
"passeeringangsdatum": "2020-10-01"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Scherp & Slim ORV annuïtair dalend",
"tekendatum": "25569",
"productnaam": "Scherp & Slim ORV annuïtair dalend",
"maatschappij": "Hera Life",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "HL0088891",
"passeeringangsdatum": "2020-10-01"
},
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"tekendatum": "25569",
"productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"maatschappij": "Risk Assuradeuren",
"productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
"factuurbedrag": "",
"offertenummer": "5369PK-*********",
"passeeringangsdatum": "2023-09-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "200000.00",
"status": "Lopend",
"artikel": "Hypotrust Annuiteit (Woon Bewust)",
"tekendatum": "25569",
"productnaam": "Hypotrust Annuiteit (Woon Bewust)",
"maatschappij": "Hypotrust",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3186715-01",
"passeeringangsdatum": "2020-09-15"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-05-05"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 6,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"211611",
"Bioniarz, Gabriela Barbara (G)",
"Gentenerf 10",
"3852 LX",
"Ermelo",
"[email]",
"[telefoon]",
"ISW-3A9DFBD7-73D1-4AEC-9110-7BD3EF138367|1015(1)",
"TAF",
"Inkomensverzekering",
"TAF Woonlasten beschermer",
"Woonlastenverzekering",
"ISW-571E896E-DCF2-407A-AD95-BDD7C366D626|1015(1)",
"Inkomensbeschermer",
"Arbeidsongeschiktheidsverzekering",
"HL0088891",
"Hera Life",
"Levensverzekering",
"Scherp & Slim ORV annuïtair dalend",
"Annuitair Dalende Risicoverzekeringen",
"5369PK-*********",
"Risk Assuradeuren",
"Schadeverzekering",
"Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
"3186715-01",
"Hypotrust",
"Hypotheek",
"Hypotrust Annuiteit (Woon Bewust)",
"Annuitair",
"Eigen kantoor",
"Hypotheekadvies"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "211611",
"dossiernummer": "211611",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1860
{
"dossier_id": "93210e0e-4e20-4e82-8c44-97c044d58598",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Gyebi, Nigel (NNA)",
"adres": "Bouwen Ewoutstraat 35",
"email": "[email]",
"postcode": "4381 PP",
"woonplaats": "Vlissingen",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Bouwen Ewoutstraat 35",
"postcode": "4381 PP",
"woonplaats": "Vlissingen"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "147500.00",
"status": "Lopend",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2021-01-18"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-09-17"
}
],
"crmdossier_id": "222986",
"dossiernummer": "222986",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1861
{
"dossier_id": "93210e0e-4e20-4e82-8c44-97c044d58598",
"key": "base_import",
"value_json": {
"adres": "Bouwen Ewoutstraat 35",
"klant": "Gyebi, Nigel (NNA)",
"plaats": "Vlissingen",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "4381 PP",
"products": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "147500.00",
"status": "Lopend",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2021-01-18"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-09-17"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 2,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"222986",
"Gyebi, Nigel (NNA)",
"Bouwen Ewoutstraat 35",
"4381 PP",
"Vlissingen",
"[email]",
"[telefoon]",
"*********",
"ING Bank",
"Hypotheek",
"ING Annuiteitenhypotheek (Reguliere hypotheek)",
"Annuitair",
"Eigen kantoor",
"Hypotheekadvies"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "222986",
"dossiernummer": "222986",
"dossierstatus": "Actief",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1862
{
"dossier_id": "fe467b1b-4567-4add-8487-22c9e3f97e13",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Broek, Lisa van den (LWS)",
"adres": "P.C. Hooftplein 29",
"email": "[email]",
"postcode": "3842 HC",
"woonplaats": "Harderwijk",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "P.C. Hooftplein 29",
"postcode": "3842 HC",
"woonplaats": "Harderwijk"
},
"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": "2021-11-02"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "175600.00",
"status": "Lopend",
"artikel": "Hypotrust Comfort Annuiteit (Hypotrust Standaard)",
"tekendatum": "25569",
"productnaam": "Hypotrust Comfort Annuiteit (Hypotrust Standaard)",
"maatschappij": "Hypotrust",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3196406-01",
"passeeringangsdatum": "2020-07-30"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Credit Life Woonlastenverzekering - AO",
"tekendatum": "25569",
"productnaam": "Credit Life Woonlastenverzekering - AO",
"maatschappij": "Credit Life",
"productsoort": "Woonlastenverzekering",
"factuurbedrag": "",
"offertenummer": "5001227953",
"passeeringangsdatum": "2020-08-01"
}
],
"crmdossier_id": "213332",
"dossiernummer": "213332",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1863
{
"dossier_id": "444a8ad7-21a2-44f5-a241-fb61c4454f50",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Wilpen, Berendina van (B)",
"adres": "Hofstede 51",
"email": "[email]",
"postcode": "8212 WD",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Wilpen, John van (J)",
"adres": "Hofstede 51",
"postcode": "8212 WD",
"woonplaats": "Lelystad"
},
"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": "2020-10-27"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "212590.00",
"status": "Lopend",
"artikel": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
"tekendatum": "25569",
"productnaam": "IQWOON Aflossingsvrije hypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
"maatschappij": "IQWOON",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "3220087-01",
"passeeringangsdatum": "2021-04-02"
}
],
"crmdossier_id": "222949",
"dossiernummer": "222949",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1864
{
"dossier_id": "10b2c088-2130-49cd-ad7c-5a36b134e1b4",
"key": "base_import",
"value_json": {
"adres": "Kempenaar 01 16",
"klant": "Kalloe (S.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8242 BA",
"products": [
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe Hypotheek/Doorstromer",
"tekendatum": "2020-06-12",
"productnaam": "Advies nieuwe Hypotheek/Doorstromer",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-12"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"213447",
"Kalloe (S.)",
"Kempenaar 01 16",
"8242 BA",
"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": "213447",
"dossiernummer": "213447",
"dossierstatus": "Vervallen",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1865
{
"dossier_id": "1d24720c-9b97-49c9-b0d8-0073a147115c",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Kooiman, Gemma (G.)",
"adres": "Jol 18 16",
"email": "[email]",
"postcode": "8243 GG",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Jol 18 16",
"postcode": "8243 GG",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe Hypotheek/Doorstromer",
"tekendatum": "2020-06-12",
"productnaam": "Advies nieuwe Hypotheek/Doorstromer",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-12"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-12"
}
],
"crmdossier_id": "213438",
"dossiernummer": "213438",
"dossierstatus": "Vervallen",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1866
{
"dossier_id": "1d24720c-9b97-49c9-b0d8-0073a147115c",
"key": "base_import",
"value_json": {
"adres": "Jol 18 16",
"klant": "Kooiman, Gemma (G.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8243 GG",
"products": [
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe Hypotheek/Doorstromer",
"tekendatum": "2020-06-12",
"productnaam": "Advies nieuwe Hypotheek/Doorstromer",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-12"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-12"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 2,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"213438",
"Kooiman, Gemma (G.)",
"Jol 18 16",
"8243 GG",
"Lelystad",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Dienst",
"Advies nieuwe Hypotheek/Doorstromer",
"Dienst BTW vrij",
"Hypotheekadvies"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "213438",
"dossiernummer": "213438",
"dossierstatus": "Vervallen",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1867
{
"dossier_id": "c930b574-88c3-4631-8b83-b23f579b8753",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Habekotte, Melissa (M)",
"adres": "Tijm 14",
"email": "[email]",
"postcode": "8252 CP",
"woonplaats": "Dronten",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Rolleman, Thijs (T.S.K.)",
"adres": "Tijm 14",
"email": "[email]",
"postcode": "8252 CP",
"woonplaats": "Dronten"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "175291.00",
"status": "Lopend",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2020-11-22"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "175291.00",
"status": "Lopend",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2020-11-22"
},
{
"norm": "",
"type": "Consumptief krediet",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Persoonlijke lening",
"tekendatum": "25569",
"productnaam": "Persoonlijke lening",
"maatschappij": "Qander Consumer Finance",
"productsoort": "Persoonlijke lening",
"factuurbedrag": "",
"offertenummer": "3080621",
"passeeringangsdatum": "2017-11-15"
},
{
"norm": "",
"type": "Consumptief krediet",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Persoonlijke lening",
"tekendatum": "25569",
"productnaam": "Persoonlijke lening",
"maatschappij": "Qander Consumer Finance",
"productsoort": "Persoonlijke lening",
"factuurbedrag": "",
"offertenummer": "3080621",
"passeeringangsdatum": "2017-11-15"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-01-10"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-01-10"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Overlijdensrisicoverzekering",
"tekendatum": "25569",
"productnaam": "Overlijdensrisicoverzekering",
"maatschappij": "Argenta hypotheken",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "[telefoon]-90",
"passeeringangsdatum": "2015-08-01"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Overlijdensrisicoverzekering",
"tekendatum": "25569",
"productnaam": "Overlijdensrisicoverzekering",
"maatschappij": "Argenta hypotheken",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "[telefoon]-90",
"passeeringangsdatum": "2015-08-01"
}
],
"crmdossier_id": "104582",
"dossiernummer": "104582",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1868
{
"dossier_id": "c930b574-88c3-4631-8b83-b23f579b8753",
"key": "base_import",
"value_json": {
"adres": "Tijm 14",
"klant": "Habekotte, Melissa (M), Rolleman, Thijs (T.S.K.)",
"plaats": "Dronten",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8252 CP",
"products": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "175291.00",
"status": "Lopend",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2020-11-22"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "175291.00",
"status": "Lopend",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2020-11-22"
},
{
"norm": "",
"type": "Consumptief krediet",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Persoonlijke lening",
"tekendatum": "25569",
"productnaam": "Persoonlijke lening",
"maatschappij": "Qander Consumer Finance",
"productsoort": "Persoonlijke lening",
"factuurbedrag": "",
"offertenummer": "3080621",
"passeeringangsdatum": "2017-11-15"
},
{
"norm": "",
"type": "Consumptief krediet",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Persoonlijke lening",
"tekendatum": "25569",
"productnaam": "Persoonlijke lening",
"maatschappij": "Qander Consumer Finance",
"productsoort": "Persoonlijke lening",
"factuurbedrag": "",
"offertenummer": "3080621",
"passeeringangsdatum": "2017-11-15"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-01-10"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-01-10"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Overlijdensrisicoverzekering",
"tekendatum": "25569",
"productnaam": "Overlijdensrisicoverzekering",
"maatschappij": "Argenta hypotheken",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "[telefoon]-90",
"passeeringangsdatum": "2015-08-01"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Overlijdensrisicoverzekering",
"tekendatum": "25569",
"productnaam": "Overlijdensrisicoverzekering",
"maatschappij": "Argenta hypotheken",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "[telefoon]-90",
"passeeringangsdatum": "2015-08-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 8,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"104582",
"Habekotte, Melissa (M), Rolleman, Thijs (T.S.K.)",
"Tijm 14",
"8252 CP",
"Dronten",
"[email]",
"[email]",
"[telefoon]",
"*********",
"ING Bank",
"Hypotheek",
"ING Annuiteitenhypotheek (Reguliere hypotheek), ING Annuiteitenhypotheek (Reguliere hypotheek)",
"Annuitair",
"3080621",
"Qander Consumer Finance",
"Consumptief krediet",
"Persoonlijke lening",
"Eigen kantoor",
"Hypotheekadvies",
"[telefoon]-90",
"Argenta hypotheken",
"Levensverzekering",
"Overlijdensrisicoverzekering",
"Annuitair Dalende Risicoverzekeringen"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "104582",
"dossiernummer": "104582",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1869
{
"dossier_id": "f235c68d-5854-465b-9477-058cd70d172c",
"key": "base_import",
"value_json": {
"adres": "Oostzeestraat 113",
"klant": "Jankowski (J.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8226 BH",
"products": [
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Offerte/renteaanbod ontvangen",
"artikel": "Cardif Aflos Verzekering",
"tekendatum": "25569",
"productnaam": "Cardif Aflos Verzekering",
"maatschappij": "Cardif",
"productsoort": "Woonlastenverzekering",
"factuurbedrag": "",
"offertenummer": "HAV00150650",
"passeeringangsdatum": "2019-11-01"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Scherp & Slim ORV annuïtair dalend",
"tekendatum": "25569",
"productnaam": "Scherp & Slim ORV annuïtair dalend",
"maatschappij": "Hera Life",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "HL0061798",
"passeeringangsdatum": "2019-11-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2019-09-07"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "173000.00",
"status": "Lopend",
"artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
"tekendatum": "25569",
"productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
"maatschappij": "Obvion",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "611756",
"passeeringangsdatum": "2019-11-28"
},
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"tekendatum": "25569",
"productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"maatschappij": "Risk Assuradeuren",
"productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
"factuurbedrag": "",
"offertenummer": "5369PK-*********",
"passeeringangsdatum": "2023-11-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 5,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"200376",
"Jankowski (J.)",
"Oostzeestraat 113",
"8226 BH",
"Lelystad",
"[email]",
"[telefoon]",
"HAV00150650",
"Cardif",
"Inkomensverzekering",
"Cardif Aflos Verzekering",
"Woonlastenverzekering",
"HL0061798",
"Hera Life",
"Levensverzekering",
"Scherp & Slim ORV annuïtair dalend",
"Annuitair Dalende Risicoverzekeringen",
"Eigen kantoor",
"Hypotheekadvies",
"611756",
"Obvion",
"Hypotheek",
"Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
"Annuitair",
"5369PK-*********",
"Risk Assuradeuren",
"Schadeverzekering",
"Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "200376",
"dossiernummer": "200376",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1870
{
"dossier_id": "b075d90a-53d2-407a-80a9-89f1ae8fec96",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Raven, Jacqueline (J.M.C.)",
"adres": "Zeepkruidstraat 131",
"email": "[email]",
"postcode": "8245 LH",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Reekers, Frans (F.M.)",
"adres": "Zeepkruidstraat 131",
"postcode": "8245 LH",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "500000.00",
"status": "Lopend",
"artikel": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
"tekendatum": "25569",
"productnaam": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
"maatschappij": "Woonnu",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "3216244-01",
"passeeringangsdatum": "2020-11-23"
},
{
"norm": "",
"type": "Consumptief krediet",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Doorlopend krediet",
"tekendatum": "25569",
"productnaam": "Doorlopend krediet",
"maatschappij": "Nationale-Nederlanden Leven",
"productsoort": "Doorlopend krediet",
"factuurbedrag": "",
"offertenummer": "2000121909",
"passeeringangsdatum": "2015-11-17"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-03-13"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
"tekendatum": "25569",
"productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
"maatschappij": "Credit Life",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "7001218289",
"passeeringangsdatum": "2020-05-01"
}
],
"crmdossier_id": "95164",
"dossiernummer": "95164",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1871
{
"dossier_id": "b075d90a-53d2-407a-80a9-89f1ae8fec96",
"key": "base_import",
"value_json": {
"adres": "Zeepkruidstraat 131",
"klant": "Raven, Jacqueline (J.M.C.), Reekers, Frans (F.M.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8245 LH",
"products": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "500000.00",
"status": "Lopend",
"artikel": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
"tekendatum": "25569",
"productnaam": "Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
"maatschappij": "Woonnu",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "3216244-01",
"passeeringangsdatum": "2020-11-23"
},
{
"norm": "",
"type": "Consumptief krediet",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Doorlopend krediet",
"tekendatum": "25569",
"productnaam": "Doorlopend krediet",
"maatschappij": "Nationale-Nederlanden Leven",
"productsoort": "Doorlopend krediet",
"factuurbedrag": "",
"offertenummer": "2000121909",
"passeeringangsdatum": "2015-11-17"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-03-13"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Credit Life Overlijdensrisicoverzekering Annuitair",
"tekendatum": "25569",
"productnaam": "Credit Life Overlijdensrisicoverzekering Annuitair",
"maatschappij": "Credit Life",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "7001218289",
"passeeringangsdatum": "2020-05-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 4,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"95164",
"Raven, Jacqueline (J.M.C.), Reekers, Frans (F.M.)",
"Zeepkruidstraat 131",
"8245 LH",
"Lelystad",
"[email]",
"[telefoon]",
"3216244-01",
"Woonnu",
"Hypotheek",
"Woonnu Aflossingsvrij, Woonnu Annuïtair, Woonnu Annuïtair, Woonnu Annuïtair",
"Aflossingsvrij, Annuitair",
"2000121909",
"Nationale-Nederlanden Leven",
"Consumptief krediet",
"Doorlopend krediet",
"Eigen kantoor",
"Hypotheekadvies",
"7001218289",
"Credit Life",
"Levensverzekering",
"Credit Life Overlijdensrisicoverzekering Annuitair",
"Annuitair Dalende Risicoverzekeringen"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "95164",
"dossiernummer": "95164",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1872
{
"dossier_id": "7065b590-ff03-4134-b2f2-40610817b5b7",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Honing, Raymon (R)",
"adres": "Bergumermeerstraat 1",
"email": "[email]",
"postcode": "8226 JK",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Kist, Mariska (MA)",
"adres": "Bergumermeerstraat 1",
"postcode": "8226 JK",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "334325.00",
"status": "Lopend",
"artikel": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair",
"tekendatum": "25569",
"productnaam": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair",
"maatschappij": "Centraal Beheer",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3298974-01",
"passeeringangsdatum": "2022-01-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-05-12"
}
],
"crmdossier_id": "211912",
"dossiernummer": "211912",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1873
{
"dossier_id": "7065b590-ff03-4134-b2f2-40610817b5b7",
"key": "base_import",
"value_json": {
"adres": "Bergumermeerstraat 1",
"klant": "Honing, Raymon (R), Kist, Mariska (MA)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8226 JK",
"products": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "334325.00",
"status": "Lopend",
"artikel": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair",
"tekendatum": "25569",
"productnaam": "Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair",
"maatschappij": "Centraal Beheer",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3298974-01",
"passeeringangsdatum": "2022-01-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-05-12"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 2,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"211912",
"Honing, Raymon (R), Kist, Mariska (MA)",
"Bergumermeerstraat 1",
"8226 JK",
"Lelystad",
"[email]",
"[telefoon]",
"3298974-01",
"Centraal Beheer",
"Hypotheek",
"Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair, Leef Hypotheek Annuïtair",
"Annuitair",
"Eigen kantoor",
"Hypotheekadvies"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "211912",
"dossiernummer": "211912",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1874
{
"dossier_id": "f235c68d-5854-465b-9477-058cd70d172c",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Jankowski (J.)",
"adres": "Oostzeestraat 113",
"email": "[email]",
"postcode": "8226 BH",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Oostzeestraat 113",
"postcode": "8226 BH",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Offerte/renteaanbod ontvangen",
"artikel": "Cardif Aflos Verzekering",
"tekendatum": "25569",
"productnaam": "Cardif Aflos Verzekering",
"maatschappij": "Cardif",
"productsoort": "Woonlastenverzekering",
"factuurbedrag": "",
"offertenummer": "HAV00150650",
"passeeringangsdatum": "2019-11-01"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Scherp & Slim ORV annuïtair dalend",
"tekendatum": "25569",
"productnaam": "Scherp & Slim ORV annuïtair dalend",
"maatschappij": "Hera Life",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "HL0061798",
"passeeringangsdatum": "2019-11-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2019-09-07"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "173000.00",
"status": "Lopend",
"artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
"tekendatum": "25569",
"productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek), Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
"maatschappij": "Obvion",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "611756",
"passeeringangsdatum": "2019-11-28"
},
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"tekendatum": "25569",
"productnaam": "Opstal, Inboedel, Aansprakelijkheid, Reis en annuleringsverzekeringen, excursies, Rechtsbijstand",
"maatschappij": "Risk Assuradeuren",
"productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand, Reis en annuleringsverzekeringen, excursies",
"factuurbedrag": "",
"offertenummer": "5369PK-*********",
"passeeringangsdatum": "2023-11-01"
}
],
"crmdossier_id": "200376",
"dossiernummer": "200376",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1875
{
"dossier_id": "e8442c1c-3339-4419-8a50-fc3ae4180fcf",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Verhoef (C.W.E.)",
"adres": "Punter 41 41",
"email": "[email]",
"postcode": "8242 GC",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Punter 41 41",
"postcode": "8242 GC",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe hypotheek starter/Aankoop",
"tekendatum": "2020-06-23",
"productnaam": "Advies nieuwe hypotheek starter/Aankoop",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-23"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-23"
}
],
"crmdossier_id": "214031",
"dossiernummer": "214031",
"dossierstatus": "Vervallen",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1876
{
"dossier_id": "e8442c1c-3339-4419-8a50-fc3ae4180fcf",
"key": "base_import",
"value_json": {
"adres": "Punter 41 41",
"klant": "Verhoef (C.W.E.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8242 GC",
"products": [
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe hypotheek starter/Aankoop",
"tekendatum": "2020-06-23",
"productnaam": "Advies nieuwe hypotheek starter/Aankoop",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-23"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-23"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 2,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"214031",
"Verhoef (C.W.E.)",
"Punter 41 41",
"8242 GC",
"Lelystad",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Dienst",
"Advies nieuwe hypotheek starter/Aankoop",
"Dienst BTW vrij",
"Hypotheekadvies"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "214031",
"dossiernummer": "214031",
"dossierstatus": "Vervallen",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1877
{
"dossier_id": "5ed6688b-c9da-4a4e-8248-bd1b1f6ffc9e",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Duztas, Cemil (C.)",
"adres": "Lagune 29",
"email": "[email]",
"postcode": "8224 CR",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Lagune 29",
"postcode": "8224 CR",
"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": "2020-06-22"
},
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe Hypotheek/Doorstromer",
"tekendatum": "2020-06-22",
"productnaam": "Advies nieuwe Hypotheek/Doorstromer",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-22"
}
],
"crmdossier_id": "213931",
"dossiernummer": "213931",
"dossierstatus": "Vervallen",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1878
{
"dossier_id": "5ed6688b-c9da-4a4e-8248-bd1b1f6ffc9e",
"key": "base_import",
"value_json": {
"adres": "Lagune 29",
"klant": "Duztas, Cemil (C.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8224 CR",
"products": [
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-22"
},
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe Hypotheek/Doorstromer",
"tekendatum": "2020-06-22",
"productnaam": "Advies nieuwe Hypotheek/Doorstromer",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-22"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 2,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"213931",
"Duztas, Cemil (C.)",
"Lagune 29",
"8224 CR",
"Lelystad",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Hypotheekadvies",
"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": "213931",
"dossiernummer": "213931",
"dossierstatus": "Vervallen",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1879
{
"dossier_id": "ec738fcd-419c-40e4-8c8e-de96b50d4b4b",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Eijk, Melvin van (M.J.)",
"adres": "Karveel 59 82",
"email": "[email]",
"postcode": "8242 WG",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Grondhuis (A)",
"adres": "Karveel 59 82",
"postcode": "8242 WG",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "16066.00",
"status": "Lopend",
"artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
"tekendatum": "25569",
"productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
"maatschappij": "Centraal Beheer",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3172756-01",
"passeeringangsdatum": "2022-07-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "229790.00",
"status": "Lopend",
"artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
"tekendatum": "25569",
"productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
"maatschappij": "Centraal Beheer",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3172756-01",
"passeeringangsdatum": "2020-08-03"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-04-02"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
"tekendatum": "25569",
"productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "GEWI.613444",
"passeeringangsdatum": "2016-09-01"
}
],
"crmdossier_id": "129443",
"dossiernummer": "129443",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1880
{
"dossier_id": "ec738fcd-419c-40e4-8c8e-de96b50d4b4b",
"key": "base_import",
"value_json": {
"adres": "Karveel 59 82",
"klant": "Eijk, Melvin van (M.J.), Grondhuis (A)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8242 WG",
"products": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "16066.00",
"status": "Lopend",
"artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
"tekendatum": "25569",
"productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
"maatschappij": "Centraal Beheer",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3172756-01",
"passeeringangsdatum": "2022-07-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "229790.00",
"status": "Lopend",
"artikel": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
"tekendatum": "25569",
"productnaam": "Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
"maatschappij": "Centraal Beheer",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3172756-01",
"passeeringangsdatum": "2020-08-03"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-04-02"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
"tekendatum": "25569",
"productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "GEWI.613444",
"passeeringangsdatum": "2016-09-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 4,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"129443",
"Eijk, Melvin van (M.J.), Grondhuis (A)",
"Karveel 59 82",
"8242 WG",
"Lelystad",
"[email]",
"[telefoon]",
"3172756-01",
"Centraal Beheer",
"Hypotheek",
"Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
"Annuitair",
"Annuïteiten Hypotheek (Centraal Beheer Hypotheek), Annuïteiten Hypotheek (Centraal Beheer Hypotheek)",
"Eigen kantoor",
"Hypotheekadvies",
"GEWI.613444",
"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": "129443",
"dossiernummer": "129443",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1881
{
"dossier_id": "479d116b-3b72-40a3-bb24-0ae34626cc9e",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Marciniec , Piotr Antoni (PA)",
"adres": "Schoener 45 9",
"email": "[email]",
"postcode": "8243 XG",
"woonplaats": "Lelystad",
"telefoon_prive": "*********"
},
"a2": {
"adres": "Schoener 45 9",
"email": "[email]",
"postcode": "8243 XG",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
"tekendatum": "25569",
"productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
"maatschappij": "Voogd & Voogd",
"productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
"factuurbedrag": "",
"offertenummer": "156722505385",
"passeeringangsdatum": "2017-05-10"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "214380.00",
"status": "Lopend",
"artikel": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
"tekendatum": "25569",
"productnaam": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
"maatschappij": "IQWOON",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3202655-01",
"passeeringangsdatum": "2020-09-01"
},
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
"tekendatum": "25569",
"productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
"maatschappij": "Risk Assuradeuren",
"productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
"factuurbedrag": "",
"offertenummer": "5369PK-*********",
"passeeringangsdatum": "2023-05-01"
},
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
"tekendatum": "25569",
"productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
"maatschappij": "Risk Assuradeuren",
"productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
"factuurbedrag": "",
"offertenummer": "5369PK-*********",
"passeeringangsdatum": "2023-05-01"
},
{
"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": "2386746",
"passeeringangsdatum": "2017-05-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2017-03-13"
}
],
"crmdossier_id": "149171",
"dossiernummer": "149171",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1882
{
"dossier_id": "479d116b-3b72-40a3-bb24-0ae34626cc9e",
"key": "base_import",
"value_json": {
"adres": "Schoener 45 9",
"klant": "Marciniec , Piotr Antoni (PA)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8243 XG",
"products": [
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
"tekendatum": "25569",
"productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
"maatschappij": "Voogd & Voogd",
"productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
"factuurbedrag": "",
"offertenummer": "156722505385",
"passeeringangsdatum": "2017-05-10"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "214380.00",
"status": "Lopend",
"artikel": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
"tekendatum": "25569",
"productnaam": "IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
"maatschappij": "IQWOON",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3202655-01",
"passeeringangsdatum": "2020-09-01"
},
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
"tekendatum": "25569",
"productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
"maatschappij": "Risk Assuradeuren",
"productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
"factuurbedrag": "",
"offertenummer": "5369PK-*********",
"passeeringangsdatum": "2023-05-01"
},
{
"norm": "",
"type": "Schadeverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
"tekendatum": "25569",
"productnaam": "Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
"maatschappij": "Risk Assuradeuren",
"productsoort": "Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
"factuurbedrag": "",
"offertenummer": "5369PK-*********",
"passeeringangsdatum": "2023-05-01"
},
{
"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": "2386746",
"passeeringangsdatum": "2017-05-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2017-03-13"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 6,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"149171",
"Marciniec , Piotr Antoni (PA)",
"Schoener 45 9",
"8243 XG",
"Lelystad",
"[email]",
"[email]",
"*********",
"156722505385",
"Voogd & Voogd",
"Schadeverzekering",
"Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren",
"Aansprakelijkheid, Inboedel, Opstal, Rechtsbijstand",
"3202655-01",
"IQWOON",
"Hypotheek",
"IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek, IQWOON Annuïteitenhypotheek",
"Annuitair",
"5369PK-*********",
"Risk Assuradeuren",
"Opstal, Inboedel, Aansprakelijkheid, Rechtsbijstand",
"2386746",
"TAF",
"Levensverzekering",
"Credit Life International Overlijdensrisicoverzekering - Annuitair",
"Overlijdensrisicoverzekering",
"Eigen kantoor",
"Hypotheekadvies"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "149171",
"dossiernummer": "149171",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "*********",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1883
{
"dossier_id": "8c825e61-048c-4ca0-9b90-994b36c01bed",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Weverling, Leslie (LG)",
"adres": "Woudlaar 71",
"email": "[email]",
"postcode": "1359 KM",
"woonplaats": "Almere",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Weverling-Gerezgiher, H (HK)",
"adres": "Woudlaar 71",
"postcode": "1359 KM",
"woonplaats": "Almere"
},
"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-05"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-04-24"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "253703.00",
"status": "Lopend",
"artikel": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
"tekendatum": "25569",
"productnaam": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
"maatschappij": "Argenta hypotheken",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "3074930-01",
"passeeringangsdatum": "2018-09-28"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "ORV Annuitair dalend",
"tekendatum": "25569",
"productnaam": "ORV Annuitair dalend",
"maatschappij": "Reaal schadeverzekeringen",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "1300306239",
"passeeringangsdatum": "2018-08-01"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "6425.00",
"status": "Offerte/renteaanbod ontvangen",
"artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
"tekendatum": "25569",
"productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
"maatschappij": "Argenta hypotheken",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3074930-01",
"passeeringangsdatum": "2020-09-01"
}
],
"crmdossier_id": "211202",
"dossiernummer": "211202",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1884
{
"dossier_id": "8c825e61-048c-4ca0-9b90-994b36c01bed",
"key": "base_import",
"value_json": {
"adres": "Woudlaar 71",
"klant": "Weverling, Leslie (LG), Weverling-Gerezgiher, H (HK)",
"plaats": "Almere",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "1359 KM",
"products": [
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2018-07-05"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-04-24"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "253703.00",
"status": "Lopend",
"artikel": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
"tekendatum": "25569",
"productnaam": "Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
"maatschappij": "Argenta hypotheken",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "3074930-01",
"passeeringangsdatum": "2018-09-28"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "ORV Annuitair dalend",
"tekendatum": "25569",
"productnaam": "ORV Annuitair dalend",
"maatschappij": "Reaal schadeverzekeringen",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "1300306239",
"passeeringangsdatum": "2018-08-01"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "6425.00",
"status": "Offerte/renteaanbod ontvangen",
"artikel": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
"tekendatum": "25569",
"productnaam": "Argenta Annuiteit (Argenta Special Line Hypotheek)",
"maatschappij": "Argenta hypotheken",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3074930-01",
"passeeringangsdatum": "2020-09-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 5,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"211202",
"Weverling, Leslie (LG), Weverling-Gerezgiher, H (HK)",
"Woudlaar 71",
"1359 KM",
"Almere",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Hypotheekadvies",
"3074930-01",
"Argenta hypotheken",
"Hypotheek",
"Argenta Aflossingsvrij (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek), Argenta Annuiteit (Argenta Special Line Hypotheek)",
"Aflossingsvrij, Annuitair",
"1300306239",
"Reaal schadeverzekeringen",
"Levensverzekering",
"ORV Annuitair dalend",
"Annuitair Dalende Risicoverzekeringen",
"Argenta Annuiteit (Argenta Special Line Hypotheek)",
"Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "211202",
"dossiernummer": "211202",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1885
{
"dossier_id": "656d3981-42a3-479f-ac53-179afc987d57",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Mahabier (P.)",
"adres": "Botter 36 44",
"email": "[email]",
"postcode": "8243 KT",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Sewberath Misser (A.G.)",
"adres": "Botter 36 44",
"email": "[email]",
"postcode": "8243 KT",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "325000.00",
"status": "Lopend",
"artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"maatschappij": "Lloyds Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "2095590",
"passeeringangsdatum": "2022-10-07"
}
],
"crmdossier_id": "251779",
"dossiernummer": "251779",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1886
{
"dossier_id": "656d3981-42a3-479f-ac53-179afc987d57",
"key": "base_import",
"value_json": {
"adres": "Botter 36 44",
"klant": "Mahabier (P.), Sewberath Misser (A.G.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8243 KT",
"products": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "325000.00",
"status": "Lopend",
"artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"maatschappij": "Lloyds Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "2095590",
"passeeringangsdatum": "2022-10-07"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 1,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"251779",
"Mahabier (P.), Sewberath Misser (A.G.)",
"Botter 36 44",
"8243 KT",
"Lelystad",
"[email]",
"[email]",
"[telefoon]",
"2095590",
"Lloyds Bank",
"Hypotheek",
"Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "251779",
"dossiernummer": "251779",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1887
{
"dossier_id": "32c01726-52ab-4a79-8222-57b5b67ff66f",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Driouech, Anouar",
"adres": "Zilverschoonlaan 203",
"email": "[email]",
"postcode": "8245 KE",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Zilverschoonlaan 203",
"postcode": "8245 KE",
"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": "2020-07-06"
},
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe hypotheek starter/Aankoop",
"tekendatum": "2020-07-06",
"productnaam": "Advies nieuwe hypotheek starter/Aankoop",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-07-06"
}
],
"crmdossier_id": "214619",
"dossiernummer": "214619",
"dossierstatus": "Vervallen",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1888
{
"dossier_id": "32c01726-52ab-4a79-8222-57b5b67ff66f",
"key": "base_import",
"value_json": {
"adres": "Zilverschoonlaan 203",
"klant": "Driouech, Anouar",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8245 KE",
"products": [
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-07-06"
},
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe hypotheek starter/Aankoop",
"tekendatum": "2020-07-06",
"productnaam": "Advies nieuwe hypotheek starter/Aankoop",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-07-06"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 2,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"214619",
"Driouech, Anouar",
"Zilverschoonlaan 203",
"8245 KE",
"Lelystad",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Hypotheekadvies",
"Dienst",
"Advies nieuwe hypotheek starter/Aankoop",
"Dienst BTW vrij"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "214619",
"dossiernummer": "214619",
"dossierstatus": "Vervallen",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1889
{
"dossier_id": "7daae1ec-0ec0-44e2-bc8b-faf549585905",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Marel, van der (M.)",
"email": "[email]",
"woonplaats": "LELYSTAD",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Mikkers, Geert (G)",
"woonplaats": "LELYSTAD"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "413741.00",
"status": "Lopend",
"artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
"tekendatum": "25569",
"productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
"maatschappij": "Munt Hypotheken",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "1822482",
"passeeringangsdatum": "2020-05-01"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "42100.00",
"status": "Lopend",
"artikel": "Munt Annuïteiten Hypotheek",
"tekendatum": "25569",
"productnaam": "Munt Annuïteiten Hypotheek",
"maatschappij": "Munt Hypotheken",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "1822482",
"passeeringangsdatum": "2022-06-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2019-02-18"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
"tekendatum": "25569",
"productnaam": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
"maatschappij": "TAF",
"productsoort": "Overlijdensrisicoverzekering",
"factuurbedrag": "",
"offertenummer": "2746171",
"passeeringangsdatum": "2020-01-01"
}
],
"crmdossier_id": "199284",
"dossiernummer": "199284",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1890
{
"dossier_id": "7daae1ec-0ec0-44e2-bc8b-faf549585905",
"key": "base_import",
"value_json": {
"adres": "",
"klant": "Marel, van der (M.), Mikkers, Geert (G)",
"plaats": "LELYSTAD",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "",
"products": [
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "413741.00",
"status": "Lopend",
"artikel": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
"tekendatum": "25569",
"productnaam": "Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
"maatschappij": "Munt Hypotheken",
"productsoort": "Aflossingsvrij, Annuitair",
"factuurbedrag": "",
"offertenummer": "1822482",
"passeeringangsdatum": "2020-05-01"
},
{
"norm": "Geldverstrekker",
"type": "Hypotheek",
"inhoud": "42100.00",
"status": "Lopend",
"artikel": "Munt Annuïteiten Hypotheek",
"tekendatum": "25569",
"productnaam": "Munt Annuïteiten Hypotheek",
"maatschappij": "Munt Hypotheken",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "1822482",
"passeeringangsdatum": "2022-06-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2019-02-18"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
"tekendatum": "25569",
"productnaam": "TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
"maatschappij": "TAF",
"productsoort": "Overlijdensrisicoverzekering",
"factuurbedrag": "",
"offertenummer": "2746171",
"passeeringangsdatum": "2020-01-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 4,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"199284",
"Marel, van der (M.), Mikkers, Geert (G)",
"LELYSTAD",
"[email]",
"[telefoon]",
"1822482",
"Munt Hypotheken",
"Hypotheek",
"Munt Aflossingsvrije Hypotheek, Munt Annuïteiten Hypotheek, Munt Annuïteiten Hypotheek",
"Aflossingsvrij, Annuitair",
"Munt Annuïteiten Hypotheek",
"Annuitair",
"Eigen kantoor",
"Hypotheekadvies",
"2746171",
"TAF",
"Levensverzekering",
"TAF Special Overlijdensrisicoverzekering iptiQ - Annuitair",
"Overlijdensrisicoverzekering"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "199284",
"dossiernummer": "199284",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1891
{
"dossier_id": "db46b3e9-6a02-46b3-89d2-955f281ef755",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Kolodziej, Bob (BJ)",
"adres": "Rozengaard 11 38",
"email": "[email]",
"postcode": "8212 DB",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Sztura, Kamila (K)",
"adres": "Rozengaard 11 38",
"postcode": "8212 DB",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "207000.00",
"status": "Lopend",
"artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"maatschappij": "Lloyds Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "1873452",
"passeeringangsdatum": "2020-12-15"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-22"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2025-03-04"
},
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe Hypotheek/Doorstromer",
"tekendatum": "2020-06-18",
"productnaam": "Advies nieuwe Hypotheek/Doorstromer",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-18"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
"tekendatum": "25569",
"productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "GEWI.615920",
"passeeringangsdatum": "2017-01-01"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
"tekendatum": "25569",
"productnaam": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
"maatschappij": "TAF",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "2788667",
"passeeringangsdatum": "2020-12-01"
}
],
"crmdossier_id": "213781",
"dossiernummer": "213781",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1892
{
"dossier_id": "db46b3e9-6a02-46b3-89d2-955f281ef755",
"key": "base_import",
"value_json": {
"adres": "Rozengaard 11 38",
"klant": "Kolodziej, Bob (BJ), Sztura, Kamila (K)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8212 DB",
"products": [
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "207000.00",
"status": "Lopend",
"artikel": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"tekendatum": "25569",
"productnaam": "Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"maatschappij": "Lloyds Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "1873452",
"passeeringangsdatum": "2020-12-15"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-22"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2025-03-04"
},
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe Hypotheek/Doorstromer",
"tekendatum": "2020-06-18",
"productnaam": "Advies nieuwe Hypotheek/Doorstromer",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-18"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "GewoonIdee Nabestaandenverzekering - Annuitair",
"tekendatum": "25569",
"productnaam": "GewoonIdee Nabestaandenverzekering - Annuitair",
"maatschappij": "Dazure",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "GEWI.615920",
"passeeringangsdatum": "2017-01-01"
},
{
"norm": "",
"type": "Levensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
"tekendatum": "25569",
"productnaam": "TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair",
"maatschappij": "TAF",
"productsoort": "Annuitair Dalende Risicoverzekeringen",
"factuurbedrag": "",
"offertenummer": "2788667",
"passeeringangsdatum": "2020-12-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 6,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"213781",
"Kolodziej, Bob (BJ), Sztura, Kamila (K)",
"Rozengaard 11 38",
"8212 DB",
"Lelystad",
"[email]",
"[telefoon]",
"1873452",
"Lloyds Bank",
"Hypotheek",
"Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek, Lloyds Annuiteitenhypotheek",
"Annuitair",
"Eigen kantoor",
"Hypotheekadvies",
"Dienst",
"Advies nieuwe Hypotheek/Doorstromer",
"Dienst BTW vrij",
"GEWI.615920",
"Dazure",
"Levensverzekering",
"GewoonIdee Nabestaandenverzekering - Annuitair",
"Annuitair Dalende Risicoverzekeringen",
"2788667",
"TAF",
"TAF Personal Overlijdensrisicoverzekering Quantum - Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "213781",
"dossiernummer": "213781",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1893
{
"dossier_id": "ee0a6758-f99f-4562-ad38-c29bd212fade",
"key": "base_import",
"value_json": {
"adres": "Horst 29 42",
"klant": "Jonge, Hendrik Jan de (HJ)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8225 MV",
"products": [
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-05-28"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-05-28"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "149989.00",
"status": "Lopend",
"artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"tekendatum": "25569",
"productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"maatschappij": "Hypotrust",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3193518-01",
"passeeringangsdatum": "2020-06-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "149989.00",
"status": "Lopend",
"artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"tekendatum": "25569",
"productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"maatschappij": "Hypotrust",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3193518-01",
"passeeringangsdatum": "2020-06-01"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Cardif Aflos Verzekering",
"tekendatum": "25569",
"productnaam": "Cardif Aflos Verzekering",
"maatschappij": "Cardif",
"productsoort": "Woonlastenverzekering",
"factuurbedrag": "",
"offertenummer": "HAV00161466",
"passeeringangsdatum": "2020-06-01"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Cardif Aflos Verzekering",
"tekendatum": "25569",
"productnaam": "Cardif Aflos Verzekering",
"maatschappij": "Cardif",
"productsoort": "Woonlastenverzekering",
"factuurbedrag": "",
"offertenummer": "HAV00161466",
"passeeringangsdatum": "2020-06-01"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 6,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"212691",
"Jonge, Hendrik Jan de (HJ)",
"Horst 29 42",
"8225 MV",
"Lelystad",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Hypotheekadvies",
"3193518-01",
"Hypotrust",
"Hypotheek",
"Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"Annuitair",
"HAV00161466",
"Cardif",
"Inkomensverzekering",
"Cardif Aflos Verzekering",
"Woonlastenverzekering"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "212691",
"dossiernummer": "212691",
"dossierstatus": "Actief",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1894
{
"dossier_id": "bd1e37d6-6948-40ca-a38b-98902294907a",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Encarnacion Montas, Junior (J.)",
"adres": "Wijngaard 76",
"email": "[email]",
"postcode": "8212 CE",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Wijngaard 76",
"postcode": "8212 CE",
"woonplaats": "Lelystad"
},
"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": "2019-12-04"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "152382.00",
"status": "Lopend",
"artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"tekendatum": "25569",
"productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"maatschappij": "Hypotrust",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3148094-01",
"passeeringangsdatum": "2020-01-06"
}
],
"crmdossier_id": "200053",
"dossiernummer": "200053",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1895
{
"dossier_id": "bd1e37d6-6948-40ca-a38b-98902294907a",
"key": "base_import",
"value_json": {
"adres": "Wijngaard 76",
"klant": "Encarnacion Montas, Junior (J.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8212 CE",
"products": [
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2019-12-04"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "152382.00",
"status": "Lopend",
"artikel": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"tekendatum": "25569",
"productnaam": "Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"maatschappij": "Hypotrust",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3148094-01",
"passeeringangsdatum": "2020-01-06"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 2,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"200053",
"Encarnacion Montas, Junior (J.)",
"Wijngaard 76",
"8212 CE",
"Lelystad",
"[email]",
"[telefoon]",
"Eigen kantoor",
"Hypotheekadvies",
"3148094-01",
"Hypotrust",
"Hypotheek",
"Hypotrust Vrij Leven Annuïtair, Hypotrust Vrij Leven Annuïtair",
"Annuitair"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "200053",
"dossiernummer": "200053",
"dossierstatus": "Actief",
"email_partner": "",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1896
{
"dossier_id": "e6717098-2c09-41fb-852b-924dd7e33403",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Algera, Melanie (M)",
"adres": "Rijnland 26",
"email": "[email]",
"postcode": "8245 CV",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Nolles, Dennis (D)",
"adres": "Rijnland 26",
"postcode": "8245 CV",
"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": "2729759",
"passeeringangsdatum": "2019-11-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2019-09-07"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Maandlastbeschermer",
"tekendatum": "25569",
"productnaam": "Maandlastbeschermer",
"maatschappij": "TAF",
"productsoort": "Arbeidsongeschiktheidsverzekering",
"factuurbedrag": "",
"offertenummer": "40035633",
"passeeringangsdatum": "2019-11-01"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Maandlastbeschermer",
"tekendatum": "25569",
"productnaam": "Maandlastbeschermer",
"maatschappij": "TAF",
"productsoort": "Arbeidsongeschiktheidsverzekering",
"factuurbedrag": "",
"offertenummer": "40035631",
"passeeringangsdatum": "2019-11-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "246000.00",
"status": "Lopend",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2019-11-15"
}
],
"crmdossier_id": "200375",
"dossiernummer": "200375",
"dossierstatus": "Actief",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1897
{
"dossier_id": "e6717098-2c09-41fb-852b-924dd7e33403",
"key": "base_import",
"value_json": {
"adres": "Rijnland 26",
"klant": "Algera, Melanie (M), Nolles, Dennis (D)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8245 CV",
"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": "2729759",
"passeeringangsdatum": "2019-11-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Aanvraag nieuw",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2019-09-07"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Maandlastbeschermer",
"tekendatum": "25569",
"productnaam": "Maandlastbeschermer",
"maatschappij": "TAF",
"productsoort": "Arbeidsongeschiktheidsverzekering",
"factuurbedrag": "",
"offertenummer": "40035633",
"passeeringangsdatum": "2019-11-01"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Maandlastbeschermer",
"tekendatum": "25569",
"productnaam": "Maandlastbeschermer",
"maatschappij": "TAF",
"productsoort": "Arbeidsongeschiktheidsverzekering",
"factuurbedrag": "",
"offertenummer": "40035631",
"passeeringangsdatum": "2019-11-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "246000.00",
"status": "Lopend",
"artikel": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"tekendatum": "25569",
"productnaam": "ING Annuiteitenhypotheek (Reguliere hypotheek)",
"maatschappij": "ING Bank",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "*********",
"passeeringangsdatum": "2019-11-15"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 5,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"200375",
"Algera, Melanie (M), Nolles, Dennis (D)",
"Rijnland 26",
"8245 CV",
"Lelystad",
"[email]",
"[telefoon]",
"2729759",
"TAF",
"Levensverzekering",
"Credit Life International Overlijdensrisicoverzekering - Annuitair",
"Overlijdensrisicoverzekering",
"Eigen kantoor",
"Hypotheekadvies",
"40035633",
"Inkomensverzekering",
"Maandlastbeschermer",
"Arbeidsongeschiktheidsverzekering",
"40035631",
"*********",
"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": "200375",
"dossiernummer": "200375",
"dossierstatus": "Actief",
"email_partner": "[email]",
"telefoonnummer": "[telefoon]",
"email_aanvrager": "[email]"
},
"updated_at": 1778230486535
}Rij 1898
{
"dossier_id": "21f82986-03d9-4fa3-94a5-61d4f72a95dd",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Burer, Jeffrey (J)",
"adres": "Punter 39 43",
"email": "[email]",
"postcode": "8242 EW",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"naam": "Verbeek, Claudia (C.)",
"adres": "Punter 39 43",
"postcode": "8242 EW",
"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": "2757921",
"passeeringangsdatum": "2020-03-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "191264.00",
"status": "Lopend",
"artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
"tekendatum": "25569",
"productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
"maatschappij": "Hypotrust",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3159460-01",
"passeeringangsdatum": "2020-07-03"
},
{
"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-06-01"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Cardif Aflos Verzekering",
"tekendatum": "25569",
"productnaam": "Cardif Aflos Verzekering",
"maatschappij": "Cardif",
"productsoort": "Woonlastenverzekering",
"factuurbedrag": "",
"offertenummer": "HAV00160709",
"passeeringangsdatum": "2020-06-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-02-07"
}
],
"crmdossier_id": "207925",
"dossiernummer": "207925",
"dossierstatus": "Geroyeerd",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1899
{
"dossier_id": "10b2c088-2130-49cd-ad7c-5a36b134e1b4",
"key": "inventarisatie",
"value_json": {
"a1": {
"naam": "Kalloe (S.)",
"adres": "Kempenaar 01 16",
"email": "[email]",
"postcode": "8242 BA",
"woonplaats": "Lelystad",
"telefoon_prive": "[telefoon]"
},
"a2": {
"adres": "Kempenaar 01 16",
"postcode": "8242 BA",
"woonplaats": "Lelystad"
},
"data": {
"adviseur": "Zwarthoff, Rogier (R.D.)",
"deelnemer": "Uw Hypotheek",
"producten": [
{
"norm": "",
"type": "Dienst",
"inhoud": "0.00",
"status": "Nieuw adviestraject",
"artikel": "Advies nieuwe Hypotheek/Doorstromer",
"tekendatum": "2020-06-12",
"productnaam": "Advies nieuwe Hypotheek/Doorstromer",
"maatschappij": "Eigen kantoor",
"productsoort": "Dienst BTW vrij",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-06-12"
}
],
"crmdossier_id": "213447",
"dossiernummer": "213447",
"dossierstatus": "Vervallen",
"producten_bron": "Excel klantenoverzicht"
}
},
"updated_at": 1778230486535
}Rij 1900
{
"dossier_id": "21f82986-03d9-4fa3-94a5-61d4f72a95dd",
"key": "base_import",
"value_json": {
"adres": "Punter 39 43",
"klant": "Burer, Jeffrey (J), Verbeek, Claudia (C.)",
"plaats": "Lelystad",
"source": "excel_klantenoverzicht",
"adviseur": "Zwarthoff, Rogier (R.D.)",
"postcode": "8242 EW",
"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": "2757921",
"passeeringangsdatum": "2020-03-01"
},
{
"norm": "NHG",
"type": "Hypotheek",
"inhoud": "191264.00",
"status": "Lopend",
"artikel": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
"tekendatum": "25569",
"productnaam": "Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
"maatschappij": "Hypotrust",
"productsoort": "Annuitair",
"factuurbedrag": "",
"offertenummer": "3159460-01",
"passeeringangsdatum": "2020-07-03"
},
{
"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-06-01"
},
{
"norm": "",
"type": "Inkomensverzekering",
"inhoud": "0.00",
"status": "Lopend",
"artikel": "Cardif Aflos Verzekering",
"tekendatum": "25569",
"productnaam": "Cardif Aflos Verzekering",
"maatschappij": "Cardif",
"productsoort": "Woonlastenverzekering",
"factuurbedrag": "",
"offertenummer": "HAV00160709",
"passeeringangsdatum": "2020-06-01"
},
{
"norm": "",
"type": "Hypotheekadvies",
"inhoud": "0.00",
"status": "Akkoord",
"artikel": "",
"tekendatum": "25569",
"productnaam": "",
"maatschappij": "Eigen kantoor",
"productsoort": "",
"factuurbedrag": "",
"offertenummer": "",
"passeeringangsdatum": "2020-02-07"
}
],
"deelnemer": "Uw Hypotheek",
"row_count": 5,
"imported_at": "2026-05-08T08:54:46.535Z",
"match_terms": [
"207925",
"Burer, Jeffrey (J), Verbeek, Claudia (C.)",
"Punter 39 43",
"8242 EW",
"Lelystad",
"[email]",
"[telefoon]",
"2757921",
"TAF",
"Levensverzekering",
"Credit Life International Overlijdensrisicoverzekering - Annuitair",
"Overlijdensrisicoverzekering",
"3159460-01",
"Hypotrust",
"Hypotheek",
"Hypotrust Annuiteit (Woon Bewust), Hypotrust Annuiteit (Woon Bewust)",
"Annuitair",
"5369PK-*********",
"Risk Assuradeuren",
"Schadeverzekering",
"Opstal, Inboedel, Aansprakelijkheid",
"Aansprakelijkheid, Inboedel, Opstal",
"HAV00160709",
"Cardif",
"Inkomensverzekering",
"Cardif Aflos Verzekering",
"Woonlastenverzekering",
"Eigen kantoor",
"Hypotheekadvies"
],
"source_file": "C:\\Users\\rdzwa\\OneDrive\\PC-Rogier\\Tools\\Adviestool\\_202113668_Klantenoverzicht_incl_Producten.xlsx",
"crmdossier_id": "207925",
"dossiernummer": "207925",
"dossierstatus": "Geroyeerd",
"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) |