14/10/2021 15:59:45  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cre_c_creditos <br><b>METODO:</b> CalcularMoraPagoPrestamo <br><b>ERROR-></b><br>Invalid query: ERROR:  column "moncapital" does not exist
LINE 11:             moncapital,
                     ^
Whole query:  SELECT COALESCE(sum(monintmora),0) AS montotintmora,
				                   MAX(diasmora) AS diasmora
				            FROM
							(
								SELECT id_prestamo,
									   id_amortiza,
									   nrocuota,
									   tasacuo,
									   tasamoracuo,
									   feccalmora,
									   moncapital,
									   monintcuota,
									   moncobcap,
									   moncobintmora,
									   COALESCE(('2021-10-14' - feccalmora),0) AS diasmora,
									   round((CASE WHEN id_cartera=2 THEN
									  		 COALESCE(((((tasamoracuo+tasacuo)*(moncapital-moncobcap)/100)/360)*('2021-10-14' - feccalmora)-moncobintmora),0)
									   ELSE
									         COALESCE((((tasamoracuo*(moncapital-moncobcap)/100)/360)*('2021-10-14' - feccalmora)-moncobintmora),0)
									   END)::numeric,4) as monintmora
								FROM(
									SELECT 
										   dt.id_prestamo,
										   dt.id_amortiza,
										   dt.nrocuota,
										   dt.tasacuo,
										   dt.tasamoracuo,
										   dt.moncapital*(pre.tascam/pre.tasaidi),
										   dt.monintcuota*(pre.tascam/pre.tasaidi),
										   s.id_cartera,
										   dt.feccuota AS feccalmora,
											(
											    SELECT COALESCE(sum(mc.moncobcap*(mc.tascam/mc.tasaidi)),0)				
												FROM cre_dt_movcobro mc 
												INNER JOIN cre_ingresos i ON i.id_suc = mc.id_suc  
															 AND i.id_caja = mc.id_caja 
															 AND i.nroing = mc.nroing
												 WHERE i.fecing<='2021-10-14'						   
												   AND mc.id_doc=dt.id_prestamo
												   AND mc.nrocuota=dt.nrocuota
												   AND tipdoc='CUOTA' 
												   AND estmovcob!='ANU'
											) AS moncobcap,
											(
											    SELECT COALESCE(sum(mc.moncobintmora*(mc.tascam/mc.tasaidi)),0)				
												FROM cre_dt_movcobro mc 
												INNER JOIN cre_ingresos i ON i.id_suc = mc.id_suc  
															 AND i.id_caja = mc.id_caja 
															 AND i.nroing = mc.nroing
												 WHERE i.fecing<='2021-10-14'						   
												   AND mc.id_doc=dt.id_prestamo
												   AND mc.nrocuota=dt.nrocuota
												   AND tipdoc='CUOTA' 
												   AND estmovcob!='ANU'
											) AS moncobintmora
									 FROM cre_prestamo_dt_amortizacion dt 
									INNER JOIN cre_prestamo_amortizacion a ON a.id_prestamo=dt.id_prestamo
																          AND a.id_amortiza=dt.id_amortiza
									INNER JOIN cre_prestamo pre ON pre.id_prestamo=a.id_prestamo
									INNER JOIN cre_estpagocuota ep ON ep.estpagcuo=dt.estpagcuo				
									INNER JOIN cre_solicitud s ON pre.id_solicitud=s.id_solicitud	
									INNER JOIN cre_estprestamo epre ON epre.estpre=pre.estpre
									WHERE dt.feccuota<'2021-10-14'
									  AND dt.estpagcuo NOT IN ('PAGA','NOEX')
									  AND dt.id_prestamo='1'									  
									  AND a.amortactivo = 1
									  AND pre.estpre!='ANU'
									  AND dt.moncuota >0
								) AS mora
								ORDER BY id_prestamo, id_amortiza, nrocuota
							 ) AS moratotal
							

