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-20261017-0001','1','A1D-ZJAF-60-0','1','1.010','1.010','TOKO','PMBK-A','TOKO','PM-A'); DELETE FROM tm_barang WHERE kode_barang='A1D-ZJAF-60-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZJAF-60-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-17 08:15:16' WHERE kode_barang='A1D-ZJAF-60-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZJAF-60-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-17 08:15:16','TOKO','PM-A','A1D','A1D-ZJAF-60-0','1','1.010','1.010','1','1.010','1.010','100.00'); DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZJAF-60-0'; DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZJAF-60-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-20261017-0001','1','A1D-ZJAF-63-0','1','1.160','1.160','TOKO','PMBK-A','TOKO','PM-A'); DELETE FROM tm_barang WHERE kode_barang='A1D-ZJAF-63-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZJAF-63-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-17 08:15:16' WHERE kode_barang='A1D-ZJAF-63-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZJAF-63-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-17 08:15:16','TOKO','PM-A','A1D','A1D-ZJAF-63-0','1','1.160','1.160','1','1.160','1.160','100.00'); DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZJAF-63-0'; DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZJAF-63-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-20261017-0001','1','A1E-ZJAF-67-0','1','0.560','0.560','TOKO','PMBK-A','TOKO','PM-A'); DELETE FROM tm_barang WHERE kode_barang='A1E-ZJAF-67-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZJAF-67-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-17 08:15:16' WHERE kode_barang='A1E-ZJAF-67-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZJAF-67-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-17 08:15:16','TOKO','PM-A','A1E','A1E-ZJAF-67-0','1','0.560','0.560','1','0.560','0.560','100.00'); DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZJAF-67-0'; DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZJAF-67-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-20261017-0001','1','A1D-ZJAF-73-0','1','0.860','0.860','TOKO','PMBK-A','TOKO','PM-A'); DELETE FROM tm_barang WHERE kode_barang='A1D-ZJAF-73-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZJAF-73-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-17 08:15:16' WHERE kode_barang='A1D-ZJAF-73-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZJAF-73-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-17 08:15:16','TOKO','PM-A','A1D','A1D-ZJAF-73-0','1','0.860','0.860','1','0.860','0.860','100.00'); DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZJAF-73-0'; DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZJAF-73-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261017-0001','2026-10-17','08:15','3.590','admpindah','2026-10-17 08:15:15'); 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-20261017-0001','1','D2E-ZIAI-170-0','1','0.450','0.450','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D2E-ZIAI-170-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZIAI-170-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-17 08:15:39' WHERE kode_barang='D2E-ZIAI-170-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZIAI-170-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-17 08:15:39','TOKO','PM-D','D2E','D2E-ZIAI-170-0','1','0.450','0.450','1','0.450','0.450','100.00'); DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZIAI-170-0'; DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZIAI-170-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-20261017-0001','1','D2E-ZJAF-102-0','1','0.520','0.520','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D2E-ZJAF-102-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZJAF-102-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-17 08:15:39' WHERE kode_barang='D2E-ZJAF-102-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZJAF-102-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-17 08:15:39','TOKO','PM-D','D2E','D2E-ZJAF-102-0','1','0.520','0.520','1','0.520','0.520','100.00'); DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZJAF-102-0'; DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZJAF-102-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261017-0001','2026-10-17','08:15','0.970','admpindah','2026-10-17 08:15:39'); 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-20261017-0001','1','E1F-ZJXF-324-0','1','0.360','0.360','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXF-324-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXF-324-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E1F-ZJXF-324-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXF-324-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-17 08:16:03','TOKO','PM-E','E1F','E1F-ZJXF-324-0','1','0.360','0.360','1','0.360','0.360','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXF-324-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXF-324-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-20261017-0001','1','E2D-ZJAF-133-0','1','0.970','0.970','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJAF-133-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-133-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2D-ZJAF-133-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJAF-133-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-17 08:16:03','TOKO','PM-E','E2D','E2D-ZJAF-133-0','1','0.970','0.970','1','0.970','0.970','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJAF-133-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-133-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-20261017-0001','1','E2D-ZJAF-144-0','1','1.920','1.920','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJAF-144-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-144-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2D-ZJAF-144-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJAF-144-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-17 08:16:03','TOKO','PM-E','E2D','E2D-ZJAF-144-0','1','1.920','1.920','1','1.920','1.920','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJAF-144-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-144-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-20261017-0001','1','E2E-ZJAF-157-0','1','0.800','0.800','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZJAF-157-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-157-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2E-ZJAF-157-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJAF-157-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-17 08:16:03','TOKO','PM-E','E2E','E2E-ZJAF-157-0','1','0.800','0.800','1','0.800','0.800','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJAF-157-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-157-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-20261017-0001','1','E2E-ZJAF-160-0','1','0.800','0.800','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZJAF-160-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-160-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2E-ZJAF-160-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJAF-160-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-17 08:16:03','TOKO','PM-E','E2E','E2E-ZJAF-160-0','1','0.800','0.800','1','0.800','0.800','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJAF-160-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-160-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-20261017-0001','1','E2E-ZJAF-170-0','1','0.760','0.760','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZJAF-170-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-170-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2E-ZJAF-170-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJAF-170-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-17 08:16:03','TOKO','PM-E','E2E','E2E-ZJAF-170-0','1','0.760','0.760','1','0.760','0.760','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJAF-170-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-170-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-20261017-0001','1','E2D-ZJAF-171-0','1','0.950','0.950','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJAF-171-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-171-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2D-ZJAF-171-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJAF-171-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-17 08:16:03','TOKO','PM-E','E2D','E2D-ZJAF-171-0','1','0.950','0.950','1','0.950','0.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJAF-171-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-171-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-20261017-0001','1','E2D-ZJAF-177-0','1','1.090','1.090','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJAF-177-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-177-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2D-ZJAF-177-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJAF-177-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-17 08:16:03','TOKO','PM-E','E2D','E2D-ZJAF-177-0','1','1.090','1.090','1','1.090','1.090','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJAF-177-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-177-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-20261017-0001','1','E2D-ZJAF-188-0','1','0.980','0.980','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJAF-188-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-188-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2D-ZJAF-188-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJAF-188-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-17 08:16:03','TOKO','PM-E','E2D','E2D-ZJAF-188-0','1','0.980','0.980','1','0.980','0.980','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJAF-188-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-188-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-20261017-0001','1','E2D-ZJAF-189-0','1','1.280','1.280','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJAF-189-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-189-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2D-ZJAF-189-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJAF-189-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-17 08:16:03','TOKO','PM-E','E2D','E2D-ZJAF-189-0','1','1.280','1.280','1','1.280','1.280','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJAF-189-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-189-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-20261017-0001','1','E2D-ZJAF-198-0','1','1.020','1.020','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJAF-198-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-198-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2D-ZJAF-198-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJAF-198-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-17 08:16:03','TOKO','PM-E','E2D','E2D-ZJAF-198-0','1','1.020','1.020','1','1.020','1.020','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJAF-198-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-198-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-20261017-0001','1','E2E-ZJAF-206-0','1','0.510','0.510','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZJAF-206-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-206-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2E-ZJAF-206-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJAF-206-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-17 08:16:03','TOKO','PM-E','E2E','E2E-ZJAF-206-0','1','0.510','0.510','1','0.510','0.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJAF-206-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-206-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-20261017-0001','1','E2E-ZJAF-207-0','1','0.660','0.660','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZJAF-207-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-207-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2E-ZJAF-207-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJAF-207-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-17 08:16:03','TOKO','PM-E','E2E','E2E-ZJAF-207-0','1','0.660','0.660','1','0.660','0.660','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJAF-207-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-207-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-20261017-0001','1','E2E-ZJAF-209-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2E-ZJAF-209-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-209-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E2E-ZJAF-209-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJAF-209-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-17 08:16:03','TOKO','PM-E','E2E','E2E-ZJAF-209-0','1','0.520','0.520','1','0.520','0.520','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJAF-209-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJAF-209-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-20261017-0001','1','E1D-ZJAF-218-0','1','2.030','2.030','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZJAF-218-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-218-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E1D-ZJAF-218-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZJAF-218-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-17 08:16:03','TOKO','PM-E','E1D','E1D-ZJAF-218-0','1','2.030','2.030','1','2.030','2.030','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZJAF-218-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-218-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-20261017-0001','1','E1D-ZJAF-219-0','1','1.780','1.780','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZJAF-219-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-219-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E1D-ZJAF-219-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZJAF-219-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-17 08:16:03','TOKO','PM-E','E1D','E1D-ZJAF-219-0','1','1.780','1.780','1','1.780','1.780','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZJAF-219-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-219-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-20261017-0001','1','E1D-ZJAF-230-0','1','1.150','1.150','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZJAF-230-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-230-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E1D-ZJAF-230-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZJAF-230-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-17 08:16:03','TOKO','PM-E','E1D','E1D-ZJAF-230-0','1','1.150','1.150','1','1.150','1.150','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZJAF-230-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-230-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-20261017-0001','1','E1D-ZJAF-231-0','1','0.920','0.920','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZJAF-231-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-231-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E1D-ZJAF-231-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZJAF-231-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-17 08:16:03','TOKO','PM-E','E1D','E1D-ZJAF-231-0','1','0.920','0.920','1','0.920','0.920','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZJAF-231-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-231-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-20261017-0001','1','E1D-ZJAF-235-0','1','1.020','1.020','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZJAF-235-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-235-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E1D-ZJAF-235-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZJAF-235-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-17 08:16:03','TOKO','PM-E','E1D','E1D-ZJAF-235-0','1','1.020','1.020','1','1.020','1.020','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZJAF-235-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-235-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-20261017-0001','1','E1D-ZJAF-237-0','1','1.000','1.000','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZJAF-237-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-237-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E1D-ZJAF-237-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZJAF-237-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-17 08:16:03','TOKO','PM-E','E1D','E1D-ZJAF-237-0','1','1.000','1.000','1','1.000','1.000','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZJAF-237-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-237-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-20261017-0001','1','E1D-ZJAF-238-0','1','1.010','1.010','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZJAF-238-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-238-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E1D-ZJAF-238-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZJAF-238-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-17 08:16:03','TOKO','PM-E','E1D','E1D-ZJAF-238-0','1','1.010','1.010','1','1.010','1.010','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZJAF-238-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZJAF-238-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-20261017-0001','1','E1E-ZJAF-240-0','1','0.560','0.560','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZJAF-240-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJAF-240-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E1E-ZJAF-240-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJAF-240-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-17 08:16:03','TOKO','PM-E','E1E','E1E-ZJAF-240-0','1','0.560','0.560','1','0.560','0.560','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZJAF-240-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJAF-240-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-20261017-0001','1','E1E-ZJAF-242-0','1','0.700','0.700','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZJAF-242-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJAF-242-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-17 08:16:03' WHERE kode_barang='E1E-ZJAF-242-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJAF-242-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-17 08:16:03','TOKO','PM-E','E1E','E1E-ZJAF-242-0','1','0.700','0.700','1','0.700','0.700','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZJAF-242-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJAF-242-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261017-0001','2026-10-17','08:15','22.790','admpindah','2026-10-17 08:16:02'); 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-20261017-0001','1','F1E-ZJXF-194-0','1','2.180','2.180','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZJXF-194-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJXF-194-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-17 08:16:30' WHERE kode_barang='F1E-ZJXF-194-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJXF-194-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-17 08:16:30','TOKO','PM-F','F1E','F1E-ZJXF-194-0','1','2.180','2.180','1','2.180','2.180','100.00'); DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZJXF-194-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJXF-194-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-20261017-0001','1','F1E-ZJXF-198-0','1','3.950','3.950','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZJXF-198-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJXF-198-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-17 08:16:30' WHERE kode_barang='F1E-ZJXF-198-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJXF-198-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-17 08:16:30','TOKO','PM-F','F1E','F1E-ZJXF-198-0','1','3.950','3.950','1','3.950','3.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZJXF-198-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJXF-198-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-20261017-0001','1','F3E-ZJAF-2-0','1','5.900','5.900','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAF-2-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-2-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-17 08:16:30' WHERE kode_barang='F3E-ZJAF-2-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAF-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-17 08:16:30','TOKO','PM-F','F3E','F3E-ZJAF-2-0','1','5.900','5.900','1','5.900','5.900','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJAF-2-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-2-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-20261017-0001','1','F3E-ZJAF-21-0','1','1.020','1.020','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAF-21-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-21-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-17 08:16:30' WHERE kode_barang='F3E-ZJAF-21-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAF-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-17 08:16:30','TOKO','PM-F','F3E','F3E-ZJAF-21-0','1','1.020','1.020','1','1.020','1.020','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJAF-21-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-21-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-20261017-0001','1','F3E-ZJAF-32-0','1','1.880','1.880','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAF-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-32-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-17 08:16:30' WHERE kode_barang='F3E-ZJAF-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAF-32-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-17 08:16:30','TOKO','PM-F','F3E','F3E-ZJAF-32-0','1','1.880','1.880','1','1.880','1.880','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJAF-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-32-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-20261017-0001','1','F3E-ZJAF-33-0','1','1.620','1.620','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAF-33-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-33-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-17 08:16:30' WHERE kode_barang='F3E-ZJAF-33-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAF-33-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-17 08:16:30','TOKO','PM-F','F3E','F3E-ZJAF-33-0','1','1.620','1.620','1','1.620','1.620','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJAF-33-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-33-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261017-0001','2026-10-17','08:16','16.550','admpindah','2026-10-17 08:16:29'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326170825341','input','1',' TEE2 X CM ','TOKO','PT-E','E2TE-WLAB-29-T','CC X WEDDING MATA CM 20 ','','2.360','1','100.00','4555000','0','0','15000','4555000','0','0','0','4555000','AAT','T0051716','E2TE','0','0','-','0','1940000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-WLAB-29-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.360',berat_jual_asli=berat_jual_asli+'2.360',stock_jual='1',berat_akhir=berat_akhir-'2.360',berat_akhir_asli=berat_akhir_asli-'2.360',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='E2TE-WLAB-29-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170825341','2026-10-17','2.360','2026-10-17','08:25:34','PLG0031922','4555000','4555000','0','4555000','4555000','input','2026-10-17 08:25:34','F32617082534'); 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-17','F326170825341','2026-10-17','08:25:34','AAT','4555000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261017-0002','D','2026-10-17','08:25:34','input','PENJUALAN','F326170825341','7892049000','4555000','7896604000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='4555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170825341' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326170825342','input',' 1',' MEF1 TD 65','TOKO','PM-F','F1E-ZHAX-315-0','GL OVAL C SLEP TD 65 8K ','','3.810','1','100.00','3974000','0','0','15000','3975000','0','0','0','3975000','AAT','00418460','F1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHAX-315-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.810',berat_jual_asli=berat_jual_asli+'3.810',stock_jual='1',berat_akhir=berat_akhir-'3.810',berat_akhir_asli=berat_akhir_asli-'3.810',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='F1E-ZHAX-315-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170825342','2026-10-17','3.810','2026-10-17','08:25:34','PLG0031923','3975000','3975000','0','3975000','3975000','input','2026-10-17 08:25:34','F32617082534'); 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-17','F326170825342','2026-10-17','08:25:34','AAT','3975000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261017-0003','D','2026-10-17','08:25:34','input','PENJUALAN','F326170825342','7896604000','3975000','7900579000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='3975000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170825342' LIMIT 1; 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-00020549','X-00020549','CC BUNGA CLOVER SLEP KH 18 8K','GR','---','E1F','BELI','BELI001','350000','2026-10-17','0.370','1','kasir','2026-10-17 08:32:46'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00020549','X-00020549'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0001','F326150930191','SIN','1','BELI','BELI001','E1F', 'X-00020549', 'CC BUNGA CLOVER SLEP KH 18 8K','0.370','0.370','100.00','391000','350000','945946','1073000','1','350000','350000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.370',berat_beli_asli=berat_beli_asli+'0.370',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.370',berat_akhir_asli=berat_akhir_asli+'0.370',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0001','2026-10-17','2026-10-17','08:32:45','SIN','---','0.370','350000','350000','350000','350000','350000','kasir','2026-10-17 08:32:46','FB-261017-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0001','INTAN DWI SEFTIA','BANGUNSARI BANDAR PCT','','','085312836879','kasir','2026-10-17 08:32:46'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0004','K','2026-10-17','08:32:45','kasir','PEMBELIAN UMUM','FB-261017-0001','7900579000','350000','7900229000'); 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-00020550','X-00020550','GL MODEL FANCY VAR HW 8K','GR','---','F3E','BELI','BELI001','1317000','2026-10-17','1.360','1','kasir','2026-10-17 08:55:32'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020550','X-00020550'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0002','F326180234521','AAT','1','BELI','BELI001','F3E', 'X-00020550', 'GL MODEL FANCY VAR HW 8K','1.360','1.360','100.00','1612000','1317000','968382','1053000','1','1317000','1317000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.360',berat_beli_asli=berat_beli_asli+'1.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.360',berat_akhir_asli=berat_akhir_asli+'1.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0002','2026-10-17','2026-10-17','08:55:32','AAT','---','1.360','1317000','1317000','1317000','1317000','1317000','kasir','2026-10-17 08:55:32','FB-261017-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0002','ERISKA','SUKOMANGU PURWANTORO','','','08216094064','kasir','2026-10-17 08:55:32'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0005','K','2026-10-17','08:55:32','kasir','PEMBELIAN UMUM','FB-261017-0002','7900229000','1317000','7898912000'); 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-00020551','X-00020551','CC WEDDING MATA CM 18 8K','GR','---','E2D','BELI','BELI001','833000','2026-10-17','0.880','1','kasir','2026-10-17 08:55:32'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020551','X-00020551'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0003','F326011049301','AAT','2','BELI','BELI001','E2D', 'X-00020551', 'CC WEDDING MATA CM 18 8K','0.880','0.880','100.00','905000','833000','946591','1033000','1','833000','833000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.880',berat_beli_asli=berat_beli_asli+'0.880',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.880',berat_akhir_asli=berat_akhir_asli+'0.880',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0003','2026-10-17','2026-10-17','08:55:32','AAT','---','0.880','833000','833000','833000','833000','833000','kasir','2026-10-17 08:55:32','FB-261017-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0003','ERISKA','SUKOMANGU PURWANTORO','','','08216094064','kasir','2026-10-17 08:55:32'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0006','K','2026-10-17','08:55:32','kasir','PEMBELIAN UMUM','FB-261017-0003','7898912000','833000','7898079000'); 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-00020552','X-00020552','GL RANTAI HOLLOW MODEL DAUN VAR HW 8K','GR','---','F3E','BELI','BELI001','2882000','2026-10-17','3.050','1','kasir','2026-10-17 08:56:11'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020552','X-00020552'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0004','F325080101521','SIN','1','BELI','BELI001','F3E', 'X-00020552', 'GL RANTAI HOLLOW MODEL DAUN VAR HW 8K','3.050','3.050','100.00','3133000','2882000','944918','1053000','1','2882000','2882000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.050',berat_beli_asli=berat_beli_asli+'3.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.050',berat_akhir_asli=berat_akhir_asli+'3.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0004','2026-10-17','2026-10-17','08:56:11','SIN','---','3.050','2882000','2882000','2882000','2882000','2882000','kasir','2026-10-17 08:56:11','FB-261017-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0004','DILA','SUMBER','','','','kasir','2026-10-17 08:56:11'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0007','K','2026-10-17','08:56:11','kasir','PEMBELIAN UMUM','FB-261017-0004','7898079000','2882000','7895197000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326170901071','kasir','1',' MEF3 X HW ','TOKO','PM-F','F3E-ZJXF-236-0','GL X HARLEY DAUN HW 8K ','','1.680','1','100.00','1752000','0','0','15000','1752000','0','0','0','1752000','SIN','00428140','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJXF-236-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.680',berat_jual_asli=berat_jual_asli+'1.680',stock_jual='1',berat_akhir=berat_akhir-'1.680',berat_akhir_asli=berat_akhir_asli-'1.680',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='F3E-ZJXF-236-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170901071','2026-10-17','1.680','2026-10-17','09:01:08','PLG0031924','1752000','1752000','0','1752000','1752000','kasir','2026-10-17 09:01:07','F32617090107'); 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-17','F326170901071','2026-10-17','09:01:08','SIN','1752000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261017-0008','D','2026-10-17','09:01:08','kasir','PENJUALAN','F326170901071','7895197000','1752000','7896949000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326170904471','kasir','1',' MEF1 X TD ','TOKO','PM-F','F1E-ZIBE-82-0','GL XX OVAL C SLEP TD 58 8K ','','3.390','1','100.00','3536000','0','0','15000','3434000','0','0','0','3434000','LIS','00425457','F1E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIBE-82-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.390',berat_jual_asli=berat_jual_asli+'3.390',stock_jual='1',berat_akhir=berat_akhir-'3.390',berat_akhir_asli=berat_akhir_asli-'3.390',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='F1E-ZIBE-82-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170904471','2026-10-17','3.390','2026-10-17','09:04:48','PLG0031925','3434000','3434000','0','3434000','3434000','kasir','2026-10-17 09:04:47','F32617090447'); 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-17','F326170904471','2026-10-17','09:04:48','LIS','3434000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261017-0009','D','2026-10-17','09:04:48','kasir','PENJUALAN','F326170904471','7896949000','3434000','7900383000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='3434000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170904471' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326170904472','kasir',' 1',' MDE1 X LG ','TOKO','PM-E','E1D-ZGXI-348-0','CC X MODEL ISYANA SLEP LG 12 8K ','','0.900','1','100.00','921000','0','0','15000','921000','0','0','0','921000','LIS','00413067','E1D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGXI-348-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='E1D-ZGXI-348-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170904472','2026-10-17','0.900','2026-10-17','09:04:48','PLG0031926','921000','921000','0','921000','921000','kasir','2026-10-17 09:04:47','F32617090447'); 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-17','F326170904472','2026-10-17','09:04:48','LIS','921000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261017-0010','D','2026-10-17','09:04:48','kasir','PENJUALAN','F326170904472','7900383000','921000','7901304000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='921000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326170904472' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326170927181','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZIBF-115-0','CC X MODEL SLEP CM 23 8K ','','1.170','1','100.00','1197000','0','0','15000','1195000','0','0','0','1195000','AAT','00425733','E1D','0','0','-','1','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZIBF-115-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='E1D-ZIBF-115-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326170927181','2026-10-17','1.170','2026-10-17','09:27:19','PLG0031927','1195000','1195000','0','1195000','1195000','kasir','2026-10-17 09:27:18','F32617092718'); 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-17','F326170927181','2026-10-17','09:27:19','AAT','1195000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261017-0011','D','2026-10-17','09:27:19','kasir','PENJUALAN','F326170927181','7901304000','1195000','7902499000'); 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-00020553','X-00020553','GW X TUSUK MRICAN SLEP LG 8K','GR','---','B1G','BELI','BELI001','335000','2026-10-17','0.340','1','kasir','2026-10-17 09:33:10'); DELETE FROM tp_barang WHERE kode_dept = 'X-B1G'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1G','X-00020553','X-00020553'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0005','F326210104051','AAT','1','BELI','BELI001','B1G', 'X-00020553', 'GW X TUSUK MRICAN SLEP LG 8K','0.340','0.340','100.00','423000','335000','985294','1083000','1','335000','335000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.340',berat_beli_asli=berat_beli_asli+'0.340',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.340',berat_akhir_asli=berat_akhir_asli+'0.340',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1G' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0005','2026-10-17','2026-10-17','09:33:09','AAT','---','0.340','335000','335000','335000','335000','335000','kasir','2026-10-17 09:33:10','FB-261017-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0005','DEK WULAN','PLOSO PUHPELEM','','','','kasir','2026-10-17 09:33:10'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0012','K','2026-10-17','09:33:09','kasir','PEMBELIAN UMUM','FB-261017-0005','7902499000','335000','7902164000'); 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-00020554','X-00020554','CC X SPIRAL ARESO VAR UB 18 8K','GR','---','E1D','BELI','BELI001','545000','2026-10-17','0.600','1','kasir','2026-10-17 09:33:10'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020554','X-00020554'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0006','F326270238471','AAT','2','BELI','BELI001','E1D', 'X-00020554', 'CC X SPIRAL ARESO VAR UB 18 8K','0.800','0.600','100.00','890000','545000','908333','1033000','1','545000','545000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0006','2026-10-17','2026-10-17','09:33:09','AAT','---','0.600','545000','545000','545000','545000','545000','kasir','2026-10-17 09:33:10','FB-261017-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0006','WULAN','PUHPELEM','','','','kasir','2026-10-17 09:33:10'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0013','K','2026-10-17','09:33:09','kasir','PEMBELIAN UMUM','FB-261017-0006','7902164000','545000','7901619000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171033091','kasir','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZJXG-229-0','KL X NORI ANAK SLEP KH 36 8K ','','2.050','1','100.00','2159000','0','0','15000','2138000','0','0','0','2138000','LIS','00428471','H1E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJXG-229-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='H1E-ZJXG-229-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171033091','2026-10-17','2.050','2026-10-17','10:33:09','PLG0031928','2138000','2138000','0','2138000','2138000','kasir','2026-10-17 10:33:09','F32617103309'); 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-17','F326171033091','2026-10-17','10:33:09','LIS','2138000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261017-0014','D','2026-10-17','10:33:09','kasir','PENJUALAN','F326171033091','7901619000','2138000','7903757000'); 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-00020555','X-00020555','KL X GUCCI ANAK UB 34 8K','GR','---','H1E','BELI','BELI001','1813000','2026-10-17','2.000','1','kasir','2026-10-17 10:45:44'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020555','X-00020555'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0007','F326021134202','LIS','1','BELI','BELI001','H1E', 'X-00020555', 'KL X GUCCI ANAK UB 34 8K','2.000','2.000','100.00','2060000','1813000','906500','1053000','1','1813000','1813000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0007','2026-10-17','2026-10-17','10:45:44','LIS','---','2.000','1813000','1813000','1813000','1813000','1813000','kasir','2026-10-17 10:45:44','FB-261017-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0007','GIARNI','PUHPELEM','','','','kasir','2026-10-17 10:45:44'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0015','K','2026-10-17','10:45:44','kasir','PEMBELIAN UMUM','FB-261017-0007','7903757000','1813000','7901944000'); 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-00020556','X-00020556','CC COR M 8K','GR','---','E2E','BELI','BELI001','770000','2026-10-17','1.120','1','kasir','2026-10-17 10:46:59'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020556','X-00020556'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0008','F321201220571','LIS','1','BELI','BELI001','E2E', 'X-00020556', 'CC COR M 8K','1.120','1.120','100.00','450000','770000','687500','1053000','1','770000','770000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.120',berat_beli_asli=berat_beli_asli+'1.120',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.120',berat_akhir_asli=berat_akhir_asli+'1.120',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0008','2026-10-17','2026-10-17','10:46:59','LIS','---','1.120','770000','770000','770000','770000','770000','kasir','2026-10-17 10:46:59','FB-261017-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0008','AIRA','GAMBIRANOM','','','','kasir','2026-10-17 10:46:59'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0016','K','2026-10-17','10:46:59','kasir','PEMBELIAN UMUM','FB-261017-0008','7901944000','770000','7901174000'); 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-00020557','X-00020557','GL CAPELLA PLAT CAT ANAK LT','GR','---','F3E','BELI','BELI001','1385000','2026-10-17','2.020','1','kasir','2026-10-17 10:49:31'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020557','X-00020557'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0009','F322270111372','LIS','1','BELI','BELI001','F3E', 'X-00020557', 'GL CAPELLA PLAT CAT ANAK LT','2.020','2.020','100.00','885000','1385000','685644','1053000','1','1385000','1385000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.020',berat_beli_asli=berat_beli_asli+'2.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.020',berat_akhir_asli=berat_akhir_asli+'2.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0009','2026-10-17','2026-10-17','10:49:30','LIS','---','2.020','1385000','1385000','1385000','1385000','1385000','kasir','2026-10-17 10:49:31','FB-261017-0009'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0009','YULIANA','GAMBIRANOM KISMANTORO','','','','kasir','2026-10-17 10:49:31'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0017','K','2026-10-17','10:49:30','kasir','PEMBELIAN UMUM','FB-261017-0009','7901174000','1385000','7899789000'); 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-00020558','X-00020558','KL POLOS 9K','GR','---','H2I','BELI','BELI001','2270000','2026-10-17','2.920','1','kasir','2026-10-17 10:52:43'); DELETE FROM tp_barang WHERE kode_dept = 'X-H2I'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00020558','X-00020558'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0010','F323120917573','LIS','1','BELI','BELI001','H2I', 'X-00020558', 'KL POLOS 9K','2.960','2.920','100.00','1460000','2270000','777397','1133000','1','2270000','2270000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.920',berat_beli_asli=berat_beli_asli+'2.920',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.920',berat_akhir_asli=berat_akhir_asli+'2.920',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0010','2026-10-17','2026-10-17','10:52:43','LIS','---','2.920','2270000','2270000','2270000','2270000','2270000','kasir','2026-10-17 10:52:43','FB-261017-0010'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0010','YULIANA','GAMBIRANOM','','','','kasir','2026-10-17 10:52:43'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0018','K','2026-10-17','10:52:43','kasir','PEMBELIAN UMUM','FB-261017-0010','7899789000','2270000','7897519000'); 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-00020559','X-00020559','CC COR M 8K','GR','---','E2D','BELI','BELI001','770000','2026-10-17','1.120','1','kasir','2026-10-17 10:52:43'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020559','X-00020559'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0011','F323120917575','LIS','2','BELI','BELI001','E2D', 'X-00020559', 'CC COR M 8K','1.120','1.120','100.00','510000','770000','687500','1033000','1','770000','770000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.120',berat_beli_asli=berat_beli_asli+'1.120',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.120',berat_akhir_asli=berat_akhir_asli+'1.120',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0011','2026-10-17','2026-10-17','10:52:43','LIS','---','1.120','770000','770000','770000','770000','770000','kasir','2026-10-17 10:52:43','FB-261017-0010'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0011','YULIANA','GAMBIRANOM','','','','kasir','2026-10-17 10:52:43'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0019','K','2026-10-17','10:52:43','kasir','PEMBELIAN UMUM','FB-261017-0011','7897519000','770000','7896749000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171100081','kasir','1',' MDE1 X PM ','TOKO','PM-E','E1D-ZHBE-88-0','CC X BANGKOK SLEP PM 18 8K','','1.120','1','100.00','1146000','0','0','15000','1146000','0','0','0','1146000','AAT','00420130','E1D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZHBE-88-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='E1D-ZHBE-88-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171100081','2026-10-17','1.120','2026-10-17','11:00:09','PLG0031929','1146000','1146000','0','1146000','1146000','kasir','2026-10-17 11:00:08','F32617110008'); 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-17','F326171100081','2026-10-17','11:00:09','AAT','1146000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261017-0020','D','2026-10-17','11:00:09','kasir','PENJUALAN','F326171100081','7896749000','1146000','7897895000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171100351','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZIBA-449-0','CC X BANGKOK SLEP CM 20 8K ','','1.110','1','100.00','1136000','0','0','15000','1136000','0','0','0','1136000','AAT','00424993','E1D','0','0','-','0','1033000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZIBA-449-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='E1D-ZIBA-449-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171100351','2026-10-17','1.110','2026-10-17','11:00:35','PLG0031930','1136000','1136000','0','1136000','1136000','kasir','2026-10-17 11:00:35','F32617110035'); 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-17','F326171100351','2026-10-17','11:00:35','AAT','1136000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261017-0021','D','2026-10-17','11:00:35','kasir','PENJUALAN','F326171100351','7897895000','1136000','7899031000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171101011','kasir','1',' MEF1 X PM ','TOKO','PM-F','F1E-ZFXE-236-0','GL X BANGKOK ANAK NEO SLEP PM 34 8K ','','1.930','1','100.00','2013000','0','0','15000','2014000','0','0','0','2014000','AAT','00407488','F1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXE-236-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='F1E-ZFXE-236-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171101011','2026-10-17','1.930','2026-10-17','11:01:02','PLG0031931','2014000','2014000','0','2014000','2014000','kasir','2026-10-17 11:01:01','F32617110101'); 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-17','F326171101011','2026-10-17','11:01:02','AAT','2014000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261017-0022','D','2026-10-17','11:01:02','kasir','PENJUALAN','F326171101011','7899031000','2014000','7901045000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171139441','kasir','1',' MEE2 KH 16','TOKO','PM-E','E2E-ZJXE-376-0','CC MODEL SNAKE MATA KH 16 8K ','','0.470','1','100.00','490000','0','0','15000','490000','0','0','0','490000','SIN','00427867','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXE-376-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='E2E-ZJXE-376-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171139441','2026-10-17','0.470','2026-10-17','11:39:44','PLG0031932','490000','490000','0','490000','490000','kasir','2026-10-17 11:39:44','F32617113944'); 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-17','F326171139441','2026-10-17','11:39:44','SIN','490000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261017-0023','D','2026-10-17','11:39:44','kasir','PENJUALAN','F326171139441','7901045000','490000','7901535000'); INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171219271','kasir','1',' MIH2 X UB ','TOKO','PM-H','H2I-ZGCA-53-0','KL X SANTA UB 44 9K ','','4.930','1','100.00','5536000','0','0','15000','5536000','0','0','0','5536000','LIS','00416139','H2I','0','0','-','0','1133000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-ZGCA-53-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.930',berat_jual_asli=berat_jual_asli+'4.930',stock_jual='1',berat_akhir=berat_akhir-'4.930',berat_akhir_asli=berat_akhir_asli-'4.930',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='H2I-ZGCA-53-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171219271','2026-10-17','4.930','2026-10-17','12:19:27','PLG0031933','5536000','5536000','0','5536000','5536000','kasir','2026-10-17 12:19:27','F32617121927'); 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-17','F326171219271','2026-10-17','12:19:27','LIS','5536000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261017-0024','D','2026-10-17','12:19:27','kasir','PENJUALAN','F326171219271','7901535000','5536000','7907071000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='5536000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326171219271' LIMIT 1; INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326171219272','kasir',' 1',' MED2 X LG ','TOKO','PM-D','D2E-ZJAF-102-0','LT X MODEL HURUF MATA LG A 8K ','','0.520','1','100.00','548000','0','0','15000','542000','0','0','0','542000','LIS','00430281','D2E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-17', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZJAF-102-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-10-17' AND kode_barang='D2E-ZJAF-102-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326171219272','2026-10-17','0.520','2026-10-17','12:19:27','PLG0031934','542000','542000','0','542000','542000','kasir','2026-10-17 12:19:27','F32617121927'); 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-17','F326171219272','2026-10-17','12:19:27','LIS','542000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261017-0025','D','2026-10-17','12:19:27','kasir','PENJUALAN','F326171219272','7907071000','542000','7907613000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='542000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326171219272' LIMIT 1; 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-00020560','X-00020560','GL X TIFF SLEP HW 8K','GR','---','F3E','BELI','BELI001','1020000','2026-10-17','1.100','1','kasir','2026-10-17 12:29:27'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020560','X-00020560'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0012','F326281219491','AAT','1','BELI','BELI001','F3E', 'X-00020560', 'GL X TIFF SLEP HW 8K','1.100','1.100','100.00','1408000','1020000','927273','1053000','1','1020000','1020000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0012','2026-10-17','2026-10-17','12:29:27','AAT','---','1.100','1020000','1020000','1020000','1020000','1020000','kasir','2026-10-17 12:29:27','FB-261017-0012'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0012','ANGGUN','PUHPELEM','','','087847535712','kasir','2026-10-17 12:29:27'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0026','K','2026-10-17','12:29:27','kasir','PEMBELIAN UMUM','FB-261017-0012','7907613000','1020000','7906593000'); 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-00020561','X-00020561','LT COR T 8K','GR','---','D1G','BELI','BELI001','290000','2026-10-17','0.300','1','kasir','2026-10-17 14:30:20'); DELETE FROM tp_barang WHERE kode_dept = 'X-D1G'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00020561','X-00020561'); INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261017-0013','00416729','AAT','1','BELI','BELI001','D1G', 'X-00020561', 'LT COR T 8K','0.300','0.300','100.00','320000','290000','966667','1083000','1','290000','290000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.300',berat_beli_asli=berat_beli_asli+'0.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.300',berat_akhir_asli=berat_akhir_asli+'0.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-17' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261017-0013','2026-10-17','2026-10-17','14:30:20','AAT','---','0.300','290000','290000','290000','290000','290000','kasir','2026-10-17 14:30:20','FB-261017-0013'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261017-0013','YUDHA','JL ANILO','','','','kasir','2026-10-17 14:30:20'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-17' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261017-0027','K','2026-10-17','14:30:20','kasir','PEMBELIAN UMUM','FB-261017-0013','7906593000','290000','7906303000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170825341' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170825341' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170825341'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170825342' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170825342' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170825342'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170901071' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170901071' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170901071'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170904471' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170904471' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170904471'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170904472' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170904472' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170904472'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326170927181' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326170927181' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326170927181'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171033091' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171033091' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171033091'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171100081' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171100081' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171100081'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171100351' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171100351' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171100351'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171101011' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171101011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171101011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171139441' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171139441' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171139441'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171219271' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171219271' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171219271'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326171219272' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326171219272' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326171219272'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0008'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0009'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0010'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0011'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0012'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261017-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261017-0013'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-18','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-17'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-17'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-17'; 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-17' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-17'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-17'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-17'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-17'; 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-18' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-17' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261018-0001','D','2026-10-18','15:08:21','SYSTEM','SALDO AWAL','SALDO AWAL','0','7906303000','7906303000'); 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-261018-0001','D','2026-10-18','15:08:21','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000'); 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-261018-0001','D','2026-10-18','15:08:21','BRI','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261018-0001','D','2026-10-18','15:08:21','DLL','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-10-18'; 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-20261018-0001','1','D2E-ZJAF-100-0','1','0.560','0.560','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D2E-ZJAF-100-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZJAF-100-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-18 17:10:25' WHERE kode_barang='D2E-ZJAF-100-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZJAF-100-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-18 17:10:25','TOKO','PM-D','D2E','D2E-ZJAF-100-0','1','0.560','0.560','1','0.560','0.560','100.00'); DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZJAF-100-0'; DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZJAF-100-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-20261018-0001','1','D2E-ZJAF-101-0','1','0.570','0.570','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D2E-ZJAF-101-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZJAF-101-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-18 17:10:25' WHERE kode_barang='D2E-ZJAF-101-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZJAF-101-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-18 17:10:25','TOKO','PM-D','D2E','D2E-ZJAF-101-0','1','0.570','0.570','1','0.570','0.570','100.00'); DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZJAF-101-0'; DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZJAF-101-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261018-0001','2026-10-18','17:10','1.130','admpindah','2026-10-17 17:10:24'); 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-20261018-0001','1','E2D-ZJAF-147-0','1','1.050','1.050','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJAF-147-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-147-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-18 17:10:40' WHERE kode_barang='E2D-ZJAF-147-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJAF-147-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-18 17:10:40','TOKO','PM-E','E2D','E2D-ZJAF-147-0','1','1.050','1.050','1','1.050','1.050','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJAF-147-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJAF-147-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261018-0001','2026-10-18','17:10','1.050','admpindah','2026-10-17 17:10:40'); 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-20261018-0001','1','F1E-ZJXG-165-0','1','3.880','3.880','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZJXG-165-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJXG-165-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-18 17:10:56' WHERE kode_barang='F1E-ZJXG-165-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJXG-165-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-18 17:10:56','TOKO','PM-F','F1E','F1E-ZJXG-165-0','1','3.880','3.880','1','3.880','3.880','100.00'); DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZJXG-165-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJXG-165-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-20261018-0001','1','F1E-ZJAE-81-0','1','3.330','3.330','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZJAE-81-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJAE-81-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-18 17:10:56' WHERE kode_barang='F1E-ZJAE-81-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJAE-81-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-18 17:10:56','TOKO','PM-F','F1E','F1E-ZJAE-81-0','1','3.330','3.330','1','3.330','3.330','100.00'); DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZJAE-81-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJAE-81-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-20261018-0001','1','F3E-ZJAF-19-0','1','1.630','1.630','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAF-19-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-19-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-18 17:10:56' WHERE kode_barang='F3E-ZJAF-19-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAF-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-18 17:10:56','TOKO','PM-F','F3E','F3E-ZJAF-19-0','1','1.630','1.630','1','1.630','1.630','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJAF-19-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAF-19-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261018-0001','2026-10-18','17:10','8.840','admpindah','2026-10-17 17:10:56'); 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-20261018-0001','1','H1E-ZJXG-230-0','1','1.980','1.980','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJXG-230-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJXG-230-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-18 17:11:13' WHERE kode_barang='H1E-ZJXG-230-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJXG-230-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-18 17:11:13','TOKO','PM-H','H1E','H1E-ZJXG-230-0','1','1.980','1.980','1','1.980','1.980','100.00'); DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZJXG-230-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJXG-230-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-20261018-0001','1','H2I-ZJAE-263-0','1','4.950','4.950','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H2I-ZJAE-263-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2I-ZJAE-263-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-18 17:11:13' WHERE kode_barang='H2I-ZJAE-263-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H2I-ZJAE-263-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-18 17:11:13','TOKO','PM-H','H2I','H2I-ZJAE-263-0','1','4.950','4.950','1','4.950','4.950','100.00'); DELETE FROM tm_dept WHERE kode_dept='H2I' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2I' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2I-ZJAE-263-0'; DELETE FROM tm_barang_export WHERE kode_barang='H2I-ZJAE-263-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261018-0001','2026-10-18','17:11','6.930','admpindah','2026-10-17 17:11:13');