11/07/2021 22:10:20  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> ConsultaIngresosCajaInvalid query: ERROR:  missing FROM-clause entry for table "mot"
LINE 155:              mot.abrmon as abrmontransac,
                       ^
Whole query: SELECT    'ING' AS tipotrans,
					            ing.fecing AS fecmov,
					            ing.codemp AS codemp, 
								ing.codsuc AS codsuc, 
								ing.codcaj AS codcaj, 
								ing.nroing AS nroing, 
								ing.id_cliente AS id_cliente, 
								'PROC' AS esting, 
								ing.fecing AS fecing, 
								ing.codforpag AS codforpag, 
								ing.codmon AS codmon, 
								ing.tascam AS tascam,								
								ing.moning AS moning,
								ing.moncomp AS moncomp,
								ing.moningret AS moningret,
								ing.moningant AS moningant,
								ing.moningnc AS moningnc,
								ing.moningotros AS moningotros,
								ing.moningdifcamb AS moningdifcamb,
								ing.moningacob AS moningacob,
								ing.nrodocpag AS nrodocpag, 
								ing.nroconform AS nroconform, 
								ing.codbancli AS codbancli, 
								ing.nroctabancli AS nroctabancli, 
								ing.fecdocing AS fecdocing, 
								ing.nacpering AS nacpering, 
								ing.cedpering AS cedpering, 
								ing.codban AS codban, 
								ing.ctaban AS ctaban, 
								ing.obsing AS obsing, 
								ing.fecreg AS fecreg, 
								ing.usureg AS usureg, 
								ing.horareg AS horareg,
								ing.fecanuing AS fecanuing, 
								ing.conanuing AS conanuing,							  
								ing.codconanuing AS codconanuing, 
								ing.noafecing AS noafecing, 
								ing.ingcmpret AS ingcmpret,							
								ing.aero_ticket AS aero_ticket, 
								ing.id_fact_ticket AS id_fact_ticket, 
								ing.codmonref AS codmonref, 
								ing.tascamref AS tascamref,
								c.id_cliente AS id_cliente,
								c.nombre_cliente AS nombre_cliente,
								c.codcliente AS codcliente,
								suc.coduniejesuc AS coduniejesuc,
								mo.abrmon AS abrmon,
								mo.denmon AS denmon,
								fp.denforpag AS denforpag,
								suc.sigsuc AS sigsuc,
								u.sigunicosto AS sigunicosto,
								ei.descesting AS descesting,
								cbe.codban AS codban, 
								cbe.ctaban AS ctaban, 
								cbe.codtipcta AS codtipcta, 
								cbe.ctabanext AS ctabanext, 
								cbe.dencta AS dencta, 
								be.codsudeban AS codsudeban,
								b.nomban AS nombancli,
								be.nomban AS nombanemp,
								ing.codmontransac AS codmontransac, 
								ing.tascamtransac AS tascamtransac,								
								ing.moningtransac AS moningtransac,
								mot.abrmon as abrmontransac,
								mot.denmon as denmontransac
							 FROM cxc_ingresos ing     INNER JOIN cxc_formapago fp ON fp.codforpag = ing.codforpag
										  INNER JOIN cxc_sucursales suc ON suc.codemp = ing.codemp 
																	  AND suc.codsuc = ing.codsuc
										  INNER JOIN cxc_esting ei ON ei.esting = ing.esting															  
										  INNER JOIN cxc_cajas caj ON caj.codemp = ing.codemp 
																	 AND caj.codsuc = ing.codsuc
																	 AND caj.codcaj = ing.codcaj
										  LEFT JOIN cxc_clientes c ON c.id_cliente = ing.id_cliente 
										  LEFT JOIN sigesp_moneda mo ON ing.codmon = mo.codmon	
										  LEFT JOIN sigesp_moneda mot ON ing.codmontransac = mot.codmon											  
										  LEFT JOIN cxc_bancos b ON b.codban = ing.codbancli 
										  LEFT JOIN scb_banco be ON be.codemp = ing.codemp AND be.codban = ing.codban 
										  LEFT JOIN scb_ctabanco cbe ON cbe.codemp = ing.codemp AND cbe.codban = ing.codban AND cbe.ctaban = ing.ctaban 							   
										  LEFT JOIN spg_unidadadministrativa u ON u.coduniadm = suc.coduniejesuc
										  WHERE ing.codemp='0001' 									  
										   AND ing.fecing BETWEEN '2021-07-11' AND '2021-07-11'    AND ing.codmontransac = 'AWG'  AND  ing.codsuc IN (
											SELECT pint.codintper
											  FROM sss_permisos_internos pint
											 WHERE pint.codemp='0001' 
											   AND pint.codusu='ADMINISTRADOR' 
											   AND pint.codsis='CXC'
											   AND trim(pint.codintper)=trim(ing.codsuc)
				                         )
		              AND (ing.aero_ticket='' OR ing.aero_ticket IS NULL) AND ing.id_fact_ticket=0  
										  UNION ALL
										  SELECT   
										            'ANU ING' AS tipotrans,
													ing.fecanuing AS fecmov,
													ing.codemp AS codemp, 
													ing.codsuc AS codsuc, 
													ing.codcaj AS codcaj, 
													ing.nroing AS nroing, 
													ing.id_cliente AS id_cliente, 
													ing.esting AS esting, 
													ing.fecing AS fecing, 
													ing.codforpag AS codforpag, 
													ing.codmon AS codmon, 
													ing.tascam AS tascam,								
													-ing.moning AS moning,
													-ing.moncomp AS moncomp,
													-ing.moningret AS moningret,
													-ing.moningant AS moningant,
													-ing.moningnc AS moningnc,
													-ing.moningotros AS moningotros,
													-ing.moningdifcamb AS moningdifcamb,
													-ing.moningacob AS moningacob,
													ing.nrodocpag AS nrodocpag, 
													ing.nroconform AS nroconform, 
													ing.codbancli AS codbancli, 
													ing.nroctabancli AS nroctabancli, 
													ing.fecdocing AS fecdocing, 
													ing.nacpering AS nacpering, 
													ing.cedpering AS cedpering, 
													ing.codban AS codban, 
													ing.ctaban AS ctaban, 
													ing.obsing AS obsing, 
													ing.fecreg AS fecreg, 
													ing.usureg AS usureg, 
													ing.horareg AS horareg,
													ing.fecanuing AS fecanuing, 
													ing.conanuing AS conanuing,							  
													ing.codconanuing AS codconanuing, 
													ing.noafecing AS noafecing, 
													ing.ingcmpret AS ingcmpret,							
													ing.aero_ticket AS aero_ticket, 
													ing.id_fact_ticket AS id_fact_ticket, 
													ing.codmonref AS codmonref, 
													ing.tascamref AS tascamref,
													c.id_cliente AS id_cliente,
													c.nombre_cliente AS nombre_cliente,
													c.codcliente AS codcliente,
													suc.coduniejesuc AS coduniejesuc,
													mo.abrmon AS abrmon,
													mo.denmon AS denmon,
													fp.denforpag AS denforpag,
													suc.sigsuc AS sigsuc,
													u.sigunicosto AS sigunicosto,
													ei.descesting AS descesting,
													cbe.codban AS codban, 
													cbe.ctaban AS ctaban, 
													cbe.codtipcta AS codtipcta, 
													cbe.ctabanext AS ctabanext, 
													cbe.dencta AS dencta, 
													be.codsudeban AS codsudeban,
													b.nomban AS nombancli,
													be.nomban AS nombanemp,
													ing.codmontransac AS codmontransac, 
													ing.tascamtransac AS tascamtransac,								
													-ing.moningtransac AS moningtransac,
													mot.abrmon as abrmontransac,
													mot.denmon as denmontransac
										             
										  FROM cxc_ingresos ing 
										  INNER JOIN cxc_formapago fp ON fp.codforpag = ing.codforpag
										  INNER JOIN cxc_sucursales suc ON suc.codemp = ing.codemp 
																	  AND suc.codsuc = ing.codsuc
										  INNER JOIN cxc_esting ei ON ei.esting = ing.esting															  
										  INNER JOIN cxc_cajas caj ON caj.codemp = ing.codemp 
																	 AND caj.codsuc = ing.codsuc
																	 AND caj.codcaj = ing.codcaj
										  LEFT JOIN cxc_clientes c ON c.id_cliente = ing.id_cliente 
										  LEFT JOIN sigesp_moneda mo ON ing.codmon = mo.codmon	 	
										  LEFT JOIN cxc_bancos b ON b.codban = ing.codbancli 
										  LEFT JOIN scb_banco be ON be.codemp = ing.codemp AND be.codban = ing.codban 
										  LEFT JOIN scb_ctabanco cbe ON cbe.codemp = ing.codemp AND cbe.codban = ing.codban AND cbe.ctaban = ing.ctaban 							   
										  LEFT JOIN spg_unidadadministrativa u ON u.coduniadm = suc.coduniejesuc
										  WHERE ing.codemp='0001'
										    AND ing.esting = 'ANU' 									  
										   AND ing.fecanuing BETWEEN '2021-07-11' AND '2021-07-11'    AND ing.codmontransac = 'AWG'  AND  ing.codsuc IN (
											SELECT pint.codintper
											  FROM sss_permisos_internos pint
											 WHERE pint.codemp='0001' 
											   AND pint.codusu='ADMINISTRADOR' 
											   AND pint.codsis='CXC'
											   AND trim(pint.codintper)=trim(ing.codsuc)
				                         )
		              AND (ing.aero_ticket='' OR ing.aero_ticket IS NULL) AND ing.id_fact_ticket=0 
										  ORDER BY fecmov,codsuc,codcaj,nroing 
								    

