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 bronnen69 tabellen/stores257.574 rijen/items22 domeincontainers

Zoeken

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

Rijen: boekhouding-sqlite.rgs_account

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

Read-only query

SELECT * FROM "rgs_account" LIMIT 50 OFFSET 600

632 matchende rijen · offset 600 · limiet 50Vorige Volgende

id	bv_code	account_no	name	rgs_code	type	active	rubriek	intercompany_bv_code
601	UZ	4750	Afschrijvingskosten computers	SNL-UZ-4750	expense	1	Afschrijvingskosten
602	UZ	4760	Afschrijvingskosten goodwill	SNL-UZ-4760	expense	1	Afschrijvingskosten
603	UZ	4770	Afschrijvingskosten machines	SNL-UZ-4770	expense	1	Afschrijvingskosten
604	UZ	4800	A L G E M E N E K O S T E N	SNL-UZ-4800	expense	1	* VERLIES & WINST *
605	UZ	4876	Kantoorkosten buiten EU	SNL-UZ-4876	expense	1	Algemene kosten
606	UZ	6999	I N K O O P K O S T E N	SNL-UZ-6999	expense	1	* BALANS *
607	UZ	7010	Gereedschappen	SNL-UZ-7010	expense	1	Inkoopkosten
608	UZ	7020	Materialen	SNL-UZ-7020	expense	1	Inkoopkosten
609	UZ	7030	Inhuur derden	SNL-UZ-7030	expense	1	Inkoopkosten
610	UZ	7095	Kredietbeperking inkopen	SNL-UZ-7095	expense	1	Inkoopkosten
611	UZ	7102	Inkoop globalisatie	SNL-UZ-7102	expense	1	Inkoopkosten
612	UZ	7103	Inkoop occasions (globalisatie)	SNL-UZ-7103	expense	1	Inkoopkosten
613	UZ	7104	Inkoop btw occasions	SNL-UZ-7104	expense	1	Inkoopkosten
614	UZ	7105	Inkoop nieuwe voertuigen	SNL-UZ-7105	expense	1	Inkoopkosten
615	UZ	7106	Btw globalisatie	SNL-UZ-7106	expense	1	Bijzondere baten en lasten
616	UZ	7200	BPM in inkoop	SNL-UZ-7200	expense	1	Inkoopkosten
617	UZ	7999	V E R K O P E N	SNL-UZ-7999	expense	1	* BALANS *
618	UZ	8005	Omzet buiten EU	SNL-UZ-8005	expense	1	Bemiddeling
619	UZ	8006	Omzet Uw paleis (verkoop) 0%	SNL-UZ-8006	expense	1	Bemiddeling	PALEIS
620	UZ	8032	Provisie LNI	SNL-UZ-8032	expense	1	Provisie
621	UZ	8040	Provisie Onderlinge	SNL-UZ-8040	expense	1	Provisie
622	UZ	8043	Provisie Stad Holland	SNL-UZ-8043	income	1	* BALANS *
623	UZ	8045	Provisie Aegon	SNL-UZ-8045	expense	1	Provisie
624	UZ	8047	Provisie Reaal	SNL-UZ-8047	expense	1	Provisie
625	UZ	8056	Provisie WEB MANAGER	SNL-UZ-8056	expense	1	Provisie
626	UZ	8057	Provisie FKJ Notaris	SNL-UZ-8057	expense	1	Provisie
627	UZ	8058	Provisie HAK EN REIN VOS	SNL-UZ-8058	expense	0	Provisie
628	UZ	8090	F I N A N C I Ë L E L A S T E N / B A T E N	SNL-UZ-8090	income	1	* BALANS *
629	UZ	8095	Kredietbeperking verkopen	SNL-UZ-8095	income	1	Omzet
630	UZ	9990	V E R K O P E N	SNL-UZ-9990	expense	0	Bijzondere baten en lasten
631	UZ	9999	Winst of Verlies	SNL-UZ-9999	expense	1	Bijzondere baten en lasten
632	HOLDING	9010	Rente r/c directie	SS9010	expense	0

Raw JSON details

Rij 601

