--
-- Host: localhost    Database: admin_vmart
-- ------------------------------------------------------


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(50) DEFAULT '',
  `category_status` int(1) NOT NULL DEFAULT '1',
  `category_prefix` varchar(5) DEFAULT '',
  `category_nextnumber` bigint(20) DEFAULT '1',
  `category_createdby` varchar(50) DEFAULT '',
  `category_createddatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `category_updatedby` varchar(50) DEFAULT '',
  `category_updateddatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=175 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (165,'Software',1,'SW',1001,'kaitong','2016-09-15 09:43:36','kaitong','2016-09-15 09:43:36'),(167,'Hardware',1,'HW',2000,'kaitong','2016-11-01 22:28:15','cheongyy','2017-04-19 18:19:27'),(169,'Software Maintenance',1,'SM',3001,'kaitong','2016-11-01 22:28:15','kaitong','2016-11-01 22:28:15'),(170,'Hardware Maintenance',1,'HM',4000,'kaitong','2016-11-01 22:28:15','kaitong','2016-11-01 22:28:15'),(171,'Trading',1,'TD',5000,'kaitong','2016-11-01 22:28:15','chiangkl','2017-03-30 16:56:40'),(172,'Services',1,'SV',6001,'kaitong','2016-11-01 22:28:15','kaitong','2016-11-01 22:28:15'),(173,'Hosting',1,'HT',7002,'chiangkl','2017-03-30 16:57:34','chiangkl','2017-03-30 16:57:34');

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `currency_id` int(11) NOT NULL AUTO_INCREMENT,
  `currency_title` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `currency_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `currency_status` tinyint(1) NOT NULL,
  `currency_createdby` varchar(20) DEFAULT NULL,
  `currency_createddatetime` datetime DEFAULT NULL,
  `currency_updatedby` varchar(20) DEFAULT NULL,
  `currency_updateddatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`currency_id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` VALUES (15,'Malaysian Ringgit','MYR',1,'kaitong','2016-11-01 19:18:32','kaitong','2016-11-01 19:19:58');

--
-- Table structure for table `currencydetails`
--

CREATE TABLE `currencydetails` (
  `currencydetail_id` int(11) NOT NULL AUTO_INCREMENT,
  `currencydetail_currencyid` int(11) DEFAULT NULL,
  `currencydetail_month` int(11) DEFAULT NULL,
  `currencydetail_year` int(1) DEFAULT NULL,
  `currencydetail_rate` decimal(15,8) DEFAULT NULL,
  `currencydetail_createdby` varchar(50) DEFAULT '',
  `currencydetail_createddatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `currencydetail_updatedby` varchar(50) DEFAULT '',
  `currencydetail_updateddatetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`currencydetail_id`)
) ENGINE=MyISAM AUTO_INCREMENT=227 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `currencydetails`
--

