-- Dumping data for table `jurnal_gaji_detail`
--

INSERT INTO `jurnal_gaji_detail` VALUES (57,22,65,'R','2025-01-15 14:33:17',3,'2025-01-15 07:33:17',NULL,'N','2025-01-15 14:33:17',3),(58,22,66,'B','2025-01-15 14:33:17',3,'2025-01-15 07:33:17',NULL,'N','2025-01-15 14:33:17',3),(59,22,67,'B','2025-01-15 14:33:17',3,'2025-01-15 07:33:17',NULL,'N','2025-01-15 14:33:17',3),(60,22,68,'B','2025-01-15 14:33:17',3,'2025-01-15 07:33:17',NULL,'N','2025-01-15 14:33:17',3),(61,22,69,'B','2025-01-15 14:33:17',3,'2025-01-15 07:33:17',NULL,'N','2025-01-15 14:33:17',3),(62,23,70,'R','2025-01-15 16:50:10',3,'2025-01-15 09:50:10',NULL,'N','2025-01-15 16:50:10',340),(63,23,71,'B','2025-01-15 16:50:10',3,'2025-01-15 09:50:10',NULL,'N','2025-01-15 16:50:10',340),(64,23,72,'B','2025-01-15 16:50:10',3,'2025-01-15 09:50:10',NULL,'N','2025-01-15 16:50:10',340),(65,23,73,'B','2025-01-15 16:50:10',3,'2025-01-15 09:50:10',NULL,'N','2025-01-15 16:50:10',340),(66,23,74,'B','2025-01-15 16:50:10',3,'2025-01-15 09:50:10',NULL,'N','2025-01-15 16:50:10',340),(67,24,75,'R','2025-01-15 16:57:12',3,'2025-01-15 09:57:12',NULL,'N','2025-01-15 16:57:12',340),(68,24,76,'B','2025-01-15 16:57:12',3,'2025-01-15 09:57:12',NULL,'N','2025-01-15 16:57:12',340),(69,24,77,'B','2025-01-15 16:57:12',3,'2025-01-15 09:57:12',NULL,'N','2025-01-15 16:57:12',340),(70,24,78,'B','2025-01-15 16:57:12',3,'2025-01-15 09:57:12',NULL,'N','2025-01-15 16:57:12',340),(71,24,79,'B','2025-01-15 16:57:12',3,'2025-01-15 09:57:12',NULL,'N','2025-01-15 16:57:12',340),(73,26,86,'R','2025-01-16 14:09:10',3,'2025-01-16 07:09:10',NULL,'Y','2025-01-16 14:09:10',NULL),(74,26,87,'B','2025-01-16 14:09:10',3,'2025-01-16 07:09:10',NULL,'Y','2025-01-16 14:09:10',NULL),(75,26,88,'B','2025-01-16 14:09:10',3,'2025-01-16 07:09:10',NULL,'Y','2025-01-16 14:09:10',NULL),(76,26,89,'B','2025-01-16 14:09:10',3,'2025-01-16 07:09:10',NULL,'Y','2025-01-16 14:09:10',NULL),(77,26,90,'B','2025-01-16 14:09:10',3,'2025-01-16 07:09:10',NULL,'Y','2025-01-16 14:09:10',NULL),(78,27,91,'R','2025-01-16 14:55:26',3,'2025-01-16 07:55:26',NULL,'Y','2025-01-16 14:55:26',NULL),(79,27,92,'B','2025-01-16 14:55:26',3,'2025-01-16 07:55:26',NULL,'Y','2025-01-16 14:55:26',NULL),(80,27,93,'B','2025-01-16 14:55:26',3,'2025-01-16 07:55:26',NULL,'Y','2025-01-16 14:55:26',NULL),(81,27,94,'B','2025-01-16 14:55:26',3,'2025-01-16 07:55:26',NULL,'Y','2025-01-16 14:55:26',NULL),(82,27,95,'B','2025-01-16 14:55:26',3,'2025-01-16 07:55:26',NULL,'Y','2025-01-16 14:55:26',NULL),(83,28,97,'R','2025-01-16 15:06:11',3,'2025-01-16 08:06:11',NULL,'Y','2025-01-16 15:06:11',NULL),(84,28,98,'B','2025-01-16 15:06:11',3,'2025-01-16 08:06:11',NULL,'Y','2025-01-16 15:06:11',NULL),(85,28,99,'B','2025-01-16 15:06:11',3,'2025-01-16 08:06:11',NULL,'Y','2025-01-16 15:06:11',NULL),(86,28,100,'B','2025-01-16 15:06:11',3,'2025-01-16 08:06:11',NULL,'Y','2025-01-16 15:06:11',NULL),(87,28,101,'B','2025-01-16 15:06:11',3,'2025-01-16 08:06:11',NULL,'Y','2025-01-16 15:06:11',NULL),(88,29,103,'R','2025-01-16 16:45:00',340,'2025-01-16 09:45:00',NULL,'Y','2025-01-16 16:45:00',NULL),(89,29,104,'B','2025-01-16 16:45:00',340,'2025-01-16 09:45:00',NULL,'Y','2025-01-16 16:45:00',NULL),(90,29,105,'B','2025-01-16 16:45:00',340,'2025-01-16 09:45:00',NULL,'Y','2025-01-16 16:45:00',NULL),(91,29,106,'B','2025-01-16 16:45:00',340,'2025-01-16 09:45:00',NULL,'Y','2025-01-16 16:45:00',NULL),(92,29,107,'B','2025-01-16 16:45:00',340,'2025-01-16 09:45:00',NULL,'Y','2025-01-16 16:45:00',NULL),(93,30,108,'R','2025-01-17 09:39:19',340,'2025-01-17 02:39:19',NULL,'Y','2025-01-17 09:39:19',NULL),(94,30,109,'B','2025-01-17 09:39:19',340,'2025-01-17 02:39:19',NULL,'Y','2025-01-17 09:39:19',NULL),(95,30,110,'B','2025-01-17 09:39:19',340,'2025-01-17 02:39:19',NULL,'Y','2025-01-17 09:39:19',NULL),(96,30,111,'B','2025-01-17 09:39:19',340,'2025-01-17 02:39:19',NULL,'Y','2025-01-17 09:39:19',NULL),(97,30,112,'B','2025-01-17 09:39:19',340,'2025-01-17 02:39:19',NULL,'Y','2025-01-17 09:39:19',NULL),(98,31,113,'R','2025-01-17 09:55:40',340,'2025-01-17 02:55:40',NULL,'Y','2025-01-17 09:55:40',NULL),(99,31,114,'B','2025-01-17 09:55:40',340,'2025-01-17 02:55:40',NULL,'Y','2025-01-17 09:55:40',NULL),(100,31,115,'B','2025-01-17 09:55:40',340,'2025-01-17 02:55:40',NULL,'Y','2025-01-17 09:55:40',NULL),(101,31,116,'B','2025-01-17 09:55:40',340,'2025-01-17 02:55:40',NULL,'Y','2025-01-17 09:55:40',NULL),(102,31,117,'B','2025-01-17 09:55:40',340,'2025-01-17 02:55:40',NULL,'Y','2025-01-17 09:55:40',NULL),(103,32,118,'R','2025-01-17 10:00:08',340,'2025-01-17 03:00:08',NULL,'Y','2025-01-17 10:00:08',NULL),(104,32,119,'B','2025-01-17 10:00:08',340,'2025-01-17 03:00:08',NULL,'Y','2025-01-17 10:00:08',NULL),(105,32,120,'B','2025-01-17 10:00:08',340,'2025-01-17 03:00:08',NULL,'Y','2025-01-17 10:00:08',NULL),(106,32,121,'B','2025-01-17 10:00:08',340,'2025-01-17 03:00:08',NULL,'Y','2025-01-17 10:00:08',NULL),(107,32,122,'B','2025-01-17 10:00:08',340,'2025-01-17 03:00:08',NULL,'Y','2025-01-17 10:00:08',NULL),(108,33,123,'R','2025-01-17 10:01:50',340,'2025-01-17 03:01:50',NULL,'Y','2025-01-17 10:01:50',NULL),(109,33,124,'B','2025-01-17 10:01:50',340,'2025-01-17 03:01:50',NULL,'Y','2025-01-17 10:01:50',NULL),(110,33,125,'B','2025-01-17 10:01:50',340,'2025-01-17 03:01:50',NULL,'Y','2025-01-17 10:01:50',NULL),(111,33,126,'B','2025-01-17 10:01:50',340,'2025-01-17 03:01:50',NULL,'Y','2025-01-17 10:01:50',NULL),(112,33,127,'B','2025-01-17 10:01:50',340,'2025-01-17 03:01:50',NULL,'Y','2025-01-17 10:01:50',NULL),(113,34,128,'R','2025-01-17 10:13:49',340,'2025-01-17 03:13:49',NULL,'Y','2025-01-17 10:13:49',NULL),(114,34,129,'B','2025-01-17 10:13:49',340,'2025-01-17 03:13:49',NULL,'Y','2025-01-17 10:13:49',NULL),(115,34,130,'B','2025-01-17 10:13:49',340,'2025-01-17 03:13:49',NULL,'Y','2025-01-17 10:13:49',NULL),(116,34,131,'B','2025-01-17 10:13:49',340,'2025-01-17 03:13:49',NULL,'Y','2025-01-17 10:13:49',NULL),(117,34,132,'B','2025-01-17 10:13:49',340,'2025-01-17 03:13:49',NULL,'Y','2025-01-17 10:13:49',NULL);

