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.140 rijen/items22 domeincontainers
Zoeken
Tabelzoeker zoekt in de gekozen tabel; dossierzoeker zoekt klant/dossierlocaties over bekende dossierstores.
Rijen: boekhouding-sqlite.herkenningsregel
Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.
Read-only query
SELECT * FROM "herkenningsregel" LIMIT 50 OFFSET 0
| id | bv_code | match_field | match_type | match_value | direction | rgs_account_no | btw_code | priority | active | source | created_at | relatie_id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1057 | UZ | remi | contains | DIB2 | D | 1830 | geen | 5 | 1 | audit-fix-a3 | 2026-06-10T22:23:46.000Z | |
| 1058 | UZ | counterparty_name | contains | PARIBAS CARDIF | C | 8049 | vrijgesteld | 10 | 1 | seed | 2026-06-11T07:22:39.212Z | |
| 1059 | UZ | counterparty_name | contains | NATIONALE-NEDERLANDEN | C | 8062 | vrijgesteld | 11 | 1 | seed | 2026-06-11T07:22:39.212Z | |
| 1060 | UZ | counterparty_name | contains | MONEYCARE | C | 8039 | vrijgesteld | 12 | 1 | seed | 2026-06-11T07:22:39.212Z | |
| 1061 | UZ | counterparty_name | contains | KLAVERBLAD | C | 8030 | vrijgesteld | 13 | 1 | seed | 2026-06-11T07:22:39.212Z | |
| 1062 | UZ | counterparty_name | contains | ANSVAR | C | 8034 | vrijgesteld | 14 | 1 | seed | 2026-06-11T07:22:39.213Z | |
| 1063 | UZ | counterparty_name | contains | FINANCIUM | C | 8038 | vrijgesteld | 15 | 1 | seed | 2026-06-11T07:22:39.213Z | |
| 1064 | UZ | counterparty_name | contains | VOOGD | C | 8041 | vrijgesteld | 16 | 1 | seed | 2026-06-11T07:22:39.213Z | |
| 1065 | UZ | counterparty_name | contains | CRYSTAL MARBLES | C | 8054 | vrijgesteld | 17 | 1 | seed | 2026-06-11T07:22:39.213Z | |
| 1066 | remi | contains | Kosten Zakelijk Betalingsverkeer | D | 9005 | geen | 30 | 1 | seed | 2026-06-11T07:22:39.213Z | ||
| 1067 | UZ | counterparty_name | contains | Kamer van Koophandel | D | 4825 | geen | 31 | 1 | seed | 2026-06-11T07:22:39.213Z | |
| 1068 | UZ | counterparty_iban | equals | NL47****9112 | 1308 | geen | 40 | 1 | seed | 2026-06-11T07:22:39.214Z |
Raw JSON details
Rij 1
{
"id": 1057,
"bv_code": "UZ",
"match_field": "remi",
"match_type": "contains",
"match_value": "DIB2",
"direction": "D",
"rgs_account_no": "1830",
"btw_code": "geen",
"priority": 5,
"active": 1,
"source": "audit-fix-a3",
"created_at": "2026-06-10T22:23:46.000Z",
"relatie_id": null
}Rij 2
{
"id": 1058,
"bv_code": "UZ",
"match_field": "counterparty_name",
"match_type": "contains",
"match_value": "PARIBAS CARDIF",
"direction": "C",
"rgs_account_no": "8049",
"btw_code": "vrijgesteld",
"priority": 10,
"active": 1,
"source": "seed",
"created_at": "2026-06-11T07:22:39.212Z",
"relatie_id": null
}Rij 3
{
"id": 1059,
"bv_code": "UZ",
"match_field": "counterparty_name",
"match_type": "contains",
"match_value": "NATIONALE-NEDERLANDEN",
"direction": "C",
"rgs_account_no": "8062",
"btw_code": "vrijgesteld",
"priority": 11,
"active": 1,
"source": "seed",
"created_at": "2026-06-11T07:22:39.212Z",
"relatie_id": null
}Rij 4
{
"id": 1060,
"bv_code": "UZ",
"match_field": "counterparty_name",
"match_type": "contains",
"match_value": "MONEYCARE",
"direction": "C",
"rgs_account_no": "8039",
"btw_code": "vrijgesteld",
"priority": 12,
"active": 1,
"source": "seed",
"created_at": "2026-06-11T07:22:39.212Z",
"relatie_id": null
}Rij 5
{
"id": 1061,
"bv_code": "UZ",
"match_field": "counterparty_name",
"match_type": "contains",
"match_value": "KLAVERBLAD",
"direction": "C",
"rgs_account_no": "8030",
"btw_code": "vrijgesteld",
"priority": 13,
"active": 1,
"source": "seed",
"created_at": "2026-06-11T07:22:39.212Z",
"relatie_id": null
}Rij 6
{
"id": 1062,
"bv_code": "UZ",
"match_field": "counterparty_name",
"match_type": "contains",
"match_value": "ANSVAR",
"direction": "C",
"rgs_account_no": "8034",
"btw_code": "vrijgesteld",
"priority": 14,
"active": 1,
"source": "seed",
"created_at": "2026-06-11T07:22:39.213Z",
"relatie_id": null
}Rij 7
{
"id": 1063,
"bv_code": "UZ",
"match_field": "counterparty_name",
"match_type": "contains",
"match_value": "FINANCIUM",
"direction": "C",
"rgs_account_no": "8038",
"btw_code": "vrijgesteld",
"priority": 15,
"active": 1,
"source": "seed",
"created_at": "2026-06-11T07:22:39.213Z",
"relatie_id": null
}Rij 8
{
"id": 1064,
"bv_code": "UZ",
"match_field": "counterparty_name",
"match_type": "contains",
"match_value": "VOOGD",
"direction": "C",
"rgs_account_no": "8041",
"btw_code": "vrijgesteld",
"priority": 16,
"active": 1,
"source": "seed",
"created_at": "2026-06-11T07:22:39.213Z",
"relatie_id": null
}Rij 9
{
"id": 1065,
"bv_code": "UZ",
"match_field": "counterparty_name",
"match_type": "contains",
"match_value": "CRYSTAL MARBLES",
"direction": "C",
"rgs_account_no": "8054",
"btw_code": "vrijgesteld",
"priority": 17,
"active": 1,
"source": "seed",
"created_at": "2026-06-11T07:22:39.213Z",
"relatie_id": null
}Rij 10
{
"id": 1066,
"bv_code": null,
"match_field": "remi",
"match_type": "contains",
"match_value": "Kosten Zakelijk Betalingsverkeer",
"direction": "D",
"rgs_account_no": "9005",
"btw_code": "geen",
"priority": 30,
"active": 1,
"source": "seed",
"created_at": "2026-06-11T07:22:39.213Z",
"relatie_id": null
}Rij 11
{
"id": 1067,
"bv_code": "UZ",
"match_field": "counterparty_name",
"match_type": "contains",
"match_value": "Kamer van Koophandel",
"direction": "D",
"rgs_account_no": "4825",
"btw_code": "geen",
"priority": 31,
"active": 1,
"source": "seed",
"created_at": "2026-06-11T07:22:39.213Z",
"relatie_id": null
}Rij 12
{
"id": 1068,
"bv_code": "UZ",
"match_field": "counterparty_iban",
"match_type": "equals",
"match_value": "NL47****9112",
"direction": null,
"rgs_account_no": "1308",
"btw_code": "geen",
"priority": 40,
"active": 1,
"source": "seed",
"created_at": "2026-06-11T07:22:39.214Z",
"relatie_id": null
}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) |