Database Explorer

{
  "dossier_id": "b555e83c-741b-455e-845b-be5ce49dbe9b",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.473Z",
        "nsn": "120363419224812682",
        "via": "whatsapp_name_match",
        "chatId": "120363419224812682@g.us",
        "chatNaam": "Hyp: Gwizdz"
      }
    ],
    "updatedAt": "2026-06-12T12:46:52.368Z"
  },
  "updated_at": 1781268412368
}

{
  "dossier_id": "ef5d19ff-e0c1-462d-a0b4-046c764f0887",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.468Z",
        "nsn": "120363045938369635",
        "via": "whatsapp_name_match",
        "chatId": "120363045938369635@g.us",
        "chatNaam": "Hyp: Swagerman/Burch"
      }
    ],
    "updatedAt": "2026-06-12T12:46:52.145Z"
  },
  "updated_at": 1781268412145
}

{
  "dossier_id": "45e526da-d0a1-43e6-b4dc-ac0191211656",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T10:51:08.181Z",
        "nsn": "*********",
        "via": "whatsapp_name_match",
        "chatId": "31638544678@s.whatsapp.net",
        "chatNaam": "Adil Bnademjdid"
      },
      {
        "at": "2026-06-12T12:46:50.486Z",
        "nsn": "6474588451559304015",
        "via": "whatsapp_name_match",
        "chatId": "31647458845-1559304015@g.us",
        "chatNaam": "Hyp: A. Bnademjdid"
      }
    ],
    "updatedAt": "2026-06-12T12:46:52.068Z"
  },
  "updated_at": 1781268412068
}

{
  "dossier_id": "fbbbb678-8ffe-4514-b46c-162431af7a1e",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.466Z",
        "nsn": "120363025111164197",
        "via": "whatsapp_name_match",
        "chatId": "120363025111164197@g.us",
        "chatNaam": "HYP: Ferzan Yalcin"
      }
    ],
    "updatedAt": "2026-06-12T12:46:52.007Z"
  },
  "updated_at": 1781268412007
}

{
  "dossier_id": "fc62902b-03b2-4d53-ac7a-3ec6a1d1eed7",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.462Z",
        "nsn": "120363039342295945",
        "via": "whatsapp_name_match",
        "chatId": "120363039342295945@g.us",
        "chatNaam": "HYP:Staniszewski-Kotowska"
      }
    ],
    "updatedAt": "2026-06-12T12:46:51.899Z"
  },
  "updated_at": 1781268411899
}

{
  "dossier_id": "72bb1e4e-6ec2-4082-a282-5d5673558f93",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.461Z",
        "nsn": "6395572821618309589",
        "via": "whatsapp_name_match",
        "chatId": "31639557282-1618309589@g.us",
        "chatNaam": "HYP: Ton & Mary Baars"
      },
      {
        "at": "2026-06-12T12:46:50.461Z",
        "nsn": "56105208152087",
        "via": "whatsapp_name_match",
        "chatId": "31639557282-1618309589@g.us",
        "chatNaam": "HYP: Ton & Mary Baars"
      }
    ],
    "updatedAt": "2026-06-12T12:46:51.741Z"
  },
  "updated_at": 1781268411741
}

{
  "dossier_id": "5862d343-6fbb-421d-b2c4-0f5d5681ff33",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.455Z",
        "nsn": "6474588451597425665",
        "via": "whatsapp_name_match",
        "chatId": "31647458845-1597425665@g.us",
        "chatNaam": "Hyp: D&A van der Geest"
      }
    ],
    "updatedAt": "2026-06-12T12:46:51.655Z"
  },
  "updated_at": 1781268411655
}

{
  "dossier_id": "b1a869b8-f5f3-4d05-a09b-a1eff6f89a7d",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.454Z",
        "nsn": "6474588451571075946",
        "via": "whatsapp_name_match",
        "chatId": "31647458845-1571075946@g.us",
        "chatNaam": "Hyp: Ubels & Ootes"
      }
    ],
    "updatedAt": "2026-06-12T12:46:51.477Z"
  },
  "updated_at": 1781268411477
}

