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 50

632 matchende rijen · offset 50 · limiet 50Vorige Volgende

id	bv_code	account_no	name	rgs_code	type	active	intercompany_bv_code
51	HOLDING	652	Privé-opnamen firmant 1	652	asset	1
52	HOLDING	1100	NL47****9112	1100	asset	1
53	HOLDING	1301	Debiteur	1301	asset	1
54	HOLDING	1482	Leningen U/G	1482	asset	1
55	HOLDING	1600	Crediteuren	1600	liability	1
56	HOLDING	1640	Rekening-courant R.D. Zwarthoff	1640	asset	1
57	HOLDING	1641	Rekening-courant Zekerheid B.V.	1641	liability	1	UZ
58	HOLDING	1642	Rekening-courant Paleis	1642	asset	1	PALEIS
59	HOLDING	1680	Btw te vorderen hoog (inkopen)	1680	asset	1
60	HOLDING	1684	Btw afdracht	1684	liability	1
61	HOLDING	1687	Te betalen loonheffing	1687	liability	1
62	HOLDING	1740	Vennootschapsbelasting	1740	asset	1
63	HOLDING	4606	Contributies en abonnementen	4606	expense	1
64	HOLDING	4700	Accountants- en advieskosten	4700	expense	1
65	HOLDING	4753	Bankkosten	4753	expense	1
66	HOLDING	4757	Boetes belastingen premies soc. verzekeringen	4757	expense	1
67	UZ	1200	NL91****9199	1200	asset	1
68	UZ	1810	Te betalen loonheffing	1810	liability	1
69	UZ	1850	Te betalen netto loon	1850	liability	1
70	UZ	2100	Tussenrekening balans	2100	asset	1
71	HOLDING	2010	Tussenrekening balans	2010	asset	1
72	UZ	2110	Tussenrekening (overig)	2110	asset	1
73	UZ	9998	Memoriaal tussenrekening	9998	asset	1
74	UZ	10000	Mollie	10000	asset	1
75	HOLDING	2011	Tussenrekening (overig)	2011	asset	1
76	HOLDING	4798	Overige kosten	4798	expense	1
77	PALEIS	1100	NL17****2419	BLimBanRba	asset	1
78	PALEIS	9005	Bankkosten/betaalde rente	WFinRla	expense	1
79	HOLDING	9005	Bankkosten/betaalde rente	WFinRla	expense	1
80	UZ	1	U I T Z O E K E N	SS1	asset	1
81	UZ	1000	Kas	SS1000	asset	1
82	UZ	1265	Beleggingen	SS1265	asset	1
83	UZ	1271	Transitoria Salarissen	SS1271	asset	1
84	UZ	1301	Debiteuren 2016	SS1301	asset	1
85	UZ	140	Autos	SS140	asset	1
86	UZ	141	Afschrijving autos	SS141	asset	1
87	UZ	1501	Crediteuren 2016	SS1501	liability	1
88	UZ	1602	Btw af te dragen hoog (verkopen)	SS1602	liability	1
89	UZ	1611	Btw te vorderen laag (inkopen)	SS1611	liability	1
90	UZ	1612	Btw te vorderen hoog (inkopen)	SS1612	liability	1
91	UZ	1625	Btw vorige jaren	SS1625	liability	1
92	UZ	1890	Te betalen vakantiegeld	SS1890	liability	1
93	UZ	2240	Tussenrekening correcties	SS2240	asset	1
94	UZ	4001	Lonen	SS4001	expense	1
95	UZ	4002	Management Fee	SS4002	expense	1
96	UZ	4006	Te betalen vakantiegeld	SS4006	expense	1
97	UZ	4030	Sociale lasten	SS4030	expense	1
98	UZ	4082	Overige personeelskosten	SS4082	expense	1
99	UZ	4101	Huur	SS4101	expense	1
100	UZ	4120	Gas/water/electriciteit	SS4120	expense	1

Raw JSON details

Rij 51

