INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-13 ','08:45:45'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('jogja','2026-10-13 ','11:28:26'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04573','ADL','1','PLD','WEDDRING','','','3.000','','25.00','1','1200000','550000','0','800000','2450000','sz cwe 10','gf Vintage : Jeffrey..Safitri','warna rosegold','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261013-0001','2026-10-13','2026-10-13 11:31:41','PESANAN : DP-04573','-','TBC','2040000','2040000'); 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-261013-0002','D','2026-10-13','11:31:41','TBC','PESANAN','DP-04573','29328204464','2040000','29330244464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04573','2026-10-13','2026-10-13','11:31:41','PLG0017315','ADL','2026-11-04','jogja','2026-10-13 11:31:41','3.000','0','0','0','2040000','0','800000','2450000','2450000','410000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04574','ADL','1','PLD','WEDDING RING','','','4.000','','25.00','1','1200000','550000','0','1500000','3700000','sz cwo 21','gf Vintage : Jeffrey...Safitri','mix white & rosegold (after glosy)','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261013-0002','2026-10-13','2026-10-13 11:35:28','PESANAN : DP-04574','-','TBC','2960000','2960000'); 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-261013-0003','D','2026-10-13','11:35:28','TBC','PESANAN','DP-04574','29330244464','2960000','29333204464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04574','2026-10-13','2026-10-13','11:35:28','PLG0017316','ADL','2026-11-04','jogja','2026-10-13 11:35:28','4.000','0','0','0','2960000','0','1500000','3700000','3700000','740000'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-13 ','11:42:03'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-13 ','11:42:08'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04575','SAL','1','PER','WED RING','','','2.000','','925.00','1','100000','0','900000','0','900000','sz 19.5 crom kuning glosy 1 zircon','font berkshire swash grf 21.11.26','','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261013-0003','2026-10-13','2026-10-13 11:49:59','PESANAN : DP-04575','.','TBC','900000','900000'); 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-261013-0004','D','2026-10-13','11:49:59','TBC','PESANAN','DP-04575','29333204464','900000','29334104464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04575','2026-10-13','2026-10-13','11:49:59','PLG0017317','SAL','2026-11-10','kasirbip','2026-10-13 11:49:59','2.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','PSPLT-ZJAB-1-0','1','3.130','3.130','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-1-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-1-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-1-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-13 11:56:13' WHERE kode_barang='PSPLT-ZJAB-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAB-1-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 11:56:13','TOKO','BIPPSN','PSPLT','PSPLT-ZJAB-1-0','1','3.130','3.130','1','3.130','3.130','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJAB-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-1-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','PSPRT-ZJAB-2-0','1','4.160','4.160','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-2-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-2-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-2-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-13 11:56:13' WHERE kode_barang='PSPRT-ZJAB-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-2-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 11:56:13','TOKO','BIPPSN','PSPRT','PSPRT-ZJAB-2-0','1','4.160','4.160','1','4.160','4.160','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-2-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','PSPRT-ZJAB-3-0','1','1.330','1.330','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-3-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-3-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-3-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-3-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-13 11:56:13' WHERE kode_barang='PSPRT-ZJAB-3-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-3-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 11:56:13','TOKO','BIPPSN','PSPRT','PSPRT-ZJAB-3-0','1','1.330','1.330','1','1.330','1.330','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-3-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-3-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','PSPLT-ZJAB-4-0','1','1.490','1.490','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-4-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-4-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-4-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-4-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-13 11:56:13' WHERE kode_barang='PSPLT-ZJAB-4-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAB-4-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 11:56:13','TOKO','BIPPSN','PSPLT','PSPLT-ZJAB-4-0','1','1.490','1.490','1','1.490','1.490','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJAB-4-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-4-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','PSPLT-ZJAB-5-0','1','2.300','2.300','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-5-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-5-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-5-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-5-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-13 11:56:13' WHERE kode_barang='PSPLT-ZJAB-5-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAB-5-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 11:56:13','TOKO','BIPPSN','PSPLT','PSPLT-ZJAB-5-0','1','2.300','2.300','1','2.300','2.300','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJAB-5-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-5-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','PSPLT-ZJAB-6-0','1','3.930','3.930','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-6-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-6-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-6-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-6-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-13 11:56:13' WHERE kode_barang='PSPLT-ZJAB-6-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAB-6-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 11:56:13','TOKO','BIPPSN','PSPLT','PSPLT-ZJAB-6-0','1','3.930','3.930','1','3.930','3.930','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJAB-6-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-6-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','PSPRT-ZJAB-16-0','1','5.120','5.120','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-16-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-16-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-16-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-16-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-13 11:56:13' WHERE kode_barang='PSPRT-ZJAB-16-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-16-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 11:56:13','TOKO','BIPPSN','PSPRT','PSPRT-ZJAB-16-0','1','5.120','5.120','1','5.120','5.120','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-16-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-16-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','PSPRT-ZJAB-17-0','1','3.430','3.430','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-17-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-17-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-17-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-17-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-13 11:56:13' WHERE kode_barang='PSPRT-ZJAB-17-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-17-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 11:56:13','TOKO','BIPPSN','PSPRT','PSPRT-ZJAB-17-0','1','3.430','3.430','1','3.430','3.430','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-17-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-17-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','PSPRT-ZJAB-18-0','1','2.300','2.300','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-18-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-18-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-18-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-13 11:56:13' WHERE kode_barang='PSPRT-ZJAB-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-18-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 11:56:13','TOKO','BIPPSN','PSPRT','PSPRT-ZJAB-18-0','1','2.300','2.300','1','2.300','2.300','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-18-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0001','1','PSPRT-ZJAB-19-0','1','3.200','3.200','TOKO','PSNB','TOKO','BIPPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-19-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-19-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-19-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2026-10-13 11:56:13' WHERE kode_barang='PSPRT-ZJAB-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-19-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 11:56:13','TOKO','BIPPSN','PSPRT','PSPRT-ZJAB-19-0','1','3.200','3.200','1','3.200','3.200','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-19-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261013-0001','2026-10-13','11:55','30.390','kasirbip','2026-10-13 11:56:13'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sby','2026-10-13 ','12:19:07'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0001','sby','1',' DP-04083SB','TOKO','SBYPSN','PSPLT-ZJXG-56-0','CINCIN PALADIUM ','','3.520','1','17.00','791000','0','0','17800','1982000','0','0','0','1982000','DIL','00048017','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXG-56-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.520',berat_jual_asli=berat_jual_asli+'3.520',stock_jual='1',berat_akhir=berat_akhir-'3.520',berat_akhir_asli=berat_akhir_asli-'3.520',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PSPLT-ZJXG-56-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0001','2026-10-13','3.520','2026-10-13','12:21:57','PLG0017318','1982000','1982000','0','1982000','0','sby','2026-10-13 12:21:57','FJ-261013-0001','DP-04083','1500000'); 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-13','FJ-261013-0001','2026-10-13','12:21:57','DIL','1982000','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-261013-0004','2026-10-13','2026-10-13 12:21:57','PENJUALAN : FJ-261013-0001','','TBC','482000','482000','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-261013-0005','D','2026-10-13','12:21:57','TBC','PENJUALAN','FJ-261013-0001','29334104464','482000','29334586464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='482000' WHERE no_faktur_jual='FJ-261013-0001' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-13 ','12:23:54'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-13 ','12:24:31'); UPDATE tt_service_head SET tgl_selesai='2026-10-13', status ='DONE' WHERE no_service='SV-02280'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02280'; UPDATE tt_service_head SET tgl_selesai='2026-10-13', status ='DONE' WHERE no_service='SV-02280'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02280'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-13 ','12:29:50'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0002','1','LXPER-ZJAB-26-0','1','1.160','1.160','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJAB-26-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJAB-26-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJAB-26-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJAB-26-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-13 12:34:30' WHERE kode_barang='LXPER-ZJAB-26-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJAB-26-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:34:30','TOKO','DUPERBDG','LXPER','LXPER-ZJAB-26-0','1','1.160','1.160','1','1.160','1.160','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJAB-26-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJAB-26-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0002','1','LXPER-ZJAB-27-0','1','1.620','1.620','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJAB-27-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJAB-27-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJAB-27-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJAB-27-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-13 12:34:30' WHERE kode_barang='LXPER-ZJAB-27-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJAB-27-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:34:30','TOKO','DUPERBDG','LXPER','LXPER-ZJAB-27-0','1','1.620','1.620','1','1.620','1.620','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJAB-27-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJAB-27-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0002','1','LXPER-ZJAB-28-0','1','1.710','1.710','TOKO','DUPER','TOKO','DUPERBDG'); DELETE FROM tm_barang WHERE kode_barang='LXPER-ZJAB-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZJAB-28-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZJAB-28-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZJAB-28-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPERBDG',tgl_last_beli='2026-10-13 12:34:30' WHERE kode_barang='LXPER-ZJAB-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZJAB-28-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:34:30','TOKO','DUPERBDG','LXPER','LXPER-ZJAB-28-0','1','1.710','1.710','1','1.710','1.710','100.00'); DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZJAB-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJAB-28-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261013-0002','2026-10-13','12:33','4.490','kasirbip','2026-10-13 12:34:29'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0003','1','PSPRT-ZJAB-7-0','1','3.560','3.560','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-7-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-7-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-7-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-13 12:35:22' WHERE kode_barang='PSPRT-ZJAB-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-7-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:35:22','TOKO','DUPSN','PSPRT','PSPRT-ZJAB-7-0','1','3.560','3.560','1','3.560','3.560','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-7-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0003','1','PSPLT-ZJAB-8-0','1','1.400','1.400','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-8-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-8-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-8-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-8-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-13 12:35:22' WHERE kode_barang='PSPLT-ZJAB-8-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAB-8-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:35:22','TOKO','DUPSN','PSPLT','PSPLT-ZJAB-8-0','1','1.400','1.400','1','1.400','1.400','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJAB-8-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-8-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0003','1','PSPRT-ZJAB-9-0','1','2.200','2.200','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-9-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-9-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-9-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-9-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-13 12:35:22' WHERE kode_barang='PSPRT-ZJAB-9-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-9-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:35:22','TOKO','DUPSN','PSPRT','PSPRT-ZJAB-9-0','1','2.200','2.200','1','2.200','2.200','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-9-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-9-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0003','1','PSPRT-ZJAB-10-0','1','1.400','1.400','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-10-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-10-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-10-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-13 12:35:22' WHERE kode_barang='PSPRT-ZJAB-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-10-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:35:22','TOKO','DUPSN','PSPRT','PSPRT-ZJAB-10-0','1','1.400','1.400','1','1.400','1.400','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-10-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0003','1','PSPRT-ZJAB-20-0','1','1.810','1.810','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-20-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-20-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-20-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-20-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-13 12:35:22' WHERE kode_barang='PSPRT-ZJAB-20-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-20-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:35:22','TOKO','DUPSN','PSPRT','PSPRT-ZJAB-20-0','1','1.810','1.810','1','1.810','1.810','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-20-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-20-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0003','1','PSPLT-ZJAB-21-0','1','4.290','4.290','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-21-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-21-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-21-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-13 12:35:22' WHERE kode_barang='PSPLT-ZJAB-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-ZJAB-21-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:35:22','TOKO','DUPSN','PSPLT','PSPLT-ZJAB-21-0','1','4.290','4.290','1','4.290','4.290','17.00'); DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-ZJAB-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-21-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0003','1','PSPRT-ZJAB-22-0','1','2.170','2.170','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-22-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-22-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-22-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-13 12:35:22' WHERE kode_barang='PSPRT-ZJAB-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-22-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:35:22','TOKO','DUPSN','PSPRT','PSPRT-ZJAB-22-0','1','2.170','2.170','1','2.170','2.170','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-22-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0003','1','PSGT-ZJAB-23-0','1','2.080','2.080','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSGT-ZJAB-23-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-ZJAB-23-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZJAB-23-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAB-23-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-13 12:35:22' WHERE kode_barang='PSGT-ZJAB-23-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-ZJAB-23-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:35:22','TOKO','DUPSN','PSGT','PSGT-ZJAB-23-0','1','2.080','2.080','1','2.080','2.080','45.00'); DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-ZJAB-23-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAB-23-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261013-0003','1','PSPRT-ZJAB-24-0','1','3.370','3.370','TOKO','DUPSN','TOKO','DUPSN'); DELETE FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-24-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-24-0' LIMIT 1; DELETE FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-24-0'; INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-24-0'; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPSN',tgl_last_beli='2026-10-13 12:35:22' WHERE kode_barang='PSPRT-ZJAB-24-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-ZJAB-24-0' LIMIT 1; INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-13 12:35:22','TOKO','DUPSN','PSPRT','PSPRT-ZJAB-24-0','1','3.370','3.370','1','3.370','3.370','100.00'); DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-ZJAB-24-0'; DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-24-0'; UPDATE tt_beli_detail SET tgl_terima='2026-10-13' WHERE no_faktur_beli=''; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261013-0003','2026-10-13','12:34','22.280','kasirbip','2026-10-13 12:35:22'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0002','kasirbip','1',' DP-04333BI','TOKO','BIPPSN','PSGT-ZJXI-22-0','CINCIN EMAS ','','2.520','1','83.00','4908000','0','0','17800','6370000','0','0','0','6370000','SULIS','00048068','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXI-22-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.520',berat_jual_asli=berat_jual_asli+'2.520',stock_jual='1',berat_akhir=berat_akhir-'2.520',berat_akhir_asli=berat_akhir_asli-'2.520',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PSGT-ZJXI-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0002','2026-10-13','2.520','2026-10-13','12:50:32','PLG0017319','6370000','6370000','0','6370000','0','kasirbip','2026-10-13 12:50:31','FJ-261013-0002','DP-04333','5060000'); 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-13','FJ-261013-0002','2026-10-13','12:50:32','SULIS','6370000','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-261013-0005','2026-10-13','2026-10-13 12:50:31','PENJUALAN : FJ-261013-0002','.','TBC','1310000','1310000','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-261013-0006','D','2026-10-13','12:50:32','TBC','PENJUALAN','FJ-261013-0002','29334586464','1310000','29335896464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1310000' WHERE no_faktur_jual='FJ-261013-0002' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0002' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0002'; UPDATE tt_service_head SET tgl_selesai='2026-10-13', status ='DONE' WHERE no_service='SV-02273'; UPDATE tt_service_detail SET STATUS ='DONE' WHERE no_service='SV-02273'; UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-13', status ='CLOS' WHERE no_service='SV-02273'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02273'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0003','kasir','1',' TFCMR75-84','TOKO','TFCINMAS','TFCMR-YIXD-30-0','THIFA CINCIN MAS RG ','','0.970','1','84.00','1996000','0','0','17800','2061000','0','0','0','2061000','RISIANA','00038548','TFCMR','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YIXD-30-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-10-13' AND kode_barang='TFCMR-YIXD-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0003','2026-10-13','0.970','2026-10-13','13:41:24','PLG0017320','2061000','2061000','0','2061000','0','kasir','2026-10-13 13:41:24','FJ-261013-0003','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-13','FJ-261013-0003','2026-10-13','13:41:24','RISIANA','2061000','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-261013-0006','2026-10-13','2026-10-13 13:41:24','PENJUALAN : FJ-261013-0003','.','TBC','2061000','2061000','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-261013-0007','D','2026-10-13','13:41:24','TBC','PENJUALAN','FJ-261013-0003','29335896464','2061000','29337957464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2061000' WHERE no_faktur_jual='FJ-261013-0003' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-13 ','14:16:34'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0004','kasirbip','1',' 750K-13 ','TOKO','DUCM','LXCM-ZEXA-98-0','LUXIA CINCIN MAS SR-01 ','','1.270','1','45.00','1400000','0','0','17800','2528000','0','0','0','2528000','PUT','00043120','LXCM','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXCM-ZEXA-98-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='LXCM-ZEXA-98-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUCM' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0004','2026-10-13','1.270','2026-10-13','14:18:02','PLG0017321','2528000','2528000','0','2528000','0','kasirbip','2026-10-13 14:18:02','FJ-261013-0004','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-13','FJ-261013-0004','2026-10-13','14:18:02','PUT','2528000','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-261013-0007','2026-10-13','2026-10-13 14:18:02','PENJUALAN : FJ-261013-0004','.','TBC','2528000','2528000','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-261013-0008','D','2026-10-13','14:18:02','TBC','PENJUALAN','FJ-261013-0004','29337957464','2528000','29340485464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2528000' WHERE no_faktur_jual='FJ-261013-0004' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0003' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0004' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0004'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-13 ','14:56:37'); UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-13', status ='CLOS' WHERE no_service='SV-02258'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02258'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-10-13 ','15:28:17'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04576','ALIKA','1','PLD','WEDING RING','','','3.500','','10.00','1','1200000','350000','0','900000','2125000','size 19 grf Y ? L 22 - 11 - 2026','crom putih doff semprot','zircone 21 btr','0','0','210000'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261013-0008','2026-10-13','2026-10-13 15:38:39','PESANAN : DP-04576','0','TBC','1868000','1868000'); 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-261013-0009','D','2026-10-13','15:38:39','TBC','PESANAN','DP-04576','29340485464','1868000','29342353464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04576','2026-10-13','2026-10-13','15:38:39','PLG0017322','ALIKA','2026-11-05','kasir','2026-10-13 15:38:39','3.500','0','0','0','1868000','0','900000','2335000','2335000','467000'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04577','ALIKA','1','PER','WEDING RING','','','4.000','','925.00','1','100000','0','0','0','1050000','size 25 grf Y ? L 22 - 11 - 2026','CROM PUTIH GLOSY LIST TENGAH DOFF SEMPROT SETENGAH','TANPA PERMATA','0','0',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261013-0009','2026-10-13','2026-10-13 15:47:26','PESANAN : DP-04577','.','TBC','1050000','1050000'); 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-261013-0010','D','2026-10-13','15:47:26','TBC','PESANAN','DP-04577','29342353464','1050000','29343403464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04577','2026-10-13','2026-10-13','15:47:26','PLG0017323','ALIKA','2026-11-05','kasir','2026-10-13 15:47:26','4.000','0','0','0','1050000','0','0','1050000','1050000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0005','kasirbip','1',' 750K-175-2','TOKO','BIPPER','PBDG-ZGXF-53-0','CINCIN SILVER 925 ','','2.330','1','100.00','238000','0','0','17800','850000','0','0','0','850000','SULIS','00044981','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZGXF-53-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PBDG-ZGXF-53-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0005','2026-10-13','2.330','2026-10-13','16:01:39','PLG0017324','850000','850000','0','850000','0','kasirbip','2026-10-13 16:01:39','FJ-261013-0005','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-13','FJ-261013-0005','2026-10-13','16:01:39','SULIS','850000','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-261013-0010','2026-10-13','2026-10-13 16:01:39','PENJUALAN : FJ-261013-0005','.','TBC','850000','850000','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-261013-0011','D','2026-10-13','16:01:39','TBC','PENJUALAN','FJ-261013-0005','29343403464','850000','29344253464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261013-0005' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0006','kasir','1',' DP-03643MM','TOKO','MMPSN','PSPRT-ZIAF-77-0','CINCIN PERAK YL01 ','','3.310','1','100.00','338000','0','0','17800','850000','0','0','0','850000','ALIKA','00047309','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZIAF-77-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.310',berat_jual_asli=berat_jual_asli+'3.310',stock_jual='1',berat_akhir=berat_akhir-'3.310',berat_akhir_asli=berat_akhir_asli-'3.310',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PSPRT-ZIAF-77-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0006','2026-10-13','3.310','2026-10-13','16:14:54','PLG0017325','850000','850000','0','850000','0','kasir','2026-10-13 16:14:53','FJ-261013-0006','DP-03643','850000'); 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-13','FJ-261013-0006','2026-10-13','16:14:54','ALIKA','850000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261013-0006' LIMIT 1; INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04578','SULIS','1','PER','WED RING','','','4.000','','925.00','1','100000','0','1400000','0','1400000','cwe sz 11.5','cwo sz 20 UPSIZE 100.000','font keduanya berkshire swash grf I & R','0','',''); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261013-0011','2026-10-13','2026-10-13 16:31:04','PESANAN : DP-04578','.','TBC','1400000','1400000'); 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-261013-0012','D','2026-10-13','16:31:04','TBC','PESANAN','DP-04578','29344253464','1400000','29345653464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04578','2026-10-13','2026-10-13','16:31:04','PLG0017326','SULIS','2026-10-30','kasirbip','2026-10-13 16:31:04','4.000','0','0','0','1400000','0','0','1400000','1400000','0'); UPDATE tt_service_head SET dibayar_rp=dibayar_rp+'0',debet_rp = debet_rp+'0', card_rp=card_rp+'0',card_fee_rp=card_fee_rp+'0', transfer_rp='0',sld_akhir_rp=sld_akhir_rp-'0', tgl_ambil='2026-10-13', status ='CLOS' WHERE no_service='SV-02282'; UPDATE tt_service_detail SET status='CLOS' WHERE no_service='SV-02282'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0007','kasirbip','1',' 700K-16-00','TOKO','DUPERBDG','LXPER-ZDXG-49-0','CINCIN SILVER 925 ','','4.220','1','100.00','431000','0','0','17800','900000','0','0','0','900000','PUT','00042364','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZDXG-49-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.220',berat_jual_asli=berat_jual_asli+'4.220',stock_jual='1',berat_akhir=berat_akhir-'4.220',berat_akhir_asli=berat_akhir_asli-'4.220',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='LXPER-ZDXG-49-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0007','2026-10-13','4.220','2026-10-13','16:56:50','PLG0017327','900000','900000','0','900000','0','kasirbip','2026-10-13 16:56:50','FJ-261013-0007','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-13','FJ-261013-0007','2026-10-13','16:56:50','PUT','900000','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-261013-0012','2026-10-13','2026-10-13 16:56:50','PENJUALAN : FJ-261013-0007','.','TBC','900000','900000','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-261013-0013','D','2026-10-13','16:56:50','TBC','PENJUALAN','FJ-261013-0007','29345653464','900000','29346553464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='900000' WHERE no_faktur_jual='FJ-261013-0007' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0008','kasirbip',' 1',' 750K-12-00','TOKO','DUPERBDG','LXPER-ZJAB-26-0','CINCIN SILVER 925 ','','1.160','1','100.00','119000','0','0','17800','850000','0','0','0','850000','PUT','00048109','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZJAB-26-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='LXPER-ZJAB-26-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0008','2026-10-13','1.160','2026-10-13','16:56:50','PLG0017328','850000','850000','0','850000','0','kasirbip','2026-10-13 16:56:50','FJ-261013-0007','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-13','FJ-261013-0008','2026-10-13','16:56:50','PUT','850000','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-261013-0013','2026-10-13','2026-10-13 16:56:50','PENJUALAN : FJ-261013-0008','.','TBC','850000','850000','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-261013-0014','D','2026-10-13','16:56:50','TBC','PENJUALAN','FJ-261013-0008','29346553464','850000','29347403464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1750000' WHERE no_faktur_jual='FJ-261013-0008' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0009','kasirbip','1',' 750K-16-00','TOKO','DUPERBDG','LXPER-ZIXC-29-0','CINCIN SILVER 925 ','','1.820','1','100.00','186000','0','0','17800','850000','0','0','0','850000','PUT','00046859','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZIXC-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='LXPER-ZIXC-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0009','2026-10-13','1.820','2026-10-13','17:03:32','PLG0017329','850000','850000','0','850000','0','kasirbip','2026-10-13 17:03:31','FJ-261013-0009','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-13','FJ-261013-0009','2026-10-13','17:03:32','PUT','850000','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-261013-0014','2026-10-13','2026-10-13 17:03:31','PENJUALAN : FJ-261013-0009','.','TBC','850000','850000','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-261013-0015','D','2026-10-13','17:03:32','TBC','PENJUALAN','FJ-261013-0009','29347403464','850000','29348253464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='850000' WHERE no_faktur_jual='FJ-261013-0009' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0010','kasirbip',' 1',' 750K-165-0','TOKO','DUPERBDG','LXPER-ZFAB-65-0','CINCIN SILVER 925 ','','1.980','1','100.00','202000','0','0','17800','850000','0','0','0','850000','PUT','00044389','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAB-65-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='LXPER-ZFAB-65-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0010','2026-10-13','1.980','2026-10-13','17:03:32','PLG0017330','850000','850000','0','850000','0','kasirbip','2026-10-13 17:03:31','FJ-261013-0009','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-13','FJ-261013-0010','2026-10-13','17:03:32','PUT','850000','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-261013-0015','2026-10-13','2026-10-13 17:03:31','PENJUALAN : FJ-261013-0010','.','TBC','850000','850000','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-261013-0016','D','2026-10-13','17:03:32','TBC','PENJUALAN','FJ-261013-0010','29348253464','850000','29349103464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1700000' WHERE no_faktur_jual='FJ-261013-0010' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0005' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0005'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0006' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0006'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0007' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0007'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0008' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0009' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0009'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0010' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0010'; 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-00000391','X-00000391','CINCIN TFC-21425','GR','---','TFC','BELI','BELI001','6080000','2026-10-13','2.570','1','kasir','2026-10-13 17:33:15'); DELETE FROM tp_barang WHERE kode_dept = 'X-TFC'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-TFC','X-00000391','X-00000391'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261013-0001','FJ-241228-0004','ILUNG','1','BELI','BELI001','TFC', 'X-00000391', 'CINCIN TFC-21425','2.570','2.570','83.00','7600000','6080000','2365759','1','6080000','6080000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.570',berat_beli_asli=berat_beli_asli+'2.570',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.570',berat_akhir_asli=berat_akhir_asli+'2.570',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='TFC' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid,type_bayar) VALUES ('FB-261013-0001','2026-10-13','2026-10-13','17:33:15','ILUNG','---','2.570','6080000','6080000','6080000','6080000','6080000','kasir','2026-10-13 17:33:15','FB-261013-0001','OPEN','TRANSFER'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261013-0001','TIARA','JKT','','JKT','0','kasir','2026-10-13 17:33:15'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261013-0016','2026-10-13','2026-10-13 17:33:15','PEMBELIAN UMUM : FB-261013-0001','.','TBC','6080000','6080000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-261013-0017','K','2026-10-13','17:33:15','TBC','PEMBELIAN UMUM','FB-261013-0001','29349103464','6080000','29343023464','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.',''); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi=''; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261013-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261013-0001'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0011','sby','1',' DP-04106SB','TOKO','SBYPSN','PSPLT-ZJXG-54-0','CINCIN PALADIUM YL10 ','','3.560','1','17.00','800000','0','0','17800','1946000','0','0','0','1946000','DIL','00048015','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJXG-54-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.560',berat_jual_asli=berat_jual_asli+'3.560',stock_jual='1',berat_akhir=berat_akhir-'3.560',berat_akhir_asli=berat_akhir_asli-'3.560',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PSPLT-ZJXG-54-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0011','2026-10-13','3.560','2026-10-13','17:41:58','PLG0017331','1946000','1946000','0','1946000','0','sby','2026-10-13 17:41:57','FJ-261013-0011','DP-04106','1400000'); 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-13','FJ-261013-0011','2026-10-13','17:41:58','DIL','1946000','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-261013-0017','2026-10-13','2026-10-13 17:41:57','PENJUALAN : FJ-261013-0011','','TBC','1946000','1946000','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-261013-0018','D','2026-10-13','17:41:58','TBC','PENJUALAN','FJ-261013-0011','29343023464','1946000','29344969464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('',''); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1946000' WHERE no_faktur_jual='FJ-261013-0011' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0012','sby',' 1',' DP-04107SB','TOKO','SBYPSN','PSGT-ZJXI-29-0','CINCIN EMAS ','','5.000','1','45.00','5279000','0','0','17800','8210000','0','0','0','8210000','DIL','00048075','PSGT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-ZJXI-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.000',berat_jual_asli=berat_jual_asli+'5.000',stock_jual='1',berat_akhir=berat_akhir-'5.000',berat_akhir_asli=berat_akhir_asli-'5.000',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PSGT-ZJXI-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0012','2026-10-13','5.000','2026-10-13','17:41:58','PLG0017332','8210000','8210000','0','8210000','0','sby','2026-10-13 17:41:57','FJ-261013-0011','DP-04107','5600000'); 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-13','FJ-261013-0012','2026-10-13','17:41:58','DIL','8210000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1946000' WHERE no_faktur_jual='FJ-261013-0012' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0013','kasirbip','1',' DP-04225DU','TOKO','DUPSN','PSPRT-ZJXF-18-0','CINCIN PERAK SR02 YL01 ','','3.580','1','100.00','366000','0','0','17800','1050000','0','0','0','1050000','PUT','00047946','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXF-18-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.580',berat_jual_asli=berat_jual_asli+'3.580',stock_jual='1',berat_akhir=berat_akhir-'3.580',berat_akhir_asli=berat_akhir_asli-'3.580',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PSPRT-ZJXF-18-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0013','2026-10-13','3.580','2026-10-13','18:08:59','PLG0017333','1050000','1050000','0','1050000','0','kasirbip','2026-10-13 18:08:58','FJ-261013-0013','DP-04225','1050000'); 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-13','FJ-261013-0013','2026-10-13','18:08:59','PUT','1050000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261013-0013' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0014','kasirbip','1',' 750K-125-0','TOKO','DUPERBDG','LXPER-ZGXF-75-0','CINCIN SILVER 925 ','','1.710','1','100.00','175000','0','0','17800','700000','0','0','0','700000','PUT','00045003','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZGXF-75-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='LXPER-ZGXF-75-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0014','2026-10-13','1.710','2026-10-13','19:01:45','PLG0017334','700000','700000','0','700000','0','kasirbip','2026-10-13 19:01:44','FJ-261013-0014','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-13','FJ-261013-0014','2026-10-13','19:01:45','PUT','700000','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-261013-0018','2026-10-13','2026-10-13 19:01:44','PENJUALAN : FJ-261013-0014','.','TBC','700000','700000','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-261013-0019','D','2026-10-13','19:01:45','TBC','PENJUALAN','FJ-261013-0014','29344969464','700000','29345669464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-261013-0014' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0015','kasirbip',' 1',' 750K-105-0','TOKO','DUPERBDG','LXPER-ZFAF-46-0','CINCIN SILVER 925 ','','1.700','1','100.00','174000','0','0','17800','700000','0','0','0','700000','PUT','00044476','LXPER','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='LXPER-ZFAF-46-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='LXPER-ZFAF-46-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='DUPERBDG' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0015','2026-10-13','1.700','2026-10-13','19:01:45','PLG0017335','700000','700000','0','700000','0','kasirbip','2026-10-13 19:01:44','FJ-261013-0014','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-13','FJ-261013-0015','2026-10-13','19:01:45','PUT','700000','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-261013-0019','2026-10-13','2026-10-13 19:01:44','PENJUALAN : FJ-261013-0015','.','TBC','700000','700000','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-261013-0020','D','2026-10-13','19:01:45','TBC','PENJUALAN','FJ-261013-0015','29345669464','700000','29346369464','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1400000' WHERE no_faktur_jual='FJ-261013-0015' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0012' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0013' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0013'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0014' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0015' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0015' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0015'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0016','kasirbip','1',' DP-04456BI','TOKO','BIPPSN','PSPLT-ZJAB-6-0','CINCIN PALADIUM ','','3.930','1','17.00','883000','0','0','17800','2175500','0','0','0','2175500','KUR','00048089','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAB-6-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.930',berat_jual_asli=berat_jual_asli+'3.930',stock_jual='1',berat_akhir=berat_akhir-'3.930',berat_akhir_asli=berat_akhir_asli-'3.930',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PSPLT-ZJAB-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0016','2026-10-13','3.930','2026-10-13','19:04:40','PLG0017336','2175500','2175500','0','2175500','0','kasirbip','2026-10-13 19:04:39','FJ-261013-0016','DP-04456','1760000'); 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-13','FJ-261013-0016','2026-10-13','19:04:40','KUR','2175500','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-261013-0020','2026-10-13','2026-10-13 19:04:39','PENJUALAN : FJ-261013-0016','.','TBC','415500','415500','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-261013-0021','D','2026-10-13','19:04:40','TBC','PENJUALAN','FJ-261013-0016','29346369464','415500','29346784964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='415500' WHERE no_faktur_jual='FJ-261013-0016' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0017','kasirbip',' 1',' DP-04454BI','TOKO','BIPPSN','PSPLT-ZJAB-5-0','CINCIN PALADIUM ','','2.300','1','17.00','517000','0','0','17800','1835000','0','0','0','1835000','KUR','00048088','PSPLT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-ZJAB-5-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.300',berat_jual_asli=berat_jual_asli+'2.300',stock_jual='1',berat_akhir=berat_akhir-'2.300',berat_akhir_asli=berat_akhir_asli-'2.300',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PSPLT-ZJAB-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0017','2026-10-13','2.300','2026-10-13','19:04:40','PLG0017337','1835000','1835000','0','1835000','0','kasirbip','2026-10-13 19:04:39','FJ-261013-0016','DP-04454','1660000'); 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-13','FJ-261013-0017','2026-10-13','19:04:40','KUR','1835000','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-261013-0021','2026-10-13','2026-10-13 19:04:39','PENJUALAN : FJ-261013-0017','.','TBC','175000','175000','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-261013-0022','D','2026-10-13','19:04:40','TBC','PENJUALAN','FJ-261013-0017','29346784964','175000','29346959964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='590500' WHERE no_faktur_jual='FJ-261013-0017' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0016' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0016' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0016'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0017' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0017' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0017'; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0018','sby','1',' DP-04161SB','TOKO','SBYPSN','PSPRT-ZJXI-33-0','1PS CINCIN PERAK ','','4.910','1','100.00','501000','0','0','17800','1400000','0','0','0','1400000','DIL','00048079','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXI-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.910',berat_jual_asli=berat_jual_asli+'4.910',stock_jual='1',berat_akhir=berat_akhir-'4.910',berat_akhir_asli=berat_akhir_asli-'4.910',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PSPRT-ZJXI-33-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0018','2026-10-13','4.910','2026-10-13','19:28:40','PLG0017338','1400000','1400000','0','1400000','0','sby','2026-10-13 19:28:40','FJ-261013-0018','DP-04161','1400000'); 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-13','FJ-261013-0018','2026-10-13','19:28:40','DIL','1400000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261013-0018' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0018' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0018' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0018'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-13 ','20:02:18'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-10-13 ','20:05:14'); INSERT INTO tt_persekot_detail(no_persekot,sales_id,no_urut,kode_group,deskripsi_short,nama_atribut,deskripsi,berat,kadar,kadar_cetak,qty,harga_skrg,harga,harga_atribut,ongkos_detail,jml_detail_rp,berlian1,berlian2,berlian3,berlian_rp1,berlian_rp2,berlian_rp3) VALUES ('DP-04579','DIL','1','PER','WEDD RING CUSTOM','','','3.000','','925.00','1','100000','0','900000','0','900000','TANPA PERMATA (LEBAR 4MM)','SIZE 26 GRF: B ?? R 04.04 (VINTAGE)','PUTIH GLOSSY','0','0','0'); INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-261013-0022','2026-10-13','2026-10-13 20:25:12','PESANAN : DP-04579','-','TBC','900000','900000'); 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-261013-0023','D','2026-10-13','20:25:12','TBC','PESANAN','DP-04579','29346959964','900000','29347859964','TRANSFER'); INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('-','0^D'); INSERT INTO tt_persekot_head(no_persekot,tgl_system,tgl_persekot,jam_persekot,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,debet_rp,card_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,jml_akhir_rp,sld_akhir_rp) VALUES ('DP-04579','2026-10-13','2026-10-13','20:25:12','PLG0017339','DIL','2026-11-07','sby','2026-10-13 20:25:12','3.000','0','0','0','900000','0','0','900000','900000','0'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0019','sby','1',' DP-04157SB','TOKO','SBYPSN','PSPRT-ZJXI-32-0','1PS CINCIN PERAK ','','3.970','1','100.00','405000','0','0','17800','1200000','0','0','0','1200000','DIL','00048078','PSPRT','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-ZJXI-32-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.970',berat_jual_asli=berat_jual_asli+'3.970',stock_jual='1',berat_akhir=berat_akhir-'3.970',berat_akhir_asli=berat_akhir_asli-'3.970',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PSPRT-ZJXI-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SBYPSN' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0019','2026-10-13','3.970','2026-10-13','20:26:36','PLG0017340','1200000','1200000','0','1200000','0','sby','2026-10-13 20:26:35','FJ-261013-0019','DP-04157','1200000'); 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-13','FJ-261013-0019','2026-10-13','20:26:36','DIL','1200000','0'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-261013-0019' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-261013-0020','kasirbip','1',' 800K-27-30','TOKO','BIPPER','PBDG-ZIBI-14-0','CINCIN SILVER 925 YL10 ','','5.390','1','100.00','550000','0','0','17800','950000','0','0','0','950000','SAL','00047753','PBDG','0','0','-','0',''); UPDATE tm_barang SET tgl_last_jual='2026-10-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZIBI-14-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.390',berat_jual_asli=berat_jual_asli+'5.390',stock_jual='1',berat_akhir=berat_akhir-'5.390',berat_akhir_asli=berat_akhir_asli-'5.390',stock_akhir='0' WHERE tanggal='2026-10-13' AND kode_barang='PBDG-ZIBI-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-261013-0020','2026-10-13','5.390','2026-10-13','20:47:32','PLG0017341','950000','950000','0','950000','0','kasirbip','2026-10-13 20:47:31','FJ-261013-0020','','POTONG'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-13','FJ-261013-0020','2026-10-13','20:47:32','SAL','950000','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-261013-0023','2026-10-13','2026-10-13 20:47:31','PENJUALAN : FJ-261013-0020','.','TBC','950000','950000','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-261013-0024','D','2026-10-13','20:47:32','TBC','PENJUALAN','FJ-261013-0020','29347859964','950000','29348809964','TRANSFER'); INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.'); UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='950000' WHERE no_faktur_jual='FJ-261013-0020' LIMIT 1; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0019' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0019' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0019'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0020' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-261013-0020' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-261013-0020'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-14','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-13'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-13'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-13'; 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-13' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-13'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-13'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-13'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-13'; 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-14' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-13' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261014-0001','D','2026-10-14','21:09:39','TBC','SALDO AWAL','SALDO AWAL','0','29348809964','29348809964'); 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-261014-0001','D','2026-10-14','21:09:39','TMR','SALDO AWAL','SALDO AWAL','0','32261000','32261000'); 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-261014-0001','D','2026-10-14','21:09:39','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000'); 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-261014-0001','D','2026-10-14','21:09:39','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000'); 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-261014-0001','D','2026-10-14','21:09:39','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000'); 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-261014-0001','D','2026-10-14','21:09:39','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000'); 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-261014-0001','D','2026-10-14','21:09:39','','SALDO AWAL','SALDO AWAL','0','250000','250000'); 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-261014-0001','D','2026-10-14','21:09:39','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000'); 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-261014-0001','D','2026-10-14','21:09:39','KET','SALDO AWAL','SALDO AWAL','0','148146000','148146000'); 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-261014-0001','D','2026-10-14','21:09:39','BCK','SALDO AWAL','SALDO AWAL','0','2043408000','2043408000'); 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-261014-0001','D','2026-10-14','21:09:39','BCD','SALDO AWAL','SALDO AWAL','0','1465961500','1465961500'); 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-261014-0001','D','2026-10-14','21:09:39','SHO','SALDO AWAL','SALDO AWAL','0','145485650','145485650'); UPDATE tp_system SET tgl_system='2026-10-14';