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-20261014-0001','1','E1E-ZJXH-147-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZJXH-147-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJXH-147-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-14 07:46:16' WHERE kode_barang='E1E-ZJXH-147-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJXH-147-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 ('2026-10-14 07:46:16','TOKO','PM-E','E1E','E1E-ZJXH-147-0','1','0.500','0.500','1','0.500','0.500','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZJXH-147-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJXH-147-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261014-0001','2026-10-14','07:46','0.500','admpindah','2026-10-14 07:46:16'); 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,status_otorisasi,harga_skrg) VALUES ('F326140916001','input','1',' MEF3 X LT ','TOKO','PM-F','F3E-ZJXG-202-0','GL X RANTAI HOLLOW P3 SLEP LT 8K ','','2.020','1','100.00','2107000','0','0','15000','2108000','0','0','0','2108000','FIT','00428444','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJXG-202-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='F3E-ZJXG-202-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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) VALUES ('F326140916001','2026-10-14','2.020','2026-10-14','09:16:00','PLG0031861','2108000','2108000','0','2108000','2108000','input','2026-10-14 09:16:00','F32614091600'); 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-10-14','F326140916001','2026-10-14','09:16:00','FIT','2108000','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-261014-0002','D','2026-10-14','09:16:00','input','PENJUALAN','F326140916001','7852073000','2108000','7854181000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2108000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140916001' 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,status_otorisasi,harga_skrg) VALUES ('F326140916002','input',' 1',' MDE2 X CM ','TOKO','PM-E','E2D-ZHBF-267-0','CC X WEDDING MATA SLEP CM 18 8K ','','0.920','1','100.00','941000','0','0','15000','942000','0','0','0','942000','FIT','00420639','E2D','0','0','-','0','1023000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHBF-267-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='E2D-ZHBF-267-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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) VALUES ('F326140916002','2026-10-14','0.920','2026-10-14','09:16:00','PLG0031862','942000','942000','0','942000','942000','input','2026-10-14 09:16:00','F32614091600'); 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-10-14','F326140916002','2026-10-14','09:16:00','FIT','942000','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-261014-0003','D','2026-10-14','09:16:00','input','PENJUALAN','F326140916002','7854181000','942000','7855123000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='942000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140916002' 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,status_otorisasi,harga_skrg) VALUES ('F326140941041','input','1',' MED1 HW ','TOKO','PM-D','D1E-ZIBB-94-0','LT MODEL BUNGA CLOVER SLEP HW 8K ','','0.500','1','100.00','521000','0','0','15000','523000','0','0','0','523000','FIT','00425102','D1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZIBB-94-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='D1E-ZIBB-94-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' 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) VALUES ('F326140941041','2026-10-14','0.500','2026-10-14','09:41:05','PLG0031863','523000','523000','0','523000','523000','input','2026-10-14 09:41:04','F32614094104'); 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-10-14','F326140941041','2026-10-14','09:41:05','FIT','523000','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-261014-0004','D','2026-10-14','09:41:05','input','PENJUALAN','F326140941041','7855123000','523000','7855646000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='523000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140941041' 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,status_otorisasi,harga_skrg) VALUES ('F326140941042','input',' 1',' MEH1 X UB ','TOKO','PM-H','H1E-ZIXI-196-0','KL X GUCCI UB 44 8K ','','1.980','1','100.00','2065000','0','0','15000','2065000','0','0','0','2065000','FIT','00422734','H1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIXI-196-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='H1E-ZIXI-196-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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) VALUES ('F326140941042','2026-10-14','1.980','2026-10-14','09:41:05','PLG0031864','2065000','2065000','0','2065000','2065000','input','2026-10-14 09:41:04','F32614094104'); 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-10-14','F326140941042','2026-10-14','09:41:05','FIT','2065000','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-261014-0005','D','2026-10-14','09:41:05','input','PENJUALAN','F326140941042','7855646000','2065000','7857711000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2065000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140941042' 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,status_otorisasi,harga_skrg) VALUES ('F326140948111','input','1',' MEE1 LG 10','TOKO','PM-E','E1E-ZGXA-340-0','CC MODEL ISYANA SLEP LG 10 8K ','','0.470','1','100.00','490000','0','0','15000','490000','0','0','0','490000','FIT','00411864','E1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-340-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='E1E-ZGXA-340-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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) VALUES ('F326140948111','2026-10-14','0.470','2026-10-14','09:48:11','PLG0031865','490000','490000','0','490000','490000','input','2026-10-14 09:48:11','F32614094811'); 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-10-14','F326140948111','2026-10-14','09:48:11','FIT','490000','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-261014-0006','D','2026-10-14','09:48:11','input','PENJUALAN','F326140948111','7857711000','490000','7858201000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='490000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140948111' 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,status_otorisasi,harga_skrg) VALUES ('F326140948112','input',' 1',' MEE2 KH 12','TOKO','PM-E','E2E-ZIXI-82-0','CC MODEL SNAKE MATA VAR KH 12 8K ','','0.500','1','100.00','521000','0','0','15000','523000','0','0','0','523000','FIT','00422620','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZIXI-82-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='E2E-ZIXI-82-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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) VALUES ('F326140948112','2026-10-14','0.500','2026-10-14','09:48:11','PLG0031866','523000','523000','0','523000','523000','input','2026-10-14 09:48:11','F32614094811'); 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-10-14','F326140948112','2026-10-14','09:48:11','FIT','523000','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-261014-0007','D','2026-10-14','09:48:11','input','PENJUALAN','F326140948112','7858201000','523000','7858724000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='523000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140948112' 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,status_otorisasi,harga_skrg) VALUES ('F326141018581','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZIBE-120-0','GL X TIFF ARESO VAR HW 8K ','','1.970','1','100.00','2055000','0','0','15000','2055000','0','0','0','2055000','SIN','00425495','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBE-120-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='F3E-ZIBE-120-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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) VALUES ('F326141018581','2026-10-14','1.970','2026-10-14','10:18:59','PLG0031867','2055000','2055000','0','2055000','2055000','input','2026-10-14 10:18:58','F32614101858'); 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-10-14','F326141018581','2026-10-14','10:18:59','SIN','2055000','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-261014-0008','D','2026-10-14','10:18:59','input','PENJUALAN','F326141018581','7858724000','2055000','7860779000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2055000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141018581' 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,status_otorisasi,harga_skrg) VALUES ('F326141018582','input',' 1',' MDE2 X CM ','TOKO','PM-E','E2D-ZIBF-38-0','CC X MODEL MATA CM 12 8K ','','0.950','1','100.00','972000','0','0','15000','972000','0','0','0','972000','SIN','00425656','E2D','0','0','-','0','1023000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIBF-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='E2D-ZIBF-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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) VALUES ('F326141018582','2026-10-14','0.950','2026-10-14','10:18:59','PLG0031868','972000','972000','0','972000','972000','input','2026-10-14 10:18:58','F32614101858'); 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-10-14','F326141018582','2026-10-14','10:18:59','SIN','972000','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-261014-0009','D','2026-10-14','10:18:59','input','PENJUALAN','F326141018582','7860779000','972000','7861751000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='972000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141018582' 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,status_otorisasi,harga_skrg) VALUES ('F326141035331','input','1',' MEF2 X PM ','TOKO','PM-F','F2E-ZBBE-62-0','GL X PIPA ANAK MATA PM 40 8K ','','2.000','1','100.00','2086000','0','0','15000','2085000','0','0','0','2085000','AAT','00391208','F2E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZBBE-62-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-10-14' AND kode_barang='F2E-ZBBE-62-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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) VALUES ('F326141035331','2026-10-14','2.000','2026-10-14','10:35:34','PLG0031869','2085000','2085000','0','2085000','2085000','input','2026-10-14 10:35:33','F32614103533'); 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-10-14','F326141035331','2026-10-14','10:35:34','AAT','2085000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261014-0010','D','2026-10-14','10:35:34','input','PENJUALAN','F326141035331','7861751000','2085000','7863836000'); 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,status_otorisasi,harga_skrg) VALUES ('F326141056451','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZHBE-26-0','KL X MILANO PANJANG UB 64 9K','','6.770','1','100.00','7738000','0','0','15000','7738000','0','0','0','7738000','SIN','00420068','H2J','0','0','-','0','1143000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZHBE-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.770',berat_jual_asli=berat_jual_asli+'6.770',stock_jual='1',berat_akhir=berat_akhir-'6.770',berat_akhir_asli=berat_akhir_asli-'6.770',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='H2J-ZHBE-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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) VALUES ('F326141056451','2026-10-14','6.770','2026-10-14','10:56:45','PLG0031870','7738000','7738000','0','7738000','7738000','input','2026-10-14 10:56:45','F32614105645'); 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-10-14','F326141056451','2026-10-14','10:56:45','SIN','7738000','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-261014-0011','D','2026-10-14','10:56:45','input','PENJUALAN','F326141056451','7863836000','7738000','7871574000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='7738000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141056451' 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,status_otorisasi,harga_skrg) VALUES ('F326141056452','input',' 1',' MGD1G 7K B','TOKO','PM-D','D1G-ZJXC-338-0','LT MODEL IKAN SLEP BG 8K ','','1.310','1','100.00','1419000','0','0','15000','1419000','0','7000','0','1426000','SIN','00427485','D1G','0','0','-','0','1083000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZJXC-338-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.310',berat_jual_asli=berat_jual_asli+'1.310',stock_jual='1',berat_akhir=berat_akhir-'1.310',berat_akhir_asli=berat_akhir_asli-'1.310',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='D1G-ZJXC-338-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' 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) VALUES ('F326141056452','2026-10-14','1.310','2026-10-14','10:56:45','PLG0031871','1419000','1419000','7000','1426000','1426000','input','2026-10-14 10:56:45','F32614105645'); 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-10-14','F326141056452','2026-10-14','10:56:45','SIN','1426000','7000'); 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-261014-0012','D','2026-10-14','10:56:45','input','PENJUALAN','F326141056452','7871574000','1426000','7873000000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1426000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141056452' 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,status_otorisasi,harga_skrg) VALUES ('F326141056453','input',' 1',' MEF3E HW ','TOKO','PM-F','F3E-ZIBH-414-0','GL HARLEY SLEP MT 8K ','','4.260','1','100.00','4443000','0','0','15000','4443000','0','0','0','4443000','SIN','00426393','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBH-414-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.260',berat_jual_asli=berat_jual_asli+'4.260',stock_jual='1',berat_akhir=berat_akhir-'4.260',berat_akhir_asli=berat_akhir_asli-'4.260',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='F3E-ZIBH-414-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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) VALUES ('F326141056453','2026-10-14','4.260','2026-10-14','10:56:45','PLG0031872','4443000','4443000','0','4443000','4443000','input','2026-10-14 10:56:45','F32614105645'); 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-10-14','F326141056453','2026-10-14','10:56:45','SIN','4443000','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-261014-0013','D','2026-10-14','10:56:45','input','PENJUALAN','F326141056453','7873000000','4443000','7877443000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='4443000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326141056453' 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,status_otorisasi,harga_skrg) VALUES ('F326141209451','input','1',' MEE1 X BW ','TOKO','PM-E','E1E-ZIBA-454-0','CC X BANGKOK SLEP BW 16 8K ','','0.610','1','100.00','636000','0','0','15000','636000','0','0','0','636000','LIS','00424998','E1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIBA-454-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='E1E-ZIBA-454-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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) VALUES ('F326141209451','2026-10-14','0.610','2026-10-14','12:09:45','PLG0031873','636000','636000','0','636000','636000','input','2026-10-14 12:09:45','F32614120945'); 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-10-14','F326141209451','2026-10-14','12:09:45','LIS','636000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261014-0014','D','2026-10-14','12:09:45','input','PENJUALAN','F326141209451','7877443000','636000','7878079000'); 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,status_otorisasi,harga_skrg) VALUES ('F326141215441','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZIAI-221-0','CC X MODEL SPECTRA SLEP CM 16 8K ','','1.020','1','100.00','1043000','0','0','15000','1043000','0','0','0','1043000','SIN','00424443','E1D','0','0','-','0','1023000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZIAI-221-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='E1D-ZIAI-221-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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) VALUES ('F326141215441','2026-10-14','1.020','2026-10-14','12:15:44','PLG0031874','1043000','1043000','0','1043000','1043000','input','2026-10-14 12:15:44','F32614121544'); 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-10-14','F326141215441','2026-10-14','12:15:44','SIN','1043000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261014-0015','D','2026-10-14','12:15:44','input','PENJUALAN','F326141215441','7878079000','1043000','7879122000'); 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-00020525','X-00020525','KL X SANTA KH 46 9K','GR','---','H2I','BELI','BELI001','6332000','2026-10-14','6.010','1','kasir','2026-10-14 12:26:00'); DELETE FROM tp_barang WHERE kode_dept = 'X-H2I'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00020525','X-00020525'); 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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261014-0001','F326160300011','LIS','1','BELI','BELI001','H2I', 'X-00020525', 'KL X SANTA KH 46 9K','6.010','6.010','100.00','7314000','6332000','1053577','1123000','1','6332000','6332000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.010',berat_beli_asli=berat_beli_asli+'6.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.010',berat_akhir_asli=berat_akhir_asli+'6.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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) VALUES ('FB-261014-0001','2026-10-14','2026-10-14','12:25:59','LIS','---','6.010','6332000','6332000','6332000','6332000','6332000','kasir','2026-10-14 12:26:00','FB-261014-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261014-0001','CICI','BITING BADEGAN','','','','kasir','2026-10-14 12:26:00'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-14' ORDER BY right(no_ref,4) DESC LIMIT 1; 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-261014-0016','K','2026-10-14','12:25:59','kasir','PEMBELIAN UMUM','FB-261014-0001','7879122000','6332000','7872790000'); 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-00020526','X-00020526','GL X OSROT BONEKA ANAK CAT LG 8K','GR','---','F1E','BELI','BELI001','870000','2026-10-14','1.050','1','kasir','2026-10-14 12:26:00'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020526','X-00020526'); 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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261014-0002','F326111031202','LIS','2','BELI','BELI001','F1E', 'X-00020526', 'GL X OSROT BONEKA ANAK CAT LG 8K','1.050','1.050','100.00','1092000','870000','828571','1053000','1','870000','870000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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) VALUES ('FB-261014-0002','2026-10-14','2026-10-14','12:25:59','LIS','---','1.050','870000','870000','870000','870000','870000','kasir','2026-10-14 12:26:00','FB-261014-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261014-0002','CICI','BITING BADEGAN','','','','kasir','2026-10-14 12:26:00'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-14' ORDER BY right(no_ref,4) DESC LIMIT 1; 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-261014-0017','K','2026-10-14','12:25:59','kasir','PEMBELIAN UMUM','FB-261014-0002','7872790000','870000','7871920000'); 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-00020527','X-00020527','LT X MODEL BALERINA BG 8K','GR','---','D1F','BELI','BELI001','545000','2026-10-14','0.550','1','kasir','2026-10-14 12:26:00'); DELETE FROM tp_barang WHERE kode_dept = 'X-D1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00020527','X-00020527'); 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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261014-0003','F326111031203','LIS','3','BELI','BELI001','D1F', 'X-00020527', 'LT X MODEL BALERINA BG 8K','0.550','0.550','100.00','585000','545000','990909','1063000','1','545000','545000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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) VALUES ('FB-261014-0003','2026-10-14','2026-10-14','12:25:59','LIS','---','0.550','545000','545000','545000','545000','545000','kasir','2026-10-14 12:26:00','FB-261014-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261014-0003','CICI','BITING BADEGAN','','','','kasir','2026-10-14 12:26:00'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-14' ORDER BY right(no_ref,4) DESC LIMIT 1; 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-261014-0018','K','2026-10-14','12:25:59','kasir','PEMBELIAN UMUM','FB-261014-0003','7871920000','545000','7871375000'); 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-00020528','X-00020528','GL ANAK MODEL OSROT BONEKA CAT CM 8K','GR','---','F1E','BELI','BELI001','795000','2026-10-14','0.820','1','kasir','2026-10-14 12:26:00'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020528','X-00020528'); 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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261014-0004','F326190210473','LIS','4','BELI','BELI001','F1E', 'X-00020528', 'GL ANAK MODEL OSROT BONEKA CAT CM 8K','0.820','0.820','100.00','890000','795000','969512','1053000','1','795000','795000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.820',berat_beli_asli=berat_beli_asli+'0.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.820',berat_akhir_asli=berat_akhir_asli+'0.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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) VALUES ('FB-261014-0004','2026-10-14','2026-10-14','12:25:59','LIS','---','0.820','795000','795000','795000','795000','795000','kasir','2026-10-14 12:26:00','FB-261014-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261014-0004','CICI','BITING BADEGAN','','','085725611542','kasir','2026-10-14 12:26:00'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-14' ORDER BY right(no_ref,4) DESC LIMIT 1; 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-261014-0019','K','2026-10-14','12:25:59','kasir','PEMBELIAN UMUM','FB-261014-0004','7871375000','795000','7870580000'); 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-00020529','X-00020529','GL X KREPYAK DAUN SLEP PM 8K','GR','---','F3E','BELI','BELI001','3065000','2026-10-14','3.130','1','kasir','2026-10-14 12:26:24'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020529','X-00020529'); 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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261014-0005','F326230911191','LIS','1','BELI','BELI001','F3E', 'X-00020529', 'GL X KREPYAK DAUN SLEP PM 8K','3.130','3.130','100.00','3395000','3065000','979233','1053000','1','3065000','3065000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.130',berat_beli_asli=berat_beli_asli+'3.130',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.130',berat_akhir_asli=berat_akhir_asli+'3.130',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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) VALUES ('FB-261014-0005','2026-10-14','2026-10-14','12:26:24','LIS','---','3.130','3065000','3065000','3065000','3065000','3065000','kasir','2026-10-14 12:26:24','FB-261014-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261014-0005','ANING','BANDAR PACITAN','','','085328709394','kasir','2026-10-14 12:26:24'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-14' ORDER BY right(no_ref,4) DESC LIMIT 1; 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-261014-0020','K','2026-10-14','12:26:24','kasir','PEMBELIAN UMUM','FB-261014-0005','7870580000','3065000','7867515000'); 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-00020530','X-00020530','GL CAPELLA SPECTRA SLEP HW 8K','GR','---','F3E','BELI','BELI001','2025000','2026-10-14','2.290','1','kasir','2026-10-14 12:27:02'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020530','X-00020530'); 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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261014-0006','F326070956422','SIN','1','BELI','BELI001','F3E', 'X-00020530', 'GL CAPELLA SPECTRA SLEP HW 8K','2.290','2.290','100.00','2382000','2025000','884279','1053000','1','2025000','2025000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.290',berat_beli_asli=berat_beli_asli+'2.290',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.290',berat_akhir_asli=berat_akhir_asli+'2.290',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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) VALUES ('FB-261014-0006','2026-10-14','2026-10-14','12:27:02','SIN','---','2.290','2025000','2025000','2025000','2025000','2025000','kasir','2026-10-14 12:27:02','FB-261014-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261014-0006','TARISKA','POHIJO SAMPUNG','','','085728200325','kasir','2026-10-14 12:27:02'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-14' ORDER BY right(no_ref,4) DESC LIMIT 1; 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-261014-0021','K','2026-10-14','12:27:02','kasir','PEMBELIAN UMUM','FB-261014-0006','7867515000','2025000','7865490000'); 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-00020531','X-00020531','GL X CASTELI SLEP HW 8K','GR','---','F3E','BELI','BELI001','1437000','2026-10-14','1.570','1','kasir','2026-10-14 12:27:02'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020531','X-00020531'); 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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261014-0007','F326070956421','SIN','2','BELI','BELI001','F3E', 'X-00020531', 'GL X CASTELI SLEP HW 8K','1.570','1.570','100.00','1633000','1437000','915287','1053000','1','1437000','1437000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.570',berat_beli_asli=berat_beli_asli+'1.570',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.570',berat_akhir_asli=berat_akhir_asli+'1.570',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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) VALUES ('FB-261014-0007','2026-10-14','2026-10-14','12:27:02','SIN','---','1.570','1437000','1437000','1437000','1437000','1437000','kasir','2026-10-14 12:27:02','FB-261014-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261014-0007','TARISKA','POHIJO SAMPUNG','','','085728200325','kasir','2026-10-14 12:27:02'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-14' ORDER BY right(no_ref,4) DESC LIMIT 1; 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-261014-0022','K','2026-10-14','12:27:02','kasir','PEMBELIAN UMUM','FB-261014-0007','7865490000','1437000','7864053000'); 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,status_otorisasi,harga_skrg) VALUES ('F326140146391','kasir','1',' MFE1 KH 16','TOKO','PM-E','E1F-ZJXE-388-0','CC MODEL SPECTRA SLEP KH 16 8K ','','0.380','1','100.00','404000','0','0','15000','405000','0','0','0','405000','LIS','00427879','E1F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-388-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='E1F-ZJXE-388-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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) VALUES ('F326140146391','2026-10-14','0.380','2026-10-14','13:46:39','PLG0031875','405000','405000','0','405000','405000','kasir','2026-10-14 13:46:39','F32614014639'); 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-10-14','F326140146391','2026-10-14','13:46:39','LIS','405000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261014-0023','D','2026-10-14','13:46:39','kasir','PENJUALAN','F326140146391','7864053000','405000','7864458000'); 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,status_otorisasi,harga_skrg) VALUES ('F326140151271','kasir','1',' MEE1 KH 16','TOKO','PM-E','E1E-ZIXI-104-0','CC MODEL RING 3 SLEP KH 16 8K ','','0.510','1','100.00','532000','0','0','15000','532000','0','0','0','532000','SIN','00422642','E1E','0','0','-','0','1053000'); 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,status_otorisasi,harga_skrg) VALUES ('F326140152471','kasir','1',' MEE1 KH 16','TOKO','PM-E','E1E-ZIXI-104-0','CC MODEL RING 3 SLEP KH 16 8K ','','0.510','1','100.00','532000','0','0','15000','532000','0','0','0','532000','SIN','00422642','E1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIXI-104-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='E1E-ZIXI-104-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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) VALUES ('F326140152471','2026-10-14','0.510','2026-10-14','13:52:47','PLG0031877','532000','532000','0','532000','532000','kasir','2026-10-14 13:52:47','F32614015247'); 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-10-14','F326140152471','2026-10-14','13:52:47','SIN','532000','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-261014-0024','D','2026-10-14','13:52:47','kasir','PENJUALAN','F326140152471','7864458000','532000','7864990000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='532000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140152471' 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,status_otorisasi,harga_skrg) VALUES ('F326140152472','kasir',' 1',' MFE1 KH 18','TOKO','PM-E','E1F-ZJXE-385-0','CC MODEL SPECTRA SLEP KH 18 8K ','','0.380','1','100.00','404000','0','0','15000','404000','0','0','0','404000','SIN','00427876','E1F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-385-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='E1F-ZJXE-385-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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) VALUES ('F326140152472','2026-10-14','0.380','2026-10-14','13:52:47','PLG0031878','404000','404000','0','404000','404000','kasir','2026-10-14 13:52:47','F32614015247'); 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-10-14','F326140152472','2026-10-14','13:52:47','SIN','404000','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-261014-0025','D','2026-10-14','13:52:47','kasir','PENJUALAN','F326140152472','7864990000','404000','7865394000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='404000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326140152472' 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,status_otorisasi,harga_skrg) VALUES ('F326140207121','input','1',' MEF1 XX YT','TOKO','PM-F','F1E-ZIBF-8-0','GL XX OVAL C SLEP YT 52 8K ','','4.090','1','100.00','4266000','0','0','15000','4143000','0','0','0','4143000','LIS','00425626','F1E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIBF-8-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.090',berat_jual_asli=berat_jual_asli+'4.090',stock_jual='1',berat_akhir=berat_akhir-'4.090',berat_akhir_asli=berat_akhir_asli-'4.090',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='F1E-ZIBF-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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) VALUES ('F326140207121','2026-10-14','4.090','2026-10-14','14:07:13','PLG0031879','4143000','4143000','0','4143000','4143000','input','2026-10-14 14:07:12','F32614020712'); 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-10-14','F326140207121','2026-10-14','14:07:13','LIS','4143000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261014-0026','D','2026-10-14','14:07:13','input','PENJUALAN','F326140207121','7865394000','4143000','7869537000'); 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,status_otorisasi,harga_skrg) VALUES ('F326140240311','input','1',' MEH1 LG 42','TOKO','PM-H','H1E-ZJXB-334-0','KL TIFF PENITI MATA VAR SERUT LG 42 8K ','','2.870','1','100.00','2993000','0','0','15000','2993000','0','0','0','2993000','LIS','00427143','H1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJXB-334-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.870',berat_jual_asli=berat_jual_asli+'2.870',stock_jual='1',berat_akhir=berat_akhir-'2.870',berat_akhir_asli=berat_akhir_asli-'2.870',stock_akhir='0' WHERE tanggal='2026-10-14' AND kode_barang='H1E-ZJXB-334-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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) VALUES ('F326140240311','2026-10-14','2.870','2026-10-14','14:40:32','PLG0031880','2993000','2993000','0','2993000','2993000','input','2026-10-14 14:40:31','F32614024031'); 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-10-14','F326140240311','2026-10-14','14:40:32','LIS','2993000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261014-0027','D','2026-10-14','14:40:32','input','PENJUALAN','F326140240311','7869537000','2993000','7872530000'); 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-00020532','X-00020532','KL X GUCCI UB 44 9K','GR','---','H2J','BELI','BELI001','2183000','2026-10-14','2.050','1','kasir','2026-10-14 14:56:13'); DELETE FROM tp_barang WHERE kode_dept = 'X-H2J'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00020532','X-00020532'); 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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261014-0008','F326140210563','LIS','1','BELI','BELI001','H2J', 'X-00020532', 'KL X GUCCI UB 44 9K','2.050','2.050','100.00','2347000','2183000','1064878','1143000','1','2183000','2183000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.050',berat_beli_asli=berat_beli_asli+'2.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.050',berat_akhir_asli=berat_akhir_asli+'2.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' 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) VALUES ('FB-261014-0008','2026-10-14','2026-10-14','14:56:13','LIS','---','2.050','2183000','2183000','2183000','2183000','2183000','kasir','2026-10-14 14:56:13','FB-261014-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261014-0008','NURUL','NGANDONG KEPYAR','','','088220245260','kasir','2026-10-14 14:56:13'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-14' ORDER BY right(no_ref,4) DESC LIMIT 1; 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-261014-0028','K','2026-10-14','14:56:13','kasir','PEMBELIAN UMUM','FB-261014-0008','7872530000','2183000','7870347000'); 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-00020533','X-00020533','AT X HUGGIES KLIP MATA VAR LG 8K','GR','---','A1D','BELI','BELI001','1375000','2026-10-14','1.430','1','kasir','2026-10-14 14:57:08'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00020533','X-00020533'); 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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261014-0009','F326250208342','AAT','1','BELI','BELI001','A1D', 'X-00020533', 'AT X HUGGIES KLIP MATA VAR LG 8K','1.430','1.430','100.00','1480000','1375000','961538','1023000','1','1375000','1375000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.430',berat_beli_asli=berat_beli_asli+'1.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.430',berat_akhir_asli=berat_akhir_asli+'1.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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) VALUES ('FB-261014-0009','2026-10-14','2026-10-14','14:57:07','AAT','---','1.430','1375000','1375000','1375000','1375000','1375000','kasir','2026-10-14 14:57:08','FB-261014-0009'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261014-0009','VINA','TEGALREJO','','','','kasir','2026-10-14 14:57:08'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-14' ORDER BY right(no_ref,4) DESC LIMIT 1; 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-261014-0029','K','2026-10-14','14:57:07','kasir','PEMBELIAN UMUM','FB-261014-0009','7870347000','1375000','7868972000'); 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-00020534','X-00020534','CC COR T 8K','GR','---','E1E','BELI','BELI001','2195000','2026-10-14','2.950','1','kasir','2026-10-14 14:59:47'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020534','X-00020534'); 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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261014-0010','F323151245331','SIN','1','BELI','BELI001','E1E', 'X-00020534', 'CC COR T 8K','2.970','2.950','100.00','1450000','2195000','744068','1053000','1','2195000','2195000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.950',berat_beli_asli=berat_beli_asli+'2.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.950',berat_akhir_asli=berat_akhir_asli+'2.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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) VALUES ('FB-261014-0010','2026-10-14','2026-10-14','14:59:47','SIN','---','2.950','2195000','2195000','2195000','2195000','2195000','kasir','2026-10-14 14:59:47','FB-261014-0010'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261014-0010','ALI ALVI','NAWANGAN PCT','','','','kasir','2026-10-14 14:59:47'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-14' ORDER BY right(no_ref,4) DESC LIMIT 1; 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-261014-0030','K','2026-10-14','14:59:47','kasir','PEMBELIAN UMUM','FB-261014-0010','7868972000','2195000','7866777000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261014-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261014-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261014-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261014-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261014-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261014-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261014-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261014-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261014-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261014-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261014-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261014-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261014-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261014-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261014-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261014-0008'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261014-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261014-0009'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261014-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261014-0010'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140146391' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140146391' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140146391'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140152471' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140152471' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140152471'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140152472' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140152472' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140152472'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140207121' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140207121' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140207121'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140240311' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140240311' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140240311'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140916001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140916001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140916001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140916002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140916002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140916002'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140941041' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140941041' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140941041'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140941042' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140941042' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140941042'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140948111' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140948111' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140948111'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326140948112' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326140948112' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326140948112'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141018581' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141018581' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141018581'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141018582' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141018582' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141018582'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141035331' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141035331' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141035331'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141056451' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141056451' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141056451'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141056452' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141056452' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141056452'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141056453' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141056453' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141056453'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141209451' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141209451' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141209451'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326141215441' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326141215441' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326141215441'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-15','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-14'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-14'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-14'; 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-10-14' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-14'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-14'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-14'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-14'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-15' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-14' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261015-0001','D','2026-10-15','15:28:49','SYSTEM','SALDO AWAL','SALDO AWAL','0','7866777000','7866777000'); 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-261015-0001','D','2026-10-15','15:28:49','DLL','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-261015-0001','D','2026-10-15','15:28:49','BRI','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-261015-0001','D','2026-10-15','15:28:49','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000'); UPDATE tp_system SET tgl_system='2026-10-15';