-- Table structure for table `m_branch_company`
--

CREATE TABLE `m_branch_company` (
  `M_BranchCompanyID` int(11) NOT NULL AUTO_INCREMENT,
  `M_BranchCompanyName` varchar(100) NOT NULL,
  `M_BranchCompanyIsActive` char(1) NOT NULL DEFAULT 'Y',
  `M_BranchCompanyUserID` int(11) DEFAULT NULL,
  `M_BranchCompanyCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `M_BranchCompanyLastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`M_BranchCompanyID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `m_branch_company`
--

INSERT INTO `m_branch_company` VALUES (1,'PT PRAMITA','Y',NULL,'2024-10-24 13:37:35','2024-10-23 16:37:35'),(2,'PT MITRA PRAMITA MEDIKA','Y',NULL,'2024-10-24 13:37:44','2024-10-23 16:37:44'),(3,'PT CITRA PRAMITA SEJAHTERA','Y',NULL,'2024-10-24 13:38:00','2024-10-23 16:38:00'),(4,'PT KARYA SURYA ANUGRAH','Y',NULL,'2024-10-24 13:38:17','2024-10-23 16:38:17'),(5,'PT MITRA PRAMITA SELARAS','Y',NULL,'2024-10-24 13:38:29','2024-10-23 16:38:29');

--
-- Table structure for table `m_branch_companydetail`
--

CREATE TABLE `m_branch_companydetail` (
  `M_BranchCompanyDetailID` int(11) NOT NULL AUTO_INCREMENT,
  `M_BranchCompanyDetailM_BranchCompanyID` int(11) NOT NULL,
  `M_BranchCompanyDetailM_BranchCode` char(3) DEFAULT NULL,
  `M_BranchCompanyDetailOwnership` varchar(50) DEFAULT 'MILIK',
  `M_BranchCompanyDetailIsActive` char(1) NOT NULL DEFAULT 'Y',
  `M_BranchCompanyDetailUserID` int(11) DEFAULT NULL,
  `M_BranchCompanyDetailCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `M_BranchCompanyDetailLastUpdated` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`M_BranchCompanyDetailID`),
  KEY `M_BranchCompanyDetailM_BranchCode` (`M_BranchCompanyDetailM_BranchCode`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `m_branch_companydetail`
--

INSERT INTO `m_branch_companydetail` VALUES (1,1,'LA','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(2,1,'DA','MILIK','Y',NULL,'2024-10-24 13:42:14','2024-10-23 16:42:14'),(3,1,'DE','MILIK','Y',NULL,'2024-10-24 13:42:46','2024-10-23 16:42:46'),(4,1,'BA','MILIK','Y',NULL,'2024-10-24 13:44:06','2024-10-23 16:44:06'),(5,1,'EA','SEWA','Y',NULL,'2024-10-24 13:44:39','2024-10-23 16:44:39'),(6,1,'BB','SEWA','Y',NULL,'2024-10-24 13:45:21','2024-10-23 16:45:21'),(7,1,'LB','MILIK & SEWA','Y',NULL,'2024-10-24 13:46:00','2024-10-23 16:46:00'),(8,1,'DB','MILIK','Y',NULL,'2024-10-24 13:46:29','2024-10-23 16:46:29'),(9,1,'AA','SEWA','Y',NULL,'2024-10-24 13:47:02','2024-10-23 16:47:02'),(10,1,'LC','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(11,1,'EB','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(12,1,'LD','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(13,1,'DC','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(14,1,'LE','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(15,1,'JA','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(16,1,'HA','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(17,1,'AB','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(18,1,'BC','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(19,1,'LF','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(20,1,'FA','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(21,1,'DD','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(22,1,'SA','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(23,1,'LL','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(24,2,'JB','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(25,2,'GA','SEWA','Y',NULL,'2024-10-24 13:45:21','2024-10-23 16:45:21'),(26,2,'BD','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(27,2,'PA','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(28,2,'NA','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(29,2,'JC','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(30,2,'BE','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(31,3,'VA','SEWA','Y',NULL,'2024-10-24 13:47:34','2024-10-23 16:47:34'),(32,3,'TA','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(33,3,'HC','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(34,3,'HD','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(35,3,'DF','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(36,3,'HE','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(37,3,'EC','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(38,3,'VB','MILIK','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(39,4,'HB','FRENCHISE','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06'),(40,5,'LM','FRENCHISE','Y',NULL,'2024-10-24 13:41:06','2024-10-23 16:41:06');

--
-- Table structure for table `m_branch_xx`
--

CREATE TABLE `m_branch_xx` (
  `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_BranchLastUpdated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `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',
  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=52 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `m_branch_xx`
--

INSERT INTO `m_branch_xx` VALUES (1,1,'DA','Lab Demo',60,716,7020,'LLRE Martadinata St No.135, Cihapit, Bandung Wetan','N','N','devone.aplikasi.web.id','',340,'2019-08-23 15:11:32','2025-01-08 16:19:27',1710,2701,3407,6595,'','Y'),(3,1,'DC','Pramita Padjajaran',60,728,7099,'Jl. Pajajaran No. 86','N','N','devone.aplikasi.web.id','',3,'2019-08-23 15:11:32','2022-01-27 10:21:33',4545,177,3407,6595,'','Y'),(4,1,'DB','Pramita Toha',60,761,7355,'Jl. Moh. Toha No.163, Cigereleng, Kec. Regol, Kota Bandung','N','Y','demo.aplikasi.web.id','',340,'2019-08-23 15:11:32','2022-07-27 09:49:43',4771,188,3407,6595,'','N'),(5,1,'DD','Pramita Cimahi',67,928,8962,'Jl. Amir Machmud No.460','N','N','devone.aplikasi.web.id','',3,'2019-08-23 15:11:32','2022-01-27 10:21:33',6077,347,3407,6595,'','Y'),(6,2,'HD','Tegal',108,1844,20619,'Jl. Gajah Mada No.88','N','N','devone.aplikasi.web.id','',1,'2020-07-11 19:36:55','2023-08-28 11:11:16',0,0,0,0,NULL,'N'),(8,3,'TA','Pramita Manado',417,6153,70936,'Jl. Garuda No. 79','N','Y','devone.aplikasi.web.id','',3,'2020-08-17 11:31:53','2021-08-24 14:01:58',6464,203,3407,6595,'','Y'),(9,4,'PA','Pramita Pontianak',151,2679,31193,'Jl. Slt. Abdurrahman','N','Y','demo.aplikasi.web.id','',341,'2020-08-17 11:31:53','2023-01-27 16:43:05',7261,942,3407,6595,'','N'),(10,5,'AA','Pramita Cik Ditiro',37,436,4370,'Jl. Cik Di Tiro No.17','N','Y','devone.aplikasi.web.id','',341,'2020-08-17 11:31:53','2021-08-24 14:01:58',4555,185,3407,6595,'','N'),(11,5,'AB','Pramita Sultan Agung',37,444,4390,'Jl. Sultan Agung No.67','N','Y','devone.aplikasi.web.id','',3,'2020-08-17 11:31:53','2021-08-24 14:01:58',5931,194,3407,6595,'','N'),(13,6,'LE','Pramita Ngagel',139,2493,29105,'Jl. Ngagel Jaya No.71','N','Y','devkedungdoro.aplikasi.web.id','',3,'2020-08-24 18:39:03','2024-02-07 15:01:51',4732,186,3407,6595,'','N'),(14,1,'LA','Pramita Adityawarman',139,2516,29223,'Jl. Adityawarman No.73-79','Y','Y','devone.aplikasi.web.id','',3,'2020-08-24 14:45:25','2024-01-03 14:36:49',0,0,3407,6595,'(031) 8477700','N'),(15,6,'LD','Pramita Jemur',139,2515,29215,'Jl. Jemur Andayani No.67','N','Y','devone.aplikasi.web.id','',3,'2020-08-24 14:45:25','2021-08-24 14:01:58',4551,182,3407,6595,'(031) 8477700','N'),(16,6,'LC','Pramita Mulyo',139,2500,29133,'Jl. Mulyosari 50-52 Blok PEE 14-15','N','Y','demo.aplikasi.web.id','',3,'2020-08-24 14:45:25','2023-02-09 14:47:45',5755,192,3407,6595,'(031) 5929222','N'),(17,6,'LF','Pramita Parkus',139,2493,29123,'Jl. Parang Kusumo No.2','N','Y','devone.aplikasi.web.id','',3,'2020-08-24 14:45:25','2021-08-24 14:01:58',6029,195,3407,6595,'(031) 3554990','N'),(18,6,'LB','Pramita HR',139,2490,29090,'Jl. Mayjen HR. Muhammad No.128','N','Y','devone.aplikasi.web.id','',3,'2020-08-24 14:45:25','2021-08-24 14:01:58',4476,176,3407,6595,'(031) 7345727','N'),(19,7,'DE','Pramita Cirebon',68,951,9178,'Jl. DR. Cipto Mangunkusumo No.95','N','Y','devkedungdoro.aplikasi.web.id','',341,'2020-08-24 14:45:25','2023-03-12 20:18:36',5754,191,3407,6595,'(0231) 248990','N'),(20,9,'JA','Pramita Veteran',455,6611,75853,'Jl. Veteran No.173','N','Y','devone.aplikasi.web.id','',341,'2020-09-21 14:31:14','2021-08-24 14:01:58',5361,189,3407,6595,'','N'),(21,9,'JB','Pramita A.Dahlan',455,6607,75824,'Jl. KH. Ahmad Dahlan No.70','N','Y','devone.aplikasi.web.id','',3,'2020-09-21 14:38:02','2021-08-24 14:01:58',0,0,0,0,'','N'),(22,9,'JC','Pramita A.Yani',455,6618,75901,'Jl. Jenderal Ahmad Yani No.88','N','Y','devone.aplikasi.web.id','',3,'2020-09-21 14:38:02','2021-08-24 14:01:58',0,0,0,0,'','N'),(23,8,'BA','Pramita Matraman',41,481,4619,'Jl. Matraman Raya No.24','N','Y','devone.aplikasi.web.id','',341,'2020-08-24 14:45:25','2021-08-24 14:01:58',4549,181,3407,6595,'(021) 85908530','N'),(25,8,'BB','Pramita Bonjer',438,451,4425,'Jl. Panjang Arteri Klp. Dua Raya No.18, RT.6/RW.2','N','Y','devone.aplikasi.web.id','',3,'2020-09-21 17:03:58','2021-08-24 14:01:58',4552,183,3407,6595,'','N'),(26,8,'BC','Pramita Samanhudi',39,461,4492,'Jl. H. Samanhudi No.21, RT.5/RW.3','N','Y','devone.aplikasi.web.id','',341,'2020-09-21 17:03:58','2021-08-24 14:01:58',6019,197,3407,6595,'','N'),(27,8,'BD','Pramita Ragunan',40,470,4545,'Jalan Raya Ragunan No.P-3, RT.2/RW.3','N','Y','devone.aplikasi.web.id','',341,'2020-09-21 17:03:58','2021-08-24 14:01:58',7162,196,3407,6595,'','N'),(28,10,'EA','Pramita Diponegoro',471,6823,78501,'Jl. Pangeran Diponegoro No.37','N','Y','devone.aplikasi.web.id','',341,'2020-10-02 09:22:45','2021-08-24 14:01:58',4554,184,3407,6595,'','N'),(29,10,'EB','Pramita Yamin',471,6827,78534,'Jl. Prof. HM. Yamin Sh No.92A','N','Y','devone.aplikasi.web.id','',341,'2020-10-02 09:22:45','2021-08-24 14:01:58',4770,187,3407,6595,'','N'),(30,11,'FA','Pramita Yani',428,6282,72034,'Jl. Jend. A Yani No.39','N','Y','devone.aplikasi.web.id','',3,'2020-10-02 09:22:45','2021-08-24 14:01:58',6042,198,3407,6595,'','N'),(31,12,'GA','Pramita Sudirman',343,5229,61355,'Jl. Jend. Sudirman No No.14CD','N','Y','devone.aplikasi.web.id','',1,'2020-10-02 09:22:45','2021-08-24 14:01:58',0,0,0,0,NULL,'N'),(32,13,'HB','Pramita Magelang',96,1628,17266,'Jalan Mayjen Bambang Soegeng No.A2 Mertoyudan Sarangan','N','Y','devone.aplikasi.web.id','',3,'2020-10-02 09:22:45','2021-08-24 14:01:58',6602,1733,3407,6595,'','N'),(33,14,'HA','Pramita Semarang',104,1775,19751,'Jl. Mayor Jend. D.I. Panjaitan No.7','N','Y','devone.aplikasi.web.id','',341,'2020-10-02 09:22:45','2021-08-24 14:01:58',5658,190,3407,6595,'','N'),(34,15,'HC','Pramita Salatiga',103,1749,19468,'Jl. Osamaliki No.90, Mangunsari','N','Y','devone.aplikasi.web.id','',1,'2020-10-02 09:22:45','2021-08-24 14:01:58',0,0,0,0,NULL,'N'),(35,16,'LM','Pramita Madiun',124,1628,17266,'Jl. Pahlawan No.60','N','Y','devone.aplikasi.web.id','',3,'2020-10-02 09:22:45','2021-08-24 14:01:58',6204,2303,3407,6595,'(0351) 462999','N'),(36,17,'SA','Pramita Balikpapan',184,3033,35563,'Jl. Mt. Haryono Dalam V No.7','N','Y','devone.aplikasi.web.id','',341,'2020-10-02 09:22:45','2021-08-24 14:01:58',6211,201,3407,6595,'(0542) 8510977','N'),(37,18,'VA','Pramita Makassar',365,5525,64403,'Jl. Karunrung No.9','N','Y','devone.aplikasi.web.id','',341,'2020-10-02 09:22:45','2021-08-24 14:01:58',6601,204,3407,6595,'(0411) 8940250','N'),(38,19,'NA','Pramita Denpasar',4,20,286,'Jl. Diponegoro No.168','N','Y','devone.aplikasi.web.id','',3,'2020-10-02 09:22:45','2021-08-24 14:01:58',7434,1615,3407,6595,'','N'),(39,20,'LP','Prospek Dupang',139,2516,29223,'-','N','Y','devone.aplikasi.web.id','',341,'2020-08-24 14:45:25','2021-08-24 14:01:58',5657,1786,3407,6595,'','N'),(40,20,'LQ','Prospek Wonokusumo',139,2516,29223,'-','N','Y','devone.aplikasi.web.id','',341,'2020-08-24 14:45:25','2021-08-24 14:01:58',5656,1787,3407,6595,'','N'),(41,21,'DF','Tasikmalaya',80,1332,12919,'Jl. Sutisna Senjaya No.39','N','Y','devone.aplikasi.web.id','',1,'2020-08-24 14:45:25','2021-08-24 14:01:58',0,0,0,0,NULL,'N'),(42,22,'LZ','Sima Tangkuban Perahu',126,2225,25541,'Jl. Tangkuban Perahu No.14','N','Y','devone.aplikasi.web.id','',3,'2020-08-24 14:45:25','2021-08-24 14:01:58',5011,2300,3407,6595,'(0341) 326060','N'),(43,22,'LX','Sima Ciliwung',126,2212,25399,'Jl. Ciliwung No.51','N','Y','devone.aplikasi.web.id','',3,'2020-08-24 14:45:25','2021-08-24 14:01:58',6043,2301,3407,6595,'(0341) 486629','N'),(44,23,'LW','Sima Jember',119,2055,23357,'Jl. Gajah Mada No.199','N','Y','devone.aplikasi.web.id','',3,'2020-08-24 14:45:25','2021-08-24 14:01:58',7187,2302,3407,6595,'(0331) 421639','N'),(45,24,'LY','Sima Kediri',121,2105,23926,'Jl. Pahlawan Kusuma Bangsa No.45','N','Y','devone.aplikasi.web.id','',3,'2020-08-24 14:45:25','2021-08-24 14:01:58',5010,2299,3407,6595,'(0354) 689992','N'),(46,20,'LR','Simokerto',139,2507,29171,'jl. simokerto no. 60','N','Y','demo.aplikasi.web.id','',1547,'2022-04-18 13:20:14','2023-01-11 15:12:37',NULL,NULL,NULL,NULL,'031-37393742','N'),(47,18,'GB','Gunung Sahari B',365,5521,64359,'Jl. Letjend Hertasning Ruko Pena Mas No 3-4 Makassar','N','Y','oneb.aplikasi.web.id','',1531,'2022-05-27 09:52:42','2024-02-01 09:45:21',1710,1051,9871,17095,'0411-4097970','N'),(48,25,'LV','Sima Tulungagung',142,2569,29979,'JL. PANGLIMA SUDIRMAN 45','N','Y','devone.aplikasi.web.id','',1642,'2022-06-07 07:24:13','2024-02-15 14:42:42',0,0,3407,6595,'0355-322353','N'),(49,10,'EC','Pramita Wahid Hasyim',471,6811,78418,'Jalan K.H. Wahid Hasyim','N','Y','devone.aplikasi.web.id','',3,'2023-07-08 10:07:45','2024-02-15 14:42:18',0,0,3407,6595,'(061) 80010380','N'),(51,10,'XX','Pramita Kompol maksum Semarang',471,6811,78418,'Jalan K.H. Wahid Hasyim','N','Y','devone.aplikasi.web.id','',3,'2023-07-08 10:07:45','2024-02-15 14:42:18',0,0,3407,6595,'(061) 80010380','N');

--
-- Table structure for table `m_omzettype`
--

CREATE TABLE `m_omzettype` (
  `M_OmzetTypeID` int(11) NOT NULL AUTO_INCREMENT,
  `M_OmzetTypeName` varchar(25) NOT NULL,
  `M_OmzetTypeIsActive` char(1) NOT NULL DEFAULT 'Y',
  `M_OmzetTypeUserID` int(11) NOT NULL,
  `M_OmzetTypeCreated` datetime NOT NULL,
  `M_OmzetTypeLastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`M_OmzetTypeID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `m_omzettype`
--

INSERT INTO `m_omzettype` VALUES (1,'APS','Y',1,'0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'Dokter','Y',1,'2019-10-21 10:26:05','0000-00-00 00:00:00'),(3,'Perusahaan','Y',1,'2019-10-21 10:26:18','0000-00-00 00:00:00'),(4,'Rujukan','Y',1,'2019-10-21 10:26:30','0000-00-00 00:00:00'),(5,'Anak Perusahaan','Y',1,'2019-10-21 10:26:51','2019-12-29 21:47:27'),(6,'Penelitian','Y',1,'2019-11-20 09:35:38','2019-11-19 19:35:38'),(7,'Rujukan Antar Pramita','Y',1,'2019-11-27 11:53:46','2019-12-29 21:47:48'),(8,'Rujukan Antar Pramita','N',1,'2019-10-21 10:26:30','2019-12-29 21:48:05');

--
-- Table structure for table `m_position`
--

CREATE TABLE `m_position` (
  `M_PositionID` int(11) NOT NULL AUTO_INCREMENT,
  `M_PositionCode` varchar(10) NOT NULL,
  `M_PositionName` varchar(50) NOT NULL,
  `M_PositionIsMarketing` char(1) NOT NULL DEFAULT 'N',
  `M_PositionIsActive` char(1) NOT NULL DEFAULT 'Y',
  `M_PositionUserID` int(11) NOT NULL DEFAULT 1,
  `M_PositionCreated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp(),
  `M_PositionLastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`M_PositionID`),
  KEY `M_PositionID` (`M_PositionID`),
  KEY `M_PositionCode` (`M_PositionCode`),
  KEY `M_PositionName` (`M_PositionName`),
  KEY `M_PositionIsActive` (`M_PositionIsActive`),
  KEY `M_PositionUserID` (`M_PositionUserID`),
  KEY `M_PositionLastUpdate` (`M_PositionLastUpdated`),
  KEY `M_PositionIsMarketing` (`M_PositionIsMarketing`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `m_position`
--

INSERT INTO `m_position` VALUES (1,'01','Analis','N','Y',349,'2020-08-31 15:21:34','2020-08-31 01:21:34'),(2,'02','Marketing','Y','Y',3,'2020-03-26 09:27:34','2020-03-25 12:27:34'),(3,'03','SDM & UMUM','N','Y',1,'0000-00-00 00:00:00','2018-12-25 20:25:33'),(4,'04','General Manager','N','N',1,'0000-00-00 00:00:00','2016-02-04 10:48:07'),(5,'04','Radiografer','N','Y',1,'0000-00-00 00:00:00','2018-12-04 07:21:50'),(6,'05','Keuangan','N','Y',1,'0000-00-00 00:00:00','2018-12-04 07:22:00'),(7,'06','Pengadaan','N','Y',1,'0000-00-00 00:00:00','2018-12-04 07:22:17'),(8,'07','Perawat','N','Y',3,'2019-12-19 12:02:46','2019-12-18 08:02:46'),(9,'08','Front Office','N','Y',348,'2020-09-08 12:43:20','2020-09-07 22:43:20'),(10,'09','SPV','N','Y',361,'2020-01-02 09:40:06','2020-01-01 05:40:06'),(11,'10','Kepala Cabang','N','Y',1,'0000-00-00 00:00:00','2018-12-27 19:05:59'),(12,'11','Pembantu Umum','N','Y',1,'0000-00-00 00:00:00','2018-12-10 22:38:45'),(13,'','Petugas Keamanan','N','Y',286,'2019-12-02 10:32:48','2019-12-01 06:32:48'),(14,'','Medi RO','N','Y',3,'2019-12-09 07:13:40','2019-12-08 03:13:40'),(15,'','Pelaksana IT','N','Y',3,'2019-12-29 14:47:47','2019-12-28 10:47:47'),(16,'','dr. PJ','N','Y',341,'2020-09-07 09:03:02','2020-09-06 19:03:02'),(17,'','','N','Y',361,'2020-01-02 09:39:54','2020-01-01 05:39:54'),(18,'','','N','N',348,'2020-09-08 09:10:29','2020-09-07 19:10:29'),(19,'','Wk Mgr Marketing','Y','Y',1,'2020-03-26 09:27:05','2020-03-25 12:27:05'),(20,'','Manager Marketing','Y','Y',1,'2020-03-26 09:27:05','2020-03-25 12:27:05'),(21,'','Admin Marketing','Y','Y',1,'2020-03-26 09:27:05','2020-03-25 12:27:05'),(22,'','Marketing Medis','Y','Y',1,'2020-03-26 09:27:05','2020-03-25 12:27:05'),(23,'','Marketing Rujukan','Y','Y',1,'2020-03-26 09:27:05','2020-03-25 12:27:05'),(24,'','Marketing Corporate','Y','Y',1,'2020-03-26 09:27:05','2020-03-25 12:27:05'),(25,'','Part Time (Marketing)','Y','Y',1,'2020-03-26 09:27:05','2020-03-25 12:27:05'),(26,'','IT','N','Y',3,'2020-08-27 22:30:14','2020-08-27 08:30:14'),(27,'','','N','N',348,'2020-09-07 14:08:53','2020-09-07 00:08:53'),(28,'','Manager Pelayanan','N','Y',349,'2020-08-31 15:29:48','2020-08-31 01:29:48'),(29,'','Manager Keuangan','N','Y',349,'2020-08-31 15:48:21','2020-08-31 01:48:21'),(30,'','Manager SDM dan Umum','N','Y',349,'2020-08-31 15:49:06','2020-08-31 01:49:06'),(31,'','Manager Laboratorium','N','Y',349,'2020-08-31 15:49:41','2020-08-31 01:49:41'),(32,'','Wkl. Manager Keuangan','N','Y',349,'2020-08-31 15:51:24','2020-08-31 01:51:24'),(33,'','Koordinator Umum','N','Y',349,'2020-08-31 15:52:17','2020-08-31 01:52:17'),(34,'','Wkl. Manager SDM dan Umum','N','Y',349,'2020-08-31 15:53:08','2020-08-31 01:53:08'),(35,'','Spv. Pelayanan','N','Y',349,'2020-08-31 15:53:17','2020-08-31 01:53:17'),(36,'','Spv. Laboratorium','N','Y',349,'2020-08-31 15:53:25','2020-08-31 01:53:25'),(37,'','Operator Telpon','N','Y',349,'2020-08-31 15:53:55','2020-08-31 01:53:55'),(38,'','','N','Y',341,'2020-09-07 09:02:56','2020-09-06 19:02:56'),(39,'','Dokter Penanggung Jawab Teknis Lab.','N','Y',341,'2020-09-07 09:03:31','2020-09-06 19:03:31'),(40,'','Dokter Penanggung Jawab Biomolekuler','N','Y',341,'2020-09-07 09:04:34','2020-09-06 19:04:34'),(41,'','','N','N',348,'2020-09-08 12:45:56','2020-09-07 22:45:56'),(42,'','Admin Marketing','N','Y',348,'2020-09-08 08:19:07','2020-09-07 18:19:07'),(43,'','Logistik','N','Y',348,'2020-09-08 08:53:22','2020-09-07 18:53:22'),(44,'','Pembelian','N','Y',348,'2020-09-08 08:57:53','2020-09-07 18:57:53'),(45,'','Customer Care','N','Y',348,'2020-09-08 09:11:35','2020-09-07 19:11:35'),(46,'','Customer Service','N','Y',348,'2020-09-08 12:46:19','2020-09-07 22:46:19'),(47,'','Dokter Pelayanan Medis','N','Y',348,'2020-09-08 13:07:43','2020-09-07 23:07:43'),(48,'','Manajer Mutu','N','Y',348,'2020-09-08 13:29:03','2020-09-07 23:29:03'),(49,'','Teknisi','N','Y',348,'2020-09-08 13:30:18','2020-09-07 23:30:18'),(50,'','Fisikawan Medis','N','Y',348,'2020-09-08 14:13:39','2020-09-08 00:13:39'),(51,'','Penagihan Keuangan','N','Y',373,'2020-09-15 07:52:01','2020-09-14 17:52:01'),(52,'','PPR','N','Y',349,'2021-04-01 07:48:45','2021-03-31 17:48:45'),(53,'','Design Grafis','N','Y',349,'2021-07-08 12:17:07','2021-07-07 22:17:07');

--
-- Table structure for table `m_religion`
--

CREATE TABLE `m_religion` (
  `M_ReligionID` int(11) NOT NULL AUTO_INCREMENT,
  `M_ReligionName` varchar(25) NOT NULL,
  `M_ReligionCreated` datetime DEFAULT current_timestamp(),
  `M_ReligionM_UserID` int(11) DEFAULT NULL,
  `M_ReligionLastUpdated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `M_ReligionIsActive` char(1) DEFAULT 'Y',
  PRIMARY KEY (`M_ReligionID`),
  KEY `M_ReligionName` (`M_ReligionName`),
  KEY `M_ReligionIsActive` (`M_ReligionIsActive`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `m_religion`
--

INSERT INTO `m_religion` VALUES (1,'ISLAM','2019-03-08 15:50:34',NULL,'2019-03-08 15:50:34','Y'),(2,'KRISTEN','2019-03-08 15:50:34',NULL,'2019-03-08 15:50:34','Y'),(3,'KATHOLIK','2019-03-08 15:50:34',NULL,'2019-03-08 15:50:34','Y'),(4,'HINDU','2019-03-08 15:50:34',NULL,'2019-03-08 15:50:34','Y'),(5,'BUDDHA','2019-03-08 15:50:34',NULL,'2019-03-08 15:50:34','Y'),(6,'OTHERS','2019-03-08 15:50:34',NULL,'2019-03-08 15:50:34','Y'),(10,'Zen','2024-06-04 11:00:46',340,'2024-06-04 11:07:17','N'),(11,'TRAINING ITEM 2','2024-06-18 16:44:15',NULL,'2024-06-19 15:51:47','N'),(12,'training item 3','2024-06-19 15:50:51',NULL,'2024-06-19 15:51:38','N'),(13,'item training 2','2024-06-19 16:01:23',NULL,'2024-06-19 16:02:07','N');

--
-- Table structure for table `m_sex`
--

CREATE TABLE `m_sex` (
  `M_SexID` int(11) NOT NULL AUTO_INCREMENT,
  `M_SexCode` char(1) NOT NULL,
  `m_sexname` varchar(15) DEFAULT NULL,
  `M_SexNameLang` varchar(15) DEFAULT NULL,
  `M_SexCreated` datetime DEFAULT current_timestamp(),
  `M_SexLastUpdated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `M_SexIsActive` char(1) DEFAULT 'Y',
  PRIMARY KEY (`M_SexID`),
  KEY `M_SexCode` (`M_SexCode`),
  KEY `M_SexName` (`m_sexname`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `m_sex`
--

INSERT INTO `m_sex` VALUES (1,'L','Laki - Laki ','Male','2019-03-08 15:42:05','2020-04-19 17:34:15','Y'),(2,'P','Perempuan.','Female','2019-03-08 15:42:05','2022-04-29 17:45:20','Y'),(3,'O','Lain-Lain','OTHER','2024-06-04 13:01:44','2024-06-04 13:04:55','N'),(4,'O','Lain-Lain','OTHER','2024-06-06 17:17:14','2024-06-06 17:17:14','Y'),(5,'O','Lain-Lain','OTHER','2024-06-10 15:32:07','2024-06-10 15:32:07','Y');

--
-- Table structure for table `m_staff`
--

CREATE TABLE `m_staff` (
  `M_StaffID` int(11) NOT NULL AUTO_INCREMENT,
  `M_StaffM_BranchID` int(11) NOT NULL DEFAULT 14,
  `M_StaffName` varchar(100) NOT NULL,
  `M_StaffDOB` date DEFAULT NULL,
  `M_StaffM_SexID` int(11) DEFAULT NULL,
  `M_StaffAddress` varchar(500) DEFAULT NULL,
  `M_StaffM_CityID` int(11) DEFAULT NULL,
  `M_StaffM_SubareaID` int(11) DEFAULT NULL,
  `M_StaffPhone` varchar(25) DEFAULT NULL,
  `M_StaffHP` varchar(25) DEFAULT NULL,
  `M_StaffM_ReligionID` int(11) DEFAULT NULL,
  `M_StaffStartDate` date DEFAULT NULL,
  `M_StaffEndDate` date DEFAULT NULL,
  `M_StaffM_PositionID` int(11) DEFAULT NULL,
  `M_StaffNIK` varchar(100) DEFAULT NULL,
  `M_StaffTimeWork` varchar(100) DEFAULT NULL,
  `M_StaffTimeWorkSaturday` varchar(100) DEFAULT NULL,
  `M_StaffBlood` varchar(100) DEFAULT NULL,
  `M_StaffStudy` varchar(100) DEFAULT NULL,
  `M_StaffIsCourier` char(1) NOT NULL DEFAULT 'N',
  `M_StaffIsActive` char(1) NOT NULL DEFAULT 'Y',
  `M_StaffUserID` int(11) NOT NULL DEFAULT 1,
  `M_StaffLastUpdate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `M_StaffCode` varchar(50) DEFAULT '',
  `M_StaffIDNumber` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`M_StaffID`),
  KEY `M_StaffID` (`M_StaffID`),
  KEY `M_StaffM_BranchID` (`M_StaffM_BranchID`),
  KEY `M_StaffName` (`M_StaffName`),
  KEY `M_StaffM_SexID` (`M_StaffM_SexID`),
  KEY `M_StaffAddress` (`M_StaffAddress`),
  KEY `M_StaffM_CityID` (`M_StaffM_CityID`),
  KEY `M_StaffM_SubareaID` (`M_StaffM_SubareaID`),
  KEY `M_StaffPhone` (`M_StaffPhone`),
  KEY `M_StaffHP` (`M_StaffHP`),
  KEY `M_StaffM_ReligionID` (`M_StaffM_ReligionID`),
  KEY `M_StaffStartDate` (`M_StaffStartDate`),
  KEY `M_StaffEndDate` (`M_StaffEndDate`),
  KEY `M_StaffM_PositionID` (`M_StaffM_PositionID`),
  KEY `M_StaffIsActive` (`M_StaffIsActive`),
  KEY `M_StaffUserID` (`M_StaffUserID`),
  KEY `M_StaffLastUpdate` (`M_StaffLastUpdate`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `m_staff`
--

INSERT INTO `m_staff` VALUES (36,13,'ADMIN','1987-08-12',2,'Jl. Pangeran Diponegoro No. 14 Pesantunan Brebes',198,157,'','085226036006',1,'2008-10-20','2018-12-05',2,'01.02.03.04.05','8','8','','Politeknik Kesehatan Semarang','N','Y',422,'2020-10-01 06:03:20','STF01.02.03.04.05',NULL),(37,0,'Fajri HM','1988-06-22',1,'',0,0,'','',0,'0000-00-00','0000-00-00',29,'','','','','','N','Y',3,'2024-09-02 08:05:42','',NULL),(38,0,'Step','1999-06-10',1,'',0,0,'','',0,'0000-00-00','0000-00-00',0,'','','','','','N','Y',340,'2025-01-08 04:09:26','',NULL);

--
-- Table structure for table `m_usergroup`
--

CREATE TABLE `m_usergroup` (
  `M_UserGroupID` int(11) NOT NULL AUTO_INCREMENT,
  `M_UserGroupName` varchar(25) NOT NULL DEFAULT '',
  `M_UserGroupDashboard` varchar(255) DEFAULT '',
  `M_UserGroupIsClinic` char(1) NOT NULL DEFAULT 'N',
  `M_UserGroupCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `M_UserGroupLastUpdated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `M_UserGroupIsActive` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`M_UserGroupID`),
  KEY `M_UserGroupName` (`M_UserGroupName`),
  KEY `M_UserGroupIsActive` (`M_UserGroupIsActive`),
  KEY `M_UserGroupDashboard` (`M_UserGroupDashboard`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `m_usergroup`
--

INSERT INTO `m_usergroup` VALUES (1,'Admin','one-ui/test/vuex/acc-one-jurnal/','N','2019-04-16 16:04:06','2025-01-15 19:31:06','Y'),(21,'Keuangan','one-ui/test/vuex/acc-one-jurnal/','Y','2020-01-06 08:58:41','2025-01-15 19:31:06','Y'),(27,'Manager Keuangan','one-ui/test/vuex/acc-one-jurnal/','Y','2020-06-08 12:04:20','2025-01-15 19:31:06','Y');

--
-- Table structure for table `m_userlocation`
--

CREATE TABLE `m_userlocation` (
  `M_UserLocationID` int(11) NOT NULL AUTO_INCREMENT,
  `M_UserLocationM_UserID` int(11) NOT NULL,
  `M_UserLocationFlag` char(1) NOT NULL,
  `M_UserLocationS_RegionalID` int(11) NOT NULL DEFAULT 0,
  `M_UserLocationM_BranchID` int(11) NOT NULL DEFAULT 0,
  `M_UserLocationIsActive` char(1) NOT NULL DEFAULT 'Y',
  `M_UserLocationCreated` datetime NOT NULL,
  `M_UserLocationLastUpdated` datetime NOT NULL,
  `M_UserLocationCreatedUserID` int(11) NOT NULL,
  `M_UserLocationLastUpdatedUserID` datetime NOT NULL,
  `M_UserLocationDeleted` datetime DEFAULT NULL,
  `M_UserLocationDeletedUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`M_UserLocationID`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `m_userlocation`
--

INSERT INTO `m_userlocation` VALUES (1,3,'R',1,0,'Y','2025-01-07 19:21:01','2025-01-07 19:21:01',3,'2025-01-08 17:28:04',NULL,NULL),(2,345,'B',6,16,'Y','2025-01-08 11:22:35','2025-01-08 11:22:35',3,'2025-01-10 09:31:57',NULL,NULL),(3,346,'B',6,13,'Y','2025-01-08 11:46:16','2025-01-08 11:46:16',340,'2025-01-08 11:46:16',NULL,NULL),(4,347,'R',1,0,'Y','2025-01-08 15:11:34','2025-01-08 15:11:34',340,'2025-01-08 15:11:34',NULL,NULL),(5,348,'R',1,0,'Y','2025-01-08 15:24:48','2025-01-08 15:24:48',340,'2025-01-08 15:24:48',NULL,NULL),(6,349,'R',1,0,'Y','2025-01-08 15:25:54','2025-01-08 15:25:54',340,'2025-01-08 15:25:54',NULL,NULL),(7,350,'B',5,10,'Y','2025-01-08 15:33:29','2025-01-08 15:33:29',340,'2025-01-10 09:51:17',NULL,NULL),(8,340,'R',1,0,'Y','2025-01-08 15:11:34','2025-01-08 15:11:34',340,'2025-01-08 15:11:34',NULL,NULL),(9,351,'R',1,0,'Y','2025-01-10 09:04:08','2025-01-10 09:04:08',340,'2025-01-10 09:04:08',NULL,NULL),(10,352,'R',1,0,'Y','2025-01-10 09:34:00','2025-01-10 09:34:00',340,'2025-01-10 09:34:00',NULL,NULL),(11,353,'R',8,0,'Y','2025-01-14 08:18:03','2025-01-14 08:18:03',340,'2025-01-14 08:18:03',NULL,NULL),(12,354,'B',8,23,'Y','2025-01-14 08:20:23','2025-01-14 08:20:23',340,'2025-01-14 08:20:23',NULL,NULL),(13,355,'B',8,25,'Y','2025-01-14 08:23:30','2025-01-14 08:23:30',340,'2025-01-14 08:23:30',NULL,NULL),(14,356,'B',8,26,'Y','2025-01-14 08:24:11','2025-01-14 08:24:11',340,'2025-01-14 08:24:11',NULL,NULL),(15,357,'R',1,0,'Y','2025-01-15 18:53:38','2025-01-15 18:53:38',340,'2025-01-15 18:53:38',NULL,NULL);

--
-- Table structure for table `map_AccDisc`
--

CREATE TABLE `map_AccDisc` (
  `map_AccDiscNat_SubGroupID` int(11) NOT NULL AUTO_INCREMENT,
  `map_AccDiscNat_SubGroupCoaID` int(11) DEFAULT NULL,
  `map_AccDiscNat_SubGroupCode` char(2) NOT NULL,
  `map_AccDiscNat_SubGroupName` varchar(50) NOT NULL,
  `map_AccDiscNat_SubGroupCreated` datetime DEFAULT NULL,
  `map_AccDiscNat_SubGroupLastUpdated` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `map_AccDiscNat_SubGroupUserID` int(11) DEFAULT NULL,
  `map_AccDiscNat_SubGroupIsActive` char(1) DEFAULT NULL,
  PRIMARY KEY (`map_AccDiscNat_SubGroupID`),
  KEY `map_AccDiscNat_SubGroupCoaID` (`map_AccDiscNat_SubGroupCoaID`),
  KEY `map_AccDiscNat_SubGroupUserID` (`map_AccDiscNat_SubGroupUserID`),
  KEY `map_AccDiscNat_SubGroupIsActive` (`map_AccDiscNat_SubGroupIsActive`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `map_AccDisc`
--


--
-- Table structure for table `map_AccSales`
--

CREATE TABLE `map_AccSales` (
  `map_AccSalesNat_SubGroupID` int(11) NOT NULL AUTO_INCREMENT,
  `map_AccSalesNat_SubGroupCoaID` int(11) DEFAULT NULL,
  `map_AccSalesNat_SubGroupCode` char(2) NOT NULL,
  `map_AccSalesNat_SubGroupName` varchar(50) NOT NULL,
  `map_AccSalesM_OmzetTypeID` int(11) NOT NULL,
  `map_AccSalesM_OmzetTypeName` varchar(25) NOT NULL,
  `map_AccSalesNat_SubGroupCreated` datetime DEFAULT NULL,
  `map_AccSalesNat_SubGroupLastUpdated` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `map_AccSalesNat_SubGroupUserID` int(11) DEFAULT NULL,
  `map_AccSalesNat_SubGroupIsActive` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`map_AccSalesNat_SubGroupID`),
  KEY `map_AccSalesNat_SubGroupCoaID` (`map_AccSalesNat_SubGroupCoaID`),
  KEY `map_AccSalesM_OmzetTypeID` (`map_AccSalesM_OmzetTypeID`),
  KEY `map_AccSalesNat_SubGroupUserID` (`map_AccSalesNat_SubGroupUserID`),
  KEY `map_AccSalesNat_SubGroupIsActive` (`map_AccSalesNat_SubGroupIsActive`)
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `map_AccSales`
--

INSERT INTO `map_AccSales` VALUES (1,9,'01','Hematologi',1,'APS','2024-09-02 15:09:24','2024-09-02 15:01:57',3,'Y'),(2,8,'01','Hematologi',2,'Dokter','2024-09-03 15:05:21','2025-01-14 09:42:06',3,'Y'),(3,11,'01','Hematologi',3,'Perusahaan','2024-09-03 15:34:34','2024-09-03 08:34:34',3,'Y'),(4,NULL,'01','Hematologi',4,'Rujukan','2024-09-03 15:51:54','2024-09-03 10:41:38',3,'Y'),(5,NULL,'01','Hematologi',5,'Anak Perusahaan','2024-09-03 18:12:09','2024-09-03 11:12:09',3,'Y'),(6,NULL,'01','Hematologi',6,'Penelitian','2024-09-03 18:12:41','2024-09-03 11:12:41',3,'Y'),(7,NULL,'01','Hematologi',7,'Rujukan Antar Pramita','2024-09-03 18:12:55','2024-09-03 11:12:55',3,'Y'),(8,NULL,'02','Urinalisis',1,'APS','2024-09-03 18:13:25','2024-09-03 11:13:25',3,'Y'),(9,NULL,'02','Urinalisis',2,'Dokter','2024-09-03 18:15:39','2024-09-03 11:15:39',3,'Y'),(10,NULL,'02','Urinalisis',3,'Perusahaan','2024-09-03 18:15:47','2024-09-03 11:15:47',3,'Y'),(11,NULL,'02','Urinalisis',4,'Rujukan','2024-09-03 18:16:04','2024-09-03 11:16:20',3,'Y'),(12,NULL,'02','Urinalisis',5,'Anak Perusahaan','2024-09-03 18:16:40','2024-09-03 11:16:40',3,'Y'),(13,NULL,'02','Urinalisis',6,'Penelitian','2024-09-03 18:16:50','2024-09-03 11:16:50',3,'Y'),(14,NULL,'02','Urinalisis',7,'Rujukan Antar Pramita','2024-09-03 18:16:59','2024-09-03 11:16:59',3,'Y'),(15,NULL,'03','Faeces & Parasitologi',1,'APS','2024-09-03 18:17:39','2024-09-03 11:17:39',3,'Y'),(16,NULL,'03','Faeces & Parasitologi',2,'Dokter','2024-09-03 18:17:57','2024-09-03 11:17:57',3,'Y'),(17,NULL,'03','Faeces & Parasitologi',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(18,NULL,'03','Faeces & Parasitologi',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(19,NULL,'03','Faeces & Parasitologi',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(20,NULL,'03','Faeces & Parasitologi',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(21,NULL,'03','Faeces & Parasitologi',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(22,NULL,'04','Analisa Klinik Rutin',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(23,NULL,'04','Analisa Klinik Rutin',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(24,NULL,'04','Analisa Klinik Rutin',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(25,NULL,'04','Analisa Klinik Rutin',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(26,NULL,'04','Analisa Klinik Rutin',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(27,NULL,'04','Analisa Klinik Rutin',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(28,NULL,'04','Analisa Klinik Rutin',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(29,NULL,'05','Kimia Klinik',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(30,NULL,'05','Kimia Klinik',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(31,NULL,'05','Kimia Klinik',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(32,NULL,'05','Kimia Klinik',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(33,NULL,'05','Kimia Klinik',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(34,NULL,'05','Kimia Klinik',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(35,NULL,'05','Kimia Klinik',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(36,NULL,'06','Immunologi',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(37,NULL,'06','Immunologi',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(38,NULL,'06','Immunologi',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(39,NULL,'06','Immunologi',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(40,NULL,'06','Immunologi',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(41,NULL,'06','Immunologi',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(42,NULL,'06','Immunologi',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(43,NULL,'07','Mikrobiologi',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(44,NULL,'07','Mikrobiologi',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(45,NULL,'07','Mikrobiologi',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(46,NULL,'07','Mikrobiologi',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(47,NULL,'07','Mikrobiologi',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(48,NULL,'07','Mikrobiologi',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(49,NULL,'07','Mikrobiologi',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(50,NULL,'08','Molekuler Diagnostik',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(51,NULL,'08','Molekuler Diagnostik',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(52,NULL,'08','Molekuler Diagnostik',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(53,NULL,'08','Molekuler Diagnostik',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(54,NULL,'08','Molekuler Diagnostik',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(55,NULL,'08','Molekuler Diagnostik',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(56,NULL,'08','Molekuler Diagnostik',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(57,NULL,'09','Pathologi Anatomi',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(58,NULL,'09','Pathologi Anatomi',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(59,NULL,'09','Pathologi Anatomi',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(60,NULL,'09','Pathologi Anatomi',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(61,NULL,'09','Pathologi Anatomi',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(62,NULL,'09','Pathologi Anatomi',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(63,NULL,'09','Pathologi Anatomi',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(64,NULL,'10','Pemeriksaan Lab Lainnya',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(65,NULL,'10','Pemeriksaan Lab Lainnya',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(66,NULL,'10','Pemeriksaan Lab Lainnya',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(67,NULL,'10','Pemeriksaan Lab Lainnya',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(68,NULL,'10','Pemeriksaan Lab Lainnya',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(69,NULL,'10','Pemeriksaan Lab Lainnya',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(70,NULL,'10','Pemeriksaan Lab Lainnya',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(71,NULL,'11','Riset',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(72,NULL,'11','Riset',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(73,NULL,'11','Riset',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(74,NULL,'11','Riset',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(75,NULL,'11','Riset',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(76,NULL,'11','Riset',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(77,NULL,'11','Riset',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(78,NULL,'01','Pemeriksaan Syaraf',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(79,NULL,'01','Pemeriksaan Syaraf',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(80,NULL,'01','Pemeriksaan Syaraf',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(81,NULL,'01','Pemeriksaan Syaraf',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(82,NULL,'01','Pemeriksaan Syaraf',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(83,NULL,'01','Pemeriksaan Syaraf',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(84,NULL,'01','Pemeriksaan Syaraf',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(85,NULL,'02','Elektromedis Jantung & Pembuluh Darah',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(86,NULL,'02','Elektromedis Jantung & Pembuluh Darah',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(87,NULL,'02','Elektromedis Jantung & Pembuluh Darah',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(88,NULL,'02','Elektromedis Jantung & Pembuluh Darah',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(89,NULL,'02','Elektromedis Jantung & Pembuluh Darah',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(90,NULL,'02','Elektromedis Jantung & Pembuluh Darah',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(91,NULL,'02','Elektromedis Jantung & Pembuluh Darah',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(92,NULL,'03','Fungsi Pendengaran',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(93,NULL,'03','Fungsi Pendengaran',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(94,NULL,'03','Fungsi Pendengaran',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(95,NULL,'03','Fungsi Pendengaran',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(96,NULL,'03','Fungsi Pendengaran',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(97,NULL,'03','Fungsi Pendengaran',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(98,NULL,'03','Fungsi Pendengaran',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(99,NULL,'04','Fungsi Paru-paru',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(100,NULL,'04','Fungsi Paru-paru',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(101,NULL,'04','Fungsi Paru-paru',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(102,NULL,'04','Fungsi Paru-paru',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(103,NULL,'04','Fungsi Paru-paru',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(104,NULL,'04','Fungsi Paru-paru',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(105,NULL,'04','Fungsi Paru-paru',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(106,NULL,'05','Otot',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(107,NULL,'05','Otot',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(108,NULL,'05','Otot',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(109,NULL,'05','Otot',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(110,NULL,'05','Otot',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(111,NULL,'05','Otot',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(112,NULL,'05','Otot',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(113,NULL,'01','Foto Polos',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(114,NULL,'01','Foto Polos',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(115,NULL,'01','Foto Polos',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(116,NULL,'01','Foto Polos',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(117,NULL,'01','Foto Polos',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(118,NULL,'01','Foto Polos',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(119,NULL,'01','Foto Polos',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(120,NULL,'02','Panoramic & Dental',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(121,NULL,'02','Panoramic & Dental',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(122,NULL,'02','Panoramic & Dental',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(123,NULL,'02','Panoramic & Dental',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(124,NULL,'02','Panoramic & Dental',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(125,NULL,'02','Panoramic & Dental',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(126,NULL,'02','Panoramic & Dental',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(127,NULL,'03','Foto Kontras',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(128,NULL,'03','Foto Kontras',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(129,NULL,'03','Foto Kontras',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(130,NULL,'03','Foto Kontras',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(131,NULL,'03','Foto Kontras',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(132,NULL,'03','Foto Kontras',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(133,NULL,'03','Foto Kontras',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(134,NULL,'04','Bonedensitometri',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(135,NULL,'04','Bonedensitometri',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(136,NULL,'04','Bonedensitometri',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(137,NULL,'04','Bonedensitometri',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(138,NULL,'04','Bonedensitometri',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(139,NULL,'04','Bonedensitometri',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(140,NULL,'04','Bonedensitometri',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(141,NULL,'05','CT Scan',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(142,NULL,'05','CT Scan',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(143,NULL,'05','CT Scan',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(144,NULL,'05','CT Scan',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(145,NULL,'05','CT Scan',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(146,NULL,'05','CT Scan',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(147,NULL,'05','CT Scan',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(148,NULL,'06','USG',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(149,NULL,'06','USG',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(150,NULL,'06','USG',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(151,NULL,'06','USG',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(152,NULL,'06','USG',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(153,NULL,'06','USG',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(154,NULL,'06','USG',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(155,NULL,'07','MRI',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(156,NULL,'07','MRI',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(157,NULL,'07','MRI',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(158,NULL,'07','MRI',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(159,NULL,'07','MRI',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(160,NULL,'07','MRI',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(161,NULL,'07','MRI',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(162,NULL,'01','Layanan Klinik',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(163,NULL,'01','Layanan Klinik',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(164,NULL,'01','Layanan Klinik',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(165,NULL,'01','Layanan Klinik',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(166,NULL,'01','Layanan Klinik',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(167,NULL,'01','Layanan Klinik',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(168,NULL,'01','Layanan Klinik',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(169,NULL,'02','Pemeriksaan K3',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(170,NULL,'02','Pemeriksaan K3',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(171,NULL,'02','Pemeriksaan K3',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(172,NULL,'02','Pemeriksaan K3',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(173,NULL,'02','Pemeriksaan K3',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(174,NULL,'02','Pemeriksaan K3',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(175,NULL,'02','Pemeriksaan K3',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(176,NULL,'03','Vaksin',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(177,NULL,'03','Vaksin',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(178,NULL,'03','Vaksin',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(179,NULL,'03','Vaksin',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(180,NULL,'03','Vaksin',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(181,NULL,'03','Vaksin',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(182,NULL,'03','Vaksin',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(183,NULL,'04','Layanan Alat & Farmasi',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(184,NULL,'04','Layanan Alat & Farmasi',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(185,NULL,'04','Layanan Alat & Farmasi',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(186,NULL,'04','Layanan Alat & Farmasi',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(187,NULL,'04','Layanan Alat & Farmasi',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(188,NULL,'04','Layanan Alat & Farmasi',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(189,NULL,'04','Layanan Alat & Farmasi',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(190,NULL,'05','Layanan Jasa',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(191,NULL,'05','Layanan Jasa',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(192,NULL,'05','Layanan Jasa',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(193,NULL,'05','Layanan Jasa',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(194,NULL,'05','Layanan Jasa',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(195,NULL,'05','Layanan Jasa',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(196,NULL,'05','Layanan Jasa',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(197,NULL,'06','Dental Lab',1,'APS','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(198,NULL,'06','Dental Lab',2,'Dokter','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(199,NULL,'06','Dental Lab',3,'Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(200,NULL,'06','Dental Lab',4,'Rujukan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(201,NULL,'06','Dental Lab',5,'Anak Perusahaan','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(202,NULL,'06','Dental Lab',6,'Penelitian','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y'),(203,NULL,'06','Dental Lab',7,'Rujukan Antar Panitia','2024-09-03 18:37:03','2024-09-03 11:37:03',3,'Y');

--
-- Table structure for table `map_BankCoa`
--

CREATE TABLE `map_BankCoa` (
  `MapBank_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MapBank_BranchCode` varchar(10) NOT NULL,
  `MapBank_NatBankName` varchar(64) NOT NULL,
  `MapBank_BankAccountNo` varchar(48) NOT NULL,
  `MapBank_coaAccountNo` varchar(48) NOT NULL,
  `MapBank_coaDescription` varchar(64) NOT NULL,
  `MapBank_IsActive` char(1) NOT NULL DEFAULT 'Y',
  `MapBank_CreatedAt` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `MapBank_LastUpdatedAt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`MapBank_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `map_BankCoa`
--

INSERT INTO `map_BankCoa` VALUES (1,'BA','BCA','3423235060','1110211021','BCA PT PRAMITTA (5060)','Y','2025-01-17 04:44:57','2025-01-16 04:18:23'),(2,'BA','BCA','3423023291','1110211022','BCA PT PRAMITA (3291)','Y','2025-01-17 04:44:59','2025-01-16 04:18:55'),(3,'BC','MANDIRI','0060009776455','1110211072','MANDIRI PT PRAMITA (6455)','Y','2025-01-17 04:45:02','2025-01-17 03:50:49');

--
-- Table structure for table `map_NatGroup`
--

CREATE TABLE `map_NatGroup` (
  `MapNatGroup_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MapNatGroup_NatGroupID` int(11) NOT NULL,
  `MapNatGroup_Disc_coaAccNo` varchar(15) NOT NULL,
  `MapNatGroup_Retur_coaAccNo` varchar(15) NOT NULL,
  `MapNatGroup_IsActive` char(1) NOT NULL DEFAULT 'Y',
  `MapNatGroup_CreatedAt` datetime NOT NULL,
  `MapNatGroup_LastUpdatedAt` datetime NOT NULL,
  PRIMARY KEY (`MapNatGroup_ID`),
  KEY `MapNatGroup_Disc_coaAccNo` (`MapNatGroup_Disc_coaAccNo`),
  KEY `MapNatGroup_Retur_coaAccNo` (`MapNatGroup_Retur_coaAccNo`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `map_NatGroup`
--

INSERT INTO `map_NatGroup` VALUES (1,1,'4110200001','4110200002','Y','2025-01-15 18:56:43','2025-01-15 18:56:43'),(2,2,'4110400001','4110400002','Y','2025-01-15 18:56:43','2025-01-15 18:56:43'),(3,3,'4110600001','4110600002','Y','2025-01-15 18:56:43','2025-01-15 18:56:43'),(4,4,'4250600001','4250600002','Y','2025-01-15 18:56:43','2025-01-15 18:56:43');

--
-- Table structure for table `map_NatSubGroup`
--

CREATE TABLE `map_NatSubGroup` (
  `MapNatSub_ID` int(11) NOT NULL AUTO_INCREMENT,
  `MapNatSub_NatGroupID` int(11) NOT NULL,
  `MapNatSub_NatSubGroupID` int(11) NOT NULL,
  `MapNatSub_NatSubGroupCode` char(2) NOT NULL,
  `MapNatSub_coaAccountNo` varchar(15) NOT NULL,
  `MapNatSub_IsActive` char(1) NOT NULL DEFAULT 'Y',
  `MapNatSub_CreatedAt` datetime NOT NULL,
  `MapNatSub_LastUpdatedAt` datetime NOT NULL,
  PRIMARY KEY (`MapNatSub_ID`),
  KEY `MapNatSub_coaAccountNo` (`MapNatSub_coaAccountNo`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `map_NatSubGroup`
--

INSERT INTO `map_NatSubGroup` VALUES (1,1,1,'1','4110100001','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(2,1,2,'2','4110100002','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(3,1,3,'3','4110100003','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(4,1,4,'4','4110100004','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(5,1,5,'5','4110100005','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(6,1,6,'6','4110100006','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(7,1,7,'7','4110100007','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(8,1,8,'8','4110100008','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(9,1,9,'9','4110100009','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(10,1,10,'10','4110100010','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(11,1,11,'11','4110100011','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(12,2,12,'1','4110300001','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(13,2,13,'2','4110300002','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(14,2,14,'3','4110300003','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(15,2,15,'4','4110300004','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(16,2,16,'5','4110300005','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(17,3,17,'1','4110500001','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(18,3,18,'2','4110500002','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(19,3,19,'3','4110500003','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(20,3,20,'4','4110500004','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(21,3,21,'5','4110500005','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(22,3,22,'6','4110500006','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(23,3,23,'7','4110500007','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(24,4,24,'1','41107','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(25,4,25,'2','4110700004','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(26,4,26,'3','4110700008','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(27,4,27,'4','4110700007','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(28,4,28,'5','4110700009','Y','2025-01-15 18:58:00','2025-01-15 18:58:00'),(29,4,29,'6','4110700006','Y','2025-01-15 18:58:00','2025-01-15 18:58:00');

--
-- Table structure for table `nat_subgroup_map`
--

CREATE TABLE `nat_subgroup_map` (
  `Nat_SubgroupMapID` int(11) NOT NULL AUTO_INCREMENT,
  `Nat_SubgroupMapNat_SubGroupID` int(11) NOT NULL,
  `Nat_SubgroupMapNat_SubGroupCode` char(2) NOT NULL,
  `Nat_SubgroupMapNat_SubGroupName` varchar(50) NOT NULL,
  `Nat_SubgroupMapPendapatanCoaID` int(11) NOT NULL,
  `Nat_SubgroupMapDiscCoaID` int(11) NOT NULL,
  `Nat_SubgroupMapReturCoaID` int(11) NOT NULL,
  `Nat_SubGroupMapUserID` int(11) NOT NULL DEFAULT 3,
  `Nat_SubgroupMapCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `Nat_SubgroupMapLastUpdated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `Nat_SubGroupMapIsActive` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`Nat_SubgroupMapID`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nat_subgroup_map`
--

INSERT INTO `nat_subgroup_map` VALUES (1,1,'01','Hematologi',822,834,845,3,'2025-01-09 09:48:13','2025-01-09 09:48:13','Y'),(2,2,'02','Urinalisis',823,834,835,3,'2025-01-09 09:48:57','2025-01-09 09:48:57','Y'),(3,3,'03','Faeces & Parasitologi',824,834,835,3,'2025-01-09 09:49:22','2025-01-09 09:49:22','Y'),(4,4,'04','Analisa Klinik Rutin',825,834,835,3,'2025-01-09 09:49:52','2025-01-09 09:49:52','Y'),(5,5,'05','Kimia Klinik',826,834,835,3,'2025-01-09 09:50:07','2025-01-09 09:50:07','Y'),(6,6,'06','Immunologi',827,834,835,3,'2025-01-09 09:50:53','2025-01-09 09:50:53','Y'),(7,7,'07','Mikrobiologi',828,834,835,3,'2025-01-09 09:51:14','2025-01-09 09:51:14','Y'),(8,8,'08','Molekuler Diagnostik',829,834,835,3,'2025-01-09 09:51:33','2025-01-09 09:51:33','Y'),(9,9,'09','Pathologi Anatomi',830,834,835,3,'2025-01-09 09:51:59','2025-01-09 09:51:59','Y'),(10,10,'10','Pemeriksaan Lab Lainnya',831,834,835,3,'2025-01-09 09:52:19','2025-01-09 09:52:19','Y'),(11,11,'11','Riset',832,834,835,3,'2025-01-09 09:52:53','2025-01-09 09:52:53','Y'),(12,12,'01','Pemeriksaan Syaraf',837,843,844,3,'2025-01-09 09:53:24','2025-01-09 09:53:24','Y'),(13,13,'02','Elektromedis Jantung & Pembuluh Darah',838,843,844,3,'2025-01-09 09:53:45','2025-01-09 09:53:45','Y'),(14,14,'03','Fungsi Pendengaran',839,843,844,3,'2025-01-09 09:54:04','2025-01-09 09:54:04','Y'),(15,15,'04','Fungsi Paru-paru',840,843,844,3,'2025-01-09 09:54:29','2025-01-09 09:54:29','Y'),(16,16,'05','Otot',841,843,844,3,'2025-01-09 09:54:54','2025-01-09 09:54:54','Y'),(17,17,'01','Foto Polos',846,854,855,3,'2025-01-09 09:55:20','2025-01-09 09:55:20','Y'),(18,18,'02','Panoramic & Dental',847,854,855,3,'2025-01-09 09:55:41','2025-01-09 09:55:41','Y'),(19,19,'03','Foto Kontras',848,854,855,3,'2025-01-09 09:56:26','2025-01-09 09:56:26','Y'),(20,20,'04','Bonedensitometri',849,854,855,3,'2025-01-09 09:57:05','2025-01-09 09:57:05','Y'),(21,21,'05','CT Scan',850,854,855,3,'2025-01-09 09:57:33','2025-01-09 09:57:33','Y'),(22,22,'06','USG',851,854,855,3,'2025-01-09 09:58:39','2025-01-09 09:58:39','Y'),(23,23,'07','MRI',852,854,855,3,'2025-01-09 09:59:03','2025-01-09 09:59:03','Y'),(24,24,'01','Layanan Klinik',856,867,868,3,'2025-01-09 10:00:30','2025-01-09 10:00:30','Y'),(25,25,'02','Pemeriksaan K3',860,867,868,3,'2025-01-09 10:00:52','2025-01-09 10:00:52','Y'),(26,26,'03','Vaksin',864,867,868,3,'2025-01-09 10:01:06','2025-01-09 10:01:06','Y'),(27,27,'04','Layanan Alat & Farmasi',863,867,868,3,'2025-01-09 10:02:10','2025-01-09 10:02:10','Y'),(28,28,'05','Layanan Jasa',865,867,868,3,'2025-01-09 10:02:44','2025-01-09 10:02:44','Y'),(29,29,'06','Dental Lab',862,867,868,3,'2025-01-09 10:03:03','2025-01-09 10:03:03','Y');

--
-- Table structure for table `periode`
--

CREATE TABLE `periode` (
  `periodeID` int(11) NOT NULL AUTO_INCREMENT,
  `periodeYear` int(11) DEFAULT NULL,
  `periodeMonth` int(11) DEFAULT NULL,
  `periodeName` varchar(100) DEFAULT NULL,
  `periodeStartDate` date DEFAULT NULL,
  `periodeEndDate` date DEFAULT NULL,
  `periodeIsActive` varchar(1) DEFAULT 'Y',
  `periodeIsClosed` varchar(1) DEFAULT 'Y',
  `periodeCreated` datetime DEFAULT current_timestamp(),
  `periodeLastUpdated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`periodeID`),
  KEY `periodeYear` (`periodeYear`),
  KEY `periodeMonth` (`periodeMonth`),
  KEY `periodeIsActive` (`periodeIsActive`),
  KEY `periodeIsPosted` (`periodeIsClosed`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `periode`
--

INSERT INTO `periode` VALUES (1,2024,9,'September 2024','2024-09-01','2024-09-30','N','N','2024-09-02 17:23:50','2025-01-14 13:56:36'),(2,2024,8,'Agustus 2024','2024-08-01','2024-08-31','Y','N','2024-09-03 09:30:58','2024-09-04 11:00:10'),(3,2024,7,'Juli 2024','2024-07-01','2024-07-30','N','Y','2024-09-03 11:48:27','2024-09-25 08:39:01'),(4,2025,1,'Januari 2025','2025-01-01','2025-01-31','Y','N','2025-01-09 09:01:31','2025-01-14 09:16:12');

--
-- Table structure for table `purchase_request_direct`
--

CREATE TABLE `purchase_request_direct` (
  `PurchaseRequestDirectID` int(11) NOT NULL AUTO_INCREMENT,
  `PurchaseRequestDirectNumber` varchar(50) DEFAULT NULL,
  `PurchaseRequestDirectDate` date DEFAULT '0000-00-00',
  `PurchaseRequestDirectDateUse` date DEFAULT '0000-00-00',
  `PurchaseRequestDirectM_BranchCode` varchar(25) DEFAULT '',
  `PurchaseRequestDirectDescription` varchar(500) DEFAULT '',
  `PurchaseRequestDirectNote` varchar(500) DEFAULT '',
  `PurchaseRequestDirectTotalEstimation` int(11) DEFAULT 0,
  `PurchaseRequestDirectTotalPaid` int(11) DEFAULT 0,
  `PurchaseRequestDirectTotalRealitation` int(11) DEFAULT 0,
  `PurchaseRequestDirectStatus` enum('Draft','Pending','Approved','Rejected','Paid','Completed') DEFAULT 'Draft',
  `PurchaseRequestApprovedDate` datetime DEFAULT '0000-00-00 00:00:00',
  `PurchaseRequestApprovedBy` int(11) DEFAULT 0 COMMENT 'M_UserID',
  `PurchaseRequestConfirmedDate` datetime DEFAULT '0000-00-00 00:00:00',
  `PurchaseRequestConfirmedBy` int(11) DEFAULT 0 COMMENT 'M_UserID',
  `PurchaseRequestPaidDate` datetime DEFAULT '0000-00-00 00:00:00',
  `PurchaseRequestPaidBy` int(11) DEFAULT 0,
  `PurchaseRequestDirectIsActive` char(1) DEFAULT 'Y',
  `PurchaseRequestCreated` datetime DEFAULT '0000-00-00 00:00:00',
  `PurchaseRequestLastUpdated` datetime DEFAULT '0000-00-00 00:00:00',
  `PurchaseRequestDeleted` datetime DEFAULT '0000-00-00 00:00:00',
  `PurchaseRequestCreatedUserID` int(11) DEFAULT 0,
  `PurchaseRequestLastUpdatedUserID` int(11) DEFAULT 0,
  `PurchaseRequestDeletedUserID` int(11) DEFAULT 0,
  PRIMARY KEY (`PurchaseRequestDirectID`),
  KEY `PurchaseRequestDirectM_BranchID` (`PurchaseRequestDirectM_BranchCode`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchase_request_direct`
--

INSERT INTO `purchase_request_direct` VALUES (1,'1','2024-09-04','2024-10-04','DA','Tes','tes note',18000,20000,18000,'Completed','2024-09-11 19:14:17',3,NULL,NULL,'2024-09-11 19:22:00',3,'Y','2024-09-04 15:55:18','2024-09-11 19:23:11',NULL,3,3,NULL),(2,'2','2024-09-04','2024-11-08','SA','Tes 2',NULL,20000,0,18000,'Pending',NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',0,'Y','2024-09-04 17:01:47','2024-09-11 09:18:18',NULL,3,3,NULL),(3,'3','2024-09-04','2024-11-07','SA','Test 3','',50000,50000,0,'Approved','2024-09-17 09:36:06',3,NULL,NULL,'2024-09-11 18:59:10',3,'Y','2024-09-04 17:27:25','2024-09-17 09:36:06',NULL,3,3,NULL),(4,'4','2024-09-04','2024-12-25','LA','Test 4',NULL,60000,0,0,'Draft',NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',0,'Y','2024-09-04 17:29:03','2024-09-17 08:44:54',NULL,3,3,NULL),(5,'5','2024-09-04','2025-01-01','LD','Test 5',NULL,0,0,0,'Draft',NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',0,'Y','2024-09-04 17:31:11',NULL,NULL,3,NULL,NULL),(6,'6','2024-09-04','2025-02-06','BD','Test 6',NULL,0,0,0,'Draft',NULL,NULL,NULL,NULL,'0000-00-00 00:00:00',0,'Y','2024-09-04 18:02:27',NULL,'2024-09-06 08:16:36',3,NULL,3),(7,'PD24090006','2024-09-12','2024-09-20','JB','Pesan nasi goreng','',15000,20000,15000,'Completed','2024-09-13 10:51:46',3,NULL,NULL,'2024-09-13 11:47:00',3,'Y','2024-09-12 21:41:48','2024-09-13 11:47:05',NULL,3,3,NULL),(8,'PD24090007','2024-09-12','2024-09-27','GB','Pesan es teh manis',NULL,0,0,0,'Draft',NULL,NULL,NULL,NULL,NULL,NULL,'Y','2024-09-12 21:50:03','2024-09-12 22:06:09',NULL,3,3,NULL),(9,'PD24090009','2024-09-17','2024-09-17','JB','Le mineral galon 15 Liter ','deskripsi gak sesuai',79000,80000,79000,'Completed','2024-09-17 09:37:31',3,NULL,NULL,'2024-09-17 09:37:51',3,'Y','2024-09-17 09:00:00','2024-09-17 09:37:55',NULL,3,3,NULL),(10,'PD24090010','2024-09-17','2024-09-17','DA','Makan siang Tim SAS','',61000,0,0,'Approved','2024-09-17 11:17:13',3,NULL,NULL,NULL,NULL,'Y','2024-09-17 09:45:13','2024-09-17 11:17:13',NULL,3,3,NULL),(11,'PD24090011','2024-09-17','2024-09-17','JB','dasdasd',NULL,200,0,0,'Draft',NULL,NULL,NULL,NULL,NULL,NULL,'N','2024-09-17 10:13:41','2024-09-17 10:15:09','2024-09-17 10:15:21',3,3,3),(12,'PD24090012','2024-09-17','2024-09-17','JB','tesing ',NULL,0,0,0,'Draft',NULL,NULL,NULL,NULL,NULL,NULL,'Y','2024-09-17 10:15:45',NULL,NULL,3,NULL,NULL),(13,'PD24090013','2024-09-17','2024-09-17','JB','Beli obat sakit perut','catatan',16000,0,0,'Approved','2024-09-17 10:30:23',3,NULL,NULL,NULL,NULL,'Y','2024-09-17 10:26:01','2024-09-17 10:30:23',NULL,3,3,NULL);

--
-- Table structure for table `purchase_request_direct_detail`
--

CREATE TABLE `purchase_request_direct_detail` (
  `PurchaseRequestDirectDetailID` int(11) NOT NULL AUTO_INCREMENT,
  `PurchaseRequestDirectDetailPurchaseRequestDirectID` int(11) DEFAULT 0,
  `PurchaseRequestDirectDescription` varchar(255) DEFAULT '',
  `PurchaseRequestDirectDetailAmountRequest` int(11) DEFAULT 0,
  `PurchaseRequestDirectDetailAmount` int(11) DEFAULT 0,
  `PurchaseRequestDirectDetailEstimationPrice` int(11) DEFAULT 0,
  `PurchaseRequestDirectDetailTotalEstimationPrice` int(11) DEFAULT 0,
  `PurchaseRequestDirectDetailTotalRealitationPrice` int(11) DEFAULT 0,
  `PurchaseRequestDirectDetailStatus` enum('Pending','Ordered','Received','Cancelled') DEFAULT 'Pending',
  `PurchaseRequestDirectDetailIsActive` char(1) DEFAULT 'Y',
  `PurchaseRequestDirectDetailCreated` datetime DEFAULT '0000-00-00 00:00:00',
  `PurchaseRequestDirectDetailLastUpdated` datetime DEFAULT '0000-00-00 00:00:00',
  `PurchaseRequestDirectDetailDeleted` datetime DEFAULT '0000-00-00 00:00:00',
  `PurchaseRequestDirectDetailCreatedUserID` int(11) DEFAULT 0,
  `PurchaseRequestDirectDetailLastUpdatedUserID` int(11) DEFAULT 0,
  `PurchaseRequestDirectDetailDeletedUserID` int(11) DEFAULT 0,
  PRIMARY KEY (`PurchaseRequestDirectDetailID`),
  KEY `PurchaseRequestDirectDetailPurchaseRequestDirectID` (`PurchaseRequestDirectDetailPurchaseRequestDirectID`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `purchase_request_direct_detail`
--

INSERT INTO `purchase_request_direct_detail` VALUES (1,1,'Obat 1',2,2,5000,10000,10000,'Received','Y','2024-09-05 16:40:27','2024-09-11 19:23:11',NULL,3,3,NULL),(2,1,'Obat 2',4,4,2000,8000,8000,'Received','Y','2024-09-06 08:50:22','2024-09-11 19:23:11','2024-09-06 08:57:25',3,3,3),(3,2,'Obat 4',5,NULL,4000,20000,NULL,'Pending','Y','2024-09-06 10:47:03','2024-09-09 17:24:33',NULL,3,3,NULL),(4,2,'Obat 1',2,NULL,10000,20000,NULL,'Pending','Y','2024-09-06 11:14:25','2024-09-09 17:24:33','2024-09-09 19:22:23',3,3,3),(5,3,'Obat 2',10,10,5000,50000,50000,'Ordered','Y','2024-09-06 11:17:52','2024-09-17 09:36:06',NULL,3,3,NULL),(6,7,'Nasi goreng gila',1,1,15000,15000,15000,'Received','Y','2024-09-13 00:03:28','2024-09-13 11:47:05',NULL,3,3,NULL),(7,4,'123456',50,NULL,1200,60000,NULL,'Pending','Y','2024-09-17 08:44:54',NULL,NULL,3,NULL,NULL),(8,9,'Le mineral galon',2,2,22000,44000,44000,'Received','Y','2024-09-17 09:00:28','2024-09-17 09:37:55',NULL,3,3,NULL),(9,9,'Aqua gelasan satu karton',1,1,35000,35000,35000,'Received','Y','2024-09-17 09:00:50','2024-09-17 09:37:55',NULL,3,3,NULL),(10,10,'Gado-gado',2,1,15000,30000,15000,'Ordered','Y','2024-09-17 10:09:01','2024-09-17 11:17:13',NULL,3,3,NULL),(11,10,'Pecel',1,1,10000,10000,10000,'Ordered','Y','2024-09-17 10:09:11','2024-09-17 11:17:13',NULL,3,3,NULL),(12,10,'Nasi Lemak',3,2,12000,36000,24000,'Ordered','Y','2024-09-17 10:09:41','2024-09-17 11:17:13',NULL,3,3,NULL),(13,11,'dqwd',1,NULL,200,200,NULL,'Pending','Y','2024-09-17 10:15:09',NULL,NULL,3,NULL,NULL),(14,13,'Obat maag',3,NULL,2000,6000,NULL,'Pending','N','2024-09-17 10:26:18',NULL,'2024-09-17 10:28:26',3,NULL,3),(15,13,'Obat maag',3,3,2000,6000,6000,'Ordered','Y','2024-09-17 10:28:37','2024-09-17 10:30:23',NULL,3,3,NULL),(16,13,'Paracetamol',2,1,5000,10000,5000,'Ordered','Y','2024-09-17 10:28:58','2024-09-17 10:30:23',NULL,3,3,NULL);

--
-- Table structure for table `r_inputtype`
--

CREATE TABLE `r_inputtype` (
  `R_InputTypeID` int(11) NOT NULL AUTO_INCREMENT,
  `R_InputTypeName` varchar(100) DEFAULT NULL,
  `R_InputTypeIsActive` varchar(1) DEFAULT 'Y',
  `R_InputTypeCreated` datetime DEFAULT current_timestamp(),
  `R_InputTypeLastUpdated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `R_InputTypeUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`R_InputTypeID`),
  KEY `R_InputTypeName` (`R_InputTypeName`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `r_inputtype`
--

INSERT INTO `r_inputtype` VALUES (1,'text','Y','2020-01-08 12:49:41','2020-01-08 12:49:41',3),(2,'date','Y','2020-01-08 12:49:41','2020-01-08 12:49:41',3),(3,'dropdown','Y','2020-01-08 12:49:41','2020-01-08 12:49:41',3),(4,'autocompletion','Y','2020-01-08 12:49:41','2020-01-08 12:49:41',3),(5,'company','Y','2025-01-16 16:00:42','2025-01-16 16:00:46',3),(6,'regional','Y','2025-01-16 16:00:56','2025-01-16 16:00:56',3),(7,'branch','Y','2025-01-16 16:01:03','2025-01-16 16:01:03',3);

--
-- Table structure for table `r_report`
--

CREATE TABLE `r_report` (
  `R_ReportID` int(11) NOT NULL AUTO_INCREMENT,
  `R_ReportR_ReportGroupID` int(11) NOT NULL DEFAULT 0,
  `R_ReportCode` varchar(25) DEFAULT NULL,
  `R_ReportWithoutXls` varchar(1) DEFAULT 'N',
  `R_ReportName` varchar(50) NOT NULL DEFAULT '',
  `R_ReportUrl` varchar(1000) DEFAULT NULL,
  `R_ReportParams` varchar(255) DEFAULT NULL,
  `R_ReportOrder` char(2) NOT NULL DEFAULT '',
  `R_ReportCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `R_ReportLastUpdated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `R_ReportIsActive` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`R_ReportID`),
  KEY `R_ReportR_ReportGroupID` (`R_ReportR_ReportGroupID`),
  KEY `R_ReportCode` (`R_ReportCode`),
  KEY `R_ReportName` (`R_ReportName`),
  KEY `R_ReportOrder` (`R_ReportOrder`),
  KEY `R_ReportIsActive` (`R_ReportIsActive`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `r_report`
--

INSERT INTO `r_report` VALUES (1,1,'MR01','Y','TRIAL BALANCE PT','/birt/run?__report=report/one/accounting/rpt_jurnal_003.rptdesign','','1','2025-01-16 08:46:36','2025-01-17 14:37:28','Y'),(2,1,'MR02','Y','TRIAL BALANCE REGIONAL','/birt/run?__report=report/one/accounting/rpt_jurnal_002.rptdesign',NULL,'2','2025-01-16 09:24:49','2025-01-17 14:37:40','Y'),(3,1,'MR03','Y','TRIAL BALANCE CABANG','/birt/run?__report=report/one/accounting/rpt_jurnal_004.rptdesign',NULL,'3','2025-01-16 09:26:34','2025-01-17 14:37:45','Y');

--
-- Table structure for table `r_reportdetail`
--

CREATE TABLE `r_reportdetail` (
  `R_ReportDetailID` int(11) NOT NULL AUTO_INCREMENT,
  `R_ReportDetailR_ReportID` int(11) DEFAULT NULL,
  `R_ReportDetailName` varchar(100) DEFAULT NULL,
  `R_ReportDetailLabel` varchar(300) DEFAULT NULL,
  `R_ReportDetailParam` varchar(300) DEFAULT NULL,
  `R_ReportDetailDepParam` varchar(300) DEFAULT NULL,
  `R_ReportDetailSourceSp` varchar(300) DEFAULT NULL,
  `R_ReportDetailSourceUrl` varchar(300) DEFAULT NULL,
  `R_ReportDetailR_InputTypeID` int(11) DEFAULT NULL,
  `R_ReportDetailDefault` varchar(100) DEFAULT NULL,
  `R_ReportDetailPriority` int(11) DEFAULT 0,
  `R_ReportDetailIsActive` varchar(1) DEFAULT 'Y',
  `R_ReportDetailCreated` datetime DEFAULT current_timestamp(),
  `R_ReportDetailLastUpdated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `R_ReportDetailUserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`R_ReportDetailID`),
  KEY `R_ReportDetailIsActive` (`R_ReportDetailIsActive`),
  KEY `R_ReportDetailR_ReportID` (`R_ReportDetailR_ReportID`),
  KEY `R_ReportDetailPriority` (`R_ReportDetailPriority`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `r_reportdetail`
--

INSERT INTO `r_reportdetail` VALUES (1,1,'Company','Company','PCompanyID',NULL,'sp_rpt_branch_company_acc',NULL,5,NULL,1,'Y','2025-01-16 09:05:08','2025-01-16 16:14:26',NULL),(2,1,'Periode','Periode','PPeriodID',NULL,'sp_rpt_period_acc',NULL,4,NULL,1,'Y','2025-01-16 09:12:37','2025-01-16 09:12:37',NULL),(3,2,'Regional','Regional','PRegID',NULL,'sp_rpt_regional_acc',NULL,6,NULL,1,'Y','2025-01-16 09:33:52','2025-01-17 09:39:14',NULL),(4,2,'Periode','Periode','PPeriodID',NULL,'sp_rpt_period_acc',NULL,4,NULL,1,'Y','2025-01-16 09:12:37','2025-01-16 09:12:37',NULL),(5,3,'Cabang','Cabang','PBranchCode',NULL,'sp_rpt_branch_code_acc_dropdown',NULL,7,NULL,1,'Y','2025-01-16 09:33:52','2025-01-17 09:39:21',NULL),(6,3,'Periode','Periode','PPeriodID',NULL,'sp_rpt_period_acc',NULL,4,NULL,1,'Y','2025-01-16 09:12:37','2025-01-16 09:12:37',NULL);

--
-- Table structure for table `r_reportgroup`
--

CREATE TABLE `r_reportgroup` (
  `R_ReportGroupID` int(11) NOT NULL AUTO_INCREMENT,
  `R_ReportGroupCode` varchar(25) DEFAULT NULL,
  `R_ReportGroupName` varchar(50) NOT NULL DEFAULT '',
  `R_ReportGroupCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `R_ReportGroupLastUpdated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `R_ReportGroupIsActive` char(1) NOT NULL DEFAULT 'Y',
  `R_ReportGroupColor` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`R_ReportGroupID`),
  KEY `R_ReportGroupCode` (`R_ReportGroupCode`),
  KEY `R_ReportGroupName` (`R_ReportGroupName`),
  KEY `R_ReportGroupIsActive` (`R_ReportGroupIsActive`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `r_reportgroup`
--

INSERT INTO `r_reportgroup` VALUES (1,'MR','Monthly Report','2025-01-16 08:37:24','2025-01-17 14:37:19','Y','grey accent-3');

--
-- Table structure for table `s_menu`
--

CREATE TABLE `s_menu` (
  `S_MenuID` int(11) NOT NULL AUTO_INCREMENT,
  `S_MenuName` varchar(50) NOT NULL DEFAULT '',
  `S_MenuRegional` char(1) NOT NULL DEFAULT 'R' COMMENT 'R = Regional, N = Cabang',
  `S_MenuUrl` varchar(255) DEFAULT NULL,
  `S_MenuIcon` varchar(100) DEFAULT NULL,
  `S_MenuParentS_MenuID` int(11) NOT NULL DEFAULT 0,
  `S_MenuLevel` tinyint(4) NOT NULL DEFAULT 0,
  `S_MenuIsParent` char(1) NOT NULL DEFAULT 'N',
  `S_MenuOrder` tinyint(4) NOT NULL DEFAULT 0,
  `S_MenuIsActive` char(1) NOT NULL DEFAULT 'Y',
  `S_MenuCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `S_MenuLastUpdated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`S_MenuID`),
  KEY `S_MenuName` (`S_MenuName`),
  KEY `S_MenuParentS_MenuID` (`S_MenuParentS_MenuID`),
  KEY `S_MenuIsActive` (`S_MenuIsActive`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `s_menu`
--

INSERT INTO `s_menu` VALUES (1,'Masterdata','R','#','storage',0,0,'Y',1,'Y','2019-06-10 13:27:49','2024-09-02 14:10:59'),(2,'Registration','R','test/vuex/one-fo-registration-v31/',NULL,1,1,'N',1,'N','2019-06-12 10:56:45','2024-09-03 08:24:55'),(3,'Sistem','R','#','settings',0,0,'Y',2,'Y','2019-06-10 13:29:07','2024-09-02 14:12:08'),(4,'Specimen Collection','R','test/vuex/one-sample-lab-v15/','',114,1,'N',1,'Y','2019-06-10 13:29:32','2023-04-04 11:45:13'),(5,'Beginning Balance','R','test/vuex/acc-beginning-balance/',NULL,1,1,'N',2,'Y','2024-09-02 11:13:07','2024-09-02 15:23:28'),(6,'Chart Of Account','R','test/vuex/acc-one-md-coa/',NULL,1,1,'N',1,'Y','2024-09-02 11:21:36','2024-09-04 12:42:49'),(7,'Data Periode','R','test/vuex/acc-one-md-periode/',NULL,1,1,'N',19,'Y','2024-09-02 11:26:31','2024-09-02 15:33:30'),(8,'Hak Akses','R','test/vuex/one-md-priviledge/',NULL,3,1,'N',3,'Y','2019-06-21 08:21:58','2024-09-02 14:51:55'),(9,'User','R','test/vuex/one-md-usergroup-user-v5/',NULL,3,1,'N',2,'Y','2019-06-21 08:21:58','2025-01-08 15:23:58'),(10,'Staf','R','test/vuex/one-md-staff-v2',NULL,3,1,'N',1,'Y','2019-06-21 08:21:58','2025-01-08 13:31:59'),(11,'Account Sales','R','test/vuex/acc-one-md-account-sales/',NULL,1,1,'N',4,'Y','2024-09-02 17:37:59','2024-09-02 17:39:10'),(12,'Media Journal','R','#','receipt',0,0,'Y',3,'Y','2024-09-03 11:34:45','2024-09-03 11:39:17'),(13,'Pendapatan Cash','R','test/vuex/acc-one-pendapatan-cash-v2/',NULL,12,1,'N',2,'Y','2024-09-03 11:35:58','2025-01-17 13:54:53'),(14,'Purchase','R','#','shopping_cart',0,0,'Y',4,'Y','2024-09-04 09:14:34','2024-09-04 15:59:31'),(15,'Purchase Request','R','test/vuex/acc-one-purchase-request/requester/',NULL,14,1,'N',1,'Y','2024-09-04 09:20:40','2024-09-04 09:22:07'),(16,'Preset Jurnal','R','test/vuex/acc-preset-jurnal/',NULL,1,1,'N',5,'N','2024-09-04 10:14:34','2025-01-16 15:43:08'),(17,'Pendapatan AR','R','test/vuex/acc-one-pendapatan-ar/',NULL,12,1,'N',3,'Y','2024-09-05 09:17:25','2025-01-16 15:57:53'),(18,'Purchase Request - Manager','R','test/vuex/acc-one-purchase-request/manager/',NULL,14,1,'N',2,'Y','2024-09-09 08:23:21','2024-09-09 16:43:49'),(19,'Purchase Request - Kasir','R','test/vuex/acc-one-purchase-request/cashier/',NULL,14,1,'N',3,'Y','2024-09-09 19:18:30','2024-09-11 10:05:28'),(20,'Reverse Journal','R','test/vuex/acc-reverse-journal/',NULL,1,1,'N',7,'N','2024-09-11 19:41:40','2025-01-16 15:44:08'),(21,'Recusive Journal template','R','test/vuex/acc-recrusive-journal-template/',NULL,1,1,'N',6,'N','2024-09-12 09:19:19','2025-01-16 15:43:52'),(22,'Pendapatan AR Payment ','R','test/vuex/acc-one-payment-receive/',NULL,12,1,'N',4,'Y','2024-09-24 11:34:07','2025-01-16 15:57:53'),(23,'Satuan Convert','R','test/vuex/acc-one-md-unitconvert/',NULL,1,1,'N',8,'N','2024-09-24 14:57:46','2025-01-16 15:44:29'),(24,'Satuan','R','test/vuex/acc-one-md-itemunit/',NULL,1,1,'N',9,'N','2024-09-24 15:56:14','2025-01-16 15:44:29'),(25,'Presentase Cabang','R','test/vuex/acc-one-presentase-cabang/',NULL,1,1,'N',10,'Y','2024-09-04 10:14:34','2024-09-04 10:14:34'),(26,'coba jurnal gaji','R','test/vuex/acc-coba-jurnal-gaji/',NULL,1,1,'N',10,'Y','2024-09-04 10:14:34','2025-01-08 17:51:40'),(27,'Jurnal Terima Barang','R','test/vuex/acc-jurnal-terimabarang/',NULL,1,1,'N',10,'N','2024-09-04 10:14:34','2025-01-16 15:44:51'),(28,'Manual Jurnal','R','test/vuex/acc-one-jurnal/',NULL,12,1,'N',1,'Y','2025-01-09 09:27:25','2025-01-15 18:44:21'),(29,'Laporan','R','test/vuex/one-report-v9/','description',0,0,'N',12,'Y','2025-01-15 19:32:25','2025-01-17 14:23:27');

--
-- Table structure for table `s_numbering`
--

CREATE TABLE `s_numbering` (
  `S_NumberingID` int(11) NOT NULL AUTO_INCREMENT,
  `S_NumberingType` varchar(12) NOT NULL,
  `S_NumberingPrefix` varchar(50) DEFAULT '',
  `S_NumberingPrefixDate` varchar(50) DEFAULT '' COMMENT 'ie %y%m for monthly',
  `S_NumberingSufix` varchar(50) DEFAULT '' COMMENT '-PAT or blank',
  `S_NumberingReset` char(1) NOT NULL DEFAULT 'D' COMMENT 'D, M , Y,X=manual',
  `S_NumberingCounter` int(11) NOT NULL DEFAULT 0 COMMENT 'increment value',
  `S_NumberingDigit` smallint(6) NOT NULL DEFAULT 1,
  `S_NumberingCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `S_NumberingLastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `S_NumberingIsActive` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`S_NumberingID`),
  KEY `S_NumberingType` (`S_NumberingType`),
  KEY `S_NumberingCounter` (`S_NumberingCounter`),
  KEY `S_NumberingDigit` (`S_NumberingDigit`),
  KEY `S_NumberingIsActive` (`S_NumberingIsActive`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `s_numbering`
--

INSERT INTO `s_numbering` VALUES (1,'PJ','PJ','%y%m','','M',13,4,'2024-09-04 13:24:59','2024-09-09 01:56:57','Y'),(2,'J','J','%y%m','','M',35,4,'2024-09-06 13:39:23','2025-01-16 08:20:12','Y'),(3,'PD','PD','%y%m','','M',14,4,'2024-09-06 13:39:23','2024-09-17 03:26:01','Y'),(4,'RJT','RJT','%y%m','','M',2,4,'2024-09-12 15:29:19','2025-01-09 06:33:00','Y'),(5,'UI','UI','%y','','Z',28,5,'2024-09-24 16:15:31','2024-09-24 09:16:04','Y'),(6,'GJ','','','','M',91,3,'2025-01-13 15:03:00','2025-01-17 03:13:49','Y');

--
-- Table structure for table `s_privilege`
--

CREATE TABLE `s_privilege` (
  `S_PrivilegeID` int(11) NOT NULL AUTO_INCREMENT,
  `S_PrivilegeM_UserGroupID` int(11) NOT NULL DEFAULT 0,
  `S_PrivilegeS_MenuID` int(11) NOT NULL DEFAULT 0,
  `S_PrivilegeCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `S_PrivilegeLastUpdated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `S_PrivilegeIsActive` char(1) NOT NULL DEFAULT 'Y',
  PRIMARY KEY (`S_PrivilegeID`),
  KEY `S_PrivilegeM_UserGroupID` (`S_PrivilegeM_UserGroupID`),
  KEY `S_PrivilegeS_MenuID` (`S_PrivilegeS_MenuID`),
  KEY `S_PrivilegeIsActive` (`S_PrivilegeIsActive`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `s_privilege`
--

INSERT INTO `s_privilege` VALUES (1,1,1,'2024-09-02 11:14:06','2024-09-02 11:14:06','Y'),(2,1,5,'2024-09-02 11:14:25','2024-09-02 11:14:25','Y'),(3,1,6,'2024-09-02 11:22:07','2024-09-02 11:22:07','Y'),(4,1,7,'2024-09-02 11:27:25','2024-09-02 11:27:25','Y'),(5,1,2,'2024-09-02 11:14:06','2024-09-02 11:14:06','Y'),(6,1,8,'2024-09-02 11:14:06','2024-09-02 11:14:06','Y'),(7,1,3,'2024-09-02 14:10:04','2024-09-02 14:10:04','Y'),(8,1,8,'2024-09-02 14:10:04','2024-09-02 14:45:19','N'),(9,1,9,'2024-09-02 14:44:52','2024-09-02 14:44:52','Y'),(10,1,10,'2024-09-02 14:52:33','2024-09-02 14:52:33','Y'),(11,1,11,'2024-09-02 17:50:14','2025-01-16 15:47:09','N'),(12,1,12,'2024-09-03 11:36:49','2024-09-03 11:36:49','Y'),(13,1,13,'2024-09-03 11:36:58','2024-09-03 11:36:58','Y'),(14,1,14,'2024-09-04 09:16:30','2024-09-04 09:16:30','Y'),(15,1,15,'2024-09-04 09:21:04','2024-09-04 09:21:04','Y'),(16,1,16,'2024-09-04 10:14:57','2024-09-04 10:14:57','Y'),(17,1,17,'2024-09-05 09:17:58','2024-09-05 09:17:58','Y'),(18,1,18,'2024-09-09 08:24:11','2024-09-09 08:24:11','Y'),(19,1,19,'2024-09-11 09:55:58','2024-09-11 09:55:58','Y'),(20,1,20,'2024-09-11 19:42:14','2024-09-11 19:42:14','Y'),(21,1,21,'2024-09-12 09:19:57','2024-09-12 09:19:57','Y'),(22,1,22,'2024-09-24 11:34:46','2024-09-24 11:34:46','Y'),(23,1,23,'2024-09-24 14:58:14','2024-09-24 14:58:14','Y'),(24,1,24,'2024-09-24 15:56:47','2024-09-24 15:56:47','Y'),(25,1,25,'2024-09-24 15:56:47','2024-09-24 15:56:47','Y'),(26,1,26,'2025-01-08 17:52:51','2025-01-08 17:52:51','Y'),(27,1,27,'2025-01-08 18:29:18','2025-01-08 18:29:18','Y'),(28,1,28,'2025-01-09 09:28:20','2025-01-09 09:28:20','Y'),(29,1,29,'2025-01-15 19:33:25','2025-01-15 19:33:25','Y'),(30,1,11,'2025-01-16 15:47:45','2025-01-16 15:47:45','Y');

--
-- Table structure for table `s_regional`
--

CREATE TABLE `s_regional` (
  `S_RegionalID` int(11) NOT NULL AUTO_INCREMENT,
  `S_RegionalName` varchar(50) NOT NULL DEFAULT '',
  `S_RegionalIsActive` char(1) NOT NULL DEFAULT 'Y',
  `S_RegionalIsDefault` varchar(1) NOT NULL DEFAULT 'N',
  `S_RegionalCreated` datetime NOT NULL DEFAULT current_timestamp(),
  `S_RegionalLastUpdated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`S_RegionalID`),
  KEY `S_RegionalName` (`S_RegionalName`),
  KEY `S_RegionalIsActive` (`S_RegionalIsActive`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `s_regional`
--

INSERT INTO `s_regional` VALUES (1,'Bandung Raya','Y','Y','2019-08-23 15:09:20','2020-07-13 09:00:26'),(2,'Tegal Raya','Y','N','2020-07-13 09:00:36','2020-07-26 14:12:33'),(3,'Manado Raya','Y','N','2020-07-22 18:47:58','2020-07-22 18:47:58'),(4,'Pontianak Raya','Y','N','2020-07-26 14:06:19','2020-07-26 14:06:19'),(5,'Yogyakarta Raya','Y','N','2020-08-17 10:24:19','2021-12-31 16:01:28'),(6,'Surabaya Raya','Y','N','2020-08-24 14:32:33','2020-08-24 14:32:48'),(7,'Cirebon Raya','Y','N','2020-08-24 15:16:51','2020-08-24 15:16:51'),(8,'Jakarta Raya','Y','N','2020-09-01 15:25:55','2020-09-01 15:25:55'),(9,'Palembang Raya','Y','N','2020-09-21 13:00:24','2020-09-21 13:00:24'),(10,'Medan Raya','Y','N','2020-10-02 07:52:16','2020-10-02 07:52:16'),(11,'Padang Raya','Y','N','2020-10-16 11:08:39','2020-10-16 11:09:24'),(12,'Pekanbaru Raya','Y','N','2020-10-16 11:08:39','2020-10-16 11:09:24'),(13,'Magelang Raya','Y','N','2020-10-19 10:31:09','2020-11-13 10:09:44'),(14,'Semarang Raya','Y','N','2020-10-19 10:31:09','2020-11-17 13:40:06'),(15,'Salatiga Raya','Y','N','2020-10-19 10:31:09','2020-11-18 12:45:57'),(16,'Madiun Raya','Y','N','2020-10-19 10:31:09','2020-11-18 15:01:27'),(17,'Balikpapan Raya','Y','N','2020-10-19 10:31:09','2020-11-21 13:50:59'),(18,'Makassar Raya','Y','N','2020-10-19 10:31:09','2020-12-24 04:03:09'),(19,'Bali Raya','Y','N','2020-10-19 10:31:09','2020-12-24 04:03:09'),(21,'Tasik Raya','Y','Y','2020-10-19 10:31:09','2021-03-05 12:17:55'),(26,'Bekasi Raya','N','N','2023-12-12 15:11:55','2024-12-26 12:13:43'),(28,'Mojokerto Raya','Y','N','2024-05-02 20:15:31','2024-07-30 10:01:02');

--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `SupplierID` int(1) NOT NULL AUTO_INCREMENT,
  `SupplierCode` varchar(100) NOT NULL DEFAULT '',
  `SupplierName` varchar(250) NOT NULL DEFAULT '0',
  `SupplierIsActive` char(1) NOT NULL DEFAULT 'Y',
  `SupplierCreatedUserID` int(11) NOT NULL DEFAULT 0,
  `SupplierCreated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `SupplierLastUpdatedUserID` int(11) NOT NULL DEFAULT 0,
  `SupplierLastUpdated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `SupplierDeleted` int(11) NOT NULL DEFAULT 0,
  `SupplierDeletedUserID` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`SupplierID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `supplier`
--

INSERT INTO `supplier` VALUES (1,'S0001','SUPPLIER 1','Y',0,'2025-01-09 09:26:44',0,'2025-01-09 09:26:44',0,'0000-00-00 00:00:00'),(2,'S0002','SUPPLIER 2','Y',0,'2025-01-09 09:27:05',0,'2025-01-09 09:27:05',0,'0000-00-00 00:00:00'),(3,'S0003','SUPPLIER 3 (INACTIVE)','N',0,'2025-01-09 09:27:37',0,'2025-01-09 09:27:37',0,'0000-00-00 00:00:00'),(4,'S0004','PT ABC','Y',3,'2025-01-10 17:32:34',3,'2025-01-10 17:32:34',0,'0000-00-00 00:00:00');

--
-- Table structure for table `t_beginningbalance`
--

CREATE TABLE `t_beginningbalance` (
  `T_BeginningBalanceID` int(11) NOT NULL AUTO_INCREMENT,
  `T_BeginningBalanceCoaID` int(11) NOT NULL,
  `T_BeginningBalancePeriodeID` int(11) NOT NULL,
  `T_BeginningBalanceCoaAccountNo` varchar(20) NOT NULL,
  `T_BeginningBalanceDescription` varchar(500) NOT NULL,
  `T_BeginningBalanceType` char(2) NOT NULL,
  `T_BeginningBalanceStatus` char(1) NOT NULL COMMENT 'N= new, P=POST',
  `T_BeginningBalanceDebit` decimal(10,0) NOT NULL,
  `T_BeginningBalanceCredit` decimal(10,0) NOT NULL,
  `T_BeginningBalanceCreated` datetime NOT NULL,
  `T_BeginningBalanceCreatedUserID` int(11) NOT NULL,
  `T_BeginningBalanceLastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `T_BeginningBalanceLastUpdatedUserID` int(11) NOT NULL,
  PRIMARY KEY (`T_BeginningBalanceID`),
  KEY `T_BeginningBalanceCoaID` (`T_BeginningBalanceCoaID`),
  KEY `T_BeginningBalanceCoaAccountNo` (`T_BeginningBalanceCoaAccountNo`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t_beginningbalance`
--

INSERT INTO `t_beginningbalance` VALUES (1,9,4,'1110211001','BCA PT PRAMITA (4338)- surabaya','DB','P',10000000,0,'2025-01-15 15:43:48',340,'2025-01-16 06:47:21',340),(2,12,4,'1110211004','BRI PT PRAMITA (2305)- surabaya','CR','P',0,5000000,'2025-01-15 15:43:48',340,'2025-01-16 06:47:21',340),(3,29,4,'1110211021','BCA PT PRAMITTA (5060)- Matraman','CR','P',0,3000000,'2025-01-15 15:43:48',340,'2025-01-16 06:47:21',340),(4,36,4,'1110211028','BNI PT PRAMITA (7780)- Medan Diponegoro','CR','P',0,2000000,'2025-01-15 15:43:48',340,'2025-01-16 06:47:21',340);

--
-- Table structure for table `t_presetjurnal`
--

CREATE TABLE `t_presetjurnal` (
  `jurnalID` int(11) NOT NULL AUTO_INCREMENT,
  `jurnalM_BranchCode` varchar(5) DEFAULT NULL,
  `jurnalperiodeID` int(11) DEFAULT NULL,
  `jurnalNo` varchar(200) DEFAULT NULL,
  `jurnalTitle` varchar(200) DEFAULT NULL,
  `jurnalStatus` int(11) DEFAULT 0 COMMENT '0 belum post, selain 0 sudah post',
  `jurnalType` varchar(10) DEFAULT 'General' COMMENT 'Umum/AP/AR/Sales/EDC',
  `jurnalIsActive` varchar(1) DEFAULT 'Y',
  `jurnalCreated` datetime DEFAULT current_timestamp(),
  `jurnalLastUpdated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `jurnalM_UserID` int(11) DEFAULT NULL,
  PRIMARY KEY (`jurnalID`),
  KEY `jurnalNo` (`jurnalNo`),
  KEY `jurnalM_BranchCode` (`jurnalM_BranchCode`),
  KEY `jurnalDate` (`jurnalStatus`),
  KEY `jurnalTitle` (`jurnalTitle`),
  KEY `jurnalType` (`jurnalType`),
  KEY `jurnalIsActive` (`jurnalIsActive`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t_presetjurnal`
--

INSERT INTO `t_presetjurnal` VALUES (1,'DB',1,NULL,'edit',0,'UMUM','N','2024-09-04 14:36:43','2024-09-04 18:10:45',3),(2,'DA',1,'PJ24090002','Ss',0,'GENERAL','N','2024-09-04 14:37:11','2024-09-04 18:10:50',3),(3,'DB',1,'PJ24090003','sadqwwq ds',0,'UMUM','Y','2024-09-04 14:41:20','2024-09-06 11:28:11',3),(4,'DA',1,'PJ24090004','weq',12,'GENERAL','Y','2024-09-04 14:42:40','2024-09-06 16:08:47',3),(5,'DA',1,'PJ24090005','Test',0,'UMUM','Y','2024-09-04 16:15:49','2024-09-04 16:15:49',3),(6,'DA',1,'PJ24090006','testb ',0,'UMUM','Y','2024-09-04 16:16:48','2024-09-06 16:07:56',3),(7,'DA',1,'PJ24090007','edittt',0,'UMUM','N','2024-09-04 17:39:00','2024-09-09 08:47:12',3),(8,'DA',1,'PJ24090008','coba',0,'UMUM','N','2024-09-06 11:21:59','2024-09-09 08:48:57',3),(9,'DA',1,'PJ24090009','sda',0,'UMUM','N','2024-09-06 11:22:15','2024-09-09 08:49:51',3),(10,'DA',1,'PJ24090010','saas',0,'UMUM','N','2024-09-06 11:22:20','2024-09-09 08:50:30',3),(11,'DA',1,'PJ24090011','Coba post',0,'UMUM','N','2024-09-06 14:17:26','2024-09-09 08:52:40',3),(12,'DA',1,'PJ24090012','asd2',0,'UMUM','N','2024-09-09 08:56:57','2024-09-09 08:57:01',3);

--
-- Table structure for table `t_presetjurnaldetail`
--

CREATE TABLE `t_presetjurnaldetail` (
  `jurnalTxID` int(11) NOT NULL AUTO_INCREMENT,
  `jurnalTxJurnalID` int(11) DEFAULT NULL,
  `jurnalTxCoaID` int(11) DEFAULT NULL,
  `junalTxDescription` 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=310 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t_presetjurnaldetail`
--

INSERT INTO `t_presetjurnaldetail` VALUES (161,5,16,'MANDIRI PT PRAMITA (2284)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(162,5,17,'BRI PT PRAMITA (0305)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(163,5,18,'BJB PT PRAMITA (7001)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(164,5,19,'BANK WOORI PT PRAMITA (0024)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(165,5,20,'BTN PT PRAMITA (2831)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(166,5,21,'DANAMON PT PRAMITA (3330)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(167,5,22,'BCA PT PRAMITA (9988)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(168,5,23,'BNI PT PRAMITA (9198)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(169,5,24,'BCA PT PRAMITA (9700)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(170,5,25,'BSI PT PRAMITA (0001)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(171,5,26,'BNI PT PRAMITA (0195)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(172,5,27,'MANDIRI PT PRAMITA (0233)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(173,5,28,'PERMATA PT PRAMITA (3492)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(174,5,29,'BCA PT PRAMITTA (5060)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(175,5,30,'BCA PT PRAMITA (3291)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(176,5,31,'CIMB NIAGA PT PRAMITA (8200)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(177,5,32,'BSM PT PRAMITA (0357)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(178,5,33,'BNI PT PRAMITA (1890)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(179,5,34,'BRI PT PRAMITA (7303)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(180,5,35,'BNI SYA PT PRAMITA (7524)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(181,5,36,'BNI PT PRAMITA (7780)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(182,5,37,'DANAMON PT PRAMITA (3989)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(183,5,38,'BCA PT PRAMITA (7371)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(184,5,39,'MANDIRI PT PRAMITA (4915)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(185,5,40,'BCA PT PRAMITA (7717)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(186,5,41,'MANDIRI PT PRAMITA (5056)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(187,5,42,'BNI PT PRAMITA (5688)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(188,5,43,'JTRUST PT PRAMITA (6243)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(189,5,44,'BCA PT PRAMITA (4926)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(190,5,45,'BCA PT PRAMITA (0472)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(191,5,46,'MANDIRI PT PRAMITA (6076)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(192,5,47,'MANDIRI PT PRAMITA (9655)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(193,5,48,'BNI PT PRAMITA (9789)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(194,5,49,'BCA PT PRAMITA (3555)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(195,5,50,'MANDIRI PT PRAMITA (2878)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(196,5,51,'BSI PT PRAMITA (8100)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(197,5,52,'BCA PT PRAMITA (4800)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(198,5,53,'MANDIRI PT PRAMITA (8608)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(199,5,54,'BCA PT PRAMITA (4527)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(200,5,55,'MANDIRI PT PRAMITA (6475)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(201,5,56,'BCA PT PRAMITA (6659)',0.00,10000.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(202,5,57,'BSI PT PRAMITA (7754)',1000000.00,0.00,'Y','2024-09-05 16:28:34','2024-09-05 16:28:34',3),(260,3,12,'BRI PT PRAMITA (2305)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(261,3,13,'BCA PT PRAMITA (4334)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(262,3,14,'BCA PT PRAMITA (3331)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(263,3,15,'BNI PT PRAMITA (3214)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(264,3,16,'MANDIRI PT PRAMITA (2284)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(265,3,17,'BRI PT PRAMITA (0305)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(266,3,18,'BJB PT PRAMITA (7001)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(267,3,19,'BANK WOORI PT PRAMITA (0024)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(268,3,20,'BTN PT PRAMITA (2831)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(269,3,21,'DANAMON PT PRAMITA (3330)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(270,3,22,'BCA PT PRAMITA (9988)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(271,3,23,'BNI PT PRAMITA (9198)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(272,3,24,'BCA PT PRAMITA (9700)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(273,3,25,'BSI PT PRAMITA (0001)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(274,3,26,'BNI PT PRAMITA (0195)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(275,3,27,'MANDIRI PT PRAMITA (0233)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(276,3,28,'PERMATA PT PRAMITA (3492)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(277,3,29,'BCA PT PRAMITTA (5060)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(278,3,30,'BCA PT PRAMITA (3291)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(279,3,31,'CIMB NIAGA PT PRAMITA (8200)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(280,3,32,'BSM PT PRAMITA (0357)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(281,3,33,'BNI PT PRAMITA (1890)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(282,3,34,'BRI PT PRAMITA (7303)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(283,3,35,'BNI SYA PT PRAMITA (7524)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(284,3,36,'BNI PT PRAMITA (7780)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(285,3,37,'DANAMON PT PRAMITA (3989)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(286,3,38,'BCA PT PRAMITA (7371)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(287,3,39,'MANDIRI PT PRAMITA (4915)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(288,3,40,'BCA PT PRAMITA (7717)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(289,3,41,'MANDIRI PT PRAMITA (5056)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(290,3,42,'BNI PT PRAMITA (5688)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(291,3,43,'JTRUST PT PRAMITA (6243)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(292,3,44,'BCA PT PRAMITA (4926)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(293,3,45,'BCA PT PRAMITA (0472)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(294,3,46,'MANDIRI PT PRAMITA (6076)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(295,3,47,'MANDIRI PT PRAMITA (9655)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(296,3,48,'BNI PT PRAMITA (9789)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(297,3,49,'BCA PT PRAMITA (3555)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(298,3,50,'MANDIRI PT PRAMITA (2878)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(299,3,51,'BSI PT PRAMITA (8100)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(300,3,52,'BCA PT PRAMITA (4800)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(301,3,53,'MANDIRI PT PRAMITA (8608)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(302,3,54,'BCA PT PRAMITA (4527)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(303,3,55,'MANDIRI PT PRAMITA (6475)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(304,3,56,'BCA PT PRAMITA (6659)',0.00,10000.00,'Y','2024-09-06 13:24:13','2024-09-06 13:24:13',3),(305,3,57,'BSI PT PRAMITA (7754) edit',1000000.00,0.00,'Y','2024-09-06 13:24:13','2024-09-06 16:07:36',3),(306,4,9,'Coba 1',1000000.00,0.00,'Y','2024-09-06 14:50:39','2024-09-06 14:50:39',3),(307,4,9,'Coba 2',0.00,1000000.00,'Y','2024-09-06 14:50:57','2024-09-06 14:50:57',3),(308,6,9,'Tes',10000.00,0.00,'Y','2024-09-06 15:27:51','2024-09-06 15:27:51',3),(309,6,9,'sad',0.00,10000.00,'Y','2024-09-06 15:28:24','2024-09-06 15:28:24',3);

--
-- Table structure for table `t_recrusivejurnaltemplate`
--

CREATE TABLE `t_recrusivejurnaltemplate` (
  `T_RecrusiveJurnalTemplateID` int(11) NOT NULL AUTO_INCREMENT,
  `T_RecrusiveJurnalTemplateNumber` varchar(20) NOT NULL,
  `T_RecrusiveJurnalTemplateStartDate` date NOT NULL,
  `T_RecrusiveJurnalTemplateEndDate` date NOT NULL,
  `T_RecrusiveJurnalTemplateTenor` int(11) NOT NULL,
  `T_RecrusiveJurnalTemplatePrePaid` decimal(10,0) NOT NULL,
  `T_RecrusiveJurnalTemplateCreditCoaID` int(11) NOT NULL,
  `T_RecrusiveJurnalTemplateDebetCoaID` int(11) NOT NULL,
  `T_RecrusiveJurnalTemplateMonthly` decimal(10,0) NOT NULL,
  `T_RecrusiveJurnalTemplateCreated` datetime NOT NULL,
  `T_RecrusiveJurnalTemplateCreatedUserID` int(11) NOT NULL,
  `T_RecrusiveJurnalTemplateLastUpdated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `T_RecrusiveJurnalTemplateLastUpdatedUserID` int(11) NOT NULL,
  `T_RecrusiveJurnalTemplateIsActive` char(1) NOT NULL DEFAULT 'Y',
  `T_RecrusiveJurnalTemplateDeleted` datetime NOT NULL,
  `T_RecrusiveJurnalTemplateDeletedUserID` int(11) NOT NULL,
  PRIMARY KEY (`T_RecrusiveJurnalTemplateID`),
  KEY `T_RecrusiveJurnalTemplateCreditCoaID` (`T_RecrusiveJurnalTemplateCreditCoaID`),
  KEY `T_RecrusiveJurnalTemplateDebetCoaID` (`T_RecrusiveJurnalTemplateDebetCoaID`),
  KEY `T_RecrusiveJurnalTemplateNumber` (`T_RecrusiveJurnalTemplateNumber`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t_recrusivejurnaltemplate`
--

INSERT INTO `t_recrusivejurnaltemplate` VALUES (1,'RJT24090001','2024-09-12','2024-12-31',3,1000000,9,14,333333,'2024-09-12 16:07:54',3,'2024-09-12 09:07:54',0,'Y','0000-00-00 00:00:00',0),(2,'RJT24090002','2024-09-13','2025-02-28',5,100000,9,14,20000,'2024-09-13 11:18:10',3,'2024-09-13 04:18:10',0,'Y','0000-00-00 00:00:00',0),(3,'RJT24090003','2024-09-13','2025-02-28',5,100000,9,35,20000,'2024-09-13 11:19:18',3,'2024-09-13 08:41:59',0,'N','2024-09-13 15:41:59',3),(4,'RJT24090004','2024-09-13','2025-05-31',8,100000,9,14,12500,'2024-09-13 11:21:27',3,'2024-09-13 08:40:28',3,'N','2024-09-13 15:40:28',3);

--
-- Table structure for table `unitconvert`
--

CREATE TABLE `unitconvert` (
  `UnitConvertID` int(11) NOT NULL AUTO_INCREMENT,
  `UnitConvertFromItemUnitID` int(11) DEFAULT NULL,
  `UnitConvertToItemUnitID` int(11) DEFAULT NULL,
  `UnitConvertAmount` double DEFAULT NULL,
  `UnitConvertIsActive` char(1) NOT NULL DEFAULT 'Y',
  `UnitConvertUserID` int(11) DEFAULT NULL,
  `UnitConvertCreated` datetime DEFAULT NULL,
  `UnitConvertLAstUpdated` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`UnitConvertID`),
  KEY `UnitConvertFronItemUnitID` (`UnitConvertFromItemUnitID`),
  KEY `UnitConvertToItemUnitID` (`UnitConvertToItemUnitID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `unitconvert`
--

INSERT INTO `unitconvert` VALUES (3,8,7,150,'Y',3,'2024-09-24 15:35:46','2024-09-24 08:36:23'),(4,2,1,5,'Y',3,'2024-09-24 16:50:14','2024-09-24 09:50:14');

--
-- Table structure for table `usergroup_report`
--

CREATE TABLE `usergroup_report` (
  `UserGroupReportID` int(11) NOT NULL AUTO_INCREMENT,
  `UserGroupReportM_UserGroupID` int(11) DEFAULT NULL,
  `UserGroupReportR_ReportID` int(11) DEFAULT NULL,
  `UserGroupReportIsActive` varchar(1) DEFAULT 'Y',
  `UserGroupReportCreated` datetime DEFAULT current_timestamp(),
  `UserGroupReportLastUpdated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `UserGroupUserID` int(11) DEFAULT 0,
  PRIMARY KEY (`UserGroupReportID`),
  KEY `UserGroupReportIsActive` (`UserGroupReportIsActive`),
  KEY `UserGroupReportM_UserGroupID` (`UserGroupReportM_UserGroupID`),
  KEY `UserGroupReportR_ReportID` (`UserGroupReportR_ReportID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `usergroup_report`
--

INSERT INTO `usergroup_report` VALUES (1,1,1,'Y','2025-01-16 09:16:27','2025-01-16 09:16:27',0),(2,1,2,'Y','2025-01-16 09:46:12','2025-01-16 09:46:12',0),(3,1,3,'Y','2025-01-16 09:46:15','2025-01-16 09:46:15',0);

--
-- Dumping routines for database 'acc_one'
--
/*!50003 DROP FUNCTION IF EXISTS `fn_numbering` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `fn_numbering`(`type` char(30)) RETURNS varchar(25) CHARSET latin1
    READS SQL DATA
begin	declare number varchar(50);
	declare prefix varchar(50);
	declare prefix_date  varchar(50);
	declare sufix varchar(50);
	declare counter int;
	declare dgt int;
	declare rst varchar(5);
	declare udt datetime;


         select S_NumberingPrefix, S_NumberingPrefixDate, S_NumberingSufix, S_NumberingCounter, S_NumberingDigit, S_NumberingReset, 
             S_NumberingLastUpdated	
             into prefix, prefix_date, sufix, counter, dgt, rst, udt	
             from s_numbering	where S_NumberingType = type	for update;

	if rst = 'D' then
		if date_format(udt, '%Y-%m-%d') <> date_format(now(), '%Y-%m-%d') then
			set counter = 1;
		end if;
	elseif rst = 'M' then
		if date_format(udt, '%Y-%m') <> date_format(now(), '%Y-%m') then
			set counter = 1;
		end if;
	elseif rst = 'Y' then
		if date_format(udt, '%Y') <> date_format(now(), '%Y') then
			set counter = 1;
		end if;
	end if;

	set number = '';
	if prefix is not null and prefix <> '' then
		set number = trim(prefix);
	end if;
	if prefix_date is not null and prefix_date <> '' then
		set number = concat(trim(number),date_format(now(),prefix_date));
                
                if type = 'P' then
                       set number = concat( prefix,fn_numbering_year(now())); 
                end if;
                
                
                
               if type = 'L' then	 
	               set number = fn_get_prefix_nolab( now() );
               end if;
                if type = 'PAY' then
                       set number = concat( trim(prefix),fn_numbering_year(now()), fn_numbering_month(now()) ); 
                end if;
	end if;

	if rst = 'X' then
		set number = counter;
	else
                 if type='PAY' then
                      set @s_counter = lpad(counter,dgt,'0');
                      set @xternal =  (
                            select numberMapTarget
                            from number_map
                            where
                            numberMapOrigin = @s_counter
                            limit 0,1
                       );
                      set number = concat(trim(number), trim(@xternal) );
		else 
                      set number = concat(trim(number), lpad(counter,dgt,'0'));
                 end if;
	end if;
	if sufix is not null and sufix <> '' then
		set number = concat(trim(number),trim(sufix));
	end if;
    
        
       
       if type = 'L' then
           set @branch_code = (select M_BranchCode from m_branch where M_BranchIsActive = 'Y' 
                and M_BranchIsDefault = 'Y' limit 0,1 );
            set number = concat(number,@branch_code);
        end if;
	update s_numbering set S_NumberingCounter = counter + 1, S_NumberingLastUpdated = NOW() where S_NumberingType=type;
	return trim(number);


END ;;
DELIMITER ;
/*!50003 DROP FUNCTION IF EXISTS `fn_sys_breadcrumb` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` FUNCTION `fn_sys_breadcrumb`(`pPath` varchar(300), `pUserID` int) RETURNS varchar(300) CHARSET utf8mb4
    READS SQL DATA
begin

set @pPath2 = concat(pPath,'/');
set @pPath3 = substr(pPath, 0, length(pPath) - 1);
set @name = null;

if @name is null then 
   return '';
end if;

if @parentID > 0 then 
  set @child_name = @name;
  set @menuID = @parentID;
  
  set @name = null;
  set @parentID=null;
  select S_MenuParentS_MenuID , S_MenuName
  into @parentID, @name
  from s_menu where S_MenuID = @menuID;

  if @name is  null then 
       return @child_name;
  end if;

  set @child_name =  concat(@name, "::", @child_name);
  if @parentID = 0 then 
      set @menuID = @parentID;
  end if;
  set @name = null;
  set @parentID=null;
  select S_MenuParentS_MenuID , S_MenuName
  into @parentID, @name
  from s_menu where S_MenuID = @menuID;
  if @name is  null then 
       return @child_name;
  end if;
  set @child_name =  concat(@name, "::", @child_name);
  return @child_name;

else 
  return @name;  
end if;


end ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_acc_001` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_rpt_acc_001`(IN `username` varchar(100))
SELECT 
coaID,
	coaAccountNo,
	case
when coaLevel = '1' and  coaIsInput = 'N' then concat("<B>" ,coaDescription,"</B>" )
when coaLevel = '1' and  coaIsInput = 'Y' then concat("&nbsp;&nbsp;&nbsp;&nbsp;" ,coaDescription)
when coaLevel = '2'  then concat("<B>&nbsp; " ,coaDescription,"</B>" )
when coaLevel = '3'  then concat("&nbsp;&nbsp; " ,coaDescription)
when coaLevel = '4'  then concat("&nbsp;&nbsp; &nbsp; " ,coaDescription)
when coaLevel = '5'  then concat("&nbsp;&nbsp;&nbsp;&nbsp; " ,coaDescription) else '' end as coaDescription,
	coaSubDescription,
	coaAccountType,
	coaIsInput,
	coaReportSchedule,
	coaCurrencyCode,
	coaCashFlowCategory,
	coaCreated,
	coaLastUpdated,
	coaIsActive,
	coaLevel
FROM `coa`
WHERE `coaIsActive` = 'Y' ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_acc_001_company` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_rpt_acc_001_company`(IN `CompanyID` int(11))
SELECT M_BranchCompanyID,
M_BranchCompanyName,
M_BranchCompanyIsActive,
M_BranchCompanyUserID,
M_BranchCompanyCreated,
M_BranchCompanyLastUpdated,
M_BranchCompanyDetailID,
M_BranchCompanyDetailM_BranchCode,
M_BranchCompanyDetailOwnership,
M_BranchCompanyDetailIsActive,
M_BranchCompanyDetailUserID,
M_BranchCompanyDetailCreated,
M_BranchCompanyDetailLastUpdated
FROM m_branch_company
JOIN m_branch_companydetail ON M_BranchCompanyID = M_BranchCompanyDetailM_BranchCompanyID
AND M_BranchCompanyDetailIsActive = 'Y'
AND M_BranchCompanyIsActive = 'Y'
AND M_BranchCompanyID = CompanyID ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_acc_001_new` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_rpt_acc_001_new`(IN `username` varchar(100))
SELECT 
coaID,
	coaAccountNo,
	case
when coaLevel = '1' and  coaIsInput = 'N' then concat("<B>" ,coaDescription,"</B>" )
when coaLevel = '1' and  coaIsInput = 'Y' then concat("&nbsp;&nbsp;&nbsp;&nbsp;" ,coaDescription)
when coaLevel = '2'  then concat("<B>&nbsp; " ,coaDescription,"</B>" )
when coaLevel = '3'  then concat("&nbsp;&nbsp; " ,coaDescription)
when coaLevel = '4'  then concat("&nbsp;&nbsp; &nbsp; " ,coaDescription)
when coaLevel = '5'  then concat("&nbsp;&nbsp;&nbsp;&nbsp; " ,coaDescription)
when coaLevel = '6'  then concat("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; " ,coaDescription)
when coaLevel = '7'  then concat("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; " ,coaDescription)
else '' end as coaDescription,
	coaSubDescription,
	coaAccountType,
        coaSpecialAccountType,
	coaIsInput,
	coaReportSchedule,
	coaCurrencyCode,
	coaCashFlowCategory,
	coaCreated,
	coaLastUpdated,
	coaIsActive,
	coaLevel
FROM `coa`
WHERE `coaIsActive` = 'Y' ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_acc_002` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_rpt_acc_002`(IN `username` varchar(100))
SELECT 
coaID,
coaAccountNo,
 coaDescription, 
"" as Debit,
"" as Kredit 
FROM `coa`
WHERE `coaIsActive` = 'Y' and coaIsInput = 'Y'  order by coaAccountNo ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_branch_code_acc_dropdown` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_rpt_branch_code_acc_dropdown`()
SELECT M_BranchCode AS code, concat(M_BranchName, ' (', M_BranchCode, ')')  as name,M_BranchID AS id, M_BranchS_RegionalID  as regionalID
FROM m_branch
WHERE M_BranchIsActive = 'Y'
ORDER BY M_BranchCode ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_branch_company_acc` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_rpt_branch_company_acc`(IN `PCompany` varchar(110))
SELECT M_BranchCompanyID as id,  M_BranchCompanyName as name
FROM `m_branch_company`
WHERE `M_BranchCompanyName` LIKE concat('%', PCompany, '%')
 and M_BranchCompanyIsActive = 'Y' ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_jurnal_001` */;
DELIMITER ;;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_jurnal_002` */;
DELIMITER ;;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_jurnal_003` */;
DELIMITER ;;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_jurnal_004` */;
DELIMITER ;;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_period_acc` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_rpt_period_acc`(IN `PPeriod` varchar(110))
SELECT periodeID as id,  periodeName as name
FROM `periode`
WHERE `periodeName` LIKE concat('%', PPeriod, '%')
 and periodeIsActive = 'Y' ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_rpt_regional_acc` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_rpt_regional_acc`(IN `PRegional` varchar(110))
SELECT S_RegionalID as id,  S_RegionalName as name
FROM `s_regional`
WHERE `S_RegionalName` LIKE concat('%', PRegional, '%')
 and S_RegionalIsActive = 'Y' ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_sys_menu_group` */;
DELIMITER ;;

END ;;
DELIMITER ;
/*!50003 DROP PROCEDURE IF EXISTS `sp_sys_menu_user` */;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_sys_menu_user`(IN `uid` int)
BEGIN

DECLARE gid INTEGER;
CALL sp_sys_menu_group(gid);

END ;;
DELIMITER ;


