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.vat_declaration

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

Read-only query

SELECT * FROM "vat_declaration" LIMIT 50 OFFSET 50

77 matchende rijen · offset 50 · limiet 50Vorige Volgende

id	bv_code	vat_period	correction_period	status	total_owed_cents	submitted_at	reference
93	UZ	2017-P2		ready	-4843		096B63479D7A4CDFAB672B5007CD9351
94	UZ	2017-P3		ready	-7364		5148199805B941B0BCA4A99FC914866C
95	UZ	2018-P2		ready	-1900		44CCB09DAB624AE881E556B2980E5513
96	UZ	2017-P4		ready	-8014		AA13****D745
98	UZ	2018-P3		submitted	-2065	2018-10-29	2821247161801270
99	UZ	2017-P17	suppletie	submitted		2019-01-28	927A08357E4943BAA9D7FF298E748C98
100	UZ	2018-P4		submitted	-249	2019-01-28	0821247161801300
101	UZ	2019-P1		ready	2603		6821247161901210
102	UZ	2019-P2		submitted	2981	2019-07-25	5821247161901240
103	UZ	2018-P17	suppletie	ready			3821247161801400
104	UZ	2019-P3		submitted	-3433	2019-10-28	4821247161901270
105	UZ	2019-P4		submitted	-4406	2020-01-03	2821247161901300
106	UZ	2020-P1		submitted	-565	2020-04-24	1821247161001210
107	UZ	2020-P2		submitted	-2631	2020-07-10	9821247161001240
108	UZ	2020-P3		submitted	1315	2020-10-16	8821247161001270
109	UZ	2020-P4		submitted	-45	2021-01-20	6821247161001300
110	UZ	2021-P1		submitted	0	2021-04-29	1821247161101210
111	UZ	2021-P2		ready	0		0821247161101240
112	UZ	2024-P1		ready	0		7821247161401210
113	UZ	2024-P2		ready	0		6821247161401240
114	UZ	2024-P3		ready	0		5821247161401270
115	UZ	2024-P4		ready	0		3821247161401300
116	UZ	2025-P1		ready	0		9821247161501210
117	UZ	2025-P2		ready	0		8821247161501240
118	UZ	2025-P3		ready	0		7821247161501270
119	UZ	2025-P4		ready	0		5821247161501300
120	UZ	2026-P1		ready	-233		0821247161601210

Raw JSON details

Rij 51

{
  "id": 93,
  "bv_code": "UZ",
  "vat_period": "2017-P2",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": -4843,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "096B63479D7A4CDFAB672B5007CD9351"
}

Rij 52

{
  "id": 94,
  "bv_code": "UZ",
  "vat_period": "2017-P3",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": -7364,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "5148199805B941B0BCA4A99FC914866C"
}

Rij 53

{
  "id": 95,
  "bv_code": "UZ",
  "vat_period": "2018-P2",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": -1900,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "44CCB09DAB624AE881E556B2980E5513"
}

Rij 54

{
  "id": 96,
  "bv_code": "UZ",
  "vat_period": "2017-P4",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": -8014,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "AA13****D745"
}

Rij 55

{
  "id": 98,
  "bv_code": "UZ",
  "vat_period": "2018-P3",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": -2065,
  "submitted_at": "2018-10-29",
  "accepted_at": null,
  "reference": "2821247161801270"
}

Rij 56

{
  "id": 99,
  "bv_code": "UZ",
  "vat_period": "2017-P17",
  "correction_period": "suppletie",
  "status": "submitted",
  "total_owed_cents": null,
  "submitted_at": "2019-01-28",
  "accepted_at": null,
  "reference": "927A08357E4943BAA9D7FF298E748C98"
}

Rij 57

{
  "id": 100,
  "bv_code": "UZ",
  "vat_period": "2018-P4",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": -249,
  "submitted_at": "2019-01-28",
  "accepted_at": null,
  "reference": "0821247161801300"
}

Rij 58

