-- MySQL dump 10.13  Distrib 8.0.22, for Win64 (x86_64)
--
-- Host: localhost    Database: keuangan_jayakarta
-- ------------------------------------------------------
-- Server version	5.7.32-0ubuntu0.18.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `tb_pembayaran_gaji_pinjaman`
--

DROP TABLE IF EXISTS `tb_pembayaran_gaji_pinjaman`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tb_pembayaran_gaji_pinjaman` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tb_pembayaran_gaji_id` int(10) unsigned NOT NULL,
  `tb_pinjaman_pegawai_id` int(10) unsigned NOT NULL,
  `nama_pinjaman` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jumlah` double(20,2) NOT NULL DEFAULT '0.00',
  `total` double(20,2) NOT NULL DEFAULT '0.00',
  `sisa` double(20,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tb_pembayaran_gaji_pinjaman_tb_pembayaran_gaji_id_index` (`tb_pembayaran_gaji_id`),
  KEY `tb_pembayaran_gaji_pinjaman_tb_pinjaman_pegawai_id_index` (`tb_pinjaman_pegawai_id`)
) ENGINE=InnoDB AUTO_INCREMENT=180 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_pembayaran_gaji_pinjaman`
--

LOCK TABLES `tb_pembayaran_gaji_pinjaman` WRITE;
/*!40000 ALTER TABLE `tb_pembayaran_gaji_pinjaman` DISABLE KEYS */;
INSERT INTO `tb_pembayaran_gaji_pinjaman` VALUES (1,5,7,'PINJAMAN KOPERASI',6300000.00,0.00,6300000.00,'2020-05-12 23:59:59','2020-05-12 23:59:59'),(2,5,8,'PINJAMAN YAYASAN',24000000.00,0.00,24000000.00,'2020-05-12 23:59:59','2020-05-12 23:59:59'),(3,6,7,'PINJAMAN KOPERASI',6300000.00,0.00,6300000.00,'2020-05-13 00:04:14','2020-05-13 00:04:14'),(4,6,8,'PINJAMAN YAYASAN',24000000.00,0.00,24000000.00,'2020-05-13 00:04:14','2020-05-13 00:04:14'),(5,7,9,'PINJAMAN KOPERASI',8400000.00,0.00,8400000.00,'2020-05-13 00:06:01','2020-05-13 00:06:01'),(6,8,11,'PINJAMAN KOPERASI',4725000.00,1575000.00,3150000.00,'2020-05-13 00:08:18','2020-05-13 00:08:18'),(7,9,10,'PINJAMAN KOPERASI',11550000.00,1575000.00,9975000.00,'2020-05-13 00:10:39','2020-05-13 00:10:39'),(8,10,14,'PINJAMAN KOPERASI',3360000.00,0.00,3360000.00,'2020-05-13 00:12:14','2020-05-13 00:12:14'),(9,10,15,'PINJAMAN YAYASAN',10000000.00,0.00,10000000.00,'2020-05-13 00:12:14','2020-05-13 00:12:14'),(10,11,6,'PINJAMAN KOPERASI',14700000.00,0.00,14700000.00,'2020-05-13 00:14:23','2020-05-13 00:14:23'),(11,12,12,'PINJAMAN KOPERASI',12600000.00,1575000.00,11025000.00,'2020-05-13 00:23:20','2020-05-13 00:23:20'),(12,12,13,'PINJAMAN YAYASAN',7000000.00,500000.00,6500000.00,'2020-05-13 00:23:20','2020-05-13 00:23:20'),(13,15,16,'PINJAMAN KOPERASI',8400000.00,0.00,8400000.00,'2020-05-13 00:33:21','2020-05-13 00:33:21'),(14,16,17,'PINJAMAN KOPERASI',2520000.00,0.00,2520000.00,'2020-05-13 00:35:44','2020-05-13 00:35:44'),(15,17,20,'PINJAMAN KOPERASI',525000.00,0.00,525000.00,'2020-05-13 00:38:07','2020-05-13 00:38:07'),(16,17,21,'PINJAMAN YAYASAN',8500000.00,0.00,8500000.00,'2020-05-13 00:38:07','2020-05-13 00:38:07'),(17,18,19,'PINJAMAN KOPERASI',6720000.00,0.00,6720000.00,'2020-05-13 00:40:02','2020-05-13 00:40:02'),(18,19,18,'PINJAMAN KOPERASI',2835000.00,0.00,2835000.00,'2020-05-13 00:41:33','2020-05-13 00:41:33'),(19,24,22,'PINJAMAN KOPERASI',3150000.00,1050000.00,2100000.00,'2020-05-13 02:20:06','2020-05-13 02:20:06'),(20,24,23,'PINJAMAN YAYASAN',71000000.00,0.00,71000000.00,'2020-05-13 02:20:06','2020-05-13 02:20:06'),(21,26,24,'PINJAMAN KOPERASI',18900000.00,2100000.00,16800000.00,'2020-05-13 02:24:25','2020-05-13 02:24:25'),(22,29,25,'PINJAMAN KOPERASI',9450000.00,3150000.00,6300000.00,'2020-05-13 02:32:33','2020-05-13 02:32:33'),(23,29,26,'PINJAMAN YAYASAN',3000000.00,1000000.00,2000000.00,'2020-05-13 02:32:33','2020-05-13 02:32:33'),(24,31,27,'PINJAMAN KOPERASI',15750000.00,0.00,15750000.00,'2020-05-13 02:35:26','2020-05-13 02:35:26'),(25,31,28,'PINJAMAN YAYASAN',6000000.00,0.00,6000000.00,'2020-05-13 02:35:26','2020-05-13 02:35:26'),(26,32,29,'PINJAMAN KOPERASI',14700000.00,2100000.00,12600000.00,'2020-05-13 02:36:32','2020-05-13 02:36:32'),(27,32,30,'PINJAMAN YAYASAN',47500000.00,0.00,47500000.00,'2020-05-13 02:36:32','2020-05-13 02:36:32'),(28,35,32,'PINJAMAN KOPERASI',4200000.00,0.00,4200000.00,'2020-05-13 03:11:13','2020-05-13 03:11:13'),(29,36,33,'PINJAMAN KOPERASI',5145000.00,0.00,5145000.00,'2020-05-13 03:12:17','2020-05-13 03:12:17'),(30,37,34,'PINJAMAN KOPERASI',4725000.00,0.00,4725000.00,'2020-05-13 03:26:06','2020-05-13 03:26:06'),(31,37,35,'PINJAMAN YAYASAN',1650000.00,0.00,1650000.00,'2020-05-13 03:26:06','2020-05-13 03:26:06'),(32,38,37,'PINJAMAN KOPERASI',4200000.00,0.00,4200000.00,'2020-05-13 03:30:34','2020-05-13 03:30:34'),(33,39,38,'PINJAMAN KOPERASI',4200000.00,0.00,4200000.00,'2020-05-13 03:31:37','2020-05-13 03:31:37'),(34,44,7,'PINJAMAN KOPERASI',6300000.00,0.00,6300000.00,'2020-06-28 14:39:16','2020-06-28 14:39:16'),(35,44,8,'PINJAMAN YAYASAN',24000000.00,0.00,24000000.00,'2020-06-28 14:39:16','2020-06-28 14:39:16'),(36,44,39,'PINJAMAN KOPERASI',5250000.00,550000.00,4700000.00,'2020-06-28 14:39:16','2020-06-28 14:39:16'),(37,45,6,'PINJAMAN KOPERASI',14700000.00,0.00,14700000.00,'2020-06-28 14:41:20','2020-06-28 14:41:20'),(38,46,9,'PINJAMAN KOPERASI',8400000.00,1050000.00,7350000.00,'2020-06-28 14:42:30','2020-06-28 14:42:30'),(39,47,10,'PINJAMAN KOPERASI',11550000.00,1575000.00,9975000.00,'2020-06-28 14:44:01','2020-06-28 14:44:01'),(40,48,11,'PINJAMAN KOPERASI',4725000.00,1575000.00,3150000.00,'2020-06-28 14:45:34','2020-06-28 14:45:34'),(41,49,12,'PINJAMAN KOPERASI',12600000.00,1575000.00,11025000.00,'2020-06-28 14:49:55','2020-06-28 14:49:55'),(42,49,13,'PINJAMAN YAYASAN',7000000.00,500000.00,6500000.00,'2020-06-28 14:49:55','2020-06-28 14:49:55'),(43,50,40,'PINJAMAN KOPERASI',10500000.00,1050000.00,9450000.00,'2020-06-28 15:05:26','2020-06-28 15:05:26'),(44,51,14,'PINJAMAN KOPERASI',3360000.00,840000.00,2520000.00,'2020-06-28 15:11:24','2020-06-28 15:11:24'),(45,51,15,'PINJAMAN YAYASAN',10000000.00,0.00,10000000.00,'2020-06-28 15:11:24','2020-06-28 15:11:24'),(46,53,16,'PINJAMAN KOPERASI',8400000.00,0.00,8400000.00,'2020-06-28 15:13:55','2020-06-28 15:13:55'),(47,54,17,'PINJAMAN KOPERASI',2520000.00,0.00,2520000.00,'2020-06-28 15:14:55','2020-06-28 15:14:55'),(48,55,18,'PINJAMAN KOPERASI',2835000.00,0.00,2835000.00,'2020-06-28 15:17:01','2020-06-28 15:17:01'),(49,56,19,'PINJAMAN KOPERASI',6720000.00,720000.00,6000000.00,'2020-06-28 15:18:14','2020-06-28 15:18:14'),(50,57,20,'PINJAMAN KOPERASI',525000.00,525000.00,0.00,'2020-06-28 15:19:19','2020-06-28 15:19:19'),(51,57,21,'PINJAMAN YAYASAN',8500000.00,250000.00,8250000.00,'2020-06-28 15:19:19','2020-06-28 15:19:19'),(52,61,22,'PINJAMAN KOPERASI',3150000.00,0.00,3150000.00,'2020-06-29 02:40:05','2020-06-29 02:40:05'),(53,61,23,'PINJAMAN YAYASAN',71000000.00,0.00,71000000.00,'2020-06-29 02:40:05','2020-06-29 02:40:05'),(54,61,41,'PINJAMAN KOPERASI',3780000.00,2080000.00,1700000.00,'2020-06-29 02:40:05','2020-06-29 02:40:05'),(55,65,24,'PINJAMAN KOPERASI',18900000.00,0.00,18900000.00,'2020-06-29 02:48:47','2020-06-29 02:48:47'),(56,67,25,'PINJAMAN KOPERASI',9450000.00,1575000.00,7875000.00,'2020-06-29 02:51:14','2020-06-29 02:51:14'),(57,67,26,'PINJAMAN YAYASAN',3000000.00,1000000.00,2000000.00,'2020-06-29 02:51:14','2020-06-29 02:51:14'),(58,68,27,'PINJAMAN KOPERASI',15750000.00,0.00,15750000.00,'2020-06-29 02:52:22','2020-06-29 02:52:22'),(59,68,28,'PINJAMAN YAYASAN',6000000.00,1500000.00,4500000.00,'2020-06-29 02:52:22','2020-06-29 02:52:22'),(60,69,29,'PINJAMAN KOPERASI',14700000.00,0.00,14700000.00,'2020-06-29 02:54:08','2020-06-29 02:54:08'),(61,69,30,'PINJAMAN YAYASAN',47500000.00,0.00,47500000.00,'2020-06-29 02:54:08','2020-06-29 02:54:08'),(63,71,32,'PINJAMAN KOPERASI',4200000.00,525000.00,3675000.00,'2020-06-29 03:08:30','2020-06-29 03:08:30'),(64,72,33,'PINJAMAN KOPERASI',5145000.00,735000.00,4410000.00,'2020-06-29 04:31:38','2020-06-29 04:31:38'),(65,73,34,'PINJAMAN KOPERASI',4725000.00,0.00,4725000.00,'2020-06-29 04:32:51','2020-06-29 04:32:51'),(66,73,35,'PINJAMAN YAYASAN',1650000.00,50000.00,1600000.00,'2020-06-29 04:32:51','2020-06-29 04:32:51'),(67,74,37,'PINJAMAN KOPERASI',4200000.00,0.00,4200000.00,'2020-06-29 04:33:46','2020-06-29 04:33:46'),(68,75,38,'PINJAMAN KOPERASI',4200000.00,0.00,4200000.00,'2020-06-29 04:34:25','2020-06-29 04:34:25'),(69,82,9,'PINJAMAN KOPERASI',8400000.00,1050000.00,7350000.00,'2020-07-28 13:26:49','2020-07-28 13:26:49'),(84,83,20,'PINJAMAN KOPERASI',525000.00,0.00,525000.00,'2020-07-28 13:43:33','2020-07-28 13:43:33'),(85,83,21,'PINJAMAN YAYASAN',8500000.00,500000.00,8000000.00,'2020-07-28 13:43:33','2020-07-28 13:43:33'),(86,84,11,'PINJAMAN KOPERASI',4725000.00,1575000.00,3150000.00,'2020-07-28 13:57:40','2020-07-28 13:57:40'),(87,85,10,'PINJAMAN KOPERASI',11550000.00,1575000.00,9975000.00,'2020-07-28 13:59:11','2020-07-28 13:59:11'),(88,86,14,'PINJAMAN KOPERASI',3360000.00,840000.00,2520000.00,'2020-07-28 14:01:00','2020-07-28 14:01:00'),(89,86,15,'PINJAMAN YAYASAN',10000000.00,0.00,10000000.00,'2020-07-28 14:01:00','2020-07-28 14:01:00'),(91,87,6,'PINJAMAN KOPERASI',14700000.00,0.00,14700000.00,'2020-07-28 14:03:50','2020-07-28 14:03:50'),(92,88,12,'PINJAMAN KOPERASI',12600000.00,1575000.00,11025000.00,'2020-07-29 13:59:57','2020-07-29 13:59:57'),(93,88,13,'PINJAMAN YAYASAN',7000000.00,500000.00,6500000.00,'2020-07-29 13:59:57','2020-07-29 13:59:57'),(94,89,40,'PINJAMAN KOPERASI',10500000.00,1050000.00,9450000.00,'2020-07-29 14:01:26','2020-07-29 14:01:26'),(95,91,16,'PINJAMAN KOPERASI',8400000.00,0.00,8400000.00,'2020-07-29 14:04:07','2020-07-29 14:04:07'),(96,92,17,'PINJAMAN KOPERASI',2520000.00,0.00,2520000.00,'2020-07-29 14:05:30','2020-07-29 14:05:30'),(97,93,20,'PINJAMAN KOPERASI',525000.00,0.00,525000.00,'2020-07-29 14:06:48','2020-07-29 14:06:48'),(98,93,21,'PINJAMAN YAYASAN',8500000.00,500000.00,8000000.00,'2020-07-29 14:06:48','2020-07-29 14:06:48'),(99,94,19,'PINJAMAN KOPERASI',6720000.00,550000.00,6170000.00,'2020-07-29 14:07:44','2020-07-29 14:07:44'),(100,95,18,'PINJAMAN KOPERASI',2835000.00,157500.00,2677500.00,'2020-07-29 14:08:45','2020-07-29 14:08:45'),(101,99,22,'PINJAMAN KOPERASI',3150000.00,1050000.00,2100000.00,'2020-07-29 14:24:07','2020-07-29 14:24:07'),(102,99,23,'PINJAMAN YAYASAN',71000000.00,0.00,71000000.00,'2020-07-29 14:24:07','2020-07-29 14:24:07'),(103,99,41,'PINJAMAN KOPERASI',3780000.00,0.00,3780000.00,'2020-07-29 14:24:07','2020-07-29 14:24:07'),(104,101,24,'PINJAMAN KOPERASI',18900000.00,2100000.00,16800000.00,'2020-07-29 14:43:36','2020-07-29 14:43:36'),(105,104,25,'PINJAMAN KOPERASI',9450000.00,1575000.00,7875000.00,'2020-07-29 14:46:40','2020-07-29 14:46:40'),(106,104,26,'PINJAMAN YAYASAN',3000000.00,1000000.00,2000000.00,'2020-07-29 14:46:40','2020-07-29 14:46:40'),(107,106,27,'PINJAMAN KOPERASI',15750000.00,0.00,15750000.00,'2020-07-29 14:49:55','2020-07-29 14:49:55'),(108,106,28,'PINJAMAN YAYASAN',6000000.00,0.00,6000000.00,'2020-07-29 14:49:55','2020-07-29 14:49:55'),(109,107,29,'PINJAMAN KOPERASI',14700000.00,0.00,14700000.00,'2020-07-29 14:51:20','2020-07-29 14:51:20'),(110,107,30,'PINJAMAN YAYASAN',47500000.00,0.00,47500000.00,'2020-07-29 14:51:20','2020-07-29 14:51:20'),(111,110,32,'PINJAMAN KOPERASI',4200000.00,525000.00,3675000.00,'2020-07-29 14:57:39','2020-07-29 14:57:39'),(112,111,33,'PINJAMAN KOPERASI',5145000.00,735000.00,4410000.00,'2020-07-29 15:08:27','2020-07-29 15:08:27'),(113,112,34,'PINJAMAN KOPERASI',4725000.00,262500.00,4462500.00,'2020-07-29 15:09:32','2020-07-29 15:09:32'),(114,112,35,'PINJAMAN YAYASAN',1650000.00,0.00,1650000.00,'2020-07-29 15:09:32','2020-07-29 15:09:32'),(115,113,37,'PINJAMAN KOPERASI',4200000.00,262500.00,3937500.00,'2020-07-29 15:10:46','2020-07-29 15:10:46'),(116,114,38,'PINJAMAN KOPERASI',4200000.00,262500.00,3937500.00,'2020-07-29 15:11:39','2020-07-29 15:11:39'),(117,119,9,'PINJAMAN KOPERASI',8400000.00,1050000.00,7350000.00,'2020-08-25 02:21:19','2020-08-25 02:21:19'),(118,121,10,'PINJAMAN KOPERASI',11550000.00,1575000.00,9975000.00,'2020-08-25 02:24:06','2020-08-25 02:24:06'),(119,122,14,'PINJAMAN KOPERASI',3360000.00,840000.00,2520000.00,'2020-08-25 02:25:20','2020-08-25 02:25:20'),(120,122,15,'PINJAMAN YAYASAN',10000000.00,0.00,10000000.00,'2020-08-25 02:25:20','2020-08-25 02:25:20'),(121,123,6,'PINJAMAN KOPERASI',14700000.00,0.00,14700000.00,'2020-08-25 02:27:48','2020-08-25 02:27:48'),(122,124,12,'PINJAMAN KOPERASI',12600000.00,1575000.00,11025000.00,'2020-08-25 02:29:33','2020-08-25 02:29:33'),(123,124,13,'PINJAMAN YAYASAN',7000000.00,500000.00,6500000.00,'2020-08-25 02:29:33','2020-08-25 02:29:33'),(124,125,40,'PINJAMAN KOPERASI',10500000.00,1050000.00,9450000.00,'2020-08-25 02:30:45','2020-08-25 02:30:45'),(125,126,42,'PINJAMAN KOPERASI',5250000.00,525000.00,4725000.00,'2020-08-25 02:35:18','2020-08-25 02:35:18'),(126,127,16,'PINJAMAN KOPERASI',8400000.00,0.00,8400000.00,'2020-08-25 02:36:20','2020-08-25 02:36:20'),(127,128,17,'PINJAMAN KOPERASI',2520000.00,0.00,2520000.00,'2020-08-25 02:37:16','2020-08-25 02:37:16'),(128,129,18,'PINJAMAN KOPERASI',2835000.00,157500.00,2677500.00,'2020-08-25 02:38:16','2020-08-25 02:38:16'),(129,132,21,'PINJAMAN YAYASAN',8500000.00,500000.00,8000000.00,'2020-08-25 02:41:03','2020-08-25 02:41:03'),(130,134,22,'PINJAMAN KOPERASI',3150000.00,0.00,3150000.00,'2020-08-25 03:24:13','2020-08-25 03:24:13'),(131,134,23,'PINJAMAN YAYASAN',71000000.00,1000000.00,70000000.00,'2020-08-25 03:24:13','2020-08-25 03:24:13'),(132,134,41,'PINJAMAN KOPERASI',3780000.00,0.00,3780000.00,'2020-08-25 03:24:13','2020-08-25 03:24:13'),(133,137,24,'PINJAMAN KOPERASI',18900000.00,2100000.00,16800000.00,'2020-08-25 03:27:25','2020-08-25 03:27:25'),(134,140,25,'PINJAMAN KOPERASI',9450000.00,3150000.00,6300000.00,'2020-08-25 03:29:49','2020-08-25 03:29:49'),(135,143,27,'PINJAMAN KOPERASI',15750000.00,0.00,15750000.00,'2020-08-25 03:33:08','2020-08-25 03:33:08'),(136,143,28,'PINJAMAN YAYASAN',6000000.00,1500000.00,4500000.00,'2020-08-25 03:33:08','2020-08-25 03:33:08'),(137,144,29,'PINJAMAN KOPERASI',14700000.00,0.00,14700000.00,'2020-08-25 03:34:24','2020-08-25 03:34:24'),(138,144,30,'PINJAMAN YAYASAN',47500000.00,0.00,47500000.00,'2020-08-25 03:34:24','2020-08-25 03:34:24'),(139,146,43,'PINJAMAN KOPERASI',4725000.00,525000.00,4200000.00,'2020-08-25 03:37:16','2020-10-24 19:04:13'),(140,147,32,'PINJAMAN KOPERASI',4200000.00,525000.00,3675000.00,'2020-08-25 03:43:47','2020-08-25 03:43:47'),(141,148,33,'PINJAMAN KOPERASI',5145000.00,735000.00,4410000.00,'2020-08-25 03:44:36','2020-08-25 03:44:36'),(142,149,34,'PINJAMAN KOPERASI',4725000.00,262500.00,4462500.00,'2020-08-25 03:45:37','2020-08-25 03:45:37'),(143,149,35,'PINJAMAN YAYASAN',1650000.00,0.00,1650000.00,'2020-08-25 03:45:37','2020-08-25 03:45:37'),(144,150,37,'PINJAMAN KOPERASI',4200000.00,262500.00,3937500.00,'2020-08-25 03:46:33','2020-08-25 03:46:33'),(145,151,38,'PINJAMAN KOPERASI',4200000.00,262500.00,3937500.00,'2020-08-25 03:47:19','2020-08-25 03:47:19'),(146,154,20,'PINJAMAN KOPERASI',525000.00,0.00,525000.00,'2020-10-10 08:09:59','2020-10-10 08:09:59'),(147,154,21,'PINJAMAN YAYASAN',8500000.00,500000.00,8000000.00,'2020-10-10 08:09:59','2020-10-10 08:09:59'),(149,155,18,'PINJAMAN KOPERASI',2835000.00,157500.00,2677500.00,'2020-10-10 08:13:12','2020-10-10 08:13:12'),(150,156,17,'PINJAMAN KOPERASI',2520000.00,0.00,2520000.00,'2020-10-10 08:26:42','2020-10-10 08:26:42'),(151,157,16,'PINJAMAN KOPERASI',8400000.00,0.00,8400000.00,'2020-10-10 08:27:49','2020-10-10 08:27:49'),(152,158,42,'PINJAMAN KOPERASI',5250000.00,525000.00,4725000.00,'2020-10-10 08:29:01','2020-10-10 08:29:01'),(153,159,40,'PINJAMAN KOPERASI',10500000.00,1050000.00,9450000.00,'2020-10-10 08:30:13','2020-10-10 08:30:13'),(154,160,12,'PINJAMAN KOPERASI',12600000.00,1575000.00,11025000.00,'2020-10-10 08:31:17','2020-10-10 08:31:17'),(155,160,13,'PINJAMAN YAYASAN',7000000.00,500000.00,6500000.00,'2020-10-10 08:31:17','2020-10-10 08:31:17'),(156,161,6,'PINJAMAN KOPERASI',14700000.00,0.00,14700000.00,'2020-10-10 08:32:19','2020-10-10 08:32:19'),(157,162,14,'PINJAMAN KOPERASI',3360000.00,840000.00,2520000.00,'2020-10-10 08:33:35','2020-10-10 08:33:35'),(158,162,15,'PINJAMAN YAYASAN',10000000.00,0.00,10000000.00,'2020-10-10 08:33:35','2020-10-10 08:33:35'),(159,163,10,'PINJAMAN KOPERASI',11550000.00,0.00,11550000.00,'2020-10-10 08:34:38','2020-10-10 08:34:38'),(160,164,11,'PINJAMAN KOPERASI',4725000.00,0.00,4725000.00,'2020-10-10 08:36:42','2020-10-10 08:36:42'),(161,165,9,'PINJAMAN KOPERASI',8400000.00,1050000.00,7350000.00,'2020-10-10 08:37:33','2020-10-10 08:37:33'),(162,173,22,'PINJAMAN KOPERASI',3150000.00,0.00,3150000.00,'2020-10-10 08:45:19','2020-10-10 08:45:19'),(163,173,23,'PINJAMAN YAYASAN',71000000.00,1000000.00,70000000.00,'2020-10-10 08:45:19','2020-10-10 08:45:19'),(164,173,41,'PINJAMAN KOPERASI',3780000.00,0.00,3780000.00,'2020-10-10 08:45:19','2020-10-10 08:45:19'),(165,175,24,'PINJAMAN KOPERASI',18900000.00,2100000.00,16800000.00,'2020-10-10 08:56:13','2020-10-10 08:56:13'),(166,178,25,'PINJAMAN KOPERASI',9450000.00,2100000.00,7350000.00,'2020-10-10 08:59:14','2020-10-10 08:59:14'),(167,178,26,'PINJAMAN YAYASAN',3000000.00,0.00,3000000.00,'2020-10-10 08:59:14','2020-10-10 08:59:14'),(168,180,27,'PINJAMAN KOPERASI',15750000.00,0.00,15750000.00,'2020-10-10 09:01:24','2020-10-10 09:01:24'),(169,180,28,'PINJAMAN YAYASAN',6000000.00,1500000.00,4500000.00,'2020-10-10 09:01:24','2020-10-10 09:01:24'),(170,181,29,'PINJAMAN KOPERASI',14700000.00,0.00,14700000.00,'2020-10-10 09:02:22','2020-10-10 09:02:22'),(171,181,30,'PINJAMAN YAYASAN',47500000.00,0.00,47500000.00,'2020-10-10 09:02:22','2020-10-10 09:02:22'),(172,183,43,'PINJAMAN KOPERASI',5250000.00,525000.00,4725000.00,'2020-10-10 09:04:20','2020-10-10 09:04:20'),(173,184,34,'PINJAMAN KOPERASI',4725000.00,262500.00,4462500.00,'2020-10-10 09:06:00','2020-10-10 09:06:00'),(174,184,35,'PINJAMAN YAYASAN',1650000.00,0.00,1650000.00,'2020-10-10 09:06:00','2020-10-10 09:06:00'),(176,185,37,'PINJAMAN KOPERASI',4200000.00,262500.00,3937500.00,'2020-10-10 09:08:40','2020-10-10 09:08:40'),(177,186,38,'PINJAMAN KOPERASI',4200000.00,262500.00,3937500.00,'2020-10-10 09:09:29','2020-10-10 09:09:29'),(178,187,32,'PINJAMAN KOPERASI',4200000.00,525000.00,3675000.00,'2020-10-10 09:12:13','2020-10-10 09:12:13'),(179,188,33,'PINJAMAN KOPERASI',5145000.00,735000.00,4410000.00,'2020-10-10 09:13:08','2020-10-10 09:13:08');
/*!40000 ALTER TABLE `tb_pembayaran_gaji_pinjaman` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-12-07 11:34:44
