INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261029-0001','1','H1F-ZJBA-28-T','1','3.020','TOKO','BK-H'); DELETE FROM tm_barang_export WHERE kode_barang='H1F-ZJBA-28-T' LIMIT 1; INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1F-ZJBA-28-T' LIMIT 1; DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MF' LIMIT 1; INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MF' LIMIT 1; DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='H1F' LIMIT 1; INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1F' LIMIT 1; DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-H'; INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-H'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H1F-ZJBA-28-T'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.020',berat_out_asli='3.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.020',berat_akhir_asli =berat_akhir_asli-'3.020' WHERE kode_barang='H1F-ZJBA-28-T' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261029-0001','2','H1F-ZJBA-29-T','1','2.400','TOKO','BK-H'); DELETE FROM tm_barang_export WHERE kode_barang='H1F-ZJBA-29-T' LIMIT 1; INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1F-ZJBA-29-T' LIMIT 1; DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='MF' LIMIT 1; INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MF' LIMIT 1; DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='H1F' LIMIT 1; INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1F' LIMIT 1; DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-H'; INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-H'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H1F-ZJBA-29-T'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.400',berat_out_asli='2.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.400',berat_akhir_asli =berat_akhir_asli-'2.400' WHERE kode_barang='H1F-ZJBA-29-T' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-261029-0001','2026-10-29','2026-10-29','07:53','2.400','input','261029'); 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 ('F226290957281','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZJXE-15-T','LT MODEL HATI SLEP VAR LG 8K ','','0.750','1','100.00','776000','0','0','15000','776000','0','0','0','776000','NOV','T0085525','D1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZJXE-15-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='D1E-ZJXE-15-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290957281','2026-10-29','0.750','2026-10-29','09:57:28','PLG0088225','776000','776000','0','776000','0','kasir','2026-10-29 09:57:28','F22629095728'); 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-29','F226290957281','2026-10-29','09:57:28','NOV','776000','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-261029-0001','2026-10-29','2026-10-29 09:57:28','PENJUALAN : F226290957281','445787653','BCA','776000','776000','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-261029-0002','D','2026-10-29','09:57:28','BCA','PENJUALAN','F226290957281','4961526888','776000','4962302888','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('445787653','CAHYA'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='776000' WHERE no_faktur_jual='F226290957281' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('B1D-ZJBG-74-T','T0087040','T0087040','GW TUSUK MODEL PENITI HW PE 8K ','GW TUSUK MODEL PENITI HW PE 8K','','','863000','863000',' 0','0','input','2026-10-29 10:26:01'); UPDATE tm_barang SET nama_barang='GW TUSUK MODEL PENITI HW PE 8K' ,nama_atribut='' ,kode_intern='MDB1 HW PE ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='B1D-ZJBG-74-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('F1E-ZJBH-2-T','T0087070','T0087070','GL OVAL MODEL C KH D56 8K ','GL OVAL MODEL C KH D56 8K','','','5470500','5470500',' 0','0','input','2026-10-29 10:26:36'); UPDATE tm_barang SET nama_barang='GL OVAL MODEL C KH D56 8K' ,nama_atribut='' ,kode_intern='MEF1 KH D56 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='F1E-ZJBH-2-T' 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 ('F226291027471','kasir','1',' MDB1 HW PE','TOKO','SMBK-B','B1D-ZJBG-74-T','GW TUSUK MODEL PENITI HW PE 8K','OL','0.850','1','100.00','863000','0','0','15000','872000','0','5000','0','877000','TJ','T0087040','B1D','0','0','-','0','1015000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZJBG-74-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='B1D-ZJBG-74-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' 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 ('F226291027471','2026-10-29','0.850','2026-10-29','10:27:47','PLG0088226','872000','872000','5000','877000','877000','kasir','2026-10-29 10:27:47','F22629102747'); 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-29','F226291027471','2026-10-29','10:27:47','TJ','877000','5000'); 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-261029-0002','D','2026-10-29','10:27:47','kasir','PENJUALAN','F226291027471','18012911000','877000','18013788000'); 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 ('F226291029101','kasir','1',' MEF1 KH D5','TOKO','SMBK-F','F1E-ZJBH-2-T','GL OVAL MODEL C KH D56 8K','OL','5.260','1','100.00','5470000','0','0','15000','5471000','0','26000','0','5497000','TJ','T0087070','F1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZJBH-2-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.260',berat_jual_asli=berat_jual_asli+'5.260',stock_jual='1',berat_akhir=berat_akhir-'5.260',berat_akhir_asli=berat_akhir_asli-'5.260',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='F1E-ZJBH-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226291029101','2026-10-29','5.260','2026-10-29','10:29:11','PLG0000001','5471000','5471000','26000','5497000','5497000','kasir','2026-10-29 10:29:10','F22629102910'); 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-29','F226291029101','2026-10-29','10:29:11','TJ','5497000','26000'); 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-261029-0003','D','2026-10-29','10:29:11','kasir','PENJUALAN','F226291029101','18013788000','5497000','18019285000'); INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('F3E-ZJAG-2-T','T0086569','T0086569','GL TRIXIE SERUT BUNGA CLOVER VAR YT 8K ','GL TRIXIE SERUT BUNGA CLOVER VAR YT 8K','','','2391000','2391000',' 0','0','input','2026-10-29 11:11:52'); UPDATE tm_barang SET nama_barang='GL TRIXIE SERUT BUNGA CLOVER VAR YT 8K' ,nama_atribut='' ,kode_intern='MEF3 15K YT ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='F3E-ZJAG-2-T' 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 ('F226291113001','kasir','1',' MEF3 15K Y','TOKO','SMBK-F','F3E-ZJAG-2-T','GL TRIXIE SERUT BUNGA CLOVER VAR YT 8K','','2.310','1','100.00','2391000','0','0','15000','2391000','0','15000','0','2406000','HAN','T0086569','F3E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJAG-2-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.310',berat_jual_asli=berat_jual_asli+'2.310',stock_jual='1',berat_akhir=berat_akhir-'2.310',berat_akhir_asli=berat_akhir_asli-'2.310',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJAG-2-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226291113001','2026-10-29','2.310','2026-10-29','11:13:00','PLG0088227','2391000','2391000','15000','2406000','2406000','kasir','2026-10-29 11:13:00','F22629111300'); 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-29','F226291113001','2026-10-29','11:13:00','HAN','2406000','15000'); 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-261029-0004','D','2026-10-29','11:13:00','kasir','PENJUALAN','F226291113001','18019285000','2406000','18021691000'); 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 ('F226291153481','kasir','1',' TEF1 UB D6','TOKO','TBK-F','F1TE-ZIAG-90-T','GL OVAL MODEL C UB D62 17K ','OL','3.240','1','100.00','6156000','0','0','15000','6172000','0','16000','0','6188000','HAN','T0083993','F1TE','0','0','-','0','1900000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-ZIAG-90-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.240',berat_jual_asli=berat_jual_asli+'3.240',stock_jual='1',berat_akhir=berat_akhir-'3.240',berat_akhir_asli=berat_akhir_asli-'3.240',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='F1TE-ZIAG-90-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226291153481','2026-10-29','3.240','2026-10-29','11:53:48','PLG0088228','6172000','6172000','16000','6188000','0','kasir','2026-10-29 11:53:48','F22629115348'); 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-29','F226291153481','2026-10-29','11:53:48','HAN','6188000','16000'); 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-261029-0002','2026-10-29','2026-10-29 11:53:48','PENJUALAN : F226291153481','873783833283289','BCA','6188000','6188000','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-261029-0003','D','2026-10-29','11:53:48','BCA','PENJUALAN','F226291153481','4962302888','6188000','4968490888','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('873783833283289','ARIFATUL'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='6188000' WHERE no_faktur_jual='F226291153481' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('F3E-ZFBC-71-T','T0080680','T0080680','GL RANTAI HOLLOW SLEP HW 8K ','GL RANTAI HOLLOW SLEP HW 8K','','','1532000','1532000',' 0','0','input','2026-10-29 11:58:08'); UPDATE tm_barang SET nama_barang='GL RANTAI HOLLOW SLEP HW 8K' ,nama_atribut='' ,kode_intern='MEF3E HW ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='F3E-ZFBC-71-T' 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 ('F226291159281','kasir','1',' MEF3E HW ','TOKO','SMBK-F','F3E-ZFBC-71-T','GL RANTAI HOLLOW SLEP HW 8K','OL','1.480','1','100.00','1532000','0','0','15000','1540000','0','7000','0','1547000','HAN','T0080680','F3E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFBC-71-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZFBC-71-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226291159281','2026-10-29','1.480','2026-10-29','11:59:28','PLG0088229','1540000','1540000','7000','1547000','1547000','kasir','2026-10-29 11:59:28','F22629115928'); 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-29','F226291159281','2026-10-29','11:59:28','HAN','1547000','7000'); 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-261029-0005','D','2026-10-29','11:59:28','kasir','PENJUALAN','F226291159281','18021691000','1547000','18023238000'); 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 ('F226291232481','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZJXB-38-T','LT SLOBOK BULAT HURUF BG V 8K ','','0.600','1','100.00','633000','0','0','15000','633000','0','5000','0','638000','NOV','T0085101','D1F','0','0','-','0','1055000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZJXB-38-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='D1F-ZJXB-38-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226291232481','2026-10-29','0.600','2026-10-29','12:32:48','PLG0088230','633000','633000','5000','638000','638000','kasir','2026-10-29 12:32:48','F22629123248'); 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-29','F226291232481','2026-10-29','12:32:48','NOV','638000','5000'); 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-261029-0006','D','2026-10-29','12:32:48','kasir','PENJUALAN','F226291232481','18023238000','638000','18023876000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='638000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291232481' 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 ('F226291232482','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZGBD-107-T','LT SLOBOK NULAT HURUF BG V 8K ','','0.620','1','100.00','654000','0','0','15000','654000','0','5000','0','659000','NOV','T0081534','D1F','0','0','-','0','1055000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGBD-107-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='D1F-ZGBD-107-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226291232482','2026-10-29','0.620','2026-10-29','12:32:48','PLG0088231','654000','654000','5000','659000','659000','kasir','2026-10-29 12:32:48','F22629123248'); 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-29','F226291232482','2026-10-29','12:32:48','NOV','659000','5000'); 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-261029-0007','D','2026-10-29','12:32:48','kasir','PENJUALAN','F226291232482','18023876000','659000','18024535000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='659000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291232482' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1G-ZJXH-64-T','T0085931','T0085931','LT CHARM MODEL KUPU SLEP LG 8K ','LT CHARM MODEL KUPU SLEP LG 8K','','','322500','322500',' 0','0','input','2026-10-29 12:39:21'); UPDATE tm_barang SET nama_barang='LT CHARM MODEL KUPU SLEP LG 8K' ,nama_atribut='' ,kode_intern='MGD1 LG ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1G-ZJXH-64-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1G-ZJXH-65-T','T0085932','T0085932','LT CHARM MODEL KUPU SLEP LG 8K ','LT CHARM MODEL KUPU SLEP LG 8K','','','322500','322500',' 0','0','input','2026-10-29 12:39:49'); UPDATE tm_barang SET nama_barang='LT CHARM MODEL KUPU SLEP LG 8K' ,nama_atribut='' ,kode_intern='MGD1 LG ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1G-ZJXH-65-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1F-ZJXH-62-T','T0085929','T0085929','LT CHARM MODEL KUPU SLEP LG 8K ','LT CHARM MODEL KUPU SLEP LG 8K','','','316500','316500',' 0','0','input','2026-10-29 12:40:36'); UPDATE tm_barang SET nama_barang='LT CHARM MODEL KUPU SLEP LG 8K' ,nama_atribut='' ,kode_intern='MFD1 LG ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1F-ZJXH-62-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1E-ZJBG-95-T','T0087061','T0087061','LT CHARM BUNGA CLOVER SLEP YT 8K ','LT CHARM BUNGA CLOVER SLEP YT 8K','','','621000','621000',' 0','0','input','2026-10-29 12:43:02'); UPDATE tm_barang SET nama_barang='LT CHARM BUNGA CLOVER SLEP YT 8K' ,nama_atribut='' ,kode_intern='MED1 YT ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1E-ZJBG-95-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1E-ZJBG-94-T','T0087060','T0087060','LT CHARM BUNGA CLOVER SLEP YT 8K ','LT CHARM BUNGA CLOVER SLEP YT 8K','','','621000','621000',' 0','0','input','2026-10-29 12:43:21'); UPDATE tm_barang SET nama_barang='LT CHARM BUNGA CLOVER SLEP YT 8K' ,nama_atribut='' ,kode_intern='MED1 YT ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1E-ZJBG-94-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1D-ZJBH-48-T','T0087116','T0087116','LT MODEL FINE GOLD PLAT LG 8K ','LT MODEL FINE GOLD PLAT LG 8K','','','1066000','1066000',' 0','0','input','2026-10-29 12:44:03'); UPDATE tm_barang SET nama_barang='LT MODEL FINE GOLD PLAT LG 8K' ,nama_atribut='' ,kode_intern='MDD1 5K LG ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1D-ZJBH-48-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('E1F-ZJBA-103-T','T0086725','T0086725','CC MODEL BOTTEGA KH 14 8K ','CC MODEL BOTTEGA KH 14 8K','','','422000','422000',' 0','0','input','2026-10-29 12:44:39'); UPDATE tm_barang SET nama_barang='CC MODEL BOTTEGA KH 14 8K' ,nama_atribut='' ,kode_intern='MFE1 KH 14 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='E1F-ZJBA-103-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1E-ZJBH-42-T','T0087110','T0087110','LT MODEL FINE GOLD PLAT LG 8K ','LT MODEL FINE GOLD PLAT LG 8K','','','530500','530500',' 0','0','input','2026-10-29 12:48:32'); UPDATE tm_barang SET nama_barang='LT MODEL FINE GOLD PLAT LG 8K' ,nama_atribut='' ,kode_intern='MED1 5K LG ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1E-ZJBH-42-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1E-ZJBH-57-T','T0087125','T0087125','AT JERSY SLEP LG 8K ','AT JERSY SLEP LG 8K','','','520000','520000',' 0','0','input','2026-10-29 12:48:55'); UPDATE tm_barang SET nama_barang='AT JERSY SLEP LG 8K' ,nama_atribut='' ,kode_intern='MEA1 LG ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1E-ZJBH-57-T' 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 ('F226291256041','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZJBH-57-T','AT JERSY SLEP LG 8K','OL','0.500','1','100.00','520000','0','0','15000','523000','0','5000','0','528000','HAN','T0087125','A1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZJBH-57-T' 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-29' AND kode_barang='A1E-ZJBH-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226291256041','2026-10-29','0.500','2026-10-29','12:56:04','PLG0088232','523000','523000','5000','528000','528000','kasir','2026-10-29 12:56:04','F22629125604'); 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-29','F226291256041','2026-10-29','12:56:04','HAN','528000','5000'); 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-261029-0008','D','2026-10-29','12:56:04','kasir','PENJUALAN','F226291256041','18024535000','528000','18025063000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='528000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291256041' 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 ('F226291256042','kasir',' 1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZJXH-64-T','LT CHARM MODEL KUPU SLEP LG 8K','OL','0.300','1','100.00','322000','0','0','15000','326000','0','5000','0','331000','HAN','T0085931','D1G','0','0','-','0','1080000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZJXH-64-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='D1G-ZJXH-64-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226291256042','2026-10-29','0.300','2026-10-29','12:56:04','PLG0088233','326000','326000','5000','331000','331000','kasir','2026-10-29 12:56:04','F22629125604'); 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-29','F226291256042','2026-10-29','12:56:04','HAN','331000','5000'); 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-261029-0009','D','2026-10-29','12:56:04','kasir','PENJUALAN','F226291256042','18025063000','331000','18025394000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='331000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291256042' 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 ('F226291256043','kasir',' 1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZJXH-65-T','LT CHARM MODEL KUPU SLEP LG 8K','OL','0.300','1','100.00','322000','0','0','15000','326000','0','5000','0','331000','HAN','T0085932','D1G','0','0','-','0','1080000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZJXH-65-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='D1G-ZJXH-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226291256043','2026-10-29','0.300','2026-10-29','12:56:04','PLG0088234','326000','326000','5000','331000','331000','kasir','2026-10-29 12:56:04','F22629125604'); 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-29','F226291256043','2026-10-29','12:56:04','HAN','331000','5000'); 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-261029-0010','D','2026-10-29','12:56:04','kasir','PENJUALAN','F226291256043','18025394000','331000','18025725000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='331000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291256043' 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 ('F226291256044','kasir',' 1',' MFD1 LG ','TOKO','SMBK-D','D1F-ZJXH-62-T','LT CHARM MODEL KUPU SLEP LG 8K','OL','0.300','1','100.00','316000','0','0','15000','326000','0','5000','0','331000','HAN','T0085929','D1F','0','0','-','0','1055000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZJXH-62-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='D1F-ZJXH-62-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226291256044','2026-10-29','0.300','2026-10-29','12:56:04','PLG0088235','326000','326000','5000','331000','331000','kasir','2026-10-29 12:56:04','F22629125604'); 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-29','F226291256044','2026-10-29','12:56:04','HAN','331000','5000'); 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-261029-0011','D','2026-10-29','12:56:04','kasir','PENJUALAN','F226291256044','18025725000','331000','18026056000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='331000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291256044' 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 ('F226291256045','kasir',' 1',' MFD1 HW ','TOKO','SMBK-D','D1F-ZIXH-69-T','LT MODEL PITA VAR HW 8K ','OL','0.320','1','100.00','338000','0','0','15000','341000','0','5000','0','346000','HAN','T0083216','D1F','0','0','-','0','1055000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZIXH-69-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='D1F-ZIXH-69-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226291256045','2026-10-29','0.320','2026-10-29','12:56:04','PLG0088236','341000','341000','5000','346000','346000','kasir','2026-10-29 12:56:04','F22629125604'); 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-29','F226291256045','2026-10-29','12:56:04','HAN','346000','5000'); 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-261029-0012','D','2026-10-29','12:56:04','kasir','PENJUALAN','F226291256045','18026056000','346000','18026402000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='346000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291256045' 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 ('F226291256046','kasir',' 1',' MED1 YT ','TOKO','SMBK-D','D1E-ZJBG-95-T','LT CHARM BUNGA CLOVER SLEP YT 8K','OL','0.600','1','100.00','621000','0','0','15000','627000','0','5000','0','632000','HAN','T0087061','D1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZJBG-95-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='D1E-ZJBG-95-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226291256046','2026-10-29','0.600','2026-10-29','12:56:04','PLG0088237','627000','627000','5000','632000','632000','kasir','2026-10-29 12:56:04','F22629125604'); 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-29','F226291256046','2026-10-29','12:56:04','HAN','632000','5000'); 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-261029-0013','D','2026-10-29','12:56:04','kasir','PENJUALAN','F226291256046','18026402000','632000','18027034000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='632000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291256046' 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 ('F226291256047','kasir',' 1',' MED1 YT ','TOKO','SMBK-D','D1E-ZJBG-94-T','LT CHARM BUNGA CLOVER SLEP YT 8K','OL','0.600','1','100.00','621000','0','0','15000','627000','0','5000','0','632000','HAN','T0087060','D1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZJBG-94-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='D1E-ZJBG-94-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226291256047','2026-10-29','0.600','2026-10-29','12:56:04','PLG0088238','627000','627000','5000','632000','632000','kasir','2026-10-29 12:56:04','F22629125604'); 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-29','F226291256047','2026-10-29','12:56:04','HAN','632000','5000'); 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-261029-0014','D','2026-10-29','12:56:04','kasir','PENJUALAN','F226291256047','18027034000','632000','18027666000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='632000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226291256047' 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 ('F226290100141','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZJBH-42-T','LT MODEL FINE GOLD PLAT LG 8K','OL ','0.510','1','100.00','530000','0','0','15000','533000','0','5000','0','538000','HAN','T0087110','D1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZJBH-42-T' 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-29' AND kode_barang='D1E-ZJBH-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290100141','2026-10-29','0.510','2026-10-29','13:00:14','PLG0088239','533000','533000','5000','538000','538000','kasir','2026-10-29 13:00:14','F22629010014'); 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-29','F226290100141','2026-10-29','13:00:14','HAN','538000','5000'); 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-261029-0015','D','2026-10-29','13:00:14','kasir','PENJUALAN','F226290100141','18027666000','538000','18028204000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='538000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290100141' 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 ('F226290100142','kasir',' 1',' MDD1 5K LG','TOKO','SMBK-D','D1D-ZJBH-48-T','LT MODEL FINE GOLD PLAT LG 8K','OL ','1.050','1','100.00','1066000','0','0','15000','1071000','0','5000','0','1076000','HAN','T0087116','D1D','0','0','-','0','1015000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-ZJBH-48-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='D1D-ZJBH-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290100142','2026-10-29','1.050','2026-10-29','13:00:14','PLG0088240','1071000','1071000','5000','1076000','1076000','kasir','2026-10-29 13:00:14','F22629010014'); 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-29','F226290100142','2026-10-29','13:00:14','HAN','1076000','5000'); 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-261029-0016','D','2026-10-29','13:00:14','kasir','PENJUALAN','F226290100142','18028204000','1076000','18029280000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1076000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290100142' 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 ('F226290100143','kasir',' 1',' MFE1 KH 14','TOKO','SMBK-E','E1F-ZJBA-103-T','CC MODEL BOTTEGA KH 14 8K','OL ','0.400','1','100.00','422000','0','0','15000','426000','0','5000','0','431000','HAN','T0086725','E1F','0','0','-','0','1055000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJBA-103-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='E1F-ZJBA-103-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290100143','2026-10-29','0.400','2026-10-29','13:00:14','PLG0088241','426000','426000','5000','431000','431000','kasir','2026-10-29 13:00:14','F22629010014'); 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-29','F226290100143','2026-10-29','13:00:14','HAN','431000','5000'); 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-261029-0017','D','2026-10-29','13:00:14','kasir','PENJUALAN','F226290100143','18029280000','431000','18029711000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='431000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290100143' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('F3E-ZJBF-77-T','T0086889','T0086889','GL CHOKER MODEL BUNGA CLOVER SLEP KH 8K ','GL CHOKER MODEL BUNGA CLOVER SLEP KH 8K','','','724500','724500',' 0','0','input','2026-10-29 13:22:14'); UPDATE tm_barang SET nama_barang='GL CHOKER MODEL BUNGA CLOVER SLEP KH 8K' ,nama_atribut='' ,kode_intern='MEF3 KH ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='F3E-ZJBF-77-T' 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 ('F226290124031','kasir','1',' MEF3 KH ','TOKO','SMBK-F','F3E-ZJBF-77-T','GL CHOKER MODEL BUNGA CLOVER SLEP KH 8K','','0.700','1','100.00','724000','0','0','15000','725000','0','0','0','725000','HAN','T0086889','F3E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJBF-77-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-77-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290124031','2026-10-29','0.700','2026-10-29','13:24:04','PLG0088242','725000','725000','0','725000','725000','kasir','2026-10-29 13:24:03','F22629012403'); 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-29','F226290124031','2026-10-29','13:24:04','HAN','725000','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-261029-0018','D','2026-10-29','13:24:04','kasir','PENJUALAN','F226290124031','18029711000','725000','18030436000'); 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 ('F226290240301','kasir','1',' TEA1 LG ','TOKO','TBK-A','A1TE-ZJXE-195-T','AT GYPSY MRICAN VAR LG 17K ','OL','0.480','1','100.00','912000','0','0','15000','919000','0','5000','0','924000','NS','T0085705','A1TE','0','0','-','0','1900000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-ZJXE-195-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='A1TE-ZJXE-195-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' 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 ('F226290240301','2026-10-29','0.480','2026-10-29','14:40:30','PLG0088243','919000','919000','5000','924000','924000','kasir','2026-10-29 14:40:30','F22629024030'); 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-29','F226290240301','2026-10-29','14:40:30','NS','924000','5000'); 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-261029-0019','D','2026-10-29','14:40:30','kasir','PENJUALAN','F226290240301','18030436000','924000','18031360000'); INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('H1E-ZJBA-24-T','T0086646','T0086646','KL JEDAR UB 42CM 8K ','KL JEDAR UB 42CM 8K','','','1056000','1056000',' 0','0','input','2026-10-29 15:10:32'); UPDATE tm_barang SET nama_barang='KL JEDAR UB 42CM 8K' ,nama_atribut='' ,kode_intern='MEH1 UB 42 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='H1E-ZJBA-24-T' 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 ('F226290311281','kasir','1',' MEH1 UB 42','TOKO','SMBK-H','H1E-ZJBA-24-T','KL JEDAR UB 42CM 8K','OL','1.020','1','100.00','1056000','0','0','15000','1061000','0','5000','0','1066000','DIN','T0086646','H1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJBA-24-T' 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-29' AND kode_barang='H1E-ZJBA-24-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290311281','2026-10-29','1.020','2026-10-29','15:11:28','PLG0088244','1061000','1061000','5000','1066000','1066000','kasir','2026-10-29 15:11:28','F22629031128'); 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-29','F226290311281','2026-10-29','15:11:28','DIN','1066000','5000'); 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-261029-0020','D','2026-10-29','15:11:28','kasir','PENJUALAN','F226290311281','18031360000','1066000','18032426000'); INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('H1E-ZJAG-13-T','T0086580','T0086580','KL KOREA UB 44CM 8K ','KL KOREA UB 44CM 8K','','','2101500','2101500',' 0','0','input','2026-10-29 15:21:26'); UPDATE tm_barang SET nama_barang='KL KOREA UB 44CM 8K' ,nama_atribut='' ,kode_intern='MEH1 UB 44 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='H1E-ZJAG-13-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('H1E-ZJAG-12-T','T0086579','T0086579','KL KOREA UB 44CM 8K ','KL KOREA UB 44CM 8K','','','2070000','2070000',' 0','0','input','2026-10-29 15:21:42'); UPDATE tm_barang SET nama_barang='KL KOREA UB 44CM 8K' ,nama_atribut='' ,kode_intern='MEH1 UB 44 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='H1E-ZJAG-12-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('H1E-ZJBF-65-T','T0086877','T0086877','KL KOREA UB 44CM 8K ','KL KOREA UB 44CM 8K','','','2111500','2111500',' 0','0','input','2026-10-29 15:22:08'); UPDATE tm_barang SET nama_barang='KL KOREA UB 44CM 8K' ,nama_atribut='' ,kode_intern='MEH1 UB 44 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='H1E-ZJBF-65-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('H1E-ZJBF-60-T','T0086872','T0086872','KL SANTA UB 40CM 8K ','KL SANTA UB 40CM 8K','','','2205000','2205000',' 0','0','input','2026-10-29 15:24:23'); UPDATE tm_barang SET nama_barang='KL SANTA UB 40CM 8K' ,nama_atribut='' ,kode_intern='MEH1 UB 40 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='H1E-ZJBF-60-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('E2F-ZJBF-132-T','T0086944','T0086944','CC MODEL PAKU MATA VAR KH 18 8K ','CC MODEL PAKU MATA VAR KH 18 8K','','','454000','454000',' 0','0','input','2026-10-29 15:27:08'); UPDATE tm_barang SET nama_barang='CC MODEL PAKU MATA VAR KH 18 8K' ,nama_atribut='' ,kode_intern='MFE2 KH 18 ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='E2F-ZJBF-132-T' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('F3E-ZJAF-54-0','00430233','00430233','GL X BRONET SLEP KH 8K ','GL X BRONET SLEP KH 8K','','','724500','724500',' 0','0','input','2026-10-29 15:29:20'); UPDATE tm_barang SET nama_barang='GL X BRONET SLEP KH 8K' ,nama_atribut='' ,kode_intern='MEF3 X KH ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='F3E-ZJAF-54-0' 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 ('F226290330221','kasir','1',' MEF3 X KH ','TOKO','SMBK-F','F3E-ZJAF-54-0','GL X BRONET SLEP KH 8K','','0.700','1','100.00','724000','0','0','15000','725000','0','0','0','725000','TJ','00430233','F3E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJAF-54-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJAF-54-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290330221','2026-10-29','0.700','2026-10-29','15:30:23','PLG0088245','725000','725000','0','725000','725000','kasir','2026-10-29 15:30:22','F22629033022'); 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-29','F226290330221','2026-10-29','15:30:23','TJ','725000','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-261029-0021','D','2026-10-29','15:30:23','kasir','PENJUALAN','F226290330221','18032426000','725000','18033151000'); 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 ('F226290330581','kasir','1',' MFE2 KH 18','TOKO','SMBK-E','E2F-ZJBF-132-T','CC MODEL PAKU MATA VAR KH 18 8K','','0.430','1','100.00','454000','0','0','15000','454000','0','0','0','454000','TJ','T0086944','E2F','0','0','-','0','1055000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZJBF-132-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='E2F-ZJBF-132-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290330581','2026-10-29','0.430','2026-10-29','15:30:59','PLG0088246','454000','454000','0','454000','454000','kasir','2026-10-29 15:30:58','F22629033058'); 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-29','F226290330581','2026-10-29','15:30:59','TJ','454000','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-261029-0022','D','2026-10-29','15:30:59','kasir','PENJUALAN','F226290330581','18033151000','454000','18033605000'); 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 ('F226290331551','kasir','1',' MEH1 UB 32','TOKO','SMBK-H','H1E-ZIBI-47-T','KL ANAK NORY UB 34CM 8K ','','1.000','1','100.00','1035000','0','0','15000','1035000','0','0','0','1035000','HAN','T0084875','H1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIBI-47-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='H1E-ZIBI-47-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290331551','2026-10-29','1.000','2026-10-29','15:31:55','PLG0088247','1035000','1035000','0','1035000','1035000','kasir','2026-10-29 15:31:55','F22629033155'); 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-29','F226290331551','2026-10-29','15:31:55','HAN','1035000','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-261029-0023','D','2026-10-29','15:31:55','kasir','PENJUALAN','F226290331551','18033605000','1035000','18034640000'); INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D2E-ZEBH-64-T','T0080005','T0080005','LT MODEL HURUF MATA V LG 8K ','LT MODEL HURUF MATA V LG 8K','','','621000','621000',' 0','0','input','2026-10-29 15:35:11'); UPDATE tm_barang SET nama_barang='LT MODEL HURUF MATA V LG 8K' ,nama_atribut='' ,kode_intern='MED2E LG V ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D2E-ZEBH-64-T' 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 ('F226290335541','kasir','1',' MED2E LG V','TOKO','SMBK-D','D2E-ZEBH-64-T','LT MODEL HURUF MATA V LG 8K','','0.600','1','100.00','621000','0','0','15000','621000','0','0','0','621000','NS','T0080005','D2E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZEBH-64-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='D2E-ZEBH-64-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290335541','2026-10-29','0.600','2026-10-29','15:35:55','PLG0088248','621000','621000','0','621000','621000','kasir','2026-10-29 15:35:54','F22629033554'); 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-29','F226290335541','2026-10-29','15:35:55','NS','621000','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-261029-0024','D','2026-10-29','15:35:55','kasir','PENJUALAN','F226290335541','18034640000','621000','18035261000'); 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 ('F226290337441','kasir','1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZJAG-13-T','KL KOREA UB 44CM 8K','','2.030','1','100.00','2101000','0','0','15000','2122000','0','10000','0','2132000','NS','T0086580','H1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJAG-13-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='H1E-ZJAG-13-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290337441','2026-10-29','2.030','2026-10-29','15:37:45','PLG0088249','2122000','2122000','10000','2132000','2132000','kasir','2026-10-29 15:37:44','F22629033744'); 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-29','F226290337441','2026-10-29','15:37:45','NS','2132000','10000'); 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-261029-0025','D','2026-10-29','15:37:45','kasir','PENJUALAN','F226290337441','18035261000','2132000','18037393000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2132000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290337441' 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 ('F226290337442','kasir',' 1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZJAG-12-T','KL KOREA UB 44CM 8K','OL','2.000','1','100.00','2070000','0','0','15000','2090000','0','10000','0','2100000','NS','T0086579','H1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJAG-12-T' 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-29' AND kode_barang='H1E-ZJAG-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290337442','2026-10-29','2.000','2026-10-29','15:37:45','PLG0088250','2090000','2090000','10000','2100000','2100000','kasir','2026-10-29 15:37:44','F22629033744'); 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-29','F226290337442','2026-10-29','15:37:45','NS','2100000','10000'); 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-261029-0026','D','2026-10-29','15:37:45','kasir','PENJUALAN','F226290337442','18037393000','2100000','18039493000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2100000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290337442' 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 ('F226290337443','kasir',' 1',' MEH1 UB 44','TOKO','SMBK-H','H1E-ZJBF-65-T','KL KOREA UB 44CM 8K','OL','2.040','1','100.00','2111000','0','0','15000','2132000','0','10000','0','2142000','NS','T0086877','H1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJBF-65-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='H1E-ZJBF-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290337443','2026-10-29','2.040','2026-10-29','15:37:45','PLG0088251','2132000','2132000','10000','2142000','2142000','kasir','2026-10-29 15:37:44','F22629033744'); 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-29','F226290337443','2026-10-29','15:37:45','NS','2142000','10000'); 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-261029-0027','D','2026-10-29','15:37:45','kasir','PENJUALAN','F226290337443','18039493000','2142000','18041635000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2142000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290337443' 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 ('F226290337444','kasir',' 1',' MEH1 UB 40','TOKO','SMBK-H','H1E-ZJBF-60-T','KL SANTA UB 40CM 8K','OL','2.130','1','100.00','2205000','0','0','15000','2226000','0','11000','0','2237000','NS','T0086872','H1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJBF-60-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='H1E-ZJBF-60-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226290337444','2026-10-29','2.130','2026-10-29','15:37:45','PLG0088252','2226000','2226000','11000','2237000','2237000','kasir','2026-10-29 15:37:44','F22629033744'); 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-29','F226290337444','2026-10-29','15:37:45','NS','2237000','11000'); 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-261029-0028','D','2026-10-29','15:37:45','kasir','PENJUALAN','F226290337444','18041635000','2237000','18043872000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2237000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290337444' 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 ('F226290337445','kasir',' 1',' MEA1E X CM','TOKO','SMBK-A','A1E-ZHBE-157-0','AT X GYPSY POLOS CM 8K ','OL','0.600','1','100.00','621000','0','0','15000','630000','0','15000','0','645000','NS','00420199','A1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHBE-157-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='A1E-ZHBE-157-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226290337445','2026-10-29','0.600','2026-10-29','15:37:45','PLG0088253','630000','630000','15000','645000','645000','kasir','2026-10-29 15:37:44','F22629033744'); 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-29','F226290337445','2026-10-29','15:37:45','NS','645000','15000'); 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-261029-0029','D','2026-10-29','15:37:45','kasir','PENJUALAN','F226290337445','18043872000','645000','18044517000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='645000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290337445' 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 ('F226290338101','kasir','1',' MEA1E X HW','TOKO','SMBK-A','A1E-ZHCA-109-0','AT X ITALY SLEP VAR HW 8K ','OL','0.680','1','100.00','704000','0','0','15000','714000','0','5000','0','719000','NS','00421397','A1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHCA-109-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='A1E-ZHCA-109-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226290338101','2026-10-29','0.680','2026-10-29','15:38:11','PLG0088254','714000','714000','5000','719000','719000','kasir','2026-10-29 15:38:10','F22629033810'); 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-29','F226290338101','2026-10-29','15:38:11','NS','719000','5000'); 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-261029-0030','D','2026-10-29','15:38:11','kasir','PENJUALAN','F226290338101','18044517000','719000','18045236000'); INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1E-ZJXI-76-T','T0086050','T0086050','AT MODEL ITALY PANJANG VAR HW 8K ','AT MODEL ITALY PANJANG VAR HW 8K','','','673000','673000',' 0','0','input','2026-10-29 15:40:16'); UPDATE tm_barang SET nama_barang='AT MODEL ITALY PANJANG VAR HW 8K' ,nama_atribut='' ,kode_intern='MEA1 HW ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1E-ZJXI-76-T' 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 ('F226290341191','kasir','1',' MEA1 HW ','TOKO','SMBK-A','A1E-ZJXI-76-T','AT MODEL ITALY PANJANG VAR HW 8K','OL','0.650','1','100.00','673000','0','0','15000','683000','0','5000','0','688000','NS','T0086050','A1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZJXI-76-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='A1E-ZJXI-76-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226290341191','2026-10-29','0.650','2026-10-29','15:41:20','PLG0088255','683000','683000','5000','688000','688000','kasir','2026-10-29 15:41:19','F22629034119'); 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-29','F226290341191','2026-10-29','15:41:20','NS','688000','5000'); 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-261029-0031','D','2026-10-29','15:41:20','kasir','PENJUALAN','F226290341191','18045236000','688000','18045924000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='688000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290341191' 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 ('F226290341192','kasir',' 1',' MEA1 HW ','TOKO','SMBK-A','A1E-ZIBI-19-T','AT MODEL ITALY PANJANG VAR HW 8K ','OL','0.620','1','100.00','642000','0','0','15000','651000','0','5000','0','656000','NS','T0084847','A1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZIBI-19-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='A1E-ZIBI-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226290341192','2026-10-29','0.620','2026-10-29','15:41:20','PLG0088256','651000','651000','5000','656000','656000','kasir','2026-10-29 15:41:19','F22629034119'); 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-29','F226290341192','2026-10-29','15:41:20','NS','656000','5000'); 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-261029-0032','D','2026-10-29','15:41:20','kasir','PENJUALAN','F226290341192','18045924000','656000','18046580000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='656000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226290341192' LIMIT 1; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','1','F3E-ZJBF-97-T','1','0.800','0.800','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZJBF-97-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F3E','F3E-ZJBF-97-T','100.00','1','0.800','0.800','1','0.800','0.800'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.800',berat_out_asli=berat_out_asli+'0.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-97-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','2','F3E-ZJBF-78-T','1','0.750','0.750','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZJBF-78-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F3E','F3E-ZJBF-78-T','100.00','1','0.750','0.750','1','0.750','0.750'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.750',berat_out_asli=berat_out_asli+'0.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-78-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','3','F3E-ZJBF-84-T','1','0.800','0.800','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZJBF-84-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F3E','F3E-ZJBF-84-T','100.00','1','0.800','0.800','1','0.800','0.800'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.800',berat_out_asli=berat_out_asli+'0.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-84-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','4','F3E-ZJBF-99-T','1','0.810','0.810','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZJBF-99-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F3E','F3E-ZJBF-99-T','100.00','1','0.810','0.810','1','0.810','0.810'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.810',berat_out_asli=berat_out_asli+'0.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-99-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','5','F3E-ZJBF-101-T','1','0.810','0.810','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZJBF-101-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F3E','F3E-ZJBF-101-T','100.00','1','0.810','0.810','1','0.810','0.810'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.810',berat_out_asli=berat_out_asli+'0.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-101-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','6','F3E-ZJBF-102-T','1','0.810','0.810','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZJBF-102-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F3E','F3E-ZJBF-102-T','100.00','1','0.810','0.810','1','0.810','0.810'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.810',berat_out_asli=berat_out_asli+'0.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-102-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','7','F3E-ZJBF-100-T','1','0.810','0.810','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZJBF-100-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F3E','F3E-ZJBF-100-T','100.00','1','0.810','0.810','1','0.810','0.810'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.810',berat_out_asli=berat_out_asli+'0.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-100-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','8','F3E-ZJAG-9-T','1','0.700','0.700','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZJAG-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F3E','F3E-ZJAG-9-T','100.00','1','0.700','0.700','1','0.700','0.700'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.700',berat_out_asli=berat_out_asli+'0.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJAG-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','9','F3E-ZJBF-96-T','1','0.820','0.820','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZJBF-96-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F3E','F3E-ZJBF-96-T','100.00','1','0.820','0.820','1','0.820','0.820'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.820',berat_out_asli=berat_out_asli+'0.820',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-96-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','10','F3E-ZJXH-41-T','1','0.710','0.710','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZJXH-41-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F3E','F3E-ZJXH-41-T','100.00','1','0.710','0.710','1','0.710','0.710'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.710',berat_out_asli=berat_out_asli+'0.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJXH-41-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','11','F1E-ZIAD-9-T','1','0.780','0.780','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F1E-ZIAD-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F1E','F1E-ZIAD-9-T','100.00','1','0.780','0.780','1','0.780','0.780'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.780',berat_out_asli=berat_out_asli+'0.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F1E-ZIAD-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0001','12','F3E-ZJBF-86-T','1','0.810','0.810','TOKO','SMBK-F','TOKO','BK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-ZJBF-86-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','BK-F','F3E','F3E-ZJBF-86-T','100.00','1','0.810','0.810','1','0.810','0.810'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.810',berat_out_asli=berat_out_asli+'0.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-86-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261029-0001','2026-10-29','2026-10-29','15:44','9.41','admin','2026-10-29 15:46:57'); 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 ('F226290350051','kasir','1',' MEA1E 5K L','TOKO','SMBK-A','A1E-ZHBG-27-T','AT KLIP BANGKOK SLEP LG 8K ','OL','1.020','1','100.00','1056000','0','0','15000','1061000','0','5000','0','1066000','HAN','T0082533','A1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHBG-27-T' 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-29' AND kode_barang='A1E-ZHBG-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226290350051','2026-10-29','1.020','2026-10-29','15:50:06','PLG0088257','1061000','1061000','5000','1066000','1066000','kasir','2026-10-29 15:50:05','F22629035005'); 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-29','F226290350051','2026-10-29','15:50:06','HAN','1066000','5000'); 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-261029-0033','D','2026-10-29','15:50:06','kasir','PENJUALAN','F226290350051','18046580000','1066000','18047646000'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0002','1','F3E-ZJBF-94-T','1','0.800','0.800','TOKO','SMBK-F','TOKO','PMBK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PMBK-F' WHERE kode_barang='F3E-ZJBF-94-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','PMBK-F','F3E','F3E-ZJBF-94-T','100.00','1','0.800','0.800','1','0.800','0.800'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.800',berat_out_asli=berat_out_asli+'0.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-94-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0002','2','F3E-ZJBF-76-T','1','0.680','0.680','TOKO','SMBK-F','TOKO','PMBK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PMBK-F' WHERE kode_barang='F3E-ZJBF-76-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','PMBK-F','F3E','F3E-ZJBF-76-T','100.00','1','0.680','0.680','1','0.680','0.680'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.680',berat_out_asli=berat_out_asli+'0.680',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-76-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0002','3','F3E-ZJBF-83-T','1','0.800','0.800','TOKO','SMBK-F','TOKO','PMBK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PMBK-F' WHERE kode_barang='F3E-ZJBF-83-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','PMBK-F','F3E','F3E-ZJBF-83-T','100.00','1','0.800','0.800','1','0.800','0.800'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.800',berat_out_asli=berat_out_asli+'0.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-83-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0002','4','F3E-ZJBF-80-T','1','0.800','0.800','TOKO','SMBK-F','TOKO','PMBK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PMBK-F' WHERE kode_barang='F3E-ZJBF-80-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','PMBK-F','F3E','F3E-ZJBF-80-T','100.00','1','0.800','0.800','1','0.800','0.800'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.800',berat_out_asli=berat_out_asli+'0.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-80-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261029-0002','5','F3E-ZJBF-87-T','1','0.760','0.760','TOKO','SMBK-F','TOKO','PMBK-F'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PMBK-F' WHERE kode_barang='F3E-ZJBF-87-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-10-29','TOKO','PMBK-F','F3E','F3E-ZJBF-87-T','100.00','1','0.760','0.760','1','0.760','0.760'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.760',berat_out_asli=berat_out_asli+'0.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-29' AND kode_barang='F3E-ZJBF-87-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261029-0002','2026-10-29','2026-10-29','15:52','3.84','admin','2026-10-29 15:53:40'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290100141' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290100141' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290100141'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290100142' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290100142' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290100142'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290100143' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290100143' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290100143'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290124031' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290124031' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290124031'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290240301' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290240301' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290240301'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290311281' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290311281' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290311281'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290330221' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290330221' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290330221'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290330581' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290330581' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290330581'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290331551' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290331551' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290331551'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290335541' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290335541' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290335541'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290337441' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290337441' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290337441'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290337442' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290337442' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290337442'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290337443' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290337443' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290337443'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290337444' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290337444' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290337444'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290337445' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290337445' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290337445'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290338101' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290338101' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290338101'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290341191' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290341191' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290341191'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290341192' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290341192' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290341192'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290350051' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290350051' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290350051'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290957281' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290957281' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290957281'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291027471' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291027471' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291027471'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291029101' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291029101' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291029101'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291113001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291113001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291113001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291153481' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291153481' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291153481'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291159281' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291159281' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291159281'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291232481' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291232481' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291232481'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291232482' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291232482' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291232482'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256041' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256041' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291256041'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256042' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256042' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291256042'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256043' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256043' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291256043'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256044' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256044' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291256044'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256045' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256045' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291256045'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256046' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256046' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291256046'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256047' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226291256047' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226291256047'; 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 ('F226290441151','kasir','1',' MEA1E X CM','TOKO','SMBK-A','A1E-ZHBE-157-0','AT X GYPSY POLOS CM 8K ','OL','0.600','1','100.00','621000','0','0','15000','630000','0','5000','0','635000','NS','00420199','A1E','0','0','-','0','1040000'); UPDATE tm_barang SET tgl_last_jual='2026-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHBE-157-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-10-29' AND kode_barang='A1E-ZHBE-157-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' 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 ('F226290441151','2026-10-29','0.600','2026-10-29','16:41:15','PLG0088258','630000','630000','5000','635000','635000','kasir','2026-10-29 16:41:15','F22629044115'); 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-29','F226290441151','2026-10-29','16:41:15','NS','635000','5000'); 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-261029-0035','D','2026-10-29','16:41:15','kasir','PENJUALAN','F226290441151','18047001000','635000','18047636000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226290441151' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226290441151' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226290441151'; 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-00005891','X-00005891','CC MODEL ISYANA SLEP LG 12 8K','GR','---','E1E','BELI','BELI001','390000','2026-10-29','0.420','1','kasir','2026-10-29 16:49:54'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005891','X-00005891'); 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-261029-0001','F226140909171','NOV','1','BELI','BELI001','E1E', 'X-00005891', 'CC MODEL ISYANA SLEP LG 12 8K','0.420','0.420','100.00','437000','390000','928571','1040000','1','390000','390000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.420',berat_beli_asli=berat_beli_asli+'0.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.420',berat_akhir_asli=berat_akhir_asli+'0.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-29' 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-261029-0001','2026-10-29','2026-10-29','16:49:54','NOV','---','0.420','390000','390000','390000','390000','390000','kasir','2026-10-29 16:49:54','FB-261029-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261029-0001','YULI','KRAJAN 2 JENANGAN','','','082311567772','kasir','2026-10-29 16:49:54'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-29' 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-261029-0036','K','2026-10-29','16:49:54','kasir','PEMBELIAN UMUM','FB-261029-0001','18047636000','390000','18047246000'); 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-00005892','X-00005892','CC X MODEL MATA CM 14 8K','GR','---','E2D','BELI','BELI001','877000','2026-10-29','0.940','1','kasir','2026-10-29 16:50:12'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00005892','X-00005892'); 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-261029-0002','F226231129491','TJ','1','BELI','BELI001','E2D', 'X-00005892', 'CC X MODEL MATA CM 14 8K','0.940','0.940','100.00','1020000','877000','932979','1015000','1','877000','877000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.940',berat_beli_asli=berat_beli_asli+'0.940',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.940',berat_akhir_asli=berat_akhir_asli+'0.940',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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-261029-0002','2026-10-29','2026-10-29','16:50:12','TJ','---','0.940','877000','877000','877000','877000','877000','kasir','2026-10-29 16:50:12','FB-261029-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261029-0002','MERRY','','','','','kasir','2026-10-29 16:50:12'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-29' 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-261029-0037','K','2026-10-29','16:50:12','kasir','PEMBELIAN UMUM','FB-261029-0002','18047246000','877000','18046369000'); 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-00005893','X-00005893','CC MODEL LISTRING V MATA CM 14','GR','---','E2TE','BELI','BELI001','1180000','2026-10-29','0.750','1','kasir','2026-10-29 16:51:34'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00005893','X-00005893'); 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-261029-0003','F222041009011','HAN','1','BELI','BELI001','E2TE', 'X-00005893', 'CC MODEL LISTRING V MATA CM 14','0.970','0.750','100.00','743000','1180000','1573333','1900000','1','1180000','1180000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.750',berat_beli_asli=berat_beli_asli+'0.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.750',berat_akhir_asli=berat_akhir_asli+'0.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-29' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-261029-0003','2026-10-29','2026-10-29','16:51:33','HAN','---','0.750','1180000','1180000','1180000','1180000','1180000','kasir','2026-10-29 16:51:34','FB-261029-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261029-0003','CICI/PIPIT OLS','PONOROGO','','','','kasir','2026-10-29 16:51:34'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-29' 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-261029-0038','K','2026-10-29','16:51:33','kasir','PEMBELIAN UMUM','FB-261029-0003','18046369000','1180000','18045189000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261029-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261029-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261029-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261029-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261029-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261029-0003'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-30','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-29'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-29'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-29'; 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-29' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-29'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-29'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-29'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-29'; 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-30' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-29' 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-261030-0001','D','2026-10-30','17:11:12','SYSTEM','SALDO AWAL','SALDO AWAL','0','18045189000','18045189000'); 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-261030-0001','D','2026-10-30','17:11:12','BCA','SALDO AWAL','SALDO AWAL','0','4968490888','4968490888'); 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-261030-0001','D','2026-10-30','17:11:12','','SALDO AWAL','SALDO AWAL','0','3346000','3346000'); 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-261030-0001','D','2026-10-30','17:11:12','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000'); 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-261030-0001','D','2026-10-30','17:11:12','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-261030-0001','D','2026-10-30','17:11:12','DLL','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-10-30';