16/02/2021 05:41:06  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldoEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  syntax error at or near "m"
LINE 5:           m.fectranage<'2021-02-01' 
                  ^
Whole query:  SELECT sum(monmovcob) as saldo 
						  FROM aero_ctlage_dt_transacciones m							
						 WHERE m.fectranage<='2021-02-01'
						   AND m.codemisor='89500375'							 
						    m.fectranage<'2021-02-01' 

16/02/2021 05:42:00  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldoEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  column "monmovcob" does not exist
LINE 1:  SELECT sum(monmovcob) as saldo 
                    ^
Whole query:  SELECT sum(monmovcob) as saldo 
						  FROM aero_ctlage_dt_transacciones m							
						 WHERE m.codemisor='89500375'							 
						    AND m.fectranage<'2021-02-01' 

16/02/2021 17:40:22  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>VALIDACIÓN DE DATOS:</b><br> Faltan datos para poder buscar el saldo del emisor. 				           			    
					<br><b>METODO:</b> SaldosMonedaEmisor 

16/02/2021 22:24:51  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  syntax error at or near "FROM"
LINE 10:          FROM scb_movbco m
                  ^
Whole query: 
							SELECT  m.codban, m.codban, m.ctaban, m.numdoc, m.codope, m.estmov, m.cod_pro, m.ced_bene, 
									m.tipo_destino, m.codconmov, m.fecmov, m.conmov, m.nomproben, m.monto as montoloc, m.estbpd,
									m.procede, m.comprobante, m.fecha, m.nroestcta, m.nromovestcta,
									m.codmon, m.tascam,m.nroestcta,m.nromovestcta,m.facturado,
									m.cxc_id_fact, m.cxc_codsuc, m.cxc_codcaj, m.cxc_nroing, 
									m.cxc_tipdoc, m.cxc_id_doc, m.cxc_nromovcob,m.codemisor,
									b.*, c.*,f.numfact,f.numcont,f.fecfact,
									round(m.monto/m.tascam,2) as monto,
							  FROM scb_movbco m
						      LEFT JOIN scb_banco b ON m.codemp=b.codemp
												 AND m.codban=b.codban 
							  LEFT JOIN scb_ctabanco c ON m.codemp=c.codemp
													  AND m.codban=c.codban 
													  AND m.ctaban=c.ctaban
							  LEFT JOIN cxc_factura f ON m.cxc_id_fact=f.id_fact													 
							  WHERE m.codemp='0001'
								 AND m.codban = '100'  AND m.ctaban = 'EFEC-001                 '  AND m.codemisor = 'PA196300' 
							   ORDER BY m.fecmov, m.numdoc
							  LIMIT 30
					  

16/02/2021 22:26:16  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_soa_c_aero <br><b>METODO:</b> ConsultaSaldosMonedaEmisor <br><b>ERROR-></b><br>Invalid query: ERROR:  function round(double precision, integer) does not exist
LINE 9:          round(m.monto/m.tascam,2) as monto
                 ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
Whole query: 
							SELECT  m.codban, m.codban, m.ctaban, m.numdoc, m.codope, m.estmov, m.cod_pro, m.ced_bene, 
									m.tipo_destino, m.codconmov, m.fecmov, m.conmov, m.nomproben, m.monto as montoloc, m.estbpd,
									m.procede, m.comprobante, m.fecha, m.nroestcta, m.nromovestcta,
									m.codmon, m.tascam,m.nroestcta,m.nromovestcta,m.facturado,
									m.cxc_id_fact, m.cxc_codsuc, m.cxc_codcaj, m.cxc_nroing, 
									m.cxc_tipdoc, m.cxc_id_doc, m.cxc_nromovcob,m.codemisor,
									b.*, c.*,f.numfact,f.numcont,f.fecfact,
									round(m.monto/m.tascam,2) as monto
							  FROM scb_movbco m
						      LEFT JOIN scb_banco b ON m.codemp=b.codemp
												 AND m.codban=b.codban 
							  LEFT JOIN scb_ctabanco c ON m.codemp=c.codemp
													  AND m.codban=c.codban 
													  AND m.ctaban=c.ctaban
							  LEFT JOIN cxc_factura f ON m.cxc_id_fact=f.id_fact													 
							  WHERE m.codemp='0001'
								 AND m.codban = '100'  AND m.ctaban = 'EFEC-001                 '  AND m.codemisor = 'PA196300' 
							   ORDER BY m.fecmov, m.numdoc
							  LIMIT 30