/* Navicat Premium Dump SQL Source Server : MysqlLocal Source Server Type : MySQL Source Server Version : 80403 (8.4.3) Source Host : localhost:3306 Source Schema : tambak_asli Target Server Type : MySQL Target Server Version : 80403 (8.4.3) File Encoding : 65001 Date: 12/04/2026 19:43:52 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for taktivitas -- ---------------------------- DROP TABLE IF EXISTS `taktivitas`; CREATE TABLE `taktivitas` ( `NO_BUKTI` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TANGGAL` datetime NULL DEFAULT NULL, `KOLAM` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `QTY` double NULL DEFAULT NULL, `SIZE` double NULL DEFAULT NULL, `GRADE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `HARGA` double NULL DEFAULT NULL, `CUSTOMER` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `JENIS` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `KETERANGAN` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `NO_POLISI` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `SUPIR` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `JAM` datetime NULL DEFAULT NULL, `PEMBUAT` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `SATUAN` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TOTAL` double NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of taktivitas -- ---------------------------- INSERT INTO `taktivitas` VALUES ('HT2505002', '2025-05-22 00:00:00', 'B06', 487.5, 72.6, 'FS', 60700, 'HA69', 'PARTIAL', NULL, NULL, NULL, '1899-12-30 10:23:00', 'ALIONG', 'KG', 29591250); INSERT INTO `taktivitas` VALUES ('HT2505002', '2025-05-22 00:00:00', 'B07', 306.66, 61.8, 'FS', 66100, 'HA69', 'PARTIAL', NULL, NULL, NULL, '1899-12-30 10:23:00', 'ALIONG', 'KG', 20270226); -- ---------------------------- -- Table structure for tbarang -- ---------------------------- DROP TABLE IF EXISTS `tbarang`; CREATE TABLE `tbarang` ( `KD_BARANG` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `KATEGORI` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `SATUAN` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `HARGA_BELI` double NULL DEFAULT NULL, `HARGA_JUAL` double NULL DEFAULT NULL, `SUPPLIER` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `KETERANGAN` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `AKTIF` tinyint(1) NULL DEFAULT NULL, `TGL_BUAT` datetime NULL DEFAULT NULL, `PEMBUAT` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TGL_AWAL` datetime NULL DEFAULT NULL, `STOK_AWAL` int NULL DEFAULT NULL, `TGL_EDIT` datetime NULL DEFAULT NULL, `PENGEDIT` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`KD_BARANG`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tbarang -- ---------------------------- INSERT INTO `tbarang` VALUES ('00100001', '011', '012', 65100, 0, 'S00001', 'SUPER LACTO BBJ', 1, '2025-04-22 00:00:00', 'FANI', NULL, 0, '2025-04-22 00:00:00', 'FANI'); INSERT INTO `tbarang` VALUES ('00100002', '011', '002', 34200, 0, 'S00001', 'GLORIPAN YEAST / RAGI BBJ', 1, '2025-04-22 00:00:00', 'FANI', NULL, 0, '2025-04-22 00:00:00', 'FANI'); -- ---------------------------- -- Table structure for tbayar_hutang -- ---------------------------- DROP TABLE IF EXISTS `tbayar_hutang`; CREATE TABLE `tbayar_hutang` ( `NO_BUKTI` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TANGGAL` datetime NULL DEFAULT NULL, `AKUN` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `SUPPLIER` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `NO_TRANS` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `JUMLAH` double NULL DEFAULT NULL, `RETUR` double NULL DEFAULT NULL, `BAYAR` double NULL DEFAULT NULL, `KETERANGAN` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TGL_BUAT` datetime NULL DEFAULT NULL, `PEMBUAT` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `JTH_TEMPO` datetime NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tbayar_hutang -- ---------------------------- INSERT INTO `tbayar_hutang` VALUES ('BYR/2503/0001', '2025-03-14 00:00:00', '10111', 'P00002', 'BB2503001', 92187864, 0, 88909920, 'BENUR', '2025-03-14 00:00:00', 'ALIONG', '2025-03-10 00:00:00'); INSERT INTO `tbayar_hutang` VALUES ('BYR/2503/0001', '2025-03-14 00:00:00', '10111', 'P00002', 'BB2503002', 87933600, 0, 87933600, 'BENUR', '2025-03-14 00:00:00', 'ALIONG', '2025-03-11 00:00:00'); -- ---------------------------- -- Table structure for tbayar_piutang -- ---------------------------- DROP TABLE IF EXISTS `tbayar_piutang`; CREATE TABLE `tbayar_piutang` ( `NO_BUKTI` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TANGGAL` datetime NULL DEFAULT NULL, `AKUN` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `CUSTOMER` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `NO_TRANS` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `JUMLAH` double NULL DEFAULT NULL, `RETUR` double NULL DEFAULT NULL, `BAYAR` double NULL DEFAULT NULL, `KETERANGAN` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TGL_BUAT` datetime NULL DEFAULT NULL, `PEMBUAT` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `JTH_TEMPO` datetime NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tbayar_piutang -- ---------------------------- INSERT INTO `tbayar_piutang` VALUES ('PIU/2506/0001', '2025-06-05 00:00:00', '10111', 'SC', 'HT2506001', 524460868, 0, 524460868, NULL, '2025-06-05 00:00:00', 'ALIONG', '2025-06-03 00:00:00'); INSERT INTO `tbayar_piutang` VALUES ('PIU/2506/0002', '2025-06-05 00:00:00', '10111', 'SC', 'HT2506002', 509690099.76, 0, 509690099.76, NULL, '2025-06-05 00:00:00', 'ALIONG', '2025-06-04 00:00:00'); -- ---------------------------- -- Table structure for tcek_air -- ---------------------------- DROP TABLE IF EXISTS `tcek_air`; CREATE TABLE `tcek_air` ( `TANGGAL` datetime NULL DEFAULT NULL, `PEMBUAT` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `JAM` datetime NULL DEFAULT NULL, `KOLAM` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `DOC` int NULL DEFAULT NULL, `JENIS` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `KETERANGAN` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `NILAI` double NULL DEFAULT NULL, `NO_BUKTI` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tcek_air -- ---------------------------- INSERT INTO `tcek_air` VALUES ('2025-03-10 00:00:00', 'HABIB', '1899-12-30 11:00:00', 'B01', 0, 'PH', NULL, 7.4, 'CEK/2503/0001'); INSERT INTO `tcek_air` VALUES ('2025-03-10 00:00:00', 'HABIB', '1899-12-30 11:00:15', 'B02', 0, 'PH', NULL, 7.4, 'CEK/2503/0001'); -- ---------------------------- -- Table structure for tclosing -- ---------------------------- DROP TABLE IF EXISTS `tclosing`; CREATE TABLE `tclosing` ( `TANGGAL` datetime NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tclosing -- ---------------------------- INSERT INTO `tclosing` VALUES ('2021-01-31 00:00:00'); -- ---------------------------- -- Table structure for tcustomer -- ---------------------------- DROP TABLE IF EXISTS `tcustomer`; CREATE TABLE `tcustomer` ( `KODE_CUST` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `NAMA` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TEMPO` tinyint NULL DEFAULT NULL, `ALAMAT` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TELP` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`KODE_CUST`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tcustomer -- ---------------------------- INSERT INTO `tcustomer` VALUES ('C01', 'CUSTOMER', 0, NULL, NULL); INSERT INTO `tcustomer` VALUES ('GL', 'PT. GLOBAL', 0, NULL, NULL); INSERT INTO `tcustomer` VALUES ('HA69', 'HA69', 0, 'LAMPUNG', NULL); INSERT INTO `tcustomer` VALUES ('PT. GLOBAL', NULL, 0, NULL, NULL); INSERT INTO `tcustomer` VALUES ('SC', 'BU NINIK', 0, NULL, NULL); INSERT INTO `tcustomer` VALUES ('TB', 'TAMBAK', 0, NULL, NULL); -- ---------------------------- -- Table structure for thak -- ---------------------------- DROP TABLE IF EXISTS `thak`; CREATE TABLE `thak` ( `NAMA` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `KD_MENU` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TAMBAH` tinyint NULL DEFAULT NULL, `EDIT` tinyint NULL DEFAULT NULL, `HAPUS` tinyint NULL DEFAULT NULL, `CETAK` tinyint NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of thak -- ---------------------------- -- ---------------------------- -- Table structure for tharga -- ---------------------------- DROP TABLE IF EXISTS `tharga`; CREATE TABLE `tharga` ( `NO_BUKTI` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `UKURAN` double NULL DEFAULT NULL, `HARGA` double NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tharga -- ---------------------------- INSERT INTO `tharga` VALUES ('HT2010005', 30, 93500); INSERT INTO `tharga` VALUES ('HT2010005', 40, 83500); -- ---------------------------- -- Table structure for tjenis_cek -- ---------------------------- DROP TABLE IF EXISTS `tjenis_cek`; CREATE TABLE `tjenis_cek` ( `JENIS` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `BATASBAWAH` double NULL DEFAULT NULL, `BATASATAS` double NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tjenis_cek -- ---------------------------- INSERT INTO `tjenis_cek` VALUES ('ALKALI', 80, 150); INSERT INTO `tjenis_cek` VALUES ('PH', 7.5, 8.5); INSERT INTO `tjenis_cek` VALUES ('MAGNESIUM', 1200, 1440); INSERT INTO `tjenis_cek` VALUES ('KALSIUM', 0, 320); INSERT INTO `tjenis_cek` VALUES ('DO', 6, 0); INSERT INTO `tjenis_cek` VALUES ('SALINITAS', 0, 0); INSERT INTO `tjenis_cek` VALUES ('NITRIT', 0, 0); INSERT INTO `tjenis_cek` VALUES ('KAPORIT', 0, 0); INSERT INTO `tjenis_cek` VALUES ('AMONIA', 0, 0); INSERT INTO `tjenis_cek` VALUES ('KECERAHAN', 0, 0); INSERT INTO `tjenis_cek` VALUES ('SUHU', 0, 0); -- ---------------------------- -- Table structure for tjurnal_umum -- ---------------------------- DROP TABLE IF EXISTS `tjurnal_umum`; CREATE TABLE `tjurnal_umum` ( `NO_BUKTI` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TANGGAL` datetime NULL DEFAULT NULL, `KETERANGAN` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `NO_PERK` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `DEBIT` double NULL DEFAULT NULL, `KREDIT` double NULL DEFAULT NULL, `PEMBUAT` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tjurnal_umum -- ---------------------------- INSERT INTO `tjurnal_umum` VALUES ('JRM/2503/0002', '2025-03-01 00:00:00', 'BELANJA DI TOKO ASUI', '60104', 1331000, 0, 'FANI'); INSERT INTO `tjurnal_umum` VALUES ('JRM/2503/0002', '2025-03-01 00:00:00', 'BELANJA DI TOKO ASUI', '20100', 0, 1331000, 'FANI'); -- ---------------------------- -- Table structure for tkategori -- ---------------------------- DROP TABLE IF EXISTS `tkategori`; CREATE TABLE `tkategori` ( `KATEGORI` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `KETERANGAN` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`KATEGORI`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tkategori -- ---------------------------- INSERT INTO `tkategori` VALUES ('001', 'OBAT UDANG'); INSERT INTO `tkategori` VALUES ('002', 'PAKAN'); INSERT INTO `tkategori` VALUES ('003', 'LAIN - LAIN'); INSERT INTO `tkategori` VALUES ('004', 'SAPROTAM'); INSERT INTO `tkategori` VALUES ('005', 'SPAREPART'); INSERT INTO `tkategori` VALUES ('006', 'ALAT TES AIR'); INSERT INTO `tkategori` VALUES ('007', 'FUEL FILTER'); INSERT INTO `tkategori` VALUES ('008', 'WATER FILTER'); INSERT INTO `tkategori` VALUES ('009', 'OIL FILTER'); INSERT INTO `tkategori` VALUES ('010', 'AIR FILTER'); INSERT INTO `tkategori` VALUES ('011', 'GUDANG OBAT'); INSERT INTO `tkategori` VALUES ('012', 'BB DIESEL'); INSERT INTO `tkategori` VALUES ('013', 'KINCIR'); INSERT INTO `tkategori` VALUES ('014', 'GUNAWAN'); INSERT INTO `tkategori` VALUES ('015', 'PERLENGKAPAN BUDIDAYA'); INSERT INTO `tkategori` VALUES ('016', 'LISTRIK'); -- ---------------------------- -- Table structure for tkolam -- ---------------------------- DROP TABLE IF EXISTS `tkolam`; CREATE TABLE `tkolam` ( `NOMOR` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `KETERANGAN` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `LUAS` double NULL DEFAULT NULL, `AKTIF` tinyint(1) NULL DEFAULT NULL, PRIMARY KEY (`NOMOR`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tkolam -- ---------------------------- INSERT INTO `tkolam` VALUES ('A01', NULL, 1700, 0); INSERT INTO `tkolam` VALUES ('A02', NULL, 2025, 0); INSERT INTO `tkolam` VALUES ('A03', NULL, 1280, 0); INSERT INTO `tkolam` VALUES ('A04', NULL, 1200, 0); INSERT INTO `tkolam` VALUES ('A05', NULL, 1280, 0); INSERT INTO `tkolam` VALUES ('A06', NULL, 1600, 0); INSERT INTO `tkolam` VALUES ('A07', NULL, 1300, 0); INSERT INTO `tkolam` VALUES ('A08', NULL, 2000, 0); INSERT INTO `tkolam` VALUES ('A09', NULL, 1900, 0); INSERT INTO `tkolam` VALUES ('A10', NULL, 1340, 0); INSERT INTO `tkolam` VALUES ('A11', NULL, 1340, 0); INSERT INTO `tkolam` VALUES ('A12', NULL, 1240, 0); INSERT INTO `tkolam` VALUES ('A13', NULL, 1880, 0); INSERT INTO `tkolam` VALUES ('A14', NULL, 1680, 0); INSERT INTO `tkolam` VALUES ('A15', NULL, 1500, 0); INSERT INTO `tkolam` VALUES ('B01', 'KOLAM BARU', 2400, 0); INSERT INTO `tkolam` VALUES ('B02', 'KOLAM BARU', 2500, 0); INSERT INTO `tkolam` VALUES ('B03', 'KOLAM BARU', 2500, 0); INSERT INTO `tkolam` VALUES ('B04', NULL, 1670, 0); INSERT INTO `tkolam` VALUES ('B05', NULL, 2050, 0); INSERT INTO `tkolam` VALUES ('B06', NULL, 2410, 0); INSERT INTO `tkolam` VALUES ('B07', NULL, 1950, 0); INSERT INTO `tkolam` VALUES ('B08', NULL, 910, 0); INSERT INTO `tkolam` VALUES ('B09', NULL, 1820, 1); INSERT INTO `tkolam` VALUES ('B10', NULL, 1470, 1); INSERT INTO `tkolam` VALUES ('B11', NULL, 1510, 1); INSERT INTO `tkolam` VALUES ('B12', NULL, 1410, 1); INSERT INTO `tkolam` VALUES ('B13', NULL, 1280, 1); INSERT INTO `tkolam` VALUES ('B14', NULL, 2480, 1); INSERT INTO `tkolam` VALUES ('B15', NULL, 2870, 1); INSERT INTO `tkolam` VALUES ('B16', NULL, 1800, 1); INSERT INTO `tkolam` VALUES ('TANDON1', 'TANDON1', 0, 0); INSERT INTO `tkolam` VALUES ('TANDON2', NULL, 0, 0); INSERT INTO `tkolam` VALUES ('TANDON3', NULL, 0, 0); INSERT INTO `tkolam` VALUES ('TANDON4', NULL, 0, 0); -- ---------------------------- -- Table structure for tledger -- ---------------------------- DROP TABLE IF EXISTS `tledger`; CREATE TABLE `tledger` ( `NO_PERK` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `NAMA` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `NORMAL` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `JENIS` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `GRUP` tinyint(1) NULL DEFAULT NULL, `KURS` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `KELOMPOK` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TAMPIL` tinyint(1) NULL DEFAULT NULL, PRIMARY KEY (`NO_PERK`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tledger -- ---------------------------- INSERT INTO `tledger` VALUES ('10101', 'KAS KECIL BANGKA', 'D', 'A', 0, 'IDR', 'AKTIVA LANCAR', 1); INSERT INTO `tledger` VALUES ('10111', 'BANK BCA SAHNA', 'D', 'A', 0, 'IDR', 'AKTIVA LANCAR', 1); INSERT INTO `tledger` VALUES ('10112', 'BANK BCA', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('10117', 'PIUTANG KARYAWAN', 'D', 'A', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('10118', 'PERSEDIAAN PAKAN', 'D', 'A', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('10119', 'PERSEDIAAN SAPROTAM', 'D', 'A', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('10120', 'PIUTANG', 'D', 'A', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('10202', 'TANAH', 'D', 'A', 0, 'IDR', 'AKTIVA TETAP / FIXED ASSET', 1); INSERT INTO `tledger` VALUES ('10301', 'KENDARAAN / MOBIL / MOTOR', 'D', 'A', 0, 'IDR', 'AKTIVA TETAP / FIXED ASSET', 1); INSERT INTO `tledger` VALUES ('10302', 'KENDARAAN ALAT BERAT', 'D', 'A', 0, 'IDR', 'AKTIVA TETAP / FIXED ASSET', 1); INSERT INTO `tledger` VALUES ('10401', 'MESIN & PERALATAN', 'D', 'A', 0, 'IDR', 'AKTIVA TETAP / FIXED ASSET', 1); INSERT INTO `tledger` VALUES ('10402', 'PERLENGKAPAN KANTOR', 'D', 'A', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('10403', 'PERLENGKAPAN VILLA', 'D', 'A', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('20100', 'HUTANG TOKO ASUI', 'K', 'A', 0, 'IDR', 'HUTANG / LIABILITY', 1); INSERT INTO `tledger` VALUES ('20101', 'HUTANG KE SUPPLIER', 'K', 'A', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('30100', 'MODAL', 'K', 'A', 0, 'IDR', 'MODAL / EQUITY', 1); INSERT INTO `tledger` VALUES ('30300', 'LABA BERJALAN', 'D', 'A', 0, 'IDR', 'MODAL / EQUITY', 1); INSERT INTO `tledger` VALUES ('30400', 'IKHTISAR LABA RUGI', 'D', 'A', 0, 'IDR', NULL, 0); INSERT INTO `tledger` VALUES ('60100', 'BEBAN GAJI BUDIDAYA', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60101', 'BEBAN MAKAN & TRANSPORT', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60102', 'BEBAN LISTRIK', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60103', 'BEBAN TIKET', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60104', 'BEBAN PERLENGKAPAN', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60105', 'BEBAN SUMBANGAN', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60106', 'BEBAN PERBAIKAN PERALATAN', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60107', 'BEBAN KENDARAAN', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60108', 'BEBAN PENGURUSAN DOKUMEN/PERIJINAN', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60109', 'BEBAN ADM BANK', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60110', 'BEBAN PAJAK BUNGA', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60111', 'BEBAN ANGKUTAN', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60112', 'BEBAN SOLAR ALAT BERAT', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60113', 'BEBAN PERBAIKAN BANGUNAN', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60114', 'BEBAN PEMELIHARAAN & PERBK KENDARAAN', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60115', 'BEBAN ONGKOS KIRIM', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60116', 'BEBAN SOLAR GENSET', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60117', 'BEBAN TELEPON/FAX/HP', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60118', 'BEBAN BENSIN', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60119', 'BEBAN HOTEL', 'D', 'B', 0, 'IDR', 'BIAYA / EXPENSE', 1); INSERT INTO `tledger` VALUES ('60120', 'BEBAN PEMBELIAN BIBIT', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60121', 'BEBAN PEMELIHARAAN KOLAM', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60122', 'BEBAN THR', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60123', 'BEBAN PAKAN', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60124', 'BEBAN OBAT / KIMIA UDANG', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60125', 'BEBAN PAJAK BUMI & BANGUNAN (PBB)', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60126', 'BEBAN BELANJA DAPUR', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60127', 'BEBAN SEWA KANTOR', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60128', 'BEBAN SAPROTAM', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60129', 'BEBAN BONUS / KOMISI', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60130', 'BEBAN GAJI UMUM', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60131', 'BEBAN LAB.', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60132', 'BEBAN PERJALANAN DINAS', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60133', 'BEBAN BENUR', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('60134', 'BEBAN INTERNET', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('70100', 'PENDAPATAN BUNGA BANK', 'K', 'P', 0, 'IDR', 'PENDAPATAN', 1); INSERT INTO `tledger` VALUES ('70101', 'PENJUALAN UDANG', 'K', 'P', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('70102', 'PENDAPATAN LAIN LAIN', 'K', 'P', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('70103', 'BEBAN PENGOBATAN KARYAWAN', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('70104', 'BIAYA BUDIDAYA', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('70105', 'BIAYA SEMBAHYANG', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('70106', 'BIAYA BUNGKUS/PACKING', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('70108', 'BIAYA ENTERTAINT', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('70109', 'PENDAPATAN DISKON', 'K', 'P', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('70110', 'BEBAN PINJAMAN KARYAWAN', 'D', 'B', 0, 'IDR', NULL, 1); INSERT INTO `tledger` VALUES ('99999', 'AKUN KOREKSI', 'D', 'A', 0, 'IDR', NULL, 0); -- ---------------------------- -- Table structure for tlokasi -- ---------------------------- DROP TABLE IF EXISTS `tlokasi`; CREATE TABLE `tlokasi` ( `LOKASI` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `KETERANGAN` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`LOKASI`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tlokasi -- ---------------------------- INSERT INTO `tlokasi` VALUES ('01', 'GUDANG'); -- ---------------------------- -- Table structure for tlpb -- ---------------------------- DROP TABLE IF EXISTS `tlpb`; CREATE TABLE `tlpb` ( `NO_LPB` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TANGGAL` datetime NULL DEFAULT NULL, `SUPPLIER` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `KD_BARANG` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `QTY` double NULL DEFAULT NULL, `HARGA` double NULL DEFAULT NULL, `LOKASI` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TOTAL` double NULL DEFAULT NULL, `KETERANGAN` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `PEMBUAT` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TEMPO` int NULL DEFAULT NULL, `NO_PO` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `KUNCI` tinyint(1) NULL DEFAULT NULL, `U_VERIFIKASI` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TGL_VERIFIKASI` datetime NULL DEFAULT NULL, `AKUN` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tlpb -- ---------------------------- INSERT INTO `tlpb` VALUES ('LPB/2503/0004', '2025-03-12 00:00:00', 'T00002', '00100005', 3000, 1800, '01', 5400000, NULL, 'FANI', 0, NULL, 0, NULL, NULL, NULL); INSERT INTO `tlpb` VALUES ('LPB/2502/0001', '2025-02-18 00:00:00', 'T00002', '00100005', 1000, 0, '01', 0, NULL, 'FANI', 0, NULL, 0, NULL, NULL, NULL); INSERT INTO `tlpb` VALUES ('LPB/2502/0001', '2025-02-18 00:00:00', 'T00002', '01100001', 2000, 0, '01', 0, NULL, 'FANI', 0, NULL, 0, NULL, NULL, NULL); INSERT INTO `tlpb` VALUES ('LPB/2504/0001', '2025-04-07 00:00:00', 'G00001', '00200002', 2000, 19600, '01', 39200000, NULL, 'FANI', 0, NULL, 0, NULL, NULL, NULL); -- ---------------------------- -- Table structure for tmati -- ---------------------------- DROP TABLE IF EXISTS `tmati`; CREATE TABLE `tmati` ( `NO_BUKTI` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TANGGAL` datetime NULL DEFAULT NULL, `KOLAM` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `DOC` double NULL DEFAULT NULL, `JUMLAH` double NULL DEFAULT NULL, `KETERANGAN` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `PEMBUAT` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tmati -- ---------------------------- INSERT INTO `tmati` VALUES ('MAT/2505/0002', '2025-05-02 00:00:00', 'B01', 53, 808, NULL, 'HABIB'); INSERT INTO `tmati` VALUES ('MAT/2505/0002', '2025-05-02 00:00:00', 'B02', 53, 239, NULL, 'HABIB'); INSERT INTO `tmati` VALUES ('MAT/2505/0002', '2025-05-02 00:00:00', 'B03', 53, 519, NULL, 'HABIB'); -- ---------------------------- -- Table structure for tmenu -- ---------------------------- DROP TABLE IF EXISTS `tmenu`; CREATE TABLE `tmenu` ( `KD_MENU` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `NAMA` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`KD_MENU`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tmenu -- ---------------------------- INSERT INTO `tmenu` VALUES ('A001', 'TOP PRODUK'); INSERT INTO `tmenu` VALUES ('A007', 'ANALISA BARANG TIDAK LAKU'); INSERT INTO `tmenu` VALUES ('A008', 'ANALISA HRG JUAL VS HRG BELI'); INSERT INTO `tmenu` VALUES ('F001', 'RETUR POS'); INSERT INTO `tmenu` VALUES ('M001', 'MASTER BARANG'); INSERT INTO `tmenu` VALUES ('M002', 'MASTER SUPPLIER'); INSERT INTO `tmenu` VALUES ('M003', 'MASTER LOKASI'); INSERT INTO `tmenu` VALUES ('M004', 'MASTER KATEGORI'); INSERT INTO `tmenu` VALUES ('M005', 'MASTER MEREK'); INSERT INTO `tmenu` VALUES ('M006', 'MASTER SATUAN'); INSERT INTO `tmenu` VALUES ('M007', 'MASTER MEMBER'); INSERT INTO `tmenu` VALUES ('M008', 'MASTER JENIS'); INSERT INTO `tmenu` VALUES ('M009', 'MASTER SUB KATEGORI'); INSERT INTO `tmenu` VALUES ('M010', 'MASTER CUSTOMER'); INSERT INTO `tmenu` VALUES ('M011', 'MASTER HADIAH'); INSERT INTO `tmenu` VALUES ('M012', 'MASTER EDC'); INSERT INTO `tmenu` VALUES ('M013', 'MASTER AKUN'); INSERT INTO `tmenu` VALUES ('R001', 'REKAP DISKON & HARGA'); INSERT INTO `tmenu` VALUES ('R002', 'REKAP PROSES POSTING'); INSERT INTO `tmenu` VALUES ('R003', 'REKAP STOK PER GUDANG'); INSERT INTO `tmenu` VALUES ('R004', 'REKAP KARTU HUTANG'); INSERT INTO `tmenu` VALUES ('R005', 'REKAP PENJUALAN'); INSERT INTO `tmenu` VALUES ('R006', 'REKAP PEMAKAIAN PAKAN'); INSERT INTO `tmenu` VALUES ('R007', 'REKAP LPB'); INSERT INTO `tmenu` VALUES ('R008', 'REKAP ROP'); INSERT INTO `tmenu` VALUES ('R009', 'REKAP KARTU PIUTANG'); INSERT INTO `tmenu` VALUES ('R010', 'LIST PENJUALAN TUNDA'); INSERT INTO `tmenu` VALUES ('R011', 'PRINT SO'); INSERT INTO `tmenu` VALUES ('R012', 'PERSEDIAAN BARANG'); INSERT INTO `tmenu` VALUES ('R013', 'REKAP TRANSAKSI STOK'); INSERT INTO `tmenu` VALUES ('R014', 'REKAP RETUR PEMBELIAN'); INSERT INTO `tmenu` VALUES ('R015', 'REKAP PEMBATALAN PENJUALAN'); INSERT INTO `tmenu` VALUES ('R016', 'REPORT PERUBAHAN HARGA'); INSERT INTO `tmenu` VALUES ('R017', 'REPORT PERUBAHAN NAMA'); INSERT INTO `tmenu` VALUES ('R018', 'REKAP HUTANG'); INSERT INTO `tmenu` VALUES ('R019', 'REKAP PIUTANG'); INSERT INTO `tmenu` VALUES ('R020', 'REKAP PENDAPATAN'); INSERT INTO `tmenu` VALUES ('R021', 'REKAP RETUR PENJUALAN'); INSERT INTO `tmenu` VALUES ('R022', 'REPORT BATAL ITEM PENJUALAN'); INSERT INTO `tmenu` VALUES ('R023', 'REPORT ITEM BARU'); INSERT INTO `tmenu` VALUES ('R024', 'REKAP PEMBAYARAN HUTANG'); INSERT INTO `tmenu` VALUES ('R025', 'REKAP REQUEST BARANG'); INSERT INTO `tmenu` VALUES ('R026', 'REKAP PENERIMAAN PIUTANG'); INSERT INTO `tmenu` VALUES ('R027', 'REKAP KOMPLAIN'); INSERT INTO `tmenu` VALUES ('R028', 'REKAP UBAH HARGA PERIODE'); INSERT INTO `tmenu` VALUES ('R029', 'REKAP PANEN'); INSERT INTO `tmenu` VALUES ('R030', 'REKAP AKUN'); INSERT INTO `tmenu` VALUES ('R033', 'LIST HAPUS TS'); INSERT INTO `tmenu` VALUES ('R034', 'REKAP PENJUALAN NOTA'); INSERT INTO `tmenu` VALUES ('T001', 'TRANSAKSI AKTIVITAS KOLAM'); INSERT INTO `tmenu` VALUES ('T002', 'TRANSAKSI LPB'); INSERT INTO `tmenu` VALUES ('T003', 'TRANSAKSI LPB VERIFIKASI'); INSERT INTO `tmenu` VALUES ('T004', 'TRANSAKSI PO'); INSERT INTO `tmenu` VALUES ('T005', 'TRANSAKSI STOK'); INSERT INTO `tmenu` VALUES ('T006', 'PEMBAYARAN HUTANG'); INSERT INTO `tmenu` VALUES ('T007', 'KOMPLAIN CUSTOMER'); INSERT INTO `tmenu` VALUES ('T008', 'PENERIMAAN PIUTANG'); INSERT INTO `tmenu` VALUES ('T009', 'INPUT PEMBIBITAN'); INSERT INTO `tmenu` VALUES ('T010', 'INPUT PANEN'); INSERT INTO `tmenu` VALUES ('T011', 'JURNAL UMUM'); INSERT INTO `tmenu` VALUES ('T012', 'RETUR BELI'); INSERT INTO `tmenu` VALUES ('T013', 'CEK BARCODE'); INSERT INTO `tmenu` VALUES ('T014', 'KONTROL PO PENDING'); INSERT INTO `tmenu` VALUES ('T015', 'CEK HARGA JUAL'); INSERT INTO `tmenu` VALUES ('T016', 'CEK PO PENDING'); INSERT INTO `tmenu` VALUES ('T017', 'CEK HARGA BELI'); INSERT INTO `tmenu` VALUES ('T018', 'PENJUALAN NOTA'); INSERT INTO `tmenu` VALUES ('T019', 'PERUBAHAN PRICELIST & MARGIN'); INSERT INTO `tmenu` VALUES ('T020', 'APPROVE PERUBAHAN PRICELIST'); INSERT INTO `tmenu` VALUES ('T021', 'POS PRINT LANGSUNG'); INSERT INTO `tmenu` VALUES ('T022', 'RETUR PENJUALAN'); INSERT INTO `tmenu` VALUES ('T023', 'STOCK OPNAME'); INSERT INTO `tmenu` VALUES ('T024', 'HASIL STOCK OPNAME'); INSERT INTO `tmenu` VALUES ('T025', 'INPUT DISKON'); INSERT INTO `tmenu` VALUES ('T026', 'APPROVE DISKON'); INSERT INTO `tmenu` VALUES ('T030', 'REQUEST PO'); INSERT INTO `tmenu` VALUES ('T031', 'TINDAK LANJUT REQ. PO'); INSERT INTO `tmenu` VALUES ('T032', 'PENERIMAAN PIUTANG'); INSERT INTO `tmenu` VALUES ('T033', 'CLOSING DATA'); INSERT INTO `tmenu` VALUES ('T034', 'CLOSING KASIR'); INSERT INTO `tmenu` VALUES ('T035', 'REQUEST BARCODE & PRICETAG'); INSERT INTO `tmenu` VALUES ('T036', 'CEK AIR'); INSERT INTO `tmenu` VALUES ('U001', 'SQL'); INSERT INTO `tmenu` VALUES ('U002', 'USER'); INSERT INTO `tmenu` VALUES ('U003', 'SETTING NOTA'); INSERT INTO `tmenu` VALUES ('Z001', 'VERIFIKASI PO'); INSERT INTO `tmenu` VALUES ('Z002', 'POTONGAN HARGA'); INSERT INTO `tmenu` VALUES ('Z003', 'BATAL ITEM PENJUALAN'); INSERT INTO `tmenu` VALUES ('Z004', 'UBAH QTY'); INSERT INTO `tmenu` VALUES ('Z005', 'AKTIFKAN BARANG'); INSERT INTO `tmenu` VALUES ('Z009', 'APPROVE PRICELIST & MARGIN'); INSERT INTO `tmenu` VALUES ('Z013', 'EDIT HARGA PARTAI'); INSERT INTO `tmenu` VALUES ('Z014', 'EDIT DISKON PARTAI'); INSERT INTO `tmenu` VALUES ('Z015', 'KELUAR POS'); INSERT INTO `tmenu` VALUES ('Z016', 'CARI BARANG POS'); INSERT INTO `tmenu` VALUES ('Z017', 'EDIT HARGA PO'); INSERT INTO `tmenu` VALUES ('Z019', 'HAPUS ITEM TS'); INSERT INTO `tmenu` VALUES ('Z020', 'APPROVE DISKON'); INSERT INTO `tmenu` VALUES ('Z021', 'APPROVE HADIAH'); -- ---------------------------- -- Table structure for tperusahaan -- ---------------------------- DROP TABLE IF EXISTS `tperusahaan`; CREATE TABLE `tperusahaan` ( `NAMA` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `NAMA1` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `ALAMAT` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TELP` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `EMAIL` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `WEBSITE` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tperusahaan -- ---------------------------- INSERT INTO `tperusahaan` VALUES ('TAMBAK', NULL, NULL, NULL, NULL, NULL); -- ---------------------------- -- Table structure for trlpb -- ---------------------------- DROP TABLE IF EXISTS `trlpb`; CREATE TABLE `trlpb` ( `NO_RLPB` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TANGGAL` datetime NULL DEFAULT NULL, `NO_LPB` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `KD_BARANG` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `QTY` double NULL DEFAULT NULL, `HARGA` double NULL DEFAULT NULL, `SUPPLIER` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TOTAL` double NULL DEFAULT NULL, `LOKASI` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of trlpb -- ---------------------------- -- ---------------------------- -- Table structure for tsampling -- ---------------------------- DROP TABLE IF EXISTS `tsampling`; CREATE TABLE `tsampling` ( `NO_BUKTI` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TANGGAL` datetime NULL DEFAULT NULL, `KOLAM` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `ABW` double NULL DEFAULT NULL, `UKURAN` double NULL DEFAULT NULL, `EKOR` double NULL DEFAULT NULL, `BERAT` double NULL DEFAULT NULL, `DOC` double NULL DEFAULT NULL, `PEMBUAT` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tsampling -- ---------------------------- INSERT INTO `tsampling` VALUES ('SAM/2504/0006', '2025-04-28 00:00:00', 'B13', 6.2972972972973, 158, 296, 1864, 49, 'HABIB'); INSERT INTO `tsampling` VALUES ('SAM/2504/0006', '2025-04-28 00:00:00', 'B14', 7.65925925925926, 130, 135, 1034, 49, 'HABIB'); -- ---------------------------- -- Table structure for tsatuan -- ---------------------------- DROP TABLE IF EXISTS `tsatuan`; CREATE TABLE `tsatuan` ( `SATUAN` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `KETERANGAN` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`SATUAN`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tsatuan -- ---------------------------- INSERT INTO `tsatuan` VALUES ('001', 'PCS'); INSERT INTO `tsatuan` VALUES ('002', 'BKS'); INSERT INTO `tsatuan` VALUES ('003', 'BTL'); INSERT INTO `tsatuan` VALUES ('004', 'BOX'); INSERT INTO `tsatuan` VALUES ('005', 'PACK'); INSERT INTO `tsatuan` VALUES ('006', 'PSG'); INSERT INTO `tsatuan` VALUES ('007', 'KLG'); INSERT INTO `tsatuan` VALUES ('008', 'TUBE'); INSERT INTO `tsatuan` VALUES ('009', 'KG'); INSERT INTO `tsatuan` VALUES ('010', 'GRAM'); INSERT INTO `tsatuan` VALUES ('011', 'ML'); INSERT INTO `tsatuan` VALUES ('012', 'LTR'); INSERT INTO `tsatuan` VALUES ('013', 'JERIGEN'); INSERT INTO `tsatuan` VALUES ('014', 'DRUM'); INSERT INTO `tsatuan` VALUES ('015', 'SAK'); INSERT INTO `tsatuan` VALUES ('016', 'SET'); INSERT INTO `tsatuan` VALUES ('017', 'MTR'); INSERT INTO `tsatuan` VALUES ('018', 'BTG'); INSERT INTO `tsatuan` VALUES ('019', 'ROLL'); -- ---------------------------- -- Table structure for tsupplier -- ---------------------------- DROP TABLE IF EXISTS `tsupplier`; CREATE TABLE `tsupplier` ( `SUPPLIER` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `NAMA` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `ALAMAT` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TEMPO` double NULL DEFAULT NULL, `KOTA` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TELP` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `REKENING` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `BANK` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `NAMA_REK` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `PPN` tinyint(1) NULL DEFAULT NULL, PRIMARY KEY (`SUPPLIER`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tsupplier -- ---------------------------- INSERT INTO `tsupplier` VALUES ('G00001', 'INDOMAKMUR', NULL, 90, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('G00002', 'GUNAWAN', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('L00001', 'LAMPUNG', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('P00001', 'PT BABEL', NULL, 0, NULL, NULL, NULL, 'BCA', '00', 0); INSERT INTO `tsupplier` VALUES ('P00002', 'PRIMA', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('P00003', 'PT VIP', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('P00004', 'PAK JAJA', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('P00005', 'PANCA BENUA', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('S00001', 'KANTOR', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('S00002', 'SARANA FILTER', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('S00003', 'STP', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('T00001', 'TOKO ASUI', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('T00002', 'TOKO TANI MAKMUR', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO `tsupplier` VALUES ('T00003', 'TAKESHU', NULL, 0, NULL, NULL, NULL, NULL, NULL, 0); -- ---------------------------- -- Table structure for tts -- ---------------------------- DROP TABLE IF EXISTS `tts`; CREATE TABLE `tts` ( `KD_TS` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `NAMA` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TIPE` varchar(510) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`KD_TS`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tts -- ---------------------------- INSERT INTO `tts` VALUES ('01', 'BONUS SUPPLIER', 'M'); INSERT INTO `tts` VALUES ('02', 'KOREKSI STOK OPNAME', 'MK'); INSERT INTO `tts` VALUES ('03', 'MUTASI GUDANG', 'P'); INSERT INTO `tts` VALUES ('04', 'PEMAKAIAN SENDIRI', 'K'); INSERT INTO `tts` VALUES ('05', 'PEMUSNAHAN BARANG', 'K'); INSERT INTO `tts` VALUES ('06', 'KOREKSI', 'MK'); INSERT INTO `tts` VALUES ('07', 'KIRIMAN GUDANG', 'M'); INSERT INTO `tts` VALUES ('08', 'PAKAN', 'K'); -- ---------------------------- -- Table structure for ttstok -- ---------------------------- DROP TABLE IF EXISTS `ttstok`; CREATE TABLE `ttstok` ( `NO_TS` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TANGGAL` datetime NULL DEFAULT NULL, `KD_TS` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TIPE_TS` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `ASAL` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `TUJUAN` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `KETERANGAN` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `KD_BARANG` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `QTY` double NULL DEFAULT NULL, `HARGA` double NULL DEFAULT NULL, `PEMBUAT` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `KOLAM` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ttstok -- ---------------------------- INSERT INTO `ttstok` VALUES ('TS/2503/0003', '2025-03-10 00:00:00', '06', 'M', '01', NULL, 'STOK AWAL', '00600007', 10, 0, 'FANI', NULL); INSERT INTO `ttstok` VALUES ('TS/2503/0003', '2025-03-10 00:00:00', '06', 'M', '01', NULL, 'STOK AWAL', '00600008', 40, 0, 'FANI', NULL); SET FOREIGN_KEY_CHECKS = 1;