{
  "dossier_id": "849de268-12c6-4df6-b466-6b60ca2610b4",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.260Z",
        "nsn": "120363306202703034",
        "via": "whatsapp_name_match",
        "chatId": "120363306202703034@g.us",
        "chatNaam": "Hyp: Kopen & Guothova"
      },
      {
        "at": "2026-06-12T12:46:50.260Z",
        "nsn": "59944925687833",
        "via": "whatsapp_name_match",
        "chatId": "120363306202703034@g.us",
        "chatNaam": "Hyp: Kopen & Guothova"
      },
      {
        "at": "2026-06-12T12:46:50.260Z",
        "nsn": "146759552655426",
        "via": "whatsapp_name_match",
        "chatId": "120363306202703034@g.us",
        "chatNaam": "Hyp: Kopen & Guothova"
      }
    ],
    "updatedAt": "2026-06-12T12:46:51.190Z"
  },
  "updated_at": 1781268411190
}

{
  "dossier_id": "03945c59-260f-45c4-8294-c4bab4ad2e29",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.207Z",
        "nsn": "6474588451611572640",
        "via": "whatsapp_match",
        "chatId": "31647458845-1611572640@g.us",
        "chatNaam": "Hyp: A. Kewalbansing"
      },
      {
        "at": "2026-06-12T12:46:50.207Z",
        "nsn": "*********",
        "via": "whatsapp_match",
        "chatId": "31647458845-1611572640@g.us",
        "chatNaam": "Hyp: A. Kewalbansing"
      },
      {
        "at": "2026-06-12T12:46:50.208Z",
        "nsn": "105166753816774",
        "via": "whatsapp_match",
        "chatId": "31647458845-1611572640@g.us",
        "chatNaam": "Hyp: A. Kewalbansing"
      }
    ],
    "updatedAt": "2026-06-12T12:46:51.056Z"
  },
  "updated_at": 1781268411056
}

{
  "dossier_id": "d9ef447d-61d5-4170-b668-ba92f1f20e7c",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.188Z",
        "nsn": "120363406193722922",
        "via": "whatsapp_name_match",
        "chatId": "120363406193722922@g.us",
        "chatNaam": "Hyp: Johan en Marcella Moser"
      },
      {
        "at": "2026-06-12T12:46:50.188Z",
        "nsn": "99995495735537",
        "via": "whatsapp_name_match",
        "chatId": "120363406193722922@g.us",
        "chatNaam": "Hyp: Johan en Marcella Moser"
      },
      {
        "at": "2026-06-12T12:46:50.188Z",
        "nsn": "278047643185233",
        "via": "whatsapp_name_match",
        "chatId": "120363406193722922@g.us",
        "chatNaam": "Hyp: Johan en Marcella Moser"
      },
      {
        "at": "2026-06-12T12:46:50.188Z",
        "nsn": "105166753816774",
        "via": "whatsapp_name_match",
        "chatId": "120363406193722922@g.us",
        "chatNaam": "Hyp: Johan en Marcella Moser"
      },
      {
        "at": "2026-06-12T12:46:50.188Z",
        "nsn": "*********",
        "via": "whatsapp_name_match",
        "chatId": "120363406193722922@g.us",
        "chatNaam": "Hyp: Johan en Marcella Moser"
      }
    ],
    "updatedAt": "2026-06-12T12:46:50.946Z"
  },
  "updated_at": 1781268410946
}

{
  "dossier_id": "7fced6ad-d4e3-428b-9577-2e38fb3460a5",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.157Z",
        "nsn": "120363158287384168",
        "via": "whatsapp_match",
        "chatId": "120363158287384168@g.us",
        "chatNaam": "HYP: Haverdings - de Ruiter"
      },
      {
        "at": "2026-06-12T12:46:50.157Z",
        "nsn": "179014287253711",
        "via": "whatsapp_match",
        "chatId": "120363158287384168@g.us",
        "chatNaam": "HYP: Haverdings - de Ruiter"
      },
      {
        "at": "2026-06-12T12:46:50.157Z",
        "nsn": "105166753816774",
        "via": "whatsapp_match",
        "chatId": "120363158287384168@g.us",
        "chatNaam": "HYP: Haverdings - de Ruiter"
      },
      {
        "at": "2026-06-12T12:46:50.157Z",
        "nsn": "*********",
        "via": "whatsapp_match",
        "chatId": "120363158287384168@g.us",
        "chatNaam": "HYP: Haverdings - de Ruiter"
      }
    ],
    "updatedAt": "2026-06-12T12:46:50.816Z"
  },
  "updated_at": 1781268410816
}

