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-20260902-0001','1','A1E-ZIXA-233-0','1','0.500','0.500','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZIXA-233-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZIXA-233-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-02 08:04:34' WHERE kode_barang='A1E-ZIXA-233-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZIXA-233-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-09-02 08:04:34','TOKO','SMBK-A','A1E','A1E-ZIXA-233-0','1','0.500','0.500','1','0.500','0.500','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-ZIXA-233-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZIXA-233-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-20260902-0001','1','A1E-ZIXA-234-0','1','0.650','0.650','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZIXA-234-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZIXA-234-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-02 08:04:34' WHERE kode_barang='A1E-ZIXA-234-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZIXA-234-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-09-02 08:04:34','TOKO','SMBK-A','A1E','A1E-ZIXA-234-0','1','0.650','0.650','1','0.650','0.650','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-ZIXA-234-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZIXA-234-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-20260902-0001','1','A1E-ZIXA-235-0','1','0.620','0.620','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZIXA-235-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZIXA-235-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-02 08:04:34' WHERE kode_barang='A1E-ZIXA-235-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZIXA-235-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-09-02 08:04:34','TOKO','SMBK-A','A1E','A1E-ZIXA-235-0','1','0.620','0.620','1','0.620','0.620','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-ZIXA-235-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZIXA-235-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-20260902-0001','1','A1E-ZIXA-236-0','1','0.570','0.570','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZIXA-236-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZIXA-236-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-02 08:04:34' WHERE kode_barang='A1E-ZIXA-236-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZIXA-236-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-09-02 08:04:34','TOKO','SMBK-A','A1E','A1E-ZIXA-236-0','1','0.570','0.570','1','0.570','0.570','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-ZIXA-236-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZIXA-236-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-20260902-0001','1','A1D-ZIXA-237-0','1','0.900','0.900','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZIXA-237-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZIXA-237-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-02 08:04:34' WHERE kode_barang='A1D-ZIXA-237-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZIXA-237-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-09-02 08:04:34','TOKO','SMBK-A','A1D','A1D-ZIXA-237-0','1','0.900','0.900','1','0.900','0.900','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-ZIXA-237-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZIXA-237-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-20260902-0001','1','A1D-ZIXA-238-0','1','1.120','1.120','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZIXA-238-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZIXA-238-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-02 08:04:34' WHERE kode_barang='A1D-ZIXA-238-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZIXA-238-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-09-02 08:04:34','TOKO','SMBK-A','A1D','A1D-ZIXA-238-0','1','1.120','1.120','1','1.120','1.120','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-ZIXA-238-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZIXA-238-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-20260902-0001','1','A1D-ZIXA-239-0','1','0.870','0.870','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZIXA-239-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZIXA-239-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2026-09-02 08:04:34' WHERE kode_barang='A1D-ZIXA-239-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZIXA-239-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-09-02 08:04:34','TOKO','SMBK-A','A1D','A1D-ZIXA-239-0','1','0.870','0.870','1','0.870','0.870','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-ZIXA-239-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZIXA-239-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0001','2026-09-02','08:04','5.230','input','2026-09-02 08:04:33');
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-20260902-0001','1','B1E-ZIXA-214-0','1','0.490','0.490','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZIXA-214-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZIXA-214-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-09-02 08:05:21' WHERE kode_barang='B1E-ZIXA-214-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZIXA-214-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-09-02 08:05:21','TOKO','SMBK-B','B1E','B1E-ZIXA-214-0','1','0.490','0.490','1','0.490','0.490','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-ZIXA-214-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZIXA-214-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-20260902-0001','1','B1E-ZIXA-215-0','1','0.700','0.700','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZIXA-215-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZIXA-215-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-09-02 08:05:21' WHERE kode_barang='B1E-ZIXA-215-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZIXA-215-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-09-02 08:05:21','TOKO','SMBK-B','B1E','B1E-ZIXA-215-0','1','0.700','0.700','1','0.700','0.700','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-ZIXA-215-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZIXA-215-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-20260902-0001','1','B1E-ZIXA-216-0','1','0.540','0.540','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZIXA-216-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZIXA-216-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-09-02 08:05:21' WHERE kode_barang='B1E-ZIXA-216-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZIXA-216-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-09-02 08:05:21','TOKO','SMBK-B','B1E','B1E-ZIXA-216-0','1','0.540','0.540','1','0.540','0.540','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-ZIXA-216-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZIXA-216-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-20260902-0001','1','B1E-ZIXA-217-0','1','0.550','0.550','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZIXA-217-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZIXA-217-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-09-02 08:05:21' WHERE kode_barang='B1E-ZIXA-217-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZIXA-217-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-09-02 08:05:21','TOKO','SMBK-B','B1E','B1E-ZIXA-217-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-ZIXA-217-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZIXA-217-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-20260902-0001','1','B1D-ZIXA-218-0','1','1.070','1.070','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZIXA-218-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZIXA-218-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2026-09-02 08:05:21' WHERE kode_barang='B1D-ZIXA-218-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZIXA-218-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-09-02 08:05:21','TOKO','SMBK-B','B1D','B1D-ZIXA-218-0','1','1.070','1.070','1','1.070','1.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' 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='B1D-ZIXA-218-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZIXA-218-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0001','2026-09-02','08:05','3.350','input','2026-09-02 08:05:20');
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-20260902-0001','1','D1F-ZIXA-200-0','1','0.350','0.350','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZIXA-200-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZIXA-200-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-09-02 08:05:39' WHERE kode_barang='D1F-ZIXA-200-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZIXA-200-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-09-02 08:05:39','TOKO','SMBK-D','D1F','D1F-ZIXA-200-0','1','0.350','0.350','1','0.350','0.350','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-ZIXA-200-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZIXA-200-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-20260902-0001','1','D2E-ZIXA-201-0','1','0.500','0.500','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZIXA-201-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZIXA-201-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-09-02 08:05:39' WHERE kode_barang='D2E-ZIXA-201-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZIXA-201-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-09-02 08:05:39','TOKO','SMBK-D','D2E','D2E-ZIXA-201-0','1','0.500','0.500','1','0.500','0.500','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-ZIXA-201-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZIXA-201-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-20260902-0001','1','D2E-ZIXA-202-0','1','0.530','0.530','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-ZIXA-202-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZIXA-202-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2026-09-02 08:05:39' WHERE kode_barang='D2E-ZIXA-202-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZIXA-202-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-09-02 08:05:39','TOKO','SMBK-D','D2E','D2E-ZIXA-202-0','1','0.530','0.530','1','0.530','0.530','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-ZIXA-202-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZIXA-202-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0001','2026-09-02','08:05','1.380','input','2026-09-02 08:05:39');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260902-0001','1','E2D-ZIXA-344-0','1','2.000','2.000','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXA-344-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-344-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2D-ZIXA-344-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2D','E2D-ZIXA-344-0','1','2.000','2.000','1','2.000','2.000','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-ZIXA-344-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-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-20260902-0001','1','E2D-ZIXA-345-0','1','1.360','1.360','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXA-345-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-345-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2D-ZIXA-345-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2D','E2D-ZIXA-345-0','1','1.360','1.360','1','1.360','1.360','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-ZIXA-345-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-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-20260902-0001','1','E2D-ZIXA-346-0','1','1.120','1.120','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXA-346-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-346-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2D-ZIXA-346-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2D','E2D-ZIXA-346-0','1','1.120','1.120','1','1.120','1.120','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-ZIXA-346-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-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-20260902-0001','1','E2D-ZIXA-347-0','1','1.230','1.230','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXA-347-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-347-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2D-ZIXA-347-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2D','E2D-ZIXA-347-0','1','1.230','1.230','1','1.230','1.230','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-ZIXA-347-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-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-20260902-0001','1','E2D-ZIXA-348-0','1','1.260','1.260','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXA-348-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-348-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2D-ZIXA-348-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2D','E2D-ZIXA-348-0','1','1.260','1.260','1','1.260','1.260','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-ZIXA-348-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-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-20260902-0001','1','E2D-ZIXA-349-0','1','0.860','0.860','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXA-349-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-349-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2D-ZIXA-349-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2D','E2D-ZIXA-349-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-ZIXA-349-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-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-20260902-0001','1','E2D-ZIXA-350-0','1','0.970','0.970','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXA-350-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-350-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2D-ZIXA-350-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2D','E2D-ZIXA-350-0','1','0.970','0.970','1','0.970','0.970','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-ZIXA-350-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-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-20260902-0001','1','E2D-ZIXA-351-0','1','0.980','0.980','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXA-351-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-351-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2D-ZIXA-351-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2D','E2D-ZIXA-351-0','1','0.980','0.980','1','0.980','0.980','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-ZIXA-351-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-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-20260902-0001','1','E2D-ZIXA-352-0','1','0.910','0.910','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXA-352-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-352-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2D-ZIXA-352-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2D','E2D-ZIXA-352-0','1','0.910','0.910','1','0.910','0.910','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-ZIXA-352-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-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-20260902-0001','1','E2E-ZIXA-353-0','1','0.800','0.800','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZIXA-353-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZIXA-353-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2E-ZIXA-353-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2E','E2E-ZIXA-353-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-ZIXA-353-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZIXA-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-20260902-0001','1','E2E-ZIXA-354-0','1','0.700','0.700','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZIXA-354-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZIXA-354-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2E-ZIXA-354-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2E','E2E-ZIXA-354-0','1','0.700','0.700','1','0.700','0.700','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-ZIXA-354-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZIXA-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-20260902-0001','1','E2E-ZIXA-355-0','1','0.510','0.510','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZIXA-355-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZIXA-355-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2E-ZIXA-355-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2E','E2E-ZIXA-355-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-ZIXA-355-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZIXA-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-20260902-0001','1','E2E-ZIXA-356-0','1','0.570','0.570','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZIXA-356-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZIXA-356-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2E-ZIXA-356-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2E','E2E-ZIXA-356-0','1','0.570','0.570','1','0.570','0.570','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-ZIXA-356-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZIXA-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-20260902-0001','1','E2E-ZIXA-357-0','1','0.730','0.730','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZIXA-357-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZIXA-357-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2E-ZIXA-357-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2E','E2E-ZIXA-357-0','1','0.730','0.730','1','0.730','0.730','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-ZIXA-357-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZIXA-357-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-20260902-0001','1','E2D-ZIXA-358-0','1','0.920','0.920','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXA-358-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-358-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2D-ZIXA-358-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2D','E2D-ZIXA-358-0','1','0.920','0.920','1','0.920','0.920','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-ZIXA-358-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-358-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-20260902-0001','1','E2D-ZIXA-359-0','1','2.200','2.200','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZIXA-359-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-359-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E2D-ZIXA-359-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E2D','E2D-ZIXA-359-0','1','2.200','2.200','1','2.200','2.200','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-ZIXA-359-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZIXA-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-20260902-0001','1','E1D-ZIXA-360-0','1','1.370','1.370','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZIXA-360-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZIXA-360-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E1D-ZIXA-360-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E1D','E1D-ZIXA-360-0','1','1.370','1.370','1','1.370','1.370','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-ZIXA-360-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZIXA-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-20260902-0001','1','E1D-ZIXA-361-0','1','1.180','1.180','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZIXA-361-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZIXA-361-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E1D-ZIXA-361-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E1D','E1D-ZIXA-361-0','1','1.180','1.180','1','1.180','1.180','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-ZIXA-361-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZIXA-361-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-20260902-0001','1','E1D-ZIXA-362-0','1','0.820','0.820','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZIXA-362-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZIXA-362-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E1D-ZIXA-362-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E1D','E1D-ZIXA-362-0','1','0.820','0.820','1','0.820','0.820','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-ZIXA-362-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZIXA-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-20260902-0001','1','E1E-ZIXA-363-0','1','0.710','0.710','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZIXA-363-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZIXA-363-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E1E-ZIXA-363-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E1E','E1E-ZIXA-363-0','1','0.710','0.710','1','0.710','0.710','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-ZIXA-363-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZIXA-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-20260902-0001','1','E1E-ZIXA-364-0','1','0.850','0.850','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZIXA-364-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZIXA-364-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E1E-ZIXA-364-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E1E','E1E-ZIXA-364-0','1','0.850','0.850','1','0.850','0.850','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-ZIXA-364-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZIXA-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-20260902-0001','1','E1D-ZIXA-365-0','1','0.820','0.820','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZIXA-365-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZIXA-365-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E1D-ZIXA-365-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E1D','E1D-ZIXA-365-0','1','0.820','0.820','1','0.820','0.820','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-ZIXA-365-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZIXA-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-20260902-0001','1','E1D-ZIXA-366-0','1','1.020','1.020','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZIXA-366-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZIXA-366-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E1D-ZIXA-366-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E1D','E1D-ZIXA-366-0','1','1.020','1.020','1','1.020','1.020','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-ZIXA-366-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZIXA-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-20260902-0001','1','E1E-ZIXA-367-0','1','0.460','0.460','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZIXA-367-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZIXA-367-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E1E-ZIXA-367-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E1E','E1E-ZIXA-367-0','1','0.460','0.460','1','0.460','0.460','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-ZIXA-367-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZIXA-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-20260902-0001','1','E1E-ZIXA-368-0','1','0.450','0.450','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZIXA-368-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZIXA-368-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E1E-ZIXA-368-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E1E','E1E-ZIXA-368-0','1','0.450','0.450','1','0.450','0.450','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-ZIXA-368-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZIXA-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-20260902-0001','1','E1F-ZIXA-369-0','1','0.360','0.360','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZIXA-369-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZIXA-369-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E1F-ZIXA-369-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E1F','E1F-ZIXA-369-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-ZIXA-369-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZIXA-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-20260902-0001','1','E1F-ZIXA-370-0','1','0.350','0.350','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZIXA-370-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZIXA-370-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2026-09-02 08:05:57' WHERE kode_barang='E1F-ZIXA-370-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZIXA-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-09-02 08:05:57','TOKO','SMBK-E','E1F','E1F-ZIXA-370-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-ZIXA-370-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZIXA-370-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0001','2026-09-02','08:05','25.510','input','2026-09-02 08:05:57');
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-20260902-0001','1','F3E-ZIXA-146-0','1','1.580','1.580','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZIXA-146-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZIXA-146-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-09-02 08:06:24' WHERE kode_barang='F3E-ZIXA-146-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZIXA-146-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-09-02 08:06:24','TOKO','SMBK-F','F3E','F3E-ZIXA-146-0','1','1.580','1.580','1','1.580','1.580','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-ZIXA-146-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZIXA-146-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-20260902-0001','1','F3E-ZIXA-152-0','1','1.180','1.180','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZIXA-152-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZIXA-152-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-09-02 08:06:24' WHERE kode_barang='F3E-ZIXA-152-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZIXA-152-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-09-02 08:06:24','TOKO','SMBK-F','F3E','F3E-ZIXA-152-0','1','1.180','1.180','1','1.180','1.180','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-ZIXA-152-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZIXA-152-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-20260902-0001','1','F3E-ZIXA-153-0','1','1.810','1.810','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZIXA-153-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZIXA-153-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-09-02 08:06:24' WHERE kode_barang='F3E-ZIXA-153-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZIXA-153-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-09-02 08:06:24','TOKO','SMBK-F','F3E','F3E-ZIXA-153-0','1','1.810','1.810','1','1.810','1.810','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-ZIXA-153-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZIXA-153-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-20260902-0001','1','F3E-ZIXA-160-0','1','1.850','1.850','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZIXA-160-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZIXA-160-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-09-02 08:06:24' WHERE kode_barang='F3E-ZIXA-160-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZIXA-160-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-09-02 08:06:24','TOKO','SMBK-F','F3E','F3E-ZIXA-160-0','1','1.850','1.850','1','1.850','1.850','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-ZIXA-160-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZIXA-160-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-20260902-0001','1','F1E-ZIXA-180-0','1','2.310','2.310','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZIXA-180-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZIXA-180-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2026-09-02 08:06:24' WHERE kode_barang='F1E-ZIXA-180-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZIXA-180-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-09-02 08:06:24','TOKO','SMBK-F','F1E','F1E-ZIXA-180-0','1','2.310','2.310','1','2.310','2.310','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-ZIXA-180-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZIXA-180-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0001','2026-09-02','08:06','8.730','input','2026-09-02 08:06:24');
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-20260902-0001','1','H1E-ZIXA-137-0','1','2.150','2.150','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZIXA-137-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZIXA-137-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-09-02 08:06:44' WHERE kode_barang='H1E-ZIXA-137-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZIXA-137-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-09-02 08:06:44','TOKO','SMBK-H','H1E','H1E-ZIXA-137-0','1','2.150','2.150','1','2.150','2.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' 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='H1E-ZIXA-137-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZIXA-137-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-20260902-0001','1','H1E-ZIXA-139-0','1','2.340','2.340','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZIXA-139-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZIXA-139-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2026-09-02 08:06:44' WHERE kode_barang='H1E-ZIXA-139-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZIXA-139-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-09-02 08:06:44','TOKO','SMBK-H','H1E','H1E-ZIXA-139-0','1','2.340','2.340','1','2.340','2.340','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' 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='H1E-ZIXA-139-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZIXA-139-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260902-0001','2026-09-02','08:06','4.490','input','2026-09-02 08:06:43');
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 ('F226020826321','kasir','1',' MEB1E X HK','TOKO','SMBK-B','B1E-ZGBX-251-0','GW X TAUGE MODEL MATA SLEP HK 8K ','OLS EFFDS','0.410','1','100.00','435000','0','0','15000','453000','0','37000','0','490000','DIN','00414452','B1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGBX-251-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='B1E-ZGBX-251-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020826321','2026-09-02','0.410','2026-09-02','08:26:32','PLG0084245','453000','453000','37000','490000','490000','kasir','2026-09-02 08:26:32','F22602082632');
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-09-02','F226020826321','2026-09-02','08:26:32','DIN','490000','37000');
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-260902-0002','D','2026-09-02','08:26:32','kasir','PENJUALAN','F226020826321','14356594000','490000','14357084000');
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 ('F226021012321','kasir','1',' MEF1E UB 5','TOKO','SMBK-F','F1E-ZHBA-65-T','GL OVAL C SLEP UB 56 8K ','OL','3.340','1','100.00','3540000','0','0','15000','3490000','0','17000','0','3507000','TIN','T0082357','F1E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHBA-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.340',berat_jual_asli=berat_jual_asli+'3.340',stock_jual='1',berat_akhir=berat_akhir-'3.340',berat_akhir_asli=berat_akhir_asli-'3.340',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='F1E-ZHBA-65-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021012321','2026-09-02','3.340','2026-09-02','10:12:33','PLG0084246','3490000','3490000','17000','3507000','3507000','kasir','2026-09-02 10:12:32','F22602101232');
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-09-02','F226021012321','2026-09-02','10:12:33','TIN','3507000','17000');
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-260902-0003','D','2026-09-02','10:12:33','kasir','PENJUALAN','F226021012321','14357084000','3507000','14360591000');
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 ('F226021013481','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZGAX-10-T','GL KOREA SLEP UB 8K ','OL','0.880','1','100.00','933000','0','0','15000','924000','0','5000','0','929000','TIN','T0080970','F3E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAX-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='F3E-ZGAX-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021013481','2026-09-02','0.880','2026-09-02','10:13:49','PLG0084247','924000','924000','5000','929000','929000','kasir','2026-09-02 10:13:48','F22602101348');
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-09-02','F226021013481','2026-09-02','10:13:49','TIN','929000','5000');
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-260902-0004','D','2026-09-02','10:13:49','kasir','PENJUALAN','F226021013481','14360591000','929000','14361520000');
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 ('F226021017271','kasir','1',' MED1E CM ','TOKO','SMBK-D','D1E-ZHBA-51-T','LT LETTERA PLAT SLEP CM 8K ','OL','0.470','1','100.00','498000','0','0','15000','498000','0','5000','0','503000','DIN','T0082343','D1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZHBA-51-T' 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-09-02' AND kode_barang='D1E-ZHBA-51-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021017271','2026-09-02','0.470','2026-09-02','10:17:27','PLG0084248','498000','498000','5000','503000','503000','kasir','2026-09-02 10:17:27','F22602101727');
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-09-02','F226021017271','2026-09-02','10:17:27','DIN','503000','5000');
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-260902-0005','D','2026-09-02','10:17:27','kasir','PENJUALAN','F226021017271','14361520000','503000','14362023000');
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 ('F226021028081','kasir','1',' MGA1G LG ','TOKO','SMBK-A','A1G-ZHBI-17-T','AT DAKOCAN SLEP LG 8K ','OL','0.300','1','100.00','330000','0','0','15000','329000','0','5000','0','334000','TIN','T0082706','A1G','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZHBI-17-T' 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-09-02' AND kode_barang='A1G-ZHBI-17-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021028081','2026-09-02','0.300','2026-09-02','10:28:09','PLG0084249','329000','329000','5000','334000','334000','kasir','2026-09-02 10:28:08','F22602102808');
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-09-02','F226021028081','2026-09-02','10:28:09','TIN','334000','5000');
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-260902-0006','D','2026-09-02','10:28:09','kasir','PENJUALAN','F226021028081','14362023000','334000','14362357000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='334000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021028081' 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 ('F226021028082','kasir',' 1',' MFE1 X KH ','TOKO','SMBK-E','E1F-ZIXA-370-0','CC X MODEL SLEP KH 16 8K ','OL','0.350','1','100.00','374000','0','0','15000','376000','0','5000','0','381000','TIN','00421797','E1F','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIXA-370-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-09-02' AND kode_barang='E1F-ZIXA-370-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021028082','2026-09-02','0.350','2026-09-02','10:28:09','PLG0084250','376000','376000','5000','381000','381000','kasir','2026-09-02 10:28:08','F22602102808');
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-09-02','F226021028082','2026-09-02','10:28:09','TIN','381000','5000');
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-260902-0007','D','2026-09-02','10:28:09','kasir','PENJUALAN','F226021028082','14362357000','381000','14362738000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='381000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021028082' 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 ('F226021041221','kasir','1',' MEE2E KH 1','TOKO','SMBK-E','E2E-ZHBI-61-T','CC MODEL SNAKE MATA SLEP KH 16 8K ','OL','0.480','1','100.00','509000','0','0','15000','504000','0','5000','0','509000','DIN','T0082750','E2E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBI-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E2E-ZHBI-61-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021041221','2026-09-02','0.480','2026-09-02','10:41:22','PLG0084251','504000','504000','5000','509000','509000','kasir','2026-09-02 10:41:22','F22602104122');
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-09-02','F226021041221','2026-09-02','10:41:22','DIN','509000','5000');
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-260902-0008','D','2026-09-02','10:41:22','kasir','PENJUALAN','F226021041221','14362738000','509000','14363247000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='509000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021041221' 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 ('F226021041222','kasir',' 1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZHBF-277-0','CC X MODEL MATA CM 16 8K ','OL','0.770','1','100.00','816000','0','0','15000','809000','0','5000','0','814000','DIN','00420649','E2E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBF-277-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E2E-ZHBF-277-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021041222','2026-09-02','0.770','2026-09-02','10:41:22','PLG0084252','809000','809000','5000','814000','814000','kasir','2026-09-02 10:41:22','F22602104122');
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-09-02','F226021041222','2026-09-02','10:41:22','DIN','814000','5000');
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-260902-0009','D','2026-09-02','10:41:22','kasir','PENJUALAN','F226021041222','14363247000','814000','14364061000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='814000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021041222' 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 ('F226021041223','kasir',' 1',' MDE1 X CM ','TOKO','SMBK-E','E1D-ZHXG-118-0','CC X WEDDING POLOS CM 14 8K ','OL','1.060','1','100.00','1102000','0','0','15000','1087000','0','5000','0','1092000','DIN','00417537','E1D','0','0','-','1','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZHXG-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E1D-ZHXG-118-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021041223','2026-09-02','1.060','2026-09-02','10:41:22','PLG0084253','1087000','1087000','5000','1092000','1092000','kasir','2026-09-02 10:41:22','F22602104122');
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-09-02','F226021041223','2026-09-02','10:41:22','DIN','1092000','5000');
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-260902-0010','D','2026-09-02','10:41:22','kasir','PENJUALAN','F226021041223','14364061000','1092000','14365153000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1092000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021041223' 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 ('F226021041224','kasir',' 1',' MEB1E 5K H','TOKO','SMBK-B','B1E-ZHXE-137-T','GW TIFF PANJANG HATI CAT SLEP HW 8K ','OL','0.560','1','100.00','594000','0','0','15000','588000','0','5000','0','593000','DIN','T0082050','B1E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZHXE-137-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='B1E-ZHXE-137-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021041224','2026-09-02','0.560','2026-09-02','10:41:22','PLG0084254','588000','588000','5000','593000','593000','kasir','2026-09-02 10:41:22','F22602104122');
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-09-02','F226021041224','2026-09-02','10:41:22','DIN','593000','5000');
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-260902-0011','D','2026-09-02','10:41:22','kasir','PENJUALAN','F226021041224','14365153000','593000','14365746000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='593000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021041224' 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 ('F226021041225','kasir',' 1',' MDB1D X LG','TOKO','SMBK-B','B1D-ZFXC-72-0','GW X PANJANG MATA LG 8K ','OL','1.020','1','100.00','1061000','0','0','15000','1046000','0','5000','0','1051000','DIN','00406615','B1D','0','0','-','1','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZFXC-72-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='B1D-ZFXC-72-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021041225','2026-09-02','1.020','2026-09-02','10:41:22','PLG0084255','1046000','1046000','5000','1051000','1051000','kasir','2026-09-02 10:41:22','F22602104122');
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-09-02','F226021041225','2026-09-02','10:41:22','DIN','1051000','5000');
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-260902-0012','D','2026-09-02','10:41:22','kasir','PENJUALAN','F226021041225','14365746000','1051000','14366797000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1051000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021041225' 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 ('F226021041226','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZHAA-50-T','LT SLOBOK HURUF D BG 8K ','OL','0.520','1','100.00','562000','0','0','15000','556000','0','5000','0','561000','DIN','T0082190','D1F','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZHAA-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='D1F-ZHAA-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021041226','2026-09-02','0.520','2026-09-02','10:41:22','PLG0084256','556000','556000','5000','561000','561000','kasir','2026-09-02 10:41:22','F22602104122');
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-09-02','F226021041226','2026-09-02','10:41:22','DIN','561000','5000');
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-260902-0013','D','2026-09-02','10:41:22','kasir','PENJUALAN','F226021041226','14366797000','561000','14367358000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='561000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021041226' 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 ('F226021041227','kasir',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZHCA-39-T','LT MODEL BALERINA SLEP BG 8K ','OL','0.550','1','100.00','594000','0','0','15000','589000','0','5000','0','594000','DIN','T0082828','D1F','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZHCA-39-T' 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-09-02' AND kode_barang='D1F-ZHCA-39-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021041227','2026-09-02','0.550','2026-09-02','10:41:22','PLG0084257','589000','589000','5000','594000','594000','kasir','2026-09-02 10:41:22','F22602104122');
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-09-02','F226021041227','2026-09-02','10:41:22','DIN','594000','5000');
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-260902-0014','D','2026-09-02','10:41:22','kasir','PENJUALAN','F226021041227','14367358000','594000','14367952000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='594000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021041227' 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 ('F226021041228','kasir',' 1',' MEH1 UB 42','TOKO','SMBK-H','H1E-ZHAA-311-0','KL SANTA UB 42 8K ','OL','1.000','1','100.00','1060000','0','0','15000','1045000','0','5000','0','1050000','DIN','00418840','H1E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHAA-311-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='H1E-ZHAA-311-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021041228','2026-09-02','1.000','2026-09-02','10:41:22','PLG0084258','1045000','1045000','5000','1050000','1050000','kasir','2026-09-02 10:41:22','F22602104122');
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-09-02','F226021041228','2026-09-02','10:41:22','DIN','1050000','5000');
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-260902-0015','D','2026-09-02','10:41:22','kasir','PENJUALAN','F226021041228','14367952000','1050000','14369002000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1050000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021041228' 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 ('F226021102401','kasir','1',' TDE2 X AY ','TOKO','TBK-E','E2TD-YFBF-138-T','CC X MODEL MATA VAR AY 12 17K ','OL','0.960','1','100.00','1834000','0','0','15000','1816000','0','7000','0','1823000','TJ','T0070505','E2TD','0','0','-','1','1910000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YFBF-138-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E2TD-YFBF-138-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226021102401','2026-09-02','0.960','2026-09-02','11:02:40','PLG0084259','1816000','1816000','7000','1823000','1823000','kasir','2026-09-02 11:02:40','F22602110240');
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-09-02','F226021102401','2026-09-02','11:02:40','TJ','1823000','7000');
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-260902-0016','D','2026-09-02','11:02:40','kasir','PENJUALAN','F226021102401','14369002000','1823000','14370825000');
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 ('F226021120541','kasir','1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZHCA-43-T','GW MODEL HATI SLEP CM 8K ','OL','0.250','1','100.00','275000','0','0','15000','274000','0','5000','0','279000','TIN','T0082832','B1G','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZHCA-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='B1G-ZHCA-43-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021120541','2026-09-02','0.250','2026-09-02','11:20:54','PLG0084260','274000','274000','5000','279000','279000','kasir','2026-09-02 11:20:54','F22602112054');
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-09-02','F226021120541','2026-09-02','11:20:54','TIN','279000','5000');
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-260902-0017','D','2026-09-02','11:20:54','kasir','PENJUALAN','F226021120541','14370825000','279000','14371104000');
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 ('F226021203151','kasir','1',' MEF3E X HW','TOKO','SMBK-F','F3E-ZHCA-27-0','GL X CASTELI ARESO VAR HW 8K ','','2.500','1','100.00','2625000','0','0','15000','2600000','0','0','0','2600000','TJ','00421315','F3E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHCA-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.500',berat_jual_asli=berat_jual_asli+'2.500',stock_jual='1',berat_akhir=berat_akhir-'2.500',berat_akhir_asli=berat_akhir_asli-'2.500',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='F3E-ZHCA-27-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021203151','2026-09-02','2.500','2026-09-02','12:03:16','PLG0084261','2600000','2600000','0','2600000','2600000','kasir','2026-09-02 12:03:15','F22602120315');
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-09-02','F226021203151','2026-09-02','12:03:16','TJ','2600000','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-260902-0018','D','2026-09-02','12:03:16','kasir','PENJUALAN','F226021203151','14371104000','2600000','14373704000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2600000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021203151' 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 ('F226021203152','kasir',' 1',' MEF1E YT 5','TOKO','SMBK-F','F1E-ZHXC-105-T','GL OVAL C SLEP YT 52 8K ','','2.040','1','100.00','2162000','0','0','15000','2122000','0','0','0','2122000','TJ','T0081834','F1E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHXC-105-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.040',berat_jual_asli=berat_jual_asli+'2.040',stock_jual='1',berat_akhir=berat_akhir-'2.040',berat_akhir_asli=berat_akhir_asli-'2.040',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='F1E-ZHXC-105-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021203152','2026-09-02','2.040','2026-09-02','12:03:16','PLG0084262','2122000','2122000','0','2122000','2122000','kasir','2026-09-02 12:03:15','F22602120315');
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-09-02','F226021203152','2026-09-02','12:03:16','TJ','2122000','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-260902-0019','D','2026-09-02','12:03:16','kasir','PENJUALAN','F226021203152','14373704000','2122000','14375826000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2122000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226021203152' 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 ('F226021206361','kasir','1',' TEH2 X UB ','TOKO','TBK-H','H2TE-ZGBH-31-T','KL X SANTA VAR HATI SLEP UB 42 17K ','OL','2.900','1','100.00','5597000','0','0','15000','5519000','0','20000','0','5539000','DIN','T0081631','H2TE','0','0','-','1','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2TE-ZGBH-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.900',berat_jual_asli=berat_jual_asli+'2.900',stock_jual='1',berat_akhir=berat_akhir-'2.900',berat_akhir_asli=berat_akhir_asli-'2.900',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='H2TE-ZGBH-31-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226021206361','2026-09-02','2.900','2026-09-02','12:06:37','PLG0084263','5519000','5519000','20000','5539000','5539000','kasir','2026-09-02 12:06:36','F22602120636');
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-09-02','F226021206361','2026-09-02','12:06:37','DIN','5539000','20000');
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-260902-0020','D','2026-09-02','12:06:37','kasir','PENJUALAN','F226021206361','14375826000','5539000','14381365000');
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 ('F226021221561','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZGAH-27-T','GL RANTAI HOLLOW UB 8K ','OL','2.000','1','100.00','2120000','0','0','15000','2090000','0','10000','0','2100000','TIN','T0081332','F3E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAH-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='F3E-ZGAH-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021221561','2026-09-02','2.000','2026-09-02','12:21:57','PLG0084264','2090000','2090000','10000','2100000','2100000','kasir','2026-09-02 12:21:56','F22602122156');
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-09-02','F226021221561','2026-09-02','12:21:57','TIN','2100000','10000');
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-260902-0021','D','2026-09-02','12:21:57','kasir','PENJUALAN','F226021221561','14381365000','2100000','14383465000');
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 ('F226021226231','kasir','1',' MEE1 5K LG','TOKO','SMBK-E','E1E-ZHCA-10-T','CC MODEL ANGGUR SLEP LG 18 8K','OL','0.710','1','100.00','753000','0','0','15000','753000','0','5000','0','758000','DIN','T0082799','E1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHCA-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E1E-ZHCA-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021226231','2026-09-02','0.710','2026-09-02','12:26:23','PLG0084265','753000','753000','5000','758000','758000','kasir','2026-09-02 12:26:23','F22602122623');
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-09-02','F226021226231','2026-09-02','12:26:23','DIN','758000','5000');
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-260902-0022','D','2026-09-02','12:26:23','kasir','PENJUALAN','F226021226231','14383465000','758000','14384223000');
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 ('F226021257491','kasir','1',' MEE1 X HT ','TOKO','SMBK-E','E1E-ZHBE-125-0','CC X MODEL DAUN SLEP HT 14 8K ','OL','0.650','1','100.00','689000','0','0','15000','686000','0','5000','0','691000','NS','00420167','E1E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBE-125-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E1E-ZHBE-125-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226021257491','2026-09-02','0.650','2026-09-02','12:57:50','PLG0084266','686000','686000','5000','691000','691000','kasir','2026-09-02 12:57:49','F22602125749');
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-09-02','F226021257491','2026-09-02','12:57:50','NS','691000','5000');
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-260902-0023','D','2026-09-02','12:57:50','kasir','PENJUALAN','F226021257491','14384223000','691000','14384914000');
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 ('F226020127391','kasir','1',' MEE2E KH 1','TOKO','SMBK-E','E2E-ZHBI-67-T','CC MODEL SNAKE MATA SLEP KH 12 8K ','OL','0.450','1','100.00','477000','0','0','15000','473000','0','5000','0','478000','DIN','T0082756','E2E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBI-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E2E-ZHBI-67-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020127391','2026-09-02','0.450','2026-09-02','13:27:40','PLG0084267','473000','473000','5000','478000','478000','kasir','2026-09-02 13:27:39','F22602012739');
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-09-02','F226020127391','2026-09-02','13:27:40','DIN','478000','5000');
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-260902-0024','D','2026-09-02','13:27:40','kasir','PENJUALAN','F226020127391','14384914000','478000','14385392000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='478000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020127391' 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 ('F226020127392','kasir',' 1',' MEE2 X PM ','TOKO','SMBK-E','E2E-ZHBF-283-0','CC X MODEL MATA PM 12 8K ','OL','0.520','1','100.00','551000','0','0','15000','546000','0','5000','0','551000','DIN','00420655','E2E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBF-283-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E2E-ZHBF-283-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020127392','2026-09-02','0.520','2026-09-02','13:27:40','PLG0084268','546000','546000','5000','551000','551000','kasir','2026-09-02 13:27:39','F22602012739');
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-09-02','F226020127392','2026-09-02','13:27:40','DIN','551000','5000');
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-260902-0025','D','2026-09-02','13:27:40','kasir','PENJUALAN','F226020127392','14385392000','551000','14385943000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='551000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020127392' 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 ('F226020142361','kasir','1',' MDE1 X CM ','TOKO','SMBK-E','E1D-ZIXA-366-0','CC X MODEL SLEP CM 14 8K ','OL','1.020','1','100.00','1051000','0','0','15000','1046000','0','5000','0','1051000','DIN','00421793','E1D','0','0','-','1','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZIXA-366-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E1D-ZIXA-366-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020142361','2026-09-02','1.020','2026-09-02','13:42:37','PLG0084269','1046000','1046000','5000','1051000','1051000','kasir','2026-09-02 13:42:36','F22602014236');
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-09-02','F226020142361','2026-09-02','13:42:37','DIN','1051000','5000');
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-260902-0026','D','2026-09-02','13:42:37','kasir','PENJUALAN','F226020142361','14385943000','1051000','14386994000');
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 ('F226020155361','kasir','1',' MFE1 X HW ','TOKO','SMBK-E','E1F-ZHBF-292-0','CC X GELOMBANG SLEP HW 16 8K ','OL','0.350','1','100.00','378000','0','0','15000','375000','0','5000','0','380000','DIN','00420664','E1F','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHBF-292-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-09-02' AND kode_barang='E1F-ZHBF-292-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020155361','2026-09-02','0.350','2026-09-02','13:55:36','PLG0084270','375000','375000','5000','380000','380000','kasir','2026-09-02 13:55:36','F22602015536');
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-09-02','F226020155361','2026-09-02','13:55:36','DIN','380000','5000');
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-260902-0027','D','2026-09-02','13:55:36','kasir','PENJUALAN','F226020155361','14386994000','380000','14387374000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='380000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020155361' 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 ('F226020155362','kasir',' 1',' MFE1 X HW ','TOKO','SMBK-E','E1F-ZHBE-130-0','CC X MODEL GELOMBANG SLEP HW 15 8K ','OL','0.380','1','100.00','410000','0','0','15000','407000','0','5000','0','412000','DIN','00420172','E1F','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHBE-130-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E1F-ZHBE-130-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020155362','2026-09-02','0.380','2026-09-02','13:55:36','PLG0084271','407000','407000','5000','412000','412000','kasir','2026-09-02 13:55:36','F22602015536');
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-09-02','F226020155362','2026-09-02','13:55:36','DIN','412000','5000');
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-260902-0028','D','2026-09-02','13:55:36','kasir','PENJUALAN','F226020155362','14387374000','412000','14387786000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='412000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020155362' 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 ('F226020155363','kasir',' 1',' MFE2F KH 1','TOKO','SMBK-E','E2F-ZHCA-19-T','CC MODEL PAKU MATA SLEP KH 16 8K ','OL','0.400','1','100.00','432000','0','0','15000','428000','0','5000','0','433000','DIN','T0082808','E2F','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZHCA-19-T' 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-09-02' AND kode_barang='E2F-ZHCA-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020155363','2026-09-02','0.400','2026-09-02','13:55:36','PLG0084272','428000','428000','5000','433000','433000','kasir','2026-09-02 13:55:36','F22602015536');
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-09-02','F226020155363','2026-09-02','13:55:36','DIN','433000','5000');
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-260902-0029','D','2026-09-02','13:55:36','kasir','PENJUALAN','F226020155363','14387786000','433000','14388219000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='433000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020155363' 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 ('F226020155364','kasir',' 1',' MEF2E KH 1','TOKO','SMBK-E','E2E-ZHBH-82-T','CC MODEL PAKU MATA SLEP KH 14 8K ','OL','0.410','1','100.00','435000','0','0','15000','439000','0','5000','0','444000','DIN','T0082679','E2E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBH-82-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E2E-ZHBH-82-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020155364','2026-09-02','0.410','2026-09-02','13:55:36','PLG0084273','439000','439000','5000','444000','444000','kasir','2026-09-02 13:55:36','F22602015536');
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-09-02','F226020155364','2026-09-02','13:55:36','DIN','444000','5000');
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-260902-0030','D','2026-09-02','13:55:36','kasir','PENJUALAN','F226020155364','14388219000','444000','14388663000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='444000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020155364' 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 ('F226020207401','kasir','1',' MEE1 X KH ','TOKO','SMBK-E','E1E-ZIXA-367-0','CC X MODEL SLEP KH 8 8K ','OL','0.460','1','100.00','483000','0','0','15000','483000','0','5000','0','488000','DIN','00421794','E1E','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIXA-367-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E1E-ZIXA-367-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020207401','2026-09-02','0.460','2026-09-02','14:07:40','PLG0084274','483000','483000','5000','488000','488000','kasir','2026-09-02 14:07:40','F22602020740');
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-09-02','F226020207401','2026-09-02','14:07:40','DIN','488000','5000');
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-260902-0031','D','2026-09-02','14:07:40','kasir','PENJUALAN','F226020207401','14388663000','488000','14389151000');
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-00005674','X-00005674','AT MODEL SLEP HW 8K','GR','---','A1E','BELI','BELI001','608000','2026-09-02','0.650','1','kasir','2026-09-02 14:33:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00005674','X-00005674');
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-260902-0001','F226301049222','NOV','1','BELI','BELI001','A1E', 'X-00005674', 'AT MODEL SLEP HW 8K','0.650','0.650','100.00','689000','608000','935385','1050000','1','608000','608000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.650',berat_beli_asli=berat_beli_asli+'0.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.650',berat_akhir_asli=berat_akhir_asli+'0.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-02' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260902-0001','2026-09-02','2026-09-02','14:33:26','NOV','---','0.650','608000','608000','608000','608000','608000','kasir','2026-09-02 14:33:26','FB-260902-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260902-0001','MARYATI','JATEN SLAHUNG','','','085233188813','kasir','2026-09-02 14:33:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-02' 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-260902-0032','K','2026-09-02','14:33:26','kasir','PEMBELIAN UMUM','FB-260902-0001','14389151000','608000','14388543000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020127391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020127391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020127391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020127392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020127392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020127392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020142361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020142361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020142361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020155361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020155361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020155361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020155362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020155362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020155362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020155363' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020155363' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020155363';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020155364' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020155364' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020155364';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020207401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020207401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020826321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020826321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020826321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021012321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021012321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021012321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021013481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021013481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021013481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021017271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021017271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021017271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021028081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021028081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021028081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021028082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021028082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021028082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021041221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021041222';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041223' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041223' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021041223';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041224' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041224' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021041224';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041225' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041225' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021041225';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041226' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041226' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021041226';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041227' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041227' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021041227';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041228' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021041228' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021041228';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021102401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021102401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021102401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021120541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021120541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021120541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021203151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021203151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021203151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021203152' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021203152' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021203152';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021206361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021206361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021206361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021221561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021221561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021221561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021226231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021226231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021226231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226021257491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226021257491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226021257491';
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 ('F226020314311','kasir','1',' MHA1 LG ','TOKO','SMBK-A','A1H-ZAAG-3-T','AT DEASY MATA LG 8K ','','0.250','1','100.00','280000','0','0','15000','275000','0','0','0','275000','LUS','T0076597','A1H','0','0','-','1','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-ZAAG-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='A1H-ZAAG-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020314311','2026-09-02','0.250','2026-09-02','15:14:32','PLG0084275','275000','275000','0','275000','275000','kasir','2026-09-02 15:14:31','F22602031431');
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-09-02','F226020314311','2026-09-02','15:14:32','LUS','275000','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-260902-0033','D','2026-09-02','15:14:32','kasir','PENJUALAN','F226020314311','14388543000','275000','14388818000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='275000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020314311' 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 ('F226020314312','kasir',' 1',' MGB1G X CM','TOKO','SMBK-B','B1G-ZHBE-190-0','GW X TUSUK DAISY MATA CM 8K ','','0.230','1','100.00','253000','0','0','15000','248000','0','0','0','248000','LUS','00420232','B1G','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZHBE-190-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.230',berat_jual_asli=berat_jual_asli+'0.230',stock_jual='1',berat_akhir=berat_akhir-'0.230',berat_akhir_asli=berat_akhir_asli-'0.230',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='B1G-ZHBE-190-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020314312','2026-09-02','0.230','2026-09-02','15:14:32','PLG0084276','248000','248000','0','248000','248000','kasir','2026-09-02 15:14:31','F22602031431');
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-09-02','F226020314312','2026-09-02','15:14:32','LUS','248000','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-260902-0034','D','2026-09-02','15:14:32','kasir','PENJUALAN','F226020314312','14388818000','248000','14389066000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='248000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020314312' 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 ('F226020314313','kasir',' 1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZHCA-48-T','GW MODEL HATI SLEP CM 8K ','','0.250','1','100.00','275000','0','0','15000','270000','0','0','0','270000','LUS','T0082837','B1G','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZHCA-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='B1G-ZHCA-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020314313','2026-09-02','0.250','2026-09-02','15:14:32','PLG0084277','270000','270000','0','270000','270000','kasir','2026-09-02 15:14:31','F22602031431');
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-09-02','F226020314313','2026-09-02','15:14:32','LUS','270000','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-260902-0035','D','2026-09-02','15:14:32','kasir','PENJUALAN','F226020314313','14389066000','270000','14389336000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='270000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020314313' 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 ('F226020314314','kasir',' 1',' MGB1G CM ','TOKO','SMBK-B','B1G-ZHCA-54-T','GW MODEL HATI SLEP CM 8K ','','0.250','1','100.00','275000','0','0','15000','270000','0','0','0','270000','LUS','T0082843','B1G','0','0','-','1','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZHCA-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='B1G-ZHCA-54-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020314314','2026-09-02','0.250','2026-09-02','15:14:32','PLG0084278','270000','270000','0','270000','270000','kasir','2026-09-02 15:14:31','F22602031431');
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-09-02','F226020314314','2026-09-02','15:14:32','LUS','270000','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-260902-0036','D','2026-09-02','15:14:32','kasir','PENJUALAN','F226020314314','14389336000','270000','14389606000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='270000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020314314' 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 ('F226020314315','kasir',' 1',' MFE2F KH 1','TOKO','SMBK-E','E2F-ZHCA-16-T','CC MODEL PAKU MATA SLEP KH 12 8K ','','0.400','1','100.00','432000','0','0','15000','425000','0','0','0','425000','LUS','T0082805','E2F','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZHCA-16-T' 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-09-02' AND kode_barang='E2F-ZHCA-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020314315','2026-09-02','0.400','2026-09-02','15:14:32','PLG0084279','425000','425000','0','425000','425000','kasir','2026-09-02 15:14:31','F22602031431');
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-09-02','F226020314315','2026-09-02','15:14:32','LUS','425000','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-260902-0037','D','2026-09-02','15:14:32','kasir','PENJUALAN','F226020314315','14389606000','425000','14390031000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='425000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020314315' 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 ('F226020314316','kasir',' 1',' MEE1E LG 1','TOKO','SMBK-E','E1E-ZFAI-44-T','CC MODEL BANGKOK SLEP LG 17 8K ','','0.510','1','100.00','541000','0','0','15000','530000','0','0','0','530000','LUS','T0080544','E1E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E1E-ZFAI-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020314316','2026-09-02','0.510','2026-09-02','15:14:32','PLG0084280','530000','530000','0','530000','530000','kasir','2026-09-02 15:14:31','F22602031431');
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-09-02','F226020314316','2026-09-02','15:14:32','LUS','530000','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-260902-0038','D','2026-09-02','15:14:32','kasir','PENJUALAN','F226020314316','14390031000','530000','14390561000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020314316' 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 ('F226020314317','kasir',' 1',' MEF3 6K UB','TOKO','SMBK-F','F3E-ZFXD-37-T','GL RANTAI P3 SLEP UB 8K ','','1.050','1','100.00','1113000','0','0','15000','1092000','0','6000','0','1098000','LUS','T0080202','F3E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='F3E-ZFXD-37-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020314317','2026-09-02','1.050','2026-09-02','15:14:32','PLG0084281','1092000','1092000','6000','1098000','1098000','kasir','2026-09-02 15:14:31','F22602031431');
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-09-02','F226020314317','2026-09-02','15:14:32','LUS','1098000','6000');
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-260902-0039','D','2026-09-02','15:14:32','kasir','PENJUALAN','F226020314317','14390561000','1098000','14391659000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1098000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020314317' 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 ('F226020314318','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZEAE-67-T','GL RANTAI HOLLOW MODEL CD VAR HW 8K ','','1.140','1','100.00','1208000','0','0','15000','1186000','0','0','0','1186000','LUS','T0079493','F3E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEAE-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.140',berat_jual_asli=berat_jual_asli+'1.140',stock_jual='1',berat_akhir=berat_akhir-'1.140',berat_akhir_asli=berat_akhir_asli-'1.140',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='F3E-ZEAE-67-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020314318','2026-09-02','1.140','2026-09-02','15:14:32','PLG0084282','1186000','1186000','0','1186000','1186000','kasir','2026-09-02 15:14:31','F22602031431');
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-09-02','F226020314318','2026-09-02','15:14:32','LUS','1186000','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-260902-0040','D','2026-09-02','15:14:32','kasir','PENJUALAN','F226020314318','14391659000','1186000','14392845000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1186000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226020314318' 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 ('F226020316001','kasir','1',' MEH1E UB 4','TOKO','SMBK-H','H1E-ZHBI-3-T','KL TIFF BOTEGA SLEP UB 40 8K ','','1.110','1','100.00','1177000','0','0','15000','1155000','0','0','0','1155000','LUS','T0082692','H1E','0','0','-','1','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBI-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='H1E-ZHBI-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020316001','2026-09-02','1.110','2026-09-02','15:16:01','PLG0084283','1155000','1155000','0','1155000','1155000','kasir','2026-09-02 15:16:00','F22602031600');
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-09-02','F226020316001','2026-09-02','15:16:01','LUS','1155000','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-260902-0041','D','2026-09-02','15:16:01','kasir','PENJUALAN','F226020316001','14392845000','1155000','14394000000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020314311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314312' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314312' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020314312';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314313' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314313' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020314313';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314314' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314314' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020314314';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314315' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314315' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020314315';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314316' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314316' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020314316';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314317' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314317' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020314317';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314318' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020314318' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020314318';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020316001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020316001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020316001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260902-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260902-0001';
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 ('F226020403571','kasir','1',' MDE1 X CM ','TOKO','SMBK-E','E1D-ZHBF-287-0','CC X MODEL SLEP CM 10 8K ','','0.900','1','100.00','936000','0','0','15000','918000','0','0','0','918000','NS','00420659','E1D','0','0','-','1','1030000');
UPDATE tm_barang SET tgl_last_jual='2026-09-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZHBF-287-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-09-02' AND kode_barang='E1D-ZHBF-287-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226020403571','2026-09-02','0.900','2026-09-02','16:03:57','PLG0084284','918000','918000','0','918000','918000','kasir','2026-09-02 16:03:57','F22602040357');
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-09-02','F226020403571','2026-09-02','16:03:57','NS','918000','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-260902-0042','D','2026-09-02','16:03:57','kasir','PENJUALAN','F226020403571','14394000000','918000','14394918000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226020403571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226020403571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226020403571';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-02';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-09-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-02' 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-260903-0001','D','2026-09-03','16:07:59','SYSTEM','SALDO AWAL','SALDO AWAL','0','14394918000','14394918000');
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-260903-0001','D','2026-09-03','16:07:59','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-260903-0001','D','2026-09-03','16:07:59','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-260903-0001','D','2026-09-03','16:07:59','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-260903-0001','D','2026-09-03','16:07:59','','SALDO AWAL','SALDO AWAL','0','3346000','3346000');
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-260903-0001','D','2026-09-03','16:07:59','BCA','SALDO AWAL','SALDO AWAL','0','4781078888','4781078888');
UPDATE tp_system SET tgl_system='2026-09-03';