11/07/2021 23:09:01  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cxc_c_reportes <br><b>METODO:</b> ConsultaMovimientosIngresoMonedaTransac <br><b>ERROR-></b><br>Invalid query: ERROR:  operator does not exist: double precision // double precision
LINE 34:           (((moncobfon//mc.tascam)*i.tascam)/i.tascamtransac...
                               ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
Whole query:  							
															
								SELECT  
									   'COB FACT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecmovcob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										f.numfact AS numdoc,           
										mc.codforpag AS codforpag,
										mc.codmontransac AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob, 
										suc.sigsuc as sigsuc,
										mc.usureg AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,										
										(((monmovcob/mc.tascam)*i.tascam)/i.tascamtransac) as moncobtot,
										(((moncobret/mc.tascam)*i.tascam)/i.tascamtransac) as moncobret,
										(((moncobant/mc.tascam)*i.tascam)/i.tascamtransac) as moncobant,
										(((moncobnc/mc.tascam)*i.tascam)/i.tascamtransac) as moncobnc,
										(((moncobotros/mc.tascam)*i.tascam)/i.tascamtransac) as moncobotros,
										(((moncobfon//mc.tascam)*i.tascam)/i.tascamtransac) as moncobfon
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
														 AND i.codsuc = mc.codsuc  
														 AND i.codcaj = mc.codcaj 
														 AND i.nroing = mc.nroing
								INNER JOIN cxc_factura f ON f.codemp = mc.codemp 
														AND f.id_fact = mc.id_doc
								LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp 
														AND suc.codsuc = f.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp   
													   AND caj.codsuc = f.codsuc
													   AND caj.codcaj = f.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
								INNER JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
								INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmontransac
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE mc.fecmovcob BETWEEN '2021-07-11' AND '2021-07-11'
								   AND mc.tipdoc='FACT'
								  AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							  AND mc.tascamtransac = 'USD'  AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0 
								UNION ALL
								SELECT  
									    'ANU COB FACT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecanucob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										f.numfact AS numdoc,           
										mc.codforpag AS codforpag,
										mc.codmontransac AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob,
										suc.sigsuc as sigsuc,
										mc.usureganu AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,	
										-(((monmovcob/mc.tascam)*i.tascam)/i.tascamtransac) as moncobtot,
										-(((moncobret/mc.tascam)*i.tascam)/i.tascamtransac) as moncobret,
										-(((moncobant/mc.tascam)*i.tascam)/i.tascamtransac) as moncobant,
										-(((moncobnc/mc.tascam)*i.tascam)/i.tascamtransac) as moncobnc,
										-(((moncobotros/mc.tascam)*i.tascam)/i.tascamtransac) as moncobotros,
										-(((moncobfon//mc.tascam)*i.tascam)/i.tascamtransac) as moncobfon										
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
											 AND i.codsuc = mc.codsuc  
											 AND i.codcaj = mc.codcaj 
											 AND i.nroing = mc.nroing
								INNER JOIN cxc_factura f ON f.codemp = mc.codemp 
														AND f.id_fact = mc.id_doc
								LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp 
														AND suc.codsuc = f.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp 
												   AND caj.codsuc = f.codsuc
												   AND caj.codcaj = f.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
								INNER JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
								INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmontransac
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE mc.fecanucob BETWEEN '2021-07-11' AND '2021-07-11'
								   AND mc.estmovcob='ANU'
								   AND tipdoc='FACT'
								    AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							  AND mc.tascamtransac = 'USD'  AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0 
								UNION ALL
								SELECT  
									   'COB ANT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecmovcob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										a.nroant AS numdoc,           
										mc.codforpag AS codforpag,
										mc.codmontransac AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob,
										suc.sigsuc as sigsuc,
										mc.usureg AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,		
										(((monmovcob/mc.tascam)*i.tascam)/i.tascamtransac) as moncobtot,
										(((moncobret/mc.tascam)*i.tascam)/i.tascamtransac) as moncobret,
										(((moncobant/mc.tascam)*i.tascam)/i.tascamtransac) as moncobant,
										(((moncobnc/mc.tascam)*i.tascam)/i.tascamtransac) as moncobnc,
										(((moncobotros/mc.tascam)*i.tascam)/i.tascamtransac) as moncobotros,
										(((moncobfon//mc.tascam)*i.tascam)/i.tascamtransac) as moncobfon
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
											 AND i.codsuc = mc.codsuc  
											 AND i.codcaj = mc.codcaj 
											 AND i.nroing = mc.nroing
								INNER JOIN cxc_anticipos a ON a.codemp = mc.codemp 
											  AND a.idant = mc.id_doc
								INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
								LEFT JOIN cxc_sucursales suc ON suc.codemp = i.codemp 
												AND suc.codsuc = i.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = i.codemp 
											   AND caj.codsuc = i.codsuc
											AND caj.codcaj = i.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc			
								INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmontransac
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE  mc.fecmovcob BETWEEN '2021-07-11' AND '2021-07-11'
								    AND mc.tipdoc='ANTI'
								    AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							  AND mc.tascamtransac = 'USD'  AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0 
								UNION ALL
								SELECT  
									    'ANU COB ANT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecanucob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										a.nroant AS numdoc,           
										mc.codforpag AS codforpag,
										mc.codmontransac AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob,
										suc.sigsuc as sigsuc,
										mc.usureganu AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,
										-(((monmovcob/mc.tascam)*i.tascam)/i.tascamtransac) as moncobtot,
										-(((moncobret/mc.tascam)*i.tascam)/i.tascamtransac) as moncobret,
										-(((moncobant/mc.tascam)*i.tascam)/i.tascamtransac) as moncobant,
										-(((moncobnc/mc.tascam)*i.tascam)/i.tascamtransac) as moncobnc,
										-(((moncobotros/mc.tascam)*i.tascam)/i.tascamtransac) as moncobotros,
										-(((moncobfon//mc.tascam)*i.tascam)/i.tascamtransac) as moncobfon										
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
											 AND i.codsuc = mc.codsuc  
											 AND i.codcaj = mc.codcaj 
											 AND i.nroing = mc.nroing
								INNER JOIN cxc_anticipos a ON a.codemp = mc.codemp 
											  AND a.idant = mc.id_doc
								INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
								LEFT JOIN cxc_sucursales suc ON suc.codemp = i.codemp 
												AND suc.codsuc = i.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = i.codemp 
											   AND caj.codsuc = i.codsuc
											AND caj.codcaj = i.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmontransac
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE  mc.fecanucob BETWEEN '2021-07-11' AND '2021-07-11'
								   AND mc.tipdoc='ANTI'
								   AND mc.estmovcob='ANU'
								    AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							  AND mc.tascamtransac = 'USD'  AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0 
								ORDER BY 14,8,4,5,7
							

11/07/2021 23:09:52  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_cxc_c_reportes <br><b>METODO:</b> ConsultaMovimientosIngresoMonedaTransac <br><b>ERROR-></b><br>Invalid query: ERROR:  invalid input syntax for type double precision: "USD"
LINE 62:          AND mc.tascamtransac = 'USD'  AND (i.aero_ticket=''...
                                         ^
Whole query:  							
															
								SELECT  
									   'COB FACT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecmovcob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										f.numfact AS numdoc,           
										mc.codforpag AS codforpag,
										mc.codmontransac AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob, 
										suc.sigsuc as sigsuc,
										mc.usureg AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,										
										(((monmovcob/mc.tascam)*i.tascam)/i.tascamtransac) as moncobtot,
										(((moncobret/mc.tascam)*i.tascam)/i.tascamtransac) as moncobret,
										(((moncobant/mc.tascam)*i.tascam)/i.tascamtransac) as moncobant,
										(((moncobnc/mc.tascam)*i.tascam)/i.tascamtransac) as moncobnc,
										(((moncobotros/mc.tascam)*i.tascam)/i.tascamtransac) as moncobotros,
										(((moncobfon/mc.tascam)*i.tascam)/i.tascamtransac) as moncobfon
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
														 AND i.codsuc = mc.codsuc  
														 AND i.codcaj = mc.codcaj 
														 AND i.nroing = mc.nroing
								INNER JOIN cxc_factura f ON f.codemp = mc.codemp 
														AND f.id_fact = mc.id_doc
								LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp 
														AND suc.codsuc = f.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp   
													   AND caj.codsuc = f.codsuc
													   AND caj.codcaj = f.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
								INNER JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
								INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmontransac
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE mc.fecmovcob BETWEEN '2021-07-11' AND '2021-07-11'
								   AND mc.tipdoc='FACT'
								  AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							  AND mc.tascamtransac = 'USD'  AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0 
								UNION ALL
								SELECT  
									    'ANU COB FACT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecanucob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										f.numfact AS numdoc,           
										mc.codforpag AS codforpag,
										mc.codmontransac AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob,
										suc.sigsuc as sigsuc,
										mc.usureganu AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,	
										-(((monmovcob/mc.tascam)*i.tascam)/i.tascamtransac) as moncobtot,
										-(((moncobret/mc.tascam)*i.tascam)/i.tascamtransac) as moncobret,
										-(((moncobant/mc.tascam)*i.tascam)/i.tascamtransac) as moncobant,
										-(((moncobnc/mc.tascam)*i.tascam)/i.tascamtransac) as moncobnc,
										-(((moncobotros/mc.tascam)*i.tascam)/i.tascamtransac) as moncobotros,
										-(((moncobfon/mc.tascam)*i.tascam)/i.tascamtransac) as moncobfon										
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
											 AND i.codsuc = mc.codsuc  
											 AND i.codcaj = mc.codcaj 
											 AND i.nroing = mc.nroing
								INNER JOIN cxc_factura f ON f.codemp = mc.codemp 
														AND f.id_fact = mc.id_doc
								LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp 
														AND suc.codsuc = f.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp 
												   AND caj.codsuc = f.codsuc
												   AND caj.codcaj = f.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
								INNER JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
								INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmontransac
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE mc.fecanucob BETWEEN '2021-07-11' AND '2021-07-11'
								   AND mc.estmovcob='ANU'
								   AND tipdoc='FACT'
								    AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							  AND mc.tascamtransac = 'USD'  AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0 
								UNION ALL
								SELECT  
									   'COB ANT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecmovcob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										a.nroant AS numdoc,           
										mc.codforpag AS codforpag,
										mc.codmontransac AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob,
										suc.sigsuc as sigsuc,
										mc.usureg AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,		
										(((monmovcob/mc.tascam)*i.tascam)/i.tascamtransac) as moncobtot,
										(((moncobret/mc.tascam)*i.tascam)/i.tascamtransac) as moncobret,
										(((moncobant/mc.tascam)*i.tascam)/i.tascamtransac) as moncobant,
										(((moncobnc/mc.tascam)*i.tascam)/i.tascamtransac) as moncobnc,
										(((moncobotros/mc.tascam)*i.tascam)/i.tascamtransac) as moncobotros,
										(((moncobfon/mc.tascam)*i.tascam)/i.tascamtransac) as moncobfon
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
											 AND i.codsuc = mc.codsuc  
											 AND i.codcaj = mc.codcaj 
											 AND i.nroing = mc.nroing
								INNER JOIN cxc_anticipos a ON a.codemp = mc.codemp 
											  AND a.idant = mc.id_doc
								INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
								LEFT JOIN cxc_sucursales suc ON suc.codemp = i.codemp 
												AND suc.codsuc = i.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = i.codemp 
											   AND caj.codsuc = i.codsuc
											AND caj.codcaj = i.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc			
								INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmontransac
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE  mc.fecmovcob BETWEEN '2021-07-11' AND '2021-07-11'
								    AND mc.tipdoc='ANTI'
								    AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							  AND mc.tascamtransac = 'USD'  AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0 
								UNION ALL
								SELECT  
									    'ANU COB ANT' AS tipmov,
										c.id_cliente AS id_cliente,
										c.nombre_cliente AS nombre_cliente,
										mc.codsuc AS codsuc,
										mc.codcaj AS codcaj,
										suc.coduniejesuc AS coduniejesuc,
										mc.nroing AS nroing,
										mc.fecanucob AS fecmov,
										mc.nromovcob AS nromovcob,
										mc.tipdoc AS tipdoc,
										mc.id_doc AS id_doc,              
										a.nroant AS numdoc,           
										mc.codforpag AS codforpag,
										mc.codmontransac AS codmon,
										mo.abrmon AS abrmon,
										mo.denmon AS denmon, 
										fp.denforpag AS denforpag,
										mc.conanucob AS conanucob,
										suc.sigsuc as sigsuc,
										mc.usureganu AS usureg,
										c.codcliente AS codcliente,
										uadm.sigunicosto,
										mc.obscob AS obscob,
										mc.codban AS codban,
										mc.ctaban AS ctaban,
										-(((monmovcob/mc.tascam)*i.tascam)/i.tascamtransac) as moncobtot,
										-(((moncobret/mc.tascam)*i.tascam)/i.tascamtransac) as moncobret,
										-(((moncobant/mc.tascam)*i.tascam)/i.tascamtransac) as moncobant,
										-(((moncobnc/mc.tascam)*i.tascam)/i.tascamtransac) as moncobnc,
										-(((moncobotros/mc.tascam)*i.tascam)/i.tascamtransac) as moncobotros,
										-(((moncobfon/mc.tascam)*i.tascam)/i.tascamtransac) as moncobfon										
								FROM cxc_dt_movcobro mc 
								INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
											 AND i.codsuc = mc.codsuc  
											 AND i.codcaj = mc.codcaj 
											 AND i.nroing = mc.nroing
								INNER JOIN cxc_anticipos a ON a.codemp = mc.codemp 
											  AND a.idant = mc.id_doc
								INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
								LEFT JOIN cxc_sucursales suc ON suc.codemp = i.codemp 
												AND suc.codsuc = i.codsuc
								LEFT JOIN cxc_cajas caj ON caj.codemp = i.codemp 
											   AND caj.codsuc = i.codsuc
											AND caj.codcaj = i.codcaj
								LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
								INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmontransac
								INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
								 WHERE  mc.fecanucob BETWEEN '2021-07-11' AND '2021-07-11'
								   AND mc.tipdoc='ANTI'
								   AND mc.estmovcob='ANU'
								    AND  mc.codsuc IN (
													SELECT pint.codintper
													  FROM sss_permisos_internos pint
													 WHERE pint.codemp='0001' 
													   AND pint.codusu='ADMINISTRADOR' 
													   AND pint.codsis='CXC'
													   AND trim(pint.codintper)=trim(i.codsuc)
												 )
							  AND mc.tascamtransac = 'USD'  AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0 
								ORDER BY 14,8,4,5,7