# MySQL-Front Dump 2.5
#
# Host: 192.168.0.5   Database: mysql_drop
# --------------------------------------------------------
# Server version 4.0.12-Max-log


#
# Table structure for table 'betalingen'
#

DROP TABLE IF EXISTS betalingen;
CREATE TABLE betalingen (
  TRANSACTIE varchar(10) NOT NULL default '',
  BEDRAG decimal(15,2) NOT NULL default '0.00',
  DATUM datetime NOT NULL default '0000-00-00 00:00:00',
  BETAALWIJZE char(2) NOT NULL default '',
  JOURNAAL varchar(6) NOT NULL default '',
  PERIODE tinyint(2) NOT NULL default '0',
  JAAR int(4) NOT NULL default '0',
  KEY TRANSACTIE (TRANSACTIE)
) TYPE=InnoDB;



#
# Dumping data for table 'betalingen'
#

INSERT INTO betalingen VALUES("A0001", "1111.76", "2000-10-24 00:00:00", "AB", "", "4", "2000");
INSERT INTO betalingen VALUES("A0002", "1594.24", "2000-10-13 00:00:00", "AB", "AB0003", "4", "2000");
INSERT INTO betalingen VALUES("A0003", "13.33", "2000-10-13 00:00:00", "AB", "AB0003", "4", "2000");
INSERT INTO betalingen VALUES("A0004", "13.33", "2000-12-01 00:00:00", "AB", "AB0006", "4", "2000");
INSERT INTO betalingen VALUES("A0005", "11.34", "2001-01-12 00:00:00", "AB", "AB0001", "1", "2001");
INSERT INTO betalingen VALUES("A0005", "1.99", "2002-03-28 00:00:00", "AB", "AB0012", "1", "2002");
INSERT INTO betalingen VALUES("A0006", "59.40", "2001-03-13 00:00:00", "AB", "AB0006", "1", "2001");
INSERT INTO betalingen VALUES("A0007", "27.00", "2001-03-16 00:00:00", "AB", "AB0007", "1", "2001");
INSERT INTO betalingen VALUES("A0008", "29.70", "2001-04-20 00:00:00", "AB", "AB0011", "2", "2001");
INSERT INTO betalingen VALUES("A0009", "13.50", "2001-04-20 00:00:00", "AB", "AB0011", "2", "2001");
INSERT INTO betalingen VALUES("A0010", "29.70", "2001-05-25 00:00:00", "AB", "AB0015", "2", "2001");
INSERT INTO betalingen VALUES("A0011", "100.98", "2001-05-25 00:00:00", "AB", "AB0014", "2", "2001");
INSERT INTO betalingen VALUES("A0012", "162.00", "2001-05-25 00:00:00", "AB", "AB0015", "2", "2001");
INSERT INTO betalingen VALUES("A0013", "100.98", "2001-07-17 00:00:00", "AB", "AB0019", "3", "2001");
INSERT INTO betalingen VALUES("A0014", "29.70", "2001-06-23 00:00:00", "AB", "AB0018", "2", "2001");
INSERT INTO betalingen VALUES("A0015", "29.70", "2001-08-17 00:00:00", "AB", "AB0026", "3", "2001");
INSERT INTO betalingen VALUES("A0016", "100.98", "2001-07-20 00:00:00", "AB", "AB0023", "3", "2001");
INSERT INTO betalingen VALUES("A0017", "29.70", "2001-08-17 00:00:00", "AB", "AB0026", "3", "2001");
INSERT INTO betalingen VALUES("A0018", "100.98", "2001-08-28 00:00:00", "AB", "AB0027", "3", "2001");
INSERT INTO betalingen VALUES("A0019", "415.80", "2001-09-25 00:00:00", "AB", "AB0031", "3", "2001");
INSERT INTO betalingen VALUES("A0019", "415.80", "2001-10-05 00:00:00", "AB", "AB0033", "4", "2001");
INSERT INTO betalingen VALUES("A0019", "-415.80", "2001-11-20 00:00:00", "AB", "AB0039", "4", "2001");
INSERT INTO betalingen VALUES("A0020", "29.70", "2001-09-18 00:00:00", "AB", "AB0030", "3", "2001");
INSERT INTO betalingen VALUES("A0021", "100.98", "2001-09-18 00:00:00", "AB", "AB0030", "3", "2001");
INSERT INTO betalingen VALUES("A0022", "29.70", "2001-10-19 00:00:00", "AB", "AB0035", "4", "2001");
INSERT INTO betalingen VALUES("A0023", "100.98", "2001-10-12 00:00:00", "AB", "AB0034", "4", "2001");
INSERT INTO betalingen VALUES("A0024", "89.10", "2001-11-23 00:00:00", "AB", "AB0040", "4", "2001");
INSERT INTO betalingen VALUES("A0025", "1350.00", "2001-11-23 00:00:00", "AB", "AB0040", "4", "2001");
INSERT INTO betalingen VALUES("A0026", "37.80", "2001-11-20 00:00:00", "AB", "AB0039", "4", "2001");
INSERT INTO betalingen VALUES("A0027", "124.95", "2001-11-23 00:00:00", "AB", "AB0040", "4", "2001");
INSERT INTO betalingen VALUES("A0028", "37.80", "2001-12-18 00:00:00", "AB", "AB0043", "4", "2001");
INSERT INTO betalingen VALUES("A0029", "89.10", "2002-01-25 00:00:00", "AB", "AB0003", "1", "2002");
INSERT INTO betalingen VALUES("A0030", "124.95", "2001-12-21 00:00:00", "AB", "AB0044", "4", "2001");
INSERT INTO betalingen VALUES("A0031", "89.10", "2002-01-25 00:00:00", "AB", "AB0003", "1", "2002");
INSERT INTO betalingen VALUES("A0032", "37.80", "2002-01-25 00:00:00", "AB", "AB0003", "1", "2002");
INSERT INTO betalingen VALUES("A0033", "243.95", "2002-01-18 00:00:00", "AB", "AB0002", "1", "2002");
INSERT INTO betalingen VALUES("B0001", "105.00", "2002-02-08 00:00:00", "AB", "AB0005", "1", "2002");
INSERT INTO betalingen VALUES("B0001", "19.95", "2002-03-28 00:00:00", "AB", "AB0012", "1", "2002");
INSERT INTO betalingen VALUES("B0002", "38.08", "2002-02-26 00:00:00", "AB", "AB0007", "1", "2002");
INSERT INTO betalingen VALUES("B0003", "59.50", "2002-03-01 00:00:00", "AB", "AB0008", "1", "2002");
INSERT INTO betalingen VALUES("B0004", "89.25", "2002-04-26 00:00:00", "AB", "AB0016", "2", "2002");
INSERT INTO betalingen VALUES("B0005", "59.50", "2002-03-01 00:00:00", "AB", "AB0008", "1", "2002");
INSERT INTO betalingen VALUES("B0006", "59.50", "2002-03-01 00:00:00", "AB", "AB0008", "1", "2002");
INSERT INTO betalingen VALUES("B0007", "59.90", "2002-03-01 00:00:00", "AB", "AB0008", "1", "2002");
INSERT INTO betalingen VALUES("B0007", "-0.40", "2002-06-28 00:00:00", "AB", "AB0025", "2", "2002");
INSERT INTO betalingen VALUES("B0008", "29.75", "2002-02-08 00:00:00", "AB", "AB0005", "1", "2002");
INSERT INTO betalingen VALUES("B0009", "700.01", "2002-03-19 00:00:00", "AB", "AB0010", "1", "2002");
INSERT INTO betalingen VALUES("B0010", "154.70", "2002-03-08 00:00:00", "AB", "AB0009", "1", "2002");
INSERT INTO betalingen VALUES("B0011", "38.08", "2002-03-22 00:00:00", "AB", "AB0011", "1", "2002");
INSERT INTO betalingen VALUES("B0012", "59.50", "2002-04-12 00:00:00", "AB", "AB0014", "2", "2002");
INSERT INTO betalingen VALUES("B0013", "89.25", "2002-04-26 00:00:00", "AB", "AB0016", "2", "2002");
INSERT INTO betalingen VALUES("B0014", "59.50", "2002-03-28 00:00:00", "AB", "AB0012", "1", "2002");
INSERT INTO betalingen VALUES("B0015", "59.50", "2002-03-28 00:00:00", "AB", "AB0012", "1", "2002");
INSERT INTO betalingen VALUES("B0016", "59.50", "2002-03-28 00:00:00", "AB", "AB0012", "1", "2002");
INSERT INTO betalingen VALUES("B0017", "29.75", "2002-03-08 00:00:00", "AB", "AB0009", "1", "2002");
INSERT INTO betalingen VALUES("B0018", "29.75", "2002-08-06 00:00:00", "KB", "KB0013", "3", "2002");
INSERT INTO betalingen VALUES("B0019", "29.75", "2002-03-19 00:00:00", "AB", "AB0010", "1", "2002");
INSERT INTO betalingen VALUES("B0020", "562.28", "2002-03-08 00:00:00", "AB", "AB0009", "1", "2002");
INSERT INTO betalingen VALUES("B0021", "59.50", "2002-03-28 00:00:00", "AB", "AB0012", "1", "2002");
INSERT INTO betalingen VALUES("B0022", "297.50", "2002-03-19 00:00:00", "AB", "AB0010", "1", "2002");
INSERT INTO betalingen VALUES("B0023", "481.95", "2002-04-26 00:00:00", "AB", "AB0016", "2", "2002");
INSERT INTO betalingen VALUES("B0024", "172.55", "2002-03-28 00:00:00", "AB", "AB0012", "1", "2002");
INSERT INTO betalingen VALUES("B0025", "38.08", "2002-04-05 00:00:00", "AB", "AB0013", "2", "2002");
INSERT INTO betalingen VALUES("B0026", "59.50", "2002-05-10 00:00:00", "AB", "AB0018", "2", "2002");
INSERT INTO betalingen VALUES("B0027", "89.25", "2002-05-17 00:00:00", "AB", "AB0019", "2", "2002");
INSERT INTO betalingen VALUES("B0028", "59.50", "2002-04-26 00:00:00", "AB", "AB0016", "2", "2002");
INSERT INTO betalingen VALUES("B0029", "59.50", "2002-04-26 00:00:00", "AB", "AB0016", "2", "2002");
INSERT INTO betalingen VALUES("B0030", "59.50", "2002-04-23 00:00:00", "AB", "AB0015", "2", "2002");
INSERT INTO betalingen VALUES("B0031", "29.75", "2002-03-28 00:00:00", "AB", "AB0012", "1", "2002");
INSERT INTO betalingen VALUES("B0032", "29.75", "2002-08-06 00:00:00", "KB", "KB0013", "3", "2002");
INSERT INTO betalingen VALUES("B0033", "29.75", "2002-04-05 00:00:00", "AB", "AB0013", "2", "2002");
INSERT INTO betalingen VALUES("B0034", "250.00", "2002-04-08 00:00:00", "KB", "KB0005", "2", "2002");
INSERT INTO betalingen VALUES("B0035", "172.55", "2002-05-31 00:00:00", "AB", "AB0021", "2", "2002");
INSERT INTO betalingen VALUES("B0036", "38.08", "2002-05-31 00:00:00", "AB", "AB0021", "2", "2002");
INSERT INTO betalingen VALUES("B0037", "59.50", "2002-06-07 00:00:00", "AB", "AB0022", "2", "2002");
INSERT INTO betalingen VALUES("B0038", "89.25", "2002-05-17 00:00:00", "AB", "AB0019", "2", "2002");
INSERT INTO betalingen VALUES("B0039", "59.50", "2002-05-31 00:00:00", "AB", "AB0021", "2", "2002");
INSERT INTO betalingen VALUES("B0040", "59.50", "2002-06-07 00:00:00", "AB", "AB0022", "2", "2002");
INSERT INTO betalingen VALUES("B0041", "59.50", "2002-06-07 00:00:00", "AB", "AB0022", "2", "2002");
INSERT INTO betalingen VALUES("B0042", "29.75", "2002-05-03 00:00:00", "AB", "AB0017", "2", "2002");
INSERT INTO betalingen VALUES("B0043", "29.75", "2002-08-06 00:00:00", "KB", "KB0013", "3", "2002");
INSERT INTO betalingen VALUES("B0044", "29.75", "2002-05-31 00:00:00", "AB", "AB0021", "2", "2002");
INSERT INTO betalingen VALUES("B0045", "107.10", "2002-05-31 00:00:00", "AB", "AB0021", "2", "2002");
INSERT INTO betalingen VALUES("B0046", "172.55", "2002-05-31 00:00:00", "AB", "AB0021", "2", "2002");
INSERT INTO betalingen VALUES("B0047", "38.08", "2002-05-31 00:00:00", "AB", "AB0021", "2", "2002");
INSERT INTO betalingen VALUES("B0048", "59.50", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("B0049", "101.15", "2002-05-17 00:00:00", "AB", "AB0019", "2", "2002");
INSERT INTO betalingen VALUES("B0050", "59.50", "2002-06-21 00:00:00", "AB", "AB0024", "2", "2002");
INSERT INTO betalingen VALUES("B0051", "59.50", "2002-06-21 00:00:00", "AB", "AB0024", "2", "2002");
INSERT INTO betalingen VALUES("B0052", "59.50", "2002-06-21 00:00:00", "AB", "AB0024", "2", "2002");
INSERT INTO betalingen VALUES("B0053", "29.75", "2002-05-28 00:00:00", "AB", "AB0020", "2", "2002");
INSERT INTO betalingen VALUES("B0054", "29.75", "2002-08-06 00:00:00", "KB", "KB0013", "3", "2002");
INSERT INTO betalingen VALUES("B0055", "29.75", "2002-06-21 00:00:00", "AB", "AB0024", "2", "2002");
INSERT INTO betalingen VALUES("B0056", "180.88", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("B0057", "38.08", "2002-06-28 00:00:00", "AB", "AB0025", "2", "2002");
INSERT INTO betalingen VALUES("B0058", "59.50", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("B0059", "101.15", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("B0060", "59.50", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("B0061", "59.50", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("B0062", "59.50", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("B0063", "29.75", "2002-06-21 00:00:00", "AB", "AB0024", "2", "2002");
INSERT INTO betalingen VALUES("B0064", "29.75", "2002-08-06 00:00:00", "KB", "KB0013", "3", "2002");
INSERT INTO betalingen VALUES("B0065", "29.75", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("B0066", "535.50", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("B0067", "38.31", "2002-07-21 00:00:00", "KB", "KB0012", "3", "2002");
INSERT INTO betalingen VALUES("B0068", "79.10", "2002-07-02 00:00:00", "KB", "KB0008", "3", "2002");
INSERT INTO betalingen VALUES("B0069", "17.32", "2002-07-04 00:00:00", "KB", "KB0009", "3", "2002");
INSERT INTO betalingen VALUES("B0070", "44.04", "2002-06-28 00:00:00", "AB", "AB0025", "2", "2002");
INSERT INTO betalingen VALUES("B0071", "357.00", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("B0072", "34.71", "2002-07-08 00:00:00", "KB", "KB0010", "3", "2002");
INSERT INTO betalingen VALUES("B0073", "401.63", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0074", "190.40", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("B0075", "38.08", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("B0076", "59.50", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("B0076", "5.95", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0077", "101.15", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("B0078", "65.45", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("B0079", "65.45", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("B0080", "65.45", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("B0081", "29.75", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("B0082", "29.75", "2002-08-06 00:00:00", "KB", "KB0013", "3", "2002");
INSERT INTO betalingen VALUES("B0083", "29.75", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("B0084", "300.00", "2002-07-21 00:00:00", "KB", "KB0012", "3", "2002");
INSERT INTO betalingen VALUES("B0085", "-178.50", "2002-08-06 00:00:00", "KB", "KB0013", "3", "2002");
INSERT INTO betalingen VALUES("B0086", "204.68", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("B0087", "38.08", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("B0088", "65.45", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0089", "101.15", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("B0090", "65.45", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("B0091", "65.45", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("B0092", "65.45", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("B0093", "29.75", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("B0094", "29.75", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("B0095", "214.20", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0096", "38.08", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("B0097", "65.45", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0098", "189.51", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("B0099", "65.45", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0100", "65.45", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0101", "65.45", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0102", "29.75", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0103", "29.75", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0104", "24.38", "2002-09-24 00:00:00", "KB", "KB0016", "3", "2002");
INSERT INTO betalingen VALUES("B0105", "214.20", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0106", "38.08", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0107", "65.45", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0109", "65.45", "2002-11-29 00:00:00", "AB", "AB0031", "4", "2002");
INSERT INTO betalingen VALUES("B0110", "65.45", "2002-11-29 00:00:00", "AB", "AB0031", "4", "2002");
INSERT INTO betalingen VALUES("B0111", "65.45", "2002-11-29 00:00:00", "AB", "AB0031", "4", "2002");
INSERT INTO betalingen VALUES("B0112", "29.75", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("B0113", "29.75", "2002-11-29 00:00:00", "AB", "AB0031", "4", "2002");
INSERT INTO betalingen VALUES("B0114", "73.14", "2002-10-13 00:00:00", "KB", "KB0017", "4", "2002");
INSERT INTO betalingen VALUES("B0115", "169.47", "2002-10-13 00:00:00", "KB", "KB0018", "4", "2002");
INSERT INTO betalingen VALUES("B0116", "214.20", "2002-11-29 00:00:00", "AB", "AB0031", "4", "2002");
INSERT INTO betalingen VALUES("B0117", "38.08", "2002-11-29 00:00:00", "AB", "AB0031", "4", "2002");
INSERT INTO betalingen VALUES("B0118", "59.50", "2002-11-29 00:00:00", "AB", "AB0031", "4", "2002");
INSERT INTO betalingen VALUES("B0118", "5.95", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("B0119", "101.15", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("B0120", "65.45", "2002-12-31 00:00:00", "AB", "AB0032", "4", "2002");
INSERT INTO betalingen VALUES("B0121", "65.45", "2002-12-31 00:00:00", "AB", "AB0032", "4", "2002");
INSERT INTO betalingen VALUES("B0122", "65.45", "2002-12-31 00:00:00", "AB", "AB0032", "4", "2002");
INSERT INTO betalingen VALUES("B0123", "29.75", "2002-12-31 00:00:00", "AB", "AB0032", "4", "2002");
INSERT INTO betalingen VALUES("B0124", "29.75", "2002-12-31 00:00:00", "AB", "AB0032", "4", "2002");
INSERT INTO betalingen VALUES("B0125", "150.00", "2002-11-26 00:00:00", "KB", "KB0021", "4", "2002");
INSERT INTO betalingen VALUES("B0125", "150.00", "2002-11-05 00:00:00", "KB", "KB0020", "4", "2002");
INSERT INTO betalingen VALUES("B0126", "90.36", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("B0127", "300.00", "2002-12-23 00:00:00", "KB", "KB0022", "4", "2002");
INSERT INTO betalingen VALUES("B0128", "38.08", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("B0129", "59.50", "2002-12-31 00:00:00", "AB", "AB0032", "4", "2002");
INSERT INTO betalingen VALUES("B0129", "5.95", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("B0130", "65.45", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("B0131", "65.45", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("B0132", "65.45", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("B0133", "29.75", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("B0134", "101.15", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("B0135", "214.20", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("B0136", "29.75", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("B0137", "215.69", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("C0001", "38.08", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("C0002", "65.45", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("C0003", "65.45", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("C0004", "65.45", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("C0005", "65.45", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("C0006", "29.75", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("C0007", "101.15", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("C0008", "214.20", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("C0009", "29.75", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("C0010", "357.00", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("C0011", "327.25", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("C0012", "38.08", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("C0013", "65.45", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("C0014", "65.45", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("C0015", "65.45", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("C0016", "65.45", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("C0017", "29.75", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("C0018", "101.15", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("C0019", "214.20", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("C0020", "38.75", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("C0021", "16.24", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("C0022", "297.50", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("C0023", "38.08", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("C0024", "59.00", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("C0030", "214.20", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("2000030001", "65.86", "2000-09-29 00:00:00", "AB", "AB0002", "3", "2000");
INSERT INTO betalingen VALUES("2000030002", "6.08", "2000-09-29 00:00:00", "AB", "AB0002", "3", "2000");
INSERT INTO betalingen VALUES("2000030003", "1138.37", "2000-11-10 00:00:00", "AB", "", "4", "2000");
INSERT INTO betalingen VALUES("2000040001", "159.43", "2000-11-03 00:00:00", "AB", "AB0005", "4", "2000");
INSERT INTO betalingen VALUES("2000040002", "135.97", "2000-12-01 00:00:00", "AB", "AB0006", "4", "2000");
INSERT INTO betalingen VALUES("2000040003", "26.51", "2000-12-20 00:00:00", "AB", "AB0007", "4", "2000");
INSERT INTO betalingen VALUES("2001010001", "26.22", "2001-01-26 00:00:00", "AB", "AB0002", "1", "2001");
INSERT INTO betalingen VALUES("2001010002", "38.43", "2001-02-28 00:00:00", "AB", "AB0004", "1", "2001");
INSERT INTO betalingen VALUES("2001010003", "62.90", "2001-03-16 00:00:00", "AB", "AB0007", "1", "2001");
INSERT INTO betalingen VALUES("2001010004", "54.83", "2001-04-03 00:00:00", "AB", "AB0008", "2", "2001");
INSERT INTO betalingen VALUES("2001020001", "25.97", "2001-05-11 00:00:00", "AB", "AB0013", "2", "2001");
INSERT INTO betalingen VALUES("2001020002", "24.27", "2001-06-21 00:00:00", "AB", "AB0017", "2", "2001");
INSERT INTO betalingen VALUES("2001020003", "24.07", "2001-07-06 00:00:00", "AB", "AB0021", "3", "2001");
INSERT INTO betalingen VALUES("2001030001", "56.70", "2001-08-04 00:00:00", "KB", "KB0002", "3", "2001");
INSERT INTO betalingen VALUES("2001030002", "38.08", "2001-08-03 00:00:00", "AB", "AB0024", "3", "2001");
INSERT INTO betalingen VALUES("2001030003", "90.20", "2001-09-12 00:00:00", "AB", "AB0028", "3", "2001");
INSERT INTO betalingen VALUES("2001030004", "173.58", "2001-09-28 00:00:00", "AB", "AB0032", "3", "2001");
INSERT INTO betalingen VALUES("2001030005", "70.16", "2001-10-19 00:00:00", "AB", "AB0035", "4", "2001");
INSERT INTO betalingen VALUES("2001040001", "45.36", "2001-10-12 00:00:00", "AB", "AB0034", "4", "2001");
INSERT INTO betalingen VALUES("2001040002", "216.00", "2001-10-26 00:00:00", "AB", "AB0036", "4", "2001");
INSERT INTO betalingen VALUES("2001040003", "33.58", "2001-10-26 00:00:00", "AB", "AB0036", "4", "2001");
INSERT INTO betalingen VALUES("2001040004", "55.02", "2001-11-09 00:00:00", "AB", "AB0038", "4", "2001");
INSERT INTO betalingen VALUES("2001040005", "810.00", "2002-03-12 00:00:00", "AB", "AB0009", "1", "2002");
INSERT INTO betalingen VALUES("2001040006", "34.92", "2001-11-23 00:00:00", "AB", "AB0040", "4", "2001");
INSERT INTO betalingen VALUES("2001040007", "116.10", "2001-11-30 00:00:00", "AB", "AB0041", "4", "2001");
INSERT INTO betalingen VALUES("2001040008", "166.83", "2001-11-30 00:00:00", "AB", "AB0041", "4", "2001");
INSERT INTO betalingen VALUES("2001040009", "72.29", "2001-12-07 00:00:00", "AB", "AB0042", "4", "2001");
INSERT INTO betalingen VALUES("2001040010", "63.30", "2001-12-28 00:00:00", "AB", "AB0045", "4", "2001");
INSERT INTO betalingen VALUES("2001040011", "1212.30", "2001-12-28 00:00:00", "AB", "AB0045", "4", "2001");
INSERT INTO betalingen VALUES("2002010001", "63.74", "2002-01-22 00:00:00", "AB", "AB0002", "1", "2002");
INSERT INTO betalingen VALUES("2002010002", "1098.85", "2002-01-22 00:00:00", "KB", "KB0001", "1", "2002");
INSERT INTO betalingen VALUES("2002010003", "63.31", "2002-02-15 00:00:00", "AB", "AB0006", "1", "2002");
INSERT INTO betalingen VALUES("2002010004", "51.79", "2002-02-15 00:00:00", "AB", "AB0006", "1", "2002");
INSERT INTO betalingen VALUES("2002010005", "48.84", "2002-02-15 00:00:00", "AB", "AB0006", "1", "2002");
INSERT INTO betalingen VALUES("2002010006", "24.73", "2002-03-22 00:00:00", "AB", "AB0011", "1", "2002");
INSERT INTO betalingen VALUES("2002010007", "17.02", "2002-03-15 00:00:00", "KB", "KB0003", "1", "2002");
INSERT INTO betalingen VALUES("2002010008", "311.62", "2002-03-15 00:00:00", "KB", "KB0004", "1", "2002");
INSERT INTO betalingen VALUES("2002010009", "321.50", "2002-03-22 00:00:00", "AB", "AB0011", "1", "2002");
INSERT INTO betalingen VALUES("2002010010", "355.81", "2002-03-22 00:00:00", "AB", "AB0011", "1", "2002");
INSERT INTO betalingen VALUES("2002010011", "102.34", "2002-04-12 00:00:00", "AB", "AB0014", "2", "2002");
INSERT INTO betalingen VALUES("2002010012", "62.23", "2002-04-12 00:00:00", "AB", "AB0014", "2", "2002");
INSERT INTO betalingen VALUES("2002020001", "22.53", "2002-04-23 00:00:00", "AB", "AB0015", "2", "2002");
INSERT INTO betalingen VALUES("2002020002", "185.34", "2002-04-12 00:00:00", "AB", "AB0014", "2", "2002");
INSERT INTO betalingen VALUES("2002020003", "92.00", "2002-04-26 00:00:00", "AB", "AB0016", "2", "2002");
INSERT INTO betalingen VALUES("2002020003", "2.68", "2002-06-28 00:00:00", "AB", "AB0025", "2", "2002");
INSERT INTO betalingen VALUES("2002020004", "402.22", "2002-05-17 00:00:00", "AB", "AB0019", "2", "2002");
INSERT INTO betalingen VALUES("2002020005", "72.51", "2002-05-10 00:00:00", "AB", "AB0018", "2", "2002");
INSERT INTO betalingen VALUES("2002020006", "61.93", "2002-05-03 00:00:00", "AB", "AB0017", "2", "2002");
INSERT INTO betalingen VALUES("2002020006", "1.80", "2002-06-28 00:00:00", "AB", "AB0025", "2", "2002");
INSERT INTO betalingen VALUES("2002020007", "24.43", "2002-05-24 00:00:00", "AB", "AB0020", "2", "2002");
INSERT INTO betalingen VALUES("2002020008", "69.31", "2002-06-14 00:00:00", "AB", "AB0023", "2", "2002");
INSERT INTO betalingen VALUES("2002020009", "20.68", "2002-06-14 00:00:00", "AB", "AB0023", "2", "2002");
INSERT INTO betalingen VALUES("2002020010", "94.00", "2002-06-14 00:00:00", "AB", "AB0023", "2", "2002");
INSERT INTO betalingen VALUES("2002020011", "145.06", "2002-06-28 00:00:00", "AB", "AB0025", "2", "2002");
INSERT INTO betalingen VALUES("2002020012", "48.21", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("2002030001", "309.40", "2002-07-06 00:00:00", "KB", "KB0011", "3", "2002");
INSERT INTO betalingen VALUES("2002030002", "45.73", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("2002030003", "121.29", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("2002030004", "64.59", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("2002030005", "16.90", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("2002030006", "16.90", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("2002030007", "-16.90", "2002-07-31 00:00:00", "AB", "AB0027", "3", "2002");
INSERT INTO betalingen VALUES("2002030008", "39.00", "2002-08-06 00:00:00", "KB", "KB0014", "3", "2002");
INSERT INTO betalingen VALUES("2002030009", "133.28", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("2002030010", "73.19", "2002-08-30 00:00:00", "AB", "AB0028", "3", "2002");
INSERT INTO betalingen VALUES("2002030011", "53.10", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("2002030012", "28.51", "2002-08-29 00:00:00", "KB", "KB0015", "3", "2002");
INSERT INTO betalingen VALUES("2002030013", "137.57", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("2002030014", "97.04", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("2002030015", "59.92", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("2002030016", "-15.90", "2002-09-30 00:00:00", "AB", "AB0029", "3", "2002");
INSERT INTO betalingen VALUES("2002030017", "-24.70", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("2002040001", "123.76", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("2002040002", "880.60", "2002-11-29 00:00:00", "AB", "AB0031", "4", "2002");
INSERT INTO betalingen VALUES("2002040003", "91.44", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("2002040004", "187.53", "2002-10-31 00:00:00", "AB", "AB0030", "4", "2002");
INSERT INTO betalingen VALUES("2002040005", "57.87", "2002-11-29 00:00:00", "AB", "AB0031", "4", "2002");
INSERT INTO betalingen VALUES("2002040006", "202.73", "2002-11-29 00:00:00", "AB", "AB0031", "4", "2002");
INSERT INTO betalingen VALUES("2002040007", "252.63", "2002-12-31 00:00:00", "AB", "AB0032", "4", "2002");
INSERT INTO betalingen VALUES("2002040008", "60.18", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("2002040009", "187.53", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("2002040010", "565.25", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("2003010001", "51.27", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("2003010002", "200.00", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("2003010003", "61.34", "2003-01-31 00:00:00", "AB", "AB0001", "1", "2003");
INSERT INTO betalingen VALUES("2003010004", "200.50", "2003-02-28 00:00:00", "AB", "AB0002", "1", "2003");
INSERT INTO betalingen VALUES("2003010005", "60.93", "2003-03-31 00:00:00", "AB", "AB0003", "1", "2003");
INSERT INTO betalingen VALUES("C0032", "38.08", "2003-04-30 00:00:00", "AB", "AB0004", "2", "2003");
INSERT INTO betalingen VALUES("C0025", "65.45", "2003-04-30 00:00:00", "AB", "AB0004", "2", "2003");
INSERT INTO betalingen VALUES("C0039", "214.20", "2003-04-30 00:00:00", "AB", "AB0004", "2", "2003");
INSERT INTO betalingen VALUES("C0043", "65.45", "2003-04-30 00:00:00", "AB", "AB0004", "2", "2003");
INSERT INTO betalingen VALUES("C0033", "65.45", "2003-04-30 00:00:00", "AB", "AB0004", "2", "2003");
INSERT INTO betalingen VALUES("C0027", "65.45", "2003-04-30 00:00:00", "AB", "AB0004", "2", "2003");
INSERT INTO betalingen VALUES("C0037", "29.75", "2003-04-30 00:00:00", "AB", "AB0004", "2", "2003");
INSERT INTO betalingen VALUES("C0026", "65.45", "2003-04-30 00:00:00", "AB", "AB0004", "2", "2003");
INSERT INTO betalingen VALUES("2003010006", "72.50", "2003-04-30 00:00:00", "AB", "AB0004", "2", "2003");
INSERT INTO betalingen VALUES("C0028", "29.75", "2003-04-30 00:00:00", "AB", "AB0004", "2", "2003");
INSERT INTO betalingen VALUES("2003010007", "74.45", "2003-04-30 00:00:00", "AB", "AB0004", "2", "2003");
INSERT INTO betalingen VALUES("C0053", "-40.16", "2003-05-26 00:00:00", "KB", "KB0002", "2", "2003");
INSERT INTO betalingen VALUES("B0066", "40.16", "2003-05-26 00:00:00", "KB", "KB0002", "2", "2003");
INSERT INTO betalingen VALUES("C0063", "0.00", "2003-06-01 00:00:00", "", "", "0", "0");


#
# Table structure for table 'deb_dl'
#

DROP TABLE IF EXISTS deb_dl;
CREATE TABLE deb_dl (
  DLDTRANS varchar(10) NOT NULL default '',
  DLDDATUM datetime NOT NULL default '0000-00-00 00:00:00',
  DLDBEDRAG decimal(15,2) NOT NULL default '0.00',
  DLDBW char(2) NOT NULL default '',
  rowid int(11) NOT NULL auto_increment,
  PRIMARY KEY  (rowid),
  KEY DLDTRANS (DLDTRANS)
) TYPE=InnoDB;



#
# Dumping data for table 'deb_dl'
#

INSERT INTO deb_dl VALUES("A0005", "2001-01-12 00:00:00", "11.34", "AB", "1");
INSERT INTO deb_dl VALUES("A0019", "2001-09-25 00:00:00", "415.80", "AB", "2");
INSERT INTO deb_dl VALUES("A0019", "2001-10-05 00:00:00", "415.80", "AB", "3");
INSERT INTO deb_dl VALUES("A0019", "2001-11-20 00:00:00", "-415.80", "AB", "4");
INSERT INTO deb_dl VALUES("B0001", "2001-01-01 01:00:00", "0.00", "", "5");
INSERT INTO deb_dl VALUES("B0001", "2002-02-08 00:00:00", "105.00", "AB", "6");
INSERT INTO deb_dl VALUES("B0007", "2001-01-01 01:00:00", "0.00", "", "7");
INSERT INTO deb_dl VALUES("B0007", "2002-03-01 00:00:00", "59.90", "AB", "8");
INSERT INTO deb_dl VALUES("A0005", "2002-03-28 00:00:00", "1.99", "AB", "9");
INSERT INTO deb_dl VALUES("B0001", "2002-03-28 00:00:00", "19.95", "AB", "10");
INSERT INTO deb_dl VALUES("B0007", "2002-06-28 00:00:00", "-0.40", "AB", "13");
INSERT INTO deb_dl VALUES("B0066", "2001-01-01 01:00:00", "0.00", "", "14");
INSERT INTO deb_dl VALUES("B0066", "2002-07-31 00:00:00", "535.50", "AB", "15");
INSERT INTO deb_dl VALUES("B0108", "2001-01-01 01:00:00", "0.00", "", "16");
INSERT INTO deb_dl VALUES("B0108", "2002-09-30 00:00:00", "88.36", "AB", "17");
INSERT INTO deb_dl VALUES("B0076", "2001-01-01 01:00:00", "0.00", "", "18");
INSERT INTO deb_dl VALUES("B0076", "2002-09-30 00:00:00", "59.50", "AB", "19");
INSERT INTO deb_dl VALUES("B0076", "2002-10-31 00:00:00", "5.95", "AB", "20");
INSERT INTO deb_dl VALUES("B0125", "2002-11-05 00:00:00", "150.00", "KB", "22");
INSERT INTO deb_dl VALUES("B0125", "2002-11-26 00:00:00", "150.00", "KB", "25");
INSERT INTO deb_dl VALUES("B0118", "2002-11-29 00:00:00", "59.50", "AB", "26");
INSERT INTO deb_dl VALUES("B0129", "2002-12-31 00:00:00", "59.50", "AB", "27");
INSERT INTO deb_dl VALUES("C0020", "2003-02-04 00:00:00", "0.00", "", "28");
INSERT INTO deb_dl VALUES("C0020", "2003-02-28 00:00:00", "38.75", "AB", "29");
INSERT INTO deb_dl VALUES("C0024", "2003-03-10 00:00:00", "0.00", "", "30");
INSERT INTO deb_dl VALUES("C0024", "2003-03-31 00:00:00", "59.00", "AB", "31");
INSERT INTO deb_dl VALUES("B0129", "2003-03-31 00:00:00", "5.95", "AB", "32");
INSERT INTO deb_dl VALUES("B0118", "2003-03-31 00:00:00", "5.95", "AB", "33");
INSERT INTO deb_dl VALUES("B0066", "2002-07-31 00:00:00", "535.50", "AB", "34");
INSERT INTO deb_dl VALUES("B0066", "2003-05-26 00:00:00", "40.16", "KB", "35");


#
# Table structure for table 'deb_rek'
#

DROP TABLE IF EXISTS deb_rek;
CREATE TABLE deb_rek (
  NUMMER int(5) NOT NULL default '0',
  FACTUUR varchar(6) NOT NULL default '',
  DATUM datetime NOT NULL default '0000-00-00 00:00:00',
  NETTO decimal(15,2) NOT NULL default '0.00',
  BRUTO decimal(15,2) NOT NULL default '0.00',
  NETTOHOOG decimal(15,2) NOT NULL default '0.00',
  NETTOLAAG decimal(15,2) NOT NULL default '0.00',
  NETTONUL decimal(15,2) NOT NULL default '0.00',
  BTWHOOG decimal(15,2) NOT NULL default '0.00',
  BTWLAAG decimal(15,2) NOT NULL default '0.00',
  BET_DATUM datetime NOT NULL default '0000-00-00 00:00:00',
  BET_BEDRAG decimal(15,2) NOT NULL default '0.00',
  TERMIJN int(100) NOT NULL default '0',
  BET_WIJZE char(2) NOT NULL default '',
  DEEL_BET enum('Y','N') NOT NULL default 'N',
  BTWTARIEFH decimal(15,2) NOT NULL default '0.00',
  BTWTARIEFL decimal(15,2) NOT NULL default '0.00',
  BTWLTR char(1) NOT NULL default '',
  MAKER char(3) NOT NULL default '',
  PRIMARY KEY  (FACTUUR),
  KEY NUMMER (NUMMER),
  KEY OVERZICHT (NUMMER,FACTUUR),
  KEY FACTUUR (FACTUUR)
) TYPE=InnoDB;



#
# Dumping data for table 'deb_rek'
#

INSERT INTO deb_rek VALUES("2", "A0001", "2000-09-29 00:00:00", "0.00", "1111.76", "0.00", "0.00", "0.00", "0.00", "0.00", "2000-10-24 00:00:00", "1111.76", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0002", "2000-10-02 00:00:00", "0.00", "1594.24", "0.00", "0.00", "0.00", "0.00", "0.00", "2000-10-13 00:00:00", "1594.24", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0003", "2000-10-04 00:00:00", "0.00", "13.33", "0.00", "0.00", "0.00", "0.00", "0.00", "2000-10-13 00:00:00", "13.33", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0004", "2000-11-08 00:00:00", "0.00", "13.33", "0.00", "0.00", "0.00", "0.00", "0.00", "2000-12-01 00:00:00", "13.33", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0005", "2000-12-18 00:00:00", "0.00", "13.33", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-28 00:00:00", "13.33", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "A0006", "2001-02-26 00:00:00", "0.00", "59.40", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-03-13 00:00:00", "59.40", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0007", "2001-02-26 00:00:00", "0.00", "27.00", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-03-16 00:00:00", "27.00", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "A0008", "2001-03-29 00:00:00", "0.00", "29.70", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-04-20 00:00:00", "29.70", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0009", "2001-03-29 00:00:00", "0.00", "13.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-04-20 00:00:00", "13.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "A0010", "2001-05-04 00:00:00", "0.00", "29.70", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-05-25 00:00:00", "29.70", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0011", "2001-05-04 00:00:00", "0.00", "100.98", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-05-25 00:00:00", "100.98", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0012", "2001-05-08 00:00:00", "0.00", "162.00", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-05-25 00:00:00", "162.00", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0013", "2001-06-06 00:00:00", "0.00", "100.98", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-07-17 00:00:00", "100.98", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "A0014", "2001-06-06 00:00:00", "0.00", "29.70", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-06-23 00:00:00", "29.70", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "A0015", "2001-07-09 00:00:00", "0.00", "29.70", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-08-17 00:00:00", "29.70", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0016", "2001-07-09 00:00:00", "0.00", "100.98", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-07-20 00:00:00", "100.98", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "A0017", "2001-08-03 00:00:00", "0.00", "29.70", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-08-17 00:00:00", "29.70", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0018", "2001-08-03 00:00:00", "0.00", "100.98", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-08-28 00:00:00", "100.98", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "A0019", "2001-08-06 00:00:00", "0.00", "415.80", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-11-20 00:00:00", "415.80", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "A0020", "2001-09-04 00:00:00", "0.00", "29.70", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-09-18 00:00:00", "29.70", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0021", "2001-09-04 00:00:00", "0.00", "100.98", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-09-18 00:00:00", "100.98", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "A0022", "2001-10-01 00:00:00", "0.00", "29.70", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-10-19 00:00:00", "29.70", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0023", "2001-10-01 00:00:00", "0.00", "100.98", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-10-12 00:00:00", "100.98", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "A0024", "2001-10-31 00:00:00", "0.00", "89.10", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-11-23 00:00:00", "89.10", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0025", "2001-10-31 00:00:00", "0.00", "1350.00", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-11-23 00:00:00", "1350.00", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "A0026", "2001-10-31 00:00:00", "0.00", "37.80", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-11-20 00:00:00", "37.80", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0027", "2001-10-31 00:00:00", "0.00", "124.95", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-11-23 00:00:00", "124.95", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "A0028", "2001-11-26 00:00:00", "0.00", "37.80", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-12-18 00:00:00", "37.80", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "A0029", "2001-11-26 00:00:00", "0.00", "89.10", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-01-25 00:00:00", "89.10", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0030", "2001-11-26 00:00:00", "0.00", "124.95", "0.00", "0.00", "0.00", "0.00", "0.00", "2001-12-21 00:00:00", "124.95", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "A0031", "2001-12-26 00:00:00", "0.00", "89.10", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-01-25 00:00:00", "89.10", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "A0032", "2001-12-26 00:00:00", "0.00", "37.80", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-01-25 00:00:00", "37.80", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "A0033", "2001-12-26 00:00:00", "0.00", "243.95", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-01-18 00:00:00", "243.95", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "B0001", "2002-01-22 00:00:00", "0.00", "124.95", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-28 00:00:00", "124.95", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "B0002", "2002-01-22 00:00:00", "0.00", "38.08", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-02-26 00:00:00", "38.08", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "B0003", "2002-01-22 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-01 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "B0004", "2002-01-22 00:00:00", "0.00", "89.25", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-04-26 00:00:00", "89.25", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("15", "B0005", "2002-01-22 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-01 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("16", "B0006", "2002-01-22 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-01 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("17", "B0007", "2002-01-22 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-06-28 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("18", "B0008", "2002-01-22 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-02-08 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("20", "B0009", "2002-01-22 00:00:00", "0.00", "700.01", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-19 00:00:00", "700.01", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "B0010", "2002-02-21 00:00:00", "0.00", "154.70", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-08 00:00:00", "154.70", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "B0011", "2002-02-21 00:00:00", "0.00", "38.08", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-22 00:00:00", "38.08", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "B0012", "2002-02-21 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-04-12 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "B0013", "2002-02-21 00:00:00", "0.00", "89.25", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-04-26 00:00:00", "89.25", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("15", "B0014", "2002-02-21 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-28 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("16", "B0015", "2002-02-21 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-28 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("17", "B0016", "2002-02-21 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-28 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("18", "B0017", "2002-02-21 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-08 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("19", "B0018", "2002-02-21 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-06 00:00:00", "29.75", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("21", "B0019", "2002-02-21 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-19 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("22", "B0020", "2002-02-21 00:00:00", "0.00", "562.28", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-08 00:00:00", "562.28", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("24", "B0021", "2002-02-25 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-28 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("21", "B0022", "2002-02-25 00:00:00", "0.00", "297.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-19 00:00:00", "297.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("22", "B0023", "2002-03-11 00:00:00", "0.00", "481.95", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-04-26 00:00:00", "481.95", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "B0024", "2002-03-18 00:00:00", "0.00", "172.55", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-28 00:00:00", "172.55", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "B0025", "2002-03-18 00:00:00", "0.00", "38.08", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-04-05 00:00:00", "38.08", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "B0026", "2002-03-18 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-10 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "B0027", "2002-03-18 00:00:00", "0.00", "89.25", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-17 00:00:00", "89.25", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("15", "B0028", "2002-03-18 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-04-26 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("16", "B0029", "2002-03-18 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-04-26 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("17", "B0030", "2002-03-18 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-04-23 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("18", "B0031", "2002-03-18 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-03-28 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("19", "B0032", "2002-03-18 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-06 00:00:00", "29.75", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("25", "B0033", "2002-03-18 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-04-05 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("1", "B0034", "2002-04-08 00:00:00", "0.00", "250.00", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-04-08 00:00:00", "250.00", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "B0035", "2002-04-25 00:00:00", "0.00", "172.55", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-31 00:00:00", "172.55", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "B0036", "2002-04-25 00:00:00", "0.00", "38.08", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-31 00:00:00", "38.08", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "B0037", "2002-04-25 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-06-07 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "B0038", "2002-04-25 00:00:00", "0.00", "89.25", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-17 00:00:00", "89.25", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("15", "B0039", "2002-04-25 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-31 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("16", "B0040", "2002-04-25 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-06-07 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("17", "B0041", "2002-04-25 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-06-07 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("18", "B0042", "2002-04-25 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-03 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("19", "B0043", "2002-04-25 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-06 00:00:00", "29.75", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("25", "B0044", "2002-04-25 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-31 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("22", "B0045", "2002-04-25 00:00:00", "0.00", "107.10", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-31 00:00:00", "107.10", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "B0046", "2002-05-16 00:00:00", "0.00", "172.55", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-31 00:00:00", "172.55", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "B0047", "2002-05-16 00:00:00", "0.00", "38.08", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-31 00:00:00", "38.08", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "B0048", "2002-05-16 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-31 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "B0049", "2002-05-16 00:00:00", "0.00", "101.15", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-17 00:00:00", "101.15", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("15", "B0050", "2002-05-16 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-06-21 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("16", "B0051", "2002-05-16 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-06-21 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("17", "B0052", "2002-05-16 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-06-21 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("18", "B0053", "2002-05-16 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-05-28 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("19", "B0054", "2002-05-16 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-06 00:00:00", "29.75", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("25", "B0055", "2002-05-16 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-06-21 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "B0056", "2002-06-13 00:00:00", "0.00", "180.88", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-31 00:00:00", "180.88", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "B0057", "2002-06-13 00:00:00", "0.00", "38.08", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-06-28 00:00:00", "38.08", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "B0058", "2002-06-13 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-30 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "B0059", "2002-06-13 00:00:00", "0.00", "101.15", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-09-30 00:00:00", "101.15", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("15", "B0060", "2002-06-13 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-31 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("16", "B0061", "2002-06-13 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-31 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("17", "B0062", "2002-06-13 00:00:00", "0.00", "59.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-31 00:00:00", "59.50", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("18", "B0063", "2002-06-13 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-06-21 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("19", "B0064", "2002-06-13 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-06 00:00:00", "29.75", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("25", "B0065", "2002-06-13 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-31 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("22", "B0066", "2002-06-13 00:00:00", "0.00", "575.66", "0.00", "0.00", "0.00", "0.00", "0.00", "2003-05-26 00:00:00", "575.66", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("1", "B0067", "2002-06-19 00:00:00", "0.00", "38.31", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-21 00:00:00", "38.31", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("30", "B0068", "2002-06-19 00:00:00", "0.00", "79.10", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-02 00:00:00", "79.10", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("1", "B0069", "2002-06-19 00:00:00", "0.00", "17.32", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-04 00:00:00", "17.32", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("31", "B0070", "2002-06-19 00:00:00", "0.00", "44.04", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-06-28 00:00:00", "44.04", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("32", "B0071", "2002-06-24 00:00:00", "0.00", "357.00", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-31 00:00:00", "357.00", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("30", "B0072", "2002-07-08 00:00:00", "0.00", "34.71", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-08 00:00:00", "34.71", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("22", "B0073", "2002-07-10 00:00:00", "0.00", "401.63", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "401.63", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "B0074", "2002-07-10 00:00:00", "0.00", "190.40", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-30 00:00:00", "190.40", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "B0075", "2002-07-10 00:00:00", "0.00", "38.08", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-31 00:00:00", "38.08", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "B0076", "2002-07-10 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "B0077", "2002-07-10 00:00:00", "0.00", "101.15", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-09-30 00:00:00", "101.15", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("15", "B0078", "2002-07-10 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-30 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("16", "B0079", "2002-07-10 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-30 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("17", "B0080", "2002-07-10 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-30 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("18", "B0081", "2002-07-10 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-31 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("19", "B0082", "2002-07-10 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-06 00:00:00", "29.75", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("25", "B0083", "2002-07-10 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-30 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("1", "B0084", "2002-07-21 00:00:00", "0.00", "300.00", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-07-21 00:00:00", "300.00", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("19", "B0085", "2002-08-06 00:00:00", "0.00", "-178.50", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-06 00:00:00", "-178.50", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "B0086", "2002-08-07 00:00:00", "0.00", "204.68", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-30 00:00:00", "204.68", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "B0087", "2002-08-07 00:00:00", "0.00", "38.08", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-30 00:00:00", "38.08", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "B0088", "2002-08-07 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "B0089", "2002-08-07 00:00:00", "0.00", "101.15", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-09-30 00:00:00", "101.15", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("15", "B0090", "2002-08-07 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-09-30 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("16", "B0091", "2002-08-07 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-09-30 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("17", "B0092", "2002-08-07 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-09-30 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("18", "B0093", "2002-08-07 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-30 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("25", "B0094", "2002-08-07 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-08-30 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "B0095", "2002-09-05 00:00:00", "0.00", "214.20", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "214.20", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "B0096", "2002-09-05 00:00:00", "0.00", "38.08", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-09-30 00:00:00", "38.08", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "B0097", "2002-09-05 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "B0098", "2002-09-05 00:00:00", "0.00", "101.15", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-09-30 00:00:00", "101.15", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("15", "B0099", "2002-09-05 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("16", "B0100", "2002-09-05 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("17", "B0101", "2002-09-05 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("18", "B0102", "2002-09-05 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("25", "B0103", "2002-09-05 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("1", "B0104", "2002-09-18 00:00:00", "0.00", "24.38", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-09-24 00:00:00", "24.38", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "B0105", "2002-10-01 00:00:00", "0.00", "214.20", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "214.20", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "B0106", "2002-10-01 00:00:00", "0.00", "38.08", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "38.08", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "B0107", "2002-10-01 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "B0108", "2002-10-01 00:00:00", "0.00", "101.15", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-09-30 00:00:00", "88.36", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("15", "B0109", "2002-10-01 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-11-29 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("16", "B0110", "2002-10-01 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-11-29 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("17", "B0111", "2002-10-01 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-11-29 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("18", "B0112", "2002-10-01 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-31 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("25", "B0113", "2002-10-01 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-11-29 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("1", "B0114", "2002-10-13 00:00:00", "0.00", "73.14", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-13 00:00:00", "73.14", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("1", "B0115", "2002-10-13 00:00:00", "0.00", "169.47", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-10-13 00:00:00", "169.47", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("3", "B0116", "2002-11-01 00:00:00", "0.00", "214.20", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-11-29 00:00:00", "214.20", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("8", "B0117", "2002-11-01 00:00:00", "0.00", "38.08", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-11-29 00:00:00", "38.08", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("9", "B0118", "2002-11-01 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2003-03-31 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("11", "B0119", "2002-11-01 00:00:00", "0.00", "101.15", "0.00", "0.00", "0.00", "0.00", "0.00", "2003-01-31 00:00:00", "101.15", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("15", "B0120", "2002-11-01 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-12-31 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("16", "B0121", "2002-11-01 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-12-31 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("17", "B0122", "2002-11-01 00:00:00", "0.00", "65.45", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-12-31 00:00:00", "65.45", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("18", "B0123", "2002-11-01 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-12-31 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("25", "B0124", "2002-11-01 00:00:00", "0.00", "29.75", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-12-31 00:00:00", "29.75", "14", "AB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("1", "B0125", "2002-11-04 00:00:00", "0.00", "300.00", "0.00", "0.00", "0.00", "0.00", "0.00", "2002-11-26 00:00:00", "300.00", "14", "KB", "", "0.00", "0.00", "", "");
INSERT INTO deb_rek VALUES("34", "B0126", "2002-12-17 00:00:00", "85.24", "90.36", "0.00", "85.24", "0.00", "0.00", "5.12", "2003-01-31 00:00:00", "90.36", "14", "AB", "", "19.00", "6.00", "L", "");
INSERT INTO deb_rek VALUES("1", "B0127", "2002-12-23 00:00:00", "252.10", "300.00", "252.10", "0.00", "0.00", "47.90", "0.00", "2002-12-23 00:00:00", "300.00", "14", "KB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("8", "B0128", "2002-12-30 00:00:00", "32.00", "38.08", "32.00", "0.00", "0.00", "6.08", "0.00", "2003-01-31 00:00:00", "38.08", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("9", "B0129", "2002-12-30 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-03-31 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("16", "B0130", "2002-12-30 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-02-28 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("17", "B0131", "2002-12-30 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-01-31 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("15", "B0132", "2002-12-30 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-01-31 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("18", "B0133", "2002-12-30 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2003-01-31 00:00:00", "29.75", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("11", "B0134", "2002-12-30 00:00:00", "85.00", "101.15", "85.00", "0.00", "0.00", "16.15", "0.00", "2003-01-31 00:00:00", "101.15", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("3", "B0135", "2002-12-30 00:00:00", "180.00", "214.20", "180.00", "0.00", "0.00", "34.20", "0.00", "2003-01-31 00:00:00", "214.20", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("25", "B0136", "2002-12-30 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2003-02-28 00:00:00", "29.75", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("2", "B0137", "2002-12-30 00:00:00", "181.25", "215.69", "181.25", "0.00", "0.00", "34.44", "0.00", "2003-01-31 00:00:00", "215.69", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("8", "C0001", "2003-01-02 00:00:00", "32.00", "38.08", "32.00", "0.00", "0.00", "6.08", "0.00", "2003-01-31 00:00:00", "38.08", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("9", "C0002", "2003-01-02 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-03-31 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("16", "C0003", "2003-01-02 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-02-28 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("17", "C0004", "2003-01-02 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-02-28 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("15", "C0005", "2003-01-02 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-02-28 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("18", "C0006", "2003-01-02 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2003-01-31 00:00:00", "29.75", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("11", "C0007", "2003-01-02 00:00:00", "85.00", "101.15", "85.00", "0.00", "0.00", "16.15", "0.00", "2003-01-31 00:00:00", "101.15", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("3", "C0008", "2003-01-02 00:00:00", "180.00", "214.20", "180.00", "0.00", "0.00", "34.20", "0.00", "2003-01-31 00:00:00", "214.20", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("25", "C0009", "2003-01-02 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2003-02-28 00:00:00", "29.75", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("21", "C0010", "2003-01-02 00:00:00", "300.00", "357.00", "300.00", "0.00", "0.00", "57.00", "0.00", "2003-02-28 00:00:00", "357.00", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("3", "C0011", "2003-01-06 00:00:00", "275.00", "327.25", "275.00", "0.00", "0.00", "52.25", "0.00", "2003-01-31 00:00:00", "327.25", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("8", "C0012", "2003-02-04 00:00:00", "32.00", "38.08", "32.00", "0.00", "0.00", "6.08", "0.00", "2003-03-31 00:00:00", "38.08", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("9", "C0013", "2003-02-04 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-03-31 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("16", "C0014", "2003-02-04 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-03-31 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("17", "C0015", "2003-02-04 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-03-31 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("15", "C0016", "2003-02-04 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-03-31 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("18", "C0017", "2003-02-04 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2003-02-28 00:00:00", "29.75", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("11", "C0018", "2003-02-04 00:00:00", "85.00", "101.15", "85.00", "0.00", "0.00", "16.15", "0.00", "2003-01-31 00:00:00", "101.15", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("3", "C0019", "2003-02-04 00:00:00", "180.00", "214.20", "180.00", "0.00", "0.00", "34.20", "0.00", "2003-02-28 00:00:00", "214.20", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("25", "C0020", "2003-02-04 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2003-02-28 00:00:00", "38.75", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("1", "C0021", "2003-02-04 00:00:00", "13.65", "16.24", "13.65", "0.00", "0.00", "2.59", "0.00", "2003-02-28 00:00:00", "16.24", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("36", "C0022", "2003-02-24 00:00:00", "250.00", "297.50", "250.00", "0.00", "0.00", "47.50", "0.00", "2003-03-31 00:00:00", "297.50", "14", "AB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("8", "C0023", "2003-03-10 00:00:00", "32.00", "38.08", "32.00", "0.00", "0.00", "6.08", "0.00", "2003-03-31 00:00:00", "38.08", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("9", "C0024", "2003-03-10 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-03-31 00:00:00", "59.00", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("16", "C0025", "2003-03-10 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-04-30 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("17", "C0026", "2003-03-10 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-04-30 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("15", "C0027", "2003-03-10 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-04-30 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("18", "C0028", "2003-03-10 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2003-04-30 00:00:00", "29.75", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("11", "C0029", "2003-03-10 00:00:00", "85.00", "101.15", "85.00", "0.00", "0.00", "16.15", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("3", "C0030", "2003-03-10 00:00:00", "180.00", "214.20", "180.00", "0.00", "0.00", "34.20", "0.00", "2003-03-31 00:00:00", "214.20", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("25", "C0031", "2003-03-10 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("8", "C0032", "2003-04-04 00:00:00", "32.00", "38.08", "32.00", "0.00", "0.00", "6.08", "0.00", "2003-04-30 00:00:00", "38.08", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("9", "C0033", "2003-04-04 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-04-30 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("16", "C0034", "2003-04-04 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("17", "C0035", "2003-04-04 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("15", "C0036", "2003-04-04 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("18", "C0037", "2003-04-04 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2003-04-30 00:00:00", "29.75", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("11", "C0038", "2003-04-04 00:00:00", "85.00", "101.15", "85.00", "0.00", "0.00", "16.15", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("3", "C0039", "2003-04-04 00:00:00", "180.00", "214.20", "180.00", "0.00", "0.00", "34.20", "0.00", "2003-04-30 00:00:00", "214.20", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("25", "C0040", "2003-04-04 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("22", "C0041", "2003-04-09 00:00:00", "90.00", "107.10", "90.00", "0.00", "0.00", "17.10", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("8", "C0042", "2003-05-01 00:00:00", "32.00", "38.08", "32.00", "0.00", "0.00", "6.08", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("9", "C0043", "2003-05-01 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2003-04-30 00:00:00", "65.45", "14", "AB", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("16", "C0044", "2003-05-01 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("17", "C0045", "2003-05-01 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("15", "C0046", "2003-05-01 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("18", "C0047", "2003-05-01 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("11", "C0048", "2003-05-01 00:00:00", "85.00", "101.15", "85.00", "0.00", "0.00", "16.15", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("3", "C0049", "2003-05-01 00:00:00", "180.00", "214.20", "180.00", "0.00", "0.00", "34.20", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("25", "C0050", "2003-05-01 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("39", "C0051", "2003-05-01 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "2001-01-01 01:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("3", "C0052", "2003-05-13 00:00:00", "350.00", "416.50", "350.00", "0.00", "0.00", "66.50", "0.00", "0001-01-01 00:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("22", "C0053", "2003-05-23 00:00:00", "-33.75", "-40.16", "-33.75", "0.00", "0.00", "-6.41", "0.00", "2003-05-26 00:00:00", "-40.16", "14", "KB", "", "19.00", "6.00", "H", "");
INSERT INTO deb_rek VALUES("8", "C0054", "2003-06-02 00:00:00", "32.00", "38.08", "32.00", "0.00", "0.00", "6.08", "0.00", "0000-00-00 00:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("9", "C0055", "2003-06-02 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "0000-00-00 00:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("16", "C0056", "2003-06-02 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "0000-00-00 00:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("17", "C0057", "2003-06-02 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "0000-00-00 00:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("15", "C0058", "2003-06-02 00:00:00", "55.00", "65.45", "55.00", "0.00", "0.00", "10.45", "0.00", "0000-00-00 00:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("18", "C0059", "2003-06-02 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "0000-00-00 00:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("11", "C0060", "2003-06-02 00:00:00", "85.00", "101.15", "85.00", "0.00", "0.00", "16.15", "0.00", "0000-00-00 00:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("3", "C0061", "2003-06-02 00:00:00", "180.00", "214.20", "180.00", "0.00", "0.00", "34.20", "0.00", "0000-00-00 00:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("25", "C0062", "2003-06-02 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "0000-00-00 00:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");
INSERT INTO deb_rek VALUES("39", "C0063", "2003-06-02 00:00:00", "25.00", "29.75", "25.00", "0.00", "0.00", "4.75", "0.00", "0000-00-00 00:00:00", "0.00", "14", "", "", "19.00", "6.00", "H", "AUT");


#
# Table structure for table 'relatie'
#

DROP TABLE IF EXISTS relatie;
CREATE TABLE relatie (
  RNUMMER int(5) NOT NULL auto_increment,
  RNAAMNTX varchar(16) NOT NULL default '',
  RNAAM varchar(100) NOT NULL default '',
  wijzig varchar(50) NOT NULL default '',
  PRIMARY KEY  (RNUMMER),
  KEY RNAAMNTX (RNAAMNTX),
  KEY RNUMMER (RNUMMER)
) TYPE=MyISAM;



#
# Dumping data for table 'relatie'
#

INSERT INTO relatie VALUES("1", "KONTANT", "Kontante Verkoop", "");
INSERT INTO relatie VALUES("2", "SYSTEMCARE", "System:Care", "");
INSERT INTO relatie VALUES("3", "KOMBIN", "Kombin", "");
INSERT INTO relatie VALUES("4", "KVK", "Kamer van Koophandel Venlo", "");
INSERT INTO relatie VALUES("5", "SOS", "Serve-On-Site", "");
INSERT INTO relatie VALUES("6", "PLEX", "Plex Internet", "");
INSERT INTO relatie VALUES("7", "BEN", "Ben Nederland", "");
INSERT INTO relatie VALUES("8", "NIEUWENHOF", "Mts. G.J.M. van den Nieuwenhof", "");
INSERT INTO relatie VALUES("9", "TAPESH", "Tapes Hilversum BV", "");
INSERT INTO relatie VALUES("10", "DIXONS", "Dixons", "");
INSERT INTO relatie VALUES("11", "DRUKSHOP", "Drukshop Venray", "");
INSERT INTO relatie VALUES("12", "MARTIN", "Martin Cuypers", "");
INSERT INTO relatie VALUES("13", "HOOFT", "Van Hooft Advocaten", "");
INSERT INTO relatie VALUES("14", "BOL", "Bol.com", "");
INSERT INTO relatie VALUES("15", "TAPESM", "Tapes Media", "");
INSERT INTO relatie VALUES("16", "TAPESA", "Tapes Amsterdam", "");
INSERT INTO relatie VALUES("17", "TAPESR", "Tapes Rotterdam", "");
INSERT INTO relatie VALUES("18", "DEEGE", "Gebr Deege Bv.", "");
INSERT INTO relatie VALUES("19", "TAEL", "Tael Bv", "");
INSERT INTO relatie VALUES("20", "ROBMENHE", "Rob Menheere", "");
INSERT INTO relatie VALUES("21", "VISION", "Vision Partners", "");
INSERT INTO relatie VALUES("22", "BAS", "BAS Bv", "");
INSERT INTO relatie VALUES("23", "GSPROM", "GS Promotions", "");
INSERT INTO relatie VALUES("24", "LIMAX", "Limax Bv", "");
INSERT INTO relatie VALUES("25", "VALITEX", "Valitex", "");
INSERT INTO relatie VALUES("26", "999GAMES", "999 Games", "");
INSERT INTO relatie VALUES("27", "PRIMAFOON", "Primafoon", "");
INSERT INTO relatie VALUES("28", "KPN", "KPN Mobile", "");
INSERT INTO relatie VALUES("29", "PSGAMES", "PS Games", "");
INSERT INTO relatie VALUES("30", "VKLEEF", "van Kleef", "");
INSERT INTO relatie VALUES("31", "BESSEMS", "Danny Bessems", "");
INSERT INTO relatie VALUES("32", "HUMAN", "Human Insurance", "");
INSERT INTO relatie VALUES("33", "ROODBEEN", "Roodbeen & Partners", "");
INSERT INTO relatie VALUES("34", "ZORG", "Ray Zorg", "");
INSERT INTO relatie VALUES("35", "KVKLEEF", "Koert van Kleef", "");
INSERT INTO relatie VALUES("36", "ADVANCE", "Advance Automatisering", "");
INSERT INTO relatie VALUES("37", "BRAM", "Barm Swaghoven", "");
INSERT INTO relatie VALUES("38", "JUNIOR", "Junior Connor", "");
INSERT INTO relatie VALUES("39", "KNOPPERS", "Firma Knoppers", "");
INSERT INTO relatie VALUES("40", "KAMP", "Mike vd Kamp", "");