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 ('F326020847361','input','1',' MEB1E X AY','TOKO','PM-B','B1E-ZHXA-64-0','GW X MODEL TAUGE MATA AY 8K ','','0.530','1','100.00','535000','0','0','15000','535000','0','0','0','535000','LIS','00416362','B1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZHXA-64-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='B1E-ZHXA-64-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326020847361','2026-11-02','0.530','2026-11-02','08:47:37','PLG0032168','535000','535000','0','535000','535000','input','2026-11-02 08:47:36','F32602084736'); 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-11-02','F326020847361','2026-11-02','08:47:37','LIS','535000','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-261102-0002','D','2026-11-02','08:47:37','input','PENJUALAN','F326020847361','8074238000','535000','8074773000'); 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 ('F326021049181','kasir','1',' MED1E X LG','TOKO','PM-D','D1E-ZIXH-41-0','LT X MODEL FG SLEP LG 8K ','','0.530','1','100.00','535000','0','0','15000','535000','0','0','0','535000','SIN','00422308','D1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZIXH-41-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='D1E-ZIXH-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326021049181','2026-11-02','0.530','2026-11-02','10:49:18','PLG0032169','535000','535000','0','535000','535000','kasir','2026-11-02 10:49:18','F32602104918'); 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-11-02','F326021049181','2026-11-02','10:49:18','SIN','535000','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-261102-0003','D','2026-11-02','10:49:18','kasir','PENJUALAN','F326021049181','8074773000','535000','8075308000'); 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 ('F326021123071','kasir','1',' MEF2 YT D5','TOKO','PM-F','F2E-ZJBH-169-0','GL OVAL MODEL PAKU MATA YT D54 8K ','','1.620','1','100.00','1636000','0','0','15000','1636000','0','0','0','1636000','FIT','00431935','F2E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZJBH-169-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.620',berat_jual_asli=berat_jual_asli+'1.620',stock_jual='1',berat_akhir=berat_akhir-'1.620',berat_akhir_asli=berat_akhir_asli-'1.620',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='F2E-ZJBH-169-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326021123071','2026-11-02','1.620','2026-11-02','11:23:07','PLG0032170','1636000','1636000','0','1636000','1636000','kasir','2026-11-02 11:23:07','F32602112307'); 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-11-02','F326021123071','2026-11-02','11:23:07','FIT','1636000','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-261102-0004','D','2026-11-02','11:23:07','kasir','PENJUALAN','F326021123071','8075308000','1636000','8076944000'); 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-00020713','X-00020713','CC XXX BANGKOK SLEP LG 14 8K','GR','---','E1E','BELI','BELI001','500000','2026-11-02','0.520','1','kasir','2026-11-02 11:42:45'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020713','X-00020713'); 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-261102-0001','F326130831261','SIN','1','BELI','BELI001','E1E', 'X-00020713', 'CC XXX BANGKOK SLEP LG 14 8K','0.520','0.520','100.00','528000','500000','961538','1020000','1','500000','500000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.520',berat_beli_asli=berat_beli_asli+'0.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.520',berat_akhir_asli=berat_akhir_asli+'0.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-02' 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-261102-0001','2026-11-02','2026-11-02','11:42:44','SIN','---','0.520','500000','500000','500000','500000','500000','kasir','2026-11-02 11:42:45','FB-261102-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261102-0001','MBAH SUM','JATISARI BITING','','','','kasir','2026-11-02 11:42:45'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-02' 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-261102-0005','K','2026-11-02','11:42:44','kasir','PEMBELIAN UMUM','FB-261102-0001','8076944000','500000','8076444000'); 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-00020714','X-00020714','GL KREPYAK MODEL DAUN PASIR VAR BG 8K','GR','---','F3F','BELI','BELI001','6630000','2026-11-02','6.930','1','kasir','2026-11-02 11:43:05'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00020714','X-00020714'); 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-261102-0002','F326021025161','FIT','1','BELI','BELI001','F3F', 'X-00020714', 'GL KREPYAK MODEL DAUN PASIR VAR BG 8K','6.930','6.930','100.00','7520000','6630000','956710','1040000','1','6630000','6630000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.930',berat_beli_asli=berat_beli_asli+'6.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.930',berat_akhir_asli=berat_akhir_asli+'6.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-261102-0002','2026-11-02','2026-11-02','11:43:05','FIT','---','6.930','6630000','6630000','6630000','6630000','6630000','kasir','2026-11-02 11:43:05','FB-261102-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261102-0002','TUTIK','SOBOGENENG','','','085326942477','kasir','2026-11-02 11:43:05'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-02' 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-261102-0006','K','2026-11-02','11:43:05','kasir','PEMBELIAN UMUM','FB-261102-0002','8076444000','6630000','8069814000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261102-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261102-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261102-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261102-0001'; 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-00020715','X-00020715','CC XXX BANGKOK SLEP LG 14 8K','GR','---','E1E','BELI','BELI001','500000','2026-11-02','0.520','1','kasir','2026-11-02 11:46:22'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020715','X-00020715'); 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-261102-0001','F326130831261','SIN','1','BELI','BELI001','E1E', 'X-00020715', 'CC XXX BANGKOK SLEP LG 14 8K','0.520','0.520','100.00','528000','500000','961538','1020000','1','500000','500000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.520',berat_beli_asli=berat_beli_asli+'0.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.520',berat_akhir_asli=berat_akhir_asli+'0.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-02' 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-261102-0001','2026-11-02','2026-11-02','11:46:21','SIN','---','0.520','500000','500000','500000','500000','500000','kasir','2026-11-02 11:46:22','FB-261102-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261102-0001','MBAH SUM','JATISARI BITING','','','','kasir','2026-11-02 11:46:22'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-02' 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-261102-0009','K','2026-11-02','11:46:21','kasir','PEMBELIAN UMUM','FB-261102-0001','8076944000','500000','8076444000'); 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-00020716','X-00020716','GL KREPYAK MODEL DAUN PASIR VAR BG 8K','GR','---','F3F','BELI','BELI001','6630000','2026-11-02','6.930','1','kasir','2026-11-02 11:47:39'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00020716','X-00020716'); 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-261102-0002','F326021025161','FIT','1','BELI','BELI001','F3F', 'X-00020716', 'GL KREPYAK MODEL DAUN PASIR VAR BG 8K','6.930','6.930','100.00','7520000','6630000','956710','1040000','1','6630000','6630000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.930',berat_beli_asli=berat_beli_asli+'6.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.930',berat_akhir_asli=berat_akhir_asli+'6.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-261102-0002','2026-11-02','2026-11-02','11:47:39','FIT','---','6.930','6630000','6630000','6630000','6630000','6630000','kasir','2026-11-02 11:47:39','FB-261102-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261102-0002','TUTIK','SOBOGENENG','','','085326942477','kasir','2026-11-02 11:47:39'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-02' 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-261102-0010','K','2026-11-02','11:47:39','kasir','PEMBELIAN UMUM','FB-261102-0002','8076444000','6630000','8069814000'); 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-00020717','X-00020717','GL CASTELI SLEP HW 8K','GR','---','F3E','BELI','BELI001','1605000','2026-11-02','1.710','1','kasir','2026-11-02 11:48:19'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020717','X-00020717'); 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-261102-0003','F326191020183','SIN','1','BELI','BELI001','F3E', 'X-00020717', 'GL CASTELI SLEP HW 8K','1.710','1.710','100.00','1801000','1605000','938596','1020000','1','1605000','1605000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.710',berat_beli_asli=berat_beli_asli+'1.710',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.710',berat_akhir_asli=berat_akhir_asli+'1.710',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261102-0003','2026-11-02','2026-11-02','11:48:18','SIN','---','1.710','1605000','1605000','1605000','1605000','1605000','kasir','2026-11-02 11:48:19','FB-261102-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261102-0003','NDARI','SUMBER CONTO BULUKERTO','','','085211494476','kasir','2026-11-02 11:48:19'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-02' 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-261102-0011','K','2026-11-02','11:48:18','kasir','PEMBELIAN UMUM','FB-261102-0003','8069814000','1605000','8068209000'); 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-00020718','X-00020718','GL XXX BANGKOK C ANAK TD 36 8K','GR','---','F1E','BELI','BELI001','1860000','2026-11-02','1.920','1','kasir','2026-11-02 11:48:47'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020718','X-00020718'); 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-261102-0004','F326201107412','LIS','1','BELI','BELI001','F1E', 'X-00020718', 'GL XXX BANGKOK C ANAK TD 36 8K','1.920','1.920','100.00','2208000','1860000','968750','1020000','1','1860000','1860000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.920',berat_beli_asli=berat_beli_asli+'1.920',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.920',berat_akhir_asli=berat_akhir_asli+'1.920',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261102-0004','2026-11-02','2026-11-02','11:48:46','LIS','---','1.920','1860000','1860000','1860000','1860000','1860000','kasir','2026-11-02 11:48:47','FB-261102-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261102-0004','BELLA','PURWANTORO','','','','kasir','2026-11-02 11:48:47'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-02' 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-261102-0012','K','2026-11-02','11:48:46','kasir','PEMBELIAN UMUM','FB-261102-0004','8068209000','1860000','8066349000'); 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-00020719','X-00020719','GL X BANGKOK C ANAK SLEP TD 34 8K','GR','---','F1E','BELI','BELI001','1750000','2026-11-02','1.950','1','kasir','2026-11-02 11:48:47'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020719','X-00020719'); 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-261102-0005','F326201107411','LIS','2','BELI','BELI001','F1E', 'X-00020719', 'GL X BANGKOK C ANAK SLEP TD 34 8K','1.950','1.950','100.00','2242000','1750000','897436','1020000','1','1750000','1750000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.950',berat_beli_asli=berat_beli_asli+'1.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.950',berat_akhir_asli=berat_akhir_asli+'1.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261102-0005','2026-11-02','2026-11-02','11:48:46','LIS','---','1.950','1750000','1750000','1750000','1750000','1750000','kasir','2026-11-02 11:48:47','FB-261102-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261102-0005','BELLA','PURWANTORO','','','','kasir','2026-11-02 11:48:47'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-02' 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-261102-0013','K','2026-11-02','11:48:46','kasir','PEMBELIAN UMUM','FB-261102-0005','8066349000','1750000','8064599000'); 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-00020720','X-00020720','GL X TIFF SPECTRA VAR YT 8K','GR','---','F3E','BELI','BELI001','1310000','2026-11-02','1.380','1','kasir','2026-11-02 11:49:07'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020720','X-00020720'); 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-261102-0006','F326020248231','SIN','1','BELI','BELI001','F3E', 'X-00020720', 'GL X TIFF SPECTRA VAR YT 8K','1.380','1.380','100.00','1420000','1310000','949275','1020000','1','1310000','1310000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.380',berat_beli_asli=berat_beli_asli+'1.380',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.380',berat_akhir_asli=berat_akhir_asli+'1.380',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261102-0006','2026-11-02','2026-11-02','11:49:06','SIN','---','1.380','1310000','1310000','1310000','1310000','1310000','kasir','2026-11-02 11:49:07','FB-261102-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261102-0006','LENI','BANDAR','','','','kasir','2026-11-02 11:49:07'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-02' 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-261102-0014','K','2026-11-02','11:49:06','kasir','PEMBELIAN UMUM','FB-261102-0006','8064599000','1310000','8063289000'); 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 ('F326021230511','kasir','1',' MDE2 X LG ','TOKO','PM-E','E2D-ZJAF-133-0','CC X MODEL MATA LG 14 8K','','0.970','1','100.00','960000','0','0','15000','960000','0','0','0','960000','SIN','00430312','E2D','0','0','-','0','1000000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJAF-133-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='E2D-ZJAF-133-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326021230511','2026-11-02','0.970','2026-11-02','12:30:52','PLG0032171','960000','960000','0','960000','960000','kasir','2026-11-02 12:30:51','F32602123051'); 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-11-02','F326021230511','2026-11-02','12:30:52','SIN','960000','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-261102-0015','D','2026-11-02','12:30:52','kasir','PENJUALAN','F326021230511','8063289000','960000','8064249000'); 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 ('F326021243401','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZFBI-63-0','CC X SOLITAIRE MATA CM 10 8K ','','0.980','1','100.00','970000','0','0','15000','970000','0','10000','0','980000','LIS','00411055','E2D','0','0','-','0','1000000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFBI-63-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='E2D-ZFBI-63-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326021243401','2026-11-02','0.980','2026-11-02','12:43:41','PLG0032172','970000','970000','10000','980000','980000','kasir','2026-11-02 12:43:40','F32602124340'); 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-11-02','F326021243401','2026-11-02','12:43:41','LIS','980000','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-261102-0016','D','2026-11-02','12:43:41','kasir','PENJUALAN','F326021243401','8064249000','980000','8065229000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='980000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326021243401' 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 ('F326021243402','kasir',' 1',' MEE1 X LG ','TOKO','PM-E','E1E-ZJXF-314-0','CC X MODEL DAUN SLEP LG 10 8K ','','0.420','1','100.00','424000','0','0','15000','424000','0','0','0','424000','LIS','00428218','E1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZJXF-314-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='E1E-ZJXF-314-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326021243402','2026-11-02','0.420','2026-11-02','12:43:41','PLG0032173','424000','424000','0','424000','424000','kasir','2026-11-02 12:43:40','F32602124340'); 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-11-02','F326021243402','2026-11-02','12:43:41','LIS','424000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261102-0017','D','2026-11-02','12:43:41','kasir','PENJUALAN','F326021243402','8065229000','424000','8065653000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='424000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326021243402' 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 ('F326021243403','kasir',' 1',' MEA1 LG ','TOKO','PM-A','A1E-ZJBH-216-0','AT MODEL BUNGA ARESO LG 8K','','0.580','1','100.00','586000','0','0','15000','586000','0','0','0','586000','LIS','00431985','A1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZJBH-216-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='A1E-ZJBH-216-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326021243403','2026-11-02','0.580','2026-11-02','12:43:41','PLG0032174','586000','586000','0','586000','586000','kasir','2026-11-02 12:43:40','F32602124340'); 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-11-02','F326021243403','2026-11-02','12:43:41','LIS','586000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261102-0018','D','2026-11-02','12:43:41','kasir','PENJUALAN','F326021243403','8065653000','586000','8066239000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='586000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326021243403' 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 ('F326021243404','kasir',' 1',' MEF3E X HW','TOKO','PM-F','F3E-ZJAF-21-0','GL X TIFF RIBBON SLEP HW 8K ','','1.020','1','100.00','1030000','0','0','15000','1030000','0','0','0','1030000','LIS','00430200','F3E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJAF-21-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='F3E-ZJAF-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326021243404','2026-11-02','1.020','2026-11-02','12:43:41','PLG0032175','1030000','1030000','0','1030000','1030000','kasir','2026-11-02 12:43:40','F32602124340'); 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-11-02','F326021243404','2026-11-02','12:43:41','LIS','1030000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261102-0019','D','2026-11-02','12:43:41','kasir','PENJUALAN','F326021243404','8066239000','1030000','8067269000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1030000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326021243404' 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 ('F326021243405','kasir',' 1',' MEH1 UB ','TOKO','PM-H','H1E-ZJBH-173-0','KL TRIXIE MODEL KUPU MATA VAR UB 8K ','','1.440','1','100.00','1454000','0','0','15000','1455000','0','0','0','1455000','LIS','00431939','H1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJBH-173-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='H1E-ZJBH-173-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326021243405','2026-11-02','1.440','2026-11-02','12:43:41','PLG0032176','1455000','1455000','0','1455000','1455000','kasir','2026-11-02 12:43:40','F32602124340'); 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-11-02','F326021243405','2026-11-02','12:43:41','LIS','1455000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261102-0020','D','2026-11-02','12:43:41','kasir','PENJUALAN','F326021243405','8067269000','1455000','8068724000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1455000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326021243405' 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 ('F326021255531','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZCBX-267-0','KL X GUCCI ANAK UB 36 9K ','','2.780','1','100.00','3086000','0','0','15000','3085000','0','0','0','3085000','AAT','00396474','H2J','0','0','-','1','1110000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZCBX-267-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.780',berat_jual_asli=berat_jual_asli+'2.780',stock_jual='1',berat_akhir=berat_akhir-'2.780',berat_akhir_asli=berat_akhir_asli-'2.780',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='H2J-ZCBX-267-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326021255531','2026-11-02','2.780','2026-11-02','12:55:53','PLG0032177','3085000','3085000','0','3085000','3085000','kasir','2026-11-02 12:55:53','F32602125553'); 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-11-02','F326021255531','2026-11-02','12:55:53','AAT','3085000','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-261102-0021','D','2026-11-02','12:55:53','kasir','PENJUALAN','F326021255531','8068724000','3085000','8071809000'); 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-00020721','X-00020721','CC X MODEL MATA CM 14 8K','GR','---','E2D','BELI','BELI001','1255000','2026-11-02','1.350','1','kasir','2026-11-02 13:27:01'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020721','X-00020721'); 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-261102-0007','F326100808421','SIN','1','BELI','BELI001','E2D', 'X-00020721', 'CC X MODEL MATA CM 14 8K','1.350','1.350','100.00','1380000','1255000','929630','1000000','1','1255000','1255000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.350',berat_beli_asli=berat_beli_asli+'1.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.350',berat_akhir_asli=berat_akhir_asli+'1.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-02' 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-261102-0007','2026-11-02','2026-11-02','13:27:00','SIN','---','1.350','1255000','1255000','1255000','1255000','1255000','kasir','2026-11-02 13:27:01','FB-261102-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261102-0007','YANTI','KEPYAR PURWANTORO','','','','kasir','2026-11-02 13:27:01'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-02' 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-261102-0022','K','2026-11-02','13:27:00','kasir','PEMBELIAN UMUM','FB-261102-0007','8071809000','1255000','8070554000'); 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 ('F326020222001','kasir','1',' MEF3E UB ','TOKO','PM-F','F3E-ZJBA-110-0','GL TIFF ISYANA SLEP UB 8K ','','1.570','1','100.00','1586000','0','0','15000','1585000','0','0','0','1585000','AAT','00430747','F3E','0','0','-','1','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJBA-110-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='F3E-ZJBA-110-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326020222001','2026-11-02','1.570','2026-11-02','14:22:00','PLG0032178','1585000','1585000','0','1585000','1585000','kasir','2026-11-02 14:22:00','F32602022200'); 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-11-02','F326020222001','2026-11-02','14:22:00','AAT','1585000','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-261102-0023','D','2026-11-02','14:22:00','kasir','PENJUALAN','F326020222001','8070554000','1585000','8072139000'); 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-00020722','X-00020722','GL X CASTELI ARESO VAR HW 8K','GR','---','F3E','BELI','BELI001','1755000','2026-11-02','1.850','1','kasir','2026-11-02 14:24:52'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020722','X-00020722'); 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-261102-0008','F326220922581','FIT','1','BELI','BELI001','F3E', 'X-00020722', 'GL X CASTELI ARESO VAR HW 8K','1.850','1.850','100.00','2035000','1755000','948649','1020000','1','1755000','1755000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.850',berat_beli_asli=berat_beli_asli+'1.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.850',berat_akhir_asli=berat_akhir_asli+'1.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261102-0008','2026-11-02','2026-11-02','14:24:52','FIT','---','1.850','1755000','1755000','1755000','1755000','1755000','kasir','2026-11-02 14:24:52','FB-261102-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261102-0008','FATMA','TEMON PAGERUKIR SAMPUNG','','','082241800137','kasir','2026-11-02 14:24:52'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-02' 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-261102-0024','K','2026-11-02','14:24:52','kasir','PEMBELIAN UMUM','FB-261102-0008','8072139000','1755000','8070384000'); 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 ('F326020229311','kasir','1',' MDA1D X CM','TOKO','PM-A','A1D-ZJAF-60-0','AT X HUGGIES DAUN KLIP SLEP CM 8K ','','1.010','1','100.00','1000000','0','0','15000','1000000','0','0','0','1000000','FIT','00430239','A1D','0','0','-','0','1000000'); UPDATE tm_barang SET tgl_last_jual='2026-11-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZJAF-60-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-11-02' AND kode_barang='A1D-ZJAF-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326020229311','2026-11-02','1.010','2026-11-02','14:29:32','PLG0032179','1000000','1000000','0','1000000','1000000','kasir','2026-11-02 14:29:31','F32602022931'); 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-11-02','F326020229311','2026-11-02','14:29:32','FIT','1000000','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-261102-0025','D','2026-11-02','14:29:32','kasir','PENJUALAN','F326020229311','8070384000','1000000','8071384000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261102-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261102-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261102-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261102-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261102-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261102-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261102-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261102-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261102-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261102-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261102-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261102-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261102-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261102-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261102-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261102-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020222001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020222001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020222001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020229311' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020229311' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020229311'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020847361' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020847361' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020847361'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021049181' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021049181' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021049181'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021123071' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021123071' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021123071'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021230511' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021230511' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021230511'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021243401' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021243401' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021243401'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021243402' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021243402' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021243402'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021243403' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021243403' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021243403'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021243404' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021243404' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021243404'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021243405' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021243405' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021243405'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021255531' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021255531' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021255531'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-03','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-03'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-02'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-02'; 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-11-02' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-02'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-02'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-02'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-02'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-03' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-02' 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-261103-0001','D','2026-11-03','15:07:13','SYSTEM','SALDO AWAL','SALDO AWAL','0','8071384000','8071384000'); 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-261103-0001','D','2026-11-03','15:07:13','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-261103-0001','D','2026-11-03','15:07:13','DLL','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261103-0001','D','2026-11-03','15:07:13','BCA','SALDO AWAL','SALDO AWAL','0','748085000','748085000'); UPDATE tp_system SET tgl_system='2026-11-03';