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

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

Read-only query

SELECT * FROM "rgs_account" LIMIT 50 OFFSET 0

632 matchende rijen · offset 0 · limiet 50Vorige Volgende

id	bv_code	account_no	name	rgs_code	type	active	intercompany_bv_code
1	UZ	130	Inventaris	130	asset	1
2	UZ	131	Afschrijving inventaris	131	asset	1
3	UZ	800	Geplaatst aandelenkapitaal	800	equity	1
4	UZ	801	Overige reserves	801	equity	1
5	UZ	810	R/C RD Zwarthoff	810	asset	1
6	UZ	1100	NL11****9678	1100	asset	1
7	UZ	1101	Bank - Paypal	1101	asset	1
8	UZ	1260	Waarborgsommen	1260	asset	1
9	UZ	1298	Kruisposten	1298	asset	1
10	UZ	1300	Debiteuren	1300	asset	1
11	UZ	1302	R/C Uw Paleis	1302	liability	1	PALEIS
12	UZ	1307	R/C Uw Paleis overboekingen	1307	asset	1	PALEIS
13	UZ	1308	R/C Zwarthoff holding	1308	asset	1	HOLDING
14	UZ	1500	Crediteuren	1500	liability	1
15	UZ	1620	Btw afdracht	1620	liability	1
16	UZ	1820	Te betalen VPB	1820	liability	1
17	UZ	1830	Te betalen dividendbelasting	1830	liability	1
18	UZ	2130	Onbekende betalingen	2130	liability	1
19	UZ	4007	Opleidingskosten	4007	expense	1
20	UZ	4064	Reiskostenvergoeding werknemers	4064	expense	1
21	UZ	4160	Overige huisvestingskosten	4160	expense	1
22	UZ	4340	Overige verkoopkosten	4340	expense	1
23	UZ	4400	Reis- / verblijfskosten	4400	expense	1
24	UZ	4630	Parkeren	4630	expense	1
25	UZ	4825	Contributies & abonnementen	4825	expense	1
26	UZ	4830	Telefoon/fax/internet/porti	4830	expense	1
27	UZ	4852	Verzekeringen	4852	expense	1
28	UZ	4854	Administratie & accountantkosten	4854	expense	1
29	UZ	4868	Automatiseringskosten	4868	expense	1
30	UZ	4885	Overige algemene kosten	4885	expense	1
31	UZ	7000	Hypokeur	7000	expense	1
32	UZ	7003	Voogd & Voogd	7003	expense	1
33	UZ	8001	Omzet advieskosten	8001	income	1
34	UZ	8003	Omzet bemiddelingsvergoeding tbv geldlening	8003	income	1
35	UZ	8015	Omzet overige bemiddelingsvergoeding	8015	income	1
36	UZ	8016	Omzet extra begeleiding	8016	income	1
37	UZ	8030	Provisie Klaverblad	8030	income	1
38	UZ	8034	Provisie Ansvar	8034	income	1
39	UZ	8038	Provisie Financium	8038	income	1
40	UZ	8039	Provisie MoneyCare	8039	income	1
41	UZ	8041	Provisie Voogd	8041	income	1
42	UZ	8049	Provisie Paribas Cardiff	8049	income	1
43	UZ	8050	Provisie SAA	8050	income	1
44	UZ	8054	Provisie Crystal Marbles	8054	income	1
45	UZ	8062	Provisie Nat. Nederlanden	8062	income	1
46	UZ	9005	Bankkosten/betaalde rente	9005	expense	1
47	UZ	9006	Boetes Belastingdienst	9006	expense	1
48	HOLDING	400	Voorziening Deelnemingen	400	liability	1
49	HOLDING	620	Geplaatst Aandelenkapitaal	620	equity	1
50	HOLDING	640	Alg. Reserve	640	equity	1

Raw JSON details

Rij 1

