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;