14/10/2021 15:59:45  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cre_c_creditos <br><b>METODO:</b> CalcularMoraPagoPrestamo <br><b>ERROR-></b><br>Invalid query: ERROR:  column "moncapital" does not exist
LINE 11:             moncapital,
                     ^
Whole query:  SELECT COALESCE(sum(monintmora),0) AS montotintmora,
				                   MAX(diasmora) AS diasmora
				            FROM
							(
								SELECT id_prestamo,
									   id_amortiza,
									   nrocuota,
									   tasacuo,
									   tasamoracuo,
									   feccalmora,
									   moncapital,
									   monintcuota,
									   moncobcap,
									   moncobintmora,
									   COALESCE(('2021-10-14' - feccalmora),0) AS diasmora,
									   round((CASE WHEN id_cartera=2 THEN
									  		 COALESCE(((((tasamoracuo+tasacuo)*(moncapital-moncobcap)/100)/360)*('2021-10-14' - feccalmora)-moncobintmora),0)
									   ELSE
									         COALESCE((((tasamoracuo*(moncapital-moncobcap)/100)/360)*('2021-10-14' - feccalmora)-moncobintmora),0)
									   END)::numeric,4) as monintmora
								FROM(
									SELECT 
										   dt.id_prestamo,
										   dt.id_amortiza,
										   dt.nrocuota,
										   dt.tasacuo,
										   dt.tasamoracuo,
										   dt.moncapital*(pre.tascam/pre.tasaidi),
										   dt.monintcuota*(pre.tascam/pre.tasaidi),
										   s.id_cartera,
										   dt.feccuota AS feccalmora,
											(
											    SELECT COALESCE(sum(mc.moncobcap*(mc.tascam/mc.tasaidi)),0)				
												FROM cre_dt_movcobro mc 
												INNER JOIN cre_ingresos i ON i.id_suc = mc.id_suc  
															 AND i.id_caja = mc.id_caja 
															 AND i.nroing = mc.nroing
												 WHERE i.fecing<='2021-10-14'						   
												   AND mc.id_doc=dt.id_prestamo
												   AND mc.nrocuota=dt.nrocuota
												   AND tipdoc='CUOTA' 
												   AND estmovcob!='ANU'
											) AS moncobcap,
											(
											    SELECT COALESCE(sum(mc.moncobintmora*(mc.tascam/mc.tasaidi)),0)				
												FROM cre_dt_movcobro mc 
												INNER JOIN cre_ingresos i ON i.id_suc = mc.id_suc  
															 AND i.id_caja = mc.id_caja 
															 AND i.nroing = mc.nroing
												 WHERE i.fecing<='2021-10-14'						   
												   AND mc.id_doc=dt.id_prestamo
												   AND mc.nrocuota=dt.nrocuota
												   AND tipdoc='CUOTA' 
												   AND estmovcob!='ANU'
											) AS moncobintmora
									 FROM cre_prestamo_dt_amortizacion dt 
									INNER JOIN cre_prestamo_amortizacion a ON a.id_prestamo=dt.id_prestamo
																          AND a.id_amortiza=dt.id_amortiza
									INNER JOIN cre_prestamo pre ON pre.id_prestamo=a.id_prestamo
									INNER JOIN cre_estpagocuota ep ON ep.estpagcuo=dt.estpagcuo				
									INNER JOIN cre_solicitud s ON pre.id_solicitud=s.id_solicitud	
									INNER JOIN cre_estprestamo epre ON epre.estpre=pre.estpre
									WHERE dt.feccuota<'2021-10-14'
									  AND dt.estpagcuo NOT IN ('PAGA','NOEX')
									  AND dt.id_prestamo='1'									  
									  AND a.amortactivo = 1
									  AND pre.estpre!='ANU'
									  AND dt.moncuota >0
								) AS mora
								ORDER BY id_prestamo, id_amortiza, nrocuota
							 ) AS moratotal
							

