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.137 rijen/items22 domeincontainers

Zoeken

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

Rijen: boekhouding-sqlite.vat_declaration

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

Read-only query

SELECT * FROM "vat_declaration" LIMIT 50 OFFSET 0

77 matchende rijen · offset 0 · limiet 50Vorige Volgende

id	bv_code	vat_period	status	total_owed_cents	submitted_at	accepted_at	reference
41	PALEIS	2019-Q1	open
42	PALEIS	2019-Q2	open
43	PALEIS	2019-Q3	open
44	PALEIS	2019-Q4	open
45	PALEIS	2020-Q1	open
46	PALEIS	2020-Q2	open
47	PALEIS	2020-Q3	open
48	PALEIS	2020-Q4	open
49	PALEIS	2021-Q1	open
50	PALEIS	2021-Q2	open
51	PALEIS	2021-Q3	open
52	PALEIS	2021-Q4	open
53	PALEIS	2022-Q1	open
54	PALEIS	2022-Q2	open
55	PALEIS	2022-Q3	open
56	PALEIS	2022-Q4	open
57	PALEIS	2023-Q1	open
58	PALEIS	2023-Q2	open
59	PALEIS	2023-Q3	open
60	PALEIS	2023-Q4	open
61	PALEIS	2024-Q1	submitted	0	2026-06-11T14:30:06.097Z		bankbewijs: betaling EUR 1.383,00 op 30-04-2024 aan Belastingdienst (NL17****2419); kwartaalpatroon OB
62	PALEIS	2024-Q2	accepted	0	2026-06-11T14:30:06.183Z	2026-06-11T14:30:42.664Z	bankbewijs: teruggaaf EUR 532,00 op 09-08-2024, kenmerk 859747700O014240 OB.2EKWART24
63	PALEIS	2024-Q3	submitted	0	2026-06-11T14:30:06.272Z		bankbewijs: betaling EUR 2.622,00 op 31-10-2024 aan Belastingdienst (NL17****2419); kwartaalpatroon OB
64	PALEIS	2024-Q4	submitted	0	2026-06-11T14:30:06.369Z		bankbewijs: betaling EUR 634,00 op 06-02-2025 aan Belastingdienst (NL17****2419); kwartaalpatroon OB
65	HOLDING	2019-Q1	open
66	HOLDING	2019-Q2	open
67	HOLDING	2019-Q3	open
68	HOLDING	2019-Q4	open
69	HOLDING	2020-Q1	open
70	HOLDING	2020-Q2	open
71	HOLDING	2020-Q3	open
72	HOLDING	2020-Q4	open
73	HOLDING	2021-Q1	open
74	HOLDING	2021-Q2	open
75	HOLDING	2021-Q3	open
76	HOLDING	2021-Q4	open
77	HOLDING	2022-Q1	open
78	HOLDING	2022-Q2	open
79	HOLDING	2022-Q3	open
80	HOLDING	2022-Q4	open
81	HOLDING	2023-Q1	open
82	HOLDING	2023-Q2	open
83	HOLDING	2023-Q3	open
84	HOLDING	2023-Q4	open
85	HOLDING	2024-Q1	open
86	HOLDING	2024-Q2	open
87	HOLDING	2024-Q3	open
88	HOLDING	2024-Q4	open
91	UZ	2018-P1	ready	-247			0BD8E011A52141FDAC986B1E317A8B0A
92	UZ	2017-P1	ready	-2135			F5502C73832D4DD794026B6B32256644

Raw JSON details

Rij 1

