   `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   `user_agent` varchar(225) NOT NULL,
   `ip_address` varchar(16) NOT NULL
-) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
+) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
 
 --
 -- Dumping data for table `additional_tr`
 --
 
-INSERT INTO `additional_tr` (`add_tr_id`, `opex_trd_id`, `budget`, `submit`, `kode`, `username`, `create_date`, `last_update`, `user_agent`, `ip_address`) VALUES
-(1, 37, 5000000, 'handoyo_division@gmail.com', 'KC', 'alhusna901@gmail.com', '2016-12-31 00:09:50', '2017-01-18 16:30:41', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0', '::1'),
-(3, 49, 8000000, 'handoyo_division@gmail.com', 'KC', 'alhusna901@gmail.com', '2016-12-31 11:55:16', '2017-01-18 16:37:28', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0', '::1'),
-(4, 40, 200000, '', 'KE', 'marina@gmail.com', '2016-12-31 14:21:01', '2016-12-31 07:21:01', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0', '192.168.1.101'),
-(5, 205, 640000, '', 'KC', 'alhusna901@gmail.com', '2017-01-13 22:54:32', '2017-01-13 16:08:26', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Gecko/20100101 Firefox/50.0', '::1'),
-(6, 350, 4600056, '', 'KE', 'marina@gmail.com', '2017-02-02 23:51:18', '2017-02-02 16:51:18', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36', '::1');
+INSERT INTO `additional_tr` (`add_tr_id`, `opex_trd_id`, `budget`, `year`, `reason`, `submit`, `kode`, `username`, `create_date`, `last_update`, `user_agent`, `ip_address`) VALUES
+(1, 37, 1200000, 2017, 'ada penambahan orang', '', 'HD', 'alhusna901@gmail.com', '2017-06-04 11:54:37', '2017-06-04 05:46:52', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0', '::1'),
+(2, 37, 780000, 2017, 'belajar ke yunani terkait ekonomi', '', 'HD', 'alhusna901@gmail.com', '2017-06-05 05:19:45', '2017-06-04 22:19:45', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0', '::1');
 
 -- --------------------------------------------------------
 

-- Dumping data for table `realization_tr`
--

INSERT INTO `realization_tr` (`id_realization`, `opex_trd_id`, `kode`, `username`, `submit`, `activity`, `amount`, `ip_address`, `user_agent`, `create_date`, `last_update`) VALUES
(1, 205, 'KC', 'alhusna901@gmail.com', 'handoyo_division@gmail.com', 'jalan jalan ke monas se kantor', 590000, '::1', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:50.0) Geck', '2017-01-15 08:36:59', '2017-01-18 18:11:20');

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


('HC', 'FINANCE & ACCOUNTING', 'H', ''),
('HD', 'IT', 'H', ''),
('IA', 'SALES ADMIN', 'I', '');

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

--
-- Table structure for table `detail_department_opex_acc`
--

CREATE TABLE IF NOT EXISTS `detail_department_opex_acc` (
  `id_ddoa` int(11) NOT NULL,
  `kode_department` varchar(3) NOT NULL,
  `no_acc_opex` varchar(20) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `detail_department_opex_acc`
--

INSERT INTO `detail_department_opex_acc` (`id_ddoa`, `kode_department`, `no_acc_opex`) VALUES
(1, 'EB', '704.00.001'),
(2, 'EB', '706.00.001'),
(3, 'EB', '707.01.001'),
(4, 'EB', '707.04.001'),
(5, 'EB', '712.02.001'),
(6, 'EB', '713.00.001'),
(7, 'EB', '714.00.001'),
(9, 'EB', '724.04.001'),
(10, 'EB', '726.01.001'),
(11, 'EB', '726.02.001'),
(12, 'EB', '726.04.001'),
(13, 'EB', '726.05.001'),
(14, 'EB', '726.06.001'),
(15, 'EB', '726.07.001'),
(16, 'EB', '726.08.001'),
(17, 'EB', '726.09.001'),
(18, 'EB', '726.99.001'),
(19, 'EB', '728.00.001'),
(20, 'EA', '704.00.001'),
(21, 'EA', '706.00.001'),
(22, 'EA', '707.02.001'),
(23, 'EA', '707.03.001'),
(24, 'EA', '707.05.001'),
(25, 'EA', '708.00.001'),
(26, 'BE', '704.00.001'),
(27, 'BE', '706.00.001'),
(28, 'BE', '712.02.001'),
(29, 'BE', '712.03.001'),
(30, 'FA', '704.00.001'),
(31, 'FA', '706.00.001'),
(32, 'FA', '728.00.001'),
(33, 'HD', '704.00.001'),
(34, 'HD', '706.00.001'),
(35, 'HD', '726.03.001'),
(36, 'EB', '730.99.001'),
(37, 'EB', '738.02.001'),
(38, 'EB', '755.01.001'),
(39, '', ''),
(40, 'FA', '730.99.001'),
(41, 'EA', '730.99.001'),
(42, 'EA', '750.00.001'),
(43, 'BE', '730.99.001'),
(44, 'HD', '730.99.001'),
(45, 'HC', '704.00.001'),
(46, 'HC', '706.00.001'),
(47, 'HC', '730.99.001'),
(48, 'HC', '742.00.001'),
(49, 'AA', '704.00.001'),
(50, 'AA', '706.00.001'),
(51, 'AA', '730.99.001'),
(52, 'AA', '732.00.001'),
(53, 'HA', '704.00.001'),
(54, 'HA', '706.00.001'),
(55, 'HA', '730.99.001'),
(56, 'HA', '750.01.001'),
(57, 'EB', '724.01.001');

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