--
-- Table structure for table `jurnal_gaji_header`
--

CREATE TABLE `jurnal_gaji_header` (
  `JurnalGajiHeaderID` int(11) NOT NULL AUTO_INCREMENT,
  `JurnalGajiHeaderBranchPercentID` int(11) NOT NULL,
  `JurnalGajiHeaderCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `JurnalGajiHeaderCreatedUserID` int(11) NOT NULL,
  `JurnalGajiHeaderUpdated` timestamp NOT NULL DEFAULT current_timestamp(),
  `JurnalGajiHeaderUpdatedUserID` int(11) DEFAULT NULL,
  `JurnalGajiHeaderIsActive` char(1) NOT NULL DEFAULT 'Y',
  `JurnalGajiHeaderDeleted` int(11) DEFAULT NULL,
  `JurnalGajiHeaderDeletedUserID` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`JurnalGajiHeaderID`),
  KEY `JurnalGajiHeaderIsActive` (`JurnalGajiHeaderIsActive`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jurnal_gaji_header`
--

INSERT INTO `jurnal_gaji_header` VALUES (22,1,'2025-01-15 14:33:17',3,'2025-01-15 07:33:17',NULL,'N',NULL,'0000-00-00 00:00:00'),(23,1,'2025-01-15 16:50:10',3,'2025-01-15 09:50:10',NULL,'N',NULL,'0000-00-00 00:00:00'),(24,1,'2025-01-15 16:57:12',3,'2025-01-15 09:57:12',NULL,'N',NULL,'0000-00-00 00:00:00'),(26,1,'2025-01-16 14:09:10',3,'2025-01-16 07:09:10',NULL,'Y',NULL,'2025-01-16 14:09:10'),(27,1,'2025-01-16 14:55:26',3,'2025-01-16 07:55:26',NULL,'Y',NULL,'2025-01-16 14:55:26'),(28,3,'2025-01-16 15:06:11',3,'2025-01-16 08:06:11',NULL,'Y',NULL,'2025-01-16 15:06:11'),(29,1,'2025-01-16 16:45:00',340,'2025-01-16 09:45:00',NULL,'Y',NULL,'2025-01-16 16:45:00'),(30,1,'2025-01-17 09:39:19',340,'2025-01-17 02:39:19',NULL,'Y',NULL,'2025-01-17 09:39:19'),(31,1,'2025-01-17 09:55:40',340,'2025-01-17 02:55:40',NULL,'Y',NULL,'2025-01-17 09:55:40'),(32,1,'2025-01-17 10:00:08',340,'2025-01-17 03:00:08',NULL,'Y',NULL,'2025-01-17 10:00:08'),(33,1,'2025-01-17 10:01:50',340,'2025-01-17 03:01:50',NULL,'Y',NULL,'2025-01-17 10:01:50'),(34,1,'2025-01-17 10:13:49',340,'2025-01-17 03:13:49',NULL,'Y',NULL,'2025-01-17 10:13:49');

--
-- Table structure for table `jurnal_tx`
--

CREATE TABLE `jurnal_tx` (
  `jurnalTxID` int(11) NOT NULL AUTO_INCREMENT,
  `jurnalTxJurnalID` int(11) DEFAULT NULL,
  `jurnalTxCoaID` int(11) DEFAULT NULL,
  `jurnalTxDescription` varchar(300) DEFAULT NULL,
  `jurnalTxDebit` decimal(20,2) DEFAULT 0.00,
  `jurnalTxCredit` decimal(20,2) DEFAULT 0.00,
  `jurnalTxIsActive` varchar(1) DEFAULT 'Y',
  `jurnalTxCreated` datetime DEFAULT current_timestamp(),
  `jurnalTxLastUpdated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `jurnalTxM_UserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`jurnalTxID`),
  KEY `jurnalTxJurnalID` (`jurnalTxJurnalID`),
  KEY `jurnalTxCoaID` (`jurnalTxCoaID`),
  KEY `jurnalTxIsActive` (`jurnalTxIsActive`)
) ENGINE=InnoDB AUTO_INCREMENT=406 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jurnal_tx`
--

INSERT INTO `jurnal_tx` VALUES (1,6,873,'B. GAJI TEHNIS - CABANG',300000000.00,0.00,'Y','2025-01-09 10:58:49','2025-01-09 10:58:49',3),(2,6,29,'BCA PT PRAMITTA (5060)',0.00,50000000.00,'Y','2025-01-09 10:58:49','2025-01-09 10:58:49',3),(3,6,30,'BCA PT PRAMITA (3291)',0.00,150000000.00,'Y','2025-01-09 10:58:49','2025-01-09 10:58:49',3),(4,6,31,'CIMB NIAGA PT PRAMITA (8200)',0.00,100000000.00,'Y','2025-01-09 10:58:49','2025-01-09 10:58:49',3),(39,7,9,'BCA PT PRAMITA (4338)',5000.00,0.00,'Y','2025-01-09 16:27:24','2025-01-09 16:27:24',345),(40,7,9,'BCA PT PRAMITA (4338)',5000.00,0.00,'Y','2025-01-09 16:27:24','2025-01-09 16:27:24',345),(41,7,9,'BCA PT PRAMITA (4338)',0.00,100000.00,'Y','2025-01-09 16:27:24','2025-01-09 16:27:24',345),(42,10,882,'B. GAJI TEHNIS - REGIONAL',50000000.00,0.00,'Y','2025-01-10 16:16:54','2025-01-10 16:16:54',3),(43,10,29,'BCA PT PRAMITTA (5060)',0.00,50000000.00,'Y','2025-01-10 16:16:54','2025-01-10 16:16:54',3),(44,11,882,'B. GAJI TEHNIS - REGIONAL',25000000.00,0.00,'Y','2025-01-10 16:16:54','2025-01-10 16:16:54',3),(45,11,40,'BCA PT PRAMITA (7717)',0.00,25000000.00,'Y','2025-01-10 16:16:54','2025-01-10 16:16:54',3),(46,12,882,'B. GAJI TEHNIS - REGIONAL',25000000.00,0.00,'Y','2025-01-10 16:16:54','2025-01-10 16:16:54',3),(47,12,79,'BCA PT PRAMITA (2121)',0.00,25000000.00,'Y','2025-01-10 16:16:54','2025-01-10 16:16:54',3),(48,13,343,'PERSEDIAAN HEMATOLOGI',10000000.00,0.00,'Y','2025-01-10 17:04:42','2025-01-10 17:04:42',3),(49,13,344,'PERSEDIAAN URINALISIS',10000000.00,0.00,'Y','2025-01-10 17:04:42','2025-01-10 17:04:42',3),(50,13,345,'PERSEDIAAN FAECES & PARASITOLOGI',10000000.00,0.00,'Y','2025-01-10 17:04:42','2025-01-10 17:04:42',3),(51,13,346,'PERSEDIAAN ANALISA KLINIK RUTIN',10000000.00,0.00,'Y','2025-01-10 17:04:42','2025-01-10 17:04:42',3),(52,13,347,'PERSEDIAAN KIMIA KLINIK',10000000.00,0.00,'Y','2025-01-10 17:04:42','2025-01-10 17:04:42',3),(53,13,1383,'GRN BLM DITAGIH',0.00,50000000.00,'Y','2025-01-10 17:04:42','2025-01-10 17:04:42',3),(54,14,9,'BCA PT PRAMITA (4338)',75000.00,0.00,'Y','2025-01-13 10:49:53','2025-01-13 10:49:53',345),(55,14,10,'MANDIRI PT PRAMITA (0156)',0.00,75000.00,'Y','2025-01-13 10:49:53','2025-01-13 10:49:53',345),(56,15,347,'PERSEDIAAN KIMIA KLINIK',5000000.00,0.00,'Y','2025-01-13 11:11:10','2025-01-13 11:11:10',345),(57,15,347,'PERSEDIAAN KIMIA KLINIK',5000000.00,0.00,'Y','2025-01-13 11:11:10','2025-01-13 11:11:10',345),(58,15,9,'BCA PT PRAMITA (4338)',0.00,10000000.00,'Y','2025-01-13 11:11:10','2025-01-13 11:11:10',345),(63,18,285,'KASBON JPA DOKTER - BANDUNG',500.00,0.00,'Y','2025-01-13 13:44:07','2025-01-13 13:44:07',345),(64,18,229,'KASBON KEGIATAN - KANTOR PUSAT',600.00,0.00,'Y','2025-01-13 13:44:07','2025-01-13 13:44:07',345),(65,18,1383,'GRN BLM DITAGIH',0.00,1100.00,'Y','2025-01-13 13:44:07','2025-01-13 13:44:07',345),(66,19,1383,'GRN BLM DITAGIH',0.00,100.00,'N','2025-01-13 16:03:49','2025-01-14 14:38:31',345),(67,19,2,'ASET LANCAR',100.00,0.00,'N','2025-01-13 16:03:49','2025-01-14 14:38:31',345),(68,20,1383,'GRN BLM DITAGIH',0.00,100.00,'Y','2025-01-13 16:05:18','2025-01-13 16:05:18',345),(69,20,1,'ASET LANCAR',100.00,0.00,'Y','2025-01-13 16:05:18','2025-01-13 16:05:18',345),(70,21,9,'BCA PT PRAMITA (4338)',5000.00,0.00,'N','2025-01-14 10:36:36','2025-01-14 10:37:17',345),(71,21,9,'BCA PT PRAMITA (4338)',5000.00,0.00,'N','2025-01-14 10:36:36','2025-01-14 10:37:17',345),(72,21,9,'BCA PT PRAMITA (4338)',0.00,100000.00,'N','2025-01-14 10:36:36','2025-01-14 10:37:17',345),(73,22,9,'BCA PT PRAMITA (4338)',5000.00,0.00,'Y','2025-01-14 10:40:39','2025-01-14 10:40:39',345),(74,22,9,'BCA PT PRAMITA (4338)',5000.00,0.00,'Y','2025-01-14 10:40:39','2025-01-14 10:40:39',345),(75,22,9,'BCA PT PRAMITA (4338)',0.00,10000.00,'Y','2025-01-14 10:40:39','2025-01-15 11:17:47',345),(81,19,2,'ASET LANCAR',200.00,0.00,'N','2025-01-14 14:36:22','2025-01-14 14:42:04',345),(82,19,1383,'GRN BLM DITAGIH',0.00,200.00,'N','2025-01-14 14:36:22','2025-01-14 14:42:04',345),(83,19,2,'ASET LANCAR',300.00,0.00,'N','2025-01-14 14:41:24','2025-01-14 14:42:04',345),(84,19,1383,'GRN BLM DITAGIH',0.00,300.00,'N','2025-01-14 14:41:24','2025-01-14 14:42:04',345),(85,19,2,'ASET LANCAR',400.00,0.00,'N','2025-01-14 14:42:04','2025-01-15 11:40:44',345),(86,19,1383,'GRN BLM DITAGIH',0.00,400.00,'N','2025-01-14 14:42:04','2025-01-15 11:40:44',345),(92,33,10,'MANDIRI PT PRAMITA (0156)',0.00,15000000.00,'Y','2025-01-14 16:00:53','2025-01-14 16:00:53',345),(93,33,346,'PERSEDIAAN ANALISA KLINIK RUTIN',7500000.00,0.00,'Y','2025-01-14 16:00:53','2025-01-14 16:00:53',345),(94,33,344,'PERSEDIAAN URINALISIS',7500000.00,0.00,'Y','2025-01-14 16:00:53','2025-01-14 16:00:53',345),(95,34,10,'MANDIRI PT PRAMITA (0156)',0.00,15000000.00,'N','2025-01-14 16:02:18','2025-01-15 08:50:07',345),(96,34,344,'PERSEDIAAN URINALISIS',7500000.00,0.00,'N','2025-01-14 16:02:18','2025-01-15 08:50:07',345),(97,34,345,'PERSEDIAAN FAECES & PARASITOLOGI',7500000.00,0.00,'N','2025-01-14 16:02:18','2025-01-15 08:50:07',345),(98,35,10,'MANDIRI PT PRAMITA (0156)',0.00,15000000.00,'Y','2025-01-14 16:05:58','2025-01-14 16:05:58',345),(99,35,348,'PERSEDIAAN IMMUNOLOGI',5000000.00,0.00,'N','2025-01-14 16:05:58','2025-01-14 16:09:55',345),(100,35,337,'PEMAKAIAN PERSEDIAAN BERSAMA',10000000.00,0.00,'N','2025-01-14 16:05:58','2025-01-14 16:09:55',345),(101,35,344,'PERSEDIAAN URINALISIS',5000000.00,0.00,'Y','2025-01-14 16:09:55','2025-01-14 16:09:55',345),(102,35,345,'PERSEDIAAN FAECES & PARASITOLOGI',10000000.00,0.00,'Y','2025-01-14 16:09:55','2025-01-14 16:09:55',345),(103,36,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'Y','2025-01-15 09:27:57','2025-01-15 09:27:57',345),(104,36,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'Y','2025-01-15 09:27:57','2025-01-15 09:27:57',345),(105,36,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'Y','2025-01-15 09:27:57','2025-01-15 09:27:57',345),(124,19,2,'ASET LANCAR',1234.00,0.00,'Y','2025-01-15 11:40:44','2025-01-15 11:40:44',345),(125,19,1383,'GRN BLM DITAGIH',0.00,1234.00,'Y','2025-01-15 11:40:44','2025-01-15 11:40:44',345),(153,65,6,'BANK',0.00,100000000.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(154,65,678,'R/K CAB. MATRAMAN - KEUANGAN',25000000.00,0.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(155,65,664,'R/K CAB. MARTADINATA - KEUANGAN',30000000.00,0.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(156,65,706,'R/K CAB. TOHA - KEUANGAN',25000000.00,0.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(157,65,741,'R/K CAB. PADJAJARAN - KEUANGAN',20000000.00,0.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(158,66,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000000.00,0.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(159,66,93,'BCA PT PRAMITA (0460)',0.00,25000000.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(160,67,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',30000000.00,0.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(161,67,15,'BNI PT PRAMITA (3214)',0.00,30000000.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(162,68,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000000.00,0.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(163,68,45,'BCA PT PRAMITA (0472)',0.00,25000000.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(164,69,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',20000000.00,0.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(165,69,60,'BCA PT PRAMITA (4554)',0.00,20000000.00,'N','2025-01-15 14:33:17','2025-01-17 11:33:00',3),(166,70,6,'BANK',0.00,100000000.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(167,70,678,'R/K CAB. MATRAMAN - KEUANGAN',25000000.00,0.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(168,70,664,'R/K CAB. MARTADINATA - KEUANGAN',30000000.00,0.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(169,70,706,'R/K CAB. TOHA - KEUANGAN',25000000.00,0.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(170,70,741,'R/K CAB. PADJAJARAN - KEUANGAN',20000000.00,0.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(171,71,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000000.00,0.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(172,71,93,'BCA PT PRAMITA (0460)',0.00,20000000.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(173,71,94,'BNI SYARIAH PT PRAMITA (2501)',0.00,5000000.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(174,72,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',30000000.00,0.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(175,72,15,'BNI PT PRAMITA (3214)',0.00,15000000.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(176,72,16,'MANDIRI PT PRAMITA (2284)',0.00,15000000.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(177,73,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000000.00,0.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(178,73,46,'MANDIRI PT PRAMITA (6076)',0.00,25000000.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(179,74,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',20000000.00,0.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(180,74,61,'MANDIRI PT PRAMITA (8608)',0.00,20000000.00,'N','2025-01-15 16:50:10','2025-01-17 11:41:48',340),(181,75,6,'BANK',0.00,100000.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(182,75,678,'R/K CAB. MATRAMAN - KEUANGAN',25000.00,0.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(183,75,664,'R/K CAB. MARTADINATA - KEUANGAN',30000.00,0.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(184,75,706,'R/K CAB. TOHA - KEUANGAN',25000.00,0.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(185,75,741,'R/K CAB. PADJAJARAN - KEUANGAN',20000.00,0.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(186,76,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(187,76,93,'BCA PT PRAMITA (0460)',0.00,25000.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(188,77,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',30000.00,0.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(189,77,17,'BRI PT PRAMITA (0305)',0.00,30000.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(190,78,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(191,78,45,'BCA PT PRAMITA (0472)',0.00,25000.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(192,79,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',20000.00,0.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(193,79,60,'BCA PT PRAMITA (4554)',0.00,20000.00,'N','2025-01-15 16:57:12','2025-01-17 11:42:17',340),(194,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 08:57:25','2025-01-16 09:13:12',345),(195,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 08:57:25','2025-01-16 09:13:12',345),(196,80,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'N','2025-01-16 08:57:25','2025-01-16 09:13:12',345),(197,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:13:12','2025-01-16 09:14:01',345),(198,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:13:12','2025-01-16 09:14:01',345),(199,80,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'N','2025-01-16 09:13:12','2025-01-16 09:14:01',345),(200,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:14:01','2025-01-16 09:20:21',345),(201,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:14:01','2025-01-16 09:20:21',345),(202,80,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'N','2025-01-16 09:14:01','2025-01-16 09:20:21',345),(203,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:20:21','2025-01-16 09:21:47',345),(204,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:20:21','2025-01-16 09:21:47',345),(205,80,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'N','2025-01-16 09:20:21','2025-01-16 09:21:47',345),(206,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:21:47','2025-01-16 09:22:04',345),(207,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:21:47','2025-01-16 09:22:04',345),(208,80,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'N','2025-01-16 09:21:47','2025-01-16 09:22:04',345),(209,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:22:04','2025-01-16 09:24:25',345),(210,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:22:04','2025-01-16 09:24:25',345),(211,80,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'N','2025-01-16 09:22:04','2025-01-16 09:24:25',345),(212,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:24:25','2025-01-16 09:24:37',345),(213,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:24:25','2025-01-16 09:24:37',345),(214,80,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'N','2025-01-16 09:24:25','2025-01-16 09:24:37',345),(215,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:24:37','2025-01-16 09:27:50',345),(216,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:24:37','2025-01-16 09:27:50',345),(217,80,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'N','2025-01-16 09:24:37','2025-01-16 09:27:50',345),(218,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:27:50','2025-01-16 09:29:37',345),(219,80,1383,'GRN BLM DITAGIH',0.00,2000.00,'N','2025-01-16 09:27:50','2025-01-16 09:29:37',345),(220,80,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:29:37','2025-01-16 09:31:03',345),(221,80,1383,'GRN BLM DITAGIH',0.00,2000.00,'N','2025-01-16 09:29:37','2025-01-16 09:31:03',345),(222,81,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:37:18','2025-01-16 09:37:50',345),(223,81,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:37:18','2025-01-16 09:37:50',345),(224,81,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'N','2025-01-16 09:37:18','2025-01-16 09:37:50',345),(225,81,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:37:50','2025-01-16 09:41:18',345),(226,81,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:37:50','2025-01-16 09:41:18',345),(227,81,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'N','2025-01-16 09:37:50','2025-01-16 09:41:18',345),(228,82,337,'PEMAKAIAN PERSEDIAAN BERSAMA',50000.00,0.00,'N','2025-01-16 09:39:06','2025-01-16 16:14:19',345),(229,82,13,'BCA PT PRAMITA (4334)',0.00,50000.00,'N','2025-01-16 09:39:06','2025-01-16 16:14:19',345),(230,81,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:41:18','2025-01-16 09:44:08',345),(231,81,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'N','2025-01-16 09:41:18','2025-01-16 09:44:08',345),(232,81,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'N','2025-01-16 09:41:18','2025-01-16 09:44:08',345),(233,81,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'Y','2025-01-16 09:44:08','2025-01-16 09:44:08',345),(234,81,9,'BCA PT PRAMITA (4338)',2000.00,0.00,'Y','2025-01-16 09:44:08','2025-01-16 09:44:08',345),(235,81,9,'BCA PT PRAMITA (4338)',0.00,4000.00,'Y','2025-01-16 09:44:08','2025-01-16 09:44:08',345),(236,83,3,'KAS DAN SETARA KAS',10000000.00,0.00,'N','2025-01-16 14:03:28','2025-01-16 14:13:52',345),(237,83,1383,'GRN BLM DITAGIH',0.00,10000000.00,'N','2025-01-16 14:03:28','2025-01-16 14:13:52',345),(238,84,2,'ASET LANCAR',100.00,0.00,'N','2025-01-16 14:05:39','2025-01-16 14:06:35',345),(239,84,2,'ASET LANCAR',0.00,100.00,'N','2025-01-16 14:05:39','2025-01-16 14:06:35',345),(241,86,6,'BANK',0.00,100000000.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(242,86,678,'R/K CAB. MATRAMAN - KEUANGAN',25000000.00,0.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(243,86,664,'R/K CAB. MARTADINATA - KEUANGAN',30000000.00,0.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(244,86,706,'R/K CAB. TOHA - KEUANGAN',25000000.00,0.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(245,86,741,'R/K CAB. PADJAJARAN - KEUANGAN',20000000.00,0.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(246,87,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000000.00,0.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(247,87,93,'BCA PT PRAMITA (0460)',0.00,25000000.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(248,88,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',30000000.00,0.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(249,88,15,'BNI PT PRAMITA (3214)',0.00,30000000.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(250,89,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000000.00,0.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(251,89,45,'BCA PT PRAMITA (0472)',0.00,25000000.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(252,90,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',20000000.00,0.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(253,90,60,'BCA PT PRAMITA (4554)',0.00,20000000.00,'Y','2025-01-16 14:09:10','2025-01-16 14:09:10',3),(254,83,2,'ASET LANCAR',11.00,0.00,'N','2025-01-16 14:13:52','2025-01-16 14:28:29',345),(255,83,384,'NILAI BUKU - ASET TETAP',0.00,11.00,'N','2025-01-16 14:13:52','2025-01-16 14:28:29',345),(256,83,2,'ASET LANCAR',11.00,0.00,'Y','2025-01-16 14:28:29','2025-01-16 14:28:29',345),(257,83,384,'NILAI BUKU - ASET TETAP',0.00,11.00,'Y','2025-01-16 14:28:29','2025-01-16 14:28:29',345),(258,91,6,'BANK',0.00,100000.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(259,91,678,'R/K CAB. MATRAMAN - KEUANGAN',25000.00,0.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(260,91,664,'R/K CAB. MARTADINATA - KEUANGAN',30000.00,0.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(261,91,706,'R/K CAB. TOHA - KEUANGAN',25000.00,0.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(262,91,741,'R/K CAB. PADJAJARAN - KEUANGAN',20000.00,0.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(263,92,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(264,92,93,'BCA PT PRAMITA (0460)',0.00,25000.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(265,93,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',30000.00,0.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(266,93,15,'BNI PT PRAMITA (3214)',0.00,30000.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(267,94,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(268,94,45,'BCA PT PRAMITA (0472)',0.00,25000.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(269,95,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',20000.00,0.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(270,95,60,'BCA PT PRAMITA (4554)',0.00,20000.00,'Y','2025-01-16 14:55:26','2025-01-16 14:55:26',3),(271,97,6,'BANK',0.00,100000.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(272,97,1,'ASET LANCAR',25000.00,0.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(273,97,1,'ASET LANCAR',20000.00,0.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(274,97,1,'ASET LANCAR',25000.00,0.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(275,97,1,'ASET LANCAR',30000.00,0.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(276,98,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(277,98,93,'BCA PT PRAMITA (0460)',0.00,25000.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(278,99,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',20000.00,0.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(279,99,15,'BNI PT PRAMITA (3214)',0.00,20000.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(280,100,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(281,100,45,'BCA PT PRAMITA (0472)',0.00,25000.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(282,101,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',30000.00,0.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(283,101,60,'BCA PT PRAMITA (4554)',0.00,30000.00,'Y','2025-01-16 15:06:11','2025-01-16 15:06:11',3),(284,102,12,'BRI PT PRAMITA (2305)',100000.00,0.00,'Y','2025-01-16 15:20:12','2025-01-16 15:20:12',345),(285,102,29,'BCA PT PRAMITTA (5060)',0.00,100000.00,'Y','2025-01-16 15:20:12','2025-01-16 15:20:12',345),(293,103,6,'BANK',0.00,100000.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(294,103,678,'R/K CAB. MATRAMAN - KEUANGAN',25000.00,0.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(295,103,664,'R/K CAB. MARTADINATA - KEUANGAN',30000.00,0.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(296,103,706,'R/K CAB. TOHA - KEUANGAN',25000.00,0.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(297,103,741,'R/K CAB. PADJAJARAN - KEUANGAN',20000.00,0.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(298,104,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(299,104,93,'BCA PT PRAMITA (0460)',0.00,25000.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(300,105,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',30000.00,0.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(301,105,15,'BNI PT PRAMITA (3214)',0.00,30000.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(302,106,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(303,106,45,'BCA PT PRAMITA (0472)',0.00,25000.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(304,107,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',20000.00,0.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(305,107,60,'BCA PT PRAMITA (4554)',0.00,20000.00,'Y','2025-01-16 16:45:00','2025-01-16 16:45:00',340),(306,96,5,'TUNAI',1850000.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(307,96,29,'BCA PT PRAMITTA (5060)',4393950.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(308,96,29,'BCA PT PRAMITTA (5060)',2336050.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(309,96,80,'MANDIRI PT PRAMITA (6455)',255000.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(310,96,29,'BCA PT PRAMITTA (5060)',10827650.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(311,96,29,'BCA PT PRAMITTA (5060)',38022900.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(312,96,42,'BNI PT PRAMITA (5688)',5766950.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(313,96,80,'MANDIRI PT PRAMITA (6455)',6458400.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(314,96,29,'BCA PT PRAMITTA (5060)',420000.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(315,96,29,'BCA PT PRAMITTA (5060)',1512100.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(316,96,826,'PENDAPATAN KIMIA KLINIK',0.00,4294000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(317,96,827,'PENDAPATAN IMMUNOLOGI',0.00,2189000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(318,96,822,'PENDAPATAN HEMATOLOGI',0.00,975000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(319,96,823,'PENDAPATAN URINALIS',0.00,560000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(320,96,846,'PEND. RAD. FOTO POLOS',0.00,367000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(321,96,856,'PENDAPATAN LAYANAN KLINIK',0.00,236000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(322,96,825,'PENDAPATAN ANALISA KLINIK RUTIN',0.00,564000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(323,96,826,'PENDAPATAN KIMIA KLINIK',0.00,18812000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(324,96,827,'PENDAPATAN IMMUNOLOGI',0.00,25948000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(325,96,822,'PENDAPATAN HEMATOLOGI',0.00,5000000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(326,96,823,'PENDAPATAN URINALIS',0.00,776000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(327,96,846,'PEND. RAD. FOTO POLOS',0.00,1896000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(328,96,847,'PEND. RAD. PANORAMIC & DENTAL',0.00,7090000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(329,96,848,'PEND. RAD. FOTO KONTRAS',0.00,1748000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(330,96,856,'PENDAPATAN LAYANAN KLINIK',0.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(331,96,865,'PEND. LAYANAN JASA MEDIS LAINNYA',0.00,103000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(332,96,826,'PENDAPATAN KIMIA KLINIK',0.00,840000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(333,96,827,'PENDAPATAN IMMUNOLOGI',0.00,687000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(334,96,830,'PENDAPATAN LAB PATHOLOGI ANATOMI',0.00,503500.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(335,96,822,'PENDAPATAN HEMATOLOGI',0.00,538000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(336,96,826,'PENDAPATAN KIMIA KLINIK',0.00,420000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(337,96,828,'PENDAPATAN MIKROBIOLOGI',0.00,1618000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(338,96,847,'PEND. RAD. PANORAMIC & DENTAL',0.00,1547000.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(339,96,847,'DISCOUNT PENDAPATAN LABORATORIUM',4623550.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(340,96,854,'DISC PEND. RADIODIAGNOSTIK',243550.00,0.00,'Y','2025-01-16 17:05:07','2025-01-16 17:05:07',345),(341,108,6,'BANK',0.00,100000.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(342,108,678,'R/K CAB. MATRAMAN - KEUANGAN',25000.00,0.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(343,108,664,'R/K CAB. MARTADINATA - KEUANGAN',30000.00,0.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(344,108,706,'R/K CAB. TOHA - KEUANGAN',25000.00,0.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(345,108,741,'R/K CAB. PADJAJARAN - KEUANGAN',20000.00,0.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(346,109,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(347,109,94,'BNI SYARIAH PT PRAMITA (2501)',0.00,25000.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(348,110,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',30000.00,0.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(349,110,15,'BNI PT PRAMITA (3214)',0.00,30000.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(350,111,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(351,111,45,'BCA PT PRAMITA (0472)',0.00,25000.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(352,112,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',20000.00,0.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(353,112,61,'MANDIRI PT PRAMITA (8608)',0.00,20000.00,'Y','2025-01-17 09:39:19','2025-01-17 09:39:19',340),(354,113,1,'ASET LANCAR',0.00,100000.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(355,113,678,'R/K CAB. MATRAMAN - KEUANGAN',25000.00,0.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(356,113,664,'R/K CAB. MARTADINATA - KEUANGAN',30000.00,0.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(357,113,706,'R/K CAB. TOHA - KEUANGAN',25000.00,0.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(358,113,741,'R/K CAB. PADJAJARAN - KEUANGAN',20000.00,0.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(359,114,11,'BANK JATIM PT PRAMITA (0661)',25000.00,0.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(360,114,93,'BCA PT PRAMITA (0460)',0.00,25000.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(361,115,11,'BANK JATIM PT PRAMITA (0661)',30000.00,0.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(362,115,15,'BNI PT PRAMITA (3214)',0.00,30000.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(363,116,11,'BANK JATIM PT PRAMITA (0661)',25000.00,0.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(364,116,45,'BCA PT PRAMITA (0472)',0.00,25000.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(365,117,11,'BANK JATIM PT PRAMITA (0661)',20000.00,0.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(366,117,60,'BCA PT PRAMITA (4554)',0.00,20000.00,'Y','2025-01-17 09:55:40','2025-01-17 09:55:40',340),(367,118,1,'ASET LANCAR',0.00,100000.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(368,118,678,'R/K CAB. MATRAMAN - KEUANGAN',25000.00,0.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(369,118,664,'R/K CAB. MARTADINATA - KEUANGAN',30000.00,0.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(370,118,706,'R/K CAB. TOHA - KEUANGAN',25000.00,0.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(371,118,741,'R/K CAB. PADJAJARAN - KEUANGAN',20000.00,0.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(372,119,1,'ASET LANCAR',25000.00,0.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(373,119,93,'BCA PT PRAMITA (0460)',0.00,25000.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(374,120,1,'ASET LANCAR',30000.00,0.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(375,120,15,'BNI PT PRAMITA (3214)',0.00,30000.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(376,121,1,'ASET LANCAR',25000.00,0.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(377,121,45,'BCA PT PRAMITA (0472)',0.00,25000.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(378,122,1,'ASET LANCAR',20000.00,0.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(379,122,60,'BCA PT PRAMITA (4554)',0.00,20000.00,'Y','2025-01-17 10:00:08','2025-01-17 10:00:08',340),(380,123,3,'KAS DAN SETARA KAS',0.00,100000.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(381,123,678,'R/K CAB. MATRAMAN - KEUANGAN',25000.00,0.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(382,123,664,'R/K CAB. MARTADINATA - KEUANGAN',30000.00,0.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(383,123,706,'R/K CAB. TOHA - KEUANGAN',25000.00,0.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(384,123,741,'R/K CAB. PADJAJARAN - KEUANGAN',20000.00,0.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(385,124,1,'ASET LANCAR',25000.00,0.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(386,124,94,'BNI SYARIAH PT PRAMITA (2501)',0.00,25000.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(387,125,1,'ASET LANCAR',30000.00,0.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(388,125,15,'BNI PT PRAMITA (3214)',0.00,30000.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(389,126,1,'ASET LANCAR',25000.00,0.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(390,126,45,'BCA PT PRAMITA (0472)',0.00,25000.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(391,127,1,'ASET LANCAR',20000.00,0.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(392,127,60,'BCA PT PRAMITA (4554)',0.00,20000.00,'Y','2025-01-17 10:01:50','2025-01-17 10:01:50',340),(393,128,6,'BANK',0.00,100000.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(394,128,678,'R/K CAB. MATRAMAN - KEUANGAN',25000.00,0.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(395,128,664,'R/K CAB. MARTADINATA - KEUANGAN',30000.00,0.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(396,128,706,'R/K CAB. TOHA - KEUANGAN',25000.00,0.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(397,128,741,'R/K CAB. PADJAJARAN - KEUANGAN',20000.00,0.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(398,129,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(399,129,93,'BCA PT PRAMITA (0460)',0.00,25000.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(400,130,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',30000.00,0.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(401,130,15,'BNI PT PRAMITA (3214)',0.00,30000.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(402,131,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',25000.00,0.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(403,131,45,'BCA PT PRAMITA (0472)',0.00,25000.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(404,132,881,'BIAYA GAJI TENAGA TEHNIS - REGIONAL',20000.00,0.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340),(405,132,60,'BCA PT PRAMITA (4554)',0.00,20000.00,'Y','2025-01-17 10:13:49','2025-01-17 10:13:49',340);

--
-- Table structure for table `jurnal_type`
--

CREATE TABLE `jurnal_type` (
  `JurnalTypeID` int(11) NOT NULL AUTO_INCREMENT,
  `JurnalTypeCode` varchar(25) NOT NULL DEFAULT '',
  `JurnalTypeName` varchar(150) NOT NULL DEFAULT '',
  `JurnalTypeAccesRight` char(1) NOT NULL DEFAULT 'R' COMMENT 'R = Regional, B = Branch',
  `JurnalTypeIsAuto` char(1) NOT NULL DEFAULT 'N',
  `JurnalTypeIsActive` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`JurnalTypeID`),
  KEY `JurnalTypeIsActive` (`JurnalTypeIsActive`),
  KEY `JurnalTypeIsAuto` (`JurnalTypeIsAuto`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jurnal_type`
