INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-01-10 ','08:34:57');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-10','105','0','-284450000','105','0','-284450000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-09';
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-01-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-09';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-09' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260110-0001','D','2026-01-10','08:35:05','BCA','SALDO AWAL','SALDO AWAL','0','1558734385','1558734385');
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-260110-0001','D','2026-01-10','08:35:05','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-01-10';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-01-10 ','08:35:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-01-10 ','08:45:49');
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260110-0001','1','X-00009130','BELI','BELI001','CN PLINTIR SHB','1','2.200','3571500.00' ,'0.00','3571500','','3571500','3571500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-01-10 08:51:02' WHERE kode_barang='X-00009130' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009130' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009130' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.200',berat_hancur_asli=berat_hancur_asli+'2.200', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTCN' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260110-0001','adminpusat','2026-01-10','2026-01-10','08:51:02','3571500','3571500', 'adminpusat','2026-01-10 08:51:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-01-10 ','08:53:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-01-10 ','08:53:58');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-01-10 ','09:24:03');
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-20260110-0001','1','MTGW-ZAXH-1-0','1','0.940','0.940','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-1-0','1','0.940','0.930','1','0.940','0.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-1-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-20260110-0001','1','MTGW-ZAXH-2-0','1','1.260','1.260','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-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-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-2-0','1','1.260','1.250','1','1.260','1.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-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-20260110-0001','1','MTGW-ZAXH-3-0','1','1.530','1.530','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-3-0','1','1.530','1.520','1','1.530','1.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-3-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-20260110-0001','1','MTGW-ZAXH-4-0','1','1.790','1.790','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-4-0','1','1.790','1.780','1','1.790','1.780','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-4-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-20260110-0001','1','MTGW-ZAXH-5-0','1','1.700','1.700','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-5-0','1','1.700','1.690','1','1.700','1.690','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-5-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-20260110-0001','1','MTGW-ZAXH-6-0','1','1.740','1.740','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-6-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-6-0','1','1.740','1.730','1','1.740','1.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-6-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-20260110-0001','1','MTGW-ZAXH-7-0','1','1.350','1.350','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-7-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-7-0','1','1.350','1.340','1','1.350','1.340','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-7-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-20260110-0001','1','MTGW-ZAXH-8-0','1','1.420','1.420','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-8-0','1','1.420','1.410','1','1.420','1.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-8-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-20260110-0001','1','MTGW-ZAXH-9-0','1','1.380','1.380','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-9-0','1','1.380','1.370','1','1.380','1.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-9-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-20260110-0001','1','MTGW-ZAXH-10-0','1','4.070','4.070','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-10-0','1','4.070','4.060','1','4.070','4.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-10-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-20260110-0001','1','MTGW-ZAXH-11-0','1','4.030','4.030','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-11-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-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-11-0','1','4.030','4.020','1','4.030','4.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-11-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-20260110-0001','1','MTGW-ZAXH-12-0','1','1.150','1.150','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-12-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-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-12-0','1','1.150','1.140','1','1.150','1.140','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-12-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-20260110-0001','1','MTGW-ZAXH-13-0','1','1.020','1.020','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-13-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-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-13-0','1','1.020','1.010','1','1.020','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-13-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-20260110-0001','1','MTGW-ZAXH-14-0','1','1.960','1.960','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-14-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-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-14-0','1','1.960','1.950','1','1.960','1.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-14-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-20260110-0001','1','MTGW-ZAXH-15-0','1','2.330','2.330','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-15-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-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-15-0','1','2.330','2.320','1','2.330','2.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-15-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-20260110-0001','1','MTGW-ZAXH-16-0','1','3.340','3.340','TOKO','BKGWMT','TOKO','BTGWMT');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXH-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTGWMT',tgl_last_beli='2026-01-10 09:24:39' WHERE kode_barang='MTGW-ZAXH-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXH-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:24:39','TOKO','BTGWMT','MTGW','MTGW-ZAXH-16-0','1','3.340','3.330','1','3.340','3.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXH-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXH-16-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260110-0001','2026-01-10','09:24','31.010','cashier1','2026-01-10 09:24: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-20260110-0001','1','MTLT-ZAXH-17-0','1','1.360','1.360','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-17-0','1','1.360','1.350','1','1.360','1.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-17-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-20260110-0001','1','MTLT-ZAXH-18-0','1','1.370','1.370','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-18-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-18-0','1','1.370','1.360','1','1.370','1.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-18-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-20260110-0001','1','MTLT-ZAXH-19-0','1','0.880','0.880','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-19-0','1','0.880','0.870','1','0.880','0.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-19-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-20260110-0001','1','MTLT-ZAXH-20-0','1','1.110','1.110','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-20-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-20-0','1','1.110','1.100','1','1.110','1.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-20-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-20260110-0001','1','MTLT-ZAXH-21-0','1','0.850','0.850','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-21-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-21-0','1','0.850','0.840','1','0.850','0.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-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-20260110-0001','1','MTLT-ZAXH-22-0','1','0.860','0.860','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-22-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-22-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-22-0','1','0.860','0.850','1','0.860','0.850','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-22-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-20260110-0001','1','MTLT-ZAXH-23-0','1','1.310','1.310','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-23-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-23-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-23-0','1','1.310','1.300','1','1.310','1.300','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-23-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-20260110-0001','1','MTLT-ZAXH-24-0','1','1.410','1.410','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-24-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-24-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-24-0','1','1.410','1.400','1','1.410','1.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-24-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-20260110-0001','1','MTLT-ZAXH-25-0','1','1.420','1.420','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-25-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-25-0','1','1.420','1.410','1','1.420','1.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-25-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-20260110-0001','1','MTLT-ZAXH-26-0','1','1.360','1.360','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-26-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-26-0','1','1.360','1.350','1','1.360','1.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-26-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-20260110-0001','1','MTLT-ZAXH-27-0','1','1.830','1.830','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-27-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-27-0','1','1.830','1.820','1','1.830','1.820','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-27-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-20260110-0001','1','MTLT-ZAXH-28-0','1','1.000','1.000','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-28-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-28-0','1','1.000','0.990','1','1.000','0.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-28-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-20260110-0001','1','MTLT-ZAXH-29-0','1','0.960','0.960','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-29-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-29-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-29-0','1','0.960','0.950','1','0.960','0.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-29-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-20260110-0001','1','MTLT-ZAXH-30-0','1','0.940','0.940','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-30-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-30-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-30-0','1','0.940','0.930','1','0.940','0.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-30-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-20260110-0001','1','MTLT-ZAXH-31-0','1','1.430','1.430','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-31-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-31-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-31-0','1','1.430','1.420','1','1.430','1.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-31-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-20260110-0001','1','MTLT-ZAXH-32-0','1','1.440','1.440','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-32-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-32-0','1','1.440','1.430','1','1.440','1.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-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-20260110-0001','1','MTLT-ZAXH-33-0','1','1.440','1.440','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-33-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-33-0','1','1.440','1.430','1','1.440','1.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-33-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-20260110-0001','1','MTLT-ZAXH-34-0','1','2.020','2.020','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-34-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-34-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-34-0','1','2.020','2.010','1','2.020','2.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-34-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-20260110-0001','1','MTLT-ZAXH-35-0','1','1.150','1.150','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-35-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-35-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-35-0','1','1.150','1.140','1','1.150','1.140','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-35-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-20260110-0001','1','MTLT-ZAXH-36-0','1','2.370','2.370','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-36-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-36-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-36-0','1','2.370','2.360','1','2.370','2.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-36-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-20260110-0001','1','MTLT-ZAXH-37-0','1','2.650','2.650','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-37-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-37-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-37-0','1','2.650','2.640','1','2.650','2.640','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-37-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-20260110-0001','1','MTLT-ZAXH-38-0','1','2.160','2.160','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-38-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-38-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-38-0','1','2.160','2.150','1','2.160','2.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-38-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-20260110-0001','1','MTLT-ZAXH-39-0','1','2.370','2.370','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-39-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-39-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-39-0','1','2.370','2.360','1','2.370','2.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-39-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-20260110-0001','1','MTLT-ZAXH-40-0','1','1.210','1.210','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-40-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-40-0','1','1.210','1.200','1','1.210','1.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-40-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-20260110-0001','1','MTLT-ZAXH-41-0','1','1.000','1.000','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-41-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-41-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-41-0','1','1.000','0.990','1','1.000','0.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-41-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-20260110-0001','1','MTLT-ZAXH-42-0','1','1.000','1.000','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-42-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-42-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-42-0','1','1.000','0.990','1','1.000','0.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-42-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-20260110-0001','1','MTLT-ZAXH-43-0','1','1.000','1.000','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-43-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-43-0','1','1.000','0.990','1','1.000','0.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-43-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-20260110-0001','1','MTLT-ZAXH-44-0','1','1.940','1.940','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-44-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-44-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-44-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-44-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-44-0','1','1.940','1.930','1','1.940','1.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-44-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-44-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-20260110-0001','1','MTLT-ZAXH-45-0','1','0.950','0.950','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-45-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-45-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-45-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-45-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-45-0','1','0.950','0.940','1','0.950','0.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-45-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-45-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-20260110-0001','1','MTLT-ZAXH-46-0','1','0.940','0.940','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-46-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-46-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-46-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-46-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-46-0','1','0.940','0.930','1','0.940','0.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-46-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-46-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-20260110-0001','1','MTLT-ZAXH-47-0','1','1.610','1.610','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-47-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-47-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-47-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-47-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-47-0','1','1.610','1.600','1','1.610','1.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-47-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-47-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-20260110-0001','1','MTLT-ZAXH-48-0','1','1.680','1.680','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-48-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-48-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-48-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-48-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-48-0','1','1.680','1.670','1','1.680','1.670','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-48-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-48-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-20260110-0001','1','MTLT-ZAXH-49-0','1','1.240','1.240','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-49-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-49-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-49-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-49-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-49-0','1','1.240','1.230','1','1.240','1.230','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-49-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-49-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-20260110-0001','1','MTLT-ZAXH-50-0','1','1.350','1.350','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-50-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-50-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-50-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-50-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-50-0','1','1.350','1.340','1','1.350','1.340','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-50-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-50-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-20260110-0001','1','MTLT-ZAXH-51-0','1','1.660','1.660','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-51-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-51-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-51-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-51-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-51-0','1','1.660','1.650','1','1.660','1.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-51-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-51-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-20260110-0001','1','MTLT-ZAXH-52-0','1','1.060','1.060','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-52-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-52-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-52-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-52-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-52-0','1','1.060','1.050','1','1.060','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-52-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-52-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-20260110-0001','1','MTLT-ZAXH-53-0','1','1.100','1.100','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-53-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-53-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-53-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-53-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-53-0','1','1.100','1.090','1','1.100','1.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-53-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-53-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-20260110-0001','1','MTLT-ZAXH-54-0','1','1.200','1.200','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-54-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-54-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-54-0','1','1.200','1.190','1','1.200','1.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-54-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-20260110-0001','1','MTLT-ZAXH-55-0','1','1.250','1.250','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-55-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-55-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-55-0','1','1.250','1.240','1','1.250','1.240','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-55-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-20260110-0001','1','MTLT-ZAXH-56-0','1','1.430','1.430','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-56-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-56-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-56-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-56-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-56-0','1','1.430','1.420','1','1.430','1.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-56-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-56-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-20260110-0001','1','MTLT-ZAXH-57-0','1','1.600','1.600','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-57-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-57-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-57-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-57-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-57-0','1','1.600','1.590','1','1.600','1.590','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-57-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-57-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-20260110-0001','1','MTLT-ZAXH-58-0','1','2.470','2.470','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-58-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-58-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-58-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-58-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-58-0','1','2.470','2.460','1','2.470','2.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-58-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-58-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-20260110-0001','1','MTLT-ZAXH-59-0','1','2.110','2.110','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-59-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-59-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:10' WHERE kode_barang='MTLT-ZAXH-59-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-59-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-01-10 09:25:10','TOKO','BTLTMT','MTLT','MTLT-ZAXH-59-0','1','2.110','2.100','1','2.110','2.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-59-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-59-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-20260110-0001','1','MTLT-ZAXH-60-0','1','1.300','1.300','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-60-0','1','1.300','1.290','1','1.300','1.290','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-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-20260110-0001','1','MTLT-ZAXH-61-0','1','1.930','1.930','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-61-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-61-0','1','1.930','1.920','1','1.930','1.920','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-61-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-20260110-0001','1','MTLT-ZAXH-62-0','1','1.620','1.620','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-62-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-62-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-62-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-62-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-62-0','1','1.620','1.610','1','1.620','1.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-62-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-62-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-20260110-0001','1','MTLT-ZAXH-63-0','1','1.760','1.760','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-63-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-63-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-63-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-63-0','1','1.760','1.750','1','1.760','1.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-63-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-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-20260110-0001','1','MTLT-ZAXH-64-0','1','1.900','1.900','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-64-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-64-0','1','1.900','1.890','1','1.900','1.890','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-64-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-20260110-0001','1','MTLT-ZAXH-65-0','1','1.000','1.000','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-65-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-65-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-65-0','1','1.000','0.990','1','1.000','0.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-65-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-20260110-0001','1','MTLT-ZAXH-66-0','1','2.200','2.200','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-66-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-66-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-66-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-66-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-66-0','1','2.200','2.190','1','2.200','2.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-66-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-66-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-20260110-0001','1','MTLT-ZAXH-67-0','1','0.950','0.950','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-67-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-67-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-67-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-67-0','1','0.950','0.940','1','0.950','0.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-67-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-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-20260110-0001','1','MTLT-ZAXH-68-0','1','1.410','1.410','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-68-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-68-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-68-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-68-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-68-0','1','1.410','1.400','1','1.410','1.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-68-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-68-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-20260110-0001','1','MTLT-ZAXH-69-0','1','3.400','3.400','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-69-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-69-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-69-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-69-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-69-0','1','3.400','3.390','1','3.400','3.390','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-69-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-69-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-20260110-0001','1','MTLT-ZAXH-70-0','1','3.760','3.760','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-70-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-70-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-70-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-70-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-70-0','1','3.760','3.750','1','3.760','3.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-70-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-70-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-20260110-0001','1','MTLT-ZAXH-71-0','1','3.400','3.400','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-71-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-71-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-71-0','1','3.400','3.390','1','3.400','3.390','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-71-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-20260110-0001','1','MTLT-ZAXH-72-0','1','8.830','8.830','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-72-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-72-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-72-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-72-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-72-0','1','8.830','8.820','1','8.830','8.820','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-72-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-72-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-20260110-0001','1','MTLT-ZAXH-73-0','1','2.070','2.070','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-73-0','1','2.070','2.060','1','2.070','2.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-73-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-20260110-0001','1','MTLT-ZAXH-74-0','1','1.240','1.240','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-74-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-74-0','1','1.240','1.230','1','1.240','1.230','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-74-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-20260110-0001','1','MTLT-ZAXH-75-0','1','1.730','1.730','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-75-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-75-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-75-0','1','1.730','1.720','1','1.730','1.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-75-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-20260110-0001','1','MTLT-ZAXH-76-0','1','1.640','1.640','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-76-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-76-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-76-0','1','1.640','1.630','1','1.640','1.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-76-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-20260110-0001','1','MTLT-ZAXH-77-0','1','1.000','1.000','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-77-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-77-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-77-0','1','1.000','0.990','1','1.000','0.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-77-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-20260110-0001','1','MTLT-ZAXH-78-0','1','1.100','1.100','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-78-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-78-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-78-0','1','1.100','1.090','1','1.100','1.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-78-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-20260110-0001','1','MTLT-ZAXH-79-0','1','1.570','1.570','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-79-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-79-0','1','1.570','1.560','1','1.570','1.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-79-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-20260110-0001','1','MTLT-ZAXH-80-0','1','0.920','0.920','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-80-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-80-0','1','0.920','0.910','1','0.920','0.910','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-80-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-20260110-0001','1','MTLT-ZAXH-81-0','1','1.460','1.460','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-81-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-81-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-81-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-81-0','1','1.460','1.450','1','1.460','1.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-81-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-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-20260110-0001','1','MTLT-ZAXH-82-0','1','1.050','1.050','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-82-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-82-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-82-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-82-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-82-0','1','1.050','1.040','1','1.050','1.040','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-82-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-82-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-20260110-0001','1','MTLT-ZAXH-83-0','1','1.840','1.840','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-83-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-83-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-83-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-83-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-83-0','1','1.840','1.830','1','1.840','1.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-83-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-83-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-20260110-0001','1','MTLT-ZAXH-84-0','1','1.180','1.180','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-84-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-84-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-84-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-84-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-84-0','1','1.180','1.170','1','1.180','1.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-84-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-84-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-20260110-0001','1','MTLT-ZAXH-85-0','1','1.200','1.200','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-85-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-85-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-85-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-85-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-85-0','1','1.200','1.190','1','1.200','1.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-85-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-85-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-20260110-0001','1','MTLT-ZAXH-86-0','1','2.250','2.250','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-86-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-86-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-86-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-86-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-86-0','1','2.250','2.240','1','2.250','2.240','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-86-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-86-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-20260110-0001','1','MTLT-ZAXH-87-0','1','1.060','1.060','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-87-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-87-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-87-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-87-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-87-0','1','1.060','1.050','1','1.060','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-87-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-87-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-20260110-0001','1','MTLT-ZAXH-88-0','1','1.040','1.040','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-88-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-88-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-88-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-88-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-88-0','1','1.040','1.030','1','1.040','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-88-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-88-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-20260110-0001','1','MTLT-ZAXH-89-0','1','0.880','0.880','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-89-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-89-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-89-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-89-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-89-0','1','0.880','0.870','1','0.880','0.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-89-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-89-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-20260110-0001','1','MTLT-ZAXH-90-0','1','1.500','1.500','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-90-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-90-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-90-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-90-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-90-0','1','1.500','1.490','1','1.500','1.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-90-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-90-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-20260110-0001','1','MTLT-ZAXH-91-0','1','1.400','1.400','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-91-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-91-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-91-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-91-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-91-0','1','1.400','1.390','1','1.400','1.390','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-91-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-91-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-20260110-0001','1','MTLT-ZAXH-92-0','1','1.100','1.100','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-92-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-92-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-92-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-92-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-92-0','1','1.100','1.090','1','1.100','1.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-92-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-92-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-20260110-0001','1','MTLT-ZAXH-93-0','1','1.330','1.330','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-93-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-93-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-93-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-93-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-93-0','1','1.330','1.320','1','1.330','1.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-93-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-93-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-20260110-0001','1','MTLT-ZAXH-94-0','1','1.700','1.700','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-94-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-94-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-94-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-94-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-94-0','1','1.700','1.690','1','1.700','1.690','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-94-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-94-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-20260110-0001','1','MTLT-ZAXH-95-0','1','0.720','0.720','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-95-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-95-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-95-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-95-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-95-0','1','0.720','0.710','1','0.720','0.710','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-95-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-95-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-20260110-0001','1','MTLT-ZAXH-96-0','1','1.120','1.120','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-96-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-96-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-96-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-96-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-96-0','1','1.120','1.110','1','1.120','1.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-96-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-96-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-20260110-0001','1','MTLT-ZAXH-97-0','1','2.280','2.280','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-97-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-97-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-97-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-97-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-97-0','1','2.280','2.270','1','2.280','2.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-97-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-97-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-20260110-0001','1','MTLT-ZAXH-98-0','1','1.500','1.500','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-98-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-98-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-98-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-98-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-98-0','1','1.500','1.490','1','1.500','1.490','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-98-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-98-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-20260110-0001','1','MTLT-ZAXH-99-0','1','2.610','2.610','TOKO','BKLTMT','TOKO','BTLTMT');
DELETE FROM tm_barang WHERE kode_barang='MTLT-ZAXH-99-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-99-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTLTMT',tgl_last_beli='2026-01-10 09:25:11' WHERE kode_barang='MTLT-ZAXH-99-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTLT-ZAXH-99-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-01-10 09:25:11','TOKO','BTLTMT','MTLT','MTLT-ZAXH-99-0','1','2.610','2.600','1','2.610','2.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTLT-ZAXH-99-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTLT-ZAXH-99-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260110-0001','2026-01-10','09:24','133.440','cashier1','2026-01-10 09:25:11');
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-20260110-0001','1','MTCN-ZAXI-1-0','1','2.610','2.610','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZAXI-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-1-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:06' WHERE kode_barang='MTCN-ZAXI-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZAXI-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:06','TOKO','BTMF','MTCN','MTCN-ZAXI-1-0','1','2.610','2.600','1','2.610','2.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZAXI-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-1-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-20260110-0001','1','MTCN-ZAXI-2-0','1','2.880','2.880','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZAXI-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-2-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:06' WHERE kode_barang='MTCN-ZAXI-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZAXI-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-01-10 09:26:06','TOKO','BTMF','MTCN','MTCN-ZAXI-2-0','1','2.880','2.870','1','2.880','2.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZAXI-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-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-20260110-0001','1','MTCN-ZAXI-3-0','1','3.010','3.010','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZAXI-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:06' WHERE kode_barang='MTCN-ZAXI-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZAXI-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:06','TOKO','BTMF','MTCN','MTCN-ZAXI-3-0','1','3.010','3.000','1','3.010','3.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZAXI-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-3-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-20260110-0001','1','MTCN-ZAXI-4-0','1','3.660','3.660','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZAXI-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-4-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:06' WHERE kode_barang='MTCN-ZAXI-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZAXI-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:06','TOKO','BTMF','MTCN','MTCN-ZAXI-4-0','1','3.660','3.650','1','3.660','3.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZAXI-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-4-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-20260110-0001','1','MTCN-ZAXI-5-0','1','4.670','4.670','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZAXI-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-5-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:06' WHERE kode_barang='MTCN-ZAXI-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZAXI-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:06','TOKO','BTMF','MTCN','MTCN-ZAXI-5-0','1','4.670','4.660','1','4.670','4.660','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZAXI-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-5-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-20260110-0001','1','MTCN-ZAXI-6-0','1','4.710','4.710','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZAXI-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-6-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:06' WHERE kode_barang='MTCN-ZAXI-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZAXI-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:06','TOKO','BTMF','MTCN','MTCN-ZAXI-6-0','1','4.710','4.700','1','4.710','4.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZAXI-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-6-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-20260110-0001','1','MTCN-ZAXI-7-0','1','5.000','5.000','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZAXI-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-7-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:06' WHERE kode_barang='MTCN-ZAXI-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZAXI-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:06','TOKO','BTMF','MTCN','MTCN-ZAXI-7-0','1','5.000','4.990','1','5.000','4.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZAXI-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-7-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-20260110-0001','1','MTCN-ZAXI-8-0','1','6.300','6.300','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZAXI-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-8-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:06' WHERE kode_barang='MTCN-ZAXI-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZAXI-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:06','TOKO','BTMF','MTCN','MTCN-ZAXI-8-0','1','6.300','6.290','1','6.300','6.290','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZAXI-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-8-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-20260110-0001','1','MTGL-ZAXI-9-0','1','16.850','16.850','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZAXI-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZAXI-9-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:06' WHERE kode_barang='MTGL-ZAXI-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZAXI-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:06','TOKO','BTMF','MTGL','MTGL-ZAXI-9-0','1','16.850','16.840','1','16.850','16.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZAXI-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZAXI-9-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-20260110-0001','1','MTGL-ZAXI-10-0','1','19.700','19.700','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZAXI-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZAXI-10-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:07' WHERE kode_barang='MTGL-ZAXI-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZAXI-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:07','TOKO','BTMF','MTGL','MTGL-ZAXI-10-0','1','19.700','19.690','1','19.700','19.690','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZAXI-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZAXI-10-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-20260110-0001','1','MTKL-ZAXI-11-0','1','15.740','15.740','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZAXI-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZAXI-11-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:07' WHERE kode_barang='MTKL-ZAXI-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZAXI-11-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-01-10 09:26:07','TOKO','BTMF','MTKL','MTKL-ZAXI-11-0','1','15.740','15.730','1','15.740','15.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZAXI-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAXI-11-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-20260110-0001','1','MTCN-ZAXI-12-0','1','3.400','3.400','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZAXI-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:07' WHERE kode_barang='MTCN-ZAXI-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZAXI-12-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-01-10 09:26:07','TOKO','BTMF','MTCN','MTCN-ZAXI-12-0','1','3.400','3.390','1','3.400','3.390','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZAXI-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-12-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-20260110-0001','1','MTGL-ZAXI-13-0','1','5.310','5.310','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZAXI-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZAXI-13-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:07' WHERE kode_barang='MTGL-ZAXI-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZAXI-13-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-01-10 09:26:07','TOKO','BTMF','MTGL','MTGL-ZAXI-13-0','1','5.310','5.300','1','5.310','5.300','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZAXI-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZAXI-13-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-20260110-0001','1','MTGW-ZAXI-14-0','1','3.380','3.380','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXI-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXI-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:07' WHERE kode_barang='MTGW-ZAXI-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXI-14-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-01-10 09:26:07','TOKO','BTMF','MTGW','MTGW-ZAXI-14-0','1','3.380','3.370','1','3.380','3.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXI-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXI-14-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-20260110-0001','1','MTKL-ZAXI-15-0','1','15.630','15.630','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZAXI-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZAXI-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:07' WHERE kode_barang='MTKL-ZAXI-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZAXI-15-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-01-10 09:26:07','TOKO','BTMF','MTKL','MTKL-ZAXI-15-0','1','15.630','15.620','1','15.630','15.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZAXI-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAXI-15-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-20260110-0001','1','MTCN-ZAXI-16-0','1','2.620','2.620','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTCN-ZAXI-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-16-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:07' WHERE kode_barang='MTCN-ZAXI-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTCN-ZAXI-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:07','TOKO','BTMF','MTCN','MTCN-ZAXI-16-0','1','2.620','2.610','1','2.620','2.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTCN' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTCN' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTCN-ZAXI-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTCN-ZAXI-16-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-20260110-0001','1','MTGL-ZAXI-17-0','1','5.640','5.640','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTGL-ZAXI-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGL-ZAXI-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:07' WHERE kode_barang='MTGL-ZAXI-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGL-ZAXI-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:07','TOKO','BTMF','MTGL','MTGL-ZAXI-17-0','1','5.640','5.630','1','5.640','5.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGL-ZAXI-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGL-ZAXI-17-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-20260110-0001','1','MTGW-ZAXI-18-0','1','3.800','3.800','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTGW-ZAXI-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTGW-ZAXI-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:07' WHERE kode_barang='MTGW-ZAXI-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTGW-ZAXI-18-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-01-10 09:26:07','TOKO','BTMF','MTGW','MTGW-ZAXI-18-0','1','3.800','3.790','1','3.800','3.790','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTGW' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTGW' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTGW-ZAXI-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTGW-ZAXI-18-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-20260110-0001','1','MTKL-ZAXI-19-0','1','19.550','19.550','TOKO','BKMF','TOKO','BTMF');
DELETE FROM tm_barang WHERE kode_barang='MTKL-ZAXI-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='MTKL-ZAXI-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BTMF',tgl_last_beli='2026-01-10 09:26:07' WHERE kode_barang='MTKL-ZAXI-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='MTKL-ZAXI-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-01-10 09:26:07','TOKO','BTMF','MTKL','MTKL-ZAXI-19-0','1','19.550','19.540','1','19.550','19.540','100.00');
DELETE FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='MTKL-ZAXI-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZAXI-19-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260110-0001','2026-01-10','09:25','144.460','cashier1','2026-01-10 09:26:07');
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-00009131','X-00009131','KL ITALY ST BTR BT DSC 42CM KKT PER BLT SHB','GR','---','MDKL','BELI','BELI001','2714000','2026-01-10','2.950','1','sales','2026-01-10 10:11:04');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDKL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDKL','X-00009131','X-00009131');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260110-0001','FJ-250915-0001','2103','1','BELI','BELI001','MDKL', 'X-00009131', 'KL ITALY ST BTR BT DSC 42CM KKT PER BLT SHB','2.950','2.950','100.00','2537000','2714000','920000','1','2714000','2714000','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-10','BELI','BELI001','MDKL','MDKL','100.00','2.950','2.950','1','2.950','2.950','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260110-0001','2026-01-10','2026-01-10','10:11:04','2103','---','2.950','2714000','2714000','2714000','2714000','2714000','sales','2026-01-10 10:11:04','FB-260110-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260110-0001','IRMA','WONOKUSUMO JAYA 7/22','','','','sales','2026-01-10 10:11:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-10' 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,status_valid) VALUES ('KK-260110-0002','K','2026-01-10','10:11:04','sales','PEMBELIAN UMUM','FB-260110-0001','171576576','2714000','168862576','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260110-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260110-0001';
UPDATE tt_hutang_head SET byr_harus_rp='1000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'1015000',tgl_lunas='2026-01-10',status='CLOS',total_lunas='1015000' WHERE no_hutang='PI25-01636';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'1000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'1000000'  WHERE tanggal='2026-01-10';
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-260110-0003','D','2026-01-10','11:12:53','cashier1','HUTANG LUNAS','PI25-01636','168862576','1015000','169877576');
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01645','2105','1','CN KRW BUNGA TL 70 SRT 1LBR','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'3000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'3000000'  WHERE tanggal='2026-01-10'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01645','2026-01-10','2026-01-10','11:29:02','PLG0017860','2105','90','2026-04-10','sales','2026-01-10 11:29:01','3.960','3000000','3.00','270000','3270000','0','OPEN','13.98','1','2026-04-10','0','3270000')
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 ('KK-260110-0004','K','2026-01-10','11:29:02','sales','HUTANG','PI26-01645','169877576','3000000','166877576','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01645' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01645';
UPDATE tt_hutang_head SET byr_harus_rp='2000000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'2058000',tgl_lunas='2026-01-10',status='CLOS',total_lunas='2058000' WHERE no_hutang='PI25-01628';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'2000000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'2000000'  WHERE tanggal='2026-01-10';
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-260110-0005','D','2026-01-10','11:32:30','cashier1','HUTANG LUNAS','PI25-01628','166877576','2058000','168935576');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260110-0001','sales','1',' EX ','TOKO','BTGLMD','MDGL-YHBH-60-0','GL FANCY VAR 16CM KKT PER MK ','','2.550','1','100.00','2728500','0','0','0','2728500','0','0','0','2728500','2103','00025974','MDGL','150000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-YHBH-60-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.550',berat_jual_asli=berat_jual_asli+'2.550',stock_jual='1',berat_akhir=berat_akhir-'2.550',berat_akhir_asli=berat_akhir_asli-'2.550',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='MDGL-YHBH-60-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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 ('FJ-260110-0001','2026-01-10','2.550','2026-01-10','12:15:09','PLG0017861','2728500','2728500','0','2728500','2728500','sales','2026-01-10 12:15:08','FJ-260110-0001');
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-01-10','FJ-260110-0001','2026-01-10','12:15:09','2103','2728500','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-260110-0006','D','2026-01-10','12:15:09','sales','PENJUALAN','FJ-260110-0001','168935576','2728500','171664076');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260110-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260110-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260110-0001';
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01646','2106','1','GL COR FORTUNE LC2 8K SRT 1LBR','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'3500000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'3500000'  WHERE tanggal='2026-01-10'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01646','2026-01-10','2026-01-10','14:41:11','PLG0017862','2106','90','2026-04-10','sales','2026-01-10 14:41:11','13.430','3500000','3.00','315000','3815000','0','OPEN','29.43','1','2026-04-10','0','3815000')
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 ('KK-260110-0007','K','2026-01-10','14:41:11','sales','HUTANG','PI26-01646','171664076','3500000','168164076','OPEN') 
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01646' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01646';
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-00009132','X-00009132','CN COR EROPA SHB','GR','---','MDCN','BELI','BELI001','3072500','2026-01-10','3.340','1','sales','2026-01-10 14:48:05');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009132','X-00009132');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260110-0002','FJ-250913-0001','2502','1','BELI','BELI001','MDCN', 'X-00009132', 'CN COR EROPA SHB','3.340','3.340','100.00','2856000','3072500','919910','1','3072500','3072500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-10','BELI','BELI001','MDCN','MDCN','100.00','3.340','3.340','1','3.340','3.340','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260110-0002','2026-01-10','2026-01-10','14:48:05','2502','---','3.340','3072500','3072500','3072500','3072500','3072500','sales','2026-01-10 14:48:05','FB-260110-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260110-0002','IBU ROKAYAH','PENGAMPON 9/41','','','','sales','2026-01-10 14:48:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-01-10' 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,status_valid) VALUES ('KK-260110-0008','K','2026-01-10','14:48:05','sales','PEMBELIAN UMUM','FB-260110-0002','168164076','3072500','165091576','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260110-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260110-0002';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260110-0002','sales','1',' EX ','TOKO','BTKLMT','MTKL-WCBH-170-0','KL ITALY ST 42CM KKT PER BLT UBS ','','4.030','1','100.00','7435500','0','0','0','7435500','0','0','0','7435500','2105','00015131','MTKL','221500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTKL-WCBH-170-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.030',berat_jual_asli=berat_jual_asli+'4.030',stock_jual='1',berat_akhir=berat_akhir-'4.030',berat_akhir_asli=berat_akhir_asli-'4.030',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='MTKL-WCBH-170-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTKLMT' 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 ('FJ-260110-0002','2026-01-10','4.030','2026-01-10','15:55:00','PLG0017863','7435500','7435500','0','7435500','7435500','sales','2026-01-10 15:54:59','FJ-260110-0002');
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-01-10','FJ-260110-0002','2026-01-10','15:55:00','2105','7435500','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-260110-0009','D','2026-01-10','15:55:00','sales','PENJUALAN','FJ-260110-0002','165091576','7435500','172527076','OPEN');
UPDATE tt_jual_head SET dibayar_rp='7435500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260110-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260110-0003','sales',' 1',' EX ','TOKO','BTLTMT','MTLT-XIXE-90-0','LT COR BT AD BIRU UBS ','','1.760','1','100.00','3247500','0','0','0','3247500','0','0','0','3247500','2105','00020945','MTLT','221500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-01-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTLT-XIXE-90-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.760',berat_jual_asli=berat_jual_asli+'1.760',stock_jual='1',berat_akhir=berat_akhir-'1.760',berat_akhir_asli=berat_akhir_asli-'1.760',stock_akhir='0' WHERE tanggal='2026-01-10' AND kode_barang='MTLT-XIXE-90-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTLTMT' 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 ('FJ-260110-0003','2026-01-10','1.760','2026-01-10','15:55:00','PLG0017864','3247500','3247500','0','3247500','3247500','sales','2026-01-10 15:54:59','FJ-260110-0002');
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-01-10','FJ-260110-0003','2026-01-10','15:55:00','2105','3247500','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-260110-0010','D','2026-01-10','15:55:00','sales','PENJUALAN','FJ-260110-0003','172527076','3247500','175774576','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3247500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260110-0003' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260110-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260110-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260110-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260110-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260110-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260110-0003';