{
  "dossier_id": "545a259b-22cc-4d90-9b60-6a787aeee03f",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.146Z",
        "nsn": "6474588451564485007",
        "via": "whatsapp_match",
        "chatId": "31647458845-1564485007@g.us",
        "chatNaam": "Hyp: Melvin Taverne"
      },
      {
        "at": "2026-06-12T12:46:50.146Z",
        "nsn": "32680557211892",
        "via": "whatsapp_match",
        "chatId": "31647458845-1564485007@g.us",
        "chatNaam": "Hyp: Melvin Taverne"
      },
      {
        "at": "2026-06-12T12:46:50.146Z",
        "nsn": "245006577188985",
        "via": "whatsapp_match",
        "chatId": "31647458845-1564485007@g.us",
        "chatNaam": "Hyp: Melvin Taverne"
      }
    ],
    "updatedAt": "2026-06-12T12:46:50.674Z"
  },
  "updated_at": 1781268410674
}

{
  "dossier_id": "009b5118-80f0-4b2a-a476-6224e9099fd9",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T12:46:50.119Z",
        "nsn": "120363408184732198",
        "via": "whatsapp_match",
        "chatId": "120363408184732198@g.us",
        "chatNaam": "Sylvia De Jong"
      },
      {
        "at": "2026-06-12T12:46:50.119Z",
        "nsn": "105166753816774",
        "via": "whatsapp_match",
        "chatId": "120363408184732198@g.us",
        "chatNaam": "Sylvia De Jong"
      }
    ],
    "updatedAt": "2026-06-12T12:46:50.560Z"
  },
  "updated_at": 1781268410560
}

{
  "dossier_id": "03c102b5-16de-45da-958e-1201eb3da19e",
  "key": "base_import",
  "value_json": {
    "adres": "Lagune 50",
    "klant": "Toppin, Jaleesa (JPO)",
    "plaats": "Lelystad",
    "source": "excel_klantenoverzicht",
    "adviseur": "Zwarthoff, Rogier (R.D.)",
    "postcode": "8224 CS",
    "products": [
      {
        "norm": "",
        "type": "",
        "inhoud": "",
        "status": "Actief",
        "artikel": "",
        "tekendatum": "",
        "productnaam": "Hypotheek (samen met ex-partner Estevez; OHA loopt via Stater)",
        "maatschappij": "Venn Hypotheken",
        "productsoort": "Hypotheek",
        "factuurbedrag": "",
        "offertenummer": "1718405",
        "passeeringangsdatum": ""
      }
    ],
    "deelnemer": "Uw Hypotheek",
    "row_count": 1,
    "imported_at": "2026-06-12T12:37:32.817Z",
    "match_terms": [
      "95062",
      "Toppin, Jaleesa (JPO)",
      "Lagune 50",
      "8224 CS",
      "Lelystad",
      "jaleesatoppin@gmail.com",
      "06-43127006",
      "1718405",
      "Venn Hypotheken",
      "Hypotheek (samen met ex-partner Estevez; OHA loopt via Stater)",
      "Hypotheek"
    ],
    "source_file": "handmatig-herstel-2026-06-12 (ontbrak in _202113668_Klantenoverzicht_incl_Producten.xlsx)",
    "crmdossier_id": "",
    "dossiernummer": "95062",
    "dossierstatus": "Actief",
    "email_partner": "",
    "telefoonnummer": "06-43127006",
    "email_aanvrager": "jaleesatoppin@gmail.com"
  },
  "updated_at": 1781267852817
}