14/10/2021 16:02:30  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cre_c_creditos <br><b>METODO:</b> CalcularMoraPagoPrestamo <br><b>ERROR-></b><br>Invalid query: ERROR:  column "moncapital" does not exist
LINE 11:             moncapital,
                     ^
Whole query:  SELECT COALESCE(sum(monintmora),0) AS montotintmora,
				                   MAX(diasmora) AS diasmora
				            FROM
							(
								SELECT id_prestamo,
									   id_amortiza,
									   nrocuota,
									   tasacuo,
									   tasamoracuo,
									   feccalmora,
									   moncapital,
									   monintcuota,
									   moncobcap,
									   moncobintmora,
									   COALESCE(('2021-10-14' - feccalmora),0) AS diasmora,
									   round((CASE WHEN id_cartera=2 THEN
									  		 COALESCE(((((tasamoracuo+tasacuo)*(moncapital-moncobcap)/100)/360)*('2021-10-14' - feccalmora)-moncobintmora),0)
									   ELSE
									         COALESCE((((tasamoracuo*(moncapital-moncobcap)/100)/360)*('2021-10-14' - feccalmora)-moncobintmora),0)
									   END)::numeric,4) as monintmora
								FROM(
									SELECT 
										   dt.id_prestamo,
										   dt.id_amortiza,
										   dt.nrocuota,
										   dt.tasacuo,
										   dt.tasamoracuo,
										   dt.moncapital*(pre.tascam/pre.tasaidi),
										   dt.monintcuota*(pre.tascam/pre.tasaidi),
										   s.id_cartera,
										   dt.feccuota AS feccalmora,
											(
											    SELECT COALESCE(sum(mc.moncobcap*(mc.tascam/mc.tasaidi)),0)				
												FROM cre_dt_movcobro mc 
												INNER JOIN cre_ingresos i ON i.id_suc = mc.id_suc  
															 AND i.id_caja = mc.id_caja 
															 AND i.nroing = mc.nroing
												 WHERE i.fecing<='2021-10-14'						   
												   AND mc.id_doc=dt.id_prestamo
												   AND mc.nrocuota=dt.nrocuota
												   AND tipdoc='CUOTA' 
												   AND estmovcob!='ANU'
											) AS moncobcap,
											(
											    SELECT COALESCE(sum(mc.moncobintmora*(mc.tascam/mc.tasaidi)),0)				
												FROM cre_dt_movcobro mc 
												INNER JOIN cre_ingresos i ON i.id_suc = mc.id_suc  
															 AND i.id_caja = mc.id_caja 
															 AND i.nroing = mc.nroing
												 WHERE i.fecing<='2021-10-14'						   
												   AND mc.id_doc=dt.id_prestamo
												   AND mc.nrocuota=dt.nrocuota
												   AND tipdoc='CUOTA' 
												   AND estmovcob!='ANU'
											) AS moncobintmora
									 FROM cre_prestamo_dt_amortizacion dt 
									INNER JOIN cre_prestamo_amortizacion a ON a.id_prestamo=dt.id_prestamo
																          AND a.id_amortiza=dt.id_amortiza
									INNER JOIN cre_prestamo pre ON pre.id_prestamo=a.id_prestamo
									INNER JOIN cre_estpagocuota ep ON ep.estpagcuo=dt.estpagcuo				
									INNER JOIN cre_solicitud s ON pre.id_solicitud=s.id_solicitud	
									INNER JOIN cre_estprestamo epre ON epre.estpre=pre.estpre
									WHERE dt.feccuota<'2021-10-14'
									  AND dt.estpagcuo NOT IN ('PAGA','NOEX')
									  AND dt.id_prestamo='1'									  
									  AND a.amortactivo = 1
									  AND pre.estpre!='ANU'
									  AND dt.moncuota >0
								) AS mora
								ORDER BY id_prestamo, id_amortiza, nrocuota
							 ) AS moratotal
							

