-- phpMyAdmin SQL Dump
-- version 5.1.0
-- https://www.phpmyadmin.net/
--
-- Host: com-linweb501.srv.combell-ops.net:3306
-- Gegenereerd op: 16 jun 2023 om 15:27
-- Serverversie: 5.7.40-43-log
-- PHP-versie: 7.1.25-1+0~20181207224605.11+jessie~1.gbpf65b84

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Database: `ID334488_dabbx22`
--
CREATE DATABASE IF NOT EXISTS `ID334488_dabbx22` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `ID334488_dabbx22`;

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `begunstigden`
--

CREATE TABLE `begunstigden` (
  `b_id` int(11) NOT NULL,
  `b_naam` varchar(100) NOT NULL,
  `b_adres` varchar(100) NOT NULL,
  `b_mail` varchar(100) NOT NULL,
  `b_btw` varchar(15) NOT NULL,
  `b_telefoon` varchar(15) NOT NULL,
  `b_rekeningnummer` varchar(30) NOT NULL,
  `b_frequent` int(11) NOT NULL,
  `b_standaard_cat` int(11) NOT NULL,
  `b_standaard_bh` int(11) NOT NULL,
  `b_standaard_bedrag` decimal(6,2) NOT NULL,
  `b_laatste_betaling` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `begunstigden`
--

INSERT INTO `begunstigden` (`b_id`, `b_naam`, `b_adres`, `b_mail`, `b_btw`, `b_telefoon`, `b_rekeningnummer`, `b_frequent`, `b_standaard_cat`, `b_standaard_bh`, `b_standaard_bedrag`, `b_laatste_betaling`) VALUES
(1, 'Brico Koksijde', 'Koksijde', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(2, 'Horecatotaal', 'Zandvoordeschorredijkstraat 26 | 8400 Oostende', 'info@horeca-totaal.be', 'BE 0876.512.982', '+32 059 33 02 1', '', 0, 44, 4, '0.00', '0000-00-00 00:00:00'),
(3, 'Verfaillie', 'Stationsdreef 160 - Roeselare', 'info@amphore.be', 'BE 0440.154.326', '051228650', 'BE15467528780130', 0, 44, 3, '0.00', '0000-00-00 00:00:00'),
(4, 'Luminus Gas salon', 'Koning Albert2laan 2 / 1210 Brussel', '', 'BE0471811661', '', 'BE0471811661', 1, 3, 3, '627.00', '2022-12-12 09:48:31'),
(5, 'Vdk graphics', 'Brugstraat 89 4383 Brecht', 'info@vdkgraphics.be', '0722.630.657', '', 'BE17 4383 1341 7122', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(8, 'Combell', 'Skaldenstraat 121 - 9042 Gent', 'administratie@combell.com', 'BE0541.977.701', '092187979', '73737003658660', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(9, 'FAVV', 'Kruidtuinlaan 55 - Brussel', 'heffingen@favv.bbe', '', '022119900', 'BE66679160034943', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(10, 'Melanie voorschot', 'loon', '', '', '', '', 1, 25, 3, '500.00', '2023-01-09 15:34:19'),
(11, 'Veronique voorschot', 'Loon', '', '', '', '', 1, 25, 3, '500.00', '2023-01-09 15:34:19'),
(12, 'Maisons du monde', '307 Route de Diekirch, 6700 BONNERT, BELGIQUE', '', '', '', 'BE14 0017 8732 0683', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(13, 'garage De Jaegher', 'Rodestraat 1 - Veurne', 'geert@renault-veurne.be', '04525050139', '058311540', 'BE45384044930989', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(14, 'Luminus alg.delen', 'Koning Albert2laan 2 / 1210 Brussel', '', 'BE0471811661', '', 'BE0471811661', 1, 5, 3, '18.00', '2022-12-12 09:48:31'),
(15, 'Scarlet Koksijde', 'Brussel', '', '', '', '', 1, 60, 1, '40.00', '2023-01-09 15:34:19'),
(16, 'Scarlet Penthouse', 'Brussel', '', '', '', '', 1, 60, 2, '40.00', '2022-12-27 12:49:52'),
(17, 'Scarlet Salon', 'Brussel', '', '', '', '', 1, 60, 3, '98.00', '2022-12-27 12:49:52'),
(18, 'Vdk graphics', 'Brugstraat 89 4383 Brecht', 'info@vdkgraphics.be', '0722.630.657', '', 'BE17 4383 1341 7122', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(19, 'De Kappe', 'Koksijde', 'info@dekappe', '0807087213', '0476779956', '47001569371080', 0, 6, 5, '0.00', '0000-00-00 00:00:00'),
(20, 'Worldline', 'Brussel', '', '0418547872', '', '38435410474172', 0, 22, 3, '0.00', '0000-00-00 00:00:00'),
(21, 'Casa', 'Zeelaan - De Panne', '', '04535132397', '', '', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(22, 'BTW BBX', 'Brussel', '', '', '', '', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(23, 'buroshop cailliau', 'veurne', '', '0472289139', '', '', 0, 16, 4, '0.00', '0000-00-00 00:00:00'),
(24, 'Lidl', 'Zeelaan - De Panne', '', '', '', '', 0, 61, 2, '0.00', '0000-00-00 00:00:00'),
(25, 'Q8', 'Antwerpen', '', '0404584525', '', '71210005230069', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(26, 'Puratos - belcolade', 'industrielaan 25 - GRoot Bijgaarden', 'beluxorders@puratos.com', '0438632416', '', '12432401633192', 0, 53, 3, '0.00', '0000-00-00 00:00:00'),
(27, 'Servimo', 'Koksijde', '', '0459830379', '', '53735041832953', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(28, 'Vlaamse belastingsdienst', 'Aalst', '', '', '', '02 3751 1109 9940', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(29, 'Baloise', 'Antwerpen', '', '0400 048 883', '', '31 4100 0007 1155', 0, 28, 3, '0.00', '0000-00-00 00:00:00'),
(30, 'ourstore', 'Pijnacker Nederland', 'info@ourstore.nl', 'NL851819308B01', '015 - 3030053', 'NL06INGB0006158345', 0, 6, 3, '0.00', '0000-00-00 00:00:00'),
(31, 'Veronique Afrekening', 'loon', '', '', '', '', 1, 25, 3, '1055.76', '2022-12-27 12:49:52'),
(32, 'Melanie Afrekening', 'loon', '', '', '', '', 1, 25, 3, '1068.45', '2022-12-27 12:49:52'),
(33, 'RSZ + soc.secr.', 'Waregem', '', '', '', 'BE56738425080088', 1, 0, 0, '1541.35', '2022-12-07 14:00:24'),
(34, 'Sofanie', 'Veurne', '', '', '', '', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(35, 'Carrefour Koksijde', 'Koksijde', '', '', '', '0448826918', 0, 0, 0, '0.00', '0000-00-00 00:00:00'),
(36, 'Carrefour Market DP', 'De Panne', '', '', '', '0451807390', 0, 53, 4, '0.00', '0000-00-00 00:00:00'),
(37, 'Horeca en co Velle', 'Veurne', '', '0534975784', '', '46001698337836', 0, 44, 4, '0.00', '0000-00-00 00:00:00'),
(38, 'Colruyt Veurne', 'Veurne', '', '0400378485', '', '', 0, 44, 1, '0.00', '0000-00-00 00:00:00'),
(39, 'Florizoone-tanghe', 'Veurne', '', '0683158033', '', '53380004499053', 0, 36, 3, '0.00', '0000-00-00 00:00:00'),
(40, 'AVA', 'Brurggen', '', '', '', '', 0, 44, 4, '0.00', '0000-00-00 00:00:00'),
(41, 'Elelektroinstallatie', 'zoetermeer', '', '001397414B76', '', '', 0, 44, 5, '0.00', '0000-00-00 00:00:00'),
(42, 'Gemeente De Panne', 'De panne', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(43, 'Rietveldlicht', 'nederland online', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(44, 'Warfid', 'waregem', '', '', '', '', 0, 19, 4, '0.00', '0000-00-00 00:00:00'),
(45, 'd-Glas', 'Oostende', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(46, 'zelectro', 'Bornem', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(47, 'Amazon.be', 'Belgie', '', '', '', '', 0, 44, 4, '0.00', '0000-00-00 00:00:00'),
(48, 'Artrtsound', 'Ronse', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(49, 'tc-technics', 'Elverdinge', '', '0752.648.932', '0492678695', 'BE46 7512 1062 5436', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(50, 'Samana', 'De Panne', '', '', '', '', 0, 34, 5, '0.00', '0000-00-00 00:00:00'),
(51, 'Ledprofiel', 'nederland', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(52, 'Famiflora', 'Duinhoekstraat - De Panne', '', '', '', '', 0, 36, 1, '0.00', '0000-00-00 00:00:00'),
(53, 'zoet genot', 'odk', '', '', '', '', 0, 12, 4, '0.00', '0000-00-00 00:00:00'),
(54, 'impermo', 'belgium', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(55, 'kos design', 'den haag', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(56, 'foxy studio', 'nederland', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(57, 'popieul', 'nieuwpoort', '', '', '', '', 0, 61, 3, '0.00', '0000-00-00 00:00:00'),
(58, 'euromex priveleven', 'berchem', '', '', '', '', 0, 40, 3, '0.00', '0000-00-00 00:00:00'),
(59, 'Liantis', 'Brugge', '', '', '', '', 0, 32, 3, '0.00', '0000-00-00 00:00:00'),
(60, 'watergroep', 'brugge', '', '', '', '', 0, 4, 3, '0.00', '0000-00-00 00:00:00'),
(61, 'Profile ', 'waregem', '', '', '', '', 0, 47, 3, '0.00', '0000-00-00 00:00:00'),
(62, 'Lampen24', 'duitslan', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(63, 'ledlichtstunter', 'nederland', '', '', '', '', 0, 6, 3, '0.00', '0000-00-00 00:00:00'),
(64, 'distrilec', '5215 MC \'s Hertogenbosch', '', '', '', '', 0, 6, 3, '0.00', '0000-00-00 00:00:00'),
(65, 'verhelst', 'veurne', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(66, 'lening verbouwing', 'kbc', '', '', '', '', 1, 0, 0, '868.51', '2023-01-09 15:34:19'),
(67, 'lening vakantiegeld', 'kbc', '', '', '', '', 1, 0, 0, '804.68', '2023-01-09 15:34:19'),
(68, 'Solcolor', 'duinkerke', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(69, 'action', 'veurne', '', '', '', '', 0, 61, 3, '0.00', '0000-00-00 00:00:00'),
(70, 'anatoli', 'koekelberg', '', '0703927515', '', '87143108581194', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(71, 'Delva', 'veurne', '', '', '', '', 0, 6, 3, '0.00', '0000-00-00 00:00:00'),
(72, 'afdekproducten', 'nederland', '', '', '', '', 0, 6, 3, '0.00', '0000-00-00 00:00:00'),
(73, 'horecatraders', 'online', '', '', '', '', 0, 44, 4, '0.00', '0000-00-00 00:00:00'),
(74, 'Gruyaert drukkerij', 'Oostkamp', 'info@gruyaert.be', 'BTW BE 0415.981', '050 83 13 00', 'BE07 4733 0030 3166', 0, 44, 4, '0.00', '0000-00-00 00:00:00'),
(75, 'Aquaduin', 'Koksijde', '', '', '', '', 0, 4, 3, '0.00', '0000-00-00 00:00:00'),
(76, 'Lening gevelrenovatie', 'brussel', '', '', '', '', 1, 0, 0, '630.04', '2023-01-09 15:34:19'),
(77, 'window2print', 'duitsland', '', '', '', '', 0, 33, 3, '0.00', '0000-00-00 00:00:00'),
(78, 'decadt', 'proven', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(79, 'Printdeal ', 'online', '', '', '', '', 0, 16, 4, '0.00', '0000-00-00 00:00:00'),
(80, 'vandervennet', 'brugge kortrijk', '', '', '', '', 0, 36, 4, '0.00', '0000-00-00 00:00:00'),
(81, 'vivium', 'brussel', '', '', '', '', 0, 43, 3, '0.00', '0000-00-00 00:00:00'),
(82, 'dochy glas', 'veurne', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(83, 'chocolateworld', 'Hoboken', '', '', '', '', 0, 53, 4, '0.00', '0000-00-00 00:00:00'),
(84, 'Bailleul', 'veurne', '', '', '', '', 0, 12, 3, '0.00', '0000-00-00 00:00:00'),
(85, 'pro duo', 'dunkerque', '', '', '', '', 0, 44, 3, '0.00', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `betaalmiddel`
--

CREATE TABLE `betaalmiddel` (
  `bw_id` int(11) NOT NULL,
  `bw_naam` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `betaalmiddel`
--

INSERT INTO `betaalmiddel` (`bw_id`, `bw_naam`) VALUES
(1, 'Kassa'),
(2, 'Rekening di-athos'),
(3, 'Rekening BBX'),
(4, 'Rekening Privé'),
(5, 'Online Visa'),
(6, 'Online Paypal'),
(7, 'Online ApplePay');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `betalingen`
--

CREATE TABLE `betalingen` (
  `bet_id` int(11) NOT NULL,
  `bet_fact_id` int(11) NOT NULL,
  `bet_bedrag` decimal(10,2) NOT NULL,
  `bet_datum` datetime NOT NULL,
  `bet_wijze` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `betalingen`
--

INSERT INTO `betalingen` (`bet_id`, `bet_fact_id`, `bet_bedrag`, `bet_datum`, `bet_wijze`) VALUES
(1, 5, '0.00', '2022-10-04 14:11:33', 'bank'),
(2, 5, '20.00', '2022-10-04 14:12:03', 'bank'),
(3, 5, '3.60', '2022-10-04 14:18:30', 'bank'),
(4, 5, '20.00', '2022-10-04 14:18:39', 'bank'),
(5, 5, '80.00', '2022-10-04 14:29:20', 'bank'),
(6, 9, '8.00', '2022-10-04 14:30:28', 'bank'),
(7, 9, '80.00', '2022-10-04 14:36:12', 'bank'),
(8, 9, '20.00', '2022-10-04 14:37:03', 'bank'),
(9, 9, '20.00', '2022-10-04 14:37:13', 'bank'),
(10, 9, '20.00', '2022-10-04 14:40:30', 'bank'),
(11, 9, '40.00', '2022-10-04 14:40:36', 'bank'),
(12, 12, '284.19', '2022-10-06 12:07:55', 'bank'),
(13, 14, '638.00', '2022-10-07 07:47:34', 'bank'),
(14, 18, '40.00', '2022-10-07 13:55:38', 'bank'),
(15, 16, '300.00', '2022-10-07 16:22:29', 'bank'),
(16, 19, '606.00', '2022-10-10 10:29:41', 'bank'),
(17, 17, '1892.00', '2022-10-10 10:29:51', 'bank'),
(18, 20, '2000.00', '2022-10-10 10:30:00', 'bank'),
(19, 16, '200.00', '2022-10-10 10:30:04', 'bank'),
(20, 27, '228.69', '2022-10-18 09:46:49', 'bank'),
(21, 28, '30.79', '2022-10-18 09:46:56', 'bank'),
(22, 26, '350.00', '2022-10-18 09:48:13', 'bank'),
(23, 24, '95.80', '2022-10-18 09:48:25', 'prive'),
(24, 23, '247.92', '2022-10-18 09:48:54', 'bank'),
(25, 30, '196.61', '2022-10-18 09:51:15', 'bank'),
(26, 31, '98.00', '2022-10-18 12:38:58', 'bank'),
(27, 32, '254.96', '2022-10-22 07:47:52', 'bank'),
(28, 33, '7.36', '2022-10-22 07:50:22', 'bank'),
(29, 25, '284.19', '2022-10-25 08:33:33', 'bank'),
(30, 21, '662.16', '2022-10-25 08:33:45', 'bank'),
(31, 34, '66.55', '2022-10-25 14:56:57', 'kassa'),
(32, 35, '4.80', '2022-10-25 17:36:02', 'kassa'),
(33, 36, '79.00', '2022-10-25 17:38:58', 'bank'),
(34, 37, '40.00', '2022-10-25 17:41:46', 'bank'),
(35, 39, '311.38', '2022-10-26 08:54:23', 'bank'),
(36, 38, '20.52', '2022-10-26 08:55:00', 'bank'),
(37, 40, '27.84', '2022-10-26 08:55:44', 'bank'),
(38, 47, '606.00', '2022-10-27 10:23:55', 'bank'),
(39, 46, '1892.00', '2022-10-27 10:24:04', 'bank'),
(40, 48, '135.20', '2022-10-27 10:37:47', 'online'),
(41, 52, '158.27', '2022-10-29 08:04:39', '4'),
(42, 53, '97.22', '2022-10-29 13:42:05', '1'),
(43, 54, '9.79', '2022-10-31 10:30:06', '4'),
(44, 55, '31.07', '2022-10-31 10:30:12', '4'),
(45, 56, '32.44', '2022-10-31 10:30:16', '4'),
(46, 57, '36.06', '2022-10-31 10:30:21', '4'),
(47, 60, '18.83', '2022-10-31 10:43:28', '4'),
(48, 59, '23.55', '2022-10-31 10:43:33', '4'),
(49, 62, '52.99', '2022-10-31 10:43:40', '4'),
(50, 63, '34.56', '2022-10-31 10:43:44', '4'),
(51, 64, '13.98', '2022-10-31 10:43:48', '4'),
(52, 65, '819.21', '2022-10-31 10:43:52', '4'),
(53, 58, '124.82', '2022-10-31 10:44:01', '4'),
(54, 61, '117.49', '2022-10-31 10:44:05', '4'),
(55, 66, '14.02', '2022-10-31 10:44:10', ''),
(56, 67, '26.98', '2022-11-02 15:08:35', '3'),
(57, 68, '39.95', '2022-11-03 14:32:40', '4'),
(58, 69, '50.00', '2022-11-04 08:35:44', '3'),
(59, 49, '1413.41', '2022-11-04 09:10:15', '2'),
(60, 50, '268.10', '2022-11-04 09:10:23', '2'),
(61, 43, '247.07', '2022-11-04 09:23:16', '4'),
(62, 41, '274.33', '2022-11-04 09:23:31', '3'),
(63, 45, '76.44', '2022-11-04 09:23:59', '4'),
(64, 42, '23.55', '2022-11-04 09:24:12', '3'),
(65, 70, '82.23', '2022-11-05 07:16:09', '3'),
(66, 72, '79.17', '2022-11-08 16:49:45', '2'),
(67, 74, '805.53', '2022-11-09 10:49:38', '2'),
(68, 75, '98.66', '2022-11-09 10:57:11', '4'),
(69, 76, '239.30', '2022-11-09 10:57:19', '4'),
(70, 73, '40.00', '2022-11-09 10:57:25', '4'),
(71, 22, '206.06', '2022-11-09 10:57:38', '2'),
(72, 77, '608.01', '2022-11-09 12:12:19', '4'),
(76, 78, '11822.59', '2022-11-09 14:02:11', '2'),
(77, 79, '50.00', '2022-11-10 14:49:47', '1'),
(78, 80, '500.00', '2022-11-10 15:31:20', '2'),
(79, 81, '500.00', '2022-11-10 15:31:24', '2'),
(80, 82, '281.99', '2022-11-12 08:27:54', '2'),
(81, 83, '14.54', '2022-11-15 19:31:42', '4'),
(82, 84, '1694.00', '2022-11-15 19:34:58', '2'),
(83, 85, '8038.13', '2022-11-15 20:08:30', '2'),
(84, 87, '63.00', '2022-11-15 20:11:28', '4'),
(85, 88, '35.73', '2022-11-16 18:53:24', '4'),
(86, 86, '1636.00', '2022-11-28 08:39:11', '2'),
(87, 108, '40.00', '2022-11-28 11:44:03', '4'),
(88, 104, '868.51', '2022-11-28 11:44:22', '2'),
(89, 107, '98.00', '2022-11-28 11:44:49', '4'),
(90, 106, '804.68', '2022-11-28 11:45:00', '2'),
(91, 109, '44.99', '2022-11-28 11:45:06', '4'),
(92, 105, '18.00', '2022-11-28 11:45:18', '2'),
(93, 100, '132.58', '2022-11-28 11:46:49', '4'),
(94, 110, '491.54', '2022-11-28 11:48:46', '4'),
(95, 111, '26.68', '2022-11-28 15:33:54', '2'),
(96, 94, '10.00', '2022-11-28 15:44:52', '2'),
(97, 93, '243.63', '2022-11-28 15:44:58', '2'),
(98, 44, '123.03', '2022-11-28 15:45:13', '2'),
(99, 97, '59.37', '2022-11-29 08:29:05', '4'),
(100, 98, '57.45', '2022-11-29 08:29:16', '4'),
(101, 99, '49.03', '2022-11-29 08:29:24', '4'),
(102, 113, '513.44', '2022-12-01 16:28:27', '2'),
(103, 112, '511.29', '2022-12-01 16:28:32', '2'),
(104, 116, '14425.00', '2022-12-02 09:16:28', '2'),
(105, 117, '110.18', '2022-12-05 08:36:56', '4'),
(106, 118, '44.89', '2022-12-05 08:38:49', '4'),
(107, 119, '103.27', '2022-12-05 08:50:31', '4'),
(108, 120, '143.72', '2022-12-05 08:51:48', '3'),
(109, 90, '22.30', '2022-12-05 09:03:39', '2'),
(110, 114, '516.44', '2022-12-05 09:04:45', '2'),
(111, 121, '10.38', '2022-12-05 11:02:15', '4'),
(112, 122, '7.44', '2022-12-05 11:02:19', '4'),
(113, 126, '1280.49', '2022-12-06 14:46:18', '4'),
(114, 43, '400.00', '2022-12-07 13:54:24', '4'),
(116, 91, '5.95', '2022-12-07 13:57:22', '2'),
(117, 132, '630.04', '2022-12-07 14:03:29', '2'),
(118, 131, '1541.35', '2022-12-07 14:05:12', '2'),
(119, 102, '300.04', '2022-12-07 14:10:54', '1'),
(120, 135, '117.61', '2022-12-08 13:25:08', '4'),
(121, 136, '166.64', '2022-12-08 16:06:32', '4'),
(122, 137, '32.00', '2022-12-08 16:08:09', '4'),
(123, 138, '97.71', '2022-12-08 16:09:26', '4'),
(124, 140, '125.53', '2022-12-12 08:36:18', '3'),
(125, 139, '9296.91', '2022-12-12 08:48:26', '2'),
(126, 129, '804.68', '2022-12-12 08:48:36', '2'),
(127, 29, '39.87', '2022-12-12 08:49:19', '2'),
(128, 142, '500.00', '2022-12-12 08:50:27', '2'),
(129, 143, '500.00', '2022-12-12 08:50:32', '2'),
(130, 146, '104.21', '2022-12-13 08:26:16', '4'),
(131, 130, '40.00', '2022-12-13 08:27:39', '4'),
(132, 145, '18.00', '2022-12-14 08:56:25', '2'),
(133, 144, '627.00', '2022-12-15 08:33:04', '2'),
(134, 89, '890.56', '2022-12-19 11:54:03', '2'),
(135, 127, '900.24', '2022-12-19 11:54:17', '2'),
(136, 123, '961.57', '2022-12-19 11:56:59', '2'),
(137, 141, '1729.80', '2022-12-19 11:57:40', '2'),
(138, 150, '3806.22', '2022-12-21 12:57:18', '2'),
(139, 152, '66.95', '2022-12-22 09:57:13', '4'),
(140, 71, '456.06', '2022-12-22 09:59:53', '2'),
(141, 128, '868.51', '2022-12-22 10:00:46', '2'),
(142, 153, '346.87', '2022-12-23 16:37:44', '2'),
(143, 156, '40.00', '2022-12-27 12:50:09', '4'),
(144, 160, '40.00', '2022-12-27 12:50:15', '4'),
(145, 157, '98.00', '2022-12-27 12:50:21', '2'),
(146, 158, '1055.76', '2022-12-28 09:06:17', '2'),
(147, 159, '1068.45', '2022-12-28 09:06:25', '2'),
(148, 133, '710.00', '2022-12-28 09:08:45', '2'),
(149, 115, '249.57', '2022-12-28 09:10:04', '2'),
(150, 162, '154.29', '2022-12-28 09:52:24', '4'),
(151, 163, '70.73', '2022-12-28 11:48:15', '4'),
(152, 165, '10.95', '2022-12-30 08:40:06', '1'),
(153, 166, '26.34', '2022-12-30 08:40:10', '1'),
(154, 155, '2293.73', '2023-01-03 10:24:22', '2'),
(155, 154, '514.05', '2023-01-03 10:25:23', '2'),
(156, 151, '300.25', '2023-01-03 10:26:07', '2'),
(157, 51, '2165.14', '2023-01-07 07:58:49', '2'),
(158, 125, '335.77', '2023-01-09 15:29:46', '2'),
(159, 172, '40.00', '2023-01-09 15:34:29', '4'),
(160, 170, '500.00', '2023-01-09 15:34:33', '2'),
(161, 171, '500.00', '2023-01-09 15:34:38', '2'),
(162, 169, '630.04', '2023-01-09 15:35:02', '2'),
(163, 168, '804.68', '2023-01-11 09:14:29', '2'),
(164, 95, '1204.63', '2023-01-11 09:14:51', '2'),
(165, 92, '86.39', '2023-01-11 09:15:04', '2');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `facturen`
--

CREATE TABLE `facturen` (
  `f_id` int(11) NOT NULL,
  `f_afdeling` int(11) NOT NULL,
  `f_begunstigde` int(11) NOT NULL,
  `f_subgroep` int(11) NOT NULL,
  `f_datum` datetime NOT NULL,
  `f_vervaldatum` datetime NOT NULL,
  `f_bedrag` decimal(10,2) NOT NULL,
  `f_omschrijving` text NOT NULL,
  `f_referentie` varchar(100) NOT NULL,
  `f_betaalwijze` varchar(10) NOT NULL,
  `f_afgewerkt` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `facturen`
--

INSERT INTO `facturen` (`f_id`, `f_afdeling`, `f_begunstigde`, `f_subgroep`, `f_datum`, `f_vervaldatum`, `f_bedrag`, `f_omschrijving`, `f_referentie`, `f_betaalwijze`, `f_afgewerkt`) VALUES
(21, 3, 19, 6, '2022-09-27 00:00:00', '2022-10-27 23:59:59', '662.16', '', '20220196', 'bank', 1),
(22, 3, 20, 22, '2022-10-18 00:00:00', '2022-11-09 23:59:59', '206.06', '', '2220794095', 'bank', 1),
(23, 4, 9, 59, '2022-10-18 00:00:00', '2022-10-31 23:59:59', '247.92', '', '4622033', 'bank', 1),
(24, 2, 21, 36, '2022-09-17 00:00:00', '2022-10-22 23:59:59', '95.80', '', '22005300418/1', 'prive', 1),
(25, 4, 8, 60, '2022-10-18 00:00:00', '2022-10-21 23:59:59', '284.19', '', '220913955', 'bank', 1),
(26, 3, 13, 47, '2022-10-18 00:00:00', '2022-11-25 23:59:59', '350.00', '', '3081/10961', 'bank', 1),
(27, 3, 3, 44, '2022-10-18 00:00:00', '2022-11-18 23:59:59', '228.69', '', '223050002747', 'bank', 1),
(28, 3, 3, 44, '2022-10-18 00:00:00', '2022-11-18 23:59:59', '30.79', '', '223144002747', 'bank', 1),
(29, 3, 3, 44, '2022-10-18 00:00:00', '2022-11-18 23:59:59', '39.87', '', '223281002747', 'bank', 1),
(30, 4, 22, 13, '2022-10-18 00:00:00', '2022-11-18 23:59:59', '196.61', '', 'afrekening trim3', 'kassa', 1),
(31, 3, 17, 14, '2022-10-18 00:00:00', '2022-11-25 23:59:59', '98.00', '', 'okt 22', '', 1),
(32, 3, 10, 25, '2022-10-21 15:52:31', '2022-11-21 15:52:31', '254.96', '', '', '', 1),
(33, 5, 23, 16, '2022-10-22 00:00:00', '2022-11-25 23:59:59', '7.36', '', '2214289', 'prive', 1),
(34, 5, 1, 6, '2022-10-25 00:00:00', '2022-11-25 23:59:59', '66.55', '', '88756865', 'kassa', 1),
(35, 5, 24, 61, '2022-10-25 00:00:00', '2022-11-25 23:59:59', '4.80', '', '408895/04', 'kassa', 1),
(36, 5, 25, 49, '2022-10-25 00:00:00', '2022-10-25 23:59:59', '79.00', '', '122H180030', 'bank', 1),
(37, 2, 16, 60, '2022-10-25 17:41:33', '2022-11-25 17:41:33', '40.00', '', '', '', 1),
(38, 4, 26, 53, '2022-09-14 00:00:00', '2022-10-29 23:59:59', '20.52', '', '7722035600', 'bank', 1),
(39, 4, 26, 53, '2022-09-14 00:00:00', '2022-10-14 23:59:59', '311.38', '', '11674943', 'bank', 1),
(40, 4, 9, 59, '2022-08-31 00:00:00', '2022-11-26 23:59:59', '27.84', '', '4619989', 'bank', 1),
(41, 1, 27, 11, '2022-10-26 00:00:00', '2022-11-26 23:59:59', '674.33', '', '282/0930/64926', 'bank', 0),
(42, 1, 27, 11, '2022-10-26 00:00:00', '2022-11-26 23:59:59', '23.55', '', '282/0930/65027', 'bank', 1),
(43, 5, 28, 2, '2022-10-26 00:00:00', '2023-01-07 23:59:59', '647.07', '', '222/0879/36756', 'bank', 1),
(44, 3, 29, 43, '2022-11-02 00:00:00', '2022-11-26 23:59:59', '123.03', '', 'Bijstand verzekering', 'bank', 1),
(45, 6, 29, 41, '2022-11-02 00:00:00', '2022-11-26 23:59:59', '76.44', '', 'Familiale', 'bank', 1),
(46, 3, 4, 3, '2022-10-27 00:00:00', '2022-11-27 23:59:59', '1892.00', '', 'voorschot okt', '', 1),
(47, 3, 14, 5, '2022-10-27 00:00:00', '2022-11-27 23:59:59', '606.00', '', 'voorschot okt', '', 1),
(48, 3, 30, 12, '2022-10-27 00:00:00', '2022-11-27 23:59:59', '135.20', '', '942211596', 'kassa', 1),
(49, 3, 11, 25, '2022-10-27 14:52:06', '2022-11-27 14:52:06', '1413.41', '', '', '', 1),
(50, 3, 10, 25, '2022-10-27 14:52:06', '2022-11-27 14:52:06', '268.10', '', '', '', 1),
(51, 3, 33, 25, '2022-10-27 00:00:00', '2022-11-27 23:59:59', '2165.14', '', '088550 27/10/2022 Oktober 2022', 'kassa', 1),
(52, 3, 34, 12, '2022-10-29 00:00:00', '2022-11-29 23:59:59', '158.27', '', '20/3310271', 'prive', 1),
(53, 3, 1, 12, '2022-10-29 00:00:00', '2022-11-29 23:59:59', '97.22', '', '11010558', 'kassa', 1),
(54, 4, 35, 53, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '9.79', '', '4527', 'prive', 1),
(55, 4, 36, 53, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '31.07', '', '89786569', 'prive', 1),
(56, 4, 35, 53, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '32.44', '', '2648', 'kassa', 1),
(57, 3, 1, 12, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '36.06', '', '17283938', 'prive', 1),
(58, 4, 37, 44, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '124.82', '', '14782', 'prive', 1),
(59, 2, 24, 61, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '23.55', '', '01893540', 'prive', 1),
(60, 1, 38, 44, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '18.83', '', '0400005', 'prive', 1),
(61, 4, 2, 44, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '117.49', '', '148159', 'prive', 1),
(62, 2, 1, 12, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '52.99', 'rolgordijn kamer boven', '25803115', 'prive', 1),
(63, 3, 1, 12, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '34.56', 'decapant meubels', '78646637', 'prive', 1),
(64, 3, 1, 12, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '13.98', '', '00636274', 'prive', 1),
(65, 3, 39, 36, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '819.21', 'kussens zetels salon', '2022/050', 'prive', 1),
(66, 4, 36, 53, '2022-10-31 00:00:00', '2022-12-01 23:59:59', '14.02', '', '24757761', 'prive', 1),
(67, 4, 40, 44, '2022-11-02 00:00:00', '2022-12-02 23:59:59', '26.98', '', '79892', 'prive', 1),
(68, 5, 41, 44, '2022-11-03 00:00:00', '2022-12-03 23:59:59', '39.95', '', '22-1109035', 'kassa', 1),
(69, 3, 42, 10, '2022-11-04 00:00:00', '2022-12-09 23:59:59', '50.00', '', 'inname openbaar domein', 'bank', 1),
(70, 3, 43, 12, '2022-11-05 00:00:00', '2022-12-05 23:59:59', '82.23', 'lampen gang salon', '22882905', 'kassa', 1),
(71, 4, 44, 19, '2022-11-05 00:00:00', '2022-11-30 23:59:59', '456.06', '', '20221463', 'kassa', 1),
(72, 3, 45, 12, '2022-11-08 00:00:00', '2022-12-08 23:59:59', '79.17', '', 'spiegels salon', 'kassa', 1),
(73, 1, 15, 60, '2022-11-09 09:11:05', '2022-12-09 09:11:05', '40.00', '', '', '', 1),
(74, 3, 46, 12, '2022-11-09 00:00:00', '2022-12-09 23:59:59', '805.53', 'stekkers en elctrische leidingen', 'INV/2022/16854', 'kassa', 1),
(75, 4, 47, 44, '2022-11-09 00:00:00', '2022-12-09 23:59:59', '98.66', 'Chocoladefontein', ' 406-0838827-6418700', 'kassa', 1),
(76, 4, 47, 44, '2022-11-09 00:00:00', '2022-12-09 23:59:59', '239.30', 'keukenrobots', '406-8925810-2470743', 'prive', 1),
(77, 3, 48, 12, '2022-11-09 00:00:00', '2022-12-09 23:59:59', '608.01', 'luidsprekers', 'FNFVNLNEM', 'kassa', 1),
(78, 3, 49, 12, '2022-11-09 00:00:00', '2022-12-09 23:59:59', '11822.59', 'Zonnepanelen', '2022/145', 'kassa', 1),
(79, 5, 50, 34, '2022-11-10 00:00:00', '2022-12-10 23:59:59', '50.00', '', 'samana ', 'kassa', 1),
(80, 3, 10, 25, '2022-11-10 15:31:07', '2022-12-10 15:31:07', '500.00', '', '', '', 1),
(81, 3, 11, 25, '2022-11-10 15:31:07', '2022-12-10 15:31:07', '500.00', '', '', '', 1),
(82, 3, 51, 12, '2022-11-12 00:00:00', '2022-12-12 23:59:59', '281.99', '', 'led profielen etalage', 'kassa', 1),
(83, 1, 52, 61, '2022-11-15 00:00:00', '2022-12-15 23:59:59', '14.54', '', 'tropi 05-3881534', 'kassa', 1),
(84, 4, 53, 12, '2022-11-15 00:00:00', '2022-12-15 23:59:59', '1694.00', '', 'wheelie fa 34', 'kassa', 1),
(85, 3, 54, 12, '2022-11-15 00:00:00', '2022-12-15 23:59:59', '8038.13', '', 'Nr.:274086973', 'kassa', 1),
(86, 3, 4, 3, '2022-11-15 20:09:18', '2022-12-15 20:09:18', '1636.00', '', '', '', 1),
(87, 3, 55, 12, '2022-11-15 00:00:00', '2022-12-15 23:59:59', '63.00', 'scharnieren deur', '2022-00489', 'kassa', 1),
(88, 3, 56, 12, '2022-11-16 00:00:00', '2022-12-16 23:59:59', '35.73', '', 'borstel bladgoud', 'kassa', 1),
(89, 3, 57, 61, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '890.56', '', 'eerste container verbouwingen', 'kassa', 1),
(90, 3, 58, 41, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '22.30', '', 'privé-leven', 'kassa', 1),
(91, 3, 20, 22, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '5.95', '', '5220153084', 'kassa', 1),
(92, 3, 59, 32, '2022-11-28 00:00:00', '1923-03-20 23:59:59', '86.39', '', '422846336378', 'kassa', 1),
(93, 3, 60, 4, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '243.63', '', '212537276542', 'kassa', 1),
(94, 3, 61, 47, '2022-11-28 00:00:00', '2022-12-29 23:59:59', '10.00', '', 'w2022110041', 'kassa', 1),
(95, 3, 59, 32, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '1204.63', '', '422/8202/39136', 'kassa', 1),
(96, 3, 62, 12, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '215.60', '', 'RE221583215', 'kassa', 1),
(97, 3, 63, 6, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '59.37', '', 'NL-LLS8072937', 'kassa', 1),
(98, 3, 30, 6, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '57.45', '', '942212525', 'bank', 1),
(99, 3, 64, 6, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '49.03', '', '7800357213', 'bank', 1),
(100, 3, 51, 12, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '132.58', '', 'lpi26116', 'bank', 1),
(102, 3, 65, 12, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '300.04', '', '22264838', 'bank', 1),
(103, 3, 65, 12, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '207.85', '', '22265328', 'bank', 0),
(104, 0, 66, 0, '2022-11-28 11:30:51', '2022-12-28 11:30:51', '868.51', '', '', '', 1),
(105, 3, 14, 5, '2022-11-28 11:33:22', '2022-12-28 11:33:22', '18.00', '', '', '', 1),
(106, 0, 67, 0, '2022-11-28 11:42:23', '2022-12-28 11:42:23', '804.68', '', '', '', 1),
(107, 3, 17, 60, '2022-11-28 11:42:46', '2022-12-28 11:42:46', '98.00', '', '', '', 1),
(108, 2, 16, 60, '2022-11-28 11:42:46', '2022-12-28 11:42:46', '40.00', '', '', '', 1),
(109, 1, 15, 60, '2022-11-28 11:42:46', '2022-12-28 11:42:46', '44.99', '', '', '', 1),
(110, 3, 68, 12, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '491.54', '', 'verf achteraan en behangpapier', 'prive', 1),
(111, 3, 69, 44, '2022-11-28 00:00:00', '2022-12-28 23:59:59', '26.68', '', '2034102-10002629', 'kassa', 1),
(112, 3, 31, 25, '2022-11-29 08:28:30', '2022-12-29 08:28:30', '511.29', '', '', '', 1),
(113, 3, 32, 25, '2022-11-29 08:28:30', '2022-12-29 08:28:30', '513.44', '', '', '', 1),
(114, 0, 33, 0, '2022-11-29 08:28:30', '2022-12-29 08:28:30', '516.44', '', '', '', 1),
(115, 3, 65, 12, '2022-11-29 00:00:00', '2023-01-01 23:59:59', '249.57', '', '22270742', 'kassa', 1),
(116, 3, 70, 12, '2022-12-02 00:00:00', '2023-01-02 23:59:59', '14425.00', 'werken in het salon', 'factuur 23 ', 'kassa', 1),
(117, 1, 52, 36, '2022-12-05 00:00:00', '2023-01-05 23:59:59', '110.18', '', '04179477', 'kassa', 1),
(118, 3, 71, 6, '2022-12-05 00:00:00', '2023-01-05 23:59:59', '44.89', '', '221005157', 'kassa', 1),
(119, 3, 72, 6, '2022-12-05 00:00:00', '2023-01-05 23:59:59', '103.27', '', '2022023094', 'kassa', 1),
(120, 4, 73, 44, '2022-12-05 00:00:00', '2023-01-05 23:59:59', '143.72', '', 'INV96522', 'kassa', 1),
(121, 4, 23, 44, '2022-12-05 00:00:00', '2023-01-05 23:59:59', '10.38', '', '2719', 'kassa', 1),
(122, 4, 69, 44, '2022-12-05 00:00:00', '2023-01-05 23:59:59', '7.44', '', '3092', 'kassa', 1),
(123, 4, 74, 44, '2022-12-06 00:00:00', '2023-01-06 23:59:59', '961.57', 'bagbox', '962/7225/14776', 'bank', 1),
(124, 3, 44, 19, '2022-12-06 00:00:00', '2023-01-06 23:59:59', '870.60', '', '009/1503/83650', 'kassa', 0),
(125, 3, 75, 4, '2022-12-06 00:00:00', '2022-12-31 23:59:59', '335.77', '', '220088873', 'kassa', 1),
(126, 3, 1, 12, '2022-12-06 00:00:00', '2023-01-06 23:59:59', '1280.49', '', '24000813511', 'kassa', 1),
(127, 3, 57, 61, '2022-12-06 00:00:00', '2023-01-06 23:59:59', '900.24', '', '2022-220', 'kassa', 1),
(128, 3, 66, 54, '2022-12-07 00:00:00', '2023-01-07 23:59:59', '868.51', '', 'dec22', '', 1),
(129, 3, 67, 27, '2022-12-07 00:00:00', '2023-01-07 23:59:59', '804.68', '', 'dec22', '', 1),
(130, 2, 16, 60, '2022-12-07 14:00:24', '2023-01-07 14:00:24', '40.00', '', '', '', 1),
(131, 0, 33, 0, '2022-12-07 14:00:24', '2023-01-07 14:00:24', '1541.35', '', '', '', 1),
(132, 0, 76, 0, '2022-12-07 14:01:31', '2023-01-07 14:01:31', '630.04', '', '', '', 1),
(133, 3, 65, 12, '2022-12-07 00:00:00', '2023-01-07 23:59:59', '710.00', '', '22269155', 'bank', 1),
(134, 3, 65, 12, '2022-12-08 00:00:00', '2023-01-08 23:59:59', '337.57', '', '22272992', 'kassa', 0),
(135, 4, 23, 16, '2022-12-08 00:00:00', '2023-01-08 23:59:59', '117.61', '', '3099', 'kassa', 1),
(136, 3, 77, 33, '2022-12-08 00:00:00', '2023-01-08 23:59:59', '166.64', '', '8219', 'prive', 1),
(137, 3, 77, 33, '2022-12-08 00:00:00', '2023-01-08 23:59:59', '32.00', '', '7094', 'kassa', 1),
(138, 3, 77, 33, '2022-12-08 00:00:00', '2023-01-08 23:59:59', '97.71', '', '6199', 'kassa', 1),
(139, 3, 78, 12, '2022-12-10 00:00:00', '2023-01-10 23:59:59', '9296.91', '', '224898', 'kassa', 1),
(140, 4, 79, 16, '2022-12-12 00:00:00', '2023-01-12 23:59:59', '125.53', '', 'cadobonnen bbx', 'kassa', 1),
(141, 3, 49, 12, '2022-12-12 00:00:00', '2023-01-12 23:59:59', '1729.80', '', '2022/173', 'kassa', 1),
(142, 3, 10, 25, '2022-12-12 08:50:14', '2023-01-12 08:50:14', '500.00', '', '', '', 1),
(143, 3, 11, 25, '2022-12-12 08:50:14', '2023-01-12 08:50:14', '500.00', '', '', '', 1),
(144, 3, 4, 3, '2022-12-12 09:48:31', '2023-01-12 09:48:31', '627.00', '', '', '', 1),
(145, 3, 14, 5, '2022-12-12 09:48:31', '2023-01-12 09:48:31', '18.00', '', '', '', 1),
(146, 4, 80, 36, '2022-12-13 00:00:00', '2023-01-13 23:59:59', '104.21', '', '2022/10279', 'kassa', 1),
(147, 3, 20, 22, '2022-12-13 00:00:00', '2023-01-06 23:59:59', '56.58', '', '2221008160', 'bank', 0),
(148, 3, 58, 40, '2022-12-16 00:00:00', '2023-01-07 23:59:59', '162.00', 'rechtsbijstand', '230/1828/60679', 'kassa', 0),
(149, 3, 81, 43, '2022-12-16 00:00:00', '2023-01-06 23:59:59', '966.55', '', '700/0318/88489', 'kassa', 0),
(150, 3, 82, 12, '2022-12-21 00:00:00', '2023-01-21 23:59:59', '3806.22', '', 'voorschot glas', 'kassa', 1),
(151, 4, 74, 44, '2022-12-22 00:00:00', '2023-01-22 23:59:59', '300.25', '', '962/7225/56913', 'prive', 1),
(152, 4, 79, 16, '2022-12-22 00:00:00', '2023-01-22 23:59:59', '66.95', '', 'F2290111866', 'prive', 1),
(153, 4, 83, 53, '2022-12-23 00:00:00', '2023-01-23 23:59:59', '346.87', '', '2205650', 'prive', 1),
(154, 3, 26, 53, '2022-12-27 00:00:00', '2023-01-27 23:59:59', '514.05', '', '772/2049/67552', 'prive', 1),
(155, 3, 84, 12, '2022-12-27 00:00:00', '2023-01-27 23:59:59', '2293.73', '', '20/221630', 'prive', 1),
(156, 1, 15, 60, '2022-12-27 12:49:52', '2023-01-27 12:49:52', '40.00', '', '', '', 1),
(157, 3, 17, 60, '2022-12-27 12:49:52', '2023-01-27 12:49:52', '98.00', '', '', '', 1),
(158, 3, 31, 25, '2022-12-27 12:49:52', '2023-01-27 12:49:52', '1055.76', '', '', '', 1),
(159, 3, 32, 25, '2022-12-27 12:49:52', '2023-01-27 12:49:52', '1068.45', '', '', '', 1),
(160, 2, 16, 60, '2022-12-27 12:49:52', '2023-01-27 12:49:52', '40.00', '', '', '', 1),
(161, 3, 29, 40, '2022-12-28 00:00:00', '2022-12-31 23:59:59', '113.35', '', '230/1727/62575', 'bank', 0),
(162, 4, 2, 44, '2022-12-28 00:00:00', '2023-01-28 23:59:59', '154.29', '', '205823', 'bank', 1),
(163, 4, 2, 44, '2022-12-28 00:00:00', '2023-01-28 23:59:59', '70.73', '', '68541', 'bank', 1),
(164, 3, 29, 28, '2022-12-28 00:00:00', '2023-01-01 23:59:59', '1197.14', '', '230/1908/27009', 'prive', 0),
(165, 3, 69, 61, '2022-12-30 00:00:00', '2023-01-30 23:59:59', '10.95', '', '404610111075471', 'kassa', 1),
(166, 3, 85, 44, '2022-12-30 00:00:00', '2023-01-30 23:59:59', '26.34', '', '0000395337', 'kassa', 1),
(167, 0, 66, 0, '2023-01-09 15:34:19', '2023-02-09 15:34:19', '868.51', '', '', '', 0),
(168, 0, 67, 0, '2023-01-09 15:34:19', '2023-02-09 15:34:19', '804.68', '', '', '', 1),
(169, 0, 76, 0, '2023-01-09 15:34:19', '2023-02-09 15:34:19', '630.04', '', '', '', 1),
(170, 3, 10, 25, '2023-01-09 15:34:19', '2023-02-09 15:34:19', '500.00', '', '', '', 1),
(171, 3, 11, 25, '2023-01-09 15:34:19', '2023-02-09 15:34:19', '500.00', '', '', '', 1),
(172, 1, 15, 60, '2023-01-09 15:34:19', '2023-02-09 15:34:19', '40.00', '', '', '', 1);

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `gebruiker`
--

CREATE TABLE `gebruiker` (
  `id` int(11) NOT NULL,
  `login` varchar(50) NOT NULL,
  `pw` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `gebruiker`
--

INSERT INTO `gebruiker` (`id`, `login`, `pw`) VALUES
(1, 'dimitri', 'vedimanno22');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `inkomsten`
--

CREATE TABLE `inkomsten` (
  `i_id` int(11) NOT NULL,
  `i_loc` int(11) NOT NULL,
  `i_maand` int(11) NOT NULL,
  `i_jaar` int(11) NOT NULL,
  `i_bedrag` decimal(8,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `inkomsten`
--

INSERT INTO `inkomsten` (`i_id`, `i_loc`, `i_maand`, `i_jaar`, `i_bedrag`) VALUES
(14, 1, 10, 2022, '1314.94'),
(15, 2, 10, 2022, '1998.05'),
(16, 3, 10, 2022, '11269.85'),
(17, 4, 10, 2022, '337.00'),
(18, 5, 10, 2022, '0.00'),
(19, 6, 10, 2022, '0.00'),
(20, 1, 9, 2022, '0.00'),
(21, 2, 9, 2022, '0.00'),
(22, 3, 9, 2022, '0.00'),
(23, 4, 9, 2022, '0.00'),
(24, 5, 9, 2022, '0.00'),
(25, 6, 9, 2022, '0.00'),
(26, 1, 11, 2022, '0.00'),
(27, 2, 11, 2022, '0.00'),
(28, 3, 11, 2022, '0.00'),
(29, 4, 11, 2022, '0.00'),
(30, 5, 11, 2022, '0.00'),
(31, 6, 11, 2022, '0.00');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `kost_bh`
--

CREATE TABLE `kost_bh` (
  `kbh_id` int(11) NOT NULL,
  `kbh_naam` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `kost_bh`
--

INSERT INTO `kost_bh` (`kbh_id`, `kbh_naam`) VALUES
(1, 'AirBnb - Koksijde'),
(2, 'AirBnb - Penthouse'),
(3, 'di-Athos'),
(4, 'BonBonXocla'),
(5, 'Gedeeld'),
(6, 'Privé');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `kost_groep`
--

CREATE TABLE `kost_groep` (
  `kg_id` int(11) NOT NULL,
  `kg_naam` varchar(40) NOT NULL,
  `kg_status` int(11) NOT NULL,
  `kg_toggle` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `kost_groep`
--

INSERT INTO `kost_groep` (`kg_id`, `kg_naam`, `kg_status`, `kg_toggle`) VALUES
(1, 'Gebouw', 0, '0'),
(2, 'Administratief', 0, '0'),
(3, 'Lonen en lasten', 0, 'active'),
(4, 'Publiciteit', 0, '0'),
(5, 'Verzekeringen', 0, '0'),
(6, 'Belastingen', 0, '0'),
(7, 'Diverse', 0, '0'),
(8, 'Grondstoffen', 0, '0'),
(9, 'Financiële kosten', 0, '0'),
(11, 'Energie', 0, 'active'),
(13, 'Werkingskosten', 1, 'active'),
(14, 'Auto', 1, '0'),
(15, 'Investeringen', 1, '0');

-- --------------------------------------------------------

--
-- Tabelstructuur voor tabel `kost_subgroep`
--

CREATE TABLE `kost_subgroep` (
  `ks_id` int(11) NOT NULL,
  `ks_kg_id` int(11) NOT NULL,
  `ks_naam` varchar(50) NOT NULL,
  `ks_status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Gegevens worden geëxporteerd voor tabel `kost_subgroep`
--

INSERT INTO `kost_subgroep` (`ks_id`, `ks_kg_id`, `ks_naam`, `ks_status`) VALUES
(1, 1, 'huur', 1),
(2, 1, 'onroerende voorheffing', 1),
(3, 11, 'Gas', 1),
(4, 11, 'Water', 1),
(5, 11, 'Electriciteit', 1),
(6, 1, 'Herstellingen gebouw', 1),
(7, 6, 'Sabam', 1),
(8, 1, 'Onderhoudsproducten gebouw', 1),
(9, 6, 'Provinciebelastingen', 1),
(10, 6, 'Gemeentebelastingen', 1),
(11, 1, 'Syndic', 1),
(12, 15, 'Renovaties via lening', 1),
(13, 6, 'BTW', 1),
(14, 13, 'Telefoon/internet abo', 1),
(15, 13, 'Post', 1),
(16, 13, 'Bureel', 1),
(17, 13, 'Lidgelden', 1),
(18, 6, 'Autobelasting', 1),
(19, 13, 'Boekhouder', 1),
(20, 13, 'Sociaal secretariaat', 1),
(21, 13, 'Informatica', 1),
(22, 2, 'Betaalterminal', 1),
(23, 6, 'Registratie rechten', 1),
(24, 6, 'Vennootschapsbelasting', 1),
(25, 3, 'Lonen', 1),
(26, 3, 'RSZ', 1),
(27, 3, 'Vankantiegeld', 1),
(28, 3, 'Verzekering Personeel', 1),
(29, 3, 'Svmb', 1),
(30, 13, 'Verplaatsingsonkosten personeel', 1),
(31, 3, 'RSVZ', 1),
(32, 3, 'Soc.zekerheid vennootschap', 1),
(33, 4, 'Publiciteit', 1),
(34, 4, 'Sponsoring', 1),
(35, 4, 'Online publiciteit', 1),
(36, 4, 'Decoratie/etalage', 1),
(37, 4, 'Relatiegeschenken', 1),
(38, 5, 'Brandverzekering', 1),
(39, 5, 'Diefstalverzekering', 1),
(40, 5, 'Burgerlijke aansprakelijkheid', 1),
(41, 5, 'Glas en waterschade', 1),
(42, 5, 'beroepsricicoverzekering', 1),
(43, 14, 'Autoverzekering', 1),
(44, 13, 'Klein materiaal', 1),
(45, 13, 'Werkkledij', 1),
(46, 13, 'Koffie/koekjes', 1),
(47, 14, 'Onderhoud auto', 1),
(48, 13, 'Logis kosten', 1),
(49, 14, 'Tankkaart', 1),
(50, 13, 'Transportkosten', 1),
(51, 13, 'Lectuur', 1),
(52, 8, 'Producten salon', 1),
(53, 8, 'Grondstoffen chocolade', 1),
(54, 2, 'Leningen', 1),
(55, 2, 'Bankkosten', 1),
(56, 13, 'Vormingsmateriaal', 1),
(57, 0, 'naam', 1),
(59, 6, 'FAVV', 1),
(60, 13, 'Internet', 1),
(61, 13, 'Schoonmaakproducten ', 1);

--
-- Indexen voor geëxporteerde tabellen
--

--
-- Indexen voor tabel `begunstigden`
--
ALTER TABLE `begunstigden`
  ADD PRIMARY KEY (`b_id`);

--
-- Indexen voor tabel `betaalmiddel`
--
ALTER TABLE `betaalmiddel`
  ADD PRIMARY KEY (`bw_id`);

--
-- Indexen voor tabel `betalingen`
--
ALTER TABLE `betalingen`
  ADD PRIMARY KEY (`bet_id`);

--
-- Indexen voor tabel `facturen`
--
ALTER TABLE `facturen`
  ADD PRIMARY KEY (`f_id`);

--
-- Indexen voor tabel `gebruiker`
--
ALTER TABLE `gebruiker`
  ADD PRIMARY KEY (`id`);

--
-- Indexen voor tabel `inkomsten`
--
ALTER TABLE `inkomsten`
  ADD PRIMARY KEY (`i_id`);

--
-- Indexen voor tabel `kost_bh`
--
ALTER TABLE `kost_bh`
  ADD PRIMARY KEY (`kbh_id`);

--
-- Indexen voor tabel `kost_groep`
--
ALTER TABLE `kost_groep`
  ADD PRIMARY KEY (`kg_id`);

--
-- Indexen voor tabel `kost_subgroep`
--
ALTER TABLE `kost_subgroep`
  ADD PRIMARY KEY (`ks_id`);

--
-- AUTO_INCREMENT voor geëxporteerde tabellen
--

--
-- AUTO_INCREMENT voor een tabel `begunstigden`
--
ALTER TABLE `begunstigden`
  MODIFY `b_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86;

--
-- AUTO_INCREMENT voor een tabel `betaalmiddel`
--
ALTER TABLE `betaalmiddel`
  MODIFY `bw_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT voor een tabel `betalingen`
--
ALTER TABLE `betalingen`
  MODIFY `bet_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=166;

--
-- AUTO_INCREMENT voor een tabel `facturen`
--
ALTER TABLE `facturen`
  MODIFY `f_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=173;

--
-- AUTO_INCREMENT voor een tabel `gebruiker`
--
ALTER TABLE `gebruiker`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT voor een tabel `inkomsten`
--
ALTER TABLE `inkomsten`
  MODIFY `i_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT voor een tabel `kost_bh`
--
ALTER TABLE `kost_bh`
  MODIFY `kbh_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT voor een tabel `kost_groep`
--
ALTER TABLE `kost_groep`
  MODIFY `kg_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT voor een tabel `kost_subgroep`
--
ALTER TABLE `kost_subgroep`
  MODIFY `ks_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;
COMMIT;