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.150 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 100

632 matchende rijen · offset 100 · limiet 50Vorige Volgende

id	bv_code	account_no	name	rgs_code	type	active
101	UZ	4140	Schoonmaakkosten	SS4140	expense	1
102	UZ	4150	Onderhoud inventaris	SS4150	expense	1
103	UZ	4305	Reclame/advertenties/marketing	SS4305	expense	1
104	UZ	4320	Repre.kosten & relatiegeschenken	SS4320	expense	1
105	UZ	4342	Kantinekosten	SS4342	expense	1
106	UZ	4502	Betalingsverschillen	SS4502	expense	1
107	UZ	4610	Brandstof	SS4610	expense	1
108	UZ	4640	Onderhoud autos	SS4640	expense	1
109	UZ	4650	Motorrijtuigenbelasting	SS4650	expense	1
110	UZ	4730	Afschrijvingskosten autos	SS4730	expense	1
111	UZ	4780	Afschrijvingskosten inventaris	SS4780	expense	1
112	UZ	4810	Kantoorbenodigdheden	SS4810	expense	1
113	UZ	4855	Juridische kosten	SS4855	expense	1
114	UZ	4858	Dotatie voorzieningen dub.deb.	SS4858	expense	1
115	UZ	4875	Kantoorkosten	SS4875	expense	1
116	UZ	4880	BTW auto	SS4880	expense	1
117	UZ	7001	Leaseweb	SS7001	expense	1
118	UZ	7002	Starterslening.nl	SS7002	expense	1
119	UZ	7004	Zien 24 (100%)	SS7004	expense	1
120	UZ	7005	Funda (100%)	SS7005	expense	1
121	UZ	7006	Kadaster	SS7006	expense	1
122	UZ	7007	Housenet (100%)	SS7007	expense	1
123	UZ	7008	BKR	SS7008	expense	1
124	UZ	7009	Perfectkeur (100%)	SS7009	income	1
125	UZ	7011	Nationale waarborg	SS7011	expense	1
126	UZ	7012	Immospot (100%)	SS7012	expense	1
127	UZ	7013	Zibber (100%)	SS7013	expense	1
128	UZ	7014	Calsaca (100%)	SS7014	expense	1
129	UZ	8000	Omzet toetskwartieren	SS8000	income	1
130	UZ	8002	Omzet belastingaangiften	SS8002	income	1
131	UZ	8004	Honorarium makelaar (BTW)	SS8004	income	1
132	UZ	8007	Omzet Funda	SS8007	income	1
133	UZ	8008	Omzet Kadaster	SS8008	income	1
134	UZ	8009	Omzet Fotograaf	SS8009	income	1
135	UZ	8010	Honorarium makelaar	SS8010	income	1
136	UZ	8011	Omzet Prestatiepakket	SS8011	income	1
137	UZ	8012	Omzet Aankoop courtage	SS8012	income	1
138	UZ	8017	Omzet begeleiding SVN	SS8017	income	1
139	UZ	8020	Boekwinst op activa	SS8020	expense	1
140	UZ	8021	Omzet Uw paleis (verkoop) 21%	SS8021	income	1
141	UZ	8022	Omzet financieel advies	SS8022	income	1
142	UZ	8023	Omzet financieel advies BTW	SS8023	income	1
143	UZ	8031	Provisie Delta Lloyd	SS8031	income	1
144	UZ	8033	Provisie Stad Holland	SS8033	income	1
145	UZ	8035	Provisie Credivance	SS8035	income	1
146	UZ	8036	Provisie Dazure	SS8036	income	1
147	UZ	8037	Provisie De Kredietmakelaar	SS8037	income	1
148	UZ	8042	Provisie Yarden	SS8042	income	1
149	UZ	8044	Provisie ASR	SS8044	income	1
150	UZ	8046	Provisie ING	SS8046	income	1

Raw JSON details

Rij 101