{
  "dossier_id": "a6ef41e2-8780-4dd6-baac-3f5126fe8e44",
  "key": "_sources",
  "value_json": {
    "inventarisatie.inc1": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-08T09:03:19.752Z"
    },
    "inventarisatie.inc2": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-08T09:03:19.752Z"
    },
    "inventarisatie.inc1.payrolls": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-08T09:04:12.038Z"
    },
    "inventarisatie.inc2.payrolls": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-08T09:04:12.038Z"
    },
    "inventarisatie.data.producten": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-08T09:04:12.038Z"
    },
    "inventarisatie.inc1.caoResults": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-08T09:04:12.038Z"
    },
    "inventarisatie.inc2.caoResults": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-08T09:04:12.038Z"
    },
    "inventarisatie.data.soort_aanvraag": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-08T09:03:47.410Z"
    },
    "inventarisatie.inc1.extraIncomeTypes": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-08T09:04:12.038Z"
    },
    "inventarisatie.inc2.extraIncomeTypes": {
      "source": "Eigen invoer",
      "updated_at": "2026-05-08T09:04:12.038Z"
    },
    "inventarisatie.data.aanvraag_hoofdsom": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.hoofdsom",
      "updated_at": "2026-06-12T10:25:57.966Z"
    },
    "inventarisatie.inc1.fields.aov_iva_pct": {
      "label": "IVA percentage",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_iva_pct": {
      "label": "IVA percentage",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_ao_klasse": {
      "label": "AO klasse scenario",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_ao_klasse": {
      "label": "AO klasse scenario",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.data.aanvraag_geldverstrekker": {
      "source": "HDN-dossierlaag",
      "hdn_path": "hypotheken.aangevraagd.geldverstrekker",
      "updated_at": "2026-06-12T10:25:57.966Z"
    },
    "inventarisatie.inc1.fields.aov_lgu_daarna_pct": {
      "label": "WGA LGU daarna",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_lgu_daarna_pct": {
      "label": "WGA LGU daarna",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.ww_maximumdagloon_toepassen": {
      "label": "WW maximumdagloon toepassen",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.ww_maximumdagloon_toepassen": {
      "label": "WW maximumdagloon toepassen",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_lgu_eerste_2_maanden_pct": {
      "label": "WGA LGU eerste 2 maanden",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_lgu_eerste_2_maanden_pct": {
      "label": "WGA LGU eerste 2 maanden",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_loondoorbetaling_jaar1_pct": {
      "label": "AOV loondoorbetaling jaar 1",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_loondoorbetaling_jaar2_pct": {
      "label": "AOV loondoorbetaling jaar 2",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_loondoorbetaling_jaar1_pct": {
      "label": "AOV loondoorbetaling jaar 1",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_loondoorbetaling_jaar2_pct": {
      "label": "AOV loondoorbetaling jaar 2",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc1.fields.aov_loongerelateerd_duur_maanden": {
      "label": "WGA LGU duur",
      "source": "Afgeleid",
      "confidence": 0.62,
      "updated_at": "2026-06-12T10:51:26.714Z",
      "derived_from": [],
      "normalized_by": "dossier-context"
    },
    "inventarisatie.inc2.fields.aov_loongerelateerd_duur_maanden": {
      "label": ... [afgekapt: 189 tekens]

{
  "dossier_id": "a6ef41e2-8780-4dd6-baac-3f5126fe8e44",
  "key": "inventarisatie",
  "value_json": {
    "a1": {
      "naam": "Bonestroo, Gerwin (G)",
      "adres": "Frederik Hendrikstraat 40",
      "email": "gerwinbonestroo@hotmail.com",
      "postcode": "8262 DT",
      "woonplaats": "Kampen",
      "telefoon_prive": "0613299157"
    },
    "a2": {
      "adres": "Frederik Hendrikstraat 40",
      "postcode": "8262 DT",
      "woonplaats": "Kampen"
    },
    "data": {
      "adviseur": "Zwarthoff, Rogier (R.D.)",
      "deelnemer": "Uw Hypotheek",
      "producten": [
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "TAF Woonlasten beschermer",
          "tekendatum": "25569",
          "productnaam": "TAF Woonlasten beschermer",
          "maatschappij": "TAF",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-D255111A-F526-4E4B-9570-B562E43EA41C|885(2)",
          "passeeringangsdatum": "2019-07-01"
        },
        {
          "norm": "",
          "type": "Levensverzekering",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "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": "ISW-8E4A3784-2A7B-4E70-AC00-7C06A5DEA31D|885(2)",
          "passeeringangsdatum": "2019-09-02"
        },
        {
          "norm": "",
          "type": "Hypotheekadvies",
          "inhoud": "0.00",
          "status": "Aanvraag nieuw",
          "artikel": "",
          "tekendatum": "25569",
          "productnaam": "",
          "maatschappij": "Eigen kantoor",
          "productsoort": "",
          "factuurbedrag": "",
          "offertenummer": "",
          "passeeringangsdatum": "2019-04-15"
        },
        {
          "norm": "",
          "type": "Inkomensverzekering",
          "inhoud": "0.00",
          "status": "Offerte aangevraagd",
          "artikel": "Cardif Aflos Verzekering",
          "tekendatum": "25569",
          "productnaam": "Cardif Aflos Verzekering",
          "maatschappij": "Cardif",
          "productsoort": "Woonlastenverzekering",
          "factuurbedrag": "",
          "offertenummer": "ISW-744DFD8E-E275-4F14-874F-22D7810F31FE|885(1)",
          "passeeringangsdatum": "2019-09-01"
        },
        {
          "norm": "NHG",
          "type": "Hypotheek",
          "inhoud": "188414.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": "2035106",
          "passeeringangsdatum": "2022-03-01"
        }
      ],
      "crmdossier_id": "189982",
      "dossiernummer": "189982",
      "dossierstatus": "Actief",
      "producten_bron": "Excel klantenoverzicht",
      "soort_aanvraag": "Bestaande bouw",
      "aanvraag_hoofdsom": "0.00",
      "aanvraag_geldverstrekker": "Eigen kantoor"
    },
    "inc1": {
      "cao": {},
      "type": "loondienst",
      "fields": {
        "aov_iva_pct": "75",
        "aov_ao_klasse": "65",
        "aov_lgu_daarna_pct": "70",
        "ww_maximumdagloon_toepassen": "Ja",
        "aov_lgu_eerste_2_maanden_pct": "75",
        "aov_loondoorbetaling_jaar1_pct": "70",
        "aov_loondoorbetaling_jaar2_pct": "70",
        "aov_loongerelateerd_duur_maanden": "24"
      },
      "payrolls": [],
      "caoResults": [],
      "payrollYear": "2026",
      "extraIncomeTypes": []
    },
    "inc2": {
      "cao": {},
      "type": "loondienst",
      "fields": {
        "aov_iva_pct": "75",
        "aov_ao_klasse": "65",
        "aov_lgu_daarna_pct": "70",
        "ww_maximumdagloon_toepassen": "Ja",
        "aov_lgu_eerste_2_maanden_pct": "75",
        "aov_loondoorbetaling_jaar1_pct": "70",
        "aov_loondoorbetaling_jaar2_pct": "70",
        "aov_loongerelateerd_duur_maanden": "24"
      },
      "payrolls": [],
      "caoResults": [],
      "payrollYear": "2026",
      "extraIncomeTypes": []
    }
  },
  "updated_at": 1781261486947
}

