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-20261106-0001','1','D2E-ZIXI-170-0','1','0.550','0.550','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D2E-ZIXI-170-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-ZIXI-170-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-11-06 08:15:45' WHERE kode_barang='D2E-ZIXI-170-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-ZIXI-170-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-11-06 08:15:45','TOKO','PM-D','D2E','D2E-ZIXI-170-0','1','0.550','0.550','1','0.550','0.550','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-ZIXI-170-0'; DELETE FROM tm_barang_export WHERE kode_barang='D2E-ZIXI-170-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261106-0001','2026-11-06','08:15','0.550','admpindah','2026-11-06 08:15:45'); 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-20261106-0001','1','E2D-ZKXE-74-0','1','1.270','1.270','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-74-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-74-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-74-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-74-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-74-0','1','1.270','1.270','1','1.270','1.270','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-ZKXE-74-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-74-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261106-0001','1','E2D-ZKXE-75-0','1','1.250','1.250','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-75-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-75-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-75-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-75-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-75-0','1','1.250','1.250','1','1.250','1.250','100.00'); DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZKXE-75-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-75-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-20261106-0001','1','E2D-ZKXE-77-0','1','1.070','1.070','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-77-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-77-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-77-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-77-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-77-0','1','1.070','1.070','1','1.070','1.070','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-ZKXE-77-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-77-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-20261106-0001','1','E2D-ZKXE-114-0','1','0.960','0.960','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-114-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-114-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-114-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-114-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-114-0','1','0.960','0.960','1','0.960','0.960','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-ZKXE-114-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-114-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-20261106-0001','1','E2D-ZKXE-115-0','1','1.030','1.030','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-115-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-115-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-115-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-115-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-115-0','1','1.030','1.030','1','1.030','1.030','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-ZKXE-115-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-115-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-20261106-0001','1','E2D-ZKXE-120-0','1','0.900','0.900','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-120-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-120-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-120-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-120-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-120-0','1','0.900','0.900','1','0.900','0.900','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-ZKXE-120-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-120-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-20261106-0001','1','E2D-ZKXE-123-0','1','0.900','0.900','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-123-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-123-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-123-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-123-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-123-0','1','0.900','0.900','1','0.900','0.900','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-ZKXE-123-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-123-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-20261106-0001','1','E2D-ZKXE-135-0','1','1.640','1.640','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-135-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-135-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-135-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-135-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-135-0','1','1.640','1.640','1','1.640','1.640','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-ZKXE-135-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-135-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-20261106-0001','1','E2D-ZKXE-139-0','1','1.450','1.450','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-139-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-139-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-139-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-139-0','1','1.450','1.450','1','1.450','1.450','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-ZKXE-139-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-139-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-20261106-0001','1','E2D-ZKXE-140-0','1','1.100','1.100','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-140-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-140-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-140-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-140-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-140-0','1','1.100','1.100','1','1.100','1.100','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-ZKXE-140-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-140-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-20261106-0001','1','E2D-ZKXE-142-0','1','1.130','1.130','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-142-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-142-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-142-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-142-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-142-0','1','1.130','1.130','1','1.130','1.130','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-ZKXE-142-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-142-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-20261106-0001','1','E2D-ZKXE-143-0','1','1.120','1.120','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-143-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-143-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-143-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-143-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-143-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-ZKXE-143-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-143-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-20261106-0001','1','E2D-ZKXE-153-0','1','0.910','0.910','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZKXE-153-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-153-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E2D-ZKXE-153-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZKXE-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-11-06 08:15:59','TOKO','PM-E','E2D','E2D-ZKXE-153-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-ZKXE-153-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZKXE-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-20261106-0001','1','E1D-ZKXE-158-0','1','1.270','1.270','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZKXE-158-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZKXE-158-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E1D-ZKXE-158-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZKXE-158-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-11-06 08:15:59','TOKO','PM-E','E1D','E1D-ZKXE-158-0','1','1.270','1.270','1','1.270','1.270','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZKXE-158-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZKXE-158-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-20261106-0001','1','E1E-ZKXE-185-0','1','0.430','0.430','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZKXE-185-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZKXE-185-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E1E-ZKXE-185-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZKXE-185-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-11-06 08:15:59','TOKO','PM-E','E1E','E1E-ZKXE-185-0','1','0.430','0.430','1','0.430','0.430','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-ZKXE-185-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZKXE-185-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-20261106-0001','1','E1E-ZKXE-193-0','1','0.630','0.630','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZKXE-193-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZKXE-193-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E1E-ZKXE-193-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZKXE-193-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-11-06 08:15:59','TOKO','PM-E','E1E','E1E-ZKXE-193-0','1','0.630','0.630','1','0.630','0.630','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-ZKXE-193-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZKXE-193-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-20261106-0001','1','E1D-ZKXE-195-0','1','0.850','0.850','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZKXE-195-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZKXE-195-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E1D-ZKXE-195-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZKXE-195-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-11-06 08:15:59','TOKO','PM-E','E1D','E1D-ZKXE-195-0','1','0.850','0.850','1','0.850','0.850','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-ZKXE-195-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZKXE-195-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-20261106-0001','1','E1E-ZKXE-203-0','1','0.540','0.540','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZKXE-203-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZKXE-203-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E1E-ZKXE-203-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZKXE-203-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-11-06 08:15:59','TOKO','PM-E','E1E','E1E-ZKXE-203-0','1','0.540','0.540','1','0.540','0.540','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-ZKXE-203-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZKXE-203-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-20261106-0001','1','E1E-ZKXE-206-0','1','0.470','0.470','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZKXE-206-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZKXE-206-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E1E-ZKXE-206-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZKXE-206-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-11-06 08:15:59','TOKO','PM-E','E1E','E1E-ZKXE-206-0','1','0.470','0.470','1','0.470','0.470','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-ZKXE-206-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZKXE-206-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-20261106-0001','1','E1F-ZKXE-218-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZKXE-218-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZKXE-218-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E1F-ZKXE-218-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZKXE-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-11-06 08:15:59','TOKO','PM-E','E1F','E1F-ZKXE-218-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-ZKXE-218-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZKXE-218-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-20261106-0001','1','E1F-ZKXE-220-0','1','0.360','0.360','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZKXE-220-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZKXE-220-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E1F-ZKXE-220-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZKXE-220-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-11-06 08:15:59','TOKO','PM-E','E1F','E1F-ZKXE-220-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-ZKXE-220-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZKXE-220-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261106-0001','1','E1F-ZKXE-222-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1F-ZKXE-222-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZKXE-222-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-11-06 08:15:59' WHERE kode_barang='E1F-ZKXE-222-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZKXE-222-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-11-06 08:15:59','TOKO','PM-E','E1F','E1F-ZKXE-222-0','1','0.400','0.400','1','0.400','0.400','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1F-ZKXE-222-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZKXE-222-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261106-0001','2026-11-06','08:15','20.030','admpindah','2026-11-06 08:15:58'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261106-0001','1','F3E-ZKXE-7-0','1','2.930','2.930','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKXE-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKXE-7-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-06 08:16:24' WHERE kode_barang='F3E-ZKXE-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKXE-7-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-11-06 08:16:24','TOKO','PM-F','F3E','F3E-ZKXE-7-0','1','2.930','2.930','1','2.930','2.930','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-ZKXE-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKXE-7-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-20261106-0001','1','F3E-ZKXE-10-0','1','2.490','2.490','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKXE-10-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKXE-10-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-06 08:16:24' WHERE kode_barang='F3E-ZKXE-10-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKXE-10-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-11-06 08:16:24','TOKO','PM-F','F3E','F3E-ZKXE-10-0','1','2.490','2.490','1','2.490','2.490','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-ZKXE-10-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKXE-10-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-20261106-0001','1','F3E-ZKXE-18-0','1','2.720','2.720','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKXE-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKXE-18-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-06 08:16:24' WHERE kode_barang='F3E-ZKXE-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKXE-18-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-11-06 08:16:24','TOKO','PM-F','F3E','F3E-ZKXE-18-0','1','2.720','2.720','1','2.720','2.720','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-ZKXE-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKXE-18-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-20261106-0001','1','F3E-ZKXE-32-0','1','1.050','1.050','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKXE-32-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKXE-32-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-06 08:16:24' WHERE kode_barang='F3E-ZKXE-32-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKXE-32-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-11-06 08:16:24','TOKO','PM-F','F3E','F3E-ZKXE-32-0','1','1.050','1.050','1','1.050','1.050','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZKXE-32-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKXE-32-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-20261106-0001','1','F3E-ZKXE-35-0','1','1.510','1.510','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZKXE-35-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZKXE-35-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-11-06 08:16:24' WHERE kode_barang='F3E-ZKXE-35-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZKXE-35-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-11-06 08:16:24','TOKO','PM-F','F3E','F3E-ZKXE-35-0','1','1.510','1.510','1','1.510','1.510','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-ZKXE-35-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZKXE-35-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261106-0001','2026-11-06','08:16','10.700','admpindah','2026-11-06 08:16:23'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261106-0001','1','H2J-ZJCX-46-0','1','1.070','1.070','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H2J-ZJCX-46-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-ZJCX-46-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-06 08:16:40' WHERE kode_barang='H2J-ZJCX-46-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-ZJCX-46-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-11-06 08:16:40','TOKO','PM-H','H2J','H2J-ZJCX-46-0','1','1.070','1.070','1','1.070','1.070','100.00'); DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-ZJCX-46-0'; DELETE FROM tm_barang_export WHERE kode_barang='H2J-ZJCX-46-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-20261106-0001','1','H1E-ZKXD-347-0','1','1.010','1.010','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZKXD-347-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZKXD-347-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-11-06 08:16:40' WHERE kode_barang='H1E-ZKXD-347-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZKXD-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-11-06 08:16:40','TOKO','PM-H','H1E','H1E-ZKXD-347-0','1','1.010','1.010','1','1.010','1.010','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-ZKXD-347-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZKXD-347-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261106-0001','2026-11-06','08:16','2.080','admpindah','2026-11-06 08:16:39'); 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 ('F326060837201','input','1',' MEF3E X UB','TOKO','PM-F','F3E-ZKXD-102-0','GL X GHENIA SLEP UB 8K ','','0.480','1','100.00','497000','0','0','15000','497000','0','0','0','497000','SIN','00433072','F3E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZKXD-102-0' 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-11-06' AND kode_barang='F3E-ZKXD-102-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326060837201','2026-11-06','0.480','2026-11-06','08:37:20','PLG0032216','497000','497000','0','497000','497000','input','2026-11-06 08:37:20','F32606083720'); 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-11-06','F326060837201','2026-11-06','08:37:20','SIN','497000','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-261106-0002','D','2026-11-06','08:37:20','input','PENJUALAN','F326060837201','8095478000','497000','8095975000'); 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-00020751','X-00020751','KL X TIFF MATA VAR UB 42 8K','GR','---','H1E','BELI','BELI001','1157000','2026-11-06','1.360','1','kasir','2026-11-06 10:04:23'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020751','X-00020751'); 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-261106-0001','F326031008381','AAT','1','BELI','BELI001','H1E', 'X-00020751', 'KL X TIFF MATA VAR UB 42 8K','1.380','1.360','100.00','1767000','1157000','850735','1045000','1','1157000','1157000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.360',berat_beli_asli=berat_beli_asli+'1.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.360',berat_akhir_asli=berat_akhir_asli+'1.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261106-0001','2026-11-06','2026-11-06','10:04:22','AAT','---','1.360','1157000','1157000','1157000','1157000','1157000','kasir','2026-11-06 10:04:23','FB-261106-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261106-0001','TARI','PAGER UKIR SAMPUNG','','','085782741027','kasir','2026-11-06 10:04:23'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261106-0003','K','2026-11-06','10:04:22','kasir','PEMBELIAN UMUM','FB-261106-0001','8095975000','1157000','8094818000'); 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 ('F326061012271','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZJAE-233-0','GL X BRONET SLEP UB 8K ','','0.700','1','100.00','724000','0','0','15000','725000','0','0','0','725000','SIN','00430116','F3E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJAE-233-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='F3E-ZJAE-233-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326061012271','2026-11-06','0.700','2026-11-06','10:12:27','PLG0032217','725000','725000','0','725000','725000','kasir','2026-11-06 10:12:27','F32606101227'); 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-11-06','F326061012271','2026-11-06','10:12:27','SIN','725000','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-261106-0004','D','2026-11-06','10:12:27','kasir','PENJUALAN','F326061012271','8094818000','725000','8095543000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='725000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061012271' 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 ('F326061012272','kasir',' 1',' MEE2 LT ','TOKO','PM-E','E2E-ZKXC-344-0','CC MODEL MATA VAR LT 8K ','','0.770','1','100.00','797000','0','0','15000','797000','0','0','0','797000','SIN','00432967','E2E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZKXC-344-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-11-06' AND kode_barang='E2E-ZKXC-344-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061012272','2026-11-06','0.770','2026-11-06','10:12:27','PLG0032218','797000','797000','0','797000','797000','kasir','2026-11-06 10:12:27','F32606101227'); 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-11-06','F326061012272','2026-11-06','10:12:27','SIN','797000','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-261106-0005','D','2026-11-06','10:12:27','kasir','PENJUALAN','F326061012272','8095543000','797000','8096340000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='797000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061012272' LIMIT 1; 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-00020752','X-00020752','GL X CAPELLA SLEP HW 8K','GR','---','F3E','BELI','BELI001','1333000','2026-11-06','1.450','1','kasir','2026-11-06 10:14:55'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020752','X-00020752'); 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-261106-0002','F326090939221','SIN','1','BELI','BELI001','F3E', 'X-00020752', 'GL X CAPELLA SLEP HW 8K','1.450','1.450','100.00','1690000','1333000','919310','1045000','1','1333000','1333000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.450',berat_beli_asli=berat_beli_asli+'1.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.450',berat_akhir_asli=berat_akhir_asli+'1.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261106-0002','2026-11-06','2026-11-06','10:14:54','SIN','---','1.450','1333000','1333000','1333000','1333000','1333000','kasir','2026-11-06 10:14:55','FB-261106-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261106-0002','YUNI','PURWANTORO','','','08899693871','kasir','2026-11-06 10:14:55'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261106-0006','K','2026-11-06','10:14:54','kasir','PEMBELIAN UMUM','FB-261106-0002','8096340000','1333000','8095007000'); 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 ('F326061053401','kasir','1',' TEE1 KH 16','TOKO','PT-E','E1TE-ZJAX-58-T','CC MODEL BUNGA CLOVER SLEP KH 16 17K ','','0.470','1','100.00','898000','0','0','15000','898000','0','0','0','898000','LIS','T0086296','E1TE','0','0','-','0','1910000'); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZJAX-58-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-11-06' AND kode_barang='E1TE-ZJAX-58-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326061053401','2026-11-06','0.470','2026-11-06','10:53:41','PLG0032219','898000','898000','0','898000','898000','kasir','2026-11-06 10:53:40','F32606105340'); 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-11-06','F326061053401','2026-11-06','10:53:41','LIS','898000','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-261106-0007','D','2026-11-06','10:53:41','kasir','PENJUALAN','F326061053401','8095007000','898000','8095905000'); 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-00020753','X-00020753','GW X PANJANG MATA LG 8K','GR','---','B1D','BELI','BELI001','1027000','2026-11-06','1.080','1','kasir','2026-11-06 11:29:33'); DELETE FROM tp_barang WHERE kode_dept = 'X-B1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1D','X-00020753','X-00020753'); 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-261106-0003','F325121116231','SIN','1','BELI','BELI001','B1D', 'X-00020753', 'GW X PANJANG MATA LG 8K','1.080','1.080','100.00','1105000','1027000','950926','1025000','1','1027000','1027000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.080',berat_beli_asli=berat_beli_asli+'1.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.080',berat_akhir_asli=berat_akhir_asli+'1.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1D' 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-261106-0003','2026-11-06','2026-11-06','11:29:32','SIN','---','1.080','1027000','1027000','1027000','1027000','1027000','kasir','2026-11-06 11:29:33','FB-261106-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261106-0003','SRI WAHYUNI','PLOSO','','','081225986090','kasir','2026-11-06 11:29:33'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261106-0008','K','2026-11-06','11:29:32','kasir','PEMBELIAN UMUM','FB-261106-0003','8095905000','1027000','8094878000'); 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-00020754','X-00020754','GL X OVAL C GELOMBANG SLEP YT 58 8K','GR','---','F1E','BELI','BELI001','3255000','2026-11-06','3.350','1','kasir','2026-11-06 11:30:07'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020754','X-00020754'); 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-261106-0004','F326311104061','AAT','1','BELI','BELI001','F1E', 'X-00020754', 'GL X OVAL C GELOMBANG SLEP YT 58 8K','3.350','3.350','100.00','3517000','3255000','971642','1045000','1','3255000','3255000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.350',berat_beli_asli=berat_beli_asli+'3.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.350',berat_akhir_asli=berat_akhir_asli+'3.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-261106-0004','2026-11-06','2026-11-06','11:30:06','AAT','---','3.350','3255000','3255000','3255000','3255000','3255000','kasir','2026-11-06 11:30:07','FB-261106-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261106-0004','INDAH','BULUKERTO','','','081333043948','kasir','2026-11-06 11:30:07'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261106-0009','K','2026-11-06','11:30:06','kasir','PEMBELIAN UMUM','FB-261106-0004','8094878000','3255000','8091623000'); 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 ('F326061150231','kasir','1',' MEF3 KH ','TOKO','PM-F','F3E-ZJBF-87-0','GL SIEM COBRA MODEL MATA VAR KH 8K ','','2.180','1','100.00','2256000','0','0','15000','2256000','0','0','0','2256000','SIN','00431171','F3E','0','0','-','0','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJBF-87-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='F3E-ZJBF-87-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-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 ('F326061150231','2026-11-06','2.180','2026-11-06','11:50:23','PLG0032220','2256000','2256000','0','2256000','2256000','kasir','2026-11-06 11:50:23','F32606115023'); 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-11-06','F326061150231','2026-11-06','11:50:23','SIN','2256000','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-261106-0010','D','2026-11-06','11:50:23','kasir','PENJUALAN','F326061150231','8091623000','2256000','8093879000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2256000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061150231' 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 ('F326061150232','kasir',' 1',' TEF3 XX HW','TOKO','PT-F','F3TE-ZIXE-40-T','GL XX MODEL FLIK VAR HW 17K ','','3.070','1','100.00','5864000','0','0','15000','5770000','0','0','0','5770000','SIN','T0083058','F3TE','0','0','-','1','1910000'); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-ZIXE-40-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='F3TE-ZIXE-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326061150232','2026-11-06','3.070','2026-11-06','11:50:23','PLG0032221','5770000','5770000','0','5770000','5770000','kasir','2026-11-06 11:50:23','F32606115023'); 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-11-06','F326061150232','2026-11-06','11:50:23','SIN','5770000','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-261106-0011','D','2026-11-06','11:50:23','kasir','PENJUALAN','F326061150232','8093879000','5770000','8099649000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='5770000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326061150232' LIMIT 1; 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-00020755','X-00020755','CC X SOLITAIRE MATA AY 12 8K','GR','---','E2E','BELI','BELI001','757000','2026-11-06','0.780','1','kasir','2026-11-06 13:16:41'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020755','X-00020755'); 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-261106-0005','F326151142091','SIN','1','BELI','BELI001','E2E', 'X-00020755', 'CC X SOLITAIRE MATA AY 12 8K','0.780','0.780','100.00','875000','757000','970513','1045000','1','757000','757000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.780',berat_beli_asli=berat_beli_asli+'0.780',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.780',berat_akhir_asli=berat_akhir_asli+'0.780',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261106-0005','2026-11-06','2026-11-06','13:16:40','SIN','---','0.780','757000','757000','757000','757000','757000','kasir','2026-11-06 13:16:41','FB-261106-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261106-0005','ERLINA','BLIMBING PWO','','','085939118571','kasir','2026-11-06 13:16:41'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261106-0012','K','2026-11-06','13:16:40','kasir','PEMBELIAN UMUM','FB-261106-0005','8099649000','757000','8098892000'); 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-00020756','X-00020756','KL TIFF RIBBON MATA VAR LG 42 8K','GR','---','H1E','BELI','BELI001','755000','2026-11-06','0.960','1','kasir','2026-11-06 13:16:41'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020756','X-00020756'); 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-261106-0006','F326100840561','SIN','2','BELI','BELI001','H1E', 'X-00020756', 'KL TIFF RIBBON MATA VAR LG 42 8K','0.960','0.960','100.00','1002000','755000','786458','1045000','1','755000','755000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.960',berat_beli_asli=berat_beli_asli+'0.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.960',berat_akhir_asli=berat_akhir_asli+'0.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261106-0006','2026-11-06','2026-11-06','13:16:40','SIN','---','0.960','755000','755000','755000','755000','755000','kasir','2026-11-06 13:16:41','FB-261106-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261106-0006','ELIN','PURWANTORO','','','','kasir','2026-11-06 13:16:41'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261106-0013','K','2026-11-06','13:16:40','kasir','PEMBELIAN UMUM','FB-261106-0006','8098892000','755000','8098137000'); 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 ('F326060141491','kasir','1',' MEB1E X LG','TOKO','PM-B','B1E-ZAXE-29-0','GW X MODEL MATA LG PE 8K ','','0.590','1','100.00','611000','0','0','15000','610000','0','0','0','610000','LIS','00383950','B1E','0','0','-','1','1045000'); UPDATE tm_barang SET tgl_last_jual='2026-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZAXE-29-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.590',berat_jual_asli=berat_jual_asli+'0.590',stock_jual='1',berat_akhir=berat_akhir-'0.590',berat_akhir_asli=berat_akhir_asli-'0.590',stock_akhir='0' WHERE tanggal='2026-11-06' AND kode_barang='B1E-ZAXE-29-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326060141491','2026-11-06','0.590','2026-11-06','13:41:49','PLG0032222','610000','610000','0','610000','610000','kasir','2026-11-06 13:41:49','F32606014149'); 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-11-06','F326060141491','2026-11-06','13:41:49','LIS','610000','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-261106-0014','D','2026-11-06','13:41:49','kasir','PENJUALAN','F326060141491','8098137000','610000','8098747000'); 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-00020757','X-00020757','CC X PIPA SLEP HT 14 8K','GR','---','E1E','BELI','BELI001','487000','2026-11-06','0.530','1','kasir','2026-11-06 14:20:43'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020757','X-00020757'); 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-261106-0007','F326200146481','SIN','1','BELI','BELI001','E1E', 'X-00020757', 'CC X PIPA SLEP HT 14 8K','0.530','0.530','100.00','580000','487000','918868','1045000','1','487000','487000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261106-0007','2026-11-06','2026-11-06','14:20:42','SIN','---','0.530','487000','487000','487000','487000','487000','kasir','2026-11-06 14:20:43','FB-261106-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261106-0007','BINTANG','PLOSOREJO KISMANTORO','','','082226243702','kasir','2026-11-06 14:20:43'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261106-0015','K','2026-11-06','14:20:42','kasir','PEMBELIAN UMUM','FB-261106-0007','8098747000','487000','8098260000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060141491' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060141491' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060141491'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326060837201' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326060837201' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326060837201'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061012271' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061012271' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061012271'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061012272' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061012272' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061012272'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061053401' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061053401' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061053401'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061150231' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061150231' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061150231'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326061150232' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326061150232' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326061150232'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261106-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261106-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261106-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261106-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261106-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261106-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261106-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261106-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261106-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261106-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261106-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261106-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261106-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261106-0007'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-07','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-07'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-06'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-06'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-11-06' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-06'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-06'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-06'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-06'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-07' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-06' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261107-0001','D','2026-11-07','15:08:24','SYSTEM','SALDO AWAL','SALDO AWAL','0','8098260000','8098260000'); 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-261107-0001','D','2026-11-07','15:08:24','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-261107-0001','D','2026-11-07','15:08:24','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-261107-0001','D','2026-11-07','15:08:24','BCA','SALDO AWAL','SALDO AWAL','0','748085000','748085000'); UPDATE tp_system SET tgl_system='2026-11-07';