INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','A1D-ZGCX-15-0','1','1.530','1.530','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZGCX-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZGCX-15-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-06 08:11:20' WHERE kode_barang='A1D-ZGCX-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZGCX-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:11:20','TOKO','PM-A','A1D','A1D-ZGCX-15-0','1','1.530','1.530','1','1.530','1.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-ZGCX-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZGCX-15-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','A1E-ZIAD-12-0','1','0.520','0.520','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZIAD-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZIAD-12-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-06 08:11:20' WHERE kode_barang='A1E-ZIAD-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZIAD-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:11:20','TOKO','PM-A','A1E','A1E-ZIAD-12-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZIAD-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZIAD-12-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','A1E-ZIAI-144-0','1','0.450','0.450','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZIAI-144-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZIAI-144-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-06 08:11:20' WHERE kode_barang='A1E-ZIAI-144-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZIAI-144-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:11:20','TOKO','PM-A','A1E','A1E-ZIAI-144-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZIAI-144-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZIAI-144-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0001','2026-10-06','08:11','2.500','admpindah','2026-10-06 08:11:19');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','B1E-ZIBE-40-0','1','0.550','0.550','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZIBE-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZIBE-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-06 08:11:39' WHERE kode_barang='B1E-ZIBE-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZIBE-40-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:11:39','TOKO','PM-B','B1E','B1E-ZIBE-40-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZIBE-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZIBE-40-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','B1E-ZJXE-358-0','1','0.560','0.560','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZJXE-358-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZJXE-358-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-06 08:11:39' WHERE kode_barang='B1E-ZJXE-358-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZJXE-358-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:11:39','TOKO','PM-B','B1E','B1E-ZJXE-358-0','1','0.560','0.560','1','0.560','0.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZJXE-358-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZJXE-358-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0001','2026-10-06','08:11','1.110','admpindah','2026-10-06 08:11:38');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','D2E-ZIBF-334-0','1','0.570','0.570','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZIBF-334-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZIBF-334-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-06 08:12:00' WHERE kode_barang='D2E-ZIBF-334-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZIBF-334-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:00','TOKO','PM-D','D2E','D2E-ZIBF-334-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-ZIBF-334-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZIBF-334-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','D1E-ZJXE-359-0','1','0.700','0.700','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZJXE-359-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZJXE-359-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-06 08:12:00' WHERE kode_barang='D1E-ZJXE-359-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZJXE-359-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:00','TOKO','PM-D','D1E','D1E-ZJXE-359-0','1','0.700','0.700','1','0.700','0.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZJXE-359-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZJXE-359-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','D1E-ZJXE-360-0','1','0.400','0.400','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZJXE-360-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZJXE-360-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-06 08:12:00' WHERE kode_barang='D1E-ZJXE-360-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZJXE-360-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:00','TOKO','PM-D','D1E','D1E-ZJXE-360-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZJXE-360-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZJXE-360-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','D1F-ZJXE-361-0','1','2.070','2.070','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZJXE-361-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZJXE-361-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-06 08:12:00' WHERE kode_barang='D1F-ZJXE-361-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZJXE-361-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:00','TOKO','PM-D','D1F','D1F-ZJXE-361-0','1','2.070','2.070','1','2.070','2.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZJXE-361-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZJXE-361-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0001','2026-10-06','08:11','3.740','admpindah','2026-10-06 08:11:59');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1D-ZHBE-88-0','1','1.120','1.120','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZHBE-88-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZHBE-88-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1D-ZHBE-88-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZHBE-88-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1D','E1D-ZHBE-88-0','1','1.120','1.120','1','1.120','1.120','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZHBE-88-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZHBE-88-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2D-ZIXH-80-0','1','0.870','0.870','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXH-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXH-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2D-ZIXH-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXH-80-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2D','E2D-ZIXH-80-0','1','0.870','0.870','1','0.870','0.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZIXH-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXH-80-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2D-ZIBF-26-0','1','2.320','2.320','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIBF-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIBF-26-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2D-ZIBF-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIBF-26-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2D','E2D-ZIBF-26-0','1','2.320','2.320','1','2.320','2.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZIBF-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIBF-26-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1D-ZIBF-101-0','1','1.270','1.270','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZIBF-101-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZIBF-101-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1D-ZIBF-101-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZIBF-101-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1D','E1D-ZIBF-101-0','1','1.270','1.270','1','1.270','1.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZIBF-101-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZIBF-101-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2D-ZIBF-171-0','1','1.250','1.250','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIBF-171-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIBF-171-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2D-ZIBF-171-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIBF-171-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2D','E2D-ZIBF-171-0','1','1.250','1.250','1','1.250','1.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZIBF-171-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIBF-171-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2D-ZJXE-362-0','1','2.250','2.250','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZJXE-362-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJXE-362-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2D-ZJXE-362-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJXE-362-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2D','E2D-ZJXE-362-0','1','2.250','2.250','1','2.250','2.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJXE-362-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJXE-362-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2D-ZJXE-363-0','1','1.510','1.510','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZJXE-363-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJXE-363-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2D-ZJXE-363-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJXE-363-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2D','E2D-ZJXE-363-0','1','1.510','1.510','1','1.510','1.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJXE-363-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJXE-363-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2D-ZJXE-364-0','1','0.860','0.860','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZJXE-364-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJXE-364-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2D-ZJXE-364-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJXE-364-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2D','E2D-ZJXE-364-0','1','0.860','0.860','1','0.860','0.860','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJXE-364-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJXE-364-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2D-ZJXE-365-0','1','0.880','0.880','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZJXE-365-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJXE-365-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2D-ZJXE-365-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJXE-365-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2D','E2D-ZJXE-365-0','1','0.880','0.880','1','0.880','0.880','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJXE-365-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJXE-365-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-366-0','1','0.800','0.800','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-366-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-366-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-366-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-366-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-366-0','1','0.800','0.800','1','0.800','0.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-366-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-366-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2D-ZJXE-367-0','1','1.160','1.160','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZJXE-367-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJXE-367-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2D-ZJXE-367-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJXE-367-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2D','E2D-ZJXE-367-0','1','1.160','1.160','1','1.160','1.160','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZJXE-367-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJXE-367-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-368-0','1','0.650','0.650','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-368-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-368-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-368-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-368-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-368-0','1','0.650','0.650','1','0.650','0.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-368-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-368-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-369-0','1','0.610','0.610','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-369-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-369-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-369-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-369-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-369-0','1','0.610','0.610','1','0.610','0.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-369-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-369-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-370-0','1','0.460','0.460','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-370-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-370-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-370-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-370-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-370-0','1','0.460','0.460','1','0.460','0.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-370-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-370-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-371-0','1','0.460','0.460','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-371-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-371-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-371-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-371-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-371-0','1','0.460','0.460','1','0.460','0.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-371-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-371-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-372-0','1','0.480','0.480','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-372-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-372-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-372-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-372-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-372-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-372-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-372-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-373-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-373-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-373-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-373-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-373-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-373-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-373-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-373-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-374-0','1','0.510','0.510','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-374-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-374-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-374-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-374-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-374-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-374-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-374-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-375-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-375-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-375-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-375-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-375-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-375-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-375-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-375-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-376-0','1','0.470','0.470','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-376-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-376-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-376-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-376-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-376-0','1','0.470','0.470','1','0.470','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-376-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-376-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-377-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-377-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-377-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-377-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-377-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-377-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-377-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-377-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-378-0','1','0.450','0.450','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-378-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-378-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-378-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-378-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-378-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-378-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-378-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-379-0','1','0.460','0.460','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-379-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-379-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-379-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-379-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-379-0','1','0.460','0.460','1','0.460','0.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-379-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-379-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-380-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-380-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-380-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-380-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-380-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-380-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-380-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-380-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-381-0','1','0.430','0.430','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-381-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-381-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-381-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-381-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-381-0','1','0.430','0.430','1','0.430','0.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-381-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-381-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-382-0','1','0.450','0.450','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-382-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-382-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-382-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-382-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-382-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-382-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-382-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-383-0','1','0.380','0.380','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-383-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-383-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-383-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-383-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-383-0','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-383-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-383-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-384-0','1','0.370','0.370','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-384-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-384-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-384-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-384-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-384-0','1','0.370','0.370','1','0.370','0.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-384-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-384-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-385-0','1','0.380','0.380','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-385-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-385-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-385-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-385-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-385-0','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-385-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-385-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-386-0','1','0.380','0.380','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-386-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-386-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-386-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-386-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-386-0','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-386-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-386-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-387-0','1','0.370','0.370','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-387-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-387-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-387-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-387-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-387-0','1','0.370','0.370','1','0.370','0.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-387-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-387-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-388-0','1','0.380','0.380','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-388-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-388-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-388-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-388-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-388-0','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-388-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-388-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-389-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-389-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-389-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-389-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-389-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-389-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-389-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-389-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-390-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-390-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-390-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-390-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-390-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-390-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-390-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-390-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-391-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-391-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-391-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-391-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-391-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-391-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-391-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-391-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-392-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-392-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-392-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-392-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-392-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-392-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-392-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-392-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-393-0','1','0.360','0.360','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-393-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-393-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-393-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-393-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-393-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-393-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-393-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-394-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-394-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-394-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-394-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-394-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-394-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-394-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-394-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-395-0','1','0.330','0.330','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-395-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-395-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-395-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-395-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-395-0','1','0.330','0.330','1','0.330','0.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-395-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-395-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-396-0','1','0.330','0.330','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-396-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-396-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-396-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-396-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-396-0','1','0.330','0.330','1','0.330','0.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-396-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-396-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-397-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-397-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-397-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-397-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-397-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-397-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-397-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-397-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-398-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-398-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-398-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-398-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-398-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-398-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-398-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-398-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1E-ZJXE-399-0','1','0.410','0.410','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZJXE-399-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJXE-399-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1E-ZJXE-399-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJXE-399-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1E','E1E-ZJXE-399-0','1','0.410','0.410','1','0.410','0.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZJXE-399-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJXE-399-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1E-ZJXE-400-0','1','0.420','0.420','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZJXE-400-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJXE-400-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1E-ZJXE-400-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJXE-400-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1E','E1E-ZJXE-400-0','1','0.420','0.420','1','0.420','0.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZJXE-400-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJXE-400-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1E-ZJXE-401-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZJXE-401-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJXE-401-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1E-ZJXE-401-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJXE-401-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1E','E1E-ZJXE-401-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZJXE-401-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJXE-401-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-402-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-402-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-402-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-402-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-402-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-402-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-402-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-402-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1F-ZJXE-403-0','1','0.380','0.380','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXE-403-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-403-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1F-ZJXE-403-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXE-403-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1F','E1F-ZJXE-403-0','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZJXE-403-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXE-403-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-404-0','1','0.410','0.410','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-404-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-404-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-404-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-404-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-404-0','1','0.410','0.410','1','0.410','0.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-404-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-404-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-405-0','1','0.410','0.410','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-405-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-405-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-405-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-405-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-405-0','1','0.410','0.410','1','0.410','0.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-405-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-405-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2E-ZJXE-406-0','1','0.480','0.480','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXE-406-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-406-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2E-ZJXE-406-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXE-406-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2E','E2E-ZJXE-406-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2E-ZJXE-406-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXE-406-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2F-ZJXE-407-0','1','0.360','0.360','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZJXE-407-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZJXE-407-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2F-ZJXE-407-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZJXE-407-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2F','E2F-ZJXE-407-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2F-ZJXE-407-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZJXE-407-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2F-ZJXE-408-0','1','0.360','0.360','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZJXE-408-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZJXE-408-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2F-ZJXE-408-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZJXE-408-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2F','E2F-ZJXE-408-0','1','0.360','0.360','1','0.360','0.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2F-ZJXE-408-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZJXE-408-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2F-ZJXE-409-0','1','0.380','0.380','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZJXE-409-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZJXE-409-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2F-ZJXE-409-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZJXE-409-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2F','E2F-ZJXE-409-0','1','0.380','0.380','1','0.380','0.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2F-ZJXE-409-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZJXE-409-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2F-ZJXE-410-0','1','0.330','0.330','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2F-ZJXE-410-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2F-ZJXE-410-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E2F-ZJXE-410-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2F-ZJXE-410-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E2F','E2F-ZJXE-410-0','1','0.330','0.330','1','0.330','0.330','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2F-ZJXE-410-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2F-ZJXE-410-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1E-ZJXE-411-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZJXE-411-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJXE-411-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1E-ZJXE-411-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJXE-411-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1E','E1E-ZJXE-411-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZJXE-411-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJXE-411-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1E-ZJXE-412-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZJXE-412-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJXE-412-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1E-ZJXE-412-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJXE-412-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1E','E1E-ZJXE-412-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZJXE-412-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJXE-412-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1D-ZJXE-413-0','1','1.130','1.130','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZJXE-413-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZJXE-413-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-06 08:12:20' WHERE kode_barang='E1D-ZJXE-413-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZJXE-413-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:20','TOKO','PM-E','E1D','E1D-ZJXE-413-0','1','1.130','1.130','1','1.130','1.130','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZJXE-413-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZJXE-413-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0001','2026-10-06','08:12','34.460','admpindah','2026-10-06 08:12:19');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F2E-YLAE-64-0','1','8.010','8.010','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-YLAE-64-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-YLAE-64-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F2E-YLAE-64-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-YLAE-64-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F2E','F2E-YLAE-64-0','1','8.010','8.010','1','8.010','8.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-YLAE-64-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-YLAE-64-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZIAD-89-0','1','1.010','1.010','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZIAD-89-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZIAD-89-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZIAD-89-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZIAD-89-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZIAD-89-0','1','1.010','1.010','1','1.010','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZIAD-89-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZIAD-89-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F1E-ZIBE-74-0','1','4.970','4.970','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZIBE-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZIBE-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F1E-ZIBE-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZIBE-74-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F1E','F1E-ZIBE-74-0','1','4.970','4.970','1','4.970','4.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZIBE-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZIBE-74-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZIBF-220-0','1','3.050','3.050','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZIBF-220-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZIBF-220-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZIBF-220-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZIBF-220-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZIBF-220-0','1','3.050','3.050','1','3.050','3.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZIBF-220-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZIBF-220-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F2E-ZJXA-84-0','1','2.110','2.110','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZJXA-84-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZJXA-84-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F2E-ZJXA-84-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZJXA-84-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F2E','F2E-ZJXA-84-0','1','2.110','2.110','1','2.110','2.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZJXA-84-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZJXA-84-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-343-0','1','4.010','4.010','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-343-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-343-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-343-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-343-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-343-0','1','4.010','4.010','1','4.010','4.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-343-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-343-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-344-0','1','2.010','2.010','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-344-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-344-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-344-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-344-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-344-0','1','2.010','2.010','1','2.010','2.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-344-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-344-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-345-0','1','1.530','1.530','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-345-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-345-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-345-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-345-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-345-0','1','1.530','1.530','1','1.530','1.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-345-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-345-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-346-0','1','2.640','2.640','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-346-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-346-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-346-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-346-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-346-0','1','2.640','2.640','1','2.640','2.640','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-346-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-346-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-347-0','1','3.650','3.650','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-347-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-347-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-347-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-347-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-347-0','1','3.650','3.650','1','3.650','3.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-347-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-347-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F1E-ZJXE-348-0','1','4.900','4.900','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZJXE-348-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJXE-348-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F1E-ZJXE-348-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJXE-348-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F1E','F1E-ZJXE-348-0','1','4.900','4.900','1','4.900','4.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZJXE-348-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJXE-348-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F2E-ZJXE-349-0','1','1.450','1.450','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZJXE-349-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZJXE-349-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F2E-ZJXE-349-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZJXE-349-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F2E','F2E-ZJXE-349-0','1','1.450','1.450','1','1.450','1.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZJXE-349-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZJXE-349-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-350-0','1','0.700','0.700','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-350-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-350-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-350-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-350-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-350-0','1','0.700','0.700','1','0.700','0.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-350-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-350-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-351-0','1','2.430','2.430','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-351-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-351-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-351-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-351-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-351-0','1','2.430','2.430','1','2.430','2.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-351-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-351-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-352-0','1','2.630','2.630','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-352-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-352-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-352-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-352-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-352-0','1','2.630','2.630','1','2.630','2.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-352-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-352-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-353-0','1','2.000','2.000','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-353-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-353-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-353-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-353-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-353-0','1','2.000','2.000','1','2.000','2.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-353-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-353-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-354-0','1','0.600','0.600','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-354-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-354-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-354-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-354-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-354-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-354-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-354-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-355-0','1','1.300','1.300','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-355-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-355-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-355-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-355-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-355-0','1','1.300','1.300','1','1.300','1.300','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-355-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-355-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3E-ZJXE-356-0','1','1.910','1.910','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXE-356-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-356-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F3E-ZJXE-356-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXE-356-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F3E','F3E-ZJXE-356-0','1','1.910','1.910','1','1.910','1.910','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXE-356-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXE-356-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F1E-ZJXE-357-0','1','3.030','3.030','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZJXE-357-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJXE-357-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-06 08:12:58' WHERE kode_barang='F1E-ZJXE-357-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJXE-357-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:12:58','TOKO','PM-F','F1E','F1E-ZJXE-357-0','1','3.030','3.030','1','3.030','3.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZJXE-357-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJXE-357-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0001','2026-10-06','08:12','53.940','admpindah','2026-10-06 08:12:58');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','A1TE-ZJXE-251-T','1','0.500','0.500','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TE-ZJXE-251-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TE-ZJXE-251-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-10-06 08:13:23' WHERE kode_barang='A1TE-ZJXE-251-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TE-ZJXE-251-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:23','TOKO','PT-A','A1TE','A1TE-ZJXE-251-T','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TE-ZJXE-251-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZJXE-251-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','A1TE-ZJXE-252-T','1','0.530','0.530','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TE-ZJXE-252-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TE-ZJXE-252-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-10-06 08:13:23' WHERE kode_barang='A1TE-ZJXE-252-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TE-ZJXE-252-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:23','TOKO','PT-A','A1TE','A1TE-ZJXE-252-T','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TE-ZJXE-252-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TE-ZJXE-252-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','A1TD-ZJXE-253-T','1','0.900','0.900','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TD-ZJXE-253-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TD-ZJXE-253-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-10-06 08:13:23' WHERE kode_barang='A1TD-ZJXE-253-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TD-ZJXE-253-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:23','TOKO','PT-A','A1TD','A1TD-ZJXE-253-T','1','0.900','0.900','1','0.900','0.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TD-ZJXE-253-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-ZJXE-253-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','A1TD-ZJXE-254-T','1','1.500','1.500','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TD-ZJXE-254-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TD-ZJXE-254-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-10-06 08:13:23' WHERE kode_barang='A1TD-ZJXE-254-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TD-ZJXE-254-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:23','TOKO','PT-A','A1TD','A1TD-ZJXE-254-T','1','1.500','1.500','1','1.500','1.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TD-ZJXE-254-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-ZJXE-254-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','A1TD-ZJXE-255-T','1','1.030','1.030','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TD-ZJXE-255-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TD-ZJXE-255-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-10-06 08:13:23' WHERE kode_barang='A1TD-ZJXE-255-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TD-ZJXE-255-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:23','TOKO','PT-A','A1TD','A1TD-ZJXE-255-T','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TD-ZJXE-255-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-ZJXE-255-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','A1TD-ZJXE-256-T','1','1.060','1.060','TOKO','PTBK-A','TOKO','PT-A');
DELETE FROM tm_barang WHERE kode_barang='A1TD-ZJXE-256-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1TD-ZJXE-256-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-A',tgl_last_beli='2026-10-06 08:13:23' WHERE kode_barang='A1TD-ZJXE-256-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1TD-ZJXE-256-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:23','TOKO','PT-A','A1TD','A1TD-ZJXE-256-T','1','1.060','1.060','1','1.060','1.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1TD-ZJXE-256-T';
DELETE FROM tm_barang_export WHERE kode_barang='A1TD-ZJXE-256-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0001','2026-10-06','08:13','5.520','admpindah','2026-10-06 08:13:22');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1TE-ZJXE-241-T','1','0.760','0.760','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TE-ZJXE-241-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TE-ZJXE-241-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-10-06 08:13:44' WHERE kode_barang='E1TE-ZJXE-241-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TE-ZJXE-241-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:44','TOKO','PT-E','E1TE','E1TE-ZJXE-241-T','1','0.760','0.760','1','0.760','0.760','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TE-ZJXE-241-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TE-ZJXE-241-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1TE-ZJXE-242-T','1','0.720','0.720','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TE-ZJXE-242-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TE-ZJXE-242-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-10-06 08:13:44' WHERE kode_barang='E1TE-ZJXE-242-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TE-ZJXE-242-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:44','TOKO','PT-E','E1TE','E1TE-ZJXE-242-T','1','0.720','0.720','1','0.720','0.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TE-ZJXE-242-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TE-ZJXE-242-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2TD-ZJXE-243-T','1','1.030','1.030','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E2TD-ZJXE-243-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2TD-ZJXE-243-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-10-06 08:13:44' WHERE kode_barang='E2TD-ZJXE-243-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2TD-ZJXE-243-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:44','TOKO','PT-E','E2TD','E2TD-ZJXE-243-T','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2TD-ZJXE-243-T';
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-ZJXE-243-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E2TD-ZJXE-244-T','1','0.980','0.980','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E2TD-ZJXE-244-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2TD-ZJXE-244-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-10-06 08:13:44' WHERE kode_barang='E2TD-ZJXE-244-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2TD-ZJXE-244-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:44','TOKO','PT-E','E2TD','E2TD-ZJXE-244-T','1','0.980','0.980','1','0.980','0.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2TD-ZJXE-244-T';
DELETE FROM tm_barang_export WHERE kode_barang='E2TD-ZJXE-244-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1TD-ZJXE-245-T','1','1.050','1.050','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZJXE-245-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-245-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-10-06 08:13:44' WHERE kode_barang='E1TD-ZJXE-245-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZJXE-245-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:44','TOKO','PT-E','E1TD','E1TD-ZJXE-245-T','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZJXE-245-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-245-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1TD-ZJXE-246-T','1','1.050','1.050','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZJXE-246-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-246-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-10-06 08:13:44' WHERE kode_barang='E1TD-ZJXE-246-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZJXE-246-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:44','TOKO','PT-E','E1TD','E1TD-ZJXE-246-T','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZJXE-246-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-246-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1TD-ZJXE-247-T','1','1.000','1.000','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZJXE-247-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-247-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-10-06 08:13:44' WHERE kode_barang='E1TD-ZJXE-247-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZJXE-247-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:44','TOKO','PT-E','E1TD','E1TD-ZJXE-247-T','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZJXE-247-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-247-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1TD-ZJXE-248-T','1','1.010','1.010','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZJXE-248-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-248-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-10-06 08:13:44' WHERE kode_barang='E1TD-ZJXE-248-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZJXE-248-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:44','TOKO','PT-E','E1TD','E1TD-ZJXE-248-T','1','1.010','1.010','1','1.010','1.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZJXE-248-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-248-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1TD-ZJXE-249-T','1','1.050','1.050','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZJXE-249-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-249-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-10-06 08:13:44' WHERE kode_barang='E1TD-ZJXE-249-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZJXE-249-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:44','TOKO','PT-E','E1TD','E1TD-ZJXE-249-T','1','1.050','1.050','1','1.050','1.050','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZJXE-249-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-249-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','E1TD-ZJXE-250-T','1','1.060','1.060','TOKO','PTBK-E','TOKO','PT-E');
DELETE FROM tm_barang WHERE kode_barang='E1TD-ZJXE-250-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-250-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-E',tgl_last_beli='2026-10-06 08:13:44' WHERE kode_barang='E1TD-ZJXE-250-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1TD-ZJXE-250-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:13:44','TOKO','PT-E','E1TD','E1TD-ZJXE-250-T','1','1.060','1.060','1','1.060','1.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1TD' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1TD' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1TD-ZJXE-250-T';
DELETE FROM tm_barang_export WHERE kode_barang='E1TD-ZJXE-250-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0001','2026-10-06','08:13','9.710','admpindah','2026-10-06 08:13:44');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3TE-ZJXE-235-T','1','2.750','2.750','TOKO','PTBK-F','TOKO','PT-F');
DELETE FROM tm_barang WHERE kode_barang='F3TE-ZJXE-235-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3TE-ZJXE-235-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-F',tgl_last_beli='2026-10-06 08:14:05' WHERE kode_barang='F3TE-ZJXE-235-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3TE-ZJXE-235-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:14:05','TOKO','PT-F','F3TE','F3TE-ZJXE-235-T','1','2.750','2.750','1','2.750','2.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3TE-ZJXE-235-T';
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-ZJXE-235-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3TE-ZJXE-236-T','1','3.170','3.170','TOKO','PTBK-F','TOKO','PT-F');
DELETE FROM tm_barang WHERE kode_barang='F3TE-ZJXE-236-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3TE-ZJXE-236-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-F',tgl_last_beli='2026-10-06 08:14:05' WHERE kode_barang='F3TE-ZJXE-236-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3TE-ZJXE-236-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:14:05','TOKO','PT-F','F3TE','F3TE-ZJXE-236-T','1','3.170','3.170','1','3.170','3.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3TE-ZJXE-236-T';
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-ZJXE-236-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3TE-ZJXE-237-T','1','1.770','1.770','TOKO','PTBK-F','TOKO','PT-F');
DELETE FROM tm_barang WHERE kode_barang='F3TE-ZJXE-237-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3TE-ZJXE-237-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-F',tgl_last_beli='2026-10-06 08:14:05' WHERE kode_barang='F3TE-ZJXE-237-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3TE-ZJXE-237-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:14:05','TOKO','PT-F','F3TE','F3TE-ZJXE-237-T','1','1.770','1.770','1','1.770','1.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3TE-ZJXE-237-T';
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-ZJXE-237-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3TE-ZJXE-238-T','1','3.310','3.310','TOKO','PTBK-F','TOKO','PT-F');
DELETE FROM tm_barang WHERE kode_barang='F3TE-ZJXE-238-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3TE-ZJXE-238-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-F',tgl_last_beli='2026-10-06 08:14:05' WHERE kode_barang='F3TE-ZJXE-238-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3TE-ZJXE-238-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:14:05','TOKO','PT-F','F3TE','F3TE-ZJXE-238-T','1','3.310','3.310','1','3.310','3.310','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3TE-ZJXE-238-T';
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-ZJXE-238-T';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','F3TE-ZJXE-239-T','1','1.620','1.620','TOKO','PTBK-F','TOKO','PT-F');
DELETE FROM tm_barang WHERE kode_barang='F3TE-ZJXE-239-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3TE-ZJXE-239-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-F',tgl_last_beli='2026-10-06 08:14:05' WHERE kode_barang='F3TE-ZJXE-239-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3TE-ZJXE-239-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:14:05','TOKO','PT-F','F3TE','F3TE-ZJXE-239-T','1','1.620','1.620','1','1.620','1.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3TE-ZJXE-239-T';
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-ZJXE-239-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0001','2026-10-06','08:13','12.620','admpindah','2026-10-06 08:14:04');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','H1TE-ZDXD-173-T','1','5.000','5.000','TOKO','PTBK-H','TOKO','PT-H');
DELETE FROM tm_barang WHERE kode_barang='H1TE-ZDXD-173-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1TE-ZDXD-173-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-H',tgl_last_beli='2026-10-06 08:14:23' WHERE kode_barang='H1TE-ZDXD-173-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1TE-ZDXD-173-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:14:23','TOKO','PT-H','H1TE','H1TE-ZDXD-173-T','1','5.000','5.000','1','5.000','5.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1TE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1TE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1TE-ZDXD-173-T';
DELETE FROM tm_barang_export WHERE kode_barang='H1TE-ZDXD-173-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0001','2026-10-06','08:14','5.000','admpindah','2026-10-06 08:14:23');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261006-0001','1','S1TG-ZJXE-240-T','1','0.400','0.400','TOKO','PTBK-S','TOKO','PT-S');
DELETE FROM tm_barang WHERE kode_barang='S1TG-ZJXE-240-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='S1TG-ZJXE-240-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PT-S',tgl_last_beli='2026-10-06 08:14:58' WHERE kode_barang='S1TG-ZJXE-240-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='S1TG-ZJXE-240-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-06 08:14:58','TOKO','PT-S','S1TG','S1TG-ZJXE-240-T','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='S1TG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='S1TG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='TG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='TG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='S1TG-ZJXE-240-T';
DELETE FROM tm_barang_export WHERE kode_barang='S1TG-ZJXE-240-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261006-0001','2026-10-06','08:14','0.400','admpindah','2026-10-06 08:14:58');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060909121','input','1',' MEB1E X BW','TOKO','PM-B','B1E-ZEXE-21-0','GW X MODEL SLEP KUPU BW 8K ','','0.470','1','100.00','486000','0','0','15000','487000','0','0','0','487000','FIT','00402194','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEXE-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='B1E-ZEXE-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060909121','2026-10-06','0.470','2026-10-06','09:09:13','PLG0031701','487000','487000','0','487000','487000','input','2026-10-06 09:09:12','F32606090912');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','F326060909121','2026-10-06','09:09:13','FIT','487000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261006-0002','D','2026-10-06','09:09:13','input','PENJUALAN','F326060909121','7746677000','487000','7747164000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060947311','kasir','1',' TEF3 X UB ','TOKO','PT-F','F3TE-UCCX-134-T','GL X FANCY VAR UB ','','3.700','1','100.00','7104000','0','0','15000','7105000','0','0','0','7105000','FIT','T0002687','F3TE','0','0','-','0','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-UCCX-134-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.700',berat_jual_asli=berat_jual_asli+'3.700',stock_jual='1',berat_akhir=berat_akhir-'3.700',berat_akhir_asli=berat_akhir_asli-'3.700',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='F3TE-UCCX-134-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060947311','2026-10-06','3.700','2026-10-06','09:47:32','PLG0031702','7105000','7105000','0','7105000','7105000','kasir','2026-10-06 09:47:31','F32606094731');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','F326060947311','2026-10-06','09:47:32','FIT','7105000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261006-0003','D','2026-10-06','09:47:32','kasir','PENJUALAN','F326060947311','7747164000','7105000','7754269000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020425','X-00020425','GL CAPELLA SLEP HW 8K','GR','---','F3E','BELI','BELI001','1115000','2026-10-06','1.500','1','kasir','2026-10-06 11:00:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020425','X-00020425');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261006-0001','F325041052531','AAT','1','BELI','BELI001','F3E', 'X-00020425', 'GL CAPELLA SLEP HW 8K','1.550','1.500','100.00','1135000','1115000','743333','1045000','1','1115000','1115000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261006-0001','2026-10-06','2026-10-06','11:00:26','AAT','---','1.500','1115000','1115000','1115000','1115000','1115000','kasir','2026-10-06 11:00:27','FB-261006-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261006-0001','FITRI','LEMAHBANG KISMANTORO','','','','kasir','2026-10-06 11:00:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261006-0004','K','2026-10-06','11:00:26','kasir','PEMBELIAN UMUM','FB-261006-0001','7754269000','1115000','7753154000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061106331','kasir','1',' MFA1F X LG','TOKO','PM-A','A1F-YHXB-45-0','AT X DAYSI MODEL MATA LG 8K ','','0.550','1','100.00','580000','0','0','15000','580000','0','0','0','580000','SIN','00363455','A1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YHXB-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='A1F-YHXB-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061106331','2026-10-06','0.550','2026-10-06','11:06:33','PLG0031703','580000','580000','0','580000','580000','kasir','2026-10-06 11:06:33','F32606110633');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','F326061106331','2026-10-06','11:06:33','SIN','580000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261006-0005','D','2026-10-06','11:06:33','kasir','PENJUALAN','F326061106331','7753154000','580000','7753734000');
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='774000',harga_beli ='774000' WHERE kode_barcode='00102296' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2494000',harga_beli ='2494000' WHERE kode_barcode='00108862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2290000',harga_beli ='2290000' WHERE kode_barcode='00113960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1881500',harga_beli ='1881500' WHERE kode_barcode='00132203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1430000',harga_beli ='1430000' WHERE kode_barcode='00174902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='645000',harga_beli ='645000' WHERE kode_barcode='00210050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='871000',harga_beli ='871000' WHERE kode_barcode='00216302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1258000',harga_beli ='1258000' WHERE kode_barcode='00232855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1247000',harga_beli ='1247000' WHERE kode_barcode='00232856' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1021500',harga_beli ='1021500' WHERE kode_barcode='00239628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='613000',harga_beli ='613000' WHERE kode_barcode='00263551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1236500',harga_beli ='1236500' WHERE kode_barcode='00267305' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1075000',harga_beli ='1075000' WHERE kode_barcode='00285477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2150000',harga_beli ='2150000' WHERE kode_barcode='00286942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2150000',harga_beli ='2150000' WHERE kode_barcode='00286945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2150000',harga_beli ='2150000' WHERE kode_barcode='00286946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='516000',harga_beli ='516000' WHERE kode_barcode='00291047' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='537500',harga_beli ='537500' WHERE kode_barcode='00304304' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2128500',harga_beli ='2128500' WHERE kode_barcode='00311794' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2204000',harga_beli ='2204000' WHERE kode_barcode='00311795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='537500',harga_beli ='537500' WHERE kode_barcode='00314180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2075000',harga_beli ='2075000' WHERE kode_barcode='00314981' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2118000',harga_beli ='2118000' WHERE kode_barcode='00314982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2042500',harga_beli ='2042500' WHERE kode_barcode='00314995' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2053500',harga_beli ='2053500' WHERE kode_barcode='00314996' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1236500',harga_beli ='1236500' WHERE kode_barcode='00314998' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='376500',harga_beli ='376500' WHERE kode_barcode='00320317' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1451500',harga_beli ='1451500' WHERE kode_barcode='00321886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='2150000',harga_beli ='2150000' WHERE kode_barcode='00329723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='226000',harga_beli ='226000' WHERE kode_barcode='00332676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='484000',harga_beli ='484000' WHERE kode_barcode='00335335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='645000',harga_beli ='645000' WHERE kode_barcode='00335339' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='570000',harga_beli ='570000' WHERE kode_barcode='00336430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='989000',harga_beli ='989000' WHERE kode_barcode='00346067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='333500',harga_beli ='333500' WHERE kode_barcode='00362873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='408500',harga_beli ='408500' WHERE kode_barcode='00367960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='408500',harga_beli ='408500' WHERE kode_barcode='00371893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1645000',harga_beli ='1645000' WHERE kode_barcode='00378118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='344000',harga_beli ='344000' WHERE kode_barcode='00386169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='344000',harga_beli ='344000' WHERE kode_barcode='00386913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='344000',harga_beli ='344000' WHERE kode_barcode='00391890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='441000',harga_beli ='441000' WHERE kode_barcode='00391892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1924500',harga_beli ='1924500' WHERE kode_barcode='00396136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='322500',harga_beli ='322500' WHERE kode_barcode='00397674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='376500',harga_beli ='376500' WHERE kode_barcode='00397802' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='398000',harga_beli ='398000' WHERE kode_barcode='00400675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='376500',harga_beli ='376500' WHERE kode_barcode='00400676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='333500',harga_beli ='333500' WHERE kode_barcode='00411011' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='247500',harga_beli ='247500' WHERE kode_barcode='00413683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='269000',harga_beli ='269000' WHERE kode_barcode='00413684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='322500',harga_beli ='322500' WHERE kode_barcode='00422303' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='269000',harga_beli ='269000' WHERE kode_barcode='00422612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='215000',harga_beli ='215000' WHERE kode_barcode='00422670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='333500',harga_beli ='333500' WHERE kode_barcode='00423004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='279500',harga_beli ='279500' WHERE kode_barcode='00423005' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='215000',harga_beli ='215000' WHERE kode_barcode='00423361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='204500',harga_beli ='204500' WHERE kode_barcode='00424553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='269000',harga_beli ='269000' WHERE kode_barcode='00425424' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='236500',harga_beli ='236500' WHERE kode_barcode='00425425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1075000',harga_jual='1408500',harga_beli ='1408500' WHERE kode_barcode='00427485' LIMIT 1;
UPDATE tm_group SET harga='1075000' WHERE kode_group = 'MG' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MG','1075000','input','2026-10-06 11:19:41');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061120251','input','1',' MGD2G X HW','TOKO','PM-D','D2G-ZIBE-68-0','LT X MODE RIBBON SLEP HW 8K ','','0.300','1','100.00','316000','0','0','15000','323000','0','0','0','323000','LIS','00425443','D2G','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2G-ZIBE-68-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='D2G-ZIBE-68-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061120251','2026-10-06','0.300','2026-10-06','11:20:25','PLG0031704','323000','323000','0','323000','323000','input','2026-10-06 11:20:25','F32606112025');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','F326061120251','2026-10-06','11:20:25','LIS','323000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261006-0006','D','2026-10-06','11:20:25','input','PENJUALAN','F326061120251','7753734000','323000','7754057000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='323000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061120251' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061120252','input',' 1',' MEH1 X UB ','TOKO','PM-H','H1E-ZIBE-152-0','KL X TIFF UB 44 8K ','','1.010','1','100.00','1045000','0','0','15000','1045000','0','0','0','1045000','LIS','00425527','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIBE-152-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='H1E-ZIBE-152-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061120252','2026-10-06','1.010','2026-10-06','11:20:25','PLG0031705','1045000','1045000','0','1045000','1045000','input','2026-10-06 11:20:25','F32606112025');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','F326061120252','2026-10-06','11:20:25','LIS','1045000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261006-0007','D','2026-10-06','11:20:25','input','PENJUALAN','F326061120252','7754057000','1045000','7755102000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1045000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061120252' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061124411','input','1',' MEE1 CM 14','TOKO','PM-E','E1E-ZIXC-31-0','CC PIPA MODEL BUNGA VAR CM 14 8K ','','0.470','1','100.00','486000','0','0','15000','485000','0','0','0','485000','AAT','00421921','E1E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIXC-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='E1E-ZIXC-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061124411','2026-10-06','0.470','2026-10-06','11:24:41','PLG0031706','485000','485000','0','485000','485000','input','2026-10-06 11:24:41','F32606112441');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','F326061124411','2026-10-06','11:24:41','AAT','485000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261006-0008','D','2026-10-06','11:24:41','input','PENJUALAN','F326061124411','7755102000','485000','7755587000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020426','X-00020426','KL TRIXIE PITA MATA VAR LG 8K','GR','---','H1E','BELI','BELI001','942000','2026-10-06','0.980','1','kasir','2026-10-06 11:42:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020426','X-00020426');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261006-0002','F326221224391','LIS','1','BELI','BELI001','H1E', 'X-00020426', 'KL TRIXIE PITA MATA VAR LG 8K','0.980','0.980','100.00','1033000','942000','961224','1045000','1','942000','942000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261006-0002','2026-10-06','2026-10-06','11:42:58','LIS','---','0.980','942000','942000','942000','942000','942000','kasir','2026-10-06 11:42:59','FB-261006-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261006-0002','ERNI','BADEGAN PONOROGO','','','','kasir','2026-10-06 11:42:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261006-0009','K','2026-10-06','11:42:58','kasir','PEMBELIAN UMUM','FB-261006-0002','7755587000','942000','7754645000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020427','X-00020427','CC MODEL SLEP KH 13 8K','GR','---','E1E','BELI','BELI001','575000','2026-10-06','0.600','1','kasir','2026-10-06 11:42:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020427','X-00020427');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261006-0003','F326030823261','LIS','2','BELI','BELI001','E1E', 'X-00020427', 'CC MODEL SLEP KH 13 8K','0.600','0.600','100.00','625000','575000','958333','1045000','1','575000','575000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261006-0003','2026-10-06','2026-10-06','11:42:58','LIS','---','0.600','575000','575000','575000','575000','575000','kasir','2026-10-06 11:42:59','FB-261006-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261006-0003','RARA','SEGARAN POHIJO','','','','kasir','2026-10-06 11:42:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261006-0010','K','2026-10-06','11:42:58','kasir','PEMBELIAN UMUM','FB-261006-0003','7754645000','575000','7754070000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020428','X-00020428','CC MODEL SNAKE MATA SLEP KH 12 8K','GR','---','E2E','BELI','BELI001','480000','2026-10-06','0.500','1','kasir','2026-10-06 11:44:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020428','X-00020428');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261006-0004','F326241020372','SIN','1','BELI','BELI001','E2E', 'X-00020428', 'CC MODEL SNAKE MATA SLEP KH 12 8K','0.500','0.500','100.00','542000','480000','960000','1045000','1','480000','480000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261006-0004','2026-10-06','2026-10-06','11:44:46','SIN','---','0.500','480000','480000','480000','480000','480000','kasir','2026-10-06 11:44:46','FB-261006-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261006-0004','DWI','BAKALAN','','','','kasir','2026-10-06 11:44:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261006-0011','K','2026-10-06','11:44:46','kasir','PEMBELIAN UMUM','FB-261006-0004','7754070000','480000','7753590000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020429','X-00020429','GL X TIFF SLEP VAR HW 8K','GR','---','F3E','BELI','BELI001','1242000','2026-10-06','1.280','1','kasir','2026-10-06 11:44:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020429','X-00020429');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261006-0005','F326041257091','SIN','2','BELI','BELI001','F3E', 'X-00020429', 'GL X TIFF SLEP VAR HW 8K','1.280','1.280','100.00','1485000','1242000','970313','1045000','1','1242000','1242000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.280',berat_beli_asli=berat_beli_asli+'1.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.280',berat_akhir_asli=berat_akhir_asli+'1.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261006-0005','2026-10-06','2026-10-06','11:44:46','SIN','---','1.280','1242000','1242000','1242000','1242000','1242000','kasir','2026-10-06 11:44:46','FB-261006-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261006-0005','ELDAR','PUHPELEM','','','085700952709','kasir','2026-10-06 11:44:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261006-0012','K','2026-10-06','11:44:46','kasir','PEMBELIAN UMUM','FB-261006-0005','7753590000','1242000','7752348000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020430','X-00020430','CC X SOLITAIRE MATA CM 12 8K','GR','---','E2E','BELI','BELI001','495000','2026-10-06','0.510','1','kasir','2026-10-06 11:45:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020430','X-00020430');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261006-0006','F325120207331','AAT','1','BELI','BELI001','E2E', 'X-00020430', 'CC X SOLITAIRE MATA CM 12 8K','0.510','0.510','100.00','533000','495000','970588','1045000','1','495000','495000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261006-0006','2026-10-06','2026-10-06','11:45:15','AAT','---','0.510','495000','495000','495000','495000','495000','kasir','2026-10-06 11:45:16','FB-261006-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261006-0006','AGENG','NAWANGAN','','','','kasir','2026-10-06 11:45:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261006-0013','K','2026-10-06','11:45:15','kasir','PEMBELIAN UMUM','FB-261006-0006','7752348000','495000','7751853000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020431','X-00020431','CC X MODEL SLEP BM 13 8K','GR','---','E1E','BELI','BELI001','662000','2026-10-06','0.720','1','kasir','2026-10-06 11:45:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020431','X-00020431');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261006-0007','F325090945061','AAT','2','BELI','BELI001','E1E', 'X-00020431', 'CC X MODEL SLEP BM 13 8K','0.720','0.720','100.00','713000','662000','919444','1045000','1','662000','662000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.720',berat_beli_asli=berat_beli_asli+'0.720',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.720',berat_akhir_asli=berat_akhir_asli+'0.720',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261006-0007','2026-10-06','2026-10-06','11:45:15','AAT','---','0.720','662000','662000','662000','662000','662000','kasir','2026-10-06 11:45:16','FB-261006-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261006-0007','WILIS','BITING PWO','','','','kasir','2026-10-06 11:45:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261006-0014','K','2026-10-06','11:45:15','kasir','PEMBELIAN UMUM','FB-261006-0007','7751853000','662000','7751191000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326061200171','kasir','1',' MFE1 KH 14','TOKO','PM-E','E1F-ZJXE-390-0','CC MODEL SPECTRA SLEP KH 14 8K ','','0.350','1','100.00','373000','0','0','15000','370000','0','0','0','370000','LIS','00427881','E1F','0','0','-','1','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-390-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='E1F-ZJXE-390-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061200171','2026-10-06','0.350','2026-10-06','12:00:18','PLG0031707','370000','370000','0','370000','370000','kasir','2026-10-06 12:00:17','F32606120017');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','F326061200171','2026-10-06','12:00:18','LIS','370000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261006-0015','D','2026-10-06','12:00:18','kasir','PENJUALAN','F326061200171','7751191000','370000','7751561000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020432','X-00020432','CC X MODEL MATA HW 15 8K','GR','---','E2E','BELI','BELI001','545000','2026-10-06','0.560','1','kasir','2026-10-06 12:59:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020432','X-00020432');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261006-0008','F326061128121','SIN','1','BELI','BELI001','E2E', 'X-00020432', 'CC X MODEL MATA HW 15 8K','0.560','0.560','100.00','585000','545000','973214','1045000','1','545000','545000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.560',berat_beli_asli=berat_beli_asli+'0.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.560',berat_akhir_asli=berat_akhir_asli+'0.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261006-0008','2026-10-06','2026-10-06','12:59:41','SIN','---','0.560','545000','545000','545000','545000','545000','kasir','2026-10-06 12:59:41','FB-261006-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261006-0008','ASIH','BANGSRI','','','','kasir','2026-10-06 12:59:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261006-0016','K','2026-10-06','12:59:41','kasir','PEMBELIAN UMUM','FB-261006-0008','7751561000','545000','7751016000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020433','X-00020433','GL ANAK MODEL FLIK VAR LT 8K','GR','---','F3E','BELI','BELI001','888000','2026-10-06','1.000','1','kasir','2026-10-06 12:59:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020433','X-00020433');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261006-0009','F326240843041','SIN','2','BELI','BELI001','F3E', 'X-00020433', 'GL ANAK MODEL FLIK VAR LT 8K','1.000','1.000','100.00','1150000','888000','888000','1045000','1','888000','888000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261006-0009','2026-10-06','2026-10-06','12:59:41','SIN','---','1.000','888000','888000','888000','888000','888000','kasir','2026-10-06 12:59:41','FB-261006-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261006-0009','MAYA','GONDANG BULUKERTO','','','','kasir','2026-10-06 12:59:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261006-0017','K','2026-10-06','12:59:41','kasir','PEMBELIAN UMUM','FB-261006-0009','7751016000','888000','7750128000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020434','X-00020434','CC X MODEL MATA BM 12 8K','GR','---','E2D','BELI','BELI001','905000','2026-10-06','0.950','1','kasir','2026-10-06 13:01:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020434','X-00020434');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261006-0010','F326291108471','SIN','1','BELI','BELI001','E2D', 'X-00020434', 'CC X MODEL MATA BM 12 8K','0.950','0.950','100.00','1055000','905000','952632','1025000','1','905000','905000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261006-0010','2026-10-06','2026-10-06','13:01:58','SIN','---','0.950','905000','905000','905000','905000','905000','kasir','2026-10-06 13:01:58','FB-261006-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261006-0010','NAILA','GESING','','','082322478471','kasir','2026-10-06 13:01:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261006-0018','K','2026-10-06','13:01:58','kasir','PEMBELIAN UMUM','FB-261006-0010','7750128000','905000','7749223000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020435','X-00020435','CC X SOLITAIRE MATA CM 14 8K','GR','---','E2D','BELI','BELI001','1285000','2026-10-06','1.350','1','kasir','2026-10-06 13:01:58');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020435','X-00020435');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-261006-0011','F326291108291','SIN','2','BELI','BELI001','E2D', 'X-00020435', 'CC X SOLITAIRE MATA CM 14 8K','1.350','1.350','100.00','1500000','1285000','951852','1025000','1','1285000','1285000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.350',berat_beli_asli=berat_beli_asli+'1.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.350',berat_akhir_asli=berat_akhir_asli+'1.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261006-0011','2026-10-06','2026-10-06','13:01:58','SIN','---','1.350','1285000','1285000','1285000','1285000','1285000','kasir','2026-10-06 13:01:58','FB-261006-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261006-0011','DARA','GESING','','','082322478471','kasir','2026-10-06 13:01:58');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261006-0019','K','2026-10-06','13:01:58','kasir','PEMBELIAN UMUM','FB-261006-0011','7749223000','1285000','7747938000');
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-261006-0001','1','E2D-ZDBC-211-0','1','1.510','1.510','TOKO','PM-E','TOKO','SBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBK-E' WHERE kode_barang='E2D-ZDBC-211-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-E';
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-10-06','TOKO','SBK-E','E2D','E2D-ZDBC-211-0','100.00','1','1.510','1.510','1','1.510','1.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.510',berat_out_asli=berat_out_asli+'1.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-06' AND kode_barang='E2D-ZDBC-211-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-E' 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-261006-0001','2','E2D-ZECX-65-T','1','1.490','1.490','TOKO','PM-E','TOKO','SBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBK-E' WHERE kode_barang='E2D-ZECX-65-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-E';
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-10-06','TOKO','SBK-E','E2D','E2D-ZECX-65-T','100.00','1','1.490','1.490','1','1.490','1.490');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.490',berat_out_asli=berat_out_asli+'1.490',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-10-06' AND kode_barang='E2D-ZECX-65-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-E' 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-261006-0001','2026-10-06','2026-10-06','14:16','3','input','2026-10-06 14:17:04');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060230531','input','1',' MDE2 CM 18','TOKO','PM-E','E2D-ZHAX-335-0','CC WEDDING MATA CM 18 8K ','','1.080','1','100.00','1096000','0','0','15000','1096000','0','0','0','1096000','LIS','00418480','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHAX-335-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='E2D-ZHAX-335-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060230531','2026-10-06','1.080','2026-10-06','14:30:53','PLG0031708','1096000','1096000','0','1096000','1096000','input','2026-10-06 14:30:53','F32606023053');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','F326060230531','2026-10-06','14:30:53','LIS','1096000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261006-0020','D','2026-10-06','14:30:53','input','PENJUALAN','F326060230531','7747938000','1096000','7749034000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060238141','input','1',' MFE1 KH 20','TOKO','PM-E','E1F-ZIAH-113-0','CC MODEL DAUN SLEP KH 20 8K ','','0.400','1','100.00','422000','0','0','15000','423000','0','0','0','423000','SIN','00424211','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIAH-113-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='E1F-ZIAH-113-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060238141','2026-10-06','0.400','2026-10-06','14:38:15','PLG0031709','423000','423000','0','423000','423000','input','2026-10-06 14:38:14','F32606023814');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','F326060238141','2026-10-06','14:38:15','SIN','423000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261006-0021','D','2026-10-06','14:38:15','input','PENJUALAN','F326060238141','7749034000','423000','7749457000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326060239141','input','1',' MGA1G X LG','TOKO','PM-A','E1G-ZFBI-19-0','AT X DAKOCAN LG 8K','','0.310','1','100.00','333000','0','0','15000','333000','0','0','0','333000','LIS','00411011','E1G','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-10-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-ZFBI-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-10-06' AND kode_barang='E1G-ZFBI-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060239141','2026-10-06','0.310','2026-10-06','14:39:15','PLG0031710','333000','333000','0','333000','333000','input','2026-10-06 14:39:14','F32606023914');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-06','F326060239141','2026-10-06','14:39:15','LIS','333000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261006-0022','D','2026-10-06','14:39:15','input','PENJUALAN','F326060239141','7749457000','333000','7749790000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261006-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261006-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261006-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261006-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261006-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261006-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261006-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261006-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261006-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261006-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261006-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261006-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261006-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261006-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261006-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261006-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261006-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261006-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261006-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261006-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261006-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261006-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060230531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060230531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060230531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060238141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060238141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060238141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060239141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060239141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060239141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060909121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060909121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060909121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060947311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060947311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060947311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061106331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061106331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061106331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061120251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061120251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061120251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061120252' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061120252' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061120252';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061124411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061124411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061124411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061200171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061200171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061200171';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-07','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-06';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-06';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-06';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-06' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-06';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-06';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-06';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-06';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
UPDATE tt_barang_saldo SET tanggal= '2026-10-07' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-06' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261007-0001','D','2026-10-07','15:14:34','SYSTEM','SALDO AWAL','SALDO AWAL','0','7749790000','7749790000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261007-0001','D','2026-10-07','15:14:34','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261007-0001','D','2026-10-07','15:14:34','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261007-0001','D','2026-10-07','15:14:34','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000');
UPDATE tp_system SET tgl_system='2026-10-07';