INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-09 ','11:14:24');
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-260509-0001','kasir','1',' LMPE75-83%','TOKO','LMP','LMP-XIXF-12-0','LIONTIN MAS PUTIH ','','3.140','1','83.00','6450000','0','0','17500','6600000','0','0','0','6600000','FAISAL','00031132','LMP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LMP-XIXF-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.140',berat_jual_asli=berat_jual_asli+'3.140',stock_jual='1',berat_akhir=berat_akhir-'3.140',berat_akhir_asli=berat_akhir_asli-'3.140',stock_akhir='0' WHERE tanggal='2026-05-09' AND kode_barang='LMP-XIXF-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LMP' 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-260509-0001','2026-05-09','3.140','2026-05-09','11:58:58','PLG0028601','6600000','6600000','0','6600000','0','kasir','2026-05-09 11:58:58','FE-260509-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('2026-05-09','FE-260509-0001','2026-05-09','11:58:58','FAISAL','6600000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0001','2026-05-09','2026-05-09 11:58:58','PENJUALAN : FE-260509-0001','.','TBC','6600000','6600000','0');
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 ('KM-260509-0002','D','2026-05-09','11:58:58','TBC','PENJUALAN','FE-260509-0001','97061340185','6600000','97067940185','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='6600000' WHERE no_faktur_jual='FE-260509-0001' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260509-0001';
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-260509-0002','kasir','1',' LGM10-112%','TOKO','LM','LGM10-ZDBH-45-0','LM ANTAM 10 GR G76245322 ','','10.000','1','112.00','27441000','0','0','17500','28000000','0','0','0','28000000','ILU','00042861','LGM10','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LGM10-ZDBH-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.000',berat_jual_asli=berat_jual_asli+'10.000',stock_jual='1',berat_akhir=berat_akhir-'10.000',berat_akhir_asli=berat_akhir_asli-'10.000',stock_akhir='0' WHERE tanggal='2026-05-09' AND kode_barang='LGM10-ZDBH-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LM' 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-260509-0002','2026-05-09','10.000','2026-05-09','13:07:59','PLG0028602','28000000','28000000','0','28000000','0','kasir','2026-05-09 13:07:58','FE-260509-0002','','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('2026-05-09','FE-260509-0002','2026-05-09','13:07:59','ILU','28000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0002','2026-05-09','2026-05-09 13:07:58','PENJUALAN : FE-260509-0002','','TBC','28000000','28000000','0');
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 ('KM-260509-0003','D','2026-05-09','13:07:59','TBC','PENJUALAN','FE-260509-0002','97067940185','28000000','97095940185','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='28000000' WHERE no_faktur_jual='FE-260509-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260509-0002';
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-260509-0003','kasir','1',' CKBE-01176','TOKO','CKB','CKBE-YLXI-9-0','CINCIN KAWIN CKBE-01176 ','','1.960','1','75.00','4205000','220500','13','17500','6750000','0','0','0','6750000','BARY','00040397','CKBE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKBE-YLXI-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-05-09' AND kode_barang='CKBE-YLXI-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CKB' 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-260509-0003','2026-05-09','1.960','2026-05-09','13:12:55','PLG0028603','6750000','6750000','0','6750000','0','kasir','2026-05-09 13:12:54','FE-260509-0003','','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('2026-05-09','FE-260509-0003','2026-05-09','13:12:55','BARY','6750000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0003','2026-05-09','2026-05-09 13:12:54','PENJUALAN : FE-260509-0003','','TBC','6750000','6750000','0');
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 ('KM-260509-0004','D','2026-05-09','13:12:55','TBC','PENJUALAN BERLIAN','FE-260509-0003','97095940185','6750000','97102690185','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='6750000' WHERE no_faktur_jual='FE-260509-0003' 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-260509-0004','kasir',' 1',' 500K-245-1','TOKO','PERAK','CKPRE-ZDBH-63-0','CINCIN SILVER 925 ','','2.240','1','100.00','229000','0','0','17500','600000','0','0','0','600000','BARY','00042879','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZDBH-63-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2026-05-09' AND kode_barang='CKPRE-ZDBH-63-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-260509-0004','2026-05-09','2.240','2026-05-09','13:12:55','PLG0028604','600000','600000','0','600000','0','kasir','2026-05-09 13:12:54','FE-260509-0003','','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('2026-05-09','FE-260509-0004','2026-05-09','13:12:55','BARY','600000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0004','2026-05-09','2026-05-09 13:12:54','PENJUALAN : FE-260509-0004','','TBC','600000','600000','0');
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 ('KM-260509-0005','D','2026-05-09','13:12:55','TBC','PENJUALAN','FE-260509-0004','97102690185','600000','97103290185','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='7350000' WHERE no_faktur_jual='FE-260509-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260509-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260509-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-09 ','13:18:16');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08158','ASRI','1','CKBE01176 DAN SILVER','CWE JD NO 14 GRF HADI CROM PUTIH DOF AMPLAS DAN CWO JD NO 18 GRF ANIS CROM PUTIH DOF AMPLAS','4.200','1','100000','100000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0005','2026-05-09','2026-05-09 13:21:48','SERVICE : SV-08158','-','TBC','100000','100000','0');
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 ('KM-260509-0006','D','2026-05-09','13:21:48','TBC','SERVICE','SV-08158','97103290185','100000','97103390185','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','-');
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-08158','2026-05-09','2026-05-09','13:21:48','PLG0028605','kasir','2026-05-12','kasir','2026-05-09 13:21:48','4.200','0','0','0','100000','0','100000','100000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-09 ','13:22:16');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08159','FAISAL','1','CKBE00071 DAN PALADIUM 30 PERSEN','CWE PASANG MATA DIKUATIN LAGI YA CROM PUTIH GLOSI DAN CWO CROM ULANG PUTIH DOF AMPLAS','2.690','1','1250000','1250000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0006','2026-05-09','2026-05-09 14:47:07','SERVICE : SV-08159','-','TBC','1250000','1250000','0');
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 ('KM-260509-0007','D','2026-05-09','14:47:07','TBC','SERVICE','SV-08159','97103390185','1250000','97104640185','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','-');
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-08159','2026-05-09','2026-05-09','14:47:07','PLG0028606','kasir','2026-05-12','kasir','2026-05-09 14:47:07','2.690','0','0','0','1250000','0','1250000','1250000','0');
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-260509-0005','kasir','1',' CBRE-07013','TOKO','CBR','CBRE-ZCXB-81-0','CBRE-07013 GIA 6361087814 ','','2.010','1','83.00','14439000','9038000','516','17500','19600000','0','0','0','19600000','BARY','00042142','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZCXB-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-05-09' AND kode_barang='CBRE-ZCXB-81-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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-260509-0005','2026-05-09','2.010','2026-05-09','16:10:10','PLG0028607','19600000','19600000','0','19600000','0','kasir','2026-05-09 16:10:10','FE-260509-0005','','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('2026-05-09','FE-260509-0005','2026-05-09','16:10:10','BARY','19600000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0007','2026-05-09','2026-05-09 16:10:10','PENJUALAN : FE-260509-0005','','TBC','19600000','19600000','0');
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 ('KM-260509-0008','D','2026-05-09','16:10:10','TBC','PENJUALAN BERLIAN','FE-260509-0005','97104640185','19600000','97124240185','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='19600000' WHERE no_faktur_jual='FE-260509-0005' 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-260509-0006','kasir',' 1',' 700K-14-91','TOKO','PERAK','CKPRE-ZAAF-37-0','CINCIN SILVER 925 ','','4.240','1','100.00','433000','0','0','17500','800000','0','0','0','800000','BARY','00040974','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-ZAAF-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.240',berat_jual_asli=berat_jual_asli+'4.240',stock_jual='1',berat_akhir=berat_akhir-'4.240',berat_akhir_asli=berat_akhir_asli-'4.240',stock_akhir='0' WHERE tanggal='2026-05-09' AND kode_barang='CKPRE-ZAAF-37-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-260509-0006','2026-05-09','4.240','2026-05-09','16:10:10','PLG0028608','800000','800000','0','800000','0','kasir','2026-05-09 16:10:10','FE-260509-0005','','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('2026-05-09','FE-260509-0006','2026-05-09','16:10:10','BARY','800000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0008','2026-05-09','2026-05-09 16:10:10','PENJUALAN : FE-260509-0006','','TBC','800000','800000','0');
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 ('KM-260509-0009','D','2026-05-09','16:10:10','TBC','PENJUALAN','FE-260509-0006','97124240185','800000','97125040185','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='20400000' WHERE no_faktur_jual='FE-260509-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260509-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260509-0006';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08160','BARY','1','CBRE07013 DAN SILVER','CWEJD NO 11 GRF ANDY CROM PUTIH DAN CWO JD NO 19 GRF RANI CROM PUTIH DOF AMPLAS','6.250','1','100000','100000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0009','2026-05-09','2026-05-09 16:16:51','SERVICE : SV-08160','-','TBC','100000','100000','0');
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 ('KM-260509-0010','D','2026-05-09','16:16:51','TBC','SERVICE','SV-08160','97125040185','100000','97125140185','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','-');
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-08160','2026-05-09','2026-05-09','16:16:51','PLG0028609','kasir','2026-05-12','kasir','2026-05-09 16:16:51','6.250','0','0','0','100000','0','100000','100000','0');
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-260509-0007','kasir','1',' LGM2-120% ','TOKO','LM','LGM2-ZDCX-37-0','LM ANTAM 2 GR J76017121 ','','2.000','1','120.00','5880000','0','0','17500','6240000','0','0','0','6240000','NANA','00042994','LGM2','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LGM2-ZDCX-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-05-09' AND kode_barang='LGM2-ZDCX-37-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='LM' 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-260509-0007','2026-05-09','2.000','2026-05-09','17:57:43','PLG0028610','6240000','6240000','0','6240000','0','kasir','2026-05-09 17:57:42','FE-260509-0007','','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('2026-05-09','FE-260509-0007','2026-05-09','17:57:43','NANA','6240000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0010','2026-05-09','2026-05-09 17:57:42','PENJUALAN : FE-260509-0007','','TBC','6240000','6240000','0');
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 ('KM-260509-0011','D','2026-05-09','17:57:43','TBC','PENJUALAN','FE-260509-0007','97125140185','6240000','97131380185','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='6240000' WHERE no_faktur_jual='FE-260509-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260509-0007';
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03007','FAISAL','1','PLD','CINCIN NIKAH','','','2.000','','10.00','1','1200000','300000','0','800000','1400000','SIZE 16 GRF DWIRANGGA','MATA ZIRKON 10 BUTIR','CROM PUTIH MODEL SEPERTI CONTOH','0','100000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260509-0011','2026-05-09','2026-05-09 18:49:44','PESANAN : DP-03007','-','TBC','1000000','1000000');
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 ('KM-260509-0012','D','2026-05-09','18:49:44','TBC','PESANAN','DP-03007','97131380185','1000000','97132380185','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03007','2026-05-09','2026-05-09','18:49:44','PLG0028611','FAISAL','2026-05-30','kasir','2026-05-09 18:49:44','2.000','0','0','0','1000000','0','800000','1500000','1500000','500000');
INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-03008','FAISAL','1','PLD','CINCIN NIKAH','','','3.500','','10.00','1','1200000','300000','0','700000','1750000','SIZE 16 GRF DYAH AYU','CROM PUTIH DOF AMPLAS','MODEL SESUAI CONTOH','0','0','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-260509-0012','2026-05-09','2026-05-09 18:51:49','PESANAN : DP-03008','-','TBC','1000000','1000000');
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 ('KM-260509-0013','D','2026-05-09','18:51:49','TBC','PESANAN','DP-03008','97132380185','1000000','97133380185','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D');
INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-03008','2026-05-09','2026-05-09','18:51:49','PLG0028612','FAISAL','2026-05-30','kasir','2026-05-09 18:51:49','3.500','0','0','0','1000000','0','700000','1750000','1750000','750000');
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-260509-0008','kasir','1',' CBRE-01657','TOKO','CBR','CBRE-ZEXA-43-0','CINCIN CBRE-01657 ','','2.240','1','75.00','6407000','1708000','98','17500','9500000','0','0','0','9500000','NANA','00043065','CBRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-05-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CBRE-ZEXA-43-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.240',berat_jual_asli=berat_jual_asli+'2.240',stock_jual='1',berat_akhir=berat_akhir-'2.240',berat_akhir_asli=berat_akhir_asli-'2.240',stock_akhir='0' WHERE tanggal='2026-05-09' AND kode_barang='CBRE-ZEXA-43-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='CBR' 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-260509-0008','2026-05-09','2.240','2026-05-09','18:58:56','PLG0028613','9500000','9500000','0','9500000','0','kasir','2026-05-09 18:58:56','FE-260509-0008','','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('2026-05-09','FE-260509-0008','2026-05-09','18:58:56','NANA','9500000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0013','2026-05-09','2026-05-09 18:58:56','PENJUALAN : FE-260509-0008','','TBC','9500000','9500000','0');
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 ('KM-260509-0014','D','2026-05-09','18:58:56','TBC','PENJUALAN BERLIAN','FE-260509-0008','97133380185','9500000','97142880185','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='9500000' WHERE no_faktur_jual='FE-260509-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-260509-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-260509-0008';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-05-09 ','19:07:35');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-08161','NANA','1','CBRE01657','JD NO 10 GRF 10 10 2026 CROM KOMBINASI ROSEGOLD','2.240','1','100000','100000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260509-0014','2026-05-09','2026-05-09 19:09:38','SERVICE : SV-08161','-','TBC','100000','100000','0');
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 ('KM-260509-0015','D','2026-05-09','19:09:38','TBC','SERVICE','SV-08161','97142880185','100000','97142980185','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','-');
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-08161','2026-05-09','2026-05-09','19:09:38','PLG0028614','kasir','2026-05-12','kasir','2026-05-09 19:09:38','2.240','0','0','0','100000','0','100000','100000','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-10','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-09';
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='2026-05-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-09';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-09' 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-260510-0001','D','2026-05-10','20:14:00','TBC','SALDO AWAL','SALDO AWAL','0','97142980185','97142980185');
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-260510-0001','D','2026-05-10','20:14:00','SHO','SALDO AWAL','SALDO AWAL','0','2758505684','2758505684');
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-260510-0001','D','2026-05-10','20:14:00','BCD','SALDO AWAL','SALDO AWAL','0','15107821700','15107821700');
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-260510-0001','D','2026-05-10','20:14:00','TMR','SALDO AWAL','SALDO AWAL','0','8689183779','8689183779');
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-260510-0001','D','2026-05-10','20:14:00','BNI','SALDO AWAL','SALDO AWAL','0','84527900','84527900');
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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','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-260510-0001','D','2026-05-10','20:14:00','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250');
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-260510-0001','D','2026-05-10','20:14:00','','SALDO AWAL','SALDO AWAL','0','16885500','16885500');
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-260510-0001','D','2026-05-10','20:14:00','DPE','SALDO AWAL','SALDO AWAL','0','226012000','226012000');
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-260510-0001','D','2026-05-10','20:14:00','BCK','SALDO AWAL','SALDO AWAL','0','16557707978.088','16557707978.088');
UPDATE tp_system SET tgl_system='2026-05-10';