24/09/2021 22:26:54  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> consulta_facturasInvalid query: ERROR:  column f.id_buque does not exist
LINE 112: ...) /*AND tc.clievent=0*/  AND f.id_estfact!=7  AND f.id_buque...
                                                               ^
Whole query: SELECT   f.*, c.*,f.id_vend as id_vendfact, v.nomvend, v.codvend, codtransp, desctransp, denmon, abrmon, desccondpago, cp.diascred as diascredito, 
					            descestfact,cp.operacion as opespi,
								tc.tipo_cliente, tc.tipo_cliente,ctlcontauto,tc.aplautodoc,
					            suc.nomsuc,suc.sucmatriz,caj.nomcaj,caj.scg_cuenta as scg_caja,caj.estcaj,suc.sigsuc,
								(now()::date - f.fecfact) as diasemifact, 
								cp.diascred as diascredfact,
								cdoc.codcliente as codcliente_doc, 
								cdoc.nombre_cliente as nombre_cliente_doc, t.*,
								'('||succl.codsuccli||') - '||succl.nomsuccli AS descsuccli,
							    (CASE WHEN (cp.diascred - (now()::date - f.fecfact)::integer)::integer<0 AND f.id_estfact!=4 AND cp.operacion='DEV'  
									   THEN abs((cp.diascred - (now()::date - f.fecfact)::integer)::integer)
								 ELSE 0
								 END) as diasvencfact,
								 (
									SELECT COALESCE(SUM(doc.total_doc),0) 
									  FROM cxc_documento doc 
									 WHERE doc.id_fact = f.id_fact
									   AND codtipdoc = 'NC'
									   AND anulado_doc = '0'	       
								) AS total_cre,
								(
									SELECT COALESCE(SUM(doc.total_doc),0) 
									  FROM cxc_documento doc 
									 WHERE doc.id_fact = f.id_fact
									   AND codtipdoc = 'ND'
									   AND anulado_doc = '0'	       
								) AS total_deb,
								(
									  f.total 
									  -
									  ( SELECT COALESCE(SUM(doc.total_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'NC'
										   AND anulado_doc = '0'
									   )
									   + 
									   (
										SELECT COALESCE(SUM(doc.total_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'ND'
										   AND anulado_doc = '0'	       
									   ) 
								) AS total_act,
								(
									  f.subtot 
									  -
									  ( SELECT COALESCE(SUM(doc.subtot_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'NC'
										   AND anulado_doc = '0' 
									   )
									   + 
									   (
										SELECT COALESCE(SUM(doc.subtot_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'ND'
										   AND anulado_doc = '0'	       
									   ) 
								) AS subtot_act,
								(
									  f.iva 
									  -
									  ( SELECT COALESCE(SUM(doc.iva_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'NC'
										   AND anulado_doc = '0' 
									   )
									   + 
									   (
										SELECT COALESCE(SUM(doc.iva_doc),0) 
										  FROM cxc_documento doc 
										 WHERE doc.id_fact = f.id_fact
										   AND codtipdoc = 'ND'
										   AND anulado_doc = '0'	       
									   ) 
								) AS iva_act,
								f.usureg as usuario_regfact
							   FROM cxc_factura f 
									  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
									  LEFT JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
									  LEFT JOIN cxc_vendedores v ON v.id_vend = f.id_vend
									  LEFT JOIN cxc_transporte t ON t.id_transp = f.id_transp
									  LEFT JOIN sigesp_moneda mo ON f.codmon = mo.codmon
									  LEFT JOIN cxc_condiciones_pago cp ON cp.id_condpago = f.id_condpago
									  LEFT JOIN cxc_estatus_factura es ON es.id_estfact = f.id_estfact
									  LEFT JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
									  LEFT JOIN cxc_zonas z ON z.id_zona = c.id_zona
									  LEFT JOIN cxc_clasif_clientes cc ON cc.id_clasif_cliente = c.id_clasif_cliente
									  LEFT JOIN cxc_vendedores vc ON vc.id_vend = c.id_vend
									  LEFT JOIN scg_cuentas cu ON cu.codemp = c.codemp AND cu.sc_cuenta = c.sc_cuenta AND status='C'
									  LEFT JOIN sigesp_pais p ON p.codpai = c.codpai
									  LEFT JOIN sigesp_estados e ON e.codpai = c.codpai AND e.codest = c.codest 
									  LEFT JOIN sigesp_municipio m ON m.codpai = c.codpai AND m.codest = c.codest AND m.codmun = c.codmun
									  LEFT JOIN sigesp_parroquia pa ON pa.codpai = c.codpai AND pa.codest = c.codest AND pa.codmun = c.codmun AND pa.codpar = c.codpar
									  LEFT JOIN cxc_clientes cdoc ON cdoc.id_cliente = f.id_cliente_doc
									  LEFT JOIN cxc_sucursales_clientes succl ON succl.id_cliente = f.id_cliente
			                                                                 AND succl.codsuccli = f.codsuccli
									  WHERE f.codemp = '0001'
									    AND f.codproceso='FACTURA' 
									    AND f.descripfact ILIKE('%%')	
									    AND f.comentadifact ILIKE('%%')	
									   AND f.fecfact BETWEEN '2021-09-09' AND '2021-09-24'   AND (f.nro_ticket='' OR f.nro_ticket IS NULL) /*AND tc.clievent=0*/  AND f.id_estfact!=7  AND f.id_buque = '47'  AND  f.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(f.codsuc)
				                         )
		                ORDER BY  numfact