{
  "id": 101,
  "bv_code": "UZ",
  "vat_period": "2019-P1",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": 2603,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "6821247161901210"
}

Rij 59

{
  "id": 102,
  "bv_code": "UZ",
  "vat_period": "2019-P2",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": 2981,
  "submitted_at": "2019-07-25",
  "accepted_at": null,
  "reference": "5821247161901240"
}

Rij 60

{
  "id": 103,
  "bv_code": "UZ",
  "vat_period": "2018-P17",
  "correction_period": "suppletie",
  "status": "ready",
  "total_owed_cents": null,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "3821247161801400"
}

Rij 61

{
  "id": 104,
  "bv_code": "UZ",
  "vat_period": "2019-P3",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": -3433,
  "submitted_at": "2019-10-28",
  "accepted_at": null,
  "reference": "4821247161901270"
}

Rij 62

{
  "id": 105,
  "bv_code": "UZ",
  "vat_period": "2019-P4",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": -4406,
  "submitted_at": "2020-01-03",
  "accepted_at": null,
  "reference": "2821247161901300"
}

Rij 63

{
  "id": 106,
  "bv_code": "UZ",
  "vat_period": "2020-P1",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": -565,
  "submitted_at": "2020-04-24",
  "accepted_at": null,
  "reference": "1821247161001210"
}

Rij 64

{
  "id": 107,
  "bv_code": "UZ",
  "vat_period": "2020-P2",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": -2631,
  "submitted_at": "2020-07-10",
  "accepted_at": null,
  "reference": "9821247161001240"
}

Rij 65

{
  "id": 108,
  "bv_code": "UZ",
  "vat_period": "2020-P3",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": 1315,
  "submitted_at": "2020-10-16",
  "accepted_at": null,
  "reference": "8821247161001270"
}

Rij 66

{
  "id": 109,
  "bv_code": "UZ",
  "vat_period": "2020-P4",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": -45,
  "submitted_at": "2021-01-20",
  "accepted_at": null,
  "reference": "6821247161001300"
}

Rij 67

{
  "id": 110,
  "bv_code": "UZ",
  "vat_period": "2021-P1",
  "correction_period": null,
  "status": "submitted",
  "total_owed_cents": 0,
  "submitted_at": "2021-04-29",
  "accepted_at": null,
  "reference": "1821247161101210"
}

Rij 68

{
  "id": 111,
  "bv_code": "UZ",
  "vat_period": "2021-P2",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": 0,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "0821247161101240"
}

Rij 69

{
  "id": 112,
  "bv_code": "UZ",
  "vat_period": "2024-P1",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": 0,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "7821247161401210"
}

Rij 70

{
  "id": 113,
  "bv_code": "UZ",
  "vat_period": "2024-P2",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": 0,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "6821247161401240"
}

Rij 71

{
  "id": 114,
  "bv_code": "UZ",
  "vat_period": "2024-P3",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": 0,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "5821247161401270"
}

Rij 72

{
  "id": 115,
  "bv_code": "UZ",
  "vat_period": "2024-P4",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": 0,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "3821247161401300"
}

Rij 73

{
  "id": 116,
  "bv_code": "UZ",
  "vat_period": "2025-P1",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": 0,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "9821247161501210"
}

Rij 74

{
  "id": 117,
  "bv_code": "UZ",
  "vat_period": "2025-P2",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": 0,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "8821247161501240"
}

Rij 75

{
  "id": 118,
  "bv_code": "UZ",
  "vat_period": "2025-P3",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": 0,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "7821247161501270"
}

Rij 76

{
  "id": 119,
  "bv_code": "UZ",
  "vat_period": "2025-P4",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": 0,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "5821247161501300"
}

Rij 77

{
  "id": 120,
  "bv_code": "UZ",
  "vat_period": "2026-P1",
  "correction_period": null,
  "status": "ready",
  "total_owed_cents": -233,
  "submitted_at": null,
  "accepted_at": null,
  "reference": "0821247161601210"
}

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)