{
  "id": 601,
  "bv_code": "UZ",
  "account_no": "4750",
  "name": "Afschrijvingskosten computers",
  "rgs_code": "SNL-UZ-4750",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Afschrijvingskosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 602

{
  "id": 602,
  "bv_code": "UZ",
  "account_no": "4760",
  "name": "Afschrijvingskosten goodwill",
  "rgs_code": "SNL-UZ-4760",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Afschrijvingskosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 603

{
  "id": 603,
  "bv_code": "UZ",
  "account_no": "4770",
  "name": "Afschrijvingskosten machines",
  "rgs_code": "SNL-UZ-4770",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Afschrijvingskosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 604

{
  "id": 604,
  "bv_code": "UZ",
  "account_no": "4800",
  "name": "A L G E M E N E     K O S T E N",
  "rgs_code": "SNL-UZ-4800",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "*** VERLIES & WINST ***",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 605

{
  "id": 605,
  "bv_code": "UZ",
  "account_no": "4876",
  "name": "Kantoorkosten buiten EU",
  "rgs_code": "SNL-UZ-4876",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Algemene kosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 606

{
  "id": 606,
  "bv_code": "UZ",
  "account_no": "6999",
  "name": "I N K O O P K O S T E N",
  "rgs_code": "SNL-UZ-6999",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "*** BALANS ***",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 607

{
  "id": 607,
  "bv_code": "UZ",
  "account_no": "7010",
  "name": "Gereedschappen",
  "rgs_code": "SNL-UZ-7010",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Inkoopkosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 608

{
  "id": 608,
  "bv_code": "UZ",
  "account_no": "7020",
  "name": "Materialen",
  "rgs_code": "SNL-UZ-7020",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Inkoopkosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 609

{
  "id": 609,
  "bv_code": "UZ",
  "account_no": "7030",
  "name": "Inhuur derden",
  "rgs_code": "SNL-UZ-7030",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Inkoopkosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 610

{
  "id": 610,
  "bv_code": "UZ",
  "account_no": "7095",
  "name": "Kredietbeperking inkopen",
  "rgs_code": "SNL-UZ-7095",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Inkoopkosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 611

{
  "id": 611,
  "bv_code": "UZ",
  "account_no": "7102",
  "name": "Inkoop globalisatie",
  "rgs_code": "SNL-UZ-7102",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Inkoopkosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 612

{
  "id": 612,
  "bv_code": "UZ",
  "account_no": "7103",
  "name": "Inkoop occasions (globalisatie)",
  "rgs_code": "SNL-UZ-7103",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Inkoopkosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 613

{
  "id": 613,
  "bv_code": "UZ",
  "account_no": "7104",
  "name": "Inkoop btw occasions",
  "rgs_code": "SNL-UZ-7104",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Inkoopkosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 614

{
  "id": 614,
  "bv_code": "UZ",
  "account_no": "7105",
  "name": "Inkoop nieuwe voertuigen",
  "rgs_code": "SNL-UZ-7105",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Inkoopkosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 615

{
  "id": 615,
  "bv_code": "UZ",
  "account_no": "7106",
  "name": "Btw globalisatie",
  "rgs_code": "SNL-UZ-7106",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Bijzondere baten en lasten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 616

{
  "id": 616,
  "bv_code": "UZ",
  "account_no": "7200",
  "name": "BPM in inkoop",
  "rgs_code": "SNL-UZ-7200",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Inkoopkosten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 617

{
  "id": 617,
  "bv_code": "UZ",
  "account_no": "7999",
  "name": "V E R K O P E N",
  "rgs_code": "SNL-UZ-7999",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "*** BALANS ***",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 618

{
  "id": 618,
  "bv_code": "UZ",
  "account_no": "8005",
  "name": "Omzet buiten EU",
  "rgs_code": "SNL-UZ-8005",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Bemiddeling",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 619

{
  "id": 619,
  "bv_code": "UZ",
  "account_no": "8006",
  "name": "Omzet Uw paleis (verkoop) 0%",
  "rgs_code": "SNL-UZ-8006",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Bemiddeling",
  "niveau": null,
  "intercompany_bv_code": "PALEIS"
}

Rij 620

{
  "id": 620,
  "bv_code": "UZ",
  "account_no": "8032",
  "name": "Provisie LNI",
  "rgs_code": "SNL-UZ-8032",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Provisie",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 621

{
  "id": 621,
  "bv_code": "UZ",
  "account_no": "8040",
  "name": "Provisie Onderlinge",
  "rgs_code": "SNL-UZ-8040",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Provisie",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 622

{
  "id": 622,
  "bv_code": "UZ",
  "account_no": "8043",
  "name": "Provisie Stad Holland",
  "rgs_code": "SNL-UZ-8043",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "*** BALANS ***",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 623

{
  "id": 623,
  "bv_code": "UZ",
  "account_no": "8045",
  "name": "Provisie Aegon",
  "rgs_code": "SNL-UZ-8045",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Provisie",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 624

{
  "id": 624,
  "bv_code": "UZ",
  "account_no": "8047",
  "name": "Provisie Reaal",
  "rgs_code": "SNL-UZ-8047",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Provisie",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 625

{
  "id": 625,
  "bv_code": "UZ",
  "account_no": "8056",
  "name": "Provisie WEB MANAGER",
  "rgs_code": "SNL-UZ-8056",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Provisie",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 626

{
  "id": 626,
  "bv_code": "UZ",
  "account_no": "8057",
  "name": "Provisie FKJ Notaris",
  "rgs_code": "SNL-UZ-8057",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Provisie",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 627

{
  "id": 627,
  "bv_code": "UZ",
  "account_no": "8058",
  "name": "Provisie HAK EN REIN VOS",
  "rgs_code": "SNL-UZ-8058",
  "type": "expense",
  "vat_default_code": null,
  "active": 0,
  "parent_account_no": null,
  "rubriek": "Provisie",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 628

{
  "id": 628,
  "bv_code": "UZ",
  "account_no": "8090",
  "name": "F I N A N C I Ë L E   L A S T E N / B A T E N",
  "rgs_code": "SNL-UZ-8090",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "*** BALANS ***",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 629

{
  "id": 629,
  "bv_code": "UZ",
  "account_no": "8095",
  "name": "Kredietbeperking verkopen",
  "rgs_code": "SNL-UZ-8095",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Omzet",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 630

{
  "id": 630,
  "bv_code": "UZ",
  "account_no": "9990",
  "name": "V E R K O P E N",
  "rgs_code": "SNL-UZ-9990",
  "type": "expense",
  "vat_default_code": null,
  "active": 0,
  "parent_account_no": null,
  "rubriek": "Bijzondere baten en lasten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 631

{
  "id": 631,
  "bv_code": "UZ",
  "account_no": "9999",
  "name": "Winst of Verlies",
  "rgs_code": "SNL-UZ-9999",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": "Bijzondere baten en lasten",
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 632

{
  "id": 632,
  "bv_code": "HOLDING",
  "account_no": "9010",
  "name": "Rente r/c directie",
  "rgs_code": "SS9010",
  "type": "expense",
  "vat_default_code": null,
  "active": 0,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": 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)