{
  "dossier_id": "f38cf1db-9bf2-4338-89cf-56063b24acba",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:51:13.250Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781261473251
}

{
  "dossier_id": "c930b574-88c3-4631-8b83-b23f579b8753",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:51:13.242Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781261473242
}

{
  "dossier_id": "49b8db2c-d85d-408c-868e-8026a9a69168",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:51:13.224Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781261473224
}

{
  "dossier_id": "7065b590-ff03-4134-b2f2-40610817b5b7",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:51:13.211Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781261473211
}

{
  "dossier_id": "45e526da-d0a1-43e6-b4dc-ac0191211656",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:51:13.203Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781261473203
}

{
  "dossier_id": "c48b19e4-7ece-4ac9-808a-c35cdf4acd9e",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:51:13.195Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781261473195
}

{
  "dossier_id": "be960a24-41d5-4f06-b00f-2f701f7d609a",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:51:13.179Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781261473179
}

{
  "dossier_id": "ac9f9569-7085-4a56-842d-d8933d54b537",
  "key": "dossier_meta",
  "value_json": {
    "reden": "Testdossier (duplicaat van 298444)",
    "status": "archief",
    "archivedAt": "2026-06-12T10:51:09.654Z"
  },
  "updated_at": 1781261469654
}

{
  "dossier_id": "49b8db2c-d85d-408c-868e-8026a9a69168",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T10:51:08.200Z",
        "nsn": "48884839295",
        "via": "whatsapp_name_match",
        "chatId": "48884839295@s.whatsapp.net",
        "chatNaam": "Kamil Gnidziejko"
      }
    ],
    "updatedAt": "2026-06-12T10:51:08.661Z"
  },
  "updated_at": 1781261468661
}

{
  "dossier_id": "c930b574-88c3-4631-8b83-b23f579b8753",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T10:51:08.192Z",
        "nsn": "*********",
        "via": "whatsapp_name_match",
        "chatId": "31611384172@s.whatsapp.net",
        "chatNaam": "Thijs Rolleman"
      }
    ],
    "updatedAt": "2026-06-12T10:51:08.613Z"
  },
  "updated_at": 1781261468613
}

{
  "dossier_id": "7065b590-ff03-4134-b2f2-40610817b5b7",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T10:51:08.184Z",
        "nsn": "*********",
        "via": "whatsapp_name_match",
        "chatId": "31614886843@s.whatsapp.net",
        "chatNaam": "Mariska Honing"
      }
    ],
    "updatedAt": "2026-06-12T10:51:08.563Z"
  },
  "updated_at": 1781261468563
}

