INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-02 ','08:03:27');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-02';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-01';
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-09-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-01';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-01' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-09-02';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-02 ','08:59:50');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-1-0','00031248',' ','KL FANCY PLT HURUF M 41CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','6624000','2026-09-02','6624000','3.600','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:03:58','3.590','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-1-0','00031248');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-1-0','MTKL','TOKO','INPUT1','100.00','3.600','3.590','1','3.600','3.590','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-2-0','00031249',' ','KL FANCY PLT HURUF R 41CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','6127500','2026-09-02','6127500','3.330','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:06:14','3.320','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-2-0','00031249');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-2-0','MTKL','TOKO','INPUT1','100.00','3.330','3.320','1','3.330','3.320','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-3-0','00031250',' ','KL FANCY PLT HURUF E 41CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','6017000','2026-09-02','6017000','3.270','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:07:44','3.260','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-3-0','00031250');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-3-0','MTKL','TOKO','INPUT1','100.00','3.270','3.260','1','3.270','3.260','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-4-0','00031251',' ','KL FANCY ANAK VAR BT 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','4011500','2026-09-02','4011500','2.180','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:12:07','2.170','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-4-0','00031251');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-4-0','MTKL','TOKO','INPUT1','100.00','2.180','2.170','1','2.180','2.170','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-5-0','00031252',' ','KL FANCY ANAK VAR BT 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','4398000','2026-09-02','4398000','2.390','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:13:37','2.380','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-5-0','00031252');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-5-0','MTKL','TOKO','INPUT1','100.00','2.390','2.380','1','2.390','2.380','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-6-0','00031253',' ','KL FANCY ANAK VAR BT 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','4048500','2026-09-02','4048500','2.200','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:15:31','2.190','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-6-0','00031253');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-6-0','MTKL','TOKO','INPUT1','100.00','2.200','2.190','1','2.200','2.190','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-7-0','00031254',' ','KL FANCY ANAK VAR BL BT 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','2815500','2026-09-02','2815500','1.530','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:17:43','1.520','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-7-0','00031254');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-7-0','MTKL','TOKO','INPUT1','100.00','1.530','1.520','1','1.530','1.520','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-8-0','00031255',' ','KL FANCY ANAK DB 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3680000','2026-09-02','3680000','2.000','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:20:18','1.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-8-0','00031255');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-8-0','MTKL','TOKO','INPUT1','100.00','2.000','1.990','1','2.000','1.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-9-0','00031256',' ','KL FANCY ANAK DB 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3698500','2026-09-02','3698500','2.010','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:23:24','2.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-9-0','00031256');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-9-0','MTKL','TOKO','INPUT1','100.00','2.010','2.000','1','2.010','2.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-10-0','00031257',' ','KL FANCY ANAK DB 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3698500','2026-09-02','3698500','2.010','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:25:43','2.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-10-0','00031257');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-10-0','MTKL','TOKO','INPUT1','100.00','2.010','2.000','1','2.010','2.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-11-0','00031258',' ','KL FANCY ANAK DB 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3754000','2026-09-02','3754000','2.040','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:30:26','2.030','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-11-0','00031258');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-11-0','MTKL','TOKO','INPUT1','100.00','2.040','2.030','1','2.040','2.030','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-12-0','00031259',' ','KL FANCY ANAK VAR BUNGA BT 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','2981000','2026-09-02','2981000','1.620','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:34:14','1.610','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-12-0','00031259');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-12-0','MTKL','TOKO','INPUT1','100.00','1.620','1.610','1','1.620','1.610','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-13-0','00031260',' ','KL FANCY ANAK VAR HT BT 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','2944000','2026-09-02','2944000','1.600','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:36:12','1.590','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-13-0','00031260');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-13-0','MTKL','TOKO','INPUT1','100.00','1.600','1.590','1','1.600','1.590','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-14-0','00031261',' ','KL FANCY ANAK VAR BT 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3698500','2026-09-02','3698500','2.010','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:40:47','2.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-14-0','00031261');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-14-0','MTKL','TOKO','INPUT1','100.00','2.010','2.000','1','2.010','2.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-15-0','00031262',' ','KL FANCY ANAK VAR BUNGA BT 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3018000','2026-09-02','3018000','1.640','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:43:18','1.630','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-15-0','00031262');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-15-0','MTKL','TOKO','INPUT1','100.00','1.640','1.630','1','1.640','1.630','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-16-0','00031263',' ','KL FANCY ANAK CAT 33CM KKT S MK ','','GR','---','MT','MTKL','TOKO','INPUT1','3735500','2026-09-02','3735500','2.030','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:44:39','2.020','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-16-0','00031263');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-16-0','MTKL','TOKO','INPUT1','100.00','2.030','2.020','1','2.030','2.020','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-17-0','00031264',' ','KL FANCY ANAK CAT 33CM KKT S MK ','','GR','---','MT','MTKL','TOKO','INPUT1','3680000','2026-09-02','3680000','2.000','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:45:33','1.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-17-0','00031264');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-17-0','MTKL','TOKO','INPUT1','100.00','2.000','1.990','1','2.000','1.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-18-0','00031265',' ','KL FANCY ANAK CAT 33CM KKT S MK ','','GR','---','MT','MTKL','TOKO','INPUT1','3680000','2026-09-02','3680000','2.000','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:47:07','1.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-18-0','00031265');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-18-0','MTKL','TOKO','INPUT1','100.00','2.000','1.990','1','2.000','1.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-19-0','00031266',' ','KL VIGARU FANCY ANAK CAT 34CM KKT S MK ','','GR','---','MT','MTKL','TOKO','INPUT1','4508000','2026-09-02','4508000','2.450','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:49:14','2.440','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-19-0','00031266');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-19-0','MTKL','TOKO','INPUT1','100.00','2.450','2.440','1','2.450','2.440','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-20-0','00031267',' ','KL KOREA 47CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','11058500','2026-09-02','11058500','6.010','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:51:24','6.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-20-0','00031267');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-20-0','MTKL','TOKO','INPUT1','100.00','6.010','6.000','1','6.010','6.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-21-0','00031268',' ','KL FANCY DB 42CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','4103500','2026-09-02','4103500','2.230','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:53:31','2.220','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-21-0','00031268');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-21-0','MTKL','TOKO','INPUT1','100.00','2.230','2.220','1','2.230','2.220','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-22-0','00031269',' ','KL VALENTINE 42CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','5520000','2026-09-02','5520000','3.000','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:54:59','2.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-22-0','00031269');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-22-0','MTKL','TOKO','INPUT1','100.00','3.000','2.990','1','3.000','2.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-23-0','00031270',' ','KL FANCY ANAK DB 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3717000','2026-09-02','3717000','2.020','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:56:58','2.010','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-23-0','00031270');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-23-0','MTKL','TOKO','INPUT1','100.00','2.020','2.010','1','2.020','2.010','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-24-0','00031271','EX ','KL FANCY ANAK DB 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3680000','2026-09-02','3680000','2.000','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 09:59:42','1.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-24-0','00031271');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-24-0','MTKL','TOKO','INPUT1','100.00','2.000','1.990','1','2.000','1.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-25-0','00031272','EX ','KL FANCY ANAK DB 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3680000','2026-09-02','3680000','2.000','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:01:24','1.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-25-0','00031272');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-25-0','MTKL','TOKO','INPUT1','100.00','2.000','1.990','1','2.000','1.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-26-0','00031273','EX ','KL FANCY ANAK VAR BT 34CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','2760000','2026-09-02','2760000','1.500','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:02:45','1.490','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-26-0','00031273');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-26-0','MTKL','TOKO','INPUT1','100.00','1.500','1.490','1','1.500','1.490','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-27-0','00031274','EX ','KL MILANO BT AD MRH 42CM KKT S SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','9605000','2026-09-02','9605000','5.220','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:06:11','5.210','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-27-0','00031274');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-27-0','MTKL','TOKO','INPUT1','100.00','5.220','5.210','1','5.220','5.210','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-28-0','00031275','EX ','KL MILANO 43CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','5354500','2026-09-02','5354500','2.910','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:10:45','2.900','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-28-0','00031275');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-28-0','MTKL','TOKO','INPUT1','100.00','2.910','2.900','1','2.910','2.900','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-29-0','00031276','EX ','KL MILANO 42CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3698500','2026-09-02','3698500','2.010','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:12:03','2.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-29-0','00031276');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-29-0','MTKL','TOKO','INPUT1','100.00','2.010','2.000','1','2.010','2.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-30-0','00031277','EX ','KL MILTA 44CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','14646500','2026-09-02','14646500','7.960','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:14:14','7.950','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-30-0','00031277');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-30-0','MTKL','TOKO','INPUT1','100.00','7.960','7.950','1','7.960','7.950','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-31-0','00031278','EX ','KL MILTA 43CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','13082500','2026-09-02','13082500','7.110','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:16:25','7.100','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-31-0','00031278');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-31-0','MTKL','TOKO','INPUT1','100.00','7.110','7.100','1','7.110','7.100','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-32-0','00031279','EX ','KL MILTA 45CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','11095500','2026-09-02','11095500','6.030','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:17:23','6.020','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-32-0','00031279');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-32-0','MTKL','TOKO','INPUT1','100.00','6.030','6.020','1','6.030','6.020','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-33-0','00031280','EX ','KL MILANO 42CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','7415500','2026-09-02','7415500','4.030','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:18:40','4.020','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-33-0','00031280');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-33-0','MTKL','TOKO','INPUT1','100.00','4.030','4.020','1','4.030','4.020','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-34-0','00031281','EX ','KL MILANO 46CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3606500','2026-09-02','3606500','1.960','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:20:32','1.950','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-34-0','00031281');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-34-0','MTKL','TOKO','INPUT1','100.00','1.960','1.950','1','1.960','1.950','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-35-0','00031282','EX ','KL ITALY CEMET 45CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3625000','2026-09-02','3625000','1.970','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:22:35','1.960','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-35-0','00031282');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-35-0','MTKL','TOKO','INPUT1','100.00','1.970','1.960','1','1.970','1.960','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-36-0','00031283','EX ','KL ITALY ST 42CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','4821000','2026-09-02','4821000','2.620','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:23:48','2.610','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-36-0','00031283');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-36-0','MTKL','TOKO','INPUT1','100.00','2.620','2.610','1','2.620','2.610','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-37-0','00031284','EX ','KL FANCY PJG 66CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','14352000','2026-09-02','14352000','7.800','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:29:10','7.790','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-37-0','00031284');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-37-0','MTKL','TOKO','INPUT1','100.00','7.800','7.790','1','7.800','7.790','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-38-0','00031285','EX ','KL FANCY 63CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','17866500','2026-09-02','17866500','9.710','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:30:35','9.700','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-38-0','00031285');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-38-0','MTKL','TOKO','INPUT1','100.00','9.710','9.700','1','9.710','9.700','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-39-0','00031286','EX ','KL FANCY 55CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','17719500','2026-09-02','17719500','9.630','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:32:43','9.620','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-39-0','00031286');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-39-0','MTKL','TOKO','INPUT1','100.00','9.630','9.620','1','9.630','9.620','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-40-0','00031287','EX ','KL MILANO 47CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','8059500','2026-09-02','8059500','4.380','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:35:03','4.370','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-40-0','00031287');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-40-0','MTKL','TOKO','INPUT1','100.00','4.380','4.370','1','4.380','4.370','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-41-0','00031288','EX ','KL MILANO ICE 42CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','5152000','2026-09-02','5152000','2.800','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:37:06','2.790','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-41-0','00031288');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-41-0','MTKL','TOKO','INPUT1','100.00','2.800','2.790','1','2.800','2.790','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-42-0','00031289','PM ','KL FANCY ANK TDK BT 39CM KKT PER BLT UBS ','PM','GR','---','MT','MTKL','TOKO','INPUT1','5612000','2026-09-02','5612000','3.050','100.00','16','229000','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:40:27','3.040','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-42-0','00031289');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-42-0','MTKL','TOKO','INPUT1','100.00','3.050','3.040','1','3.050','3.040','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-43-0','00031290',' ','KL ITALY ST ANAK CAT 35CM KKT PER BLT UBS ','','GR','---','MT','MTKL','TOKO','INPUT1','5814500','2026-09-02','5814500','3.160','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:42:29','3.150','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-43-0','00031290');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-43-0','MTKL','TOKO','INPUT1','100.00','3.160','3.150','1','3.160','3.150','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-44-0','00031291',' ','KL ITALY ST ANAK CAT 35CM KKT PER BLT UBS ','','GR','---','MT','MTKL','TOKO','INPUT1','5851500','2026-09-02','5851500','3.180','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:44:36','3.170','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-44-0','00031291');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-44-0','MTKL','TOKO','INPUT1','100.00','3.180','3.170','1','3.180','3.170','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-45-0','00031292',' ','KL ITALY ST ANAK CAT 35CM KKT PER BLT UBS ','','GR','---','MT','MTKL','TOKO','INPUT1','6348000','2026-09-02','6348000','3.450','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:45:49','3.440','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-45-0','00031292');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-45-0','MTKL','TOKO','INPUT1','100.00','3.450','3.440','1','3.450','3.440','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-46-0','00031293',' ','KL ITALY ST ANAK CAT 35CM KKT PER BLT UBS ','','GR','---','MT','MTKL','TOKO','INPUT1','5244000','2026-09-02','5244000','2.850','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:47:08','2.840','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-46-0','00031293');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-46-0','MTKL','TOKO','INPUT1','100.00','2.850','2.840','1','2.850','2.840','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-47-0','00031294',' ','KL ITALY ST ANAK CAT BT 35CM KKT PER BLT UBS ','','GR','---','MT','MTKL','TOKO','INPUT1','5410000','2026-09-02','5410000','2.940','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:49:27','2.930','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-47-0','00031294');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-47-0','MTKL','TOKO','INPUT1','100.00','2.940','2.930','1','2.940','2.930','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-48-0','00031295',' ','KL ITALY ST ANAK CAT 34CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','4821000','2026-09-02','4821000','2.620','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:50:51','2.610','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-48-0','00031295');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-48-0','MTKL','TOKO','INPUT1','100.00','2.620','2.610','1','2.620','2.610','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-49-0','00031296',' ','KL ITALY ST ANAK CAT 34CM KKT PER BLT MK ','','GR','---','MT','MTKL','TOKO','INPUT1','4858000','2026-09-02','4858000','2.640','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:52:26','2.630','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-49-0','00031296');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-49-0','MTKL','TOKO','INPUT1','100.00','2.640','2.630','1','2.640','2.630','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-50-0','00031297',' ','KL MILANO 43CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3643500','2026-09-02','3643500','1.980','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:54:50','1.970','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-50-0','00031297');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-50-0','MTKL','TOKO','INPUT1','100.00','1.980','1.970','1','1.980','1.970','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-51-0','00031298',' ','KL MILANO 43CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3625000','2026-09-02','3625000','1.970','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:57:51','1.960','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-51-0','00031298');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-51-0','MTKL','TOKO','INPUT1','100.00','1.970','1.960','1','1.970','1.960','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-52-0','00031299',' ','KL MILANO 47CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','7360000','2026-09-02','7360000','4.000','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 10:59:07','3.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-52-0','00031299');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-52-0','MTKL','TOKO','INPUT1','100.00','4.000','3.990','1','4.000','3.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-53-0','00031300',' ','KL MILANO 42CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','11058500','2026-09-02','11058500','6.010','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 11:00:17','6.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-53-0','00031300');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-53-0','MTKL','TOKO','INPUT1','100.00','6.010','6.000','1','6.010','6.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-54-0','00031301',' ','KL MILANO ICE 43CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','9200000','2026-09-02','9200000','5.000','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 11:01:31','4.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-54-0','00031301');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-54-0','MTKL','TOKO','INPUT1','100.00','5.000','4.990','1','5.000','4.990','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-55-0','00031302',' ','KL ITALY ST 41CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3790500','2026-09-02','3790500','2.060','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 11:03:02','2.050','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-55-0','00031302');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-55-0','MTKL','TOKO','INPUT1','100.00','2.060','2.050','1','2.060','2.050','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-56-0','00031303',' ','KL ITALY ST 41CM KKT PER BLT SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','3790500','2026-09-02','3790500','2.060','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 11:05:30','2.050','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-56-0','00031303');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-56-0','MTKL','TOKO','INPUT1','100.00','2.060','2.050','1','2.060','2.050','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZIXB-57-0','00031304',' ','KL CATENA VAR BT 42CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','8004500','2026-09-02','8004500','4.350','100.00','16','0','1840000.00','1','0.045', 'adminpusat','2026-09-02 11:07:23','4.340','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZIXB-57-0','00031304');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-09-02','MTKL-ZIXB-57-0','MTKL','TOKO','INPUT1','100.00','4.350','4.340','1','4.350','4.340','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','1','MTKL-ZIXB-1-0','1','3.600','3.600','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-1-0','100.00','1','3.600','3.590','1','3.600','3.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.600',berat_out_asli=berat_out_asli+'3.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','2','MTKL-ZIXB-2-0','1','3.330','3.330','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-2-0','100.00','1','3.330','3.320','1','3.330','3.320');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.330',berat_out_asli=berat_out_asli+'3.320',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','3','MTKL-ZIXB-3-0','1','3.270','3.270','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-3-0','100.00','1','3.270','3.260','1','3.270','3.260');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.270',berat_out_asli=berat_out_asli+'3.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','4','MTKL-ZIXB-4-0','1','2.180','2.180','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-4-0','100.00','1','2.180','2.170','1','2.180','2.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.180',berat_out_asli=berat_out_asli+'2.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','5','MTKL-ZIXB-5-0','1','2.390','2.390','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-5-0','100.00','1','2.390','2.380','1','2.390','2.380');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.390',berat_out_asli=berat_out_asli+'2.380',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','6','MTKL-ZIXB-6-0','1','2.200','2.200','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-6-0','100.00','1','2.200','2.190','1','2.200','2.190');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.200',berat_out_asli=berat_out_asli+'2.190',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','7','MTKL-ZIXB-7-0','1','1.530','1.530','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-7-0','100.00','1','1.530','1.520','1','1.530','1.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.530',berat_out_asli=berat_out_asli+'1.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','8','MTKL-ZIXB-8-0','1','2.000','2.000','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-8-0','100.00','1','2.000','1.990','1','2.000','1.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.000',berat_out_asli=berat_out_asli+'1.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','9','MTKL-ZIXB-9-0','1','2.010','2.010','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-9-0','100.00','1','2.010','2.000','1','2.010','2.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.010',berat_out_asli=berat_out_asli+'2.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','10','MTKL-ZIXB-10-0','1','2.010','2.010','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-10-0','100.00','1','2.010','2.000','1','2.010','2.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.010',berat_out_asli=berat_out_asli+'2.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','11','MTKL-ZIXB-11-0','1','2.040','2.040','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-11-0','100.00','1','2.040','2.030','1','2.040','2.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.040',berat_out_asli=berat_out_asli+'2.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','12','MTKL-ZIXB-12-0','1','1.620','1.620','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-12-0','100.00','1','1.620','1.610','1','1.620','1.610');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.620',berat_out_asli=berat_out_asli+'1.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','13','MTKL-ZIXB-13-0','1','1.600','1.600','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-13-0','100.00','1','1.600','1.590','1','1.600','1.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.600',berat_out_asli=berat_out_asli+'1.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','14','MTKL-ZIXB-14-0','1','2.010','2.010','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-14-0','100.00','1','2.010','2.000','1','2.010','2.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.010',berat_out_asli=berat_out_asli+'2.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','15','MTKL-ZIXB-15-0','1','1.640','1.640','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-15-0','100.00','1','1.640','1.630','1','1.640','1.630');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.640',berat_out_asli=berat_out_asli+'1.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','16','MTKL-ZIXB-16-0','1','2.030','2.030','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-16-0','100.00','1','2.030','2.020','1','2.030','2.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.030',berat_out_asli=berat_out_asli+'2.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','17','MTKL-ZIXB-17-0','1','2.000','2.000','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-17-0','100.00','1','2.000','1.990','1','2.000','1.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.000',berat_out_asli=berat_out_asli+'1.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','18','MTKL-ZIXB-18-0','1','2.000','2.000','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-18-0','100.00','1','2.000','1.990','1','2.000','1.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.000',berat_out_asli=berat_out_asli+'1.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','19','MTKL-ZIXB-19-0','1','2.450','2.450','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-19-0','100.00','1','2.450','2.440','1','2.450','2.440');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.450',berat_out_asli=berat_out_asli+'2.440',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','20','MTKL-ZIXB-20-0','1','6.010','6.010','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-20-0','100.00','1','6.010','6.000','1','6.010','6.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.010',berat_out_asli=berat_out_asli+'6.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','21','MTKL-ZIXB-21-0','1','2.230','2.230','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-21-0','100.00','1','2.230','2.220','1','2.230','2.220');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.230',berat_out_asli=berat_out_asli+'2.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','22','MTKL-ZIXB-22-0','1','3.000','3.000','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-22-0','100.00','1','3.000','2.990','1','3.000','2.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.000',berat_out_asli=berat_out_asli+'2.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','23','MTKL-ZIXB-23-0','1','2.020','2.020','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-23-0','100.00','1','2.020','2.010','1','2.020','2.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.020',berat_out_asli=berat_out_asli+'2.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','24','MTKL-ZIXB-24-0','1','2.000','2.000','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-24-0','100.00','1','2.000','1.990','1','2.000','1.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.000',berat_out_asli=berat_out_asli+'1.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','25','MTKL-ZIXB-25-0','1','2.000','2.000','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-25-0','100.00','1','2.000','1.990','1','2.000','1.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.000',berat_out_asli=berat_out_asli+'1.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','26','MTKL-ZIXB-26-0','1','1.500','1.500','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-26-0','100.00','1','1.500','1.490','1','1.500','1.490');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.500',berat_out_asli=berat_out_asli+'1.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','27','MTKL-ZIXB-27-0','1','5.220','5.220','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-27-0','100.00','1','5.220','5.210','1','5.220','5.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.220',berat_out_asli=berat_out_asli+'5.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','28','MTKL-ZIXB-28-0','1','2.910','2.910','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-28-0','100.00','1','2.910','2.900','1','2.910','2.900');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.910',berat_out_asli=berat_out_asli+'2.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','29','MTKL-ZIXB-29-0','1','2.010','2.010','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-29-0','100.00','1','2.010','2.000','1','2.010','2.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.010',berat_out_asli=berat_out_asli+'2.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','30','MTKL-ZIXB-30-0','1','7.960','7.960','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-30-0','100.00','1','7.960','7.950','1','7.960','7.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.960',berat_out_asli=berat_out_asli+'7.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','31','MTKL-ZIXB-31-0','1','7.110','7.110','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-31-0','100.00','1','7.110','7.100','1','7.110','7.100');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.110',berat_out_asli=berat_out_asli+'7.100',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','32','MTKL-ZIXB-32-0','1','6.030','6.030','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-32-0','100.00','1','6.030','6.020','1','6.030','6.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.030',berat_out_asli=berat_out_asli+'6.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','33','MTKL-ZIXB-33-0','1','4.030','4.030','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-33-0','100.00','1','4.030','4.020','1','4.030','4.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.030',berat_out_asli=berat_out_asli+'4.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','34','MTKL-ZIXB-34-0','1','1.960','1.960','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-34-0','100.00','1','1.960','1.950','1','1.960','1.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.960',berat_out_asli=berat_out_asli+'1.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','35','MTKL-ZIXB-35-0','1','1.970','1.970','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-35-0','100.00','1','1.970','1.960','1','1.970','1.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.970',berat_out_asli=berat_out_asli+'1.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','36','MTKL-ZIXB-36-0','1','2.620','2.620','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-36-0','100.00','1','2.620','2.610','1','2.620','2.610');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.620',berat_out_asli=berat_out_asli+'2.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','37','MTKL-ZIXB-37-0','1','7.800','7.800','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-37-0','100.00','1','7.800','7.790','1','7.800','7.790');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.800',berat_out_asli=berat_out_asli+'7.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','38','MTKL-ZIXB-38-0','1','9.710','9.710','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-38-0','100.00','1','9.710','9.700','1','9.710','9.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.710',berat_out_asli=berat_out_asli+'9.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','39','MTKL-ZIXB-39-0','1','9.630','9.630','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-39-0','100.00','1','9.630','9.620','1','9.630','9.620');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.630',berat_out_asli=berat_out_asli+'9.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','40','MTKL-ZIXB-40-0','1','4.380','4.380','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-40-0','100.00','1','4.380','4.370','1','4.380','4.370');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.380',berat_out_asli=berat_out_asli+'4.370',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','41','MTKL-ZIXB-41-0','1','2.800','2.800','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-41-0','100.00','1','2.800','2.790','1','2.800','2.790');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.800',berat_out_asli=berat_out_asli+'2.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','42','MTKL-ZIXB-42-0','1','3.050','3.050','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-42-0','100.00','1','3.050','3.040','1','3.050','3.040');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.050',berat_out_asli=berat_out_asli+'3.040',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','43','MTKL-ZIXB-43-0','1','3.160','3.160','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-43-0','100.00','1','3.160','3.150','1','3.160','3.150');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.160',berat_out_asli=berat_out_asli+'3.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','44','MTKL-ZIXB-44-0','1','3.180','3.180','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-44-0','100.00','1','3.180','3.170','1','3.180','3.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.180',berat_out_asli=berat_out_asli+'3.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','45','MTKL-ZIXB-45-0','1','3.450','3.450','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-45-0','100.00','1','3.450','3.440','1','3.450','3.440');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.450',berat_out_asli=berat_out_asli+'3.440',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','46','MTKL-ZIXB-46-0','1','2.850','2.850','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-46-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-46-0','100.00','1','2.850','2.840','1','2.850','2.840');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.850',berat_out_asli=berat_out_asli+'2.840',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-46-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','47','MTKL-ZIXB-47-0','1','2.940','2.940','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-47-0','100.00','1','2.940','2.930','1','2.940','2.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.940',berat_out_asli=berat_out_asli+'2.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-47-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','48','MTKL-ZIXB-48-0','1','2.620','2.620','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-48-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-48-0','100.00','1','2.620','2.610','1','2.620','2.610');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.620',berat_out_asli=berat_out_asli+'2.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-48-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','49','MTKL-ZIXB-49-0','1','2.640','2.640','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-49-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-49-0','100.00','1','2.640','2.630','1','2.640','2.630');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.640',berat_out_asli=berat_out_asli+'2.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-49-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','50','MTKL-ZIXB-50-0','1','1.980','1.980','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-50-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-50-0','100.00','1','1.980','1.970','1','1.980','1.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.980',berat_out_asli=berat_out_asli+'1.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-50-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','51','MTKL-ZIXB-51-0','1','1.970','1.970','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-51-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-51-0','100.00','1','1.970','1.960','1','1.970','1.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.970',berat_out_asli=berat_out_asli+'1.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-51-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','52','MTKL-ZIXB-52-0','1','4.000','4.000','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-52-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-52-0','100.00','1','4.000','3.990','1','4.000','3.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.000',berat_out_asli=berat_out_asli+'3.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-52-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','53','MTKL-ZIXB-53-0','1','6.010','6.010','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-53-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-53-0','100.00','1','6.010','6.000','1','6.010','6.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.010',berat_out_asli=berat_out_asli+'6.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-53-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','54','MTKL-ZIXB-54-0','1','5.000','5.000','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-54-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-54-0','100.00','1','5.000','4.990','1','5.000','4.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.000',berat_out_asli=berat_out_asli+'4.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-54-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','55','MTKL-ZIXB-55-0','1','2.060','2.060','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-55-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-55-0','100.00','1','2.060','2.050','1','2.060','2.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.060',berat_out_asli=berat_out_asli+'2.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-55-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','56','MTKL-ZIXB-56-0','1','2.060','2.060','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-56-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-56-0','100.00','1','2.060','2.050','1','2.060','2.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.060',berat_out_asli=berat_out_asli+'2.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-56-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260902-0001','57','MTKL-ZIXB-57-0','1','4.350','4.350','TOKO','INPUT1','TOKO','BKKLMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKKLMT' WHERE kode_barang='MTKL-ZIXB-57-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-09-02','TOKO','BKKLMT','MTKL','MTKL-ZIXB-57-0','100.00','1','4.350','4.340','1','4.350','4.340');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.350',berat_out_asli=berat_out_asli+'4.340',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-09-02' AND kode_barang='MTKL-ZIXB-57-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260902-0001','2026-09-02','2026-09-02','12:38','188.13','adminpusat','2026-09-02 12:42:55');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','1','MTKL-ZIXB-1-0','1','3.600','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-1-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-1-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.600',berat_out_asli='3.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.600',berat_akhir_asli =berat_akhir_asli-'3.590' WHERE kode_barang='MTKL-ZIXB-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','2','MTKL-ZIXB-2-0','1','3.330','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-2-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-2-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.330',berat_out_asli='3.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.330',berat_akhir_asli =berat_akhir_asli-'3.320' WHERE kode_barang='MTKL-ZIXB-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','3','MTKL-ZIXB-3-0','1','3.270','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-3-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-3-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.270',berat_out_asli='3.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.270',berat_akhir_asli =berat_akhir_asli-'3.260' WHERE kode_barang='MTKL-ZIXB-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','4','MTKL-ZIXB-4-0','1','2.180','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-4-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-4-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.180',berat_out_asli='2.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.180',berat_akhir_asli =berat_akhir_asli-'2.170' WHERE kode_barang='MTKL-ZIXB-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','5','MTKL-ZIXB-5-0','1','2.390','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-5-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-5-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.390',berat_out_asli='2.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.390',berat_akhir_asli =berat_akhir_asli-'2.380' WHERE kode_barang='MTKL-ZIXB-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','6','MTKL-ZIXB-6-0','1','2.200','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-6-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-6-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.200',berat_out_asli='2.190', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.200',berat_akhir_asli =berat_akhir_asli-'2.190' WHERE kode_barang='MTKL-ZIXB-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','7','MTKL-ZIXB-7-0','1','1.530','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-7-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-7-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.530',berat_out_asli='1.520', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.530',berat_akhir_asli =berat_akhir_asli-'1.520' WHERE kode_barang='MTKL-ZIXB-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','8','MTKL-ZIXB-8-0','1','2.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-8-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-8-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='1.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'1.990' WHERE kode_barang='MTKL-ZIXB-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','9','MTKL-ZIXB-9-0','1','2.010','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-9-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-9-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='MTKL-ZIXB-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','10','MTKL-ZIXB-10-0','1','2.010','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-10-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-10-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='MTKL-ZIXB-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','11','MTKL-ZIXB-11-0','1','2.040','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-11-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-11-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.040',berat_out_asli='2.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.040',berat_akhir_asli =berat_akhir_asli-'2.030' WHERE kode_barang='MTKL-ZIXB-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','12','MTKL-ZIXB-12-0','1','1.620','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-12-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-12-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.620',berat_out_asli='1.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.620',berat_akhir_asli =berat_akhir_asli-'1.610' WHERE kode_barang='MTKL-ZIXB-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','13','MTKL-ZIXB-13-0','1','1.600','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-13-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-13-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.600',berat_out_asli='1.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.600',berat_akhir_asli =berat_akhir_asli-'1.590' WHERE kode_barang='MTKL-ZIXB-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','14','MTKL-ZIXB-14-0','1','2.010','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-14-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-14-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='MTKL-ZIXB-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','15','MTKL-ZIXB-15-0','1','1.640','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-15-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-15-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.640',berat_out_asli='1.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.640',berat_akhir_asli =berat_akhir_asli-'1.630' WHERE kode_barang='MTKL-ZIXB-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','16','MTKL-ZIXB-16-0','1','2.030','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-16-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-16-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.030',berat_out_asli='2.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.030',berat_akhir_asli =berat_akhir_asli-'2.020' WHERE kode_barang='MTKL-ZIXB-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','17','MTKL-ZIXB-17-0','1','2.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-17-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-17-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='1.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'1.990' WHERE kode_barang='MTKL-ZIXB-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','18','MTKL-ZIXB-18-0','1','2.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-18-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-18-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='1.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'1.990' WHERE kode_barang='MTKL-ZIXB-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','19','MTKL-ZIXB-19-0','1','2.450','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-19-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-19-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.450',berat_out_asli='2.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.450',berat_akhir_asli =berat_akhir_asli-'2.440' WHERE kode_barang='MTKL-ZIXB-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','20','MTKL-ZIXB-20-0','1','6.010','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-20-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-20-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.010',berat_out_asli='6.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.010',berat_akhir_asli =berat_akhir_asli-'6.000' WHERE kode_barang='MTKL-ZIXB-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','21','MTKL-ZIXB-21-0','1','2.230','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-21-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-21-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.230',berat_out_asli='2.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.230',berat_akhir_asli =berat_akhir_asli-'2.220' WHERE kode_barang='MTKL-ZIXB-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','22','MTKL-ZIXB-22-0','1','3.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-22-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-22-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='2.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'2.990' WHERE kode_barang='MTKL-ZIXB-22-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','23','MTKL-ZIXB-23-0','1','2.020','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-23-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-23-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.020',berat_out_asli='2.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.020',berat_akhir_asli =berat_akhir_asli-'2.010' WHERE kode_barang='MTKL-ZIXB-23-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','24','MTKL-ZIXB-24-0','1','2.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-24-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-24-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='1.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'1.990' WHERE kode_barang='MTKL-ZIXB-24-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','25','MTKL-ZIXB-25-0','1','2.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-25-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-25-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='1.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'1.990' WHERE kode_barang='MTKL-ZIXB-25-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','26','MTKL-ZIXB-26-0','1','1.500','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-26-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-26-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.500',berat_out_asli='1.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.500',berat_akhir_asli =berat_akhir_asli-'1.490' WHERE kode_barang='MTKL-ZIXB-26-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','27','MTKL-ZIXB-27-0','1','5.220','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-27-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-27-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.220',berat_out_asli='5.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.220',berat_akhir_asli =berat_akhir_asli-'5.210' WHERE kode_barang='MTKL-ZIXB-27-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','28','MTKL-ZIXB-28-0','1','2.910','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-28-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-28-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.910',berat_out_asli='2.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.910',berat_akhir_asli =berat_akhir_asli-'2.900' WHERE kode_barang='MTKL-ZIXB-28-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','29','MTKL-ZIXB-29-0','1','2.010','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-29-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-29-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='MTKL-ZIXB-29-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','30','MTKL-ZIXB-30-0','1','7.960','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-30-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-30-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.960',berat_out_asli='7.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.960',berat_akhir_asli =berat_akhir_asli-'7.950' WHERE kode_barang='MTKL-ZIXB-30-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','31','MTKL-ZIXB-31-0','1','7.110','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-31-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-31-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.110',berat_out_asli='7.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.110',berat_akhir_asli =berat_akhir_asli-'7.100' WHERE kode_barang='MTKL-ZIXB-31-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','32','MTKL-ZIXB-32-0','1','6.030','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-32-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-32-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-32-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.030',berat_out_asli='6.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.030',berat_akhir_asli =berat_akhir_asli-'6.020' WHERE kode_barang='MTKL-ZIXB-32-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','33','MTKL-ZIXB-33-0','1','4.030','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-33-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-33-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-33-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.030',berat_out_asli='4.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.030',berat_akhir_asli =berat_akhir_asli-'4.020' WHERE kode_barang='MTKL-ZIXB-33-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','34','MTKL-ZIXB-34-0','1','1.960','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-34-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-34-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-34-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.960',berat_out_asli='1.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.960',berat_akhir_asli =berat_akhir_asli-'1.950' WHERE kode_barang='MTKL-ZIXB-34-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','35','MTKL-ZIXB-35-0','1','1.970','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-35-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-35-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-35-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.960' WHERE kode_barang='MTKL-ZIXB-35-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','36','MTKL-ZIXB-36-0','1','2.620','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-36-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-36-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.620',berat_out_asli='2.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.620',berat_akhir_asli =berat_akhir_asli-'2.610' WHERE kode_barang='MTKL-ZIXB-36-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','37','MTKL-ZIXB-37-0','1','7.800','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-37-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-37-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.800',berat_out_asli='7.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.800',berat_akhir_asli =berat_akhir_asli-'7.790' WHERE kode_barang='MTKL-ZIXB-37-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','38','MTKL-ZIXB-38-0','1','9.710','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-38-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-38-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-38-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.710',berat_out_asli='9.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.710',berat_akhir_asli =berat_akhir_asli-'9.700' WHERE kode_barang='MTKL-ZIXB-38-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','39','MTKL-ZIXB-39-0','1','9.630','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-39-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-39-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-39-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='9.630',berat_out_asli='9.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.630',berat_akhir_asli =berat_akhir_asli-'9.620' WHERE kode_barang='MTKL-ZIXB-39-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','40','MTKL-ZIXB-40-0','1','4.380','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-40-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-40-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-40-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.380',berat_out_asli='4.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.380',berat_akhir_asli =berat_akhir_asli-'4.370' WHERE kode_barang='MTKL-ZIXB-40-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','41','MTKL-ZIXB-41-0','1','2.800','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-41-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-41-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-41-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.800',berat_out_asli='2.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.800',berat_akhir_asli =berat_akhir_asli-'2.790' WHERE kode_barang='MTKL-ZIXB-41-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','42','MTKL-ZIXB-42-0','1','3.050','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-42-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-42-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-42-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.050',berat_out_asli='3.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.050',berat_akhir_asli =berat_akhir_asli-'3.040' WHERE kode_barang='MTKL-ZIXB-42-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','43','MTKL-ZIXB-43-0','1','3.160','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-43-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-43-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-43-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.160',berat_out_asli='3.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.160',berat_akhir_asli =berat_akhir_asli-'3.150' WHERE kode_barang='MTKL-ZIXB-43-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','44','MTKL-ZIXB-44-0','1','3.180','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-44-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-44-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-44-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.180',berat_out_asli='3.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.180',berat_akhir_asli =berat_akhir_asli-'3.170' WHERE kode_barang='MTKL-ZIXB-44-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','45','MTKL-ZIXB-45-0','1','3.450','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-45-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-45-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-45-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.450',berat_out_asli='3.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.450',berat_akhir_asli =berat_akhir_asli-'3.440' WHERE kode_barang='MTKL-ZIXB-45-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','46','MTKL-ZIXB-46-0','1','2.850','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-46-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-46-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-46-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.850',berat_out_asli='2.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.850',berat_akhir_asli =berat_akhir_asli-'2.840' WHERE kode_barang='MTKL-ZIXB-46-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','47','MTKL-ZIXB-47-0','1','2.940','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-47-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-47-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-47-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.940',berat_out_asli='2.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.940',berat_akhir_asli =berat_akhir_asli-'2.930' WHERE kode_barang='MTKL-ZIXB-47-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','48','MTKL-ZIXB-48-0','1','2.620','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-48-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-48-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-48-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.620',berat_out_asli='2.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.620',berat_akhir_asli =berat_akhir_asli-'2.610' WHERE kode_barang='MTKL-ZIXB-48-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','49','MTKL-ZIXB-49-0','1','2.640','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-49-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-49-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-49-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.640',berat_out_asli='2.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.640',berat_akhir_asli =berat_akhir_asli-'2.630' WHERE kode_barang='MTKL-ZIXB-49-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','50','MTKL-ZIXB-50-0','1','1.980','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-50-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-50-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-50-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.980',berat_out_asli='1.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.980',berat_akhir_asli =berat_akhir_asli-'1.970' WHERE kode_barang='MTKL-ZIXB-50-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','51','MTKL-ZIXB-51-0','1','1.970','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-51-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-51-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-51-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.960' WHERE kode_barang='MTKL-ZIXB-51-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','52','MTKL-ZIXB-52-0','1','4.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-52-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-52-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-52-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.000',berat_out_asli='3.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.000',berat_akhir_asli =berat_akhir_asli-'3.990' WHERE kode_barang='MTKL-ZIXB-52-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','53','MTKL-ZIXB-53-0','1','6.010','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-53-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-53-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-53-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='6.010',berat_out_asli='6.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.010',berat_akhir_asli =berat_akhir_asli-'6.000' WHERE kode_barang='MTKL-ZIXB-53-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','54','MTKL-ZIXB-54-0','1','5.000','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-54-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-54-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-54-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='4.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'4.990' WHERE kode_barang='MTKL-ZIXB-54-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','55','MTKL-ZIXB-55-0','1','2.060','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-55-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-55-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-55-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.060',berat_out_asli='2.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.060',berat_akhir_asli =berat_akhir_asli-'2.050' WHERE kode_barang='MTKL-ZIXB-55-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','56','MTKL-ZIXB-56-0','1','2.060','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-56-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-56-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-56-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.060',berat_out_asli='2.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.060',berat_akhir_asli =berat_akhir_asli-'2.050' WHERE kode_barang='MTKL-ZIXB-56-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260902-0001','57','MTKL-ZIXB-57-0','1','4.350','TOKO','BKKLMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTKL-ZIXB-57-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTKL-ZIXB-57-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKKLMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKKLMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTKL-ZIXB-57-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.350',berat_out_asli='4.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.350',berat_akhir_asli =berat_akhir_asli-'4.340' WHERE kode_barang='MTKL-ZIXB-57-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260902-0001','2026-09-02','2026-09-02','13:14','4.350','adminpusat','260902');