--

INSERT INTO `jurnal_type` VALUES (1,'SALARYREG','Gaji Regional','R','N','Y'),(2,'GOODRECEIVE','Penerimaan Barang','R','N','Y'),(3,'DAILYSALES','Penjualan Harian','R','N','Y'),(4,'PAYOFFDEBT','Pelunasan Hutang','R','N','Y'),(5,'GENERAL','Umum','R','N','Y'),(6,'SALARYBCH','Gaji Cabang','R','N','Y'),(7,'AUTODAILYSALES','Auto Penjualan Harian','R','Y','Y');

--
-- Table structure for table `m_branch`
--

CREATE TABLE `m_branch` (
  `M_BranchID` int(11) NOT NULL AUTO_INCREMENT,
  `M_BranchS_RegionalID` int(11) NOT NULL DEFAULT 0,
  `M_BranchCode` varchar(10) NOT NULL,
  `M_BranchName` varchar(100) NOT NULL,
  `M_BranchM_CityID` int(11) NOT NULL,
  `M_BranchM_DistrictID` int(11) NOT NULL DEFAULT 0,
  `M_BranchM_KelurahanID` int(11) NOT NULL DEFAULT 0,
  `M_BranchAddress` varchar(300) NOT NULL,
  `M_BranchIsDefault` char(1) NOT NULL DEFAULT 'N',
  `M_BranchIsActive` char(1) NOT NULL DEFAULT 'Y',
  `M_BranchIPAddress` varchar(100) NOT NULL DEFAULT '',
  `M_BranchBaseName` varchar(50) NOT NULL,
  `M_BranchUserID` int(11) NOT NULL DEFAULT 1,
  `M_BranchCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `M_BranchImage` varchar(255) DEFAULT NULL,
  `M_BranchLastUpdated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `M_BranchLat` decimal(10,8) DEFAULT NULL,
  `M_BranchLng` decimal(11,8) DEFAULT NULL,
  `M_BranchM_CompanyID` int(11) DEFAULT 0,
  `M_BranchM_MouID` int(11) DEFAULT 0,
  `M_BranchM_DoctorID` int(11) DEFAULT 0,
  `M_BranchM_DoctorAddressID` int(11) DEFAULT 0,
  `M_BranchPhone` varchar(50) DEFAULT NULL,
  `M_BranchHaveSatellite` varchar(1) DEFAULT 'N',
  `M_BranchLastPing` datetime DEFAULT '2020-01-01 00:00:01',
  `M_BranchIsEhac` char(1) DEFAULT 'N',
  `M_BranchImg` mediumtext DEFAULT NULL,
  PRIMARY KEY (`M_BranchID`),
  KEY `M_BranchIsActive` (`M_BranchIsActive`),
  KEY `M_BranchID` (`M_BranchID`),
  KEY `M_BranchCode` (`M_BranchCode`),
  KEY `M_BranchName` (`M_BranchName`),
  KEY `M_BranchM_CityID` (`M_BranchM_CityID`),
  KEY `M_BranchAddress` (`M_BranchAddress`),
  KEY `M_BranchIPAddress` (`M_BranchIPAddress`),
  KEY `M_BranchBaseName` (`M_BranchBaseName`),
  KEY `M_BranchIsDefault` (`M_BranchIsDefault`),
  KEY `M_BranchUserID` (`M_BranchUserID`),
  KEY `M_BranchLastUpdate` (`M_BranchLastUpdated`),
  KEY `M_BranchM_DistrictID` (`M_BranchM_DistrictID`),
  KEY `M_BranchM_KelurahanID` (`M_BranchM_KelurahanID`),
  KEY `M_BranchHaveSatellite` (`M_BranchHaveSatellite`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `m_branch`
--

INSERT INTO `m_branch` VALUES (1,1,'DA','Pramita Martadinata',60,716,7020,'LLRE Martadinata No.135, Cihapit, Bandung Wetan','Y','Y','192.168.250.201','',363,'2019-08-23 15:11:32','','2025-01-08 16:20:05',-6.90832000,107.62459000,0,0,0,0,'','N','2025-01-08 16:20:05','N','[BLOB]'),(3,1,'DC','Pramita Padjajaran',60,728,7099,'Jl. Pajajaran No.86','N','Y','192.168.250.202','',363,'2019-08-23 15:11:32','','2025-01-08 16:20:05',-6.90679000,107.59367000,1263,326,3407,5153,'','Y','2025-01-08 16:20:05','Y','[BLOB]