{
  "dossier_id": "c48b19e4-7ece-4ac9-808a-c35cdf4acd9e",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T10:51:08.170Z",
        "nsn": "*********",
        "via": "whatsapp_name_match",
        "chatId": "31616989878@s.whatsapp.net",
        "chatNaam": "Tjesse Boiten"
      }
    ],
    "updatedAt": "2026-06-12T10:51:08.466Z"
  },
  "updated_at": 1781261468466
}

{
  "dossier_id": "eec8ad9e-b509-4cc3-898e-70e82feac4a9",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T10:51:07.974Z",
        "nsn": "*********",
        "via": "whatsapp_name_match",
        "chatId": "31622972768@s.whatsapp.net",
        "chatNaam": "Hiddo Kuipers"
      }
    ],
    "updatedAt": "2026-06-12T10:51:08.416Z"
  },
  "updated_at": 1781261468416
}

{
  "dossier_id": "be960a24-41d5-4f06-b00f-2f701f7d609a",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T10:51:07.899Z",
        "nsn": "*********",
        "via": "whatsapp_name_match",
        "chatId": "137477759234138@lid",
        "chatNaam": "Dylan Riebel"
      }
    ],
    "updatedAt": "2026-06-12T10:51:08.367Z"
  },
  "updated_at": 1781261468367
}

{
  "dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T10:51:07.883Z",
        "nsn": "*********",
        "via": "whatsapp_name_match",
        "chatId": "85323971309792@lid",
        "chatNaam": "Raymon Mollink"
      }
    ],
    "updatedAt": "2026-06-12T10:51:08.314Z"
  },
  "updated_at": 1781261468315
}

{
  "dossier_id": "a6ef41e2-8780-4dd6-baac-3f5126fe8e44",
  "key": "whatsapp_nummers",
  "value_json": {
    "nummers": [
      {
        "at": "2026-06-12T10:51:07.820Z",
        "nsn": "*********",
        "via": "whatsapp_name_match",
        "chatId": "155473672175813@lid",
        "chatNaam": "Gerwin Bonestroo"
      }
    ],
    "updatedAt": "2026-06-12T10:51:08.241Z"
  },
  "updated_at": 1781261468241
}

{
  "dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
  "key": "dossier_relaties",
  "value_json": {
    "relaties": [
      {
        "type": "voorganger",
        "createdAt": "2026-06-12T10:28:14.440Z",
        "dossierId": "5b3c09e6-81cf-4545-a5cc-db66772bb285",
        "dossierNaam": "Mollink, Raymon (R.L.), Schut, Michelle (M) (133886)"
      }
    ],
    "updatedAt": "2026-06-12T10:28:14.539Z"
  },
  "updated_at": 1781260094539
}

{
  "dossier_id": "5b3c09e6-81cf-4545-a5cc-db66772bb285",
  "key": "dossier_relaties",
  "value_json": {
    "relaties": [
      {
        "type": "opvolger",
        "createdAt": "2026-06-12T10:28:14.440Z",
        "dossierId": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
        "dossierNaam": "Baljé (C.), Mollink, Raymon (R.L.) (298444)"
      }
    ],
    "updatedAt": "2026-06-12T10:28:14.464Z"
  },
  "updated_at": 1781260094464
}

{
  "dossier_id": "5b3c09e6-81cf-4545-a5cc-db66772bb285",
  "key": "dossier_meta",
  "value_json": {
    "reden": "Woning verkocht, klantpaar uit elkaar — opgesplitst; opvolger: Baljé/Mollink (298444)",
    "status": "archief",
    "archivedAt": "2026-06-12T10:26:58.958Z"
  },
  "updated_at": 1781260018958
}

