11/09/2021 21:44:51 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_reconv_c_reconversion
METODO: ProcesarReconversionCxc
ERROR:
Invalid query: ERROR: relation "cxc_dt_movfondos" does not exist LINE 181: UPDATE cxc_dt_movfondos ^ Whole query: UPDATE cxc_anticipos SET monant=monant/1000000; UPDATE cxc_anticipos SET tascam=tascam/1000000 WHERE tascam!=1; UPDATE cxc_anticipos SET tascamref=tascamref/1000000 WHERE tascamref!=1; UPDATE cxc_clientes SET fondogar=fondogar/1000000; UPDATE cxc_cmp_ret SET totcmp_sin_iva=totcmp_sin_iva/1000000, totcmp_con_iva=totcmp_con_iva/1000000, basimp=basimp/1000000, monimp=monimp/1000000, monret=monret/1000000; UPDATE cxc_cmp_ret SET tascam=tascam/1000000 WHERE tascam!=1; /* UPDATE cxc_comipromo SET subtotcom=subtotcom/1000000, baseimpcom=baseimpcom/1000000, montodesccom=montodesccom/1000000, ivatotcom=ivatotcom/1000000, montotcom=montotcom/1000000; UPDATE cxc_comipromo_det SET subcomdet=subcomdet/1000000, baseimpcomdet=baseimpcomdet/1000000, montodesccomdet=montodesccomdet/1000000, ivacomdet=ivacomdet/1000000, moncomdet=moncomdet/1000000; */ UPDATE cxc_cotiza_pedidos SET montodesc=montodesc/1000000, saldo=saldo/1000000, subtot=subtot/1000000, iva=iva/1000000, otros=otros/1000000, baseimp=baseimp/1000000, total=total/1000000, tarifa_carga=tarifa_carga/1000000, monflete_carga=monflete_carga/1000000 ; UPDATE cxc_cotiza_pedidos SET tascam=tascam/1000000 WHERE tascam!=1; UPDATE cxc_detalle SET precio_detalle=precio_detalle/1000000, desc_detalle=desc_detalle/1000000, iva_detalle=iva_detalle/1000000, neto_detalle=neto_detalle/1000000, otros_detalle=otros_detalle/1000000, precioneto_detalle=precioneto_detalle/1000000, costprom=costprom/1000000, precompra=precompra/1000000, otroscost=otroscost/1000000, ultcosto=ultcosto/1000000, prevena=prevena/1000000, prevenb=prevenb/1000000, prevenc=prevenc/1000000, prevend=prevend/1000000, preciocompraa=preciocompraa/1000000, preciocomprab=preciocomprab/1000000, preciocomprac=preciocomprac/1000000, preciocomprad=preciocomprad/1000000, cxcprecompa=cxcprecompa/1000000, cxcprecompb=cxcprecompb/1000000, cxcprecompc=cxcprecompc/1000000, cxcprecompd=cxcprecompd/1000000; UPDATE cxc_documento SET montodesc_doc=montodesc_doc/1000000, saldo_doc=saldo_doc/1000000, subtot_doc=subtot_doc/1000000, iva_doc=iva_doc/1000000, otros_doc=otros_doc/1000000, baseimp_doc=baseimp_doc/1000000, total_doc=total_doc/1000000, subtotservidoc=subtotservidoc/1000000, subtotproddoc=subtotproddoc/1000000, subtotconcedoc=subtotconcedoc/1000000; UPDATE cxc_documento SET tascam_doc=tascam_doc/1000000 WHERE tascam_doc!=1; UPDATE cxc_documento SET tascamref=tascamref/1000000 WHERE tascamref!=1; UPDATE cxc_dt_anticipos SET montodesc=montodesc/1000000; UPDATE cxc_dt_anticipos SET tascamref=tascamref/1000000 WHERE tascamref!=1; UPDATE cxc_dt_cargos SET monbasimp=monbasimp/1000000, monimp=monimp/1000000, montot=montot/1000000; UPDATE cxc_dt_cargos_cotped SET monbasimp=monbasimp/1000000, monimp=monimp/1000000, montot=montot/1000000; UPDATE cxc_dt_cotiza_pedidos SET precio_detalle=precio_detalle/1000000, desc_detalle=desc_detalle/1000000, iva_detalle=iva_detalle/1000000, neto_detalle=neto_detalle/1000000, otros_detalle=otros_detalle/1000000, precioneto_detalle=precioneto_detalle/1000000; UPDATE cxc_dt_documento SET precio_detdoc=precio_detdoc/1000000, desc_detdoc=desc_detdoc/1000000, iva_detdoc=iva_detdoc/1000000, neto_detdoc=neto_detdoc/1000000, otros_detdoc=otros_detdoc/1000000, precioneto_detdoc=precioneto_detdoc/1000000, costprom_detdoc=costprom_detdoc/1000000, precompra_detdoc=precompra_detdoc/1000000, otroscost_detdoc=otroscost_detdoc/1000000, ultcosto_detdoc=ultcosto_detdoc/1000000, tarifa_calculo=tarifa_calculo/1000000; UPDATE cxc_dt_movcobro SET monmovcob=monmovcob/1000000, monmovcobcomp=monmovcobcomp/1000000, moncobret=moncobret/1000000, moncobant=moncobant/1000000, moncobnc=moncobnc/1000000, moncobotros=moncobotros/1000000, moncobfon=moncobfon/1000000; UPDATE cxc_dt_movcobro SET tascam=tascam/1000000 WHERE tascam!=1; UPDATE cxc_dt_movcobro SET tascamref=tascamref/1000000 WHERE tascamref!=1; UPDATE cxc_dt_movcobro SET tascamtransac=tascamtransac/1000000 WHERE tascamtransac!=1; UPDATE cxc_dt_movdoc SET monmovdoc=monmovdoc/1000000; UPDATE cxc_dt_movdoc SET tascam=tascam/1000000 WHERE tascam!=1; UPDATE cxc_dt_movdoc SET tascamref=tascamref/1000000 WHERE tascamref!=1; UPDATE cxc_dt_movfondos SET monmovfon=monmovfon/1000000; UPDATE cxc_dt_scg SET monto=monto/1000000; UPDATE cxc_dt_spg SET monto=monto/1000000; UPDATE cxc_dt_spi SET monto=monto/1000000; UPDATE cxc_factura SET montodesc=montodesc/1000000, saldo=saldo/1000000, subtot=subtot/1000000, iva=iva/1000000, otros=otros/1000000, baseimp=baseimp/1000000, total=total/1000000, total_tarifas=total_tarifas/1000000, total_tasas=total_tasas/1000000, total_otros_ingresos=total_otros_ingresos/1000000, total_comisiones=total_comisiones/1000000, aero_fare=aero_fare/1000000, aero_eqfare=aero_eqfare/1000000, aero_cobticket=aero_cobticket/1000000, aero_baseimp=aero_baseimp/1000000, aero_totexento=aero_totexento/1000000, aero_exento_cupones=aero_exento_cupones/1000000, tarifa_carga=tarifa_carga/1000000, monflete_carga=monflete_carga/1000000, subtotservi=subtotservi/1000000, subtotprod=subtotprod/1000000, subtotconce=subtotconce/1000000 ; UPDATE cxc_factura SET tascam=tascam/1000000 WHERE tascam!=1; UPDATE cxc_factura SET tascamref=tascamref/1000000 WHERE tascamref!=1; UPDATE cxc_ingresos SET moning=moning/1000000, moncomp=moncomp/1000000, moningret=moningret/1000000, moningant=moningant/1000000, moningnc=moningnc/1000000, moningotros=moningotros/1000000, cmpret_totbasimp=cmpret_totbasimp/1000000, cmpret_totimp=cmpret_totimp/1000000, cmpret_totret=cmpret_totret/1000000, moningdifcamb=moningdifcamb/1000000, moningacob=moningacob/1000000; UPDATE cxc_ingresos SET tascam=tascam/1000000 WHERE tascam!=1; UPDATE cxc_ingresos SET tascamref=tascamref/1000000 WHERE tascamref!=1; UPDATE cxc_ingresos SET tascamtransac=tascamtransac/1000000 WHERE tascamtransac!=1; /* UPDATE cxc_mov_fondos_comerciales SET monmovcom=monmovcom/1000000, monrefmov=monrefmov/1000000; */ UPDATE cxc_mov_ventas SET total=total/1000000, totalnograb=totalnograb/1000000, baseimp=baseimp/1000000, monimp=monimp/1000000, ivaret=ivaret/1000000, ivaper=ivaper/1000000; UPDATE cxc_productos_cliente SET precli=precli/1000000; UPDATE cxc_tarifas_servicios SET montarifa=montarifa/1000000;