-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 08, 2023 at 08:49 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `akssimakom6_sma`
--

-- --------------------------------------------------------

--
-- Table structure for table `billing`
--

CREATE TABLE `billing` (
  `no` int(11) NOT NULL,
  `id` varchar(15) NOT NULL,
  `nis` varchar(18) NOT NULL,
  `nama` varchar(150) NOT NULL,
  `id_siswa` varchar(20) NOT NULL,
  `tahun` date NOT NULL,
  `created_at` datetime NOT NULL,
  `status` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bulanan`
--

CREATE TABLE `bulanan` (
  `no` int(11) NOT NULL,
  `bulan` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bulanan`
--

INSERT INTO `bulanan` (`no`, `bulan`) VALUES
(1, 'Juli'),
(2, 'Agustus'),
(3, 'September'),
(4, 'Oktober'),
(5, 'Nopember'),
(6, 'Desember'),
(7, 'Januari'),
(8, 'Februari'),
(9, 'Maret'),
(10, 'April'),
(11, 'Mei'),
(12, 'Juni');

-- --------------------------------------------------------

--
-- Table structure for table `db_setor2324`
--

CREATE TABLE `db_setor2324` (
  `no` int(11) NOT NULL,
  `tanggal_draf` datetime NOT NULL,
  `jumlah` varchar(15) NOT NULL,
  `uraian` text NOT NULL,
  `setor_status` varchar(10) NOT NULL,
  `setor_tanggal` datetime NOT NULL,
  `terima_status` varchar(10) NOT NULL,
  `terima_tanggal` datetime NOT NULL,
  `penyetor` varchar(50) NOT NULL,
  `penerima` varchar(50) NOT NULL,
  `id_rkas` varchar(50) NOT NULL,
  `tahun` varchar(10) NOT NULL,
  `id_setor` varchar(50) NOT NULL,
  `created_by` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  `id` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `db_transaksi2324`
--

CREATE TABLE `db_transaksi2324` (
  `no` int(11) NOT NULL,
  `tanggal` datetime NOT NULL,
  `nis` varchar(18) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `kelamin` varchar(2) NOT NULL,
  `jenjang` varchar(5) NOT NULL,
  `paralel` varchar(50) NOT NULL,
  `jenis` varchar(2) NOT NULL,
  `tahap` float NOT NULL,
  `jumlah` varchar(15) NOT NULL,
  `random` varchar(20) NOT NULL,
  `penerima` varchar(100) NOT NULL,
  `setor` varchar(10) NOT NULL,
  `id_setor` varchar(50) NOT NULL,
  `metode` varchar(20) NOT NULL,
  `catatan` text DEFAULT NULL,
  `time` datetime NOT NULL,
  `ip` varchar(30) NOT NULL,
  `browser` text DEFAULT NULL,
  `id_tr` varchar(50) NOT NULL,
  `id` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `deleted`
--

CREATE TABLE `deleted` (
  `no` int(11) NOT NULL,
  `deleted_time` datetime NOT NULL,
  `deleted_user` varchar(100) NOT NULL,
  `deleted_ip` varchar(20) NOT NULL,
  `deleted_browser` varchar(100) NOT NULL,
  `deleted_alasan` text NOT NULL,
  `tanggal` date NOT NULL,
  `nama` varchar(75) NOT NULL,
  `nis` varchar(18) NOT NULL,
  `kelamin` varchar(10) NOT NULL,
  `jenjang` varchar(10) NOT NULL,
  `paralel` varchar(20) NOT NULL,
  `jenis` varchar(5) NOT NULL,
  `tahap` varchar(2) NOT NULL,
  `jumlah` varchar(15) NOT NULL,
  `random` varchar(17) NOT NULL,
  `penerima` varchar(75) NOT NULL,
  `setor` varchar(10) DEFAULT NULL,
  `id_setor` varchar(15) NOT NULL,
  `tgl_setor` date NOT NULL,
  `terima` varchar(15) DEFAULT NULL,
  `tgl_terima` date NOT NULL,
  `metode` varchar(20) DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `time` datetime NOT NULL,
  `ip` varchar(20) NOT NULL,
  `browser` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `deleted_tabungan`
--

CREATE TABLE `deleted_tabungan` (
  `no` int(11) NOT NULL,
  `tanggal` date NOT NULL,
  `nis` varchar(18) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `jenis` varchar(2) NOT NULL,
  `jumlah` varchar(15) NOT NULL,
  `jurnal` varchar(2) NOT NULL,
  `catatan` text NOT NULL,
  `created_by` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  `id` varchar(50) NOT NULL,
  `deleted_at` datetime NOT NULL,
  `deleted_by` text NOT NULL,
  `browser` text NOT NULL,
  `ip` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `deleted_transaksi`
--

CREATE TABLE `deleted_transaksi` (
  `no` int(11) NOT NULL,
  `tanggal` datetime NOT NULL,
  `nis` varchar(18) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `kelamin` varchar(2) NOT NULL,
  `jenjang` varchar(5) NOT NULL,
  `paralel` varchar(50) NOT NULL,
  `jenis` varchar(2) NOT NULL,
  `tahap` float NOT NULL,
  `jumlah` varchar(15) NOT NULL,
  `random` varchar(20) NOT NULL,
  `penerima` varchar(100) NOT NULL,
  `setor` varchar(10) NOT NULL,
  `id_setor` varchar(50) NOT NULL,
  `metode` varchar(20) NOT NULL,
  `catatan` text DEFAULT NULL,
  `time` datetime NOT NULL,
  `ip` varchar(30) NOT NULL,
  `browser` text DEFAULT NULL,
  `id_tr` varchar(50) NOT NULL,
  `id` varchar(50) NOT NULL,
  `deleted_by` varchar(100) NOT NULL,
  `deleted_at` datetime NOT NULL,
  `alasan` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `kd_namabayar`
--

CREATE TABLE `kd_namabayar` (
  `no` int(11) NOT NULL,
  `kode` varchar(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `kd_namabayar`
--

INSERT INTO `kd_namabayar` (`no`, `kode`) VALUES
(1, 'A'),
(2, 'B'),
(3, 'C'),
(4, 'D'),
(5, 'E'),
(6, 'F'),
(7, 'G'),
(8, 'H'),
(9, 'I'),
(10, 'J'),
(11, 'K'),
(12, 'L'),
(13, 'M'),
(14, 'N'),
(15, 'O'),
(16, 'P'),
(17, 'Q'),
(18, 'R'),
(19, 'S'),
(20, 'T'),
(21, 'U'),
(22, 'V'),
(23, 'W'),
(24, 'X'),
(25, 'Y'),
(26, 'Z');

-- --------------------------------------------------------

--
-- Table structure for table `kuitansi_pejabat`
--

CREATE TABLE `kuitansi_pejabat` (
  `no` int(11) NOT NULL,
  `pejabat` varchar(75) NOT NULL,
  `jabatan` varchar(75) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `log`
--

CREATE TABLE `log` (
  `no` int(11) NOT NULL,
  `waktu` datetime NOT NULL,
  `user` varchar(100) NOT NULL,
  `aksi` varchar(10) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `browser` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `log`
--

INSERT INTO `log` (`no`, `waktu`, `user`, `aksi`, `ip`, `browser`) VALUES
(1, '2023-11-08 14:07:27', 'admin', 'admin', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0'),
(2, '2023-11-08 14:09:33', 'admin', 'admin', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0'),
(3, '2023-11-08 14:15:49', 'admin', 'admin', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/119.0');

-- --------------------------------------------------------

--
-- Table structure for table `mailer`
--

CREATE TABLE `mailer` (
  `no` int(11) NOT NULL,
  `aktif` varchar(1) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(50) DEFAULT NULL,
  `server` text NOT NULL,
  `port` varchar(5) DEFAULT NULL,
  `id` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `mailer`
--

INSERT INTO `mailer` (`no`, `aktif`, `email`, `password`, `server`, `port`, `id`) VALUES
(1, '1', '', '', 'smtp.gmail.com', '587', 'a2d1b94z548ced30cd7bf030568e2e8b8');

-- --------------------------------------------------------

--
-- Table structure for table `pajak`
--

CREATE TABLE `pajak` (
  `no` int(11) NOT NULL,
  `pasal` varchar(75) NOT NULL,
  `kode` varchar(5) NOT NULL,
  `akun` varchar(6) NOT NULL,
  `pajak` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pajak`
--

INSERT INTO `pajak` (`no`, `pasal`, `kode`, `akun`, `pajak`) VALUES
(1, 'PPh Ps 21', '21', '411121', 'ya'),
(2, 'PPh Ps 22', '22', '411122', 'ya'),
(3, 'PPh Ps 23', '23', '411124', 'ya'),
(4, 'PPh Ps 4', '24', '411128', 'ya'),
(5, 'PPN', '25', '411211', 'ya');

-- --------------------------------------------------------

--
-- Table structure for table `payment_list2324`
--

CREATE TABLE `payment_list2324` (
  `no` int(11) NOT NULL,
  `tanggal` date NOT NULL,
  `nis` varchar(18) NOT NULL,
  `nama` varchar(120) NOT NULL,
  `jenjang` varchar(10) NOT NULL,
  `paralel` varchar(50) NOT NULL,
  `hp` varchar(18) NOT NULL,
  `email` varchar(100) NOT NULL,
  `jumlah` varchar(15) NOT NULL,
  `status` varchar(15) NOT NULL,
  `keterangan` text NOT NULL,
  `payment_id` varchar(50) NOT NULL,
  `tahun` varchar(9) NOT NULL,
  `created_at` datetime NOT NULL,
  `id` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `payment_list_detail`
--

CREATE TABLE `payment_list_detail` (
  `no` int(11) NOT NULL,
  `tanggal` datetime NOT NULL,
  `nis` varchar(18) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `kelamin` varchar(2) NOT NULL,
  `jenjang` varchar(5) NOT NULL,
  `paralel` varchar(50) NOT NULL,
  `jenis` varchar(2) NOT NULL,
  `tahap` float NOT NULL,
  `jumlah` varchar(15) NOT NULL,
  `random` varchar(20) NOT NULL,
  `penerima` varchar(100) NOT NULL,
  `setor` varchar(10) NOT NULL,
  `id_setor` varchar(50) NOT NULL,
  `metode` varchar(20) NOT NULL,
  `catatan` text DEFAULT NULL,
  `time` datetime NOT NULL,
  `ip` varchar(30) NOT NULL,
  `browser` text DEFAULT NULL,
  `id_tr` varchar(50) NOT NULL,
  `payment_id` varchar(50) NOT NULL,
  `id` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `payment_set`
--

CREATE TABLE `payment_set` (
  `no` int(11) NOT NULL,
  `aktif` varchar(1) DEFAULT NULL,
  `sistem` varchar(2) NOT NULL,
  `api` text DEFAULT NULL,
  `callback` text DEFAULT NULL,
  `fee` varchar(15) NOT NULL,
  `id` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `payment_set`
--

INSERT INTO `payment_set` (`no`, `aktif`, `sistem`, `api`, `callback`, `fee`, `id`) VALUES
(1, '', '', '', '', '0', 'E0C1A06358CCF7F36F2D151AFBD46E4A');

-- --------------------------------------------------------

--
-- Table structure for table `payment_temp`
--

CREATE TABLE `payment_temp` (
  `no` int(11) NOT NULL,
  `tanggal` datetime NOT NULL,
  `nis` varchar(18) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `kelamin` varchar(2) NOT NULL,
  `jenjang` varchar(5) NOT NULL,
  `paralel` varchar(50) NOT NULL,
  `jenis` varchar(2) NOT NULL,
  `tahap` float NOT NULL,
  `jumlah` varchar(15) NOT NULL,
  `random` varchar(20) NOT NULL,
  `penerima` varchar(100) NOT NULL,
  `setor` varchar(10) NOT NULL,
  `id_setor` varchar(50) NOT NULL,
  `metode` varchar(20) NOT NULL,
  `catatan` text DEFAULT NULL,
  `time` datetime NOT NULL,
  `ip` varchar(30) NOT NULL,
  `browser` text DEFAULT NULL,
  `id_tr` varchar(20) NOT NULL,
  `payment_id` varchar(50) NOT NULL,
  `id` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sekolah`
--

CREATE TABLE `sekolah` (
  `no` int(11) NOT NULL,
  `sekolah` varchar(200) NOT NULL,
  `alamat` varchar(150) NOT NULL,
  `kota` varchar(20) NOT NULL,
  `jenjang` varchar(4) NOT NULL,
  `nama_kuitansi` varchar(25) NOT NULL,
  `info_kuitansi` varchar(10) NOT NULL,
  `info_tahap` varchar(10) NOT NULL,
  `info_kettrans` varchar(20) NOT NULL,
  `bg` varchar(10) NOT NULL,
  `menu` varchar(5) NOT NULL,
  `versi` varchar(10) NOT NULL,
  `bg_color` varchar(20) NOT NULL,
  `nama_pimpinan` varchar(100) NOT NULL,
  `pimpinan` varchar(50) NOT NULL,
  `model_kw` varchar(20) NOT NULL,
  `startPeriode` varchar(20) NOT NULL,
  `tgl_backup` date NOT NULL,
  `kops1` text NOT NULL,
  `kops2` text NOT NULL,
  `simakom_bendahara_nama` varchar(250) NOT NULL,
  `simakom_bendahara_nip` varchar(18) NOT NULL,
  `simakom_atasan_nama` varchar(250) NOT NULL,
  `simakom_atasan_nip` varchar(118) NOT NULL,
  `simakom_atasan_jabatan` varchar(250) NOT NULL,
  `simakom_atasan2_nama` varchar(250) NOT NULL,
  `simakom_atasan2_jabatan` varchar(250) NOT NULL,
  `simakom_ppk_nama` varchar(200) NOT NULL,
  `simakom_ppk_nip` varchar(18) NOT NULL,
  `simakom_ppk_jabatan` varchar(200) NOT NULL,
  `notice` text DEFAULT NULL,
  `notice2` text DEFAULT NULL,
  `tk` text DEFAULT NULL,
  `tp` varchar(10) NOT NULL,
  `id` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `sekolah`
--

INSERT INTO `sekolah` (`no`, `sekolah`, `alamat`, `kota`, `jenjang`, `nama_kuitansi`, `info_kuitansi`, `info_tahap`, `info_kettrans`, `bg`, `menu`, `versi`, `bg_color`, `nama_pimpinan`, `pimpinan`, `model_kw`, `startPeriode`, `tgl_backup`, `kops1`, `kops2`, `simakom_bendahara_nama`, `simakom_bendahara_nip`, `simakom_atasan_nama`, `simakom_atasan_nip`, `simakom_atasan_jabatan`, `simakom_atasan2_nama`, `simakom_atasan2_jabatan`, `simakom_ppk_nama`, `simakom_ppk_nip`, `simakom_ppk_jabatan`, `notice`, `notice2`, `tk`, `tp`, `id`) VALUES
(1, '', '', '', '', 'Nama Siswa', 'no', 'no', 'no', 'primary', '', '', 'primary', '', '', '6', '1', '2023-11-08', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'TERIMA KASIH', '2023/2024', 'E0C1A06358CCF7F36F2D151AFBD46E4A');

-- --------------------------------------------------------

--
-- Table structure for table `serial`
--

CREATE TABLE `serial` (
  `no` int(11) NOT NULL,
  `sekolah` varchar(200) NOT NULL,
  `seri` varchar(100) NOT NULL,
  `aktivasi` varchar(100) NOT NULL,
  `tanggal` date NOT NULL,
  `id` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `serial`
--

INSERT INTO `serial` (`no`, `sekolah`, `seri`, `aktivasi`, `tanggal`, `id`) VALUES
(1, '', '', '', '2023-11-08', 'E0C1A06358CCF7F36F2D151AFBD46E4A');

-- --------------------------------------------------------

--
-- Table structure for table `simakom_akun2324`
--

CREATE TABLE `simakom_akun2324` (
  `no` int(11) NOT NULL,
  `kategori` varchar(1) NOT NULL,
  `kegiatan` varchar(4) NOT NULL,
  `komponen` varchar(5) NOT NULL,
  `akun` float NOT NULL,
  `uraian` text NOT NULL,
  `kode_id` varchar(20) NOT NULL,
  `akun_id` varchar(15) NOT NULL,
  `id` varchar(100) NOT NULL,
  `revisi` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `simakom_akun2324`
--

INSERT INTO `simakom_akun2324` (`no`, `kategori`, `kegiatan`, `komponen`, `akun`, `uraian`, `kode_id`, `akun_id`, `id`, `revisi`) VALUES
(1, 'A', '1000', 'A', 100000, 'Penerimaan Saldo Tahun Lalu', 'A1000A', 'A1000100000A', 'eaba27fc567ba70270e7a70fa', '0'),
(2, 'A', '1001', 'A', 100102, 'Penerimaan Sumbangan Pengembangan Sekolah', 'A1001A', 'A1001100102A', '338d77fc5637e33270e7a70fa', '0'),
(6, 'A', '1003', 'A', 100302, 'Uang Kegiatan', 'A1003A', 'A1003100302A', '0c10b7fc568c75c270e7a70fa', '0'),
(8, 'B', '2000', 'A', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2000A', 'B2000200106A', '097dd9d5ed90c1a270e7a70fa', '0'),
(9, 'B', '2000', 'B', 200501, 'Belanja Perjaanan Dinas', 'B2000B', 'B2000200501B', 'a2b349d5ed90c1a678fe57bcc', '0'),
(10, 'B', '2000', 'B', 200105, 'Belanja Honor Kegiatan', 'B2000B', 'B2000200105B', 'a52489d5ed90c1a678fe57bcc', '0'),
(11, 'B', '2000', 'B', 200302, 'Belanja Bahan', 'B2000B', 'B2000200302B', '1ed6c9d5ed90c1a678fe57bcc', '0'),
(12, 'B', '2000', 'B', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2000B', 'B2000200106B', '097dd9d5ed90c1a678fe57bcc', '0'),
(13, 'B', '2000', 'B', 200402, 'Belanja Sewa', 'B2000B', 'B2000200402B', '7f7b19d5ed90c1a678fe57bcc', '0'),
(150, 'B', '2001', 'A', 200105, 'Belanja Honor Kegiatan', 'B2001A', 'B2001200105F', 'a52489d5edb963f8943025315', '0'),
(30, 'B', '2002', 'A', 200302, 'Belanja Bahan', 'B2002A', 'B2002200302A', '1ed6c9d5ed29b9f270e7a70fa', '0'),
(31, 'B', '2002', 'A', 200401, 'Belanja Jasa Profesi', 'B2002A', 'B2002200401A', '2aa949d5ed29b9f270e7a70fa', '0'),
(32, 'B', '2002', 'B', 200301, 'Belanja Keperluan Perkantoran', 'B2002B', 'B2002200301B', 'a52489d5ed29b9f2dffc6cb06', '0'),
(181, 'B', '2002', 'M', 200105, 'Belanja Honor Kegiatan', 'B2002M', 'B2002200105Z3', 'a52489d5ed29b9fac6776e733', '0'),
(186, 'B', '2002', 'I', 200105, 'Belanja Honor Kegiatan', 'B2002I', 'B2002200105I', 'a52489d5ed29b9f6794b63bf9', '0'),
(35, 'B', '2002', 'C', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2002C', 'B2002200106C', '097dd9d5ed29b9f6b051f63d7', '0'),
(36, 'B', '2002', 'D', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2002D', 'B2002200106D', '097dd9d5ed29b9f097d2fa7a4', '0'),
(38, 'B', '2002', 'F', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2002F', 'B2002200106F', '097dd9d5ed29b9f67b72d78b7', '0'),
(43, 'B', '2002', 'H', 200302, 'Belanja Bahan', 'B2002H', 'B2002200302H', '1ed6c9d5ed29b9f75af30e62b', '0'),
(50, 'B', '2002', 'L', 200302, 'Belanja Bahan', 'B2002L', 'B2002200302L', '1ed6c9d5ed29b9f50f86825a1', '0'),
(53, 'B', '2002', 'N', 200105, 'Belanja Honor Kegiatan', 'B2002N', 'B2002200105N', 'a52489d5ed29b9fc7bdcc3ce6', '0'),
(55, 'B', '2002', 'N', 200401, 'Belanja Jasa Profesi', 'B2002N', 'B2002200401N', '2aa949d5ed29b9fc7bdcc3ce6', '0'),
(64, 'B', '2002', 'R', 200302, 'Belanja Bahan', 'B2002R', 'B2002200302R', '1ed6c9d5ed29b9f3d40573127', '0'),
(66, 'B', '2002', 'R', 200105, 'Belanja Honor Kegiatan', 'B2002R', 'B2002200105R', 'a52489d5ed29b9f3d40573127', '0'),
(67, 'B', '2002', 'S', 200105, 'Belanja Honor Kegiatan', 'B2002S', 'B2002200105S', 'a52489d5ed29b9f8dcc983a70', '0'),
(69, 'B', '2002', 'S', 200302, 'Belanja Bahan', 'B2002S', 'B2002200302S', '1ed6c9d5ed29b9f8dcc983a70', '0'),
(70, 'B', '2002', 'T', 200105, 'Belanja Honor Kegiatan', 'B2002T', 'B2002200105T', 'a52489d5ed29b9f18c950afbf', '0'),
(71, 'B', '2002', 'T', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2002T', 'B2002200106T', '097dd9d5ed29b9f18c950afbf', '0'),
(72, 'B', '2002', 'T', 200302, 'Belanja Bahan', 'B2002T', 'B2002200302T', '1ed6c9d5ed29b9f18c950afbf', '0'),
(74, 'B', '2002', 'U', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2002U', 'B2002200106U', '097dd9d5ed29b9f360da93c0a', '0'),
(75, 'B', '2002', 'U', 200302, 'Belanja Bahan', 'B2002U', 'B2002200302U', '1ed6c9d5ed29b9f360da93c0a', '0'),
(76, 'B', '2002', 'Q', 200105, 'Belanja Honor Kegiatan', 'B2002Q', 'B2002200105V', 'a52489d5ed29b9f60a306a2e0', '0'),
(77, 'B', '2002', 'Q', 200302, 'Belanja Bahan', 'B2002Q', 'B2002200302V', '1ed6c9d5ed29b9f60a306a2e0', '0'),
(79, 'B', '2002', 'P', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2002P', 'B2002200106W', '097dd9d5ed29b9f06ea9a85a5', '0'),
(80, 'B', '2002', 'P', 200302, 'Belanja Bahan', 'B2002P', 'B2002200302W', '1ed6c9d5ed29b9f06ea9a85a5', '0'),
(82, 'B', '2002', 'O', 200105, 'Belanja Honor Kegiatan', 'B2002O', 'B2002200105Y', 'a52489d5ed29b9f4137b614c8', '0'),
(83, 'B', '2002', 'O', 200302, 'Belanja Bahan', 'B2002O', 'B2002200302Y', '1ed6c9d5ed29b9f4137b614c8', '0'),
(86, 'B', '2003', 'A', 200302, 'Belanja Bahan', 'B2003A', 'B2003200302A', '1ed6c9d5ed10243270e7a70fa', '0'),
(88, 'B', '2003', 'C', 299999, 'Belanja Lainnya', 'B2003C', 'B2003299999C', 'f110f9d5ed102438370cad1d4', '0'),
(89, 'B', '2003', 'D', 200302, 'Belanja Bahan', 'B2003D', 'B2003200302D', '1ed6c9d5ed1024300cfc35332', '0'),
(90, 'B', '2003', 'D', 200501, 'Belanja Perjaanan Dinas', 'B2003D', 'B2003200501D', 'a2b349d5ed1024300cfc35332', '0'),
(91, 'B', '2003', 'E', 200102, 'Belanja Honorarium Pegawai Tidak Tetap', 'B2003E', 'B2003200102E', 'ef7e89d5ed102438943025315', '0'),
(92, 'B', '2003', 'E', 200101, 'Belanja Honorarium Guru Tidak Tetap', 'B2003E', 'B2003200101E', '4c5069d5ed102438943025315', '0'),
(93, 'B', '2003', 'E', 200107, 'Belanja Honorarium THR Guru Tidak Tetap', 'B2003E', 'B2003200107E', '88e789d5ed102438943025315', '0'),
(94, 'B', '2003', 'E', 200108, 'Belanja Honorarium THR Pegawai Tidak Tetap', 'B2003E', 'B2003200108E', 'b81719d5ed102438943025315', '0'),
(99, 'B', '2003', 'E', 200113, 'Belanja Honorarium Petugas Piket Hari Libur', 'B2003E', 'B2003200113E', '6ec9d9d5ed102438943025315', '0'),
(101, 'B', '2003', 'F', 200105, 'Belanja Honor Kegiatan', 'B2003F', 'B2003200105F', 'a52489d5ed102438d0734569a', '0'),
(102, 'B', '2003', 'F', 200402, 'Belanja Sewa', 'B2003F', 'B2003200402F', '7f7b19d5ed102438d0734569a', '0'),
(187, 'B', '2002', 'K', 200302, 'Belanja Bahan', 'B2002K', 'B2002200302Z5', 'a52489d5ed29b9f418362b172', '0'),
(106, 'B', '2003', 'H', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2003H', 'B2003200106H', '097dd9d5ed1024370aca82419', '0'),
(107, 'B', '2003', 'G', 200105, 'Belanja Honor Kegiatan', 'B2003G', 'B2003200105I', '1ed6c9d5ed102436a11b03839', '0'),
(108, 'B', '2003', 'B', 200501, 'Belanja Perjaanan Dinas', 'B2003B', 'B2003200501J', 'a2b349d5ed10243ec3b48a1ee', '0'),
(109, 'B', '2003', 'B', 299999, 'Belanja Lainnya', 'B2003B', 'B2003299999J', 'f110f9d5ed10243ec3b48a1ee', '0'),
(110, 'B', '2003', 'B', 200403, 'Belanja Langganan Daya dan Jasa', 'B2003B', 'B2003200403J', '20a5d9d5ed10243ec3b48a1ee', '0'),
(111, 'B', '2003', 'B', 200302, 'Belanja Bahan', 'B2003B', 'B2003200302J', '1ed6c9d5ed10243ec3b48a1ee', '0'),
(112, 'B', '2004', 'A', 200501, 'Belanja Perjaanan Dinas', 'B2004A', 'B2004200501A', 'a2b349d5ed4b727270e7a70fa', '0'),
(151, 'B', '2002', 'L', 200105, 'Belanja Honor Kegiatan', 'B2002L', 'B2002200105L', 'a52489d5ed29b9fec3b48a1ee', '0'),
(122, 'B', '2005', 'B', 200302, 'Belanja Bahan', 'B2005B', 'B2005200302D', '1ed6c9d5ed268e98943025315', '0'),
(123, 'B', '2005', 'B', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2005B', 'B2005200106D', '097dd9d5ed268e98943025315', '0'),
(124, 'B', '2006', 'A', 200301, 'Belanja Keperluan Perkantoran', 'B2006A', 'B2006200301A', 'e623d9d5eda486c270e7a70fa', '0'),
(125, 'B', '2006', 'B', 200301, 'Belanja Keperluan Perkantoran', 'B2006B', 'B2006200301B', 'e623d9d5eda486c678fe57bcc', '0'),
(126, 'B', '2006', 'C', 200202, 'Belanja Pemeliharaan Peralatan dan Mesin', 'B2006C', 'B2006200202C', 'd404c9d5eda486c8370cad1d4', '0'),
(127, 'B', '2006', 'D', 200201, 'Belanja Pemeliharaan Gedung dan Bangunan', 'B2006D', 'B2006200201D', '5ad929d5eda486c75af30e62b', '0'),
(128, 'B', '2006', 'E', 200201, 'Belanja Pemeliharaan Gedung dan Bangunan', 'B2006E', 'B2006200201E', '5ad929d5eda486c00cfc35332', '0'),
(130, 'B', '2006', 'G', 200301, 'Belanja Keperluan Perkantoran', 'B2006G', 'B2006200301G', 'e623d9d5eda486c8d0734569a', '0'),
(131, 'B', '2006', 'H', 200302, 'Belanja Bahan', 'B2006H', 'B2006200302H', 'f110f9d5eda486c50f86825a1', '0'),
(133, 'B', '2006', 'I', 200202, 'Belanja Pemeliharaan Peralatan dan Mesin', 'B2006I', 'B2006200202J', 'd404c9d5eda486c70aca82419', '0'),
(134, 'B', '2006', 'F', 200301, 'Belanja Keperluan Perkantoran', 'B2006F', 'B2006200301K', 'e623d9d5eda486c6a11b03839', '0'),
(135, 'B', '2007', 'A', 200401, 'Belanja Jasa Profesi', 'B2007A', 'B2007200401A', '2aa949d5ede5eb0270e7a70fa', '0'),
(137, 'B', '2007', 'B', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2007B', 'B2007200106B', 'a52489d5ede5eb0678fe57bcc', '0'),
(138, 'B', '2007', 'C', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2007C', 'B2007200106C', 'a52489d5ede5eb08370cad1d4', '0'),
(141, 'B', '2007', 'E', 200302, 'Belanja Bahan', 'B2007E', 'B2007200302E', '1ed6c9d5ede5eb000cfc35332', '0'),
(145, 'B', '2007', 'D', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2007D', 'B2007200106H', 'f110f9d5ede5eb050f86825a1', '0'),
(146, 'B', '2007', 'D', 200105, 'Belanja Honor Kegiatan', 'B2007D', 'B2007200105H', 'a52489d5ede5eb050f86825a1', '0'),
(148, 'B', '2004', 'B', 200501, 'Belanja Perjaanan Dinas', 'B2004B', 'B2004200501D', 'a2b349d5ed4b72775af30e62b', '0'),
(152, 'B', '2002', 'G', 200105, 'Belanja Honor Kegiatan', 'B2002G', 'B2002200105G', '097dd9d5ed29b9f8d0734569a', '0'),
(153, 'B', '2002', 'H', 200105, 'Belanja Honor Kegiatan', 'B2002H', 'B2002200105H', '097dd9d5ed29b9f50f86825a1', '0'),
(155, 'B', '2002', 'N', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2002N', 'B2002200106N', '097dd9d5ed29b9f07cb7f3c4a', '0'),
(159, 'B', '2002', 'Q', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2002Q', 'B2002200106V', '097dd9d5ed29b9f60a306a2e0', '0'),
(161, 'B', '2001', 'B', 200105, 'Belanja Honor Kegiatan', 'B2001B', 'B2001200105G', 'a52489d5edb963f8d0734569a', '0'),
(162, 'B', '2003', 'A', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2003A', 'B2003200106A', '097dd9d5ed10243270e7a70fa', '0'),
(163, 'B', '2003', 'C', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2003C', 'B2003200106C', '097dd9d5ed102438370cad1d4', '0'),
(164, 'B', '2003', 'F', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2003F', 'B2003200106F', '097dd9d5ed102438943025315', '0'),
(167, 'B', '2004', 'A', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2004A', 'B2004200106A', '097dd9d5ed4b727270e7a70fa', '0'),
(168, 'B', '2006', 'D', 200202, 'Belanja Pemeliharaan Peralatan dan Mesin', 'B2006D', 'B2006200202D', 'd404c9d5eda486c75af30e62b', '0'),
(169, 'B', '2006', 'E', 200201, 'Belanja Pemeliharaan Gedung dan Bangunan', 'B2006E', 'B2006200201E', 'd404c9d5eda486c00cfc35332', '0'),
(170, 'B', '2006', 'H', 200201, 'Belanja Pemeliharaan Gedung dan Bangunan', 'B2006H', 'B2006200201H', '097dd9d5eda486c50f86825a1', '0'),
(171, 'B', '2007', 'A', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2007A', 'B2007200106A', '097dd9d5ede5eb0270e7a70fa', '0'),
(174, 'B', '2003', 'B', 200106, 'Belanja Penunjang Kegiatan Pendidikan', 'B2003B', 'B2003200106K', '097dd9d5ed102436a11b03839', '0'),
(188, 'B', '2002', 'K', 200302, 'Belanja Bahan', 'B2002K', 'B2002200302Z5', '1ed6c9d5ed29b9f418362b172', '0'),
(189, 'B', '2002', 'J', 200105, 'Belanja Honor Kegiatan', 'B2002J', 'B2002200105Z6', 'a52489d5ed29b9f86df3739da', '0'),
(190, 'B', '2002', 'J', 200302, 'Belanja Bahan', 'B2002J', 'B2002200302Z6', '1ed6c9d5ed29b9f86df3739da', '0'),
(191, 'B', '2002', 'E', 200105, 'Belanja Honor Kegiatan', 'B2002E', 'B2002200105Z7', 'a52489d5ed29b9fef78d93e91', '0'),
(192, 'B', '2002', 'E', 200302, 'Belanja Bahan', 'B2002E', 'B2002200302Z7', '1ed6c9d5ed29b9fef78d93e91', '0'),
(193, 'B', '2002', 'K', 200105, 'Belanja Honor Kegiatan', 'B2002K', 'B2002200105Z5', '4c5069d5ed29b9f418362b172', '0'),
(194, 'B', '2005', 'A', 200105, 'Belanja Honor Kegiatan', 'B2005A', 'B2005200105E1', 'a52489d5ed268e9d2db39237d', '0');

-- --------------------------------------------------------

--
-- Table structure for table `simakom_detail2324`
--

CREATE TABLE `simakom_detail2324` (
  `no` int(11) NOT NULL,
  `kategori` varchar(1) NOT NULL,
  `kegiatan` varchar(4) NOT NULL,
  `komponen` varchar(5) NOT NULL,
  `akun` float NOT NULL,
  `detail` float NOT NULL,
  `detail_id` varchar(20) NOT NULL,
  `uraian` text NOT NULL,
  `volume` varchar(15) NOT NULL,
  `satuan` varchar(50) NOT NULL,
  `unit` varchar(50) NOT NULL,
  `total` varchar(15) NOT NULL,
  `komponen_1` varchar(10) NOT NULL,
  `komponen_2` varchar(10) NOT NULL,
  `komponen_3` varchar(10) NOT NULL,
  `komponen_4` varchar(10) NOT NULL,
  `unit_1` varchar(100) NOT NULL,
  `unit_2` varchar(100) NOT NULL,
  `unit_3` varchar(100) NOT NULL,
  `unit_4` varchar(100) NOT NULL,
  `pembiayaan_id` varchar(50) NOT NULL,
  `pembiayaan_kegiatan` varchar(4) NOT NULL,
  `pembiayaan_komponen` varchar(5) NOT NULL,
  `pembiayaan_akun` varchar(6) NOT NULL,
  `revisi` varchar(10) NOT NULL,
  `time` datetime NOT NULL,
  `kode_id` varchar(20) NOT NULL,
  `id` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `simakom_detail2324`
--

INSERT INTO `simakom_detail2324` (`no`, `kategori`, `kegiatan`, `komponen`, `akun`, `detail`, `detail_id`, `uraian`, `volume`, `satuan`, `unit`, `total`, `komponen_1`, `komponen_2`, `komponen_3`, `komponen_4`, `unit_1`, `unit_2`, `unit_3`, `unit_4`, `pembiayaan_id`, `pembiayaan_kegiatan`, `pembiayaan_komponen`, `pembiayaan_akun`, `revisi`, `time`, `kode_id`, `id`) VALUES
(1, 'A', '1000', 'A', 100000, 1, 'A1000A10000000100', 'Saldo Tahun Lalu', '1', '750000', 'Tahun', '750000', '', '', '', '', '', '', '', '', '', '', '', '', '0', '2023-10-03 05:24:42', 'A1000A', 'eab9436a4237f4610d7f4610dcd98f00'),
(2, 'A', '1001', 'A', 100102, 1, 'A1001A10010200100', 'SOP', '125', '735000', 'Siswa', '91875000', '', '', '', '', '', '', '', '', '', '', '', '', '0', '2023-10-05 08:10:44', 'A1001A', '338921f84994f3382632ed3bfcd98f00'),
(3, 'A', '1001', 'A', 100102, 2, 'A1001A10010200200', 'Uang Pangkal', '400', '450000', 'Siswa', '180000000', '', '', '', '', '', '', '', '', '', '', '', '', '0', '2023-10-05 07:40:32', 'A1001A', '338ca57edb84efaeb055d91a1cd98f00'),
(4, 'A', '1001', 'A', 100102, 3, 'A1001A10010200300', 'Akomodasi Siswa', '150', '690000', 'Siswa', '103500000', '', '', '', '', '', '', '', '', '', '', '', '', '0', '2023-10-05 08:15:40', 'A1001A', '3384a70f1bd4f338261a38577cd98f00'),
(8, 'A', '1003', 'A', 100302, 1, 'A1003A10030200100', 'Uang Kegiatan', '400', '775000', 'Siswa', '310000000', '', '', '', '', '', '', '', '', '', '', '', '', '0', '2023-10-05 08:14:27', 'A1003A', '0c19c09cfc442123a30d8ee52cd98f00'),
(10, 'B', '2000', 'A', 200106, 1, 'B2000A20010600100', 'Beasiswa Peringkat 1 Paralel', '5', '450000', 'st', '2250000', '5', '1', '', '', 'siswa', 'tahun', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 13:16:00', 'B2000A', '09787b4a3b71c580ae1ae2367a338d71'),
(11, 'B', '2000', 'A', 200106, 2, 'B2000A20010600200', 'Beasiswa Peringkat II Paralel', '5', '337500', 'st', '1687500', '5', '1', '', '', 'siswa', 'tahun', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 13:19:00', 'B2000A', '097fa69a3b74db07fab9e1a28a338d71'),
(12, 'B', '2000', 'A', 200106, 3, 'B2000A20010600300', 'Beasiswa Peringkat III Paralel', '5', '225000', 'st', '1125000', '5', '1', '', '', 'siswa', 'tahun', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 13:20:00', 'B2000A', '097a6f2a3b73d388b78831997a338d71'),
(535, 'B', '2007', 'C', 200106, 2, 'B2007C20010600200', 'Honor Panitia Pelaksana', '1', '4500000', 'Paket', '4500000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 12:30:24', 'B2007C', '09753b4a423fd148defd148dea338d71'),
(539, 'B', '2003', 'B', 200106, 9, 'B2003B20010600900', 'Belanja Keperluan Kantor', '1', '750000', 'paket', '750000', '', '', '', '', '', '', '', '', 'A1000A10000000100', '1000', 'A', '100000', '0', '2023-10-05 07:46:53', 'B2003B', '097a7f7a4232b075c22b075c22eaba29'),
(538, 'A', '1001', 'A', 100102, 4, 'A1001A10010200400', 'Infak Pembangunan', '125', '700000', 'Siswa', '87500000', '', '', '', '', '', '', '', '', '', '', '', '', '0', '2023-10-05 08:12:00', 'A1001A', '338d6028499c545f8449ccfedcd98f00'),
(23, 'B', '2000', 'B', 200106, 1, 'B2000B20010600100', 'Persiapan dan gladi bersih', '1', '300000', 'paket', '300000', '1', '', '', '', 'paket', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 10:47:00', 'B2000B', 'a52df0fa42304ce9ba04ce9baa338d71'),
(29, 'B', '2000', 'B', 200106, 7, 'B2000B20010600700', 'Samir', '256', '17500', 'orang', '4480000', '2256', '', '', '', 'orang', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:24:00', 'B2000B', '0971b6b8499981d8d37093d9ea338d71'),
(30, 'B', '2000', 'B', 200106, 8, 'B2000B20010600800', 'Sleyer peringkat 10 besar', '10', '35000', 'orang', '350000', '10', '', '', '', 'orang', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:25:00', 'B2000B', '0977e2c944697dcd8300a1908a338d71'),
(31, 'B', '2000', 'B', 200106, 9, 'B2000B20010600900', 'Baner spot', '1', '311500', 'unit', '311500', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-10-05 08:16:27', 'B2000B', '0977e2fa42361603f661603f6a338d71'),
(32, 'B', '2000', 'B', 200106, 10, 'B2000B20010601000', 'Baner', '1', '360000', 'unit', '360000', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:36:00', 'B2000B', '097a460a42363e106663e1066a338d71'),
(33, 'B', '2000', 'B', 200106, 11, 'B2000B20010601100', 'Penataan dan kebersihan', '6', '50000', 'orang', '300000', '1', '6', '', '', 'kali', 'orang', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:42:00', 'B2000B', 'a5255649091fd4673904ce9baa338d71'),
(34, 'B', '2000', 'B', 200106, 12, 'B2000B20010601200', 'Foto wisuda', '256', '10000', 'orang', '2560000', '256', '', '', '', 'orang', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:44:00', 'B2000B', '097bc2084992741f6609acfc8a338d71'),
(35, 'B', '2000', 'B', 200106, 13, 'B2000B20010601300', 'Dokumantasi', '1', '300000', 'paket', '300000', '1', '', '', '', 'paket', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:46:00', 'B2000B', '0970666a42304ce9ba04ce9baa338d71'),
(37, 'B', '2000', 'B', 200302, 15, 'B2000B20030201500', 'Snak dan minuman teh pucuk', '625', '13000', 'paket', '8125000', '625', '', '', '', 'paket', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:09:00', 'B2000B', '1edf24d50907c261dc9d33c44a338d71'),
(38, 'B', '2000', 'B', 200302, 16, 'B2000B20030201600', 'Tas snak dan sablon', '625', '3000', 'buah', '1875000', '625', '', '', '', 'buah', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:12:00', 'B2000B', '1edf6dc50908bdc1aa01141fda338d71'),
(40, 'B', '2000', 'B', 200302, 18, 'B2000B20030201800', 'Snak latihan', '81', '5000', 'orang', '405000', '81', '', '', '', 'orang', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:48:00', 'B2000B', '1ed682cc5177f7fe82888449aa338d71'),
(41, 'B', '2000', 'B', 200302, 19, 'B2000B20030201900', 'Konsumsi undangan khusus', '1', '250000', 'paket', '250000', '1', '', '', '', 'paket', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:57:00', 'B2000B', '1edffd2a42355e038c55e038ca338d71'),
(42, 'B', '2000', 'B', 200302, 20, 'B2000B20030202000', 'Buket', '1', '50000', 'unit', '50000', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:58:00', 'B2000B', '1ed1fcea423fd46739fd46739a338d71'),
(43, 'B', '2000', 'B', 200302, 21, 'B2000B20030202100', 'Konsumsi rapat panitia', '3', '240000', 'kali', '720000', '3', '', '', '', 'kali', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 10:26:00', 'B2000B', '1ed13dfbc87a7f5f1e34c608ba338d71'),
(44, 'B', '2000', 'B', 200402, 22, 'B2000B20040202200', 'Sewa tarub', '396', '7500', 'meter', '2970000', '396', '', '', '', 'meter', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:27:00', 'B2000B', '7f73bcd1f2313c82894f6f6b3a338d71'),
(45, 'B', '2000', 'B', 200402, 23, 'B2000B20040202300', 'Sewa klambu', '8', '10000', 'meter', '80000', '8', '', '', '', 'meter', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:28:00', 'B2000B', '7f740680f892741f66d8be800a338d71'),
(46, 'B', '2000', 'B', 200402, 24, 'B2000B20040202400', 'Sewa kursi', '400', '2000', 'unit', '800000', '400', '', '', '', 'unit', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:29:00', 'B2000B', '7f75f438042c1a4171a0e8e3fa338d71'),
(47, 'B', '2000', 'B', 200402, 25, 'B2000B20040202500', 'Sewa sound system', '1', '1000000', 'unit', '1000000', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:31:00', 'B2000B', '7f7a0b4a423c545f84c545f84a338d71'),
(48, 'B', '2000', 'B', 200402, 26, 'B2000B20040202600', 'Panggung dan perlengkapanya', '1', '1000000', 'paket', '1000000', '1', '', '', '', 'paket', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:37:00', 'B2000B', '7f7973ba423c545f84c545f84a338d71'),
(49, 'B', '2000', 'B', 200402, 27, 'B2000B20040202700', 'Dekor panggung', '1', '700000', 'paket', '700000', '1', '', '', '', 'paket', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:39:00', 'B2000B', '7f74e7da423a82eacaa82eacaa338d71'),
(50, 'B', '2000', 'B', 200402, 28, 'B2000B20040202800', 'Sewa kostum tari', '3', '100000', 'orang', '300000', '3', '', '', '', 'orang', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:47:00', 'B2000B', '7f76b12bc872eaba2904ce9baa338d71'),
(52, 'B', '2000', 'B', 200501, 30, 'B2000B20050103000', 'Transpot komite', '10', '50000', 'orang', '500000', '1', '10', '', '', 'kali', 'orang', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 10:44:00', 'B2000B', 'a2b75a99446fd46739732a294a338d71'),
(455, 'B', '2001', 'B', 200105, 1, 'B2001B20010500100', 'Insentif TIM PKG dan SKP', '1', '1550000', 'Tahun', '1550000', '1', '', '', '', 'Tahun', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-31 17:06:54', 'B2001B', 'a52eaa1a4233d051663d05166a338d71'),
(519, 'B', '2002', 'J', 200302, 3, 'B2002J20030200300', 'Konsumsi Dewan Penggalang', '180', '10000', 'OK', '1800000', '60', '3', '', '', 'Siswa', 'Keg', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 11:23:30', 'B2002J', '1edab2b117b2741f66c2fe464a338d71'),
(446, 'B', '2003', 'F', 200105, 1, 'B2003F20010500100', 'insentif Panitia Pelaksana Rapat Pleno', '1', '1800000', 'kegiatan', '1800000', '1', '', '', '', 'kegiatan', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-31 16:15:23', 'B2003F', 'a52866aa423c2fe464c2fe464a338d71'),
(85, 'B', '2002', 'A', 200302, 1, 'B2002A20030200100', 'Papan Pengumuman', '2', '276000', 'Paket', '552000', '', '', '', '', '', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-08-07 14:34:43', 'B2002A', '1edbd77e72861603f6d28294fa338d71'),
(86, 'B', '2002', 'A', 200401, 1, 'B2002A20040100100', 'Service Program/Software Komputer/Laptop', '40', '100000', 'Unit', '4000000', '40', '', '', '', 'Unit', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-08-01 09:28:44', 'B2002A', '2aa056259202eaba298c482a5a0c10b1'),
(87, 'B', '2002', 'A', 200401, 2, 'B2002A20040100200', 'Service Hardware Komputer/Laptop', '40', '50000', 'Unit', '2000000', '40', '', '', '', 'Unit', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-01 09:30:00', 'B2002A', '2aa9f445920fd467394386659a0c10b1'),
(90, 'B', '2002', 'C', 200106, 3, 'B2002C20010600300', 'Insentif pelatih', '5', '150000', 'ok', '750000', '5', '1', '', '', 'orang', 'kegiatan', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-05 15:08:45', 'B2002C', 'a52bd86a3b7dd62b6f2973530a0c10b1'),
(91, 'B', '2002', 'C', 200106, 4, 'B2002C20010600400', 'Akomodasi peserta tahap seleksi pra POPDA', '25', '41000', 'pk', '1025000', '25', '1', '', '', 'peserta', 'kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-01 10:31:43', 'B2002C', '097860496a08b15670e968456a0c10b1'),
(92, 'B', '2002', 'C', 200106, 5, 'B2002C20010600500', 'Akomodasi training champ pra POPDA', '15', '73000', 'pk', '1095000', '15', '1', '', '', 'peserta', 'kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-01 10:31:59', 'B2002C', '097436531c76089a6e8c64b7aa0c10b1'),
(93, 'B', '2002', 'C', 200106, 6, 'B2002C20010600600', 'Akomodasi pelaksanaan lomba POPDA kabupaten', '20', '80000', 'pk', '1600000', '20', '1', '', '', 'peserta', 'kegiatan', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-08-02 11:46:19', 'B2002C', '0970f141370d8be800d3d9847a0c10b1'),
(94, 'B', '2002', 'D', 200106, 1, 'B2002D20010600100', 'Reward Juara POPDA Kabupaten 2024', '22', '200000', 'ok', '4400000', '22', '1', '', '', 'orang', 'kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 15:54:00', 'B2002D', '097183b767d61603f66dd5167a338d71'),
(95, 'B', '2002', 'D', 200106, 2, 'B2002D20010600200', 'Reward Juara KSM Kabupaten 2023', '3', '350000', 'ck', '1050000', '3', '1', '', '', 'cabang', 'kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 16:00:00', 'B2002D', '0978f3cbc8700a1908bb2c34ba338d71'),
(96, 'B', '2002', 'D', 200106, 3, 'B2002D20010600300', 'Reward Juara OSN Kabupaten', '3', '350000', 'ck', '1050000', '3', '1', '', '', 'cabang', 'kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 16:05:00', 'B2002D', '0978a3abc8700a1908bb2c34ba338d71'),
(97, 'B', '2002', 'D', 200106, 4, 'B2002D20010600400', 'Reward Juara O2SN Kabupaten', '2', '350000', 'ck', '700000', '2', '1', '', '', 'cabang', 'kegiatan', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 16:06:00', 'B2002D', '09775e6e72800a1908a82eacaa338d71'),
(98, 'B', '2002', 'D', 200106, 5, 'B2002D20010600500', 'Reward Pelatih Lomba', '13', '200000', 'ct', '2600000', '13', '1', '', '', 'cabang', 'tahun', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 16:08:00', 'B2002D', '097e823ce4161603f61707f2ca338d71'),
(100, 'B', '2002', 'F', 200106, 7, 'B2002F20010600700', 'Akomodasi kegiatan lomba akademik online', '2', '900000', 'kegiatan', '1800000', '2', '', '', '', 'kegiatan', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-01 10:30:57', 'B2002F', '097eb4be7288c964d8c2fe464a0c10b1'),
(101, 'B', '2002', 'G', 200105, 1, 'B2002G20010500100', 'Insentif TIM Pengelola IT', '36', '150000', 'OB', '5400000', '3', '12', '', '', 'Orang', 'Bulan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-02 09:59:41', 'B2002G', 'a52f25ca423318de45318de45a0c10b1'),
(102, 'B', '2002', 'G', 200105, 2, 'B2002G20010500200', 'Insentif penulis berita/artikel/essay', '60', '30000', 'OB', '1800000', '12', '5', '', '', 'Bulan', 'Orang', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-08-01 09:32:31', 'B2002G', 'a521663b030cdf31c086626aea0c10b1'),
(108, 'B', '2002', 'H', 200105, 1, 'B2002H20010500100', 'Insentif Pembuatan Soal Seleksi', '4', '50000', 'pk', '200000', '4', '1', '', '', 'paket', 'kegiatan', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-08-01 09:33:11', 'B2002H', 'a525995ff67fd4673961603f6a0c10b1'),
(109, 'B', '2002', 'H', 200105, 2, 'B2002H20010500200', 'Insentif Pengawas Seleksi', '12', '50000', 'ok', '600000', '12', '1', '', '', 'orang', 'kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-01 09:33:28', 'B2002H', 'a524a3bad4dfd46739a425f77a0c10b1'),
(110, 'B', '2002', 'H', 200105, 3, 'B2002H20010500300', 'Insentif Proktor/Teknisi', '2', '50000', 'ok', '100000', '2', '1', '', '', 'orang', 'kegiatan', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-08-01 09:33:47', 'B2002H', 'a52fdebe728fd467392eaba29a0c10b1'),
(521, 'B', '2002', 'J', 200302, 5, 'B2002J20030200500', 'Pengadaan tanda Nomor Gudep kelas 7', '256', '2000', 'Siswa', '512000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 11:24:53', 'B2002J', '1ed71ce8499c1a4171c127b74a338d71'),
(115, 'B', '2002', 'H', 200302, 4, 'B2002H20030200400', 'Konsumsi Rapat', '95', '18000', 'ok', '1710000', '19', '5', '', '', 'orang', 'kali', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-20 15:42:00', 'B2002H', '1ed77c2b4ba6f68689501a686a338d71'),
(116, 'B', '2002', 'H', 200302, 5, 'B2002H20030200500', 'Konsumsi Seleksi dan Pemberkasan', '76', '25000', 'oh', '1900000', '19', '4', '', '', '0rang', 'hari', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-20 15:43:00', 'B2002H', '1edd04d7939538106c9e483a9a338d71'),
(117, 'B', '2002', 'H', 200302, 6, 'B2002H20030200600', 'Konsumsi Daftar Ulang', '57', '25000', 'oh', '1425000', '19', '3', '', '', 'orang', 'hari', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-20 15:45:00', 'B2002H', '1ed488632a1538106c518ebb7a338d71'),
(118, 'B', '2002', 'H', 200302, 7, 'B2002H20030200700', 'Konsumsi Pengawas Seleksi CBT', '12', '18000', 'ok', '216000', '12', '1', '', '', 'orang', 'kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-20 15:46:00', 'B2002H', '1ed8e0dad4d6f686892e87a3ca338d71'),
(119, 'B', '2002', 'H', 200302, 8, 'B2002H20030200800', 'Snack Piket Sekretariat', '30', '9000', 'oh', '270000', '5', '6', '', '', 'orang', 'hari', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-20 15:50:00', 'B2002H', '1ed92ca73cbdc7ef67de10ebea338d71'),
(120, 'B', '2002', 'H', 200302, 9, 'B2002H20030200900', 'Snack Daftar Ulang dan Seleksi', '76', '7500', 'oh', '570000', '19', '4', '', '', 'orang', 'hari', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-20 15:52:00', 'B2002H', '1ed836c793913c8289d9d7090a338d71'),
(461, 'B', '2002', 'L', 200105, 2, 'B2002L20010500200', 'Insentif Juri/Wasit', '18', '50000', 'Ok', '900000', '9', '2', '', '', 'Orang', 'Keg', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-01 07:50:54', 'B2002L', 'a52c2fb922ffd467398c964d8a338d71'),
(143, 'B', '2002', 'L', 200302, 1, 'B2002L20030200100', 'Belanja hadiah classmeeting', '2', '2275000', 'kegiatan', '4550000', '2', '', '', '', 'kegiatan', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-02 11:52:51', 'B2002L', '1edb328e72805e5811b39aa9da0c10b1'),
(144, 'B', '2002', 'L', 200302, 2, 'B2002L20030200200', 'Konsumsi juri', '24', '25000', 'ko', '600000', '2', '12', '', '', 'kegiatan ', 'orang', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-24 10:33:00', 'B2002L', '1ed68631de7538106ca425f77a0c10b1'),
(145, 'B', '2002', 'L', 200302, 3, 'B2002L20030200300', 'Konsumsi panitia', '18', '25000', 'ko', '450000', '2', '9', '', '', 'kegiatan', 'orang', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-24 10:33:00', 'B2002L', '1ed0506922f538106c1c580aea0c10b1'),
(146, 'B', '2002', 'L', 200302, 4, 'B2002L20030200400', 'Snack juri dan panitia', '42', '5000', 'ko', '210000', '2', '21', '', '', 'kegiatan', 'orang', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-24 10:34:00', 'B2002L', '1ed38930c6e7f7fe824fe9e20a0c10b1'),
(147, 'B', '2002', 'L', 200302, 5, 'B2002L20030200500', 'Snack petugas OSIS', '180', '5000', 'kah', '900000', '2', '15', '6', '', 'kegiatan', 'anak', 'hari', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-10-05 07:49:15', 'B2002L', '1edbab0117b7f7fe828c964d8a0c10b1'),
(151, 'B', '2002', 'N', 200106, 1, 'B2002N20010600100', 'Insentif Pendamping dan Pemateri', '252', '10000', 'oh', '2520000', '42', '6', '', '', 'orang', 'hari', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 12:42:00', 'B2002N', 'a527ab16b062741f66f2da042a338d71'),
(155, 'B', '2002', 'N', 200401, 1, 'B2002N20040100100', 'Honor Pemateri Eksternal', '4', '125000', 'op', '500000', '2', '2', '', '', 'orang', 'pertemuan', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-08-02 11:53:34', 'B2002N', '2aa478bff67c2cefa9732a294a0c10b1'),
(513, 'B', '2002', 'K', 200105, 3, 'B2002K20010500300', 'Insentif Pemateri dari luar', '2', '200000', 'OK', '400000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 11:07:30', 'B2002K', 'a527600e72861603f6d28294fa338d71'),
(456, 'B', '2001', 'B', 200105, 2, 'B2001B20010500200', 'Insentif TIM Supervisi Guru', '2', '1300000', 'Semester', '2600000', '2', '', '', '', 'Semester', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-31 17:08:06', 'B2001B', 'a52fbebe7286e4900d1707f2ca338d71'),
(514, 'B', '2002', 'K', 200302, 7, 'B2002K20030200700', 'Konsumsi Peserta Dianpinru', '500', '10000', 'OK', '5000000', '100', '5', '', '', 'Siswa', 'Keg', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 11:11:21', 'B2002K', '1edbb6063112741f66adbbd8ea338d71'),
(516, 'B', '2002', 'J', 200105, 2, 'B2002J20010500200', 'Insentif Jaga Malam', '2', '50000', 'Orang', '100000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 11:20:07', 'B2002J', 'a528e75e728fd467392eaba29a338d71'),
(517, 'B', '2002', 'J', 200302, 1, 'B2002J20030200100', 'Belanja Perlengkapan Api Unggun', '1', '177000', 'Keg', '177000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-10-05 08:17:19', 'B2002J', '1edbe92a423d28294fd28294fa338d71'),
(442, 'B', '2001', 'A', 200105, 2, 'B2001A20010500200', 'Honor Narasumber dari Puskesmas', '4', '105000', 'pertemuan', '420000', '4', '', '', '', 'Pertemuan', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-08-01 09:24:24', 'B2001A', 'a524552ff67713ca4e428eec2a0c10b1'),
(462, 'B', '2002', 'O', 200105, 2, 'B2002O20010500200', 'Insentif Pelatih', '4', '50000', 'OK', '200000', '2', '2 ', '', '', 'Orang', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-01 08:02:52', 'B2002O', 'a52ec5aff67fd4673961603f6a338d71'),
(189, 'B', '2002', 'R', 200302, 2, 'B2002R20030200200', 'Snack Latihan', '180', '5000', 'ok', '900000', '45', '4', '', '', 'orang', 'kali', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 09:56:00', 'B2002R', '1ed4726117b7f7fe828c964d8a338d71'),
(193, 'B', '2002', 'T', 200106, 2, 'B2002T20010600200', 'Insentif Pelatih', '16', '50000', 'ok', '800000', '4', '4', '', '', 'orang', 'kali', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-24 10:36:00', 'B2002T', 'a52ec5ad97bfd46739a0e8e3fa0c10b1'),
(194, 'B', '2002', 'T', 200302, 1, 'B2002T20030200100', 'Snack Latihan', '56', '5000', 'oh', '280000', '14', '4', '', '', 'orang', 'hari', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 10:42:00', 'B2002T', '1ed472614087f7fe824fc965ca338d71'),
(195, 'B', '2002', 'U', 200106, 2, 'B2002U20010600200', 'insentif Pendamping', '1', '75000', 'ok', '75000', '1', '1', '', '', 'orang', 'kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-24 10:36:00', 'B2002U', 'a522750a423b1bb4f513c8289a0c10b1'),
(197, 'B', '2002', 'U', 200302, 1, 'B2002U20030200100', 'Snack Latihan', '28', '5000', 'ok', '140000', '7', '4', '', '', 'orang', 'kali', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-22 14:36:00', 'B2002U', '1ed472675ff7f7fe82cc0c4c2a338d71'),
(198, 'B', '2002', 'Q', 200106, 1, 'B2002Q20010600100', 'Insentif Pemateri Eksternal', '1', '125000', 'ok', '125000', '1', '1', '', '', 'orang', 'kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-02 11:55:59', 'B2002Q', 'a528a18a423c2cefa9c2cefa9a0c10b1'),
(199, 'B', '2002', 'Q', 200106, 2, 'B2002Q20010600200', 'Insentif Pemateri Internal', '4', '50000', 'ok', '200000', '4', '1', '', '', 'orang', 'kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 14:42:00', 'B2002Q', 'a5278cdff67fd4673961603f6a338d71'),
(200, 'B', '2002', 'Q', 200106, 3, 'B2002Q20010600300', 'Insentif Pelaksana kegiatan', '2', '100000', 'ok', '200000', '2', '1', '', '', 'orang', 'kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-02 11:55:07', 'B2002Q', 'a524ca9e7282eaba2961603f6a0c10b1'),
(202, 'B', '2002', 'Q', 200302, 2, 'B2002Q20030200200', 'Konsumsi Peserta LDK', '50', '15000', 'oh', '750000', '25', '2', '', '', 'orang', 'hari', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 14:45:00', 'B2002Q', '1edaf027c76886c7f82973530a338d71'),
(203, 'B', '2002', 'P', 200106, 2, 'B2002P20010600200', 'insentif Pendamping', '4', '75000', 'oh', '300000', '2', '2', '', '', 'orang', 'hari', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-24 10:37:00', 'B2002P', 'a522750ff67b1bb4f504ce9baa0c10b1'),
(205, 'B', '2002', 'P', 200302, 1, 'B2002P20030200100', 'Perlengkapan', '1', '1000000', 'pk', '1000000', '1', '1', '', '', 'paket', 'kegiatan', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-08-02 11:56:33', 'B2002P', '1ed59bba423c545f84c545f84a0c10b1'),
(522, 'B', '2002', 'J', 200302, 6, 'B2002J20030200600', 'Belanja hadiah untuk peserta', '1', '400000', 'Paket', '400000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 11:25:22', 'B2002J', '1ed66c2a423d28294fd28294fa338d71'),
(210, 'B', '2002', 'O', 200302, 2, 'B2002O20030200200', 'Konsumsi Rapat', '20', '20000', 'ok', '400000', '10', '2', '', '', 'orang', 'kali', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 15:10:00', 'B2002O', '1ed77c21370cdf31c0d28294fa338d71'),
(212, 'B', '2002', 'O', 200302, 4, 'B2002O20030200400', 'Konsumsi Panitia Pelaksana LDK dan Pilkasis', '30', '25000', 'ok', '750000', '10', '3', '', '', 'orang', 'kali', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 15:15:00', 'B2002O', '1edd61373cb538106c2973530a338d71'),
(213, 'B', '2002', 'O', 200302, 5, 'B2002O20030200500', 'Snack Kegiatan Tahapan LDK dan Pilkasis', '126', '5000', 'ok', '630000', '42', '3', '', '', 'orang', 'kali', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-24 10:37:00', 'B2002O', '1ed8786059b7f7fe8274c1933a0c10b1'),
(216, 'B', '2003', 'A', 200106, 1, 'B2003A20010600100', 'Insentif Tim TPM Penyusunan EDM-RKAM', '200', '50000', 'OK', '10000000', '20', '10', '', '', 'Orang', 'Keg', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 09:04:00', 'B2003A', 'a525c2c4a68fd46739aaf52b4a338d71'),
(217, 'B', '2003', 'A', 200302, 1, 'B2003A20030200100', 'Konsumsi Rapat', '200', '25000', 'OK', '5000000', '20', '10', '', '', 'Orang', 'Keg', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 09:02:00', 'B2003A', '1ed77c24a68538106cadbbd8ea338d71'),
(219, 'B', '2003', 'C', 200106, 1, 'B2003C20010600100', 'Iuran Kas KKM Kecamatan', '1590', '2500', 'Siswa', '3975000', '795', '2', '', '', 'Siswa', 'Semester', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-22 09:50:00', 'B2003C', 'f111fed41cca9b362a507fb11a338d71'),
(220, 'B', '2003', 'C', 200106, 2, 'B2003C20010600200', 'Iuran Kas KKM Kabupaten', '1590', '2000', 'Siswa', '3180000', '795', '2', '', '', 'Siswa', 'Semester', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 09:50:00', 'B2003C', 'f11e91941ccc1a41717aa8a64a338d71'),
(221, 'B', '2003', 'C', 299999, 1, 'B2003C29999900100', 'Iuran KKM MTs Kecamatan', '1590', '2500', 'Siswa', '3975000', '795', '2', '', '', 'Siswa', 'Semester', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-24 10:47:00', 'B2003C', 'f11db3141cca9b362a507fb11a338d71'),
(222, 'B', '2003', 'C', 299999, 2, 'B2003C29999900200', 'Iuran KKM MTs kabupaten', '1590', '2000', 'Siswa', '3180000', '795', '2', '', '', 'Siswa', 'Semester', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-24 10:48:00', 'B2003C', 'f11e2b841ccc1a41717aa8a64a338d71'),
(223, 'B', '2003', 'C', 299999, 3, 'B2003C29999900300', 'Iuran Aksioma', '1590', '2500', 'Siswa', '3975000', '795', '2', '', '', 'Siswa', 'Semester', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-24 10:49:00', 'B2003C', 'f11b7b941cca9b362a507fb11a338d71'),
(224, 'B', '2003', 'D', 200302, 1, 'B2003D20030200100', 'Konsumsi Kegiatan Bimtek Tenaga Administrasi', '10', '30000', 'OK', '300000', '10', '1', '', '', 'Orang', 'Keg', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-24 13:41:00', 'B2003D', '1ed6d3f944613150de04ce9baa338d71'),
(225, 'B', '2003', 'D', 200501, 1, 'B2003D20050100100', 'Perjalanan Dinas Pengiriman Kegiatan Bimtek', '16', '50000', 'OK', '800000', '8', '2', '', '', 'Pegawai', 'Keg', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-24 13:39:00', 'B2003D', 'a2b95b3d97bfd46739a0e8e3fa338d71'),
(226, 'B', '2003', 'E', 200101, 1, 'B2003E20010100100', 'Belanja Honorarium Guru Tidak Tetap', '17', '800000', 'OB', '13600000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-10-03 14:01:56', 'B2003E', '4c59e3630a9a0e8e3feda3c11a0c10b1'),
(227, 'B', '2003', 'E', 200101, 2, 'B2003E20010100200', 'Belanja Honorarium Guru Tidak Tetap', '12', '4500000', 'Bulan', '54000000', '12', '', '', '', 'Bulan', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-10-04 14:28:08', 'B2003E', '4c59e36ad4d33660fda7af59fa338d71'),
(228, 'B', '2003', 'E', 200102, 1, 'B2003E20010200100', 'Belanja Honorarium Pegawai Tidak Tetap', '12', '3287000', 'Bulan', '39444000', '12', '', '', '', 'Bulan', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-10-04 14:32:17', 'B2003E', 'ef7ed0bad4ddd952168217e14a338d71'),
(229, 'B', '2003', 'E', 200102, 2, 'B2003E20010200200', 'Belanja Honorarium Pegawai Tidak Tetap', '24', '500000', 'OB', '12000000', '12', '2', '', '', 'Bulan', 'Orang', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-10-03 14:02:31', 'B2003E', 'ef7ed0b57d5732a29422bd81aa0c10b1'),
(230, 'B', '2003', 'E', 200107, 1, 'B2003E20010700100', 'Belanja Honorarium THR Guru Tidak Tetap', '2', '800000', 'OB', '1600000', '1', '2', '', '', 'Bulan', 'Orang', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-10-03 14:03:19', 'B2003E', '88e7a8da4235b5fd2f716a620a338d71'),
(231, 'B', '2003', 'E', 200107, 2, 'B2003E20010700200', 'Belanja Honorarium THR Guru Tidak Tetap', '6', '800000', 'OB', '4800000', '1', '6', '', '', 'Bulan', 'Orang', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 12:14:00', 'B2003E', '88edc599091a0e8e3ff67663aa338d71'),
(232, 'B', '2003', 'E', 200108, 1, 'B2003E20010800100', 'Belanja Honorarium THR Pegawai Tidak Tetap', '3', '500000', 'OB', '1500000', '1', '3', '', '', 'Bulan', 'Orang', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-10-03 14:03:36', 'B2003E', 'b81e5710f89732a2948c482a5a338d71'),
(233, 'B', '2003', 'E', 200108, 2, 'B2003E20010800200', 'Belanja Honorarium THR Pegawai Tidak Tetap', '8', '300000', 'OB', '2400000', '1', '8', '', '', 'Bulan', 'Orang', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 11:03:00', 'B2003E', 'b81e5710f8904ce9ba2c3da6ca338d71'),
(234, 'B', '2003', 'E', 200108, 3, 'B2003E20010800300', 'Belanja Honorarium THR Pegawai Tidak Tetap', '3', '800000', 'OB', '2400000', '1', '3', '', '', 'Bulan', 'Orang', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 11:06:00', 'B2003E', 'b81e571bc87a0e8e3f2c3da6ca338d71'),
(239, 'B', '2003', 'E', 200113, 1, 'B2003E20011300100', 'Belanja Honorarium Petugas Piket Hari Libur', '1', '6500000', 'Tahun', '6500000', '1', '', '', '', 'Tahun', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 13:27:00', 'B2003E', '6eca0ada423744d7cf744d7cfa338d71'),
(241, 'B', '2003', 'F', 200106, 2, 'B2003F20010600200', 'Transport Rapat Rutin', '120', '100000', 'OK', '12000000', '10', '12', '', '', 'Orang', 'Keg', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-20 15:20:00', 'B2003F', 'a52cce7fb5c2eaba2951f7b42a338d71'),
(246, 'B', '2003', 'F', 200402, 1, 'B2003F20040200100', 'Sewa Tarub [Rapat Pleno]', '1', '2880000', 'Unit', '2880000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 09:44:00', 'B2003F', '7f75386a4230ebba4d0ebba4da338d71'),
(247, 'B', '2003', 'F', 200402, 2, 'B2003F20040200200', 'Sewa Panggung [Rapat Pleno]', '1', '600000', 'Unit', '600000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 09:45:00', 'B2003F', '7f7e3b3a423a425f77a425f77a338d71'),
(248, 'B', '2003', 'F', 200402, 3, 'B2003F20040200300', 'Sewa Sound Sistem  [Rapat Pleno]', '1', '1000000', 'Unit', '1000000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 09:46:00', 'B2003F', '7f7a368a423c545f84c545f84a338d71'),
(250, 'B', '2003', 'H', 200106, 1, 'B2003H20010600100', 'home visit reguler bagi kelas V11', '256', '20000', 'wali murid', '5120000', '1', '256', '', '', 'kali', 'wali murid', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-22 15:16:00', 'B2003H', '097066d8499cdf31c0336dd06a338d71'),
(251, 'B', '2003', 'H', 200106, 2, 'B2003H20010600200', 'Home Visit Kasus', '150', '20000', 'orang', '3000000', '75', '2', '1', '', 'kali', 'kali ', 'kegiatan', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 15:20:00', 'B2003H', '097bb86605fcdf31c07cfba9aa338d71'),
(252, 'B', '2003', 'G', 200105, 2, 'B2003G20010500200', 'Dana sosial anak sakit', '36', '200000', 'bulan', '7200000', '3', '12', '', '', 'kali ', 'bulan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 08:40:00', 'B2003G', '1ed672ead4d61603f62c3da6c0d8134a'),
(254, 'B', '2003', 'B', 200106, 4, 'B2003B20010600400', 'Akomodasi Tamu Dinas', '12', '750000', 'Keg', '9000000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-22 08:41:00', 'B2003B', 'f110c6bad4d29735306ac22dba338d71'),
(256, 'B', '2003', 'B', 200302, 1, 'B2003B20030200100', 'Belanja Keperluan Minum (Gula/Teh/Kopi/Galon)', '12', '1750000', 'Bulan', '21000000', '', '', '', '', '', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-22 09:19:00', 'B2003B', '1ed8557ad4df65a083f9af8dea338d71'),
(258, 'B', '2003', 'B', 200403, 2, 'B2003B20040300200', 'Langganan Telpon', '12', '60000', 'Bulan', '720000', '', '', '', '', '', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-22 09:14:00', 'B2003B', '20a09d9ad4d6dd7ed634c608ba0c10b1'),
(259, 'B', '2003', 'B', 200403, 3, 'B2003B20040300300', 'Langganan Internet', '12', '500000', 'Bulan', '6000000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-10-05 07:35:18', 'B2003B', '20ad1bdad4df021678876e2a2a0c10b1'),
(260, 'B', '2003', 'B', 200501, 1, 'B2003B20050100100', 'Belanja Perjalanan Pengiriman Laporan', '72', '50000', 'OB', '3600000', '2', '3', '12', '', 'Orang', 'Keg', 'Bulan', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-22 08:31:00', 'B2003B', 'a2b8429b90efd467396315402a0c10b1'),
(261, 'B', '2003', 'B', 200501, 2, 'B2003B20050100200', 'Perjaanan Rapat Dinas dalam Kota', '24', '100000', 'OK', '2400000', '2', '1', '12', '', 'Orang', 'Kegiatan', 'Bulan', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-22 08:47:00', 'B2003B', 'a2b207b1de72eaba292c3da6ca0c10b1'),
(262, 'B', '2003', 'B', 299999, 1, 'B2003B29999900100', 'Iuran Kegiatan FKKB', '12', '200000', 'Bulan', '2400000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-24 10:49:00', 'B2003B', 'f110fd4ad4d61603f62c3da6ca338d71'),
(263, 'B', '2004', 'A', 200106, 1, 'B2004A20010600100', 'Belanja Akomodasi Rapat KKM Kedu', '12', '500000', 'Keg', '6000000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-20 15:30:00', 'B2004A', 'f114622ad4d732a294318de45a338d71'),
(264, 'B', '2004', 'A', 200501, 1, 'B2004A20050100100', 'Perjalanan Dinas Dalam Kota', '48', '100000', 'Keg', '4800000', '4', '12', '', '', 'Keg', 'Bulan', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 14:41:00', 'B2004A', 'a2b3459e92e2eaba29f67663aa0c10b1'),
(265, 'B', '2004', 'A', 200501, 2, 'B2004A20050100200', 'Perjalanan Dinas Luar Kota', '12', '500000', 'Keg', '6000000', '', '', '', '', '', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 14:42:00', 'B2004A', 'a2b1acbad4d732a294318de45a0c10b1'),
(306, 'B', '2005', 'B', 200106, 1, 'B2005B20010600100', 'Lomba tumpeng tingkat kecamatan', '1', '700000', 'unit', '700000', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 15:00:00', 'B2005B', '0979adba423a425f77a425f77a338d71'),
(307, 'B', '2005', 'B', 200106, 2, 'B2005B20010600200', 'Lomba tingkat kecamatan', '50', '75000', 'orang', '3750000', '50', '', '', '', 'orang', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 14:47:00', 'B2005B', '0971c817c76b1bb4f5de6383ea338d71'),
(308, 'B', '2005', 'B', 200106, 3, 'B2005B20010600300', 'Hadiah lomba di MTs', '30', '20000', 'hadiah', '600000', '30', '', '', '', 'hadiah', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 14:56:00', 'B2005B', '09702d973cbcdf31c0a425f77a338d71'),
(309, 'B', '2005', 'B', 200106, 4, 'B2005B20010600400', 'Iuran ke Kecamatan', '1', '2000000', 'iuran', '2000000', '1', '', '', '', 'iuran', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 14:57:00', 'B2005B', '097c7e6a42343866594386659a338d71'),
(310, 'B', '2005', 'B', 200302, 2, 'B2005B20030200200', 'Transpot upacara', '67', '50000', 'orang', '3350000', '67', '', '', '', 'orang', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 14:19:00', 'B2005B', '1ed7a1bb90bfd46739e6aa066a338d71'),
(311, 'B', '2005', 'B', 200302, 1, 'B2005B20030200100', 'Tasyakuran/konsumsi', '67', '25000', 'orang', '1675000', '67', '', '', '', 'orang', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-22 14:16:00', 'B2005B', '1ed22b9b90b538106c3e15a23a338d71'),
(312, 'B', '2006', 'A', 200301, 2, 'B2006A20030100200', 'Lemari buku referensi', '1', '4000000', 'unit', '4000000', '1', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 14:20:00', 'B2006A', 'e6239b3a4238c482a58c482a5a0c10b1'),
(313, 'B', '2006', 'A', 200301, 1, 'B2006A20030100100', 'Meja kursi siswa', '32', '600000', 'stel', '19200000', '32', '', '', '', 'stel', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 14:15:00', 'B2006A', 'e62d2fb4d3fa425f77ece6733a0c10b1'),
(314, 'B', '2006', 'A', 200301, 3, 'B2006A20030100300', 'Meja sirkulasi perpustakaan', '1', '2320000', 'unit', '2320000', '1', '', '', '', '', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-10-05 08:20:15', 'B2006A', 'e62d62da423adbbd8eadbbd8ea0c10b1'),
(315, 'B', '2006', 'A', 200301, 4, 'B2006A20030100400', 'Meja baca perpustakaan', '5', '1000000', 'set', '5000000', '', '', '', '', '', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 14:30:00', 'B2006A', 'e62cac5a3b7c545f84adbbd8ea0c10b1'),
(316, 'B', '2006', 'A', 200301, 5, 'B2006A20030100500', 'Meja dan kursi guru', '10', '800000', 'stel', '8000000', '8', '', '', '', 'stel', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-08-02 11:31:42', 'B2006A', 'e625a890f89a0e8e3fad950c4a0c10b1'),
(322, 'B', '2006', 'A', 200301, 11, 'B2006A20030101100', 'Komputer', '1', '10000000', 'unit', '10000000', '', '', '', '', '', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-22 11:08:00', 'B2006A', 'e622b40a423aaf52b4aaf52b4a0c10b1'),
(323, 'B', '2006', 'A', 200301, 12, 'B2006A20030101200', 'Mebelair meja dan kursi Kepala laboratorium PAI', '1', '2340000', 'Unit', '2340000', '', '', '', '', '', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-10-05 08:18:02', 'B2006A', 'e62a721a423c545f84c545f84a338d71'),
(324, 'B', '2006', 'A', 200301, 13, 'B2006A20030101300', 'Pembelian papan tulis white board lab PAI', '6', '700000', 'Unit', '4200000', '6', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-08-01 09:48:33', 'B2006A', 'e626dfca423a82eacaa82eacaa338d71'),
(325, 'B', '2006', 'B', 200301, 1, 'B2006B20030100100', 'Lemari alat praktikum', '2', '4000000', 'unit', '8000000', '2', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 14:43:00', 'B2006B', 'e62a70de7288c482a592913f4a0c10b1'),
(326, 'B', '2006', 'B', 200301, 2, 'B2006B20030100200', 'Travo 5 ampere', '5', '600000', 'unit', '3000000', '5', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 14:48:00', 'B2006B', 'e62ae26a3b7a425f777cfba9aa0c10b1'),
(327, 'B', '2006', 'B', 200301, 3, 'B2006B20030100300', 'Pengadaan alat elektronik', '4', '250000', 'set', '1000000', '4', '', '', '', 'set', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 15:03:00', 'B2006B', 'e626c13ff6755e038cc545f84a0c10b1'),
(328, 'B', '2006', 'B', 200301, 4, 'B2006B20030100400', 'Torso peredaran darah manusia', '1', '1000000', 'unit', '1000000', '1', '', '', '', 'unit ', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-24 10:38:00', 'B2006B', 'e62b872a423c545f84c545f84a0c10b1'),
(329, 'B', '2006', 'B', 200301, 5, 'B2006B20030100500', 'Torso sistem reproduksi manusia', '2', '1000000', 'unit', '2000000', '2', '', '', '', 'unit', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-24 10:38:00', 'B2006B', 'e62d362e728c545f844386659a0c10b1'),
(330, 'B', '2006', 'B', 200301, 6, 'B2006B20030100600', 'Torso sistem gerak manusia', '1', '1000000', 'unit', '1000000', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-24 10:39:00', 'B2006B', 'e62c9c7a423c545f84a70783ba0c10b1'),
(331, 'B', '2006', 'B', 200301, 7, 'B2006B20030100700', 'Torso sistem pencernaan manusia', '1', '1000000', 'unit', '1000000', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-24 10:39:00', 'B2006B', 'e621f12a423c545f84c545f84a0c10b1'),
(332, 'B', '2006', 'B', 200301, 8, 'B2006B20030100800', 'Torso sistem ekskresi manusia', '1', '1000000', 'unit', '1000000', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-24 10:40:00', 'B2006B', 'e629bf8a423c545f84c545f84a0c10b1'),
(333, 'B', '2006', 'B', 200301, 9, 'B2006B20030100900', 'Torso sistem syaraf manusia', '1', '1000000', 'unit', '1000000', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-24 10:40:00', 'B2006B', 'e62f7e3a423c545f84c545f84a0c10b1'),
(334, 'B', '2006', 'C', 200202, 1, 'B2006C20020200100', 'kabel listrik', '2', '500000', 'rol', '1000000', '2', '', '', '', 'rol', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-21 10:43:00', 'B2006C', 'd40c0d1e728732a294c545f84a0c10b1'),
(335, 'B', '2006', 'C', 200202, 2, 'B2006C20020200200', 'Stop kontak', '20', '65000', 'unit', '1300000', '5', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-31 08:31:10', 'B2006C', 'd404ef7a3b71d0f87ca7754b9a0c10b1'),
(336, 'B', '2006', 'C', 200202, 3, 'B2006C20020200300', 'Lampu', '48', '40000', 'unit', '1920000', '24', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-21 10:49:00', 'B2006C', 'd40bb6fe92e048a2d0db356cfa0c10b1'),
(338, 'B', '2006', 'C', 200202, 5, 'B2006C20020200500', 'klem kabel', '10', '10000', 'bungkus', '100000', '10', '', '', '', 'bungkus', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-22 10:45:00', 'B2006C', 'd40620694462741f662eaba29a0c10b1'),
(339, 'B', '2006', 'C', 200202, 6, 'B2006C20020200600', 'steker', '10', '30000', 'unit', '300000', '10', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-31 09:24:32', 'B2006C', 'd402b9794462741f662eaba29a0c10b1'),
(340, 'B', '2006', 'C', 200202, 7, 'B2006C20020200700', 'Kipas angin kelas', '6', '675000', 'unit', '4050000', '6', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-08-01 09:50:46', 'B2006C', 'd40f05e9091ca7f12a9677cc8ef85cbe'),
(441, 'B', '2001', 'A', 200105, 1, 'B2001A20010500100', 'Honor Narasumber Kegiatan dari eksternal', '24', '55000', 'pertemuan', '1320000', '24', '', '', '', 'pertemuan', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-31 15:39:33', 'B2001A', 'a52e38e1de7e065d564ea4ddba338d71'),
(344, 'B', '2006', 'D', 200201, 1, 'B2006D20020100100', 'pengecatan lapangan multifungsi', '1', '10000000', 'unit', '10000000', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-10-05 07:37:15', 'B2006D', '5ad7f30a423aaf52b4aaf52b4ef85cbe'),
(506, 'B', '2002', 'K', 200302, 2, 'B2002K20030200200', 'Konsumsi Pembina', '48', '25000', 'OK', '1200000', '8', '6', '', '', 'Orang', 'Keg', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 10:54:05', 'B2002K', 'a528aede92e538106c86626aea338d71'),
(507, 'B', '2002', 'K', 200302, 3, 'B2002K20030200300', 'Konsumsi Dewan Penggalang', '165', '15000', 'OK', '2475000', '55', '3', '', '', 'Siswa', 'Keg', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 10:57:51', 'B2002K', 'a52ab2b6527886c7f870bb5b6a338d71'),
(508, 'B', '2002', 'K', 200302, 4, 'B2002K20030200400', 'Air Mineral', '10', '35000', 'Dus', '350000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 10:58:25', 'B2002K', 'a52340d944697dcd8300a1908a338d71'),
(509, 'B', '2002', 'K', 200302, 5, 'B2002K20030200500', 'Belanja hadiah untuk peserta', '1', '400000', 'Paket', '400000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 10:59:02', 'B2002K', 'a5266c2a423d28294fd28294fa338d71'),
(349, 'B', '2006', 'D', 200202, 2, 'B2006D20020200200', 'Bola voli', '2', '900000', 'unit', '1800000', '2', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 15:16:00', 'B2006D', '5ad3836e7288c964d8c2fe464a0c10b1'),
(350, 'B', '2006', 'D', 200202, 3, 'B2006D20020200300', 'Bola sepak', '2', '400000', 'unit', '800000', '2', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 15:18:00', 'B2006D', '5ad0331e728d28294fa0e8e3fa0c10b1'),
(351, 'B', '2006', 'D', 200202, 4, 'B2006D20020200400', 'Bola futsal', '2', '250000', 'unit', '500000', '2', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 15:19:00', 'B2006D', '5add898e72855e038c732a294a0c10b1'),
(352, 'B', '2006', 'D', 200202, 5, 'B2006D20020200500', 'Alat angkat badan', '1', '1000000', 'unit', '1000000', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-24 10:40:00', 'B2006D', '5ad1856a423c545f84c545f84a0c10b1'),
(505, 'B', '2002', 'K', 200302, 1, 'B2002K20030200100', 'Belanja Perlengkapan Kegiatan', '1', '400000', 'paket', '400000', '', '', '', '', '', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-08-02 10:47:40', 'B2002K', 'a52df9da423d28294fd28294fa338d71'),
(355, 'B', '2006', 'E', 200201, 2, 'B2006E20020100200', 'Pembuatan ruang OSIS [Sumber BOS]', '1', '125000000', 'ruang', '125000000', '1', '', '', '', 'ruang', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-08-01 10:23:46', 'B2006E', '5adfef1a42338612473861247a0c10b1'),
(356, 'B', '2006', 'E', 200201, 1, 'B2006E20020100100', 'Pengecatan ruang perpustakaan', '136', '50000', 'meter/segi', '6800000', '136', '', '', '', 'meter/segi', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 16:08:00', 'B2006E', '5ad29f50e18fd467393f6f746a0c10b1'),
(357, 'B', '2006', 'E', 200201, 4, 'B2006E20020100400', 'Kran air dapur, WC dan tempat cuci tangan', '30', '20000', 'unit', '600000', '30', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-24 10:43:00', 'B2006E', '5adffb173cbcdf31c0a425f77a0c10b1'),
(499, 'B', '2003', 'B', 200106, 7, 'B2003B20010600700', 'Langganan Koran', '12', '100000', 'Bulan', '1200000', '', '', '', '', '', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-10-04 14:22:46', 'B2003B', '0974090ad4d2eaba2986626aea0c10b1'),
(359, 'B', '2006', 'E', 200201, 5, 'B2006E20020100500', 'Pengecatan Ruang Laboratorium PAI', '1', '2000000', 'Paket', '2000000', '', '', '', '', '', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-08-01 09:51:56', 'B2006E', '5adead5a42343866594386659a338d71'),
(361, 'B', '2006', 'G', 200301, 1, 'B2006G20030100100', 'Alat stapler buku', '2', '150000', 'unit', '300000', '2', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 15:29:00', 'B2006G', 'e62b8c6e728dd62b6f04ce9baa0c10b1'),
(363, 'B', '2006', 'G', 200301, 3, 'B2006G20030100300', 'Kamus Bahasa Inggris-Indonesia', '32', '100000', 'unit', '3200000', '32', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 15:35:00', 'B2006G', 'e6230964d3f2eaba29ec28ee7a0c10b1'),
(364, 'B', '2006', 'G', 200301, 4, 'B2006G20030100400', 'Punch Hole', '2', '75000', 'unit', '150000', '2', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 15:40:00', 'B2006G', 'e62e51be728b1bb4f5dd62b6fa0c10b1'),
(438, 'B', '2002', 'O', 200302, 7, 'B2002O20030200700', 'Air Mineral', '7', '35000', 'dk', '245000', '7', '1', '', '', 'dus', 'kegiatan', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-31 14:21:27', 'B2002O', '1ed340d4e4597dcd83a8fd403a338d71'),
(439, 'B', '2002', 'O', 200105, 1, 'B2002O20010500100', 'Narasumber Pemateri', '8', '50000', 'ok', '400000', '8', '1', '', '', 'orang', 'kali', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-31 14:28:46', 'B2002O', 'a522d1e0f89fd46739d28294fa338d71'),
(520, 'B', '2002', 'J', 200302, 4, 'B2002J20030200400', 'Air Mineral', '20', '20000', 'Buah', '400000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 11:24:12', 'B2002J', '1ed340d1370cdf31c0d28294fa338d71'),
(449, 'B', '2000', 'B', 200105, 1, 'B2000B20010500100', 'Insentif Panitia Pelaksana Pelepasan Pesdik Kelas 9', '1', '2500000', 'kegiatan', '2500000', '1', '', '', '', 'kegiatan', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-31 16:18:56', 'B2000B', 'a52ba74a4233c92e0f3c92e0fa338d71'),
(371, 'B', '2006', 'G', 200301, 13, 'B2006G20030101300', 'Atlas', '32', '100000', 'eksemplar', '3200000', '32', '', '', '', 'eksemplar', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-22 10:47:00', 'B2006G', 'e62a6564d3f2eaba29ec28ee7a0c10b1'),
(534, 'B', '2007', 'C', 200106, 1, 'B2007C20010600100', 'Honor pembuat Kisi-kisi dan soal', '45', '50000', 'OK', '2250000', '3', '15', '', '', 'Tingkat', 'Mapel', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 12:29:02', 'B2007C', '0974459349cfd467391ae2367a338d71');
INSERT INTO `simakom_detail2324` (`no`, `kategori`, `kegiatan`, `komponen`, `akun`, `detail`, `detail_id`, `uraian`, `volume`, `satuan`, `unit`, `total`, `komponen_1`, `komponen_2`, `komponen_3`, `komponen_4`, `unit_1`, `unit_2`, `unit_3`, `unit_4`, `pembiayaan_id`, `pembiayaan_kegiatan`, `pembiayaan_komponen`, `pembiayaan_akun`, `revisi`, `time`, `kode_id`, `id`) VALUES
(374, 'B', '2006', 'G', 200301, 14, 'B2006G20030101400', 'Buku ensiklopedi sains dan teknologi', '1', '3850000', 'paket', '3850000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-02 11:59:47', 'B2006G', 'e6255e4a423cac6219cac6219a0c10b1'),
(375, 'B', '2006', 'H', 200201, 1, 'B2006H20020100100', 'Pavingisasi halaman', '270', '75000', 'm2', '20250000', '270', '', '', '', 'm2', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-08-01 12:21:34', 'B2006H', 'f1125899c88b1bb4f5766f543a0c10b1'),
(504, 'B', '2002', 'I', 200105, 1, 'B2002I20010500100', 'Insentif Pembina Kesiswaan', '72', '80000', 'OB', '5760000', '6', '12', '', '', 'Orang', 'Bulan', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 10:07:24', 'B2002I', 'a5212f2b90ed8be8001fac2d9a338d71'),
(378, 'B', '2006', 'H', 200302, 1, 'B2006H20030200100', 'Bensin penyiraman halaman', '20', '12000', 'liter', '240000', '20', '', '', '', 'liter', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-31 08:24:21', 'B2006H', 'f112d1613703dd5d09a7f5f1ea338d71'),
(379, 'B', '2006', 'H', 200302, 2, 'B2006H20030200200', 'Herbisida penyemprot rumput halaman dan taman', '12', '100000', 'botol', '1200000', '12', '', '', '', 'botol', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-31 08:26:17', 'B2006H', 'f11eb84ad4dcdf31c0a7f5f1ea338d71'),
(380, 'B', '2006', 'H', 200302, 3, 'B2006H20030200300', 'Bunga untuk taman', '25', '100000', 'pohon', '2500000', '25', '', '', '', 'pohon', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-29 07:07:00', 'B2006H', 'f11313896a02eaba293c92e0fa338d71'),
(381, 'B', '2006', 'H', 200302, 4, 'B2006H20030200400', 'Pembuangan sampah', '2', '400000', 'Kegiatan', '800000', '2', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-31 09:17:31', 'B2006H', 'f11fa14e72855e038c732a294a338d71'),
(382, 'B', '2006', 'H', 200302, 5, 'B2006H20030200500', 'Perbaikan  instalasi air halaman dan taman', '2', '1000000', 'Kegiatan', '2000000', '2', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-07-29 07:18:00', 'B2006H', 'f117fcfe728c545f844386659a338d71'),
(383, 'B', '2006', 'H', 200302, 6, 'B2006H20030200600', 'Pembuatan kebun', '1', '1000000', 'kegiatan', '1000000', '1', '', '', '', 'kegiatan ', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-10-05 08:29:42', 'B2006H', 'f11775ea423c545f84c545f84a338d71'),
(385, 'B', '2006', 'I', 200202, 1, 'B2006I20020200100', 'Tongkat mayoret', '5', '200000', 'unit', '1000000', '5', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-22 13:29:00', 'B2006I', 'd40b06aa423318de45318de45a0c10b1'),
(386, 'B', '2006', 'I', 200202, 3, 'B2006I20020200300', 'Bas drumb', '1', '3000000', 'unit', '3000000', '1', '', '', '', 'unit', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-24 10:43:00', 'B2006I', 'd401beea4237cfba9a7cfba9aa0c10b1'),
(503, 'B', '2006', 'H', 200302, 8, 'B2006H20030200800', 'Sapu lidi', '60', '7000', 'unit', '420000', '20', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-08-02 11:34:28', 'B2006H', '1ed503f13702741f6661603f6a0c10b1'),
(388, 'B', '2006', 'I', 200202, 4, 'B2006I20020200400', 'Baju mayoret', '4', '500000', 'stel', '2000000', '4', '', '', '', 'Stel', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-22 14:31:00', 'B2006I', 'd40dd5eff67732a2944386659a0c10b1'),
(389, 'B', '2006', 'I', 200202, 5, 'B2006I20020200500', 'Stik Drumd dan pemukul', '40', '35000', 'stel ', '1400000', '40', '', '', '', 'stel', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-22 14:34:00', 'B2006I', 'd4001fa592097dcd83c6795d4a0c10b1'),
(502, 'B', '2006', 'C', 200202, 11, 'B2006C20020201100', 'Pemeliharaan mesin jahit', '1', '5000000', 'kegiatan', '5000000', '1', '', '', '', 'kegiatan', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-08-01 12:26:16', 'B2006C', 'd40a3eca423adbbd8eadbbd8ea0c10b1'),
(391, 'B', '2006', 'I', 200202, 7, 'B2006I20020200700', 'Membrand drumb', '15', '50000', 'unit', '750000', '15', '', '', '', 'unit', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-22 14:46:00', 'B2006I', 'd40746831c7fd467392973530a0c10b1'),
(392, 'B', '2006', 'F', 200301, 1, 'B2006F20030100100', 'Peralatan dan obat-obatan UKS dan P3K', '2', '2000000', 'Semester', '4000000', '1', '', '', '', 'kegiatan', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-08-02 11:34:59', 'B2006F', 'e622867a42343866594386659ef85cbe'),
(393, 'B', '2007', 'A', 200106, 1, 'B2007A20010600100', 'Konsumsi kegiatan', '100', '50000', 'Orang/Hari', '5000000', '50', '2', '', '', 'Orang', 'Hari', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-08-01 09:54:32', 'B2007A', 'f11e14c9139fd46739adbbd8e2eaba29'),
(394, 'B', '2007', 'A', 200401, 1, 'B2007A20040100100', 'Honor Nara Sumber', '3', '500000', 'Orang', '1500000', '3', '', '', '', 'Orang', '', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-21 00:06:00', 'B2007A', '2aa60dfe728732a294c545f84a0c10b1'),
(501, 'B', '2003', 'B', 200302, 2, 'B2003B20030200200', 'KOnsumsi Rapat Dinas', '670', '26000', 'OK', '17420000', '67', '10', '', '', 'Orang', 'Kegiatan', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-01 10:29:40', 'B2003B', '1ed1179276cae8b9dd2cd330fa338d71'),
(396, 'B', '2007', 'B', 200106, 2, 'B2007B20010600200', 'honor panitia pelaksana', '1', '4500000', 'keg', '4500000', '1', '', '', '', 'kegiatan', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-10-05 08:19:17', 'B2007B', 'a52eab5a423fd148defd148dea0c10b1'),
(397, 'B', '2007', 'B', 200106, 3, 'B2007B20010600300', 'Honor pengawas ruang (non ASN)', '80', '20000', 'hari/orang', '1600000', '8', '10', '', '', 'hari', 'orang', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-01 10:00:02', 'B2007B', 'a52f1fe3ab3cdf31c0d3d9847a0c10b1'),
(497, 'B', '2007', 'B', 200106, 1, 'B2007B20010600100', 'Honor Pembuat Kisi-kisi', '45', '50000', 'OK', '2250000', '3', '15', '', '', 'Tingkat', 'Mapel', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-01 09:57:11', 'B2007B', '0971e81349cfd467391ae2367a338d71'),
(410, 'B', '2007', 'E', 200302, 1, 'B2007E20030200100', 'Penggandaan Soal Sumatif/Penilaian Harian', '60000', '250', 'Mapel/siswa', '15000000', '15', '800', '5', '', 'Mapel', 'Siswa', 'lembar', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-07-20 14:46:00', 'B2007E', '1edc2a1a7202bbac1c6ac22dba0c10b1'),
(418, 'B', '2007', 'D', 200105, 3, 'B2007D20010500300', 'Honor Proktor dan Teknisi ANBK', '6', '80000', 'OK', '480000', '3', '2', '', '', 'Hari', 'Orang', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-09-11 14:06:15', 'B2007D', 'a525c42e92ed8be800033d4f7a0c10b1'),
(554, 'B', '2007', 'D', 200105, 2, 'B2007D20010500200', 'Insentif Pelaksana Tryout ANBK dan AKMI', '4', '1500000', 'Paket', '6000000', '4', '', '', '', 'Kegiatan', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-09-11 14:24:42', 'B2007D', 'a52dfbfff67f021678318de45a338d71'),
(420, 'B', '2007', 'D', 200105, 1, 'B2007D20010500100', 'Honor Pengawas ANBK', '8', '50000', 'Ruang/hari', '400000', '2', '1', '2', '2', 'Sesi', 'ruang', 'pengawas', 'hari', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-09-11 14:04:13', 'B2007D', 'a5201e5ad4d4386659debaa61a0c10b1'),
(421, 'B', '2007', 'D', 200105, 4, 'B2007D20010500400', 'Honor Panitia ANBK Utama', '1', '2500000', 'kegiatan', '2500000', '2', '6', '', '', 'kegiatan', 'Periode', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-09-11 14:00:27', 'B2007D', 'a52424fad4d3c92e0f2ab1136a0c10b1'),
(423, 'B', '2007', 'D', 200106, 1, 'B2007D20010600100', 'Try Out ANBK', '50', '50000', 'Siswa/Keg', '2500000', '1', '50', '', '', 'Kegiatan', 'Siswa', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-09-11 11:53:08', 'B2007D', 'f118e297c766dd7ed67cfba9aa0c10b1'),
(426, 'B', '2004', 'B', 200501, 1, 'B2004B20050100100', 'Perjadin Kegiatan MGMP dalam kota', '90', '100000', 'pewrtemuan', '9000000', '15', '6', '', '', 'mapel', 'pertemuan', '', '', 'A1003A10030200100', '1003', 'A', '100302', '0', '2023-08-16 10:33:45', 'B2004B', 'a2bf9d439852eaba296ac22dba0c10b1'),
(451, 'B', '2002', 'L', 200105, 1, 'B2002L20010500100', 'Insentif Pelaksana Kegiatan Classmeeting', '2', '1500000', 'kegiatan', '3000000', '2', '', '', '', 'kegiatan', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-31 16:25:41', 'B2002L', 'a52f8e8e728f0216787cfba9aa338d71'),
(452, 'B', '2002', 'R', 200105, 1, 'B2002R20010500100', 'Insentif Panitia Pelaksana Jambore Ranting', '1', '600000', 'kegiatan', '600000', '1', '', '', '', 'kegiatan', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-31 16:30:01', 'B2002R', 'a523ee4a423a425f77a425f77a338d71'),
(453, 'B', '2002', 'S', 200105, 1, 'B2002S20010500100', 'Insentif Pelaksana Kegiatan Jambore Cabang', '1', '300000', 'kegiatan', '300000', '1', '', '', '', 'kegiatan', '', '', '', 'A1001A10010200300', '1001', 'A', '100102', '0', '2023-07-31 16:32:08', 'B2002S', 'a52c5cfa42304ce9ba04ce9baa338d71'),
(454, 'B', '2002', 'N', 200105, 1, 'B2002N20010500100', 'Insentif Pelaksana Kegiatan', '1', '400000', 'kegiatan', '400000', '1', '', '', '', 'kegiatan', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-07-31 16:39:22', 'B2002N', 'a520a65a423d28294fd28294fa338d71'),
(536, 'B', '2007', 'C', 200106, 3, 'B2007C20010600300', 'Honor pengawas ruang (non ASN)', '80', '20000', 'OH', '1600000', '8', '10', '', '', 'hari', 'Orang', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 12:31:29', 'B2007C', '097f1fe3ab3cdf31c0d3d9847a338d71'),
(459, 'B', '2002', 'B', 200301, 1, 'B2002B20030100100', 'Pengadaan Aplikasi Perpustakaan Digital', '1', '1500000', 'Paket', '1500000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-01 07:29:39', 'B2002B', 'e6223b5a423f021678f021678a338d71'),
(518, 'B', '2002', 'J', 200302, 2, 'B2002J20030200200', 'Konsumsi Pembina', '18', '25000', 'OK', '450000', '6', '3', '', '', 'Orang', 'Keg', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 11:22:50', 'B2002J', '1ed8aed922f538106c1c580aea338d71'),
(492, 'B', '2002', 'M', 200105, 1, 'B2002M20010500100', 'Insentif Pendamping/Pelatih', '4', '100000', 'Ok', '400000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-01 08:52:55', 'B2002M', 'a5255caff672eaba29d28294fa338d71'),
(512, 'B', '2002', 'K', 200105, 2, 'B2002K20010500200', 'Insentif Pemateri', '28', '50000', 'Materi', '1400000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 11:06:43', 'B2002K', 'a5210c575fffd46739c6795d4a338d71'),
(523, 'B', '2002', 'E', 200105, 1, 'B2002E20010500100', 'Insentif Pendamping Saat Ujian dan Pelantikan', '2', '75000', 'OK', '150000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-02 11:26:36', 'B2002E', 'a524459e728b1bb4f5dd62b6fa338d71'),
(524, 'B', '2002', 'E', 200105, 2, 'B2002E20010500200', 'Insentif pelatih', '1', '50000', 'OK', '50000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-02 11:27:01', 'B2002E', 'a52bd86a423fd46739fd46739a338d71'),
(525, 'B', '2002', 'E', 200302, 1, 'B2002E20030200100', 'Belanja Perlengkapan seleksi', '1', '150000', 'Paket', '150000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-02 11:29:13', 'B2002E', '1ed2042a423dd62b6fdd62b6fa338d71'),
(526, 'B', '2002', 'E', 200302, 2, 'B2002E20030200200', 'Konsumsi saat latihan', '8', '20000', 'OH', '160000', '2', '4', '', '', 'Orang', 'hari', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-02 11:29:46', 'B2002E', '1ed89490f89cdf31c041ebce5a338d71'),
(527, 'B', '2002', 'E', 200302, 3, 'B2002E20030200300', 'Pendaftaran Peserta', '2', '100000', 'OK', '200000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-02 11:30:16', 'B2002E', '1edc858e7282eaba2961603f6a338d71'),
(528, 'B', '2006', 'C', 200202, 12, 'B2006C20020201200', 'Perbaikan Pompa Air', '1', '500000', 'paket', '500000', '', '', '', '', '', '', '', '', 'A1001A10010200100', '1001', 'A', '100102', '0', '2023-08-02 11:33:28', 'B2006C', 'd4069b8a423732a294732a294a338d71'),
(529, 'B', '2005', 'A', 200105, 1, 'B2005A20010500100', 'Insentif Tim Beasiswa dan Keringan Biaya', '2', '1150000', 'Semester', '2300000', '', '', '', '', '', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-02 11:39:11', 'B2005A', 'a52615be728abfe1534f33826a338d71'),
(548, 'B', '2005', 'B', 200106, 5, 'B2005B20010600500', 'IURAN HUT RI TK. DESA', '1', '500000', 'TH', '500000', '1', '', '', '', 'TH', '', '', '', 'A1001A10010200200', '1001', 'A', '100102', '0', '2023-08-21 09:07:10', 'B2005B', '097589aa423732a294732a294a338d71');

-- --------------------------------------------------------

--
-- Table structure for table `simakom_jurnal2324`
--

CREATE TABLE `simakom_jurnal2324` (
  `no` int(11) NOT NULL,
  `tanggal` date NOT NULL,
  `jenis` varchar(2) NOT NULL,
  `jumlah` varchar(15) NOT NULL,
  `uraian` text NOT NULL,
  `id` varchar(40) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `simakom_kegiatan2324`
--

CREATE TABLE `simakom_kegiatan2324` (
  `no` int(11) NOT NULL,
  `kategori` varchar(1) NOT NULL,
  `kegiatan` varchar(4) NOT NULL,
  `uraian` text NOT NULL,
  `kode_id` varchar(20) NOT NULL,
  `id` varchar(100) NOT NULL,
  `revisi` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `simakom_kegiatan2324`
--

INSERT INTO `simakom_kegiatan2324` (`no`, `kategori`, `kegiatan`, `uraian`, `kode_id`, `id`, `revisi`) VALUES
(1, 'A', '1000', 'Penerimaan Saldo Tahun Lalu', 'A1000', '7fc56270e7a70faa70783b617e9998dc4ddcfcd2', '0'),
(2, 'A', '1001', 'Penerimaan Sumbangan Masyarakat', 'A1001', '7fc56270e7a70fae33defde51cf91e1e03ecfcd2', '0'),
(3, 'B', '2001', 'Belanja Kegiatan Standar Isi', 'B2001', '9d5ed678fe57bcc63ff976f9c37fc81fe03cfcd2', '0'),
(4, 'B', '2005', 'Belanja Kegiatan Standar Pembiayaan', 'B2005', '9d5ed678fe57bcc8e9db2e9aa3827bba3afcfcd2', '0'),
(5, 'B', '2002', 'Belanja Kegiatan Standar Proses', 'B2002', '9d5ed678fe57bccb9f9e5732ed33761840fcfcd2', '0'),
(9, 'B', '2007', 'Belanja Kegiatan Standar Penilaian', 'B2007', '9d5ed678fe57bcceb0973d24649a4a920fccfcd2', '0'),
(10, 'B', '2000', 'Belanja Kegiatan Standar Kelulusan', 'B2000', '9d5ed678fe57bccc1a417155361a5c4b8d2cfcd2', '0'),
(11, 'B', '2004', 'Belanja Kegiatan Standar Tendik', 'B2004', '9d5ed678fe57bcc727d6f5d1b61fff7be68cfcd2', '0'),
(12, 'B', '2006', 'Belanja Kegiatan Standar Sarana Prasarana', 'B2006', '9d5ed678fe57bcc86c712a91e48443cd802cfcd2', '0'),
(13, 'B', '2003', 'Belanja Kegiatan Standar Pengelolaan', 'B2003', '9d5ed678fe57bcc24321c5e2bdbd23ed35fcfcd2', '0'),
(16, 'A', '1003', 'Penerimaan Uang Kegiatan', 'A1003', '7fc56270e7a70fa75c4a77c87f97fb686b2cfcd2', '0');

-- --------------------------------------------------------

--
-- Table structure for table `simakom_komponen2324`
--

CREATE TABLE `simakom_komponen2324` (
  `no` int(11) NOT NULL,
  `kategori` varchar(1) NOT NULL,
  `kegiatan` varchar(4) NOT NULL,
  `komponen` varchar(5) NOT NULL,
  `uraian` text NOT NULL,
  `kode_id` varchar(20) NOT NULL,
  `id` varchar(100) NOT NULL,
  `revisi` varchar(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `simakom_komponen2324`
--

INSERT INTO `simakom_komponen2324` (`no`, `kategori`, `kegiatan`, `komponen`, `uraian`, `kode_id`, `id`, `revisi`) VALUES
(1, 'A', '1000', 'A', 'Saldo Tahun Lalu', 'A1000A', '7fc56a70783b617270e7a70fa', '0'),
(2, 'A', '1001', 'A', 'Sumbangan Masyarakat', 'A1001A', '7fc56e33defde51270e7a70fa', '0'),
(3, 'A', '1003', 'A', 'Penerimaan Uang Kegiatan', 'A1003A', '7fc5675c4a77c87270e7a70fa', '0'),
(5, 'B', '2000', 'A', 'Pemberian Beasiswa Siswa Berprestasi', 'B2000A', '9d5edc1a4171553270e7a70fa', '0'),
(6, 'B', '2000', 'B', 'Kegiatan Pelepasan dan Wisuda Kelas IX', 'B2000B', '9d5edc1a4171553678fe57bcc', '0'),
(13, 'B', '2002', 'A', 'Perlengkapan Laboratorium Komputer', 'B2002A', '9d5edb9f9e5732e270e7a70fa', '0'),
(14, 'B', '2002', 'B', 'Pengembangan Aplikasi Perpustakaan', 'B2002B', '9d5edb9f9e5732e678fe57bcc', '0'),
(15, 'B', '2002', 'B', 'Lomba O2SN', 'B2002B', '9d5edb9f9e5732e2dffc6cb06', '0'),
(16, 'B', '2002', 'C', 'Lomba POPDA', 'B2002C', '9d5edb9f9e5732e6b051f63d7', '0'),
(17, 'B', '2002', 'D', 'Reward Pembimbing Juara Lomba Resmi Tingkat Kabupaten dan tingkat diatasnya', 'B2002D', '9d5edb9f9e5732e097d2fa7a4', '0'),
(19, 'B', '2002', 'F', 'Lomba online akademik', 'B2002F', '9d5edb9f9e5732e67b72d78b7', '0'),
(20, 'B', '2002', 'G', 'Pengembangan Sarana dan Prasarana Multimedia', 'B2002G', '9d5edb9f9e5732e8370cad1d4', '0'),
(21, 'B', '2002', 'H', 'Kegiatan PPDB', 'B2002H', '9d5edb9f9e5732e75af30e62b', '0'),
(22, 'B', '2002', 'I', 'Kegiatan Penegakan Kedisiplinan Sekolah', 'B2002I', '9d5edb9f9e5732e00cfc35332', '0'),
(23, 'B', '2002', 'I', 'Pengiriman Lomba OSN', 'B2002I', '9d5edb9f9e5732e70aca82419', '0'),
(27, 'B', '2002', 'L', 'Penyelenggaraan Lomba Class Meeting', 'B2002L', '9d5edb9f9e5732e6794b63bf9', '0'),
(28, 'B', '2002', 'L', 'Kegiatan Kemah Pramuka Pelantikan Penggalang Rakit dan Dianpimru', 'B2002L', '9d5edb9f9e5732eec3b48a1ee', '0'),
(30, 'B', '2002', 'N', 'Kegiatan Pesantren Romadhon', 'B2002N', '9d5edb9f9e5732ec7bdcc3ce6', '0'),
(35, 'B', '2002', 'R', 'Lomba Jambore Ranting', 'B2002R', '9d5edb9f9e5732e3d40573127', '0'),
(36, 'B', '2002', 'S', 'Lomba Jambore Cabang', 'B2002S', '9d5edb9f9e5732e8dcc983a70', '0'),
(37, 'B', '2002', 'T', 'Lomba Cerdas Tangkas Pramuka ( LCTP )', 'B2002T', '9d5edb9f9e5732e18c950afbf', '0'),
(38, 'B', '2002', 'U', 'Lomba Olimpiade PMR', 'B2002U', '9d5edb9f9e5732e360da93c0a', '0'),
(39, 'B', '2002', 'Q', 'Latihan Dasar Kepemimpinan PMR Madya', 'B2002Q', '9d5edb9f9e5732e60a306a2e0', '0'),
(40, 'B', '2002', 'P', 'Lomba Jumbara Cabang', 'B2002P', '9d5edb9f9e5732e06ea9a85a5', '0'),
(42, 'B', '2002', 'O', 'Pilkasis dan Latihan Dasar Kepemimpinan OSIS', 'B2002O', '9d5edb9f9e5732e4137b614c8', '0'),
(44, 'B', '2003', 'A', 'Kegiatan Penyusunan EDS', 'B2003A', '9d5ed24321c5e2b270e7a70fa', '0'),
(46, 'B', '2003', 'C', 'Pelaksanaan Kegiatan Tingkat KKM', 'B2003C', '9d5ed24321c5e2b8370cad1d4', '0'),
(47, 'B', '2003', 'D', 'Kegiatan Penyusunan RKJM, RKT', 'B2003D', '9d5ed24321c5e2b75af30e62b', '0'),
(48, 'B', '2003', 'D', 'Peningkatan Kompetensi Tenaga Administrasi Perkantoran', 'B2003D', '9d5ed24321c5e2b00cfc35332', '0'),
(49, 'B', '2003', 'E', 'Honor dan Tunjangan GTT dan PTT', 'B2003E', '9d5ed24321c5e2b8943025315', '0'),
(50, 'B', '2003', 'F', 'Rakor Komite', 'B2003F', '9d5ed24321c5e2b8d0734569a', '0'),
(52, 'B', '2003', 'H', 'Transport Pelaksanaan Home Visit', 'B2003H', '9d5ed24321c5e2b70aca82419', '0'),
(53, 'B', '2003', 'G', 'Dana Sosial Peserta Didik', 'B2003G', '9d5ed24321c5e2b6794b63bf9', '0'),
(55, 'B', '2003', 'B', 'Kegiatan Pengelolaan Administrasi Kantor dan Rumah Tangga', 'B2003B', '9d5ed24321c5e2bec3b48a1ee', '0'),
(56, 'B', '2004', 'A', 'Perjalanan Dinas Kepala Dalam dan luar Kota dalam Rangka Peningkatan Kompetensi dan Koordinasi', 'B2004A', '9d5ed727d6f5d1b270e7a70fa', '0'),
(60, 'B', '2004', 'B', 'Pengiriman Peserta MGMP dan Sejenisnya', 'B2004B', '9d5ed727d6f5d1b75af30e62b', '0'),
(66, 'B', '2005', 'B', 'Pelaksanaan Kegiatan HUT RI', 'B2005B', '9d5ed8e9db2e9aa8943025315', '0'),
(67, 'B', '2006', 'A', 'Pengadaan Sarana Fisik Meubeler', 'B2006A', '9d5ed86c712a91e270e7a70fa', '0'),
(68, 'B', '2006', 'B', 'Pengembangan Laboratorium IPA', 'B2006B', '9d5ed86c712a91e678fe57bcc', '0'),
(69, 'B', '2006', 'C', 'Pemeliharaan dan pengadaan alat elektronik', 'B2006C', '9d5ed86c712a91e8370cad1d4', '0'),
(70, 'B', '2006', 'D', 'Pengadaan dan pemeliharaan sarana olah raga', 'B2006D', '9d5ed86c712a91e75af30e62b', '0'),
(71, 'B', '2006', 'E', 'Pemeliharaan gedung', 'B2006E', '9d5ed86c712a91e00cfc35332', '0'),
(73, 'B', '2006', 'G', 'Pengembangan Perpustakaan', 'B2006G', '9d5ed86c712a91e8d0734569a', '0'),
(74, 'B', '2006', 'H', 'Pemeliharaan halaman dan taman', 'B2006H', '9d5ed86c712a91e50f86825a1', '0'),
(76, 'B', '2006', 'I', 'Pemeliharaan peralatan drumband', 'B2006I', '9d5ed86c712a91e70aca82419', '0'),
(77, 'B', '2006', 'F', 'Kebutuhan UKS dan P3K', 'B2006F', '9d5ed86c712a91e6a11b03839', '0'),
(78, 'B', '2007', 'A', 'Penyelenggaraan Workshop/IHT Mandiri Peningkatan Kompetensi Penilaian', 'B2007A', '9d5edeb0973d246270e7a70fa', '0'),
(79, 'B', '2007', 'B', 'Kegiatan Asesmen Sumatif Akhir Semester Gasal/Penilaian Akhir Semester Gasal', 'B2007B', '9d5edeb0973d246678fe57bcc', '0'),
(80, 'B', '2007', 'C', 'Asesmen Sumatif Akhir Sumatif Genap/Penilaian Akhir Tahun', 'B2007C', '9d5edeb0973d2468370cad1d4', '0'),
(82, 'B', '2007', 'E', 'Sumatif Harian/Penilaian Harian', 'B2007E', '9d5edeb0973d24600cfc35332', '0'),
(85, 'B', '2007', 'D', 'Asesmen Nasional Berbasis Komputer (ANBK) ', 'B2007D', '9d5edeb0973d24650f86825a1', '0'),
(88, 'B', '2001', 'A', 'Penyelenggaraan Kegiatan Keputrian', 'B2001A', '9d5ed63ff976f9c8943025315', '0'),
(89, 'B', '2001', 'B', 'TIM Pengelola PKG, SKP dan Supervisi Guru', 'B2001B', '9d5ed63ff976f9c8d0734569a', '0'),
(93, 'B', '2002', 'M', 'Pengiriman Lomba OSN Kabupaten', 'B2002M', '9d5edb9f9e5732eac6776e733', '0'),
(95, 'B', '2002', 'K', 'Gladian Pimpinan Regu dan Kemah Pelantikan', 'B2002K', '9d5edb9f9e5732e418362b172', '0'),
(96, 'B', '2002', 'J', 'Kemah Penerimaan Tamu Penggalang', 'B2002J', '9d5edb9f9e5732e86df3739da', '0'),
(97, 'B', '2002', 'E', 'Pengiriman Pramuka Garuda Kabupaten', 'B2002E', '9d5edb9f9e5732eef78d93e91', '0'),
(98, 'B', '2005', 'A', 'Pemberian Bantuan Sosial dan keringanan Siswa Tidak Mampu', 'B2005A', '9d5ed8e9db2e9aad2db39237d', '0');

-- --------------------------------------------------------

--
-- Table structure for table `simakom_ref_akun`
--

CREATE TABLE `simakom_ref_akun` (
  `no` int(11) NOT NULL,
  `kategori` varchar(1) NOT NULL,
  `akun` varchar(6) NOT NULL,
  `akun_custome` varchar(50) NOT NULL,
  `uraian` text NOT NULL,
  `id` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `simakom_ref_akun`
--

INSERT INTO `simakom_ref_akun` (`no`, `kategori`, `akun`, `akun_custome`, `uraian`, `id`) VALUES
(19, 'A', '100202', '100202', 'Pendapatan Sewa GOR', 'be9bbf8e7cb2de034bee59162bafcaaefb0'),
(17, 'A', '100103', '100103', 'Penerimaan Biaya Akomodasi MMP', '9ae26ff44c264acbcdb9f37bb5c08fcc9f9'),
(18, 'A', '100201', '100201', 'Pendapatan Ternak Ikan', '7c7523f13ef609d154a6ac2187a5c8735fa'),
(13, 'A', '100000', '100000', 'Penerimaan Saldo Tahun Lalu', '14ee22eaba29794682775be85f192af3021'),
(14, 'A', '100101', '100101', 'Penerimaan SPP', '732e276ec85f14e5ddca80e9dd3badedebc'),
(15, 'A', '100102', '100102', 'Penerimaan Sumbangan Pengembangan Sekolah', '54ebda338d716823ef59a48ec57a173850c'),
(16, 'A', '100104', '100104', 'Penerimaan Biaya Kelas KKO', '72984ef85cbebaa1de90c11baa503343547'),
(20, 'B', '200101', '200101', 'Belanja Honorarium Guru Tidak Tetap', 'fae1f94c506115ec42df2a0fd12dbe9c7aa'),
(21, 'B', '200102', '200102', 'Belanja Honorarium Pegawai Tidak Tetap', 'bc0db1ef7e8b6388b70ac689b02eee2cda0'),
(22, 'B', '200103', '200103', 'Belanja Honorarium Pembina Ekstra Internal', 'bd0b3e43c34a47ccdb67d115df7de21d9b8'),
(23, 'B', '200104', '200104', 'Belanja Honorarium Pembina Ekstra Eksternal', 'dde4acfdb0be07ac132ad5a295fc9f4b8ad'),
(24, 'B', '200201', '200201', 'Belanja Pemeliharaan Gedung dan Bangunan', 'fafe0a5ad92e1f86d2c833d5982ea8d01c1'),
(25, 'B', '200202', '200202', 'Belanja Pemeliharaan Peralatan dan Mesin', '452bfed404cb95dbfaadfd1aa56e52d612a'),
(26, 'B', '200301', '200301', 'Belanja Keperluan Perkantoran', '8aee09e623dfe2f7d11e4d0ad60d0a5ca38'),
(27, 'B', '200302', '200302', 'Belanja Bahan', '004ca31ed6cc0360fe946d3365893f2b99d'),
(28, 'B', '200401', '200401', 'Belanja Jasa Profesi', '9756342aa9434be8f1e85b87a4163c6354d'),
(29, 'B', '200402', '200402', 'Belanja Sewa', '800d427f7b19cf62174b86e51875116f576'),
(30, 'B', '200403', '200403', 'Belanja Langganan Daya dan Jasa', 'de345b20a5d60aecea768241b2e0d2fcb0d'),
(42, 'B', '200107', '200107', 'Belanja Honorarium THR Guru Tidak Tetap', '6752ca88e78474b7acd301cfefc889b658a'),
(41, 'B', '200106', '200106', 'Belanja Penunjang Kegiatan Pendidikan', '7a303a097dd4e0259280330a6809291f824'),
(34, 'B', '299999', '299999', 'Belanja Lainnya', '94cfaff110fc98938230b1e4e53541cfbc5'),
(35, 'B', '200105', '200105', 'Belanja Honor Kegiatan', 'e085d8a5248ec1cee089e4a2bff2e804231'),
(36, 'A', '100301', '100301', 'Bantuan Operasional Sekolah (BOS)', 'a6061a0c10b13bf137460ec8e143a214b05'),
(37, 'A', '199999', '199999', 'Penerimaan Lain', '174d10d8134ad94f0c285f19d5f8238d516'),
(38, 'A', '100105', '100105', 'Penerimaan Biaya Kelas Akademik', '123faaaa42b5d906c7d0fa6b50781c14bca'),
(39, 'B', '200501', '200501', 'Belanja Perjaanan Dinas', '269727a2b342292f278b69e51643ea9e1b8'),
(40, 'B', '200210', '200210', 'Belanja Pengadaan Tanah', '71464592903d1ac6bfb8cdcfed812c0c969'),
(43, 'B', '200108', '200108', 'Belanja Honorarium THR Pegawai Tidak Tetap', '1fdbafb8171bc612ee72f9fa507f8e4fa32'),
(44, 'B', '200109', '200109', 'Belanja Honorarium Ke-13 Guru Tidak Tetap', 'b746153e7a27362c6c611539f2d9acd0094'),
(45, 'B', '200110', '200110', 'Belanja Honorarium Ke-13 Pegawai Tidak Tetap', 'f234d714e94e229d926d70b864ce568ad54'),
(46, 'B', '200111', '200111', 'Belanja Tunjangan Reward Kehadiran Guru Tidak Tetap', '6e59975fd49e3d83bcf5381468064911efa'),
(47, 'B', '200112', '200112', 'Belanja Tunjangan Reward Kehadiran Pegawai Tidak Tetap', '8655f16996c8058e106e2bc0ab56d9a4f0b'),
(48, 'B', '200113', '200113', 'Belanja Honorarium Petugas Piket Hari Libur', 'd6155c6ec9d14c2bdc408fb3fe9db1bfa3e'),
(49, 'A', '100302', '100302', 'Uang Kegiatan', '8acdf12cd77f6e7b488840a65a20ab6e33d');

-- --------------------------------------------------------

--
-- Table structure for table `simakom_ref_jenisbelanja`
--

CREATE TABLE `simakom_ref_jenisbelanja` (
  `no` int(11) NOT NULL,
  `jenis` varchar(70) NOT NULL,
  `kode` float NOT NULL,
  `kategori` varchar(2) NOT NULL,
  `show_rkas` varchar(1) NOT NULL,
  `kategori2` varchar(2) NOT NULL,
  `kategori_deskripsi` varchar(200) NOT NULL,
  `model` float NOT NULL,
  `model_deskripsi` varchar(100) NOT NULL,
  `debet` tinyint(1) NOT NULL,
  `kredit` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `simakom_ref_jenisbelanja`
--

INSERT INTO `simakom_ref_jenisbelanja` (`no`, `jenis`, `kode`, `kategori`, `show_rkas`, `kategori2`, `kategori_deskripsi`, `model`, `model_deskripsi`, `debet`, `kredit`) VALUES
(1, 'Penerimaan ke Tunai', 11, 'A1', 'A', 'A', 'Penerimaan Tunai', 1, 'Pendapatan', 1, 0),
(2, 'Penerimaan ke Bank', 12, 'A2', 'A', 'A', 'Penerimaan Bank', 2, 'Pendapatan', 1, 0),
(3, 'Pungutan Pajak Tunai', 13, 'A1', 'A', 'A', 'Penerimaan Tunai', 1, 'Pendapatan', 1, 0),
(4, 'Pungutan Pajak Bank', 14, 'A2', 'A', 'A', 'Penerimaan Bank', 2, 'Pendapatan', 1, 0),
(5, 'Pengembalian Belanja Tunai', 15, 'A1', 'B', 'A', 'Penerimaan Tunai', 1, 'Pengembalian Belanja', 1, 0),
(6, 'Pengembalian Belanja Bank', 16, 'A2', 'B', 'A', 'Penerimaan Bank', 2, 'Pengembalian Belanja', 1, 0),
(7, 'Setor ke Bank', 21, 'C0', 'C', 'C', 'Pergeseran Uang (PU) Bank', 3, 'Pergeseran Uang (PU) Bank', 1, 1),
(8, 'Tarik Tunai', 22, 'C0', 'C', 'C', 'Pergeseran Uang (PU) Bank', 3, 'Pergeseran Uang (PU) Bank', 1, 1),
(9, 'Belanja Tunai', 31, 'B1', 'B', 'B', 'Pengeluaran Tunai', 1, 'Belanja', 0, 1),
(10, 'Belanja Bank', 32, 'B2', 'B', 'B', 'Pengeluaran Bank', 2, 'Belanja', 0, 1),
(11, 'Setor Pajak Tunai', 33, 'B1', 'B', 'B', 'Pengeluaran Tunai', 1, 'Belanja', 0, 1),
(12, 'Setor Pajak Bank', 34, 'B2', 'B', 'B', 'Pengeluaran Bank', 2, 'Belanja', 0, 1),
(13, 'Pengembalian Pendapatan Tunai', 35, 'B1', 'A', 'B', 'Pengeluaran Tunai', 1, 'Pengembalian Pendapatan', 0, 1),
(14, 'Pengembalian Pendapatan Bank', 36, 'B2', 'A', 'B', 'Pengeluaran Bank', 2, 'Pengembalian Pendapatan', 0, 1),
(15, 'Penerimaan Hutang Pihak Ketiga Tunai', 41, 'D1', 'D', 'D', 'Non Anggaran', 1, 'Hutang Kepada Pihak Ketiga', 1, 0),
(16, 'Penerimaan Hutang Pihak Ketiga Bank', 42, 'D2', 'D', 'D', 'Non Anggaran', 2, 'Hutang Kepada Pihak Ketiga', 1, 0),
(17, 'Pembayaran Hutang Pada Pihak Ketiga Tunai', 43, 'D1', 'D', 'D', 'Non Anggaran', 1, 'Hutang Kepada Pihak Ketiga', 0, 1),
(18, 'Pembayaran Hutang Pada Pihak Ketiga Bank', 44, 'D2', 'D', 'D', 'Non Anggaran', 2, 'Hutang Kepada Pihak Ketiga', 0, 1),
(19, 'Pengeluaran Piutang Kepada Pihak Ketiga Tunai', 45, 'D1', 'D', 'D', 'Non Anggaran', 1, 'Piutang Pihak Ketiga', 0, 1),
(20, 'Pengeluaran Piutang Kepada Pihak Ketiga Bank', 46, 'D2', 'D', 'D', 'Non Anggaran', 2, 'Piutang Pihak Ketiga', 0, 1),
(21, 'Pengembalian Piutang Kepada Pihak Ketiga Tunai', 47, 'D1', 'D', 'D', 'Non Anggaran', 1, 'Piutang Pihak Ketiga', 1, 0),
(22, 'Pengembalian Piutang Kepada Pihak Ketiga Bank', 48, 'D2', 'D', 'D', 'Non Anggaran', 2, 'Piutang Pihak Ketiga', 1, 0);

-- --------------------------------------------------------

--
-- Table structure for table `simakom_ref_kategori`
--

CREATE TABLE `simakom_ref_kategori` (
  `no` int(11) NOT NULL,
  `kategori` varchar(1) NOT NULL,
  `uraian` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `simakom_ref_kategori`
--

INSERT INTO `simakom_ref_kategori` (`no`, `kategori`, `uraian`) VALUES
(1, 'A', 'PENDAPATAN'),
(2, 'B', 'BELANJA'),
(3, 'C', 'SURPLUS (DEFISIT)');

-- --------------------------------------------------------

--
-- Table structure for table `simakom_ref_kegiatan`
--

CREATE TABLE `simakom_ref_kegiatan` (
  `no` int(11) NOT NULL,
  `id` varchar(100) NOT NULL,
  `kategori` varchar(1) NOT NULL,
  `kegiatan` varchar(4) NOT NULL,
  `kegiatan_custome` varchar(15) NOT NULL,
  `uraian` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `simakom_ref_kegiatan`
--

INSERT INTO `simakom_ref_kegiatan` (`no`, `id`, `kategori`, `kegiatan`, `kegiatan_custome`, `uraian`) VALUES
(112, 'a9b7ba70783b617682775be85f192af3021', 'A', '1000', '1000', 'Penerimaan Saldo Tahun Lalu'),
(113, 'b8c37e33defde51c9354242c284f97a5e37', 'A', '1001', '1001', 'Penerimaan Sumbangan Masyarakat'),
(114, '5ec829debe54b19f0c285f19d5f8238d516', 'A', '1999', '1999', 'Penerimaan Lain'),
(115, 'fba9d88164f3e2d96797f48c50918cfed34', 'A', '1002', '1002', 'Penerimaan Pendapatan Asli sekolah'),
(116, '08f90c1a41715538b72664c9498459011e6', 'B', '2000', '2000', 'Belanja Kegiatan Standar Kelulusan'),
(117, 'd0fb963ff976f9c653181e9d8ca9683b483', 'B', '2001', '2001', 'Belanja Kegiatan Standar Isi'),
(118, '4ba29b9f9e5732ec04affa66cf010b62572', 'B', '2002', '2002', 'Belanja Kegiatan Standar Proses'),
(119, 'a591024321c5e2b16506375d817b0241e6f', 'B', '2003', '2003', 'Belanja Kegiatan Standar Pengelolaan'),
(120, 'b8b4b727d6f5d1b10479106d6c3105ea2a5', 'B', '2004', '2004', 'Belanja Kegiatan Standar Tendik'),
(121, 'd47268e9db2e9aa32fc56790236f069da49', 'B', '2005', '2005', 'Belanja Kegiatan Standar Pembiayaan'),
(122, 'ea5a486c712a91eb215f8699c222f811cdc', 'B', '2006', '2006', 'Belanja Kegiatan Standar Sarana Prasarana'),
(123, 'a00e5eb0973d2463c5686760dfed4295acd', 'B', '2007', '2007', 'Belanja Kegiatan Standar Penilaian'),
(124, 'aa68c75c4a77c870bcef3a2582241da86d0', 'A', '1003', '1003', 'Penerimaan Uang Kegiatan'),
(125, 'a36e841c5230a796600fd02a16301a5fb97', 'B', '2999', '2999', 'Belanja Lain-lain');

-- --------------------------------------------------------

--
-- Table structure for table `simakom_revisi2324`
--

CREATE TABLE `simakom_revisi2324` (
  `no` int(11) NOT NULL,
  `revisi` float NOT NULL,
  `tanggal` date NOT NULL,
  `time` datetime NOT NULL,
  `id` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `simakom_revisi2324`
--

INSERT INTO `simakom_revisi2324` (`no`, `revisi`, `tanggal`, `time`, `id`) VALUES
(1, 0, '2023-07-10', '2023-07-10 14:30:19', '98a6684daa65e55e46e18f949483c72cd46');

-- --------------------------------------------------------

--
-- Table structure for table `simakom_transaksi2324`
--

CREATE TABLE `simakom_transaksi2324` (
  `no` int(11) NOT NULL,
  `tanggal` date NOT NULL,
  `bukti` float NOT NULL,
  `bukti_sistem` float NOT NULL,
  `jenis` float NOT NULL,
  `kategori` varchar(3) NOT NULL,
  `rkas_kategori` varchar(1) NOT NULL,
  `rkas_kegiatan` varchar(4) NOT NULL,
  `rkas_komponen` varchar(5) NOT NULL,
  `rkas_akun` float NOT NULL,
  `rkas_detail_id` varchar(25) NOT NULL,
  `uraian` text NOT NULL,
  `debet` varchar(15) NOT NULL,
  `kredit` varchar(15) NOT NULL,
  `penerima` varchar(100) DEFAULT NULL,
  `penerima_jabatan` varchar(100) DEFAULT NULL,
  `pembiayaan_id` varchar(50) NOT NULL,
  `pembiayaan_kegiatan` varchar(4) NOT NULL,
  `pembiayaan_komponen` varchar(5) NOT NULL,
  `pembiayaan_akun` varchar(6) NOT NULL,
  `pajak` tinyint(1) NOT NULL,
  `pajak_akun` varchar(10) NOT NULL,
  `revisi` varchar(10) NOT NULL,
  `id_setor` varchar(25) NOT NULL,
  `time` datetime NOT NULL,
  `id` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `simakom_transaksi2324`
--

INSERT INTO `simakom_transaksi2324` (`no`, `tanggal`, `bukti`, `bukti_sistem`, `jenis`, `kategori`, `rkas_kategori`, `rkas_kegiatan`, `rkas_komponen`, `rkas_akun`, `rkas_detail_id`, `uraian`, `debet`, `kredit`, `penerima`, `penerima_jabatan`, `pembiayaan_id`, `pembiayaan_kegiatan`, `pembiayaan_komponen`, `pembiayaan_akun`, `pajak`, `pajak_akun`, `revisi`, `id_setor`, `time`, `id`) VALUES
(4, '2023-07-01', 1, 200027, 41, 'D1', '', '', '', 0, '', 'Penerimaan Hutang Pihak Ketiga Tunai (Dana Simpanan Tanah)', '30000000', '0', '', '', '', '', '', '', 0, '', '0', '', '2023-08-03 11:57:01', '5f48fa895db08495d598f00b204e9800998ecf8427e5cd98f00'),
(5, '2023-07-13', 2, 200016, 31, 'B1', 'B', '2003', 'E', 200101, 'B2003E20010100200', 'Belanja  Belanja Honorarium Guru Tidak Tetap', '0', '3740000', 'terlampir', 'terlampir', 'A1001A10010200200', '1001', 'A', '100102', 1, '135478', '0', '', '2023-07-30 10:47:05', '20f6135478708495d58134ad94a2fefe3af422bc03959debe54'),
(30, '2023-07-01', 26, 200026, 11, 'A1', 'A', '1000', 'A', 100000, 'A1000A10000000100', 'Terima  Saldo Tahun Lalu', '679500', '0', '', '', '', '', '', '', 1, '', '0', '', '2023-08-03 11:54:21', '43d5dbf9b5308495d598f00b204e9800998ecf8427e5cd98f00'),
(8, '2023-07-14', 5, 200137, 31, 'B1', 'B', '2003', 'E', 200102, 'B2003E20010200100', 'Belanja  Belanja Honorarium Pegawai Tidak Tetap', '0', '10034000', 'Terlampir', 'Terlampir', 'A1001A10010200300', '1001', 'A', '100102', 1, '0b1214', '0', '', '2023-09-02 07:24:30', '20f10b1214108495d58134ad94a2fefe3af422bc03959debe54'),
(9, '2023-07-15', 6, 200011, 31, 'B1', 'B', '2003', 'A', 200302, 'B2003A20030200100', 'Belanja  Konsumsi Rapat', '0', '263000', '', '', 'A1001A10010200200', '1001', 'A', '100102', 1, 'd67216', '0', '', '2023-07-26 08:41:47', '20ffd67216d08495d58134ad94a2fefe3af422bc03959debe54'),
(10, '2023-07-14', 7, 200025, 31, 'B1', 'B', '2006', 'H', 200302, 'B2006H20030200500', 'Belanja  Perbaikan  instalasi air halaman dan taman', '0', '85000', '', '', 'A1001A10010200200', '1001', 'A', '100102', 1, '711bbd', '0', '', '2023-08-03 11:11:51', '20ff711bbd608495d58134ad94a2fefe3af422bc03959debe54'),
(13, '2023-07-20', 10, 200011, 31, 'B1', 'B', '2003', 'A', 200302, 'B2003A20030200100', 'Belanja  Konsumsi Rapat', '0', '223500', '', '', 'A1001A10010200200', '1001', 'A', '100102', 1, '898217', '0', '', '2023-07-26 09:26:11', '20ff898217208495d58134ad94a2fefe3af422bc03959debe54'),
(14, '2023-07-22', 11, 200011, 31, 'B1', 'B', '2003', 'A', 200302, 'B2003A20030200100', 'Belanja  Konsumsi Rapat', '0', '266000', '', '', 'A1001A10010200200', '1001', 'A', '100102', 1, '326aea', '0', '', '2023-07-26 09:32:53', '20fa326aea208495d58134ad94a2fefe3af422bc03959debe54'),
(15, '2023-07-26', 12, 200011, 31, 'B1', 'B', '2006', 'C', 200202, 'B2006C20020200100', 'Belanja  kabel listrik', '0', '65000', '', '', 'A1003A10030100100', '1003', 'A', '100301', 0, '', '0', '', '2023-07-26 10:08:07', '20f30cbf71d08495d5c10b13bf3faf1373a525505c9575c4a77'),
(21, '2023-07-30', 17, 200017, 31, 'B1', 'B', '2006', 'E', 200201, 'B2006E20020100400', 'Belanja  Belanja Pengelasan pintu wc', '0', '100000', '', '', 'A1003A10030100100', '1003', 'A', '100301', 1, '', '0', '', '2023-08-01 09:53:23', '20f4506e22e08495d5c10b13bf3faf1373a525505c9575c4a77'),
(23, '2023-07-29', 19, 200018, 31, 'B1', 'B', '2006', 'H', 200302, 'B2006H20030200400', 'Belanja  Ban Gerobag Sampah', '0', '100000', '', '', 'A1001A10010200200', '1001', 'A', '100102', 0, '', '0', '', '2023-08-01 11:56:56', '20fa850e22e08495d538d716822a078aff56186feb65e33defd'),
(25, '2023-07-31', 21, 200020, 31, 'B1', 'B', '2003', 'A', 200302, 'B2003A20030200100', 'Belanja  Konsumsi Rapat RKM 29 Juli 2023', '0', '276000', '', '', 'A1001A10010200200', '1001', 'A', '100102', 0, '', '0', '', '2023-08-02 09:36:45', '20f1eb8ee2708495d538d716822a078aff56186feb65e33defd'),
(34, '2023-08-07', 30, 200185, 31, 'B1', 'B', '2004', 'A', 200106, 'B2004A20010600100', 'Belanja  Belanja Akomodasi Rakor Komite Kepala', '0', '1000000', '', '', 'A1001A10010200200', '1001', 'A', '100102', 1, '', '0', '', '2023-10-06 05:18:27', '20ffa8b5bc508495d538d716822a078aff56186feb65e33defd'),
(39, '2023-08-11', 35, 200034, 11, 'A1', 'A', '1001', 'A', 100102, 'A1001A10010200200', 'Terima  Sumbangan Pengembangan Mutu', '500000', '0', NULL, NULL, '', '', '', '', 0, '', '0', 'E37FF60C27F7543B6A', '2023-08-11 14:03:10', 'd3020a6777308495d538d716822a078aff56186feb65d1ab2fc'),
(40, '2023-08-11', 36, 200035, 11, 'A1', 'A', '1001', 'A', 100102, 'A1001A10010200200', 'Terima  Sumbangan Pengembangan Mutu', '100000', '0', NULL, NULL, '', '', '', '', 0, '', '0', '659FF60C27F7543B6A', '2023-08-11 14:03:24', 'e7ea88de22e08495d538d716822a078aff56186feb65d1ab2fc'),
(41, '2023-08-11', 37, 200036, 11, 'A1', 'A', '1001', 'A', 100102, 'A1001A10010200100', 'Terima  Sumbangan Pengembangan Institusi (SPI)', '7800000', '0', NULL, NULL, '', '', '', '', 0, '', '0', 'F466F896F587543B6A', '2023-08-11 14:03:37', 'e07323c45d608495d538d716822a078aff56186feb652aa1c33'),
(42, '2023-08-14', 38, 200037, 43, 'D1', '', '', '', 0, '', 'Pembayaran Hutang Pada Pihak Ketiga Tunai (Dana Simpanan Tanah TP. 2022/2023', '0', '30000000', '-', '-', '', '', '', '', 0, '', '0', '', '2023-08-14 11:19:59', '66fc59f212a08495d598f00b204e9800998ecf8427e5cd98f00'),
(44, '2023-08-14', 40, 200039, 11, 'A1', 'A', '1001', 'A', 100102, 'A1001A10010200100', 'Terima  Sumbangan Pengembangan Institusi (SPI)', '100649990', '0', '', '', '', '', '', '', 0, '', '0', '', '2023-08-14 12:07:02', '43d6853ca0f08495d598f00b204e9800998ecf8427e5cd98f00'),
(46, '2023-08-14', 42, 200041, 11, 'A1', 'A', '1001', 'A', 100102, 'A1001A10010200200', 'Terima  Sumbangan Pengembangan Mutu Kls 7', '2500000', '0', '', '', '', '', '', '', 0, '', '0', '', '2023-08-14 12:12:33', '43dc590163c08495d598f00b204e9800998ecf8427e5cd98f00'),
(49, '2023-08-14', 45, 200044, 11, 'A1', 'A', '1001', 'A', 100102, 'A1001A10010200200', 'Terima  Sumbangan Pengembangan Mutu kLS 8', '83862500', '0', '', '', '', '', '', '', 0, '', '0', '', '2023-08-14 13:23:05', '43d31ff012b08495d598f00b204e9800998ecf8427e5cd98f00'),
(52, '2023-08-15', 48, 200047, 11, 'A1', 'A', '1001', 'A', 100102, 'A1001A10010200200', 'Terima  Sumbangan Pengembangan Mutu Kls 9', '69798500', '0', '', '', '', '', '', '', 0, '', '0', '', '2023-08-15 07:25:25', '43d2494f22508495d598f00b204e9800998ecf8427e5cd98f00'),
(54, '2023-08-15', 50, 200185, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota Konsultasi dan Koordinasi ,Pengelolaan dana Komite', '0', '100000', 'Drs Mohamad Makhi', 'Kasek', 'A1003A10030200100', '1003', 'A', '100302', 1, '', '0', '', '2023-10-05 08:24:27', '20f8477e22e08495d5c10b13bf3faf1373a525505c9575c4a77'),
(55, '2023-08-15', 51, 200185, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota Konsultasi dan Koodinasi ,Pengelola dana Komite', '0', '100000', 'Tukijan', 'Ketua Komite', 'A1003A10030200100', '1003', 'A', '100302', 1, '', '0', '', '2023-10-06 05:17:58', '20f538ee22e08495d5c10b13bf3faf1373a525505c9575c4a77'),
(56, '2023-08-15', 52, 200185, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota Konsultasi dan Koordinasi ,Pengelolaan dana Komite', '0', '75000', 'Khamdi Rahmani S.H.I.', 'Ka TU', 'A1003A10030200100', '1003', 'A', '100302', 1, '', '0', '', '2023-10-06 05:18:14', '20f7daf99b108495d5c10b13bf3faf1373a525505c9575c4a77'),
(57, '2023-08-15', 53, 200121, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota Konsultasi dan Kordinasi .Pengelolaan dana Komite', '0', '75000', 'Fauzin Jamil S.Pd.I M.Pd.I', 'Waka Kesiswaan', 'A1003A10030100100', '1003', 'A', '100301', 1, '', '0', '', '2023-08-29 08:31:26', '20f70be99b108495d5c10b13bf3faf1373a525505c9575c4a77'),
(58, '2023-08-15', 54, 200053, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota Konsultasi dan Koordinasi .pengelolaan dana Komite', '0', '75000', 'Subandi', 'Bendahara Pelaksana Komite', 'A1003A10030100100', '1003', 'A', '100301', 0, '', '0', '', '2023-08-15 14:06:20', '20f2e5699b108495d5c10b13bf3faf1373a525505c9575c4a77'),
(73, '2023-08-19', 65, 200064, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota Mengkuti Technical meeting Lomba gerak jalan', '0', '30000', 'Saiman', 'Petugas Keamanan', 'A1003A10030100100', '1003', 'A', '100301', 0, '', '0', '', '2023-08-19 07:43:12', '20f944ac61308495d5c10b13bf3faf1373a525505c9575c4a77'),
(75, '2023-08-19', 67, 200066, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota  Mengikuti Sosialisasi dan Fasilitasi sertifikasi Produk halal', '0', '75000', 'Muhdir S.Pd.I.', 'Waka Humas', 'A1003A10030100100', '1003', 'A', '100301', 0, '', '0', '', '2023-08-19 08:43:14', '20f8ff599b108495d5c10b13bf3faf1373a525505c9575c4a77'),
(82, '2023-08-21', 74, 200185, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota  Menghadiri undangan Rapat', '0', '75000', 'Ahmad', 'Guru', 'A1003A10030200100', '1003', 'A', '100302', 1, '', '0', '', '2023-10-05 08:23:46', '20ff58f99b108495d5c10b13bf3faf1373a525505c9575c4a77'),
(93, '2023-08-23', 85, 200084, 31, 'B1', 'B', '2003', 'E', 200102, 'B2003E20010200100', 'Belanja   Honorarium Pegawai Tidak Tetap Bln Agustus 2023', '0', '10244000', '', '', 'A1001A10010200300', '1001', 'A', '100102', 0, '', '0', '', '2023-08-23 09:56:37', '20fbd1b399708495d538d716822a078aff56186feb65e33defd'),
(94, '2023-08-23', 86, 200085, 31, 'B1', 'B', '2003', 'E', 200101, 'B2003E20010100200', 'Belanja  Belanja Honorarium Guru Tidak Tetap bLN aGUSTUS 2023', '0', '10290000', '', '', 'A1001A10010200200', '1001', 'A', '100102', 0, '', '0', '', '2023-08-23 10:01:13', '20fb765b74408495d538d716822a078aff56186feb65e33defd'),
(96, '2023-08-23', 88, 200185, 31, 'B1', 'B', '2004', 'A', 200106, 'B2004A20010600100', 'Belanja  Belanja Akomodasi Rapat Koordinasi ANBK  dan Penguatan  Listerasi Numertasi', '0', '150000', 'Koordinasi ANBK dan penguatanListerasi Numerasi  di MTs N 2  Purworejo', '', 'A1001A10010200200', '1001', 'A', '100102', 1, '', '0', '', '2023-10-05 08:24:05', '20f2c6cbedd08495d538d716822a078aff56186feb65e33defd'),
(98, '2023-08-24', 90, 200090, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota Menghadiri Malam Tasyakuran HUT  RI Kecamatan', '0', '30000', 'Muhdir S.Pd.I', 'Waka Humas', 'A1003A10030100100', '1003', 'A', '100301', 1, '', '0', '', '2023-08-24 10:34:15', '20ffa0ac61308495d5c10b13bf3faf1373a525505c9575c4a77'),
(99, '2023-08-24', 91, 200090, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota Menghadiri Undangan Ziaroh  HUT RI  Kecamatan', '0', '30000', 'Muhdir S.Pd.I', 'Waka Humas', 'A1003A10030100100', '1003', 'A', '100301', 0, '', '0', '', '2023-08-24 10:44:34', '20f16c3c61308495d5c10b13bf3faf1373a525505c9575c4a77'),
(100, '2023-08-24', 92, 200091, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota Pengajuan Alih Fung si PTK dan mutasi tgl 21  Agustus 2023', '0', '50000', 'Nasrudin', '', 'A1003A10030100100', '1003', 'A', '100301', 0, '', '0', '', '2023-08-24 10:53:57', '20fa5a47bfd08495d5c10b13bf3faf1373a525505c9575c4a77'),
(101, '2023-08-24', 93, 200092, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota  Mengajukan VERVAL PTK  Baru dan lainya', '0', '50000', 'Nasrudin', 'Operator', 'A1003A10030100100', '1003', 'A', '100301', 0, '', '0', '', '2023-08-24 11:28:17', '20f14fc7bfd08495d5c10b13bf3faf1373a525505c9575c4a77'),
(106, '2023-08-25', 98, 200097, 31, 'B1', 'B', '2002', 'J', 200302, 'B2002J20030200200', 'Belanja  Keperluan  outbond Balon Tiup', '0', '22000', '', '', 'A1003A10030100100', '1003', 'A', '100301', 0, '', '0', '', '2023-08-25 07:28:11', '20ffef0ea0608495d5c10b13bf3faf1373a525505c9575c4a77'),
(107, '2023-08-25', 99, 200101, 31, 'B1', 'B', '2002', 'J', 200302, 'B2002J20030200400', 'Belanja  Snack seluruh guru', '0', '1140000', 'Toko senek Rohman Buah', '', 'A1001A10010200100', '1001', 'A', '100102', 1, '', '0', '', '2023-08-25 07:50:54', '20f4cdce6c608495d538d716822a078aff56186feb65e33defd'),
(118, '2023-08-25', 110, 200109, 31, 'B1', 'B', '2003', 'F', 200402, 'B2003F20040200300', 'Belanja  Sewa Sound Sistem  [Rapat Pleno]', '0', '600000', 'Jarodin', 'Tukang Ssond', 'A1001A10010200200', '1001', 'A', '100102', 0, '', '0', '', '2023-08-25 10:59:26', '20fc6b163a408495d538d716822a078aff56186feb65e33defd'),
(119, '2023-08-25', 111, 200110, 31, 'B1', 'B', '2003', 'F', 200402, 'B2003F20040200100', 'Belanja  Sewa Tarub [Rapat Pleno]', '0', '1094000', '', '', 'A1001A10010200200', '1001', 'A', '100102', 0, '', '0', '', '2023-08-25 11:03:41', '20fc5fd626908495d538d716822a078aff56186feb65e33defd'),
(120, '2023-08-25', 112, 200111, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota jumtek PMI', '0', '75000', 'Wasitun', 'Pembina PMR', 'A1003A10030100100', '1003', 'A', '100301', 0, '', '0', '', '2023-08-25 11:32:46', '20fc72a99b108495d5c10b13bf3faf1373a525505c9575c4a77'),
(133, '2023-08-30', 125, 200124, 31, 'B1', 'B', '2006', 'G', 200301, 'B2006G20030101400', 'Belanja  Buku MANAWA ( Satu SET Kitab Syeh  Nawawi An Bantani )', '0', '3310000', 'Ahmad Baehaki', 'PT. Alifa', 'A1001A10010200200', '1001', 'A', '100102', 0, '', '0', '', '2023-08-30 11:29:23', '20fe163585c08495d538d716822a078aff56186feb65e33defd'),
(135, '2023-08-30', 127, 200126, 31, 'B1', 'B', '2003', 'D', 200501, 'B2003D20050100100', 'Belanja  Perjalanan Dinas Pengiriman Kegiatan Bimtek Penguatan Penyelenggaraan Sekolah Pendidikan Inklusi.', '0', '75000', 'AgusWidodo S.Pd.', 'Guru BP Kls 10', 'A1001A10010200300', '1001', 'A', '100102', 0, '', '0', '', '2023-08-30 13:40:54', '20f3c5399b108495d538d716822a078aff56186feb65e33defd'),
(136, '2023-08-30', 128, 200127, 31, 'B1', 'B', '2003', 'D', 200501, 'B2003D20050100100', 'Belanja  Perjalanan Dinas Pengiriman Kegiatan Bimtek Penguatan  Penyelenggaraan Sekolah Pendidikan Inklusi', '0', '150000', 'Tukijan', 'Ketua Komite', 'A1001A10010200300', '1001', 'A', '100102', 0, '', '0', '', '2023-08-30 14:16:04', '20f0a3bbedd08495d538d716822a078aff56186feb65e33defd'),
(137, '2023-08-30', 129, 200128, 31, 'B1', 'B', '2003', 'D', 200501, 'B2003D20050100100', 'Belanja  Perjalanan Dinas Pengiriman Kegiatan Bimtek Penguatan Penyelenggaraan  Sekolah Pendidikan Inklusi', '0', '75000', 'Fauzin Jamil S.Pd.I M.Pd.I', 'Waka Humas', 'A1001A10010200300', '1001', 'A', '100102', 0, '', '0', '', '2023-08-30 14:23:40', '20f28cc99b108495d538d716822a078aff56186feb65e33defd'),
(138, '2023-08-30', 130, 200129, 31, 'B1', 'B', '2003', 'D', 200501, 'B2003D20050100100', 'Belanja  Perjalanan Dinas Pengiriman Kegiatan Bimtek Penguatan Penyelenggaraan Sekolah Pendidikan Inklusi', '0', '75000', 'Puji Astuti S.Pd.', 'Guru BP kls 11', 'A1001A10010200300', '1001', 'A', '100102', 0, '', '0', '', '2023-08-30 14:28:24', '20f776f99b108495d538d716822a078aff56186feb65e33defd'),
(140, '2023-08-31', 132, 200131, 11, 'A1', 'A', '1001', 'A', 100102, 'A1001A10010200100', 'Terima  Sumbangan Pengembangan Institusi (SPI)', '400000', '0', NULL, NULL, '', '', '', '', 0, '', '0', 'A986F896F588543E23', '2023-08-31 11:38:59', '35304c5a2d208495d538d716822a078aff56186feb652aa1c33'),
(141, '2023-08-31', 133, 200132, 11, 'A1', 'A', '1001', 'A', 100102, 'A1001A10010200200', 'Terima  Sumbangan Pengembangan Mutu', '250000', '0', NULL, NULL, '', '', '', '', 0, '', '0', '6C6FF60C27F8543E23', '2023-08-31 14:11:43', '1529abc455508495d538d716822a078aff56186feb65d1ab2fc'),
(142, '2023-09-01', 134, 200133, 31, 'B1', 'B', '2003', 'E', 200113, 'B2003E20011300100', 'Belanja  Belanja Honorarium Petugas Piket Hari Libur Bln  Juni , Juli ,Agustus 2023', '0', '950000', '-', '-', 'A1001A10010200200', '1001', 'A', '100102', 0, '', '0', '', '2023-09-01 11:05:25', '20f86abf89e08495d538d716822a078aff56186feb65e33defd'),
(144, '2023-09-01', 136, 200135, 31, 'B1', 'B', '2003', 'E', 200102, 'B2003E20010200100', 'Belanja   Honorarium Pegawai Tidak Tetap  September 2023', '0', '9249000', '', '', 'A1001A10010200300', '1001', 'A', '100102', 0, '', '0', '', '2023-09-01 11:17:32', '20fdcb8a0a308495d538d716822a078aff56186feb65e33defd'),
(145, '2023-09-01', 137, 200136, 31, 'B1', 'B', '2003', 'E', 200101, 'B2003E20010100200', 'Belanja  Honorarium Guru Tidak Tetap  Bulan September 2023', '0', '8125000', '', '', 'A1001A10010200200', '1001', 'A', '100102', 0, '', '0', '', '2023-09-01 11:20:34', '20ffe5eed9d08495d538d716822a078aff56186feb65e33defd'),
(148, '2023-08-31', 140, 200153, 31, 'B1', 'B', '2003', 'F', 200105, 'B2003F20010500100', 'Belanja  insentif Panitia Pelaksana Rapat Pleno Tgl 12 Agustus 2023', '0', '1250000', '', '', 'A1001A10010200300', '1001', 'A', '100102', 1, '', '0', '', '2023-09-11 08:07:43', '20fc596135008495d538d716822a078aff56186feb65e33defd'),
(153, '2023-08-12', 145, 200144, 21, 'C0', '', '', '', 0, '', 'Setor Tunai ke Bank', '70000000', '70000000', '', '', '', '', '', '', 0, '', '0', '', '2023-09-09 08:45:42', '048ffca045608495d598f00b204e9800998ecf8427e5cd98f00'),
(154, '2023-08-31', 146, 200146, 31, 'B1', 'B', '2004', 'A', 200501, 'B2004A20050100100', 'Belanja  Perjalanan Dinas Dalam Kota Mengantar Undangan Komite PErsiapan Pleno Tgl 4 Agustus 23', '0', '35000', '', '', 'A1003A10030100100', '1003', 'A', '100301', 1, '', '0', '', '2023-09-09 14:13:14', '20fb3bf8c9708495d5c10b13bf3faf1373a525505c9575c4a77'),
(156, '2023-08-31', 148, 200149, 31, 'B1', 'B', '2003', 'F', 200106, 'B2003F20010600200', 'Belanja  Transport Rapat Rutin Peesiapan Pleno Tgl 12 Agustus 2023', '0', '1050000', '', '', 'A1001A10010200300', '1001', 'A', '100102', 1, '', '0', '', '2023-09-09 14:48:28', '20f1e020ebb08495d538d716822a078aff56186feb65e33defd'),
(159, '2023-08-31', 151, 200152, 31, 'B1', 'B', '2007', 'A', 200401, 'B2007A20040100100', 'Belanja Pajak  Honor Nara Sumber  dan  Work shop IKM', '0', '262500', '-', '-', 'A1003A10030100100', '1003', 'A', '100301', 1, '', '0', '', '2023-09-11 07:34:01', '20f056daf3508495d5c10b13bf3faf1373a525505c9575c4a77'),
(161, '2023-08-31', 153, 200152, 31, 'B1', 'B', '2003', 'F', 200106, 'B2003F20010600200', 'Belanja  Transport Pengurus Komite  dalam Rangka  Rapat  pleno', '0', '1350000', '', '', 'A1001A10010200300', '1001', 'A', '100102', 0, '', '0', '', '2023-09-11 07:53:58', '20f3d6314be08495d538d716822a078aff56186feb65e33defd'),
(164, '2023-08-31', 156, 200155, 31, 'B1', 'B', '2006', 'E', 200201, 'B2006E20020100500', 'Belanja  Gembok ,Paku dll', '0', '166500', '', '', 'A1003A10030100100', '1003', 'A', '100301', 0, '', '0', '', '2023-09-11 09:59:43', '20f4468f82a08495d5c10b13bf3faf1373a525505c9575c4a77'),
(174, '2023-08-31', 166, 200185, 31, 'B1', 'B', '2004', 'A', 200106, 'B2004A20010600100', 'Belanja  Belanja Akomodasi Rapat Pembinaan Bidang Penma dan Bintek Work Shop digilitalisasi', '0', '128000', '', '', 'A1001A10010200200', '1001', 'A', '100102', 1, '', '0', '', '2023-10-06 05:18:49', '20fb524347908495d538d716822a078aff56186feb65e33defd'),
(179, '2023-08-31', 171, 200175, 31, 'B1', 'B', '2006', 'H', 200302, 'B2006H20030200500', 'Belanja  PIngkrak,Tutup Kran dll', '0', '101000', '', '', 'A1001A10010200200', '1001', 'A', '100102', 1, '', '0', '', '2023-09-13 13:50:57', '20fefc67b8c08495d538d716822a078aff56186feb65e33defd'),
(180, '2023-09-13', 172, 200171, 31, 'B1', 'B', '2003', 'A', 200302, 'B2003A20030200100', 'Belanja  Konsumsi Rapat', '0', '252000', '-', '-', 'A1001A10010200200', '1001', 'A', '100102', 0, '', '0', '', '2023-09-13 07:28:59', '20f7725d93b08495d538d716822a078aff56186feb65e33defd'),
(188, '2023-09-14', 180, 200185, 31, 'B1', 'B', '2003', 'A', 200106, 'B2003A20010600100', 'Belanja  Insentif Tim TPM Penyusunan EDS', '0', '10000000', '-', '-', 'A1001A10010200200', '1001', 'A', '100102', 1, '', '0', '', '2023-10-06 05:18:37', '20fc944a3aa08495d538d716822a078aff56186feb65e33defd'),
(189, '2023-09-14', 181, 200180, 31, 'B1', 'B', '2006', 'E', 200201, 'B2006E20020100100', 'Belanja  Gembok Ruang Kelas', '0', '157500', '', '', 'A1003A10030100100', '1003', 'A', '100301', 0, '', '0', '', '2023-09-14 14:31:44', '20f915f5fd708495d5c10b13bf3faf1373a525505c9575c4a77'),
(193, '2023-09-15', 185, 200184, 31, 'B1', 'B', '2006', 'H', 200302, 'B2006H20030200100', 'Belanja  Bensin penyiraman halaman', '0', '200000', 'Humaidah', 'Marketing Koperasi', 'A1001A10010200200', '1001', 'A', '100102', 0, '', '0', '', '2023-09-15 10:32:51', '20f77016c6108495d538d716822a078aff56186feb65e33defd');

-- --------------------------------------------------------

--
-- Table structure for table `tabungan_periode`
--

CREATE TABLE `tabungan_periode` (
  `no` int(11) NOT NULL,
  `tahun` varchar(9) NOT NULL,
  `status` varchar(6) NOT NULL,
  `created_at` datetime NOT NULL,
  `closed_at` datetime DEFAULT NULL,
  `closed_by` varchar(100) DEFAULT NULL,
  `id` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tabungan_periode`
--

INSERT INTO `tabungan_periode` (`no`, `tahun`, `status`, `created_at`, `closed_at`, `closed_by`, `id`) VALUES
(1, '2022/2023', 'close', '2023-04-20 11:33:23', '2023-10-03 05:06:19', 'tabungan', '38eafdfa86559e303bd0'),
(2, '2023/2024', 'open', '2023-04-21 19:57:26', '1901-01-01 00:00:00', '', 'da6363e171cecab03bd0');

-- --------------------------------------------------------

--
-- Table structure for table `tabungan_siswa2324`
--

CREATE TABLE `tabungan_siswa2324` (
  `no` int(11) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `nis` varchar(18) NOT NULL,
  `rekening` varchar(20) NOT NULL,
  `kelamin` varchar(2) NOT NULL,
  `saldo` varchar(15) NOT NULL,
  `status` varchar(15) NOT NULL,
  `id` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tabungan_siswa2324`
--

INSERT INTO `tabungan_siswa2324` (`no`, `nama`, `nis`, `rekening`, `kelamin`, `saldo`, `status`, `id`, `created_at`, `updated_at`, `created_by`) VALUES
(1, 'ADHITYA NUR RAHMAT', '230002', '230002', 'L', '0', 'Aktif', '4d32e045c04dc8b13523', '2023-10-03 05:06:44', '2023-10-03 05:06:44', 'd0f83653fdb01ed928a4'),
(2, 'AHMAD ROMADHON', '230003', '230003', 'L', '0', 'Aktif', 'e7b90eb764686ef13523', '2023-10-03 05:06:57', '2023-10-03 05:06:57', 'd0f83653fdb01ed928a4');

-- --------------------------------------------------------

--
-- Table structure for table `tabungan_transaksi2324`
--

CREATE TABLE `tabungan_transaksi2324` (
  `no` int(11) NOT NULL,
  `tanggal` date NOT NULL,
  `nis` varchar(18) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `jenis` varchar(2) NOT NULL,
  `jumlah` varchar(15) NOT NULL,
  `jurnal` varchar(1) NOT NULL,
  `catatan` text NOT NULL,
  `created_by` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  `id` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tabungan_transaksi2324`
--

INSERT INTO `tabungan_transaksi2324` (`no`, `tanggal`, `nis`, `nama`, `jenis`, `jumlah`, `jurnal`, `catatan`, `created_by`, `created_at`, `id`) VALUES
(1, '2023-10-03', '230002', 'ADHITYA NUR RAHMAT', 'D', '50000', '', '', 'd0f83653fdb01ed928a4', '2023-10-03 05:07:12', '8d54b485467c18f1017b4d32e'),
(2, '2023-10-03', '230002', 'ADHITYA NUR RAHMAT', 'K', '10000', '', '', 'd0f83653fdb01ed928a4', '2023-10-03 05:08:16', '8d54bcfe9a96a52b7a784d32e'),
(3, '2023-10-08', '230003', 'AHMAD ROMADHON', 'D', '50000', '', '', 'd0f83653fdb01ed928a4', '2023-10-08 20:45:02', 'bdb5d7aadd520d61017be7b90');

-- --------------------------------------------------------

--
-- Table structure for table `tb_jenjang`
--

CREATE TABLE `tb_jenjang` (
  `no` int(11) NOT NULL,
  `jenjang` varchar(15) NOT NULL,
  `j-1` varchar(5) NOT NULL,
  `j-2` varchar(5) NOT NULL,
  `j-3` varchar(5) NOT NULL,
  `j-4` varchar(5) NOT NULL,
  `j-5` varchar(5) NOT NULL,
  `j-6` varchar(5) NOT NULL,
  `j-t` varchar(5) NOT NULL,
  `db` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_jenjang`
--

INSERT INTO `tb_jenjang` (`no`, `jenjang`, `j-1`, `j-2`, `j-3`, `j-4`, `j-5`, `j-6`, `j-t`, `db`) VALUES
(1, 'PAUD', 'TPA', 'KB', 'TK', '', '', '', '', 'aks_paud'),
(2, 'SD', '1', '2', '3', '4', '5', '6', '6', 'aks_sd'),
(3, 'SMP', '7', '8', '9', '', '', '', '9', 'aks_smp'),
(4, 'SMA', '10', '11', '12', '', '', '', '12', 'aks_sma');

-- --------------------------------------------------------

--
-- Table structure for table `tb_kodebelanja`
--

CREATE TABLE `tb_kodebelanja` (
  `no` int(11) NOT NULL,
  `kategori` varchar(100) NOT NULL,
  `kode` varchar(2) NOT NULL,
  `kode_li` varchar(2) NOT NULL,
  `kode_emis` varchar(2) NOT NULL,
  `kode_akreditasi` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_kodebelanja`
--

INSERT INTO `tb_kodebelanja` (`no`, `kategori`, `kode`, `kode_li`, `kode_emis`, `kode_akreditasi`) VALUES
(1, 'Gaji Guru PNS', 'A', 'A', 'A', 'B'),
(2, 'Gaji Guru DPK (Swasta)', 'B', 'B', 'A', 'B'),
(3, 'Gaji Guru Honorer', 'C', 'C', 'B', 'B'),
(4, 'Gaji Guru Bantu/Kontrak', 'D', 'D', 'B', 'B'),
(5, 'Kesra Guru PNS', 'E', 'E', 'A', 'B'),
(6, 'Kesra Guru Honorer', 'F', 'E', 'B', 'B'),
(7, 'Gaji Pegawai TU PNS', 'G', 'F', 'A', 'C'),
(8, 'Gaji Pegawai TU Honorer', 'H', 'G', 'B', 'C'),
(9, 'Kesra Pegawai TU PNS', 'I', 'H', 'A', 'C'),
(10, 'Kesra Pegawai TU Honorer', 'J', 'H', 'B', 'C'),
(11, 'Pengembangan Profesi Guru', 'K', 'I', 'I', 'B'),
(12, 'Biaya Pelaksanaan Ulangan dan Ujian', 'L', 'I', 'J', 'E'),
(13, 'Kegiatan Ekstrakurikuler', 'M', 'P', 'H', 'K'),
(14, 'Kegiatan PPDB', 'N', 'I', 'K', 'K'),
(15, 'Pemeliharaan Gedung', 'O', 'J', 'E', 'F'),
(16, 'Pemeliharaan Alat', 'P', 'K', 'E', 'F'),
(17, 'Pemeliharaan Perabot', 'Q', 'L', 'E', 'F'),
(18, 'Rehabilitasi', 'R', 'M', 'D', 'A'),
(19, 'Pengadaan Buku', 'S', 'N', 'F', 'A'),
(20, 'Pengadaan Lainnya', 'T', 'O', 'C', 'A'),
(21, 'Pengembangan Perpustakaan', 'U', 'N', 'F', 'A'),
(22, 'Alat Tulis Sekolah - ATK (Tata Usaha/Administrasi)', 'V', 'I', 'L', 'D'),
(23, 'Bahan dan Alat Habis Pakai (Tata Usaha/Administrasi)', 'W', 'I', 'L', 'E'),
(24, 'Konsumsi Rapat / Tamu (Tata Usaha/Administrasi)', 'X', 'S', 'L', 'I'),
(25, 'Daya dan Jasa', 'Y', 'Q', 'G', 'G'),
(26, 'Transportasi / Perjadin (Tata Usaha/Administrasi)', 'Z', 'R', 'L', 'H'),
(27, 'Transportasi / Perjadin (Guru)', 'AA', 'I', 'I', 'H'),
(28, 'Pelaporan', 'AB', 'R', 'L', 'L'),
(29, 'Lainnya', 'AC', 'S', 'M', 'E');

-- --------------------------------------------------------

--
-- Table structure for table `tb_nama_bayar`
--

CREATE TABLE `tb_nama_bayar` (
  `no` int(11) NOT NULL,
  `tp` varchar(10) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `kode` varchar(2) NOT NULL,
  `bulanan` varchar(10) NOT NULL,
  `id` varchar(15) NOT NULL,
  `blok` varchar(20) NOT NULL,
  `kelas` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_nama_bayar`
--

INSERT INTO `tb_nama_bayar` (`no`, `tp`, `nama`, `kode`, `bulanan`, `id`, `blok`, `kelas`) VALUES
(31, '2023/2024', 'Tanggungan Tahun Lalu', 'A', 'Tidak', '2023/2024A8', '', '11'),
(32, '2023/2024', 'Tanggungan Tahun Lalu', 'A', 'Tidak', '2023/2024A9', '', '12'),
(34, '2023/2024', 'Sumbangan Operasional Sekolah (SOP)', 'B', 'Ya', '2023/2024B10', '', '10'),
(35, '2023/2024', 'Sumbangan Operasional Sekolah (SOP)', 'B', 'Ya', '2023/2024B8', '', '11'),
(36, '2023/2024', 'Sumbangan Operasional Sekolah (SOP)', 'B', 'Ya', '2023/2024B9', '', '12'),
(53, '2023/2024', 'Uang Kegiatan', 'C', 'Tidak', '2023/2024C8', '', '11'),
(54, '2023/2024', 'Uang Kegiatan', 'C', 'Tidak', '2023/2024C9', '', '12'),
(61, '2023/2024', 'Tanggungan Tahun Lalu', 'A', 'Tidak', '2023/2024ALulus', '', 'LULUS'),
(62, '2023/2024', 'Uang Kegiatan', 'C', 'Tidak', '2023/2024C7', '', '10');

-- --------------------------------------------------------

--
-- Table structure for table `tb_paralel`
--

CREATE TABLE `tb_paralel` (
  `no` int(11) NOT NULL,
  `id` varchar(50) NOT NULL,
  `paralel` varchar(20) NOT NULL,
  `status` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_paralel`
--

INSERT INTO `tb_paralel` (`no`, `id`, `paralel`, `status`) VALUES
(18, '9d5ed678fe57e75fa5704cf40', 'B', 'Aktif'),
(21, '0d61f8370cad82c486547f599', 'C', 'Aktif'),
(23, '7fc56270e7a70c1fbfac34ac2', 'A', 'Aktif'),
(24, 'f623e75af30e6f2052d0bd5ba', 'D', 'Aktif'),
(25, '3a3ea00cfc35009f23e17ec68', 'E', 'Aktif'),
(26, '800618943025ed73eb5b6b972', 'F', 'Aktif'),
(27, 'dfcf28d07345df1fb088c98f0', 'G', 'Aktif'),
(33, 'e11c1bc57b97131059d58b826', 'LULUS', 'Aktif');

-- --------------------------------------------------------

--
-- Table structure for table `tb_periode`
--

CREATE TABLE `tb_periode` (
  `no` int(11) NOT NULL,
  `periode` varchar(10) NOT NULL,
  `nilai` varchar(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_periode`
--

INSERT INTO `tb_periode` (`no`, `periode`, `nilai`) VALUES
(1, 'Januari', '01'),
(2, 'Februari', '02'),
(3, 'Maret', '03'),
(4, 'April', '04'),
(5, 'Mei', '05'),
(6, 'Juni', '06'),
(7, 'Juli', '07'),
(8, 'Agustus', '08'),
(9, 'September', '09'),
(10, 'Oktober', '10'),
(11, 'Nopember', '11'),
(12, 'Desember', '12');

-- --------------------------------------------------------

--
-- Table structure for table `tb_rekening`
--

CREATE TABLE `tb_rekening` (
  `no` int(11) NOT NULL,
  `rekening` varchar(50) NOT NULL,
  `bank` varchar(150) NOT NULL,
  `an` text NOT NULL,
  `wa` varchar(15) NOT NULL,
  `operator` varchar(100) NOT NULL,
  `id` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_rekening`
--

INSERT INTO `tb_rekening` (`no`, `rekening`, `bank`, `an`, `wa`, `operator`, `id`) VALUES
(31, '013401025248501', 'BRI CAbang Gombong', 'Komite MTs N 6 Kebumen', '085328654555', 'Khamdi Rahmani', '40e8a1308036d4d0828f6123c4fd83d7'),
(33, '754511112', 'BSI Gombong', 'KOmite', '0854553432', 'Aku', '44770e11ef14db2e52bdb2689621a33b');

-- --------------------------------------------------------

--
-- Table structure for table `tb_siswa2324`
--

CREATE TABLE `tb_siswa2324` (
  `no` int(11) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `nis` varchar(18) NOT NULL,
  `kelamin` varchar(20) NOT NULL,
  `jenjang` varchar(5) NOT NULL,
  `paralel` varchar(20) NOT NULL,
  `ortu` varchar(75) DEFAULT NULL,
  `alamat` text DEFAULT NULL,
  `tang_A` varchar(10) NOT NULL,
  `tang_B` varchar(10) NOT NULL,
  `tang_C` varchar(10) NOT NULL,
  `tang_D` varchar(10) NOT NULL,
  `tang_E` varchar(10) NOT NULL,
  `tang_F` varchar(10) NOT NULL,
  `tang_G` varchar(10) NOT NULL,
  `tang_H` varchar(10) NOT NULL,
  `tang_I` varchar(10) NOT NULL,
  `tang_J` varchar(10) NOT NULL,
  `tang_K` varchar(10) NOT NULL,
  `tang_L` varchar(10) NOT NULL,
  `tang_M` varchar(10) NOT NULL,
  `tang_N` varchar(10) NOT NULL,
  `tang_O` varchar(10) NOT NULL,
  `tang_P` varchar(10) NOT NULL,
  `tang_Q` varchar(10) NOT NULL,
  `tang_R` varchar(10) NOT NULL,
  `tang_S` varchar(10) NOT NULL,
  `tang_T` varchar(10) NOT NULL,
  `tang_U` varchar(10) NOT NULL,
  `tang_V` varchar(10) NOT NULL,
  `tang_W` varchar(10) NOT NULL,
  `tang_X` varchar(10) NOT NULL,
  `tang_Y` varchar(10) NOT NULL,
  `tang_Z` varchar(10) NOT NULL,
  `status` varchar(15) NOT NULL,
  `email` varchar(75) NOT NULL,
  `hp` varchar(15) NOT NULL,
  `kategori` varchar(200) NOT NULL,
  `startAt` varchar(2) NOT NULL,
  `id` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tb_siswa_kategori`
--

CREATE TABLE `tb_siswa_kategori` (
  `no` int(11) NOT NULL,
  `kategori` varchar(200) NOT NULL,
  `id` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_siswa_kategori`
--

INSERT INTO `tb_siswa_kategori` (`no`, `kategori`, `id`, `created_at`) VALUES
(1, 'Umum', '919db3a7bfc497f00ddfb51592d', '2023-05-24 05:31:46'),
(4, 'MMP', '606670ce12a5a75f2ada86cae30', '2023-07-31 08:44:47'),
(5, 'Akademik', '1603223377224863b9c36f969e2', '2023-07-31 08:44:57'),
(6, 'KKO', 'de3ad54b3bd47253639bd484582', '2023-07-31 08:45:02');

-- --------------------------------------------------------

--
-- Table structure for table `tb_siswa_min2324`
--

CREATE TABLE `tb_siswa_min2324` (
  `no` int(11) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `nis` varchar(18) NOT NULL,
  `jenjang` varchar(5) NOT NULL,
  `paralel` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tb_tingkat`
--

CREATE TABLE `tb_tingkat` (
  `no` int(11) NOT NULL,
  `tingkat` varchar(5) NOT NULL,
  `paud` varchar(5) NOT NULL,
  `sd` varchar(5) NOT NULL,
  `smp` varchar(5) NOT NULL,
  `sma` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_tingkat`
--

INSERT INTO `tb_tingkat` (`no`, `tingkat`, `paud`, `sd`, `smp`, `sma`) VALUES
(1, '1', 'TPA', '1', '7', '10'),
(2, '2', 'KB', '2', '8', '11'),
(3, '3', 'TK', '3', '9', '12'),
(4, '4', '', '4', '', ''),
(5, '5', '', '5', '', ''),
(6, '6', '', '6', '', ''),
(7, '7', 'Lulus', 'Lulus', 'Lulus', 'Lulus');

-- --------------------------------------------------------

--
-- Table structure for table `tb_tp`
--

CREATE TABLE `tb_tp` (
  `no` int(11) NOT NULL,
  `tp` varchar(9) NOT NULL,
  `backup` varchar(100) NOT NULL,
  `time` datetime NOT NULL,
  `id` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `tb_tp`
--

INSERT INTO `tb_tp` (`no`, `tp`, `backup`, `time`, `id`, `created_at`, `created_by`) VALUES
(13, '2023/2024', '', '2023-07-10 14:24:48', '5531a5834816c3f04945cbc9d', '2023-07-10 14:24:48', '113ccaa98a0a30bc5204ed2fccc9c515');

-- --------------------------------------------------------

--
-- Table structure for table `tb_walikelas`
--

CREATE TABLE `tb_walikelas` (
  `no` int(11) NOT NULL,
  `tp` varchar(9) NOT NULL,
  `jenjang` varchar(2) NOT NULL,
  `paralel` varchar(100) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `nip` varchar(18) NOT NULL,
  `id` varchar(50) NOT NULL,
  `created_at` datetime NOT NULL,
  `created_by` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `tutorial`
--

CREATE TABLE `tutorial` (
  `no` int(11) NOT NULL,
  `judul` text NOT NULL,
  `link` text NOT NULL,
  `kategori` varchar(50) NOT NULL,
  `id` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tutorial`
--

INSERT INTO `tutorial` (`no`, `judul`, `link`, `kategori`, `id`) VALUES
(1, '1. Gambaran Umum AKS-SIMAKOM', 'https://www.youtube.com/embed/Jn2_-uVA0nU?si=lTR2irwSBxhjRmH9', 'All', 'fdwef8413hfui1nhfvherf343gg34'),
(2, '2. Fitur Aplikasi AKS-SIMAKOM', 'https://www.youtube.com/embed/tE9EfBI2Y6Y?si=1eOSuyAaY_FD-xcL', 'All', 'fdwef8413hfui1nhfvherf34398hj'),
(3, '3. Apa yang dilakukan Pertama Kali', 'https://www.youtube.com/embed/oTJCNotdJDM?si=XsIt6-JmOWnuqCZV', 'All', 'fdwef8jah67di1nhfvherf34398hj'),
(4, '4. Seting / Pengaturan Aplikasi [Modul : Admin/Teller]', 'https://www.youtube.com/embed/3OtkiCQ3a9s?si=2bab1m6dHcDqxl-9', 'All', 'fdwef8jah67di1nhfac8rf34398hj'),
(5, '5. Backup & Restore Database [Modul : Admin/Teller]', 'https://www.youtube.com/embed/pqRpX2LY1G4?si=9VAO8ZqHOGoP0J5T', 'All', 'fdwef8jah67di9aje6ac8rf34398hj'),
(6, '6. Rekam Transaksi Pembayaran [Modul : Admin/Teller]', 'https://www.youtube.com/embed/_DceXOfuYrY?si=z8WVpYWIOSJxCkca', 'All', 't4aef8jah67di9aje6ac8rf34398hj'),
(7, '7. Pengelolaan Data Transaksi Pembayaran [Modul : Admin/Teller]', 'https://www.youtube.com/embed/yBle8J4S-Zs?si=GfUFRBwLwWqsQrrE', 'All', 't4aef8jah67di9a8ahac8rf34398hj'),
(8, '8. Sistem Setor ke Bendahara [Modul : Admin/Teller/Bendahara]', 'https://www.youtube.com/embed/bm8C3Boolvo?si=WBoN8MMprcePiKaT', 'All', 't4aef8jah67di9a8ahac8rf3438ao7'),
(9, '9. Laporan / Report AKS [Modul : Admin/Teller]', 'https://www.youtube.com/embed/ghralSbDySk?si=biTwBxvy4T80Psak', 'All', 't4aef8jah6ka69a8ahac8rf3438ao7'),
(10, '10. Modul Monitoring [Modul : Monitoring ]', 'https://www.youtube.com/embed/zSuY1hbpawM?si=Zwc3dEf4lDD9dVEc', 'All', 't4aef8jah6ka69a8ahac8rf34388pw');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `no` int(11) NOT NULL,
  `id_user` varchar(20) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `kelamin` varchar(1) NOT NULL,
  `email` varchar(120) NOT NULL,
  `hp` varchar(18) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(50) NOT NULL,
  `level` varchar(20) NOT NULL,
  `status` varchar(10) NOT NULL,
  `id` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`no`, `id_user`, `nama`, `kelamin`, `email`, `hp`, `username`, `password`, `level`, `status`, `id`) VALUES
(11, '9J2mFH', 'Khamdi', 'L', 'admin@gmail.com', '0888888888', 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'admin', 'Aktif', '50463efa59739fd6caf07114793ee291'),
(26, 'd0f83653fdb01ed928a4', 'Siti', 'P', '', '', 'tabungan', 'c1b1f59dbfe51b882c8b0dd09c86c1ca', 'tabungan', 'Aktif', 'd0f83653fdb01ed928a4'),
(27, '606ef979469528e637f6', 'Khumairah', 'P', '', '', 'bendahara', 'c9ccd7f3c1145515a9d3f7415d5bcbea', 'bendahara', 'Aktif', '606ef979469528e637f6'),
(28, '4bc2be4245c022748235', 'Ahmad', 'L', '', '', 'kepala', '870f669e4bbbfa8a6fde65549826d1c4', 'monitoring', 'Aktif', '4bc2be4245c022748235'),
(29, '6088971c048fb45e4317', 'Nisa', 'P', '', '', 'teller', '8482dfb1bca15b503101eb438f52deed', 'teller', 'Aktif', '6088971c048fb45e4317');

-- --------------------------------------------------------

--
-- Table structure for table `user_siswa`
--

CREATE TABLE `user_siswa` (
  `no` int(11) NOT NULL,
  `nis` varchar(18) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `kelamin` varchar(1) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(50) NOT NULL,
  `hp` varchar(15) NOT NULL,
  `email` varchar(150) NOT NULL,
  `id` text NOT NULL,
  `status` varchar(10) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_by` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `whatsapp`
--

CREATE TABLE `whatsapp` (
  `no` int(11) NOT NULL,
  `aktif` varchar(1) DEFAULT NULL,
  `sistem` varchar(2) NOT NULL,
  `key_api` text DEFAULT NULL,
  `server` text NOT NULL,
  `token` varchar(100) DEFAULT NULL,
  `device` varchar(15) DEFAULT NULL,
  `idinstance` text NOT NULL,
  `admin` varchar(15) DEFAULT NULL,
  `id` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `whatsapp`
--

INSERT INTO `whatsapp` (`no`, `aktif`, `sistem`, `key_api`, `server`, `token`, `device`, `idinstance`, `admin`, `id`) VALUES
(1, '', '', '', '', '0', '', '', '0', 'E0C1A06358CCF7F36F2D151AFBD46E4A');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `billing`
--
ALTER TABLE `billing`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `bulanan`
--
ALTER TABLE `bulanan`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `db_setor2324`
--
ALTER TABLE `db_setor2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `db_transaksi2324`
--
ALTER TABLE `db_transaksi2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `deleted`
--
ALTER TABLE `deleted`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `deleted_tabungan`
--
ALTER TABLE `deleted_tabungan`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `deleted_transaksi`
--
ALTER TABLE `deleted_transaksi`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `kd_namabayar`
--
ALTER TABLE `kd_namabayar`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `kuitansi_pejabat`
--
ALTER TABLE `kuitansi_pejabat`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `log`
--
ALTER TABLE `log`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `mailer`
--
ALTER TABLE `mailer`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `pajak`
--
ALTER TABLE `pajak`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `payment_list2324`
--
ALTER TABLE `payment_list2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `payment_list_detail`
--
ALTER TABLE `payment_list_detail`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `payment_set`
--
ALTER TABLE `payment_set`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `payment_temp`
--
ALTER TABLE `payment_temp`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `sekolah`
--
ALTER TABLE `sekolah`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `serial`
--
ALTER TABLE `serial`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `simakom_akun2324`
--
ALTER TABLE `simakom_akun2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `simakom_detail2324`
--
ALTER TABLE `simakom_detail2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `simakom_jurnal2324`
--
ALTER TABLE `simakom_jurnal2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `simakom_kegiatan2324`
--
ALTER TABLE `simakom_kegiatan2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `simakom_komponen2324`
--
ALTER TABLE `simakom_komponen2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `simakom_ref_akun`
--
ALTER TABLE `simakom_ref_akun`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `simakom_ref_jenisbelanja`
--
ALTER TABLE `simakom_ref_jenisbelanja`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `simakom_ref_kategori`
--
ALTER TABLE `simakom_ref_kategori`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `simakom_ref_kegiatan`
--
ALTER TABLE `simakom_ref_kegiatan`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `simakom_revisi2324`
--
ALTER TABLE `simakom_revisi2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `simakom_transaksi2324`
--
ALTER TABLE `simakom_transaksi2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `tabungan_periode`
--
ALTER TABLE `tabungan_periode`
  ADD PRIMARY KEY (`no`),
  ADD UNIQUE KEY `tahun` (`tahun`);

--
-- Indexes for table `tabungan_siswa2324`
--
ALTER TABLE `tabungan_siswa2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `tabungan_transaksi2324`
--
ALTER TABLE `tabungan_transaksi2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `tb_jenjang`
--
ALTER TABLE `tb_jenjang`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `tb_nama_bayar`
--
ALTER TABLE `tb_nama_bayar`
  ADD PRIMARY KEY (`no`),
  ADD UNIQUE KEY `id` (`id`);

--
-- Indexes for table `tb_paralel`
--
ALTER TABLE `tb_paralel`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `tb_periode`
--
ALTER TABLE `tb_periode`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `tb_rekening`
--
ALTER TABLE `tb_rekening`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `tb_siswa2324`
--
ALTER TABLE `tb_siswa2324`
  ADD PRIMARY KEY (`no`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `tb_siswa_kategori`
--
ALTER TABLE `tb_siswa_kategori`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `tb_siswa_min2324`
--
ALTER TABLE `tb_siswa_min2324`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `tb_tingkat`
--
ALTER TABLE `tb_tingkat`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `tb_tp`
--
ALTER TABLE `tb_tp`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `tb_walikelas`
--
ALTER TABLE `tb_walikelas`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `tutorial`
--
ALTER TABLE `tutorial`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`no`);

--
-- Indexes for table `user_siswa`
--
ALTER TABLE `user_siswa`
  ADD PRIMARY KEY (`no`),
  ADD UNIQUE KEY `nip_2` (`nis`),
  ADD KEY `nip` (`nis`);

--
-- Indexes for table `whatsapp`
--
ALTER TABLE `whatsapp`
  ADD PRIMARY KEY (`no`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `billing`
--
ALTER TABLE `billing`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `db_setor2324`
--
ALTER TABLE `db_setor2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `db_transaksi2324`
--
ALTER TABLE `db_transaksi2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deleted`
--
ALTER TABLE `deleted`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deleted_tabungan`
--
ALTER TABLE `deleted_tabungan`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `deleted_transaksi`
--
ALTER TABLE `deleted_transaksi`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log`
--
ALTER TABLE `log`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `mailer`
--
ALTER TABLE `mailer`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `payment_list2324`
--
ALTER TABLE `payment_list2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_list_detail`
--
ALTER TABLE `payment_list_detail`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_set`
--
ALTER TABLE `payment_set`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `payment_temp`
--
ALTER TABLE `payment_temp`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sekolah`
--
ALTER TABLE `sekolah`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `serial`
--
ALTER TABLE `serial`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `simakom_akun2324`
--
ALTER TABLE `simakom_akun2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=207;

--
-- AUTO_INCREMENT for table `simakom_detail2324`
--
ALTER TABLE `simakom_detail2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=555;

--
-- AUTO_INCREMENT for table `simakom_jurnal2324`
--
ALTER TABLE `simakom_jurnal2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `simakom_kegiatan2324`
--
ALTER TABLE `simakom_kegiatan2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `simakom_komponen2324`
--
ALTER TABLE `simakom_komponen2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=103;

--
-- AUTO_INCREMENT for table `simakom_ref_akun`
--
ALTER TABLE `simakom_ref_akun`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `simakom_ref_jenisbelanja`
--
ALTER TABLE `simakom_ref_jenisbelanja`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `simakom_ref_kategori`
--
ALTER TABLE `simakom_ref_kategori`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `simakom_ref_kegiatan`
--
ALTER TABLE `simakom_ref_kegiatan`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=126;

--
-- AUTO_INCREMENT for table `simakom_revisi2324`
--
ALTER TABLE `simakom_revisi2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `simakom_transaksi2324`
--
ALTER TABLE `simakom_transaksi2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=196;

--
-- AUTO_INCREMENT for table `tabungan_periode`
--
ALTER TABLE `tabungan_periode`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `tabungan_siswa2324`
--
ALTER TABLE `tabungan_siswa2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tabungan_transaksi2324`
--
ALTER TABLE `tabungan_transaksi2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tb_jenjang`
--
ALTER TABLE `tb_jenjang`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tb_nama_bayar`
--
ALTER TABLE `tb_nama_bayar`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;

--
-- AUTO_INCREMENT for table `tb_paralel`
--
ALTER TABLE `tb_paralel`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `tb_periode`
--
ALTER TABLE `tb_periode`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `tb_rekening`
--
ALTER TABLE `tb_rekening`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `tb_siswa2324`
--
ALTER TABLE `tb_siswa2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tb_siswa_kategori`
--
ALTER TABLE `tb_siswa_kategori`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tb_siswa_min2324`
--
ALTER TABLE `tb_siswa_min2324`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tb_tingkat`
--
ALTER TABLE `tb_tingkat`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tb_tp`
--
ALTER TABLE `tb_tp`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `tb_walikelas`
--
ALTER TABLE `tb_walikelas`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tutorial`
--
ALTER TABLE `tutorial`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `user_siswa`
--
ALTER TABLE `user_siswa`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `whatsapp`
--
ALTER TABLE `whatsapp`
  MODIFY `no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;