text: -- phpMyAdmin SQL Dump
  -- version 3.4.5
  -- http://www.phpmyadmin.net
  --
  -- Host: localhost
  -- Generation Time: Nov 24, 2017 at 01:53 AM
  -- Server version: 5.5.16
  -- PHP Version: 5.3.8
  
  SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  
  --
  -- Database: `dts-dashboard`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `file_transaksi`
  --
  
  CREATE TABLE IF NOT EXISTS `file_transaksi` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nama_file` varchar(250) NOT NULL,
    `deskripsi` text,
    `waktu_upload` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `jenis_transaksi` varchar(50) NOT NULL,
    `last_update` timestamp NULL DEFAULT NULL,
    `status` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
  
  --
  -- Dumping data for table `file_transaksi`
  --
  
  INSERT INTO `file_transaksi` (`id`, `nama_file`, `deskripsi`, `waktu_upload`, `jenis_transaksi`, `last_update`, `status`) VALUES
  (1, '2017-11-16-bond', NULL, '2017-11-15 23:56:15', 'bond', NULL, NULL),
  (2, '2017-11-16-bond', NULL, '2017-11-15 23:56:56', 'bond', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `target`
  --
  
  CREATE TABLE IF NOT EXISTS `target` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `bulan` int(2) NOT NULL,
    `tahun` int(4) NOT NULL,
    `volumefx` decimal(30,2) DEFAULT NULL,
    `transaksifx` decimal(30,2) DEFAULT NULL,
    `nasabahfx` decimal(30,2) DEFAULT NULL,
    `volumebond` decimal(30,2) DEFAULT NULL,
    `nasabahbond` decimal(30,2) DEFAULT NULL,
    `transaksigmra` decimal(30,2) DEFAULT NULL,
    `nasabahgmra` decimal(30,2) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
  
  --
  -- Dumping data for table `target`
  --
  
  INSERT INTO `target` (`id`, `bulan`, `tahun`, `volumefx`, `transaksifx`, `nasabahfx`, `volumebond`, `nasabahbond`, `transaksigmra`, `nasabahgmra`) VALUES
  (4, 1, 2016, 234.00, 20.00, 123123123.00, NULL, NULL, 123123123123.00, 1234.00),
  (5, 4, 2018, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `transaksi_bond`
  --
  
  CREATE TABLE IF NOT EXISTS `transaksi_bond` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_file_transaksi` int(11) DEFAULT NULL,
    `trade_date` date NOT NULL,
    `settlement_date` date NOT NULL,
    `customer` varchar(250) DEFAULT NULL,
    `buy_sell` varchar(50) NOT NULL,
    `security_id` varchar(50) DEFAULT NULL,
    `kupon` double DEFAULT NULL,
    `quantity` decimal(30,2) NOT NULL,
    `price` double DEFAULT NULL,
    `principal` decimal(30,2) DEFAULT NULL,
    `yield` double DEFAULT NULL,
    `accrued_interest` decimal(30,2) DEFAULT NULL,
    `total_cash` decimal(30,2) DEFAULT NULL,
    `dealer` varchar(50) DEFAULT NULL,
    `kurs_penutupan_trade_date` decimal(30,2) DEFAULT NULL,
    `volume` decimal(30,2) DEFAULT NULL,
    `pasar` varchar(50) DEFAULT NULL,
    `bank_nonbank` varchar(50) DEFAULT NULL,
    `last_update` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=181 ;
  
  --
  -- Dumping data for table `transaksi_bond`
  --
  
  INSERT INTO `transaksi_bond` (`id`, `id_file_transaksi`, `trade_date`, `settlement_date`, `customer`, `buy_sell`, `security_id`, `kupon`, `quantity`, `price`, `principal`, `yield`, `accrued_interest`, `total_cash`, `dealer`, `kurs_penutupan_trade_date`, `volume`, `pasar`, `bank_nonbank`, `last_update`) VALUES
  (1, NULL, '2017-01-17', '2017-01-19', 'JAMKRINDO', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.024199, 10241990000.00, 0.08, 148140000.00, 10390130000.00, 'WIW', 13351.50, 748979.52, 'PRIMER', 'NON BANK', NULL),
  (2, NULL, '2017-01-17', '2017-01-19', 'JAMKRINDO', 'SELL', 'FR0074', 0.075, 10000000000.00, 0.983721, 9837210000.00, 0.0768, 319970000.00, 10157180000.00, 'TIARA', 13351.50, 748979.52, 'PRIMER', 'NON BANK', NULL),
  (3, NULL, '2017-01-17', '2017-01-19', 'ASURANSI JIWASRAYA', 'SELL', 'FR0074', 0.075, 100000000000.00, 0.973186, 97318600000.00, 0.0779936, 3199700000.00, 100518300000.00, 'BAYU', 13351.50, 7489795.15, 'PRIMER', 'NON BANK', NULL),
  (4, NULL, '2017-01-17', '2017-01-19', 'DAPEN SULSELBAR', 'SELL', 'FR0074', 0.075, 3000000000.00, 0.97313, 2919390000.00, 0.078, 95991000.00, 3015381000.00, 'TIARA', 13351.50, 224693.85, 'PRIMER', 'NON BANK', NULL),
  (5, NULL, '2017-02-07', '2017-02-09', 'REINDO SYARIAH JIWA', 'SELL', 'PBS0012', 0.075, 5000000000.00, 1.044849, 5224245000.00, 0.08338525, 105420000.00, 5329665000.00, 'TIARA', 13328.50, 375135.99, 'PRIMER', 'NON BANK', NULL),
  (6, NULL, '2017-02-07', '2017-02-09', 'REINDO SYARIAH UMUM', 'SELL', 'PBS0012', 0.08875, 5000000000.00, 1.044849, 5224245000.00, 0.08338525, 105420000.00, 5329665000.00, 'TIARA', 13328.50, 375135.99, 'PRIMER', 'NON BANK', NULL),
  (7, NULL, '2017-02-14', '2017-02-17', 'JP MORGAN', 'SELL', 'FR0059', 0.07, 100000000000.00, 0.961096, 96109600000.00, 0.0755, 1817700000.00, 97927300000.00, 'DOEL', 13330.50, 7501594.09, 'PRIMER', 'BANK', NULL),
  (8, NULL, '2017-02-14', '2017-02-17', 'JP MORGAN', 'SELL', 'SPN03170515', 0, 200000000000.00, 0.988013, 197602600000.00, 0.0509, 0.00, 197602600000.00, 'DOEL', 13330.50, 15003188.18, 'PRIMER', 'BANK', NULL),
  (9, NULL, '2017-02-14', '2017-02-17', 'JAMKRINDO', 'SELL', 'FR0072', 0.0825, 15000000000.00, 1.014295, 15214425000.00, 0.081, 321345000.00, 15535770000.00, 'TIARA', 13330.50, 1125239.11, 'PRIMER', 'NON BANK', NULL),
  (10, NULL, '2017-02-14', '2017-02-17', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0059', 0.07, 10000000000.00, 0.961096, 9610960000.00, 0.0755, 181770000.00, 9792730000.00, 'DOEL', 13330.50, 750159.41, 'PRIMER', 'NON BANK', NULL),
  (11, NULL, '2017-02-21', '2017-02-23', 'ASURANSI BRINGIN LIFE', 'SELL', 'PBS0013', 0.0625, 5000000000.00, 0.982785, 4913925000.00, 0.0709377, 86325000.00, 5000250000.00, 'TIARA', 13372.50, 373901.66, 'PRIMER', 'NON BANK', NULL),
  (12, NULL, '2017-02-21', '2017-02-23', 'DAPEN MITRA KRAKATAU', 'SELL', 'PBS0011', 0.0875, 2000000000.00, 1.045313, 2090626000.00, 0.0784375, 3868000.00, 2094494000.00, 'TIARA', 13372.50, 149560.67, 'PRIMER', 'NON BANK', NULL),
  (13, NULL, '2017-02-21', '2017-02-23', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS0011', 0.0875, 38286000000.00, 1.042104, 39897993744.00, 0.0790625, 74045124.00, 39972038868.00, 'TIARA', 13372.50, 2863039.82, 'PRIMER', 'NON BANK', NULL),
  (14, NULL, '2017-02-21', '2017-02-23', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS0011', 0.0875, 21557000000.00, 1.043458, 22493824106.00, 0.0787985, 41691238.00, 22535515344.00, 'TIARA', 13372.50, 1612039.63, 'PRIMER', 'NON BANK', NULL),
  (15, NULL, '2017-02-21', '2017-02-23', 'BPD ACEH', 'SELL', 'SPNS08082017', 0, 10000000000.00, 0.976274, 9762740000.00, 0.053437, 0.00, 9762740000.00, 'RIDWAN', 13372.50, 747803.33, 'PRIMER', 'BANK', NULL),
  (16, NULL, '2017-02-28', '2017-03-02', 'JP MORGAN', 'SELL', 'FR0061', 0.07, 100000000000.00, 0.988745, 98874500000.00, 0.0726, 2069100000.00, 100943600000.00, 'DOEL', 13336.00, 7498500.30, 'PRIMER', 'BANK', NULL),
  (17, NULL, '2017-02-28', '2017-03-02', 'BPD DKI', 'SELL', 'FR0059', 0.07, 5631000000.00, 0.961192, 5412472152.00, 0.0755, 116511021.00, 5528983173.00, 'DOEL', 13336.00, 422240.55, 'PRIMER', 'BANK', NULL),
  (18, NULL, '2017-03-07', '2017-03-09', 'BPD ACEH', 'SELL', 'PBS011', 0.0875, 50000000000.00, 1.048257, 52412850000.00, 0.0778124, 265900000.00, 52678750000.00, 'RIDWAN', 13347.00, 3746160.19, 'PRIMER', 'BANK', NULL),
  (19, NULL, '2017-03-07', '2017-03-09', 'BPD ACEH', 'SELL', 'SPNS', 0, 47647000000.00, 0.972571, 46340090437.00, 0.05625, 0.00, 46340090437.00, 'RIDWAN', 13347.00, 3569865.89, 'PRIMER', 'BANK', NULL),
  (20, NULL, '2017-03-14', '2017-03-16', 'ASURANSI BRINS', 'SELL', 'FR0061', 0.07, 4433000000.00, 0.990123, 4389215259.00, 0.0722927, 103723334.00, 4492938593.00, 'TIARA', 13371.00, 331538.40, 'PRIMER', 'NON BANK', NULL),
  (21, NULL, '2017-03-14', '2017-03-16', 'JP MORGAN', 'SELL', 'FR0072', 0.0825, 70000000000.00, 1.022144, 71550080000.00, 0.08020003, 1930320000.00, 73480400000.00, 'TIARA', 13371.00, 5235210.53, 'PRIMER', 'BANK', NULL),
  (22, NULL, '2017-03-14', '2017-03-16', 'JP MORGAN', 'SELL', 'FR0072', 0.0825, 50000000000.00, 1.024121, 51206050000.00, 0.08000001, 1378800000.00, 52584850000.00, 'TIARA', 13371.00, 3739436.09, 'PRIMER', 'BANK', NULL),
  (23, NULL, '2017-03-14', '2017-03-16', 'JP MORGAN', 'SELL', 'FR0074', 0.075, 100000000000.00, 0.974134, 97413400000.00, 0.07790002, 600800000.00, 98014200000.00, 'TIARA', 13371.00, 7478872.19, 'PRIMER', 'BANK', NULL),
  (24, NULL, '2017-03-14', '2017-03-16', 'JP MORGAN', 'SELL', 'FR0061', 0.07, 33251000000.00, 0.990123, 32922579873.00, 0.0722927, 778006898.00, 33700586771.00, 'TIARA', 13371.00, 2486799.79, 'PRIMER', 'BANK', NULL),
  (25, NULL, '2017-03-14', '2017-03-16', 'BPD SUMSELBABEL', 'SELL', 'FR0074', 0.075, 7337000000.00, 0.973262, 7140823294.00, 0.07800001, 44080696.00, 7184903990.00, 'TIARA', 13371.00, 548724.85, 'PRIMER', 'BANK', NULL),
  (26, NULL, '2017-03-21', '2017-03-23', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS012', 0.08875, 94426000000.00, 1.070992, 101129490592.00, 0.08039394, 2963182306.00, 104092672898.00, 'DOEL', 13319.00, 7089571.29, 'PRIMER', 'NON BANK', NULL),
  (27, NULL, '2017-03-21', '2017-03-23', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS012', 0.08875, 50000000000.00, 1.071721, 53586050000.00, 0.08031247, 1569050000.00, 55155100000.00, 'DOEL', 13319.00, 3754035.59, 'PRIMER', 'NON BANK', NULL),
  (28, NULL, '2017-03-21', '2017-03-23', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS012', 0.08875, 50000000000.00, 1.068928, 53446400000.00, 0.08062503, 1569050000.00, 55015450000.00, 'DOEL', 13319.00, 3754035.59, 'PRIMER', 'NON BANK', NULL),
  (29, NULL, '2017-03-21', '2017-03-23', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS012', 0.08875, 50000000000.00, 1.066146, 53307300000.00, 0.08093751, 1569050000.00, 54876350000.00, 'DOEL', 13319.00, 3754035.59, 'PRIMER', 'NON BANK', NULL),
  (30, NULL, '2017-03-21', '2017-03-23', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS011', 0.0875, 60847000000.00, 1.057637, 64354038539.00, 0.07593746, 529490594.00, 64883529133.00, 'DOEL', 13319.00, 4568436.07, 'PRIMER', 'NON BANK', NULL),
  (31, NULL, '2017-03-21', '2017-03-23', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS011', 0.0875, 52000000000.00, 1.060434, 55142568000.00, 0.07539794, 452504000.00, 55595072000.00, 'DOEL', 13319.00, 3904197.01, 'PRIMER', 'NON BANK', NULL),
  (32, NULL, '2017-03-21', '2017-03-23', 'DAPEN MITRA KRAKATAU', 'SELL', 'PBS011', 0.0875, 2000000000.00, 1.059256, 2118512000.00, 0.075625, 17404000.00, 2135916000.00, 'TIARA', 13319.00, 150161.42, 'PRIMER', 'NON BANK', NULL),
  (33, NULL, '2017-03-21', '2017-03-23', 'BRINGIN LIFE', 'SELL', 'PBS012', 0.08875, 5000000000.00, 1.077337, 5386685000.00, 0.0796875, 156905000.00, 5543590000.00, 'TIARA', 13319.00, 375403.56, 'PRIMER', 'NON BANK', NULL),
  (34, NULL, '2024-03-17', '2031-03-17', 'BPD KALSEL', 'SELL', 'SDBI 6 BLN', 0, 25000000000.00, 1, 25000000000.00, 0.0586, 0.00, 25000000000.00, 'RIDWAN', 13326.50, 1875961.43, 'PRIMER', 'BANK', NULL),
  (35, NULL, '2017-03-27', '2017-03-30', 'BPJS KETENAGAKERJAAN', 'SELL', 'FR0074', 0.075, 219594000000.00, 0.999009, 219376382346.00, 0.0750959, 1956362946.00, 221332745292.00, 'RIDWAN', 13309.50, 16499042.04, 'PRIMER', 'NON BANK', NULL),
  (36, NULL, '2017-03-27', '2017-03-30', 'BPJS KETENAGAKERJAAN', 'SELL', 'FR0074', 0.075, 200000000000.00, 0.998972, 199794400000.00, 0.0751, 1781800000.00, 201576200000.00, 'RIDWAN', 13309.50, 15026860.51, 'PRIMER', 'NON BANK', NULL),
  (37, NULL, '2017-03-27', '2017-03-30', 'BPJS KETENAGAKERJAAN', 'SELL', 'FR0074', 0.075, 200000000000.00, 0.997169, 199433800000.00, 0.0753, 1781800000.00, 201215600000.00, 'RIDWAN', 13309.50, 15026860.51, 'PRIMER', 'NON BANK', NULL),
  (38, NULL, '2017-03-27', '2017-03-30', 'BPJS KETENAGAKERJAAN', 'SELL', 'FR0074', 0.075, 8154000000.00, 0.996269, 8123577426.00, 0.0754, 72643986.00, 8196221412.00, 'RIDWAN', 13309.50, 612645.10, 'PRIMER', 'NON BANK', NULL),
  (39, NULL, '2017-03-27', '2017-03-30', 'ASURANSI JIWASRAYA', 'SELL', 'FR0074', 0.075, 100000000000.00, 0.999875, 99987500000.00, 0.075, 890900000.00, 100878400000.00, 'TIARA', 13309.50, 7513430.26, 'PRIMER', 'NON BANK', NULL),
  (40, NULL, '2017-03-27', '2017-03-30', 'ASURANSI JIWASRAYA', 'SELL', 'FR0074', 0.075, 43919000000.00, 0.999009, 43875476271.00, 0.0750959, 391274371.00, 44266750642.00, 'TIARA', 13309.50, 3299823.43, 'PRIMER', 'NON BANK', NULL),
  (41, NULL, '2017-03-27', '2017-03-30', 'ASURANSI JIWASRAYA', 'SELL', 'FR0059', 0.07, 44118000000.00, 0.99374, 43841821320.00, 0.0708604, 1151700390.00, 44993521710.00, 'TIARA', 13309.50, 3314775.16, 'PRIMER', 'NON BANK', NULL),
  (42, NULL, '2017-03-27', '2017-03-30', 'DAPEN BPD MALUKU', 'SELL', 'FR0074', 0.075, 5000000000.00, 0.999875, 4999375000.00, 0.075, 44545000.00, 5043920000.00, 'TIARA', 13309.50, 375671.51, 'PRIMER', 'NON BANK', NULL),
  (43, NULL, '2017-03-27', '2017-03-30', 'BPD DKI', 'SELL', 'FR0059', 0.07, 6753000000.00, 0.992748, 6704027244.00, 0.071, 176287065.00, 6880314309.00, 'DOEL', 13309.50, 507381.95, 'PRIMER', 'BANK', NULL),
  (44, NULL, '2017-03-27', '2017-03-30', 'BPD DKI', 'SELL', 'FR0059', 0.07, 10000000000.00, 0.993459, 9934590000.00, 0.0709, 261050000.00, 10195640000.00, 'DOEL', 13309.50, 751343.03, 'PRIMER', 'BANK', NULL),
  (45, NULL, '2017-03-27', '2017-03-30', 'BPD KALTIM', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.047252, 10472520000.00, 0.0777, 307670000.00, 10780190000.00, 'RIDWAN', 13309.50, 751343.03, 'PRIMER', 'BANK', NULL),
  (46, NULL, '2017-04-04', '2017-04-06', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS012', 0.08875, 46628000000.00, 1.079915, 50354276620.00, 0.0793932, 1623307192.00, 51977583812.00, 'TIARA', 13328.00, 3498499.40, 'PRIMER', 'NON BANK', NULL),
  (47, NULL, '2017-04-04', '2017-04-06', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS012', 0.08875, 100000000000.00, 1.080079, 108007900000.00, 0.079375, 3481400000.00, 111489300000.00, 'TIARA', 13328.00, 7503001.20, 'PRIMER', 'NON BANK', NULL),
  (48, NULL, '2017-04-04', '2017-04-06', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS012', 0.08875, 6976000000.00, 1.07726, 7514965760.00, 0.0796875, 242862464.00, 7757828224.00, 'TIARA', 13328.00, 523409.36, 'PRIMER', 'NON BANK', NULL),
  (49, NULL, '2017-04-04', '2017-04-06', 'JAMKRINDO', 'SELL', 'PBS012', 0.08875, 3997000000.00, 1.079915, 4316420255.00, 0.0793932, 139151558.00, 4455571813.00, 'TIARA', 13328.00, 299894.96, 'PRIMER', 'NON BANK', NULL),
  (50, NULL, '2017-04-11', '2017-04-13', 'BPJS KETENAGAKERJAAN', 'SELL', 'FR0074', 0.075, 82317000000.00, 1.002581, 82529460177.00, 0.0746982, 972081453.00, 83501541630.00, 'TIARA', 13281.50, 6197869.22, 'PRIMER', 'NON BANK', NULL),
  (51, NULL, '2017-04-11', '2017-04-13', 'JAMKRINDO', 'SELL', 'FR0074', 0.075, 8459000000.00, 1.000755, 8465386545.00, 0.0749, 99892331.00, 8565278876.00, 'TIARA', 13281.50, 636900.95, 'PRIMER', 'NON BANK', NULL),
  (52, NULL, '2017-04-11', '2017-04-13', 'ASURANSI BRINS', 'SELL', 'FR0061', 0.07, 4558000000.00, 1.007774, 4593433892.00, 0.0681462, 131325096.00, 4724758988.00, 'TIARA', 13281.50, 343184.13, 'PRIMER', 'NON BANK', NULL),
  (53, NULL, '2017-04-11', '2017-04-13', 'BANK OF AMERICA (SG)', 'SELL', 'SPN03170712', 0, 100000000000.00, 0.987942, 98794200000.00, 0.0495, 0.00, 98794200000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (54, NULL, '2017-04-11', '2017-04-13', 'BANK OF AMERICA (SG)', 'SELL', 'SPN03170712', 0, 100000000000.00, 0.988182, 98818200000.00, 0.0485, 0.00, 98818200000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (55, NULL, '2017-04-18', '2017-04-20', 'BPJS KETENAGAKERJAAN', 'SELL', 'PBS012', 0.08875, 26000000000.00, 1.078894, 28051244000.00, 0.0794986, 994396000.00, 29045640000.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (56, NULL, '2017-04-18', '2017-04-20', 'DAPEN MITRA KRAKATAU', 'SELL', 'PBS011', 0.0875, 2000000000.00, 1.068321, 2136642000.00, 0.07375, 30940000.00, 2167582000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (57, NULL, '2017-04-18', '2017-04-20', 'BPD ACEH', 'SELL', 'PBS011', 0.0875, 50000000000.00, 1.071573, 53578650000.00, 0.073125, 773500000.00, 54352150000.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (58, NULL, '2017-04-18', '2017-04-20', 'BPD ACEH', 'SELL', 'PBS013', 0.0625, 50000000000.00, 0.987483, 49374150000.00, 0.0690624, 1346700000.00, 50720850000.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (59, NULL, '2017-04-25', '2017-04-27', 'BPD DKI', 'SELL', 'FR0059', 0.07, 26224000000.00, 0.996106, 26121883744.00, 0.07054, 826554256.00, 26948438000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (60, NULL, '2017-04-25', '2017-04-27', 'BPD DKI', 'SELL', 'FR0061', 0.07, 4459000000.00, 1.012684, 4515557956.00, 0.066986, 140543221.00, 4656101177.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (61, NULL, '2017-04-25', '2017-04-27', 'BANK BTN', 'SELL', 'FR0072', 0.0825, 31293000000.00, 1.047245, 32771437785.00, 0.0777, 1162472364.00, 33933910149.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (62, NULL, '2017-04-25', '2017-04-27', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0072', 0.0825, 6258000000.00, 1.047245, 6553659210.00, 0.0777, 232472184.00, 6786131394.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (63, NULL, '2017-04-25', '2017-04-27', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.050313, 10503130000.00, 0.0774, 371480000.00, 10874610000.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (64, NULL, '2017-04-25', '2017-04-27', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.049289, 10492890000.00, 0.0775, 371480000.00, 10864370000.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (65, NULL, '2017-04-25', '2017-04-27', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.050313, 10503130000.00, 0.0774, 371480000.00, 10874610000.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (66, NULL, '2017-05-02', '2017-05-04', 'BANK BTN', 'SELL', 'SPNS03112017', 0, 49667000000.00, 0.973016, 48326785672.00, 0.0553125, 0.00, 48326785672.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (67, NULL, '2017-05-02', '2017-05-04', 'BPD ACEH', 'SELL', 'PBS012', 0.08875, 25000000000.00, 1.079947, 26998675000.00, 0.079375, 1041950000.00, 28040625000.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (68, NULL, '2017-05-02', '2017-05-04', 'BPD ACEH', 'SELL', 'PBS012', 0.08875, 25000000000.00, 1.082768, 27069200000.00, 0.0790625, 1041950000.00, 28111150000.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (69, NULL, '2017-05-02', '2017-05-04', 'BRINGIN LIFE', 'SELL', 'PBS012', 0.08875, 5000000000.00, 1.079947, 5399735000.00, 0.079375, 208390000.00, 5608125000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (70, NULL, '2017-05-02', '2017-05-04', 'DAPEN MITRA KRAKATAU', 'SELL', 'PBS012', 0.08875, 2000000000.00, 1.079947, 2159894000.00, 0.079375, 83356000.00, 2243250000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (71, NULL, '2017-05-02', '2017-05-04', 'JAMKRINDO', 'SELL', 'PBS012', 0.08875, 8673000000.00, 1.07883, 9356692590.00, 0.0794991, 361473294.00, 9718165884.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (72, NULL, '2017-05-09', '2017-05-12', 'JAMKRINDO', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.045222, 10452220000.00, 0.0779, 405660000.00, 10857880000.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (73, NULL, '2017-05-09', '2017-05-12', 'BANK BTN', 'SELL', 'FR0061', 0.07, 50000000000.00, 1.01173, 50586500000.00, 0.0672, 1721000000.00, 52307500000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (74, NULL, '2017-05-09', '2017-05-12', 'BANK BTN', 'SELL', 'FR0072', 0.0825, 7304000000.00, 1.04016, 7597328640.00, 0.0784, 296294064.00, 7893622704.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (75, NULL, '2017-05-16', '2017-05-18', 'JP MORGAN', 'SELL', 'PBS011', 0.0875, 50000000000.00, 1.069249, 53462450000.00, 0.073438, 1111900000.00, 54574350000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (76, NULL, '2017-05-16', '2017-05-18', 'JP MORGAN', 'SELL', 'PBS012', 0.08875, 50000000000.00, 1.074267, 53713350000.00, 0.08, 36150000.00, 53749500000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (77, NULL, '2017-05-16', '2017-05-18', 'BPD ACEH', 'SELL', 'SPNS03112017', 0, 500000000000.00, 0.975442, 487721000000.00, 0.054375, NULL, 487721000000.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (78, NULL, '2017-05-16', '2017-05-18', 'BPD ACEH', 'SELL', 'PBS012', 0.08875, 50000000000.00, 1.085511, 54275550000.00, 0.07875, 36150000.00, 54311700000.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (79, NULL, '2017-05-23', '2017-05-26', 'BPJS KETENAGAKERJAAN', 'SELL', 'FR0072', 0.0825, 100000000000.00, 1.073103, 107310300000.00, 0.0752, 246600000.00, 107556900000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (80, NULL, '2017-05-23', '2017-05-26', 'BPJS KETENAGAKERJAAN', 'SELL', 'FR0072', 0.0825, 100000000000.00, 1.070995, 107099500000.00, 0.0754, 246600000.00, 107346100000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (81, NULL, '2017-05-23', '2017-05-26', 'JP MORGAN', 'SELL', 'FR0059', 0.07, 150000000000.00, 1.00566, 150849000000.00, 0.0692, 313800000.00, 151162800000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (82, NULL, '2017-05-23', '2017-05-26', 'JP MORGAN', 'SELL', 'FR0059', 0.07, 37725000000.00, 1.005578, 37935430050.00, 0.069212, 78920700.00, 38014350750.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (83, NULL, '2017-05-23', '2017-05-26', 'JP MORGAN', 'SELL', 'FR0074', 0.075, 50000000000.00, 1.01344, 50672000000.00, 0.0735, 1035900000.00, 51707900000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (84, NULL, '2017-05-23', '2017-05-26', 'BANK BTN', 'SELL', 'FR0059', 0.07, 18862000000.00, 1.005578, 18967212236.00, 0.069212, 39459304.00, 19006671540.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (85, NULL, '2017-05-30', '2017-06-02', 'BANK MUAMALAT', 'SELL', 'PBS014', 0.065, 10000000000.00, 0.978752, 9787520000.00, 0.07125, 31790000.00, 9819310000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (86, NULL, '2017-05-30', '2017-06-02', 'BPD ACEH', 'SELL', 'PBS011', 0.0875, 50000000000.00, 1.07855, 53927500000.00, 1.07125, 31790001.00, 53959290001.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (87, NULL, '2017-05-30', '2017-06-02', 'BPD ACEH', 'SELL', 'PBS012', 0.08875, 50000000000.00, 1.111185, 55559250000.00, 2.07125, 31790002.00, 55591040002.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (88, NULL, '2017-05-30', '2017-06-02', 'BPD ACEH', 'SELL', 'SBSN311217', 0, 500000000000.00, 0.974342, 487171000000.00, 3.07125, 31790003.00, 487202790003.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (89, NULL, '2017-06-06', '2017-06-08', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0059', 0.07, 11112000000.00, 1.004188, 11158537056.00, 0.0694, 50771930.00, 11209308986.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (90, NULL, '2017-06-06', '2017-06-08', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0074', 0.075, 3034000000.00, 1.008871, 3060914614.00, 0.074, 71032008.00, 3131946622.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (91, NULL, '2017-06-06', '2017-06-08', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0074', 0.075, 20000000000.00, 1.009781, 20195620000.00, 0.0739, 468240000.00, 20663860000.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (92, NULL, '2017-06-06', '2017-06-08', 'JP MORGAN', 'SELL', 'FR0074', 0.075, 9103000000.00, 1.008871, 9183752713.00, 0.074, 213119436.00, 9396872149.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (93, NULL, '2017-06-06', '2017-06-08', 'JP MORGAN', 'SELL', 'FR0074', 0.075, 56170000000.00, 1.01008, 56736193600.00, 0.073867, 1315052040.00, 58051245640.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (94, NULL, '2017-06-06', '2017-06-08', 'BANK BTN', 'SELL', 'FR0061', 0.07, 32353000000.00, 1.013627, 32793874331.00, 0.066698, 147691445.00, 32941565776.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (95, NULL, '2017-06-13', '2017-06-15', 'ASURANSI BRINGIN LIFE', 'SELL', 'PBS011', 0.0875, 5000000000.00, 1.07338, 5366900000.00, 0.0725, 145030000.00, 5511930000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (96, NULL, '2017-06-13', '2017-06-15', 'ASURANSI BRINGIN LIFE', 'SELL', 'PBS011', 0.0875, 5000000000.00, 1.074984, 5374920000.00, 0.0721875, 145030000.00, 5519950000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (97, NULL, '2017-06-13', '2017-06-15', 'BANK MUAMALAT', 'SELL', 'PBS011', 0.0875, 10000000000.00, 1.070182, 10701820000.00, 0.073125, 290060000.00, 10991880000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (98, NULL, '2017-06-13', '2017-06-15', 'BANK MUAMALAT', 'SELL', 'PBS011', 0.0875, 9500000000.00, 1.068587, 10151576500.00, 0.073438, 275557000.00, 10427133500.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (99, NULL, '2017-06-13', '2017-06-15', 'BPD ACEH', 'SELL', 'PBS011', 0.0875, 50000000000.00, 1.07659, 53829500000.00, 0.071875, 1450300000.00, 55279800000.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (100, NULL, '2017-06-13', '2017-06-15', 'BPD ACEH', 'SELL', 'SPNS', 0, 500000000000.00, 0.975717, 487858500000.00, 0.05375, 0.00, 487858500000.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (101, NULL, '2020-06-17', '2022-06-17', 'BNP PARIBAS', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.072891, 10728910000.00, 0.0752, 85190000.00, 10814100000.00, 'EKO', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (102, NULL, '2020-06-17', '2022-06-17', 'JP MORGAN', 'SELL', 'FR0061', 0.07, 100000000000.00, 1.015165, 101516500000.00, 0.0663, 722800000.00, 102239300000.00, 'EKO', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (103, NULL, '2020-06-17', '2022-06-17', 'JP MORGAN', 'SELL', 'FR0074', 0.075, 100000000000.00, 1.016174, 101617400000.00, 0.0732, 2631200000.00, 104248600000.00, 'EKO', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (104, NULL, '2020-06-17', '2022-06-17', 'JP MORGAN', 'SELL', 'FR0072', 0.0825, 47392000000.00, 1.070787, 50746737504.00, 0.0754, 403732448.00, 51150469952.00, 'EKO', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (105, NULL, '2020-06-17', '2022-06-17', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0074', 0.075, 10000000000.00, 1.014342, 10143420000.00, 0.0734, 263120000.00, 10406540000.00, 'EKO', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (106, NULL, '2017-07-04', '2017-07-06', 'BANK MUAMALAT', 'SELL', 'PBS013', 0.0625, 10000000000.00, 0.98916, 9891600000.00, 0.06875, 88320000.00, 9979920000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (107, NULL, '2017-07-04', '2017-07-06', 'BANK MUAMALAT', 'SELL', 'PBS013', 0.0625, 10000000000.00, 0.990227, 9902270000.00, 0.068125, 88320000.00, 9990590000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (108, NULL, '2017-07-04', '2017-07-06', 'BANK MUAMALAT', 'SELL', 'PBS013', 0.0625, 7000000000.00, 0.988627, 6920389000.00, 0.0690625, 61824000.00, 6982213000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (109, NULL, '2017-07-04', '2017-07-06', 'BANK MUAMALAT', 'SELL', 'PBS013', 0.0625, 7000000000.00, 0.988627, 6920389000.00, 0.0690625, 61824000.00, 6982213000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (110, NULL, '2017-07-11', '2017-07-13', 'BANK BTN', 'SELL', 'FR0059', 0.07, 55516000000.00, 0.990097, 54966225052.00, 0.071399, 623056068.00, 55589281120.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (111, NULL, '2017-07-11', '2017-07-13', 'BANK BTN', 'SELL', 'FR0061', 0.07, 29602000000.00, 1.000274, 29610110948.00, 0.0699, 332223246.00, 29942334194.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (112, NULL, '2017-07-11', '2017-07-13', 'BPD SUMSELBABEL', 'SELL', 'FR0059', 0.07, 4213000000.00, 0.989397, 4168329561.00, 0.0715, 47282499.00, 4215612060.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (113, NULL, '2017-07-11', '2017-07-13', 'BRI AGRO', 'SELL', 'FR0059', 0.07, 4213000000.00, 0.989397, 4168329561.00, 0.0715, 47282499.00, 4215612060.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (114, NULL, '2017-07-11', '2017-07-13', 'BRI AGRO', 'SELL', 'FR0059', 0.07, 10000000000.00, 0.993569, 9935690000.00, 0.0709, 112230000.00, 10047920000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (115, NULL, '2017-07-11', '2017-07-13', 'BRI AGRO', 'SELL', 'FR0059', 0.07, 10000000000.00, 0.99148, 9914800000.00, 0.0712, 112230000.00, 10027030000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (116, NULL, '2017-07-11', '2017-07-13', 'BRI AGRO', 'SELL', 'FR0061', 0.07, 10000000000.00, 1.001084, 10010840000.00, 0.0697, 112230000.00, 10123070000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (117, NULL, '2017-07-11', '2017-07-13', 'BRI AGRO', 'SELL', 'FR0061', 0.07, 5920000000.00, 1.000274, 5921622080.00, 0.0699, 66440160.00, 5988062240.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (118, NULL, '2017-07-11', '2017-07-13', 'JAMKRINDO', 'SELL', 'FR0072', 0.0825, 50000000000.00, 1.022963, 51148150000.00, 0.0801, 661350000.00, 51809500000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (119, NULL, '2017-07-18', '2017-07-20', 'JAMKRINDO', 'SELL', 'PBS005', 0.0675, 300000000000.00, 0.849094, 254728200000.00, 0.0816, 5311500000.00, 260039700000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (120, NULL, '2017-07-18', '2017-07-20', 'BPD ACEH', 'SELL', 'SPNS05012018', 0, 292307000000.00, 0.975167, 285048140269.00, 0.055, 0.00, 285048140269.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (121, NULL, '2017-07-18', '2017-07-20', 'BPD ACEH', 'SELL', 'PBS013', 0.0625, 50000000000.00, 0.989875, 49493750000.00, 0.0684375, 560450000.00, 50054200000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (122, NULL, '2017-07-18', '2017-07-20', 'JP MORGAN', 'SELL', 'PBS014', 0.065, 49348000000.00, 0.975224, 48125353952.00, 0.0725, 575298984.00, 48700652936.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (123, NULL, '2017-07-18', '2017-07-20', 'BANK MUAMALAT', 'SELL', 'PBS011', 0.0875, 10000000000.00, 7.069381, 70693810000.00, 0.073125, 374650000.00, 71068460000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (124, NULL, '2017-07-18', '2017-07-20', 'BANK MUAMALAT', 'SELL', 'PBS012', 0.08875, 10000000000.00, 1.081968, 10819680000.00, 0.0790625, 159170000.00, 10978850000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (125, NULL, '2017-07-18', '2017-07-20', 'BANK MUAMALAT', 'SELL', 'PBS012', 0.08875, 16118000000.00, 1.079171, 17394078178.00, 0.079375, 256550206.00, 17650628384.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (126, NULL, '2017-07-18', '2017-07-20', 'BANK MUAMALAT', 'SELL', 'PBS013', 0.0625, 18991000000.00, 0.989352, 18788783832.00, 0.06875, 212870119.00, 19001653951.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (127, NULL, '2017-07-18', '2017-07-20', 'BANK MUAMALAT', 'SELL', 'PBS014', 0.065, 10000000000.00, 0.980299, 9802990000.00, 0.0709375, 116580000.00, 9919570000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (128, NULL, '2017-07-18', '2017-07-20', 'BANK MUAMALAT', 'SELL', 'PBS014', 0.065, 10000000000.00, 0.979282, 9792820000.00, 0.07125, 116580000.00, 9909400000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (129, NULL, '2017-07-18', '2017-07-20', 'BANK MUAMALAT', 'SELL', 'PBS014', 0.065, 20000000000.00, 0.978265, 19565300000.00, 0.0715625, 233160000.00, 19798460000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (130, NULL, '2017-07-25', '2017-07-27', 'BANK BTN', 'SELL', 'FR0059', 0.07, 100000000000.00, 1.004073, 100407300000.00, 0.0694, 1388600000.00, 101795900000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (131, NULL, '2017-07-25', '2017-07-27', 'BANK BTN', 'SELL', 'FR0074', 0.075, 33783000000.00, 1.015304, 34300015032.00, 0.073297, 1133892612.00, 35433907644.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (132, NULL, '2017-07-25', '2017-07-27', 'BANK BTN', 'SELL', 'SPN03171026', 0, 100000000000.00, 0.987493, 98749300000.00, 0.0508, 1133892612.00, 99883192612.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (133, NULL, '2017-07-25', '2017-07-27', 'BANK MEGA', 'SELL', 'FR0061', 0.07, 200000000000.00, 1.010785, 202157000000.00, 0.0673, 2777200000.00, 204934200000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (134, NULL, '2017-07-25', '2017-07-27', 'BNP PARIBAS', 'SELL', 'FR0061', 0.07, 5328000000.00, 1.009157, 5376788496.00, 0.0677, 73984608.00, 5450773104.00, 'EKO', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (135, NULL, '2017-07-25', '2017-07-27', 'BNP PARIBAS', 'SELL', 'FR0074', 0.075, 10000000000.00, 1.015281, 10152810000.00, 0.0733, 335640000.00, 10488450000.00, 'EKO', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (136, NULL, '2017-08-01', '2017-08-03', 'BANK MUAMALAT', 'SELL', 'PBS011', 0.0875, 7619000000.00, 1.069076, 8145290044.00, 0.073125, 311228531.00, 8456518575.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (137, NULL, '2017-08-01', '2017-08-03', 'BANK MUAMALAT', 'SELL', 'PBS014', 0.065, 10000000000.00, 0.978444, 9784440000.00, 0.0715625, 141300000.00, 9925740000.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (138, NULL, '2017-08-01', '2017-08-03', 'BANK MUAMALAT', 'SELL', 'PBS014', 0.065, 8118000000.00, 0.977438, 7934841684.00, 0.071875, 114707340.00, 8049549024.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (139, NULL, '2017-08-01', '2017-08-03', 'BANK MUAMALAT', 'SELL', 'PBS012', 0.08875, 10000000000.00, 1.084638, 10846380000.00, 0.07875, 192930000.00, 11039310000.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (140, NULL, '2017-08-01', '2017-08-03', 'BANK MUAMALAT', 'SELL', 'PBS012', 0.08875, 805000000.00, 1.081835, 870877175.00, 0.0790625, 15530865.00, 886408040.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (141, NULL, '2017-08-01', '2017-08-03', 'BPD ACEH', 'SELL', 'SPNS02022018', 0, 250000000000.00, 0.973313, 243328250000.00, 0.0546875, 0.00, 243328250000.00, 'RIDWAN', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (142, NULL, '2017-08-08', '2017-08-10', 'BPD NAGARI', 'SELL', 'SPN12180809', 0, 50000000000.00, 0.944431, 47221550000.00, 0.059, NULL, 47221550000.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (143, NULL, '2017-08-08', '2017-08-10', 'BANK MEGA', 'SELL', 'FR0061', 0.07, 143918000000.00, 1.013543, 145867081474.00, 0.0666, 2381698982.00, 148248780456.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (144, NULL, '2017-08-08', '2017-08-10', 'JP MORGAN', 'SELL', 'FR0074', 0.075, 97974000000.00, 1.014394, 99384237756.00, 0.0734, 3572523936.00, 102956761692.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (145, NULL, '2017-08-08', '2017-08-10', 'BANK BTN', 'SELL', 'FR0075', 0.075, 56338000000.00, 0.984355, 55456591990.00, 0.07649874, 998929078.00, 56455521068.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (146, NULL, '2017-08-08', '2017-08-10', 'JP MORGAN', 'SELL', 'FR0075', 0.075, 56338000000.00, 0.984355, 55456591990.00, 0.07649874, 998929078.00, 56455521068.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (147, NULL, '2017-08-08', '2017-08-10', 'JP MORGAN', 'SELL', 'FR0075', 0.075, 77365000000.00, 0.982304, 75995948960.00, 0.0767, 1371758815.00, 77367707775.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (148, NULL, '2017-08-08', '2017-08-10', 'BANK BTN', 'SELL', 'FR0061', 0.07, 33444000000.00, 1.013736, 33903386784.00, 0.06655248, 553464756.00, 34456851540.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (149, NULL, '2017-08-08', '2017-08-10', 'BANK MEGA', 'SELL', 'FR0061', 0.07, 100000000000.00, 1.013949, 101394900000.00, 0.06650005, 1654900000.00, 103049800000.00, 'TIARA', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (150, NULL, '2017-08-08', '2017-08-10', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0075', 0.075, 20000000000.00, 1.008, 20160000000.00, NULL, NULL, 20160000000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (151, NULL, '2017-08-15', '2017-08-18', 'BANK MUAMALAT', 'SELL', 'PBS012', 0.08875, 20000000000.00, 1.08731, 21746200000.00, 0.0784375, 458220000.00, 22204420000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (152, NULL, '2017-08-15', '2017-08-18', 'BANK MUAMALAT', 'SELL', 'PBS012', 0.08875, 1753000000.00, 1.084502, 1901132006.00, 0.07875, 40162983.00, 1941294989.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (153, NULL, '2017-08-15', '2017-08-18', 'DAPEN MITRA KRAKATAU', 'SELL', 'PBS011', 0.0875, 2000000000.00, 1.074986, 2149972000.00, 0.071875, 1426000.00, 2151398000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (154, NULL, '2017-08-15', '2017-08-18', 'BATAVIA DANA OBLIGASI UNGGULAN', 'SELL', 'PBS011', 0.0875, 5000000000.00, 1.074986, 5374930000.00, 0.071875, 3565000.00, 5378495000.00, 'TIARA', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (155, NULL, '2017-08-22', '2017-08-24', 'BANK BTN', 'SELL', 'FR0075', 0.075, 27530000000.00, 1.014495, 27929047350.00, 0.07361, 566677520.00, 28495724870.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (156, NULL, '2017-08-22', '2017-08-24', 'BANK BTN', 'SELL', 'FR0074', 0.075, 12360000000.00, 1.018923, 12593888280.00, 0.072899, 22668240.00, 12616556520.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (157, NULL, '2017-08-22', '2017-08-24', 'BPD SUMUT', 'SELL', 'SPN 178', 0, 8824000000.00, 0.987566, 8714282384.00, 0.0505, NULL, 8714282384.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (158, NULL, '2017-08-22', '2017-08-24', 'BPD SUMUT', 'SELL', 'SPN 178', 0, 50000000000.00, 0.987639, 49381950000.00, 0.0502, NULL, 49381950000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (159, NULL, '2017-08-22', '2017-08-24', 'BANK NEGARA MALAYSIA', 'SELL', 'SPN 178', 0, 200000000000.00, 0.987688, 197537600000.00, 0.05, NULL, 197537600000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (160, NULL, '2017-08-22', '2017-08-24', 'JP MORGAN', 'SELL', 'FR0074', 0.075, 35813000000.00, 1.018004, 36457777252.00, 0.073, 65681042.00, 36523458294.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (161, NULL, '2017-08-22', '2017-08-24', 'JP MORGAN', 'SELL', 'FR0074', 0.075, 24720000000.00, 1.018923, 25187776560.00, 0.072899, 45336480.00, 25233113040.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (162, NULL, '2017-08-22', '2017-08-24', 'BNP PARIBAS', 'SELL', 'FR0075', 0.075, 48424000000.00, 1.013535, 49079418840.00, 0.0737, 996759616.00, 50076178456.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (163, NULL, '2017-08-22', '2017-08-24', 'BOA SING', 'SELL', 'FR0075', 0.075, 27532000000.00, 1.014495, 27931076340.00, 0.07361, 556718688.00, 28487795028.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (164, NULL, '2017-08-22', '2017-08-24', 'BOA SING', 'SELL', 'FR0075', 0.075, 80000000000.00, 1.015669, 81253520000.00, 0.0735, 1646720000.00, 82900240000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (165, NULL, '2017-08-29', '2017-08-31', 'BANK MUAMALAT', 'SELL', 'PBS013', 0.0625, 20000000000.00, 0.996875, 19937500000.00, 0.064375, 366840000.00, 20304340000.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (166, NULL, '2017-08-29', '2017-08-31', 'BANK MUAMALAT', 'SELL', 'PBS013', 0.0625, 1311000000.00, 0.996398, 1306277778.00, 0.0646875, 24046362.00, 1330324140.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (167, NULL, '2017-09-05', '2017-09-07', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0074', 0.075, 1512000000.00, 1.039206, 1571279472.00, 0.0707, 7086744.00, 1578366216.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (168, NULL, '2017-09-05', '2017-09-07', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0061', 0.07, 5980000000.00, 1.03199, 6171300200.00, 0.062, 130812500.00, 6302112700.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (169, NULL, '2017-09-05', '2017-09-07', 'BUMI PUTRA SEKURITAS', 'SELL', 'FR0059', 0.07, 10000000000.00, 1.025288, 10252880000.00, 0.0664, 218750000.00, 10471630000.00, 'DOEL', NULL, NULL, 'PRIMER', 'NON BANK', NULL),
  (170, NULL, '2017-09-05', '2017-09-07', 'BANK BTN', 'SELL', 'FR0074', 0.075, 17791000000.00, 1.0411, 18522210100.00, 0.070498, 83386417.00, 18605596517.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (171, NULL, '2017-09-05', '2017-09-07', 'BANK BTN', 'SELL', 'FR0061', 0.07, 23054000000.00, 1.03271, 23808096340.00, 0.061824, 504306250.00, 24312402590.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (172, NULL, '2017-09-05', '2017-09-07', 'BANK BTN', 'SELL', 'FR0059', 0.07, 34491000000.00, 1.024904, 35349963864.00, 0.066454, 754490625.00, 36104454489.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (173, NULL, '2017-09-05', '2017-09-07', 'BNP PARIBAS', 'SELL', 'FR0059', 0.07, 98259000000.00, 1.024571, 100673321889.00, 0.0665, 2149415625.00, 102822737514.00, 'DOEL', NULL, NULL, 'PRIMER', 'BANK', NULL),
  (174, 3, '2017-01-17', '2017-01-19', 'JAMKRINDO', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.024199, 10241990000.00, 0.08, 148140000.00, 10390130000.00, 'WIW', 13351.50, 748979.52, 'PRIMER', 'NON BANK', NULL),
  (175, 4, '2017-01-17', '2017-01-19', 'JAMKRINDO', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.024199, 10241990000.00, 0.08, 148140000.00, 10390130000.00, 'WIW', 13351.50, 748979.52, 'PRIMER', 'NON BANK', NULL),
  (176, 5, '2017-01-17', '2017-01-19', 'JAMKRINDO', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.024199, 10241990000.00, 0.08, 148140000.00, 10390130000.00, 'WIW', 13351.50, 748979.52, 'PRIMER', 'NON BANK', NULL),
  (177, 3, '2017-01-17', '2017-01-19', 'JAMKRINDO', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.024199, 10241990000.00, 0.08, 148140000.00, 10390130000.00, 'WIW', 13351.50, 748979.52, 'PRIMER', 'NON BANK', NULL),
  (178, 4, '2017-01-17', '2017-01-19', 'JAMKRINDO', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.024199, 10241990000.00, 0.08, 148140000.00, 10390130000.00, 'WIW', 13351.50, 748979.52, 'PRIMER', 'NON BANK', NULL),
  (179, 5, '2017-01-17', '2017-01-19', 'JAMKRINDO', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.024199, 10241990000.00, 0.08, 148140000.00, 10390130000.00, 'WIW', 13351.50, 748979.52, 'PRIMER', 'NON BANK', NULL),
  (180, 6, '2017-01-17', '2017-01-19', 'JAMKRINDO', 'SELL', 'FR0072', 0.0825, 10000000000.00, 1.024199, 10241990000.00, 0.08, 148140000.00, 10390130000.00, 'WIW', 13351.50, 748979.52, 'PRIMER', 'NON BANK', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `transaksi_gmra`
  --
  
  CREATE TABLE IF NOT EXISTS `transaksi_gmra` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_file_transaksi` int(11) DEFAULT NULL,
    `trade_date` date NOT NULL,
    `settlement_date_1st_leg` date DEFAULT NULL,
    `settlement_date_2nd_leg` date DEFAULT NULL,
    `customer` varchar(250) DEFAULT NULL,
    `r_rr` varchar(5) NOT NULL,
    `tenor` int(11) DEFAULT NULL,
    `rate` double DEFAULT NULL,
    `quantity` decimal(30,2) NOT NULL,
    `price_1st_leg` double DEFAULT NULL,
    `amount_1st_leg` decimal(30,2) DEFAULT NULL,
    `amount_2nd_leg` decimal(30,2) DEFAULT NULL,
    `dealer` varchar(250) DEFAULT NULL,
    `last_update` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=116 ;
  
  --
  -- Dumping data for table `transaksi_gmra`
  --
  
  INSERT INTO `transaksi_gmra` (`id`, `id_file_transaksi`, `trade_date`, `settlement_date_1st_leg`, `settlement_date_2nd_leg`, `customer`, `r_rr`, `tenor`, `rate`, `quantity`, `price_1st_leg`, `amount_1st_leg`, `amount_2nd_leg`, `dealer`, `last_update`) VALUES
  (1, NULL, '2017-03-24', '2017-03-24', '2017-04-21', 'BPD SULTENG', 'R', 28, 0.057, 30000000000.00, 0.9056261, 27168783000.00, 27289231271.30, 'RIDWAN', NULL),
  (2, NULL, '2017-03-24', '2017-03-24', '2017-03-31', 'BANK MAYAPADA', 'R', 7, 0.048, 150000000000.00, 0.8962196, 134432940000.00, 134558410744.00, 'RIDWAN', NULL),
  (3, NULL, '2017-03-29', '2017-03-29', '2017-04-05', 'BPD SULTENG', 'R', 7, 0.0475, 35000000000.00, 0.943485, 33021975000.00, 33052474463.02, 'RIDWAN', NULL),
  (4, NULL, '2017-04-04', '2017-04-04', '2017-04-11', 'BPD SULSELBAR', 'R', 7, 0.0485, 100000000000.00, 0.8775036, 87750360000.00, 87833113464.50, 'RIDWAN', NULL),
  (5, NULL, '2017-04-04', '2017-04-04', '2017-04-18', 'BPD SULTENG', 'RR', 14, 0.05, 50000000000.00, 0.92278411, 46139205500.00, 46228920621.81, 'RIDWAN', NULL),
  (6, NULL, '2017-04-05', '2017-04-05', '2017-05-03', 'BPD KALTIM', 'R', 28, 0.057, 500000000000.00, 0.8585055, 429252750000.00, 431155770525.00, 'RIDWAN', NULL),
  (7, NULL, '2017-04-10', '2017-04-10', '2017-04-25', 'BPD SULSELBAR', 'R', 15, 0.049, 100000000000.00, 0.8551854, 85518540000.00, 85693140352.50, 'RIDWAN', NULL),
  (8, NULL, '2017-04-17', '2017-04-17', '2017-04-25', 'BPD KALSEL', 'R', 8, 0.048, 100000000000.00, 0.8597358, 85973580000.00, 86065285152.00, 'RIDWAN', NULL),
  (9, NULL, '2017-04-18', '2017-04-18', '2017-04-25', 'BPD JAMBI', 'RR', 7, 0.048, 10000000000.00, 0.9789553, 9789553000.00, 9798689916.13, 'RIDWAN', NULL),
  (10, NULL, '2017-05-03', '2017-05-03', '2017-05-17', 'BPD BALI', 'R', 14, 0.051, 200000000000.00, 0.8875593, 177511860000.00, 177863925189.00, 'RIDWAN', NULL),
  (11, NULL, '2017-05-03', '2017-05-03', '2017-06-02', 'BPD KALTIM', 'R', 30, 0.058, 115000000000.00, 0.8875593, 102069319500.00, 102562654544.25, 'RIDWAN', NULL),
  (12, NULL, '2017-05-05', '2017-05-05', '2017-05-10', 'BNP PARIBAS', 'RR', 5, 0.047, 50000000000.00, 0.908745705, 45437285250.00, 45466945700.09, 'DOEL', NULL),
  (13, NULL, '2017-05-05', '2017-05-05', '2017-05-10', 'BNP PARIBAS', 'RR', 5, 0.047, 50000000000.00, 0.898461072, 44923053600.00, 44952378371.10, 'DOEL', NULL),
  (14, NULL, '2017-05-09', '2017-05-12', '2017-05-15', 'BNP PARIBAS', 'RR', 3, 0.046, 150000000000.00, 0.934163181, 140124477150.00, 140178191532.91, 'DOEL', NULL),
  (15, NULL, '2017-05-09', '2017-05-12', '2017-05-26', 'BPD SULTENG', 'RR', 14, 0.052, 30000000000.00, 0.934163181, 28024895430.00, 28081567996.31, 'RIDWAN', NULL),
  (16, NULL, '2017-05-12', '2017-05-15', '2017-05-18', 'BNP PARIBAS', 'RR', 3, 0.046, 160000000000.00, 0.9333, 149328000000.00, 149385242400.00, 'DOEL', NULL),
  (17, NULL, '2017-05-15', '2017-05-15', '2017-05-22', 'BNP PARIBAS', 'RR', 7, 0.0485, 50000000000.00, 0.907836408, 45391820400.00, 45434627408.41, 'DOEL', NULL),
  (18, NULL, '2017-05-16', '2017-05-16', '2017-05-19', 'BNP PARIBAS', 'RR', 3, 0.047, 80000000000.00, 0.979559163, 78364733040.00, 78395425893.77, 'DOEL', NULL),
  (19, NULL, '2017-05-16', '2017-05-16', '2017-05-22', 'BNP PARIBAS', 'RR', 6, 0.049, 70000000000.00, 0.922502853, 64575199710.00, 64627936123.10, 'DOEL', NULL),
  (20, NULL, '2017-05-17', '2017-05-17', '2017-05-24', 'BPD JATIM', 'R', 7, 0.048, 100000000000.00, 0.899538, 89953800000.00, 90037756880.00, 'RIDWAN', NULL),
  (21, NULL, '2017-05-24', '2017-05-24', '2017-05-26', 'BNP PARIBAS', 'RR', 2, 0.0445, 100000000000.00, 0.98775, 98775000000.00, 98799419375.00, 'DOEL', NULL),
  (22, NULL, '2017-05-24', '2017-05-24', '2017-05-30', 'BNP PARIBAS', 'RR', 6, 0.0475, 90000000000.00, 0.9322335, 83901015000.00, 83967436636.88, 'DOEL', NULL),
  (23, NULL, '2017-05-24', '2017-05-24', '2017-06-14', 'BPD SUMUT', 'R', 21, 0.0545, 200000000000.00, 0.8905311, 178106220000.00, 178672449357.75, 'DOEL', NULL),
  (24, NULL, '2017-05-30', '2017-05-30', '2017-06-13', 'BPD SUMSEL BB', 'R', 14, 0.0505, 75000000000.00, 0.8915256, 66864420000.00, 66995734291.50, 'RIDWAN', NULL),
  (25, NULL, '2017-05-31', '2017-05-31', '2017-06-05', 'BNP PARIBAS', 'RR', 5, 0.047, 69000000000.00, 0.911030616, 62861112504.00, 62902146841.33, 'DOEL', NULL),
  (26, NULL, '2017-05-31', '2017-05-31', '2017-06-05', 'BNP PARIBAS', 'RR', 5, 0.047, 47000000000.00, 0.923381694, 43398939618.00, 43427269481.36, 'DOEL', NULL),
  (27, NULL, '2017-06-07', '2017-06-07', '2017-06-23', 'BPD PAPUA', 'R', 16, 0.0505, 120000000000.00, 0.8925228, 107102736000.00, 107343122140.80, 'RIDWAN', NULL),
  (28, NULL, '2017-06-07', '2017-06-07', '2017-06-14', 'BNP PARIBAS', 'RR', 7, 0.048, 46000000000.00, 0.9216, 42393600000.00, 42433167360.00, 'EKO ', NULL),
  (29, NULL, '2017-06-09', '2017-06-09', '2017-06-16', 'BPD SULTENG', 'R', 7, 0.0478, 90000000000.00, 0.91248322, 82123489800.00, 82199819021.35, 'RIDWAN', NULL),
  (30, NULL, '2017-06-12', '2017-06-12', '2017-06-13', 'BNP PARIBAS', 'RR', 1, 0.044, 197000000000.00, 0.949629906, 187077091482.00, 187099956459.85, 'DOEL', NULL),
  (31, NULL, '2017-06-12', '2017-06-12', '2017-06-13', 'BNP PARIBAS', 'RR', 1, 0.044, 101000000000.00, 0.9135, 92263500000.00, 92274776650.00, 'DOEL', NULL),
  (32, NULL, '2017-06-14', '2017-06-14', '2017-06-21', 'BNP PARIBAS', 'RR', 7, 0.0485, 46000000000.00, 0.92401362, 42504626520.00, 42544710744.18, 'DOEL', NULL),
  (33, NULL, '2017-06-14', '2017-06-14', '2017-06-21', 'BNP PARIBAS', 'RR', 7, 0.0485, 33000000000.00, 0.973021734, 32109717222.00, 32139998469.21, 'DOEL', NULL),
  (34, NULL, '2017-06-14', '2017-06-14', '2017-06-19', 'BNP PARIBAS', 'RR', 5, 0.0475, 106000000000.00, 0.931639473, 98753784138.00, 98818934203.92, 'DOEL', NULL),
  (35, NULL, '2017-06-14', '2017-06-14', '2017-06-23', 'BPD SUMUT', 'R', 9, 0.048, 150000000000.00, 0.8935218, 134028270000.00, 134189103924.00, 'DOEL', NULL),
  (36, NULL, '2017-06-15', '2017-06-15', '2017-07-06', 'BPD PAPUA', 'R', 21, 0.057, 56000000000.00, 0.8936649, 50045234400.00, 50211634804.38, 'RIDWAN', NULL),
  (37, NULL, '2017-06-15', '2017-06-15', '2017-07-06', 'BPD KALTIM', 'R', 21, 0.0577, 224000000000.00, 0.893808, 200212992000.00, 200886875562.24, 'RIDWAN', NULL),
  (38, NULL, '2017-06-16', '2017-06-16', '2017-06-20', 'BNP PARIBAS', 'RR', 4, 0.046, 60000000000.00, 0.925073127, 55504387620.00, 55532756529.23, 'DOEL', NULL),
  (39, NULL, '2017-06-16', '2017-06-16', '2017-07-07', 'BPD SUMUT', 'R', 21, 0.059, 168000000000.00, 0.8939511, 150183784800.00, 150700667326.02, 'RIDWAN', NULL),
  (40, NULL, '2017-06-19', '2017-06-20', '2017-07-05', 'BNP PARIBAS', 'RR', 15, 0.056, 100000000000.00, 0.92925, 92925000000.00, 93141825000.00, 'EKO ', NULL),
  (41, NULL, '2017-06-20', '2017-06-20', '2017-07-04', 'BPD SULTENG', 'R', 14, 0.053, 100000000000.00, 1.02662188, 102662188000.00, 102873786176.38, 'RIDWAN', NULL),
  (42, NULL, '2017-06-22', '2017-06-22', '2017-07-04', 'BPD SULTENG', 'RR', 12, 0.0525, 50000000000.00, 1.0175708, 50878540000.00, 50967577445.00, 'RIDWAN', NULL),
  (43, NULL, '2017-07-05', '2017-07-05', '2017-07-12', 'BNP PARIBAS', 'RR', 7, 0.048, 100000000000.00, 0.932043708, 93204370800.00, 93291361546.08, NULL, NULL),
  (44, NULL, '2017-07-06', '2017-07-06', '2017-07-13', 'BNP PARIBAS', 'RR', 7, 0.048, 60000000000.00, 0.923422653, 55405359180.00, 55457070848.57, NULL, NULL),
  (45, NULL, '2017-07-06', '2017-07-06', '2017-07-13', 'BNP PARIBAS', 'RR', 7, 0.048, 166000000000.00, 0.93152961, 154633915260.00, 154778240247.58, NULL, NULL),
  (46, NULL, '2017-07-06', '2017-07-06', '2017-07-12', 'BNP PARIBAS', 'RR', 6, 0.0475, 130000000000.00, 0.850097961, 110512734930.00, 110600224178.49, NULL, NULL),
  (47, NULL, '2017-07-07', '2017-07-07', '2017-07-13', 'BNP PARIBAS', 'R', 6, 0.047, 60000000000.00, 0.921637035, 55298222100.00, 55341539040.65, NULL, NULL),
  (48, NULL, '2017-07-11', '2017-07-11', '2017-08-11', 'BPD NAGARI', 'R', 31, 0.0595, 9999999999999999999999999999.99, 0.8812089, 132181335000.00, 132858580756.69, NULL, NULL),
  (49, NULL, '2017-07-12', '2017-07-12', '2017-07-19', 'BNP PARIBAS', 'RR', 7, 0.048, 100000000000.00, 0.930391758, 93039175800.00, 93126012364.08, NULL, NULL),
  (50, NULL, '2017-07-12', '2017-07-12', '2017-07-19', 'BNP PARIBAS', 'RR', 7, 0.048, 130000000000.00, 0.841610529, 109409368770.00, 109511484180.85, NULL, NULL),
  (51, NULL, '2017-07-14', '2017-07-14', '2017-07-21', 'BPD DKI', 'R', 7, 0.0475, 150000000000.00, 0.8917524, 133762860000.00, 133886404863.75, NULL, NULL),
  (52, NULL, '2017-07-14', '2017-07-14', '2017-07-28', 'BPD KALTIM', 'R', 14, 0.0515, 210000000000.00, 0.943622595, 198160744950.00, 198557616886.41, NULL, NULL),
  (53, NULL, '2017-07-17', '2017-07-17', '2017-07-27', 'BPD KALTIM', 'R', 10, 0.0495, 330000000000.00, 0.8857737, 292305321000.00, 292707240816.38, NULL, NULL),
  (54, NULL, '2017-07-18', '2017-07-18', '2017-07-20', 'BNP PARIBAS', 'RR', 2, 0.0455, 126000000000.00, 0.929237004, 117083862504.00, 117113458702.58, NULL, NULL),
  (55, NULL, '2017-07-18', '2017-07-18', '2017-07-24', 'BNP PARIBAS', 'RR', 6, 0.0495, 116000000000.00, 0.965012661, 111941468676.00, 112033820387.66, NULL, NULL),
  (56, NULL, '2017-07-18', '2017-07-18', '2017-08-01', 'BPD SULTENG', 'R', 14, 0.0505, 50000000000.00, 0.94378302, 47189151000.00, 47281825249.33, 'EKO ', NULL),
  (57, NULL, '2017-07-19', '2017-07-19', '2017-08-02', 'BPD KALTIM', 'R', 14, 0.05, 115000000000.00, 0.8730801, 100404211500.00, 100599441911.25, 'EKO ', NULL),
  (58, NULL, '2017-07-19', '2017-07-19', '2017-07-25', 'BNP PARIBAS', 'RR', 6, 0.0475, 300000000000.00, 1.049256, 314776800000.00, 315025998300.00, 'EKO ', NULL),
  (59, NULL, '2017-07-20', '2017-07-20', '2017-08-03', 'BPD PAPUA', 'R', 14, 0.05, 100000000000.00, 0.8733456, 87334560000.00, 87504377200.00, 'EKO ', NULL),
  (60, NULL, '2017-07-20', '2017-07-20', '2017-08-03', 'BPD SULTENG', 'R', 14, 0.05, 50000000000.00, 0.976109751, 48805487550.00, 48900387109.13, 'EKO ', NULL),
  (61, NULL, '2017-07-21', '2017-07-21', '2017-08-04', 'BPD KALTIM', 'R', 14, 0.05, 135000000000.00, 0.945584046, 127653846210.00, 127902062022.08, 'EKO ', NULL),
  (62, NULL, '2017-07-21', '2017-07-24', '2017-08-22', 'BPD PAPUA', 'R', 31, 0.058, 150000000000.00, 0.8749161, 131237415000.00, 131892872978.25, 'EKO ', NULL),
  (63, NULL, '2017-07-24', '2017-07-24', '2017-08-07', 'BPD PAPUA', 'R', 14, 0.0499, 200000000000.00, 0.8872047, 177440940000.00, 177785274001.90, 'EKO ', NULL),
  (64, NULL, '2017-07-24', '2017-07-24', '2017-08-07', 'BPD KALTIM', 'R', 14, 0.0498, 110000000000.00, 0.8949366, 98443026000.00, 98633677327.02, NULL, NULL),
  (65, NULL, '2017-07-26', '2017-07-26', '2017-08-01', 'BNP PARIBAS', 'RR', 6, 0.048, 52000000000.00, 0.962596872, 50055037344.00, 50095081373.88, NULL, NULL),
  (66, NULL, '2017-07-26', '2017-07-26', '2017-08-01', 'BNP PARIBAS', 'RR', 6, 0.048, 195000000000.00, 0.921661911, 179724072645.00, 179867851903.12, NULL, NULL),
  (67, NULL, '2017-07-26', '2017-07-26', '2017-08-02', 'BNP PARIBAS', 'RR', 7, 0.0485, 39000000000.00, 0.91575, 35714250000.00, 35747930521.88, NULL, NULL),
  (68, NULL, '2017-07-26', '2017-07-26', '2017-08-02', 'BNP PARIBAS', 'RR', 7, 0.0485, 13000000000.00, 0.82560798, 10732903740.00, 10743025464.50, NULL, NULL),
  (69, NULL, '2017-07-27', '2017-07-27', '2017-08-28', 'BPD PAPUA', 'R', 32, 0.0595, 200000000000.00, 0.8742105, 174842100000.00, 175766820440.00, NULL, NULL),
  (70, NULL, '2017-07-27', '2017-07-27', '2017-07-28', 'BNP PARIBAS', 'RR', 1, 0.044, 100000000000.00, 0.966501225, 96650122500.00, 96661935292.75, NULL, NULL),
  (71, NULL, '2017-07-27', '2017-07-27', '2017-07-28', 'BNP PARIBAS', 'RR', 1, 0.044, 160000000000.00, 0.903576042, 144572166720.00, 144589836651.49, NULL, NULL),
  (72, NULL, '2017-07-27', '2017-07-27', '2017-08-01', 'BNP PARIBAS', 'RR', 5, 0.047, 24000000000.00, 0.945877419, 22701058056.00, 22715876802.23, NULL, NULL),
  (73, NULL, '2017-07-28', '2017-07-28', '2017-08-11', 'BRI AGRO', 'R', 14, 0.049, 100000000000.00, 0.946134441, 94613444100.00, 94793735274.04, NULL, NULL),
  (74, NULL, '2017-07-28', '2017-07-28', '2017-08-28', 'BPD KALTIM', 'R', 31, 0.0585, 300000000000.00, 0.946134441, 283840332300.00, 285270177973.96, NULL, NULL),
  (75, NULL, '2017-07-31', '2017-07-31', '2017-08-02', 'BNP PARIBAS', 'RR', 2, 0.045, 135000000000.00, 0.970311519, 130992055065.00, 131024803078.77, NULL, NULL),
  (76, NULL, '2017-07-31', '2017-07-31', '2017-08-01', 'BNP PARIBAS', 'RR', 1, 0.044, 35000000000.00, 0.966519648, 33828187680.00, 33832322236.27, NULL, NULL),
  (77, NULL, '2017-07-31', '2017-07-31', '2017-08-02', 'BNP PARIBAS', 'RR', 2, 0.045, 57000000000.00, 1.097494047, 62557160679.00, 62572799969.17, NULL, NULL),
  (78, NULL, '2017-08-03', '2017-08-03', '2017-08-18', 'BPD SULTENG', 'R', 15, 0.05, 50000000000.00, 0.94606796, 47303398000.00, 47401946745.83, NULL, NULL),
  (79, NULL, '2017-08-03', '2017-08-03', '2017-08-10', 'BPD SULSELBAR', 'R', 7, 0.0475, 50000000000.00, 0.8884962, 44424810000.00, 44465841248.13, NULL, NULL),
  (80, NULL, '2017-08-03', '2017-08-03', '2017-08-04', 'BPD SULTRA', 'RR', 1, 0.043, 100000000000.00, 0.9358203, 93582030000.00, 93593207853.58, NULL, NULL),
  (81, NULL, '2017-08-04', '2017-08-04', '2017-08-18', 'BPD PAPUA', 'R', 14, 0.05, 100000000000.00, 0.8886402, 88864020000.00, 89036811150.00, NULL, NULL),
  (82, NULL, '2017-08-04', '2017-08-04', '2017-08-08', 'BNP PARIBAS', 'RR', 4, 0.0465, 150000000000.00, 1.060486488, 159072973200.00, 159155160902.82, NULL, NULL),
  (83, NULL, '2017-08-04', '2017-08-04', '2017-08-09', 'BNP PARIBAS', 'RR', 5, 0.047, 100000000000.00, 0.928083807, 92808380700.00, 92868963948.51, NULL, NULL),
  (84, NULL, '2017-08-04', '2017-08-04', '2017-08-09', 'BNP PARIBAS', 'RR', 5, 0.047, 195000000000.00, 0.920546406, 179506549170.00, 179623727056.26, NULL, NULL),
  (85, NULL, '2017-08-07', '2017-08-07', '2017-09-07', 'BANK MNC', 'RR', 31, 0.06, 100000000000.00, 0.8838702, 88387020000.00, 88843686270.00, NULL, NULL),
  (86, NULL, '2017-08-07', '2017-08-07', '2017-08-14', 'BPD SUMSEL BB', 'R', 7, 0.0478, 100000000000.00, 0.8838702, 88387020000.00, 88469170824.70, NULL, NULL),
  (87, NULL, '2017-08-07', '2017-08-07', '2017-09-07', 'BPD PAPUA', 'R', 31, 0.0593, 100000000000.00, 0.8838702, 88387020000.00, 88838358496.85, NULL, NULL),
  (88, NULL, '2017-08-14', '2017-08-14', '2017-08-21', 'BNP PARIBAS', 'RR', 7, 0.048, 135000000000.00, 0.921984435, 124467898725.00, 124584068763.81, NULL, NULL),
  (89, NULL, '2017-08-14', '2017-08-14', '2017-08-21', 'BNP PARIBAS', 'RR', 7, 0.048, 115000000000.00, 0.969833214, 111530819610.00, 111634915041.64, NULL, NULL),
  (90, NULL, '2017-08-14', '2017-08-14', '2017-08-21', 'BNP PARIBAS', 'RR', 7, 0.048, 83000000000.00, 0.852119424, 70725912192.00, 70791923043.38, NULL, NULL),
  (91, NULL, '2017-08-14', '2017-08-14', '2017-08-21', 'BNP PARIBAS', 'RR', 7, 0.048, 50000000000.00, 0.94849884, 47424942000.00, 47469205279.20, NULL, NULL),
  (92, NULL, '2017-08-14', '2017-08-14', '2017-08-18', 'BNP PARIBAS', 'RR', 4, 0.047, 100000000000.00, 0.928680957, 92868095700.00, 92916593483.31, NULL, NULL),
  (93, NULL, '2017-08-22', '2017-08-22', '2017-09-05', 'BPD JATIM', 'R', 14, 0.05, 50000000000.00, 0.8929688, 44648440000.00, 44735256411.11, NULL, NULL),
  (94, NULL, '2017-08-22', '2017-08-22', '2017-08-28', 'BNP PARIBAS', 'RR', 6, 0.0475, 50000000000.00, 0.969417477, 48470873850.00, 48509246625.13, NULL, NULL),
  (95, NULL, '2017-08-22', '2017-08-22', '2017-08-28', 'BNP PARIBAS', 'RR', 6, 0.0475, 65000000000.00, 0.94933386, 61706700900.00, 61755552038.21, NULL, NULL),
  (96, NULL, '2017-08-22', '2017-08-22', '2017-08-28', 'BNP PARIBAS', 'RR', 6, 0.0475, 80000000000.00, 0.853012476, 68240998080.00, 68295022203.48, NULL, NULL),
  (97, NULL, '2017-08-22', '2017-08-22', '2017-08-28', 'BNP PARIBAS', 'RR', 6, 0.0475, 20000000000.00, 1.023494877, 20469897540.00, 20486102875.55, NULL, NULL),
  (98, NULL, '2017-08-24', '2017-08-24', '2017-08-29', 'BNP PARIBAS', 'RR', 5, 0.045, 80000000000.00, 0.910915137, 72873210960.00, 72918756716.85, NULL, NULL),
  (99, NULL, '2017-08-24', '2017-08-24', '2017-08-29', 'BNP PARIBAS', 'RR', 5, 0.045, 120000000000.00, 0.928571085, 111428530200.00, 111498173031.38, NULL, NULL),
  (100, NULL, '2017-08-25', '2017-08-25', '2017-08-28', 'BNP PARIBAS', 'R', 3, 0.0395, 20000000000.00, 1.024341993, 20486839860.00, 20493583444.79, NULL, NULL),
  (101, NULL, '2017-08-28', '2017-08-28', '2017-09-11', 'BPD KALTIM', 'R', 14, 0.0475, 170000000000.00, 0.990753, 168428010000.00, 168739133962.92, NULL, NULL),
  (102, NULL, '2017-08-29', '2017-08-29', '2017-09-04', 'BPD SULSELBAR', 'RR', 6, 0.0455, 200000000000.00, 0.989201, 197840200000.00, 197990228818.33, NULL, NULL),
  (103, NULL, '2017-08-30', '2017-08-30', '2017-08-31', 'BPD SULSELBAR', 'RR', 1, 0.041, 100000000000.00, 0.990479, 99047900000.00, 99059180455.28, NULL, NULL),
  (104, NULL, '2017-08-30', '2017-08-30', '2017-08-31', 'BPD SULSELBAR', 'RR', 1, 0.041, 300000000000.00, 0.988246, 296473800000.00, 296507565071.67, NULL, NULL),
  (105, NULL, '2017-08-31', '2017-08-31', '2017-09-14', 'BPD PAPUA', 'R', 14, 0.0468, 100000000000.00, 0.8947539, 89475390000.00, 89638235209.80, NULL, NULL),
  (106, NULL, '2017-09-04', '2017-09-04', '2017-09-18', 'BPD PAPUA', 'R', 14, 0.0468, 100000000000.00, 0.8947539, 89475390000.00, 89638235209.80, NULL, NULL),
  (107, NULL, '2017-09-04', '2017-09-04', '2017-09-06', 'BNP PARIBAS', 'RR', 2, 0.042, 65000000000.00, 0.961425, 62492625000.00, 62507206612.50, NULL, NULL),
  (108, NULL, '2017-09-04', '2017-09-04', '2017-09-06', 'BNP PARIBAS', 'RR', 2, 0.042, 35000000000.00, 0.987700194, 34569506790.00, 34577573008.25, NULL, NULL),
  (109, NULL, '2017-09-04', '2017-09-04', '2017-09-06', 'BNP PARIBAS', 'RR', 2, 0.042, 20000000000.00, 0.930202254, 18604045080.00, 18608386023.85, NULL, NULL),
  (110, NULL, '2017-09-05', '2017-09-05', '2017-09-19', 'BPD KALTIM', 'R', 14, 0.047, 170000000000.00, 0.990479, 168381430000.00, 168689193835.94, NULL, NULL),
  (111, NULL, '2017-09-06', '2017-09-06', '2017-09-20', 'BPD SUMSEL BB', 'R', 14, 0.0467, 100000000000.00, 0.992841, 99284100000.00, 99464410957.17, NULL, NULL),
  (112, NULL, '2017-09-07', '2017-09-07', '2017-09-08', 'BNP PARIBAS', 'RR', 1, 0.042, 14000000000.00, 0.999281124, 13989935736.00, 13991567895.17, NULL, NULL),
  (113, NULL, '2017-09-07', '2017-09-07', '2017-09-08', 'BNP PARIBAS', 'RR', 1, 0.042, 31000000000.00, 0.850706064, 26371887984.00, 26374964704.26, NULL, NULL),
  (114, NULL, '2017-09-07', '2017-09-07', '2017-09-11', 'BNP PARIBAS', 'RR', 4, 0.0445, 63000000000.00, 0.926685675, 58381197525.00, 58410063783.78, NULL, NULL),
  (115, NULL, '2017-09-07', '2017-09-07', '2017-09-11', 'BNP PARIBAS', 'RR', 4, 0.0445, 50000000000000000000000.00, 0.941321106, 47066055300.00, 47089326849.57, NULL, NULL);
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  