{
  "dossier_id": "a6ef41e2-8780-4dd6-baac-3f5126fe8e44",
  "key": "financieringsopzet",
  "value_json": {
    "activeId": "hdn-aangevraagd-s5axqk",
    "voorstellen": [
      {
        "id": "hdn-aangevraagd-s5axqk",
        "naam": "Aangevraagd uit HDN",
        "kosten": {},
        "status": "selected",
        "notitie": "Bron: HDN aangevraagd. Automatisch als apart voorstel vastgelegd en breed gevuld uit de HDN-aanvraag/objectgegevens zodat gewijzigde bedragen of voorwaarden als nieuw aangevraagd-voorstel vergelijkbaar blijven.",
        "leningdelen": [
          {
            "id": "hdn-aangevraagd-leningdeel-s5axqk-1",
            "box": "1",
            "type": "Nieuw",
            "hoofdsom": "0.00",
            "geldverstrekker": "Eigen kantoor"
          }
        ],
        "financiering": {
          "hypotheek1": "0.00"
        },
        "vergelijking": {},
        "arrangementCd": "",
        "geldverstrekker": "Eigen kantoor",
        "maatschappijCode": "",
        "selectedProductCodes": [
          "hypotheek"
        ]
      }
    ],
    "selectedProposalId": "hdn-aangevraagd-s5axqk"
  },
  "updated_at": 1781259958256
}

