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-20261016-0001','1','A1D-ZJAE-18-0','1','1.010','1.010','TOKO','PMBK-A','TOKO','PM-A'); DELETE FROM tm_barang WHERE kode_barang='A1D-ZJAE-18-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZJAE-18-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-16 08:05:00' WHERE kode_barang='A1D-ZJAE-18-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZJAE-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-10-16 08:05:00','TOKO','PM-A','A1D','A1D-ZJAE-18-0','1','1.010','1.010','1','1.010','1.010','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-ZJAE-18-0'; DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZJAE-18-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261016-0001','2026-10-16','08:04','1.010','admpindah','2026-10-16 08:05:00'); 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-20261016-0001','1','B1D-ZJAE-22-0','1','1.080','1.080','TOKO','PMBK-B','TOKO','PM-B'); DELETE FROM tm_barang WHERE kode_barang='B1D-ZJAE-22-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZJAE-22-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-16 08:05:27' WHERE kode_barang='B1D-ZJAE-22-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZJAE-22-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:05:27','TOKO','PM-B','B1D','B1D-ZJAE-22-0','1','1.080','1.080','1','1.080','1.080','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-ZJAE-22-0'; DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZJAE-22-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-20261016-0001','1','B1E-ZJAE-28-0','1','0.500','0.500','TOKO','PMBK-B','TOKO','PM-B'); DELETE FROM tm_barang WHERE kode_barang='B1E-ZJAE-28-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZJAE-28-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-16 08:05:27' WHERE kode_barang='B1E-ZJAE-28-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZJAE-28-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:05:27','TOKO','PM-B','B1E','B1E-ZJAE-28-0','1','0.500','0.500','1','0.500','0.500','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-ZJAE-28-0'; DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZJAE-28-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261016-0001','2026-10-16','08:05','1.580','admpindah','2026-10-16 08:05:26'); 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-20261016-0001','1','D1E-ZJAE-52-0','1','0.510','0.510','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D1E-ZJAE-52-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZJAE-52-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-16 08:05:42' WHERE kode_barang='D1E-ZJAE-52-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZJAE-52-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:05:42','TOKO','PM-D','D1E','D1E-ZJAE-52-0','1','0.510','0.510','1','0.510','0.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZJAE-52-0'; DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZJAE-52-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-20261016-0001','1','D1E-ZJAE-53-0','1','0.480','0.480','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D1E-ZJAE-53-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZJAE-53-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-16 08:05:42' WHERE kode_barang='D1E-ZJAE-53-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZJAE-53-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:05:42','TOKO','PM-D','D1E','D1E-ZJAE-53-0','1','0.480','0.480','1','0.480','0.480','100.00'); DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZJAE-53-0'; DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZJAE-53-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261016-0001','2026-10-16','08:05','0.990','admpindah','2026-10-16 08:05:42'); 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-20261016-0001','1','E1E-ZJXF-312-0','1','0.480','0.480','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZJXF-312-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJXF-312-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-16 08:05:57' WHERE kode_barang='E1E-ZJXF-312-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJXF-312-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:05:57','TOKO','PM-E','E1E','E1E-ZJXF-312-0','1','0.480','0.480','1','0.480','0.480','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-ZJXF-312-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJXF-312-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-20261016-0001','1','E2D-ZJXH-475-0','1','2.260','2.260','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E2D-ZJXH-475-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-475-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-16 08:05:57' WHERE kode_barang='E2D-ZJXH-475-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJXH-475-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:05:57','TOKO','PM-E','E2D','E2D-ZJXH-475-0','1','2.260','2.260','1','2.260','2.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-ZJXH-475-0'; DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-475-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-20261016-0001','1','E1D-ZJAE-135-0','1','1.510','1.510','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1D-ZJAE-135-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZJAE-135-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-16 08:05:57' WHERE kode_barang='E1D-ZJAE-135-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZJAE-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-10-16 08:05:57','TOKO','PM-E','E1D','E1D-ZJAE-135-0','1','1.510','1.510','1','1.510','1.510','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-ZJAE-135-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZJAE-135-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261016-0001','2026-10-16','08:05','4.250','admpindah','2026-10-16 08:05:56'); 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-20261016-0001','1','F1E-ZJAE-86-0','1','2.350','2.350','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZJAE-86-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJAE-86-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F1E-ZJAE-86-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJAE-86-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:06:14','TOKO','PM-F','F1E','F1E-ZJAE-86-0','1','2.350','2.350','1','2.350','2.350','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-ZJAE-86-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJAE-86-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-20261016-0001','1','F1E-ZJAE-87-0','1','3.130','3.130','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZJAE-87-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJAE-87-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F1E-ZJAE-87-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJAE-87-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:06:14','TOKO','PM-F','F1E','F1E-ZJAE-87-0','1','3.130','3.130','1','3.130','3.130','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-ZJAE-87-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJAE-87-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-20261016-0001','1','F1E-ZJAE-88-0','1','2.130','2.130','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZJAE-88-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJAE-88-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F1E-ZJAE-88-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJAE-88-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:06:14','TOKO','PM-F','F1E','F1E-ZJAE-88-0','1','2.130','2.130','1','2.130','2.130','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-ZJAE-88-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJAE-88-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261016-0001','1','F3E-ZJAE-212-0','1','5.050','5.050','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAE-212-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-212-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F3E-ZJAE-212-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAE-212-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:06:14','TOKO','PM-F','F3E','F3E-ZJAE-212-0','1','5.050','5.050','1','5.050','5.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-ZJAE-212-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-212-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-20261016-0001','1','F3E-ZJAE-215-0','1','5.020','5.020','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAE-215-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-215-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F3E-ZJAE-215-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAE-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-10-16 08:06:14','TOKO','PM-F','F3E','F3E-ZJAE-215-0','1','5.020','5.020','1','5.020','5.020','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-ZJAE-215-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-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-20261016-0001','1','F3E-ZJAE-219-0','1','1.650','1.650','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAE-219-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-219-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F3E-ZJAE-219-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAE-219-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:06:14','TOKO','PM-F','F3E','F3E-ZJAE-219-0','1','1.650','1.650','1','1.650','1.650','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJAE-219-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-219-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-20261016-0001','1','F3E-ZJAE-221-0','1','1.510','1.510','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAE-221-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-221-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F3E-ZJAE-221-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAE-221-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:06:14','TOKO','PM-F','F3E','F3E-ZJAE-221-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-ZJAE-221-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-221-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-20261016-0001','1','F3E-ZJAE-223-0','1','1.380','1.380','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAE-223-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-223-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F3E-ZJAE-223-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAE-223-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:06:14','TOKO','PM-F','F3E','F3E-ZJAE-223-0','1','1.380','1.380','1','1.380','1.380','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-ZJAE-223-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-223-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-20261016-0001','1','F3E-ZJAE-226-0','1','1.280','1.280','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAE-226-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-226-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F3E-ZJAE-226-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAE-226-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:06:14','TOKO','PM-F','F3E','F3E-ZJAE-226-0','1','1.280','1.280','1','1.280','1.280','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-ZJAE-226-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-226-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-20261016-0001','1','F3E-ZJAE-228-0','1','1.500','1.500','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAE-228-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-228-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F3E-ZJAE-228-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAE-228-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:06:14','TOKO','PM-F','F3E','F3E-ZJAE-228-0','1','1.500','1.500','1','1.500','1.500','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-ZJAE-228-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-228-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-20261016-0001','1','F3E-ZJAE-233-0','1','0.700','0.700','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAE-233-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-233-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F3E-ZJAE-233-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAE-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-10-16 08:06:14','TOKO','PM-F','F3E','F3E-ZJAE-233-0','1','0.700','0.700','1','0.700','0.700','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJAE-233-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-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-20261016-0001','1','F3E-ZJAE-237-0','1','2.100','2.100','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJAE-237-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-237-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F3E-ZJAE-237-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJAE-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-10-16 08:06:14','TOKO','PM-F','F3E','F3E-ZJAE-237-0','1','2.100','2.100','1','2.100','2.100','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-ZJAE-237-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJAE-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-20261016-0001','1','F4I-ZJAE-240-0','1','2.080','2.080','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F4I-ZJAE-240-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F4I-ZJAE-240-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-16 08:06:14' WHERE kode_barang='F4I-ZJAE-240-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F4I-ZJAE-240-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:06:14','TOKO','PM-F','F4I','F4I-ZJAE-240-0','1','2.080','2.080','1','2.080','2.080','100.00'); DELETE FROM tm_dept WHERE kode_dept='F4I' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F4I' LIMIT 1; DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F4I-ZJAE-240-0'; DELETE FROM tm_barang_export WHERE kode_barang='F4I-ZJAE-240-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261016-0001','2026-10-16','08:06','29.880','admpindah','2026-10-16 08:06:13'); 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-20261016-0001','1','PFF-ZJAE-1-0','1','4.270','4.270','TOKO','PMBK-P','TOKO','PM-P'); DELETE FROM tm_barang WHERE kode_barang='PFF-ZJAE-1-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PFF-ZJAE-1-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-P',tgl_last_beli='2026-10-16 08:06:35' WHERE kode_barang='PFF-ZJAE-1-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='PFF-ZJAE-1-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-16 08:06:35','TOKO','PM-P','PFF','PFF-ZJAE-1-0','1','4.270','4.270','1','4.270','4.270','100.00'); DELETE FROM tm_dept WHERE kode_dept='PFF' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PFF' 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='PFF-ZJAE-1-0'; DELETE FROM tm_barang_export WHERE kode_barang='PFF-ZJAE-1-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261016-0001','2026-10-16','08:06','4.270','admpindah','2026-10-16 08:06:34'); 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 ('F326160834311','input','1',' TEA1 X DG ','TOKO','PT-A','A1TE-ZGBI-36-T','AT X DAKOCAN SLEP DG 17K ','','0.500','1','100.00','965000','0','0','15000','965000','0','0','0','965000','LIS','T0081695','A1TE','0','0','-','0','1940000'); UPDATE tm_barang SET tgl_last_jual='2026-10-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-ZGBI-36-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-10-16' AND kode_barang='A1TE-ZGBI-36-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326160834311','2026-10-16','0.500','2026-10-16','08:34:32','PLG0031911','965000','965000','0','965000','965000','input','2026-10-16 08:34:31','F32616083431'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-16','F326160834311','2026-10-16','08:34:32','LIS','965000','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-261016-0002','D','2026-10-16','08:34:32','input','PENJUALAN','F326160834311','7899135000','965000','7900100000'); 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 ('F326160857461','input','1',' MEE2 CM 14','TOKO','PM-E','E2E-ZIXC-30-0','CC MODEL MATA VAR CM 14 8K ','','0.670','1','100.00','699000','0','0','15000','700000','0','0','0','700000','AAT','00421920','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZIXC-30-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-10-16' AND kode_barang='E2E-ZIXC-30-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 ('F326160857461','2026-10-16','0.670','2026-10-16','08:57:47','PLG0031912','700000','700000','0','700000','700000','input','2026-10-16 08:57:46','F32616085746'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-16','F326160857461','2026-10-16','08:57:47','AAT','700000','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-261016-0003','D','2026-10-16','08:57:47','input','PENJUALAN','F326160857461','7900100000','700000','7900800000'); 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 ('F326160858151','input','1',' MFB1F X LG','TOKO','PM-B','B1F-ZFCX-147-0','GW X MODEL MATA LG 8K ','','0.370','1','100.00','393000','0','0','15000','395000','0','0','0','395000','AAT','00411354','B1F','0','0','-','0','1073000'); UPDATE tm_barang SET tgl_last_jual='2026-10-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZFCX-147-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-10-16' AND kode_barang='B1F-ZFCX-147-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 ('F326160858151','2026-10-16','0.370','2026-10-16','08:58:15','PLG0031913','395000','395000','0','395000','395000','input','2026-10-16 08:58:15','F32616085815'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-16','F326160858151','2026-10-16','08:58:15','AAT','395000','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-261016-0004','D','2026-10-16','08:58:15','input','PENJUALAN','F326160858151','7900800000','395000','7901195000'); 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 ('F326161103581','input','1',' MFE1 KH 12','TOKO','PM-E','E1F-ZJXE-403-0','CC MODEL DAUN SLEP KH 12 8K ','','0.380','1','100.00','404000','0','0','15000','405000','0','0','0','405000','AAT','00427894','E1F','0','0','-','0','1073000'); UPDATE tm_barang SET tgl_last_jual='2026-10-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-403-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-10-16' AND kode_barang='E1F-ZJXE-403-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 ('F326161103581','2026-10-16','0.380','2026-10-16','11:03:59','PLG0031914','405000','405000','0','405000','405000','input','2026-10-16 11:03:58','F32616110358'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-16','F326161103581','2026-10-16','11:03:59','AAT','405000','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-261016-0005','D','2026-10-16','11:03:59','input','PENJUALAN','F326161103581','7901195000','405000','7901600000'); 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 ('F326161128111','input','1',' MFPFF X LT','TOKO','PM-P','PFF-ZHBE-2-0','GL X WG RANTAI HATI SLEP LT 8K','','1.010','1','100.00','1074000','0','0','15000','1075000','0','0','0','1075000','SIN','00420044','PFF','0','0','-','0','1073000'); UPDATE tm_barang SET tgl_last_jual='2026-10-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PFF-ZHBE-2-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-10-16' AND kode_barang='PFF-ZHBE-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' 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 ('F326161128111','2026-10-16','1.010','2026-10-16','11:28:12','PLG0031915','1075000','1075000','0','1075000','1075000','input','2026-10-16 11:28:11','F32616112811'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-16','F326161128111','2026-10-16','11:28:12','SIN','1075000','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-261016-0006','D','2026-10-16','11:28:12','input','PENJUALAN','F326161128111','7901600000','1075000','7902675000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1075000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161128111' 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 ('F326161128112','input',' 1',' MEE1E LG 1','TOKO','PM-E','E1E-ZFXE-200-0','CC MODEL ISYANA SLEP LG 14 8K ','','0.460','1','100.00','480000','0','0','15000','480000','0','0','0','480000','SIN','00407452','E1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXE-200-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-10-16' AND kode_barang='E1E-ZFXE-200-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 ('F326161128112','2026-10-16','0.460','2026-10-16','11:28:12','PLG0031916','480000','480000','0','480000','480000','input','2026-10-16 11:28:11','F32616112811'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-16','F326161128112','2026-10-16','11:28:12','SIN','480000','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-261016-0007','D','2026-10-16','11:28:12','input','PENJUALAN','F326161128112','7902675000','480000','7903155000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='480000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161128112' 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 ('F326161128113','input',' 1',' MGPD LG D ','TOKO','PM-P','PDG-XDXG-97-0','LT WG MODEL HURUF MATA LG D 8K ','','0.480','1','100.00','520000','0','0','15000','520000','0','0','0','520000','SIN','00291047','PDG','0','0','-','0','1083000'); UPDATE tm_barang SET tgl_last_jual='2026-10-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PDG-XDXG-97-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-10-16' AND kode_barang='PDG-XDXG-97-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' 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 ('F326161128113','2026-10-16','0.480','2026-10-16','11:28:12','PLG0031917','520000','520000','0','520000','520000','input','2026-10-16 11:28:11','F32616112811'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-16','F326161128113','2026-10-16','11:28:12','SIN','520000','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-261016-0008','D','2026-10-16','11:28:12','input','PENJUALAN','F326161128113','7903155000','520000','7903675000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='520000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161128113' 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-00020538','X-00020538','CC MODEL SNAKE MATA SLEP KH 14 8K','GR','---','E2E','BELI','BELI001','470000','2026-10-16','0.490','1','kasir','2026-10-16 11:49:52'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020538','X-00020538'); 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-261016-0001','F326270903401','SIN','1','BELI','BELI001','E2E', 'X-00020538', 'CC MODEL SNAKE MATA SLEP KH 14 8K','0.490','0.490','100.00','513000','470000','959184','1053000','1','470000','470000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.490',berat_beli_asli=berat_beli_asli+'0.490',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.490',berat_akhir_asli=berat_akhir_asli+'0.490',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-16' 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-261016-0001','2026-10-16','2026-10-16','11:49:52','SIN','---','0.490','470000','470000','470000','470000','470000','kasir','2026-10-16 11:49:52','FB-261016-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261016-0001','TITIK','BULUKERTO','','','','kasir','2026-10-16 11:49:52'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-16' 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-261016-0009','K','2026-10-16','11:49:52','kasir','PEMBELIAN UMUM','FB-261016-0001','7903675000','470000','7903205000'); 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-00020539','X-00020539','CC MODEL DAUN SLEP KH 10 8K','GR','---','E1F','BELI','BELI001','390000','2026-10-16','0.400','1','kasir','2026-10-16 11:49:52'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00020539','X-00020539'); 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-261016-0002','F326300938361','SIN','2','BELI','BELI001','E1F', 'X-00020539', 'CC MODEL DAUN SLEP KH 10 8K','0.400','0.400','100.00','425000','390000','975000','1073000','1','390000','390000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.400',berat_beli_asli=berat_beli_asli+'0.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.400',berat_akhir_asli=berat_akhir_asli+'0.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-261016-0002','2026-10-16','2026-10-16','11:49:52','SIN','---','0.400','390000','390000','390000','390000','390000','kasir','2026-10-16 11:49:52','FB-261016-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261016-0002','TITIK','BULUKERTO','','','','kasir','2026-10-16 11:49:52'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-16' 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-261016-0010','K','2026-10-16','11:49:52','kasir','PEMBELIAN UMUM','FB-261016-0002','7903205000','390000','7902815000'); 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-00020540','X-00020540','CC X MODEL SLEP UB 18 8K','GR','---','E1E','BELI','BELI001','612000','2026-10-16','0.630','1','kasir','2026-10-16 11:51:00'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020540','X-00020540'); 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-261016-0003','F326101054021','LIS','1','BELI','BELI001','E1E', 'X-00020540', 'CC X MODEL SLEP UB 18 8K','0.630','0.630','100.00','660000','612000','971429','1053000','1','612000','612000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.630',berat_beli_asli=berat_beli_asli+'0.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.630',berat_akhir_asli=berat_akhir_asli+'0.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-16' 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-261016-0003','2026-10-16','2026-10-16','11:50:59','LIS','---','0.630','612000','612000','612000','612000','612000','kasir','2026-10-16 11:51:00','FB-261016-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261016-0003','CITRA','SIDODADI JERUK PCT','','','081252043103','kasir','2026-10-16 11:51:00'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-16' 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-261016-0011','K','2026-10-16','11:50:59','kasir','PEMBELIAN UMUM','FB-261016-0003','7902815000','612000','7902203000'); 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-00020541','X-00020541','GL X OVAL C UB 52 8K','GR','---','F1E','BELI','BELI001','2020000','2026-10-16','2.180','1','kasir','2026-10-16 11:52:49'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020541','X-00020541'); 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-261016-0004','F326190137271','SIN','1','BELI','BELI001','F1E', 'X-00020541', 'GL X OVAL C UB 52 8K','2.180','2.180','100.00','2573000','2020000','926606','1053000','1','2020000','2020000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.180',berat_beli_asli=berat_beli_asli+'2.180',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.180',berat_akhir_asli=berat_akhir_asli+'2.180',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-16' 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-261016-0004','2026-10-16','2026-10-16','11:52:49','SIN','---','2.180','2020000','2020000','2020000','2020000','2020000','kasir','2026-10-16 11:52:49','FB-261016-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261016-0004','TIARA','BANGSRI','','','','kasir','2026-10-16 11:52:49'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-16' 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-261016-0012','K','2026-10-16','11:52:49','kasir','PEMBELIAN UMUM','FB-261016-0004','7902203000','2020000','7900183000'); 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-00020542','X-00020542','GL ANAK BANGKOK MODEL C TD D42 8K','GR','---','F1E','BELI','BELI001','1425000','2026-10-16','2.010','1','kasir','2026-10-16 11:54:54'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020542','X-00020542'); 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-261016-0005','F325071107271','LIS','1','BELI','BELI001','F1E', 'X-00020542', 'GL ANAK BANGKOK MODEL C TD D42 8K','2.010','2.010','100.00','1595000','1425000','708955','1053000','1','1425000','1425000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.010',berat_beli_asli=berat_beli_asli+'2.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.010',berat_akhir_asli=berat_akhir_asli+'2.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-16' 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-261016-0005','2026-10-16','2026-10-16','11:54:54','LIS','---','2.010','1425000','1425000','1425000','1425000','1425000','kasir','2026-10-16 11:54:54','FB-261016-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261016-0005','ARIK','PUCUNG KISMANTORO','','','','kasir','2026-10-16 11:54:54'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-16' 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-261016-0013','K','2026-10-16','11:54:54','kasir','PEMBELIAN UMUM','FB-261016-0005','7900183000','1425000','7898758000'); 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-00020543','X-00020543','GL BANGKOK C LINE SLEP TD 58 8K','GR','---','F1E','BELI','BELI001','4842000','2026-10-16','5.000','1','kasir','2026-10-16 12:47:35'); DELETE FROM tp_barang WHERE kode_dept = 'X-F1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020543','X-00020543'); 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-261016-0006','F326250224181','SIN','1','BELI','BELI001','F1E', 'X-00020543', 'GL BANGKOK C LINE SLEP TD 58 8K','5.000','5.000','100.00','5550000','4842000','968400','1053000','1','4842000','4842000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.000',berat_beli_asli=berat_beli_asli+'5.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.000',berat_akhir_asli=berat_akhir_asli+'5.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-16' 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-261016-0006','2026-10-16','2026-10-16','12:47:34','SIN','---','5.000','4842000','4842000','4842000','4842000','4842000','kasir','2026-10-16 12:47:35','FB-261016-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261016-0006','ESTER','BULUKERTO','','','082221367933','kasir','2026-10-16 12:47:35'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-16' 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-261016-0014','K','2026-10-16','12:47:34','kasir','PEMBELIAN UMUM','FB-261016-0006','7898758000','4842000','7893916000'); 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 ('F326160123001','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-ZJAE-221-0','GL X CASTELI SPECTRA VAR SLEP HW 8K ','','1.510','1','100.00','1590000','0','0','15000','1575000','0','0','0','1575000','AAT','00430104','F3E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJAE-221-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-10-16' AND kode_barang='F3E-ZJAE-221-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 ('F326160123001','2026-10-16','1.510','2026-10-16','13:23:01','PLG0031918','1575000','1575000','0','1575000','1575000','kasir','2026-10-16 13:23:00','F32616012300'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-16','F326160123001','2026-10-16','13:23:01','AAT','1575000','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-261016-0015','D','2026-10-16','13:23:01','kasir','PENJUALAN','F326160123001','7893916000','1575000','7895491000'); 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-00020544','X-00020544','KL POLOS 9K','GR','---','H2J','BELI','BELI001','1357000','2026-10-16','1.280','1','kasir','2026-10-16 13:48:44'); DELETE FROM tp_barang WHERE kode_dept = 'X-H2J'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00020544','X-00020544'); 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-261016-0007','t0077613','AAT','1','BELI','BELI001','H2J', 'X-00020544', 'KL POLOS 9K','1.280','1.280','100.00','1658000','1357000','1060156','1143000','1','1357000','1357000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.280',berat_beli_asli=berat_beli_asli+'1.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.280',berat_akhir_asli=berat_akhir_asli+'1.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' 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-261016-0007','2026-10-16','2026-10-16','13:48:43','AAT','---','1.280','1357000','1357000','1357000','1357000','1357000','kasir','2026-10-16 13:48:44','FB-261016-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261016-0007','BUDI','TUMPUK BANDAR','','','','kasir','2026-10-16 13:48:44'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-16' 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-261016-0016','K','2026-10-16','13:48:43','kasir','PEMBELIAN UMUM','FB-261016-0007','7895491000','1357000','7894134000'); 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-00020545','X-00020545','CC COR M 8K','GR','---','E2D','BELI','BELI001','1016000','2026-10-16','1.070','1','kasir','2026-10-16 13:55:11'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020545','X-00020545'); 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-261016-0008','00391497','AAT','1','BELI','BELI001','E2D', 'X-00020545', 'CC COR M 8K','1.070','1.070','100.00','1257000','1016000','949533','1033000','1','1016000','1016000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.070',berat_beli_asli=berat_beli_asli+'1.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.070',berat_akhir_asli=berat_akhir_asli+'1.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261016-0008','2026-10-16','2026-10-16','13:55:10','AAT','---','1.070','1016000','1016000','1016000','1016000','1016000','kasir','2026-10-16 13:55:11','FB-261016-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261016-0008','BUDI','TUMPUK BANDAR','','','','kasir','2026-10-16 13:55:11'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-16' 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-261016-0017','K','2026-10-16','13:55:10','kasir','PEMBELIAN UMUM','FB-261016-0008','7894134000','1016000','7893118000'); 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-00020546','X-00020546','GW COR 8K','GR','---','B1D','BELI','BELI001','997000','2026-10-16','1.050','1','kasir','2026-10-16 13:55:11'); DELETE FROM tp_barang WHERE kode_dept = 'X-B1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1D','X-00020546','X-00020546'); 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-261016-0009','00394163','AAT','2','BELI','BELI001','B1D', 'X-00020546', 'GW COR 8K','1.050','1.050','100.00','1235000','997000','949524','1033000','1','997000','997000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-16' 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-261016-0009','2026-10-16','2026-10-16','13:55:10','AAT','---','1.050','997000','997000','997000','997000','997000','kasir','2026-10-16 13:55:11','FB-261016-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261016-0009','BUDI','TUMPUK BANDAR','','','','kasir','2026-10-16 13:55:11'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-16' 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-261016-0018','K','2026-10-16','13:55:10','kasir','PEMBELIAN UMUM','FB-261016-0009','7893118000','997000','7892121000'); 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-00020547','X-00020547','LT COR M 8K','GR','---','D2D','BELI','BELI001','970000','2026-10-16','1.020','1','kasir','2026-10-16 13:55:11'); DELETE FROM tp_barang WHERE kode_dept = 'X-D2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2D','X-00020547','X-00020547'); 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-261016-0010','t0073646','AAT','3','BELI','BELI001','D2D', 'X-00020547', 'LT COR M 8K','1.020','1.020','100.00','1200000','970000','950980','1033000','1','970000','970000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2D' 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-261016-0010','2026-10-16','2026-10-16','13:55:10','AAT','---','1.020','970000','970000','970000','970000','970000','kasir','2026-10-16 13:55:11','FB-261016-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261016-0010','BUDI','TUMPUK BANDAR','','','','kasir','2026-10-16 13:55:11'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-16' 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-261016-0019','K','2026-10-16','13:55:10','kasir','PEMBELIAN UMUM','FB-261016-0010','7892121000','970000','7891151000'); 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-00020548','X-00020548','AT X MODEL MATA VAR LG 8K','GR','---','A1E','BELI','BELI001','460000','2026-10-16','0.470','1','kasir','2026-10-16 14:02:17'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020548','X-00020548'); 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-261016-0011','F326051006241','AAT','1','BELI','BELI001','A1E', 'X-00020548', 'AT X MODEL MATA VAR LG 8K','0.470','0.470','100.00','545000','460000','978723','1053000','1','460000','460000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-16' 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-261016-0011','2026-10-16','2026-10-16','14:02:17','AAT','---','0.470','460000','460000','460000','460000','460000','kasir','2026-10-16 14:02:17','FB-261016-0011'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261016-0011','AINI','BITING PWO','','','','kasir','2026-10-16 14:02:17'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-16' 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-261016-0020','K','2026-10-16','14:02:17','kasir','PEMBELIAN UMUM','FB-261016-0011','7891151000','460000','7890691000'); 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 ('F326160256021','kasir','1',' MFE1 KH 12','TOKO','PM-E','E1F-ZJXE-395-0','CC MODEL SPECTRA SLEP KH 12 8K ','','0.330','1','100.00','351000','0','0','15000','350000','0','0','0','350000','SIN','00427886','E1F','0','0','-','1','1073000'); UPDATE tm_barang SET tgl_last_jual='2026-10-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-395-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-10-16' AND kode_barang='E1F-ZJXE-395-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 ('F326160256021','2026-10-16','0.330','2026-10-16','14:56:02','PLG0031919','350000','350000','0','350000','350000','kasir','2026-10-16 14:56:02','F32616025602'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-16','F326160256021','2026-10-16','14:56:02','SIN','350000','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-261016-0021','D','2026-10-16','14:56:02','kasir','PENJUALAN','F326160256021','7890691000','350000','7891041000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='350000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160256021' 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 ('F326160256022','kasir',' 1',' MEE2 X YT ','TOKO','PM-E','E2E-YHAD-148-0','CC X MODEL MATA YT 14 8K','','0.610','1','100.00','636000','0','0','15000','635000','0','0','0','635000','SIN','00365762','E2E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YHAD-148-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-10-16' AND kode_barang='E2E-YHAD-148-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 ('F326160256022','2026-10-16','0.610','2026-10-16','14:56:02','PLG0031920','635000','635000','0','635000','635000','kasir','2026-10-16 14:56:02','F32616025602'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-16','F326160256022','2026-10-16','14:56:02','SIN','635000','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-261016-0022','D','2026-10-16','14:56:02','kasir','PENJUALAN','F326160256022','7891041000','635000','7891676000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='635000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160256022' 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 ('F326160256471','kasir','1',' MFE1 KH 10','TOKO','PM-E','E1F-ZJXE-397-0','CC MODEL SPECTRA SLEP KH 10 8K ','','0.350','1','100.00','372000','0','0','15000','373000','0','0','0','373000','LIS','00427888','E1F','0','0','-','0','1073000'); UPDATE tm_barang SET tgl_last_jual='2026-10-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-397-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-10-16' AND kode_barang='E1F-ZJXE-397-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 ('F326160256471','2026-10-16','0.350','2026-10-16','14:56:47','PLG0031921','373000','373000','0','373000','373000','kasir','2026-10-16 14:56:47','F32616025647'); INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-16','F326160256471','2026-10-16','14:56:47','LIS','373000','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-261016-0023','D','2026-10-16','14:56:47','kasir','PENJUALAN','F326160256471','7891676000','373000','7892049000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261016-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261016-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261016-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261016-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261016-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261016-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261016-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261016-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261016-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261016-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261016-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261016-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261016-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261016-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261016-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261016-0008'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261016-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261016-0009'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261016-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261016-0010'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261016-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261016-0011'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160123001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160123001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160123001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160256021' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160256021' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160256021'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160256022' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160256022' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160256022'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160256471' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160256471' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160256471'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160834311' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160834311' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160834311'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160857461' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160857461' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160857461'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160858151' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160858151' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160858151'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161103581' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161103581' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161103581'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161128111' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161128111' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161128111'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161128112' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161128112' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161128112'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161128113' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161128113' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161128113'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-17','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-16'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-16'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-16'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-16' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-16'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-16'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-16'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-16'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-17' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-16' 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-261017-0001','D','2026-10-17','15:18:50','SYSTEM','SALDO AWAL','SALDO AWAL','0','7892049000','7892049000'); 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-261017-0001','D','2026-10-17','15:18:50','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-261017-0001','D','2026-10-17','15:18:50','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-261017-0001','D','2026-10-17','15:18:50','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000'); UPDATE tp_system SET tgl_system='2026-10-17';