[2026-01-17 13:35:09] ======== START PROCESS ======== [2026-01-17 13:35:09] Last deptrans_id: 677694 [2026-01-17 13:35:09] 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 > 677694 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-17 13:35:09] Total Rows query.sql : 89 [2026-01-17 13:35:10] HTTP Status Code: 200 [2026-01-17 13:35:10] Response: [{"success":true}] [2026-01-17 13:35:10] Deptrans ID: 677699 telah diproses [2026-01-17 13:35:11] HTTP Status Code: 200 [2026-01-17 13:35:11] Response: [{"success":true}] [2026-01-17 13:35:11] Deptrans ID: 677702 telah diproses [2026-01-17 13:35:11] HTTP Status Code: 200 [2026-01-17 13:35:11] Response: [{"success":true}] [2026-01-17 13:35:11] Deptrans ID: 677714 telah diproses [2026-01-17 13:35:12] HTTP Status Code: 200 [2026-01-17 13:35:12] Response: [{"success":true}] [2026-01-17 13:35:12] Deptrans ID: 677744 telah diproses [2026-01-17 13:35:12] HTTP Status Code: 200 [2026-01-17 13:35:12] Response: [{"success":true}] [2026-01-17 13:35:12] Deptrans ID: 677750 telah diproses [2026-01-17 13:35:13] HTTP Status Code: 200 [2026-01-17 13:35:13] Response: [{"success":true}] [2026-01-17 13:35:13] Deptrans ID: 677754 telah diproses [2026-01-17 13:35:13] HTTP Status Code: 200 [2026-01-17 13:35:13] Response: [{"success":true}] [2026-01-17 13:35:13] Deptrans ID: 677760 telah diproses [2026-01-17 13:35:14] HTTP Status Code: 200 [2026-01-17 13:35:14] Response: [{"success":true}] [2026-01-17 13:35:14] Deptrans ID: 677766 telah diproses [2026-01-17 13:35:15] HTTP Status Code: 200 [2026-01-17 13:35:15] Response: [{"success":true}] [2026-01-17 13:35:15] Deptrans ID: 677770 telah diproses [2026-01-17 13:35:15] HTTP Status Code: 200 [2026-01-17 13:35:15] Response: [{"success":true}] [2026-01-17 13:35:15] Deptrans ID: 677774 telah diproses [2026-01-17 13:35:16] HTTP Status Code: 200 [2026-01-17 13:35:16] Response: [{"success":true}] [2026-01-17 13:35:16] Deptrans ID: 677778 telah diproses [2026-01-17 13:35:16] HTTP Status Code: 200 [2026-01-17 13:35:16] Response: [{"success":true}] [2026-01-17 13:35:16] Deptrans ID: 677784 telah diproses [2026-01-17 13:35:17] HTTP Status Code: 200 [2026-01-17 13:35:17] Response: [{"success":true}] [2026-01-17 13:35:17] Deptrans ID: 677788 telah diproses [2026-01-17 13:35:17] HTTP Status Code: 200 [2026-01-17 13:35:17] Response: [{"success":true}] [2026-01-17 13:35:17] Deptrans ID: 677813 telah diproses [2026-01-17 13:35:18] HTTP Status Code: 200 [2026-01-17 13:35:18] Response: [{"success":true}] [2026-01-17 13:35:18] Deptrans ID: 677817 telah diproses [2026-01-17 13:35:18] HTTP Status Code: 200 [2026-01-17 13:35:18] Response: [{"success":true}] [2026-01-17 13:35:18] Deptrans ID: 677821 telah diproses [2026-01-17 13:35:19] HTTP Status Code: 200 [2026-01-17 13:35:19] Response: [{"success":true}] [2026-01-17 13:35:19] Deptrans ID: 677837 telah diproses [2026-01-17 13:35:20] HTTP Status Code: 200 [2026-01-17 13:35:20] Response: [{"success":true}] [2026-01-17 13:35:20] Deptrans ID: 677843 telah diproses [2026-01-17 13:35:20] HTTP Status Code: 200 [2026-01-17 13:35:20] Response: [{"success":true}] [2026-01-17 13:35:20] Deptrans ID: 677855 telah diproses [2026-01-17 13:35:21] HTTP Status Code: 200 [2026-01-17 13:35:21] Response: [{"success":true}] [2026-01-17 13:35:21] Deptrans ID: 677865 telah diproses [2026-01-17 13:35:21] HTTP Status Code: 200 [2026-01-17 13:35:21] Response: [{"success":true}] [2026-01-17 13:35:21] Deptrans ID: 677871 telah diproses [2026-01-17 13:35:22] HTTP Status Code: 200 [2026-01-17 13:35:22] Response: [{"success":true}] [2026-01-17 13:35:22] Deptrans ID: 677875 telah diproses [2026-01-17 13:35:22] HTTP Status Code: 200 [2026-01-17 13:35:22] Response: [{"success":true}] [2026-01-17 13:35:22] Deptrans ID: 677883 telah diproses [2026-01-17 13:35:23] HTTP Status Code: 200 [2026-01-17 13:35:23] Response: [{"success":true}] [2026-01-17 13:35:23] Deptrans ID: 677895 telah diproses [2026-01-17 13:35:23] HTTP Status Code: 200 [2026-01-17 13:35:23] Response: [{"success":true}] [2026-01-17 13:35:23] Deptrans ID: 677909 telah diproses [2026-01-17 13:35:24] HTTP Status Code: 200 [2026-01-17 13:35:24] Response: [{"success":true}] [2026-01-17 13:35:24] Deptrans ID: 677923 telah diproses [2026-01-17 13:35:25] HTTP Status Code: 200 [2026-01-17 13:35:25] Response: [{"success":true}] [2026-01-17 13:35:25] Deptrans ID: 677927 telah diproses [2026-01-17 13:35:25] HTTP Status Code: 200 [2026-01-17 13:35:25] Response: [{"success":true}] [2026-01-17 13:35:25] Deptrans ID: 677959 telah diproses [2026-01-17 13:35:26] HTTP Status Code: 200 [2026-01-17 13:35:26] Response: [{"success":true}] [2026-01-17 13:35:26] Deptrans ID: 677963 telah diproses [2026-01-17 13:35:26] HTTP Status Code: 200 [2026-01-17 13:35:26] Response: [{"success":true}] [2026-01-17 13:35:26] Deptrans ID: 677977 telah diproses [2026-01-17 13:35:27] HTTP Status Code: 200 [2026-01-17 13:35:27] Response: [{"success":true}] [2026-01-17 13:35:27] Deptrans ID: 677991 telah diproses [2026-01-17 13:35:27] HTTP Status Code: 200 [2026-01-17 13:35:27] Response: [{"success":true}] [2026-01-17 13:35:27] Deptrans ID: 678011 telah diproses [2026-01-17 13:35:28] HTTP Status Code: 200 [2026-01-17 13:35:28] Response: [{"success":true}] [2026-01-17 13:35:28] Deptrans ID: 678041 telah diproses [2026-01-17 13:35:28] HTTP Status Code: 200 [2026-01-17 13:35:28] Response: [{"success":true}] [2026-01-17 13:35:28] Deptrans ID: 678045 telah diproses [2026-01-17 13:35:29] HTTP Status Code: 200 [2026-01-17 13:35:29] Response: [{"success":true}] [2026-01-17 13:35:29] Deptrans ID: 678049 telah diproses [2026-01-17 13:35:30] HTTP Status Code: 200 [2026-01-17 13:35:30] Response: [{"success":true}] [2026-01-17 13:35:30] Deptrans ID: 678053 telah diproses [2026-01-17 13:35:30] HTTP Status Code: 200 [2026-01-17 13:35:30] Response: [{"success":true}] [2026-01-17 13:35:30] Deptrans ID: 678060 telah diproses [2026-01-17 13:35:31] HTTP Status Code: 200 [2026-01-17 13:35:31] Response: [{"success":true}] [2026-01-17 13:35:31] Deptrans ID: 678072 telah diproses [2026-01-17 13:35:31] HTTP Status Code: 200 [2026-01-17 13:35:31] Response: [{"success":true}] [2026-01-17 13:35:31] Deptrans ID: 678118 telah diproses [2026-01-17 13:35:32] HTTP Status Code: 200 [2026-01-17 13:35:32] Response: [{"success":true}] [2026-01-17 13:35:32] Deptrans ID: 678122 telah diproses [2026-01-17 13:35:32] HTTP Status Code: 200 [2026-01-17 13:35:32] Response: [{"success":true}] [2026-01-17 13:35:32] Deptrans ID: 678126 telah diproses [2026-01-17 13:35:33] HTTP Status Code: 200 [2026-01-17 13:35:33] Response: [{"success":true}] [2026-01-17 13:35:33] Deptrans ID: 678137 telah diproses [2026-01-17 13:35:33] HTTP Status Code: 200 [2026-01-17 13:35:33] Response: [{"success":true}] [2026-01-17 13:35:33] Deptrans ID: 678141 telah diproses [2026-01-17 13:35:34] HTTP Status Code: 200 [2026-01-17 13:35:34] Response: [{"success":true}] [2026-01-17 13:35:34] Deptrans ID: 678145 telah diproses [2026-01-17 13:35:35] HTTP Status Code: 200 [2026-01-17 13:35:35] Response: [{"success":true}] [2026-01-17 13:35:35] Deptrans ID: 678179 telah diproses [2026-01-17 13:35:35] HTTP Status Code: 200 [2026-01-17 13:35:35] Response: [{"success":true}] [2026-01-17 13:35:35] Deptrans ID: 678183 telah diproses [2026-01-17 13:35:36] HTTP Status Code: 200 [2026-01-17 13:35:36] Response: [{"success":true}] [2026-01-17 13:35:36] Deptrans ID: 678201 telah diproses [2026-01-17 13:35:36] HTTP Status Code: 200 [2026-01-17 13:35:36] Response: [{"success":true}] [2026-01-17 13:35:36] Deptrans ID: 678225 telah diproses [2026-01-17 13:35:37] HTTP Status Code: 200 [2026-01-17 13:35:37] Response: [{"success":true}] [2026-01-17 13:35:37] Deptrans ID: 678229 telah diproses [2026-01-17 13:35:37] HTTP Status Code: 200 [2026-01-17 13:35:37] Response: [{"success":true}] [2026-01-17 13:35:37] Deptrans ID: 678235 telah diproses [2026-01-17 13:35:38] HTTP Status Code: 200 [2026-01-17 13:35:38] Response: [{"success":true}] [2026-01-17 13:35:38] Deptrans ID: 678243 telah diproses [2026-01-17 13:35:38] HTTP Status Code: 200 [2026-01-17 13:35:38] Response: [{"success":true}] [2026-01-17 13:35:38] Deptrans ID: 678254 telah diproses [2026-01-17 13:35:39] HTTP Status Code: 200 [2026-01-17 13:35:39] Response: [{"success":true}] [2026-01-17 13:35:39] Deptrans ID: 678262 telah diproses [2026-01-17 13:35:40] HTTP Status Code: 200 [2026-01-17 13:35:40] Response: [{"success":true}] [2026-01-17 13:35:40] Deptrans ID: 678266 telah diproses [2026-01-17 13:35:40] HTTP Status Code: 200 [2026-01-17 13:35:40] Response: [{"success":true}] [2026-01-17 13:35:40] Deptrans ID: 678270 telah diproses [2026-01-17 13:35:41] HTTP Status Code: 200 [2026-01-17 13:35:41] Response: [{"success":true}] [2026-01-17 13:35:41] Deptrans ID: 678274 telah diproses [2026-01-17 13:35:41] HTTP Status Code: 200 [2026-01-17 13:35:41] Response: [{"success":true}] [2026-01-17 13:35:41] Deptrans ID: 678282 telah diproses [2026-01-17 13:35:42] HTTP Status Code: 200 [2026-01-17 13:35:42] Response: [{"success":true}] [2026-01-17 13:35:42] Deptrans ID: 678288 telah diproses [2026-01-17 13:35:42] HTTP Status Code: 200 [2026-01-17 13:35:42] Response: [{"success":true}] [2026-01-17 13:35:42] Deptrans ID: 678292 telah diproses [2026-01-17 13:35:43] HTTP Status Code: 200 [2026-01-17 13:35:43] Response: [{"success":true}] [2026-01-17 13:35:43] Deptrans ID: 678302 telah diproses [2026-01-17 13:35:43] HTTP Status Code: 200 [2026-01-17 13:35:43] Response: [{"success":true}] [2026-01-17 13:35:43] Deptrans ID: 678308 telah diproses [2026-01-17 13:35:44] HTTP Status Code: 200 [2026-01-17 13:35:44] Response: [{"success":true}] [2026-01-17 13:35:44] Deptrans ID: 678314 telah diproses [2026-01-17 13:35:45] HTTP Status Code: 200 [2026-01-17 13:35:45] Response: [{"success":true}] [2026-01-17 13:35:45] Deptrans ID: 678318 telah diproses [2026-01-17 13:35:45] HTTP Status Code: 200 [2026-01-17 13:35:45] Response: [{"success":true}] [2026-01-17 13:35:45] Deptrans ID: 678326 telah diproses [2026-01-17 13:35:46] HTTP Status Code: 200 [2026-01-17 13:35:46] Response: [{"success":true}] [2026-01-17 13:35:46] Deptrans ID: 678332 telah diproses [2026-01-17 13:35:46] HTTP Status Code: 200 [2026-01-17 13:35:46] Response: [{"success":true}] [2026-01-17 13:35:46] Deptrans ID: 678336 telah diproses [2026-01-17 13:35:47] HTTP Status Code: 200 [2026-01-17 13:35:47] Response: [{"success":true}] [2026-01-17 13:35:47] Deptrans ID: 678349 telah diproses [2026-01-17 13:35:47] HTTP Status Code: 200 [2026-01-17 13:35:47] Response: [{"success":true}] [2026-01-17 13:35:47] Deptrans ID: 678355 telah diproses [2026-01-17 13:35:48] HTTP Status Code: 200 [2026-01-17 13:35:48] Response: [{"success":true}] [2026-01-17 13:35:48] Deptrans ID: 678359 telah diproses [2026-01-17 13:35:48] HTTP Status Code: 200 [2026-01-17 13:35:48] Response: [{"success":true}] [2026-01-17 13:35:48] Deptrans ID: 678377 telah diproses [2026-01-17 13:35:49] HTTP Status Code: 200 [2026-01-17 13:35:49] Response: [{"success":true}] [2026-01-17 13:35:49] Deptrans ID: 678387 telah diproses [2026-01-17 13:35:50] HTTP Status Code: 200 [2026-01-17 13:35:50] Response: [{"success":true}] [2026-01-17 13:35:50] Deptrans ID: 678394 telah diproses [2026-01-17 13:35:50] HTTP Status Code: 200 [2026-01-17 13:35:50] Response: [{"success":true}] [2026-01-17 13:35:50] Deptrans ID: 678398 telah diproses [2026-01-17 13:35:51] HTTP Status Code: 200 [2026-01-17 13:35:51] Response: [{"success":true}] [2026-01-17 13:35:51] Deptrans ID: 678410 telah diproses [2026-01-17 13:35:51] HTTP Status Code: 200 [2026-01-17 13:35:51] Response: [{"success":true}] [2026-01-17 13:35:51] Deptrans ID: 678414 telah diproses [2026-01-17 13:35:52] HTTP Status Code: 200 [2026-01-17 13:35:52] Response: [{"success":true}] [2026-01-17 13:35:52] Deptrans ID: 678430 telah diproses [2026-01-17 13:35:52] HTTP Status Code: 200 [2026-01-17 13:35:52] Response: [{"success":true}] [2026-01-17 13:35:52] Deptrans ID: 678446 telah diproses [2026-01-17 13:35:53] HTTP Status Code: 200 [2026-01-17 13:35:53] Response: [{"success":true}] [2026-01-17 13:35:53] Deptrans ID: 678452 telah diproses [2026-01-17 13:35:54] HTTP Status Code: 200 [2026-01-17 13:35:54] Response: [{"success":true}] [2026-01-17 13:35:54] Deptrans ID: 678458 telah diproses [2026-01-17 13:35:54] HTTP Status Code: 200 [2026-01-17 13:35:54] Response: [{"success":true}] [2026-01-17 13:35:54] Deptrans ID: 678468 telah diproses [2026-01-17 13:35:55] HTTP Status Code: 200 [2026-01-17 13:35:55] Response: [{"success":true}] [2026-01-17 13:35:55] Deptrans ID: 678478 telah diproses [2026-01-17 13:35:55] HTTP Status Code: 200 [2026-01-17 13:35:55] Response: [{"success":true}] [2026-01-17 13:35:55] Deptrans ID: 678630 telah diproses [2026-01-17 13:35:56] HTTP Status Code: 200 [2026-01-17 13:35:56] Response: [{"success":true}] [2026-01-17 13:35:56] Deptrans ID: 678631 telah diproses [2026-01-17 13:35:56] HTTP Status Code: 200 [2026-01-17 13:35:56] Response: [{"success":true}] [2026-01-17 13:35:56] Deptrans ID: 678632 telah diproses [2026-01-17 13:35:57] HTTP Status Code: 200 [2026-01-17 13:35:57] Response: [{"success":true}] [2026-01-17 13:35:57] Deptrans ID: 678633 telah diproses [2026-01-17 13:35:57] HTTP Status Code: 200 [2026-01-17 13:35:57] Response: [{"success":true}] [2026-01-17 13:35:57] Deptrans ID: 678634 telah diproses [2026-01-17 13:35:58] HTTP Status Code: 200 [2026-01-17 13:35:58] Response: [{"success":true}] [2026-01-17 13:35:58] Deptrans ID: 678635 telah diproses [2026-01-17 13:35:59] HTTP Status Code: 200 [2026-01-17 13:35:59] Response: [{"success":true}] [2026-01-17 13:35:59] Deptrans ID: 678636 telah diproses [2026-01-17 13:35:59] HTTP Status Code: 200 [2026-01-17 13:35:59] Response: [{"success":true}] [2026-01-17 13:35:59] Deptrans ID: 678637 telah diproses [2026-01-17 13:35:59] Total Processed Row: 89 | Last deptrans_id: 678637 [2026-01-17 13:35:59] ======== END PROCESS ========