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


