>[Error] Script lines: 168-168 ----------------------
 ERROR: null value in column "counter" violates not-null constraint
  Detail: Failing row contains (e21fd0993dafada0d621b7a14891589f, hm_oem001_id3, 202009, 81759e0fe7be989f1363cedf344b96af, ITP/2020-0007, 2020-08-26, [email protected], null, null, Tunjangan, null, null, null, null, null, null, null, null, null, , null, 0, [email protected], 2020-08-26 15:02:51.669277, [email protected], 2020-08-26 15:02:51.669277).
  Where: SQL statement "INSERT INTO hm_opy017
			(	id, hm_oem001_karyawan_id, tahun_bulan_gaji,
				ref_byr_trx_prs_id, ref_byr_trx_prs_number, ref_byr_trx_prs_date, ref_byr_trx_prs_user,
				counter, tanggal_bayar, jenis_pembayaran, metode_pembayaran,
				hm_msd007_bank_id, nomor_rekening, nama_rekening,
				nilai_awal, koreksi_thp_tunai, nilai_akhir,
				tanggal_transfer,
				ref_e_payroll_trx_prs_id, ref_e_payroll_trx_prs_number, ref_e_payroll_trx_prs_date,
				version, user_create, creation_time, user_modify, modification_time )
		SELECT	public.sys_guid(), A.hm_oem001_karyawan_id, A.tahun_bulan_gaji,
				A.hm_msy015_ref_prs_id, A.ref_prs_number, A.ref_prs_date, A.ref_prs_user,
				B.counter, A.tanggal, A.jenis_pembayaran, B.metode_pembayaran,
				B.hm_msd007_bank_id, B.nomor_rekening, B.nama_rekening,
				B.nilai_awal, B.koreksi_thp_tunai, B.nilai_akhir,
				null,
				null, '', null,
				0, PUserName, NOW(), PUserName, NOW()
		FROM	update_summary_penghasilan_t001 A
      	LEFT JOIN update_summary_penghasilan_t077 B ON A.process_id = B.process_id AND A.hm_oem001_karyawan_id = B.hm_oem001_karyawan_id AND
   													   A.tahun_bulan_gaji = B.tahun_bulan_gaji
   		WHERE	A.process_id = PProcessId"
PL/pgSQL function public.spupdatesummarypenghasilan_180(character varying,character varying,date,character varying,boolean,character varying) line 114 at SQL statement
PL/pgSQL function public.spupdatesummarypenghasilan(character varying,character varying,date,character varying,boolean,character varying) line 88 at EXECUTE
 Line: 1