('EM20110027',1,0,9,'SANDRA AGUSTIN','MUHAMMAD KHALID KADERUSSYAIKHAN','017651-2','','M','1995-08-04','S','017651','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-07-13 00:00:00','fauzan import','2020-07-13 00:00:00','2020-07-13',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020905LS','GSC EAJP P2 Batam - PEM SC & Log.','DVC NPV','2018-12-12','2020-12-11','PEM','SESA527242',0,'10641958'),('EM20110028',1,0,9,'DESI AGUSTA','MAIGUSTIRIZON','014647-2','','M','1993-05-11','S','014647','2020-01-01','2020-12-31','M',0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-07-13 00:00:00','fauzan import','2020-07-13 00:00:00','2020-07-13',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020010','Unit Mfg PEM','DVC PV','2016-08-12','1900-01-01','PEM','SESA436871',1,'10527280'),('EM20110029',1,0,9,'MUHAMAD ILHAM','SHELLY PARAPATI ABDUL','018734-2','','F','1999-09-22','S','018734','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-07-13 00:00:00','fauzan import','2020-07-13 00:00:00','2020-07-13',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020905LS','GSC EAJP P2 Batam - PEM SC & Log.','DVC NPV','2019-12-18','2021-12-18','PEM','SESA566271',0,'10685399'),('EM20110030',1,0,9,'ABDUL RAHMAN','QIORA SABIYA RAHMAN','011973-4','','F','2020-09-19','C','011973','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-07-13 00:00:00','fauzan import','2020-07-13 00:00:00','2020-07-13',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020953LS','Quality PEL','DVC NPV','2014-04-16','1900-01-01','DRIVE','SESA274722',1,'00258113'),('EM20110031',1,0,9,'INDAH AYU LESTARI','YOGI JULIO TRINANTA SINAGA','015287-2','','M','1994-07-07','S','015287','2020-01-01','2020-12-31','M',0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-07-13 00:00:00','fauzan import','2020-07-13 00:00:00','2020-07-13',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020010','Unit Mfg PEM','DVC PV','2017-01-26','1900-01-01','PEM','SESA453365',1,'10556864'),('EM20110032',1,0,9,'MUHAMMAD KHALID KADERUSSYAIKHAN','SANDRA AGUSTIN','018714-2','','F','1995-08-15','S','018714','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-07-13 00:00:00','fauzan import','2020-07-13 00:00:00','2020-07-13',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020952LS','GSC EAJP P2 Batam - PEL SC & Log.','DVC NPV','2019-12-18','2021-12-17','PEL','SESA566277',0,'10685408'),('EM20110033',1,0,9,'RAMLAN SIHOLE','BERNAWATI SAGALA','021225-2','','F','1992-02-28','S','021225','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-07-13 00:00:00','fauzan import','2020-07-13 00:00:00','2020-07-13',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020090LS','Batam Logistic Platform','DVC NPV','2020-02-26','2022-02-25','LOGISTIC','SESA571956',0,'10692533'),('EM20110034',1,0,9,'YAYAH ISTIATI','RAYYANKA FITRIADI PUTERA','005518-5','','M','2020-07-07','C','005518','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-07-13 00:00:00','fauzan import','2020-07-13 00:00:00','2020-07-13',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020429LS','Batam SQE','DVC NPV','2008-05-30','1900-01-01','LOGISTIC','SESA203551',1,'00216077'),('EM20110035',1,0,9,'WIJI LESTARI','BAGAS PAMUNGKAS','013762-2','','M','1994-09-20','S','013762','2020-01-01','2020-12-31','M',0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-07-13 00:00:00','fauzan import','2020-07-13 00:00:00','2020-07-13',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020057','Unit Mfg VSD','DVC PV','2015-12-29','1900-01-01','DRIVE','SESA428782',1,'10509251'),('EM20120001',1,0,10,'RITA JULIANA KRISTIKA','RITA JULIANA KRISTIKA','021342-1','','F','1998-07-12','E','021342','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,1032569.75,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020020','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-10-13','2021-01-12','DRIVE','SESA598158',0,'10723289'),('EM20120002',1,0,10,'DIFA UZDRI SYAHPUTRI','DIFA UZDRI SYAHPUTRI','021343-1','','F','2002-05-22','E','021343','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,1032569.75,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020059','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-10-13','2021-01-12','DRIVE','SESA598686',0,'10723778'),('EM20120003',1,0,10,'ADBREANSYAH EKO WIJAYA','ADBREANSYAH EKO WIJAYA','021344-1','','M','2002-04-29','E','021344','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,1032569.75,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020057','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-10-15','2021-01-14','DRIVE','SESA598488',0,'10723610'),('EM20120004',1,0,10,'AUDREY ADELEA PUTRI THENU','AUDREY ADELEA PUTRI THENU','021345-1','','F','2002-09-29','E','021345','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,1032569.75,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020057','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-10-15','2021-01-14','DRIVE','SESA598483',0,'10723602'),('EM20120005',1,0,10,'EDY ARNOLD GILBERT SITOHANG','EDY ARNOLD GILBERT SITOHANG','021346-1','','M','2001-05-10','E','021346','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,1032569.75,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020057','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-10-15','2021-01-14','DRIVE','SESA598484',0,'10723604'),('EM20120006',1,0,10,'SWANDI HASIBUAN','SWANDI HASIBUAN','021347-1','','M','2001-11-17','E','021347','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,942569.75,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020057','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-10-15','2021-01-14','DRIVE','SESA598489',0,'10723612'),('EM20120007',1,0,10,'INDRA GUNAWAN','INDRA GUNAWAN','021348-1','','M','1999-09-27','E','021348','2020-01-01','2020-12-31','M',0.00,4230111.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,705018.50,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020953LS','GSC INT EAJ IND Batam PEL CS&Q','DVC NPV ','2020-10-22','2021-04-21','PEL','SESA599347',0,'10724133'),('EM20120008',1,0,10,'ADISTY DIANE ROLIS','ADISTY DIANE ROLIS','021349-1','','F','2001-10-04','E','021349','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020020','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-02','2021-02-01','DRIVE','SESA600192',0,'10725482'),('EM20120009',1,0,10,'DEBORA SUMTARI','DEBORA SUMTARI','021350-1','','F','2002-10-10','E','021350','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020057','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-02','2021-02-01','DRIVE','SESA600147',0,'10725475'),('EM20120010',1,0,10,'DESI HARIANJA','DESI HARIANJA','021351-1','','F','1997-12-27','E','021351','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020020','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-02','2021-02-01','DRIVE','SESA600123',0,'10725460'),('EM20120011',1,0,10,'DINDA REZKI WULAN SARI','DINDA REZKI WULAN SARI','021352-1','','F','1997-08-11','E','021352','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020057','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-02','2021-02-01','DRIVE','SESA600133',0,'10725471'),('EM20120012',1,0,10,'ELISMAWATY SIAHAAN','ELISMAWATY SIAHAAN','021353-1','','F','2000-08-06','E','021353','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020059','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-02','2021-02-01','DRIVE','SESA600153',0,'10725477'),('EM20120013',1,0,10,'EVA UYUNG HANA PERTIWI','EVA UYUNG HANA PERTIWI','021354-1','','F','2001-07-14','E','021354','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020057','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-02','2021-02-01','DRIVE','SESA600131',0,'10725469'),('EM20120014',1,0,10,'FARADHITA MEGA DWIMUSTIKA','FARADHITA MEGA DWIMUSTIKA','021355-1','','F','2002-06-07','E','021355','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020058','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-02','2021-02-01','DRIVE','SESA600127',0,'10725467'),('EM20120015',1,0,10,'HERLINAWATI GEA','HERLINAWATI GEA','021356-1','','F','1998-11-14','E','021356','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020057','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-02','2021-02-01','DRIVE','SESA600142',0,'10725473'),('EM20120016',1,0,10,'JUNIATI LUMBAN GAOL','JUNIATI LUMBAN GAOL','021357-1','','F','2002-06-06','E','021357','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020020','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-02','2021-02-01','DRIVE','SESA600196',0,'10725484'),('EM20120017',1,0,10,'GILANG RAMADHAN','GILANG RAMADHAN','021358-1','','M','1999-12-08','E','021358','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020057','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-04','2021-02-03','DRIVE','SESA600694',0,'10725883'),('EM20120018',1,0,10,'JUANDI NAINGGOLAN','JUANDI NAINGGOLAN','021359-1','','M','1999-11-29','E','021359','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020023','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-04','2021-02-03','PEL','SESA600526',0,'10725728'),('EM20120019',1,0,10,'KRISDA MELINDA SAMOSIR','KRISDA MELINDA SAMOSIR','021360-1','','F','1998-12-16','E','021360','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020027','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-04','2021-02-03','PEL','SESA600510',0,'10725712'),('EM20120020',1,0,10,'NAFA SADILA','NAFA SADILA','021361-1','','F','2000-11-01','E','021361','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020018','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-04','2021-02-03','PEL','SESA600523',0,'10725725'),('EM20120021',1,0,10,'RONY SAPUTRA YEREMIA WOLO','RONY SAPUTRA YEREMIA WOLO','021362-1','','M','2001-06-12','E','021362','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020023','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-04','2021-02-03','PEL','SESA600521',0,'10725723'),('EM20120022',1,0,10,'ZENI SILVIA','ZENI SILVIA','021363-1','','F','2001-08-28','E','021363','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020023','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-04','2021-02-03','PEL','SESA600519',0,'10725720'),('EM20120023',1,0,10,'ZILHI ZIYATI BR GINTING','ZILHI ZIYATI BR GINTING','021364-1','','F','2002-03-05','E','021364','2020-01-01','2020-12-31','M',0.00,4130279.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,688379.83,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020020','GSC INT EAJ IND Batam PEL AUT Mfg Unit','DVC PV','2020-11-04','2021-02-03','DRIVE','SESA600512',0,'10725716'),('EM20120024',1,0,10,'NAUFAL IHZA REVANDHIKA','NAUFAL IHZA REVANDHIKA','021365-1','','M','1998-07-26','E','021365','2020-01-01','2020-12-31','M',0.00,7200000.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,1200000.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'2','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020505','GSC INT EAJ LOG Central Network Engineering','EAJP','2020-11-11','2022-11-10','SHARE SERVICE','SESA543248',0,'10723557'),('EM20120025',1,0,10,'DIVYAH LAKSMI','DIVYAH LAKSMI','021366-1','','F','1999-06-18','E','021366','2020-01-01','2020-12-31','M',0.00,7200000.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,1200000.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'2','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020053','GSC INT EAJ IND Batam PEL Methods','STAFF','2020-11-11','2022-11-10','PEL','SESA543245',0,'10723559'),('EM20120026',1,0,10,'AURELL QUINTA MIRANDA','AURELL QUINTA MIRANDA','021367-1','','F','1999-01-04','E','021367','2020-01-01','2020-12-31','M',0.00,7200000.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,1200000.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'2','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020131','GSC INT EAJ IND Batam Sensors Method','STAFF','2020-11-11','2022-11-10','SENSOR','SESA600815',0,'10725977'),('EM20120027',1,0,10,'EKO WAHYUDI','EKO WAHYUDI','021368-1','','M','1985-04-17','E','021368','2020-01-01','2020-12-31','M',0.00,45000000.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,7500000.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'VIP','VIP','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020001','Plant Director PEM & SENSOR','MGR','2020-11-01','1900-01-01','PEM','SESA108962',1,'00130305'),('EM20120028',1,0,10,'QATRUN NADA','AHMAD HABIBI NADA','008032-5','','M','2020-10-22','C','008032','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'1','VIP','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020106','Cust. Satisfaction & Quality ','STAFF','2011-06-15','1900-01-01','SENSOR','SESA199020',1,'00214223'),('EM20120029',1,0,10,'MHD.ANDIKA BUTAR BUTAR','BINA NUR AMALIYAH','018040-2','','F','1996-03-26','S','018040','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020041LS','GSC EAJP P2 Batam - PEM SC & Log.','DVC NPV','2019-03-19','2021-03-18','PEM','SESA536107',0,'10656879'),('EM20120030',1,0,10,'MUHAMMAD ALIEF ALDINO','INDRI WAHYUNI','014756-2','','F','1993-06-03','S','014756','2020-01-01','2020-12-31','M',0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020010','Unit Mfg PEM','DVC PV','2016-09-13','1900-01-01','PEM','SESA440001',1,'10530339'),('EM20120031',1,0,10,'LINA MAWADDAH','AJI PALINGGA','014174-2','','M','1994-06-11','S','014174','2020-01-01','2020-12-31','M',0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020014','Unit Mfg PEM','DVC PV','2016-03-14','1900-01-01','PEM','SESA420852',1,'10514348'),('EM20120032',1,0,10,'IKHSAN SAFRI','SYAHLA HUMAIRAH SYAFRI','018367-3','','F','2020-10-11','C','018367','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020908LS','Maintenance Engineering ','DVC NPV','2019-11-25','2021-05-24','PEM','SESA563356',0,'10682491'),('EM20120033',1,0,10,'MORIKA LUMBANTOBING','GOVINDO PURBA','013525-2','','M','1996-06-19','S','013525','2020-01-01','2020-12-31','M',0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020010','Unit Mfg PEM','DVC PV','2015-08-24','1900-01-01','PEM','SESA398377',1,'00341657'),('EM20120034',1,0,10,'CALVIN SANPRATAMA DEWANGGA','TIKA RAHMAWATI','017525-2','','M','1991-11-22','S','017525','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'2','1','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020510','INDQSINCS - IND IQ&SC Indus-AOCS','EAJP','2018-07-11','1900-01-01','SHARE SERVICE','SESA507889',1,'10620804'),('EM20120035',1,0,10,'JUPRIZAL','YUNI MARLINA','017552-2','','F','1995-01-12','S','017552','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020041LS','GSC EAJP P2 Batam - PEM SC & Log.','DVC NPV','2018-08-14','2021-08-13','PEM','SESA516686',0,'10629333'),('EM20120036',1,0,10,'MEILA LENI NURLAENI','MOCH. SOFYAN SEPTIADI','014587-2','','M','1995-09-29','S','014587','2020-01-01','2020-12-31','M',0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020027','Unit Mfg PEL','DVC PV','2016-06-20','1900-01-01','PEL','SESA432153',1,'10521879'),('EM20120037',1,0,10,'MARIA SINAMBELA','PETRUS ROBERT SANTOSO SILABAN','013150-2','','M','1995-06-11','S','013150','2020-01-01','2020-12-31','M',0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,300000.00,0.00,0.00,0.00,0.00,0.00,300000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','3','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020020','Unit Mfg VSD','DVC PV','2015-04-06','1900-01-01','DRIVE','SESA377053',1,'00327397'),('EM20120038',1,0,10,'ALDI PHIRAWANDI','ABIZARD BAIHAQI PHIRAWANDI','017418-3','','M','2020-10-21','C','017418','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020042LS','GSC EAJP P2 Batam - PEL SC & Log.','DVC NPV','2018-04-27','2021-04-26','PEL','SESA504340',0,'10617172'),('EM20120039',1,0,10,'HASNA ZAHRA','CHRISTOFER PANDAPOTAN PURBA','021239-2','','M','1995-08-29','S','021239','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'2','1','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020239','Batam Logistic Platform','STAFF','2020-03-02','2021-03-01','LOGISTIC','SESA571030',0,'10691657'),('EM20120040',1,0,10,'ASTI BUDIANTO','GIANDRA NABIL NOVRIANTO','016036-3','','M','2020-11-03','C','016036','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'2','1','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020054','Test & Maintenance ','STAFF','2017-08-29','1900-01-01','PEL','SESA472231',1,'10580631'),('EM20120041',1,0,10,'ANDRI DARMA SAPUTRA','GITA MAYESTI','015047-2','','F','1993-08-28','S','015047','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'2','1','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020437','Parts Industrialization','STAFF','2016-12-29','1900-01-01','SHARE SERVICE','SESA449006',1,'10549427'),('EM20120042',1,0,10,'TRI AYUNI','FARHAN','017599-2','','M','1996-06-12','S','017599','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'2','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020138','Technical Antena','STAFF','2018-09-03','1900-01-01','SENSOR','SESA516836',1,'10629516'),('EM20120043',1,0,10,'FITRI DEVI PONCOWATI','RAFFASYA ADZKAA ALFAREZY','005117-3','','M','2020-11-04','C','005117','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020916LS','Quality Sensor','DVC NPV','2007-10-17','1900-01-01','SENSOR','SESA203696',1,'00216220'),('EM20120044',1,0,10,'ANDI SAPUTRA','MESHANUM RAMADHANI','015632-4','','F','2020-05-08','C','015632','2020-01-01','2020-12-31','M',0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,0.00,0.00,0.00,2000000.00,0.00,0.00,0.00,0.00,0.00,4000000.00,'','fauzan import','2020-12-21 00:00:00','fauzan import','2020-12-21 00:00:00','2020-12-21',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'3','2','','','','','',0.00,0,0.00,0.00,0.00,0.00,'2020918LS','Maintenance Sensor','DVC NPV','2017-03-07','1900-01-01','SENSOR','SESA457457',1,'10561252'),('Falah',1,0,0,'Falah','Falah','0217055',' ','M','1982-01-01','A','0217055','2020-01-01','2020-12-31','M',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,' ','fauzan admin','2019-12-19 00:00:00','fauzan admin','2019-12-19 00:00:00','2019-12-19',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'Sedana','Sedana',' ',' ',' ',' ',' ',0.00,0,0.00,0.00,0.00,0.00,'Sedana','Sedana','Sedana','2020-02-02','2020-02-02','Sedana','Sedana',1,NULL),('FAUZAN',1,0,0,'Achmad Fauzan','Achmad Fauzan','0217055',' ','M','1982-01-01','A','0217055','2020-01-01','2020-12-31','M',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,' ','fauzan admin','2019-12-19 00:00:00','fauzan admin','2019-12-19 00:00:00','2019-12-19',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'Sedana','Sedana',' ',' ',' ',' ',' ',0.00,0,0.00,0.00,0.00,0.00,'Sedana','Sedana','Sedana','2020-02-02','2020-02-02','Sedana','Sedana',1,NULL),('FITRI',1,0,0,'Fitri','Fitri','0217055',' ','M','1982-01-01','A','0217055','2020-01-01','2020-12-31','M',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,' ','fauzan admin','2019-12-19 00:00:00','fauzan admin','2019-12-19 00:00:00','2019-12-19',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'Sedana','Sedana',' ',' ',' ',' ',' ',0.00,0,0.00,0.00,0.00,0.00,'Sedana','Sedana','Sedana','2020-02-02','2020-02-02','Sedana','Sedana',1,NULL),('TRY',1,0,0,'Try','Try','0217055',' ','M','1982-01-01','A','0217055','2020-01-01','2020-12-31','M',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,' ','fauzan admin','2019-12-19 00:00:00','fauzan admin','2019-12-19 00:00:00','2019-12-19',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'Sedana','Sedana',' ',' ',' ',' ',' ',0.00,0,0.00,0.00,0.00,0.00,'Sedana','Sedana','Sedana','2020-02-02','2020-02-02','Sedana','Sedana',1,NULL),('Vika',1,0,0,'Vika','Vika','0217055',' ','M','1982-01-01','A','0217055','2020-01-01','2020-12-31','M',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,' ','fauzan admin','2019-12-19 00:00:00','fauzan admin','2019-12-19 00:00:00','2019-12-19',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'Sedana','Sedana',' ',' ',' ',' ',' ',0.00,0,0.00,0.00,0.00,0.00,'Sedana','Sedana','Sedana','2020-02-02','2020-02-02','Sedana','Sedana',1,NULL);

--
-- Table structure for table `tp_policy`
--

CREATE TABLE `tp_policy` (
  `policy_id` int(11) NOT NULL,
  `polis_number` varchar(100) NOT NULL,
  `company_id` varchar(21) DEFAULT NULL,
  `policy_inception_date` date NOT NULL,
  `policy_due_date` date NOT NULL,
  `policy_created_by` varchar(50) DEFAULT NULL,
  `policy_created date` date DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`policy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tp_policy`
--

INSERT INTO `tp_policy` VALUES (1,'01402202000024','COM003','2021-01-01','2021-12-31','fauzan',NULL,1),(2,'01402202000025','COM001','2021-01-01','2021-12-31','fauzan',NULL,1),(3,'01402202000026','COM004','2021-01-01','2021-12-31','fauzan',NULL,1),(4,'01402202000027','COM005','2021-01-01','2021-12-31','fauzan',NULL,1),(5,'01402202000028','COM002','2021-01-01','2021-12-31','fauzan',NULL,1);

--
-- Table structure for table `tp_quotation_slip`
--

CREATE TABLE `tp_quotation_slip` (
  `quotation_slip_id` varchar(21) NOT NULL,
  `quotation_slip_date` date NOT NULL,
  `quotation_slip_number` varchar(50) DEFAULT NULL,
  `eob_id` varchar(21) DEFAULT NULL,
  `up_name` varchar(50) DEFAULT NULL,
  `quotation_slip_period` varchar(200) DEFAULT 'NULL',
  `batch_number` varchar(20) DEFAULT NULL,
  `verified_by` varchar(21) DEFAULT NULL,
  `verified_dt` datetime DEFAULT NULL,
  `verified_status` tinyint(4) DEFAULT 0,
  `verified_reason` varchar(50) DEFAULT NULL,
  `approved_by` varchar(12) DEFAULT NULL,
  `approved_dt` datetime DEFAULT NULL,
  `approval_status` tinyint(4) DEFAULT 0,
  `approval_reason` varchar(20) DEFAULT NULL,
  `status` int(11) DEFAULT 0 COMMENT '0: ready entry;1:un-posted,100:posted,5: need verification,10: need approval, 3: done',
  `dt_etr` datetime DEFAULT NULL,
  `user_etr` varchar(21) DEFAULT NULL,
  PRIMARY KEY (`quotation_slip_id`,`quotation_slip_date`),
  UNIQUE KEY `quotation_slip_id` (`quotation_slip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tp_quotation_slip`
--

INSERT INTO `tp_quotation_slip` VALUES ('QL2021020001','2021-02-01','fauzan','AC2021020001','Bapak Karno','PERIODE DESEMBER (Tahap II)','Batch 05','USR-202001002','2021-03-18 12:51:16',1,'ok','USR-20200100','2021-03-18 12:55:14',1,'test',10,'2021-02-26 05:24:38','USR-202001002'),('QL2021030001','2021-03-24','Quotation Letter Number','AC2021030001','Bapak Karno','PERIODE Maret 2021','Batch 08','USR-202001002','2021-03-19 07:53:52',1,'ok','USR-20200100','2021-03-19 07:54:08',1,'sip',10,'2021-03-19 07:53:18','USR-202001002'),('QL2021110001','2021-11-15','001','AC2021110002','Bapak Karno','PERIODE 2021','Batch 001','USR-202001002','2021-11-15 12:18:52',1,'','USR-20200100','2021-11-15 12:19:01',1,'',10,'2021-11-15 12:18:33','USR-202001002');

--
-- Table structure for table `tp_upload_file_name`
--

CREATE TABLE `tp_upload_file_name` (
  `upload_id` varchar(21) NOT NULL,
  `file_name` varchar(50) NOT NULL,
  `user_etr` varchar(21) NOT NULL,
  `dt_etr` datetime NOT NULL,
  PRIMARY KEY (`upload_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tp_upload_file_name`
--


--
-- Dumping routines for database 'db_fsa2021'
--


