INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-17 ','08:36:59');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250917-0001','1','ABRE-YIAG-2-0','1','2.690','2.690','TOKO','ABRE','TOKO','ABR');
DELETE FROM tm_barang WHERE kode_barang='ABRE-YIAG-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='ABRE-YIAG-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRE-YIAG-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='ABRE-YIAG-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='ABR',tgl_last_beli='2025-09-17 08:37:11' WHERE kode_barang='ABRE-YIAG-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='ABRE-YIAG-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-17 08:37:11','TOKO','ABR','ABRE','ABRE-YIAG-2-0','1','2.690','2.690','1','2.690','2.690','83.00');
DELETE FROM tm_dept WHERE kode_dept='ABRE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='ABRE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='DM' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='DM' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='ABRE-YIAG-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='ABRE-YIAG-2-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-17' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250917-0001','2025-09-17','08:37','2.690','kasir','2025-09-17 08:37:10');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20250917-0002','1','PSGE-YIAG-1-0','1','2.150','2.150','TOKO','PSN','TOKO','PSN');
DELETE FROM tm_barang WHERE kode_barang='PSGE-YIAG-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGE-YIAG-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGE-YIAG-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGE-YIAG-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2025-09-17 08:37:31' WHERE kode_barang='PSGE-YIAG-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGE-YIAG-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-09-17 08:37:31','TOKO','PSN','PSGE','PSGE-YIAG-1-0','1','2.150','2.150','1','2.150','2.150','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGE-YIAG-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGE-YIAG-1-0';
UPDATE tt_beli_detail SET tgl_terima='2025-09-17' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20250917-0002','2025-09-17','08:37','2.150','kasir','2025-09-17 08:37:31');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-17 ','10:20:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-09-17 ','10:49:41');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00008710','X-00008710','CINCIN MAS PUTIH','GR','---','CMP','BELI','BELI001','2937500','2025-09-17','2.350','1','kasir','2025-09-17 16:24:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-CMP';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CMP','X-00008710','X-00008710');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-250917-0001','-','ASRI','1','BELI','BELI001','CMP', 'X-00008710', 'CINCIN MAS PUTIH','2.350','2.350','75.00','2499000','2937500','1250000','1','2937500','2937500','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.350',berat_beli_asli=berat_beli_asli+'2.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.350',berat_akhir_asli=berat_akhir_asli+'2.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CMP' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('BE-250917-0001','2025-09-17','2025-09-17','16:24:30','ASRI','---','2.350','2937500','2937500','2937500','2937500','2937500','kasir','2025-09-17 16:24:31','BE-250917-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-250917-0001','AZZAM SEPTIAN','JKT','','JKT','0','kasir','2025-09-17 16:24:31');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-250917-0001','2025-09-17','2025-09-17 16:24:31','PEMBELIAN UMUM : BE-250917-0001','.','TBC','2937500','2937500');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-250917-0002','K','2025-09-17','16:24:30','TBC','PEMBELIAN UMUM','BE-250917-0001','92110166720','2937500','92107229220','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-250917-0001','kasir','1',' CKSE-800K ','TOKO','CKS','CKSE-YHAE-87-0','CINCIN KAWIN SIRKON ELCO ','','2.250','1','83.00','3667000','0','0','16500','4690000','0','0','0','4690000','NANA','00038129','CKSE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKSE-YHAE-87-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2025-09-17' AND kode_barang='CKSE-YHAE-87-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CKS' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-250917-0001','2025-09-17','2.250','2025-09-17','18:22:41','PLG0026889','4690000','4690000','0','4690000','4690000','kasir','2025-09-17 18:22:41','FE-250917-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-17','FE-250917-0001','2025-09-17','18:22:41','NANA','4690000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250917-0002','D','2025-09-17','18:22:41','kasir','PENJUALAN','FE-250917-0001','2344050','4690000','7034050','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4690000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-250917-0001' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FE-250917-0002','kasir',' 1',' 700K-16-73','TOKO','PERAK','CKPRE-YFBC-3-0','CINCIN SILVER 925 ','','4.320','1','100.00','100000','0','0','16500','700000','0','0','0','700000','NANA','00036613','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-09-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-YFBC-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.320',berat_jual_asli=berat_jual_asli+'4.320',stock_jual='1',berat_akhir=berat_akhir-'4.320',berat_akhir_asli=berat_akhir_asli-'4.320',stock_akhir='0' WHERE tanggal='2025-09-17' AND kode_barang='CKPRE-YFBC-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FE-250917-0002','2025-09-17','4.320','2025-09-17','18:22:41','PLG0026890','700000','700000','0','700000','700000','kasir','2025-09-17 18:22:41','FE-250917-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-17','FE-250917-0002','2025-09-17','18:22:41','NANA','700000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-250917-0003','D','2025-09-17','18:22:41','kasir','PENJUALAN','FE-250917-0002','7034050','700000','7734050','OPEN');
UPDATE tt_jual_head SET dibayar_rp='700000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FE-250917-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-250917-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-250917-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-250917-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-250917-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-250917-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-250917-0002';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-07746','NANA','1','CKS DAN SILVER','CWE GRF DENIS CWO GRF REAVY','6.570','2','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-07746','2025-09-17','2025-09-17','18:26:39','PLG0026891','kasir','2025-09-18','kasir','2025-09-17 18:26:39','6.570','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-09-17 ','18:27:33');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250917-0004','K','2025-09-17','19:15:30','kasir','KAS BESAR','STOR REK NADA','7734050','5400000','2334050');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-250917-0005','K','2025-09-17','19:18:07','kasir','KIRIM PAKET','JNE SLEMAN ','2334050','22000','2312050');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-250917-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-250917-0001';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-18','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-18';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-17';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-17';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-09-17' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-17';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-17';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-17';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-17';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-18' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-17' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','TBC','SALDO AWAL','SALDO AWAL','0','92107229220','92107229220');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','BCK','SALDO AWAL','SALDO AWAL','0','15802684978.088','15802684978.088');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','DPE','SALDO AWAL','SALDO AWAL','0','285586800','285586800');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','KET','SALDO AWAL','SALDO AWAL','0','129319250','129319250');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','TMR','SALDO AWAL','SALDO AWAL','0','8166083779','8166083779');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','4000000','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','3450000','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','BCA','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','6000000','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','SHO','SALDO AWAL','SALDO AWAL','0','2741005684','2741005684');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','BCD','SALDO AWAL','SALDO AWAL','0','14828019700','14828019700');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-250918-0001','D','2025-09-18','20:07:46','','SALDO AWAL','SALDO AWAL','0','13818500','13818500');
UPDATE tp_system SET tgl_system='2025-09-18';