-- Table structure for table `tp_deposit`
--

CREATE TABLE `tp_deposit` (
  `deposit_id` varchar(21) NOT NULL DEFAULT '',
  `remark` varchar(200) DEFAULT 'NULL',
  `amount` double(18,4) NOT NULL DEFAULT 0.0000,
  `policy_id` varchar(21) NOT NULL DEFAULT '',
  `payment_paid` date NOT NULL,
  `status` tinyint(1) NOT NULL,
  `user_etr` varchar(21) NOT NULL DEFAULT '',
  `dt_etr` date NOT NULL,
  `user_update` varchar(21) NOT NULL DEFAULT '',
  `dt_update` date NOT NULL,
  PRIMARY KEY (`deposit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tp_deposit`
--

INSERT INTO `tp_deposit` VALUES ('DP0001','Saldo Deposit Awal PT Agility',100600000.0000,'1','2021-07-30',1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('DP0002','Saldo Deposit Awal PT Agility International',627600000.0000,'2','2021-07-30',1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26');

--
-- Table structure for table `tp_eob`
--

CREATE TABLE `tp_eob` (
  `eob_id` varchar(21) NOT NULL,
  `eob_number` int(11) DEFAULT NULL,
  `eob_number_generate` varchar(50) DEFAULT NULL,
  `eob_date` date DEFAULT NULL,
  `policy_id` varchar(50) DEFAULT 'NULL',
  `amount` decimal(11,0) DEFAULT 0,
  `amount_transfer_fee` decimal(11,0) DEFAULT 0,
  `is_payment` tinyint(4) DEFAULT 0,
  `payment_date` date DEFAULT NULL,
  `benefit_type_id` varchar(21) DEFAULT NULL,
  `is_printed` tinyint(4) DEFAULT 0,
  `dt_printed` datetime DEFAULT NULL,
  `user_printed` varchar(21) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=menunggu request\r\n1=menunggu payment\r\n99=sudah payment ',
  `user_etr` varchar(21) DEFAULT NULL,
  `dt_etr` datetime DEFAULT NULL,
  `user_update` varchar(21) DEFAULT NULL,
  `dt_update` datetime DEFAULT NULL,
  PRIMARY KEY (`eob_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tp_eob`
--

INSERT INTO `tp_eob` VALUES ('AC2021070001',1,'00001/EOB/VII/2021/AGILITY','2021-07-19','1',3095000,0,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-07-19 05:59:00','USR-202001002','2021-07-19 05:59:00'),('AC2021070002',2,'00002/EOB/VII/2021/AGILITY','2021-07-19','2',11425000,0,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-07-19 05:59:10','USR-202001002','2021-07-19 05:59:10'),('AC2021080001',3,'00003/EOB/VIII/2021/AGILITY','2021-08-25','1',738000,0,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-08-25 03:43:16','USR-202001002','2021-08-25 03:43:16'),('AC2021080002',4,'00004/EOB/VIII/2021/AGILITY','2021-08-25','2',5073455,0,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-08-25 03:43:32','USR-202001002','2021-08-25 03:43:32'),('AC2021080003',5,'00005/EOB/VIII/2021/AGILITY','2021-08-31','1',2299850,0,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-08-31 05:54:00','USR-202001002','2021-08-31 05:54:00'),('AC2021080004',6,'00006/EOB/VIII/2021/AGILITY','2021-08-31','2',9156300,0,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-08-31 05:54:14','USR-202001002','2021-08-31 05:54:14'),('AC2021090001',7,'00007/EOB/IX/2021/AGILITY','2021-09-15','1',2300000,0,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-09-15 08:51:47','USR-202001002','2021-09-15 08:51:47'),('AC2021090002',8,'00008/EOB/IX/2021/AGILITY','2021-09-15','2',19592200,0,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-09-15 08:52:02','USR-202001002','2021-09-15 08:52:02'),('AC2021090003',9,'00009/EOB/IX/2021/AGILITY','2021-09-22','1',3150000,0,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-09-22 10:34:36','USR-202001002','2021-09-22 10:34:36'),('AC2021090004',10,'00010/EOB/IX/2021/AGILITY','2021-09-22','2',16748500,0,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-09-22 10:34:46','USR-202001002','2021-09-22 10:34:46'),('AC2021090005',11,'00011/EOB/IX/2021/AGILITY','2021-09-29','2',8715000,0,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-09-29 10:40:15','USR-202001002','2021-09-29 10:40:15'),('AC2021100001',12,'00012/EOB/X/2021/AGILITY','2021-10-07','2',8970000,20000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-10-07 09:25:08','USR-202001002','2021-10-07 09:25:08'),('AC2021100002',13,'00013/EOB/X/2021/AGILITY','2021-10-26','1',1100000,2000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-10-26 11:49:00','USR-202001003','2021-10-26 11:49:00'),('AC2021100003',14,'00014/EOB/X/2021/AGILITY','2021-10-26','2',7405000,24000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-10-26 11:53:44','USR-202001003','2021-10-26 11:53:44'),('AC2021100004',15,'00015/EOB/X/2021/AGILITY','2021-10-29','1',2048992,6000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-10-29 09:31:41','USR-202001003','2021-10-29 09:31:41'),('AC2021100005',16,'00016/EOB/X/2021/AGILITY','2021-10-29','2',5085000,12000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-10-29 09:33:46','USR-202001003','2021-10-29 09:33:46'),('AC2021110001',17,'00017/EOB/XI/2021/AGILITY','2021-11-01','1',1485000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-11-01 10:19:04','USR-202001003','2021-11-01 10:19:04'),('AC2021110002',18,'00018/EOB/XI/2021/AGILITY','2021-11-01','2',5546000,14000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-11-01 10:20:04','USR-202001003','2021-11-01 10:20:04'),('AC2021110003',19,'00019/EOB/XI/2021/AGILITY','2021-11-15','2',9050000,14000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-11-15 05:42:59','USR-202001003','2021-11-15 05:42:59'),('AC2021110004',20,'00020/EOB/XI/2021/AGILITY','2021-11-22','2',6244000,14000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-11-22 05:50:12','USR-202001003','2021-11-22 05:50:12'),('AC2021110005',21,'00021/EOB/XI/2021/AGILITY','2021-11-23','1',350000,2000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-11-23 08:57:20','USR-202001003','2021-11-23 08:57:20'),('AC2021110006',22,'00022/EOB/XI/2021/AGILITY','2021-11-23','2',2550000,8000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-11-23 08:57:46','USR-202001003','2021-11-23 08:57:46'),('AC2021110007',23,'00023/EOB/XI/2021/AGILITY','2021-11-30','2',3900000,16000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-11-30 05:28:04','USR-202001003','2021-11-30 05:28:04'),('AC2021120001',24,'00024/EOB/XII/2021/AGILITY','2021-12-07','1',1100000,2000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-12-07 05:57:25','USR-202001003','2021-12-07 05:57:25'),('AC2021120002',25,'00025/EOB/XII/2021/AGILITY','2021-12-07','2',4324000,8000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-12-07 05:58:24','USR-202001003','2021-12-07 05:58:24'),('AC2021120003',26,'00026/EOB/XII/2021/AGILITY','2021-12-16','1',2200000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-12-16 10:03:47','USR-202001003','2021-12-16 10:03:47'),('AC2021120004',27,'00027/EOB/XII/2021/AGILITY','2021-12-16','2',9104500,20000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-12-16 10:07:43','USR-202001003','2021-12-16 10:07:43'),('AC2021120005',28,'00028/EOB/XII/2021/AGILITY','2021-12-24','2',1115000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2021-12-24 10:09:49','USR-202001002','2021-12-24 10:09:49'),('AC2021120006',29,'00029/EOB/XII/2021/AGILITY','2021-12-30','2',4716000,14000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001003','2021-12-30 08:56:18','USR-202001003','2021-12-30 08:56:18'),('AC2022010001',30,'00030/EOB/I/2022/AGILITY','2022-01-05','2',2025000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-01-05 03:46:37','USR-202001002','2022-01-05 03:46:37'),('AC2022010002',31,'00031/EOB/I/2022/AGILITY','2022-01-07','2',8488000,18000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-01-07 04:30:53','USR-202001002','2022-01-07 04:30:53'),('AC2022010003',32,'00032/EOB/I/2022/AGILITY','2022-01-14','1',1100000,2000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-01-14 03:44:06','USR-202001002','2022-01-14 03:44:06'),('AC2022010004',33,'00033/EOB/I/2022/AGILITY','2022-01-14','2',2700000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-01-14 03:44:51','USR-202001002','2022-01-14 03:44:51'),('AC2022010005',34,'00034/EOB/I/2022/AGILITY','2022-01-24','2',6655000,12000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-01-24 07:52:53','USR-202001002','2022-01-24 07:52:53'),('AC2022010006',35,'00035/EOB/I/2022/AGILITY','2022-01-25','1',350000,2000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-01-25 08:57:22','USR-202001002','2022-01-25 08:57:22'),('AC2022010007',36,'00036/EOB/I/2022/AGILITY','2022-01-27','2',1850000,6000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-01-27 05:43:43','USR-202001002','2022-01-27 05:43:43'),('AC2022020001',37,'00037/EOB/II/2022/AGILITY','2022-02-08','2',5000000,10000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-02-08 08:38:54','USR-202001002','2022-02-08 08:38:54'),('AC2022020002',38,'00038/EOB/II/2022/AGILITY','2022-02-21','2',2300000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-02-21 04:33:45','USR-202001002','2022-02-21 04:33:45'),('AC2022020003',39,'00039/EOB/II/2022/AGILITY','2022-02-22','1',1890000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-02-22 09:38:02','USR-202001002','2022-02-22 09:38:02'),('AC2022030001',40,'00040/EOB/III/2022/AGILITY','2022-03-01','1',1165000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-03-01 05:36:20','USR-202001002','2022-03-01 05:36:20'),('AC2022030002',41,'00041/EOB/III/2022/AGILITY','2022-03-01','2',4200000,12000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-03-01 05:43:07','USR-202001002','2022-03-01 05:43:07'),('AC2022030003',42,'00042/EOB/III/2022/AGILITY','2022-03-07','2',15345000,32000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-03-07 07:52:51','USR-202001002','2022-03-07 07:52:51'),('AC2022030004',43,'00043/EOB/III/2022/AGILITY','2022-03-16','1',300000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-03-16 08:58:41','USR-202001002','2022-03-16 08:58:41'),('AC2022030005',44,'00044/EOB/III/2022/AGILITY','2022-03-17','1',2165950,6000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-03-17 05:15:59','USR-202001002','2022-03-17 05:15:59'),('AC2022030006',45,'00045/EOB/III/2022/AGILITY','2022-03-17','2',3790000,8000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-03-17 05:16:39','USR-202001002','2022-03-17 05:16:39'),('AC2022030007',46,'00046/EOB/III/2022/AGILITY','2022-03-22','2',4386000,8000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-03-22 04:36:54','USR-202001002','2022-03-22 04:36:54'),('AC2022030008',47,'00047/EOB/III/2022/AGILITY','2022-03-24','1',970000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-03-24 04:41:16','USR-202001002','2022-03-24 04:41:16'),('AC2022030009',48,'00048/EOB/III/2022/AGILITY','2022-03-24','2',4500000,6000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-03-24 04:41:41','USR-202001002','2022-03-24 04:41:41'),('AC2022030010',49,'00049/EOB/III/2022/AGILITY','2022-03-29','1',2876158,6000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-03-29 04:57:36','USR-202001002','2022-03-29 04:57:36'),('AC2022040001',50,'00050/EOB/IV/2022/AGILITY','2022-04-01','2',6982000,16000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-04-01 05:18:55','USR-202001002','2022-04-01 05:18:55'),('AC2022040002',51,'00051/EOB/IV/2022/AGILITY','2022-04-04','2',2083000,6000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-04-04 03:18:01','USR-202001002','2022-04-04 03:18:01'),('AC2022040003',52,'00052/EOB/IV/2022/AGILITY','2022-04-12','1',400000,2000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-04-12 04:25:22','USR-202001002','2022-04-12 04:25:22'),('AC2022040004',53,'00053/EOB/IV/2022/AGILITY','2022-04-12','2',8390000,20000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-04-12 04:31:00','USR-202001002','2022-04-12 04:31:00'),('AC2022040005',54,'00054/EOB/IV/2022/AGILITY','2022-04-25','2',1200000,2000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-04-25 04:36:47','USR-202001002','2022-04-25 04:36:47'),('AC2022040006',55,'00055/EOB/IV/2022/AGILITY','2022-04-25','1',2200000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-04-25 05:20:19','USR-202001002','2022-04-25 05:20:19'),('AC2022040007',56,'00056/EOB/IV/2022/AGILITY','2022-04-25','2',3650000,6000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-04-25 05:26:28','USR-202001002','2022-04-25 05:26:28'),('AC2022050001',57,'00057/EOB/V/2022/AGILITY','2022-05-17','2',6199000,16000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-05-17 08:11:34','USR-202001002','2022-05-17 08:11:34'),('AC2022050002',58,'00058/EOB/V/2022/AGILITY','2022-05-23','2',5425000,10000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-05-23 04:47:35','USR-202001002','2022-05-23 04:47:35'),('AC2022050003',59,'00059/EOB/V/2022/AGILITY','2022-05-23','2',2300000,4000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-05-23 09:04:34','USR-202001002','2022-05-23 09:04:34'),('AC2022060001',60,'00060/EOB/VI/2022/AGILITY','2022-06-02','2',5910000,12000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-06-02 06:00:53','USR-202001002','2022-06-02 06:00:53'),('AC2022060002',61,'00061/EOB/VI/2022/AGILITY','2022-06-09','2',5122500,10000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-06-09 03:34:20','USR-202001002','2022-06-09 03:34:20'),('AC2022060003',62,'00062/EOB/VI/2022/AGILITY','2022-06-15','2',7950000,16000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-06-15 04:37:56','USR-202001002','2022-06-15 04:37:56'),('AC2022080001',63,'00063/EOB/VIII/2022/AGILITY','2022-08-01','2',1300000,2000,0,NULL,NULL,0,NULL,NULL,99,'USR-202001002','2022-08-01 04:15:16','USR-202001002','2022-08-01 04:15:16');

--
-- Table structure for table `tp_eob_claim`
--

CREATE TABLE `tp_eob_claim` (
  `eob_claim_id` varchar(21) NOT NULL,
  `eob_id` varchar(21) DEFAULT NULL,
  `claim_id` varchar(21) DEFAULT NULL,
  `user_etr` varchar(21) DEFAULT NULL,
  `dt_etr` datetime DEFAULT NULL,
  `is_deleted` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`eob_claim_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tp_eob_claim`
--

INSERT INTO `tp_eob_claim` VALUES ('EC210700001','AC2021070001','RC2021070001','USR-202001002','2021-07-19 05:59:00',0),('EC210700002','AC2021070001','RC2021070015','USR-202001002','2021-07-19 05:59:00',0),('EC210700003','AC2021070001','RC2021070016','USR-202001002','2021-07-19 05:59:00',0),('EC210700004','AC2021070001','RC2021070017','USR-202001002','2021-07-19 05:59:00',0),('EC210700005','AC2021070002','RC2021070002','USR-202001002','2021-07-19 05:59:10',0),('EC210700006','AC2021070002','RC2021070003','USR-202001002','2021-07-19 05:59:10',0),('EC210700007','AC2021070002','RC2021070004','USR-202001002','2021-07-19 05:59:10',0),('EC210700008','AC2021070002','RC2021070005','USR-202001002','2021-07-19 05:59:10',0),('EC210700009','AC2021070002','RC2021070006','USR-202001002','2021-07-19 05:59:10',0),('EC210700010','AC2021070002','RC2021070007','USR-202001002','2021-07-19 05:59:10',0),('EC210700011','AC2021070002','RC2021070008','USR-202001002','2021-07-19 05:59:10',0),('EC210700012','AC2021070002','RC2021070010','USR-202001002','2021-07-19 05:59:10',0),('EC210700013','AC2021070002','RC2021070011','USR-202001002','2021-07-19 05:59:10',0),('EC210700014','AC2021070002','RC2021070012','USR-202001002','2021-07-19 05:59:10',0),('EC210700015','AC2021070002','RC2021070013','USR-202001002','2021-07-19 05:59:10',0),('EC210700016','AC2021070002','RC2021070014','USR-202001002','2021-07-19 05:59:10',0),('EC210700017','AC2021070002','RC2021070018','USR-202001002','2021-07-19 05:59:10',0),('EC210700018','AC2021070002','RC2021070019','USR-202001002','2021-07-19 05:59:10',0),('EC210700019','AC2021070002','RC2021070020','USR-202001002','2021-07-19 05:59:10',0),('EC210700020','AC2021070002','RC2021070021','USR-202001002','2021-07-19 05:59:10',0),('EC210700021','AC2021070002','RC2021070022','USR-202001002','2021-07-19 05:59:10',0),('EC210700022','AC2021070002','RC2021070023','USR-202001002','2021-07-19 05:59:10',0),('EC210700023','AC2021070002','RC2021070024','USR-202001002','2021-07-19 05:59:10',0),('EC210800001','AC2021080001','RC2021080010','USR-202001002','2021-08-25 03:43:16',0),('EC210800002','AC2021080001','RC2021080011','USR-202001002','2021-08-25 03:43:16',0),('EC210800003','AC2021080002','RC2021080001','USR-202001002','2021-08-25 03:43:32',0),('EC210800004','AC2021080002','RC2021080002','USR-202001002','2021-08-25 03:43:32',0),('EC210800005','AC2021080002','RC2021080003','USR-202001002','2021-08-25 03:43:32',0),('EC210800006','AC2021080002','RC2021080004','USR-202001002','2021-08-25 03:43:32',0),('EC210800007','AC2021080002','RC2021080005','USR-202001002','2021-08-25 03:43:32',0),('EC210800008','AC2021080002','RC2021080006','USR-202001002','2021-08-25 03:43:32',0),('EC210800009','AC2021080002','RC2021080007','USR-202001002','2021-08-25 03:43:32',0),('EC210800010','AC2021080002','RC2021080008','USR-202001002','2021-08-25 03:43:32',0),('EC210800011','AC2021080002','RC2021080009','USR-202001002','2021-08-25 03:43:32',0),('EC210800012','AC2021080003','RC2021080018','USR-202001002','2021-08-31 05:54:00',0),('EC210800013','AC2021080003','RC2021080019','USR-202001002','2021-08-31 05:54:00',0),('EC210800014','AC2021080003','RC2021080020','USR-202001002','2021-08-31 05:54:00',0),('EC210800015','AC2021080003','RC2021080022','USR-202001002','2021-08-31 05:54:00',0),('EC210800016','AC2021080004','RC2021080012','USR-202001002','2021-08-31 05:54:14',0),('EC210800017','AC2021080004','RC2021080013','USR-202001002','2021-08-31 05:54:14',0),('EC210800018','AC2021080004','RC2021080014','USR-202001002','2021-08-31 05:54:14',0),('EC210800019','AC2021080004','RC2021080015','USR-202001002','2021-08-31 05:54:14',0),('EC210800020','AC2021080004','RC2021080016','USR-202001002','2021-08-31 05:54:14',0),('EC210800021','AC2021080004','RC2021080017','USR-202001002','2021-08-31 05:54:14',0),('EC210800022','AC2021080004','RC2021080021','USR-202001002','2021-08-31 05:54:14',0),('EC210800023','AC2021080004','RC2021080023','USR-202001002','2021-08-31 05:54:14',0),('EC210800024','AC2021080004','RC2021080024','USR-202001002','2021-08-31 05:54:14',0),('EC210800025','AC2021080004','RC2021080025','USR-202001002','2021-08-31 05:54:14',0),('EC210900001','AC2021090001','RC2021080041','USR-202001002','2021-09-15 08:51:47',0),('EC210900002','AC2021090001','RC2021090012','USR-202001002','2021-09-15 08:51:47',0),('EC210900003','AC2021090002','RC2021080026','USR-202001002','2021-09-15 08:52:02',0),('EC210900004','AC2021090002','RC2021080027','USR-202001002','2021-09-15 08:52:02',0),('EC210900005','AC2021090002','RC2021080028','USR-202001002','2021-09-15 08:52:02',0),('EC210900006','AC2021090002','RC2021080029','USR-202001002','2021-09-15 08:52:02',0),('EC210900007','AC2021090002','RC2021080031','USR-202001002','2021-09-15 08:52:02',0),('EC210900008','AC2021090002','RC2021080032','USR-202001002','2021-09-15 08:52:02',0),('EC210900009','AC2021090002','RC2021080033','USR-202001002','2021-09-15 08:52:02',0),('EC210900010','AC2021090002','RC2021080034','USR-202001002','2021-09-15 08:52:02',0),('EC210900011','AC2021090002','RC2021080035','USR-202001002','2021-09-15 08:52:02',0),('EC210900012','AC2021090002','RC2021080036','USR-202001002','2021-09-15 08:52:02',0),('EC210900013','AC2021090002','RC2021080037','USR-202001002','2021-09-15 08:52:02',0),('EC210900014','AC2021090002','RC2021080038','USR-202001002','2021-09-15 08:52:02',0),('EC210900015','AC2021090002','RC2021080039','USR-202001002','2021-09-15 08:52:02',0),('EC210900016','AC2021090002','RC2021080040','USR-202001002','2021-09-15 08:52:02',0),('EC210900017','AC2021090002','RC2021090001','USR-202001002','2021-09-15 08:52:02',0),('EC210900018','AC2021090002','RC2021090002','USR-202001002','2021-09-15 08:52:02',0),('EC210900019','AC2021090002','RC2021090003','USR-202001002','2021-09-15 08:52:02',0),('EC210900020','AC2021090002','RC2021090004','USR-202001002','2021-09-15 08:52:02',0),('EC210900021','AC2021090002','RC2021090005','USR-202001002','2021-09-15 08:52:02',0),('EC210900022','AC2021090002','RC2021090006','USR-202001002','2021-09-15 08:52:02',0),('EC210900023','AC2021090002','RC2021090007','USR-202001002','2021-09-15 08:52:02',0),('EC210900024','AC2021090002','RC2021090008','USR-202001002','2021-09-15 08:52:02',0),('EC210900025','AC2021090002','RC2021090009','USR-202001002','2021-09-15 08:52:02',0),('EC210900026','AC2021090002','RC2021090010','USR-202001002','2021-09-15 08:52:02',0),('EC210900027','AC2021090002','RC2021090011','USR-202001002','2021-09-15 08:52:02',0),('EC210900028','AC2021090003','RC2021090037','USR-202001002','2021-09-22 10:34:36',0),('EC210900029','AC2021090003','RC2021090038','USR-202001002','2021-09-22 10:34:36',0),('EC210900030','AC2021090003','RC2021090039','USR-202001002','2021-09-22 10:34:36',0),('EC210900031','AC2021090004','RC2021090024','USR-202001002','2021-09-22 10:34:46',0),('EC210900032','AC2021090004','RC2021090025','USR-202001002','2021-09-22 10:34:46',0),('EC210900033','AC2021090004','RC2021090026','USR-202001002','2021-09-22 10:34:46',0),('EC210900034','AC2021090004','RC2021090027','USR-202001002','2021-09-22 10:34:46',0),('EC210900035','AC2021090004','RC2021090028','USR-202001002','2021-09-22 10:34:46',0),('EC210900036','AC2021090004','RC2021090029','USR-202001002','2021-09-22 10:34:46',0),('EC210900037','AC2021090004','RC2021090030','USR-202001002','2021-09-22 10:34:46',0),('EC210900038','AC2021090004','RC2021090031','USR-202001002','2021-09-22 10:34:46',0),('EC210900039','AC2021090004','RC2021090032','USR-202001002','2021-09-22 10:34:46',0),('EC210900040','AC2021090004','RC2021090033','USR-202001002','2021-09-22 10:34:46',0),('EC210900041','AC2021090004','RC2021090034','USR-202001002','2021-09-22 10:34:46',0),('EC210900042','AC2021090004','RC2021090035','USR-202001002','2021-09-22 10:34:46',0),('EC210900043','AC2021090004','RC2021090036','USR-202001002','2021-09-22 10:34:46',0),('EC210900044','AC2021090004','RC2021090041','USR-202001002','2021-09-22 10:34:46',0),('EC210900045','AC2021090004','RC2021090042','USR-202001002','2021-09-22 10:34:46',0),('EC210900046','AC2021090004','RC2021090043','USR-202001002','2021-09-22 10:34:46',0),('EC210900047','AC2021090004','RC2021090044','USR-202001002','2021-09-22 10:34:46',0),('EC210900048','AC2021090004','RC2021090045','USR-202001002','2021-09-22 10:34:46',0),('EC210900049','AC2021090004','RC2021090046','USR-202001002','2021-09-22 10:34:46',0),('EC210900050','AC2021090004','RC2021090047','USR-202001002','2021-09-22 10:34:46',0),('EC210900051','AC2021090005','RC2021090048','USR-202001002','2021-09-29 10:40:15',0),('EC210900052','AC2021090005','RC2021090049','USR-202001002','2021-09-29 10:40:15',0),('EC210900053','AC2021090005','RC2021090050','USR-202001002','2021-09-29 10:40:15',0),('EC210900054','AC2021090005','RC2021090051','USR-202001002','2021-09-29 10:40:15',0),('EC210900055','AC2021090005','RC2021090053','USR-202001002','2021-09-29 10:40:15',0),('EC210900056','AC2021090005','RC2021090054','USR-202001002','2021-09-29 10:40:15',0),('EC210900057','AC2021090005','RC2021090055','USR-202001002','2021-09-29 10:40:15',0),('EC210900058','AC2021090005','RC2021090056','USR-202001002','2021-09-29 10:40:15',0),('EC211000001','AC2021100001','RC2021100001','USR-202001002','2021-10-07 09:25:08',0),('EC211000002','AC2021100001','RC2021100002','USR-202001002','2021-10-07 09:25:08',0),('EC211000003','AC2021100001','RC2021100003','USR-202001002','2021-10-07 09:25:08',0),('EC211000004','AC2021100001','RC2021100004','USR-202001002','2021-10-07 09:25:08',0),('EC211000005','AC2021100001','RC2021100006','USR-202001002','2021-10-07 09:25:08',0),('EC211000006','AC2021100001','RC2021100007','USR-202001002','2021-10-07 09:25:08',0),('EC211000007','AC2021100001','RC2021100008','USR-202001002','2021-10-07 09:25:08',0),('EC211000008','AC2021100001','RC2021100009','USR-202001002','2021-10-07 09:25:08',0),('EC211000009','AC2021100001','RC2021100010','USR-202001002','2021-10-07 09:25:08',0),('EC211000010','AC2021100001','RC2021100011','USR-202001002','2021-10-07 09:25:08',0),('EC211000011','AC2021100002','RC2021100012','USR-202001003','2021-10-26 11:49:00',0),('EC211000012','AC2021100003','RC2021100013','USR-202001003','2021-10-26 11:53:44',0),('EC211000013','AC2021100003','RC2021100014','USR-202001003','2021-10-26 11:53:44',0),('EC211000014','AC2021100003','RC2021100015','USR-202001003','2021-10-26 11:53:44',0),('EC211000015','AC2021100003','RC2021100016','USR-202001003','2021-10-26 11:53:44',0),('EC211000016','AC2021100003','RC2021100017','USR-202001003','2021-10-26 11:53:44',0),('EC211000017','AC2021100003','RC2021100018','USR-202001003','2021-10-26 11:53:44',0),('EC211000018','AC2021100003','RC2021100019','USR-202001003','2021-10-26 11:53:44',0),('EC211000019','AC2021100003','RC2021100020','USR-202001003','2021-10-26 11:53:44',0),('EC211000020','AC2021100003','RC2021100021','USR-202001003','2021-10-26 11:53:44',0),('EC211000021','AC2021100003','RC2021100022','USR-202001003','2021-10-26 11:53:44',0),('EC211000022','AC2021100003','RC2021100023','USR-202001003','2021-10-26 11:53:44',0),('EC211000023','AC2021100003','RC2021100031','USR-202001003','2021-10-26 11:53:44',0),('EC211000024','AC2021100004','RC2021100024','USR-202001003','2021-10-29 09:31:41',0),('EC211000025','AC2021100004','RC2021100025','USR-202001003','2021-10-29 09:31:41',0),('EC211000026','AC2021100004','RC2021100026','USR-202001003','2021-10-29 09:31:41',0),('EC211000027','AC2021100005','RC2021100027','USR-202001003','2021-10-29 09:33:46',0),('EC211000028','AC2021100005','RC2021100028','USR-202001003','2021-10-29 09:33:46',0),('EC211000029','AC2021100005','RC2021100029','USR-202001003','2021-10-29 09:33:46',0),('EC211000030','AC2021100005','RC2021100030','USR-202001003','2021-10-29 09:33:46',0),('EC211000031','AC2021100005','RC2021100040','USR-202001003','2021-10-29 09:33:46',0),('EC211000032','AC2021100005','RC2021100041','USR-202001003','2021-10-29 09:33:46',0),('EC211100001','AC2021110001','RC2021100033','USR-202001003','2021-11-01 10:19:04',0),('EC211100002','AC2021110001','RC2021100034','USR-202001003','2021-11-01 10:19:04',0),('EC211100003','AC2021110002','RC2021100035','USR-202001003','2021-11-01 10:20:04',0),('EC211100004','AC2021110002','RC2021100036','USR-202001003','2021-11-01 10:20:04',0),('EC211100005','AC2021110002','RC2021100037','USR-202001003','2021-11-01 10:20:04',0),('EC211100006','AC2021110002','RC2021100038','USR-202001003','2021-11-01 10:20:04',0),('EC211100007','AC2021110002','RC2021100039','USR-202001003','2021-11-01 10:20:04',0),('EC211100008','AC2021110002','RC2021100042','USR-202001003','2021-11-01 10:20:04',0),('EC211100009','AC2021110002','RC2021110002','USR-202001003','2021-11-01 10:20:04',0),('EC211100010','AC2021110003','RC2021110003','USR-202001003','2021-11-15 05:42:59',0),('EC211100011','AC2021110003','RC2021110005','USR-202001003','2021-11-15 05:42:59',0),('EC211100012','AC2021110003','RC2021110006','USR-202001003','2021-11-15 05:42:59',0),('EC211100013','AC2021110003','RC2021110007','USR-202001003','2021-11-15 05:42:59',0),('EC211100014','AC2021110003','RC2021110008','USR-202001003','2021-11-15 05:42:59',0),('EC211100015','AC2021110003','RC2021110009','USR-202001003','2021-11-15 05:42:59',0),('EC211100016','AC2021110003','RC2021110012','USR-202001003','2021-11-15 05:42:59',0),('EC211100017','AC2021110004','RC2021110010','USR-202001003','2021-11-22 05:50:12',0),('EC211100018','AC2021110004','RC2021110011','USR-202001003','2021-11-22 05:50:12',0),('EC211100019','AC2021110004','RC2021110013','USR-202001003','2021-11-22 05:50:12',0),('EC211100020','AC2021110004','RC2021110014','USR-202001003','2021-11-22 05:50:12',0),('EC211100021','AC2021110004','RC2021110015','USR-202001003','2021-11-22 05:50:12',0),('EC211100022','AC2021110004','RC2021110016','USR-202001003','2021-11-22 05:50:12',0),('EC211100023','AC2021110004','RC2021110017','USR-202001003','2021-11-22 05:50:12',0),('EC211100024','AC2021110005','RC2021110020','USR-202001003','2021-11-23 08:57:20',0),('EC211100025','AC2021110006','RC2021110021','USR-202001003','2021-11-23 08:57:46',0),('EC211100026','AC2021110006','RC2021110022','USR-202001003','2021-11-23 08:57:46',0),('EC211100027','AC2021110006','RC2021110023','USR-202001003','2021-11-23 08:57:46',0),('EC211100028','AC2021110006','RC2021110024','USR-202001003','2021-11-23 08:57:46',0),('EC211100029','AC2021110007','RC2021110025','USR-202001003','2021-11-30 05:28:04',0),('EC211100030','AC2021110007','RC2021110029','USR-202001003','2021-11-30 05:28:04',0),('EC211100031','AC2021110007','RC2021110030','USR-202001003','2021-11-30 05:28:04',0),('EC211100032','AC2021110007','RC2021110031','USR-202001003','2021-11-30 05:28:04',0),('EC211100033','AC2021110007','RC2021110032','USR-202001003','2021-11-30 05:28:04',0),('EC211100034','AC2021110007','RC2021110033','USR-202001003','2021-11-30 05:28:04',0),('EC211100035','AC2021110007','RC2021110035','USR-202001003','2021-11-30 05:28:04',0),('EC211100036','AC2021110007','RC2021110036','USR-202001003','2021-11-30 05:28:04',0),('EC211200001','AC2021120001','RC2021120001','USR-202001003','2021-12-07 05:57:25',0),('EC211200002','AC2021120002','RC2021120002','USR-202001003','2021-12-07 05:58:24',0),('EC211200003','AC2021120002','RC2021120003','USR-202001003','2021-12-07 05:58:24',0),('EC211200004','AC2021120002','RC2021120004','USR-202001003','2021-12-07 05:58:24',0),('EC211200005','AC2021120002','RC2021120005','USR-202001003','2021-12-07 05:58:24',0),('EC211200006','AC2021120003','RC2021120006','USR-202001003','2021-12-16 10:03:47',0),('EC211200007','AC2021120003','RC2021120007','USR-202001003','2021-12-16 10:03:47',0),('EC211200008','AC2021120004','RC2021120008','USR-202001003','2021-12-16 10:07:43',0),('EC211200009','AC2021120004','RC2021120009','USR-202001003','2021-12-16 10:07:43',0),('EC211200010','AC2021120004','RC2021120010','USR-202001003','2021-12-16 10:07:43',0),('EC211200011','AC2021120004','RC2021120011','USR-202001003','2021-12-16 10:07:43',0),('EC211200012','AC2021120004','RC2021120012','USR-202001003','2021-12-16 10:07:43',0),('EC211200013','AC2021120004','RC2021120013','USR-202001003','2021-12-16 10:07:43',0),('EC211200014','AC2021120004','RC2021120014','USR-202001003','2021-12-16 10:07:43',0),('EC211200015','AC2021120004','RC2021120015','USR-202001003','2021-12-16 10:07:43',0),('EC211200016','AC2021120004','RC2021120016','USR-202001003','2021-12-16 10:07:43',0),('EC211200017','AC2021120004','RC2021120017','USR-202001003','2021-12-16 10:07:43',0),('EC211200018','AC2021120005','RC2021120018','USR-202001002','2021-12-24 10:09:49',0),('EC211200019','AC2021120005','RC2021120019','USR-202001002','2021-12-24 10:09:49',0),('EC211200020','AC2021120006','RC2021120020','USR-202001003','2021-12-30 08:56:18',0),('EC211200021','AC2021120006','RC2021120021','USR-202001003','2021-12-30 08:56:18',0),('EC211200022','AC2021120006','RC2021120022','USR-202001003','2021-12-30 08:56:18',0),('EC211200023','AC2021120006','RC2021120023','USR-202001003','2021-12-30 08:56:18',0),('EC211200024','AC2021120006','RC2021120024','USR-202001003','2021-12-30 08:56:18',0),('EC211200025','AC2021120006','RC2021120025','USR-202001003','2021-12-30 08:56:19',0),('EC211200026','AC2021120006','RC2021120027','USR-202001003','2021-12-30 08:56:19',0),('EC220100001','AC2022010001','RC2022010001','USR-202001002','2022-01-05 03:46:37',0),('EC220100002','AC2022010001','RC2022010002','USR-202001002','2022-01-05 03:46:37',0),('EC220100003','AC2022010002','RC2022010003','USR-202001002','2022-01-07 04:30:53',0),('EC220100004','AC2022010002','RC2022010004','USR-202001002','2022-01-07 04:30:53',0),('EC220100005','AC2022010002','RC2022010005','USR-202001002','2022-01-07 04:30:53',0),('EC220100006','AC2022010002','RC2022010006','USR-202001002','2022-01-07 04:30:53',0),('EC220100007','AC2022010002','RC2022010007','USR-202001002','2022-01-07 04:30:53',0),('EC220100008','AC2022010002','RC2022010009','USR-202001002','2022-01-07 04:30:53',0),('EC220100009','AC2022010002','RC2022010010','USR-202001002','2022-01-07 04:30:53',0),('EC220100010','AC2022010002','RC2022010011','USR-202001002','2022-01-07 04:30:53',0),('EC220100011','AC2022010002','RC2022010013','USR-202001002','2022-01-07 04:30:53',0),('EC220100012','AC2022010003','RC2022010014','USR-202001002','2022-01-14 03:44:06',0),('EC220100013','AC2022010004','RC2022010015','USR-202001002','2022-01-14 03:44:51',0),('EC220100014','AC2022010004','RC2022010016','USR-202001002','2022-01-14 03:44:51',0),('EC220100015','AC2022010005','RC2022010017','USR-202001002','2022-01-24 07:52:53',0),('EC220100016','AC2022010005','RC2022010018','USR-202001002','2022-01-24 07:52:53',0),('EC220100017','AC2022010005','RC2022010019','USR-202001002','2022-01-24 07:52:53',0),('EC220100018','AC2022010005','RC2022010020','USR-202001002','2022-01-24 07:52:53',0),('EC220100019','AC2022010005','RC2022010021','USR-202001002','2022-01-24 07:52:53',0),('EC220100020','AC2022010005','RC2022010022','USR-202001002','2022-01-24 07:52:53',0),('EC220100021','AC2022010006','RC2022010024','USR-202001002','2022-01-25 08:57:22',0),('EC220100022','AC2022010007','RC2022010025','USR-202001002','2022-01-27 05:43:43',0),('EC220100023','AC2022010007','RC2022010026','USR-202001002','2022-01-27 05:43:43',0),('EC220100024','AC2022010007','RC2022010030','USR-202001002','2022-01-27 05:43:43',0),('EC220200001','AC2022020001','RC2022010027','USR-202001002','2022-02-08 08:38:54',0),('EC220200002','AC2022020001','RC2022010028','USR-202001002','2022-02-08 08:38:54',0),('EC220200003','AC2022020001','RC2022010029','USR-202001002','2022-02-08 08:38:54',0),('EC220200004','AC2022020001','RC2022010031','USR-202001002','2022-02-08 08:38:54',0),('EC220200005','AC2022020001','RC2022020001','USR-202001002','2022-02-08 08:38:54',0),('EC220200006','AC2022020002','RC2022020003','USR-202001002','2022-02-21 04:33:45',0),('EC220200007','AC2022020002','RC2022020004','USR-202001002','2022-02-21 04:33:45',0),('EC220200008','AC2022020003','RC2022020005','USR-202001002','2022-02-22 09:38:02',0),('EC220200009','AC2022020003','RC2022020006','USR-202001002','2022-02-22 09:38:02',0),('EC220300001','AC2022030001','RC2022020007','USR-202001002','2022-03-01 05:36:20',0),('EC220300002','AC2022030001','RC2022020008','USR-202001002','2022-03-01 05:36:20',0),('EC220300003','AC2022030002','RC2022020009','USR-202001002','2022-03-01 05:43:07',0),('EC220300004','AC2022030002','RC2022020010','USR-202001002','2022-03-01 05:43:07',0),('EC220300005','AC2022030002','RC2022020011','USR-202001002','2022-03-01 05:43:07',0),('EC220300006','AC2022030002','RC2022020012','USR-202001002','2022-03-01 05:43:07',0),('EC220300007','AC2022030002','RC2022020013','USR-202001002','2022-03-01 05:43:07',0),('EC220300008','AC2022030002','RC2022020014','USR-202001002','2022-03-01 05:43:07',0),('EC220300009','AC2022030003','RC2022030001','USR-202001002','2022-03-07 07:52:51',0),('EC220300010','AC2022030003','RC2022030002','USR-202001002','2022-03-07 07:52:51',0),('EC220300011','AC2022030003','RC2022030003','USR-202001002','2022-03-07 07:52:51',0),('EC220300012','AC2022030003','RC2022030004','USR-202001002','2022-03-07 07:52:51',0),('EC220300013','AC2022030003','RC2022030005','USR-202001002','2022-03-07 07:52:51',0),('EC220300014','AC2022030003','RC2022030006','USR-202001002','2022-03-07 07:52:51',0),('EC220300015','AC2022030003','RC2022030007','USR-202001002','2022-03-07 07:52:51',0),('EC220300016','AC2022030003','RC2022030008','USR-202001002','2022-03-07 07:52:51',0),('EC220300017','AC2022030003','RC2022030009','USR-202001002','2022-03-07 07:52:51',0),('EC220300018','AC2022030003','RC2022030010','USR-202001002','2022-03-07 07:52:51',0),('EC220300019','AC2022030003','RC2022030011','USR-202001002','2022-03-07 07:52:51',0),('EC220300020','AC2022030003','RC2022030012','USR-202001002','2022-03-07 07:52:51',0),('EC220300021','AC2022030003','RC2022030013','USR-202001002','2022-03-07 07:52:51',0),('EC220300022','AC2022030003','RC2022030016','USR-202001002','2022-03-07 07:52:51',0),('EC220300023','AC2022030003','RC2022030017','USR-202001002','2022-03-07 07:52:51',0),('EC220300024','AC2022030003','RC2022030018','USR-202001002','2022-03-07 07:52:51',0),('EC220300025','AC2022030004','RC2022030019','USR-202001002','2022-03-16 08:58:41',0),('EC220300026','AC2022030004','RC2022030020','USR-202001002','2022-03-16 08:58:41',0),('EC220300027','AC2022030005','RC2022030025','USR-202001002','2022-03-17 05:15:59',0),('EC220300028','AC2022030005','RC2022030026','USR-202001002','2022-03-17 05:15:59',0),('EC220300029','AC2022030005','RC2022030027','USR-202001002','2022-03-17 05:15:59',0),('EC220300030','AC2022030006','RC2022030021','USR-202001002','2022-03-17 05:16:39',0),('EC220300031','AC2022030006','RC2022030022','USR-202001002','2022-03-17 05:16:39',0),('EC220300032','AC2022030006','RC2022030023','USR-202001002','2022-03-17 05:16:39',0),('EC220300033','AC2022030006','RC2022030024','USR-202001002','2022-03-17 05:16:39',0),('EC220300034','AC2022030007','RC2022030028','USR-202001002','2022-03-22 04:36:54',0),('EC220300035','AC2022030007','RC2022030029','USR-202001002','2022-03-22 04:36:54',0),('EC220300036','AC2022030007','RC2022030030','USR-202001002','2022-03-22 04:36:54',0),('EC220300037','AC2022030007','RC2022030031','USR-202001002','2022-03-22 04:36:54',0),('EC220300038','AC2022030008','RC2022030035','USR-202001002','2022-03-24 04:41:16',0),('EC220300039','AC2022030008','RC2022030036','USR-202001002','2022-03-24 04:41:16',0),('EC220300040','AC2022030009','RC2022030032','USR-202001002','2022-03-24 04:41:41',0),('EC220300041','AC2022030009','RC2022030033','USR-202001002','2022-03-24 04:41:41',0),('EC220300042','AC2022030009','RC2022030034','USR-202001002','2022-03-24 04:41:41',0),('EC220300043','AC2022030010','RC2022030045','USR-202001002','2022-03-29 04:57:36',0),('EC220300044','AC2022030010','RC2022030046','USR-202001002','2022-03-29 04:57:36',0),('EC220300045','AC2022030010','RC2022030047','USR-202001002','2022-03-29 04:57:36',0),('EC220400001','AC2022040001','RC2022030037','USR-202001002','2022-04-01 05:18:55',0),('EC220400002','AC2022040001','RC2022030038','USR-202001002','2022-04-01 05:18:55',0),('EC220400003','AC2022040001','RC2022030039','USR-202001002','2022-04-01 05:18:55',0),('EC220400004','AC2022040001','RC2022030040','USR-202001002','2022-04-01 05:18:55',0),('EC220400005','AC2022040001','RC2022030041','USR-202001002','2022-04-01 05:18:55',0),('EC220400006','AC2022040001','RC2022030042','USR-202001002','2022-04-01 05:18:55',0),('EC220400007','AC2022040001','RC2022030043','USR-202001002','2022-04-01 05:18:55',0),('EC220400008','AC2022040001','RC2022030044','USR-202001002','2022-04-01 05:18:55',0),('EC220400009','AC2022040002','RC2022040001','USR-202001002','2022-04-04 03:18:01',0),('EC220400010','AC2022040002','RC2022040002','USR-202001002','2022-04-04 03:18:01',0),('EC220400011','AC2022040002','RC2022040003','USR-202001002','2022-04-04 03:18:01',0),('EC220400012','AC2022040003','RC2022040004','USR-202001002','2022-04-12 04:25:22',0),('EC220400013','AC2022040004','RC2022040007','USR-202001002','2022-04-12 04:31:00',0),('EC220400014','AC2022040004','RC2022040008','USR-202001002','2022-04-12 04:31:00',0),('EC220400015','AC2022040004','RC2022040009','USR-202001002','2022-04-12 04:31:00',0),('EC220400016','AC2022040004','RC2022040010','USR-202001002','2022-04-12 04:31:00',0),('EC220400017','AC2022040004','RC2022040011','USR-202001002','2022-04-12 04:31:00',0),('EC220400018','AC2022040004','RC2022040012','USR-202001002','2022-04-12 04:31:00',0),('EC220400019','AC2022040004','RC2022040013','USR-202001002','2022-04-12 04:31:00',0),('EC220400020','AC2022040004','RC2022040014','USR-202001002','2022-04-12 04:31:00',0),('EC220400021','AC2022040004','RC2022040015','USR-202001002','2022-04-12 04:31:00',0),('EC220400022','AC2022040004','RC2022040016','USR-202001002','2022-04-12 04:31:00',0),('EC220400023','AC2022040005','RC2022040017','USR-202001002','2022-04-25 04:36:47',0),('EC220400024','AC2022040006','RC2022040018','USR-202001002','2022-04-25 05:20:19',0),('EC220400025','AC2022040006','RC2022040019','USR-202001002','2022-04-25 05:20:19',0),('EC220400026','AC2022040007','RC2022040020','USR-202001002','2022-04-25 05:26:28',0),('EC220400027','AC2022040007','RC2022040021','USR-202001002','2022-04-25 05:26:28',0),('EC220400028','AC2022040007','RC2022040022','USR-202001002','2022-04-25 05:26:28',0),('EC220500001','AC2022050001','RC2022050001','USR-202001002','2022-05-17 08:11:34',0),('EC220500002','AC2022050001','RC2022050002','USR-202001002','2022-05-17 08:11:34',0),('EC220500003','AC2022050001','RC2022050003','USR-202001002','2022-05-17 08:11:34',0),('EC220500004','AC2022050001','RC2022050004','USR-202001002','2022-05-17 08:11:34',0),('EC220500005','AC2022050001','RC2022050005','USR-202001002','2022-05-17 08:11:34',0),('EC220500006','AC2022050001','RC2022050006','USR-202001002','2022-05-17 08:11:34',0),('EC220500007','AC2022050001','RC2022050007','USR-202001002','2022-05-17 08:11:34',0),('EC220500008','AC2022050001','RC2022050008','USR-202001002','2022-05-17 08:11:34',0),('EC220500009','AC2022050002','RC2022050009','USR-202001002','2022-05-23 04:47:35',0),('EC220500010','AC2022050002','RC2022050011','USR-202001002','2022-05-23 04:47:35',0),('EC220500011','AC2022050002','RC2022050012','USR-202001002','2022-05-23 04:47:35',0),('EC220500012','AC2022050002','RC2022050013','USR-202001002','2022-05-23 04:47:35',0),('EC220500013','AC2022050002','RC2022050014','USR-202001002','2022-05-23 04:47:35',0),('EC220500014','AC2022050003','RC2022050015','USR-202001002','2022-05-23 09:04:34',0),('EC220500015','AC2022050003','RC2022050016','USR-202001002','2022-05-23 09:04:34',0),('EC220600001','AC2022060001','RC2022050017','USR-202001002','2022-06-02 06:00:53',0),('EC220600002','AC2022060001','RC2022050018','USR-202001002','2022-06-02 06:00:53',0),('EC220600003','AC2022060001','RC2022050019','USR-202001002','2022-06-02 06:00:53',0),('EC220600004','AC2022060001','RC2022050020','USR-202001002','2022-06-02 06:00:53',0),('EC220600005','AC2022060001','RC2022050021','USR-202001002','2022-06-02 06:00:53',0),('EC220600006','AC2022060001','RC2022060001','USR-202001002','2022-06-02 06:00:53',0),('EC220600007','AC2022060002','RC2022060002','USR-202001002','2022-06-09 03:34:21',0),('EC220600008','AC2022060002','RC2022060003','USR-202001002','2022-06-09 03:34:21',0),('EC220600009','AC2022060002','RC2022060004','USR-202001002','2022-06-09 03:34:21',0),('EC220600010','AC2022060002','RC2022060005','USR-202001002','2022-06-09 03:34:21',0),('EC220600011','AC2022060002','RC2022060006','USR-202001002','2022-06-09 03:34:21',0),('EC220600012','AC2022060003','RC2022060007','USR-202001002','2022-06-15 04:37:56',0),('EC220600013','AC2022060003','RC2022060008','USR-202001002','2022-06-15 04:37:56',0),('EC220600014','AC2022060003','RC2022060009','USR-202001002','2022-06-15 04:37:56',0),('EC220600015','AC2022060003','RC2022060010','USR-202001002','2022-06-15 04:37:56',0),('EC220600016','AC2022060003','RC2022060011','USR-202001002','2022-06-15 04:37:56',0),('EC220600017','AC2022060003','RC2022060012','USR-202001002','2022-06-15 04:37:56',0),('EC220600018','AC2022060003','RC2022060013','USR-202001002','2022-06-15 04:37:56',0),('EC220600019','AC2022060003','RC2022060014','USR-202001002','2022-06-15 04:37:56',0),('EC220800001','AC2022080001','RC2022080001','USR-202001002','2022-08-01 04:15:16',0);

--
-- Table structure for table `tp_eob_payment`
--

CREATE TABLE `tp_eob_payment` (
  `payment_id` varchar(21) NOT NULL DEFAULT '',
  `remark` varchar(200) DEFAULT 'NULL',
  `amount` double(18,4) NOT NULL DEFAULT 0.0000,
  `fee_transfer` double(18,4) NOT NULL DEFAULT 0.0000,
  `payment_date` date NOT NULL,
  `bank_id` varchar(21) NOT NULL,
  `eob_id` varchar(21) NOT NULL DEFAULT '',
  `file_name` varchar(200) NOT NULL,
  `type` varchar(100) NOT NULL,
  `size` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `user_etr` varchar(21) NOT NULL DEFAULT '',
  `dt_etr` date NOT NULL,
  `user_update` varchar(21) NOT NULL DEFAULT '',
  `dt_update` date NOT NULL,
  PRIMARY KEY (`payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tp_eob_payment`
--

INSERT INTO `tp_eob_payment` VALUES ('PAY0001','Pembayaran EOB 00001',3095000.0000,0.0000,'2021-07-30','BNK-1910017','AC2021070001','AC2021070001_PAY0001_Payment.pdf','application/pdf',383992,99,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('PAY0002','Pembayaran EOB 00002',11425000.0000,0.0000,'2021-07-30','BNK-1910017','AC2021070002','AC2021070002_PAY0002_Payment.pdf','application/pdf',1872203,99,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('PAY0004','Pembayaran EOB 00003',738000.0000,2900.0000,'2021-08-26','BNK-1910017','AC2021080001','AC2021080001_PAY0004_Payment.pdf','application/pdf',374479,99,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('PAY0005','Pembayaran EOB 00004',5073455.0000,20300.0000,'2021-08-26','BNK-1910017','AC2021080002','AC2021080002_PAY0005_Payment.pdf','application/pdf',1257377,99,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('PAY0006','Pembayaran EOB 00006',9156300.0000,26100.0000,'2021-09-02','BNK-1910017','AC2021080004','AC2021080004_PAY0006_Payment.pdf','application/pdf',62409,99,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('PAY0007','Pembayaran EOB 00007',2300000.0000,5800.0000,'2021-09-22','BNK-1910017','AC2021090001','AC2021090001_PAY0007_Payment.pdf','application/pdf',66387,99,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('PAY0008','Pembayaran EOB 00008',19592200.0000,60900.0000,'2021-09-22','BNK-1910017','AC2021090002','AC2021090002_PAY0008_Payment.pdf','application/pdf',66387,99,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('PAY0009','Pembayaran EOB 00009',3150000.0000,8700.0000,'2021-09-24','BNK-1910017','AC2021090003','AC2021090003_PAY0009_Payment.pdf','application/pdf',64844,99,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('PAY0010','Pembayaran EOB 00010',16748500.0000,49300.0000,'2021-09-28','BNK-1910017','AC2021090004','AC2021090004_PAY0010_Payment.pdf','application/pdf',64844,99,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('PAY0011','Pembayaran EOB 00011',8715000.0000,20300.0000,'2021-10-01','BNK-1910017','AC2021090005','AC2021090005_PAY0011_Payment.pdf','application/pdf',60032,99,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('PAY0012','Pembayaran EOB 00012',8970000.0000,29000.0000,'2021-10-08','BNK-1910017','AC2021100001','AC2021100001_PAY0012_Payment.pdf','application/pdf',61449,99,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('PAY0013','Pembayaran EOB 00013',1100000.0000,2900.0000,'2021-10-27','BNK-1910017','AC2021100002','AC2021100002_PAY0013_Payment.pdf','application/pdf',60608,99,'USR-201703002','2021-10-27','USR-201703002','2021-10-27'),('PAY0014','Pembayaran EOB 00014',7405000.0000,20300.0000,'2021-10-27','BNK-1910017','AC2021100003','AC2021100003_PAY0014_Payment.pdf','application/pdf',60608,99,'USR-201703002','2021-10-27','USR-201703002','2021-10-27'),('PAY0015','Pembayaran EOB 00015',2048992.0000,8700.0000,'2021-12-02','BNK-1910017','AC2021100004','AC2021100004_PAY0015_Payment.pdf','application/pdf',60806,99,'USR-201703002','2021-11-02','USR-201703002','2021-11-02'),('PAY0016','Pembayaran EOB 00016',5085000.0000,17400.0000,'2021-11-02','BNK-1910017','AC2021100005','AC2021100005_PAY0016_Payment.pdf','application/pdf',60806,99,'USR-201703002','2021-11-02','USR-201703002','2021-11-02'),('PAY0017','Pembayaran EOB 00005',2299850.0000,8700.0000,'2021-09-02','BNK-1910017','AC2021080003','AC2021080003_PAY0017_Payment.pdf','application/pdf',62409,99,'USR-202001003','2021-11-03','USR-202001003','2021-11-03'),('PAY0018','Pembayaran EOB 00017',1485000.0000,5800.0000,'2021-11-03','BNK-1910017','AC2021110001','AC2021110001_PAY0018_Payment.pdf','application/pdf',61220,99,'USR-201703002','2021-11-03','USR-201703002','2021-11-03'),('PAY0019','Pembayaran EOB 00018',5546000.0000,20300.0000,'2021-11-03','BNK-1910017','AC2021110002','AC2021110002_PAY0019_Payment.pdf','application/pdf',61220,99,'USR-201703002','2021-11-03','USR-201703002','2021-11-03'),('PAY0020','Pembayaran EOB 00019',9050000.0000,20300.0000,'2021-11-16','BNK-1910017','AC2021110003','AC2021110003_PAY0020_Payment.pdf','application/pdf',60923,99,'USR-201703002','2021-11-16','USR-201703002','2021-11-16'),('PAY0021','Pembayaran EOB 00020',6244000.0000,17400.0000,'2021-11-23','BNK-1910017','AC2021110004','AC2021110004_PAY0021_Payment.pdf','application/pdf',58854,99,'USR-201703002','2021-11-23','USR-201703002','2021-11-23'),('PAY0022','Pembayaran EOB 00021',350000.0000,2900.0000,'2021-11-24','BNK-1910017','AC2021110005','AC2021110005_PAY0022_Payment.pdf','application/pdf',58568,99,'USR-201703002','2021-11-24','USR-201703002','2021-11-24'),('PAY0023','Pembayaran EOB 00022',2550000.0000,8700.0000,'2021-11-24','BNK-1910017','AC2021110006','AC2021110006_PAY0023_Payment.pdf','application/pdf',58568,99,'USR-201703002','2021-11-24','USR-201703002','2021-11-24'),('PAY0024','Pembayaran EOB 00023',3900000.0000,17400.0000,'2021-12-01','BNK-1910017','AC2021110007','AC2021110007_PAY0024_Payment.pdf','application/pdf',59693,99,'USR-201703002','2021-12-01','USR-201703002','2021-12-01'),('PAY0025','Pembayaran Eob 00024',1100000.0000,2900.0000,'2021-12-08','BNK-1910017','AC2021120001','AC2021120001_PAY0025_Payment.pdf','application/pdf',59103,99,'USR-201703002','2021-12-09','USR-201703002','2021-12-09'),('PAY0026','Pembayaran Eob 00025',4324000.0000,11600.0000,'2021-12-08','BNK-1910017','AC2021120002','AC2021120002_PAY0026_Payment.pdf','application/pdf',59103,99,'USR-201703002','2021-12-09','USR-201703002','2021-12-09'),('PAY0027','Pembayaran EOB 00026',2200000.0000,5800.0000,'2021-12-17','BNK-1910017','AC2021120003','AC2021120003_PAY0027_Payment.pdf','application/pdf',62282,99,'USR-201703002','2021-12-17','USR-201703002','2021-12-17'),('PAY0028','Pembayaran EOB 00027',9104500.0000,26100.0000,'2021-12-17','BNK-1910017','AC2021120004','AC2021120004_PAY0028_Payment.pdf','application/pdf',62282,99,'USR-201703002','2021-12-17','USR-201703002','2021-12-17'),('PAY0029','Pembayaran EOB 00028',1115000.0000,5800.0000,'2021-12-27','BNK-1910017','AC2021120005','AC2021120005_PAY0029_Payment.pdf','application/pdf',57625,99,'USR-201703002','2021-12-27','USR-201703002','2021-12-27'),('PAY0030','Pembayaran EOB 00029',4716000.0000,17400.0000,'2021-12-31','BNK-1910017','AC2021120006','AC2021120006_PAY0030_Payment.pdf','application/pdf',60302,99,'USR-201703002','2021-12-31','USR-201703002','2021-12-31'),('PAY0031','Pembayaran EOB 00030',2025000.0000,5800.0000,'2022-01-06','BNK-1910017','AC2022010001','AC2022010001_PAY0031_Payment.pdf','application/pdf',58094,99,'USR-201703002','2022-01-06','USR-201703002','2022-01-06'),('PAY0032','Pembayaran EOB 00031',8488000.0000,26100.0000,'2022-01-10','BNK-1910017','AC2022010002','AC2022010002_PAY0032_Payment.pdf','application/pdf',61063,99,'USR-201703002','2022-01-10','USR-201703002','2022-01-10'),('PAY0033','Pembayaran EOB 00032',1100000.0000,2900.0000,'2022-01-19','BNK-1910017','AC2022010003','AC2022010003_PAY0033_Payment.pdf','application/pdf',58131,99,'USR-201703002','2022-01-19','USR-201703002','2022-01-19'),('PAY0034','Pembayaran EOB 00033',2700000.0000,5800.0000,'2022-01-19','BNK-1910017','AC2022010004','AC2022010004_PAY0034_Payment.pdf','application/pdf',58131,99,'USR-201703002','2022-01-19','USR-201703002','2022-01-19'),('PAY0035','Pembayaran EOB 00034',6655000.0000,14500.0000,'2022-01-25','BNK-1910017','AC2022010005','AC2022010005_PAY0035_Payment.pdf','application/pdf',58852,99,'USR-201703002','2022-01-25','USR-201703002','2022-01-25'),('PAY0036','PembayaranEOB 00036',1850000.0000,8700.0000,'2022-01-31','BNK-1910017','AC2022010007','AC2022010007_PAY0036_Payment.pdf','application/pdf',58081,99,'USR-201703002','2022-01-31','USR-201703002','2022-01-31'),('PAY0037','Pembayaran EOB00037',5000000.0000,11600.0000,'2022-02-10','BNK-1910017','AC2022020001','AC2022020001_PAY0037_Payment.pdf','application/pdf',59514,99,'USR-201703002','2022-02-10','USR-201703002','2022-02-10'),('PAY0038','Pembayaran EOB 00038',2300000.0000,5800.0000,'2022-02-23','BNK-1910017','AC2022020002','AC2022020002_PAY0038_Payment.pdf','application/pdf',57456,99,'USR-201703002','2022-02-23','USR-201703002','2022-02-23'),('PAY0039','Pembayaran EOB 00039',1890000.0000,5800.0000,'2022-02-25','BNK-1910017','AC2022020003','AC2022020003_PAY0039_Payment.pdf','application/pdf',57671,99,'USR-201703002','2022-02-25','USR-201703002','2022-02-25'),('PAY0040','Pembayaran EOB 00040 ',1165000.0000,5800.0000,'2022-03-02','BNK-1910017','AC2022030001','AC2022030001_PAY0040_Payment.pdf','application/pdf',59541,99,'USR-201703002','2022-03-02','USR-201703002','2022-03-02'),('PAY0041','Pembayaran EOB 00041',4200000.0000,11600.0000,'2022-03-02','BNK-1910017','AC2022030002','AC2022030002_PAY0041_Payment.pdf','application/pdf',59541,99,'USR-201703002','2022-03-02','USR-201703002','2022-03-02'),('PAY0042','Pembayaran EOB 00042',15345000.0000,46400.0000,'2022-03-09','BNK-1910017','AC2022030003','AC2022030003_PAY0042_Payment.pdf','application/pdf',63509,99,'USR-201703002','2022-03-17','USR-201703002','2022-03-17'),('PAY0043','EOB 00043',300000.0000,2900.0000,'2022-03-17','BNK-1910017','AC2022030004','AC2022030004_PAY0043_Payment.pdf','application/pdf',19490,99,'USR-201703002','2022-03-17','USR-201703002','2022-03-17'),('PAY0044','Pembayaran EOB 00044',2165950.0000,5800.0000,'2022-03-21','BNK-1910017','AC2022030005','AC2022030005_PAY0044_Payment.pdf','application/pdf',59682,99,'USR-201703002','2022-03-21','USR-201703002','2022-03-21'),('PAY0045','Pembayaran EOB 00045',3790000.0000,11600.0000,'2022-03-21','BNK-1910017','AC2022030006','AC2022030006_PAY0045_Payment.pdf','application/pdf',59682,99,'USR-201703002','2022-03-21','USR-201703002','2022-03-21'),('PAY0046','Pembayaran EOB 00046',4386000.0000,11600.0000,'2022-03-24','BNK-1910017','AC2022030007','AC2022030007_PAY0046_Payment.pdf','application/pdf',58903,99,'USR-201703002','2022-03-24','USR-201703002','2022-03-24'),('PAY0047','Pembayaran EOB 00047',970000.0000,5800.0000,'2022-03-25','BNK-1910017','AC2022030008','AC2022030008_PAY0047_Payment.pdf','application/pdf',58738,99,'USR-201703002','2022-03-25','USR-201703002','2022-03-25'),('PAY0048','Pembayaran EOB 00048',4500000.0000,8700.0000,'2022-03-25','BNK-1910017','AC2022030009','AC2022030009_PAY0048_Payment.pdf','application/pdf',58738,99,'USR-201703002','2022-03-25','USR-201703002','2022-03-25'),('PAY0049','Pembayaran EOB 00049',2876158.0000,8700.0000,'2022-04-01','BNK-1910017','AC2022030010','AC2022030010_PAY0049_Payment.pdf','application/pdf',58182,99,'USR-201703002','2022-04-01','USR-201703002','2022-04-01'),('PAY0050','Pembayaran EOB 00050',6982000.0000,17400.0000,'2022-04-06','BNK-1910017','AC2022040001','AC2022040001_PAY0050_Payment.pdf','application/pdf',60951,99,'USR-201703002','2022-04-06','USR-201703002','2022-04-06'),('PAY0051','Pembayaran EOB 00051',2083000.0000,8700.0000,'2022-04-06','BNK-1910017','AC2022040002','AC2022040002_PAY0051_Payment.pdf','application/pdf',60951,99,'USR-201703002','2022-04-06','USR-201703002','2022-04-06'),('PAY0052','Pembayaran EOB 00052',400000.0000,2900.0000,'2022-04-13','BNK-1910017','AC2022040003','AC2022040003_PAY0052_Payment.pdf','application/pdf',61070,99,'USR-201703002','2022-04-13','USR-201703002','2022-04-13'),('PAY0053','Pembayaran EOB 00053',8390000.0000,26100.0000,'2022-04-13','BNK-1910017','AC2022040004','AC2022040004_PAY0053_Payment.pdf','application/pdf',61070,99,'USR-201703002','2022-04-13','USR-201703002','2022-04-13'),('PAY0054','Pembayaran EOB 00054',1200000.0000,2900.0000,'2022-04-26','BNK-1910017','AC2022040005','AC2022040005_PAY0054_Payment.pdf','application/pdf',59282,99,'USR-201703002','2022-04-26','USR-201703002','2022-04-26'),('PAY0055','Pembayaran EOB 00055',2200000.0000,5800.0000,'2022-04-26','BNK-1910017','AC2022040006','AC2022040006_PAY0055_Payment.pdf','application/pdf',59282,99,'USR-201703002','2022-04-26','USR-201703002','2022-04-26'),('PAY0056','Pembayaran EOB ',350000.0000,0.0000,'2022-02-25','BNK-1910017','AC2022010006','AC2022010006_PAY0056_Payment.pdf','application/pdf',2079,99,'USR-201703002','2022-05-18','USR-201703002','2022-05-18'),('PAY0057','Pembayaran EOB ',3650000.0000,8700.0000,'2022-04-26','BNK-1910017','AC2022040007','AC2022040007_PAY0057_Payment.pdf','application/pdf',59282,99,'USR-201703002','2022-05-18','USR-201703002','2022-05-18'),('PAY0058','Pembayaran EOB',6199000.0000,17400.0000,'2022-05-19','BNK-1910017','AC2022050001','AC2022050001_PAY0058_Payment.pdf','application/pdf',59786,99,'USR-201703002','2022-05-19','USR-201703002','2022-05-19'),('PAY0059','Pembayaran EOB',5425000.0000,14500.0000,'2022-05-25','BNK-1910017','AC2022050002','AC2022050002_PAY0059_Payment.pdf','application/pdf',59775,99,'USR-201703002','2022-05-25','USR-201703002','2022-05-25'),('PAY0060','Pembayaran EOB',2300000.0000,5800.0000,'2022-05-25','BNK-1910017','AC2022050003','AC2022050003_PAY0060_Payment.pdf','application/pdf',59775,99,'USR-201703002','2022-05-25','USR-201703002','2022-05-25'),('PAY0061','pembayaran EOB',5910000.0000,17400.0000,'2022-06-07','BNK-1910017','AC2022060001','AC2022060001_PAY0061_Payment.pdf','application/pdf',59932,99,'USR-201703002','2022-06-07','USR-201703002','2022-06-07'),('PAY0062','EOB 00061',5122500.0000,14500.0000,'2022-06-10','BNK-1910017','AC2022060002','AC2022060002_PAY0062_Payment.pdf','application/pdf',58784,99,'USR-201703002','2022-06-10','USR-201703002','2022-06-10'),('PAY0063','Pembayaran EOB 0062',7950000.0000,20300.0000,'2022-06-20','BNK-1910017','AC2022060003','AC2022060003_PAY0063_Payment.pdf','application/pdf',59686,99,'USR-201703002','2022-06-20','USR-201703002','2022-06-20'),('PAY0064','Pembayaran EOB 00063',1300000.0000,2900.0000,'2022-08-02','BNK-1910017','AC2022080001','AC2022080001_PAY0064_Payment.pdf','application/pdf',18465,99,'USR-201703002','2022-08-02','USR-201703002','2022-08-02');

--
-- 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,'20210601AG','COM002','2021-01-01','2021-12-31','fauzan',NULL,1),(2,'20210601AGI','COM001','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`
--


--
-- Table structure for table `tp_request_payment`
--

CREATE TABLE `tp_request_payment` (
  `request_id` varchar(21) NOT NULL DEFAULT '',
  `remark` varchar(200) DEFAULT 'NULL',
  `amount` double(18,4) NOT NULL DEFAULT 0.0000,
  `eob_id` varchar(21) NOT NULL DEFAULT '',
  `file_name` varchar(200) NOT NULL,
  `type` varchar(100) NOT NULL,
  `size` int(11) NOT NULL,
  `file_name_E` varchar(200) NOT NULL,
  `type_E` varchar(100) NOT NULL,
  `size_E` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `user_etr` varchar(21) NOT NULL DEFAULT '',
  `dt_etr` date NOT NULL,
  `user_update` varchar(21) NOT NULL DEFAULT '',
  `dt_update` date NOT NULL,
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tp_request_payment`
--

INSERT INTO `tp_request_payment` VALUES ('REQ0001','Pengajuan Pembayaran EOB 00001',3095000.0000,'AC2021070001','AC2021070001_REQ0001_reqPay.pdf','application/pdf',71793,'AC2021070001_REQ0001_reqPayE.xls','application/vnd.ms-excel',14848,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0002','Pengajuan Pembayaran EOB 00002',11955000.0000,'AC2021070002','AC2021070002_REQ0002_reqPay.pdf','application/pdf',71793,'AC2021070002_REQ0002_reqPayE.xls','application/vnd.ms-excel',19968,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0003','Pengajuan Pembayaran EOB 00003',738000.0000,'AC2021080001','AC2021080001_REQ0003_reqPay.pdf','application/pdf',68620,'AC2021080001_REQ0003_reqPayE.xls','application/vnd.ms-excel',13824,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0004','Pengajuan Pembayaran EOB 00004',5073455.0000,'AC2021080002','AC2021080002_REQ0004_reqPay.msg','application/octet-stream',58368,'AC2021080002_REQ0004_reqPayE.xls','application/vnd.ms-excel',16384,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0005','Pengajuan Pembayaran EOB 00005',2299850.0000,'AC2021080003','AC2021080003_REQ0005_reqPay.pdf','application/pdf',528817,'AC2021080003_REQ0005_reqPayE.xls','application/vnd.ms-excel',14848,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0007','Pengajuan Pembayaran EOB 00006',9156300.0000,'AC2021080004','AC2021080004_REQ0007_reqPay.pdf','application/pdf',528817,'AC2021080004_REQ0007_reqPayE.xls','application/vnd.ms-excel',17408,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0008','Pengajuan Pembayaran EOB 00007',2300000.0000,'AC2021090001','AC2021090001_REQ0008_reqPay.pdf','application/pdf',426613,'AC2021090001_REQ0008_reqPayE.xls','application/vnd.ms-excel',14336,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0009','Pengajuan Pembayaran EOB 00008',19592200.0000,'AC2021090002','AC2021090002_REQ0009_reqPay.pdf','application/pdf',426613,'AC2021090002_REQ0009_reqPayE.xls','application/vnd.ms-excel',22016,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0010','Pengajuan Pembayaran EOB 00009',3150000.0000,'AC2021090003','AC2021090003_REQ0010_reqPay.pdf','application/pdf',622726,'AC2021090003_REQ0010_reqPayE.xls','application/vnd.ms-excel',14336,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0011','Pengajuan Pembayaran EOB 00010',16548500.0000,'AC2021090004','AC2021090004_REQ0011_reqPay.pdf','application/pdf',622726,'AC2021090004_REQ0011_reqPayE.xls','application/vnd.ms-excel',20480,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0012','Pengajuan Pembayaran EOB 00011',8715000.0000,'AC2021090005','AC2021090005_REQ0012_reqPay.pdf','application/pdf',315310,'AC2021090005_REQ0012_reqPayE.xls','application/vnd.ms-excel',16384,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0013','Pengajuan Pembayaran EOB 00012',8970000.0000,'AC2021100001','AC2021100001_REQ0013_reqPay.pdf','application/pdf',315909,'AC2021100001_REQ0013_reqPayE.xls','application/vnd.ms-excel',17408,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0014','Pengajuan Pembayaran EOB 00013',1100000.0000,'AC2021100002','AC2021100002_REQ0014_reqPay.pdf','application/pdf',213074,'AC2021100002_REQ0014_reqPayE.xls','application/vnd.ms-excel',13824,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0015','Pengajuan Pembayaran EOB 00014',7405000.0000,'AC2021100003','AC2021100003_REQ0015_reqPay.pdf','application/pdf',376119,'AC2021100003_REQ0015_reqPayE.xls','application/vnd.ms-excel',16896,1,'USR-202001003','2021-10-26','USR-202001003','2021-10-26'),('REQ0016','Pengajuan EOB 00015',2048992.0000,'AC2021100004','AC2021100004_REQ0016_reqPay.pdf','application/pdf',221717,'AC2021100004_REQ0016_reqPayE.xls','application/vnd.ms-excel',14336,1,'USR-202001003','2021-10-29','USR-202001003','2021-10-29'),('REQ0017','Pengajuan EOB 00016',5085000.0000,'AC2021100005','AC2021100005_REQ0017_reqPay.pdf','application/pdf',249380,'AC2021100005_REQ0017_reqPayE.xls','application/vnd.ms-excel',28672,1,'USR-202001003','2021-10-29','USR-202001003','2021-10-29'),('REQ0018','Pengajuan Pembayaran EOB 00017',1485000.0000,'AC2021110001','AC2021110001_REQ0018_reqPay.pdf','application/pdf',229694,'AC2021110001_REQ0018_reqPayE.xls','application/vnd.ms-excel',26624,1,'USR-202001003','2021-11-02','USR-202001003','2021-11-02'),('REQ0019','Pengajuan Pembayaran EOB 00018',5546000.0000,'AC2021110002','AC2021110002_REQ0019_reqPay.pdf','application/pdf',292035,'AC2021110002_REQ0019_reqPayE.xls','application/vnd.ms-excel',30720,1,'USR-202001003','2021-11-02','USR-202001003','2021-11-02'),('REQ0020','Pengajuan pembayaran klaim EOB 00019',9050000.0000,'AC2021110003','AC2021110003_REQ0020_reqPay.pdf','application/pdf',254450,'AC2021110003_REQ0020_reqPayE.xls','application/vnd.ms-excel',27648,1,'USR-202001003','2021-11-15','USR-202001003','2021-11-15'),('REQ0021','Pengajuan Pembayaran EOB 00020',6244000.0000,'AC2021110004','AC2021110004_REQ0021_reqPay.pdf','application/pdf',266502,'AC2021110004_REQ0021_reqPayE.xls','application/vnd.ms-excel',30208,1,'USR-202001003','2021-11-22','USR-202001003','2021-11-22'),('REQ0022','Pengajuan Pembayaran EOB 00021',350000.0000,'AC2021110005','AC2021110005_REQ0022_reqPay.pdf','application/pdf',186744,'AC2021110005_REQ0022_reqPayE.pdf','application/pdf',186744,1,'USR-202001003','2021-11-23','USR-202001003','2021-11-23'),('REQ0023','Pengajuan Pembayaran EOB 00022',2550000.0000,'AC2021110006','AC2021110006_REQ0023_reqPay.pdf','application/pdf',225315,'AC2021110006_REQ0023_reqPayE.xls','application/vnd.ms-excel',27136,1,'USR-202001003','2021-11-23','USR-202001003','2021-11-23'),('REQ0024','Pengajuan Pembayaran Klaim EOB 00023',3900000.0000,'AC2021110007','AC2021110007_REQ0024_reqPay.pdf','application/pdf',265183,'AC2021110007_REQ0024_reqPayE.xls','application/vnd.ms-excel',30720,1,'USR-202001003','2021-11-30','USR-202001003','2021-11-30'),('REQ0025','Pengajuan Pembayaran EOB 00024',1100000.0000,'AC2021120001','AC2021120001_REQ0025_reqPay.pdf','application/pdf',184888,'AC2021120001_REQ0025_reqPayE.xls','application/vnd.ms-excel',26112,1,'USR-202001003','2021-12-07','USR-202001003','2021-12-07'),('REQ0026','Pengajuan Pembayaran EOB 00025',4324000.0000,'AC2021120002','AC2021120002_REQ0026_reqPay.pdf','application/pdf',229306,'AC2021120002_REQ0026_reqPayE.xls','application/vnd.ms-excel',27136,1,'USR-202001003','2021-12-07','USR-202001003','2021-12-07'),('REQ0028','Pengajuan Pembayaran EOB 00026',2200000.0000,'AC2021120003','AC2021120003_REQ0028_reqPay.pdf','application/pdf',523389,'AC2021120003_REQ0028_reqPayE.xls','application/vnd.ms-excel',27648,1,'USR-202001003','2021-12-17','USR-202001003','2021-12-17'),('REQ0029','Pengajuan Pembayaran EOB 00027',9104500.0000,'AC2021120004','AC2021120004_REQ0029_reqPay.pdf','application/pdf',623968,'AC2021120004_REQ0029_reqPayE.xls','application/vnd.ms-excel',29696,1,'USR-202001003','2021-12-17','USR-202001003','2021-12-17'),('REQ0030','Pengajuan Pembayaran EOB 00028',1115000.0000,'AC2021120005','AC2021120005_REQ0030_reqPay.pdf','application/pdf',234260,'AC2021120005_REQ0030_reqPayE.xls','application/vnd.ms-excel',27648,1,'USR-202001002','2021-12-24','USR-202001002','2021-12-24'),('REQ0031','Pengjauan Pembayaran EOB 00029',4716000.0000,'AC2021120006','AC2021120006_REQ0031_reqPay.pdf','application/pdf',273218,'AC2021120006_REQ0031_reqPayE.xls','application/vnd.ms-excel',30720,1,'USR-202001002','2021-12-30','USR-202001002','2021-12-30'),('REQ0032','Pengajuan Pembayaran Klaim EOB 00030',2025000.0000,'AC2022010001','AC2022010001_REQ0032_reqPay.pdf','application/pdf',222130,'AC2022010001_REQ0032_reqPayE.xls','application/vnd.ms-excel',28160,1,'USR-202001002','2022-01-05','USR-202001002','2022-01-05'),('REQ0033','Pengajuan Pembayaran Klaim EOB 00031',8488000.0000,'AC2022010002','AC2022010002_REQ0033_reqPay.pdf','application/pdf',311893,'AC2022010002_REQ0033_reqPayE.xls','application/vnd.ms-excel',31744,1,'USR-202001002','2022-01-07','USR-202001002','2022-01-07'),('REQ0034','Pengajuan Pembayaran Klaim ASO ',1100000.0000,'AC2022010003','AC2022010003_REQ0034_reqPay.pdf','application/pdf',201528,'AC2022010003_REQ0034_reqPayE.xls','application/vnd.ms-excel',27648,1,'USR-202001002','2022-01-17','USR-202001002','2022-01-17'),('REQ0035','Pengajuan Pembayaran Klaim ASO',2700000.0000,'AC2022010004','AC2022010004_REQ0035_reqPay.pdf','application/pdf',218574,'AC2022010004_REQ0035_reqPayE.xls','application/vnd.ms-excel',27136,1,'USR-202001002','2022-01-17','USR-202001002','2022-01-17'),('REQ0036','Pengajuan Pembayaran Klaim ASO',6655000.0000,'AC2022010005','AC2022010005_REQ0036_reqPay.pdf','application/pdf',278504,'AC2022010005_REQ0036_reqPayE.xls','application/vnd.ms-excel',28160,1,'USR-202001002','2022-01-24','USR-202001002','2022-01-24'),('REQ0037','Pengajuan Pembayaran Klaim ASO',1850000.0000,'AC2022010007','AC2022010007_REQ0037_reqPay.pdf','application/pdf',231934,'AC2022010007_REQ0037_reqPayE.xls','application/vnd.ms-excel',27136,1,'USR-202001002','2022-01-27','USR-202001002','2022-01-27'),('REQ0038','Pengajuan Pembayaran Klaim',5000000.0000,'AC2022020001','AC2022020001_REQ0038_reqPay.pdf','application/pdf',205732,'AC2022020001_REQ0038_reqPayE.xls','application/vnd.ms-excel',32768,1,'USR-202001002','2022-02-09','USR-202001002','2022-02-09'),('REQ0039','Pengajuan Pembayaran Klaim',2300000.0000,'AC2022020002','AC2022020002_REQ0039_reqPay.pdf','application/pdf',210437,'AC2022020002_REQ0039_reqPayE.xls','application/vnd.ms-excel',34816,1,'USR-202001002','2022-02-22','USR-202001002','2022-02-22'),('REQ0040','Pengajuan Pembayaran Klaim',1890000.0000,'AC2022020003','AC2022020003_REQ0040_reqPay.pdf','application/pdf',218029,'AC2022020003_REQ0040_reqPayE.xls','application/vnd.ms-excel',29696,1,'USR-202001002','2022-02-23','USR-202001002','2022-02-23'),('REQ0041','Pengajuan Pembayaran Klaim',350000.0000,'AC2022010006','AC2022010006_REQ0041_reqPay.pdf','application/pdf',221644,'AC2022010006_REQ0041_reqPayE.xls','application/vnd.ms-excel',26624,1,'USR-202001002','2022-02-23','USR-202001002','2022-02-23'),('REQ0042','Pengajuan Pembayaran Klaim',1165000.0000,'AC2022030001','AC2022030001_REQ0042_reqPay.pdf','application/pdf',179962,'AC2022030001_REQ0042_reqPayE.xls','application/vnd.ms-excel',32256,1,'USR-202001002','2022-03-01','USR-202001002','2022-03-01'),('REQ0043','Pengajuan Pembayaran Klaim',4200000.0000,'AC2022030002','AC2022030002_REQ0043_reqPay.pdf','application/pdf',223525,'AC2022030002_REQ0043_reqPayE.xls','application/vnd.ms-excel',30720,1,'USR-202001002','2022-03-01','USR-202001002','2022-03-01'),('REQ0044','Pengajuan Pembayaran Klaim',15345000.0000,'AC2022030003','AC2022030003_REQ0044_reqPay.pdf','application/pdf',467090,'AC2022030003_REQ0044_reqPayE.xls','application/vnd.ms-excel',33792,1,'USR-202001002','2022-03-08','USR-202001002','2022-03-08'),('REQ0045','Pengajuan Pembayaran Klaim',300000.0000,'AC2022030004','AC2022030004_REQ0045_reqPay.pdf','application/pdf',572734,'AC2022030004_REQ0045_reqPayE.xls','application/vnd.ms-excel',28160,1,'USR-202001002','2022-03-17','USR-202001002','2022-03-17'),('REQ0046','Pengajuan Pembayaran Klaim',2165950.0000,'AC2022030005','AC2022030005_REQ0046_reqPay.pdf','application/pdf',233305,'AC2022030005_REQ0046_reqPayE.xls','application/vnd.ms-excel',31232,1,'USR-202001002','2022-03-17','USR-202001002','2022-03-17'),('REQ0047','Pengajuan Pembayaran Klaim',3790000.0000,'AC2022030006','AC2022030006_REQ0047_reqPay.pdf','application/pdf',246825,'AC2022030006_REQ0047_reqPayE.xls','application/vnd.ms-excel',30208,1,'USR-202001002','2022-03-17','USR-202001002','2022-03-17'),('REQ0048','Pengajuan Pembayaran Klaim',4386000.0000,'AC2022030007','AC2022030007_REQ0048_reqPay.pdf','application/pdf',242996,'AC2022030007_REQ0048_reqPayE.xls','application/vnd.ms-excel',28672,1,'USR-202001002','2022-03-22','USR-202001002','2022-03-22'),('REQ0049','Pengajuan Pembayaran Klaim',970000.0000,'AC2022030008','AC2022030008_REQ0049_reqPay.pdf','application/pdf',184446,'AC2022030008_REQ0049_reqPayE.xls','application/vnd.ms-excel',29696,1,'USR-202001002','2022-03-24','USR-202001002','2022-03-24'),('REQ0050','Pengajuan Pembayaran Klaim',4500000.0000,'AC2022030009','AC2022030009_REQ0050_reqPay.pdf','application/pdf',194936,'AC2022030009_REQ0050_reqPayE.xls','application/vnd.ms-excel',27136,1,'USR-202001002','2022-03-24','USR-202001002','2022-03-24'),('REQ0051','Pengajuan Pembayaran Klaim',2876158.0000,'AC2022030010','AC2022030010_REQ0051_reqPay.pdf','application/pdf',227895,'AC2022030010_REQ0051_reqPayE.xls','application/vnd.ms-excel',30208,1,'USR-202001002','2022-03-30','USR-202001002','2022-03-30'),('REQ0052','Pengajuan Pembayaran Klaim',6982000.0000,'AC2022040001','AC2022040001_REQ0052_reqPay.pdf','application/pdf',343595,'AC2022040001_REQ0052_reqPayE.xls','application/vnd.ms-excel',31232,1,'USR-202001002','2022-04-01','USR-202001002','2022-04-01'),('REQ0053','Pengajuan Pembayaran Klaim',2083000.0000,'AC2022040002','AC2022040002_REQ0053_reqPay.pdf','application/pdf',222783,'AC2022040002_REQ0053_reqPayE.xls','application/vnd.ms-excel',28672,1,'USR-202001002','2022-04-05','USR-202001002','2022-04-05'),('REQ0054','Pengajuan Pembayaran Klaim ASO',400000.0000,'AC2022040003','AC2022040003_REQ0054_reqPay.pdf','application/pdf',200706,'AC2022040003_REQ0054_reqPayE.xls','application/vnd.ms-excel',27648,1,'USR-202001002','2022-04-12','USR-202001002','2022-04-12'),('REQ0055','Pengajuan Pembayaran Klaim ASO',8390000.0000,'AC2022040004','AC2022040004_REQ0055_reqPay.pdf','application/pdf',316504,'AC2022040004_REQ0055_reqPayE.xls','application/vnd.ms-excel',31744,1,'USR-202001002','2022-04-12','USR-202001002','2022-04-12'),('REQ0056','Pengajuan Pembayaran Klaim',1200000.0000,'AC2022040005','AC2022040005_REQ0056_reqPay.pdf','application/pdf',673198,'AC2022040005_REQ0056_reqPayE.xls','application/vnd.ms-excel',27648,1,'USR-202001002','2022-04-25','USR-202001002','2022-04-25'),('REQ0057','Pengajuan Pembayaran Klaim',2200000.0000,'AC2022040006','AC2022040006_REQ0057_reqPay.pdf','application/pdf',208654,'AC2022040006_REQ0057_reqPayE.xls','application/vnd.ms-excel',26624,1,'USR-202001002','2022-04-25','USR-202001002','2022-04-25'),('REQ0059','Pengajuan Pembayaran Klaim',3650000.0000,'AC2022040007','AC2022040007_REQ0059_reqPay.pdf','application/pdf',233244,'AC2022040007_REQ0059_reqPayE.xls','application/vnd.ms-excel',27136,1,'USR-202001002','2022-04-25','USR-202001002','2022-04-25'),('REQ0060','Pengajuan Pembayaran Klaim ASO ',6199000.0000,'AC2022050001','AC2022050001_REQ0060_reqPay.pdf','application/pdf',286430,'AC2022050001_REQ0060_reqPayE.xls','application/vnd.ms-excel',28672,1,'USR-202001002','2022-05-17','USR-202001002','2022-05-17'),('REQ0061','Pengajuan Pembayaran Klaim ASO',5425000.0000,'AC2022050002','AC2022050002_REQ0061_reqPay.pdf','application/pdf',258602,'AC2022050002_REQ0061_reqPayE.xls','application/vnd.ms-excel',29184,1,'USR-202001002','2022-05-23','USR-202001002','2022-05-23'),('REQ0062','Pengajuan Pembayaran Klaim ASO',2300000.0000,'AC2022050003','AC2022050003_REQ0062_reqPay.pdf','application/pdf',217230,'AC2022050003_REQ0062_reqPayE.xls','application/vnd.ms-excel',27136,1,'USR-202001002','2022-05-23','USR-202001002','2022-05-23'),('REQ0063','Pengajuan Pembayaran Klaim ASO',5910000.0000,'AC2022060001','AC2022060001_REQ0063_reqPay.pdf','application/pdf',264234,'AC2022060001_REQ0063_reqPayE.xls','application/vnd.ms-excel',28160,1,'USR-202001002','2022-06-03','USR-202001002','2022-06-03'),('REQ0064','Pengajuan Pembayaran Klaim',5122500.0000,'AC2022060002','AC2022060002_REQ0064_reqPay.pdf','application/pdf',255621,'AC2022060002_REQ0064_reqPayE.xls','application/vnd.ms-excel',29184,1,'USR-202001002','2022-06-09','USR-202001002','2022-06-09'),('REQ0065','Pengajuan Pembayaran Klaim',7950000.0000,'AC2022060003','AC2022060003_REQ0065_reqPay.pdf','application/pdf',282347,'AC2022060003_REQ0065_reqPayE.xls','application/vnd.ms-excel',32256,1,'USR-202001002','2022-06-16','USR-202001002','2022-06-16'),('REQ0066','Pengajuan Pembayaran Klaim ASO',1300000.0000,'AC2022080001','AC2022080001_REQ0066_reqPay.pdf','application/pdf',207884,'AC2022080001_REQ0066_reqPayE.xls','application/vnd.ms-excel',27648,1,'USR-202001002','2022-08-01','USR-202001002','2022-08-01');

--
-- Table structure for table `tp_request_payment_delete`
--

CREATE TABLE `tp_request_payment_delete` (
  `request_id` varchar(21) NOT NULL DEFAULT '',
  `remark` varchar(200) DEFAULT 'NULL',
  `amount` double(18,4) NOT NULL DEFAULT 0.0000,
  `eob_id` varchar(21) NOT NULL DEFAULT '',
  `file_name` varchar(200) NOT NULL,
  `type` varchar(100) NOT NULL,
  `size` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `user_etr` varchar(21) NOT NULL DEFAULT '',
  `dt_etr` date NOT NULL,
  `user_update` varchar(21) NOT NULL DEFAULT '',
  `dt_update` date NOT NULL,
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tp_request_payment_delete`
--


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


