Controlpanel / Database

Database Explorer

Read-only SQL/JSON werkbank. Open een databron, kies een tabel, zoek in echte rijen en inspecteer data als ruwe JSON. Geen vrije SQL, geen writes, geen export.

6 bronnen66 tabellen/stores257.157 rijen/items22 domeincontainers

Zoeken

Tabelzoeker zoekt in de gekozen tabel; dossierzoeker zoekt klant/dossierlocaties over bekende dossierstores.

Rijen: postgres-main.dossier_data

Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.

Read-only query

WITH _statement_timeout AS (SELECT set_config('statement_timeout', '1500ms', true)) SELECT t.* FROM public."dossier_data" t CROSS JOIN _statement_timeout ORDER BY updated_at DESC LIMIT 50 OFFSET 500

50 matchende rijen · offset 500 · limiet 50Vorige Volgende

dossier_id	key	value_json	updated_at
18811837-d6ad-454e-8bc2-8f72c0c5304b	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-24T03:21:22.082Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1779592882083
18811837-d6ad-454e-8bc2-8f72c0c5304b	inventarisatie	{ "a1": { "naam": "Jan Testkoper", "adres": "Teststraat 12, 1234 AB Teststad", "straat": "Teststraat", "geslacht": "Man", "postcode": "1234 AB", "huisnummer": "12", "woonplaats": "Teststad", "geboortedatum": "01-01-1990", "nationaliteit": "Nederlandse", "telefoon_prive": "0612345678", "burgerlijke_staat": "Ongehuwd" }, "a2": {}, "data": { "maatschappij": "Uw Zekerheid B.V.", "aanvraag_door": "Hermes E2E", "onderpand_adres": "Kooplaan", "onderpand_huisnummer": "5" } }	1779592046016
2f118f6f-05da-462f-8d39-dd947dbdb1fd	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-05-23T15:22:01.740Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1779549721740
5b3c09e6-81cf-4545-a5cc-db66772bb285	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-05-23T15:22:01.729Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1779549721730
5b3c09e6-81cf-4545-a5cc-db66772bb285	_sources	{}	1779549721144
5b3c09e6-81cf-4545-a5cc-db66772bb285	inventarisatie	{ "a1": { "naam": "Mollink, Raymon (R.L.)", "adres": "Zandbank 71", "email": "r.l.mollink@outlook.com", "postcode": "8224 ZD", "woonplaats": "Lelystad", "telefoon_prive": "0611298544" }, "a2": { "naam": "Schut, Michelle (M)", "adres": "Zandbank 71", "postcode": "8224 ZD", "woonplaats": "Lelystad" }, "data": { "adviseur": "Zwarthoff, Rogier (R.D.)", "deelnemer": "Uw Hypotheek", "producten": [ { "norm": "NHG", "type": "Hypotheek", "inhoud": "22896.00", "status": "Gepasseerd", "artikel": "Starterslening", "tekendatum": "25569", "productnaam": "Starterslening", "maatschappij": "SVn", "productsoort": "Annuitair", "factuurbedrag": "", "offertenummer": "238.626.000", "passeeringangsdatum": "2017-05-02" }, { "norm": "", "type": "Schadeverzekering", "inhoud": "0.00", "status": "Aanvraag nieuw", "artikel": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren", "tekendatum": "25569", "productnaam": "Woonhuisverzekering, Inboedelverzekering, Aansprakelijkheidsverzekering Particulieren, Rechtsbijstand voor Particulieren", "maatschappij": "Voogd & Voo ... [afgekapt: 1333 tekens]	1779549721121
test-queue-dossier-1	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-05-22T09:25:44.958Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1779441944959
b1a25305-031f-4c74-9fa3-58038271ce95	financieringsopzet	{ "activeId": "d9d7e30f-599a-4f10-a0b5-c0d0877678b8", "voorstellen": [ { "id": "d9d7e30f-599a-4f10-a0b5-c0d0877678b8", "naam": "Voorstel 1", "kosten": { "koopsom": "100000", "taxatie": "", "kadaster": "", "meerwerk": "", "boeterente": "", "verbouwing": "", "bankgarantie": "", "nhgBorgtocht": "", "overigKosten": "", "roerendeZaken": "", "aankoopmakelaar": "", "hypotheekadvies": "", "aflossingBestaand": "", "bouwkundigeKeuring": "", "notarisHypotheekakte": "", "notarisLeveringsakte": "", "overdrachtsbelasting": "" }, "status": "selected", "notitie": "", "leningdelen": [ { "id": "b492e459-59ba-4033-b64f-fc08d7424565", "box": "1", "nhg": "Nee", "rente": "4,01", "hoofdsom": "100.000", "aflosvorm": "Annuiteit", "looptijdJaren": "30", "brutoMaandlast": "€ 478", "rentevastJaren": "10", "geldverstrekker": "" } ], "financiering": { "bouwdepot": "", "schenking": "", "hypotheek1": "", "hypotheek2": "", "eigenMiddelen": "", "verkoopopbrengst": "", "overigFinanciering": "", "overbrug ... [afgekapt: 2880 tekens]	1778842982152
b1a25305-031f-4c74-9fa3-58038271ce95	berekeningen_v1	{ "version": 1, "updatedAt": "2026-05-15T11:02:51.570Z", "calculations": [ { "id": "calc-aankoop-bestaande-bouw-live", "title": "Aankoop bestaande bouw", "source": "manual", "status": "draft", "purpose": "aankoop_bestaande_bouw", "summary": "Live smoke: geselecteerd voorstel onder actieve berekening.", "createdAt": "2026-05-12T16:39:40.990Z", "dossierId": "b1a25305-031f-4c74-9fa3-58038271ce95", "updatedAt": "2026-05-15T11:02:51.570Z", "proposalIds": [ "d968f0a6-cab5-4d21-85d5-7de44878eafb", "98ac57b1-baea-4fe2-a642-bd4897c74235", "d9d7e30f-599a-4f10-a0b5-c0d0877678b8" ], "applicantScope": "joint", "selectedProposalId": "d9d7e30f-599a-4f10-a0b5-c0d0877678b8" } ], "activeCalculationId": "calc-aankoop-bestaande-bouw-live" }	1778842971570
b1a25305-031f-4c74-9fa3-58038271ce95	aanvraagproces-stukken	{ "log": [ { "at": "2026-05-12T08:19:50.84Z", "result": "DVO gekoppeld aan stuk bb4fb349-2a5c-412a-9209-653f4436d186", "command": "generate dvo" }, { "at": "2026-05-12T08:16:13.095Z", "result": "DVO gekoppeld aan stuk bb4fb349-2a5c-412a-9209-653f4436d186", "command": "generate dvo" }, { "at": "2026-05-10T11:32:57.603Z", "result": "+11 stukken, 18 bestand(en) gekoppeld", "command": "auto-detect" } ], "stukken": [ { "id": "bb4fb349-2a5c-412a-9209-653f4436d186", "type": "overig", "label": "Dienstverleningsovereenkomst (DVO)", "status": "ontvangen", "fileIds": [ "28b15d5f-5609-431e-adf2-148b34a95f99" ], "history": [ { "at": "2026-05-12T08:19:50.84Z", "who": "auto", "status": "ontvangen", "notitie": "DVO gegenereerd vanuit Stukkenlijst." }, { "at": "2026-05-12T08:16:13.095Z", "who": "auto", "status": "ontvangen", "notitie": "DVO gegenereerd vanuit Stukkenlijst." } ], "notitie": "Standaarddocument: dienstverleningsovereenkomst.", "pairKey": "standaard-dvo", "persoon": "joint", "required": true, "createdAt": "2026-05-12T08:16:13.095Z", "bevindingen": [], ... [afgekapt: 10545 tekens]	1778755522317
b1a25305-031f-4c74-9fa3-58038271ce95	orv	{ "eerste": { "leeftijd": "42", "inkomenNu": "", "inkomenPensioen": "", "percentageWerken": "", "inkomenTussentijds": "" }, "tweede": { "leeftijd": "", "inkomenNu": "", "inkomenPensioen": "", "percentageWerken": "", "inkomenTussentijds": "" }, "polissen": [ { "id": "polis-f2825c95-bbf1-4cec-b122-2ff80cfdf2ad", "roker": false, "soort": "Gelijkblijvend", "status": "bestaand", "verpand": false, "einddatum": "", "verzekerde": "A1", "polisnummer": "", "productnaam": "Bestaande ORV", "toelichting": "", "begunstiging": "Partner / kinderen / erfgenamen", "ingangsdatum": "", "looptijdJaar": "30", "maatschappij": "", "premiePerMaand": "", "verzekerdKapitaal": "" } ], "maandlast": "", "relatievorm": "", "kinderenLeeftijd": "", "hoofdsomHypotheek": "", "acceptatieprobleem": "", "bestaandeOrvNabestaande": "" }	1778754916028
d1d96ea8-3a18-41f4-ae78-8e24c0cce484	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-05-13T12:41:06.218Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778676066218
d1d96ea8-3a18-41f4-ae78-8e24c0cce484	aanvraagproces-stukken	{ "log": [ { "at": "2026-05-13T12:41:03.697Z", "result": "+11 stukken, 0 bestand(en) gekoppeld", "command": "auto-detect" } ], "stukken": [ { "id": "8fda633b-8c1f-405e-9c57-329334da8c8c", "type": "id_bewijs", "label": "Legitimatiebewijs aanvrager 1", "status": "aan_te_leveren", "fileIds": [], "history": [], "notitie": "", "persoon": "a1", "required": true, "createdAt": "2026-05-13T12:41:03.697Z", "bevindingen": [], "documentLinks": [] }, { "id": "ea570be0-ad8e-4414-84dc-ca29634bb78d", "type": "id_bewijs", "label": "Legitimatiebewijs aanvrager 2", "status": "aan_te_leveren", "fileIds": [], "history": [], "notitie": "", "persoon": "a2", "required": true, "createdAt": "2026-05-13T12:41:03.697Z", "bevindingen": [], "documentLinks": [] }, { "id": "370f9f27-15ac-4ee4-a6bd-312cac2e8235", "type": "werkgeversverklaring", "label": "Werkgeversverklaring A1", "status": "aan_te_leveren", "fileIds": [], "history": [], "notitie": "", "pairKey": "income-a1", "persoon": "a1", "required": true, "createdAt": "2026-05-13T12:41:03.697Z", "bevindingen": [], "documentLinks": [] }, { ... [afgekapt: 3105 tekens]	1778676063698
b1a25305-031f-4c74-9fa3-58038271ce95	aov	{ "producten": [] }	1778669623017
dde8f934-dafd-4776-8342-d0d37cf72252	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-05-12T11:43:51.750Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778586231751
dde8f934-dafd-4776-8342-d0d37cf72252	_sources	{ "inventarisatie.a1": { "source": "Eigen invoer", "updated_at": "2026-05-09T19:48:44.431Z" }, "inventarisatie.a2": { "source": "Eigen invoer", "updated_at": "2026-05-09T19:48:44.431Z" }, "inventarisatie.data": { "source": "Eigen invoer", "updated_at": "2026-05-09T19:48:44.431Z" }, "inventarisatie.inc1": { "source": "Eigen invoer", "updated_at": "2026-05-12T11:43:50.111Z" }, "inventarisatie.inc2": { "source": "Eigen invoer", "updated_at": "2026-05-12T11:43:50.111Z" }, "inventarisatie.products": { "source": "Eigen invoer", "updated_at": "2026-05-12T11:43:50.111Z" } }	1778586230149
dde8f934-dafd-4776-8342-d0d37cf72252	inventarisatie	{ "a1": {}, "a2": {}, "data": {}, "products": { "pensioen": { "aow-standaard": { "id": "aow-standaard", "type": "aow", "Anv_Id": "Beide", "Pen_In_OP": true, "Aow_Om_Bron": "Standaard aanname: vanaf 18e in Nederland", "source_kind": "standaard", "Pen_Cd_Soort": "AOW", "Pen_Om_Fonds": "Sociale Verzekeringsbank", "Aow_Pc_Opbouw": "100", "Aow_Cd_Leefsituatie": "Nog bepalen", "Aow_Buitenland_Jaren": "0", "Aow_In_NederlandSinds18": true } } } }	1778586230111
b1a25305-031f-4c74-9fa3-58038271ce95	workflow_v1	{ "flags": [], "actions": [ { "type": "intent_classification_pending" } ], "lastDerived": { "at": "2026-05-12T08:16:16.084Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778573776085
b1a25305-031f-4c74-9fa3-58038271ce95	klantprofiel	{ "woonduur": "10 jaar", "ww_wensen": [ "Niets verzekeren" ], "aanleiding": [ "Aankoop bestaande woning" ], "aov_wensen": [ "Inkomensaanvulling" ], "aov_periode": "Minstens 10 jaar", "verduurzaming": "Nee", "aflossingsvorm": "Annuïtair", "aov_motivering": "€ 45.000 nog over uit een erfenis na overdracht", "aov_verzekeren": "Zeer beperkt", "grote_uitgaven": "Nee", "rentevast_wens": "6 tot 10 jaar", "productvoorkeur": "Minder risico/veilig rendement", "wijziging_gezin": "Nee", "hypotheek_doelen": [ "Woning kopen", "Stabiele maandlasten lange periode" ], "financiele_doelen": [ "Zekerheid van voldoende inkomsten in alle situaties" ], "hypotheek_koopsom": "€ 401.000", "overlijden_wensen": [ "Partner verzorgd achterlaten" ], "risico_acceptatie": "Gokje mag, geen grote risico's", "verantwoord_lenen": "NHG", "ww_inkomensniveau": "Niet van toepassing", "ww_wensen_partner": [ "Niets verzekeren" ], "aov_inkomensniveau": "90%", "aov_wensen_partner": [ "Inkomensaanvulling" ], "inbreng_eigen_geld": "Verlagen hypotheek", "overlijden_periode": "Tijdelijk", "fiscale_aftrek_wens": "Consumptieve besteding meefinancieren", "uitgaven_bijstellen": "Besparen op levensonderhoud", "wijziging_werkgever": "Nee", "ww_wensen_aanvrager": [ "Niets verzekeren" ... [afgekapt: 689 tekens]	1778511166644
supplier-woonfonds-hypotheken	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.201Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859202
supplier-sns-bank	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.198Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859198
supplier-regiobank	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.194Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859194
supplier-philips-pensioenfonds	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.190Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859191
supplier-orange-credit	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.186Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859187
supplier-onderlinge-nederland	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.183Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859183
supplier-neo-hypotheken	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.179Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859179
supplier-iqwoon	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.175Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859176
supplier-hq-hypotheken	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.171Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859172
supplier-groene-hart-hypotheken	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.167Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859168
supplier-dynamic-hypotheken	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.163Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859164
supplier-dynamic-credit	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.160Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859160
supplier-colibri-hypotheken	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.156Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859156
supplier-clarian-wonen	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.152Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859153
supplier-bnp-paribas-personal-finance	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.148Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859149
supplier-blg-hypotheken	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.145Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859145
supplier-crystal-marbles	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.141Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859141
supplier-stater	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.137Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859137
supplier-taxatheek	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.133Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859134
supplier-nrvt	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.129Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859130
supplier-nwwi	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.126Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859126
supplier-uw-garantiestelling	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.122Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859122
supplier-nationale-waarborg	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.118Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859119
supplier-ingage-aetos	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.114Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859115
supplier-woonnu	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.111Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859111
supplier-vista	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.107Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859107
supplier-venn	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.103Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859103
supplier-vandaag-hypotheken	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.099Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859100
supplier-tulp-hypotheken	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.095Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859096
supplier-triodos	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.092Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859092
supplier-syntrus-achmea	workflow_v1	{ "flags": [], "actions": [], "lastDerived": { "at": "2026-05-10T12:07:39.088Z", "phase": "F00_lead" }, "uitvraagReminders": [] }	1778414859088

Raw JSON details

Rij 501

{
  "dossier_id": "18811837-d6ad-454e-8bc2-8f72c0c5304b",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-24T03:21:22.082Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1779592882083
}

Rij 502

{
  "dossier_id": "18811837-d6ad-454e-8bc2-8f72c0c5304b",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Jan Testkoper",
      "adres": "Teststraat 12, 1234 AB Teststad",
      "straat": "Teststraat",
      "geslacht": "Man",
      "postcode": "1234 AB",
      "huisnummer": "12",
      "woonplaats": "Teststad",
      "geboortedatum": "01-01-1990",
      "nationaliteit": "Nederlandse",
      "telefoon_prive": "0612345678",
      "burgerlijke_staat": "Ongehuwd"
    },
    "a2": {},
    "data": {
      "maatschappij": "Uw Zekerheid B.V.",
      "aanvraag_door": "Hermes E2E",
      "onderpand_adres": "Kooplaan",
      "onderpand_huisnummer": "5"
    }
  },
  "updated_at": 1779592046016
}

Rij 503

{
  "dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-05-23T15:22:01.740Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1779549721740
}

Rij 504

{
  "dossier_id": "5b3c09e6-81cf-4545-a5cc-db66772bb285",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-05-23T15:22:01.729Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1779549721730
}

Rij 505

{
  "dossier_id": "5b3c09e6-81cf-4545-a5cc-db66772bb285",
  "key": "_sources",
  "value_json": {},
  "updated_at": 1779549721144
}

Rij 506

{
  "dossier_id": "5b3c09e6-81cf-4545-a5cc-db66772bb285",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Mollink, Raymon (R.L.)",
      "adres": "Zandbank 71",
      "email": "r.l.mollink@outlook.com",
      "postcode": "8224 ZD",
      "woonplaats": "Lelystad",
      "telefoon_prive": "0611298544"
    },
    "a2": {
      "naam": "Schut, Michelle (M)",
      "adres": "Zandbank 71",
      "postcode": "8224 ZD",
      "woonplaats": "Lelystad"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "22896.00",
          "status": "Gepasseerd",
          "artikel": "Starterslening",
          "tekendatum": "25569",
          "productnaam": "Starterslening",
          "maatschappij": "SVn",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "238.626.000",
          "passeeringangsdatum": "2017-05-02"
        },
        {
          "norm": "",
          "type": "Schadeverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "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": "156130805385",
          "passeeringangsdatum": "2017-05-02"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "91300.00",
          "status": "Gepasseerd",
          "artikel": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "tekendatum": "25569",
          "productnaam": "Obvion Annuïteitenhypotheek (Obvion Compact Hypotheek)",
          "maatschappij": "Obvion",
          "productsoort": "Annuitair",
          "factuurbedrag": "",
          "offertenummer": "562.169",
          "passeeringangsdatum": "2017-05-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.616678",
          "passeeringangsdatum": "2017-03-01"
        }
      ],
      "crmdossier_id": "133886",
      "dossiernummer": "133886",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht"
    }
  },
  "updated_at": 1779549721121
}

Rij 507

{
  "dossier_id": "test-queue-dossier-1",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-05-22T09:25:44.958Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1779441944959
}

Rij 508

{
  "dossier_id": "b1a25305-031f-4c74-9fa3-58038271ce95",
  "key": "financieringsopzet",
  "value_json": {
    "activeId": "d9d7e30f-599a-4f10-a0b5-c0d0877678b8",
    "voorstellen": [
      {
        "id": "d9d7e30f-599a-4f10-a0b5-c0d0877678b8",
        "naam": "Voorstel 1",
        "kosten": {
          "koopsom": "100000",
          "taxatie": "",
          "kadaster": "",
          "meerwerk": "",
          "boeterente": "",
          "verbouwing": "",
          "bankgarantie": "",
          "nhgBorgtocht": "",
          "overigKosten": "",
          "roerendeZaken": "",
          "aankoopmakelaar": "",
          "hypotheekadvies": "",
          "aflossingBestaand": "",
          "bouwkundigeKeuring": "",
          "notarisHypotheekakte": "",
          "notarisLeveringsakte": "",
          "overdrachtsbelasting": ""
        },
        "status": "selected",
        "notitie": "",
        "leningdelen": [
          {
            "id": "b492e459-59ba-4033-b64f-fc08d7424565",
            "box": "1",
            "nhg": "Nee",
            "rente": "4,01",
            "hoofdsom": "100.000",
            "aflosvorm": "Annuiteit",
            "looptijdJaren": "30",
            "brutoMaandlast": "€ 478",
            "rentevastJaren": "10",
            "geldverstrekker": ""
          }
        ],
        "financiering": {
          "bouwdepot": "",
          "schenking": "",
          "hypotheek1": "",
          "hypotheek2": "",
          "eigenMiddelen": "",
          "verkoopopbrengst": "",
          "overigFinanciering": "",
          "overbruggingskrediet": ""
        },
        "selectedProductCodes": [
          "hypotheek"
        ]
      },
      {
        "id": "d968f0a6-cab5-4d21-85d5-7de44878eafb",
        "naam": "Voorstel 2",
        "kosten": {
          "koopsom": "100000",
          "taxatie": "",
          "kadaster": "",
          "meerwerk": "",
          "boeterente": "",
          "verbouwing": "",
          "bankgarantie": "",
          "nhgBorgtocht": "",
          "overigKosten": "",
          "roerendeZaken": "",
          "aankoopmakelaar": "",
          "hypotheekadvies": "",
          "aflossingBestaand": "",
          "bouwkundigeKeuring": "",
          "notarisHypotheekakte": "",
          "notarisLeveringsakte": "",
          "overdrachtsbelasting": ""
        },
        "status": "draft",
        "notitie": "",
        "leningdelen": [
          {
            "id": "8a995875-398f-47e7-b5ed-e3097e01d668",
            "box": "1",
            "nhg": "Nee",
            "rente": "4,01",
            "hoofdsom": "100.000",
            "aflosvorm": "Annuiteit",
            "looptijdJaren": "30",
            "brutoMaandlast": "€ 478",
            "rentevastJaren": "10",
            "geldverstrekker": ""
          }
        ],
        "financiering": {
          "bouwdepot": "",
          "schenking": "",
          "hypotheek1": "",
          "hypotheek2": "",
          "eigenMiddelen": "",
          "verkoopopbrengst": "",
          "overigFinanciering": "",
          "overbruggingskrediet": ""
        },
        "selectedProductCodes": [
          "hypotheek"
        ]
      },
      {
        "id": "98ac57b1-baea-4fe2-a642-bd4897c74235",
        "naam": "Voorstel 3",
        "kosten": {
          "koopsom": "100000",
          "taxatie": "",
          "kadaster": "",
          "meerwerk": "",
          "boeterente": "",
          "verbouwing": "",
          "bankgarantie": "",
          "nhgBorgtocht": "",
          "overigKosten": "",
          "roerendeZaken": "",
          "aankoopmakelaar": "",
          "hypotheekadvies": "",
          "aflossingBestaand": "",
          "bouwkundigeKeuring": "",
          "notarisHypotheekakte": "",
          "notarisLeveringsakte": "",
          "overdrachtsbelasting": ""
        },
        "status": "draft",
        "notitie": "",
        "leningdelen": [
          {
            "id": "80396f67-78c4-4a00-b4b5-307c7a2cd654",
            "box": "1",
            "nhg": "Nee",
            "rente": "4,01",
            "hoofdsom": "100.000",
            "aflosvorm": "Annuiteit",
            "looptijdJaren": "30",
            "brutoMaandlast": "€ 478",
            "rentevastJaren": "10",
            "geldverstrekker": ""
          }
        ],
        "financiering": {
          "bouwdepot": "",
          "schenking": "",
          "hypotheek1": "",
          "hypotheek2": "",
          "eigenMiddelen": "",
          "verkoopopbrengst": "",
          "overigFinanciering": "",
          "overbruggingskrediet": ""
        },
        "selectedProductCodes": [
          "hypotheek"
        ]
      }
    ],
    "selectedProposalId": "d9d7e30f-599a-4f10-a0b5-c0d0877678b8"
  },
  "updated_at": 1778842982152
}

Rij 509

{
  "dossier_id": "b1a25305-031f-4c74-9fa3-58038271ce95",
  "key": "berekeningen_v1",
  "value_json": {
    "version": 1,
    "updatedAt": "2026-05-15T11:02:51.570Z",
    "calculations": [
      {
        "id": "calc-aankoop-bestaande-bouw-live",
        "title": "Aankoop bestaande bouw",
        "source": "manual",
        "status": "draft",
        "purpose": "aankoop_bestaande_bouw",
        "summary": "Live smoke: geselecteerd voorstel onder actieve berekening.",
        "createdAt": "2026-05-12T16:39:40.990Z",
        "dossierId": "b1a25305-031f-4c74-9fa3-58038271ce95",
        "updatedAt": "2026-05-15T11:02:51.570Z",
        "proposalIds": [
          "d968f0a6-cab5-4d21-85d5-7de44878eafb",
          "98ac57b1-baea-4fe2-a642-bd4897c74235",
          "d9d7e30f-599a-4f10-a0b5-c0d0877678b8"
        ],
        "applicantScope": "joint",
        "selectedProposalId": "d9d7e30f-599a-4f10-a0b5-c0d0877678b8"
      }
    ],
    "activeCalculationId": "calc-aankoop-bestaande-bouw-live"
  },
  "updated_at": 1778842971570
}

Rij 510

{
  "dossier_id": "b1a25305-031f-4c74-9fa3-58038271ce95",
  "key": "aanvraagproces-stukken",
  "value_json": {
    "log": [
      {
        "at": "2026-05-12T08:19:50.84Z",
        "result": "DVO gekoppeld aan stuk bb4fb349-2a5c-412a-9209-653f4436d186",
        "command": "generate dvo"
      },
      {
        "at": "2026-05-12T08:16:13.095Z",
        "result": "DVO gekoppeld aan stuk bb4fb349-2a5c-412a-9209-653f4436d186",
        "command": "generate dvo"
      },
      {
        "at": "2026-05-10T11:32:57.603Z",
        "result": "+11 stukken, 18 bestand(en) gekoppeld",
        "command": "auto-detect"
      }
    ],
    "stukken": [
      {
        "id": "bb4fb349-2a5c-412a-9209-653f4436d186",
        "type": "overig",
        "label": "Dienstverleningsovereenkomst (DVO)",
        "status": "ontvangen",
        "fileIds": [
          "28b15d5f-5609-431e-adf2-148b34a95f99"
        ],
        "history": [
          {
            "at": "2026-05-12T08:19:50.84Z",
            "who": "auto",
            "status": "ontvangen",
            "notitie": "DVO gegenereerd vanuit Stukkenlijst."
          },
          {
            "at": "2026-05-12T08:16:13.095Z",
            "who": "auto",
            "status": "ontvangen",
            "notitie": "DVO gegenereerd vanuit Stukkenlijst."
          }
        ],
        "notitie": "Standaarddocument: dienstverleningsovereenkomst.",
        "pairKey": "standaard-dvo",
        "persoon": "joint",
        "required": true,
        "createdAt": "2026-05-12T08:16:13.095Z",
        "bevindingen": [],
        "documentLinks": [
          {
            "role": "primary",
            "fileId": "28b15d5f-5609-431e-adf2-148b34a95f99",
            "linkedAt": "2026-05-12T08:16:13.095Z",
            "linkedBy": "auto",
            "matchReason": "legacy-fileIds"
          }
        ]
      },
      {
        "id": "55adfefb-72b0-4864-8b17-3944011f42ac",
        "type": "id_bewijs",
        "label": "Legitimatiebewijs aanvrager 1",
        "status": "ontvangen",
        "fileIds": [
          "9b23c59c-13ce-4c3b-a17f-73263687f975",
          "fc2b4c8a-a308-44d6-b622-2f7d0e3f8b7e"
        ],
        "history": [
          {
            "at": "2026-05-10T11:32:57.603Z",
            "who": "auto",
            "status": "ontvangen"
          }
        ],
        "notitie": "",
        "persoon": "a1",
        "required": true,
        "createdAt": "2026-05-10T11:32:57.603Z",
        "bevindingen": [],
        "documentLinks": [
          {
            "role": "primary",
            "fileId": "9b23c59c-13ce-4c3b-a17f-73263687f975",
            "linkedAt": "2026-05-10T11:32:57.603Z",
            "linkedBy": "auto",
            "matchReason": "legacy-fileIds"
          },
          {
            "role": "primary",
            "fileId": "fc2b4c8a-a308-44d6-b622-2f7d0e3f8b7e",
            "linkedAt": "2026-05-10T11:32:57.603Z",
            "linkedBy": "auto",
            "matchReason": "legacy-fileIds"
          }
        ]
      },
      {
        "id": "4f8b4fe2-878a-4de3-933e-53adcb1fd95f",
        "type": "id_bewijs",
        "label": "Legitimatiebewijs aanvrager 2",
        "status": "ontvangen",
        "fileIds": [
          "d47ad2fd-6e4a-49b6-9360-d2c6b396023e"
        ],
        "history": [
          {
            "at": "2026-05-10T11:32:57.603Z",
            "who": "auto",
            "status": "ontvangen"
          }
        ],
        "notitie": "",
        "persoon": "a2",
        "required": true,
        "createdAt": "2026-05-10T11:32:57.603Z",
        "bevindingen": [],
        "documentLinks": [
          {
            "role": "primary",
            "fileId": "d47ad2fd-6e4a-49b6-9360-d2c6b396023e",
            "linkedAt": "2026-05-10T11:32:57.603Z",
            "linkedBy": "auto",
            "matchReason": "legacy-fileIds"
          }
        ]
      },
      {
        "id": "e83ca7a1-53d6-4c7a-9de9-ce0ad953dab2",
        "type": "werkgeversverklaring",
        "label": "Werkgeversverklaring A1",
        "status": "ontvangen",
        "fileIds": [
          "db2bfff1-a4bf-4654-908a-11f3440f163f",
          "1682e484-f902-43f6-9cdd-6d33cb9fe3cc"
        ],
        "history": [
          {
            "at": "2026-05-10T11:32:57.603Z",
            "who": "auto",
            "status": "ontvangen"
          }
        ],
        "notitie": "",
        "pairKey": "income-a1",
        "persoon": "a1",
        "required": true,
        "createdAt": "2026-05-10T11:32:57.603Z",
        "bevindingen": [],
        "documentLinks": [
          {
            "role": "primary",
            "fileId": "db2bfff1-a4bf-4654-908a-11f3440f163f",
            "linkedAt": "2026-05-10T11:32:57.603Z",
            "linkedBy": "auto",
            "matchReason": "legacy-fileIds"
          },
          {
            "role": "primary",
            "fileId": "1682e484-f902-43f6-9cdd-6d33cb9fe3cc",
            "linkedAt": "2026-05-10T11:32:57.603Z",
            "linkedBy": "auto",
            "matchReason": "legacy-fileIds"
          }
        ]
      },
      {
        "id": "689dfaa0-11a1-4f1f-a812-aac8b2c5e34b",
        "type": "salarisstrook",
        "label": "Salarisstrook A1",
        "status": "ontvangen",
        "fileIds": [
          "2255af5e-4f59-42b5-a948-b9e903cc2aa7",
          "e30a3802-c1ca-408a-974d-8234685fec18",
          "8717b321-e0f2-4a15-9c58-8217bc07d8cb",
          "c0939442-7ecf-4f6c-b113-b78c14187268",
          "d2ab8777-0a69-4fae-8305-bc8045c55186",
          "54d04022-d99b-42d0-9106-72064b6276fb",
          "1dc9df3e-9c1f-44ab-b313-86f77c8d1402",
          "7b2d3499-99a3-4831-9377-2d9f4ca7eb38",
          "2347b026-9fc2-4443-9383-6612e12275ef"
        ],
        "history": [
          {
            "at": "2026-05-10T11:32:57.603Z",
            "who": "auto",
            "status": "ontvangen"
          }
        ],
        "notitie": "",
        "pairKey": "income-a1",
        "persoon": "a1",
        "required": true, ... [afgekapt: 6921 tekens]

Rij 511

{
  "dossier_id": "b1a25305-031f-4c74-9fa3-58038271ce95",
  "key": "orv",
  "value_json": {
    "eerste": {
      "leeftijd": "42",
      "inkomenNu": "",
      "inkomenPensioen": "",
      "percentageWerken": "",
      "inkomenTussentijds": ""
    },
    "tweede": {
      "leeftijd": "",
      "inkomenNu": "",
      "inkomenPensioen": "",
      "percentageWerken": "",
      "inkomenTussentijds": ""
    },
    "polissen": [
      {
        "id": "polis-f2825c95-bbf1-4cec-b122-2ff80cfdf2ad",
        "roker": false,
        "soort": "Gelijkblijvend",
        "status": "bestaand",
        "verpand": false,
        "einddatum": "",
        "verzekerde": "A1",
        "polisnummer": "",
        "productnaam": "Bestaande ORV",
        "toelichting": "",
        "begunstiging": "Partner / kinderen / erfgenamen",
        "ingangsdatum": "",
        "looptijdJaar": "30",
        "maatschappij": "",
        "premiePerMaand": "",
        "verzekerdKapitaal": ""
      }
    ],
    "maandlast": "",
    "relatievorm": "",
    "kinderenLeeftijd": "",
    "hoofdsomHypotheek": "",
    "acceptatieprobleem": "",
    "bestaandeOrvNabestaande": ""
  },
  "updated_at": 1778754916028
}

Rij 512

{
  "dossier_id": "d1d96ea8-3a18-41f4-ae78-8e24c0cce484",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-05-13T12:41:06.218Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778676066218
}

Rij 513

{
  "dossier_id": "d1d96ea8-3a18-41f4-ae78-8e24c0cce484",
  "key": "aanvraagproces-stukken",
  "value_json": {
    "log": [
      {
        "at": "2026-05-13T12:41:03.697Z",
        "result": "+11 stukken, 0 bestand(en) gekoppeld",
        "command": "auto-detect"
      }
    ],
    "stukken": [
      {
        "id": "8fda633b-8c1f-405e-9c57-329334da8c8c",
        "type": "id_bewijs",
        "label": "Legitimatiebewijs aanvrager 1",
        "status": "aan_te_leveren",
        "fileIds": [],
        "history": [],
        "notitie": "",
        "persoon": "a1",
        "required": true,
        "createdAt": "2026-05-13T12:41:03.697Z",
        "bevindingen": [],
        "documentLinks": []
      },
      {
        "id": "ea570be0-ad8e-4414-84dc-ca29634bb78d",
        "type": "id_bewijs",
        "label": "Legitimatiebewijs aanvrager 2",
        "status": "aan_te_leveren",
        "fileIds": [],
        "history": [],
        "notitie": "",
        "persoon": "a2",
        "required": true,
        "createdAt": "2026-05-13T12:41:03.697Z",
        "bevindingen": [],
        "documentLinks": []
      },
      {
        "id": "370f9f27-15ac-4ee4-a6bd-312cac2e8235",
        "type": "werkgeversverklaring",
        "label": "Werkgeversverklaring A1",
        "status": "aan_te_leveren",
        "fileIds": [],
        "history": [],
        "notitie": "",
        "pairKey": "income-a1",
        "persoon": "a1",
        "required": true,
        "createdAt": "2026-05-13T12:41:03.697Z",
        "bevindingen": [],
        "documentLinks": []
      },
      {
        "id": "2f0f8a84-cc8b-4bfe-8b09-50dda9d9c732",
        "type": "salarisstrook",
        "label": "Salarisstrook A1",
        "status": "aan_te_leveren",
        "fileIds": [],
        "history": [],
        "notitie": "",
        "pairKey": "income-a1",
        "persoon": "a1",
        "required": true,
        "createdAt": "2026-05-13T12:41:03.697Z",
        "bevindingen": [],
        "documentLinks": []
      },
      {
        "id": "30017d02-a3e2-48da-801f-f3d01eb9ef91",
        "type": "werkgeversverklaring",
        "label": "Werkgeversverklaring A2",
        "status": "aan_te_leveren",
        "fileIds": [],
        "history": [],
        "notitie": "",
        "pairKey": "income-a2",
        "persoon": "a2",
        "required": true,
        "createdAt": "2026-05-13T12:41:03.697Z",
        "bevindingen": [],
        "documentLinks": []
      },
      {
        "id": "db876cb2-986c-4f51-8967-262b1fa133d4",
        "type": "salarisstrook",
        "label": "Salarisstrook A2",
        "status": "aan_te_leveren",
        "fileIds": [],
        "history": [],
        "notitie": "",
        "pairKey": "income-a2",
        "persoon": "a2",
        "required": true,
        "createdAt": "2026-05-13T12:41:03.697Z",
        "bevindingen": [],
        "documentLinks": []
      },
      {
        "id": "7f79be6d-43d9-4058-8785-c39a29c9b9eb",
        "type": "bankafschrift",
        "label": "Bankafschrift salaris A1",
        "status": "aan_te_leveren",
        "fileIds": [],
        "history": [],
        "notitie": "",
        "persoon": "a1",
        "required": true,
        "createdAt": "2026-05-13T12:41:03.697Z",
        "bevindingen": [],
        "documentLinks": []
      },
      {
        "id": "ccce12ca-06de-4bfa-90b8-cac10e693af8",
        "type": "bankafschrift",
        "label": "Bankafschrift salaris A2",
        "status": "aan_te_leveren",
        "fileIds": [],
        "history": [],
        "notitie": "",
        "persoon": "a2",
        "required": true,
        "createdAt": "2026-05-13T12:41:03.697Z",
        "bevindingen": [],
        "documentLinks": []
      },
      {
        "id": "71f8f257-d942-4184-82e4-322b738e56c3",
        "type": "koopovereenkomst",
        "label": "Koopovereenkomst",
        "status": "aan_te_leveren",
        "fileIds": [],
        "history": [],
        "notitie": "",
        "persoon": null,
        "required": true,
        "createdAt": "2026-05-13T12:41:03.697Z",
        "bevindingen": [],
        "documentLinks": []
      },
      {
        "id": "9b75fdf7-0330-48e6-94b3-2bf4eef8b203",
        "type": "taxatierapport",
        "label": "Taxatierapport",
        "status": "aan_te_leveren",
        "fileIds": [],
        "history": [],
        "notitie": "",
        "persoon": null,
        "required": true,
        "createdAt": "2026-05-13T12:41:03.697Z",
        "bevindingen": [],
        "documentLinks": []
      },
      {
        "id": "1ee086ad-bee5-4606-8e53-52f005a57d07",
        "type": "hypotheekofferte",
        "label": "Hypotheekofferte",
        "status": "aan_te_leveren",
        "fileIds": [],
        "history": [],
        "notitie": "",
        "persoon": null,
        "required": false,
        "createdAt": "2026-05-13T12:41:03.697Z",
        "bevindingen": [],
        "documentLinks": []
      }
    ],
    "templateId": "nhg-loondienst-duo"
  },
  "updated_at": 1778676063698
}

Rij 514

{
  "dossier_id": "b1a25305-031f-4c74-9fa3-58038271ce95",
  "key": "aov",
  "value_json": {
    "producten": []
  },
  "updated_at": 1778669623017
}

Rij 515

{
  "dossier_id": "dde8f934-dafd-4776-8342-d0d37cf72252",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-05-12T11:43:51.750Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778586231751
}

Rij 516

{
  "dossier_id": "dde8f934-dafd-4776-8342-d0d37cf72252",
  "key": "_sources",
  "value_json": {
    "inventarisatie.a1": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-09T19:48:44.431Z"
    },
    "inventarisatie.a2": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-09T19:48:44.431Z"
    },
    "inventarisatie.data": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-09T19:48:44.431Z"
    },
    "inventarisatie.inc1": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-12T11:43:50.111Z"
    },
    "inventarisatie.inc2": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-12T11:43:50.111Z"
    },
    "inventarisatie.products": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-12T11:43:50.111Z"
    }
  },
  "updated_at": 1778586230149
}

Rij 517

{
  "dossier_id": "dde8f934-dafd-4776-8342-d0d37cf72252",
  "key": "inventarisatie",
  "value_json": {
    "a1": {},
    "a2": {},
    "data": {},
    "products": {
      "pensioen": {
        "aow-standaard": {
          "id": "aow-standaard",
          "type": "aow",
          "Anv_Id": "Beide",
          "Pen_In_OP": true,
          "Aow_Om_Bron": "Standaard aanname: vanaf 18e in Nederland",
          "source_kind": "standaard",
          "Pen_Cd_Soort": "AOW",
          "Pen_Om_Fonds": "Sociale Verzekeringsbank",
          "Aow_Pc_Opbouw": "100",
          "Aow_Cd_Leefsituatie": "Nog bepalen",
          "Aow_Buitenland_Jaren": "0",
          "Aow_In_NederlandSinds18": true
        }
      }
    }
  },
  "updated_at": 1778586230111
}

Rij 518

{
  "dossier_id": "b1a25305-031f-4c74-9fa3-58038271ce95",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-05-12T08:16:16.084Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778573776085
}

Rij 519

{
  "dossier_id": "b1a25305-031f-4c74-9fa3-58038271ce95",
  "key": "klantprofiel",
  "value_json": {
    "woonduur": "10 jaar",
    "ww_wensen": [
      "Niets verzekeren"
    ],
    "aanleiding": [
      "Aankoop bestaande woning"
    ],
    "aov_wensen": [
      "Inkomensaanvulling"
    ],
    "aov_periode": "Minstens 10 jaar",
    "verduurzaming": "Nee",
    "aflossingsvorm": "Annuïtair",
    "aov_motivering": "€ 45.000 nog over uit een erfenis na overdracht",
    "aov_verzekeren": "Zeer beperkt",
    "grote_uitgaven": "Nee",
    "rentevast_wens": "6 tot 10 jaar",
    "productvoorkeur": "Minder risico/veilig rendement",
    "wijziging_gezin": "Nee",
    "hypotheek_doelen": [
      "Woning kopen",
      "Stabiele maandlasten lange periode"
    ],
    "financiele_doelen": [
      "Zekerheid van voldoende inkomsten in alle situaties"
    ],
    "hypotheek_koopsom": "€ 401.000",
    "overlijden_wensen": [
      "Partner verzorgd achterlaten"
    ],
    "risico_acceptatie": "Gokje mag, geen grote risico's",
    "verantwoord_lenen": "NHG",
    "ww_inkomensniveau": "Niet van toepassing",
    "ww_wensen_partner": [
      "Niets verzekeren"
    ],
    "aov_inkomensniveau": "90%",
    "aov_wensen_partner": [
      "Inkomensaanvulling"
    ],
    "inbreng_eigen_geld": "Verlagen hypotheek",
    "overlijden_periode": "Tijdelijk",
    "fiscale_aftrek_wens": "Consumptieve besteding meefinancieren",
    "uitgaven_bijstellen": "Besparen op levensonderhoud",
    "wijziging_werkgever": "Nee",
    "ww_wensen_aanvrager": [
      "Niets verzekeren"
    ],
    "zekerheid_rendement": "Zekerheid",
    "aov_wachttijd_risico": "Niet van toepassing",
    "aov_wensen_aanvrager": [
      "Inkomensaanvulling"
    ],
    "financiele_meevaller": "Nee",
    "risico_rentestijging": "Beperkt",
    "overlijden_motivering": "€ 45.000 nog over uit een erfenis na overdracht",
    "inkomen_a1_ontwikkeling": "Stijgend",
    "inkomen_a2_ontwikkeling": "Stijgend",
    "aov_alternatief_vermogen": "Ja",
    "overlijden_inkomensniveau": "90%",
    "overlijden_wensen_partner": [
      "Partner verzorgd achterlaten"
    ],
    "overlijden_doel_voorziening": [
      "Eenmalige uitkering bij overlijden"
    ],
    "overlijden_wensen_aanvrager": [
      "Partner verzorgd achterlaten"
    ],
    "overlijden_alternatief_vermogen": "Ja"
  },
  "updated_at": 1778511166644
}

Rij 520

{
  "dossier_id": "supplier-woonfonds-hypotheken",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.201Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859202
}

Rij 521

{
  "dossier_id": "supplier-sns-bank",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.198Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859198
}

Rij 522

{
  "dossier_id": "supplier-regiobank",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.194Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859194
}

Rij 523

{
  "dossier_id": "supplier-philips-pensioenfonds",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.190Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859191
}

Rij 524

{
  "dossier_id": "supplier-orange-credit",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.186Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859187
}

Rij 525

{
  "dossier_id": "supplier-onderlinge-nederland",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.183Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859183
}

Rij 526

{
  "dossier_id": "supplier-neo-hypotheken",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.179Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859179
}

Rij 527

{
  "dossier_id": "supplier-iqwoon",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.175Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859176
}

Rij 528

{
  "dossier_id": "supplier-hq-hypotheken",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.171Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859172
}

Rij 529

{
  "dossier_id": "supplier-groene-hart-hypotheken",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.167Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859168
}

Rij 530

{
  "dossier_id": "supplier-dynamic-hypotheken",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.163Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859164
}

Rij 531

{
  "dossier_id": "supplier-dynamic-credit",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.160Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859160
}

Rij 532

{
  "dossier_id": "supplier-colibri-hypotheken",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.156Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859156
}

Rij 533

{
  "dossier_id": "supplier-clarian-wonen",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.152Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859153
}

Rij 534

{
  "dossier_id": "supplier-bnp-paribas-personal-finance",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.148Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859149
}

Rij 535

{
  "dossier_id": "supplier-blg-hypotheken",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.145Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859145
}

Rij 536

{
  "dossier_id": "supplier-crystal-marbles",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.141Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859141
}

Rij 537

{
  "dossier_id": "supplier-stater",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.137Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859137
}

Rij 538

{
  "dossier_id": "supplier-taxatheek",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.133Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859134
}

Rij 539

{
  "dossier_id": "supplier-nrvt",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.129Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859130
}

Rij 540

{
  "dossier_id": "supplier-nwwi",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.126Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859126
}

Rij 541

{
  "dossier_id": "supplier-uw-garantiestelling",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.122Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859122
}

Rij 542

{
  "dossier_id": "supplier-nationale-waarborg",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.118Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859119
}

Rij 543

{
  "dossier_id": "supplier-ingage-aetos",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.114Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859115
}

Rij 544

{
  "dossier_id": "supplier-woonnu",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.111Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859111
}

Rij 545

{
  "dossier_id": "supplier-vista",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.107Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859107
}

Rij 546

{
  "dossier_id": "supplier-venn",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.103Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859103
}

Rij 547

{
  "dossier_id": "supplier-vandaag-hypotheken",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.099Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859100
}

Rij 548

{
  "dossier_id": "supplier-tulp-hypotheken",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.095Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859096
}

Rij 549

{
  "dossier_id": "supplier-triodos",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.092Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859092
}

Rij 550

{
  "dossier_id": "supplier-syntrus-achmea",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [],
    "lastDerived": {
      "at": "2026-05-10T12:07:39.088Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1778414859088
}

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)