{
  "id": 1,
  "bv_code": "UZ",
  "account_no": "130",
  "name": "Inventaris",
  "rgs_code": "130",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 2

{
  "id": 2,
  "bv_code": "UZ",
  "account_no": "131",
  "name": "Afschrijving inventaris",
  "rgs_code": "131",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 3

{
  "id": 3,
  "bv_code": "UZ",
  "account_no": "800",
  "name": "Geplaatst aandelenkapitaal",
  "rgs_code": "800",
  "type": "equity",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 4

{
  "id": 4,
  "bv_code": "UZ",
  "account_no": "801",
  "name": "Overige reserves",
  "rgs_code": "801",
  "type": "equity",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 5

{
  "id": 5,
  "bv_code": "UZ",
  "account_no": "810",
  "name": "R/C RD Zwarthoff",
  "rgs_code": "810",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 6

{
  "id": 6,
  "bv_code": "UZ",
  "account_no": "1100",
  "name": "NL11****9678",
  "rgs_code": "1100",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 7

{
  "id": 7,
  "bv_code": "UZ",
  "account_no": "1101",
  "name": "Bank - Paypal",
  "rgs_code": "1101",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 8

{
  "id": 8,
  "bv_code": "UZ",
  "account_no": "1260",
  "name": "Waarborgsommen",
  "rgs_code": "1260",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 9

{
  "id": 9,
  "bv_code": "UZ",
  "account_no": "1298",
  "name": "Kruisposten",
  "rgs_code": "1298",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 10

{
  "id": 10,
  "bv_code": "UZ",
  "account_no": "1300",
  "name": "Debiteuren",
  "rgs_code": "1300",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 11

{
  "id": 11,
  "bv_code": "UZ",
  "account_no": "1302",
  "name": "R/C Uw Paleis",
  "rgs_code": "1302",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": "PALEIS"
}

Rij 12

{
  "id": 12,
  "bv_code": "UZ",
  "account_no": "1307",
  "name": "R/C Uw Paleis overboekingen",
  "rgs_code": "1307",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": "PALEIS"
}

Rij 13

{
  "id": 13,
  "bv_code": "UZ",
  "account_no": "1308",
  "name": "R/C Zwarthoff holding",
  "rgs_code": "1308",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": "HOLDING"
}

Rij 14

{
  "id": 14,
  "bv_code": "UZ",
  "account_no": "1500",
  "name": "Crediteuren",
  "rgs_code": "1500",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 15

{
  "id": 15,
  "bv_code": "UZ",
  "account_no": "1620",
  "name": "Btw afdracht",
  "rgs_code": "1620",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 16

{
  "id": 16,
  "bv_code": "UZ",
  "account_no": "1820",
  "name": "Te betalen VPB",
  "rgs_code": "1820",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 17

{
  "id": 17,
  "bv_code": "UZ",
  "account_no": "1830",
  "name": "Te betalen dividendbelasting",
  "rgs_code": "1830",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 18

{
  "id": 18,
  "bv_code": "UZ",
  "account_no": "2130",
  "name": "Onbekende betalingen",
  "rgs_code": "2130",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 19

{
  "id": 19,
  "bv_code": "UZ",
  "account_no": "4007",
  "name": "Opleidingskosten",
  "rgs_code": "4007",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 20

{
  "id": 20,
  "bv_code": "UZ",
  "account_no": "4064",
  "name": "Reiskostenvergoeding werknemers",
  "rgs_code": "4064",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 21

{
  "id": 21,
  "bv_code": "UZ",
  "account_no": "4160",
  "name": "Overige huisvestingskosten",
  "rgs_code": "4160",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 22

{
  "id": 22,
  "bv_code": "UZ",
  "account_no": "4340",
  "name": "Overige verkoopkosten",
  "rgs_code": "4340",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 23

{
  "id": 23,
  "bv_code": "UZ",
  "account_no": "4400",
  "name": "Reis- / verblijfskosten",
  "rgs_code": "4400",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 24

{
  "id": 24,
  "bv_code": "UZ",
  "account_no": "4630",
  "name": "Parkeren",
  "rgs_code": "4630",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 25

{
  "id": 25,
  "bv_code": "UZ",
  "account_no": "4825",
  "name": "Contributies & abonnementen",
  "rgs_code": "4825",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 26

{
  "id": 26,
  "bv_code": "UZ",
  "account_no": "4830",
  "name": "Telefoon/fax/internet/porti",
  "rgs_code": "4830",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 27

{
  "id": 27,
  "bv_code": "UZ",
  "account_no": "4852",
  "name": "Verzekeringen",
  "rgs_code": "4852",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 28

{
  "id": 28,
  "bv_code": "UZ",
  "account_no": "4854",
  "name": "Administratie & accountantkosten",
  "rgs_code": "4854",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 29

{
  "id": 29,
  "bv_code": "UZ",
  "account_no": "4868",
  "name": "Automatiseringskosten",
  "rgs_code": "4868",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 30

{
  "id": 30,
  "bv_code": "UZ",
  "account_no": "4885",
  "name": "Overige algemene kosten",
  "rgs_code": "4885",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 31

{
  "id": 31,
  "bv_code": "UZ",
  "account_no": "7000",
  "name": "Hypokeur",
  "rgs_code": "7000",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 32

{
  "id": 32,
  "bv_code": "UZ",
  "account_no": "7003",
  "name": "Voogd & Voogd",
  "rgs_code": "7003",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 33

{
  "id": 33,
  "bv_code": "UZ",
  "account_no": "8001",
  "name": "Omzet advieskosten",
  "rgs_code": "8001",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 34

{
  "id": 34,
  "bv_code": "UZ",
  "account_no": "8003",
  "name": "Omzet bemiddelingsvergoeding tbv geldlening",
  "rgs_code": "8003",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 35

{
  "id": 35,
  "bv_code": "UZ",
  "account_no": "8015",
  "name": "Omzet overige bemiddelingsvergoeding",
  "rgs_code": "8015",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 36

{
  "id": 36,
  "bv_code": "UZ",
  "account_no": "8016",
  "name": "Omzet extra begeleiding",
  "rgs_code": "8016",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 37

{
  "id": 37,
  "bv_code": "UZ",
  "account_no": "8030",
  "name": "Provisie Klaverblad",
  "rgs_code": "8030",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 38

{
  "id": 38,
  "bv_code": "UZ",
  "account_no": "8034",
  "name": "Provisie Ansvar",
  "rgs_code": "8034",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 39

{
  "id": 39,
  "bv_code": "UZ",
  "account_no": "8038",
  "name": "Provisie Financium",
  "rgs_code": "8038",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 40

{
  "id": 40,
  "bv_code": "UZ",
  "account_no": "8039",
  "name": "Provisie MoneyCare",
  "rgs_code": "8039",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 41

{
  "id": 41,
  "bv_code": "UZ",
  "account_no": "8041",
  "name": "Provisie Voogd",
  "rgs_code": "8041",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 42

{
  "id": 42,
  "bv_code": "UZ",
  "account_no": "8049",
  "name": "Provisie Paribas Cardiff",
  "rgs_code": "8049",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 43

{
  "id": 43,
  "bv_code": "UZ",
  "account_no": "8050",
  "name": "Provisie SAA",
  "rgs_code": "8050",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 44

{
  "id": 44,
  "bv_code": "UZ",
  "account_no": "8054",
  "name": "Provisie Crystal Marbles",
  "rgs_code": "8054",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 45

{
  "id": 45,
  "bv_code": "UZ",
  "account_no": "8062",
  "name": "Provisie Nat. Nederlanden",
  "rgs_code": "8062",
  "type": "income",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 46

{
  "id": 46,
  "bv_code": "UZ",
  "account_no": "9005",
  "name": "Bankkosten/betaalde rente",
  "rgs_code": "9005",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 47

{
  "id": 47,
  "bv_code": "UZ",
  "account_no": "9006",
  "name": "Boetes Belastingdienst",
  "rgs_code": "9006",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 48

{
  "id": 48,
  "bv_code": "HOLDING",
  "account_no": "400",
  "name": "Voorziening Deelnemingen",
  "rgs_code": "400",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 49

{
  "id": 49,
  "bv_code": "HOLDING",
  "account_no": "620",
  "name": "Geplaatst Aandelenkapitaal",
  "rgs_code": "620",
  "type": "equity",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 50

{
  "id": 50,
  "bv_code": "HOLDING",
  "account_no": "640",
  "name": "Alg. Reserve",
  "rgs_code": "640",
  "type": "equity",
  "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)