/*
 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;
