INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-13 ','08:06:42'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-13','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-13'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-12'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-12'; 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-12' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-12'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-12'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-12'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-12'; 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-13' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-12' 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-13'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-13 ','08:53:02'); 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-ZKAB-39-0','00031990','00031990','GL ITALY ST SRT VAR BT 17CM KKT PER BLT MK ','GL ITALY ST SRT VAR BT 17CM KKT PER MK','','','6100000','6100000',' 0','0','adminpusat','2026-11-13 09:16:01'); UPDATE tm_barang SET nama_barang='GL ITALY ST SRT VAR BT 17CM KKT PER MK' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='16.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MTGL-ZKAB-39-0' LIMIT 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 ('MDAT-ZKAC-1-0','00032011','EX ','AT TINDIK POLOS SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','512500','2026-11-13','512500','0.470','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 09:32:41','0.460','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZKAC-1-0','00032011'); 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-13','MDAT-ZKAC-1-0','MDAT','TOKO','INPUT1','100.00','0.470','0.460','1','0.470','0.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 ('MDAT-ZKAC-2-0','00032012','EX ','AT JEPSI POLOS SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','512500','2026-11-13','512500','0.470','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 09:37:15','0.460','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZKAC-2-0','00032012'); 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-13','MDAT-ZKAC-2-0','MDAT','TOKO','INPUT1','100.00','0.470','0.460','1','0.470','0.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 ('MDAT-ZKAC-3-0','00032013','EX ','AT CAP KWT BTR BT SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','1951500','2026-11-13','1951500','1.790','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 09:40:28','1.780','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZKAC-3-0','00032013'); 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-13','MDAT-ZKAC-3-0','MDAT','TOKO','INPUT1','100.00','1.790','1.780','1','1.790','1.780','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 ('MDAT-ZKAC-4-0','00032014','EX ','AT COR KWT TDK BT LC2 ','','GR','---','MD','MDAT','TOKO','INPUT1','992000','2026-11-13','992000','0.910','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 09:42:39','0.900','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZKAC-4-0','00032014'); 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-13','MDAT-ZKAC-4-0','MDAT','TOKO','INPUT1','100.00','0.910','0.900','1','0.910','0.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 ('MDAT-ZKAC-5-0','00032015','EX ','AT COR KWT FORT LC2 ','','GR','---','MD','MDAT','TOKO','INPUT1','3183000','2026-11-13','3183000','2.920','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 09:45:15','2.910','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZKAC-5-0','00032015'); 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-13','MDAT-ZKAC-5-0','MDAT','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 ('MDAT-ZKAC-6-0','00032016','EX ','AT ITALY HT BT MK ','','GR','---','MD','MDAT','TOKO','INPUT1','1188500','2026-11-13','1188500','1.090','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 09:48:14','1.080','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZKAC-6-0','00032016'); 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-13','MDAT-ZKAC-6-0','MDAT','TOKO','INPUT1','100.00','1.090','1.080','1','1.090','1.080','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 ('MDAT-ZKAC-7-0','00032017','EX ','AT ITALY KUPU BT SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','1144500','2026-11-13','1144500','1.050','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 09:51:18','1.040','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZKAC-7-0','00032017'); 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-13','MDAT-ZKAC-7-0','MDAT','TOKO','INPUT1','100.00','1.050','1.040','1','1.050','1.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 ('MDAT-ZKAC-8-0','00032018','EX ','AT ANAK COR KLP TDK BT UBS ','','GR','---','MD','MDAT','TOKO','INPUT1','1428000','2026-11-13','1428000','1.310','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 09:54:20','1.300','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZKAC-8-0','00032018'); 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-13','MDAT-ZKAC-8-0','MDAT','TOKO','INPUT1','100.00','1.310','1.300','1','1.310','1.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 ('MDAT-ZKAC-9-0','00032019','EX ','AT TUSUK ITALY TDK BT SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','1602500','2026-11-13','1602500','1.470','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 09:58:48','1.460','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZKAC-9-0','00032019'); 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-13','MDAT-ZKAC-9-0','MDAT','TOKO','INPUT1','100.00','1.470','1.460','1','1.470','1.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 ('MDCN-ZKAC-10-0','00032020','EX ','CN COR TDK BT SMBR PTH LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','3924000','2026-11-13','3924000','3.600','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:02:47','3.590','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-ZKAC-10-0','00032020'); 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-13','MDCN-ZKAC-10-0','MDCN','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 ('MDCN-ZKAC-11-0','00032021','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2420000','2026-11-13','2420000','2.220','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:05:00','2.210','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-ZKAC-11-0','00032021'); 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-13','MDCN-ZKAC-11-0','MDCN','TOKO','INPUT1','100.00','2.220','2.210','1','2.220','2.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 ('MDCN-ZKAC-12-0','00032022','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','959500','2026-11-13','959500','0.880','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:06:52','0.870','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-ZKAC-12-0','00032022'); 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-13','MDCN-ZKAC-12-0','MDCN','TOKO','INPUT1','100.00','0.880','0.870','1','0.880','0.870','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 ('MDCN-ZKAC-13-0','00032023','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','894000','2026-11-13','894000','0.820','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:10:03','0.810','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-ZKAC-13-0','00032023'); 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-13','MDCN-ZKAC-13-0','MDCN','TOKO','INPUT1','100.00','0.820','0.810','1','0.820','0.810','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 ('MDCN-ZKAC-14-0','00032024','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1003000','2026-11-13','1003000','0.920','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:13:36','0.910','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-ZKAC-14-0','00032024'); 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-13','MDCN-ZKAC-14-0','MDCN','TOKO','INPUT1','100.00','0.920','0.910','1','0.920','0.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 ('MDCN-ZKAC-15-0','00032025','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','796000','2026-11-13','796000','0.730','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:15:41','0.720','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-ZKAC-15-0','00032025'); 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-13','MDCN-ZKAC-15-0','MDCN','TOKO','INPUT1','100.00','0.730','0.720','1','0.730','0.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 ('MDCN-ZKAC-16-0','00032026','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','905000','2026-11-13','905000','0.830','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:17:22','0.820','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-ZKAC-16-0','00032026'); 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-13','MDCN-ZKAC-16-0','MDCN','TOKO','INPUT1','100.00','0.830','0.820','1','0.830','0.820','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 ('MDCN-ZKAC-17-0','00032027','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1602500','2026-11-13','1602500','1.470','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:19:19','1.460','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-ZKAC-17-0','00032027'); 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-13','MDCN-ZKAC-17-0','MDCN','TOKO','INPUT1','100.00','1.470','1.460','1','1.470','1.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 ('MDCN-ZKAC-18-0','00032028','EX ','CN COR BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1471500','2026-11-13','1471500','1.350','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:21:21','1.340','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-ZKAC-18-0','00032028'); 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-13','MDCN-ZKAC-18-0','MDCN','TOKO','INPUT1','100.00','1.350','1.340','1','1.350','1.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 ('MDCN-ZKAC-19-0','00032029','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','1166500','2026-11-13','1166500','1.070','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:22:29','1.060','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-ZKAC-19-0','00032029'); 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-13','MDCN-ZKAC-19-0','MDCN','TOKO','INPUT1','100.00','1.070','1.060','1','1.070','1.060','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 ('MDCN-ZKAC-20-0','00032030','EX ','CN COR BT MK ','','GR','---','MD','MDCN','TOKO','INPUT1','796000','2026-11-13','796000','0.730','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:23:50','0.720','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-ZKAC-20-0','00032030'); 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-13','MDCN-ZKAC-20-0','MDCN','TOKO','INPUT1','100.00','0.730','0.720','1','0.730','0.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 ('MDCN-ZKAC-21-0','00032031','EX ','CN COR CAT BT BTG ','','GR','---','MD','MDCN','TOKO','INPUT1','850500','2026-11-13','850500','0.780','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:25:33','0.770','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-ZKAC-21-0','00032031'); 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-13','MDCN-ZKAC-21-0','MDCN','TOKO','INPUT1','100.00','0.780','0.770','1','0.780','0.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 ('MDCN-ZKAC-22-0','00032032','EX ','CN BRILLIANT BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','719500','2026-11-13','719500','0.660','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:26:54','0.650','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-ZKAC-22-0','00032032'); 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-13','MDCN-ZKAC-22-0','MDCN','TOKO','INPUT1','100.00','0.660','0.650','1','0.660','0.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 ('MDCN-ZKAC-23-0','00032033','EX ','CN COR EROPA SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','5385000','2026-11-13','5385000','4.940','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:29:04','4.930','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-ZKAC-23-0','00032033'); 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-13','MDCN-ZKAC-23-0','MDCN','TOKO','INPUT1','100.00','4.940','4.930','1','4.940','4.930','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-ZKAC-24-0','00032034','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2125500','2026-11-13','2125500','1.950','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:31:22','1.940','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-ZKAC-24-0','00032034'); 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-13','MDCN-ZKAC-24-0','MDCN','TOKO','INPUT1','100.00','1.950','1.940','1','1.950','1.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 ('MDCN-ZKAC-25-0','00032035','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1907500','2026-11-13','1907500','1.750','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:32:46','1.740','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-ZKAC-25-0','00032035'); 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-13','MDCN-ZKAC-25-0','MDCN','TOKO','INPUT1','100.00','1.750','1.740','1','1.750','1.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 ('MDCN-ZKAC-26-0','00032036','EX ','CN COR DB SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1112000','2026-11-13','1112000','1.020','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:34:36','1.010','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-ZKAC-26-0','00032036'); 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-13','MDCN-ZKAC-26-0','MDCN','TOKO','INPUT1','100.00','1.020','1.010','1','1.020','1.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 ('MDCN-ZKAC-27-0','00032037','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2158500','2026-11-13','2158500','1.980','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:36:47','1.970','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-ZKAC-27-0','00032037'); 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-13','MDCN-ZKAC-27-0','MDCN','TOKO','INPUT1','100.00','1.980','1.970','1','1.980','1.970','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-ZKAC-28-0','00032038','EX ','CN COR TDK BT MN GYG LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','4109500','2026-11-13','4109500','3.770','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:38:35','3.760','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-ZKAC-28-0','00032038'); 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-13','MDCN-ZKAC-28-0','MDCN','TOKO','INPUT1','100.00','3.770','3.760','1','3.770','3.760','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 ('MDCN-ZKAC-29-0','00032039','EX ','CN COR FORT LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','3717000','2026-11-13','3717000','3.410','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:40:16','3.400','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-ZKAC-29-0','00032039'); 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-13','MDCN-ZKAC-29-0','MDCN','TOKO','INPUT1','100.00','3.410','3.400','1','3.410','3.400','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 ('MDCN-ZKAC-30-0','00032040','EX ','CN COR TDK BT LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','2594500','2026-11-13','2594500','2.380','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:41:33','2.370','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-ZKAC-30-0','00032040'); 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-13','MDCN-ZKAC-30-0','MDCN','TOKO','INPUT1','100.00','2.380','2.370','1','2.380','2.370','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-ZKAC-31-0','00032041','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1384500','2026-11-13','1384500','1.270','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:43:03','1.260','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-ZKAC-31-0','00032041'); 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-13','MDCN-ZKAC-31-0','MDCN','TOKO','INPUT1','100.00','1.270','1.260','1','1.270','1.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 ('MDCN-ZKAC-32-0','00032042','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1515500','2026-11-13','1515500','1.390','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:48:28','1.380','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-ZKAC-32-0','00032042'); 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-13','MDCN-ZKAC-32-0','MDCN','TOKO','INPUT1','100.00','1.390','1.380','1','1.390','1.380','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-ZKAC-33-0','00032043','EX ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1362500','2026-11-13','1362500','1.250','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:50:31','1.240','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-ZKAC-33-0','00032043'); 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-13','MDCN-ZKAC-33-0','MDCN','TOKO','INPUT1','100.00','1.250','1.240','1','1.250','1.240','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 ('MDCN-ZKAC-34-0','00032044',' ','CN COR TDK BT SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','785000','2026-11-13','785000','0.720','100.00','','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:54:36','0.710','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-ZKAC-34-0','00032044'); 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-13','MDCN-ZKAC-34-0','MDCN','TOKO','INPUT1','100.00','0.720','0.710','1','0.720','0.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 ('MDCN-ZKAC-35-0','00032045',' ','CN COR LBG CAT LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','2387500','2026-11-13','2387500','2.190','100.00','','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:57:25','2.180','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-ZKAC-35-0','00032045'); 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-13','MDCN-ZKAC-35-0','MDCN','TOKO','INPUT1','100.00','2.190','2.180','1','2.190','2.180','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 ('MDCN-ZKAC-36-0','00032046',' ','CN COR SLP LC2 ','','GR','---','MD','MDCN','TOKO','INPUT1','2104000','2026-11-13','2104000','1.930','100.00','','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 10:59:50','1.920','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-ZKAC-36-0','00032046'); 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-13','MDCN-ZKAC-36-0','MDCN','TOKO','INPUT1','100.00','1.930','1.920','1','1.930','1.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 ('MDCN-ZKAC-37-0','00032047',' ','CN SESER MK ','','GR','---','MD','MDCN','TOKO','INPUT1','2224000','2026-11-13','2224000','2.040','100.00','','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:01:02','2.030','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-ZKAC-37-0','00032047'); 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-13','MDCN-ZKAC-37-0','MDCN','TOKO','INPUT1','100.00','2.040','2.030','1','2.040','2.030','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDCN-ZKAC-38-0','00032048','EX ','CN PLINTIR SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','2943000','2026-11-13','2943000','2.700','100.00','','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:02:11','2.690','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-ZKAC-38-0','00032048'); 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-13','MDCN-ZKAC-38-0','MDCN','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 ('MDCN-ZKAC-39-0','00032049','EX ','CN PLINTIR SHB ','','GR','---','MD','MDCN','TOKO','INPUT1','1907500','2026-11-13','1907500','1.750','100.00','','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:04:40','1.740','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-ZKAC-39-0','00032049'); 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-13','MDCN-ZKAC-39-0','MDCN','TOKO','INPUT1','100.00','1.750','1.740','1','1.750','1.740','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 ('MDCN-ZKAC-34-0','00032044','00032044','CN COR TDK BT SHB ','CN COR TDK BT SHB','','','785000','785000',' 0','0','adminpusat','2026-11-13 11:09:32'); UPDATE tm_barang SET nama_barang='CN COR TDK BT SHB' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDCN-ZKAC-34-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 ('MDCN-ZKAC-35-0','00032045','00032045','CN COR LBG CAT LC2 ','CN COR LBG CAT LC2','','','2387500','2387500',' 0','0','adminpusat','2026-11-13 11:09:52'); UPDATE tm_barang SET nama_barang='CN COR LBG CAT LC2' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDCN-ZKAC-35-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 ('MDCN-ZKAC-36-0','00032046','00032046','CN COR SLP LC2 ','CN COR SLP LC2','','','2104000','2104000',' 0','0','adminpusat','2026-11-13 11:10:06'); UPDATE tm_barang SET nama_barang='CN COR SLP LC2' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDCN-ZKAC-36-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 ('MDCN-ZKAC-37-0','00032047','00032047','CN SESER MK ','CN SESER MK','','','2224000','2224000',' 0','0','adminpusat','2026-11-13 11:10:21'); UPDATE tm_barang SET nama_barang='CN SESER MK' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDCN-ZKAC-37-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 ('MDCN-ZKAC-38-0','00032048','00032048','CN PLINTIR SHB ','CN PLINTIR SHB','','','2943000','2943000',' 0','0','adminpusat','2026-11-13 11:10:47'); UPDATE tm_barang SET nama_barang='CN PLINTIR SHB' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDCN-ZKAC-38-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 ('MDCN-ZKAC-39-0','00032049','00032049','CN PLINTIR SHB ','CN PLINTIR SHB','','','1907500','1907500',' 0','0','adminpusat','2026-11-13 11:10:58'); UPDATE tm_barang SET nama_barang='CN PLINTIR SHB' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDCN-ZKAC-39-0' LIMIT 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 ('MDGL-ZKAC-40-0','00032050','EX ','GL PAJERO 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','3074000','2026-11-13','3074000','2.820','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:15:35','2.810','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZKAC-40-0','00032050'); 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-13','MDGL-ZKAC-40-0','MDGL','TOKO','INPUT1','100.00','2.820','2.810','1','2.820','2.810','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 ('MDGL-ZKAC-41-0','00032051','EX ','GL PAJERO BTR 17CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','4098500','2026-11-13','4098500','3.760','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:17:28','3.750','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZKAC-41-0','00032051'); 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-13','MDGL-ZKAC-41-0','MDGL','TOKO','INPUT1','100.00','3.760','3.750','1','3.760','3.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 ('MDGL-ZKAC-42-0','00032052','EX ','GL RANGKAIAN COR 17CM KKT PER LC2 ','','GR','---','MD','MDGL','TOKO','INPUT1','4447500','2026-11-13','4447500','4.080','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:20:03','4.070','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZKAC-42-0','00032052'); 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-13','MDGL-ZKAC-42-0','MDGL','TOKO','INPUT1','100.00','4.080','4.070','1','4.080','4.070','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 ('MDGL-ZKAC-43-0','00032053','EX ','GL ITALY ST SRT BL PSR BL SLP 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','2485500','2026-11-13','2485500','2.280','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:26:21','2.270','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZKAC-43-0','00032053'); 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-13','MDGL-ZKAC-43-0','MDGL','TOKO','INPUT1','100.00','2.280','2.270','1','2.280','2.270','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 ('MDGL-ZKAC-44-0','00032054','EX ','GL FANCY DB MN12 17CM KKT PER UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','7913500','2026-11-13','7913500','7.260','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:29:57','7.250','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZKAC-44-0','00032054'); 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-13','MDGL-ZKAC-44-0','MDGL','TOKO','INPUT1','100.00','7.260','7.250','1','7.260','7.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 ('MDGL-ZKAC-45-0','00032055','EX ','GL RANGKAIAN COR 18CM KKT PER SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','6725500','2026-11-13','6725500','6.170','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:33:47','6.160','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZKAC-45-0','00032055'); 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-13','MDGL-ZKAC-45-0','MDGL','TOKO','INPUT1','100.00','6.170','6.160','1','6.170','6.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 ('MDGL-ZKAC-46-0','00032056','EX ','GL PIPA BT AD WARNA SHB ','','GR','---','MD','MDGL','TOKO','INPUT1','4632500','2026-11-13','4632500','4.250','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:37:09','4.240','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZKAC-46-0','00032056'); 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-13','MDGL-ZKAC-46-0','MDGL','TOKO','INPUT1','100.00','4.250','4.240','1','4.250','4.240','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 ('MDGL-ZKAC-47-0','00032057','EX ','GL BANGKOK TL AIR SMBR PTH UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','10671500','2026-11-13','10671500','9.790','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:39:25','9.780','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-ZKAC-47-0','00032057'); 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-13','MDGL-ZKAC-47-0','MDGL','TOKO','INPUT1','100.00','9.790','9.780','1','9.790','9.780','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 ('MDGW-ZKAC-48-0','00032058','EX ','GW CAP TDK BT LC2 ','','GR','---','MD','MDGW','TOKO','INPUT1','1014000','2026-11-13','1014000','0.930','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:45:25','0.920','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGW' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGW','MDGW-ZKAC-48-0','00032058'); 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-13','MDGW-ZKAC-48-0','MDGW','TOKO','INPUT1','100.00','0.930','0.920','1','0.930','0.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 ('MDGW-ZKAC-49-0','00032059','EX ','GW COR TDK BT LC2 ','','GR','---','MD','MDGW','TOKO','INPUT1','687000','2026-11-13','687000','0.630','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:47:16','0.620','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDGW' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGW','MDGW-ZKAC-49-0','00032059'); 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-13','MDGW-ZKAC-49-0','MDGW','TOKO','INPUT1','100.00','0.630','0.620','1','0.630','0.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 ('MDKL-ZKAC-50-0','00032060','EX ','KL ITALY ST 42CM PNT MN3WRN BT KKT PER MK ','','GR','---','MD','MDKL','TOKO','INPUT1','2769000','2026-11-13','2769000','2.540','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 11:59:46','2.530','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZKAC-50-0','00032060'); 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-13','MDKL-ZKAC-50-0','MDKL','TOKO','INPUT1','100.00','2.540','2.530','1','2.540','2.530','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 ('MDKL-ZKAC-51-0','00032061','EX ','KL FANCY DB 42CM KKT S UBS ','','GR','---','MD','MDKL','TOKO','INPUT1','6071500','2026-11-13','6071500','5.570','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 12:09:36','5.560','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZKAC-51-0','00032061'); 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-13','MDKL-ZKAC-51-0','MDKL','TOKO','INPUT1','100.00','5.570','5.560','1','5.570','5.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 ('MDKL-ZKAC-52-0','00032062','EX ','KL FANCY SLP VAR BL 42CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','2747000','2026-11-13','2747000','2.520','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 12:14:01','2.510','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZKAC-52-0','00032062'); 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-13','MDKL-ZKAC-52-0','MDKL','TOKO','INPUT1','100.00','2.520','2.510','1','2.520','2.510','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 ('MDKL-ZKAC-53-0','00032063','EX ','KL FANCY 42CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','2104000','2026-11-13','2104000','1.930','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 12:15:10','1.920','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZKAC-53-0','00032063'); 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-13','MDKL-ZKAC-53-0','MDKL','TOKO','INPUT1','100.00','1.930','1.920','1','1.930','1.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 ('MDKL-ZKAC-54-0','00032064','EX ','KL RANGKAIAN PJG 60CM KKT PER LC2 ','','GR','---','MD','MDKL','TOKO','INPUT1','15107500','2026-11-13','15107500','13.860','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 12:21:23','13.850','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZKAC-54-0','00032064'); 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-13','MDKL-ZKAC-54-0','MDKL','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 ('MDKL-ZKAC-55-0','00032065','EX ','KL SATELIT PSR 49CM KKT PER SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','11772000','2026-11-13','11772000','10.800','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 12:23:13','10.790','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-ZKAC-55-0','00032065'); 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-13','MDKL-ZKAC-55-0','MDKL','TOKO','INPUT1','100.00','10.800','10.790','1','10.800','10.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 ('MDLT-ZKAC-56-0','00032066','EX ','LT COR DOLLAR LC2 ','','GR','---','MD','MDLT','TOKO','INPUT1','1308000','2026-11-13','1308000','1.200','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 12:27:52','1.190','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDLT','MDLT-ZKAC-56-0','00032066'); 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-13','MDLT-ZKAC-56-0','MDLT','TOKO','INPUT1','100.00','1.200','1.190','1','1.200','1.190','1'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDLT-ZKAC-57-0','00032067','EX ','LT CAP PLAT LM SHB ','','GR','---','MD','MDLT','TOKO','INPUT1','1101000','2026-11-13','1101000','1.010','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 12:30:01','1.000','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDLT','MDLT-ZKAC-57-0','00032067'); 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-13','MDLT-ZKAC-57-0','MDLT','TOKO','INPUT1','100.00','1.010','1.000','1','1.010','1.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 ('MDLT-ZKAC-58-0','00032068','EX ','LT COR BOROBUDUR LC2 ','','GR','---','MD','MDLT','TOKO','INPUT1','7150500','2026-11-13','7150500','6.560','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 12:31:51','6.550','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDLT','MDLT-ZKAC-58-0','00032068'); 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-13','MDLT-ZKAC-58-0','MDLT','TOKO','INPUT1','100.00','6.560','6.550','1','6.560','6.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 ('MDLT-ZKAC-59-0','00032069','EX ','LT COR BOROBUDUR LC2 ','','GR','---','MD','MDLT','TOKO','INPUT1','5145000','2026-11-13','5145000','4.720','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 12:33:15','4.710','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDLT','MDLT-ZKAC-59-0','00032069'); 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-13','MDLT-ZKAC-59-0','MDLT','TOKO','INPUT1','100.00','4.720','4.710','1','4.720','4.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 ('MDLT-ZKAC-60-0','00032070','EX ','LT COR TDK BT LC2 ','','GR','---','MD','MDLT','TOKO','INPUT1','2038500','2026-11-13','2038500','1.870','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 12:35:06','1.860','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDLT','MDLT-ZKAC-60-0','00032070'); 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-13','MDLT-ZKAC-60-0','MDLT','TOKO','INPUT1','100.00','1.870','1.860','1','1.870','1.860','1'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-13 ','15:49:33'); 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 ('MDAT-ZKAC-61-0','00032071','EX ','AT TINDIK PLS SHB ','','GR','---','MD','MDAT','TOKO','INPUT1','523500','2026-11-13','523500','0.480','100.00','8','0','1090000.00','1','0.045', 'adminpusat','2026-11-13 15:53:26','0.470','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MDAT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDAT','MDAT-ZKAC-61-0','00032071'); 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-13','MDAT-ZKAC-61-0','MDAT','TOKO','INPUT1','100.00','0.480','0.470','1','0.480','0.470','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 ('MDKL-ZKAC-50-0','00032060','00032060','KL ITALY ST 42CM PNT MN3WRN BT KKT PER MK ','KL ITALY ST PNT MN3WRN BT 42CM KKT PER MK','','','2769000','2769000',' 0','0','adminpusat','2026-11-13 15:57:54'); UPDATE tm_barang SET nama_barang='KL ITALY ST PNT MN3WRN BT 42CM KKT PER MK' ,nama_atribut='' ,kode_intern='EX ', kadar_cetak='8.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='MDKL-ZKAC-50-0' LIMIT 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-261113-0001','1','MDAT-ZKAC-1-0','1','0.470','0.470','TOKO','INPUT1','TOKO','BATMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZKAC-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-13','TOKO','BATMD','MDAT','MDAT-ZKAC-1-0','100.00','1','0.470','0.460','1','0.470','0.460'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.470',berat_out_asli=berat_out_asli+'0.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDAT-ZKAC-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261113-0001','2','MDAT-ZKAC-2-0','1','0.470','0.470','TOKO','INPUT1','TOKO','BATMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZKAC-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-13','TOKO','BATMD','MDAT','MDAT-ZKAC-2-0','100.00','1','0.470','0.460','1','0.470','0.460'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.470',berat_out_asli=berat_out_asli+'0.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDAT-ZKAC-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-261113-0001','3','MDAT-ZKAC-3-0','1','1.790','1.790','TOKO','INPUT1','TOKO','BATMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZKAC-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-13','TOKO','BATMD','MDAT','MDAT-ZKAC-3-0','100.00','1','1.790','1.780','1','1.790','1.780'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.790',berat_out_asli=berat_out_asli+'1.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDAT-ZKAC-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-261113-0001','4','MDAT-ZKAC-4-0','1','0.910','0.910','TOKO','INPUT1','TOKO','BATMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZKAC-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-13','TOKO','BATMD','MDAT','MDAT-ZKAC-4-0','100.00','1','0.910','0.900','1','0.910','0.900'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.910',berat_out_asli=berat_out_asli+'0.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDAT-ZKAC-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-261113-0001','5','MDAT-ZKAC-5-0','1','2.920','2.920','TOKO','INPUT1','TOKO','BATMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZKAC-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-13','TOKO','BATMD','MDAT','MDAT-ZKAC-5-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-13' AND kode_barang='MDAT-ZKAC-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-261113-0001','6','MDAT-ZKAC-6-0','1','1.090','1.090','TOKO','INPUT1','TOKO','BATMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZKAC-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-13','TOKO','BATMD','MDAT','MDAT-ZKAC-6-0','100.00','1','1.090','1.080','1','1.090','1.080'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.090',berat_out_asli=berat_out_asli+'1.080',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDAT-ZKAC-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-261113-0001','7','MDAT-ZKAC-7-0','1','1.050','1.050','TOKO','INPUT1','TOKO','BATMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZKAC-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-13','TOKO','BATMD','MDAT','MDAT-ZKAC-7-0','100.00','1','1.050','1.040','1','1.050','1.040'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.050',berat_out_asli=berat_out_asli+'1.040',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDAT-ZKAC-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-261113-0001','8','MDAT-ZKAC-8-0','1','1.310','1.310','TOKO','INPUT1','TOKO','BATMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZKAC-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-13','TOKO','BATMD','MDAT','MDAT-ZKAC-8-0','100.00','1','1.310','1.300','1','1.310','1.300'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.310',berat_out_asli=berat_out_asli+'1.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDAT-ZKAC-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-261113-0001','9','MDAT-ZKAC-9-0','1','1.470','1.470','TOKO','INPUT1','TOKO','BATMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZKAC-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-13','TOKO','BATMD','MDAT','MDAT-ZKAC-9-0','100.00','1','1.470','1.460','1','1.470','1.460'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.470',berat_out_asli=berat_out_asli+'1.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDAT-ZKAC-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-261113-0001','10','MDAT-ZKAC-61-0','1','0.480','0.480','TOKO','INPUT1','TOKO','BATMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BATMD' WHERE kode_barang='MDAT-ZKAC-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-13','TOKO','BATMD','MDAT','MDAT-ZKAC-61-0','100.00','1','0.480','0.470','1','0.480','0.470'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.480',berat_out_asli=berat_out_asli+'0.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDAT-ZKAC-61-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-261113-0001','2026-11-13','2026-11-13','16:00','11.96','adminpusat','2026-11-13 16:01:34'); 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-261113-0002','1','MDCN-ZKAC-10-0','1','3.600','3.600','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-10-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-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','2','MDCN-ZKAC-11-0','1','2.220','2.220','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-11-0','100.00','1','2.220','2.210','1','2.220','2.210'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.220',berat_out_asli=berat_out_asli+'2.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','3','MDCN-ZKAC-12-0','1','0.880','0.880','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-12-0','100.00','1','0.880','0.870','1','0.880','0.870'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.880',berat_out_asli=berat_out_asli+'0.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','4','MDCN-ZKAC-13-0','1','0.820','0.820','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-13-0','100.00','1','0.820','0.810','1','0.820','0.810'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.820',berat_out_asli=berat_out_asli+'0.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','5','MDCN-ZKAC-14-0','1','0.920','0.920','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-14-0','100.00','1','0.920','0.910','1','0.920','0.910'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.920',berat_out_asli=berat_out_asli+'0.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','6','MDCN-ZKAC-15-0','1','0.730','0.730','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-15-0','100.00','1','0.730','0.720','1','0.730','0.720'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.730',berat_out_asli=berat_out_asli+'0.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','7','MDCN-ZKAC-16-0','1','0.830','0.830','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-16-0','100.00','1','0.830','0.820','1','0.830','0.820'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.830',berat_out_asli=berat_out_asli+'0.820',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','8','MDCN-ZKAC-17-0','1','1.470','1.470','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-17-0','100.00','1','1.470','1.460','1','1.470','1.460'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.470',berat_out_asli=berat_out_asli+'1.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','9','MDCN-ZKAC-18-0','1','1.350','1.350','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-18-0','100.00','1','1.350','1.340','1','1.350','1.340'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.350',berat_out_asli=berat_out_asli+'1.340',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','10','MDCN-ZKAC-19-0','1','1.070','1.070','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-19-0','100.00','1','1.070','1.060','1','1.070','1.060'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.070',berat_out_asli=berat_out_asli+'1.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','11','MDCN-ZKAC-20-0','1','0.730','0.730','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-20-0','100.00','1','0.730','0.720','1','0.730','0.720'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.730',berat_out_asli=berat_out_asli+'0.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','12','MDCN-ZKAC-21-0','1','0.780','0.780','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-21-0','100.00','1','0.780','0.770','1','0.780','0.770'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.780',berat_out_asli=berat_out_asli+'0.770',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','13','MDCN-ZKAC-22-0','1','0.660','0.660','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-22-0','100.00','1','0.660','0.650','1','0.660','0.650'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.660',berat_out_asli=berat_out_asli+'0.650',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','14','MDCN-ZKAC-23-0','1','4.940','4.940','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-23-0','100.00','1','4.940','4.930','1','4.940','4.930'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.940',berat_out_asli=berat_out_asli+'4.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','15','MDCN-ZKAC-24-0','1','1.950','1.950','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-24-0','100.00','1','1.950','1.940','1','1.950','1.940'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.950',berat_out_asli=berat_out_asli+'1.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','16','MDCN-ZKAC-25-0','1','1.750','1.750','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-25-0','100.00','1','1.750','1.740','1','1.750','1.740'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.750',berat_out_asli=berat_out_asli+'1.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','17','MDCN-ZKAC-26-0','1','1.020','1.020','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-26-0','100.00','1','1.020','1.010','1','1.020','1.010'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.020',berat_out_asli=berat_out_asli+'1.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','18','MDCN-ZKAC-27-0','1','1.980','1.980','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-27-0','100.00','1','1.980','1.970','1','1.980','1.970'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.980',berat_out_asli=berat_out_asli+'1.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','19','MDCN-ZKAC-28-0','1','3.770','3.770','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-28-0','100.00','1','3.770','3.760','1','3.770','3.760'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.770',berat_out_asli=berat_out_asli+'3.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','20','MDCN-ZKAC-29-0','1','3.410','3.410','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-29-0','100.00','1','3.410','3.400','1','3.410','3.400'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.410',berat_out_asli=berat_out_asli+'3.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','21','MDCN-ZKAC-30-0','1','2.380','2.380','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-30-0','100.00','1','2.380','2.370','1','2.380','2.370'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.380',berat_out_asli=berat_out_asli+'2.370',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','22','MDCN-ZKAC-31-0','1','1.270','1.270','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-31-0','100.00','1','1.270','1.260','1','1.270','1.260'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.270',berat_out_asli=berat_out_asli+'1.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','23','MDCN-ZKAC-32-0','1','1.390','1.390','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-32-0','100.00','1','1.390','1.380','1','1.390','1.380'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.390',berat_out_asli=berat_out_asli+'1.380',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','24','MDCN-ZKAC-33-0','1','1.250','1.250','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-33-0','100.00','1','1.250','1.240','1','1.250','1.240'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.250',berat_out_asli=berat_out_asli+'1.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','25','MDCN-ZKAC-34-0','1','0.720','0.720','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-34-0','100.00','1','0.720','0.710','1','0.720','0.710'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.720',berat_out_asli=berat_out_asli+'0.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','26','MDCN-ZKAC-35-0','1','2.190','2.190','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-35-0','100.00','1','2.190','2.180','1','2.190','2.180'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.190',berat_out_asli=berat_out_asli+'2.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','27','MDCN-ZKAC-36-0','1','1.930','1.930','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-36-0','100.00','1','1.930','1.920','1','1.930','1.920'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.930',berat_out_asli=berat_out_asli+'1.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','28','MDCN-ZKAC-37-0','1','2.040','2.040','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-37-0','100.00','1','2.040','2.030','1','2.040','2.030'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.040',berat_out_asli=berat_out_asli+'2.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','29','MDCN-ZKAC-38-0','1','2.700','2.700','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-38-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-13' AND kode_barang='MDCN-ZKAC-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-261113-0002','30','MDCN-ZKAC-39-0','1','1.750','1.750','TOKO','INPUT1','TOKO','BCNMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMD' WHERE kode_barang='MDCN-ZKAC-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-13','TOKO','BCNMD','MDCN','MDCN-ZKAC-39-0','100.00','1','1.750','1.740','1','1.750','1.740'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.750',berat_out_asli=berat_out_asli+'1.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDCN-ZKAC-39-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-261113-0002','2026-11-13','2026-11-13','16:01','52.5','adminpusat','2026-11-13 16:03:57'); 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-261113-0003','1','MDGL-ZKAC-40-0','1','2.820','2.820','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZKAC-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-13','TOKO','BGLMD','MDGL','MDGL-ZKAC-40-0','100.00','1','2.820','2.810','1','2.820','2.810'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.820',berat_out_asli=berat_out_asli+'2.810',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDGL-ZKAC-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-261113-0003','2','MDGL-ZKAC-41-0','1','3.760','3.760','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZKAC-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-13','TOKO','BGLMD','MDGL','MDGL-ZKAC-41-0','100.00','1','3.760','3.750','1','3.760','3.750'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.760',berat_out_asli=berat_out_asli+'3.750',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDGL-ZKAC-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-261113-0003','3','MDGL-ZKAC-42-0','1','4.080','4.080','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZKAC-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-13','TOKO','BGLMD','MDGL','MDGL-ZKAC-42-0','100.00','1','4.080','4.070','1','4.080','4.070'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.080',berat_out_asli=berat_out_asli+'4.070',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDGL-ZKAC-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-261113-0003','4','MDGL-ZKAC-43-0','1','2.280','2.280','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZKAC-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-13','TOKO','BGLMD','MDGL','MDGL-ZKAC-43-0','100.00','1','2.280','2.270','1','2.280','2.270'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.280',berat_out_asli=berat_out_asli+'2.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDGL-ZKAC-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-261113-0003','5','MDGL-ZKAC-44-0','1','7.260','7.260','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZKAC-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-13','TOKO','BGLMD','MDGL','MDGL-ZKAC-44-0','100.00','1','7.260','7.250','1','7.260','7.250'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.260',berat_out_asli=berat_out_asli+'7.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDGL-ZKAC-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-261113-0003','6','MDGL-ZKAC-45-0','1','6.170','6.170','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZKAC-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-13','TOKO','BGLMD','MDGL','MDGL-ZKAC-45-0','100.00','1','6.170','6.160','1','6.170','6.160'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.170',berat_out_asli=berat_out_asli+'6.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDGL-ZKAC-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-261113-0003','7','MDGL-ZKAC-46-0','1','4.250','4.250','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZKAC-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-13','TOKO','BGLMD','MDGL','MDGL-ZKAC-46-0','100.00','1','4.250','4.240','1','4.250','4.240'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.250',berat_out_asli=berat_out_asli+'4.240',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDGL-ZKAC-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-261113-0003','8','MDGL-ZKAC-47-0','1','9.790','9.790','TOKO','INPUT1','TOKO','BGLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-ZKAC-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-13','TOKO','BGLMD','MDGL','MDGL-ZKAC-47-0','100.00','1','9.790','9.780','1','9.790','9.780'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.790',berat_out_asli=berat_out_asli+'9.780',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDGL-ZKAC-47-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-261113-0003','2026-11-13','2026-11-13','16:04','40.41','adminpusat','2026-11-13 16:05:28'); 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-261113-0004','1','MDGW-ZKAC-48-0','1','0.930','0.930','TOKO','INPUT1','TOKO','BGWMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGWMD' WHERE kode_barang='MDGW-ZKAC-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-13','TOKO','BGWMD','MDGW','MDGW-ZKAC-48-0','100.00','1','0.930','0.920','1','0.930','0.920'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.930',berat_out_asli=berat_out_asli+'0.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDGW-ZKAC-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-261113-0004','2','MDGW-ZKAC-49-0','1','0.630','0.630','TOKO','INPUT1','TOKO','BGWMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGWMD' WHERE kode_barang='MDGW-ZKAC-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-13','TOKO','BGWMD','MDGW','MDGW-ZKAC-49-0','100.00','1','0.630','0.620','1','0.630','0.620'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.630',berat_out_asli=berat_out_asli+'0.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDGW-ZKAC-49-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-261113-0004','2026-11-13','2026-11-13','16:05','1.56','adminpusat','2026-11-13 16:06:15'); 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-261113-0005','1','MDKL-ZKAC-50-0','1','2.540','2.540','TOKO','INPUT1','TOKO','BKLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZKAC-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-13','TOKO','BKLMD','MDKL','MDKL-ZKAC-50-0','100.00','1','2.540','2.530','1','2.540','2.530'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.540',berat_out_asli=berat_out_asli+'2.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDKL-ZKAC-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-261113-0005','2','MDKL-ZKAC-51-0','1','5.570','5.570','TOKO','INPUT1','TOKO','BKLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZKAC-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-13','TOKO','BKLMD','MDKL','MDKL-ZKAC-51-0','100.00','1','5.570','5.560','1','5.570','5.560'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.570',berat_out_asli=berat_out_asli+'5.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDKL-ZKAC-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-261113-0005','3','MDKL-ZKAC-52-0','1','2.520','2.520','TOKO','INPUT1','TOKO','BKLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZKAC-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-13','TOKO','BKLMD','MDKL','MDKL-ZKAC-52-0','100.00','1','2.520','2.510','1','2.520','2.510'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.520',berat_out_asli=berat_out_asli+'2.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDKL-ZKAC-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-261113-0005','4','MDKL-ZKAC-53-0','1','1.930','1.930','TOKO','INPUT1','TOKO','BKLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZKAC-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-13','TOKO','BKLMD','MDKL','MDKL-ZKAC-53-0','100.00','1','1.930','1.920','1','1.930','1.920'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.930',berat_out_asli=berat_out_asli+'1.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDKL-ZKAC-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-261113-0005','5','MDKL-ZKAC-54-0','1','13.860','13.860','TOKO','INPUT1','TOKO','BKLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZKAC-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-13','TOKO','BKLMD','MDKL','MDKL-ZKAC-54-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-13' AND kode_barang='MDKL-ZKAC-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-261113-0005','6','MDKL-ZKAC-55-0','1','10.800','10.800','TOKO','INPUT1','TOKO','BKLMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-ZKAC-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-13','TOKO','BKLMD','MDKL','MDKL-ZKAC-55-0','100.00','1','10.800','10.790','1','10.800','10.790'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'10.800',berat_out_asli=berat_out_asli+'10.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDKL-ZKAC-55-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-261113-0005','2026-11-13','2026-11-13','16:06','37.22','adminpusat','2026-11-13 16:07:12'); 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-261113-0006','1','MDLT-ZKAC-56-0','1','1.200','1.200','TOKO','INPUT1','TOKO','BLTMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-ZKAC-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-13','TOKO','BLTMD','MDLT','MDLT-ZKAC-56-0','100.00','1','1.200','1.190','1','1.200','1.190'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.200',berat_out_asli=berat_out_asli+'1.190',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDLT-ZKAC-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-261113-0006','2','MDLT-ZKAC-57-0','1','1.010','1.010','TOKO','INPUT1','TOKO','BLTMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-ZKAC-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-13','TOKO','BLTMD','MDLT','MDLT-ZKAC-57-0','100.00','1','1.010','1.000','1','1.010','1.000'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.010',berat_out_asli=berat_out_asli+'1.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDLT-ZKAC-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-261113-0006','3','MDLT-ZKAC-58-0','1','6.560','6.560','TOKO','INPUT1','TOKO','BLTMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-ZKAC-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-13','TOKO','BLTMD','MDLT','MDLT-ZKAC-58-0','100.00','1','6.560','6.550','1','6.560','6.550'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.560',berat_out_asli=berat_out_asli+'6.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDLT-ZKAC-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-261113-0006','4','MDLT-ZKAC-59-0','1','4.720','4.720','TOKO','INPUT1','TOKO','BLTMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-ZKAC-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-13','TOKO','BLTMD','MDLT','MDLT-ZKAC-59-0','100.00','1','4.720','4.710','1','4.720','4.710'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.720',berat_out_asli=berat_out_asli+'4.710',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDLT-ZKAC-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-261113-0006','5','MDLT-ZKAC-60-0','1','1.870','1.870','TOKO','INPUT1','TOKO','BLTMD'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BLTMD' WHERE kode_barang='MDLT-ZKAC-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-13','TOKO','BLTMD','MDLT','MDLT-ZKAC-60-0','100.00','1','1.870','1.860','1','1.870','1.860'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.870',berat_out_asli=berat_out_asli+'1.860',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MDLT-ZKAC-60-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-261113-0006','2026-11-13','2026-11-13','16:07','15.36','adminpusat','2026-11-13 16:08:19'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-11-13 ','16:11:09'); INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MTKL-ZKAC-62-0','00032072','FS EX ','KL VANESSA DB 48CM KKT PER SHB ','','GR','---','MT','MTKL','TOKO','INPUT1','32833500','2026-11-13','32833500','18.140','100.00','16','0','1810000.00','1','0.045', 'adminpusat','2026-11-13 16:17:56','18.130','0','','0','','TOKO','FREETAG','','0','','0',''); DELETE FROM tp_barang WHERE kode_dept = 'MTKL' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTKL','MTKL-ZKAC-62-0','00032072'); 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-13','MTKL-ZKAC-62-0','MTKL','TOKO','INPUT1','100.00','18.140','18.130','1','18.140','18.130','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-261113-0007','1','MTKL-ZKAC-62-0','1','18.140','18.140','TOKO','INPUT1','TOKO','BKMF'); UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKMF' WHERE kode_barang='MTKL-ZKAC-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-13','TOKO','BKMF','MTKL','MTKL-ZKAC-62-0','100.00','1','18.140','18.130','1','18.140','18.130'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'18.140',berat_out_asli=berat_out_asli+'18.130',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-13' AND kode_barang='MTKL-ZKAC-62-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-261113-0007','2026-11-13','2026-11-13','16:21','18.14','adminpusat','2026-11-13 16:21:27');