14/10/2021 16:02:30  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cre_c_creditos <br><b>METODO:</b> CalcularMoraPagoPrestamo <br><b>ERROR-></b><br>Invalid query: ERROR:  column "moncapital" does not exist
LINE 11:             moncapital,
                     ^
Whole query:  SELECT COALESCE(sum(monintmora),0) AS montotintmora,
				                   MAX(diasmora) AS diasmora
				            FROM
							(
								SELECT id_prestamo,
									   id_amortiza,
									   nrocuota,
									   tasacuo,
									   tasamoracuo,
									   feccalmora,
									   moncapital,
									   monintcuota,
									   moncobcap,
									   moncobintmora,
									   COALESCE(('2021-10-14' - feccalmora),0) AS diasmora,
									   round((CASE WHEN id_cartera=2 THEN
									  		 COALESCE(((((tasamoracuo+tasacuo)*(moncapital-moncobcap)/100)/360)*('2021-10-14' - feccalmora)-moncobintmora),0)
									   ELSE
									         COALESCE((((tasamoracuo*(moncapital-moncobcap)/100)/360)*('2021-10-14' - feccalmora)-moncobintmora),0)
									   END)::numeric,4) as monintmora
								FROM(
									SELECT 
										   dt.id_prestamo,
										   dt.id_amortiza,
										   dt.nrocuota,
										   dt.tasacuo,
										   dt.tasamoracuo,
										   dt.moncapital*(pre.tascam/pre.tasaidi),
										   dt.monintcuota*(pre.tascam/pre.tasaidi),
										   s.id_cartera,
										   dt.feccuota AS feccalmora,
											(
											    SELECT COALESCE(sum(mc.moncobcap*(mc.tascam/mc.tasaidi)),0)				
												FROM cre_dt_movcobro mc 
												INNER JOIN cre_ingresos i ON i.id_suc = mc.id_suc  
															 AND i.id_caja = mc.id_caja 
															 AND i.nroing = mc.nroing
												 WHERE i.fecing<='2021-10-14'						   
												   AND mc.id_doc=dt.id_prestamo
												   AND mc.nrocuota=dt.nrocuota
												   AND tipdoc='CUOTA' 
												   AND estmovcob!='ANU'
											) AS moncobcap,
											(
											    SELECT COALESCE(sum(mc.moncobintmora*(mc.tascam/mc.tasaidi)),0)				
												FROM cre_dt_movcobro mc 
												INNER JOIN cre_ingresos i ON i.id_suc = mc.id_suc  
															 AND i.id_caja = mc.id_caja 
															 AND i.nroing = mc.nroing
												 WHERE i.fecing<='2021-10-14'						   
												   AND mc.id_doc=dt.id_prestamo
												   AND mc.nrocuota=dt.nrocuota
												   AND tipdoc='CUOTA' 
												   AND estmovcob!='ANU'
											) AS moncobintmora
									 FROM cre_prestamo_dt_amortizacion dt 
									INNER JOIN cre_prestamo_amortizacion a ON a.id_prestamo=dt.id_prestamo
																          AND a.id_amortiza=dt.id_amortiza
									INNER JOIN cre_prestamo pre ON pre.id_prestamo=a.id_prestamo
									INNER JOIN cre_estpagocuota ep ON ep.estpagcuo=dt.estpagcuo				
									INNER JOIN cre_solicitud s ON pre.id_solicitud=s.id_solicitud	
									INNER JOIN cre_estprestamo epre ON epre.estpre=pre.estpre
									WHERE dt.feccuota<'2021-10-14'
									  AND dt.estpagcuo NOT IN ('PAGA','NOEX')
									  AND dt.id_prestamo='1'									  
									  AND a.amortactivo = 1
									  AND pre.estpre!='ANU'
									  AND dt.moncuota >0
								) AS mora
								ORDER BY id_prestamo, id_amortiza, nrocuota
							 ) AS moratotal