{
  "id": 101,
  "bv_code": "UZ",
  "account_no": "4140",
  "name": "Schoonmaakkosten",
  "rgs_code": "SS4140",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 102

{
  "id": 102,
  "bv_code": "UZ",
  "account_no": "4150",
  "name": "Onderhoud inventaris",
  "rgs_code": "SS4150",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 103

{
  "id": 103,
  "bv_code": "UZ",
  "account_no": "4305",
  "name": "Reclame/advertenties/marketing",
  "rgs_code": "SS4305",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 104

{
  "id": 104,
  "bv_code": "UZ",
  "account_no": "4320",
  "name": "Repre.kosten & relatiegeschenken",
  "rgs_code": "SS4320",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 105

{
  "id": 105,
  "bv_code": "UZ",
  "account_no": "4342",
  "name": "Kantinekosten",
  "rgs_code": "SS4342",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 106

{
  "id": 106,
  "bv_code": "UZ",
  "account_no": "4502",
  "name": "Betalingsverschillen",
  "rgs_code": "SS4502",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 107

{
  "id": 107,
  "bv_code": "UZ",
  "account_no": "4610",
  "name": "Brandstof",
  "rgs_code": "SS4610",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 108

{
  "id": 108,
  "bv_code": "UZ",
  "account_no": "4640",
  "name": "Onderhoud autos",
  "rgs_code": "SS4640",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 109

{
  "id": 109,
  "bv_code": "UZ",
  "account_no": "4650",
  "name": "Motorrijtuigenbelasting",
  "rgs_code": "SS4650",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 110

{
  "id": 110,
  "bv_code": "UZ",
  "account_no": "4730",
  "name": "Afschrijvingskosten autos",
  "rgs_code": "SS4730",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 111

{
  "id": 111,
  "bv_code": "UZ",
  "account_no": "4780",
  "name": "Afschrijvingskosten inventaris",
  "rgs_code": "SS4780",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 112

{
  "id": 112,
  "bv_code": "UZ",
  "account_no": "4810",
  "name": "Kantoorbenodigdheden",
  "rgs_code": "SS4810",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 113

{
  "id": 113,
  "bv_code": "UZ",
  "account_no": "4855",
  "name": "Juridische kosten",
  "rgs_code": "SS4855",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 114

{
  "id": 114,
  "bv_code": "UZ",
  "account_no": "4858",
  "name": "Dotatie voorzieningen dub.deb.",
  "rgs_code": "SS4858",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 115

{
  "id": 115,
  "bv_code": "UZ",
  "account_no": "4875",
  "name": "Kantoorkosten",
  "rgs_code": "SS4875",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 116

{
  "id": 116,
  "bv_code": "UZ",
  "account_no": "4880",
  "name": "BTW auto",
  "rgs_code": "SS4880",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 117

{
  "id": 117,
  "bv_code": "UZ",
  "account_no": "7001",
  "name": "Leaseweb",
  "rgs_code": "SS7001",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 118

{
  "id": 118,
  "bv_code": "UZ",
  "account_no": "7002",
  "name": "Starterslening.nl",
  "rgs_code": "SS7002",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 119

{
  "id": 119,
  "bv_code": "UZ",
  "account_no": "7004",
  "name": "Zien 24 (100%)",
  "rgs_code": "SS7004",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 120

{
  "id": 120,
  "bv_code": "UZ",
  "account_no": "7005",
  "name": "Funda (100%)",
  "rgs_code": "SS7005",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 121

{
  "id": 121,
  "bv_code": "UZ",
  "account_no": "7006",
  "name": "Kadaster",
  "rgs_code": "SS7006",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 122

{
  "id": 122,
  "bv_code": "UZ",
  "account_no": "7007",
  "name": "Housenet (100%)",
  "rgs_code": "SS7007",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 123

{
  "id": 123,
  "bv_code": "UZ",
  "account_no": "7008",
  "name": "BKR",
  "rgs_code": "SS7008",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 124

{
  "id": 124,
  "bv_code": "UZ",
  "account_no": "7009",
  "name": "Perfectkeur (100%)",
  "rgs_code": "SS7009",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 125

{
  "id": 125,
  "bv_code": "UZ",
  "account_no": "7011",
  "name": "Nationale waarborg",
  "rgs_code": "SS7011",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 126

{
  "id": 126,
  "bv_code": "UZ",
  "account_no": "7012",
  "name": "Immospot (100%)",
  "rgs_code": "SS7012",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 127

{
  "id": 127,
  "bv_code": "UZ",
  "account_no": "7013",
  "name": "Zibber (100%)",
  "rgs_code": "SS7013",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 128

{
  "id": 128,
  "bv_code": "UZ",
  "account_no": "7014",
  "name": "Calsaca (100%)",
  "rgs_code": "SS7014",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 129

{
  "id": 129,
  "bv_code": "UZ",
  "account_no": "8000",
  "name": "Omzet toetskwartieren",
  "rgs_code": "SS8000",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 130

{
  "id": 130,
  "bv_code": "UZ",
  "account_no": "8002",
  "name": "Omzet belastingaangiften",
  "rgs_code": "SS8002",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 131

{
  "id": 131,
  "bv_code": "UZ",
  "account_no": "8004",
  "name": "Honorarium makelaar (BTW)",
  "rgs_code": "SS8004",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 132

{
  "id": 132,
  "bv_code": "UZ",
  "account_no": "8007",
  "name": "Omzet Funda",
  "rgs_code": "SS8007",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 133

{
  "id": 133,
  "bv_code": "UZ",
  "account_no": "8008",
  "name": "Omzet Kadaster",
  "rgs_code": "SS8008",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 134

{
  "id": 134,
  "bv_code": "UZ",
  "account_no": "8009",
  "name": "Omzet Fotograaf",
  "rgs_code": "SS8009",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 135

{
  "id": 135,
  "bv_code": "UZ",
  "account_no": "8010",
  "name": "Honorarium makelaar",
  "rgs_code": "SS8010",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 136

{
  "id": 136,
  "bv_code": "UZ",
  "account_no": "8011",
  "name": "Omzet Prestatiepakket",
  "rgs_code": "SS8011",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 137

{
  "id": 137,
  "bv_code": "UZ",
  "account_no": "8012",
  "name": "Omzet Aankoop courtage",
  "rgs_code": "SS8012",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 138

{
  "id": 138,
  "bv_code": "UZ",
  "account_no": "8017",
  "name": "Omzet begeleiding SVN",
  "rgs_code": "SS8017",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 139

{
  "id": 139,
  "bv_code": "UZ",
  "account_no": "8020",
  "name": "Boekwinst op activa",
  "rgs_code": "SS8020",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 140

{
  "id": 140,
  "bv_code": "UZ",
  "account_no": "8021",
  "name": "Omzet Uw paleis (verkoop) 21%",
  "rgs_code": "SS8021",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 141

{
  "id": 141,
  "bv_code": "UZ",
  "account_no": "8022",
  "name": "Omzet financieel advies",
  "rgs_code": "SS8022",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 142

{
  "id": 142,
  "bv_code": "UZ",
  "account_no": "8023",
  "name": "Omzet financieel advies BTW",
  "rgs_code": "SS8023",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 143

{
  "id": 143,
  "bv_code": "UZ",
  "account_no": "8031",
  "name": "Provisie Delta Lloyd",
  "rgs_code": "SS8031",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 144

{
  "id": 144,
  "bv_code": "UZ",
  "account_no": "8033",
  "name": "Provisie Stad Holland",
  "rgs_code": "SS8033",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 145

{
  "id": 145,
  "bv_code": "UZ",
  "account_no": "8035",
  "name": "Provisie Credivance",
  "rgs_code": "SS8035",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 146

{
  "id": 146,
  "bv_code": "UZ",
  "account_no": "8036",
  "name": "Provisie Dazure",
  "rgs_code": "SS8036",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 147

{
  "id": 147,
  "bv_code": "UZ",
  "account_no": "8037",
  "name": "Provisie De Kredietmakelaar",
  "rgs_code": "SS8037",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 148

{
  "id": 148,
  "bv_code": "UZ",
  "account_no": "8042",
  "name": "Provisie Yarden",
  "rgs_code": "SS8042",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 149

{
  "id": 149,
  "bv_code": "UZ",
  "account_no": "8044",
  "name": "Provisie ASR",
  "rgs_code": "SS8044",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 150

{
  "id": 150,
  "bv_code": "UZ",
  "account_no": "8046",
  "name": "Provisie ING",
  "rgs_code": "SS8046",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "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)