INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-16 ','08:01:48'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-15','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-15'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-14'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-14'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-11-14' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-14'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-14'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-14'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-14'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-15' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-14' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-11-15'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-16 ','08:02:53'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-16','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-16'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-15'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-15'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-11-15' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-15'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-15'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-15'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-15'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-16' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-15' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-11-16'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-16 ','10:42:58'); 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 ('MDCN-ZKAF-1-0','00032074',' ','CN COR LBG CAT LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','1559000','2026-11-16','1559000','1.430','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-16 10:47:50','1.420','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDCN' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDCN','MDCN-ZKAF-1-0','00032074'); 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-11-16','MDCN-ZKAF-1-0','MDCN','TOKO','INPUT1','100.00','1.430','1.420','1','1.430','1.420','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 ('MTGL-ZKAF-2-0','00032075',' ','GL CAP HOLLO 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5394000','2026-11-16','5394000','2.980','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 10:52:00','2.970','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-2-0','00032075'); 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-11-16','MTGL-ZKAF-2-0','MTGL','TOKO','INPUT1','100.00','2.980','2.970','1','2.980','2.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 ('MTGL-ZKAF-3-0','00032076',' ','GL PIPA ANAK KRC PLTR KOMB 6 SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','27150000','2026-11-16','27150000','15.000','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 10:59:00','14.990','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-3-0','00032076'); 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-11-16','MTGL-ZKAF-3-0','MTGL','TOKO','INPUT1','100.00','15.000','14.990','1','15.000','14.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 ('MTGL-ZKAF-4-0','00032077',' ','GL PLINTIR SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','18064000','2026-11-16','18064000','9.980','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 10:59:49','9.970','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-4-0','00032077'); 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-11-16','MTGL-ZKAF-4-0','MTGL','TOKO','INPUT1','100.00','9.980','9.970','1','9.980','9.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 ('MTGL-ZKAF-5-0','00032078','EX ','GL BANGKOK PLT SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','27729500','2026-11-16','27729500','15.320','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:05:04','15.310','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-5-0','00032078'); 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-11-16','MTGL-ZKAF-5-0','MTGL','TOKO','INPUT1','100.00','15.320','15.310','1','15.320','15.310','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 ('MTGL-ZKAF-6-0','00032079','EX ','GL PIPA TDK BT BG3 ','','GR','---','MT','MTGL','TOKO','INPUT1','35766000','2026-11-16','35766000','19.760','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:12:34','19.750','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-6-0','00032079'); 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-11-16','MTGL-ZKAF-6-0','MTGL','TOKO','INPUT1','100.00','19.760','19.750','1','19.760','19.750','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 ('MTGL-ZKAF-7-0','00032080','EX ','GL PIPA BT SMBR PTH BG3 ','','GR','---','MT','MTGL','TOKO','INPUT1','25087000','2026-11-16','25087000','13.860','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:15:21','13.850','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-7-0','00032080'); 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-11-16','MTGL-ZKAF-7-0','MTGL','TOKO','INPUT1','100.00','13.860','13.850','1','13.860','13.850','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 ('MTGL-ZKAF-8-0','00032081','EX ','GL PIPA ANK KRC 6 SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','20543500','2026-11-16','20543500','11.350','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:17:39','11.340','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-8-0','00032081'); 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-11-16','MTGL-ZKAF-8-0','MTGL','TOKO','INPUT1','100.00','11.350','11.340','1','11.350','11.340','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 ('MTGL-ZKAF-9-0','00032082','EX ','GL VANESSA HL RT PLT TDK BT 16CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','6082000','2026-11-16','6082000','3.360','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:21:13','3.350','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-9-0','00032082'); 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-11-16','MTGL-ZKAF-9-0','MTGL','TOKO','INPUT1','100.00','3.360','3.350','1','3.360','3.350','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 ('MTGL-ZKAF-10-0','00032083','EX ','GL VIGARU SMBR PTH 17CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','10769500','2026-11-16','10769500','5.950','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:23:43','5.940','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-10-0','00032083'); 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-11-16','MTGL-ZKAF-10-0','MTGL','TOKO','INPUT1','100.00','5.950','5.940','1','5.950','5.940','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 ('MTGL-ZKAF-11-0','00032084','EX ','GL VIGARU SMBR PTH 16CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','8869000','2026-11-16','8869000','4.900','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:26:21','4.890','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-11-0','00032084'); 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-11-16','MTGL-ZKAF-11-0','MTGL','TOKO','INPUT1','100.00','4.900','4.890','1','4.900','4.890','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 ('MTGL-ZKAF-12-0','00032085','EX ','GL MOCCA VIGARU SMBR PTH 17CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','6733500','2026-11-16','6733500','3.720','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:28:45','3.710','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-12-0','00032085'); 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-11-16','MTGL-ZKAF-12-0','MTGL','TOKO','INPUT1','100.00','3.720','3.710','1','3.720','3.710','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 ('MTGL-ZKAF-13-0','00032086','EX ','GL FANCY SRT VAR SMBR PTH 19CM KKT PER BLT UBS ','','GR','---','MT','MTGL','TOKO','INPUT1','3095500','2026-11-16','3095500','1.710','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:38:32','1.700','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-13-0','00032086'); 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-11-16','MTGL-ZKAF-13-0','MTGL','TOKO','INPUT1','100.00','1.710','1.700','1','1.710','1.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 ('MTGL-ZKAF-14-0','00032087','EX ','GL VANESSA VAR 16CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','7330500','2026-11-16','7330500','4.050','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:43:40','4.040','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-14-0','00032087'); 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-11-16','MTGL-ZKAF-14-0','MTGL','TOKO','INPUT1','100.00','4.050','4.040','1','4.050','4.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 ('MTGL-ZKAF-15-0','00032088',' ','GL VANESSA KBS 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6570500','2026-11-16','6570500','3.630','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:48:19','3.620','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-15-0','00032088'); 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-11-16','MTGL-ZKAF-15-0','MTGL','TOKO','INPUT1','100.00','3.630','3.620','1','3.630','3.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 ('MTGL-ZKAF-16-0','00032089',' ','GL VANESSA VAR BT 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','7711000','2026-11-16','7711000','4.260','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:51:56','4.250','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-16-0','00032089'); 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-11-16','MTGL-ZKAF-16-0','MTGL','TOKO','INPUT1','100.00','4.260','4.250','1','4.260','4.250','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 ('MTGL-ZKAF-17-0','00032090',' ','GL VANESSA BTR MN BT 17CM KKT S SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5828500','2026-11-16','5828500','3.220','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:54:21','3.210','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-17-0','00032090'); 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-11-16','MTGL-ZKAF-17-0','MTGL','TOKO','INPUT1','100.00','3.220','3.210','1','3.220','3.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 ('MTGL-ZKAF-18-0','00032091',' ','GL VANESSA DOLLAR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5520500','2026-11-16','5520500','3.050','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 11:57:07','3.040','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-18-0','00032091'); 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-11-16','MTGL-ZKAF-18-0','MTGL','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 ('MTGL-ZKAF-19-0','00032092',' ','GL VANESSA BTR HT 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6643000','2026-11-16','6643000','3.670','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:04:11','3.660','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-19-0','00032092'); 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-11-16','MTGL-ZKAF-19-0','MTGL','TOKO','INPUT1','100.00','3.670','3.660','1','3.670','3.660','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 ('MTGL-ZKAF-20-0','00032093',' ','GL VANESSA BTR HT 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6606500','2026-11-16','6606500','3.650','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:05:25','3.640','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-20-0','00032093'); 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-11-16','MTGL-ZKAF-20-0','MTGL','TOKO','INPUT1','100.00','3.650','3.640','1','3.650','3.640','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 ('MTGL-ZKAF-21-0','00032094',' ','GL VANESSA BTR BL CN BT 17CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','5303500','2026-11-16','5303500','2.930','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:10:13','2.920','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-21-0','00032094'); 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-11-16','MTGL-ZKAF-21-0','MTGL','TOKO','INPUT1','100.00','2.930','2.920','1','2.930','2.920','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 ('MTGL-ZKAF-22-0','00032095',' ','GL VANESSA VAR 16CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','6281000','2026-11-16','6281000','3.470','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:13:12','3.460','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-22-0','00032095'); 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-11-16','MTGL-ZKAF-22-0','MTGL','TOKO','INPUT1','100.00','3.470','3.460','1','3.470','3.460','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 ('MTGL-ZKAF-23-0','00032096',' ','GL CATENA DBL VAR BT 17CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','6534500','2026-11-16','6534500','3.610','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:17:13','3.600','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-23-0','00032096'); 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-11-16','MTGL-ZKAF-23-0','MTGL','TOKO','INPUT1','100.00','3.610','3.600','1','3.610','3.600','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 ('MTGL-ZKAF-24-0','00032097',' ','GL VANESSA DOLLAR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5466500','2026-11-16','5466500','3.020','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:22:13','3.010','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-24-0','00032097'); 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-11-16','MTGL-ZKAF-24-0','MTGL','TOKO','INPUT1','100.00','3.020','3.010','1','3.020','3.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 ('MTGL-ZKAF-25-0','00032098',' ','GL VANESSA VAR BTR BL PSR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6299000','2026-11-16','6299000','3.480','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:24:59','3.470','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-25-0','00032098'); 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-11-16','MTGL-ZKAF-25-0','MTGL','TOKO','INPUT1','100.00','3.480','3.470','1','3.480','3.470','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 ('MTGL-ZKAF-26-0','00032099',' ','GL VANESSA BL CN 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5448500','2026-11-16','5448500','3.010','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:29:38','3.000','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-26-0','00032099'); 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-11-16','MTGL-ZKAF-26-0','MTGL','TOKO','INPUT1','100.00','3.010','3.000','1','3.010','3.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 ('MTGL-ZKAF-27-0','00032100',' ','GL RANGKAIAN HT 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','7729000','2026-11-16','7729000','4.270','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:35:57','4.260','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-27-0','00032100'); 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-11-16','MTGL-ZKAF-27-0','MTGL','TOKO','INPUT1','100.00','4.270','4.260','1','4.270','4.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 ('MTGL-ZKAF-28-0','00032101',' ','GL BLB VAR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','7964500','2026-11-16','7964500','4.400','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:39:26','4.390','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-28-0','00032101'); 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-11-16','MTGL-ZKAF-28-0','MTGL','TOKO','INPUT1','100.00','4.400','4.390','1','4.400','4.390','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 ('MTGL-ZKAF-29-0','00032102',' ','GL BMB VAR BL PSR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8815000','2026-11-16','8815000','4.870','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:42:11','4.860','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-29-0','00032102'); 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-11-16','MTGL-ZKAF-29-0','MTGL','TOKO','INPUT1','100.00','4.870','4.860','1','4.870','4.860','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 ('MTGL-ZKAF-30-0','00032103',' ','GL JELITA BTR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8797000','2026-11-16','8797000','4.860','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:44:28','4.850','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-30-0','00032103'); 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-11-16','MTGL-ZKAF-30-0','MTGL','TOKO','INPUT1','100.00','4.860','4.850','1','4.860','4.850','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 ('MTGL-ZKAF-31-0','00032104',' ','GL JELITA BTR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8869000','2026-11-16','8869000','4.900','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:45:45','4.890','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-31-0','00032104'); 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-11-16','MTGL-ZKAF-31-0','MTGL','TOKO','INPUT1','100.00','4.900','4.890','1','4.900','4.890','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 ('MTGL-ZKAF-32-0','00032105',' ','GL RANGKAIAN BTR OVAL 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8163500','2026-11-16','8163500','4.510','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:48:44','4.500','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-32-0','00032105'); 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-11-16','MTGL-ZKAF-32-0','MTGL','TOKO','INPUT1','100.00','4.510','4.500','1','4.510','4.500','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 ('MTGL-ZKAF-33-0','00032106',' ','GL CATENA VAR HT 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8362500','2026-11-16','8362500','4.620','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:51:59','4.610','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-33-0','00032106'); 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-11-16','MTGL-ZKAF-33-0','MTGL','TOKO','INPUT1','100.00','4.620','4.610','1','4.620','4.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 ('MTGL-ZKAF-34-0','00032107',' ','GL CATENA VAR HT 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6082000','2026-11-16','6082000','3.360','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:54:43','3.350','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-34-0','00032107'); 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-11-16','MTGL-ZKAF-34-0','MTGL','TOKO','INPUT1','100.00','3.360','3.350','1','3.360','3.350','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 ('MTGL-ZKAF-35-0','00032108',' ','GL CATENA VAR BTR 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','4977500','2026-11-16','4977500','2.750','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:56:36','2.740','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-35-0','00032108'); 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-11-16','MTGL-ZKAF-35-0','MTGL','TOKO','INPUT1','100.00','2.750','2.740','1','2.750','2.740','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 ('MTGL-ZKAF-36-0','00032109',' ','GL CATENA VAR BT MN1 17CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','7530000','2026-11-16','7530000','4.160','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 12:59:38','4.150','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-36-0','00032109'); 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-11-16','MTGL-ZKAF-36-0','MTGL','TOKO','INPUT1','100.00','4.160','4.150','1','4.160','4.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 ('MTGL-ZKAF-37-0','00032110',' ','GL CAP PLT 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6715500','2026-11-16','6715500','3.710','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:02:48','3.700','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-37-0','00032110'); 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-11-16','MTGL-ZKAF-37-0','MTGL','TOKO','INPUT1','100.00','3.710','3.700','1','3.710','3.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 ('MTGL-ZKAF-38-0','00032111',' ','GL CAP PLT 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6570500','2026-11-16','6570500','3.630','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:04:37','3.620','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-38-0','00032111'); 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-11-16','MTGL-ZKAF-38-0','MTGL','TOKO','INPUT1','100.00','3.630','3.620','1','3.630','3.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 ('MTGL-ZKAF-39-0','00032112',' ','GL RANGKAIAN VAR 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8525500','2026-11-16','8525500','4.710','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:08:06','4.700','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-39-0','00032112'); 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-11-16','MTGL-ZKAF-39-0','MTGL','TOKO','INPUT1','100.00','4.710','4.700','1','4.710','4.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 ('MTGL-ZKAF-40-0','00032113',' ','GL RANGKAIAN VAR 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8235500','2026-11-16','8235500','4.550','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:09:34','4.540','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-40-0','00032113'); 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-11-16','MTGL-ZKAF-40-0','MTGL','TOKO','INPUT1','100.00','4.550','4.540','1','4.550','4.540','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 ('MTGL-ZKAF-41-0','00032114',' ','GL RANGKAIAN 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','9358000','2026-11-16','9358000','5.170','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:12:44','5.160','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-41-0','00032114'); 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-11-16','MTGL-ZKAF-41-0','MTGL','TOKO','INPUT1','100.00','5.170','5.160','1','5.170','5.160','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 ('MTGL-ZKAF-42-0','00032115',' ','GL SQUIDEST BTR 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8525500','2026-11-16','8525500','4.710','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:14:50','4.700','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-42-0','00032115'); 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-11-16','MTGL-ZKAF-42-0','MTGL','TOKO','INPUT1','100.00','4.710','4.700','1','4.710','4.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 ('MTGL-ZKAF-43-0','00032116',' ','GL FANCY SLP VAR 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','9846500','2026-11-16','9846500','5.440','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:20:38','5.430','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-43-0','00032116'); 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-11-16','MTGL-ZKAF-43-0','MTGL','TOKO','INPUT1','100.00','5.440','5.430','1','5.440','5.430','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 ('MTGL-ZKAF-44-0','00032117',' ','GL FANCY SLP VAR BTR BL PSR 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6516000','2026-11-16','6516000','3.600','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:23:52','3.590','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-44-0','00032117'); 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-11-16','MTGL-ZKAF-44-0','MTGL','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 ('MTGL-ZKAF-45-0','00032118',' ','GL RANGKAIAN MN BTR4 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8000500','2026-11-16','8000500','4.420','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:28:03','4.410','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-45-0','00032118'); 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-11-16','MTGL-ZKAF-45-0','MTGL','TOKO','INPUT1','100.00','4.420','4.410','1','4.420','4.410','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 ('MTGL-ZKAF-46-0','00032119',' ','GL RANGKAIAN MN BTR4 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8109000','2026-11-16','8109000','4.480','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:30:20','4.470','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-46-0','00032119'); 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-11-16','MTGL-ZKAF-46-0','MTGL','TOKO','INPUT1','100.00','4.480','4.470','1','4.480','4.470','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 ('MTGL-ZKAF-47-0','00032120',' ','GL RANGKAIAN MN BTR4 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8036500','2026-11-16','8036500','4.440','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:32:07','4.430','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-47-0','00032120'); 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-11-16','MTGL-ZKAF-47-0','MTGL','TOKO','INPUT1','100.00','4.440','4.430','1','4.440','4.430','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 ('MTGL-ZKAF-48-0','00032121',' ','GL VIGARU 5516 BTR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6751500','2026-11-16','6751500','3.730','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:34:50','3.720','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-48-0','00032121'); 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-11-16','MTGL-ZKAF-48-0','MTGL','TOKO','INPUT1','100.00','3.730','3.720','1','3.730','3.720','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 ('MTGL-ZKAF-49-0','00032122',' ','GL GUCCI VAR BTR 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6878000','2026-11-16','6878000','3.800','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:36:37','3.790','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-49-0','00032122'); 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-11-16','MTGL-ZKAF-49-0','MTGL','TOKO','INPUT1','100.00','3.800','3.790','1','3.800','3.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 ('MTGL-ZKAF-50-0','00032123',' ','GL GUCCI VAR BTR 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','7258500','2026-11-16','7258500','4.010','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:38:22','4.000','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-50-0','00032123'); 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-11-16','MTGL-ZKAF-50-0','MTGL','TOKO','INPUT1','100.00','4.010','4.000','1','4.010','4.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 ('MTGL-ZKAF-51-0','00032124',' ','GL VANESSA BLCHN VAR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6697000','2026-11-16','6697000','3.700','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:42:27','3.690','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-51-0','00032124'); 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-11-16','MTGL-ZKAF-51-0','MTGL','TOKO','INPUT1','100.00','3.700','3.690','1','3.700','3.690','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 ('MTGL-ZKAF-52-0','00032125',' ','GL BABY KWT BTR 1 BEL SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','3095500','2026-11-16','3095500','1.710','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:44:27','1.700','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-52-0','00032125'); 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-11-16','MTGL-ZKAF-52-0','MTGL','TOKO','INPUT1','100.00','1.710','1.700','1','1.710','1.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 ('MTGL-ZKAF-53-0','00032126',' ','GL BABY KWT BTR 1 BEL SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','3005000','2026-11-16','3005000','1.660','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:45:19','1.650','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-53-0','00032126'); 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-11-16','MTGL-ZKAF-53-0','MTGL','TOKO','INPUT1','100.00','1.660','1.650','1','1.660','1.650','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 ('MTGL-ZKAF-54-0','00032127',' ','GL BABY KWT BTR 1 BEL SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','4163500','2026-11-16','4163500','2.300','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:46:43','2.290','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-54-0','00032127'); 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-11-16','MTGL-ZKAF-54-0','MTGL','TOKO','INPUT1','100.00','2.300','2.290','1','2.300','2.290','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 ('MTGL-ZKAF-55-0','00032128',' ','GL BABY CAT BT SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','3837500','2026-11-16','3837500','2.120','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:48:55','2.110','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-55-0','00032128'); 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-11-16','MTGL-ZKAF-55-0','MTGL','TOKO','INPUT1','100.00','2.120','2.110','1','2.120','2.110','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 ('MTGL-ZKAF-56-0','00032129',' ','GL BABY CAT BT SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','4181500','2026-11-16','4181500','2.310','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:51:06','2.300','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-56-0','00032129'); 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-11-16','MTGL-ZKAF-56-0','MTGL','TOKO','INPUT1','100.00','2.310','2.300','1','2.310','2.300','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 ('MTGL-ZKAF-57-0','00032130',' ','GL PIPA CAT UBS ','','GR','---','MT','MTGL','TOKO','INPUT1','6462000','2026-11-16','6462000','3.570','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:54:23','3.560','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-57-0','00032130'); 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-11-16','MTGL-ZKAF-57-0','MTGL','TOKO','INPUT1','100.00','3.570','3.560','1','3.570','3.560','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 ('MTGL-ZKAF-58-0','00032131',' ','GL ANAK PIPA CAT UBS ','','GR','---','MT','MTGL','TOKO','INPUT1','4706000','2026-11-16','4706000','2.600','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:57:10','2.590','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-58-0','00032131'); 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-11-16','MTGL-ZKAF-58-0','MTGL','TOKO','INPUT1','100.00','2.600','2.590','1','2.600','2.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 ('MTGL-ZKAF-59-0','00032132','EX ','GL ANAK PIPA CAT UBS ','','GR','---','MT','MTGL','TOKO','INPUT1','5068000','2026-11-16','5068000','2.800','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 13:59:14','2.790','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-59-0','00032132'); 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-11-16','MTGL-ZKAF-59-0','MTGL','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 ('MTGL-ZKAF-60-0','00032133','EX ','GL BABY CAT BT SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','4290000','2026-11-16','4290000','2.370','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:00:48','2.360','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-60-0','00032133'); 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-11-16','MTGL-ZKAF-60-0','MTGL','TOKO','INPUT1','100.00','2.370','2.360','1','2.370','2.360','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 ('MTGL-ZKAF-61-0','00032134','EX ','GL ANAK PIPA TDK BT SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','3457500','2026-11-16','3457500','1.910','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:02:06','1.900','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-61-0','00032134'); 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-11-16','MTGL-ZKAF-61-0','MTGL','TOKO','INPUT1','100.00','1.910','1.900','1','1.910','1.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 ('MTGL-ZKAF-62-0','00032135','EX ','GL BABY KWT BTR 1 BEL SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5285500','2026-11-16','5285500','2.920','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:03:45','2.910','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-62-0','00032135'); 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-11-16','MTGL-ZKAF-62-0','MTGL','TOKO','INPUT1','100.00','2.920','2.910','1','2.920','2.910','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 ('MTGL-ZKAF-63-0','00032136','EX ','GL BABY KWT BTR 1 BEL SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','3023000','2026-11-16','3023000','1.670','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:04:50','1.660','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-63-0','00032136'); 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-11-16','MTGL-ZKAF-63-0','MTGL','TOKO','INPUT1','100.00','1.670','1.660','1','1.670','1.660','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 ('MTGL-ZKAF-64-0','00032137','EX ','GL ITALY ST SRT VAR BT 18CM KKT PER MK ','','GR','---','MT','MTGL','TOKO','INPUT1','7168000','2026-11-16','7168000','3.960','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:08:09','3.950','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-64-0','00032137'); 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-11-16','MTGL-ZKAF-64-0','MTGL','TOKO','INPUT1','100.00','3.960','3.950','1','3.960','3.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 ('MTGL-ZKAF-65-0','00032138','EX ','GL POPCORN VAR MN2 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8272000','2026-11-16','8272000','4.570','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:15:11','4.560','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-65-0','00032138'); 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-11-16','MTGL-ZKAF-65-0','MTGL','TOKO','INPUT1','100.00','4.570','4.560','1','4.570','4.560','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 ('MTGL-ZKAF-66-0','00032139','EX ','GL BLB VAR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6643000','2026-11-16','6643000','3.670','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:16:37','3.660','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-66-0','00032139'); 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-11-16','MTGL-ZKAF-66-0','MTGL','TOKO','INPUT1','100.00','3.670','3.660','1','3.670','3.660','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 ('MTGL-ZKAF-67-0','00032140','EX ','GL RANGKAIAN MN BTR4 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8054500','2026-11-16','8054500','4.450','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:18:55','4.440','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-67-0','00032140'); 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-11-16','MTGL-ZKAF-67-0','MTGL','TOKO','INPUT1','100.00','4.450','4.440','1','4.450','4.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 ('MTGL-ZKAF-68-0','00032141','EX ','GL GUCCI VIGARU VAR 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6444000','2026-11-16','6444000','3.560','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:21:27','3.550','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-68-0','00032141'); 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-11-16','MTGL-ZKAF-68-0','MTGL','TOKO','INPUT1','100.00','3.560','3.550','1','3.560','3.550','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 ('MTGL-ZKAF-69-0','00032142','EX ','GL VANESSA VAR BLCHN 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','4887000','2026-11-16','4887000','2.700','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:23:52','2.690','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-69-0','00032142'); 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-11-16','MTGL-ZKAF-69-0','MTGL','TOKO','INPUT1','100.00','2.700','2.690','1','2.700','2.690','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 ('MTGL-ZKAF-70-0','00032143','EX ','GL VANESSA VAR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','4959500','2026-11-16','4959500','2.740','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:25:50','2.730','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-70-0','00032143'); 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-11-16','MTGL-ZKAF-70-0','MTGL','TOKO','INPUT1','100.00','2.740','2.730','1','2.740','2.730','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 ('MTGL-ZKAF-71-0','00032144','EX ','GL VANESSA VAR BLCHN 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','4815000','2026-11-16','4815000','2.660','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:27:30','2.650','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-71-0','00032144'); 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-11-16','MTGL-ZKAF-71-0','MTGL','TOKO','INPUT1','100.00','2.660','2.650','1','2.660','2.650','1'); INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTGL-ZKAF-13-0','00032086','00032086','GL FANCY SRT VAR SMBR PTH 19CM KKT PER BLT UBS ','GL FANCY SRT VAR SMBR PTH 19CM KKT PER BLT UBS','','','3095500','3095500',' 0','0','adminpusat','2026-11-16 14:30:37'); UPDATE tm_barang SET nama_barang='GL FANCY SRT VAR SMBR PTH 19CM KKT PER BLT UBS' ,nama_atribut='' ,kode_intern='', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTGL-ZKAF-13-0' LIMIT 1; INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('MTGL-ZKAF-14-0','00032087','00032087','GL VANESSA VAR 16CM KKT PER MK ','GL VANESSA VAR 16CM KKT PER MK','','','7330500','7330500',' 0','0','adminpusat','2026-11-16 14:30:48'); UPDATE tm_barang SET nama_barang='GL VANESSA VAR 16CM KKT PER MK' ,nama_atribut='' ,kode_intern='', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTGL-ZKAF-14-0' LIMIT 1; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-16 ','14:32:25'); 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 ('MTGL-ZKAF-72-0','00032145','EX ','GL VANESSA VAR BL CN BT 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6842000','2026-11-16','6842000','3.780','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:34:53','3.770','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-72-0','00032145'); 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-11-16','MTGL-ZKAF-72-0','MTGL','TOKO','INPUT1','100.00','3.780','3.770','1','3.780','3.770','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 ('MTGL-ZKAF-73-0','00032146','EX ','GL RANGKAIAN BTR 16CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','6082000','2026-11-16','6082000','3.360','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:36:23','3.350','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-73-0','00032146'); 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-11-16','MTGL-ZKAF-73-0','MTGL','TOKO','INPUT1','100.00','3.360','3.350','1','3.360','3.350','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 ('MTGL-ZKAF-74-0','00032147','EX ','GL RANGKAIAN KWT BTR 17CM KKT S SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8416500','2026-11-16','8416500','4.650','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:38:13','4.640','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-74-0','00032147'); 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-11-16','MTGL-ZKAF-74-0','MTGL','TOKO','INPUT1','100.00','4.650','4.640','1','4.650','4.640','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 ('MTGL-ZKAF-75-0','00032148','EX ','GL SATELIT BTR 17CM KKT PER SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','8416500','2026-11-16','8416500','4.650','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:39:40','4.640','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-75-0','00032148'); 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-11-16','MTGL-ZKAF-75-0','MTGL','TOKO','INPUT1','100.00','4.650','4.640','1','4.650','4.640','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 ('MTGL-ZKAF-76-0','00032149','EX ','GL VIGARU 17CM KKT S SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','9919000','2026-11-16','9919000','5.480','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:42:01','5.470','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-76-0','00032149'); 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-11-16','MTGL-ZKAF-76-0','MTGL','TOKO','INPUT1','100.00','5.480','5.470','1','5.480','5.470','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 ('MTGL-ZKAF-77-0','00032150','EX ','GL MOCCA VIGARU MN5 16CM KKT S SHB ','','GR','---','MT','MTGL','TOKO','INPUT1','5701500','2026-11-16','5701500','3.150','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-16 14:44:04','3.140','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTGL','MTGL-ZKAF-77-0','00032150'); 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-11-16','MTGL-ZKAF-77-0','MTGL','TOKO','INPUT1','100.00','3.150','3.140','1','3.150','3.140','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-261116-0001','1','MDCN-ZKAF-1-0','1','1.430','1.430','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAF-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-11-16','TOKO','BCNMD','MDCN','MDCN-ZKAF-1-0','100.00','1','1.430','1.420','1','1.430','1.420'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.430',berat_out_asli=berat_out_asli+'1.420',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MDCN-ZKAF-1-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-261116-0001','2026-11-16','2026-11-16','15:39','1.43','adminpusat','2026-11-16 15:40:20'); 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-261116-0002','1','MTGL-ZKAF-2-0','1','2.980','2.980','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-2-0','100.00','1','2.980','2.970','1','2.980','2.970'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.980',berat_out_asli=berat_out_asli+'2.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','2','MTGL-ZKAF-3-0','1','15.000','15.000','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-3-0','100.00','1','15.000','14.990','1','15.000','14.990'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'15.000',berat_out_asli=berat_out_asli+'14.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','3','MTGL-ZKAF-4-0','1','9.980','9.980','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-4-0','100.00','1','9.980','9.970','1','9.980','9.970'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.980',berat_out_asli=berat_out_asli+'9.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','4','MTGL-ZKAF-5-0','1','15.320','15.320','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-5-0','100.00','1','15.320','15.310','1','15.320','15.310'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'15.320',berat_out_asli=berat_out_asli+'15.310',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','5','MTGL-ZKAF-6-0','1','19.760','19.760','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-6-0','100.00','1','19.760','19.750','1','19.760','19.750'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'19.760',berat_out_asli=berat_out_asli+'19.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','6','MTGL-ZKAF-7-0','1','13.860','13.860','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-7-0','100.00','1','13.860','13.850','1','13.860','13.850'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'13.860',berat_out_asli=berat_out_asli+'13.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','7','MTGL-ZKAF-8-0','1','11.350','11.350','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-8-0','100.00','1','11.350','11.340','1','11.350','11.340'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'11.350',berat_out_asli=berat_out_asli+'11.340',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','8','MTGL-ZKAF-9-0','1','3.360','3.360','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-9-0','100.00','1','3.360','3.350','1','3.360','3.350'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.360',berat_out_asli=berat_out_asli+'3.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','9','MTGL-ZKAF-10-0','1','5.950','5.950','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-10-0','100.00','1','5.950','5.940','1','5.950','5.940'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.950',berat_out_asli=berat_out_asli+'5.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','10','MTGL-ZKAF-11-0','1','4.900','4.900','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-11-0','100.00','1','4.900','4.890','1','4.900','4.890'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.900',berat_out_asli=berat_out_asli+'4.890',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','11','MTGL-ZKAF-12-0','1','3.720','3.720','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-12-0','100.00','1','3.720','3.710','1','3.720','3.710'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.720',berat_out_asli=berat_out_asli+'3.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','12','MTGL-ZKAF-13-0','1','1.710','1.710','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-13-0','100.00','1','1.710','1.700','1','1.710','1.700'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.710',berat_out_asli=berat_out_asli+'1.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','13','MTGL-ZKAF-14-0','1','4.050','4.050','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-14-0','100.00','1','4.050','4.040','1','4.050','4.040'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.050',berat_out_asli=berat_out_asli+'4.040',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','14','MTGL-ZKAF-15-0','1','3.630','3.630','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-15-0','100.00','1','3.630','3.620','1','3.630','3.620'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.630',berat_out_asli=berat_out_asli+'3.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','15','MTGL-ZKAF-16-0','1','4.260','4.260','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-16-0','100.00','1','4.260','4.250','1','4.260','4.250'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.260',berat_out_asli=berat_out_asli+'4.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','16','MTGL-ZKAF-17-0','1','3.220','3.220','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-17-0','100.00','1','3.220','3.210','1','3.220','3.210'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.220',berat_out_asli=berat_out_asli+'3.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','17','MTGL-ZKAF-18-0','1','3.050','3.050','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-18-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-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','18','MTGL-ZKAF-19-0','1','3.670','3.670','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-19-0','100.00','1','3.670','3.660','1','3.670','3.660'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.670',berat_out_asli=berat_out_asli+'3.660',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','19','MTGL-ZKAF-20-0','1','3.650','3.650','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-20-0','100.00','1','3.650','3.640','1','3.650','3.640'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.650',berat_out_asli=berat_out_asli+'3.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','20','MTGL-ZKAF-21-0','1','2.930','2.930','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-21-0','100.00','1','2.930','2.920','1','2.930','2.920'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.930',berat_out_asli=berat_out_asli+'2.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','21','MTGL-ZKAF-22-0','1','3.470','3.470','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-22-0','100.00','1','3.470','3.460','1','3.470','3.460'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.470',berat_out_asli=berat_out_asli+'3.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','22','MTGL-ZKAF-23-0','1','3.610','3.610','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-23-0','100.00','1','3.610','3.600','1','3.610','3.600'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.610',berat_out_asli=berat_out_asli+'3.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','23','MTGL-ZKAF-24-0','1','3.020','3.020','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-24-0','100.00','1','3.020','3.010','1','3.020','3.010'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.020',berat_out_asli=berat_out_asli+'3.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','24','MTGL-ZKAF-25-0','1','3.480','3.480','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-25-0','100.00','1','3.480','3.470','1','3.480','3.470'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.480',berat_out_asli=berat_out_asli+'3.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','25','MTGL-ZKAF-26-0','1','3.010','3.010','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-26-0','100.00','1','3.010','3.000','1','3.010','3.000'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.010',berat_out_asli=berat_out_asli+'3.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','26','MTGL-ZKAF-27-0','1','4.270','4.270','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-27-0','100.00','1','4.270','4.260','1','4.270','4.260'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.270',berat_out_asli=berat_out_asli+'4.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','27','MTGL-ZKAF-28-0','1','4.400','4.400','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-28-0','100.00','1','4.400','4.390','1','4.400','4.390'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.400',berat_out_asli=berat_out_asli+'4.390',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','28','MTGL-ZKAF-29-0','1','4.870','4.870','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-29-0','100.00','1','4.870','4.860','1','4.870','4.860'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.870',berat_out_asli=berat_out_asli+'4.860',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','29','MTGL-ZKAF-30-0','1','4.860','4.860','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-30-0','100.00','1','4.860','4.850','1','4.860','4.850'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.860',berat_out_asli=berat_out_asli+'4.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','30','MTGL-ZKAF-31-0','1','4.900','4.900','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-31-0','100.00','1','4.900','4.890','1','4.900','4.890'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.900',berat_out_asli=berat_out_asli+'4.890',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','31','MTGL-ZKAF-32-0','1','4.510','4.510','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-32-0','100.00','1','4.510','4.500','1','4.510','4.500'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.510',berat_out_asli=berat_out_asli+'4.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','32','MTGL-ZKAF-33-0','1','4.620','4.620','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-33-0','100.00','1','4.620','4.610','1','4.620','4.610'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.620',berat_out_asli=berat_out_asli+'4.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','33','MTGL-ZKAF-34-0','1','3.360','3.360','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-34-0','100.00','1','3.360','3.350','1','3.360','3.350'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.360',berat_out_asli=berat_out_asli+'3.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','34','MTGL-ZKAF-35-0','1','2.750','2.750','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-35-0','100.00','1','2.750','2.740','1','2.750','2.740'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.750',berat_out_asli=berat_out_asli+'2.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','35','MTGL-ZKAF-36-0','1','4.160','4.160','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-36-0','100.00','1','4.160','4.150','1','4.160','4.150'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.160',berat_out_asli=berat_out_asli+'4.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','36','MTGL-ZKAF-37-0','1','3.710','3.710','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-37-0','100.00','1','3.710','3.700','1','3.710','3.700'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.710',berat_out_asli=berat_out_asli+'3.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','37','MTGL-ZKAF-38-0','1','3.630','3.630','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-38-0','100.00','1','3.630','3.620','1','3.630','3.620'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.630',berat_out_asli=berat_out_asli+'3.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','38','MTGL-ZKAF-39-0','1','4.710','4.710','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-39-0','100.00','1','4.710','4.700','1','4.710','4.700'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.710',berat_out_asli=berat_out_asli+'4.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','39','MTGL-ZKAF-40-0','1','4.550','4.550','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-40-0','100.00','1','4.550','4.540','1','4.550','4.540'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.550',berat_out_asli=berat_out_asli+'4.540',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','40','MTGL-ZKAF-41-0','1','5.170','5.170','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-41-0','100.00','1','5.170','5.160','1','5.170','5.160'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.170',berat_out_asli=berat_out_asli+'5.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','41','MTGL-ZKAF-42-0','1','4.710','4.710','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-42-0','100.00','1','4.710','4.700','1','4.710','4.700'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.710',berat_out_asli=berat_out_asli+'4.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','42','MTGL-ZKAF-43-0','1','5.440','5.440','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-43-0','100.00','1','5.440','5.430','1','5.440','5.430'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.440',berat_out_asli=berat_out_asli+'5.430',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','43','MTGL-ZKAF-44-0','1','3.600','3.600','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-44-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-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','44','MTGL-ZKAF-45-0','1','4.420','4.420','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-45-0','100.00','1','4.420','4.410','1','4.420','4.410'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.420',berat_out_asli=berat_out_asli+'4.410',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','45','MTGL-ZKAF-46-0','1','4.480','4.480','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-46-0','100.00','1','4.480','4.470','1','4.480','4.470'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.480',berat_out_asli=berat_out_asli+'4.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','46','MTGL-ZKAF-47-0','1','4.440','4.440','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-47-0','100.00','1','4.440','4.430','1','4.440','4.430'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.440',berat_out_asli=berat_out_asli+'4.430',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','47','MTGL-ZKAF-48-0','1','3.730','3.730','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-48-0','100.00','1','3.730','3.720','1','3.730','3.720'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.730',berat_out_asli=berat_out_asli+'3.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','48','MTGL-ZKAF-49-0','1','3.800','3.800','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-49-0','100.00','1','3.800','3.790','1','3.800','3.790'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.800',berat_out_asli=berat_out_asli+'3.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','49','MTGL-ZKAF-50-0','1','4.010','4.010','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-50-0','100.00','1','4.010','4.000','1','4.010','4.000'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.010',berat_out_asli=berat_out_asli+'4.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','50','MTGL-ZKAF-51-0','1','3.700','3.700','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-51-0','100.00','1','3.700','3.690','1','3.700','3.690'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.700',berat_out_asli=berat_out_asli+'3.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','51','MTGL-ZKAF-52-0','1','1.710','1.710','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-52-0','100.00','1','1.710','1.700','1','1.710','1.700'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.710',berat_out_asli=berat_out_asli+'1.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','52','MTGL-ZKAF-53-0','1','1.660','1.660','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-53-0','100.00','1','1.660','1.650','1','1.660','1.650'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.660',berat_out_asli=berat_out_asli+'1.650',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','53','MTGL-ZKAF-54-0','1','2.300','2.300','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-54-0','100.00','1','2.300','2.290','1','2.300','2.290'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.300',berat_out_asli=berat_out_asli+'2.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','54','MTGL-ZKAF-55-0','1','2.120','2.120','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-55-0','100.00','1','2.120','2.110','1','2.120','2.110'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.120',berat_out_asli=berat_out_asli+'2.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','55','MTGL-ZKAF-56-0','1','2.310','2.310','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-56-0','100.00','1','2.310','2.300','1','2.310','2.300'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.310',berat_out_asli=berat_out_asli+'2.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-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-261116-0002','56','MTGL-ZKAF-57-0','1','3.570','3.570','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-57-0','100.00','1','3.570','3.560','1','3.570','3.560'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.570',berat_out_asli=berat_out_asli+'3.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-57-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-261116-0002','57','MTGL-ZKAF-58-0','1','2.600','2.600','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-58-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-58-0','100.00','1','2.600','2.590','1','2.600','2.590'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.600',berat_out_asli=berat_out_asli+'2.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-58-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-261116-0002','58','MTGL-ZKAF-59-0','1','2.800','2.800','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-59-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-59-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-11-16' AND kode_barang='MTGL-ZKAF-59-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-261116-0002','59','MTGL-ZKAF-60-0','1','2.370','2.370','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-60-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-60-0','100.00','1','2.370','2.360','1','2.370','2.360'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.370',berat_out_asli=berat_out_asli+'2.360',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-60-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-261116-0002','60','MTGL-ZKAF-61-0','1','1.910','1.910','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-61-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-61-0','100.00','1','1.910','1.900','1','1.910','1.900'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.910',berat_out_asli=berat_out_asli+'1.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-61-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-261116-0002','61','MTGL-ZKAF-62-0','1','2.920','2.920','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-62-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-62-0','100.00','1','2.920','2.910','1','2.920','2.910'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.920',berat_out_asli=berat_out_asli+'2.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-62-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-261116-0002','62','MTGL-ZKAF-63-0','1','1.670','1.670','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-63-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-63-0','100.00','1','1.670','1.660','1','1.670','1.660'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.670',berat_out_asli=berat_out_asli+'1.660',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-63-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-261116-0002','63','MTGL-ZKAF-64-0','1','3.960','3.960','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-64-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-64-0','100.00','1','3.960','3.950','1','3.960','3.950'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.960',berat_out_asli=berat_out_asli+'3.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-64-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-261116-0002','64','MTGL-ZKAF-65-0','1','4.570','4.570','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-65-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-65-0','100.00','1','4.570','4.560','1','4.570','4.560'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.570',berat_out_asli=berat_out_asli+'4.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-65-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-261116-0002','65','MTGL-ZKAF-66-0','1','3.670','3.670','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-66-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-66-0','100.00','1','3.670','3.660','1','3.670','3.660'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.670',berat_out_asli=berat_out_asli+'3.660',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-66-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-261116-0002','66','MTGL-ZKAF-67-0','1','4.450','4.450','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-67-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-67-0','100.00','1','4.450','4.440','1','4.450','4.440'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.450',berat_out_asli=berat_out_asli+'4.440',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-67-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-261116-0002','67','MTGL-ZKAF-68-0','1','3.560','3.560','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-68-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-68-0','100.00','1','3.560','3.550','1','3.560','3.550'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.560',berat_out_asli=berat_out_asli+'3.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-68-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-261116-0002','68','MTGL-ZKAF-69-0','1','2.700','2.700','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-69-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-69-0','100.00','1','2.700','2.690','1','2.700','2.690'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.700',berat_out_asli=berat_out_asli+'2.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-69-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-261116-0002','69','MTGL-ZKAF-70-0','1','2.740','2.740','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-70-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-70-0','100.00','1','2.740','2.730','1','2.740','2.730'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.740',berat_out_asli=berat_out_asli+'2.730',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-70-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-261116-0002','70','MTGL-ZKAF-71-0','1','2.660','2.660','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-71-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-71-0','100.00','1','2.660','2.650','1','2.660','2.650'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.660',berat_out_asli=berat_out_asli+'2.650',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-71-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-261116-0002','71','MTGL-ZKAF-72-0','1','3.780','3.780','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-72-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-72-0','100.00','1','3.780','3.770','1','3.780','3.770'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.780',berat_out_asli=berat_out_asli+'3.770',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-72-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-261116-0002','72','MTGL-ZKAF-73-0','1','3.360','3.360','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-73-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-73-0','100.00','1','3.360','3.350','1','3.360','3.350'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.360',berat_out_asli=berat_out_asli+'3.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-73-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-261116-0002','73','MTGL-ZKAF-74-0','1','4.650','4.650','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-74-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-74-0','100.00','1','4.650','4.640','1','4.650','4.640'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.650',berat_out_asli=berat_out_asli+'4.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-74-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-261116-0002','74','MTGL-ZKAF-75-0','1','4.650','4.650','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-75-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-75-0','100.00','1','4.650','4.640','1','4.650','4.640'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.650',berat_out_asli=berat_out_asli+'4.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-75-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-261116-0002','75','MTGL-ZKAF-76-0','1','5.480','5.480','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-76-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-76-0','100.00','1','5.480','5.470','1','5.480','5.470'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.480',berat_out_asli=berat_out_asli+'5.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-76-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-261116-0002','76','MTGL-ZKAF-77-0','1','3.150','3.150','TOKO','INPUT1','TOKO','BKGLMT'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKGLMT' WHERE kode_barang='MTGL-ZKAF-77-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-11-16','TOKO','BKGLMT','MTGL','MTGL-ZKAF-77-0','100.00','1','3.150','3.140','1','3.150','3.140'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.150',berat_out_asli=berat_out_asli+'3.140',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-16' AND kode_barang='MTGL-ZKAF-77-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-261116-0002','2026-11-16','2026-11-16','15:40','341.06','adminpusat','2026-11-16 15:48:18');