{
  "dossier_id": "a6ef41e2-8780-4dd6-baac-3f5126fe8e44",
  "key": "hdn_dossier",
  "value_json": {
    "schema": "adviestool.hdn_like",
    "bronnen": {
      "partijen.p1.contact.email": [
        {
          "at": 1781259958061,
          "value": "gerwinbonestroo@hotmail.com",
          "context": "inventarisatie.a1.email",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.plaats": [
        {
          "at": 1781259958061,
          "value": "Kampen",
          "context": "inventarisatie.a1.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.plaats": [
        {
          "at": 1781259958062,
          "value": "Kampen",
          "context": "inventarisatie.a2.woonplaats",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.woonadres.postcode": [
        {
          "at": 1781259958061,
          "value": "8262 DT",
          "context": "inventarisatie.a1.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.postcode": [
        {
          "at": 1781259958062,
          "value": "8262 DT",
          "context": "inventarisatie.a2.postcode",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.hoofdsom": [
        {
          "at": 1781259958062,
          "value": "0.00",
          "context": "base_import.products[].inhoud",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ],
      "partijen.p1.woonadres.adresregel": [
        {
          "at": 1781259958061,
          "value": "Frederik Hendrikstraat 40",
          "context": "inventarisatie.a1.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p2.woonadres.adresregel": [
        {
          "at": 1781259958062,
          "value": "Frederik Hendrikstraat 40",
          "context": "inventarisatie.a2.adres",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.contact.telefoonPrive": [
        {
          "at": 1781259958061,
          "value": "0613299157",
          "context": "inventarisatie.a1.telefoon_prive",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "partijen.p1.natuurlijkPersoon.naam": [
        {
          "at": 1781259958061,
          "value": "Bonestroo, Gerwin (G)",
          "context": "inventarisatie.a1.naam",
          "confidence": 0.55,
          "sourceKind": "inventarisatie"
        }
      ],
      "hypotheken.aangevraagd.geldverstrekker": [
        {
          "at": 1781259958062,
          "value": "Eigen kantoor",
          "context": "base_import.products[].maatschappij",
          "confidence": 0.68,
          "sourceKind": "extractie"
        }
      ]
    },
    "version": 1,
    "inkomens": {
      "inkomen1": {
        "soort": "loondienst",
        "partyId": "p1"
      },
      "inkomen2": {
        "soort": "loondienst",
        "partyId": "p2"
      }
    },
    "objecten": {
      "teFinancieren": {
        "soort": "te_financieren_object"
      },
      "vorigeWoning1": {
        "soort": "vorige_woning"
      },
      "huidigeWoning1": {
        "soort": "huidige_woning"
      }
    },
    "partijen": {
      "p1": {
        "rol": "aanvrager",
        "contact": {
          "email": "gerwinbonestroo@hotmail.com",
          "telefoonPrive": "0613299157"
        },
        "woonadres": {
          "plaats": "Kampen",
          "postcode": "8262 DT",
          "adresregel": "Frederik Hendrikstraat 40"
        },
        "volgnummer": 1,
        "natuurlijkPersoon": {
          "naam": "Bonestroo, Gerwin (G)"
        }
      },
      "p2": {
        "rol": "aanvrager",
        "woonadres": {
          "plaats": "Kampen",
          "postcode": "8262 DT",
          "adresregel": "Frederik Hendrikstraat 40"
        },
        "volgnummer": 2
      }
    },
    "dossierId": "a6ef41e2-8780-4dd6-baac-3f5126fe8e44",
    "rebuiltAt": 1781259957966,
    "documenten": [],
    "hypotheken": {
      "bestaand1": {
        "soort": "bestaande_hypotheek",
        "objectId": "huidigeWoning1"
      },
      "aangevraagd": {
        "soort": "aangevraagde_hypotheek",
        "hoofdsom": "0.00",
        "objectId": "teFinancieren",
        "geldverstrekker": "Eigen kantoor"
      }
    },
    "statistiek": {
      "documenten": 0,
      "extracties": 0,
      "gelezenItems": 0,
      "gemapteWaarden": 11,
      "overgeslagenItems": 0,
      "projectieWijzigingen": 2
    },
    "gekozenBron": {
      "partijen.p1.contact.email": {
        "at": 1781259958061,
        "value": "gerwinbonestroo@hotmail.com",
        "context": "inventarisatie.a1.email",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p1.woonadres.plaats": {
        "at": 1781259958061,
        "value": "Kampen",
        "context": "inventarisatie.a1.woonplaats",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p2.woonadres.plaats": {
        "at": 1781259958062,
        "value": "Kampen",
        "context": "inventarisatie.a2.woonplaats",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p1.woonadres.postcode": {
        "at": 1781259958061,
        "value": "8262 DT",
        "context": "inventarisatie.a1.postcode",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "partijen.p2.woonadres.postcode": {
        "at": 1781259958062,
        "value": "8262 DT",
        "context": "inventarisatie.a2.postcode",
        "confidence": 0.55,
        "sourceKind": "inventarisatie"
      },
      "hypotheken.aangevraagd.hoofd ... [afgekapt: 1439 tekens]

{
  "dossier_id": "85fc19d8-cac4-497e-947e-43d549eb733c",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:25:17.913Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781259917913
}

{
  "dossier_id": "2e8bae07-270e-41b1-a35a-e76a5ee8b526",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:25:17.904Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781259917904
}

{
  "dossier_id": "fa02ee41-b27f-4497-ba8f-153bf28e1a05",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:25:17.895Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781259917895
}

{
  "dossier_id": "8af06f3e-4db7-46c4-be6e-f9a7bb25b576",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:25:17.885Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781259917885
}

{
  "dossier_id": "c04a3284-7183-4164-a21a-79b732cfd412",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:25:17.872Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781259917873
}

{
  "dossier_id": "69d7416b-85b9-4447-8cdb-74e5e91d3b97",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:25:17.851Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781259917851
}

{
  "dossier_id": "a6ef41e2-8780-4dd6-baac-3f5126fe8e44",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:25:17.842Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781259917842
}

{
  "dossier_id": "0fa132bb-baef-44fd-b4df-cf56ac8932c5",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:25:17.833Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781259917833
}

{
  "dossier_id": "5efa3b6c-6a51-4314-a025-c044b671ecd3",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:25:17.805Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781259917805
}

{
  "dossier_id": "b8fb12b0-5dfd-4453-b787-4d2d51da21bf",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:25:17.797Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781259917797
}

{
  "dossier_id": "da3a52d9-8459-4a75-9d69-4306cd572b35",
  "key": "workflow_v1",
  "value_json": {
    "flags": [],
    "actions": [
      {
        "type": "intent_classification_pending"
      }
    ],
    "lastDerived": {
      "at": "2026-06-12T10:25:17.788Z",
      "phase": "F00_lead"
    },
    "uitvraagReminders": []
  },
  "updated_at": 1781259917788
}

{
  "dossier_id": "2f118f6f-05da-462f-8d39-dd947dbdb1fd",
  "key": "aov",
  "value_json": {
    "producten": [
      {
        "id": "aov-adviesbox-a1",
        "soort": "AOV",
        "status": "voorstel",
        "verzekerde": "A1",
        "productnaam": "TAF Woonlastenverzekering",
        "toelichting": "Geïmporteerd uit Adviesbox-advies.",
        "looptijdJaren": "20",
        "premiePerMaand": "19,56",
        "wachttijdMaanden": "24",
        "verzekerdBedragMaand": "940"
      },
      {
        "id": "aov-adviesbox-a2",
        "soort": "AOV",
        "status": "voorstel",
        "verzekerde": "A2",
        "productnaam": "TAF Woonlastenverzekering",
        "toelichting": "Geïmporteerd uit Adviesbox-advies.",
        "looptijdJaren": "20",
        "premiePerMaand": "14,59",
        "wachttijdMaanden": "24",
        "verzekerdBedragMaand": "979"
      }
    ]
  },
  "updated_at": 1781254801324
}