{
  "id": 41,
  "bv_code": "PALEIS",
  "vat_period": "2019-Q1",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 2

{
  "id": 42,
  "bv_code": "PALEIS",
  "vat_period": "2019-Q2",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 3

{
  "id": 43,
  "bv_code": "PALEIS",
  "vat_period": "2019-Q3",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 4

{
  "id": 44,
  "bv_code": "PALEIS",
  "vat_period": "2019-Q4",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 5

{
  "id": 45,
  "bv_code": "PALEIS",
  "vat_period": "2020-Q1",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 6

{
  "id": 46,
  "bv_code": "PALEIS",
  "vat_period": "2020-Q2",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 7

{
  "id": 47,
  "bv_code": "PALEIS",
  "vat_period": "2020-Q3",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 8

{
  "id": 48,
  "bv_code": "PALEIS",
  "vat_period": "2020-Q4",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 9

{
  "id": 49,
  "bv_code": "PALEIS",
  "vat_period": "2021-Q1",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 10

{
  "id": 50,
  "bv_code": "PALEIS",
  "vat_period": "2021-Q2",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 11

{
  "id": 51,
  "bv_code": "PALEIS",
  "vat_period": "2021-Q3",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 12

{
  "id": 52,
  "bv_code": "PALEIS",
  "vat_period": "2021-Q4",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 13

{
  "id": 53,
  "bv_code": "PALEIS",
  "vat_period": "2022-Q1",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 14

{
  "id": 54,
  "bv_code": "PALEIS",
  "vat_period": "2022-Q2",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 15

{
  "id": 55,
  "bv_code": "PALEIS",
  "vat_period": "2022-Q3",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 16

{
  "id": 56,
  "bv_code": "PALEIS",
  "vat_period": "2022-Q4",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 17

{
  "id": 57,
  "bv_code": "PALEIS",
  "vat_period": "2023-Q1",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 18

{
  "id": 58,
  "bv_code": "PALEIS",
  "vat_period": "2023-Q2",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 19

{
  "id": 59,
  "bv_code": "PALEIS",
  "vat_period": "2023-Q3",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 20

{
  "id": 60,
  "bv_code": "PALEIS",
  "vat_period": "2023-Q4",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 21

{
  "id": 61,
  "bv_code": "PALEIS",
  "vat_period": "2024-Q1",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": 0,
  "submitted_at": "2026-06-11T14:30:06.097Z",
  "accepted_at": null,
  "reference": "bankbewijs: betaling EUR 1.383,00 op 30-04-2024 aan Belastingdienst (NL17****2419); kwartaalpatroon OB"
}

Rij 22

{
  "id": 62,
  "bv_code": "PALEIS",
  "vat_period": "2024-Q2",
  "correction_period": null,
  "status": "accepted",
  "total_owed_cents": 0,
  "submitted_at": "2026-06-11T14:30:06.183Z",
  "accepted_at": "2026-06-11T14:30:42.664Z",
  "reference": "bankbewijs: teruggaaf EUR 532,00 op 09-08-2024, kenmerk 859747700O014240 OB.2EKWART24"
}

Rij 23

{
  "id": 63,
  "bv_code": "PALEIS",
  "vat_period": "2024-Q3",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": 0,
  "submitted_at": "2026-06-11T14:30:06.272Z",
  "accepted_at": null,
  "reference": "bankbewijs: betaling EUR 2.622,00 op 31-10-2024 aan Belastingdienst (NL17****2419); kwartaalpatroon OB"
}

Rij 24

{
  "id": 64,
  "bv_code": "PALEIS",
  "vat_period": "2024-Q4",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": 0,
  "submitted_at": "2026-06-11T14:30:06.369Z",
  "accepted_at": null,
  "reference": "bankbewijs: betaling EUR 634,00 op 06-02-2025 aan Belastingdienst (NL17****2419); kwartaalpatroon OB"
}

Rij 25

{
  "id": 65,
  "bv_code": "HOLDING",
  "vat_period": "2019-Q1",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 26

{
  "id": 66,
  "bv_code": "HOLDING",
  "vat_period": "2019-Q2",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 27

{
  "id": 67,
  "bv_code": "HOLDING",
  "vat_period": "2019-Q3",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 28

{
  "id": 68,
  "bv_code": "HOLDING",
  "vat_period": "2019-Q4",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 29

{
  "id": 69,
  "bv_code": "HOLDING",
  "vat_period": "2020-Q1",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 30

{
  "id": 70,
  "bv_code": "HOLDING",
  "vat_period": "2020-Q2",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 31

{
  "id": 71,
  "bv_code": "HOLDING",
  "vat_period": "2020-Q3",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 32

{
  "id": 72,
  "bv_code": "HOLDING",
  "vat_period": "2020-Q4",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 33

{
  "id": 73,
  "bv_code": "HOLDING",
  "vat_period": "2021-Q1",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 34

{
  "id": 74,
  "bv_code": "HOLDING",
  "vat_period": "2021-Q2",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 35

{
  "id": 75,
  "bv_code": "HOLDING",
  "vat_period": "2021-Q3",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 36

{
  "id": 76,
  "bv_code": "HOLDING",
  "vat_period": "2021-Q4",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 37

{
  "id": 77,
  "bv_code": "HOLDING",
  "vat_period": "2022-Q1",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 38

{
  "id": 78,
  "bv_code": "HOLDING",
  "vat_period": "2022-Q2",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 39

{
  "id": 79,
  "bv_code": "HOLDING",
  "vat_period": "2022-Q3",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 40

{
  "id": 80,
  "bv_code": "HOLDING",
  "vat_period": "2022-Q4",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 41

{
  "id": 81,
  "bv_code": "HOLDING",
  "vat_period": "2023-Q1",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 42

{
  "id": 82,
  "bv_code": "HOLDING",
  "vat_period": "2023-Q2",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 43

{
  "id": 83,
  "bv_code": "HOLDING",
  "vat_period": "2023-Q3",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 44

{
  "id": 84,
  "bv_code": "HOLDING",
  "vat_period": "2023-Q4",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 45

{
  "id": 85,
  "bv_code": "HOLDING",
  "vat_period": "2024-Q1",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 46

{
  "id": 86,
  "bv_code": "HOLDING",
  "vat_period": "2024-Q2",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 47

{
  "id": 87,
  "bv_code": "HOLDING",
  "vat_period": "2024-Q3",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 48

{
  "id": 88,
  "bv_code": "HOLDING",
  "vat_period": "2024-Q4",
  "correction_period": null,
  "status": "open",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": null
}

Rij 49

{
  "id": 91,
  "bv_code": "UZ",
  "vat_period": "2018-P1",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": -247,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "0BD8E011A52141FDAC986B1E317A8B0A"
}

Rij 50

{
  "id": 92,
  "bv_code": "UZ",
  "vat_period": "2017-P1",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": -2135,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "F5502C73832D4DD794026B6B32256644"
}

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)