INSERT INTO `currencydetails` VALUES (203,15,1,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(204,15,2,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(205,15,3,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(206,15,4,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(207,15,5,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(208,15,6,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(209,15,7,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(210,15,8,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(211,15,9,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(212,15,10,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(213,15,11,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(214,15,12,2016,1.00000000,'kaitong','2016-11-02 10:30:01','kaitong','2016-11-23 17:37:48'),(215,15,1,2017,0.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12'),(216,15,2,2017,0.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12'),(217,15,3,2017,2.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12'),(218,15,4,2017,3.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12'),(219,15,5,2017,0.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12'),(220,15,6,2017,4.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12'),(221,15,7,2017,0.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12'),(222,15,8,2017,0.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12'),(223,15,9,2017,0.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12'),(224,15,10,2017,0.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12'),(225,15,11,2017,0.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12'),(226,15,12,2017,0.00000000,'kaitong','2016-11-02 10:30:12','kaitong','2016-11-02 10:30:12');

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `customer_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) NOT NULL DEFAULT '',
  `customer_address` varchar(255) NOT NULL DEFAULT '',
  `customer_contactperson` varchar(255) NOT NULL DEFAULT '',
  `customer_contactnumber` varchar(255) NOT NULL DEFAULT '',
  `customer_fax` varchar(255) DEFAULT '',
  `customer_email` varchar(255) DEFAULT '',
  `customer_status` int(1) DEFAULT NULL,
  `customer_createdby` varchar(20) DEFAULT NULL,
  `customer_createddatetime` datetime DEFAULT NULL,
  `customer_updatedby` varchar(20) DEFAULT NULL,
  `customer_updateddatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`customer_id`)
) ENGINE=MyISAM AUTO_INCREMENT=130 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` VALUES (12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','James','0122125737','','mwater.james@gmail.com',1,'chiangkl','2017-03-30 16:47:02','chiangkl','2017-04-04 22:53:05'),(13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','Kenny Ong','0102223839','','salesherdiva@gmail.com',1,'chiangkl','2017-03-30 16:51:10','chiangkl','2017-03-30 16:51:10'),(14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','Kim','0395439339','','sjyeong76@hotmail.com',1,'chiangkl','2017-03-30 16:53:26','chiangkl','2017-07-03 12:26:43'),(15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','Jessie Chua','0362501035','','jessie.chua@firstcoach.com.my',1,'chiangkl','2017-03-30 16:55:29','chiangkl','2017-07-06 16:50:58'),(19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','Alice Toh','0379560544','0379570616','tipmy@tiptape.com.my',1,'chiangkl','2017-04-13 15:12:46','chiangkl','2017-04-13 15:12:46'),(20,'Suprima Holdings Sdn. Bhd.','No. 12-1, Lorong Batu Nilam 3C,\r\nBandar Bukit Tinggi, 41200 Klang,\r\nMalaysia.','Stephen Lee','0333247684','0333247620','stephen@suprimacomm.com',1,'chiangkl','2017-04-13 15:14:42','cheongyy','2017-12-26 23:58:25'),(21,'Syarikat Kau Lee','63B-2 Jalan Sultan,\r\n50000 Kuala Lumpur.','Annie Lim','0320780188','','skl_88@yahoo.com',1,'chiangkl','2017-04-13 15:15:55','chiangkl','2017-04-13 15:15:55'),(22,'Syarikat Central Pahang Omnibus Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','Jessie Chua','0362501035','','jessie.chua@firstcoach.com.my',1,'chiangkl','2017-04-13 15:29:46','chiangkl','2017-04-13 15:32:49'),(23,'Syarikat Kenderaan Satria Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','Jessie Chua','0362501035','','jessie.chua@firstcoach.com.my',1,'chiangkl','2017-04-13 15:30:54','chiangkl','2017-04-13 15:39:53'),(24,'The Pahang South Union Omnibus Company Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','Jessie Chua','0362501035','','jessie.chua@firstcoach.com.my',1,'chiangkl','2017-04-13 15:32:07','chiangkl','2017-04-13 15:39:50'),(25,'Temerloh - Kuala Lumpur Express Omnibus Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','Jessie Chua','0362501035','','jessie.chua@firstcoach.com.my',1,'chiangkl','2017-04-13 15:33:38','chiangkl','2017-04-13 15:40:10'),(26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','Kent Lee','0391026032','','kentlee1984@gmail.com',1,'chiangkl','2017-04-13 15:36:20','chiangkl','2017-04-13 15:40:48'),(27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','Yap','0320955811','0320955843','hq@jlj.com.my',1,'chiangkl','2017-04-13 15:39:14','chiangkl','2017-12-19 13:25:38'),(28,'YHC Paper Trading Sdn. Bhd.','No.3, Jalan 33/4A,\r\nElite Industrial Estate,\r\nSeksyen 33, Shah Alam,\r\n40400 Selangor.','Calvin Lim','0351211901','0351211462','',1,'chiangkl','2017-04-25 12:29:15','chiangkl','2017-04-25 12:29:15'),(119,'Livingears Malaysia Sdn Bhd','B2-20-21 & B2-20-22, 2Floor,\r\nLorong Batu Nilam 3F,\r\nBandar Bukit Tinggi\r\n41200 Klang','Vinsen','0333187667','','sales@livinggears.com',1,'chiangkl','2017-10-11 05:18:47','chiangkl','2019-10-14 01:47:19'),(29,'Jordan Lee & Jaafar Sdn. Bhd. (Ipoh)','Ipoh Branch','Ms Yap','0320955811','0320955843','styap@jlj.com.my',1,'chiangkl','2017-07-03 12:56:08','chiangkl','2017-07-03 12:56:08'),(30,'Masitu Marketing (M) Sdn Bhd',' Lot 882, Jalan Subang 9,\r\nTaman Perindustrian Subang, \r\n47600 Subang Jaya, \r\nSelangor\r\n','Mr Lee','0380234327','','sales@masitu.com',1,'chiangkl','2017-07-03 13:23:01','chiangkl','2017-07-03 13:23:01'),(31,'Bakti Raya Sdn Bhd','Selangor','','','','',1,'chiangkl','2017-07-03 13:43:07','chiangkl','2017-07-03 13:43:07'),(118,'Casitan Sdn Bhd','65-1 Petaling Utama Avenue,\r\nJalan PJS 1/50, 7th Mile off Jalan Klang Lama,\r\n46150 Petaling Jaya, Selangor','Ms Tan','0377851245','0377851251','casitancarbon@gmail.com',1,'chiangkl','2017-08-01 23:18:17','chiangkl','2017-08-01 23:18:17'),(120,'Rightcliq Solutions','E7-05 The Gamuda Biz Suites,\r\nNo. 12, Jalan Anggerik Vanilla 31/99,\r\nKota Kemuning,\r\n40460 Shah Alam,\r\nSelangor, Malaysia','Mr. Aliasgar','','','aliasgar@rightcliq.com.my',1,'chiangkl','2017-10-25 10:17:34','chiangkl','2017-10-25 10:20:21'),(121,'Jordan Lee & Jaafar Sdn. Bhd.  (PJ)','A-2-3, Block A,\r\nPusat Perniagaan Seksyen 8, \r\nJalan Sungai Jernih 8/1,  \r\n46050 Petaling Jaya, Selangor','Mr. Sherman Tangga','03-7956 5811','03-7955 5843','sherman@jlj.com.my',1,'chiangkl','2018-02-11 14:13:54','chiangkl','2018-02-11 14:13:54'),(122,'Daebak Esport Cafe','18, Jalan Damai Perdana 1/9a,\r\nBandar Damai Perdana,\r\n56000 Cheras 9 Miles, Kuala Lumpur','Kent Lee','0177808884','','cheongkl@gmail.com',1,'chiangkl','2018-05-14 18:08:47','chiangkl','2018-05-14 18:08:47'),(123,'Hyperack Sdn Bhd.','No. 40G & MF, Lintang Gelugor,\r\nOff Persiaran Sultan Ibrahim,\r\n41300 Klang, Selangor.','Chester','0193836933','','chester@hyperack.com.m',1,'chiangkl','2018-05-17 17:44:35','chiangkl','2018-05-17 17:44:35'),(124,'Boon Hua Motor Sdn Bhd','1, Jalan Sri Puchong 2b,\r\n47100 Puchong,\r\nSelangor','','','','',1,'chiangkl','2018-12-17 04:21:53','chiangkl','2018-12-17 04:21:53'),(125,'SQL ERP Business  Solution PLT','1, Jalan Sri Puchong 2b,\r\n47100 Puchong, Selangor','','','','',1,'chiangkl','2018-12-17 04:25:05','chiangkl','2019-01-03 03:53:41'),(126,'Genusis Consultancy Sdn Bhd','','Gary','0122811933','','Gary.leong@genusis.com',1,'chiangkl','2019-02-12 05:14:40','chiangkl','2019-02-12 05:14:40'),(127,'Asia Pacific Truck & Bus Sdn Bhd','Segambut\r\nKUala Lumpur','Jessie','','','',1,'chiangkl','2019-04-16 03:35:37','chiangkl','2019-04-16 03:35:37'),(128,'Jurusniaga Sdn. Bhd.','','Ms Yee','','','',1,'chiangkl','2019-06-03 07:32:14','chiangkl','2019-06-03 07:32:14'),(129,'Syarikat Central Pahang Omnifi Holdings Sdn Bhd','Segambut','Jessie Chua','0362501035','','jessie.chua@firstcoach.com.my',1,'chiangkl','2020-02-10 10:26:16','chiangkl','2020-02-10 10:26:48');

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `log_menuid` int(11) DEFAULT NULL,
  `log_action` varchar(1) DEFAULT NULL,
  `log_oldvalue` text,
  `log_newvalue` text,
  `log_createdby` varchar(20) DEFAULT NULL,
  `log_createddatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1555 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` VALUES (1483,209,'D','','','kaitong','2016-11-01 21:31:41'),(1484,209,'D','','','kaitong','2016-11-01 21:32:46'),(1485,209,'D','','','kaitong','2016-11-01 21:34:14'),(1486,209,'D','','','kaitong','2016-11-01 21:34:52'),(1487,209,'D','a:8:{s:9:\"colour_id\";i:173;s:11:\"colour_code\";s:4:\"dddd\";s:11:\"colour_name\";s:4:\"dddd\";s:13:\"colour_status\";i:1;s:16:\"colour_createdby\";s:7:\"kaitong\";s:22:\"colour_createddatetime\";s:19:\"2016-11-01 21:38:29\";s:16:\"colour_updatedby\";s:7:\"kaitong\";s:22:\"colour_updateddatetime\";s:19:\"2016-11-01 21:38:29\";}','','kaitong','2016-11-01 21:38:34'),(1488,209,'D','{\"colour_id\":174,\"colour_code\":\"sdaas\",\"colour_name\":\"asdsa\",\"colour_status\":1,\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:41:45\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 21:41:45\"}','','kaitong','2016-11-01 21:41:50'),(1489,209,'C','{\"colour_status\":\"1\",\"colour_code\":\"sadas\",\"colour_name\":\"sasdasa\",\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:43:48\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 21:43:48\"}','','kaitong','2016-11-01 21:43:48'),(1490,209,'C','','{\"colour_status\":\"1\",\"colour_code\":\"asdas\",\"colour_name\":\"sadasdas\",\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:46:58\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 21:46:58\"}','kaitong','2016-11-01 21:46:58'),(1491,209,'U','{\"colour_id\":175,\"colour_code\":\"sadas\",\"colour_name\":\"sasdasa1111\",\"colour_status\":\"1\",\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:43:48\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 21:48:58\"}','{\"colour_id\":175,\"colour_code\":\"sadas\",\"colour_name\":\"sasdasa1111\",\"colour_status\":\"1\",\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:43:48\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 21:48:58\"}','kaitong','2016-11-01 21:48:58'),(1492,209,'U','{\"colour_id\":175,\"colour_code\":\"sadas\",\"colour_name\":\"sasdasa2222\",\"colour_status\":\"1\",\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:43:48\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 21:50:02\"}','{\"colour_id\":175,\"colour_code\":\"sadas\",\"colour_name\":\"sasdasa2222\",\"colour_status\":\"1\",\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:43:48\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 21:50:02\"}','kaitong','2016-11-01 21:50:02'),(1493,209,'U','{\"colour_id\":175,\"colour_code\":\"sadas\",\"colour_name\":\"sasdasa2222\",\"colour_status\":1,\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:43:48\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 21:50:02\"}','{\"colour_id\":175,\"colour_code\":\"sadas\",\"colour_name\":\"sasdasa333\",\"colour_status\":\"1\",\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:43:48\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 21:57:22\"}','kaitong','2016-11-01 21:57:22'),(1494,209,'D','{\"colour_id\":176,\"colour_code\":\"asdas\",\"colour_name\":\"sadasdas\",\"colour_status\":1,\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:46:58\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 21:46:58\"}','','kaitong','2016-11-01 21:59:56'),(1495,209,'U','{\"colour_id\":175,\"colour_code\":\"sadas\",\"colour_name\":\"sasdasa333\",\"colour_status\":1,\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:43:48\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 21:57:22\"}','{\"colour_id\":175,\"colour_code\":\"sadas\",\"colour_name\":\"sasdasa33322222\",\"colour_status\":\"1\",\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 21:43:48\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 22:01:12\"}','kaitong','2016-11-01 22:01:12'),(1496,209,'C','','{\"colour_status\":\"1\",\"colour_code\":\"sadsa\",\"colour_name\":\"sadasd\",\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 22:25:24\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 22:25:24\"}','kaitong','2016-11-01 22:25:24'),(1497,209,'D','{\"colour_id\":177,\"colour_code\":\"sadsa\",\"colour_name\":\"sadasd\",\"colour_status\":1,\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-01 22:25:24\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-01 22:25:24\"}','','kaitong','2016-11-01 22:25:56'),(1498,210,'C','','{\"category_status\":\"1\",\"category_name\":\"Computer\",\"category_prefix\":\"CT\",\"category_nextnumber\":\"100\",\"category_createdby\":\"kaitong\",\"category_createddatetime\":\"2016-11-01 22:28:15\",\"category_updatedby\":\"kaitong\",\"category_updateddatetime\":\"2016-11-01 22:28:15\"}','kaitong','2016-11-01 22:28:15'),(1499,210,'C','','{\"category_status\":\"1\",\"category_name\":\"dqweqw\",\"category_prefix\":\"qweqw\",\"category_nextnumber\":\"111\",\"category_createdby\":\"kaitong\",\"category_createddatetime\":\"2016-11-01 22:28:47\",\"category_updatedby\":\"kaitong\",\"category_updateddatetime\":\"2016-11-01 22:28:47\"}','kaitong','2016-11-01 22:28:47'),(1500,210,'U','{\"category_id\":168,\"category_name\":\"dqweqw\",\"category_status\":1,\"category_prefix\":\"qweqw\",\"category_nextnumber\":111,\"category_createdby\":\"kaitong\",\"category_createddatetime\":\"2016-11-01 22:28:47\",\"category_updatedby\":\"kaitong\",\"category_updateddatetime\":\"2016-11-01 22:28:47\"}','{\"category_id\":168,\"category_name\":\"dqweqw\",\"category_status\":\"1\",\"category_prefix\":\"qweqw\",\"category_nextnumber\":\"222\",\"category_createdby\":\"kaitong\",\"category_createddatetime\":\"2016-11-01 22:28:47\",\"category_updatedby\":\"kaitong\",\"category_updateddatetime\":\"2016-11-01 22:28:51\"}','kaitong','2016-11-01 22:28:51'),(1501,210,'D','{\"category_id\":168,\"category_name\":\"dqweqw\",\"category_status\":1,\"category_prefix\":\"qweqw\",\"category_nextnumber\":222,\"category_createdby\":\"kaitong\",\"category_createddatetime\":\"2016-11-01 22:28:47\",\"category_updatedby\":\"kaitong\",\"category_updateddatetime\":\"2016-11-01 22:28:51\"}','','kaitong','2016-11-01 22:28:57'),(1502,209,'C','','{\"colour_status\":\"1\",\"colour_code\":\"YL\",\"colour_name\":\"sddasd\",\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-02 08:37:21\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-02 08:37:21\"}','kaitong','2016-11-02 08:37:21'),(1503,209,'D','{\"colour_id\":178,\"colour_code\":\"YL\",\"colour_name\":\"sddasd\",\"colour_status\":1,\"colour_createdby\":\"kaitong\",\"colour_createddatetime\":\"2016-11-02 08:37:21\",\"colour_updatedby\":\"kaitong\",\"colour_updateddatetime\":\"2016-11-02 08:37:21\"}','','kaitong','2016-11-02 08:37:31'),(1504,206,'C','','{\"currency_status\":\"1\",\"currency_code\":\"AAA\",\"currency_title\":\"\",\"currency_createdby\":\"kaitong\",\"currency_createddatetime\":\"2016-11-02 08:52:26\",\"currency_updatedby\":\"kaitong\",\"currency_updateddatetime\":\"2016-11-02 08:52:26\"}','kaitong','2016-11-02 08:52:26'),(1505,206,'C','','{\"currency_status\":\"1\",\"currency_code\":\"BBB\",\"currency_title\":\"\",\"currency_createdby\":\"kaitong\",\"currency_createddatetime\":\"2016-11-02 08:53:25\",\"currency_updatedby\":\"kaitong\",\"currency_updateddatetime\":\"2016-11-02 08:53:25\"}','kaitong','2016-11-02 08:53:25'),(1506,208,'C','','{\"reason_status\":\"1\",\"reason_name\":\"FAULTY\",\"reason_module\":\"STOCKADJ\",\"reason_createdby\":\"kaitong\",\"reason_createddatetime\":\"2016-11-02 08:57:34\",\"reason_updatedby\":\"kaitong\",\"reason_updateddatetime\":\"2016-11-02 08:57:34\"}','kaitong','2016-11-02 08:57:34'),(1507,208,'U','{\"reason_id\":169,\"reason_name\":\"LOST\",\"reason_module\":\"STOCKADJ\",\"reason_status\":1,\"reason_createdby\":\"kaitong\",\"reason_createddatetime\":\"2016-10-27 03:16:14\",\"reason_updatedby\":\"kaitong\",\"reason_updateddatetime\":\"2016-10-27 03:16:14\"}','{\"reason_id\":169,\"reason_name\":\"LOST\",\"reason_module\":\"STOCKADJ\",\"reason_status\":\"1\",\"reason_createdby\":\"kaitong\",\"reason_createddatetime\":\"2016-10-27 03:16:14\",\"reason_updatedby\":\"kaitong\",\"reason_updateddatetime\":\"2016-11-02 08:59:36\"}','kaitong','2016-11-02 08:59:36'),(1508,208,'U','{\"reason_id\":169,\"reason_name\":\"LOST\",\"reason_module\":\"STOCKADJ\",\"reason_status\":1,\"reason_createdby\":\"kaitong\",\"reason_createddatetime\":\"2016-10-27 03:16:14\",\"reason_updatedby\":\"kaitong\",\"reason_updateddatetime\":\"2016-11-02 08:59:36\"}','{\"reason_id\":169,\"reason_name\":\"LOST\",\"reason_module\":\"STOCKADJ\",\"reason_status\":\"1\",\"reason_createdby\":\"kaitong\",\"reason_createddatetime\":\"2016-10-27 03:16:14\",\"reason_updatedby\":\"kaitong\",\"reason_updateddatetime\":\"2016-11-02 09:01:14\"}','kaitong','2016-11-02 09:01:14'),(1509,203,'C','','{\"user_status\":\"Active\",\"user_id\":\"michael\",\"user_name\":\"michael\",\"user_password\":\"michael\",\"user_email\":\"michael@ccc.cxm\",\"user_createdby\":\"kaitong\",\"user_createddatetime\":\"2016-11-02 09:58:31\",\"user_updatedby\":\"kaitong\",\"user_updateddatetime\":\"2016-11-02 09:58:31\",\"user_authkey\":\"54VmcDkUXd_WAEC9F0Ijej8WJE-5LtaC\"}','kaitong','2016-11-02 09:58:31'),(1510,206,'D','{\"currency_id\":17,\"currency_title\":\"\",\"currency_code\":\"BBB\",\"currency_status\":1,\"currency_createdby\":\"kaitong\",\"currency_createddatetime\":\"2016-11-02 08:53:25\",\"currency_updatedby\":\"kaitong\",\"currency_updateddatetime\":\"2016-11-02 08:53:25\"}','','kaitong','2016-11-02 10:32:49'),(1511,206,'D','{\"currency_id\":16,\"currency_title\":\"\",\"currency_code\":\"AAA\",\"currency_status\":1,\"currency_createdby\":\"kaitong\",\"currency_createddatetime\":\"2016-11-02 08:52:26\",\"currency_updatedby\":\"kaitong\",\"currency_updateddatetime\":\"2016-11-02 08:52:26\"}','','kaitong','2016-11-02 10:37:47'),(1512,211,'C','','{\"product_status\":\"1\",\"product_categoryid\":\"165\",\"product_colourid\":\"168\",\"product_sku\":\"WC-13-GR\",\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_sellingprice\":\"130\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-08 23:20:06\",\"product_image\":\"WC-13-GR_20150902163713.jpg\"}','kaitong','2016-11-08 23:20:06'),(1513,211,'C','','{\"product_status\":\"1\",\"product_categoryid\":\"165\",\"product_colourid\":\"167\",\"product_sku\":\"WC-14-YL\",\"product_title\":\"Watch 14 Yellow\",\"product_description\":\"Watch 14 Yellow\",\"product_sellingprice\":\"140\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:34\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-08 23:20:34\",\"product_image\":\"WC-14-YL_20150902163805.jpg\"}','kaitong','2016-11-08 23:20:34'),(1514,211,'C','','{\"product_status\":\"1\",\"product_categoryid\":\"167\",\"product_colourid\":\"167\",\"product_sku\":\"CT-100-YL\",\"product_title\":\"Computer 001\",\"product_description\":\"Computer 001\",\"product_sellingprice\":\"\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-09 15:15:58\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-09 15:15:58\",\"product_image\":\"CT-100-YL_YENG.png\"}','kaitong','2016-11-09 15:15:58'),(1515,203,'U','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"$2y$13$y3Yg0Uk2QyrzvWBA19p/su2URworV.SJLb1oqJZpSrsntj8zNrbyq\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"admin\",\"user_updateddatetime\":\"2015-10-20 16:26:47\"}','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"chiangkl1234\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"kaitong\",\"user_updateddatetime\":\"2016-11-21 21:29:32\"}','kaitong','2016-11-21 21:29:32'),(1516,203,'U','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"$2y$13$ZUjAOia9HPG0BwDAmYlpPe3px/1QQSgkkrsRLX2njGsW1PvQMYpT6\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"kaitong\",\"user_updateddatetime\":\"2016-11-21 21:29:32\"}','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"chiangkl1234\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"chiangkl\",\"user_updateddatetime\":\"2016-11-21 22:06:14\"}','chiangkl','2016-11-21 22:06:14'),(1517,203,'U','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"chiangkl1234\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"chiangkl\",\"user_updateddatetime\":\"2016-11-21 22:06:14\"}','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"chiangkl1234\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"chiangkl\",\"user_updateddatetime\":\"2016-11-21 22:09:34\"}','chiangkl','2016-11-21 22:09:34'),(1518,203,'U','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"chiangkl1234\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"chiangkl\",\"user_updateddatetime\":\"2016-11-21 22:09:34\"}','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"chiangkl1234\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"chiangkl\",\"user_updateddatetime\":\"2016-11-21 22:10:47\"}','chiangkl','2016-11-21 22:10:47'),(1519,203,'U','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"chiangkl1234\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"chiangkl\",\"user_updateddatetime\":\"2016-11-21 22:10:47\"}','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"chiangkl1234\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"chiangkl\",\"user_updateddatetime\":\"2016-11-21 22:11:57\"}','chiangkl','2016-11-21 22:11:57'),(1520,203,'U','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"chiangkl1234\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"chiangkl\",\"user_updateddatetime\":\"2016-11-21 22:11:57\"}','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"$2y$13$vEbVzF05V8T/Vxl6NiC12.PnE44N0jSJy9m5naQKs7gTLQtTdARmi\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"chiangkl\",\"user_updateddatetime\":\"2016-11-21 22:17:07\"}','chiangkl','2016-11-21 22:17:07'),(1521,213,'U','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":0,\"product_balance\":0,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-08 23:20:06\"}','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":1000,\"product_balance\":1000,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-24 16:01:24\"}','kaitong','2016-11-24 16:01:24'),(1522,213,'U','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":1000,\"product_balance\":1000,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-24 16:01:24\"}','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":2000,\"product_balance\":2000,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-24 16:15:03\"}','kaitong','2016-11-24 16:15:03'),(1523,213,'U','{\"product_id\":169,\"product_sku\":\"WC-14-YL\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"Watch 14 Yellow\",\"product_description\":\"Watch 14 Yellow\",\"product_image\":\"WC-14-YL_20150902163805.jpg\",\"product_accquantity\":0,\"product_balance\":0,\"product_sellingprice\":\"140.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:34\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-08 23:20:34\"}','{\"product_id\":169,\"product_sku\":\"WC-14-YL\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"Watch 14 Yellow\",\"product_description\":\"Watch 14 Yellow\",\"product_image\":\"WC-14-YL_20150902163805.jpg\",\"product_accquantity\":100,\"product_balance\":100,\"product_sellingprice\":\"140.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:34\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-24 16:15:03\"}','kaitong','2016-11-24 16:15:03'),(1524,213,'U','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":2000,\"product_balance\":2000,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-24 16:15:03\"}','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":3000,\"product_balance\":3000,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-24 16:18:01\"}','kaitong','2016-11-24 16:18:01'),(1525,213,'U','{\"product_id\":169,\"product_sku\":\"WC-14-YL\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"Watch 14 Yellow\",\"product_description\":\"Watch 14 Yellow\",\"product_image\":\"WC-14-YL_20150902163805.jpg\",\"product_accquantity\":100,\"product_balance\":100,\"product_sellingprice\":\"140.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:34\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-24 16:15:03\"}','{\"product_id\":169,\"product_sku\":\"WC-14-YL\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"Watch 14 Yellow\",\"product_description\":\"Watch 14 Yellow\",\"product_image\":\"WC-14-YL_20150902163805.jpg\",\"product_accquantity\":200,\"product_balance\":200,\"product_sellingprice\":\"140.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:34\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-24 16:18:01\"}','kaitong','2016-11-24 16:18:01'),(1526,213,'U','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":3000,\"product_balance\":3000,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-24 16:18:01\"}','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":3600,\"product_balance\":3600,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 07:45:55\"}','kaitong','2016-11-25 07:45:55'),(1527,213,'U','{\"product_id\":169,\"product_sku\":\"WC-14-YL\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"Watch 14 Yellow\",\"product_description\":\"Watch 14 Yellow\",\"product_image\":\"WC-14-YL_20150902163805.jpg\",\"product_accquantity\":200,\"product_balance\":200,\"product_sellingprice\":\"140.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:34\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-24 16:18:01\"}','{\"product_id\":169,\"product_sku\":\"WC-14-YL\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"Watch 14 Yellow\",\"product_description\":\"Watch 14 Yellow\",\"product_image\":\"WC-14-YL_20150902163805.jpg\",\"product_accquantity\":600,\"product_balance\":600,\"product_sellingprice\":\"140.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:34\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 07:45:55\"}','kaitong','2016-11-25 07:45:55'),(1528,213,'U','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":3600,\"product_balance\":3600,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 07:45:55\"}','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":3001,\"product_balance\":3001,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 07:46:15\"}','kaitong','2016-11-25 07:46:15'),(1529,213,'U','{\"product_id\":169,\"product_sku\":\"WC-14-YL\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"Watch 14 Yellow\",\"product_description\":\"Watch 14 Yellow\",\"product_image\":\"WC-14-YL_20150902163805.jpg\",\"product_accquantity\":600,\"product_balance\":600,\"product_sellingprice\":\"140.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:34\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 07:45:55\"}','{\"product_id\":169,\"product_sku\":\"WC-14-YL\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"Watch 14 Yellow\",\"product_description\":\"Watch 14 Yellow\",\"product_image\":\"WC-14-YL_20150902163805.jpg\",\"product_accquantity\":201,\"product_balance\":201,\"product_sellingprice\":\"140.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:34\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 07:46:15\"}','kaitong','2016-11-25 07:46:15'),(1530,213,'U','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":3001,\"product_balance\":3001,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 07:46:15\"}','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":3011,\"product_balance\":3011,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 10:14:43\"}','kaitong','2016-11-25 10:14:43'),(1531,215,'U','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":3011,\"product_balance\":3011,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 10:14:43\"}','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":3011,\"product_balance\":3021,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 18:14:16\"}','kaitong','2016-11-25 18:14:16'),(1532,215,'U','{\"product_id\":169,\"product_sku\":\"WC-14-YL\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"Watch 14 Yellow\",\"product_description\":\"Watch 14 Yellow\",\"product_image\":\"WC-14-YL_20150902163805.jpg\",\"product_accquantity\":201,\"product_balance\":201,\"product_sellingprice\":\"140.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:34\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 07:46:15\"}','{\"product_id\":169,\"product_sku\":\"WC-14-YL\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"Watch 14 Yellow\",\"product_description\":\"Watch 14 Yellow\",\"product_image\":\"WC-14-YL_20150902163805.jpg\",\"product_accquantity\":201,\"product_balance\":196,\"product_sellingprice\":\"140.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:34\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 18:14:27\"}','kaitong','2016-11-25 18:14:27'),(1533,211,'U','{\"product_id\":167,\"product_sku\":\"B003\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"dsfdsf12345678\",\"product_description\":\"testing\",\"product_image\":\"123456_20150902163537.jpg\",\"product_accquantity\":0,\"product_balance\":0,\"product_sellingprice\":\"16.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-10-11 09:42:51\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-10-28 22:15:57\"}','{\"product_id\":167,\"product_sku\":\"B003\",\"product_categoryid\":\"165\",\"product_colourid\":167,\"product_title\":\"dsfdsf12345678\",\"product_description\":\"testing\",\"product_image\":\"123456_20150902163537.jpg\",\"product_accquantity\":\"0\",\"product_balance\":\"0\",\"product_sellingprice\":\"16.00\",\"product_costprice\":\"0.00\",\"product_status\":\"1\",\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-10-11 09:42:51\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2017-03-15 17:45:57\"}','kaitong','2017-03-15 17:45:57'),(1534,210,'C','','{\"paymentterm_status\":\"1\",\"paymentterm_name\":\"Cash On Delivery\",\"paymentterm_number\":\"0\",\"paymentterm_createdby\":\"kaitong\",\"paymentterm_createddatetime\":\"2017-03-25 08:43:45\",\"paymentterm_updatedby\":\"kaitong\",\"paymentterm_updateddatetime\":\"2017-03-25 08:43:45\"}','kaitong','2017-03-25 08:43:45'),(1535,210,'C','','{\"paymentterm_status\":\"1\",\"paymentterm_name\":\"30 Days\",\"paymentterm_number\":\"30\",\"paymentterm_createdby\":\"kaitong\",\"paymentterm_createddatetime\":\"2017-03-25 08:44:35\",\"paymentterm_updatedby\":\"kaitong\",\"paymentterm_updateddatetime\":\"2017-03-25 08:44:35\"}','kaitong','2017-03-25 08:44:35'),(1536,207,'U','{\"customer_id\":11,\"customer_name\":\"Taobao\",\"customer_address\":\"China\",\"customer_contactperson\":\"Ah Long\",\"customer_contactnumber\":\"1234567\",\"customer_fax\":\"\",\"customer_email\":\"\",\"customer_status\":1,\"customer_createdby\":\"admin\",\"customer_createddatetime\":\"2016-10-18 03:59:26\",\"customer_updatedby\":\"admin\",\"customer_updateddatetime\":\"2016-10-18 03:59:26\"}','{\"customer_id\":11,\"customer_name\":\"Taobao\",\"customer_address\":\"China\",\"customer_contactperson\":\"Ah Long\",\"customer_contactnumber\":\"1234567\",\"customer_fax\":\"7654321\",\"customer_email\":\"casasd@asdasdsa.cxm\",\"customer_status\":\"1\",\"customer_createdby\":\"admin\",\"customer_createddatetime\":\"2016-10-18 03:59:26\",\"customer_updatedby\":\"kaitong\",\"customer_updateddatetime\":\"2017-03-28 17:07:51\"}','kaitong','2017-03-28 17:07:51'),(1537,207,'U','{\"customer_id\":11,\"customer_name\":\"Taobao\",\"customer_address\":\"China\",\"customer_contactperson\":\"Ah Long\",\"customer_contactnumber\":\"1234567\",\"customer_fax\":\"7654321\",\"customer_email\":\"casasd@asdasdsa.cxm\",\"customer_status\":1,\"customer_createdby\":\"admin\",\"customer_createddatetime\":\"2016-10-18 03:59:26\",\"customer_updatedby\":\"kaitong\",\"customer_updateddatetime\":\"2017-03-28 17:07:51\"}','{\"customer_id\":11,\"customer_name\":\"Taobao\",\"customer_address\":\"31 Jalan Nyaman 10\\r\\nTaman Gembira\\r\\n58200 Kuala Lumpur\",\"customer_contactperson\":\"Ah Long\",\"customer_contactnumber\":\"1234567\",\"customer_fax\":\"7654321\",\"customer_email\":\"casasd@asdasdsa.cxm\",\"customer_status\":\"1\",\"customer_createdby\":\"admin\",\"customer_createddatetime\":\"2016-10-18 03:59:26\",\"customer_updatedby\":\"kaitong\",\"customer_updateddatetime\":\"2017-03-28 17:08:15\"}','kaitong','2017-03-28 17:08:15'),(1538,211,'U','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":165,\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":3011,\"product_balance\":3021,\"product_sellingprice\":\"130.00\",\"product_costprice\":\"15.31\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2016-11-25 18:14:16\"}','{\"product_id\":168,\"product_sku\":\"WC-13-GR\",\"product_categoryid\":\"165\",\"product_colourid\":168,\"product_title\":\"Watch WC-13 Green\",\"product_description\":\"Watch WC-13 Green Description\",\"product_image\":\"WC-13-GR_20150902163713.jpg\",\"product_accquantity\":\"3011\",\"product_balance\":\"3021\",\"product_sellingprice\":\"130.00\",\"product_costprice\":\"15.31\",\"product_status\":\"1\",\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-11-08 23:20:06\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2017-03-29 14:57:52\"}','kaitong','2017-03-29 14:57:52'),(1539,211,'U','{\"product_id\":167,\"product_sku\":\"B003\",\"product_categoryid\":165,\"product_colourid\":167,\"product_title\":\"dsfdsf12345678\",\"product_description\":\"testing\",\"product_image\":\"123456_20150902163537.jpg\",\"product_accquantity\":0,\"product_balance\":0,\"product_sellingprice\":\"16.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-10-11 09:42:51\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2017-03-15 17:45:57\"}','{\"product_id\":167,\"product_sku\":\"B003\",\"product_categoryid\":\"165\",\"product_colourid\":167,\"product_title\":\"dsfdsf12345678\",\"product_description\":\"testing 1\\r\\ntesting 2\\r\\ntesting 3\",\"product_image\":\"123456_20150902163537.jpg\",\"product_accquantity\":\"0\",\"product_balance\":\"0\",\"product_sellingprice\":\"16.00\",\"product_costprice\":\"0.00\",\"product_status\":\"1\",\"product_taxrate\":\"0.00\",\"product_createdby\":\"kaitong\",\"product_createddatetime\":\"2016-10-11 09:42:51\",\"product_updatedby\":\"kaitong\",\"product_updateddatetime\":\"2017-03-29 16:06:15\"}','kaitong','2017-03-29 16:06:15'),(1540,203,'U','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Kl Cheong\",\"user_password\":\"$2y$13$vEbVzF05V8T/Vxl6NiC12.PnE44N0jSJy9m5naQKs7gTLQtTdARmi\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"chiangkl\",\"user_updateddatetime\":\"2016-11-21 22:17:07\"}','{\"user_no\":29,\"user_id\":\"chiangkl\",\"user_name\":\"Cheong Kok Leong\",\"user_password\":\"$2y$13$p96Ue3rrEYgDPoEmaQtLUO7KUKv4wJWjb/4uVe8jY4q7DY/PuAyUS\",\"user_email\":\"cheongkl@gmail.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":null,\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"kaitong\",\"user_updateddatetime\":\"2017-03-30 16:37:56\"}','kaitong','2017-03-30 16:37:56'),(1541,203,'U','{\"user_no\":28,\"user_id\":\"cheongyy\",\"user_name\":\"Cheong Yeng Yeng\",\"user_password\":\"$2y$13$ZUjAOia9HPG0BwDAmYlpPe3px/1QQSgkkrsRLX2njGsW1PvQMYpT6\",\"user_email\":\"yengyeng@yahoo.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":\"54VmcDkUXd_WAEC9F0Ijej8WJE-5LtaC\",\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"admin\",\"user_updateddatetime\":\"2015-10-21 00:31:59\"}','{\"user_no\":28,\"user_id\":\"cheongyy\",\"user_name\":\"Cheong Yeng Yeng\",\"user_password\":\"$2y$13$TNIKSPKruUER1vlmlEawBODNPiHGmtlw5I77fYLCyz5kVUGMR6JJ6\",\"user_email\":\"yengyeng@yahoo.com\",\"user_status\":\"Active\",\"user_adminrole\":1,\"user_teacherrole\":1,\"user_studentrole\":1,\"user_madrasahrole\":1,\"user_failedcount\":0,\"user_lastactivity\":null,\"user_token\":null,\"user_authkey\":\"54VmcDkUXd_WAEC9F0Ijej8WJE-5LtaC\",\"user_createdby\":\"admin\",\"user_createddatetime\":\"2015-01-01 12:00:00\",\"user_updatedby\":\"chiangkl\",\"user_updateddatetime\":\"2017-03-30 16:40:25\"}','chiangkl','2017-03-30 16:40:25'),(1542,208,'U','{\"paymentterm_id\":169,\"paymentterm_name\":\"Cash On Delivery\",\"paymentterm_status\":1,\"paymentterm_number\":0,\"paymentterm_createdby\":\"kaitong\",\"paymentterm_createddatetime\":\"2017-03-25 08:43:45\",\"paymentterm_updatedby\":\"kaitong\",\"paymentterm_updateddatetime\":\"2017-03-25 08:43:45\"}','{\"paymentterm_id\":169,\"paymentterm_name\":\"Cash\",\"paymentterm_status\":\"1\",\"paymentterm_number\":\"0\",\"paymentterm_createdby\":\"kaitong\",\"paymentterm_createddatetime\":\"2017-03-25 08:43:45\",\"paymentterm_updatedby\":\"chiangkl\",\"paymentterm_updateddatetime\":\"2017-03-30 16:41:28\"}','chiangkl','2017-03-30 16:41:28'),(1543,207,'C','','{\"customer_status\":\"1\",\"customer_name\":\"Dellmax Trading and Service\",\"customer_address\":\"43300 Seri Kembangan\\r\\nSelangor\",\"customer_contactperson\":\"James\",\"customer_contactnumber\":\"0122125737\",\"customer_fax\":\"\",\"customer_email\":\"mwater.james@gmail.com\",\"customer_createdby\":\"chiangkl\",\"customer_createddatetime\":\"2017-03-30 16:47:02\",\"customer_updatedby\":\"chiangkl\",\"customer_updateddatetime\":\"2017-03-30 16:47:02\"}','chiangkl','2017-03-30 16:47:02'),(1544,207,'C','','{\"customer_status\":\"1\",\"customer_name\":\"Herdiva Sdn. Bhd.\",\"customer_address\":\"21, Jalan Samarinda 21,\\r\\nTaman Emas, Batu 3 1/2, Kampung Jawa, \\r\\n41000 Klang, Selangor\",\"customer_contactperson\":\"Kenny Ong\",\"customer_contactnumber\":\"0102223839\",\"customer_fax\":\"\",\"customer_email\":\"salesherdiva@gmail.com\",\"customer_createdby\":\"chiangkl\",\"customer_createddatetime\":\"2017-03-30 16:51:10\",\"customer_updatedby\":\"chiangkl\",\"customer_updateddatetime\":\"2017-03-30 16:51:10\"}','chiangkl','2017-03-30 16:51:10'),(1545,207,'C','','{\"customer_status\":\"1\",\"customer_name\":\"Eco Active Resources\",\"customer_address\":\"Taman Pinggiran Putra, Seksyen 1,\\r\\n43300 Seri Kembangan,\\r\\nSelangor\",\"customer_contactperson\":\"Kim\",\"customer_contactnumber\":\"0389424921\",\"customer_fax\":\"\",\"customer_email\":\"sjyeong76@hotmail.com\",\"customer_createdby\":\"chiangkl\",\"customer_createddatetime\":\"2017-03-30 16:53:26\",\"customer_updatedby\":\"chiangkl\",\"customer_updateddatetime\":\"2017-03-30 16:53:26\"}','chiangkl','2017-03-30 16:53:26'),(1546,207,'C','','{\"customer_status\":\"1\",\"customer_name\":\"Bulan Restu Sdn Bhd\",\"customer_address\":\"282, Jalan Segambut,\\r\\n51200 Kuala Lumpur\",\"customer_contactperson\":\"Jessie Chua\",\"customer_contactnumber\":\"0362501035\",\"customer_fax\":\"\",\"customer_email\":\"jessie.chua@firstcoach.com.my\",\"customer_createdby\":\"chiangkl\",\"customer_createddatetime\":\"2017-03-30 16:55:29\",\"customer_updatedby\":\"chiangkl\",\"customer_updateddatetime\":\"2017-03-30 16:55:29\"}','chiangkl','2017-03-30 16:55:29'),(1547,210,'U','{\"category_id\":171,\"category_name\":\"E-Commerce\",\"category_status\":1,\"category_prefix\":\"EC\",\"category_nextnumber\":5000,\"category_createdby\":\"kaitong\",\"category_createddatetime\":\"2016-11-01 22:28:15\",\"category_updatedby\":\"kaitong\",\"category_updateddatetime\":\"2016-11-01 22:28:15\"}','{\"category_id\":171,\"category_name\":\"Trading\",\"category_status\":\"1\",\"category_prefix\":\"TD\",\"category_nextnumber\":\"5000\",\"category_createdby\":\"kaitong\",\"category_createddatetime\":\"2016-11-01 22:28:15\",\"category_updatedby\":\"chiangkl\",\"category_updateddatetime\":\"2017-03-30 16:56:40\"}','chiangkl','2017-03-30 16:56:40'),(1548,210,'C','','{\"category_status\":\"1\",\"category_name\":\"Hosting\",\"category_prefix\":\"HT\",\"category_nextnumber\":\"7000\",\"category_createdby\":\"chiangkl\",\"category_createddatetime\":\"2017-03-30 16:57:34\",\"category_updatedby\":\"chiangkl\",\"category_updateddatetime\":\"2017-03-30 16:57:34\"}','chiangkl','2017-03-30 16:57:34'),(1549,211,'C','','{\"product_status\":\"1\",\"product_categoryid\":\"173\",\"product_sku\":\"HT-7000\",\"product_title\":\"Web Hosting\",\"product_description\":\"- Domain :\\r\\n- Period : \",\"product_sellingprice\":\"0\",\"product_createdby\":\"chiangkl\",\"product_createddatetime\":\"2017-03-30 16:58:32\",\"product_updatedby\":\"chiangkl\",\"product_updateddatetime\":\"2017-03-30 16:58:32\"}','chiangkl','2017-03-30 16:58:32'),(1550,211,'U','{\"product_id\":171,\"product_sku\":\"HT-7000\",\"product_categoryid\":173,\"product_colourid\":null,\"product_title\":\"Web Hosting\",\"product_description\":\"- Domain :\\r\\n- Period : \",\"product_image\":\"\",\"product_accquantity\":0,\"product_balance\":0,\"product_sellingprice\":\"0.00\",\"product_costprice\":\"0.00\",\"product_status\":1,\"product_taxrate\":\"0.00\",\"product_createdby\":\"chiangkl\",\"product_createddatetime\":\"2017-03-30 16:58:32\",\"product_updatedby\":\"chiangkl\",\"product_updateddatetime\":\"2017-03-30 16:58:32\"}','{\"product_id\":171,\"product_sku\":\"HT-7000\",\"product_categoryid\":\"173\",\"product_colourid\":null,\"product_title\":\"Web Hosting Fees\",\"product_description\":\"- Domain :\\r\\n- Period : \",\"product_image\":\"\",\"product_accquantity\":\"0\",\"product_balance\":\"0\",\"product_sellingprice\":\"0.00\",\"product_costprice\":\"0.00\",\"product_status\":\"1\",\"product_taxrate\":\"0.00\",\"product_createdby\":\"chiangkl\",\"product_createddatetime\":\"2017-03-30 16:58:32\",\"product_updatedby\":\"chiangkl\",\"product_updateddatetime\":\"2017-03-30 16:58:48\"}','chiangkl','2017-03-30 16:58:48'),(1551,211,'C','','{\"product_status\":\"1\",\"product_categoryid\":\"173\",\"product_sku\":\"HT-7001\",\"product_title\":\"Domain Fees\",\"product_description\":\"- Domain :\\r\\n- Period :\",\"product_sellingprice\":\"0\",\"product_createdby\":\"chiangkl\",\"product_createddatetime\":\"2017-03-30 16:59:34\",\"product_updatedby\":\"chiangkl\",\"product_updateddatetime\":\"2017-03-30 16:59:34\"}','chiangkl','2017-03-30 16:59:34'),(1552,211,'C','','{\"product_status\":\"1\",\"product_categoryid\":\"169\",\"product_sku\":\"SM-3000\",\"product_title\":\"Software Maintenance\",\"product_description\":\"- CRM Software\\r\\n- Period :\",\"product_sellingprice\":\"0\",\"product_createdby\":\"chiangkl\",\"product_createddatetime\":\"2017-03-30 17:00:06\",\"product_updatedby\":\"chiangkl\",\"product_updateddatetime\":\"2017-03-30 17:00:06\"}','chiangkl','2017-03-30 17:00:06'),(1553,211,'C','','{\"product_status\":\"1\",\"product_categoryid\":\"172\",\"product_sku\":\"SV-6000\",\"product_title\":\"Services\",\"product_description\":\"- Description\",\"product_sellingprice\":\"0\",\"product_createdby\":\"chiangkl\",\"product_createddatetime\":\"2017-03-30 17:00:54\",\"product_updatedby\":\"chiangkl\",\"product_updateddatetime\":\"2017-03-30 17:00:54\"}','chiangkl','2017-03-30 17:00:54'),(1554,211,'C','','{\"product_status\":\"1\",\"product_categoryid\":\"165\",\"product_sku\":\"SW-1000\",\"product_title\":\"Customized Software Development\",\"product_description\":\"- Scope\",\"product_sellingprice\":\"0\",\"product_createdby\":\"chiangkl\",\"product_createddatetime\":\"2017-03-30 17:01:28\",\"product_updatedby\":\"chiangkl\",\"product_updateddatetime\":\"2017-03-30 17:01:28\"}','chiangkl','2017-03-30 17:01:28');

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(50) DEFAULT NULL,
  `menu_category` varchar(255) DEFAULT NULL,
  `menu_subcategory` varchar(255) DEFAULT NULL,
  `menu_url` varchar(255) DEFAULT NULL,
  `menu_displayorder` bigint(20) NOT NULL,
  `menu_icon` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=227 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (203,'User','Maintenance',NULL,'/users',300,'life-ring'),(206,'Currency','Maintenance',NULL,'/currencies',330,'life-ring'),(207,'Customer','Maintenance',NULL,'/customers',340,'life-ring'),(208,'Payment Terms','Maintenance',NULL,'/paymentterms',350,'life-ring'),(210,'Category','Maintenance',NULL,'/categories',370,'life-ring'),(211,'Product','Maintenance',NULL,'/products',380,'life-ring'),(212,'Sales','Transaction',NULL,'/sales',100,'empire'),(217,'Sales Report','Report',NULL,'/salesreport',500,'file-word-o'),(226,'Product Movement','Report',NULL,'/productmovement',560,'file-word-o');

--
-- Table structure for table `movements`
--

CREATE TABLE `movements` (
  `movement_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `movement_module` varchar(50) DEFAULT NULL,
  `movement_productid` int(11) DEFAULT NULL,
  `movement_refid` int(11) DEFAULT NULL,
  `movement_refno` varchar(50) DEFAULT NULL,
  `movement_description` varchar(255) DEFAULT NULL,
  `movement_quantity` int(11) DEFAULT '0',
  `movement_unitprice` decimal(12,2) DEFAULT '0.00',
  `movement_webstoreid` int(11) DEFAULT NULL,
  `movement_affectbalance` tinyint(1) DEFAULT NULL,
  `movement_createdby` varchar(20) DEFAULT NULL,
  `movement_createddatetime` datetime DEFAULT NULL,
  `movement_updatedby` varchar(20) DEFAULT NULL,
  `movement_updateddatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`movement_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `movements`
--

INSERT INTO `movements` VALUES (1,'STOCKIN',167,NULL,NULL,'Order',10,0.00,1,1,'kaitong','2016-11-08 22:52:11',NULL,NULL),(2,'STOCKIN',167,NULL,NULL,'Order',15,0.00,1,1,'kaitong','2016-11-09 22:52:17',NULL,NULL),(3,'RETURN',167,NULL,NULL,'Stock Return',-1,0.00,1,1,'kaitong','2016-11-10 00:00:00',NULL,NULL),(4,'STOCKIN',168,86,NULL,'Stock In',2000,19.99,NULL,1,'kaitong','2016-11-24 16:15:03','kaitong','2016-11-24 16:15:03'),(5,'STOCKIN',169,86,NULL,'Stock In',100,9.99,NULL,1,'kaitong','2016-11-24 16:15:03','kaitong','2016-11-24 16:15:03'),(6,'STOCKIN',168,87,NULL,'Stock In',1000,19.99,NULL,1,'kaitong','2016-11-24 16:18:01','kaitong','2016-11-24 16:18:01'),(7,'STOCKIN',169,87,NULL,'Stock In',100,9.99,NULL,1,'kaitong','2016-11-24 16:18:01','kaitong','2016-11-24 16:18:01'),(8,'STOCKIN',168,88,NULL,'Stock In',1,19.99,NULL,1,'kaitong','2016-11-25 07:45:55','kaitong','2016-11-25 07:46:15'),(9,'STOCKIN',169,88,NULL,'Stock In',1,9.99,NULL,1,'kaitong','2016-11-25 07:45:55','kaitong','2016-11-25 07:46:15'),(10,'STOCKIN',168,90,NULL,'Stock In',10,1.25,NULL,1,'kaitong','2016-11-25 10:14:43','kaitong','2016-11-25 10:14:43'),(11,'STOCKADJ',168,4,NULL,'Stock Adjustment',10,0.00,NULL,1,'kaitong','2016-11-25 18:14:16','kaitong','2016-11-25 18:14:16'),(12,'STOCKADJ',169,4,NULL,'Stock Adjustment',-5,0.00,NULL,1,'kaitong','2016-11-25 18:14:27','kaitong','2016-11-25 18:14:27');

--
-- Table structure for table `paymentterms`
--

CREATE TABLE `paymentterms` (
  `paymentterm_id` int(11) NOT NULL AUTO_INCREMENT,
  `paymentterm_name` varchar(50) DEFAULT '',
  `paymentterm_status` int(1) NOT NULL DEFAULT '1',
  `paymentterm_number` bigint(20) DEFAULT '1',
  `paymentterm_createdby` varchar(50) DEFAULT '',
  `paymentterm_createddatetime` datetime NOT NULL,
  `paymentterm_updatedby` varchar(50) DEFAULT '',
  `paymentterm_updateddatetime` datetime NOT NULL,
  PRIMARY KEY (`paymentterm_id`)
) ENGINE=MyISAM AUTO_INCREMENT=172 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `paymentterms`
--

INSERT INTO `paymentterms` VALUES (169,'Cash',1,0,'kaitong','2017-03-25 08:43:45','chiangkl','2017-03-30 16:41:28'),(170,'30 Days',1,30,'kaitong','2017-03-25 08:44:35','cheongyy','2017-05-03 19:38:59');

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_sku` varchar(50) DEFAULT '',
  `product_categoryid` int(11) DEFAULT NULL,
  `product_colourid` int(11) DEFAULT NULL,
  `product_title` text,
  `product_description` varchar(255) DEFAULT '',
  `product_image` varchar(255) DEFAULT '',
  `product_accquantity` int(11) DEFAULT '0',
  `product_balance` int(11) DEFAULT '0',
  `product_sellingprice` decimal(12,2) DEFAULT '0.00',
  `product_costprice` decimal(12,2) DEFAULT '0.00',
  `product_status` int(11) DEFAULT NULL,
  `product_taxrate` decimal(12,2) DEFAULT '0.00',
  `product_createdby` varchar(50) DEFAULT '',
  `product_createddatetime` datetime NOT NULL,
  `product_updatedby` varchar(50) DEFAULT '',
  `product_updateddatetime` datetime NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=MyISAM AUTO_INCREMENT=182 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `products`
--

INSERT INTO `products` VALUES (174,'SV-6000',172,NULL,'Services','- Description','',0,0,0.00,0.00,1,0.00,'chiangkl','2017-03-30 17:00:54','chiangkl','2017-03-30 17:00:54'),(175,'SW-1000',165,NULL,'Customized Software Development','- Scope','',0,0,0.00,0.00,1,0.00,'chiangkl','2017-03-30 17:01:28','cheongyy','2017-04-21 00:14:40'),(173,'SM-3000',169,NULL,'Software Maintenance','- CRM Software\r\n- Period :','',0,0,0.00,0.00,1,0.00,'chiangkl','2017-03-30 17:00:06','chiangkl','2017-03-30 17:00:06'),(172,'HT-7001',173,NULL,'Domain Fees','- Domain :\r\n- Period :','',0,0,0.00,0.00,1,0.00,'chiangkl','2017-03-30 16:59:34','chiangkl','2017-03-30 16:59:34'),(171,'HT-7000',173,NULL,'Web Hosting Fees','- Domain :\r\n- Period : ','',0,0,0.00,0.00,1,0.00,'chiangkl','2017-03-30 16:58:32','chiangkl','2017-03-30 16:58:48'),(177,'HW-1001',167,NULL,'SATA Cable','SATA Cable','',0,0,15.00,0.00,1,0.00,'chiangkl','2017-08-20 14:54:49','chiangkl','2017-08-20 14:54:49'),(178,'SSLCERT',173,NULL,'SSL Certificate','EssentialSSL Wildcard Certificate\r\n','',0,0,400.00,0.00,1,0.00,'chiangkl','2018-09-12 09:27:47','chiangkl','2018-09-12 09:27:47'),(179,'INTSRV',172,NULL,'Integration Service','Maybank Payment Gateway Integration Service','',0,0,2000.00,0.00,1,0.00,'chiangkl','2018-09-12 09:28:53','chiangkl','2018-09-12 09:28:53'),(180,'B2BINT',172,NULL,'B2B Intergration Service','RedBus','',0,0,5500.00,0.00,1,0.00,'chiangkl','2018-09-12 09:29:32','chiangkl','2018-09-12 09:29:32'),(181,'INSTALL',172,NULL,'Installation Fees','Installation of','',0,0,0.00,0.00,1,0.00,'chiangkl','2018-09-12 09:37:37','chiangkl','2018-09-12 09:37:37');

--
-- Table structure for table `saledetails`
--

CREATE TABLE `saledetails` (
  `saledetail_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `saledetail_saleid` bigint(20) NOT NULL DEFAULT '0',
  `saledetail_displayorder` int(11) DEFAULT '0',
  `saledetail_productid` bigint(20) NOT NULL DEFAULT '0',
  `saledetail_title` varchar(100) DEFAULT '',
  `saledetail_description` text,
  `saledetail_quantity` bigint(20) NOT NULL DEFAULT '0',
  `saledetail_uom` varchar(5) DEFAULT '',
  `saledetail_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `saledetail_total` decimal(12,2) DEFAULT '0.00',
  `saledetail_createdby` varchar(20) DEFAULT NULL,
  `saledetail_createddatetime` datetime DEFAULT NULL,
  `saledetail_updatedby` varchar(20) DEFAULT NULL,
  `saledetail_updateddatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`saledetail_id`)
) ENGINE=InnoDB AUTO_INCREMENT=305 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `saledetails`
--

INSERT INTO `saledetails` VALUES (13,1,10,173,'Software Maintenance','- CRM Software\n- Period : Jan, Feb, Mar 2017',3,'mths',300.00,900.00,'chiangkl','2017-03-30 17:09:30','chiangkl','2017-03-30 17:09:30'),(14,2,10,173,'Website Maintenance Fees','- herdivaonlinefashion.com\n- Period : Jan, Feb, Mar 2017',3,'mths',250.00,750.00,'chiangkl','2017-03-30 18:46:26','chiangkl','2017-03-30 18:49:20'),(15,2,10,171,'VPS Hosting Fees','- Period : Jan, Feb, Mar 2017',3,'mths',180.00,540.00,'chiangkl','2017-03-30 18:47:09','chiangkl','2017-03-30 18:47:09'),(16,2,10,175,'Job Order Module Addon','- scope as per e-mail dated 5th Jan 2017',1,'L/S',2500.00,2500.00,'chiangkl','2017-03-30 18:53:40','chiangkl','2017-03-30 18:53:40'),(17,3,10,175,'Being 40% deposit payment for Firstcoach Bus Ticketing System','- Online Web Ticketing System\n- Counter Self Service Application\n- Hybrid Mobile Application\n- RESTFUL API Backend\n- RM74000 x 40%',1,'L/S',29600.00,29600.00,'chiangkl','2017-03-30 19:00:26','chiangkl','2017-03-30 19:00:26'),(18,80004,10,171,'Web Hosting and Domain Fees','- Domain : suprimacomm.com\n- Period : 28/3/2017 - 27/3/2018',1,'year',320.00,320.00,'chiangkl','2017-04-23 09:47:17','chiangkl','2017-04-23 09:49:04'),(19,80005,10,174,'Remote Services (weight4me)','- Purging of old logs\n- Housekeeping of database',1,'L/S',120.00,120.00,'chiangkl','2017-04-25 12:30:51','chiangkl','2017-04-25 12:31:32'),(20,80006,10,175,'POS Software Enhancement','- Outlet Stock Balance synchronization to HQ\n- Deploy to 6 counters',1,'L/S',850.00,850.00,'chiangkl','2017-04-25 19:26:36','chiangkl','2017-04-25 19:26:36'),(21,80008,10,174,'Services','- Bus Application Remote Installation\n- 100% identical client installation',1,'L/S',250.00,250.00,'chiangkl','2017-04-28 14:59:23','chiangkl','2017-04-28 14:59:23'),(22,80009,10,174,'Services Rendered For Feb 2017','',1,'mth',1800.00,1800.00,'chiangkl','2017-05-25 14:31:38','chiangkl','2017-05-25 14:31:38'),(23,80010,10,174,'Services Rendered For Mar 2017 ','',1,'mth',1800.00,1800.00,'chiangkl','2017-05-25 14:33:25','chiangkl','2017-05-25 14:34:18'),(24,80011,10,174,'Services Rendered For Apr 2017 ','',1,'mth',1800.00,1800.00,'chiangkl','2017-05-25 14:35:11','chiangkl','2017-05-25 14:35:11'),(25,80007,10,174,'Maintenance for CRM','- For Apr,  May and Jun 2017',3,'mths',300.00,900.00,'chiangkl','2017-05-25 14:37:30','chiangkl','2017-05-25 14:37:30'),(26,80012,10,173,'Website Maintenance Fees','- herdivaonlinefashion.com\n- Period : Apr and May 2017\n',2,'mths',250.00,500.00,'chiangkl','2017-05-25 14:50:07','chiangkl','2017-05-25 14:50:07'),(27,80012,10,174,'VPS Hosting Fees','- Period : Apr, May 2017',2,'mths',180.00,360.00,'chiangkl','2017-05-25 14:50:44','chiangkl','2017-05-25 14:50:44'),(28,80013,10,174,'CRM Software Maintenance','- Period : Apr and May 2017',2,'mths',500.00,1000.00,'chiangkl','2017-05-25 14:59:09','chiangkl','2017-05-25 14:59:09'),(29,80014,10,174,'CRM Software Maintenance','- Period : June 2017',1,'mth',500.00,500.00,'chiangkl','2017-05-25 15:02:50','chiangkl','2017-05-25 15:02:50'),(30,80015,10,175,'Corporate Website Development','- Being fees on website development\n- As per quotation #20170607-TAP',1,'L/S',2000.00,2000.00,'chiangkl','2017-06-29 12:47:09','chiangkl','2017-07-03 12:23:22'),(31,80016,10,173,'CRM Software Maintenance','- Period : July 2017',1,'mth',500.00,500.00,'chiangkl','2017-07-03 12:28:04','chiangkl','2017-07-03 12:28:38'),(32,80017,10,173,'CRM Software Maintenance','- Period : June and July 2017',2,'mths',500.00,1000.00,'chiangkl','2017-07-03 12:31:51','chiangkl','2017-07-03 12:31:51'),(33,80018,10,173,'Website Maintenance Fees','- herdivaonlinefashion.com\n- Period : June and July 2017',2,'mths',250.00,500.00,'chiangkl','2017-07-03 12:39:56','chiangkl','2017-07-03 12:39:56'),(34,80018,10,171,'VPS Hosting Fees','- Period : June, July 2017 ',2,'mths',180.00,360.00,'chiangkl','2017-07-03 12:40:34','chiangkl','2017-07-03 12:40:34'),(35,80018,10,172,'Domain Fees','- Domain : herdiva.com\n- Period : 11/07/2017 to 11/072018',1,'year',70.00,70.00,'chiangkl','2017-07-03 12:41:46','chiangkl','2017-07-03 12:41:46'),(36,80019,10,173,'VMS Software Maintenance','- Ipoh Branch\n- Period : 1/8/2017 to 31/7/2018',1,'year',1800.00,1800.00,'chiangkl','2017-07-03 12:57:43','chiangkl','2017-07-03 12:57:43'),(37,80020,10,171,'Web Hosting Fees (June 2017)','',1,'year',300.00,300.00,'chiangkl','2017-07-03 13:24:18','chiangkl','2017-07-03 13:24:18'),(38,80020,10,172,'Domain Fees : ','- masitu.com.my (May 2017)\n- masitu.com (June 2017)\n- esphi.com (July 2017)\n- archifoam.com (June 2017)\n(renewed to 2018)',1,'year',280.00,280.00,'chiangkl','2017-07-03 13:24:50','chiangkl','2017-07-03 13:28:02'),(39,80021,10,171,'Dynamic DNS Service For Web Server','- Name : supercab.dyndns.org\n- Period : 20/12/2016 to 19/12/2017',1,'year',250.00,250.00,'chiangkl','2017-07-03 13:46:05','chiangkl','2017-07-03 13:46:05'),(40,80022,10,171,'Virtual Private Server','- Windows Server\n- 4GB Guaranteed RAM\n- 120GB HD space\n- 1Mbps bandwidth\n- 1 x IP Address\n- Renewal Period : 15/7/2017 to 14/7/2018',1,'year',5800.00,5800.00,'chiangkl','2017-07-05 05:57:18','chiangkl','2017-07-05 05:58:16'),(41,80023,10,174,'CRM Software Maintenance','- Period : August 2017',1,'mth',500.00,500.00,'chiangkl','2017-08-01 15:41:16','chiangkl','2017-08-01 15:41:16'),(42,80024,10,172,'Domain Fees','- Domain : casitan.com',1,'year',65.00,65.00,'chiangkl','2017-08-01 23:19:30','chiangkl','2017-08-01 23:19:30'),(43,80024,10,171,'Web Hosting Fees','',1,'year',150.00,150.00,'chiangkl','2017-08-01 23:19:50','chiangkl','2017-08-01 23:19:50'),(44,80025,10,172,'Domain Fees','- Domain : heryexpress.com\n- Period : 9/8/2017 to 8/8/2018',1,'year',70.00,70.00,'chiangkl','2017-08-11 11:35:28','chiangkl','2017-08-11 11:37:06'),(45,80025,10,175,'HeryExpress Website','- Consignment Recording\n- Consignment Tracking\n- Development and deployment',1,'L/S',500.00,500.00,'chiangkl','2017-08-11 11:36:41','chiangkl','2017-08-11 11:36:41'),(47,80027,10,174,'CRM SOftware Maintenance','- Period : Jul, Aug, Sep 2017',3,'mth',300.00,900.00,'chiangkl','2017-08-20 14:52:08','chiangkl','2017-08-20 14:52:08'),(48,80027,10,177,'SATA Cable','',3,'pcs',15.00,45.00,'chiangkl','2017-08-20 14:55:18','chiangkl','2017-08-20 14:55:18'),(50,80027,10,174,'Installation Service','',5,'unit',60.00,300.00,'chiangkl','2017-08-20 15:04:36','chiangkl','2017-08-20 15:04:36'),(51,80028,10,171,'Web Hosting & Domain Fees','- Domain : livinggears.com\n- Period : 23/10/2017 to 22/10/2018',1,'year',670.00,670.00,'chiangkl','2017-10-11 05:21:29','chiangkl','2017-10-11 05:21:29'),(52,80028,10,173,'Annual Maintenance','',1,'year',3000.00,3000.00,'chiangkl','2017-10-11 05:22:14','chiangkl','2017-10-11 05:22:14'),(53,80029,10,173,'CRM Software Maintenance','For Period : Aug, Sep, Oct 2017',3,'mths',500.00,1500.00,'chiangkl','2017-10-11 05:28:51','chiangkl','2017-10-11 05:28:51'),(54,80030,10,173,'Website Software Maintenance','- herdivaonlinefashion.com\n- Period : Aug and Sep 2017',2,'mths',250.00,500.00,'chiangkl','2017-10-11 05:34:53','chiangkl','2017-10-11 05:34:53'),(55,80030,10,171,'VPS Hosting Fees','- Period : Aug, Sep 2017 ',2,'mths',180.00,360.00,'chiangkl','2017-10-11 05:35:33','chiangkl','2017-10-11 05:35:33'),(56,80031,10,173,'VMS Annual Software Maintenance','- Kuantan Branch\n- Period : 12/9/2017 to 11/9/2018',1,'year',1800.00,1800.00,'chiangkl','2017-10-11 05:41:00','chiangkl','2017-10-11 05:41:00'),(57,80032,10,173,'Software Maintenance','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2017 to 31 Oct 2018',1,'year',2400.00,2400.00,'chiangkl','2017-10-11 05:58:11','chiangkl','2017-10-11 05:58:11'),(58,80033,10,173,'Software Maintenance','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2017 to 31 Oct 2018',1,'year',800.00,800.00,'chiangkl','2017-10-11 05:59:38','chiangkl','2017-10-20 11:16:38'),(59,80034,10,173,'Software Maintenance','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2017 to 31 Oct 2018',1,'year',2400.00,2400.00,'chiangkl','2017-10-11 06:00:31','chiangkl','2017-10-11 06:00:31'),(60,80035,10,173,'Software Maintenance','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2017 to 31 Oct 2018',1,'year',3200.00,3200.00,'chiangkl','2017-10-11 06:01:23','chiangkl','2017-10-20 11:17:16'),(61,80036,10,173,'Software Maintenance','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2017 to 31 Oct 2018',1,'year',3200.00,3200.00,'chiangkl','2017-10-11 06:02:06','chiangkl','2017-10-20 11:16:58'),(62,80037,10,173,'CRM Software Maintenance','- Period : Sep 2017',1,'month',500.00,500.00,'chiangkl','2017-10-15 09:57:07','chiangkl','2017-10-15 09:57:07'),(63,80038,10,173,'CRM Software Maintenance','- Period : Oct 2017',1,'month',500.00,500.00,'chiangkl','2017-10-15 09:58:00','chiangkl','2017-10-15 09:58:00'),(64,80039,10,172,'Domain Fees','- Domain : e-skl.com\n- Period : 26/09/2017 to 25/09/2017',1,'year',70.00,70.00,'chiangkl','2017-10-21 23:10:09','chiangkl','2017-10-21 23:10:09'),(65,80040,10,174,'Support Services','Period : 22 Feb 2017 to 25 Oct 2017',14,'hrs',87.50,1225.00,'chiangkl','2017-10-25 10:22:43','chiangkl','2017-10-25 10:22:43'),(66,80041,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : Oct, Nov and Dec 2017',3,'mths',250.00,750.00,'chiangkl','2017-11-29 08:44:54','chiangkl','2017-11-29 08:46:05'),(67,80041,10,171,'VPS Hosting Fees','- Period : Oct, Nov and Dec 2017',3,'mths',180.00,540.00,'chiangkl','2017-11-29 08:45:25','chiangkl','2017-11-29 08:45:25'),(68,80042,10,173,'CRM Software Maintenance','- For Period : Nov and Dec 2017',2,'mths',500.00,1000.00,'chiangkl','2017-12-01 09:51:22','chiangkl','2017-12-01 09:51:22'),(70,80044,10,173,'Software Maintenance','- CRM Software\n- Period : Nov 2017',1,'mth',500.00,500.00,'chiangkl','2017-12-13 17:51:24','chiangkl','2017-12-13 17:51:24'),(71,80045,10,173,'Software Maintenance','- CRM Software\n- Period : Dec 2017',1,'mth',500.00,500.00,'chiangkl','2017-12-13 17:52:14','chiangkl','2017-12-13 17:52:14'),(72,80046,10,173,'Software Maintenance','- CRM Software\n- Period : Oct, Nov, Dec 2017',3,'mth',300.00,900.00,'chiangkl','2017-12-13 17:53:25','chiangkl','2017-12-13 17:53:25'),(73,80047,10,175,'Being 30% on confirmation of Development of Automated Valuation System (AVS)','- Technical consultancy\n- System and database design\n- Programming of Banker and Administrator Modules\n- Refer Quotation 20171211-JLJv2 for detailed work scope\n\n',1,'L/S',15600.00,15600.00,'chiangkl','2017-12-19 13:29:18','chiangkl','2017-12-19 13:30:21'),(74,80048,10,174,'Services','- May 2017',1,'',1800.00,1800.00,'cheongyy','2017-12-28 18:05:29','cheongyy','2017-12-28 18:05:29'),(75,80049,10,174,'Services','- June 2017',1,'',1800.00,1800.00,'cheongyy','2017-12-28 21:54:15','cheongyy','2017-12-28 21:54:15'),(76,80050,10,174,'Services','- July 2017',1,'',1800.00,1800.00,'cheongyy','2017-12-28 22:28:00','cheongyy','2017-12-28 22:28:00'),(77,80051,10,174,'Services','- August 2017',1,'',1800.00,1800.00,'cheongyy','2017-12-28 23:34:55','cheongyy','2017-12-28 23:34:55'),(78,80052,10,174,'Services','- Sep 2017',1,'',1800.00,1800.00,'cheongyy','2017-12-29 15:17:16','cheongyy','2017-12-29 15:17:16'),(79,80053,10,174,'Services','- October 2017',1,'',1800.00,1800.00,'cheongyy','2017-12-29 16:12:33','cheongyy','2017-12-29 16:12:33'),(80,80054,10,174,'Services','- November 2017',1,'',1800.00,1800.00,'cheongyy','2017-12-29 16:33:56','cheongyy','2017-12-29 16:33:56'),(81,80055,10,174,'Dynamic DNS Service For Web Server','- Name : supercab.dyndns.org\n- Period : 20/12/2017 to 19/12/2018',1,'year',250.00,250.00,'chiangkl','2018-01-08 12:09:30','chiangkl','2018-01-08 12:09:30'),(82,80056,10,174,'Lazada Product Posting','- Lazada API addproduct\n- Interface to post products\n- interface to set group pricing',1,'L/S',1500.00,1500.00,'chiangkl','2018-01-08 12:17:48','chiangkl','2018-01-08 12:17:48'),(83,80057,10,173,'Software Maintenance','- CRM Software\n- Period : Jan, Feb and Mar 2018',3,'mths',300.00,900.00,'chiangkl','2018-02-11 13:52:20','chiangkl','2018-02-11 13:52:20'),(84,80058,10,173,'Software Maintenance','- CRM Software\n- Period : Jan 2018',1,'mth',500.00,500.00,'chiangkl','2018-02-11 13:56:14','chiangkl','2018-02-11 13:56:14'),(85,80059,10,173,'Valuation Management System (HQ)','- Annual Maintenance Fees\n- Period : 1 Feb 2018 to 31 Jan 2019',1,'year',3600.00,3600.00,'chiangkl','2018-02-11 14:02:12','chiangkl','2018-02-11 14:02:12'),(86,80060,10,173,'Valuation Management System (VMS)','- Annual software maintenance\n- Period : 1/2/2018 to 31/01/2019',1,'year',1800.00,1800.00,'chiangkl','2018-02-11 14:15:38','chiangkl','2018-02-11 14:15:38'),(87,80061,10,173,'Point Of Sale System','- Annual Service Maintenance\n- For HQ and up to 5 outlets\n- Period : 1/3/2018 to 28/2/2019',1,'year',3000.00,3000.00,'chiangkl','2018-02-11 14:22:35','chiangkl','2018-02-11 14:22:35'),(88,80062,10,175,'Being progress claim for Firstcoach Bus Ticketing System Development','- Online Web Ticketing System\n- Counter Self Service Application\n- Hybrid Mobile Application\n- RESTFUL API Backend\n- RM74000 x 25% (Balance : 35%)',1,'L/S',18500.00,18500.00,'chiangkl','2018-02-11 14:31:24','chiangkl','2018-02-11 14:32:02'),(89,80063,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : Jan and Feb 2018',2,'mths',250.00,500.00,'chiangkl','2018-02-11 14:36:55','chiangkl','2018-02-11 14:38:05'),(90,80063,10,171,'VPS Hosting Fees','Period : Jan and Feb 2018',2,'mths',180.00,360.00,'chiangkl','2018-02-11 14:37:37','chiangkl','2018-02-11 14:38:18'),(91,80064,10,174,'Services','- Period : Dec 2017',1,'mth',1800.00,1800.00,'chiangkl','2018-02-11 16:05:26','chiangkl','2018-02-11 16:05:26'),(92,80065,10,174,'Services','- Period : Jan 2018',1,'mth',1800.00,1800.00,'chiangkl','2018-02-11 16:06:27','chiangkl','2018-02-11 16:06:27'),(93,80066,10,171,'Web Hosting and Domain Fees','- Domain : suprimacomm.com\n- Period : 28/3/2018 - 27/3/2019',1,'year',320.00,320.00,'chiangkl','2018-03-27 08:38:29','chiangkl','2018-03-27 08:38:29'),(94,80067,10,173,'Software Maintenance','- CRM Software\n- Period : Feb 2018',1,'mth',500.00,500.00,'chiangkl','2018-03-27 08:48:17','chiangkl','2018-03-27 08:48:17'),(95,80068,10,173,'Software Maintenance','- CRM Software\n- Period : Mar 2018',1,'mth',500.00,500.00,'chiangkl','2018-03-27 08:49:14','chiangkl','2018-08-24 07:17:03'),(96,80069,10,173,'CRM Software Maintenance','- For Period : Jan, Feb and Mar 2018',3,'mths',500.00,1500.00,'chiangkl','2018-03-27 08:57:32','chiangkl','2018-03-27 08:57:32'),(97,80070,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : Mar and Apr 2018',2,'mths',250.00,500.00,'chiangkl','2018-03-27 09:01:51','chiangkl','2018-03-27 09:01:51'),(98,80070,10,171,'VPS Hosting Fees','Period : Mar and Apr 2018',2,'mths',180.00,360.00,'chiangkl','2018-03-27 09:02:39','chiangkl','2018-03-27 09:02:39'),(99,80071,10,175,'Shopee Bulk Product Posting','- Export product to EXCEL format\n- Service to submit exported EXCEL to Shopee\n',1,'L/S',1200.00,1200.00,'chiangkl','2018-03-27 09:06:39','chiangkl','2018-03-27 09:06:39'),(100,80072,10,173,'CRM Software Maintenance','- For Period : April, May and June 2018',3,'mths',500.00,1500.00,'chiangkl','2018-05-14 18:10:19','chiangkl','2018-05-14 18:10:19'),(101,80073,10,173,'Software Development ','- 2 LC control programs',1,'L/S',400.00,400.00,'chiangkl','2018-05-14 18:21:18','chiangkl','2018-05-14 18:21:18'),(102,80074,10,173,'Software Maintenance','- CRM Software\n- Period : Apr, May and Jun 2018',3,'mths',300.00,900.00,'chiangkl','2018-05-14 18:27:57','chiangkl','2018-05-14 18:27:57'),(104,80076,10,174,'Ad-hoc Remote Support Service','',1,'L/S',90.00,90.00,'chiangkl','2018-05-31 09:30:50','chiangkl','2018-05-31 09:30:50'),(105,80077,10,171,'Web Hosting Fees (June 2018)','',1,'year',300.00,300.00,'chiangkl','2018-05-31 09:36:34','chiangkl','2018-05-31 09:39:11'),(106,80077,10,172,'Domain Fees','- masitu.com.my (May 2018)\n- masitu.com (June 2018)\n- esphi.com (July 2018)\n- archifoam.com (June 2018)\n(renewed to 2019)',1,'year',280.00,280.00,'chiangkl','2018-05-31 09:38:04','chiangkl','2018-05-31 09:38:04'),(107,80078,10,174,'Server POS Software Reinstallation','- Re-installation of database\n- POS components and software\n- 2 times installations',1,'L/S',450.00,450.00,'chiangkl','2018-06-11 21:40:45','chiangkl','2018-06-11 21:40:45'),(108,80079,10,175,'Being 30% progress payment on Development of Automated Valuation System (AVS)','- Technical consultancy\n- System and database design\n- Programming of Banker and Administrator Modules\n- Refer Quotation 20171211-JLJv2 for detailed work scope',1,'L/S',15600.00,15600.00,'chiangkl','2018-07-02 03:30:07','chiangkl','2018-07-02 03:30:07'),(110,80080,10,171,'Virtual Private Server (CPO System) - 6 Months Renewal','- Windows Server\n- 4GB Guaranteed RAM\n- 120GB HD space\n- 10Mbps bandwidth\n- 1 x IP Address\n- Renewal Period : 15/7/2018 to 14/1/2019 (6 months)\n',1,'L/S',2900.00,2900.00,'chiangkl','2018-07-05 03:46:33','chiangkl','2018-07-05 03:47:27'),(111,80081,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : May, June and July 2018',3,'mths',250.00,750.00,'chiangkl','2018-07-07 01:31:38','chiangkl','2018-07-07 01:36:06'),(112,80081,10,171,'VPS Hosting Fees','Period : May, June and July 2018',3,'mths',180.00,540.00,'chiangkl','2018-07-07 01:32:42','chiangkl','2018-07-07 01:36:18'),(113,80081,10,172,'Domain Fees','- Domain : herdiva.com\n- Period : 11/7/2018 to 11/7/2019',1,'year',70.00,70.00,'chiangkl','2018-07-07 01:35:55','chiangkl','2018-07-07 01:35:55'),(114,80082,10,174,'Commisions','- March (RM232)\n- April (RM327)\n- May (RM924)\n- June (RM1164)',1,'L/S',2647.00,2647.00,'chiangkl','2018-07-23 14:26:23','chiangkl','2018-07-25 06:30:16'),(115,80083,10,173,'VMS Software Maintenance','- Ipoh Branch\n- Period : 1/8/2018 to 31/7/2019',1,'year',1800.00,1800.00,'chiangkl','2018-07-25 07:14:51','chiangkl','2018-07-25 07:14:51'),(116,80084,10,172,'Domain Fees','- Domain : casitan.com\n',1,'year',65.00,65.00,'chiangkl','2018-08-03 08:46:55','chiangkl','2018-08-03 08:47:28'),(117,80084,10,171,'Web Hosting Fees','',1,'year',150.00,150.00,'chiangkl','2018-08-03 08:47:10','chiangkl','2018-08-03 08:47:10'),(118,80085,10,172,'Domain Fees','- Domain : e-skl.com\n- Period : 26/09/2018 to 26/09/2019',1,'year',70.00,70.00,'chiangkl','2018-08-03 08:55:48','chiangkl','2018-08-03 08:55:48'),(119,80086,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : August 2018',1,'mth',250.00,250.00,'chiangkl','2018-08-03 09:00:48','chiangkl','2018-08-03 09:00:48'),(120,80086,10,171,'VPS Hosting Fees','- Period : August 2018',1,'mth',180.00,180.00,'chiangkl','2018-08-03 09:01:28','chiangkl','2018-08-03 09:01:28'),(121,80086,10,172,'Domain Fees','- Domain : heryexpress.com (New Expiry : 8/2019)\n- Domain : herdivaonlinefashion.com (New Expiry : 9/2019)',1,'year',140.00,140.00,'chiangkl','2018-08-03 09:03:27','chiangkl','2018-08-03 09:03:27'),(122,80086,10,174,'Re-development of Lazada Auto Posting','- Product posting thru Lazada Open Platform',1,'L/S',600.00,600.00,'chiangkl','2018-08-03 09:06:15','chiangkl','2018-08-03 09:06:15'),(123,80087,10,173,'Software Maintenance','- CRM Software\n- Period : Jul, Aug and Sep 2018',3,'mths',300.00,900.00,'chiangkl','2018-08-14 09:38:53','chiangkl','2018-08-14 09:38:53'),(124,80088,10,173,'VMS Annual Software Maintenance','- Kuantan Branch\n- Period : 12/9/2018 to 11/9/2019',1,'year',1800.00,1800.00,'chiangkl','2018-08-14 10:22:09','chiangkl','2018-08-14 10:22:09'),(125,80089,10,171,'Virtual Private Server Hosting (for AVS)','- 40 GB Disk Space\n- 2 GB Memory\n- 2 vCPU\n- 1 Dedicated IP\n- 2TB Monthly Data Transfer\n- 100 Mbps Bandwidth\n- Linux based OS\n- Server management and backup management\n- Free initial setup/commissioning\n- Period : 1/9/2018 - 31/08/2019',1,'year',3000.00,3000.00,'chiangkl','2018-08-14 10:25:39','chiangkl','2018-08-23 14:33:18'),(126,80090,10,174,'VMS Migration Service','- Migrate VMS database to new server\n- Configure and install in new server\n- Testing and Commissiing',1,'L/S',300.00,300.00,'chiangkl','2018-08-23 14:34:48','chiangkl','2018-08-23 14:35:04'),(127,80091,10,173,'Software Maintenance','- CRM Software\n- Period : Jul, Aug, Sep 2018',3,'mths',500.00,1500.00,'chiangkl','2018-08-24 07:10:15','chiangkl','2018-08-24 07:10:46'),(128,80092,10,173,'Software Maintenance','- CRM Software\n- Period : Apr 2018',1,'mth',500.00,500.00,'chiangkl','2018-08-24 07:17:56','chiangkl','2018-08-24 07:17:56'),(129,80093,10,173,'Software Maintenance','- CRM Software\n- Period : May 2018',1,'mth',500.00,500.00,'chiangkl','2018-08-24 07:18:36','chiangkl','2018-08-24 07:18:36'),(130,80094,10,173,'Software Maintenance','- CRM Software\n- Period : June 2018',1,'mth',500.00,500.00,'chiangkl','2018-08-24 07:19:25','chiangkl','2018-08-24 07:19:25'),(131,80095,10,173,'Software Maintenance','- CRM Software\n- Period : July 2018',1,'mth',500.00,500.00,'chiangkl','2018-08-24 07:20:13','chiangkl','2018-08-24 07:20:13'),(132,80096,10,173,'Software Maintenance','- CRM Software\n- Period : August 2018',1,'mth',500.00,500.00,'chiangkl','2018-08-24 07:22:41','chiangkl','2018-08-24 07:22:41'),(133,80097,10,174,'Services','- Period : Feb 2018',1,'mth',1800.00,1800.00,'chiangkl','2018-08-24 07:26:09','chiangkl','2018-08-24 07:26:09'),(134,80098,10,174,'Services','- Period : Mar 2018',1,'mth',1800.00,1800.00,'chiangkl','2018-08-24 07:26:48','chiangkl','2018-08-24 07:26:48'),(135,80099,10,174,'Services','- Period : Apr 2018',1,'mth',1800.00,1800.00,'chiangkl','2018-08-24 07:27:28','chiangkl','2018-08-24 07:27:28'),(136,80100,10,174,'Services','- Period : May 2018',1,'mth',1800.00,1800.00,'chiangkl','2018-08-24 07:28:09','chiangkl','2018-08-24 07:28:09'),(137,80101,10,174,'Services','- Period : June 2018',1,'mth',1800.00,1800.00,'chiangkl','2018-08-24 07:29:08','chiangkl','2018-08-24 07:29:08'),(138,80102,10,174,'Services','- Period : JUl 2018',1,'mth',1800.00,1800.00,'chiangkl','2018-08-24 07:29:44','chiangkl','2018-08-24 07:29:44'),(139,80103,10,174,'Services','- Period : Aug 2018',1,'mth',1800.00,1800.00,'chiangkl','2018-08-24 07:30:15','chiangkl','2018-08-24 07:30:15'),(140,80104,10,178,'SSL Certificate','EssentialSSL Wildcard Certificate\n- Domain Validation\n- Wildcard\n- Encryption (up to 256-bit)\n- Renewable yearly\n',1,'year',400.00,400.00,'chiangkl','2018-09-12 09:30:54','chiangkl','2018-09-12 09:30:54'),(141,80104,10,174,'SSL Certificate Installation Service','- Install of SSL into hosted server',1,'L/S',200.00,200.00,'chiangkl','2018-09-12 09:31:46','chiangkl','2018-09-12 09:31:46'),(142,80104,10,179,'Maybank Payment Gateway Integration Service','- Development of Payment Gateway module\n- Re-query of transaction before cancellation\n- Communicate with Maybank on testing/commissioning\n- Enforce number of successful transaction per day per customer',1,'L/S',2000.00,2000.00,'chiangkl','2018-09-12 09:33:46','chiangkl','2018-09-12 09:33:57'),(143,80104,10,180,'B2B Intergration Service (based on RedBus)','- To develop an interface (API) for third party agent to query trip and purchase tickets\n- Scope as per documented in Quotation',1,'L/S',5500.00,5500.00,'chiangkl','2018-09-12 09:35:09','chiangkl','2018-09-12 09:35:09'),(144,80104,10,171,'VPS Hosting Fees','Virtual Private Server\nLinux Cloud Based\n4GB RAM\n120GB HDD\nAddon Service : Backup Server management1\nPeriod : 07/08/2018 to 06/08/2019 ',1,'year',4800.00,4800.00,'chiangkl','2018-09-12 09:36:48','chiangkl','2018-09-12 09:40:18'),(145,80104,10,181,'Server Installation Fees','- Linux server OS Installation\n- Latest server update and patches \n- Testing and commissioning',1,'L/S',500.00,500.00,'chiangkl','2018-09-12 09:38:57','chiangkl','2018-09-12 09:38:57'),(146,80105,10,175,'Being 40% final payment on Development of Automated Valuation System (AVS)','- Technical consultancy\n- System and database design\n- Programming of Banker and Administrator Modules\n- Refer Quotation 20171211-JLJv2 for detailed work scope',1,'L/S',20800.00,20800.00,'chiangkl','2018-10-02 08:09:00','chiangkl','2018-10-02 08:09:00'),(147,80106,10,175,'Being 25% for Firstcoach Bus Ticketing System Development','- Online Web Ticketing System\n- Counter Self Service Application\n- Hybrid Mobile Application\n- RESTFUL API Backend\n- RM74000 x 25% (10% balance)',1,'L/S',18500.00,18500.00,'chiangkl','2018-10-02 08:47:29','chiangkl','2018-10-02 09:12:08'),(148,80106,10,174,'Migration Service','- Basic data migration from old system (advance ticket & bookings)',1,'L/S',1200.00,1200.00,'chiangkl','2018-10-02 08:48:57','chiangkl','2018-10-02 08:48:57'),(150,80107,10,173,'Software Maintenance','- Firstcoach Ticketing System\n- Period : 1/10/2018 to 30/9/2019',1,'year',17500.00,17500.00,'chiangkl','2018-10-02 09:18:56','chiangkl','2018-10-02 09:19:18'),(151,80108,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : Sep and Oct 2018',2,'mths',250.00,500.00,'chiangkl','2018-10-12 23:59:19','chiangkl','2018-10-12 23:59:19'),(152,80108,10,171,'VPS Hosting Fees','- Period : Sep and Oct 2018',2,'mths',180.00,360.00,'chiangkl','2018-10-13 00:00:13','chiangkl','2018-10-13 00:00:13'),(153,80108,10,175,'Changes related to SST Implementation','',1,'L/S',600.00,600.00,'chiangkl','2018-10-13 00:00:52','chiangkl','2018-10-13 00:00:52'),(155,80108,10,174,'Printing In Bulk','- Invoice\n- Debit Note\n- Statement',1,'L/S',900.00,900.00,'chiangkl','2018-10-13 00:04:31','chiangkl','2018-10-13 08:27:04'),(156,80109,10,171,'Web Hosting Fees','- Domain : livinggears.com\n- Period : 23/10/2018 to 22/10/2019',1,'year',670.00,670.00,'chiangkl','2018-10-16 14:29:20','chiangkl','2018-10-16 14:29:20'),(157,80109,10,173,'Web site Annual Maintenance','- Daily Web database backup service (excl. images)\n- Website Maintenance Support',1,'year',3000.00,3000.00,'chiangkl','2018-10-16 14:30:56','chiangkl','2018-10-16 14:30:56'),(158,80110,10,174,'Software Maintenance','- CRM Software\n- Period : October 2018',1,'mth',500.00,500.00,'chiangkl','2018-10-16 14:34:42','chiangkl','2018-10-16 14:36:46'),(159,80111,10,173,'Software Maintenance','- CRM Software\n- Period : September 2018',1,'mth',500.00,500.00,'chiangkl','2018-10-16 14:36:18','chiangkl','2018-10-16 14:36:18'),(160,80112,10,173,'Software Maintenance (CPO Group)','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2018 to 31 Oct 2019\n',1,'year',2573.00,2573.00,'chiangkl','2018-10-19 00:19:00','chiangkl','2018-10-25 04:59:21'),(161,80113,10,173,'Software Maintenance (CPO Group)','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2018 to 31 Oct 2019',1,'year',857.00,857.00,'chiangkl','2018-10-19 00:20:36','chiangkl','2018-10-25 04:59:46'),(162,80114,10,173,'Software Maintenance (CPO Group)','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2018 to 31 Oct 2019',1,'year',2571.00,2571.00,'chiangkl','2018-10-19 00:21:33','chiangkl','2018-10-25 04:58:56'),(163,80115,10,173,'Software Maintenance (CPO Group)','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2018 to 31 Oct 2019',1,'year',2571.00,2571.00,'chiangkl','2018-10-19 00:22:21','chiangkl','2018-10-25 05:00:40'),(164,80116,10,173,'Software Maintenance (CPO Group)','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2018 to 31 Oct 2019',1,'year',3428.00,3428.00,'chiangkl','2018-10-19 00:23:03','chiangkl','2018-10-25 05:00:06'),(165,80117,10,174,'Non Maintenance Services (Bangsar On-Site)','- Troubleshoot Ticket Printer\n- Install Additional Ticket Printer\n- Visit Date 16/10/2018 (5.40pm to 8.10pm)',1,'L/S',200.00,200.00,'chiangkl','2018-10-25 05:09:03','chiangkl','2018-10-25 05:09:03'),(166,80118,10,173,'Software Maintenance','- CRM Software\n- Period : Oct, Nov, Dec 2018',3,'mth',300.00,900.00,'chiangkl','2018-10-29 09:51:44','chiangkl','2018-10-29 09:51:44'),(167,80119,10,173,'Software Maintenance','- CRM Software\n- Period : Oct, Nov, Dec 2018',3,'mth',500.00,1500.00,'chiangkl','2018-10-29 09:54:52','chiangkl','2018-10-29 09:54:52'),(168,80120,10,174,'Commission','- Jul 2018 (RM124)\n- Aug 2018 (RM148)\n- Sep 2018 (RM78)\n- Oct 2018 (RM134)',1,'L/S',484.00,484.00,'chiangkl','2018-11-14 07:43:00','chiangkl','2018-11-14 07:43:00'),(169,80121,10,173,'AVS System Maintenance','- Being annual system maintenance of Automated Valuation System (AVS)\n- Current development fees RM52000 x 18%\n- Period : 1/11/2018 to 31/10/2019 \n- Fees shall be revised in the event of further enhancement to the system',1,'year',9360.00,9360.00,'chiangkl','2018-11-23 04:19:27','chiangkl','2018-11-23 04:22:27'),(170,80122,10,174,'Commission','- Nov 2018',1,'L/S',224.00,224.00,'chiangkl','2018-12-14 01:01:29','chiangkl','2018-12-14 01:01:29'),(171,80123,10,175,'Motor Stock Development','- Being 1st Payment on project confirmation\n- Scope as per e-mail dated 23 Oct 2018',1,'L/S',5000.00,5000.00,'chiangkl','2018-12-17 04:27:49','chiangkl','2019-01-04 00:38:09'),(172,80124,10,175,'Website Development','- boonhuamotor.com\n- 40% on project confirmation\n- scope as per quotation no. 20181012-BHM',1,'L/S',2800.00,2800.00,'chiangkl','2018-12-17 04:30:10','chiangkl','2018-12-17 04:30:10'),(173,80125,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : Nov, Dec 2018',2,'mth',250.00,500.00,'chiangkl','2018-12-17 23:05:02','chiangkl','2018-12-17 23:05:02'),(174,80125,10,171,'VPS Hosting Fees','- Period :  Nov, Dec 2018',2,'mth',180.00,360.00,'chiangkl','2018-12-17 23:05:31','chiangkl','2018-12-17 23:05:31'),(175,80126,10,174,'Modification to CRM Program','- as per email dated 14/12/2018',1,'L/S',600.00,600.00,'chiangkl','2018-12-17 23:11:08','chiangkl','2018-12-17 23:11:40'),(176,80127,10,171,'Linux SSD VPS 3','- Period : 26/12/2018 - 25/12/2019\n- Operating System: CentOS 7.x x86_64 with Plesk 17\n- 3 vCPU\n- 60 GB Disk Space\n- 3GB RAM\n- 100Mbps bandwidth\n- Renewal @ RM1335.60 yearly',1,'year',868.14,868.14,'chiangkl','2019-01-03 03:59:33','chiangkl','2019-01-03 04:01:02'),(177,80127,10,172,'Domain Fees','- Domain : sqlerp.my\n- Period : 26/12/2018 to 25/12/2019',1,'year',60.00,60.00,'chiangkl','2019-01-03 04:00:52','chiangkl','2019-01-03 04:00:52'),(178,80128,10,174,'Motor Stock Development','- Being final Payment on project development\n- Scope as per e-mail dated 23 Oct 2018',1,'L/S',5000.00,5000.00,'chiangkl','2019-01-03 04:03:05','chiangkl','2019-01-04 00:36:46'),(179,80129,10,175,'Website Development','- boonhuamotor.com\n- Final payment on project completion\n- scope as per quotation no. 20181012-BHM',1,'L/S',4200.00,4200.00,'chiangkl','2019-01-03 04:07:15','chiangkl','2019-01-03 04:07:15'),(180,80130,10,171,'Virtual Private Server (CPO System)','- Windows Server VPS3\n- 3 vCPU\n- 80GB disk space\n- 100Mbps bandwidth\n- 1 x IP Address\n- Renewal Period : 15/1/2019 to 14/1/2020 (1 year)',1,'year',5800.00,5800.00,'chiangkl','2019-01-03 04:14:00','chiangkl','2019-01-03 04:14:00'),(181,80131,10,175,'Being final payment for Firstcoach Bus Ticketing System Development','- Online Web Ticketing System\n- Hybrid Mobile Application\n- RESTFUL API Backend\n- RM74000 x final 10%',1,'L/S',7400.00,7400.00,'chiangkl','2019-01-03 04:16:41','chiangkl','2019-01-03 04:16:41'),(182,80131,10,174,'Pepipost Transactional Email Subscription (USD15)','',1,'mth',65.00,65.00,'chiangkl','2019-01-03 04:18:22','chiangkl','2019-01-03 04:18:35'),(183,80132,10,175,'B2B Integration (based on RedBus) - Enhancement','- To enhance third party agent integration with “Prepaid Top Up” model\n- Details as per Quotation No. 20180107BR & 20181018BR\n- Maintenance will commence when Agent starts using the module\n- Yearly maintenance fees applied : (RM5500+RM7500) x 18% = RM2340 per year',1,'L/S',7500.00,7500.00,'chiangkl','2019-01-03 04:26:53','chiangkl','2019-01-24 01:22:48'),(184,80133,10,173,'Software Maintenance','- CRM Software\n- Period : Jan, Feb, Mar 2019',3,'mth',300.00,900.00,'chiangkl','2019-01-15 08:20:35','chiangkl','2019-01-15 08:22:56'),(185,80134,10,175,'Enhancement to boonhuamotor.com','- Scope as per email dated 15/01/2019\n- being 40% on confirmation',1,'L/S',2000.00,2000.00,'chiangkl','2019-01-15 14:06:04','chiangkl','2019-01-15 14:06:04'),(186,80135,10,173,'VMS Software Maintenance','- Annual Maintenance Fees\n- Period : 1 Feb 2019 to 31 Jan 2020',1,'year',3600.00,3600.00,'chiangkl','2019-01-24 01:51:01','chiangkl','2019-01-24 01:51:01'),(187,80135,10,172,'Domain Fees','- Domain : valchecker.com\n- Period : 10/01/2019 to 09/01/2010',1,'year',70.00,70.00,'chiangkl','2019-01-24 01:52:48','chiangkl','2019-01-24 01:52:48'),(188,80136,10,173,'Valuation Management System (VMS) - PJ','- Annual software maintenance\n- Period : 1/2/2019 to 31/01/2020',1,'year',1800.00,1800.00,'chiangkl','2019-01-31 09:54:49','chiangkl','2019-01-31 09:54:49'),(189,80137,10,173,'Point Of Sale System','- Annual Service Maintenance\n- For HQ and outlets\n- Period : 1/3/2019 to 28/2/2020',1,'year',3000.00,3000.00,'chiangkl','2019-01-31 10:00:05','chiangkl','2019-01-31 10:00:05'),(190,80138,10,171,'Web Hosting and Domain Fees','- Domain : suprimacomm.com\n- Period : 28/3/2019 - 27/3/2020',1,'year',320.00,320.00,'chiangkl','2019-02-12 05:15:38','chiangkl','2019-02-12 05:16:42'),(191,80139,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : Jan, Feb, Mar 2019',3,'mth',250.00,750.00,'chiangkl','2019-03-01 00:23:25','chiangkl','2019-03-01 00:24:12'),(192,80139,10,171,'VPS Hosting Fees','- Period : Jan, Feb, Mar 2019',3,'mth',180.00,540.00,'chiangkl','2019-03-01 00:24:07','chiangkl','2019-11-27 09:12:12'),(193,80140,10,173,'Software Maintenance','- CRM Software\n- Period : Jan, Feb, Mar 2019',3,'mth',500.00,1500.00,'chiangkl','2019-03-01 00:26:40','chiangkl','2019-11-27 09:12:43'),(194,80141,10,173,'Software Maintenance','- CRM Software\n- Period : November 2018',1,'mth',500.00,500.00,'chiangkl','2019-03-01 00:38:33','chiangkl','2019-03-01 00:40:39'),(195,80142,10,173,'Software Maintenance','- CRM Software\n- Period : December 2018',1,'mth',500.00,500.00,'chiangkl','2019-03-01 00:39:21','chiangkl','2019-03-01 00:40:55'),(196,80143,10,173,'Software Maintenance','- CRM Software\n- Period : January 2019',1,'mth',500.00,500.00,'chiangkl','2019-03-01 00:40:16','chiangkl','2019-03-01 00:40:16'),(197,80144,10,173,'Software Maintenance','- CRM Software\n- Period : February 2019',1,'mth',500.00,500.00,'chiangkl','2019-03-01 00:41:50','chiangkl','2019-03-01 00:41:50'),(198,80145,10,173,'Software Maintenance','- CRM Software\n- Period : March 2019',1,'mth',500.00,500.00,'chiangkl','2019-03-01 00:42:28','chiangkl','2019-03-01 00:42:28'),(199,80146,10,174,'Services','- Period : Sep 2018',1,'mth',1800.00,1800.00,'chiangkl','2019-03-14 07:59:18','chiangkl','2019-03-14 07:59:18'),(200,80147,10,174,'Services','- Period : Oct 2018',1,'mth',1800.00,1800.00,'chiangkl','2019-03-14 08:01:00','chiangkl','2019-03-14 08:01:00'),(201,80148,10,174,'Services','- Period : Nov 2018',1,'mth',1800.00,1800.00,'chiangkl','2019-03-14 08:19:30','chiangkl','2019-03-14 08:19:30'),(202,80149,10,174,'Services','- Period : Dec 2018',1,'mth',1800.00,1800.00,'chiangkl','2019-03-14 08:20:19','chiangkl','2019-03-14 08:20:19'),(203,80150,10,173,'Agent API Module and Agent  Web Backed ','- Annual Maintenance (18%)\n- Agent Module Development (RM5500)\n- Agent Prepaid enhancement and Web Backend module (RM7500)\n- Period : 1/4/2019 to 31/3/2020',1,'year',2340.00,2340.00,'chiangkl','2019-04-05 02:48:37','chiangkl','2019-04-05 02:50:21'),(204,80151,10,172,'Domain Fees','- Domain : aptb.com.my\n- Period : 4 Apr 2019 to 3 Apr 2020',1,'year',100.00,100.00,'chiangkl','2019-04-16 03:36:52','chiangkl','2019-04-16 03:36:52'),(205,80151,10,171,'E-mail Hosting Fees (5 Users)','- Domain : aptb.com.my\n- Period : 4 Apr 2019 to 3 Apr 2020',1,'year',300.00,300.00,'chiangkl','2019-04-16 03:38:02','chiangkl','2019-04-16 03:38:02'),(206,80152,10,171,'E-mail Hosting Fees (15 Users)','- Domain : firstcoach.com.my\n- Period : 5 Apr 2019 to 4 Apr 2020',1,'year',900.00,900.00,'chiangkl','2019-04-16 03:39:30','chiangkl','2019-04-16 03:39:30'),(207,80152,10,181,'E-mail Implementation Fees','',1,'L/S',500.00,500.00,'chiangkl','2019-04-16 03:40:10','chiangkl','2019-04-16 03:40:28'),(208,80153,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : Apr, May, Jun 2019',3,'mth',250.00,750.00,'chiangkl','2019-04-16 03:42:06','chiangkl','2019-04-16 03:42:06'),(209,80153,10,171,'VPS Hosting Fees','- Domain : herdivaonlinefashion.com\n- Period : Apr, May, Jun 2019',3,'mths',180.00,540.00,'chiangkl','2019-04-16 03:42:50','chiangkl','2019-04-16 03:43:01'),(210,80154,10,173,'Software Maintenance','- CRM Software\n- Period : April 2019',1,'mth',500.00,500.00,'chiangkl','2019-04-16 03:44:33','chiangkl','2019-04-16 03:44:33'),(211,80155,10,173,'Software Maintenance','- CRM Software\n- Period : Apr, May, Jun 2019',3,'mths',500.00,1500.00,'chiangkl','2019-04-16 03:51:53','chiangkl','2019-04-16 03:51:53'),(212,80156,10,175,'Enhancement to boonhuamotor.com','- Scope as per email dated 15/01/2019\n- final payment for enhancement',1,'L/S',3000.00,3000.00,'chiangkl','2019-04-24 02:46:16','chiangkl','2019-04-24 02:46:16'),(214,80158,10,175,'Motor Stock Enhancement','- Insurance Integration (Zurich)\n- as per email dated 22 Jan 2019',1,'L/S',4000.00,4000.00,'chiangkl','2019-04-25 15:33:19','chiangkl','2019-04-25 15:33:19'),(215,80159,10,171,'Web Hosting Fees (June 2019)','',1,'year',300.00,300.00,'chiangkl','2019-04-26 02:08:28','chiangkl','2019-04-26 02:09:13'),(216,80159,10,172,'Domain Fees','- masitu.com.my (Apr 2019)\n- masitu.com (June 2019)\n- esphi.com (July 2019)\n- archifoam.com (June 2019)\n(renewed to 2020)',1,'year',280.00,280.00,'chiangkl','2019-04-26 02:10:22','chiangkl','2019-04-26 02:10:30'),(217,80160,10,171,'Web Hosting Fees (Shared VPS)','- Domain : boonhuamotor.com\n- Period : 26 Apr 2019 to 25 Apr 2020\n- Free SSL Certificate',1,'year',500.00,500.00,'chiangkl','2019-04-26 02:18:35','chiangkl','2019-04-26 03:42:50'),(218,80160,10,172,'Domain Fees','- Domain : boonhuamotor.com',1,'year',100.00,100.00,'chiangkl','2019-04-26 02:20:15','chiangkl','2019-04-26 02:20:15'),(219,80160,10,174,'Email Hosting','- Yandex Mail',1,'FOC',0.00,0.00,'chiangkl','2019-04-26 03:39:49','chiangkl','2019-04-26 03:39:49'),(220,80160,10,179,'EMail Setup Service','',1,'L/S',50.00,50.00,'chiangkl','2019-04-26 03:40:16','chiangkl','2019-04-26 03:40:16'),(221,80161,10,175,'AVS Enhancement','- Check Value screen enhancement (format 2)\n- Mass Import for Change Name (Scheme)\n- Control User Login by Time\n- Base Comparable Locking\n- Control of AVS Value Report contents by user role',1,'L/S',8000.00,8000.00,'chiangkl','2019-05-09 08:48:15','chiangkl','2019-05-09 08:56:15'),(222,80161,10,173,'Software Maintenance','- Automatic Valuation System (AVS)\n- Period : 01/06/2019 to 31/10/2019 \n- Pro-rated Fees : RM8000 x 18% x 5 months',1,'L/S',600.00,600.00,'chiangkl','2019-05-09 08:51:09','chiangkl','2019-05-09 08:52:00'),(223,80162,10,175,'Function To Import Excel','',1,'L/S',350.00,350.00,'chiangkl','2019-05-13 11:23:32','chiangkl','2019-05-13 11:23:32'),(224,80163,10,171,'Email Hosting Fees','- Domain : jurusniaga.com\n- Period : 1/6/2019 to 31/5/2020',1,'year',300.00,300.00,'chiangkl','2019-06-03 07:34:26','chiangkl','2019-06-03 07:34:26'),(225,80163,10,172,'Domain Fees','- Domain : jurusniaga.com\n- Expiry : 25/6/2020',1,'year',100.00,100.00,'chiangkl','2019-06-03 07:36:28','chiangkl','2019-06-03 07:36:28'),(226,80163,10,174,'Service Fees (management of domain and email setup)','',1,'L/S',100.00,100.00,'chiangkl','2019-06-03 07:37:23','chiangkl','2019-06-03 07:37:56'),(227,80164,10,171,'Linux SSD VPS 3','- Period : 20/06/2019 - 19/06/2020\n- Operating System: CentOS 7.x x86_64 with Plesk 17\n- 3 vCPU\n- 60 GB Disk Space\n- 3GB RAM\n- 100Mbps bandwidth\n- Renewal @ RM1335.60 yearly',1,'year',868.14,868.14,'chiangkl','2019-06-20 11:00:26','chiangkl','2019-06-20 11:00:26'),(228,80164,10,172,'Domain Fees','- Domain : aveta.my\n- Period : 20/06/2019 - 19/06/2024',1,'L/S',292.00,292.00,'chiangkl','2019-06-20 11:01:36','chiangkl','2019-11-27 10:15:24'),(229,80164,10,175,'Aveta Motor Stock Development','- Aveta Web Motor Stock (RM8000)\n- Aveta Android Mobile Scanner App (RM5000)\n- 30% downpayment',1,'L/S',3900.00,3900.00,'chiangkl','2019-06-20 11:03:27','chiangkl','2019-06-20 11:03:27'),(230,80164,10,174,'Enhancement to Motor Stock','- Addition of Cash Sale module',1,'L/S',2500.00,2500.00,'chiangkl','2019-06-20 11:04:20','chiangkl','2019-06-20 11:04:20'),(231,80165,10,178,'SSL Certificate','EssentialSSL Wildcard Certificate\n- Domain Validation\n- Wildcard\n- Encryption (up to 256-bit)\n- Period : 07/08/2019 to 06/08/2020\n- Renewable yearly',1,'year',400.00,400.00,'chiangkl','2019-07-18 10:31:13','chiangkl','2019-07-18 10:31:13'),(232,80165,10,171,'VPS Hosting Fees for Firstcoach','Virtual Private Server\nLinux Cloud Based\n4GB RAM\n120GB HDD\nAddon Service : Backup Server management1\nPeriod : 07/08/2019 to 06/08/2020',1,'year',4800.00,4800.00,'chiangkl','2019-07-18 10:31:47','chiangkl','2019-07-18 10:31:47'),(233,80166,10,171,'Virtual Private Server Hosting (for AVS)','- 40 GB Disk Space\n- 2 GB Memory\n- 2 vCPU\n- 1 Dedicated IP\n- 2TB Monthly Data Transfer\n- 100 Mbps Bandwidth\n- Linux based OS\n- Server management and backup management\n- Free initial setup/commissioning\n- Period : 1/9/2019 - 31/08/2020',1,'year',3000.00,3000.00,'chiangkl','2019-07-18 10:37:41','chiangkl','2019-07-18 10:37:41'),(234,80167,10,173,'VMS Software Maintenance','- Ipoh Branch\n- Period : 1/8/2019 to 31/7/2020',1,'year',1800.00,1800.00,'chiangkl','2019-07-18 10:39:46','chiangkl','2019-07-18 10:39:46'),(235,80168,10,173,'VMS Annual Software Maintenance','- Kuantan Branch\n- Period : 12/9/2019 to 11/9/2020',1,'year',1800.00,1800.00,'chiangkl','2019-07-18 10:41:05','chiangkl','2019-07-18 10:41:21'),(236,80169,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : Jul, Aug, Sep 2019',3,'mth',250.00,750.00,'chiangkl','2019-07-19 01:08:47','chiangkl','2019-07-19 01:08:47'),(237,80169,10,171,'VPS Hosting Fees','- Domain : herdivaonlinefashion.com\n- Period : Jul, Aug, Sep 2019',3,'mth',180.00,540.00,'chiangkl','2019-07-19 01:09:13','chiangkl','2019-07-19 01:09:13'),(238,80170,10,173,'Software Maintenance','- CRM Software\n- Period :Apr, May and Jun 2019',3,'mth',300.00,900.00,'chiangkl','2019-07-19 01:16:28','chiangkl','2019-07-19 01:16:28'),(239,80171,10,173,'Software Maintenance','- CRM Software\n- Period : May 2019',1,'mth',500.00,500.00,'chiangkl','2019-07-19 01:17:51','chiangkl','2019-07-19 01:17:51'),(240,80172,10,173,'Software Maintenance','- CRM Software\n- Period : Jun 2019',1,'mth',500.00,500.00,'chiangkl','2019-07-19 01:18:33','chiangkl','2019-07-19 01:18:33'),(241,80173,10,173,'Software Maintenance','- CRM Software\n- Period : Jul 2019',1,'mth',500.00,500.00,'chiangkl','2019-07-19 01:19:17','chiangkl','2019-07-19 01:19:17'),(242,80174,10,173,'Software Maintenance','- CRM Software\n- Period : Jul, Aug and Sep 2019',3,'mths',500.00,1500.00,'chiangkl','2019-07-19 01:22:38','chiangkl','2019-07-19 01:22:38'),(243,80175,10,172,'Domain Fees','- Domain : casitan.com\n',1,'year',65.00,65.00,'chiangkl','2019-08-01 09:53:03','chiangkl','2019-08-01 09:53:57'),(244,80175,10,171,'Web Hosting Fees','',1,'year',150.00,150.00,'chiangkl','2019-08-01 09:53:18','chiangkl','2019-08-01 09:54:03'),(245,80176,10,173,'Software Maintenance','- CRM Software\n- Period : Jul, Aug and Sep 2019',3,'mth',300.00,900.00,'chiangkl','2019-08-05 09:29:36','chiangkl','2019-08-05 09:29:36'),(246,80176,10,175,'Services','- Data Import Into Excel',1,'L/S',600.00,600.00,'chiangkl','2019-08-05 09:30:09','chiangkl','2019-08-05 09:30:09'),(247,80177,10,174,'Firstcoach Backend','- Account Interface for Agent Commision',1,'L/S',500.00,500.00,'chiangkl','2019-08-09 02:58:11','chiangkl','2019-08-09 02:58:11'),(248,80178,10,173,'Software Maintenance','- Firstcoach Ticketing System\n- Period : 1/10/2019 to 30/9/2020',1,'year',17500.00,17500.00,'chiangkl','2019-09-17 07:52:55','chiangkl','2019-09-17 07:52:55'),(249,80179,10,173,'Software Maintenance (CPO Group)','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2019 to 31 Oct 2020',1,'year',857.00,857.00,'chiangkl','2019-09-19 08:03:35','chiangkl','2019-09-19 08:05:10'),(250,80180,10,173,'Software Maintenance (CPO Group)','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2019 to 31 Oct 2020',1,'year',2573.00,2573.00,'chiangkl','2019-09-19 08:04:30','chiangkl','2019-09-19 08:04:58'),(251,80181,10,173,'Software Maintenance (CPO Group)','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2019 to 31 Oct 2020',1,'year',2571.00,2571.00,'chiangkl','2019-09-19 08:06:08','chiangkl','2019-09-19 08:06:08'),(252,80182,10,173,'Software Maintenance (CPO Group)','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2019 to 31 Oct 2020',1,'year',3428.00,3428.00,'chiangkl','2019-09-19 08:07:02','chiangkl','2019-09-19 08:07:22'),(253,80183,10,173,'Software Maintenance (CPO Group)','- Bus Ticketing System (HQ and Counter desktop system)\n- Period : 1 Nov 2019 to 31 Oct 2020',1,'year',2571.00,2571.00,'chiangkl','2019-09-19 08:08:23','chiangkl','2019-09-19 08:08:23'),(254,80184,10,171,'Web Hosting Fees','- Domain : livinggears.com\n- Period : 23/10/2019 to 22/10/2020    RM670',1,'year',670.00,670.00,'chiangkl','2019-10-03 03:20:51','chiangkl','2019-10-03 03:20:51'),(255,80184,10,173,'Website Annual Maintenance','- Periodic Web database backup service (excl. images)\n- Website Maintenance Support',1,'year',3000.00,3000.00,'chiangkl','2019-10-03 03:21:23','chiangkl','2019-10-03 03:21:23'),(256,80185,10,171,'Linux SSD VPS 3','- Period : 26/12/2019 - 25/12/2020\n- Operating System: CentOS 7.x x86_64 with Plesk 17\n- 3 vCPU\n- 60 GB Disk Space\n- 3GB RAM\n- 100Mbps bandwidth',1,'year',1400.00,1400.00,'chiangkl','2019-11-14 00:32:03','chiangkl','2019-11-14 00:32:03'),(257,80185,10,172,'Domain Fees','- Domain : sqlerp.my\n- Period : 26/12/2019 to 25/12/2020',1,'year',100.00,100.00,'chiangkl','2019-11-14 00:32:35','chiangkl','2019-11-14 00:32:35'),(258,80186,10,173,'AVS System Maintenance','- Being annual system maintenance of Automated Valuation System (AVS)\n- Current development fees RM60000 x 18%\n- Period : 1/11/2019 to 31/10/2020\n- Fees shall be revised in the event of further enhancement to the system',1,'year',10800.00,10800.00,'chiangkl','2019-11-14 09:50:34','chiangkl','2019-11-14 09:50:34'),(259,80187,10,174,'Services','- Jan 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:39:45','chiangkl','2019-11-27 07:39:45'),(260,80188,10,174,'Services','- Feb 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:41:31','chiangkl','2019-11-27 07:41:31'),(261,80189,10,174,'Services','- Mar 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:42:32','chiangkl','2019-11-27 07:42:32'),(262,80190,10,174,'Services','- Apr 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:43:42','chiangkl','2019-11-27 07:43:42'),(263,80191,10,174,'Services','- May 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:44:56','chiangkl','2019-11-27 07:44:56'),(264,80192,10,174,'Services','- June 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:45:42','chiangkl','2019-11-27 07:45:42'),(265,80193,10,174,'Services','- July 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:46:31','chiangkl','2019-11-27 07:46:31'),(266,80194,10,174,'Services','- Aug 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:47:30','chiangkl','2019-11-27 07:47:30'),(267,80195,10,174,'Services','- September 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:48:46','chiangkl','2019-11-27 07:48:46'),(268,80196,10,174,'Services','- Oct 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:49:32','chiangkl','2019-11-27 07:49:32'),(269,80197,10,174,'Services','- November 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:50:12','chiangkl','2019-11-27 07:50:12'),(270,80198,10,174,'Services','- December 2019',1,'L/S',1800.00,1800.00,'chiangkl','2019-11-27 07:51:35','chiangkl','2019-11-27 07:51:35'),(271,80199,10,173,'Software Maintenance','- CRM Software\n- Period : Aug 2019',1,'mth',500.00,500.00,'chiangkl','2019-11-27 07:53:10','chiangkl','2019-11-27 07:53:10'),(272,80200,10,173,'Software Maintenance','- CRM Software\n- Period : Sep 2019',1,'mth',500.00,500.00,'chiangkl','2019-11-27 07:53:54','chiangkl','2019-11-27 07:53:54'),(273,80201,10,173,'Software Maintenance','- CRM Software\n- Period : Oct 2019',1,'mth',500.00,500.00,'chiangkl','2019-11-27 07:54:48','chiangkl','2019-11-27 07:54:48'),(274,80202,10,173,'Software Maintenance','- CRM Software\n- Period : Nov 2019',1,'mth',500.00,500.00,'chiangkl','2019-11-27 07:55:47','chiangkl','2019-11-27 07:55:47'),(275,80203,10,173,'Software Maintenance','- CRM Software\n- Period : Dec 2019',1,'mth',500.00,500.00,'chiangkl','2019-11-27 07:56:33','chiangkl','2019-11-27 07:56:33'),(276,80204,10,173,'Software Maintenance','- CRM Software\n- Period : Oct, Nov and Dec 2019',3,'mths',300.00,900.00,'chiangkl','2019-11-27 08:03:05','chiangkl','2019-11-27 08:03:13'),(277,80205,10,173,'Software Maintenance','- CRM Software\n- Period : Oct, Nov and Dec 2019',3,'mths',500.00,1500.00,'chiangkl','2019-11-27 08:05:06','chiangkl','2019-11-27 08:05:06'),(278,80206,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : Oct, Nov, Dec 2019\n',3,'mths',250.00,750.00,'chiangkl','2019-11-27 08:07:39','chiangkl','2019-11-27 08:07:39'),(279,80206,10,171,'VPS Hosting Fees','- Domain : herdivaonlinefashion.com\n- Period : Oct, Nov, Dec 2019',3,'mths',180.00,540.00,'chiangkl','2019-11-27 08:08:39','chiangkl','2019-11-27 08:08:39'),(280,80207,10,175,'Aveta Motor Stock Development','- Aveta Web Motor Stock (RM8000)\n- Aveta Android Mobile Scanner App (RM5000)\n- Final payment',1,'L/S',9100.00,9100.00,'chiangkl','2019-11-27 08:45:49','chiangkl','2019-11-27 08:45:49'),(281,80208,10,172,'Domain Fees','- Domain : herdivaonlinefashion.com (New Expiry : 9/2020)',1,'year',70.00,70.00,'chiangkl','2019-12-26 07:42:07','chiangkl','2019-12-26 07:42:07'),(282,80209,10,171,'Web Hosting and Domain Fees','- Domain : suprimacomm.com\n- Period : 28/3/2020 - 27/3/2021',1,'year',320.00,320.00,'chiangkl','2020-02-05 04:38:53','chiangkl','2020-02-05 04:39:46'),(283,80210,10,173,'Valuation Management System (VMS) - PJ','- Annual software maintenance\n- Period : 1/2/2020 to 31/01/2021',1,'year',1800.00,1800.00,'chiangkl','2020-02-05 04:50:19','chiangkl','2020-02-05 04:50:57'),(284,80211,10,173,'VMS Software Maintenance','- Annual Maintenance Fees\n- Period : 1 Feb 2020 to 31 Jan 2021',1,'year',3600.00,3600.00,'chiangkl','2020-02-05 04:54:43','chiangkl','2020-02-05 04:54:43'),(285,80211,10,172,'Domain Fees','- Domain : valchecker.com\n- Period : 10/01/2020 to 09/01/2021',1,'year',70.00,70.00,'chiangkl','2020-02-05 04:55:23','chiangkl','2020-02-05 04:55:23'),(286,80212,10,173,'Point Of Sale System','- Annual Service Maintenance\n- For HQ and outlets\n- Period : 1/3/2020 to 28/2/2021',1,'year',3000.00,3000.00,'chiangkl','2020-02-05 04:59:38','chiangkl','2020-02-05 04:59:38'),(287,80213,10,171,'Virtual Private Server (CPO System)','- CPO VPS Server\n- 3 vCPU\n- 80GB disk space\n- 100Mbps bandwidth\n- 1 x IP Address\n- Renewal Period : 15/1/2020 to 14/1/2021 (1 year)',1,'year',5800.00,5800.00,'chiangkl','2020-02-09 01:31:51','chiangkl','2020-02-09 01:31:51'),(288,80214,10,173,'Software Maintenance','- CRM Software\n- Period : Jan 2020',1,'mth',500.00,500.00,'chiangkl','2020-02-09 01:43:06','chiangkl','2020-02-09 01:43:06'),(289,80215,10,173,'Software Maintenance','- CRM Software\n- Period : Feb 2020',1,'mth',500.00,500.00,'chiangkl','2020-02-09 01:43:58','chiangkl','2020-02-09 01:43:58'),(290,80216,10,173,'Software Maintenance','- CRM Software\n- Period : Jan, Feb and Mar 2020',3,'mths',300.00,900.00,'chiangkl','2020-02-09 01:47:03','chiangkl','2020-02-09 01:47:03'),(291,80217,10,173,'Software Maintenance','- CRM Software\n- Period : Jan, Feb and Mar 2020',3,'mths',500.00,1500.00,'chiangkl','2020-02-09 01:51:58','chiangkl','2020-02-09 01:54:11'),(292,80218,10,171,'VPS Hosting Fees','- Domain : herdivaonlinefashion.com\n- Period : Jan, Feb, Mar 2020',3,'mths',180.00,540.00,'chiangkl','2020-02-09 01:56:35','chiangkl','2020-02-09 01:56:35'),(293,80218,10,173,'Website Maintenance','- herdivaonlinefashion.com\n- Period : Jan, Feb, Mar 2020',3,'mths',250.00,750.00,'chiangkl','2020-02-09 01:57:10','chiangkl','2020-02-09 01:57:10'),(294,80219,10,174,'Service','Modify Print Format for Delivery Order',1,'L/S',150.00,150.00,'chiangkl','2020-02-17 03:59:10','chiangkl','2020-02-17 03:59:41'),(295,80220,10,173,'Agent API Module and Agent Web Backed','- Annual Maintenance\n- Agent Module Backend\n- Agent Moduel API\n- Period : 1/4/2020 to 31/3/2021',1,'year',2340.00,2340.00,'chiangkl','2020-03-05 03:44:14','chiangkl','2020-03-05 03:44:14'),(296,80221,10,171,'E-mail Hosting Fees (15 Users)','- Domain : firstcoach.com.my\n- Period : 5 Apr 2020 to 4 Apr 2021',1,'year',900.00,900.00,'chiangkl','2020-03-05 03:45:36','chiangkl','2020-03-05 03:45:36'),(297,80222,10,172,'Domain Fees','- Domain : aptb.com.my\n- Period : 4 Apr 2020 to 3 Apr 2021',1,'year',100.00,100.00,'chiangkl','2020-03-05 03:46:22','chiangkl','2020-03-05 03:46:22'),(298,80222,10,171,'E-mail Web Hosting Fees (5 Users)','- Domain : aptb.com.my\n- Period : 4 Apr 2020 to 3 Apr 2021',1,'year',300.00,300.00,'chiangkl','2020-03-05 03:47:01','chiangkl','2020-03-05 03:47:01'),(300,80223,10,171,'Web Hosting Fees (June 2020)','',1,'year',300.00,300.00,'chiangkl','2020-03-05 03:47:58','chiangkl','2020-03-05 03:47:58'),(301,80223,10,172,'Domain Fees','- masitu.com.my (Apr 2020)\n- masitu.com (June 2020)\n- esphi.com (July 2020)\n- archifoam.com (June 2020)\n(renewed to 2021)',1,'year',280.00,280.00,'chiangkl','2020-03-05 03:48:34','chiangkl','2020-03-05 03:48:34'),(302,80224,10,172,'Domain Fees','- Domain : boonhuamotor.com\n',1,'year',100.00,100.00,'chiangkl','2020-03-09 06:38:14','chiangkl','2020-03-09 06:38:14'),(303,80224,10,171,'Web Hosting Fees (Shared VPS)','- Domain : boonhuamotor.com\n- Period : 26 Apr 2020 to 25 Apr 2021\n- Free SSL Certificate',1,'year',500.00,500.00,'chiangkl','2020-03-09 06:38:52','chiangkl','2020-03-09 06:38:52'),(304,80225,10,173,'Software Maintenance for Aveta','- Period : Oct to Dec 2019',840,'unit',2.50,2100.00,'chiangkl','2020-03-09 09:45:06','chiangkl','2020-03-09 09:45:06');

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `sale_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sale_invoiceno` varchar(50) DEFAULT NULL,
  `sale_customerid` bigint(20) NOT NULL DEFAULT '0',
  `sale_customername` varchar(255) DEFAULT NULL,
  `sale_address` varchar(255) DEFAULT NULL,
  `sale_tel` varchar(255) DEFAULT NULL,
  `sale_fax` varchar(255) DEFAULT NULL,
  `sale_email` varchar(255) DEFAULT NULL,
  `sale_poref` varchar(20) NOT NULL,
  `sale_quotationref` varchar(20) DEFAULT NULL,
  `sale_paymenttermid` bigint(20) DEFAULT NULL,
  `sale_remark` text,
  `sale_date` date NOT NULL,
  `sale_currencyid` bigint(20) DEFAULT NULL,
  `sale_grosstotal` decimal(12,2) DEFAULT NULL,
  `sale_tax` decimal(12,2) DEFAULT NULL,
  `sale_total` decimal(15,2) DEFAULT NULL,
  `sale_status` varchar(20) NOT NULL,
  `sale_createdby` varchar(50) DEFAULT NULL,
  `sale_createddatetime` datetime DEFAULT NULL,
  `sale_updatedby` varchar(50) DEFAULT NULL,
  `sale_updateddatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`sale_id`)
) ENGINE=MyISAM AUTO_INCREMENT=80226 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sales`
--

INSERT INTO `sales` VALUES (1,'2017/03/001',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','-','-',169,'Paid 13/04/2017. CKL','2017-03-15',15,900.00,0.00,900.00,'Normal','chiangkl','2017-03-30 17:06:23','chiangkl','2017-07-10 11:36:58'),(2,'2017/03/002',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','-','-',169,'Paid 09/05/2017. CYY RM1250, CKL Balance','2017-03-30',15,3790.00,0.00,3790.00,'Normal','chiangkl','2017-03-30 18:39:02','chiangkl','2017-07-10 11:38:49'),(3,'2017/03/003',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','-','20160805-FC2',169,'Paid 24/05/2017. CKL RM17760, CYY RM11840','2017-03-30',15,29600.00,0.00,29600.00,'Normal','chiangkl','2017-03-30 18:55:57','chiangkl','2017-07-10 11:40:55'),(80004,'2017/04/001',20,'Suprima Holdings Sdn. Bhd.','No. 12-1, Lorong Batu Nilam 3C,\r\nBandar Bukit Tinggi, 41200 Klang,\r\nMalaysia.','0333247684','0333247620','stephen@suprimacomm.com','','',169,'CKL Outstanding','2017-04-01',15,320.00,0.00,320.00,'Normal','chiangkl','2017-04-23 09:24:39','chiangkl','2018-08-24 07:04:59'),(80005,'2017/04/002',28,'YHC Paper Trading Sdn. Bhd.','No.3, Jalan 33/4A,\r\nElite Industrial Estate,\r\nSeksyen 33, Shah Alam,\r\n40400 Selangor.','0351211901','0351211462','','By Phone','',169,'Paid 25/04/2017. CKL','2017-04-25',15,120.00,0.00,120.00,'Normal','chiangkl','2017-04-25 12:29:50','chiangkl','2017-07-10 11:42:53'),(80006,'2017/04/003',21,'Syarikat Kau Lee','63B-2 Jalan Sultan,\r\n50000 Kuala Lumpur.','0320780188','','skl_88@yahoo.com','','E-mail 20170307',169,'02/05/2017 Paid. CKL','2017-04-28',15,850.00,0.00,850.00,'Normal','chiangkl','2017-04-25 19:24:32','chiangkl','2017-07-10 11:44:17'),(80007,'2017/04/004',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'Paid 19/05/2017. CKL','2017-04-28',15,900.00,0.00,900.00,'Normal','chiangkl','2017-04-28 14:58:20','chiangkl','2017-07-10 11:45:02'),(80009,'2017/02/001',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'Paid. CYY','2017-02-25',15,1800.00,0.00,1800.00,'Normal','chiangkl','2017-05-25 14:30:24','chiangkl','2017-07-10 11:35:09'),(80008,'2017/04/005',25,'Temerloh - Kuala Lumpur Express Omnibus Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','Email20170425',169,'18/05/2017 Paid. CKL','2017-04-28',15,250.00,0.00,250.00,'Normal','chiangkl','2017-04-28 14:58:21','chiangkl','2017-07-10 11:46:26'),(80010,'2017/03/004',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'Paid. CYY','2017-03-25',15,1800.00,0.00,1800.00,'Normal','chiangkl','2017-05-25 14:33:04','chiangkl','2017-07-10 11:41:24'),(80011,'2017/04/006',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'Paid. CYY','2017-04-25',15,1800.00,0.00,1800.00,'Normal','chiangkl','2017-05-25 14:34:50','chiangkl','2017-07-10 11:46:47'),(80012,'2017/05/001',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'19/06/2017 Paid. CKL','2017-05-15',15,860.00,0.00,860.00,'Normal','chiangkl','2017-05-25 14:49:07','chiangkl','2017-07-10 11:47:49'),(80013,'2017/05/002',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'03/07/2017 Paid. CKL (Combined payment)','2017-05-25',15,1000.00,0.00,1000.00,'Normal','chiangkl','2017-05-25 14:58:31','chiangkl','2017-07-10 11:48:39'),(80014,'2017/05/003',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL Outstanding','2017-05-25',15,500.00,0.00,500.00,'Normal','chiangkl','2017-05-25 15:02:21','chiangkl','2018-08-24 07:03:21'),(80015,'2017/06/001',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','20170607-TAP',169,'28/06/2017 Paid RM800. Outstanding RM1200. CYY 50%, CKL 50%','2017-06-23',15,2000.00,0.00,2000.00,'Normal','chiangkl','2017-06-29 12:45:58','chiangkl','2018-08-24 07:03:56'),(80016,'2017/07/001',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'ckl Outstanding','2017-07-03',15,500.00,0.00,500.00,'Normal','chiangkl','2017-07-03 12:27:35','chiangkl','2018-08-24 07:01:09'),(80017,'2017/07/002',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'03/07/2017 Paid. CKL (Combined payment)','2017-07-03',15,1000.00,0.00,1000.00,'Normal','chiangkl','2017-07-03 12:31:26','chiangkl','2017-07-10 11:49:50'),(80018,'2017/07/003',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'ckl Outstanding','2017-07-03',15,930.00,0.00,930.00,'Normal','chiangkl','2017-07-03 12:39:09','chiangkl','2018-08-24 07:01:39'),(80019,'2017/07/004',29,'Jordan Lee & Jaafar Sdn. Bhd. (Ipoh)','Ipoh Branch','0320955811','0320955843','styap@jlj.com.my','','',169,'CKL Outstanding','2017-07-03',15,1800.00,0.00,1800.00,'Normal','chiangkl','2017-07-03 12:56:32','chiangkl','2018-08-24 07:01:52'),(80020,'2017/07/005',30,'Masitu Marketing (M) Sdn Bhd',' Lot 882, Jalan Subang 9,\r\nTaman Perindustrian Subang, \r\n47600 Subang Jaya, \r\nSelangor\r\n','0380234327','','sales@masitu.com','','',169,'06/07/2017 Paid. CKL','2017-07-03',15,580.00,0.00,580.00,'Normal','chiangkl','2017-07-03 13:23:16','chiangkl','2017-07-10 11:50:50'),(80021,'2017/02/002',31,'Bakti Raya Sdn Bhd','Selangor','','','','','',169,'Paid 06/07/2017. CKL','2017-02-25',15,250.00,0.00,250.00,'Normal','chiangkl','2017-07-03 13:44:03','chiangkl','2017-07-10 11:35:54'),(80022,'2017/07/006',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL Outstanding','2017-07-04',15,5800.00,0.00,5800.00,'Normal','chiangkl','2017-07-05 05:54:27','chiangkl','2018-08-24 07:02:05'),(80023,'2017/08/001',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2017-08-01',15,500.00,0.00,500.00,'Normal','chiangkl','2017-08-01 15:40:43','chiangkl','2018-08-24 06:59:11'),(80024,'2017/08/002',118,'Casitan Sdn Bhd','65-1 Petaling Utama Avenue,\r\nJalan PJS 1/50, 7th Mile off Jalan Klang Lama,\r\n46150 Petaling Jaya, Selangor','0377851245','0377851251','casitancarbon@gmail.com','','',169,'CKL Paid 9/8/2017','2017-08-01',15,215.00,0.00,215.00,'Normal','chiangkl','2017-08-01 23:18:42','chiangkl','2018-08-24 06:59:18'),(80025,'2017/08/003',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'CYY RM250, CKL RM320','2017-08-11',15,570.00,0.00,570.00,'Normal','chiangkl','2017-08-11 11:34:44','chiangkl','2018-08-24 06:59:59'),(80055,'2017/12/006',31,'Bakti Raya Sdn Bhd','Selangor','','','','','',169,'ckl','2017-12-28',15,250.00,0.00,250.00,'Normal','chiangkl','2018-01-08 12:08:24','chiangkl','2018-08-24 06:51:32'),(80056,'2017/12/007',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'CKL 50%, CYY 50%','2017-12-28',15,1500.00,0.00,1500.00,'Normal','chiangkl','2018-01-08 12:16:35','chiangkl','2018-08-24 06:51:23'),(80027,'2017/08/005',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'ckl','2017-08-21',15,1545.00,0.00,1245.00,'Normal','chiangkl','2017-08-20 14:51:30','chiangkl','2018-08-24 07:00:08'),(80028,'2017/10/001',119,'Living Planet Enterprise','C-G-1, BBT ONE Tower C,\r\nBandar Bukit Tinggi,\r\n41200, Klang, Selangor','0333187667','','sales@livinggears.com','','',169,'CYY RM1500, CKL RM2170','2017-10-11',15,3670.00,0.00,3670.00,'Normal','chiangkl','2017-10-11 05:19:15','chiangkl','2018-08-24 06:58:14'),(80029,'2017/10/002',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'CKL Paid','2017-10-11',15,1500.00,0.00,1500.00,'Normal','chiangkl','2017-10-11 05:28:11','chiangkl','2018-08-24 06:57:29'),(80030,'2017/10/003',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'CKL','2017-10-11',15,860.00,0.00,860.00,'Normal','chiangkl','2017-10-11 05:34:01','chiangkl','2018-08-24 06:57:21'),(80031,'2017/09/001',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','',169,'CKL','2017-09-30',15,1800.00,0.00,1800.00,'Normal','chiangkl','2017-10-11 05:39:56','chiangkl','2018-08-24 07:00:24'),(80032,'2017/10/004',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL','2017-10-11',15,2400.00,0.00,2400.00,'Normal','chiangkl','2017-10-11 05:56:56','chiangkl','2018-08-24 06:57:09'),(80033,'2017/10/005',23,'Syarikat Kenderaan Satria Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL','2017-10-11',15,800.00,0.00,800.00,'Normal','chiangkl','2017-10-11 05:58:42','chiangkl','2018-08-24 06:57:02'),(80034,'2017/10/006',22,'Syarikat Central Pahang Omnibus Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL','2017-10-11',15,2400.00,0.00,2400.00,'Normal','chiangkl','2017-10-11 06:00:01','chiangkl','2018-08-24 06:55:17'),(80035,'2017/10/007',24,'The Pahang South Union Omnibus Company Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL','2017-10-11',15,3200.00,0.00,3200.00,'Normal','chiangkl','2017-10-11 06:00:57','chiangkl','2018-08-24 06:55:35'),(80036,'2017/10/008',25,'Temerloh - Kuala Lumpur Express Omnibus Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL','2017-10-11',15,3200.00,0.00,3200.00,'Normal','chiangkl','2017-10-11 06:01:42','chiangkl','2018-08-24 06:55:43'),(80037,'2017/09/002',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2017-09-15',15,500.00,0.00,500.00,'Normal','chiangkl','2017-10-15 09:56:40','chiangkl','2018-08-24 06:58:42'),(80038,'2017/10/009',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2017-10-15',15,500.00,0.00,500.00,'Normal','chiangkl','2017-10-15 09:57:36','chiangkl','2018-08-24 06:55:49'),(80039,'2017/09/003',21,'Syarikat Kau Lee','63B-2 Jalan Sultan,\r\n50000 Kuala Lumpur.','0320780188','','skl_88@yahoo.com','','',169,'CKL','2017-09-25',15,70.00,0.00,70.00,'Normal','chiangkl','2017-10-21 23:09:18','chiangkl','2018-08-24 06:58:32'),(80040,'2017/10/010',120,'Rightcliq Solutions','E7-05 The Gamuda Biz Suites,\r\nNo. 12, Jalan Anggerik Vanilla 31/99,\r\nKota Kemuning,\r\n40460 Shah Alam,\r\nSelangor, Malaysia','','','aliasgar@rightcliq.com.my','','',169,'CKL','2017-10-25',15,1225.00,0.00,1225.00,'Normal','chiangkl','2017-10-25 10:18:03','chiangkl','2018-08-24 06:56:03'),(80041,'2017/11/001',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'CKL','2017-11-29',15,1290.00,0.00,1290.00,'Normal','chiangkl','2017-11-29 08:44:10','chiangkl','2018-08-24 06:56:28'),(80042,'2017/12/001',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'CKL Paid','2017-12-01',15,1000.00,0.00,1000.00,'Normal','chiangkl','2017-12-01 09:50:46','chiangkl','2018-08-24 06:54:15'),(80043,'2017/12/002',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'To CANCEL','2017-12-13',15,0.00,0.00,0.00,'Normal','chiangkl','2017-12-13 17:47:09','chiangkl','2018-08-24 07:31:25'),(80044,'2017/11/002',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CYY','2017-11-13',15,500.00,0.00,500.00,'Normal','chiangkl','2017-12-13 17:51:03','chiangkl','2018-08-24 06:54:48'),(80045,'2017/12/003',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'ckl','2017-12-13',15,500.00,0.00,500.00,'Normal','chiangkl','2017-12-13 17:51:53','chiangkl','2018-08-24 06:53:21'),(80046,'2017/12/004',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'ckl','2017-12-13',15,900.00,0.00,900.00,'Normal','chiangkl','2017-12-13 17:52:58','chiangkl','2018-08-24 06:51:54'),(80047,'2017/12/005',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','20171211-JLJv2',169,'CKL 60%, CYY 40%','2017-12-19',15,15600.00,0.00,15600.00,'Normal','chiangkl','2017-12-19 13:26:15','chiangkl','2018-08-24 06:51:46'),(80048,'2017/05/004',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2017-05-31',15,1800.00,0.00,1800.00,'Normal','cheongyy','2017-12-28 18:04:59','chiangkl','2018-08-24 07:03:31'),(80049,'2017/06/002',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2017-06-30',15,1800.00,0.00,1800.00,'Normal','cheongyy','2017-12-28 21:53:58','chiangkl','2018-08-24 07:04:08'),(80050,'2017/07/007',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2017-07-31',15,1800.00,0.00,1800.00,'Normal','cheongyy','2017-12-28 22:27:45','chiangkl','2018-08-24 07:02:14'),(80051,'2017/08/006',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2017-08-31',15,1800.00,0.00,1800.00,'Normal','cheongyy','2017-12-28 23:34:40','chiangkl','2018-08-24 07:00:16'),(80052,'2017/09/004',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2017-09-29',15,1800.00,0.00,1800.00,'Normal','cheongyy','2017-12-29 15:16:59','chiangkl','2018-08-24 06:58:22'),(80053,'2017/10/011',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2017-10-31',15,1800.00,0.00,1800.00,'Normal','cheongyy','2017-12-29 16:12:18','chiangkl','2018-08-24 06:56:14'),(80054,'2017/11/003',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2017-11-30',15,1800.00,0.00,1800.00,'Normal','cheongyy','2017-12-29 16:33:38','chiangkl','2018-08-24 06:54:34'),(80057,'2018/01/001',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'ckl','2018-01-15',15,900.00,0.00,900.00,'Normal','chiangkl','2018-02-11 13:51:47','chiangkl','2018-08-24 06:50:20'),(80058,'2018/01/002',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'ckl','2018-01-15',15,500.00,0.00,500.00,'Normal','chiangkl','2018-02-11 13:55:55','chiangkl','2018-08-24 06:50:11'),(80059,'2018/01/003',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','',169,'ckl','2018-01-18',15,3600.00,0.00,3600.00,'Normal','chiangkl','2018-02-11 14:01:13','chiangkl','2018-08-24 06:47:18'),(80060,'2018/01/004',121,'Jordan Lee & Jaafar Sdn. Bhd.  (PJ)','A-2-3, Block A,\r\nPusat Perniagaan Seksyen 8, \r\nJalan Sungai Jernih 8/1,  \r\n46050 Petaling Jaya, Selangor','03-7956 5811','03-7955 5843','sherman@jlj.com.my','','',169,'ckl','2018-01-18',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-02-11 14:14:20','chiangkl','2018-08-24 06:47:42'),(80061,'2018/02/001',21,'Syarikat Kau Lee','63B-2 Jalan Sultan,\r\n50000 Kuala Lumpur.','0320780188','','skl_88@yahoo.com','','',169,'ckl','2018-02-09',15,3000.00,0.00,3000.00,'Normal','chiangkl','2018-02-11 14:21:22','chiangkl','2018-08-24 06:48:13'),(80062,'2018/02/002',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL 60%, CYY 40%','2018-02-09',15,18500.00,0.00,18500.00,'Normal','chiangkl','2018-02-11 14:29:27','chiangkl','2018-08-24 06:48:43'),(80063,'2018/02/003',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'ckl','2018-02-11',15,860.00,0.00,860.00,'Normal','chiangkl','2018-02-11 14:36:00','chiangkl','2018-08-24 06:48:59'),(80064,'2017/12/008',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2017-12-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-02-11 16:05:04','chiangkl','2018-08-24 06:50:30'),(80065,'2018/01/005',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2018-01-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-02-11 16:06:01','chiangkl','2018-08-24 06:48:05'),(80066,'2018/03/001',20,'Suprima Holdings Sdn. Bhd.','No. 12-1, Lorong Batu Nilam 3C,\r\nBandar Bukit Tinggi, 41200 Klang,\r\nMalaysia.','0333247684','0333247620','stephen@suprimacomm.com','','',169,'ckl','2018-03-27',15,320.00,0.00,320.00,'Normal','chiangkl','2018-03-27 08:37:47','chiangkl','2018-08-24 06:49:15'),(80067,'2018/02/004',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'ckl','2018-02-15',15,500.00,0.00,500.00,'Normal','chiangkl','2018-03-27 08:47:51','chiangkl','2018-08-24 06:49:08'),(80068,'2018/03/002',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'ckl','2018-03-15',15,500.00,0.00,500.00,'Normal','chiangkl','2018-03-27 08:48:52','chiangkl','2018-08-24 07:17:03'),(80069,'2018/03/003',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'ckl','2018-03-27',15,1500.00,0.00,1500.00,'Normal','chiangkl','2018-03-27 08:56:56','chiangkl','2018-08-24 06:45:38'),(80070,'2018/03/004',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'ckl','2018-03-27',15,860.00,0.00,860.00,'Normal','chiangkl','2018-03-27 09:01:03','chiangkl','2018-08-24 06:45:54'),(80071,'2018/03/005',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'CKL 50%, CYY 50%','2018-03-27',15,1200.00,0.00,1200.00,'Normal','chiangkl','2018-03-27 09:03:27','chiangkl','2018-08-24 06:46:19'),(80072,'2018/05/001',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'ckl','2018-05-14',15,1500.00,0.00,1500.00,'Normal','chiangkl','2018-05-14 18:09:28','chiangkl','2018-08-24 06:45:07'),(80073,'2018/05/002',122,'Daebak Esport Cafe','18, Jalan Damai Perdana 1/9a,\r\nBandar Damai Perdana,\r\n56000 Cheras 9 Miles, Kuala Lumpur','0177808884','','cheongkl@gmail.com','','',169,'ckl','2018-05-14',15,400.00,0.00,400.00,'Normal','chiangkl','2018-05-14 18:19:46','chiangkl','2018-08-24 06:44:55'),(80074,'2018/05/003',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'ckl','2018-08-31',15,900.00,0.00,900.00,'Normal','chiangkl','2018-05-14 18:25:21','chiangkl','2018-08-24 06:44:29'),(80075,'2018/05/004',123,'Hyperack Sdn Bhd.','No. 40G & MF, Lintang Gelugor,\r\nOff Persiaran Sultan Ibrahim,\r\n41300 Klang, Selangor.','0193836933','','chester@hyperack.com.m','','20180428HPR',169,'To Cancel','2018-05-17',15,0.00,0.00,0.00,'Normal','chiangkl','2018-05-17 17:45:30','chiangkl','2018-08-24 07:30:38'),(80076,'2018/05/005',28,'YHC Paper Trading Sdn. Bhd.','No.3, Jalan 33/4A,\r\nElite Industrial Estate,\r\nSeksyen 33, Shah Alam,\r\n40400 Selangor.','0351211901','0351211462','','','',169,'ckl','2018-05-30',15,90.00,0.00,90.00,'Normal','chiangkl','2018-05-31 09:29:59','chiangkl','2018-08-24 06:44:05'),(80077,'2018/05/006',30,'Masitu Marketing (M) Sdn Bhd',' Lot 882, Jalan Subang 9,\r\nTaman Perindustrian Subang, \r\n47600 Subang Jaya, \r\nSelangor\r\n','0380234327','','sales@masitu.com','','',169,'ckl','2018-05-31',15,580.00,0.00,580.00,'Normal','chiangkl','2018-05-31 09:36:03','chiangkl','2018-08-24 06:39:48'),(80078,'2018/06/001',21,'Syarikat Kau Lee','63B-2 Jalan Sultan,\r\n50000 Kuala Lumpur.','0320780188','','skl_88@yahoo.com','','',169,'ckl','2018-06-10',15,450.00,0.00,450.00,'Normal','chiangkl','2018-06-11 21:38:51','chiangkl','2018-08-24 06:42:14'),(80079,'2018/06/002',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','20171211-JLJv2',169,'CKL 60%, CYY 40%','2018-06-28',15,15600.00,0.00,15600.00,'Normal','chiangkl','2018-07-02 03:28:42','chiangkl','2018-08-24 06:42:39'),(80080,'2018/06/003',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL','2018-06-30',15,-8700.00,0.00,2900.00,'Normal','chiangkl','2018-07-05 03:42:58','chiangkl','2018-08-24 06:43:15'),(80081,'2018/07/001',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'ckl','2018-07-07',15,1360.00,0.00,1360.00,'Normal','chiangkl','2018-07-07 01:30:33','chiangkl','2018-08-24 06:43:38'),(80082,'2018/07/002',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'CYY 50% , CKL 50%','2018-07-15',15,2647.00,0.00,2647.00,'Normal','chiangkl','2018-07-23 14:24:39','chiangkl','2018-08-24 06:36:16'),(80083,'2018/07/003',29,'Jordan Lee & Jaafar Sdn. Bhd. (Ipoh)','Ipoh Branch','0320955811','0320955843','styap@jlj.com.my','','',169,'CKL','2018-07-25',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-07-25 07:13:46','chiangkl','2018-08-24 06:35:40'),(80084,'2018/08/001',118,'Casitan Sdn Bhd','65-1 Petaling Utama Avenue,\r\nJalan PJS 1/50, 7th Mile off Jalan Klang Lama,\r\n46150 Petaling Jaya, Selangor','0377851245','0377851251','casitancarbon@gmail.com','','',169,'CKL','2018-08-03',15,215.00,0.00,215.00,'Normal','chiangkl','2018-08-03 08:46:23','chiangkl','2018-08-24 06:35:07'),(80085,'2018/08/002',21,'Syarikat Kau Lee','63B-2 Jalan Sultan,\r\n50000 Kuala Lumpur.','0320780188','','skl_88@yahoo.com','','',169,'CKL','2018-08-03',15,70.00,0.00,70.00,'Normal','chiangkl','2018-08-03 08:55:07','chiangkl','2018-08-24 06:34:49'),(80086,'2018/08/003',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'CYY RM300, CKL RM870','2018-08-03',15,1170.00,0.00,1170.00,'Normal','chiangkl','2018-08-03 08:59:55','chiangkl','2018-08-24 06:33:21'),(80087,'2018/08/004',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'ckl','2018-08-14',15,900.00,0.00,900.00,'Normal','chiangkl','2018-08-14 09:37:39','chiangkl','2018-08-24 06:32:18'),(80088,'2018/08/005',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','',169,'ckl','2018-08-22',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-08-14 10:21:28','chiangkl','2018-08-24 06:32:05'),(80089,'2018/08/006',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','',169,'ckl','2018-08-22',15,3000.00,0.00,3000.00,'Normal','chiangkl','2018-08-14 10:22:46','chiangkl','2018-08-24 06:31:51'),(80090,'2018/08/007',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','',169,'ckl','2018-08-23',15,300.00,0.00,300.00,'Normal','chiangkl','2018-08-23 14:33:38','chiangkl','2018-08-24 06:31:39'),(80091,'2018/08/008',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'CKL','2018-08-24',15,1500.00,0.00,1500.00,'Normal','chiangkl','2018-08-24 07:09:48','chiangkl','2018-08-24 07:10:46'),(80092,'2018/04/001',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2018-04-24',15,500.00,0.00,500.00,'Normal','chiangkl','2018-08-24 07:17:30','chiangkl','2018-08-24 07:17:56'),(80093,'2018/05/007',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2018-05-24',15,500.00,0.00,500.00,'Normal','chiangkl','2018-08-24 07:18:15','chiangkl','2018-08-24 07:18:36'),(80094,'2018/06/004',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2018-06-24',15,500.00,0.00,500.00,'Normal','chiangkl','2018-08-24 07:19:05','chiangkl','2018-08-24 07:19:25'),(80095,'2018/07/004',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2018-07-24',15,500.00,0.00,500.00,'Normal','chiangkl','2018-08-24 07:19:51','chiangkl','2018-08-24 07:20:13'),(80096,'2018/08/009',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2018-08-24',15,500.00,0.00,500.00,'Normal','chiangkl','2018-08-24 07:22:22','chiangkl','2018-08-24 07:22:41'),(80097,'2018/02/005',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2018-02-28',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-08-24 07:25:46','chiangkl','2018-08-24 07:26:09'),(80098,'2018/03/006',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2018-03-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-08-24 07:26:32','chiangkl','2018-08-24 07:26:48'),(80099,'2018/04/002',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2018-04-30',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-08-24 07:27:09','chiangkl','2018-08-24 07:27:28'),(80100,'2018/05/008',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2018-05-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-08-24 07:27:53','chiangkl','2018-08-24 07:28:09'),(80101,'2018/06/005',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2018-06-30',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-08-24 07:28:27','chiangkl','2018-08-24 07:29:08'),(80102,'2018/07/005',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2018-07-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-08-24 07:29:29','chiangkl','2018-08-24 07:29:44'),(80103,'2018/08/010',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2018-08-24',15,1800.00,0.00,1800.00,'Normal','chiangkl','2018-08-24 07:29:59','chiangkl','2018-08-24 07:30:15'),(80104,'2018/09/001',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','By Email','20180701BR',169,'','2018-09-03',15,13400.00,0.00,13400.00,'Normal','chiangkl','2018-09-12 09:25:57','chiangkl','2018-09-12 09:40:18'),(80105,'2018/10/001',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','29171211-JLJv2',169,'ckl 60% cyy 40%','2018-09-26',15,20800.00,0.00,20800.00,'Normal','chiangkl','2018-10-02 08:07:48','chiangkl','2018-10-02 08:13:21'),(80106,'2018/10/002',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'','2018-10-01',15,19700.00,0.00,19700.00,'Normal','chiangkl','2018-10-02 08:45:55','chiangkl','2018-10-02 09:17:31'),(80107,'2018/10/003',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'','2018-10-01',15,17500.00,0.00,17500.00,'Normal','chiangkl','2018-10-02 09:18:16','chiangkl','2018-10-02 09:19:18'),(80108,'2018/10/004',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'','2018-10-11',15,2360.00,0.00,2360.00,'Normal','chiangkl','2018-10-12 23:58:15','chiangkl','2018-10-13 08:27:04'),(80109,'2018/10/005',119,'Living Planet Enterprise','C-G-1, BBT ONE Tower C,\r\nBandar Bukit Tinggi,\r\n41200, Klang, Selangor','0333187667','','sales@livinggears.com','','',169,'','2018-10-16',15,3670.00,0.00,3670.00,'Normal','chiangkl','2018-10-16 14:28:39','chiangkl','2018-10-16 14:30:56'),(80110,'2018/10/006',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2018-10-16',15,500.00,0.00,500.00,'Normal','chiangkl','2018-10-16 14:34:10','chiangkl','2019-11-27 07:58:36'),(80111,'2018/09/002',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2018-09-16',15,500.00,0.00,500.00,'Normal','chiangkl','2018-10-16 14:35:43','chiangkl','2019-11-27 07:58:30'),(80112,'2018/10/007',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'','2018-10-19',15,2573.00,0.00,2573.00,'Normal','chiangkl','2018-10-19 00:17:36','chiangkl','2018-10-25 04:59:21'),(80113,'2018/10/008',23,'Syarikat Kenderaan Satria Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'','2018-10-19',15,857.00,0.00,857.00,'Normal','chiangkl','2018-10-19 00:19:59','chiangkl','2018-10-25 04:59:46'),(80114,'2018/10/009',22,'Syarikat Central Pahang Omnibus Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'','2018-10-19',15,2571.00,0.00,2571.00,'Normal','chiangkl','2018-10-19 00:21:03','chiangkl','2018-10-25 04:58:56'),(80115,'2018/10/010',24,'The Pahang South Union Omnibus Company Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'','2018-10-19',15,2571.00,0.00,2571.00,'Normal','chiangkl','2018-10-19 00:21:59','chiangkl','2018-10-25 05:00:40'),(80116,'2018/10/011',25,'Temerloh - Kuala Lumpur Express Omnibus Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'','2018-10-19',15,3428.00,0.00,3428.00,'Normal','chiangkl','2018-10-19 00:22:41','chiangkl','2018-10-25 05:00:06'),(80117,'2018/10/012',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'','2018-10-25',15,200.00,0.00,200.00,'Normal','chiangkl','2018-10-25 05:06:15','chiangkl','2018-10-25 05:09:03'),(80118,'2018/10/013',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'','2018-10-15',15,900.00,0.00,900.00,'Normal','chiangkl','2018-10-29 09:51:15','chiangkl','2018-10-29 09:51:44'),(80119,'2018/10/014',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'','2018-10-19',15,1500.00,0.00,1500.00,'Normal','chiangkl','2018-10-29 09:54:26','chiangkl','2018-10-29 09:54:52'),(80120,'2018/11/001',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'','2018-11-10',15,484.00,0.00,484.00,'Normal','chiangkl','2018-11-14 07:38:59','chiangkl','2018-11-14 07:43:00'),(80121,'2018/11/002',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','20171211-JLJv2',169,'','2018-11-23',15,9360.00,0.00,9360.00,'Normal','chiangkl','2018-11-23 04:18:15','chiangkl','2018-11-23 04:22:27'),(80122,'2018/12/001',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'','2018-12-11',15,224.00,0.00,224.00,'Normal','chiangkl','2018-12-14 01:01:02','chiangkl','2018-12-14 01:01:29'),(80123,'2018/11/003',125,'SQL ERP Business  Solutions PLT','1, Jalan Sri Puchong 2b,\r\n47100 Puchong, Selangor','','','','','',169,'','2018-11-03',15,5000.00,0.00,5000.00,'Normal','chiangkl','2018-12-17 04:25:54','chiangkl','2019-01-04 00:38:09'),(80124,'2018/11/004',124,'Boon Hua Motor Sdn Bhd','1, Jalan Sri Puchong 2b,\r\n47100 Puchong,\r\nSelangor','','','','20181012-BHM','',169,'CKL-60%','2018-11-17',15,2800.00,0.00,2800.00,'Normal','chiangkl','2018-12-17 04:29:01','chiangkl','2019-11-27 07:38:50'),(80125,'2018/12/002',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'CKL','2018-12-17',15,860.00,0.00,860.00,'Normal','chiangkl','2018-12-17 23:04:23','chiangkl','2019-11-27 08:09:20'),(80126,'2018/12/003',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'','2018-12-17',15,600.00,0.00,600.00,'Normal','chiangkl','2018-12-17 23:10:26','chiangkl','2018-12-17 23:11:40'),(80127,'2019/01/001',125,'SQL ERP Business  Solution PLT','1, Jalan Sri Puchong 2b,\r\n47100 Puchong, Selangor','','','','','',169,'CKL','2019-01-03',15,928.14,0.00,928.14,'Normal','chiangkl','2019-01-03 03:54:03','chiangkl','2019-11-27 07:22:46'),(80128,'2019/01/002',125,'SQL ERP Business  Solution PLT','1, Jalan Sri Puchong 2b,\r\n47100 Puchong, Selangor','','','','','',169,'CKL-60%','2019-01-03',15,5000.00,0.00,5000.00,'Normal','chiangkl','2019-01-03 04:02:14','chiangkl','2019-11-27 07:22:29'),(80129,'2019/01/003',124,'Boon Hua Motor Sdn Bhd','1, Jalan Sri Puchong 2b,\r\n47100 Puchong,\r\nSelangor','','','','','20181012-BHM',169,'CKL-60%','2019-01-31',15,4200.00,0.00,4200.00,'Normal','chiangkl','2019-01-03 04:06:23','chiangkl','2019-11-27 07:30:03'),(80130,'2019/01/004',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL','2019-01-03',15,5800.00,0.00,5800.00,'Normal','chiangkl','2019-01-03 04:12:21','chiangkl','2019-11-27 07:22:59'),(80131,'2019/01/005',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL RM4505','2019-01-03',15,7465.00,0.00,7465.00,'Normal','chiangkl','2019-01-03 04:15:42','chiangkl','2019-11-27 07:24:19'),(80132,'2019/01/006',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','20180701/1018BR',169,'CKL-60%','2019-01-24',15,7500.00,0.00,7500.00,'Normal','chiangkl','2019-01-03 04:20:17','chiangkl','2019-11-27 08:25:52'),(80133,'2019/01/007',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'CKL','2019-01-15',15,900.00,0.00,900.00,'Normal','chiangkl','2019-01-15 08:19:41','chiangkl','2019-11-27 08:24:53'),(80134,'2019/01/008',124,'Boon Hua Motor Sdn Bhd','1, Jalan Sri Puchong 2b,\r\n47100 Puchong,\r\nSelangor','','','','','20181012-BHM(Add)',169,'CKL-60%','2019-01-15',15,2000.00,0.00,2000.00,'Normal','chiangkl','2019-01-15 14:05:14','chiangkl','2019-11-27 07:38:19'),(80135,'2019/01/009',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','',169,'CKL','2019-01-24',15,3670.00,0.00,3670.00,'Normal','chiangkl','2019-01-24 01:50:26','chiangkl','2019-11-27 08:24:40'),(80136,'2019/01/010',121,'Jordan Lee & Jaafar Sdn. Bhd.  (PJ)','A-2-3, Block A,\r\nPusat Perniagaan Seksyen 8, \r\nJalan Sungai Jernih 8/1,  \r\n46050 Petaling Jaya, Selangor','03-7956 5811','03-7955 5843','sherman@jlj.com.my','','',169,'CKL','2019-01-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-01-31 09:54:13','chiangkl','2019-11-27 08:23:44'),(80137,'2019/02/001',21,'Syarikat Kau Lee','63B-2 Jalan Sultan,\r\n50000 Kuala Lumpur.','0320780188','','skl_88@yahoo.com','','',169,'CKL','2019-02-01',15,3000.00,0.00,3000.00,'Normal','chiangkl','2019-01-31 09:59:18','chiangkl','2019-11-27 08:23:19'),(80138,'2019/02/002',126,'Genusis Consultancy Sdn Bhd','','0122811933','','Gary.leong@genusis.com','','',169,'CKL','2019-02-12',15,320.00,0.00,320.00,'Normal','chiangkl','2019-02-12 05:15:04','chiangkl','2019-11-27 08:22:58'),(80139,'2019/03/001',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'CKL','2019-03-01',15,1290.00,0.00,1290.00,'Normal','chiangkl','2019-03-01 00:22:33','chiangkl','2019-11-27 09:12:12'),(80140,'2019/03/002',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'CKL','2019-03-01',15,1500.00,0.00,1500.00,'Normal','chiangkl','2019-03-01 00:25:56','chiangkl','2019-11-27 09:12:43'),(80141,'2018/11/005',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2018-11-30',15,500.00,0.00,500.00,'Normal','chiangkl','2019-03-01 00:37:45','chiangkl','2019-11-27 07:58:43'),(80142,'2018/12/004',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2018-12-30',15,500.00,0.00,500.00,'Normal','chiangkl','2019-03-01 00:38:59','chiangkl','2019-11-27 07:58:49'),(80143,'2019/01/011',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2019-01-30',15,500.00,0.00,500.00,'Normal','chiangkl','2019-03-01 00:39:43','chiangkl','2019-11-27 07:58:06'),(80144,'2019/02/003',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2019-02-28',15,500.00,0.00,500.00,'Normal','chiangkl','2019-03-01 00:41:31','chiangkl','2019-11-27 07:58:00'),(80145,'2019/03/003',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2019-03-01',15,500.00,0.00,500.00,'Normal','chiangkl','2019-03-01 00:42:11','chiangkl','2019-11-27 07:57:41'),(80146,'2018/09/003',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'','2018-09-15',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-03-14 07:58:54','chiangkl','2019-03-14 07:59:18'),(80147,'2018/10/015',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'','2018-10-15',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-03-14 08:00:33','chiangkl','2019-03-14 08:01:19'),(80148,'2018/11/006',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'','2018-11-15',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-03-14 08:19:05','chiangkl','2019-03-14 08:19:30'),(80149,'2018/12/005',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2018-12-15',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-03-14 08:19:57','chiangkl','2019-11-27 08:25:29'),(80150,'2019/04/001',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','20180701 & 20181018',169,'CKL-50%','2019-04-05',15,2340.00,0.00,2340.00,'Normal','chiangkl','2019-04-05 02:47:05','chiangkl','2019-11-27 08:21:46'),(80151,'2019/04/002',127,'Asia Pacific Truck & Bus Sdn Bhd','Segambut\r\nKUala Lumpur','','','','','',169,'CKL','2019-04-16',15,400.00,0.00,400.00,'Normal','chiangkl','2019-04-16 03:35:56','chiangkl','2019-11-27 08:20:57'),(80152,'2019/04/003',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL','2019-04-16',15,1400.00,0.00,1400.00,'Normal','chiangkl','2019-04-16 03:38:34','chiangkl','2019-11-27 08:20:26'),(80153,'2019/04/004',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'CKL','2019-04-16',15,1290.00,0.00,1290.00,'Normal','chiangkl','2019-04-16 03:41:22','chiangkl','2019-11-27 08:09:07'),(80154,'2019/04/005',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2019-04-16',15,500.00,0.00,500.00,'Normal','chiangkl','2019-04-16 03:44:04','chiangkl','2019-11-27 07:57:34'),(80155,'2019/04/006',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'CKL','2019-04-16',15,1500.00,0.00,1500.00,'Normal','chiangkl','2019-04-16 03:51:26','chiangkl','2019-11-27 08:19:08'),(80156,'2019/04/007',124,'Boon Hua Motor Sdn Bhd','1, Jalan Sri Puchong 2b,\r\n47100 Puchong,\r\nSelangor','','','','','',169,'CKL-60%','2019-04-24',15,3000.00,0.00,3000.00,'Normal','chiangkl','2019-04-24 02:45:24','chiangkl','2019-11-27 07:37:39'),(80157,'2019/04/008',125,'SQL ERP Business  Solution PLT','1, Jalan Sri Puchong 2b,\r\n47100 Puchong, Selangor','','','','','',169,'-','2019-04-24',15,0.00,0.00,0.00,'Normal','chiangkl','2019-04-24 02:50:45','chiangkl','2019-11-27 09:41:02'),(80158,'2019/04/009',125,'SQL ERP Business  Solution PLT','1, Jalan Sri Puchong 2b,\r\n47100 Puchong, Selangor','','','','','',169,'CKL-60%','2019-04-25',15,4000.00,0.00,4000.00,'Normal','chiangkl','2019-04-25 15:32:22','chiangkl','2019-11-27 08:19:48'),(80159,'2019/04/010',30,'Masitu Marketing (M) Sdn Bhd',' Lot 882, Jalan Subang 9,\r\nTaman Perindustrian Subang, \r\n47600 Subang Jaya, \r\nSelangor\r\n','0380234327','','sales@masitu.com','','',170,'CKL','2019-04-26',15,580.00,0.00,580.00,'Normal','chiangkl','2019-04-26 02:07:58','chiangkl','2019-11-27 08:18:45'),(80160,'2019/04/011',124,'Boon Hua Motor Sdn Bhd','1, Jalan Sri Puchong 2b,\r\n47100 Puchong,\r\nSelangor','','','','','',169,'CKL','2019-04-26',15,650.00,0.00,650.00,'Normal','chiangkl','2019-04-26 02:17:42','chiangkl','2019-11-27 07:36:59'),(80161,'2019/05/001',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','',169,'CKL-RM5100','2019-05-02',15,8600.00,0.00,8600.00,'Normal','chiangkl','2019-05-09 08:47:28','chiangkl','2019-11-27 08:18:13'),(80162,'2019/05/002',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'CKL','2019-05-14',15,350.00,0.00,350.00,'Normal','chiangkl','2019-05-13 11:22:14','chiangkl','2019-11-27 08:17:20'),(80163,'2019/06/001',128,'Jurusniaga Sdn. Bhd.','','','','','','',169,'CKL','2019-06-03',15,500.00,0.00,500.00,'Normal','chiangkl','2019-06-03 07:32:35','chiangkl','2019-11-27 08:15:41'),(80164,'2019/06/002',125,'SQL ERP Business  Solution PLT','1, Jalan Sri Puchong 2b,\r\n47100 Puchong, Selangor','','','','','',169,'CKL-RM5000.14','2019-06-20',15,7560.14,0.00,7560.14,'Normal','chiangkl','2019-06-20 10:59:33','chiangkl','2019-11-27 10:15:24'),(80165,'2019/07/001',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'ckl','2019-07-17',15,5200.00,0.00,5200.00,'Normal','chiangkl','2019-07-18 10:30:49','chiangkl','2019-11-27 08:14:31'),(80166,'2019/07/002',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','',169,'ckl','2019-07-18',15,3000.00,0.00,3000.00,'Normal','chiangkl','2019-07-18 10:37:02','chiangkl','2019-11-27 08:14:21'),(80167,'2019/07/003',29,'Jordan Lee & Jaafar Sdn. Bhd. (Ipoh)','Ipoh Branch','0320955811','0320955843','styap@jlj.com.my','','',169,'ckl','2019-07-18',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-07-18 10:39:17','chiangkl','2019-11-27 08:14:09'),(80168,'2019/07/004',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','',169,'ckl','2019-07-18',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-07-18 10:40:47','chiangkl','2019-09-04 05:42:46'),(80169,'2019/07/005',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'ckl','2019-07-19',15,1290.00,0.00,1290.00,'Normal','chiangkl','2019-07-19 01:08:05','chiangkl','2019-09-04 05:43:04'),(80170,'2019/06/003',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'CKL - Paid 13/06/2019','2019-06-12',15,900.00,0.00,900.00,'Normal','chiangkl','2019-07-19 01:15:54','chiangkl','2019-11-27 08:15:23'),(80171,'2019/05/003',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2019-05-19',15,500.00,0.00,500.00,'Normal','chiangkl','2019-07-19 01:17:27','chiangkl','2019-11-27 07:57:27'),(80172,'2019/06/004',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2019-06-19',15,500.00,0.00,500.00,'Normal','chiangkl','2019-07-19 01:18:16','chiangkl','2019-11-27 07:57:03'),(80173,'2019/07/006',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'ckl','2019-07-18',15,500.00,0.00,500.00,'Normal','chiangkl','2019-07-19 01:19:02','chiangkl','2019-09-04 05:43:12'),(80174,'2019/07/007',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'ckl','2019-07-19',15,1500.00,0.00,1500.00,'Normal','chiangkl','2019-07-19 01:22:18','chiangkl','2019-09-04 05:43:24'),(80175,'2019/08/001',118,'Casitan Sdn Bhd','65-1 Petaling Utama Avenue,\r\nJalan PJS 1/50, 7th Mile off Jalan Klang Lama,\r\n46150 Petaling Jaya, Selangor','0377851245','0377851251','casitancarbon@gmail.com','','',169,'ckl','2019-08-01',15,215.00,0.00,215.00,'Normal','chiangkl','2019-08-01 09:51:47','chiangkl','2019-09-04 05:43:34'),(80176,'2019/08/002',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'ckl','2019-08-05',15,1500.00,0.00,1500.00,'Normal','chiangkl','2019-08-05 09:29:05','chiangkl','2019-09-04 05:43:43'),(80177,'2019/08/003',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'ckl-60%','2019-08-09',15,500.00,0.00,500.00,'Normal','chiangkl','2019-08-09 02:57:09','chiangkl','2019-11-27 08:13:11'),(80178,'2019/09/001',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL-50% Paid','2019-09-17',15,17500.00,0.00,17500.00,'Normal','chiangkl','2019-09-17 07:33:21','chiangkl','2019-11-27 08:12:09'),(80179,'2019/09/002',23,'Syarikat Kenderaan Satria Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL- Paid','2019-09-20',15,857.00,0.00,857.00,'Normal','chiangkl','2019-09-19 08:02:54','chiangkl','2019-09-27 15:52:05'),(80180,'2019/09/003',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL - Paid','2019-09-20',15,2573.00,0.00,2573.00,'Normal','chiangkl','2019-09-19 08:04:03','chiangkl','2019-09-27 15:52:28'),(80181,'2019/09/004',24,'The Pahang South Union Omnibus Company Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL - Paid 22/11/2019','2019-09-20',15,2571.00,0.00,2571.00,'Normal','chiangkl','2019-09-19 08:05:38','chiangkl','2019-11-27 08:11:43'),(80182,'2019/09/005',25,'Temerloh - Kuala Lumpur Express Omnibus Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL - Paid 22/11/2019','2019-09-20',15,3428.00,0.00,3428.00,'Normal','chiangkl','2019-09-19 08:06:39','chiangkl','2019-11-27 08:11:35'),(80183,'2019/09/006',22,'Syarikat Central Pahang Omnibus Sdn. Bhd.','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'CKL - Paid','2019-09-20',15,2571.00,0.00,2571.00,'Normal','chiangkl','2019-09-19 08:07:51','chiangkl','2019-09-27 15:48:51'),(80184,'2019/10/001',119,'Livingears Malaysia Sdn Bhd','B2-20-21 & B2-20-22, 2Floor,\r\nLorong Batu Nilam 3F,\r\nBandar Bukit Tinggi\r\n41200 Klang','0333187667','','sales@livinggears.com','','',169,'CKL-RM2170','2019-10-03',15,3670.00,0.00,3670.00,'Normal','chiangkl','2019-10-03 03:20:24','chiangkl','2019-11-27 08:11:08'),(80185,'2019/11/001',125,'SQL ERP Business  Solution PLT','1, Jalan Sri Puchong 2b,\r\n47100 Puchong, Selangor','','','','','',169,'CKL','2019-11-11',15,1500.00,0.00,1500.00,'Normal','chiangkl','2019-11-14 00:31:24','chiangkl','2019-11-27 08:10:08'),(80186,'2019/11/002',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','',169,'CKL-50%','2019-11-14',15,10800.00,0.00,10800.00,'Normal','chiangkl','2019-11-14 09:49:56','chiangkl','2019-11-27 08:09:34'),(80187,'2019/01/012',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY-100%','2019-01-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:39:25','chiangkl','2019-11-27 07:39:55'),(80188,'2019/02/004',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2019-02-28',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:41:14','chiangkl','2019-11-27 07:41:31'),(80189,'2019/03/004',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2019-03-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:42:15','chiangkl','2019-11-27 07:42:32'),(80190,'2019/04/012',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2019-04-30',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:43:19','chiangkl','2019-11-27 07:43:42'),(80191,'2019/05/004',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2019-05-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:44:31','chiangkl','2019-11-27 07:44:56'),(80192,'2019/06/005',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2019-06-30',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:45:25','chiangkl','2019-11-27 07:45:42'),(80193,'2019/07/008',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2019-07-01',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:46:13','chiangkl','2019-11-27 07:46:31'),(80194,'2019/08/004',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2019-08-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:47:12','chiangkl','2019-11-27 07:47:30'),(80195,'2019/09/007',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2019-09-30',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:47:54','chiangkl','2019-11-27 07:48:46'),(80196,'2019/10/002',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2019-10-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:49:12','chiangkl','2019-11-27 07:49:32'),(80197,'2019/11/003',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2019-11-30',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:49:57','chiangkl','2019-11-27 07:50:12'),(80198,'2019/12/001',19,'Tapes & Insulated Products Sdn. Bhd.','604, Jalan 17/12,\r\n46400 Petaling Jaya,\r\nSelangor.','0379560544','0379570616','tipmy@tiptape.com.my','','',169,'CYY','2019-12-31',15,1800.00,0.00,1800.00,'Normal','chiangkl','2019-11-27 07:51:13','chiangkl','2019-11-27 07:51:35'),(80199,'2019/08/005',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2019-08-31',15,500.00,0.00,500.00,'Normal','chiangkl','2019-11-27 07:52:41','chiangkl','2019-11-27 07:53:10'),(80200,'2019/09/008',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2019-09-30',15,500.00,0.00,500.00,'Normal','chiangkl','2019-11-27 07:53:33','chiangkl','2019-11-27 07:53:54'),(80201,'2019/10/003',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2019-10-31',15,500.00,0.00,500.00,'Normal','chiangkl','2019-11-27 07:54:15','chiangkl','2019-11-27 07:54:48'),(80202,'2019/11/004',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2019-11-30',15,500.00,0.00,500.00,'Normal','chiangkl','2019-11-27 07:55:29','chiangkl','2019-11-27 07:55:47'),(80203,'2019/12/002',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'CKL','2019-12-31',15,500.00,0.00,500.00,'Normal','chiangkl','2019-11-27 07:56:11','chiangkl','2019-11-27 07:56:33'),(80204,'2019/11/005',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'CKL','2019-11-27',15,900.00,0.00,900.00,'Normal','chiangkl','2019-11-27 08:02:34','chiangkl','2019-11-27 08:03:13'),(80205,'2019/11/006',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'CKL','2019-11-27',15,1500.00,0.00,1500.00,'Normal','chiangkl','2019-11-27 08:04:17','chiangkl','2019-11-27 08:05:06'),(80206,'2019/11/007',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'CKL','2019-11-27',15,1290.00,0.00,1290.00,'Normal','chiangkl','2019-11-27 08:06:34','chiangkl','2019-11-27 08:08:39'),(80207,'2019/11/008',125,'SQL ERP Business  Solution PLT','1, Jalan Sri Puchong 2b,\r\n47100 Puchong, Selangor','','','','','',169,'CKL-60%','2019-11-30',15,9100.00,0.00,9100.00,'Normal','chiangkl','2019-11-27 08:45:16','chiangkl','2019-11-27 08:45:49'),(80208,'2019/12/003',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'','2019-12-01',15,70.00,0.00,70.00,'Normal','chiangkl','2019-12-26 07:41:38','chiangkl','2019-12-26 07:42:07'),(80209,'2020/02/001',126,'Genusis Consultancy Sdn Bhd','','0122811933','','Gary.leong@genusis.com','','',169,'','2020-02-05',15,320.00,0.00,320.00,'Normal','chiangkl','2020-02-05 04:38:22','chiangkl','2020-02-05 04:39:46'),(80210,'2020/02/002',121,'Jordan Lee & Jaafar Sdn. Bhd.  (PJ)','A-2-3, Block A,\r\nPusat Perniagaan Seksyen 8, \r\nJalan Sungai Jernih 8/1,  \r\n46050 Petaling Jaya, Selangor','03-7956 5811','03-7955 5843','sherman@jlj.com.my','','',169,'','2020-02-05',15,1800.00,0.00,1800.00,'Normal','chiangkl','2020-02-05 04:49:47','chiangkl','2020-02-05 04:50:58'),(80211,'2020/02/003',27,'Jordan Lee & Jaafar Sdn. Bhd.','Suite 1.1, Level 1,\r\nBlock C, Plaza Damansara,\r\nNo. 45, Jalan Medan Setia 1,\r\nBukit Damansara,\r\n50490 Kuala Lumpur','0320955811','0320955843','hq@jlj.com.my','','',169,'','2020-02-05',15,3670.00,0.00,3670.00,'Normal','chiangkl','2020-02-05 04:54:04','chiangkl','2020-02-05 04:55:23'),(80212,'2020/02/004',21,'Syarikat Kau Lee','63B-2 Jalan Sultan,\r\n50000 Kuala Lumpur.','0320780188','','skl_88@yahoo.com','','',169,'','2020-02-05',15,3000.00,0.00,3000.00,'Normal','chiangkl','2020-02-05 04:59:00','chiangkl','2020-02-05 04:59:38'),(80213,'2020/02/005',129,'Syarikat Central Pahang Omnifi Holdings Sdn Bhd','Segambut','0362501035','','jessie.chua@firstcoach.com.my','','',169,'','2020-02-09',15,5800.00,0.00,5800.00,'Normal','chiangkl','2020-02-09 01:30:58','chiangkl','2020-02-10 10:27:31'),(80214,'2020/01/001',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'','2020-01-31',15,500.00,0.00,500.00,'Normal','chiangkl','2020-02-09 01:42:46','chiangkl','2020-02-09 01:43:06'),(80215,'2020/02/006',14,'Eco Active Resources','B3-2-24, Jalan Pinggiran Putra 1/3,\r\nTaman Pinggiran Putra, Seksyen 1,\r\n43300 Seri Kembangan,\r\nSelangor','0395439339','','sjyeong76@hotmail.com','','',169,'','2020-02-09',15,500.00,0.00,500.00,'Normal','chiangkl','2020-02-09 01:43:37','chiangkl','2020-02-09 01:43:58'),(80216,'2020/02/007',12,'Dellmax Trading and Service','43300 Seri Kembangan\r\nSelangor','0122125737','','mwater.james@gmail.com','','',169,'','2020-02-09',15,900.00,0.00,900.00,'Normal','chiangkl','2020-02-09 01:46:31','chiangkl','2020-02-09 01:47:03'),(80217,'2020/02/008',26,'Polypure Filtration (M) Sdn. Bhd.','6, Level 1, Jalan Damai Perdana 1/8B,\r\nBandar Damai Perdana,\r\n56000 Kuala Lumpur','0391026032','','kentlee1984@gmail.com','','',169,'','2020-02-09',15,1500.00,0.00,1500.00,'Normal','chiangkl','2020-02-09 01:51:28','chiangkl','2020-02-09 01:54:11'),(80218,'2020/02/009',13,'Herdiva Sdn. Bhd.','21, Jalan Samarinda 21,\r\nTaman Emas, Batu 3 1/2, Kampung Jawa, \r\n41000 Klang, Selangor','0102223839','','salesherdiva@gmail.com','','',169,'','2020-02-09',15,1290.00,0.00,1290.00,'Normal','chiangkl','2020-02-09 01:55:53','chiangkl','2020-02-09 01:57:10'),(80219,'2020/02/010',30,'Masitu Marketing (M) Sdn Bhd',' Lot 882, Jalan Subang 9,\r\nTaman Perindustrian Subang, \r\n47600 Subang Jaya, \r\nSelangor\r\n','0380234327','','sales@masitu.com','','',169,'','2020-02-17',15,150.00,0.00,150.00,'Normal','chiangkl','2020-02-17 03:58:34','chiangkl','2020-02-17 03:59:41'),(80220,'2020/03/001',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'','2020-03-05',15,2340.00,0.00,2340.00,'Normal','chiangkl','2020-03-05 03:43:02','chiangkl','2020-03-05 03:44:14'),(80221,'2020/03/002',15,'Bulan Restu Sdn Bhd','282, Jalan Segambut,\r\n51200 Kuala Lumpur','0362501035','','jessie.chua@firstcoach.com.my','','',169,'','2020-03-05',15,900.00,0.00,900.00,'Normal','chiangkl','2020-03-05 03:44:50','chiangkl','2020-03-05 03:45:36'),(80222,'2020/03/003',127,'Asia Pacific Truck & Bus Sdn Bhd','Segambut\r\nKUala Lumpur','','','','','',169,'','2020-03-05',15,400.00,0.00,400.00,'Normal','chiangkl','2020-03-05 03:45:57','chiangkl','2020-03-05 03:47:09'),(80223,'2020/03/004',30,'Masitu Marketing (M) Sdn Bhd',' Lot 882, Jalan Subang 9,\r\nTaman Perindustrian Subang, \r\n47600 Subang Jaya, \r\nSelangor\r\n','0380234327','','sales@masitu.com','','',169,'','2020-03-05',15,580.00,0.00,580.00,'Normal','chiangkl','2020-03-05 03:47:33','chiangkl','2020-03-05 03:48:34'),(80224,'2020/03/005',124,'Boon Hua Motor Sdn Bhd','1, Jalan Sri Puchong 2b,\r\n47100 Puchong,\r\nSelangor','','','','','',169,'','2020-03-09',15,600.00,0.00,600.00,'Normal','chiangkl','2020-03-09 06:37:42','chiangkl','2020-03-09 06:38:52'),(80225,'2020/03/006',125,'SQL ERP Business  Solution PLT','1, Jalan Sri Puchong 2b,\r\n47100 Puchong, Selangor','','','','','',169,'','2020-03-09',15,2100.00,0.00,2100.00,'Normal','chiangkl','2020-03-09 09:44:12','chiangkl','2020-03-09 09:45:06');

--
-- Table structure for table `serialnos`
--

CREATE TABLE `serialnos` (
  `serialno_module` varchar(20) NOT NULL,
  `serialno_year` int(11) NOT NULL,
  `serialno_month` int(11) NOT NULL,
  `serialno_prefix` varchar(2) DEFAULT NULL,
  `serialno_nextno` int(11) DEFAULT NULL,
  PRIMARY KEY (`serialno_module`,`serialno_year`,`serialno_month`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `serialnos`
--

INSERT INTO `serialnos` VALUES ('INVOICE',2017,2,'',3),('INVOICE',2017,3,'',5),('INVOICE',2017,4,'',7),('INVOICE',2017,5,'',5),('INVOICE',2017,6,'',3),('INVOICE',2017,7,'',8),('INVOICE',2017,8,'',7),('INVOICE',2017,9,'',5),('INVOICE',2017,10,'',12),('INVOICE',2017,11,'',4),('INVOICE',2017,12,'',9),('INVOICE',2018,1,'',6),('INVOICE',2018,2,'',6),('INVOICE',2018,3,'',7),('INVOICE',2018,4,'',3),('INVOICE',2018,5,'',9),('INVOICE',2018,6,'',6),('INVOICE',2018,7,'',6),('INVOICE',2018,8,'',11),('INVOICE',2018,9,'',4),('INVOICE',2018,10,'',16),('INVOICE',2018,11,'',7),('INVOICE',2018,12,'',6),('INVOICE',2019,1,'',13),('INVOICE',2019,2,'',5),('INVOICE',2019,3,'',5),('INVOICE',2019,4,'',13),('INVOICE',2019,5,'',5),('INVOICE',2019,6,'',6),('INVOICE',2019,7,'',9),('INVOICE',2019,8,'',6),('INVOICE',2019,9,'',9),('INVOICE',2019,10,'',4),('INVOICE',2019,11,'',9),('INVOICE',2019,12,'',4),('INVOICE',2020,1,'',2),('INVOICE',2020,2,'',11),('INVOICE',2020,3,'',7);

--
-- Table structure for table `usermenus`
--

CREATE TABLE `usermenus` (
  `usermenu_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `usermenu_userid` int(11) DEFAULT NULL,
  `usermenu_menuid` bigint(20) DEFAULT NULL,
  `usermenu_createdby` varchar(50) DEFAULT NULL,
  `usermenu_createddatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`usermenu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=228 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usermenus`
--

INSERT INTO `usermenus` VALUES (210,29,203,'kaitong','2017-03-30 16:38:06'),(211,29,206,'kaitong','2017-03-30 16:38:06'),(212,29,207,'kaitong','2017-03-30 16:38:06'),(213,29,208,'kaitong','2017-03-30 16:38:06'),(214,29,210,'kaitong','2017-03-30 16:38:06'),(215,29,211,'kaitong','2017-03-30 16:38:06'),(216,29,212,'kaitong','2017-03-30 16:38:06'),(217,29,217,'kaitong','2017-03-30 16:38:06'),(218,29,226,'kaitong','2017-03-30 16:38:06'),(219,28,203,'chiangkl','2017-03-30 16:40:33'),(220,28,206,'chiangkl','2017-03-30 16:40:33'),(221,28,207,'chiangkl','2017-03-30 16:40:33'),(222,28,208,'chiangkl','2017-03-30 16:40:33'),(223,28,210,'chiangkl','2017-03-30 16:40:33'),(224,28,211,'chiangkl','2017-03-30 16:40:33'),(225,28,212,'chiangkl','2017-03-30 16:40:33'),(226,28,217,'chiangkl','2017-03-30 16:40:33'),(227,28,226,'chiangkl','2017-03-30 16:40:34');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `user_no` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) DEFAULT NULL,
  `user_name` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `user_password` varchar(100) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `user_email` varchar(100) DEFAULT NULL,
  `user_status` varchar(10) DEFAULT NULL,
  `user_adminrole` int(1) DEFAULT '0',
  `user_teacherrole` int(1) DEFAULT '0',
  `user_studentrole` int(1) DEFAULT '0',
  `user_madrasahrole` int(1) DEFAULT '0',
  `user_failedcount` int(11) DEFAULT '0',
  `user_lastactivity` bigint(20) DEFAULT NULL,
  `user_token` varchar(255) DEFAULT NULL,
  `user_authkey` varchar(255) DEFAULT NULL,
  `user_apitoken` varchar(255) DEFAULT NULL,
  `user_createdby` varchar(20) DEFAULT NULL,
  `user_createddatetime` datetime DEFAULT NULL,
  `user_updatedby` varchar(20) DEFAULT NULL,
  `user_updateddatetime` datetime DEFAULT NULL,
  PRIMARY KEY (`user_no`),
  UNIQUE KEY `uqauthkey` (`user_authkey`),
  UNIQUE KEY `user_apitoken_UNIQUE` (`user_apitoken`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (28,'cheongyy','Cheong Yeng Yeng','$2y$13$TNIKSPKruUER1vlmlEawBODNPiHGmtlw5I77fYLCyz5kVUGMR6JJ6','yengyeng@yahoo.com','Active',1,1,1,1,0,NULL,NULL,'YbG1Mp7ksxu_2Qg4xRke0m13zxA9zmRB','mX0uiPj60aUqdVZG1_JAeFiYW36B9Xb8','admin','2015-01-01 12:00:00','chiangkl','2017-03-30 16:40:25'),(29,'chiangkl','Cheong Kok Leong','$2y$13$p96Ue3rrEYgDPoEmaQtLUO7KUKv4wJWjb/4uVe8jY4q7DY/PuAyUS','cheongkl@gmail.com','Active',1,1,1,1,0,NULL,NULL,NULL,'jUZF0_TEhjGOrkTXEZWRen8VXcr4rrWX','admin','2015-01-01 12:00:00','admin','2017-03-30 16:37:56');


