INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-10-01 ','08:09:33');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-10-01 ','08:30:38');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-10-01 ','08:31:58');
DELETE FROM tm_berlian WHERE kode_barang='KLBE-XFAD-14-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XFAD-14-0','KLBE-XFAD-14-0','00029127','RD','6','0.180','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XFAD-14-0','00029127','RD','6','0.180','420','75.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XFAD-14-0','KLBE-XFAD-14-0','00029127','RD','24','0.065','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XFAD-14-0','00029127','RD','24','0.065','450','29.25')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-XFAD-14-0','00029127','00029127','KALUNG KLBE-00135','KALUNG KLBE-00135','','','7620000','7620000',' 0','0','spv','2025-10-01 08:34:25');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00135' ,nama_atribut='' ,kode_intern='KLBE-00135 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='0925',total_usd_ext='IDB 36 000 000',total_usd='104.85' WHERE kode_barang='KLBE-XFAD-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-XFAD-14-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XFAD-14-0','KLBE-XFAD-14-0','00029127','RD','24','0.065','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XFAD-14-0','00029127','RD','24','0.065','450','29.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XFAD-14-0','KLBE-XFAD-14-0','00029127','RD','6','0.180','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XFAD-14-0','00029127','RD','6','0.180','420','75.6')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-XFAD-14-0','00029127','00029127','KALUNG KLBE-00135','KALUNG KLBE-00135','','','7620000','7620000',' 0','0','spv','2025-10-01 08:38:52');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00135' ,nama_atribut='' ,kode_intern='KLBE-00135 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 36 000 000',total_usd='104.85' WHERE kode_barang='KLBE-XFAD-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YGCX-57-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGCX-57-0','KLBE-YGCX-57-0','00037796','RD','8','0.240','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGCX-57-0','00037796','RD','8','0.240','420','100.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGCX-57-0','KLBE-YGCX-57-0','00037796','RD','1','0.110','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGCX-57-0','00037796','RD','1','0.110','620','68.2')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YGCX-57-0','00037796','00037796','KALUNG KLBE-00558 ','KALUNG KLBE-00558','','','4349500','4349500',' 0','0','spv','2025-10-01 08:39:17');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00558' ,nama_atribut='' ,kode_intern='KLBE-00558 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L99 1025',total_usd_ext='IDB 29 500 000',total_usd='169' WHERE kode_barang='KLBE-YGCX-57-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YGBD-55-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGBD-55-0','KLBE-YGBD-55-0','00037517','RD','2','0.080','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGBD-55-0','00037517','RD','2','0.080','420','33.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGBD-55-0','KLBE-YGBD-55-0','00037517','RD','4','0.240','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGBD-55-0','00037517','RD','4','0.240','450','108')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGBD-55-0','KLBE-YGBD-55-0','00037517','RD','29','0.170','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGBD-55-0','00037517','RD','29','0.170','400','68')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YGBD-55-0','00037517','00037517','KALUNG KLBE-00854 ','KALUNG KLBE-00854','','','7281500','7281500',' 0','0','spv','2025-10-01 08:41:14');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00854' ,nama_atribut='' ,kode_intern='KLBE-00854 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDR 40 000 000',total_usd='209.6' WHERE kode_barang='KLBE-YGBD-55-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YIAX-15-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YIAX-15-0','KLBE-YIAX-15-0','00038681','RD','14','0.070','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YIAX-15-0','00038681','RD','14','0.070','320','22.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YIAX-15-0','KLBE-YIAX-15-0','00038681','RD','1','0.030','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YIAX-15-0','00038681','RD','1','0.030','320','9.6')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YIAX-15-0','00038681','00038681','KALUNG KLBE-00022 ','KALUNG KLBE-00022','','','3668500','3668500',' 0','0','spv','2025-10-01 08:43:03');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00022' ,nama_atribut='' ,kode_intern='KLBE-00022 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 16 000 000',total_usd='32' WHERE kode_barang='KLBE-YIAX-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-XJXC-14-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XJXC-14-0','KLBE-XJXC-14-0','00031605','RD','40','0.170','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XJXC-14-0','00031605','RD','40','0.170','400','68')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XJXC-14-0','KLBE-XJXC-14-0','00031605','RD','18','0.360','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XJXC-14-0','00031605','RD','18','0.360','400','144')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XJXC-14-0','KLBE-XJXC-14-0','00031605','RD','7','0.280','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XJXC-14-0','00031605','RD','7','0.280','400','112')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XJXC-14-0','KLBE-XJXC-14-0','00031605','RD','1','0.045','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XJXC-14-0','00031605','RD','1','0.045','450','20.25')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-XJXC-14-0','00031605','00031605','KALUNG KLBE-00837','KALUNG KLBE-00837','','','7683500','7683500',' 0','0','spv','2025-10-01 08:45:31');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00837' ,nama_atribut='' ,kode_intern='KLBE-00837 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDR 50 000 000',total_usd='344.25' WHERE kode_barang='KLBE-XJXC-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-WCCA-48-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-WCCA-48-0','KLBE-WCCA-48-0','00021167','RD','18','0.257','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-WCCA-48-0','00021167','RD','18','0.257','420','107.94')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-WCCA-48-0','00021167','00021167','KALUNG BERLIAN','KALUNG BERLIAN','','','12472000','12472000',' 0','0','spv','2025-10-01 08:47:55');
UPDATE tm_barang SET nama_barang='KALUNG BERLIAN' ,nama_atribut='' ,kode_intern='KLBE-00420 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='HK 1025',total_usd_ext='IDB 52 000 000',total_usd='107.94' WHERE kode_barang='KLBE-WCCA-48-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YEXI-16-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YEXI-16-0','KLBE-YEXI-16-0','00035521','RD','13','0.620','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YEXI-16-0','00035521','RD','13','0.620','480','297.6')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YEXI-16-0','00035521','00035521','KALUNG KLBE-00357 ','KALUNG KLBE-00357','','','9461500','9461500',' 0','0','spv','2025-10-01 08:52:33');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00357' ,nama_atribut='' ,kode_intern='KLBE-00357 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 53 000 000',total_usd='297.6' WHERE kode_barang='KLBE-YEXI-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YDBI-37-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDBI-37-0','KLBE-YDBI-37-0','00035330','RD','15','0.750','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDBI-37-0','00035330','RD','15','0.750','480','360')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YDBI-37-0','00035330','00035330','KALUNG KLBE-00850 ','KALUNG KLBE-00850','','','9461500','9461500',' 0','0','spv','2025-10-01 08:54:08');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00850' ,nama_atribut='' ,kode_intern='KLBE-00850 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 55 000 000',total_usd='360' WHERE kode_barang='KLBE-YDBI-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YBXD-16-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YBXD-16-0','KLBE-YBXD-16-0','00033895','RD','1','0.100','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YBXD-16-0','00033895','RD','1','0.100','620','62')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YBXD-16-0','KLBE-YBXD-16-0','00033895','RD','2','0.060','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YBXD-16-0','00033895','RD','2','0.060','420','25.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YBXD-16-0','KLBE-YBXD-16-0','00033895','RD','10','0.210','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YBXD-16-0','00033895','RD','10','0.210','420','88.2')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YBXD-16-0','00033895','00033895','KALUNG KLBE-00202','KALUNG KLBE-00202','','','8170500','8170500',' 0','0','spv','2025-10-01 08:56:09');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00202' ,nama_atribut='' ,kode_intern='KLBE-00202 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 41 000 000',total_usd='175.4' WHERE kode_barang='KLBE-YBXD-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-WJBC-7-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-WJBC-7-0','KLBE-WJBC-7-0','00024580','RD','23','0.720','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-WJBC-7-0','00024580','RD','23','0.720','420','302.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-WJBC-7-0','KLBE-WJBC-7-0','00024580','RD','1','0.055','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-WJBC-7-0','00024580','RD','1','0.055','480','26.4')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-WJBC-7-0','00024580','00024580','KALUNG KLBE-00538','KALUNG KLBE-00538','','','13441000','13441000',' 0','0','spv','2025-10-01 08:58:04');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00538' ,nama_atribut='' ,kode_intern='KLBE-00538 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 66 500 000',total_usd='328.8' WHERE kode_barang='KLBE-WJBC-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YIXH-14-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YIXH-14-0','KLBE-YIXH-14-0','00038608','RD','1','0.160','1500');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YIXH-14-0','00038608','RD','1','0.160','1500','240')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YIXH-14-0','00038608','00038608','KLBE-00514 GIA 5416868076 ','KLBE-00514 GIA 5416868076','','','3391000','3391000',' 0','0','spv','2025-10-01 08:59:52');
UPDATE tm_barang SET nama_barang='KLBE-00514 GIA 5416868076' ,nama_atribut='' ,kode_intern='KLBE-00514 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='EVVS1 1025',total_usd_ext='GIE 27 500 000',total_usd='240' WHERE kode_barang='KLBE-YIXH-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-WKAE-7-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-WKAE-7-0','KLBE-WKAE-7-0','00024886','RD','10','0.080','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-WKAE-7-0','00024886','RD','10','0.080','450','36')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-WKAE-7-0','00024886','00024886','KALUNG KLBE-00811','KALUNG KLBE-00811','','','4656500','4656500',' 0','0','spv','2025-10-01 09:01:22');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00811' ,nama_atribut='' ,kode_intern='KLBE-00811 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 21 000 000',total_usd='36' WHERE kode_barang='KLBE-WKAE-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YBBF-18-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YBBF-18-0','KLBE-YBBF-18-0','00034406','RD','13','0.740','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YBBF-18-0','00034406','RD','13','0.740','450','333')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YBBF-18-0','00034406','00034406','KALUNG KLBE-00494','KALUNG KLBE-00494','','','5970000','5970000',' 0','0','spv','2025-10-01 09:02:52');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00494' ,nama_atribut='' ,kode_intern='KLBE-00494 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L139 1025',total_usd_ext='IDB 43 500 000',total_usd='333' WHERE kode_barang='KLBE-YBBF-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YGXH-29-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXH-29-0','KLBE-YGXH-29-0','00037058','RD','10','0.180','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXH-29-0','00037058','RD','10','0.180','420','75.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXH-29-0','KLBE-YGXH-29-0','00037058','RD','10','0.150','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXH-29-0','00037058','RD','10','0.150','420','63')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXH-29-0','KLBE-YGXH-29-0','00037058','RD','8','0.220','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXH-29-0','00037058','RD','8','0.220','420','92.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXH-29-0','KLBE-YGXH-29-0','00037058','RD','6','0.280','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXH-29-0','00037058','RD','6','0.280','480','134.4')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YGXH-29-0','00037058','00037058','KALUNG KLBE-00412 ','KALUNG KLBE-00412','','','8494500','8494500',' 0','0','spv','2025-10-01 09:04:52');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00412' ,nama_atribut='' ,kode_intern='KLBE-00412 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L109 1025',total_usd_ext='IDB 53 500 000',total_usd='365.4' WHERE kode_barang='KLBE-YGXH-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-XLXB-5-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XLXB-5-0','KLBE-XLXB-5-0','00032406','RD','16','0.400','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XLXB-5-0','00032406','RD','16','0.400','420','168')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XLXB-5-0','KLBE-XLXB-5-0','00032406','RD','1','0.050','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XLXB-5-0','00032406','RD','1','0.050','450','22.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-XLXB-5-0','00032406','00032406','KALUNG KLBE-00532','KALUNG KLBE-00532','','','7451000','7451000',' 0','0','spv','2025-10-01 09:06:34');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00532' ,nama_atribut='' ,kode_intern='KLBE-00532 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 39 000 000',total_usd='190.5' WHERE kode_barang='KLBE-XLXB-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YGBD-56-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGBD-56-0','KLBE-YGBD-56-0','00037518','RD','56','0.710','360');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGBD-56-0','00037518','RD','56','0.710','360','255.6')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YGBD-56-0','00037518','00037518','KALUNG KLBE-00855 ','KALUNG KLBE-00855','','','7982500','7982500',' 0','0','spv','2025-10-01 09:08:12');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00855' ,nama_atribut='' ,kode_intern='KLBE-00855 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDR 47 500 000',total_usd='255.6' WHERE kode_barang='KLBE-YGBD-56-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YGAH-12-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGAH-12-0','KLBE-YGAH-12-0','00037330','RD','2','0.050','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGAH-12-0','00037330','RD','2','0.050','320','16')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGAH-12-0','KLBE-YGAH-12-0','00037330','RD','2','0.035','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGAH-12-0','00037330','RD','2','0.035','320','11.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGAH-12-0','KLBE-YGAH-12-0','00037330','RD','17','0.495','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGAH-12-0','00037330','RD','17','0.495','320','158.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGAH-12-0','KLBE-YGAH-12-0','00037330','RD','22','0.120','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGAH-12-0','00037330','RD','22','0.120','320','38.4')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YGAH-12-0','00037330','00037330','KALUNG KLBE-00787 ','KALUNG KLBE-00787','','','25848000','25848000',' 0','0','spv','2025-10-01 09:13:42');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00787' ,nama_atribut='' ,kode_intern='KLBE-00787 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 102 000 000',total_usd='224' WHERE kode_barang='KLBE-YGAH-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YGAF-3-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGAF-3-0','KLBE-YGAF-3-0','00037222','RD','34','0.235','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGAF-3-0','00037222','RD','34','0.235','320','75.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGAF-3-0','KLBE-YGAF-3-0','00037222','RD','16','0.340','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGAF-3-0','00037222','RD','16','0.340','320','108.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGAF-3-0','KLBE-YGAF-3-0','00037222','RD','1','0.055','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGAF-3-0','00037222','RD','1','0.055','320','17.6')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YGAF-3-0','00037222','00037222','KALUNG KLBE-00644','KALUNG KLBE-00644','','','9895000','9895000',' 0','0','spv','2025-10-01 09:29:51');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00644' ,nama_atribut='' ,kode_intern='KLBE-00644 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L113 XL 1025',total_usd_ext='IDB 55 000 000',total_usd='201.6' WHERE kode_barang='KLBE-YGAF-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YDBE-14-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDBE-14-0','KLBE-YDBE-14-0','00035274','RD','1','0.050','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDBE-14-0','00035274','RD','1','0.050','480','24')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDBE-14-0','KLBE-YDBE-14-0','00035274','RD','16','0.300','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDBE-14-0','00035274','RD','16','0.300','420','126')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDBE-14-0','KLBE-YDBE-14-0','00035274','RD','34','0.270','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDBE-14-0','00035274','RD','34','0.270','450','121.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YDBE-14-0','00035274','00035274','KALUNG KLBE-00848 ','KALUNG KLBE-00848','','','10029500','10029500',' 0','0','spv','2025-10-01 09:30:17');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00848' ,nama_atribut='' ,kode_intern='KLBE-00848 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L113 XL 1025',total_usd_ext='IDB 55 000 000',total_usd='271.5' WHERE kode_barang='KLBE-YDBE-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YDBA-7-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDBA-7-0','KLBE-YDBA-7-0','00035101','RD','1','0.120','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDBA-7-0','00035101','RD','1','0.120','620','74.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDBA-7-0','KLBE-YDBA-7-0','00035101','RD','1','0.080','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDBA-7-0','00035101','RD','1','0.080','620','49.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDBA-7-0','KLBE-YDBA-7-0','00035101','RD','1','0.075','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDBA-7-0','00035101','RD','1','0.075','620','46.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDBA-7-0','KLBE-YDBA-7-0','00035101','RD','10','0.320','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDBA-7-0','00035101','RD','10','0.320','420','134.4')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YDBA-7-0','00035101','00035101','KALUNG KLBE-00597 ','KALUNG KLBE-00597','','','8911500','8911500',' 0','0','spv','2025-10-01 09:32:36');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00597' ,nama_atribut='' ,kode_intern='KLBE-00597 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 51 000 000',total_usd='304.9' WHERE kode_barang='KLBE-YDBA-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YGXG-33-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXG-33-0','KLBE-YGXG-33-0','00037027','RD','1','0.025','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXG-33-0','00037027','RD','1','0.025','420','10.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXG-33-0','KLBE-YGXG-33-0','00037027','RD','16','0.190','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXG-33-0','00037027','RD','16','0.190','420','79.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXG-33-0','KLBE-YGXG-33-0','00037027','RD','34','0.200','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXG-33-0','00037027','RD','34','0.200','450','90')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YGXG-33-0','00037027','00037027','KALUNG KLBE-00851 ','KALUNG KLBE-00851','','','6123500','6123500',' 0','0','spv','2025-10-01 10:05:18');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00851' ,nama_atribut='' ,kode_intern='KLBE-00851 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L106M 1025',total_usd_ext='IDB 40 000 000',total_usd='180.3' WHERE kode_barang='KLBE-YGXG-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YGXI-29-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXI-29-0','KLBE-YGXI-29-0','00037090','RD','34','0.255','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXI-29-0','00037090','RD','34','0.255','450','114.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXI-29-0','KLBE-YGXI-29-0','00037090','RD','16','0.295','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXI-29-0','00037090','RD','16','0.295','420','123.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXI-29-0','KLBE-YGXI-29-0','00037090','RD','1','0.050','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXI-29-0','00037090','RD','1','0.050','480','24')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YGXI-29-0','00037090','00037090','KALUNG KLBE-00249 ','KALUNG KLBE-00249','','','10541000','10541000',' 0','0','spv','2025-10-01 10:05:44');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00249' ,nama_atribut='' ,kode_intern='KLBE-00249 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L113 XL 1025',total_usd_ext='IDB 55 000 000',total_usd='262.65' WHERE kode_barang='KLBE-YGXI-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YBAA-26-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YBAA-26-0','KLBE-YBAA-26-0','00034092','RD','1','0.030','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YBAA-26-0','00034092','RD','1','0.030','420','12.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YBAA-26-0','KLBE-YBAA-26-0','00034092','RD','16','0.180','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YBAA-26-0','00034092','RD','16','0.180','420','75.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YBAA-26-0','KLBE-YBAA-26-0','00034092','RD','34','0.205','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YBAA-26-0','00034092','RD','34','0.205','420','86.1')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YBAA-26-0','00034092','00034092','KALUNG KLBE-00572','KALUNG KLBE-00572','','','6720500','6720500',' 0','0','spv','2025-10-01 10:06:09');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00572' ,nama_atribut='' ,kode_intern='KLBE-00572 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L106M 1025',total_usd_ext='IDB 40 000 000',total_usd='174.3' WHERE kode_barang='KLBE-YBAA-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YEBC-39-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YEBC-39-0','KLBE-YEBC-39-0','00035829','RD','13','0.510','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YEBC-39-0','00035829','RD','13','0.510','420','214.2')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YEBC-39-0','00035829','00035829','KALUNG KLBE-00584','KALUNG KLBE-00584','','','10245000','10245000',' 0','0','spv','2025-10-01 10:09:21');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00584' ,nama_atribut='' ,kode_intern='KLBE-00584 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 53 000 000',total_usd='214.2' WHERE kode_barang='KLBE-YEBC-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YEXF-6-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YEXF-6-0','KLBE-YEXF-6-0','00035463','RD','1','0.025','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YEXF-6-0','00035463','RD','1','0.025','420','10.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YEXF-6-0','KLBE-YEXF-6-0','00035463','RD','16','0.190','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YEXF-6-0','00035463','RD','16','0.190','420','79.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YEXF-6-0','KLBE-YEXF-6-0','00035463','RD','34','0.185','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YEXF-6-0','00035463','RD','34','0.185','450','83.25')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YEXF-6-0','00035463','00035463','KALUNG KLBE-00745 ','KALUNG KLBE-00745','','','6277000','6277000',' 0','0','spv','2025-10-01 10:09:50');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00745' ,nama_atribut='' ,kode_intern='KLBE-00745 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L106M 1025',total_usd_ext='IDB 40 000 000',total_usd='173.55' WHERE kode_barang='KLBE-YEXF-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YFAF-14-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFAF-14-0','KLBE-YFAF-14-0','00036345','RD','1','0.080','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFAF-14-0','00036345','RD','1','0.080','600','48')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFAF-14-0','KLBE-YFAF-14-0','00036345','RD','1','0.105','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFAF-14-0','00036345','RD','1','0.105','620','65.1')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFAF-14-0','KLBE-YFAF-14-0','00036345','RD','1','0.100','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFAF-14-0','00036345','RD','1','0.100','620','62')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFAF-14-0','KLBE-YFAF-14-0','00036345','RD','10','0.680','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFAF-14-0','00036345','RD','10','0.680','480','326.4')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YFAF-14-0','00036345','00036345','KALUNG KLBE-00471 ','KALUNG KLBE-00471','','','11176000','11176000',' 0','0','spv','2025-10-01 10:12:17');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00471' ,nama_atribut='' ,kode_intern='KLBE-00471 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 68 500 000',total_usd='501.5' WHERE kode_barang='KLBE-YFAF-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YFAH-5-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFAH-5-0','KLBE-YFAH-5-0','00036404','RD','6','0.320','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFAH-5-0','00036404','RD','6','0.320','480','153.6')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YFAH-5-0','00036404','00036404','KALUNG KLBE-00366 ','KALUNG KLBE-00366','','','6350000','6350000',' 0','0','spv','2025-10-01 10:13:49');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00366' ,nama_atribut='' ,kode_intern='KLBE-00366 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 34 000 000',total_usd='153.6' WHERE kode_barang='KLBE-YFAH-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YBAB-15-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YBAB-15-0','KLBE-YBAB-15-0','00034119','RD','10','0.100','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YBAB-15-0','00034119','RD','10','0.100','420','42')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YBAB-15-0','00034119','00034119','KALUNG KLBE-00108','KALUNG KLBE-00108','','','3577500','3577500',' 0','0','spv','2025-10-01 10:15:43');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00108' ,nama_atribut='' ,kode_intern='KLBE-00108 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 17 500 000',total_usd='42' WHERE kode_barang='KLBE-YBAB-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YEXF-15-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YEXF-15-0','KLBE-YEXF-15-0','00035472','RD','1','0.120','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YEXF-15-0','00035472','RD','1','0.120','620','74.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YEXF-15-0','KLBE-YEXF-15-0','00035472','RD','57','0.345','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YEXF-15-0','00035472','RD','57','0.345','450','155.25')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YEXF-15-0','00035472','00035472','KALUNG KLBE-00525 ','KALUNG KLBE-00525','','','15960000','15960000',' 0','0','spv','2025-10-01 10:17:25');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00525' ,nama_atribut='' ,kode_intern='KLBE-00525 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 70 000 000',total_usd='229.65' WHERE kode_barang='KLBE-YEXF-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YGBD-54-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGBD-54-0','KLBE-YGBD-54-0','00037516','RD','1','0.030','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGBD-54-0','00037516','RD','1','0.030','400','12')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGBD-54-0','KLBE-YGBD-54-0','00037516','RD','4','0.215','475');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGBD-54-0','00037516','RD','4','0.215','475','102.13')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGBD-54-0','KLBE-YGBD-54-0','00037516','RD','24','0.140','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGBD-54-0','00037516','RD','24','0.140','450','63')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YGBD-54-0','00037516','00037516','KALUNG KLBE-00853 ','KALUNG KLBE-00853','','','16065500','16065500',' 0','0','spv','2025-10-01 10:19:24');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00853' ,nama_atribut='' ,kode_intern='KLBE-00853 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDR 67 000 000',total_usd='177.13' WHERE kode_barang='KLBE-YGBD-54-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YBXD-14-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YBXD-14-0','KLBE-YBXD-14-0','00033893','RD','13','0.770','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YBXD-14-0','00033893','RD','13','0.770','450','346.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YBXD-14-0','00033893','00033893','KALUNG KLBE-00511','KALUNG KLBE-00511','','','5987000','5987000',' 0','0','spv','2025-10-01 10:21:14');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00511' ,nama_atribut='' ,kode_intern='KLBE-00511 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 44 500 000',total_usd='346.5' WHERE kode_barang='KLBE-YBXD-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YBAG-21-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YBAG-21-0','KLBE-YBAG-21-0','00034171','RD','51','0.425','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YBAG-21-0','00034171','RD','51','0.425','420','178.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YBAG-21-0','00034171','00034171','KALUNG KLBE-00438','KALUNG KLBE-00438','','','7334500','7334500',' 0','0','spv','2025-10-01 10:22:35');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00438' ,nama_atribut='' ,kode_intern='KLBE-00438 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L106M 1025',total_usd_ext='IDB 40 000 000',total_usd='178.5' WHERE kode_barang='KLBE-YBAG-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YHXG-9-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YHXG-9-0','KLBE-YHXG-9-0','00037900','RD','13','0.570','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YHXG-9-0','00037900','RD','13','0.570','400','228')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YHXG-9-0','00037900','00037900','KALUNG KLBE-00629 ','KALUNG KLBE-00629','','','10245000','10245000',' 0','0','spv','2025-10-01 10:23:54');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00629' ,nama_atribut='' ,kode_intern='KLBE-00629 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 53 000 000',total_usd='228' WHERE kode_barang='KLBE-YHXG-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YDAE-30-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDAE-30-0','KLBE-YDAE-30-0','00034998','RD','1','0.025','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDAE-30-0','00034998','RD','1','0.025','420','10.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDAE-30-0','KLBE-YDAE-30-0','00034998','RD','16','0.190','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDAE-30-0','00034998','RD','16','0.190','420','79.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDAE-30-0','KLBE-YDAE-30-0','00034998','RD','34','0.210','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDAE-30-0','00034998','RD','34','0.210','450','94.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YDAE-30-0','00034998','00034998','KALUNG KLBE-00847','KALUNG KLBE-00847','','','6226000','6226000',' 0','0','spv','2025-10-01 10:24:16');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00847' ,nama_atribut='' ,kode_intern='KLBE-00847 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L106M 1025',total_usd_ext='IDB 40 000 000',total_usd='184.8' WHERE kode_barang='KLBE-YDAE-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YCAX-2-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YCAX-2-0','KLBE-YCAX-2-0','00034659','RD','34','0.205','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YCAX-2-0','00034659','RD','34','0.205','420','86.1')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YCAX-2-0','KLBE-YCAX-2-0','00034659','RD','16','0.180','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YCAX-2-0','00034659','RD','16','0.180','420','75.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YCAX-2-0','KLBE-YCAX-2-0','00034659','RD','1','0.025','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YCAX-2-0','00034659','RD','1','0.025','420','10.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YCAX-2-0','00034659','00034659','KALUNG KLBE-00226','KALUNG KLBE-00226','','','6737500','6737500',' 0','0','spv','2025-10-01 10:24:50');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00226' ,nama_atribut='' ,kode_intern='KLBE-00226 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L106M 1025',total_usd_ext='IDB 40 000 000',total_usd='172.2' WHERE kode_barang='KLBE-YCAX-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YBXG-18-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YBXG-18-0','KLBE-YBXG-18-0','00034025','RD','10','0.450','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YBXG-18-0','00034025','RD','10','0.450','420','189')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YBXG-18-0','00034025','00034025','KALUNG KLBE-00076','KALUNG KLBE-00076','','','10139000','10139000',' 0','0','spv','2025-10-01 10:26:49');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00076' ,nama_atribut='' ,kode_intern='KLBE-00076 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 49 000 000',total_usd='189' WHERE kode_barang='KLBE-YBXG-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-XHXF-39-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XHXF-39-0','KLBE-XHXF-39-0','00030412','RD','51','0.230','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XHXF-39-0','00030412','RD','51','0.230','450','103.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-XHXF-39-0','00030412','00030412','KALUNG KLBE-00759','KALUNG KLBE-00759','','','6192000','6192000',' 0','0','spv','2025-10-01 10:28:13');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00759' ,nama_atribut='' ,kode_intern='KLBE-00759 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L208 1025',total_usd_ext='IDB 33 000 000',total_usd='103.5' WHERE kode_barang='KLBE-XHXF-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YIAE-22-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YIAE-22-0','KLBE-YIAE-22-0','00038731','RD','1','0.025','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YIAE-22-0','00038731','RD','1','0.025','320','8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YIAE-22-0','KLBE-YIAE-22-0','00038731','RD','16','0.190','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YIAE-22-0','00038731','RD','16','0.190','320','60.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YIAE-22-0','KLBE-YIAE-22-0','00038731','RD','34','0.220','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YIAE-22-0','00038731','RD','34','0.220','320','70.4')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YIAE-22-0','00038731','00038731','KALUNG KLBE-00842 ','KALUNG KLBE-00842','','','6042000','6042000',' 0','0','spv','2025-10-01 10:28:36');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00842' ,nama_atribut='' ,kode_intern='KLBE-00842 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L106 M 1025',total_usd_ext='IDB 40 000 000',total_usd='139.2' WHERE kode_barang='KLBE-YIAE-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YIAG-18-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YIAG-18-0','KLBE-YIAG-18-0','00038780','RD','51','0.325','320');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YIAG-18-0','00038780','RD','51','0.325','320','104')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YIAG-18-0','00038780','00038780','KALUNG KLBE-00162 ','KALUNG KLBE-00162','','','5780000','5780000',' 0','0','spv','2025-10-01 10:29:06');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00162' ,nama_atribut='' ,kode_intern='KLBE-00162 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L106 M 1025',total_usd_ext='IDB 40 000 000',total_usd='104' WHERE kode_barang='KLBE-YIAG-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-PFBX-4-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-PFBX-4-0','KLBE-PFBX-4-0','00015388','RD','6','0.025','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-PFBX-4-0','00015388','RD','6','0.025','450','11.25')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-PFBX-4-0','00015388','00015388','KALUNG BERLIAN','KALUNG KLBE-00659','','','6140500','6140500',' 0','0','spv','2025-10-01 10:31:09');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00659' ,nama_atribut='' ,kode_intern='KLBE-00659 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='handmade 1025',total_usd_ext='IDR 26 000 000',total_usd='11.25' WHERE kode_barang='KLBE-PFBX-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YAAG-3-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YAAG-3-0','KLBE-YAAG-3-0','00033442','RD','10','0.400','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YAAG-3-0','00033442','RD','10','0.400','420','168')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YAAG-3-0','KLBE-YAAG-3-0','00033442','RD','3','0.085','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YAAG-3-0','00033442','RD','3','0.085','420','35.7')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YAAG-3-0','KLBE-YAAG-3-0','00033442','RD','3','0.200','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YAAG-3-0','00033442','RD','3','0.200','450','90')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YAAG-3-0','KLBE-YAAG-3-0','00033442','RD','1','0.040','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YAAG-3-0','00033442','RD','1','0.040','450','18')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YAAG-3-0','00033442','00033442','KALUNG KLBE-00841','KALUNG KLBE-00841','','','9207500','9207500',' 0','0','spv','2025-10-01 10:33:31');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00841' ,nama_atribut='' ,kode_intern='KLBE-00841 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 53 000 000',total_usd='311.7' WHERE kode_barang='KLBE-YAAG-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YDBE-17-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDBE-17-0','KLBE-YDBE-17-0','00035277','SP','3','0.680','20');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDBE-17-0','00035277','SP','3','0.680','20','13.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDBE-17-0','KLBE-YDBE-17-0','00035277','RD','2','0.050','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDBE-17-0','00035277','RD','2','0.050','420','21')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YDBE-17-0','KLBE-YDBE-17-0','00035277','RD','36','0.285','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YDBE-17-0','00035277','RD','36','0.285','450','128.25')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YDBE-17-0','00035277','00035277','KALUNG KLBE-00849 ','KALUNG KLBE-00849','','','6686500','6686500',' 0','0','spv','2025-10-01 10:35:13');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00849' ,nama_atribut='' ,kode_intern='KLBE-00849 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L179 1025',total_usd_ext='IDB 36 500 000',total_usd='162.85' WHERE kode_barang='KLBE-YDBE-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-XEXI-30-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XEXI-30-0','KLBE-XEXI-30-0','00028276','RD','4','0.010','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XEXI-30-0','00028276','RD','4','0.010','450','4.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XEXI-30-0','KLBE-XEXI-30-0','00028276','RD','1','0.030','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XEXI-30-0','00028276','RD','1','0.030','420','12.6')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-XEXI-30-0','00028276','00028276','KALUNG KLBE-00298','KALUNG KLBE-00298','','','3789000','3789000',' 0','0','spv','2025-10-01 10:36:45');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00298' ,nama_atribut='' ,kode_intern='KLBE-00298 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 16 500 000',total_usd='17.1' WHERE kode_barang='KLBE-XEXI-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-XAAH-6-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XAAH-6-0','KLBE-XAAH-6-0','00025929','RD','23','0.130','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XAAH-6-0','00025929','RD','23','0.130','450','58.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XAAH-6-0','KLBE-XAAH-6-0','00025929','RD','1','0.120','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XAAH-6-0','00025929','RD','1','0.120','620','74.4')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-XAAH-6-0','00025929','00025929','KALUNG KLBE-00374','KALUNG KLBE-00374','','','6054000','6054000',' 0','0','spv','2025-10-01 10:38:27');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00374' ,nama_atribut='' ,kode_intern='KLBE-00374 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 32 000 000',total_usd='132.9' WHERE kode_barang='KLBE-XAAH-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YFBG-20-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFBG-20-0','KLBE-YFBG-20-0','00036795','RD','2','0.210','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFBG-20-0','00036795','RD','2','0.210','620','130.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFBG-20-0','KLBE-YFBG-20-0','00036795','RD','64','0.175','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFBG-20-0','00036795','RD','64','0.175','450','78.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFBG-20-0','KLBE-YFBG-20-0','00036795','RD','10','0.350','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFBG-20-0','00036795','RD','10','0.350','450','157.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFBG-20-0','KLBE-YFBG-20-0','00036795','RD','1','0.075','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFBG-20-0','00036795','RD','1','0.075','480','36')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YFBG-20-0','00036795','00036795','KALUNG KLBE-00650 ','KALUNG KLBE-00650','','','8488000','8488000',' 0','0','spv','2025-10-01 10:40:26');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00650' ,nama_atribut='' ,kode_intern='KLBE-00650 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 55 000 000',total_usd='402.45' WHERE kode_barang='KLBE-YFBG-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-XKAA-29-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XKAA-29-0','KLBE-XKAA-29-0','00032141','RD','1','0.040','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XKAA-29-0','00032141','RD','1','0.040','420','16.8')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XKAA-29-0','KLBE-XKAA-29-0','00032141','RD','16','0.320','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XKAA-29-0','00032141','RD','16','0.320','420','134.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XKAA-29-0','KLBE-XKAA-29-0','00032141','RD','34','0.235','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XKAA-29-0','00032141','RD','34','0.235','420','98.7')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-XKAA-29-0','00032141','00032141','KALUNG KLBE-00824','KALUNG KLBE-00824','','','10115000','10115000',' 0','0','spv','2025-10-01 10:41:15');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00824' ,nama_atribut='' ,kode_intern='KLBE-00824 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L113 XL 1025',total_usd_ext='IDB 55 000 000',total_usd='249.9' WHERE kode_barang='KLBE-XKAA-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YGXI-30-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXI-30-0','KLBE-YGXI-30-0','00037091','RD','1','0.025','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXI-30-0','00037091','RD','1','0.025','420','10.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXI-30-0','KLBE-YGXI-30-0','00037091','RD','16','0.185','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXI-30-0','00037091','RD','16','0.185','420','77.7')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YGXI-30-0','KLBE-YGXI-30-0','00037091','RD','34','0.220','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YGXI-30-0','00037091','RD','34','0.220','450','99')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YGXI-30-0','00037091','00037091','KALUNG KLBE-00852','KALUNG KLBE-00852','','','6618000','6618000',' 0','0','spv','2025-10-01 10:42:52');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00852' ,nama_atribut='' ,kode_intern='KLBE-00852 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L106 M 1025',total_usd_ext='IDB 40 000 000',total_usd='187.2' WHERE kode_barang='KLBE-YGXI-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-XEAX-8-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-XEAX-8-0','KLBE-XEAX-8-0','00028289','RD','13','0.510','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-XEAX-8-0','00028289','RD','13','0.510','480','244.8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-XEAX-8-0','00028289','00028289','KALUNG KLBE-00583','KALUNG KLBE-00583','','','10329500','10329500',' 0','0','spv','2025-10-01 10:44:26');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00583' ,nama_atribut='' ,kode_intern='KLBE-00583 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1025',total_usd_ext='IDB 53 000 000',total_usd='244.8' WHERE kode_barang='KLBE-XEAX-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='KLBE-YFXC-13-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFXC-13-0','KLBE-YFXC-13-0','00036081','RD','1','0.025','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFXC-13-0','00036081','RD','1','0.025','420','10.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFXC-13-0','KLBE-YFXC-13-0','00036081','RD','16','0.195','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFXC-13-0','00036081','RD','16','0.195','420','81.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('KLBE-YFXC-13-0','KLBE-YFXC-13-0','00036081','RD','34','0.215','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('KLBE-YFXC-13-0','00036081','RD','34','0.215','450','96.75')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('KLBE-YFXC-13-0','00036081','00036081','KALUNG KLBE-00696 ','KALUNG KLBE-00696','','','6311000','6311000',' 0','0','spv','2025-10-01 10:46:16');
UPDATE tm_barang SET nama_barang='KALUNG KLBE-00696' ,nama_atribut='' ,kode_intern='KLBE-00696 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='L106M 1025',total_usd_ext='IDB 40 000 000',total_usd='189.15' WHERE kode_barang='KLBE-YFXC-13-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-10-01 ','10:58:00');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-01 ','11:15:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-10-01 ','13:43:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-10-01 ','15:52:13');
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-00008764','X-00008764','LIONTIN LBRE-00807','GR','---','LBRE','BELI','BELI001','8400000','2025-10-01','1.620','1','kasir','2025-10-01 17:28:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-LBRE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-LBRE','X-00008764','X-00008764');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251001-0001','FE-250429-0004','NANA','1','BELI','BELI001','LBRE', 'X-00008764', 'LIONTIN LBRE-00807','1.620','1.620','83.00','10500000','8400000','5185185','1','8400000','8400000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.620',berat_beli_asli=berat_beli_asli+'1.620',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.620',berat_akhir_asli=berat_akhir_asli+'1.620',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='LBRE' 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,status_valid,type_bayar) VALUES ('BE-251001-0001','2025-10-01','2025-10-01','17:28:19','NANA','---','1.620','8400000','8400000','8400000','8400000','8400000','kasir','2025-10-01 17:28:19','BE-251001-0001','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251001-0001','AMALIA','JKT','','','0','kasir','2025-10-01 17:28:19');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251001-0001','2025-10-01','2025-10-01 17:28:19','PEMBELIAN UMUM : BE-251001-0001','.','TBC','8400000','8400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-251001-0002','K','2025-10-01','17:28:19','TBC','PEMBELIAN UMUM','BE-251001-0001','92236180220','8400000','92227780220','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
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-00008765','X-00008765','CINCIN BERLIAN BALIK','GR','---','CBR','BELI','BELI001','12750000','2025-10-01','9.640','1','kasir','2025-10-01 19:16:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-CBR';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-CBR','X-00008765','X-00008765');
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,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('BE-251001-0002','-','FAISAL','1','BELI','BELI001','CBR', 'X-00008765', 'CINCIN BERLIAN BALIK','0.000','9.640','75.00','0','12750000','1322614','1','12750000','12750000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'9.640',berat_beli_asli=berat_beli_asli+'9.640',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'9.640',berat_akhir_asli=berat_akhir_asli+'9.640',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='CBR' 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,status_valid,type_bayar) VALUES ('BE-251001-0002','2025-10-01','2025-10-01','19:16:49','FAISAL','---','9.640','12750000','12750000','12750000','12750000','12750000','kasir','2025-10-01 19:16:50','BE-251001-0002','OPEN','TRANSFER');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('BE-251001-0002','BUDI SUSILO','JKT','','JKT','0','kasir','2025-10-01 19:16:50');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp) VALUES ('TF-251001-0002','2025-10-01','2025-10-01 19:16:50','PEMBELIAN UMUM : BE-251001-0002','.','TBC','12750000','12750000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KK-251001-0003','K','2025-10-01','19:16:49','TBC','PEMBELIAN UMUM','BE-251001-0002','92227780220','12750000','92215030220','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','');
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,potong_rp,keterangan) VALUES ('FE-251001-0001','kasir','1',' 700K-21-75','TOKO','PERAK','CKPRE-YGAE-9-0','CINCIN SILVER 925 ','','2.150','1','100.00','44000','0','0','16500','700000','0','0','0','700000','NANA','00037189','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-YGAE-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2025-10-01' AND kode_barang='CKPRE-YGAE-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' 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,no_persekot,dp_pesanan) VALUES ('FE-251001-0001','2025-10-01','2.150','2025-10-01','19:27:50','PLG0027008','700000','700000','0','700000','0','kasir','2025-10-01 19:27:50','FE-251001-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-01','FE-251001-0001','2025-10-01','19:27:50','NANA','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251001-0003','2025-10-01','2025-10-01 19:27:50','PENJUALAN : FE-251001-0001','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251001-0004','D','2025-10-01','19:27:50','TBC','PENJUALAN','FE-251001-0001','92215030220','700000','92215730220','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FE-251001-0001' 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,potong_rp,keterangan) VALUES ('FE-251001-0002','kasir',' 1',' 700K-26-76','TOKO','PERAK','CKPRE-YHXE-28-0','CINCIN SILVER 925 ','','5.130','1','100.00','132000','0','0','16500','700000','0','0','0','700000','NANA','00037878','CKPRE','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='CKPRE-YHXE-28-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.130',berat_jual_asli=berat_jual_asli+'5.130',stock_jual='1',berat_akhir=berat_akhir-'5.130',berat_akhir_asli=berat_akhir_asli-'5.130',stock_akhir='0' WHERE tanggal='2025-10-01' AND kode_barang='CKPRE-YHXE-28-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PERAK' 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,no_persekot,dp_pesanan) VALUES ('FE-251001-0002','2025-10-01','5.130','2025-10-01','19:27:50','PLG0027009','700000','700000','0','700000','0','kasir','2025-10-01 19:27:50','FE-251001-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-01','FE-251001-0002','2025-10-01','19:27:50','NANA','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251001-0004','2025-10-01','2025-10-01 19:27:50','PENJUALAN : FE-251001-0002','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251001-0005','D','2025-10-01','19:27:50','TBC','PENJUALAN','FE-251001-0002','92215730220','700000','92216430220','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1400000' WHERE no_faktur_jual='FE-251001-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251001-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251001-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251001-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251001-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FE-251001-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FE-251001-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251001-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251001-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='BE-251001-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='BE-251001-0002';
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-251001-0002','K','2025-10-01','19:43:29','kasir','BELANJA','BELI KABEL','567050','380000','187050');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-01';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-01';
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='2025-10-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-01';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-01' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-251002-0001','D','2025-10-02','20:21:59','TBC','SALDO AWAL','SALDO AWAL','0','92216430220','92216430220');
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-251002-0001','D','2025-10-02','20:21:59','TMR','SALDO AWAL','SALDO AWAL','0','8166083779','8166083779');
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-251002-0001','D','2025-10-02','20:21:59','BNI','SALDO AWAL','SALDO AWAL','0','79502900','79502900');
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-251002-0001','D','2025-10-02','20:21:59','3400000','SALDO AWAL','SALDO AWAL','0','-20800000','-20800000');
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-251002-0001','D','2025-10-02','20:21:59','BKC','SALDO AWAL','SALDO AWAL','0','7600000','7600000');
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-251002-0001','D','2025-10-02','20:21:59','4000000','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-251002-0001','D','2025-10-02','20:21:59','DEBIT BCA','SALDO AWAL','SALDO AWAL','0','213120000','213120000');
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-251002-0001','D','2025-10-02','20:21:59','3450000','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-251002-0001','D','2025-10-02','20:21:59','TRANSFER MANDIRI','SALDO AWAL','SALDO AWAL','0','2000000','2000000');
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-251002-0001','D','2025-10-02','20:21:59','CREDIT BCA','SALDO AWAL','SALDO AWAL','0','10800000','10800000');
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-251002-0001','D','2025-10-02','20:21:59','TRANSFER BCA','SALDO AWAL','SALDO AWAL','0','212267092','212267092');
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-251002-0001','D','2025-10-02','20:21:59','BCA','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-251002-0001','D','2025-10-02','20:21:59','TOKO PEDIA','SALDO AWAL','SALDO AWAL','0','500000','500000');
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-251002-0001','D','2025-10-02','20:21:59','BNK','SALDO AWAL','SALDO AWAL','0','8191000','8191000');
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-251002-0001','D','2025-10-02','20:21:59','6000000','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-251002-0001','D','2025-10-02','20:21:59','MANDIRI','SALDO AWAL','SALDO AWAL','0','295387450','295387450');
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-251002-0001','D','2025-10-02','20:21:59','TOP','SALDO AWAL','SALDO AWAL','0','6539308581','6539308581');
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-251002-0001','D','2025-10-02','20:21:59','SHO','SALDO AWAL','SALDO AWAL','0','2741005684','2741005684');
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-251002-0001','D','2025-10-02','20:21:59','BCD','SALDO AWAL','SALDO AWAL','0','14828019700','14828019700');
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-251002-0001','D','2025-10-02','20:21:59','','SALDO AWAL','SALDO AWAL','0','13818500','13818500');
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-251002-0001','D','2025-10-02','20:21:59','DPE','SALDO AWAL','SALDO AWAL','0','264226800','264226800');
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-251002-0001','D','2025-10-02','20:21:59','KET','SALDO AWAL','SALDO AWAL','0','130319250','130319250');
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-251002-0001','D','2025-10-02','20:21:59','BCK','SALDO AWAL','SALDO AWAL','0','15848983978.088','15848983978.088');
UPDATE tp_system SET tgl_system='2025-10-02';