-- http://www.phpmyadmin.net
--


--
-- Database: `rlis5`
--

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

--
-- Table structure for table `captcha`
--

CREATE TABLE IF NOT EXISTS `captcha` (
  `captcha_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `captcha_time` int(10) unsigned DEFAULT NULL,
  `ip_address` varchar(16) NOT NULL DEFAULT '0',
  `word` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`captcha_id`),
  KEY `word` (`word`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Data captcha' AUTO_INCREMENT=26 ;

--
-- Dumping data for table `captcha`
--

INSERT INTO `captcha` (`captcha_id`, `captcha_time`, `ip_address`, `word`) VALUES
(1, NULL, '157.56.94.167', NULL),
(2, NULL, '157.55.32.189', NULL),
(3, NULL, '157.55.36.37', NULL),
(4, NULL, '157.55.34.168', NULL),
(5, NULL, '157.55.34.168', NULL),
(6, NULL, '157.55.34.168', NULL),
(7, NULL, '222.165.222.139', NULL),
(8, NULL, '222.165.222.139', NULL),
(9, NULL, '222.165.222.139', NULL),
(10, NULL, '222.165.222.139', NULL),
(11, NULL, '222.165.222.139', NULL),
(12, NULL, '222.165.222.144', NULL),
(13, 1356589883, '222.165.222.139', '158026'),
(14, 1356589961, '222.165.222.139', '636513'),
(15, 1356594101, '222.165.222.139', '335776'),
(16, 1358262413, '157.55.34.168', '474777'),
(17, 1359950614, '127.0.0.1', '632090'),
(18, 1360115573, '127.0.0.1', '210859'),
(19, 1360115576, '127.0.0.1', '251641'),
(20, 1360115579, '127.0.0.1', '016014'),
(21, 1360115580, '127.0.0.1', '148853'),
(22, 1360115581, '127.0.0.1', '937923'),
(23, 1360115582, '127.0.0.1', '683611'),
(24, NULL, '222.165.222.139', NULL),
(25, 1366365412, '127.0.0.1', '563145');

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

--
-- Table structure for table `h_gl_cancel`
--

CREATE TABLE IF NOT EXISTS `h_gl_cancel` (
  `nocpvform` char(10) NOT NULL COMMENT 'No. CPV Format',
  `year` year(4) NOT NULL COMMENT 'Tahun',
  `glacc` char(10) NOT NULL COMMENT 'No. GL Acc',
  `glacc_cancel` char(10) NOT NULL COMMENT 'No. GL Acc cancel',
  `canby` varchar(10) NOT NULL COMMENT 'Cancel By',
  `candate` datetime NOT NULL COMMENT 'Cancel Date',
  PRIMARY KEY (`nocpvform`,`year`,`glacc`,`glacc_cancel`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table History Cancel GL';

--
-- Dumping data for table `h_gl_cancel`
--


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

--
-- Table structure for table `h_miro_cancel`
--

CREATE TABLE IF NOT EXISTS `h_miro_cancel` (
  `ebeln` char(10) NOT NULL COMMENT 'No. PO',
  `year` year(4) NOT NULL COMMENT 'Tahun',
  `miro` char(10) NOT NULL COMMENT 'No. miro',
  `miro_cancel` char(10) NOT NULL COMMENT 'No. miro cancel',
  `canby` varchar(10) NOT NULL COMMENT 'Cancel By',
  `candate` datetime NOT NULL COMMENT 'Cancel Date',
  PRIMARY KEY (`ebeln`,`year`,`miro`,`miro_cancel`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table History Cancel MIRO';

--
-- Dumping data for table `h_miro_cancel`
--


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

--
-- Table structure for table `h_pcop_trf`
--

CREATE TABLE IF NOT EXISTS `h_pcop_trf` (
  `idcab` int(11) NOT NULL DEFAULT '0' COMMENT 'ID Cabang',
  `sap_ref` varchar(100) NOT NULL DEFAULT '' COMMENT 'No. referensi transaksi SAP',
  `rlis_ref` varchar(100) NOT NULL COMMENT 'No. referensi transaksi RLIS',
  `amount` double DEFAULT NULL COMMENT 'Jumlah uang',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  PRIMARY KEY (`idcab`,`sap_ref`,`rlis_ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table history transfer petty cash opr';

--
-- Dumping data for table `h_pcop_trf`
--

INSERT INTO `h_pcop_trf` (`idcab`, `sap_ref`, `rlis_ref`, `amount`, `adddate`, `addby`) VALUES
(3, '0100004480WGI12013', 'CPV/7/05/13/1', 5000000, '2013-05-14 15:20:27', 'imam');

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

--
-- Table structure for table `master_menu`
--

CREATE TABLE IF NOT EXISTS `master_menu` (
  `mid` int(4) NOT NULL AUTO_INCREMENT COMMENT 'Menu ID',
  `pid` int(4) NOT NULL COMMENT 'Menu parent ID',
  `mname` varchar(50) NOT NULL COMMENT 'Nama menu',
  `murl` varchar(150) NOT NULL COMMENT 'Menu URL',
  `crby` varchar(10) NOT NULL COMMENT 'Dibuat oleh',
  `crdate` date NOT NULL COMMENT 'Tgl buat',
  `crtime` time NOT NULL COMMENT 'Jam buat',
  `chby` varchar(10) NOT NULL COMMENT 'Diubah oleh',
  `chdate` date NOT NULL COMMENT 'Tgl ubah',
  `chtime` time NOT NULL COMMENT 'Jam ubah',
  PRIMARY KEY (`mid`,`pid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COMMENT='Master menu' AUTO_INCREMENT=111 ;

--
-- Dumping data for table `master_menu`
--

INSERT INTO `master_menu` (`mid`, `pid`, `mname`, `murl`, `crby`, `crdate`, `crtime`, `chby`, `chdate`, `chtime`) VALUES
(1, 0, 'ADMINISTRATOR', '#', 'Imam', '2012-08-07', '10:48:10', 'Imam', '2012-08-14', '11:34:46'),
(3, 1, 'MENU', '#', 'Imam', '2012-08-07', '10:53:42', '', '0000-00-00', '00:00:00'),
(10, 1, 'ROLE', '#', 'Imam', '2012-08-07', '11:12:33', '', '0000-00-00', '00:00:00'),
(11, 10, 'Add role', 'admin/admin_role', 'Imam', '2012-08-07', '11:12:41', 'Imam', '2012-08-08', '12:36:30'),
(12, 10, 'Edit role', 'admin/admin_role/admin_list_role', 'Imam', '2012-08-07', '11:13:06', 'Imam', '2012-08-14', '12:58:43'),
(13, 1, 'USER', '#', 'Imam', '2012-08-07', '11:16:01', '', '0000-00-00', '00:00:00'),
(17, 3, 'Add menu', 'admin/admin_menu', 'Imam', '2012-08-07', '21:56:54', '', '0000-00-00', '00:00:00'),
(19, 13, 'Add user', 'admin/admin_user', 'Imam', '2012-08-07', '22:02:22', 'Imam', '2012-08-10', '09:39:40'),
(20, 3, 'Edit menu', 'admin/admin_menu/admin_list_menu', 'Imam', '2012-08-07', '23:05:54', '', '0000-00-00', '00:00:00'),
(22, 13, 'Edit user', 'admin/admin_user/admin_list_user', 'Imam', '2012-08-08', '12:35:54', 'Imam', '2012-08-10', '11:23:21'),
(25, 0, 'USER TOOLS', '#', 'Imam', '2012-08-11', '05:57:30', '', '0000-00-00', '00:00:00'),
(26, 25, 'Change password', 'user/user_chg_pwd/', 'Imam', '2012-08-11', '05:57:52', 'Imam', '2012-08-15', '13:34:41'),
(41, 1, 'BRANCH', '#', 'imam', '2013-02-04', '11:08:13', 'imam', '2013-02-05', '15:36:47'),
(42, 41, 'Add branch', 'admin/admin_cabang/', 'imam', '2013-02-04', '11:08:25', 'imam', '2013-02-05', '15:37:01'),
(43, 41, 'Edit branch', 'admin/admin_cabang/admin_list_cabang', 'imam', '2013-02-04', '11:08:40', 'imam', '2013-02-05', '15:37:10'),
(44, 0, 'BRANCH', '#', 'imam', '2013-02-04', '21:22:35', 'imam', '2013-02-05', '15:38:09'),
(45, 44, 'SUPPLIER', '#', 'imam', '2013-02-04', '21:23:34', '', '0000-00-00', '00:00:00'),
(46, 44, 'TRANSPORTER', '#', 'imam', '2013-02-04', '21:23:50', '', '0000-00-00', '00:00:00'),
(47, 45, 'Add supplier', 'branch/cabang_supp/cabang_add_supp', 'imam', '2013-02-04', '21:24:19', 'roberthus', '2013-03-06', '09:49:04'),
(48, 45, 'Edit supplier', 'branch/cabang_supp/cabang_list_supp', 'imam', '2013-02-04', '21:24:33', 'roberthus', '2013-03-06', '09:40:05'),
(49, 46, 'Add transporter', 'branch/cabang_trans/cabang_add_trans', 'imam', '2013-02-04', '21:25:01', 'roberthus', '2013-03-06', '09:57:58'),
(50, 46, 'Edit transporter', 'branch/cabang_trans/cabang_list_trans', 'imam', '2013-02-04', '21:25:13', 'roberthus', '2013-03-06', '09:59:06'),
(51, 1, 'SUPPLIER GROUP', '#', 'imam', '2013-02-05', '10:16:32', 'imam', '2013-02-05', '15:37:36'),
(52, 51, 'Add group', 'admin/admin_suppgrp/', 'imam', '2013-02-05', '10:17:02', 'imam', '2013-02-05', '14:18:07'),
(53, 51, 'Edit group', 'admin/admin_suppgrp/admin_list_suppgrp	', 'imam', '2013-02-05', '10:17:18', 'imam', '2013-02-05', '14:37:18'),
(54, 44, 'PURCHASE REQUISITION', '#', 'imam', '2013-02-05', '10:21:35', 'imam', '2013-02-05', '15:38:02'),
(55, 54, 'Create PR', 'branch/branch_pr/', 'imam', '2013-02-05', '10:21:50', 'imam', '2013-03-05', '10:50:26'),
(56, 54, 'Print PR', 'branch/branch_pr/list_pr/', 'imam', '2013-02-05', '10:22:06', 'imam', '2013-03-05', '12:08:44'),
(57, 44, 'PURCHASE ORDER', '#', 'imam', '2013-02-05', '10:24:06', 'imam', '2013-02-05', '15:38:52'),
(59, 57, 'Print PO', 'branch/branch_po/list_po/', 'imam', '2013-02-05', '10:24:46', 'imam', '2013-04-02', '17:12:52'),
(60, 44, 'OIL PURCHASE', '#', 'imam', '2013-02-05', '10:27:43', 'imam', '2013-02-05', '15:39:54'),
(61, 60, 'Add OP', 'branch/cabang_op/cabang_add_op', 'imam', '2013-02-05', '10:28:20', 'roberthus', '2013-03-27', '15:30:35'),
(62, 60, 'List OP', 'branch/cabang_op/cabang_list_op', 'imam', '2013-02-05', '10:28:52', 'roberthus', '2013-04-02', '15:51:44'),
(63, 0, 'FINANCE', '#', 'imam', '2013-02-07', '13:09:57', '', '0000-00-00', '00:00:00'),
(64, 63, 'CPV', '#', 'imam', '2013-02-07', '13:11:30', 'imam', '2013-02-18', '09:11:30'),
(65, 1, 'NOTIFICATION', '#', 'imam', '2013-02-11', '09:50:38', '', '0000-00-00', '00:00:00'),
(66, 65, 'Add notification', 'admin/admin_notgrp', 'imam', '2013-02-11', '09:50:58', 'imam', '2013-02-11', '13:13:30'),
(67, 65, 'Edit notification', 'admin/admin_notgrp/admin_list_notgrp', 'imam', '2013-02-11', '09:51:13', 'imam', '2013-02-11', '13:13:21'),
(68, 71, 'Direct transfer', 'finance/fin_cpv', 'imam', '2013-02-18', '09:12:14', 'imam', '2013-02-25', '14:03:38'),
(69, 71, 'Create from MIRO', 'finance/fin_cpv/create_fr_miro', 'imam', '2013-02-18', '09:12:43', 'imam', '2013-03-30', '18:38:32'),
(70, 64, 'Edit CPV', 'finance/fin_cpv/list_cpv', 'imam', '2013-02-25', '14:02:48', 'imam', '2013-02-25', '14:04:07'),
(71, 64, 'Create CPV', '#', 'imam', '2013-02-25', '14:03:22', '', '0000-00-00', '00:00:00'),
(72, 64, 'Approval CPV', 'finance/fin_cpv/list_cpv_app', 'imam', '2013-02-26', '10:13:09', 'imam', '2013-02-26', '11:02:17'),
(73, 64, 'Print CPV', 'finance/fin_cpv/print_cpv', 'imam', '2013-02-26', '10:15:00', 'imam', '2013-02-26', '14:10:14'),
(74, 0, 'ACCOUNTING', '#', 'imam', '2013-02-26', '15:00:34', '', '0000-00-00', '00:00:00'),
(75, 74, 'G/L acct post from CPV', 'accounting/acc_gl/', 'imam', '2013-02-26', '15:02:06', 'imam', '2013-02-26', '15:40:04'),
(76, 44, 'PETTY CASH', '#', 'imam', '2013-03-01', '15:30:18', 'imam', '2013-03-05', '08:40:21'),
(77, 100, 'Create PC UO', 'branch/branch_cpv', 'imam', '2013-03-01', '15:30:48', 'imam', '2013-04-17', '15:13:29'),
(78, 76, 'Print PC', 'branch/branch_cpv/list_cpv', 'imam', '2013-03-01', '15:32:21', 'imam', '2013-03-05', '08:40:41'),
(79, 44, 'MANIFEST', '#', 'roberthus', '2013-03-18', '09:05:08', 'roberthus', '2013-03-18', '09:05:37'),
(80, 79, 'Add Manifest', 'branch/cabang_mnfst/cabang_add_mnfst', 'roberthus', '2013-03-18', '09:05:58', 'roberthus', '2013-03-21', '09:03:14'),
(81, 79, 'Edit Manifest', 'branch/cabang_mnfst/cabang_list_mnfst', 'roberthus', '2013-03-18', '09:06:21', 'roberthus', '2013-03-18', '09:16:57'),
(82, 44, 'DELIVERY NOTE', '#', 'roberthus', '2013-03-21', '14:04:34', 'roberthus', '2013-03-21', '14:05:53'),
(83, 82, 'Create Delivery Note', 'branch/cabang_dn/cabang_add_dn', 'roberthus', '2013-03-21', '14:05:12', 'roberthus', '2013-04-10', '17:50:10'),
(84, 74, 'Create MIRO', 'accounting/miro/', 'imam', '2013-03-30', '18:42:53', '', '0000-00-00', '00:00:00'),
(85, 60, 'Add OP Fee Payment', 'branch/cabang_op/cabang_add_op_fee', 'roberthus', '2013-04-01', '10:27:50', 'roberthus', '2013-04-01', '11:46:55'),
(86, 25, 'Dashboard', 'user/dashboard/', 'imam', '2013-04-03', '16:15:59', 'imam', '2013-04-03', '16:19:55'),
(87, 44, 'MIGO', '#', 'imam', '2013-04-04', '10:58:26', '', '0000-00-00', '00:00:00'),
(88, 87, 'Create MIGO', 'branch/branch_migo/', 'imam', '2013-04-04', '10:59:07', '', '0000-00-00', '00:00:00'),
(89, 74, 'Reverse MIRO', 'accounting/miro/reverse', 'imam', '2013-04-05', '09:26:11', '', '0000-00-00', '00:00:00'),
(90, 44, 'QUALITY', '#', 'roberthus', '2013-04-10', '09:44:25', 'roberthus', '2013-04-10', '09:47:04'),
(91, 90, 'Quality Control', 'branch/cabang_qa/cabang_add_qa', 'roberthus', '2013-04-10', '09:47:57', 'roberthus', '2013-04-11', '11:39:21'),
(92, 82, 'List Delivery Note', 'branch/cabang_dn/cabang_list_dn', 'roberthus', '2013-04-10', '17:50:43', 'roberthus', '2013-04-18', '11:13:50'),
(93, 90, 'List QA', 'branch/cabang_qa/cabang_list_qa', 'roberthus', '2013-04-15', '12:22:31', '', '0000-00-00', '00:00:00'),
(95, 0, 'BRANCH MANAGER', '#', 'roberthus', '2013-04-17', '09:44:02', '', '0000-00-00', '00:00:00'),
(96, 95, 'ADJUSTMENT STOK', '#', 'roberthus', '2013-04-17', '09:44:43', '', '0000-00-00', '00:00:00'),
(97, 96, 'Adjustment Stok', 'branch/manager_qa/manager_list_qa', 'roberthus', '2013-04-17', '09:45:05', 'roberthus', '2013-04-17', '13:09:43'),
(98, 95, 'REPORT', '#', 'roberthus', '2013-04-17', '09:46:02', '', '0000-00-00', '00:00:00'),
(99, 98, 'Report Stok', '#', 'roberthus', '2013-04-17', '09:46:28', '', '0000-00-00', '00:00:00'),
(100, 76, 'PETTY CASH UO', '#', 'imam', '2013-04-17', '15:12:32', '', '0000-00-00', '00:00:00'),
(101, 76, 'PETTY CASH OP', '#', 'imam', '2013-04-17', '15:12:43', '', '0000-00-00', '00:00:00'),
(102, 101, 'Create PC OP', 'branch/branch_cpv/create_pcop', 'imam', '2013-04-17', '15:17:12', '', '0000-00-00', '00:00:00'),
(103, 101, 'Create BPKK', 'branch/branch_bpkk/create_bpkk', 'imam', '2013-04-17', '15:18:27', '', '0000-00-00', '00:00:00'),
(104, 101, 'List BPKK', 'branch/branch_bpkk/print_bpkk', 'imam', '2013-04-17', '15:19:41', '', '0000-00-00', '00:00:00'),
(105, 96, 'Print BA Adjustment', '#', 'roberthus', '2013-04-18', '16:32:58', '', '0000-00-00', '00:00:00'),
(106, 60, 'Add OP With PPN', 'branch/cabang_op/cabang_add_op_tax', 'roberthus', '2013-04-29', '13:52:15', 'imam', '2013-05-15', '11:02:40'),
(107, 44, 'OTHER PURCHASE', '#', 'roberthus', '2013-04-29', '16:43:07', '', '0000-00-00', '00:00:00'),
(108, 101, 'Posting to Finance', 'branch/branch_bpkk/post_to_fin', 'imam', '2013-04-26', '11:49:05', 'imam', '2013-04-26', '11:50:06'),
(109, 71, 'Create from Reimbursement', 'finance/fin_cpv/create_fr_rmb', 'imam', '2013-04-29', '10:39:41', 'imam', '2013-04-30', '16:00:26'),
(110, 101, 'Cancel reimbursement', 'branch/branch_bpkk/cancel_rmb', 'imam', '2013-04-29', '15:33:43', 'imam', '2013-04-30', '16:01:16');

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

--
-- Table structure for table `master_role`
--

CREATE TABLE IF NOT EXISTS `master_role` (
  `roleid` int(3) NOT NULL AUTO_INCREMENT COMMENT 'Role ID',
  `rolename` varchar(30) NOT NULL COMMENT 'Nama role',
  `roledesc` varchar(35) NOT NULL COMMENT 'Deskripsi',
  `view` int(1) NOT NULL COMMENT '0 = False, 1= True',
  `add` int(1) NOT NULL,
  `edit` int(1) NOT NULL COMMENT '0 = False, 1= True',
  `delete` int(1) NOT NULL COMMENT '0 = False, 1= True',
  `app` int(1) NOT NULL COMMENT '0 = False, 1= True',
  `cancel` int(1) NOT NULL COMMENT '0 = False, 1= True',
  `crby` varchar(20) NOT NULL COMMENT 'Dibuat oleh',
  `crdate` date NOT NULL COMMENT 'Tgl buat',
  `crtime` time NOT NULL COMMENT 'Jam buat',
  `chby` varchar(20) NOT NULL COMMENT 'Diubah oleh',
  `chdate` date NOT NULL COMMENT 'Tgl ubah',
  `chtime` time NOT NULL COMMENT 'Jam ubah',
  PRIMARY KEY (`roleid`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COMMENT='Data role' AUTO_INCREMENT=18 ;

--
-- Dumping data for table `master_role`
--

INSERT INTO `master_role` (`roleid`, `rolename`, `roledesc`, `view`, `add`, `edit`, `delete`, `app`, `cancel`, `crby`, `crdate`, `crtime`, `chby`, `chdate`, `chtime`) VALUES
(11, 'ADMIN', 'Super user role', 1, 1, 1, 1, 1, 0, 'Imam', '2012-08-14', '10:52:43', 'Imam', '2012-08-09', '23:32:10'),
(12, 'PIC CABANG', 'Role PIC Cabang', 1, 1, 1, 1, 1, 1, 'roberthus', '2013-05-13', '09:35:49', '', '0000-00-00', '00:00:00'),
(13, 'Finance Staff', 'Role Finance Staff', 1, 1, 1, 1, 0, 0, 'imam', '2013-05-13', '12:19:43', '', '0000-00-00', '00:00:00'),
(14, 'Finance Manager', 'Role Finance Manager', 1, 1, 1, 1, 1, 1, 'roberthus', '2013-05-13', '09:40:14', '', '0000-00-00', '00:00:00'),
(15, 'Accounting Staff', 'Role Accounting Staff', 1, 1, 1, 1, 0, 0, 'roberthus', '2013-05-13', '09:40:28', '', '0000-00-00', '00:00:00'),
(16, 'Manager Collecting', 'Manager Collecting', 1, 1, 1, 1, 1, 1, 'roberthus', '2013-05-13', '09:38:45', '', '0000-00-00', '00:00:00'),
(17, 'Branch Manager', 'Branch Manager', 1, 1, 1, 1, 1, 1, 'roberthus', '2013-05-13', '09:38:07', '', '0000-00-00', '00:00:00');

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

--
-- Table structure for table `master_user`
--

CREATE TABLE IF NOT EXISTS `master_user` (
  `uid` varchar(10) NOT NULL COMMENT 'User ID',
  `idcab` int(11) NOT NULL COMMENT 'ID Cabang',
  `roleid` int(3) NOT NULL COMMENT 'Role ID',
  `pass` text NOT NULL COMMENT 'Password',
  `dispname` varchar(100) NOT NULL COMMENT 'Display name',
  `email` varchar(100) NOT NULL COMMENT 'Email',
  `lock` int(1) NOT NULL COMMENT '1= lock, 0= not lock',
  `crby` varchar(20) NOT NULL COMMENT 'Dibuat oleh',
  `crdate` date NOT NULL COMMENT 'Tgl buat',
  `crtime` time NOT NULL COMMENT 'Jam buat',
  `chby` varchar(30) NOT NULL COMMENT 'Diubah oleh',
  `chdate` date NOT NULL COMMENT 'Tgl ubah',
  `chtime` time NOT NULL COMMENT 'Jam ubah',
  PRIMARY KEY (`uid`,`roleid`),
  KEY `roleid` (`roleid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Data user';

--
-- Dumping data for table `master_user`
--

INSERT INTO `master_user` (`uid`, `idcab`, `roleid`, `pass`, `dispname`, `email`, `lock`, `crby`, `crdate`, `crtime`, `chby`, `chdate`, `chtime`) VALUES
('Achmad', 3, 17, '0imQoGyXbTUBoFBhbqWDiG/F877M1mXj0U7dGsibWYkepuDkdcu+1d71v4kCKWTDX+9SjUX/Vhddi3tY8Ky8AA==', 'Achmad', 'achmad@evalube.com', 0, 'roberthus', '2013-04-18', '12:00:47', '', '0000-00-00', '00:00:00'),
('dini', 3, 12, 'yoLZVqjjAqJ57bZhtyHhGr6+EAH4uqUUUKtHl68fktDcheRGA8sHm54mvmSLaNyejsTBbbWKteyH9Tggb7ZC5w==', 'Dini', 'rony.aprianto@evalube.com', 0, 'imam', '2013-02-08', '13:55:52', 'imam', '2013-02-11', '15:32:53'),
('finmgr', 1, 14, 'uHvKerOTuSqLpY7PGhST0B3/t0FcOboAIzukMLxzcfndYE/KZUNznEvP58pHrO+LO/RujNbK7zZvE1I+IEKIOw==', 'Finance Manager', 'yuswati@evalube.com', 0, 'imam', '2013-04-19', '16:30:23', '', '0000-00-00', '00:00:00'),
('imam', 1, 11, 'x/nGepTrt/MdOG7CP0I1TbQl+qhFuYCxPnbMjOnH218LItGdOUmHKj+r3K9Rceio31vvodtG6SS7admQzfNOHg==', 'Imam Wiguna', 'imam@evalube.com', 0, 'Imam', '2012-08-10', '11:45:34', 'imam', '2013-02-05', '09:00:46'),
('izza', 1, 15, 'QV3MX3hHIXNPgICxYiryPiwjJ/A4AKFkjvglfjs7cCOd5DkGgAjqnS1QA4RJCHxVoih9dg01bVMtAx/80BeTwQ==', 'Izza', 'izza@evalube.com', 0, 'imam', '2013-03-30', '19:02:16', '', '0000-00-00', '00:00:00'),
('novika', 1, 13, 'fbYAcTtvJoefC7o5AWyHcKAv+r3Cq1SCNdceYcKg0/4AsODpX2cH94QZxFtZcu6EfUi6/VfWBgvwAOBTM5rTzw==', 'Novika', 'novika@evalube.com', 0, 'imam', '2013-03-30', '19:01:22', '', '0000-00-00', '00:00:00'),
('roberthus', 1, 11, '8EYuoWS11ug0oOKlO2igPjUp+8fsu7Yeq5bZZ70lXsja3kFfokBX59dx2IrMLn90Ji06a+XdFmkLATGcOwC+NA==', 'Andreas Roberthus', 'roberthus@evalube.com', 0, 'imam', '2013-02-05', '09:08:56', 'roberthus', '2013-03-06', '11:28:14'),
('yuswati', 1, 14, 'uNZ5B0ILjDmyZExHYcCFGYvAo0R6uOok+J/gXtFkAJmdBgwcE5SZk8UXL3Hi/zUrkvL3JESgUCFreyj6tJ8BTQ==', 'Yuswati', 'yuswati@evalube.com', 0, 'imam', '2013-03-30', '19:01:54', '', '0000-00-00', '00:00:00');

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

--
-- Table structure for table `m_cab`
--

CREATE TABLE IF NOT EXISTS `m_cab` (
  `idcab` int(11) NOT NULL COMMENT 'Kode cabang',
  `cabname` varchar(100) DEFAULT NULL COMMENT 'Nama cabang',
  `cabshorttxt` varchar(9) NOT NULL,
  `addr` text COMMENT 'Alamat cabang',
  `active` int(1) DEFAULT NULL COMMENT 'Status cabang: aktif = 0, non aktif = 1',
  `pic` varchar(12) DEFAULT NULL COMMENT 'ID User PIC cabang',
  `phone` char(20) DEFAULT NULL COMMENT 'No. telepon cabang',
  `city` varchar(50) DEFAULT NULL COMMENT 'Kota cabang',
  `fax` char(20) DEFAULT NULL COMMENT 'No. Fax cabang',
  `prov` varchar(50) DEFAULT NULL COMMENT 'Propinsi',
  `lifnr` char(10) DEFAULT NULL COMMENT 'SAP Vendor code',
  `werks` char(4) DEFAULT NULL COMMENT 'SAP Plant',
  `lgort` char(4) DEFAULT NULL COMMENT 'SAP Storage location',
  `pcglaccuo` char(10) NOT NULL COMMENT 'Petty cash G/L Acc Uo',
  `pcglaccop` char(10) NOT NULL COMMENT 'Petty cash G/L Acc Op',
  `pcbankglacc` char(10) NOT NULL COMMENT 'Petty cash G/L Acc bank',
  `costctr` char(10) NOT NULL COMMENT 'Cost Center',
  `max_stor` int(11) NOT NULL COMMENT 'Akum daya tampung maksimal tanki',
  `max_pcop_trf` double NOT NULL COMMENT 'Maximum PC OP',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `chby` varchar(10) DEFAULT NULL COMMENT 'Diubah oleh',
  `chdate` datetime DEFAULT NULL COMMENT 'Tanggal ganti',
  PRIMARY KEY (`idcab`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table master cabang';

--
-- Dumping data for table `m_cab`
--

INSERT INTO `m_cab` (`idcab`, `cabname`, `cabshorttxt`, `addr`, `active`, `pic`, `phone`, `city`, `fax`, `prov`, `lifnr`, `werks`, `lgort`, `pcglaccuo`, `pcglaccop`, `pcbankglacc`, `costctr`, `max_stor`, `max_pcop_trf`, `addby`, `adddate`, `chby`, `chdate`) VALUES
(1, 'PUSAT', 'Coll Cbt', 'Cibitung', 1, 'PUSAT', '0000000000', 'Bekasi', '0000000000', 'Jawa Barat', '00000', '1000', '0000', '0000000000', '', '0000000000', '', 16000, 0, 'imam', '2013-02-04 14:43:19', 'imam', '2013-03-04 16:20:45'),
(3, 'Refinery Logistic Bandung', 'Coll Bdg', 'Bandung', 1, 'Achmad', '-', 'Bandung', '-', 'Jawa Barat', '30200', '1000', 'BDG', '1111402', '1111407', '1112137', '123200', 32000, 5000000, 'imam', '2013-02-04 16:07:16', 'imam', '2013-05-13 13:33:09');

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

--
-- Table structure for table `m_gl_opr`
--

CREATE TABLE IF NOT EXISTS `m_gl_opr` (
  `glacc` char(10) NOT NULL COMMENT 'No. G/L',
  `desc` varchar(60) NOT NULL COMMENT 'Desc',
  `cashflow` char(10) NOT NULL COMMENT 'Cash flow',
  PRIMARY KEY (`glacc`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Master data G/L Acc Petty Cash Opr';

--
-- Dumping data for table `m_gl_opr`
--

INSERT INTO `m_gl_opr` (`glacc`, `desc`, `cashflow`) VALUES
('5223001', 'ENTERTAINT', '3303'),
('5229004', 'BBM', '3309'),
('5229005', 'TOL/PARKIR', '3309'),
('5231204', 'PENG. DOKUMEN', '3310'),
('5271001', 'BIAYA LAIN LAIN', '3322'),
('5271003', 'KEB. RMH TANGGA', '3316'),
('5521099', 'PULSA HP', '3301');

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

--
-- Table structure for table `m_manifest`
--

CREATE TABLE IF NOT EXISTS `m_manifest` (
  `idmnfst` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID Manifest',
  `nomnfst` varchar(20) NOT NULL COMMENT 'No Manifest',
  `nosj` varchar(20) NOT NULL COMMENT 'No Surat Jalan',
  `idcab` int(11) NOT NULL COMMENT 'ID Cabang',
  `nmcab` varchar(20) NOT NULL COMMENT 'Nama Cabang',
  `addr` varchar(200) NOT NULL COMMENT 'Alamat Cabang',
  `telephone` int(15) NOT NULL COMMENT 'No Telp Cabang',
  `nmpengirim` varchar(15) NOT NULL COMMENT 'Nama Pengirim',
  `jabatanpngirim` varchar(15) NOT NULL COMMENT 'Jabatan Pengirim',
  `jmlkemasan` varchar(15) NOT NULL COMMENT 'Jumlah Kemasan',
  `nmteknik` varchar(15) NOT NULL COMMENT 'Nama Teknik',
  `krkterlimbah` varchar(15) NOT NULL COMMENT 'Karakter Limbah',
  `jnslimbah` varchar(15) NOT NULL COMMENT 'Jenis Limbah',
  `kdlimbah` varchar(15) NOT NULL COMMENT 'Kode Limbah',
  `voldikirim` int(15) NOT NULL COMMENT 'Volume Dikirim',
  `noisotank` varchar(15) NOT NULL COMMENT 'No. ISO TANK',
  `keterangan` varchar(100) NOT NULL COMMENT 'Keterangan',
  `nmsupir` varchar(20) NOT NULL COMMENT 'Nama Driver',
  `hpsupir` int(15) NOT NULL COMMENT 'HP Driver',
  `jabatansupir` varchar(15) NOT NULL COMMENT 'Jabatan Penerima',
  `nopolisi` varchar(15) NOT NULL COMMENT 'No Polisi',
  `typekendaraan` varchar(15) NOT NULL COMMENT 'Type Kendaraan',
  `penerima` varchar(30) NOT NULL COMMENT 'Nama Penerima / Perusahaan',
  `jabatanpenerima` varchar(15) NOT NULL COMMENT 'Jabatan Penerima',
  `nmpenerima` varchar(20) NOT NULL COMMENT 'Nama Penerima',
  `tlppenerima` int(15) NOT NULL COMMENT 'No Telephone Penerima',
  `faxpenerima` int(15) NOT NULL COMMENT 'No Fax Penerima',
  PRIMARY KEY (`idmnfst`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `m_manifest`
--


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

--
-- Table structure for table `m_notgrp`
--

CREATE TABLE IF NOT EXISTS `m_notgrp` (
  `idnotgrp` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Notification group ID',
  `desc` varchar(100) DEFAULT NULL,
  `subject` varchar(100) NOT NULL COMMENT 'Subject',
  `msg` text NOT NULL COMMENT 'Notification message',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `chdate` datetime DEFAULT NULL COMMENT 'Tanggal ganti',
  `chby` varchar(10) DEFAULT NULL COMMENT 'Diubah oleh',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  PRIMARY KEY (`idnotgrp`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Table master email notification group' AUTO_INCREMENT=12 ;

--
-- Dumping data for table `m_notgrp`
--

INSERT INTO `m_notgrp` (`idnotgrp`, `desc`, `subject`, `msg`, `adddate`, `chdate`, `chby`, `addby`) VALUES
(5, 'Test Notification', 'Test Notification (Do Not Reply)', 'Hi $1, this is just testing notification message.\r\n\r\nBy $2.', '2013-02-11 15:32:12', '2013-02-13 08:57:49', 'imam', 'imam'),
(6, 'Test Notification 2', 'This is just testing message', 'Hi $1,\r\n\r\n\r\n\r\nBy $2', '2013-02-12 16:26:50', NULL, NULL, 'imam'),
(7, 'CPV Notification Mgr', 'CPV Notification', 'CPV No. $1 has been created ​​by $2, please check the RLIS system for approval.\n\nTransfer To : $3\nAmount      : Rp. $4\nDescription : $5\n\nNote: Please do not reply this message.\n\nRegards,\n\n\nSystem Administrator', '2013-04-03 11:22:41', '2013-04-03 14:29:51', 'imam', 'imam'),
(8, 'CPV Notification Approved', 'CPV Approved Notification ', 'CPV No. $1 has been approved ​​by $2, please check the RLIS system.\n\nTransfer To : $3\nAmount      : Rp. $4\nDescription : $5\n\nNote: Please do not reply this message.\n\nRegards,\n\n\nSystem Administrator', '2013-04-03 14:29:14', '2013-04-03 14:29:57', 'imam', 'imam'),
(9, 'CPV Notification Rejected', 'CPV Rejected Notification', 'CPV No. $1 has been rejected ​​by $2, please check the RLIS system.\n\nTransfer To : $3\nAmount      : Rp. $4\nDescription : $5\nRejected reason : $6\n\nNote: Please do not reply this message.\n\nRegards,\n\n\nSystem Administrator', '2013-04-03 14:29:34', '2013-04-03 14:30:05', 'imam', 'imam'),
(10, 'CPV MIRO', 'CPV Ready To Create From MIRO', 'MIRO No. $1 has been created ​​by $2, please check the RLIS system.\r\n\r\nNo. PO       : $3\r\nQty          : $4 L\r\nRounding Disc: Rp. $6\r\nTotal Amount : Rp. $5\r\n\r\nNote: Please do not reply this message.\r\n\r\nRegards,\r\n\r\n\r\nSystem Administrator', '2013-04-03 15:23:03', '2013-05-15 10:43:38', 'imam', 'imam'),
(11, 'MIRO Accounting', 'MIGO Notification', 'MIGO No. $1 has been created ​​by $2, please check the RLIS system.\r\n\r\nNo. PO       : $3\r\nQty          : $4 L\r\nRounding Disc: Rp. $6\r\nPPN          : Rp. $7\r\nTotal Amount : Rp. $5\r\n\r\nNote: Please do not reply this message.\r\n\r\nRegards,\r\n\r\n\r\nSystem Administrator', '2013-04-04 10:58:05', '2013-05-15 16:00:39', 'imam', 'imam');

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

--
-- Table structure for table `m_op`
--

CREATE TABLE IF NOT EXISTS `m_op` (
  `idop` int(11) NOT NULL AUTO_INCREMENT,
  `c_amt_bapi` int(20) NOT NULL COMMENT 'Harga per liter saat transaksi',
  `opnumb` varchar(20) NOT NULL COMMENT 'No. OP',
  `prnumb` varchar(20) NOT NULL COMMENT 'No. PR',
  `type` varchar(15) NOT NULL COMMENT 'Type Penjual',
  `invoice` varchar(10) NOT NULL COMMENT 'no kwitansi',
  `idsupp` int(5) NOT NULL COMMENT 'ID Supplier',
  `idtrans` int(5) NOT NULL COMMENT 'ID Transporter',
  `vol` int(10) NOT NULL COMMENT 'Volume Pembelian',
  `vnumb` varchar(10) NOT NULL COMMENT 'No Polisi Kendaraan',
  `total` double NOT NULL COMMENT 'Total Biaya',
  `pur` int(30) NOT NULL,
  `fee` int(30) NOT NULL,
  `donumb` varchar(20) NOT NULL COMMENT 'No Surat Jalan',
  `mnfst` varchar(20) NOT NULL COMMENT 'No Manifest',
  `inf` varchar(200) NOT NULL COMMENT 'Keterangan',
  `ambil` int(1) NOT NULL COMMENT 'Ambil dari PC = 1 atau SALDO BANK = 2',
  `nocpvform` varchar(100) DEFAULT NULL COMMENT 'Jika ambil dari bank NO. CPV nya diinput',
  `tax` int(1) NOT NULL COMMENT '0 = Non PPN, 1 = PPN',
  `chdate` date NOT NULL COMMENT 'Tanggal Edit',
  `adddate` datetime NOT NULL COMMENT 'Tanggal Input',
  `addby` varchar(20) NOT NULL COMMENT 'Di input oleh',
  `chby` varchar(20) NOT NULL COMMENT 'Di Edit Oleh',
  `year` year(4) NOT NULL COMMENT 'Tahun',
  `idcab` int(10) NOT NULL COMMENT 'ID cabang',
  `quantity` int(10) NOT NULL COMMENT 'Quantity PR',
  `cancel` int(11) NOT NULL COMMENT 'Cancel = 1',
  `closed` int(11) NOT NULL COMMENT 'Closed 1, Available 0',
  PRIMARY KEY (`idop`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

--
-- Dumping data for table `m_op`
--

INSERT INTO `m_op` (`idop`, `c_amt_bapi`, `opnumb`, `prnumb`, `type`, `invoice`, `idsupp`, `idtrans`, `vol`, `vnumb`, `total`, `pur`, `fee`, `donumb`, `mnfst`, `inf`, `ambil`, `nocpvform`, `tax`, `chdate`, `adddate`, `addby`, `chby`, `year`, `idcab`, `quantity`, `cancel`, `closed`) VALUES
(1, 3000, 'OP/18/05/13/3', '9800000011', 'Sumber', 'xxxxxxxxxx', 1, 1, 5000, 'B 1234 NN', 48000000, 10000000, 0, 'xxxxxxxxxx', 'xxxxxxxxxxx', 'xxxxx', 0, '', 0, '0000-00-00', '2013-05-14 15:22:34', 'dini', '0', 2013, 3, 16000, 0, 0),
(2, 3000, 'OP/19/05/13/3', '9800000011', 'Sumber', 'xxxxxxxxxx', 1, 2, 10000, 'B 7777 IT', 48000000, 11000000, 0, 'xxxxxxxxxxx', 'xxxxxxxxxxx', '', 0, '', 0, '0000-00-00', '2013-05-14 15:23:33', 'dini', '0', 2013, 3, 16000, 0, 0),
(3, 3000, 'OP/20/05/13/3', '9800000011', '0', 'xxxxxxxxxx', 0, 0, 0, '0', 48000000, 0, 475000, '0', '0', 'Biaya security', 0, '', 0, '0000-00-00', '2013-05-14 15:24:13', 'dini', '0', 2013, 3, 16000, 0, 0),
(4, 1000, 'OP/21/05/13/3', '9800000012', 'Sumber', 'xxxxxxxxxx', 1, 1, 5500, 'B 1234 NN', 16000000, 5000000, 0, 'xxxxxxxxxxx', 'xxxxxxxxx', '', 0, '', 0, '0000-00-00', '2013-05-14 15:40:48', 'dini', '0', 2013, 3, 16000, 0, 0),
(5, 1000, 'OP/23/05/13/3', '9800000012', '0', 'xxxxxxxxxx', 0, 0, 0, '0', 16000000, 0, 350000, '0', '0', 'xxxxxxx', 0, '', 0, '0000-00-00', '2013-05-14 15:41:43', 'dini', '0', 2013, 3, 16000, 0, 0),
(7, 3000, 'OP/26/05/13/3', '9800000013', 'Sumber', 'xxxxxxxxxx', 1, 1, 16000, 'B 1234 NN', 48000000, 10000000, 0, 'xxxxxxxxxxx', 'xxxxxxxxxx', 'Test', 1, NULL, 0, '0000-00-00', '2013-05-15 10:02:45', 'dini', '0', 2013, 3, 16000, 0, 0),
(8, 3000, 'OP/27/05/13/3', '9800000013', '0', 'xxxxxxxxx', 0, 0, 0, '0', 48000000, 0, 500000, '0', '0', 'Test', 0, NULL, 0, '0000-00-00', '2013-05-15 10:12:19', 'dini', '0', 2013, 3, 16000, 0, 0),
(9, 3000, 'OP/28/05/13/3', '9800000014', 'Sumber', 'xxxxxxxxxx', 1, 1, 5000, 'B 1234 NN', 48000000, 1000000, 0, 'xxxxxxxxx', 'xxxxxxxxxxxx', 'xxxxxxxx', 1, NULL, 0, '0000-00-00', '2013-05-15 10:41:14', 'dini', '0', 2013, 3, 16000, 0, 0),
(10, 3000, 'OP/29/05/13/3', '9800000015', 'Sumber', 'xxxxxxxx', 1, 2, 10000, 'B 7777 IT', 48000000, 10000000, 0, 'xxxxxx', 'xxxxxxxxxx', 'Test', 1, NULL, 0, '0000-00-00', '2013-05-15 12:43:13', 'dini', '0', 2013, 3, 16000, 0, 0),
(14, 3000, 'OP/33/05/13/3', '9800000016', 'Sumber', 'xxxxxxxxx', 30200, 1, 13500, 'B 1234 NN', 48000000, 11000000, 0, 'xxxxx', 'xxxxxx', 'Test', 1, NULL, 0, '0000-00-00', '2013-05-15 15:33:42', 'dini', '0', 2013, 3, 16000, 0, 0),
(15, 3000, 'OP/34/05/13/3', '9800000017', 'Sumber', 'xxxxxxxxxx', 30000, 2, 13500, 'B 7777 IT', 48000000, 11000000, 0, 'xxxxxxxxxx', 'xxxxxxxxxxx', 'xxxx', 1, NULL, 0, '0000-00-00', '2013-05-15 15:46:45', 'dini', '0', 2013, 3, 16000, 0, 0),
(16, 3200, 'OP/35/05/13/3', '9800000018', 'Sumber', 'xxxxxxxxxx', 30002, 1, 13500, 'B 1234 NN', 51200000, 11000000, 0, 'xxxxxxxxx', 'xxxxxxxxxxxx', 'xxxxx', 1, NULL, 0, '0000-00-00', '2013-05-15 16:06:49', 'dini', '0', 2013, 3, 16000, 0, 0),
(17, 3000, 'OP/36/05/13/3', '9800000019', 'Sumber', 'xxxxxxxxxx', 30200, 1, 13500, 'B 1234 NN', 48000000, 11000000, 0, 'xxxxxxxx', 'xxxxxxxx', 'Test', 1, NULL, 0, '0000-00-00', '2013-05-15 17:15:41', 'dini', '0', 2013, 3, 16000, 0, 0),
(18, 3000, 'OP/37/05/13/3', '9800000020', 'Sumber', 'xxxxxxxxxx', 30200, 1, 13500, 'B 1234 NN', 48000000, 11000000, 0, 'xxxxxx', 'xxxxxxxxxxx', 'Test', 1, NULL, 0, '0000-00-00', '2013-05-15 17:21:44', 'dini', '0', 2013, 3, 16000, 0, 0),
(19, 3000, 'OP/38/05/13/3', '9800000021', 'Sumber', 'xxxxxxxxxx', 30200, 1, 16000, 'B 1234 NN', 48000000, 11000000, 0, '11111111111111', '111111111111111', 'Test', 1, NULL, 0, '0000-00-00', '2013-05-15 17:23:59', 'dini', '0', 2013, 3, 16000, 0, 0);

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

--
-- Table structure for table `m_pc_trans`
--

CREATE TABLE IF NOT EXISTS `m_pc_trans` (
  `idpctrans` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID petty cash transaction',
  `desc` varchar(100) DEFAULT NULL,
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `chdate` datetime DEFAULT NULL COMMENT 'Tanggal ganti',
  `chby` varchar(10) DEFAULT NULL COMMENT 'Diubah oleh',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  PRIMARY KEY (`idpctrans`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Table master petty cash transaction type' AUTO_INCREMENT=4 ;

--
-- Dumping data for table `m_pc_trans`
--

INSERT INTO `m_pc_trans` (`idpctrans`, `desc`, `adddate`, `chdate`, `chby`, `addby`) VALUES
(1, 'Direct Transfer', '2013-02-25 09:11:29', NULL, NULL, 'imam'),
(2, 'Trans From MIRO', '2013-02-25 09:12:06', NULL, NULL, 'imam'),
(3, 'PC OP Rembuirsement', '2013-04-29 13:43:20', NULL, NULL, 'imam');

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

--
-- Table structure for table `m_pc_typ`
--

CREATE TABLE IF NOT EXISTS `m_pc_typ` (
  `idpctyp` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID Petty Cash Type',
  `max_trans_amt` double NOT NULL COMMENT 'Nilai maksimal yang ditransfer',
  `desc` varchar(100) DEFAULT NULL,
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `chdate` datetime DEFAULT NULL COMMENT 'Tanggal ganti',
  `chby` varchar(10) DEFAULT NULL COMMENT 'Diubah oleh',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  PRIMARY KEY (`idpctyp`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Table master petty cash type' AUTO_INCREMENT=3 ;

--
-- Dumping data for table `m_pc_typ`
--

INSERT INTO `m_pc_typ` (`idpctyp`, `max_trans_amt`, `desc`, `adddate`, `chdate`, `chby`, `addby`) VALUES
(0, 100000000000000, 'Petty Cash', '2013-04-26 08:55:58', NULL, NULL, 'imam'),
(1, 150000000, 'Petty Cash Used Oil', '2013-02-25 09:13:00', NULL, NULL, 'imam'),
(2, 5000000, 'Petty Cash Operational', '2013-04-10 10:25:15', NULL, NULL, 'Imam');

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

--
-- Table structure for table `m_supp`
--

CREATE TABLE IF NOT EXISTS `m_supp` (
  `idsupp` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID Supplier',
  `suppname` varchar(50) NOT NULL COMMENT 'Nama Supplier',
  `idcab` int(11) NOT NULL COMMENT 'ID Cabang',
  `addr` text COMMENT 'Alamat supplier',
  `city` varchar(50) DEFAULT NULL COMMENT 'Kota',
  `prov` varchar(50) DEFAULT NULL COMMENT 'Propinsi',
  `pic` varchar(50) DEFAULT NULL COMMENT 'PIC',
  `phone` char(20) DEFAULT NULL COMMENT 'No. telp',
  `fax` char(20) DEFAULT NULL COMMENT 'No. Fax',
  `noijin` varchar(50) DEFAULT NULL COMMENT 'No. ijin supplier',
  `status` int(11) DEFAULT NULL COMMENT 'Status aktive. 0 :Tidak aktive, 1: aktive',
  `idgroup` int(11) DEFAULT NULL COMMENT 'Kategori group supplier',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `chdate` datetime DEFAULT NULL COMMENT 'Tanggal ganti',
  `chby` varchar(10) DEFAULT NULL COMMENT 'Diubah oleh',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  `codevendor` varchar(20) NOT NULL COMMENT 'Kode Vendor di SAP',
  PRIMARY KEY (`idsupp`,`idcab`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Table supplier' AUTO_INCREMENT=4 ;

--
-- Dumping data for table `m_supp`
--

INSERT INTO `m_supp` (`idsupp`, `suppname`, `idcab`, `addr`, `city`, `prov`, `pic`, `phone`, `fax`, `noijin`, `status`, `idgroup`, `adddate`, `chdate`, `chby`, `addby`, `codevendor`) VALUES
(1, 'Supplier 1', 3, 'Jl Supplier 1 no 32', 'Jakarta', 'DKI Jakarta', 'Imam', '647364758', '94857603', 'Ijin 123456', 1, NULL, '2013-04-16 09:30:36', '0000-00-00 00:00:00', '0', 'test', 'SAP Vendor'),
(3, 'Supplier 2', 3, 'Jl. Rusak Bolong - Bolong no 3', 'Bekasi', 'Jawa Barat', 'Rony A', '23445', '34563546', '3456234', 1, NULL, '2013-04-26 10:18:18', '0000-00-00 00:00:00', '0', 'dini', 'SAP');

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

--
-- Table structure for table `m_suppgrp`
--

CREATE TABLE IF NOT EXISTS `m_suppgrp` (
  `idgroup` int(11) NOT NULL AUTO_INCREMENT,
  `desc` varchar(50) DEFAULT NULL,
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `chdate` datetime DEFAULT NULL COMMENT 'Tanggal ganti',
  `chby` varchar(10) DEFAULT NULL COMMENT 'Diubah oleh',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  PRIMARY KEY (`idgroup`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Table master group supplier' AUTO_INCREMENT=3 ;

--
-- Dumping data for table `m_suppgrp`
--

INSERT INTO `m_suppgrp` (`idgroup`, `desc`, `adddate`, `chdate`, `chby`, `addby`) VALUES
(2, 'SUPPLIER DGN IZIN', '2013-02-05 14:39:54', '2013-02-12 16:46:01', 'imam', 'imam');

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

--
-- Table structure for table `m_supptype`
--

CREATE TABLE IF NOT EXISTS `m_supptype` (
  `idtype` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID Type Supplier',
  `type` varchar(10) NOT NULL COMMENT 'Type Supplier',
  `info` varchar(200) NOT NULL COMMENT 'Info Type',
  `limit` int(20) NOT NULL COMMENT 'Limit Pembelian Oli',
  `active` int(11) NOT NULL COMMENT 'Status active / inactive',
  PRIMARY KEY (`idtype`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `m_supptype`
--

INSERT INTO `m_supptype` (`idtype`, `type`, `info`, `limit`, `active`) VALUES
(1, 'Corporate', 'Mempunyai Ijin', 0, 1),
(2, 'Collector', 'Tidak mempunyai ijin dan bisa menjual banyak', 0, 1),
(3, 'Other', 'Pengoser dan tidak mempunyai ijin', 3000, 1);

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

--
-- Table structure for table `m_transport`
--

CREATE TABLE IF NOT EXISTS `m_transport` (
  `idtrans` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID Transporter',
  `idcab` int(11) NOT NULL COMMENT 'ID Cabang',
  `name` varchar(100) DEFAULT NULL COMMENT 'Nama transporter',
  `addr` text COMMENT 'Alamat transporter',
  `vnumb` varchar(10) NOT NULL,
  `mbrekomklh` date NOT NULL,
  `mbijindarat` date NOT NULL,
  `mbstnk` date NOT NULL,
  `mbpajak` date NOT NULL,
  `mbkir` date NOT NULL,
  `fax` int(12) NOT NULL COMMENT 'Fax',
  `city` varchar(20) NOT NULL COMMENT 'Kota',
  `phone` char(20) DEFAULT NULL COMMENT 'No. telp transporter',
  `pic` varchar(50) DEFAULT NULL COMMENT 'PIC Transporter',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `chdate` datetime DEFAULT NULL COMMENT 'Tanggal ganti',
  `chby` varchar(10) DEFAULT NULL COMMENT 'Diubah oleh',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  `status` int(11) NOT NULL COMMENT 'Status wgi : 1, luar : 0',
  `prov` varchar(20) NOT NULL COMMENT 'Province',
  PRIMARY KEY (`idtrans`,`idcab`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Table master transpoter' AUTO_INCREMENT=3 ;

--
-- Dumping data for table `m_transport`
--

INSERT INTO `m_transport` (`idtrans`, `idcab`, `name`, `addr`, `vnumb`, `mbrekomklh`, `mbijindarat`, `mbstnk`, `mbpajak`, `mbkir`, `fax`, `city`, `phone`, `pic`, `adddate`, `chdate`, `chby`, `addby`, `status`, `prov`) VALUES
(1, 3, 'Transporter 1', 'Jl. Sedang Bingung 1 no 66', 'B 1234 NN', '2006-04-20', '2009-04-20', '2009-04-20', '2007-04-20', '2007-04-20', 2147483647, 'Jakarta', '923274954724', 'Willy FR', '2013-04-16 09:33:10', NULL, NULL, 'test', 1, 'DKI Jakarta'),
(2, 3, 'Transporter 2', 'Jl. Lemah Gemulai 1000 no 100', 'B 7777 IT', '2018-04-20', '2011-04-20', '2024-04-20', '2025-04-20', '2024-04-20', 4567634, 'Bekasi', '345665', 'Willy', '2013-04-26 15:43:36', NULL, NULL, 'dini', 1, 'Jawa Barat');

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

--
-- Table structure for table `notgrp_member`
--

CREATE TABLE IF NOT EXISTS `notgrp_member` (
  `idnotgrp` int(11) DEFAULT NULL COMMENT 'Notification group ID',
  `notgrp_uid` varchar(10) DEFAULT NULL COMMENT 'Notification group member',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table email notification group';

--
-- Dumping data for table `notgrp_member`
--

INSERT INTO `notgrp_member` (`idnotgrp`, `notgrp_uid`, `adddate`, `addby`) VALUES
(6, 'imam', '2013-02-12 16:26:50', 'imam'),
(6, 'roberthus', '2013-02-12 16:26:50', 'imam'),
(6, 'test', '2013-02-12 16:26:50', 'imam'),
(5, 'imam', '2013-02-13 08:57:49', 'imam'),
(7, 'imam', '2013-04-03 14:29:51', 'imam'),
(7, 'roberthus', '2013-04-03 14:29:51', 'imam'),
(8, 'imam', '2013-04-03 14:29:57', 'imam'),
(8, 'roberthus', '2013-04-03 14:29:57', 'imam'),
(9, 'imam', '2013-04-03 14:30:05', 'imam'),
(9, 'roberthus', '2013-04-03 14:30:05', 'imam'),
(10, 'imam', '2013-05-15 10:43:38', 'imam'),
(10, 'roberthus', '2013-05-15 10:43:38', 'imam'),
(11, 'imam', '2013-05-15 16:00:39', 'imam'),
(11, 'roberthus', '2013-05-15 16:00:39', 'imam');

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

--
-- Table structure for table `rlis_sessions`
--

CREATE TABLE IF NOT EXISTS `rlis_sessions` (
  `session_id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(45) NOT NULL DEFAULT '0',
  `user_agent` varchar(120) NOT NULL,
  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
  `user_data` text NOT NULL,
  PRIMARY KEY (`session_id`),
  KEY `last_activity_idx` (`last_activity`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rlis_sessions`
--

INSERT INTO `rlis_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
('b49a04a93adcdf9dcec21d9d1b73b508', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1362716673, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('c33fd3782aa8812951a96c6c931ef7e1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1362561425, 'a:19:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:12:"sess_segment";s:15:"admin_list_menu";}'),
('5546b33330bfeaed48f6dd1f323d5f10', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1362642900, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('1c455957f15e2b23891a33407a0b439a', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1362965879, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('d77359137bb4583339896f6195f4092f', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1362990692, 'a:19:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:12:"sess_segment";s:15:"admin_list_menu";}'),
('c3321f9d4b4691d1fed7e6e2e0c4e645', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363139137, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('dbf14005712904fbf0cdced4545fbf4b', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363166332, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('e2b1f42f1f1232814c8aeeebcd8f0f57', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363859429, 'a:19:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:12:"sess_segment";s:15:"admin_list_menu";}'),
('f673980b2c92fdc04d59565d099c7853', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363340655, 'a:23:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:14:"txt_cari_trans";s:2:"15";s:13:"txt_opt_trans";s:7:"idtrans";s:16:"cb_cari_supplier";s:6:"idsupp";s:8:"txt_cari";s:1:"o";s:7:"txt_opt";s:8:"suppname";}'),
('ac1fc348de6118929be77d70512cb28a', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363595495, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('d3de83810ea8ea848ba438570c35af3c', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363832699, 'a:19:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:12:"sess_segment";s:15:"admin_list_menu";}'),
('0fd1275b9d4fad5f45a4f94f2a9f1756', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363851064, 'a:21:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30013";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:10:"sap_pr_num";s:10:"9800000013";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";}'),
('a47e893f2f8004747bfba96cf4d34413', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363859060, 'a:19:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:12:"sess_segment";s:15:"admin_list_menu";}'),
('0d90cbbd02f0dcae4a44985722b6ddc0', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363859063, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:old:message_err";s:28:"Please login to enter system";}'),
('ace6f9716f03d168cca063ed2d81d979', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363874579, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('e11a117d8338108ee98d6a915f2d9abe', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363944903, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('91bad7eb97ae1d56459d7bf3669bdebf', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1363939975, 'a:24:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:6:"idsupp";s:0:"";s:7:"preq_no";s:0:"";s:7:"txt_opt";s:6:"idsupp";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";}'),
('5914060af40f91a1c2ca319eae348906', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364208375, 'a:21:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";s:7:"txt_opt";s:6:"idsupp";}'),
('cc1b96140612a57aab2ab4fd5b24bc37', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364177556, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('41f8dc3423aa85aa96c26af7a4775f3b', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364224093, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('e7475059a72b0fcfce0574759348396d', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364237783, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('0e0588120e129637bf32c6a4bccd7604', '192.168.100.122', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1364447009, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:old:message_err";s:28:"Please login to enter system";}'),
('e2e0fabab03fe66033406a35c3d0bada', '192.168.100.122', 'Microsoft-WebDAV-MiniRedir/6.1.7601', 1364447012, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('64fb0425461fa7a1807bbbf8c14e5ea2', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364268912, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30013";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('41d653007791b4f9ca94e52631009dcc', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364289973, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('e38b2785e24b5d5b2e2b8808cd9718f8', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364357488, 'a:21:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";s:12:"sess_segment";s:15:"admin_list_menu";}'),
('0f01dfa1a51fc525ef3c2dc67f809d5a', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364369971, ''),
('4c19491e828bf5bfde4fd082819b629a', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364377796, 'a:25:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";s:12:"sess_segment";s:15:"admin_list_menu";s:7:"txt_opt";s:6:"idsupp";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";s:20:"flash:old:message_ok";s:10:"Data saved";}'),
('f12eaa26b896663dc870e032cbf546a2', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.43 Safari/537.31', 1364895955, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('20bc391186377748d37d7c68f081f674', '192.168.100.122', 'Microsoft-WebDAV-MiniRedir/6.1.7601', 1364447005, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('fb09652fa545cb8949020b57219683ef', '192.168.100.122', 'Microsoft-WebDAV-MiniRedir/6.1.7601', 1364447019, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('264a380ad63b7cb913f1b0a3461b9087', '192.168.100.122', 'Microsoft-WebDAV-MiniRedir/6.1.7601', 1364447026, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('37886a769278958be35196aca3e67ae5', '192.168.100.122', 'Microsoft-WebDAV-MiniRedir/6.1.7601', 1364447033, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('d9da86c870625af02c5c614386a08dfe', '192.168.100.122', 'Microsoft-WebDAV-MiniRedir/6.1.7601', 1364447041, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('4ee3fcf86186647add212da904bf2e67', '192.168.100.122', 'Microsoft-WebDAV-MiniRedir/6.1.7601', 1364447048, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('c0eed93e210f53f847c2aed28b0dfaef', '192.168.100.122', 'Microsoft-WebDAV-MiniRedir/6.1.7601', 1364447055, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('f0e5b47f9226a7e12958e896e383e3d0', '192.168.100.122', 'Microsoft-WebDAV-MiniRedir/6.1.7601', 1364447062, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('59ee47850845c175c03c5caa4f420075', '192.168.100.122', 'Microsoft-WebDAV-MiniRedir/6.1.7601', 1364447069, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('c5df41495c568a63e39cd5b79bcfd330', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1364643329, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"imam";s:5:"login";b:1;s:8:"dispname";s:11:"Imam Wiguna";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('7835ba1c232843965d6d5715afee7c8d', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1364645242, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:7:"yuswati";s:5:"login";b:1;s:8:"dispname";s:7:"Yuswati";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"14";s:8:"rolename";s:15:"Finance Manager";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('b44eb38f51ca8242d93a46b7008433cd', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364779799, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('b1d4174abab2c1cc2dd822399f8377da', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364818901, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('b2ade10d4baa57e0e693bf3e99e8defc', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364878156, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('b8385bf0029024260789a415ddb0d530', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364890044, 'a:21:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";s:12:"sess_segment";s:15:"admin_list_menu";}'),
('78a59da1b11496960fcd0f7b156cf313', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.43 Safari/537.31', 1364893975, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('c1b425ba08c610e15cf7d9e26eb36d6d', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364962355, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:old:message_err";s:28:"Please login to enter system";}'),
('096b6a4946560b5daaf9af6dafcce436', '222.165.222.139', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.43 Safari/537.31', 1365389771, ''),
('210cee7830f5ac0a7b216496d09c379b', '222.165.222.139', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1364982686, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('d1a96eecd1fef6c659e0dd70d9a61308', '222.165.222.139', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.43 Safari/537.31', 1365045320, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('fb8fc3223400d0a2703352d9f7cd4579', '222.165.222.138', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1364963127, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('ab4ee2c7dd3c1a26b5c5978ccae4fc95', '222.165.222.138', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.43 Safari/537.31', 1364975281, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('bef030ac5a3a6b549ad513382629e1ff', '222.165.222.139', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1365058273, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"imam";s:5:"login";b:1;s:8:"dispname";s:11:"Imam Wiguna";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('4efada127818774adfeb1610f5e084e4', '222.165.222.139', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1365154653, 'a:21:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"imam";s:5:"login";b:1;s:8:"dispname";s:11:"Imam Wiguna";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:12:"sess_segment";s:15:"admin_list_menu";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('e8af745207e547a46340069a3a48c3bf', '222.165.222.138', 'Mozilla/5.0 (Windows NT 6.1; rv:18.0) Gecko/20100101 Firefox/18.0', 1365132511, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:old:message_err";s:28:"Please login to enter system";}'),
('dd9ad72aa64937e5ed614048e7e77f5c', '222.165.222.138', 'Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; GTB7.4; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .', 1365134443, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:old:message_err";s:28:"Please login to enter system";}'),
('26315f21c7d5fb05ce69d783eedf8c85', '222.165.222.138', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1365154593, 'a:21:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";s:12:"sap_migo_num";s:10:"5000121406";}'),
('5939db9b030efe5752716cbe0fc170c3', '222.165.222.139', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.43 Safari/537.31', 1365389771, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('8cb8f958184f8f2e8d24b7391c3218e7', '222.165.222.139', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.43 Safari/537.31', 1365405629, ''),
('541c55479f5b696d493141ed3d0e50bf', '222.165.222.139', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.43 Safari/537.31', 1365418879, 'a:19:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:20:"flash:old:message_ok";s:12:"Data changed";}'),
('a81bbcaa0b8cd6652d5f9103a43cdff3', '222.165.222.139', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1365413170, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('6b3a9c8817303dc9f26621ed52c90cc1', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1365453810, 'a:19:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:20:"flash:old:message_ok";s:12:"Data changed";}'),
('4308cbf946e3d07be814283a7d7a6a4b', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.43 Safari/537.31', 1365471130, 'a:19:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:20:"flash:old:message_ok";s:12:"Data changed";}'),
('433e08381d321c7377d1bd4fe24db49c', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.43 Safari/537.31', 1365477187, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"imam";s:5:"login";b:1;s:8:"dispname";s:11:"Imam Wiguna";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('c05740498c6fa0f363770fe82188ebad', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1365734877, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";}'),
('d25d49a5557ff07f88cb829cf94e980b', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366033520, 'a:23:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";s:7:"txt_opt";s:6:"idsupp";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";}'),
('3c36496b1d0a7f889b914e6f513a142d', '222.165.222.138', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366104761, ''),
('e3de12da4ef6b92d04951150b1b15ef8', '222.165.222.138', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.64 Safari/537.31', 1366080315, 'a:25:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:11:"sap_obj_key";s:18:"0100000078WGI12013";s:10:"sap_pr_num";s:10:"9800000050";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";s:7:"txt_opt";s:6:"idsupp";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";}'),
('0e39b64a2bc727affb71824ddeb52007', '222.165.222.138', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366104761, 'a:19:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:12:"sess_segment";s:15:"admin_list_menu";}'),
('5a2dc1631fd6c764a117e4d1e576a2c3', '222.165.222.138', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366104806, ''),
('dbac921a56c8e1e25fcced6258bcf323', '222.165.222.138', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366178952, 'a:24:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:2:"99";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:12:"sess_segment";s:15:"admin_list_menu";s:8:"txt_cari";s:0:"";s:7:"txt_opt";s:6:"idsupp";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";s:20:"flash:old:message_ok";s:23:"Data succesfully update";}'),
('737cf92553eaf1296e4380d22db005c2', '222.165.222.139', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1366189092, 'a:28:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:11:"sap_obj_key";s:18:"0100000084WGI12013";s:9:"bpkk_item";a:2:{i:0;a:4:{s:10:"txt_uraian";s:15:"Biaya Klaim BBM";s:5:"cb_gl";s:7:"5229004";s:10:"cb_gl_desc";s:3:"BBM";s:6:"jumlah";s:12:"1.000.000,00";}i:1;a:4:{s:10:"txt_uraian";s:19:"Biaya Klaim Hiburan";s:5:"cb_gl";s:7:"5223001";s:10:"cb_gl_desc";s:10:"ENTERTAINT";s:6:"jumlah";s:10:"500.000,00";}}s:10:"sap_pr_num";s:10:"9800000053";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";s:7:"txt_opt";s:6:"idsupp";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";s:10:"sap_po_num";s:10:"9900000042";s:12:"sap_migo_num";s:10:"5000121413";}'),
('d741a2f67811db38ca97462044609060', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366259589, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:6:"Achmad";s:5:"login";b:1;s:8:"dispname";s:6:"Achmad";s:5:"idcab";s:1:"1";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"17";s:8:"rolename";s:14:"Branch Manager";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('76d52b6f280c3b86c28735f7b25a94df', '192.168.100.102', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366785730, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:6:"novika";s:5:"login";b:1;s:8:"dispname";s:6:"Novika";s:5:"idcab";s:1:"1";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"13";s:8:"rolename";s:13:"Finance Staff";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"0";s:6:"cancel";s:1:"0";}'),
('0bf2979453a71df750ca5475a523b8eb', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366362256, 'a:22:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"3";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:11:"sap_obj_key";s:18:"0100000086WGI12013";s:10:"sap_pr_num";s:10:"9800000054";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('a827c0ae54e87f457846b16baf6d903c', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366598883, 'a:27:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"test";s:5:"login";b:1;s:8:"dispname";s:4:"Rony";s:5:"idcab";s:1:"3";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";s:7:"txt_opt";s:6:"idsupp";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";s:11:"sap_obj_key";s:18:"0100000092WGI12013";s:10:"sap_pr_num";s:10:"9800000059";s:10:"sap_po_num";s:10:"9900000047";s:12:"sap_migo_num";s:10:"5000121418";}'),
('d1100f0707e1b1392812d02be7b0756a', '192.168.100.143', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1366611962, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";}'),
('4eed8477d60c7b04400741c155aa328e', '192.168.100.107', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366706345, 'a:23:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";s:10:"sap_tp_num";s:10:"4900336397";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('9864e72edfb47f37eb1b63011ad7263c', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366769465, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('4c3902906c33eb58e5120eff30b7d9b7', '192.168.100.143', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1366621828, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:18:"Collecting Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('ae5a34f645307c10a01b8236ab81ce0b', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366791178, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('2cc6d4899e26d05f245e169af69f5e22', '192.168.100.96', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366880051, ''),
('36aa9f18c6c5517a0ff6f6172eb443f6', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1366915428, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('46ad236b6f36ad2683cb1da3c137fe8a', '192.168.100.132', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1367123236, 'a:19:{s:9:"user_data";s:0:"";s:3:"uid";s:6:"novika";s:5:"login";b:1;s:8:"dispname";s:6:"Novika";s:5:"idcab";s:1:"1";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"13";s:8:"rolename";s:13:"Finance Staff";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"0";s:6:"cancel";s:1:"0";s:21:"flash:old:message_err";s:46:"User ID or password is wrong, please try again";}'),
('c16294bebdde957858e354b306e5a9e9', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1367309035, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:old:message_err";s:28:"Please login to enter system";}'),
('89da3e105daec79cd9c13f512d6b4870', '192.168.100.109', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1366945812, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:25:"Refinery Logistic Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('64b5e241b4346b3aa783ad8165ca79d9', '192.168.99.41', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1367485194, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:25:"Refinery Logistic Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";}'),
('cea5a1efc3e4c525ad258558eb6cf591', '192.168.99.98', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1367399303, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:25:"Refinery Logistic Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('41746f2949037c5678d056be66a94425', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1367478072, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('1829464e9d857498a0f61eea60a77ab1', '192.168.100.121', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1367309337, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"imam";s:5:"login";b:1;s:8:"dispname";s:11:"Imam Wiguna";s:5:"idcab";s:1:"1";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:12:"sess_segment";s:15:"admin_list_role";s:20:"flash:old:message_ok";s:23:"Data update succesfully";}'),
('82ed93ee252dbdda07ecbed8097d344d', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1367489673, 'a:2:{s:9:"user_data";s:0:"";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('cf4d77c8c8c6d162169f413f2efb15f0', '192.168.100.153', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1367489674, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:25:"Refinery Logistic Bandung";s:5:"lifnr";s:5:"30156";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:4:"COL1";s:3:"pic";s:9:"Roberthus";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('265609357f4f1bdeba5e53b75af988ee', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1367985819, 'a:3:{s:9:"user_data";s:0:"";s:21:"flash:old:message_err";s:28:"Please login to enter system";s:21:"flash:new:message_err";s:28:"Please login to enter system";}'),
('b5b0ee1c9283e87fc63c882673e97983', '192.168.100.89', 'Mozilla/5.0 (Windows NT 6.1; rv:16.0) Gecko/20100101 Firefox/16.0', 1368408975, 'a:20:{s:9:"user_data";s:0:"";s:3:"uid";s:9:"roberthus";s:5:"login";b:1;s:8:"dispname";s:17:"Andreas Roberthus";s:5:"idcab";s:1:"1";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"11";s:8:"rolename";s:5:"ADMIN";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"0";s:12:"sess_segment";s:15:"admin_list_role";s:20:"flash:old:message_ok";s:23:"Data update succesfully";}'),
('2a3daf78d0ede2170a66b8a660b1d840', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1368435657, 'a:19:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:25:"Refinery Logistic Bandung";s:5:"lifnr";s:5:"30200";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:3:"BDG";s:3:"pic";s:6:"Achmad";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:11:"sap_obj_key";s:18:"0100004475WGI12013";}'),
('9c37b58e8864048b021f92dc3911c87b', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1368522763, 'a:21:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:25:"Refinery Logistic Bandung";s:5:"lifnr";s:5:"30200";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:3:"BDG";s:3:"pic";s:6:"Achmad";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";s:10:"sap_tp_num";s:10:"4900400497";}'),
('f203589bf4069a3b2590f28ea040cd07', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1368593668, 'a:25:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:25:"Refinery Logistic Bandung";s:5:"lifnr";s:5:"30200";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:3:"BDG";s:3:"pic";s:6:"Achmad";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:14:"txt_cari_trans";s:0:"";s:13:"txt_opt_trans";s:7:"idtrans";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";s:11:"sap_obj_key";s:18:"0100004482WGI12013";s:10:"sap_pr_num";s:10:"9800000016";s:7:"txt_opt";s:6:"idsupp";}'),
('f10925ed8418819c1ff94a0b529c0786', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:20.0) Gecko/20100101 Firefox/20.0', 1368589975, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:25:"Refinery Logistic Bandung";s:5:"lifnr";s:5:"30200";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:3:"BDG";s:3:"pic";s:6:"Achmad";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";}'),
('11331e7b9083a8c2ed3236538322364e', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1; rv:20.0) Gecko/20100101 Firefox/20.0', 1368593492, '');
INSERT INTO `rlis_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
('86c4060c9e00c87f0f834036b2d05291', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1368609975, 'a:23:{s:9:"user_data";s:0:"";s:3:"uid";s:4:"dini";s:5:"login";b:1;s:8:"dispname";s:4:"Dini";s:5:"idcab";s:1:"3";s:7:"namacab";s:25:"Refinery Logistic Bandung";s:5:"lifnr";s:5:"30200";s:8:"max_stor";s:5:"32000";s:5:"lgort";s:3:"BDG";s:3:"pic";s:6:"Achmad";s:6:"roleid";s:2:"12";s:8:"rolename";s:10:"PIC CABANG";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"1";s:6:"cancel";s:1:"1";s:8:"txt_cari";s:0:"";s:7:"preq_no";s:0:"";s:10:"sap_pr_num";s:10:"9800000021";s:10:"sap_po_num";s:10:"9900000013";s:12:"sap_migo_num";s:10:"5000155009";}'),
('a4c5753f405ecaf8f636210eeb9ebed4', '127.0.0.1', 'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.45 Safari/537.22', 1368669685, 'a:18:{s:9:"user_data";s:0:"";s:3:"uid";s:6:"novika";s:5:"login";b:1;s:8:"dispname";s:6:"Novika";s:5:"idcab";s:1:"1";s:7:"namacab";s:5:"PUSAT";s:5:"lifnr";s:5:"00000";s:8:"max_stor";s:5:"16000";s:5:"lgort";s:4:"0000";s:3:"pic";s:5:"PUSAT";s:6:"roleid";s:2:"13";s:8:"rolename";s:13:"Finance Staff";s:4:"view";s:1:"1";s:3:"add";s:1:"1";s:4:"edit";s:1:"1";s:6:"delete";s:1:"1";s:3:"app";s:1:"0";s:6:"cancel";s:1:"0";}');

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

--
-- Table structure for table `role_menu`
--

CREATE TABLE IF NOT EXISTS `role_menu` (
  `roleid` int(3) NOT NULL COMMENT 'Role ID',
  `mid` int(3) NOT NULL COMMENT 'Menu ID',
  `crby` varchar(10) NOT NULL COMMENT 'Dibuat oleh',
  `crdate` date NOT NULL COMMENT 'Tgl buat',
  `crtime` time NOT NULL COMMENT 'Jam buat',
  PRIMARY KEY (`roleid`,`mid`),
  KEY `mid` (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Menu role';

--
-- Dumping data for table `role_menu`
--

INSERT INTO `role_menu` (`roleid`, `mid`, `crby`, `crdate`, `crtime`) VALUES
(12, 25, 'roberthus', '2013-05-13', '09:35:49'),
(12, 26, 'roberthus', '2013-05-13', '09:35:49'),
(12, 44, 'roberthus', '2013-05-13', '09:35:49'),
(12, 45, 'roberthus', '2013-05-13', '09:35:49'),
(12, 46, 'roberthus', '2013-05-13', '09:35:49'),
(12, 47, 'roberthus', '2013-05-13', '09:35:49'),
(12, 48, 'roberthus', '2013-05-13', '09:35:49'),
(12, 49, 'roberthus', '2013-05-13', '09:35:49'),
(12, 50, 'roberthus', '2013-05-13', '09:35:49'),
(12, 54, 'roberthus', '2013-05-13', '09:35:49'),
(12, 55, 'roberthus', '2013-05-13', '09:35:49'),
(12, 56, 'roberthus', '2013-05-13', '09:35:49'),
(12, 57, 'roberthus', '2013-05-13', '09:35:49'),
(12, 59, 'roberthus', '2013-05-13', '09:35:49'),
(12, 60, 'roberthus', '2013-05-13', '09:35:49'),
(12, 61, 'roberthus', '2013-05-13', '09:35:49'),
(12, 62, 'roberthus', '2013-05-13', '09:35:49'),
(12, 76, 'roberthus', '2013-05-13', '09:35:49'),
(12, 77, 'roberthus', '2013-05-13', '09:35:49'),
(12, 78, 'roberthus', '2013-05-13', '09:35:49'),
(12, 79, 'roberthus', '2013-05-13', '09:35:49'),
(12, 80, 'roberthus', '2013-05-13', '09:35:49'),
(12, 81, 'roberthus', '2013-05-13', '09:35:49'),
(12, 82, 'roberthus', '2013-05-13', '09:35:49'),
(12, 83, 'roberthus', '2013-05-13', '09:35:49'),
(12, 85, 'roberthus', '2013-05-13', '09:35:49'),
(12, 86, 'roberthus', '2013-05-13', '09:35:49'),
(12, 87, 'roberthus', '2013-05-13', '09:35:49'),
(12, 88, 'roberthus', '2013-05-13', '09:35:49'),
(12, 90, 'roberthus', '2013-05-13', '09:35:49'),
(12, 91, 'roberthus', '2013-05-13', '09:35:49'),
(12, 92, 'roberthus', '2013-05-13', '09:35:49'),
(12, 93, 'roberthus', '2013-05-13', '09:35:49'),
(12, 100, 'roberthus', '2013-05-13', '09:35:49'),
(12, 101, 'roberthus', '2013-05-13', '09:35:49'),
(12, 102, 'roberthus', '2013-05-13', '09:35:49'),
(12, 103, 'roberthus', '2013-05-13', '09:35:49'),
(12, 104, 'roberthus', '2013-05-13', '09:35:49'),
(12, 106, 'roberthus', '2013-05-13', '09:35:49'),
(12, 107, 'roberthus', '2013-05-13', '09:35:49'),
(12, 108, 'roberthus', '2013-05-13', '09:35:49'),
(12, 110, 'roberthus', '2013-05-13', '09:35:49'),
(13, 25, 'imam', '2013-05-13', '12:19:43'),
(13, 26, 'imam', '2013-05-13', '12:19:43'),
(13, 63, 'imam', '2013-05-13', '12:19:43'),
(13, 64, 'imam', '2013-05-13', '12:19:43'),
(13, 68, 'imam', '2013-05-13', '12:19:43'),
(13, 69, 'imam', '2013-05-13', '12:19:43'),
(13, 70, 'imam', '2013-05-13', '12:19:43'),
(13, 71, 'imam', '2013-05-13', '12:19:43'),
(13, 73, 'imam', '2013-05-13', '12:19:43'),
(13, 86, 'imam', '2013-05-13', '12:19:43'),
(13, 109, 'imam', '2013-05-13', '12:19:43'),
(14, 25, 'roberthus', '2013-05-13', '09:40:14'),
(14, 26, 'roberthus', '2013-05-13', '09:40:14'),
(14, 63, 'roberthus', '2013-05-13', '09:40:14'),
(14, 64, 'roberthus', '2013-05-13', '09:40:14'),
(14, 68, 'roberthus', '2013-05-13', '09:40:14'),
(14, 69, 'roberthus', '2013-05-13', '09:40:14'),
(14, 70, 'roberthus', '2013-05-13', '09:40:14'),
(14, 71, 'roberthus', '2013-05-13', '09:40:14'),
(14, 72, 'roberthus', '2013-05-13', '09:40:14'),
(14, 73, 'roberthus', '2013-05-13', '09:40:14'),
(14, 86, 'roberthus', '2013-05-13', '09:40:14'),
(14, 109, 'roberthus', '2013-05-13', '09:40:14'),
(15, 25, 'roberthus', '2013-05-13', '09:40:28'),
(15, 26, 'roberthus', '2013-05-13', '09:40:28'),
(15, 74, 'roberthus', '2013-05-13', '09:40:28'),
(15, 75, 'roberthus', '2013-05-13', '09:40:28'),
(15, 84, 'roberthus', '2013-05-13', '09:40:28'),
(15, 86, 'roberthus', '2013-05-13', '09:40:28'),
(15, 89, 'roberthus', '2013-05-13', '09:40:28'),
(16, 25, 'roberthus', '2013-05-13', '09:38:45'),
(16, 26, 'roberthus', '2013-05-13', '09:38:45'),
(16, 86, 'roberthus', '2013-05-13', '09:38:45'),
(16, 95, 'roberthus', '2013-05-13', '09:38:45'),
(16, 96, 'roberthus', '2013-05-13', '09:38:45'),
(16, 97, 'roberthus', '2013-05-13', '09:38:45'),
(16, 98, 'roberthus', '2013-05-13', '09:38:45'),
(16, 99, 'roberthus', '2013-05-13', '09:38:45'),
(16, 105, 'roberthus', '2013-05-13', '09:38:45'),
(17, 95, 'roberthus', '2013-05-13', '09:38:07'),
(17, 96, 'roberthus', '2013-05-13', '09:38:07'),
(17, 97, 'roberthus', '2013-05-13', '09:38:07'),
(17, 98, 'roberthus', '2013-05-13', '09:38:07'),
(17, 99, 'roberthus', '2013-05-13', '09:38:07'),
(17, 105, 'roberthus', '2013-05-13', '09:38:07');

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

--
-- Table structure for table `t_bankbal`
--

CREATE TABLE IF NOT EXISTS `t_bankbal` (
  `idcab` int(11) NOT NULL DEFAULT '0' COMMENT 'ID Cabang',
  `sap_ref` varchar(100) NOT NULL DEFAULT '' COMMENT 'No. referensi transaksi SAP',
  `rlis_ref` varchar(100) NOT NULL COMMENT 'No. referensi transaksi RLIS',
  `amount` double DEFAULT NULL COMMENT 'Jumlah uang',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  PRIMARY KEY (`idcab`,`sap_ref`,`rlis_ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table saldo Bank';

--
-- Dumping data for table `t_bankbal`
--

INSERT INTO `t_bankbal` (`idcab`, `sap_ref`, `rlis_ref`, `amount`, `adddate`, `addby`) VALUES
(3, '0100004480WGI12013', 'CPV/7/05/13/1', 150000000, '2013-05-14 15:20:27', 'imam'),
(3, '0100004481WGI12013', 'CPV/13/05/13/3', -50000000, '2013-05-14 15:21:27', 'dini'),
(3, '0100004482WGI12013', 'CPV/14/05/13/3', -100000000, '2013-05-15 12:36:25', 'dini'),
(3, '1500001271', 'CPV/8/05/13/1', 5350000, '2013-05-14 17:06:47', 'imam');

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

--
-- Table structure for table `t_bpkk_detail`
--

CREATE TABLE IF NOT EXISTS `t_bpkk_detail` (
  `idcab` int(11) NOT NULL COMMENT 'ID Cabang',
  `nobpkk` int(11) NOT NULL COMMENT 'No BPKK',
  `year` year(4) NOT NULL COMMENT 'Tahun',
  `itemno` int(11) NOT NULL COMMENT 'No. Item',
  `uraian` varchar(100) NOT NULL COMMENT 'Uraian',
  `total_item` double NOT NULL COMMENT 'Total ITEM',
  `glacc` char(10) NOT NULL COMMENT 'G/L Account',
  PRIMARY KEY (`idcab`,`nobpkk`,`year`,`itemno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table BPKK (Petty Cash Operational) Detail';

--
-- Dumping data for table `t_bpkk_detail`
--


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

--
-- Table structure for table `t_bpkk_header`
--

CREATE TABLE IF NOT EXISTS `t_bpkk_header` (
  `idcab` int(11) NOT NULL COMMENT 'ID Cabang',
  `nobpkk` int(11) NOT NULL COMMENT 'No. BPKK',
  `nobpkkform` varchar(100) NOT NULL COMMENT 'No. Format BPKK',
  `total` double NOT NULL COMMENT 'Total',
  `status` int(1) NOT NULL COMMENT '1 = Cancel, 2=Post To Finance',
  `candesc` text NOT NULL,
  `canby` varchar(10) NOT NULL,
  `candate` datetime NOT NULL,
  `addby` varchar(10) NOT NULL COMMENT 'Dibuat oleh',
  `adddate` datetime NOT NULL COMMENT 'Tgl Buat',
  `chby` varchar(10) NOT NULL COMMENT 'Diubah oleh',
  `chdate` datetime NOT NULL COMMENT 'Tgl Ubah',
  `year` year(4) NOT NULL COMMENT 'Tahun',
  PRIMARY KEY (`idcab`,`nobpkk`,`year`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table BPKK (Petty Cash Operational) Header';

--
-- Dumping data for table `t_bpkk_header`
--


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

--
-- Table structure for table `t_count`
--

CREATE TABLE IF NOT EXISTS `t_count` (
  `idcab` int(11) NOT NULL,
  `bpb_count` int(11) DEFAULT NULL COMMENT 'Counter BPB',
  `pc_count` int(11) DEFAULT NULL COMMENT 'Petty cash counter',
  `op_count` int(11) NOT NULL,
  `opc_count` int(11) NOT NULL,
  `ba_count` int(11) NOT NULL,
  `sj_count` int(11) NOT NULL,
  `bpkk_count` int(11) NOT NULL COMMENT 'Counter BPKK',
  `rmb_count` int(11) NOT NULL COMMENT 'Rembuirsement Count',
  `year` year(4) DEFAULT NULL,
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `chdate` datetime DEFAULT NULL COMMENT 'Tanggal ganti',
  `chby` varchar(10) DEFAULT NULL COMMENT 'Diubah oleh',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  PRIMARY KEY (`idcab`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table transaksi counter';

--
-- Dumping data for table `t_count`
--

INSERT INTO `t_count` (`idcab`, `bpb_count`, `pc_count`, `op_count`, `opc_count`, `ba_count`, `sj_count`, `bpkk_count`, `rmb_count`, `year`, `adddate`, `chdate`, `chby`, `addby`) VALUES
(1, 8, 0, 0, 0, 0, 0, 0, 0, 2013, '2013-04-19 15:26:55', '2013-05-14 16:55:44', 'novika', 'Imam'),
(3, 15, 15, 38, 0, 2, 3, 5, 2, 2013, NULL, '2013-05-15 17:23:59', 'dini', 'Imam');

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

--
-- Table structure for table `t_cpv`
--

CREATE TABLE IF NOT EXISTS `t_cpv` (
  `nocpv` int(11) NOT NULL COMMENT 'No. CPV',
  `idcab` int(11) NOT NULL COMMENT 'ID Cabang',
  `year` year(4) NOT NULL COMMENT 'Fiscal year',
  `nocpvform` varchar(100) NOT NULL COMMENT 'No. CPV Format',
  `nocpdu` varchar(100) NOT NULL,
  `miro` char(10) DEFAULT NULL COMMENT 'No. Miro',
  `amount_trf` double DEFAULT NULL COMMENT 'Jumlah yg ditransfer',
  `amount_req` double DEFAULT NULL COMMENT 'Jumlah transfer yang diminta',
  `desc` text COMMENT 'Keterangan',
  `status` int(1) DEFAULT NULL COMMENT 'Status doc. 0: pending, 1: approve, 2: cancel',
  `pctyp` int(1) NOT NULL COMMENT 'Petty cash type . 0: PC Uo, 1: PC Op',
  `descan` text COMMENT 'Keterangan cancel',
  `pctrans` int(1) NOT NULL COMMENT 'jenis BPB, 1: Direct, 2: Reference by MIRO',
  `bankrefno` varchar(20) NOT NULL COMMENT 'Bank Reference Number',
  `chdate` datetime DEFAULT NULL COMMENT 'Tanggal ganti',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  `chby` varchar(10) DEFAULT NULL COMMENT 'Diubah oleh',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `appby` varchar(10) DEFAULT NULL COMMENT 'Diapprove oleh',
  `appdate` datetime DEFAULT NULL COMMENT 'Tgl approve',
  `canby` varchar(10) DEFAULT NULL COMMENT 'Dicancel oleh',
  `candate` datetime DEFAULT NULL COMMENT 'Tgl cancel',
  `accglpost` int(1) NOT NULL COMMENT 'Status G/L account post by accounting. 0: No, 1: yes',
  `accglpostby` varchar(10) NOT NULL COMMENT 'G/L Post by',
  `accglpostdate` datetime NOT NULL COMMENT 'G/L Post date',
  `accglno` char(20) NOT NULL,
  PRIMARY KEY (`nocpv`,`idcab`,`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table CPV Finance';

--
-- Dumping data for table `t_cpv`
--

INSERT INTO `t_cpv` (`nocpv`, `idcab`, `year`, `nocpvform`, `nocpdu`, `miro`, `amount_trf`, `amount_req`, `desc`, `status`, `pctyp`, `descan`, `pctrans`, `bankrefno`, `chdate`, `addby`, `chby`, `adddate`, `appby`, `appdate`, `canby`, `candate`, `accglpost`, `accglpostby`, `accglpostdate`, `accglno`) VALUES
(7, 3, 2013, 'CPV/7/05/13/1', 'CPDU/XXX/XXX/XXX', NULL, 150000000, NULL, 'Test', 1, 0, NULL, 1, '1111111111111111', '2013-05-14 15:20:19', 'imam', 'imam', '2013-05-14 15:19:55', 'imam', '2013-05-14 15:20:05', NULL, NULL, 1, 'imam', '2013-05-14 15:20:27', '0100004480WGI12013'),
(8, 3, 2013, 'CPV/8/05/13/1', 'CP/XXXX/XXXX/XX', NULL, 5350000, NULL, 'Test', 1, 1, NULL, 2, '111111111111111', '2013-05-14 16:56:15', 'novika', 'imam', '2013-05-14 16:55:44', 'imam', '2013-05-14 16:56:01', NULL, NULL, 1, 'imam', '2013-05-14 17:06:47', '1500001271');

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

--
-- Table structure for table `t_dn`
--

CREATE TABLE IF NOT EXISTS `t_dn` (
  `iddn` int(11) NOT NULL AUTO_INCREMENT,
  `dnnumb` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `mnfst` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `vnumb` varchar(10) COLLATE latin1_general_ci DEFAULT NULL,
  `noiso` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `vol` int(50) DEFAULT NULL,
  `quantity` int(50) DEFAULT NULL,
  `idtrans` int(10) DEFAULT NULL,
  `eta` date DEFAULT NULL,
  `seal1` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  `seal2` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  `seal3` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  `seal4` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  `seal5` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  `seal6` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  `driver` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `type` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `status` int(1) NOT NULL,
  `idcab` int(11) NOT NULL,
  `chby` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `inf` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `year` year(4) NOT NULL,
  `matdoc` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `adddate` datetime NOT NULL,
  `addby` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `chdate` datetime NOT NULL,
  PRIMARY KEY (`iddn`,`dnnumb`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `t_dn`
--

INSERT INTO `t_dn` (`iddn`, `dnnumb`, `mnfst`, `vnumb`, `noiso`, `vol`, `quantity`, `idtrans`, `eta`, `seal1`, `seal2`, `seal3`, `seal4`, `seal5`, `seal6`, `driver`, `type`, `status`, `idcab`, `chby`, `inf`, `year`, `matdoc`, `adddate`, `addby`, `chdate`) VALUES
(1, 'SJ/3/05/13/3', 'xxxxxxxxxx', 'B 1234 NN', 'xxxxxx', 16000, 0, 1, '2014-05-20', 'xxxx', 'xxx', 'xxxx', 'xxxx', '0', '0', 'xxxx', 'Truck', 0, 3, '', 'test', 2013, '4900400497', '2013-05-14 17:12:34', 'dini', '0000-00-00 00:00:00');

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

--
-- Table structure for table `t_pcbal`
--

CREATE TABLE IF NOT EXISTS `t_pcbal` (
  `idcab` int(11) NOT NULL DEFAULT '0',
  `ref` varchar(100) NOT NULL DEFAULT '' COMMENT 'Referensi transaksi',
  `amount` double DEFAULT NULL COMMENT 'Jumlah uang',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  PRIMARY KEY (`idcab`,`ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table saldo petty cash balance';

--
-- Dumping data for table `t_pcbal`
--

INSERT INTO `t_pcbal` (`idcab`, `ref`, `amount`, `adddate`, `addby`) VALUES
(3, 'CPV/13/05/13/3', 50000000, '2013-05-14 15:21:27', 'dini'),
(3, 'CPV/14/05/13/3', 100000000, '2013-05-15 12:36:25', 'dini'),
(3, 'OP/18/05/13/3', -10000000, '2013-05-14 15:22:34', 'dini'),
(3, 'OP/19/05/13/3', -11000000, '2013-05-14 15:23:33', 'dini'),
(3, 'OP/20/05/13/3', -475000, '2013-05-14 15:24:13', 'dini'),
(3, 'OP/21/05/13/3', -5000000, '2013-05-14 15:40:48', 'dini'),
(3, 'OP/23/05/13/3', -350000, '2013-05-14 15:41:43', 'dini'),
(3, 'OP/26/05/13/3', -10, '2013-05-15 10:02:45', 'dini'),
(3, 'OP/27/05/13/3', -500, '2013-05-15 10:12:19', 'dini'),
(3, 'OP/28/05/13/3', -1, '2013-05-15 10:41:14', 'dini'),
(3, 'OP/29/05/13/3', -10000000, '2013-05-15 12:43:13', 'dini'),
(3, 'OP/33/05/13/3', -11000000, '2013-05-15 15:33:41', 'dini'),
(3, 'OP/34/05/13/3', -11000000, '2013-05-15 15:46:45', 'dini'),
(3, 'OP/35/05/13/3', -11000000, '2013-05-15 16:06:49', 'dini'),
(3, 'OP/36/05/13/3', -11000000, '2013-05-15 17:15:41', 'dini'),
(3, 'OP/37/05/13/3', -11000000, '2013-05-15 17:21:44', 'dini'),
(3, 'OP/38/05/13/3', -11000000, '2013-05-15 17:23:59', 'dini');

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

--
-- Table structure for table `t_pcbal_op`
--

CREATE TABLE IF NOT EXISTS `t_pcbal_op` (
  `idcab` int(11) NOT NULL DEFAULT '0',
  `ref` varchar(100) NOT NULL DEFAULT '' COMMENT 'Referensi transaksi',
  `amount` double DEFAULT NULL COMMENT 'Jumlah uang',
  `status` int(1) NOT NULL COMMENT '1 =  Cancel',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  PRIMARY KEY (`idcab`,`ref`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table saldo petty cash balance OP';

--
-- Dumping data for table `t_pcbal_op`
--


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

--
-- Table structure for table `t_pc_cab`
--

CREATE TABLE IF NOT EXISTS `t_pc_cab` (
  `nopc` int(11) NOT NULL COMMENT 'No. PC',
  `idcab` int(11) NOT NULL COMMENT 'ID Cabang',
  `year` year(4) NOT NULL,
  `nopcform` varchar(100) NOT NULL COMMENT 'No. PC Format',
  `amount` double DEFAULT NULL COMMENT 'Jumlah yg ditransfer',
  `desc` text COMMENT 'Keterangan',
  `pctyp` int(1) NOT NULL COMMENT '1 = Used Oil, 2 = Operasional',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `accglno` char(20) NOT NULL COMMENT 'No. Journal ACC',
  PRIMARY KEY (`nopc`,`idcab`,`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table Petty Cash cabang Used Oil';

--
-- Dumping data for table `t_pc_cab`
--

INSERT INTO `t_pc_cab` (`nopc`, `idcab`, `year`, `nopcform`, `amount`, `desc`, `pctyp`, `addby`, `adddate`, `accglno`) VALUES
(13, 3, 2013, 'CPV/13/05/13/3', 50000000, 'Test', 1, 'dini', '2013-05-14 15:21:27', '0100004481WGI12013'),
(14, 3, 2013, 'CPV/14/05/13/3', 100000000, 'Ambil PC UO', 1, 'dini', '2013-05-15 12:36:25', '0100004482WGI12013'),
(15, 3, 2013, 'CPV/15/05/13/3', 5000000, 'Test', 1, 'dini', '2013-05-15 14:29:11', '0100004483WGI12013');

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

--
-- Table structure for table `t_po`
--

CREATE TABLE IF NOT EXISTS `t_po` (
  `ebeln` char(10) NOT NULL,
  `idcab` int(11) NOT NULL,
  `preq_no` char(10) NOT NULL,
  `mblnr` char(10) NOT NULL,
  `year` year(4) NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `net_price` double DEFAULT NULL,
  `disc` double NOT NULL COMMENT 'Potongan pembulatan',
  `tax` double NOT NULL COMMENT 'PPN',
  `vendor` char(16) NOT NULL COMMENT 'No. Vendor',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  `miro` char(10) NOT NULL COMMENT 'No. Miro',
  `miraddby` varchar(10) NOT NULL COMMENT 'Miro dibuat oleh',
  `miradddate` datetime NOT NULL COMMENT 'Miro tgl buat',
  `clearno` char(10) NOT NULL COMMENT 'Post Clearing Number',
  `clearaddby` varchar(10) NOT NULL COMMENT 'Clear By',
  `clearadddate` datetime NOT NULL COMMENT 'Clear Date',
  `nocpvform` varchar(100) NOT NULL COMMENT 'No. CPV',
  `cpvaddby` varchar(10) NOT NULL COMMENT 'CPV Dibuat',
  `cpvadddate` datetime NOT NULL COMMENT 'Tgl Buat CPV',
  PRIMARY KEY (`ebeln`,`idcab`,`preq_no`,`mblnr`,`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table transaksi PO';

--
-- Dumping data for table `t_po`
--

INSERT INTO `t_po` (`ebeln`, `idcab`, `preq_no`, `mblnr`, `year`, `quantity`, `net_price`, `disc`, `tax`, `vendor`, `adddate`, `addby`, `miro`, `miraddby`, `miradddate`, `clearno`, `clearaddby`, `clearadddate`, `nocpvform`, `cpvaddby`, `cpvadddate`) VALUES
('9900000004', 3, '9800000011', '5000155004', 2013, 15000, 1432, 5000, 0, '30200', '2013-05-14 15:27:12', 'dini', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00'),
('9900000005', 3, '9800000012', '5000155005', 2013, 5500, 973, 1500, 0, '30200', '2013-05-14 15:42:14', 'dini', '5105670701', 'izza', '2013-05-14 16:32:15', '1500001271', 'imam', '2013-05-14 17:06:47', 'CPV/8/05/13/1', 'novika', '2013-05-14 16:55:44'),
('9900000006', 3, '9800000013', '5000155006', 2013, 16000, 657, 12000, 0, '30200', '2013-05-15 10:13:08', 'dini', '5105670703', 'imam', '2013-05-16 10:01:20', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00'),
('9900000007', 3, '9800000014', '5000155007', 2013, 5000, 200, 0, 0, '30200', '2013-05-15 10:41:26', 'dini', '5105670702', 'izza', '2013-05-16 09:44:53', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00'),
('9900000010', 3, '9800000018', '5000155008', 2013, 13500, 815, 2500, 1100000, '10283', '2013-05-15 16:06:57', 'dini', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00'),
('9900000011', 3, '9800000019', '0', 2013, 13500, 815, 2500, 1100000, '30200', '2013-05-15 17:15:47', 'dini', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00'),
('9900000012', 3, '9800000020', '0', 2013, 13500, 815, 2500, 1100000, '30200', '2013-05-15 17:21:47', 'dini', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00'),
('9900000013', 3, '9800000021', '5000155009', 2013, 16000, 688, 8000, 1100000, '30200', '2013-05-15 17:24:04', 'dini', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00', '', '', '0000-00-00 00:00:00');

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

--
-- Table structure for table `t_pr`
--

CREATE TABLE IF NOT EXISTS `t_pr` (
  `preq_no` char(10) NOT NULL COMMENT 'No. PP SAP',
  `idcab` int(11) NOT NULL COMMENT 'ID Cabang',
  `c_amt_bapi` double DEFAULT NULL COMMENT 'Valuation price',
  `quantity` int(11) DEFAULT NULL,
  `closed` int(1) DEFAULT NULL COMMENT 'Closed : 1, Open : 0',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  `chdate` datetime DEFAULT NULL COMMENT 'Tanggal ganti',
  `chby` varchar(10) DEFAULT NULL COMMENT 'Diubah oleh',
  `clby` varchar(10) DEFAULT NULL COMMENT 'Closed by',
  `cldate` datetime DEFAULT NULL COMMENT 'Closed date',
  `year` year(4) DEFAULT NULL COMMENT 'Tahun',
  PRIMARY KEY (`preq_no`,`idcab`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table transaksi PP';

--
-- Dumping data for table `t_pr`
--

INSERT INTO `t_pr` (`preq_no`, `idcab`, `c_amt_bapi`, `quantity`, `closed`, `adddate`, `addby`, `chdate`, `chby`, `clby`, `cldate`, `year`) VALUES
('9800000011', 3, 1432, 15000, 1, '2013-05-14 15:21:59', 'dini', NULL, NULL, 'dini', '2013-05-14 15:27:12', 2013),
('9800000012', 3, 973, 5500, 1, '2013-05-14 15:39:23', 'dini', NULL, NULL, 'dini', '2013-05-14 15:42:14', 2013),
('9800000013', 3, 657, 16000, 1, '2013-05-15 09:43:07', 'dini', NULL, NULL, 'dini', '2013-05-15 10:13:08', 2013),
('9800000014', 3, 200, 5000, 1, '2013-05-15 10:36:10', 'dini', NULL, NULL, 'dini', '2013-05-15 10:41:26', 2013),
('9800000015', 3, 3000, 16000, 0, '2013-05-15 12:36:47', 'dini', NULL, NULL, NULL, NULL, 2013),
('9800000016', 3, 3000, 16000, 0, '2013-05-15 12:36:57', 'dini', NULL, NULL, NULL, NULL, 2013),
('9800000017', 3, 3000, 16000, 0, '2013-05-15 15:46:08', 'dini', NULL, NULL, NULL, NULL, 2013),
('9800000018', 3, 815, 13500, 1, '2013-05-15 16:06:05', 'dini', NULL, NULL, 'dini', '2013-05-15 16:06:57', 2013),
('9800000019', 3, 815, 13500, 1, '2013-05-15 17:15:05', 'dini', NULL, NULL, 'dini', '2013-05-15 17:15:47', 2013),
('9800000020', 3, 815, 13500, 1, '2013-05-15 17:21:06', 'dini', NULL, NULL, 'dini', '2013-05-15 17:21:47', 2013),
('9800000021', 3, 688, 16000, 1, '2013-05-15 17:23:21', 'dini', NULL, NULL, 'dini', '2013-05-15 17:24:04', 2013);

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

--
-- Table structure for table `t_qa`
--

CREATE TABLE IF NOT EXISTS `t_qa` (
  `idqa` int(11) NOT NULL AUTO_INCREMENT,
  `idba` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `sertifikat` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `vol` int(10) NOT NULL,
  `scrap` int(10) NOT NULL,
  `adj` int(10) NOT NULL,
  `appdivheaddate` date NOT NULL,
  `appmngr2date` date NOT NULL,
  `appmngr1date` date NOT NULL,
  `appdivhead` int(1) NOT NULL,
  `appmngr2` int(1) NOT NULL,
  `appmngr1` int(1) NOT NULL,
  `qcair` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `qcbakar` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `qcresidu` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `qct` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `qctbk` varchar(10) COLLATE latin1_general_ci NOT NULL,
  `year` year(4) NOT NULL,
  `inf` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `addby` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `adddate` datetime NOT NULL,
  `idcab` int(11) NOT NULL,
  `appby` varchar(15) COLLATE latin1_general_ci NOT NULL,
  `nosap` char(10) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`idqa`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `t_qa`
--


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

--
-- Table structure for table `t_rmb_detail`
--

CREATE TABLE IF NOT EXISTS `t_rmb_detail` (
  `idcab` int(11) NOT NULL COMMENT 'ID Cabang',
  `normb` int(11) NOT NULL COMMENT 'No BPKK',
  `nobpkk` int(11) NOT NULL COMMENT 'No BPKK',
  `year` year(4) NOT NULL COMMENT 'Tahun',
  PRIMARY KEY (`idcab`,`normb`,`nobpkk`,`year`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table reimbursement BPKK Detail';

--
-- Dumping data for table `t_rmb_detail`
--


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

--
-- Table structure for table `t_rmb_header`
--

CREATE TABLE IF NOT EXISTS `t_rmb_header` (
  `idcab` int(11) NOT NULL COMMENT 'ID Cabang',
  `normb` int(11) NOT NULL COMMENT 'No. Reimbursement',
  `normbform` varchar(100) NOT NULL COMMENT 'No. Format Reimbursement',
  `total` double NOT NULL COMMENT 'Total',
  `status` int(1) NOT NULL COMMENT '1 = Cancel, 2=CPV Created',
  `nocpvform` varchar(100) NOT NULL COMMENT 'No. CPV Format',
  `candesc` text NOT NULL,
  `canby` varchar(10) NOT NULL,
  `candate` datetime NOT NULL,
  `addby` varchar(10) NOT NULL COMMENT 'Dibuat oleh',
  `adddate` datetime NOT NULL COMMENT 'Tgl Buat',
  `year` year(4) NOT NULL COMMENT 'Tahun',
  PRIMARY KEY (`idcab`,`normb`,`year`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table reimbursement BPKK Header';

--
-- Dumping data for table `t_rmb_header`
--


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

--
-- Table structure for table `t_stockbal`
--

CREATE TABLE IF NOT EXISTS `t_stockbal` (
  `idcab` int(11) NOT NULL DEFAULT '0',
  `ref` varchar(100) NOT NULL DEFAULT '' COMMENT 'Referensi transaksi',
  `year` int(4) NOT NULL,
  `qty` int(11) DEFAULT NULL COMMENT 'Jumlah stock',
  `adddate` datetime DEFAULT NULL COMMENT 'Tanggal buat',
  `addby` varchar(10) DEFAULT NULL COMMENT 'Dibuat oleh',
  PRIMARY KEY (`idcab`,`ref`,`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table saldo stock balance';

--
-- Dumping data for table `t_stockbal`
--

INSERT INTO `t_stockbal` (`idcab`, `ref`, `year`, `qty`, `adddate`, `addby`) VALUES
(3, '5000155004', 2013, 15000, '2013-05-14 15:27:12', 'dini'),
(3, '5000155005', 2013, 5500, '2013-05-14 15:42:14', 'dini'),
(3, '5000155006', 2013, 16000, '2013-05-15 10:13:08', 'dini'),
(3, '5000155007', 2013, 5000, '2013-05-15 10:41:26', 'dini'),
(3, '5000155008', 2013, 13500, '2013-05-15 16:06:57', 'dini'),
(3, '5000155009', 2013, 16000, '2013-05-15 17:24:04', 'dini'),
(3, 'SJ/3/05/13/3', 2013, -16000, '2013-05-14 17:12:34', 'dini');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `role_menu`
--
ALTER TABLE `role_menu`
  ADD CONSTRAINT `role_menu_ibfk_1` FOREIGN KEY (`roleid`) REFERENCES `master_role` (`roleid`) ON DELETE CASCADE;