{
  "id": 51,
  "bv_code": "HOLDING",
  "account_no": "652",
  "name": "Privé-opnamen firmant 1",
  "rgs_code": "652",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 52

{
  "id": 52,
  "bv_code": "HOLDING",
  "account_no": "1100",
  "name": "NL47****9112",
  "rgs_code": "1100",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 53

{
  "id": 53,
  "bv_code": "HOLDING",
  "account_no": "1301",
  "name": "Debiteur",
  "rgs_code": "1301",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 54

{
  "id": 54,
  "bv_code": "HOLDING",
  "account_no": "1482",
  "name": "Leningen U/G",
  "rgs_code": "1482",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 55

{
  "id": 55,
  "bv_code": "HOLDING",
  "account_no": "1600",
  "name": "Crediteuren",
  "rgs_code": "1600",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 56

{
  "id": 56,
  "bv_code": "HOLDING",
  "account_no": "1640",
  "name": "Rekening-courant R.D. Zwarthoff",
  "rgs_code": "1640",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 57

{
  "id": 57,
  "bv_code": "HOLDING",
  "account_no": "1641",
  "name": "Rekening-courant Zekerheid B.V.",
  "rgs_code": "1641",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": "UZ"
}

Rij 58

{
  "id": 58,
  "bv_code": "HOLDING",
  "account_no": "1642",
  "name": "Rekening-courant Paleis",
  "rgs_code": "1642",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": "PALEIS"
}

Rij 59

{
  "id": 59,
  "bv_code": "HOLDING",
  "account_no": "1680",
  "name": "Btw te vorderen hoog (inkopen)",
  "rgs_code": "1680",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 60

{
  "id": 60,
  "bv_code": "HOLDING",
  "account_no": "1684",
  "name": "Btw afdracht",
  "rgs_code": "1684",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 61

{
  "id": 61,
  "bv_code": "HOLDING",
  "account_no": "1687",
  "name": "Te betalen loonheffing",
  "rgs_code": "1687",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 62

{
  "id": 62,
  "bv_code": "HOLDING",
  "account_no": "1740",
  "name": "Vennootschapsbelasting",
  "rgs_code": "1740",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 63

{
  "id": 63,
  "bv_code": "HOLDING",
  "account_no": "4606",
  "name": "Contributies en abonnementen",
  "rgs_code": "4606",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 64

{
  "id": 64,
  "bv_code": "HOLDING",
  "account_no": "4700",
  "name": "Accountants- en advieskosten",
  "rgs_code": "4700",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 65

{
  "id": 65,
  "bv_code": "HOLDING",
  "account_no": "4753",
  "name": "Bankkosten",
  "rgs_code": "4753",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 66

{
  "id": 66,
  "bv_code": "HOLDING",
  "account_no": "4757",
  "name": "Boetes belastingen premies soc. verzekeringen",
  "rgs_code": "4757",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 67

{
  "id": 67,
  "bv_code": "UZ",
  "account_no": "1200",
  "name": "NL91****9199",
  "rgs_code": "1200",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 68

{
  "id": 68,
  "bv_code": "UZ",
  "account_no": "1810",
  "name": "Te betalen loonheffing",
  "rgs_code": "1810",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 69

{
  "id": 69,
  "bv_code": "UZ",
  "account_no": "1850",
  "name": "Te betalen netto loon",
  "rgs_code": "1850",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 70

{
  "id": 70,
  "bv_code": "UZ",
  "account_no": "2100",
  "name": "Tussenrekening balans",
  "rgs_code": "2100",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 71

{
  "id": 71,
  "bv_code": "HOLDING",
  "account_no": "2010",
  "name": "Tussenrekening balans",
  "rgs_code": "2010",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 72

{
  "id": 72,
  "bv_code": "UZ",
  "account_no": "2110",
  "name": "Tussenrekening (overig)",
  "rgs_code": "2110",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 73

{
  "id": 73,
  "bv_code": "UZ",
  "account_no": "9998",
  "name": "Memoriaal tussenrekening",
  "rgs_code": "9998",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 74

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

Rij 75

{
  "id": 75,
  "bv_code": "HOLDING",
  "account_no": "2011",
  "name": "Tussenrekening (overig)",
  "rgs_code": "2011",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 76

{
  "id": 76,
  "bv_code": "HOLDING",
  "account_no": "4798",
  "name": "Overige kosten",
  "rgs_code": "4798",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 77

{
  "id": 77,
  "bv_code": "PALEIS",
  "account_no": "1100",
  "name": "NL17****2419",
  "rgs_code": "BLimBanRba",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 78

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

Rij 79

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

Rij 80

{
  "id": 80,
  "bv_code": "UZ",
  "account_no": "1",
  "name": "U I T Z O E K E N",
  "rgs_code": "SS1",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 81

{
  "id": 81,
  "bv_code": "UZ",
  "account_no": "1000",
  "name": "Kas",
  "rgs_code": "SS1000",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 82

{
  "id": 82,
  "bv_code": "UZ",
  "account_no": "1265",
  "name": "Beleggingen",
  "rgs_code": "SS1265",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 83

{
  "id": 83,
  "bv_code": "UZ",
  "account_no": "1271",
  "name": "Transitoria Salarissen",
  "rgs_code": "SS1271",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 84

{
  "id": 84,
  "bv_code": "UZ",
  "account_no": "1301",
  "name": "Debiteuren 2016",
  "rgs_code": "SS1301",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 85

{
  "id": 85,
  "bv_code": "UZ",
  "account_no": "140",
  "name": "Autos",
  "rgs_code": "SS140",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 86

{
  "id": 86,
  "bv_code": "UZ",
  "account_no": "141",
  "name": "Afschrijving autos",
  "rgs_code": "SS141",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 87

{
  "id": 87,
  "bv_code": "UZ",
  "account_no": "1501",
  "name": "Crediteuren 2016",
  "rgs_code": "SS1501",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 88

{
  "id": 88,
  "bv_code": "UZ",
  "account_no": "1602",
  "name": "Btw af te dragen hoog (verkopen)",
  "rgs_code": "SS1602",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 89

{
  "id": 89,
  "bv_code": "UZ",
  "account_no": "1611",
  "name": "Btw te vorderen laag (inkopen)",
  "rgs_code": "SS1611",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 90

{
  "id": 90,
  "bv_code": "UZ",
  "account_no": "1612",
  "name": "Btw te vorderen hoog (inkopen)",
  "rgs_code": "SS1612",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 91

{
  "id": 91,
  "bv_code": "UZ",
  "account_no": "1625",
  "name": "Btw vorige jaren",
  "rgs_code": "SS1625",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 92

{
  "id": 92,
  "bv_code": "UZ",
  "account_no": "1890",
  "name": "Te betalen vakantiegeld",
  "rgs_code": "SS1890",
  "type": "liability",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 93

{
  "id": 93,
  "bv_code": "UZ",
  "account_no": "2240",
  "name": "Tussenrekening correcties",
  "rgs_code": "SS2240",
  "type": "asset",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 94

{
  "id": 94,
  "bv_code": "UZ",
  "account_no": "4001",
  "name": "Lonen",
  "rgs_code": "SS4001",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 95

{
  "id": 95,
  "bv_code": "UZ",
  "account_no": "4002",
  "name": "Management Fee",
  "rgs_code": "SS4002",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 96

{
  "id": 96,
  "bv_code": "UZ",
  "account_no": "4006",
  "name": "Te betalen vakantiegeld",
  "rgs_code": "SS4006",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 97

{
  "id": 97,
  "bv_code": "UZ",
  "account_no": "4030",
  "name": "Sociale lasten",
  "rgs_code": "SS4030",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 98

{
  "id": 98,
  "bv_code": "UZ",
  "account_no": "4082",
  "name": "Overige personeelskosten",
  "rgs_code": "SS4082",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 99

{
  "id": 99,
  "bv_code": "UZ",
  "account_no": "4101",
  "name": "Huur",
  "rgs_code": "SS4101",
  "type": "expense",
  "vat_default_code": null,
  "active": 1,
  "parent_account_no": null,
  "rubriek": null,
  "niveau": null,
  "intercompany_bv_code": null
}

Rij 100

{
  "id": 100,
  "bv_code": "UZ",
  "account_no": "4120",
  "name": "Gas/water/electriciteit",
  "rgs_code": "SS4120",
  "type": "expense",
  "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)