 ('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');
 
 -- --------------------------------------------------------
 

  `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;

--
-- 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');

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


  `add_tr_id` int(11) NOT NULL,
  `opex_trd_id` int(11) NOT NULL,
  `budget` int(15) NOT NULL,
  `year` int(5) NOT NULL,
  `reason` text NOT NULL,
  `submit` varchar(80) NOT NULL,
  `kode` varchar(10) NOT NULL,
  `username` varchar(50) NOT NULL,
