[2026-01-26 11:44:59] ======== START PROCESS ======== [2026-01-26 11:44:59] Last deptrans_id: 682072 [2026-01-26 11:44:59] Query: SELECT TRIM(deposito.NO_REKENING) AS no_rekening ,TRIM(deposito.NO_ALTERNATIF) AS no_bilyet ,deposito.JKW AS jangka_waktu ,deposito.SUKU_BUNGA AS suku_bunga ,deposito.BUNGA_BERBUNGA AS flag_bunga_masuk_pokok ,deposito.TGL_REGISTRASI AS tanggal_registrasi ,deposito.TGL_MULAI AS tanggal_pembukaan ,deposito.TGL_JT AS tanggal_jatuh_tempo ,kodejenisdeposito.KODE_JENIS_DEPOSITO AS kode_jenis_deposito ,kodejenisdeposito.DESKRIPSI_JENIS_DEPOSITO AS jenis_deposito ,deposito.JML_DEPOSITO AS nominal_deposito ,CASE WHEN deptrans.KUITANSI LIKE '%ARO%' THEN deposito.JML_DEPOSITO ELSE 0 END AS nominal_outstanding ,TRIM(deposito.STATUS_BUNGA) AS status_bunga ,TRIM(deposito.qq) AS qq ,TRIM(deposito.and_or) AS and_or ,TRIM(deposito.nasabah_qq) AS nasabah_qq ,TRIM(deposito.NO_REK_TABUNGAN) AS no_rekening_tabungan ,CASE WHEN deposito.STATUS_AKTIF = '1' THEN 'Baru' WHEN deposito.STATUS_AKTIF = '2' THEN 'Aktif' WHEN deposito.STATUS_AKTIF = '3' THEN 'Tutup' ELSE 'Invalid' END AS status_aktif ,TRIM(kodegroup1deposito.KODE_GROUP1) AS kode_marketing_deposito ,TRIM(kodegroup1deposito.DESKRIPSI_GROUP1) AS nama_marketing_deposito ,TRIM(kodegroup2deposito.DESKRIPSI_GROUP2) AS kode_group2 ,TRIM(kodegroup3deposito.DESKRIPSI_GROUP3) AS kode_group3 ,TRIM(kodegroup4_deposito.DESKRIPSI_GROUP4) AS kode_group4 ,TRIM(kodegroup5deposito.DESKRIPSI_GROUP5) AS kode_group5 ,TRIM(nasabah.NASABAH_ID) AS cif ,nasabah.TGL_BUKA AS tanggal_registrasi_cif ,TRIM(nasabah.NAMA_NASABAH) AS nama_nasabah ,CASE WHEN nasabah.JENIS_NASABAH='1' THEN 'Individu' ELSE 'Non Invidividu' END AS jenis_nasabah ,TRIM(nasabah.ALAMAT_DOMISILI) AS alamat ,TRIM(nasabah.KOTA) AS kota ,TRIM(nasabah.NO_HP) AS no_handphone ,TRIM(nasabah.EMAIL) AS email ,TRIM(nasabah.no_id) AS nik ,nasabah.tgllahir AS tanggal_lahir ,TRIM(kodegroup1_nasabah.DESKRIPSI_GROUP1) AS agama ,deptrans.DEPTRANS_ID AS deptrans_id ,TRIM(deptrans.NO_REKENING) AS deptrans_no_rekening ,deptrans.TGL_TRANS AS deptrans_tgl_trans ,TRIM(deptrans.MY_KODE_TRANS) AS deptrans_my_kode_trans ,TRIM(kodetransdeposito.KODE_TRANS) AS deptrans_kode_trans ,CASE WHEN deptrans.KUITANSI LIKE '%ARO%' THEN deptrans.KUITANSI ELSE TRIM(kodetransdeposito.DESKRIPSI_TRANS) END AS deptrans_deskripsi_trans ,deptrans.SALDO_TRANS AS deptrans_saldo_trans ,TRIM(deptrans.KUITANSI) AS deptrans_kuitansi FROM deptrans JOIN deposito ON deptrans.NO_REKENING = deposito.NO_REKENING JOIN nasabah ON deposito.NASABAH_ID = nasabah.nasabah_id LEFT JOIN kodetransdeposito ON deptrans.KODE_TRANS = kodetransdeposito.KODE_TRANS LEFT JOIN kodegroup1deposito ON deposito.KODE_GROUP1 = kodegroup1deposito.KODE_GROUP1 LEFT JOIN kodegroup2deposito ON deposito.KODE_GROUP2 = kodegroup2deposito.KODE_GROUP2 LEFT JOIN kodegroup3deposito ON deposito.KODE_GROUP3 = kodegroup3deposito.KODE_GROUP3 LEFT JOIN kodegroup4_deposito ON deposito.KODE_GROUP4 = kodegroup4_deposito.KODE_GROUP4 LEFT JOIN kodegroup5deposito ON deposito.KODE_GROUP5 = kodegroup5deposito.KODE_GROUP5 LEFT JOIN kodegroup1_nasabah ON nasabah.NASABAH_GROUP1 = kodegroup1_nasabah.NASABAH_GROUP1 LEFT JOIN kodejenisdeposito ON deposito.JENIS_DEPOSITO = kodejenisdeposito.KODE_JENIS_DEPOSITO WHERE deptrans.DEPTRANS_ID > 682072 AND deptrans.MY_KODE_TRANS NOT IN ('500') AND (deptrans.KODE_TRANS IN ('01','08','03','09') OR deptrans.KUITANSI LIKE '%ARO%') ORDER BY deptrans.DEPTRANS_ID ; [2026-01-26 11:44:59] Total Rows query.sql : 78 [2026-01-26 11:44:59] HTTP Status Code: 200 [2026-01-26 11:44:59] Response: [{"success":true}] [2026-01-26 11:44:59] Deptrans ID: 682080 telah diproses [2026-01-26 11:45:00] HTTP Status Code: 200 [2026-01-26 11:45:00] Response: [{"success":true}] [2026-01-26 11:45:00] Deptrans ID: 682101 telah diproses [2026-01-26 11:45:00] HTTP Status Code: 200 [2026-01-26 11:45:00] Response: [{"success":true}] [2026-01-26 11:45:01] Deptrans ID: 682109 telah diproses [2026-01-26 11:45:01] HTTP Status Code: 200 [2026-01-26 11:45:01] Response: [{"success":true}] [2026-01-26 11:45:01] Deptrans ID: 682113 telah diproses [2026-01-26 11:45:02] HTTP Status Code: 200 [2026-01-26 11:45:02] Response: [{"success":true}] [2026-01-26 11:45:02] Deptrans ID: 682127 telah diproses [2026-01-26 11:45:02] HTTP Status Code: 200 [2026-01-26 11:45:02] Response: [{"success":true}] [2026-01-26 11:45:02] Deptrans ID: 682149 telah diproses [2026-01-26 11:45:04] HTTP Status Code: 200 [2026-01-26 11:45:04] Response: [{"success":true}] [2026-01-26 11:45:04] Deptrans ID: 682155 telah diproses [2026-01-26 11:45:04] HTTP Status Code: 200 [2026-01-26 11:45:04] Response: [{"success":true}] [2026-01-26 11:45:04] Deptrans ID: 682159 telah diproses [2026-01-26 11:45:05] HTTP Status Code: 200 [2026-01-26 11:45:05] Response: [{"success":true}] [2026-01-26 11:45:05] Deptrans ID: 682208 telah diproses [2026-01-26 11:45:06] HTTP Status Code: 200 [2026-01-26 11:45:06] Response: [{"success":true}] [2026-01-26 11:45:06] Deptrans ID: 682220 telah diproses [2026-01-26 11:45:06] HTTP Status Code: 200 [2026-01-26 11:45:06] Response: [{"success":true}] [2026-01-26 11:45:06] Deptrans ID: 682226 telah diproses [2026-01-26 11:45:07] HTTP Status Code: 200 [2026-01-26 11:45:07] Response: [{"success":true}] [2026-01-26 11:45:07] Deptrans ID: 682260 telah diproses [2026-01-26 11:45:07] HTTP Status Code: 200 [2026-01-26 11:45:07] Response: [{"success":true}] [2026-01-26 11:45:07] Deptrans ID: 682280 telah diproses [2026-01-26 11:45:08] HTTP Status Code: 200 [2026-01-26 11:45:08] Response: [{"success":true}] [2026-01-26 11:45:08] Deptrans ID: 682286 telah diproses [2026-01-26 11:45:08] HTTP Status Code: 200 [2026-01-26 11:45:08] Response: [{"success":true}] [2026-01-26 11:45:08] Deptrans ID: 682310 telah diproses [2026-01-26 11:45:09] HTTP Status Code: 200 [2026-01-26 11:45:09] Response: [{"success":true}] [2026-01-26 11:45:09] Deptrans ID: 682316 telah diproses [2026-01-26 11:45:10] HTTP Status Code: 200 [2026-01-26 11:45:10] Response: [{"success":true}] [2026-01-26 11:45:10] Deptrans ID: 682320 telah diproses [2026-01-26 11:45:10] HTTP Status Code: 200 [2026-01-26 11:45:10] Response: [{"success":true}] [2026-01-26 11:45:10] Deptrans ID: 682324 telah diproses [2026-01-26 11:45:11] HTTP Status Code: 200 [2026-01-26 11:45:11] Response: [{"success":true}] [2026-01-26 11:45:11] Deptrans ID: 682330 telah diproses [2026-01-26 11:45:11] HTTP Status Code: 200 [2026-01-26 11:45:11] Response: [{"success":true}] [2026-01-26 11:45:11] Deptrans ID: 682338 telah diproses [2026-01-26 11:45:12] HTTP Status Code: 200 [2026-01-26 11:45:12] Response: [{"success":true}] [2026-01-26 11:45:12] Deptrans ID: 682342 telah diproses [2026-01-26 11:45:12] HTTP Status Code: 200 [2026-01-26 11:45:12] Response: [{"success":true}] [2026-01-26 11:45:12] Deptrans ID: 682347 telah diproses [2026-01-26 11:45:13] HTTP Status Code: 200 [2026-01-26 11:45:13] Response: [{"success":true}] [2026-01-26 11:45:13] Deptrans ID: 682357 telah diproses [2026-01-26 11:45:14] HTTP Status Code: 200 [2026-01-26 11:45:14] Response: [{"success":true}] [2026-01-26 11:45:14] Deptrans ID: 682375 telah diproses [2026-01-26 11:45:14] HTTP Status Code: 200 [2026-01-26 11:45:14] Response: [{"success":true}] [2026-01-26 11:45:14] Deptrans ID: 682403 telah diproses [2026-01-26 11:45:15] HTTP Status Code: 200 [2026-01-26 11:45:15] Response: [{"success":true}] [2026-01-26 11:45:15] Deptrans ID: 682449 telah diproses [2026-01-26 11:45:15] HTTP Status Code: 200 [2026-01-26 11:45:15] Response: [{"success":true}] [2026-01-26 11:45:15] Deptrans ID: 682459 telah diproses [2026-01-26 11:45:16] HTTP Status Code: 200 [2026-01-26 11:45:16] Response: [{"success":true}] [2026-01-26 11:45:16] Deptrans ID: 682465 telah diproses [2026-01-26 11:45:16] HTTP Status Code: 200 [2026-01-26 11:45:16] Response: [{"success":true}] [2026-01-26 11:45:16] Deptrans ID: 682491 telah diproses [2026-01-26 11:45:17] HTTP Status Code: 200 [2026-01-26 11:45:17] Response: [{"success":true}] [2026-01-26 11:45:17] Deptrans ID: 682509 telah diproses [2026-01-26 11:45:17] HTTP Status Code: 200 [2026-01-26 11:45:17] Response: [{"success":true}] [2026-01-26 11:45:17] Deptrans ID: 682529 telah diproses [2026-01-26 11:45:18] HTTP Status Code: 200 [2026-01-26 11:45:18] Response: [{"success":true}] [2026-01-26 11:45:18] Deptrans ID: 682546 telah diproses [2026-01-26 11:45:18] HTTP Status Code: 200 [2026-01-26 11:45:18] Response: [{"success":true}] [2026-01-26 11:45:18] Deptrans ID: 682557 telah diproses [2026-01-26 11:45:19] HTTP Status Code: 200 [2026-01-26 11:45:19] Response: [{"success":true}] [2026-01-26 11:45:19] Deptrans ID: 682575 telah diproses [2026-01-26 11:45:20] HTTP Status Code: 200 [2026-01-26 11:45:20] Response: [{"success":true}] [2026-01-26 11:45:20] Deptrans ID: 682583 telah diproses [2026-01-26 11:45:20] HTTP Status Code: 200 [2026-01-26 11:45:20] Response: [{"success":true}] [2026-01-26 11:45:20] Deptrans ID: 682587 telah diproses [2026-01-26 11:45:21] HTTP Status Code: 200 [2026-01-26 11:45:21] Response: [{"success":true}] [2026-01-26 11:45:21] Deptrans ID: 682591 telah diproses [2026-01-26 11:45:21] HTTP Status Code: 200 [2026-01-26 11:45:21] Response: [{"success":true}] [2026-01-26 11:45:21] Deptrans ID: 682600 telah diproses [2026-01-26 11:45:22] HTTP Status Code: 200 [2026-01-26 11:45:22] Response: [{"success":true}] [2026-01-26 11:45:22] Deptrans ID: 682606 telah diproses [2026-01-26 11:45:22] HTTP Status Code: 200 [2026-01-26 11:45:22] Response: [{"success":true}] [2026-01-26 11:45:22] Deptrans ID: 682612 telah diproses [2026-01-26 11:45:23] HTTP Status Code: 200 [2026-01-26 11:45:23] Response: [{"success":true}] [2026-01-26 11:45:23] Deptrans ID: 682616 telah diproses [2026-01-26 11:45:23] HTTP Status Code: 200 [2026-01-26 11:45:23] Response: [{"success":true}] [2026-01-26 11:45:23] Deptrans ID: 682620 telah diproses [2026-01-26 11:45:24] HTTP Status Code: 200 [2026-01-26 11:45:24] Response: [{"success":true}] [2026-01-26 11:45:24] Deptrans ID: 682650 telah diproses [2026-01-26 11:45:25] HTTP Status Code: 200 [2026-01-26 11:45:25] Response: [{"success":true}] [2026-01-26 11:45:25] Deptrans ID: 682656 telah diproses [2026-01-26 11:45:25] HTTP Status Code: 200 [2026-01-26 11:45:25] Response: [{"success":true}] [2026-01-26 11:45:25] Deptrans ID: 682662 telah diproses [2026-01-26 11:45:26] HTTP Status Code: 200 [2026-01-26 11:45:26] Response: [{"success":true}] [2026-01-26 11:45:26] Deptrans ID: 682670 telah diproses [2026-01-26 11:45:26] HTTP Status Code: 200 [2026-01-26 11:45:26] Response: [{"success":true}] [2026-01-26 11:45:26] Deptrans ID: 682676 telah diproses [2026-01-26 11:45:27] HTTP Status Code: 200 [2026-01-26 11:45:27] Response: [{"success":true}] [2026-01-26 11:45:27] Deptrans ID: 682690 telah diproses [2026-01-26 11:45:27] HTTP Status Code: 200 [2026-01-26 11:45:27] Response: [{"success":true}] [2026-01-26 11:45:27] Deptrans ID: 682694 telah diproses [2026-01-26 11:45:28] HTTP Status Code: 200 [2026-01-26 11:45:28] Response: [{"success":true}] [2026-01-26 11:45:28] Deptrans ID: 682728 telah diproses [2026-01-26 11:45:28] HTTP Status Code: 200 [2026-01-26 11:45:28] Response: [{"success":true}] [2026-01-26 11:45:28] Deptrans ID: 682740 telah diproses [2026-01-26 11:45:29] HTTP Status Code: 200 [2026-01-26 11:45:29] Response: [{"success":true}] [2026-01-26 11:45:29] Deptrans ID: 682888 telah diproses [2026-01-26 11:45:30] HTTP Status Code: 200 [2026-01-26 11:45:30] Response: [{"success":true}] [2026-01-26 11:45:30] Deptrans ID: 682889 telah diproses [2026-01-26 11:45:30] HTTP Status Code: 200 [2026-01-26 11:45:30] Response: [{"success":true}] [2026-01-26 11:45:30] Deptrans ID: 682890 telah diproses [2026-01-26 11:45:31] HTTP Status Code: 200 [2026-01-26 11:45:31] Response: [{"success":true}] [2026-01-26 11:45:31] Deptrans ID: 682891 telah diproses [2026-01-26 11:45:31] HTTP Status Code: 200 [2026-01-26 11:45:31] Response: [{"success":true}] [2026-01-26 11:45:31] Deptrans ID: 682892 telah diproses [2026-01-26 11:45:32] HTTP Status Code: 200 [2026-01-26 11:45:32] Response: [{"success":true}] [2026-01-26 11:45:32] Deptrans ID: 682893 telah diproses [2026-01-26 11:45:32] HTTP Status Code: 200 [2026-01-26 11:45:32] Response: [{"success":true}] [2026-01-26 11:45:32] Deptrans ID: 682894 telah diproses [2026-01-26 11:45:33] HTTP Status Code: 200 [2026-01-26 11:45:33] Response: [{"success":true}] [2026-01-26 11:45:33] Deptrans ID: 682895 telah diproses [2026-01-26 11:45:33] HTTP Status Code: 200 [2026-01-26 11:45:33] Response: [{"success":true}] [2026-01-26 11:45:33] Deptrans ID: 682896 telah diproses [2026-01-26 11:45:34] HTTP Status Code: 200 [2026-01-26 11:45:34] Response: [{"success":true}] [2026-01-26 11:45:34] Deptrans ID: 682897 telah diproses [2026-01-26 11:45:34] HTTP Status Code: 200 [2026-01-26 11:45:34] Response: [{"success":true}] [2026-01-26 11:45:34] Deptrans ID: 682898 telah diproses [2026-01-26 11:45:35] HTTP Status Code: 200 [2026-01-26 11:45:35] Response: [{"success":true}] [2026-01-26 11:45:35] Deptrans ID: 682899 telah diproses [2026-01-26 11:45:35] HTTP Status Code: 200 [2026-01-26 11:45:35] Response: [{"success":true}] [2026-01-26 11:45:35] Deptrans ID: 682900 telah diproses [2026-01-26 11:45:36] HTTP Status Code: 200 [2026-01-26 11:45:36] Response: [{"success":true}] [2026-01-26 11:45:36] Deptrans ID: 682901 telah diproses [2026-01-26 11:45:37] HTTP Status Code: 200 [2026-01-26 11:45:37] Response: [{"success":true}] [2026-01-26 11:45:37] Deptrans ID: 682902 telah diproses [2026-01-26 11:45:37] HTTP Status Code: 200 [2026-01-26 11:45:37] Response: [{"success":true}] [2026-01-26 11:45:37] Deptrans ID: 682903 telah diproses [2026-01-26 11:45:38] HTTP Status Code: 200 [2026-01-26 11:45:38] Response: [{"success":true}] [2026-01-26 11:45:38] Deptrans ID: 682904 telah diproses [2026-01-26 11:45:38] HTTP Status Code: 200 [2026-01-26 11:45:38] Response: [{"success":true}] [2026-01-26 11:45:38] Deptrans ID: 682905 telah diproses [2026-01-26 11:45:39] HTTP Status Code: 200 [2026-01-26 11:45:39] Response: [{"success":true}] [2026-01-26 11:45:39] Deptrans ID: 682906 telah diproses [2026-01-26 11:45:39] HTTP Status Code: 200 [2026-01-26 11:45:39] Response: [{"success":true}] [2026-01-26 11:45:39] Deptrans ID: 682907 telah diproses [2026-01-26 11:45:40] HTTP Status Code: 200 [2026-01-26 11:45:40] Response: [{"success":true}] [2026-01-26 11:45:40] Deptrans ID: 682908 telah diproses [2026-01-26 11:45:41] HTTP Status Code: 200 [2026-01-26 11:45:41] Response: [{"success":true}] [2026-01-26 11:45:41] Deptrans ID: 682909 telah diproses [2026-01-26 11:45:41] HTTP Status Code: 200 [2026-01-26 11:45:41] Response: [{"success":true}] [2026-01-26 11:45:41] Deptrans ID: 682911 telah diproses [2026-01-26 11:45:42] HTTP Status Code: 200 [2026-01-26 11:45:42] Response: [{"success":true}] [2026-01-26 11:45:42] Deptrans ID: 682912 telah diproses [2026-01-26 11:45:42] HTTP Status Code: 200 [2026-01-26 11:45:42] Response: [{"success":true}] [2026-01-26 11:45:42] Deptrans ID: 682913 telah diproses [2026-01-26 11:45:43] HTTP Status Code: 200 [2026-01-26 11:45:43] Response: [{"success":true}] [2026-01-26 11:45:43] Deptrans ID: 682914 telah diproses [2026-01-26 11:45:43] HTTP Status Code: 200 [2026-01-26 11:45:43] Response: [{"success":true}] [2026-01-26 11:45:43] Deptrans ID: 682915 telah diproses [2026-01-26 11:45:43] Total Processed Row: 78 | Last deptrans_id: 682915 [2026-01-26 11:45:43] ======== END PROCESS ========