DELETE FROM VEN_INFOADICFAC;
DELETE FROM VEN_INFOADICGRE;
DELETE FROM COM_INFOADICLIQ;
DELETE FROM INV_TRNKARDEXOTR;
DELETE FROM ACT_DETKARDEX; 
DELETE FROM ACT_DETSALIDA; 
DELETE FROM ACT_DETTRANSF; 
DELETE FROM ACT_DETVARIOSSAL; 
DELETE FROM ACT_ENCKARDEX; 
DELETE FROM ACT_ENCSALIDA; 
DELETE FROM ACT_ENCTRANSF; 
DELETE FROM ACT_TMPDEPXMES; 
DELETE FROM ACT_TMPOPERACION; 
DELETE FROM ACT_TMPSALIDA; 
DELETE FROM ACT_TMPTRANSFER; 
DELETE FROM ACT_TRNTRANSF; 
DELETE FROM ANEX_ERROR; 
DELETE FROM ANEX_IVA; 
DELETE FROM ANEX_IVACOM;
DELETE FROM ANEX_IVAVEN;
delete from anex_ivavendia;
DELETE FROM ANEX_REGERROR; 
DELETE FROM ANEX_RETENCIONES; 
DELETE FROM ANEXMAR_TMPCOMDEV;
DELETE FROM ANEXMAR_TMPCOMPRAS;
DELETE FROM ANEXMAR_TMPFCVENTAS;
DELETE FROM ANEXMAR_TMPNCVENTAS;
DELETE FROM ANEXMAR_TMPRETCLI;
DELETE FROM ANEXMAR_TMPVENTAS;
delete from articulos;
DELETE FROM ARTICULOS;
DELETE FROM ASIENTO_APERTURA; 
DELETE FROM BAL_DETLIQUIDACION; 
DELETE FROM BAL_ENCFAC; 
DELETE FROM BAL_ENCLIQUIDACION; 
DELETE FROM BAL_MAESUBPRODUCTO; 
DELETE FROM BAL_TMP_TRNPESOPRODUCTO_EXP; 
DELETE FROM BAL_TMPGUIAS; 
DELETE FROM BAL_TMPPROVLIQ; 
DELETE FROM BAL_TMPTRNANALISISPROD_EXP; 
DELETE FROM BAL_TMPTRNCOMPRA_EXP; 
DELETE FROM BAL_TMPTRNDESCUENTO_EMP_EXP; 
DELETE FROM BAL_TMPTRNVENTA_EXP; 
DELETE FROM BAL_TRNANALISISPROD; 
DELETE FROM BAL_TRNCOMPRA; 
DELETE FROM BAL_TRNDESCUENTO_EMP; 
DELETE FROM BAL_TRNDESCUENTO_LEG; 
DELETE FROM BAL_TRNLIQPRESTAMO; 
DELETE FROM BAL_TRNPESOPRODUCTO; 
DELETE FROM BAL_TRNPRESTAMO; 
DELETE FROM BAL_TRNPRESTAMO_LIQ; 
DELETE FROM BAL_TRNVARIOS; 
DELETE FROM BAL_TRNVENTA; 
delete from ban_cuadrecajatemporal;
DELETE FROM BAN_DETCASHMNG; 
DELETE FROM BAN_DETCONCIL; 
DELETE FROM BAN_ENCCASHMNG; 
DELETE FROM BAN_ENCCONCIL; 
DELETE FROM BAN_TMP_CONCILIACIONES;
DELETE FROM BAN_TMP_CONCILIACIONES; 
DELETE FROM BAN_TMP_DEPOSITOS_CHEF; 
DELETE FROM BAN_TMP_SALDOTARJETAS; 
DELETE FROM BAN_TMP_TRNBAN; 
DELETE FROM BAN_TMPCASHMNGMT; 
DELETE FROM BAN_TMPCIERRCAJDET; 
DELETE FROM BAN_TMPCIERRECAJ; 
DELETE FROM BAN_TMPCIERRECAJBOD; 
DELETE FROM BAN_TMPCOMPROBANTEEGRESO; 
DELETE FROM BAN_TMPCONCILIACION; 
DELETE FROM BAN_TMPESTADO; 
DELETE FROM BAN_TMPESTADOCTA_BANCO; 
DELETE FROM BAN_TMPTRNBAN_PV; 
DELETE FROM BAN_TMPTRNCAJ_PV; 
DELETE FROM BAN_TMPTRNCAJDET_PV; 
DELETE FROM BAN_TRNBAN; 
DELETE FROM BAN_TRNBANAJC; 
DELETE FROM BAN_TRNBANAJCDET; 
DELETE FROM BAN_TRNBANAJCVAR; 
DELETE FROM BAN_TRNBANSALDO; 
DELETE FROM BAN_TRNBANVAR; 
DELETE FROM BAN_TRNBANVARIOS; 
DELETE FROM BAN_TRNCAJ; 
DELETE FROM BAN_TRNCAJDET; 
DELETE FROM BAN_TRNCAJVAR; 
DELETE FROM BAN_TRNOTROS; 
DELETE FROM BAN_TRNPARTIDACONCIL; 
DELETE FROM BAN_TRNTARJETA; 
DELETE FROM BAN_TRNTARJETADET; 
DELETE FROM BAN_TRNTARVARIOS; 
DELETE FROM BODEGA_MATRIZ; 
DELETE FROM BODEGA_NORTE; 
DELETE FROM BODEGA_SUR; 
DELETE FROM BODEGA3; 
DELETE FROM CMS_TMPCOMISVENDEDORES;
DELETE FROM CODIGOCONT_BORRAR; 
DELETE FROM COM_ANEXOSIVA; 
commit;
DELETE FROM COM_ARTPROVEEDOR; 
DELETE FROM COM_DESFINANCIEROS; 
DELETE FROM COM_DETDEV; 
DELETE FROM COM_DETFACPRO; 
DELETE FROM COM_DETNOTREC; 
DELETE FROM COM_DETORDCOM; 
DELETE FROM COM_ENCDEV; 
DELETE FROM COM_ENCFACPRO; 
delete from com_encfacpro_tmp;
DELETE FROM COM_ENCNOTREC; 
DELETE FROM COM_ENCORDCOM; 
DELETE FROM COM_MAERETPROV; 
DELETE FROM COM_TMP_INGRESOMERCADERIA; 
DELETE FROM COM_TMP_IVA_RETENCION; 
delete from com_tmp_rptretenciones;
DELETE FROM COM_TMP_VENTASDIARIAS; 
DELETE FROM COM_TMPCOMPYRET;
DELETE FROM COM_TMPDETFACPRO; 
DELETE FROM COM_TMPDETNOTREC; 
DELETE FROM COM_TMPENCFACPRO; 
DELETE FROM COM_TMPENCNOTREC; 
DELETE FROM COM_TMPLIQUIDACION_COMPRAS; 
DELETE FROM COM_TMPMAEPROVEEDOR_BAL; 
DELETE FROM COM_TMPORDEN_COMPRA; 
DELETE FROM COM_TMPRPTRETENCION; 
DELETE FROM COM_TMPTRNPRECIOS; 
DELETE FROM COM_TRNAJUSTECOSTOS; 
DELETE FROM COM_TRNCARGOS; 
delete from COM_TRNNOTRECVAR;
DELETE FROM COM_TRNNOTRECVAR; 
DELETE FROM COM_TRNSERVICIOCC; 
delete from con_asientos_eliminados;
DELETE FROM CON_DETASI_L; 
DELETE FROM CON_DETDEFBAL; 
DELETE FROM CON_DETINDFINAN; 
DELETE FROM CON_ENCASI_L; 
delete from con_encasi_l_integra;
DELETE FROM CON_ENCDEFBAL; 
DELETE FROM CON_ENCINDFINAN; 
DELETE FROM CON_MAECON_TMP; 
DELETE FROM CON_TMP_RETENCIONES_TOTAL;
DELETE FROM CON_TMP_RETENCIONES_TOTAL; 
delete from con_tmpasientocontable;
DELETE FROM CON_TMPASINROBALANCE; 
DELETE FROM CON_TMPBALANCE; 
delete from con_tmpbalance_cons;
DELETE FROM CON_TMPBALANCEC; 
DELETE FROM CON_TMPBALANCEDEF; 
DELETE FROM CON_TMPBALANCER; 
DELETE FROM CON_TMPBALANCER_MENSUAL; 
DELETE FROM CON_TMPDETALLE_ASIENTOS; 
DELETE FROM CON_TMPINDFINAN; 
DELETE FROM CON_TMPINDICESFIN; 
DELETE FROM CON_TMPMAYOR_L; 
delete from con_tmpmayor_l_cons;
DELETE FROM CON_TMPPRESUPUESTO; 
DELETE FROM CON_TRNPEDIDO; 
DELETE FROM COSTOS;
DELETE FROM CUENTASXCOBRAR; 
DELETE FROM CXC_DETCUOTA; 
DELETE FROM CXC_ENCANTICIPO; 
delete from CXC_ENCCUOTA;
DELETE FROM CXC_ENCCUOTA; 
DELETE FROM CXC_TMP_COBROS; 
DELETE FROM CXC_TMP_DEVOLUCIONESEFECTIVO; 
DELETE FROM CXC_TMP_MOVIMIENTOSCXC; 
DELETE FROM CXC_TMP_RPT_CHEQUEPOSFECH; 
delete from cxc_tmp_trnresumen;
delete from cxc_tmpanalisis_vencimiento;
delete from cxc_tmpanalisis_vencimientov;
DELETE FROM CXC_TMPCARTCLIXRNGVCMT; 
DELETE FROM CXC_TMPCARTERA_BODEGA; 
DELETE FROM CXC_TMPCARTERA_CLIENTE; 
DELETE FROM CXC_TMPCARTERA_CLIENTE_LLL; 
DELETE FROM CXC_TMPCHEQUESPOSFECHADO; 
DELETE FROM CXC_TMPCMSVEN; 
DELETE FROM CXC_TMPCOBROS_GRUCLI; 
DELETE FROM CXC_TMPCOMPINGRESO; 
DELETE FROM CXC_TMPCOMPROBANTE_INGRESO; 
DELETE FROM CXC_TMPCTASCBRADAS;
DELETE FROM CXC_TMPESTADOCTA_CLI_GEN; 
delete from cxc_tmpestadocta_clie;
DELETE FROM CXC_TMPESTADOCTA_CLIENTE; 
DELETE FROM CXC_TMPESTADOCTA_CLIENTE_FP; 
DELETE FROM CXC_TMPESTADOCTA_CLIENTE_O; 
DELETE FROM CXC_TMPESTADOCTA_CLIENTE_RPT; 
DELETE FROM CXC_TMPESTADOFAC_CLIENTE; 
DELETE FROM CXC_TMPFORMA_PAGO; 
DELETE FROM CXC_TMPOTROS_COBRAR; 
DELETE FROM CXC_TMPRECIBO_COBRO; 
DELETE FROM CXC_TMPRETCARTACTIVA; 
DELETE FROM CXC_TMPRETENCION; 
commit;

DELETE FROM CXC_TMPRETENCION_COBROS; 
DELETE FROM CXC_TMPSALDODOC; 
DELETE FROM CXC_TMPTRNCOBRO_PV; 
DELETE FROM CXC_TMPTRNCOBRODOC; 
DELETE FROM CXC_TMPTRNCOBROSALDO;
DELETE FROM CXC_TMPTRNCOBROSALDO; 
DELETE FROM CXC_TMPTRNCOBROSALDOCLI; 
DELETE FROM CXC_TMPTRNDOCUMENTO_PV; 
DELETE FROM CXC_TMPTRNPAGO_PV; 
DELETE FROM CXC_TRNBANDOC; 
DELETE FROM CXC_TRNCOBRO; 
DELETE FROM CXC_TRNCOBRO_HISTORICO; 
DELETE FROM CXC_TRNDETCUOTA; 
DELETE FROM CXC_TRNDEVANT; 
DELETE FROM CXC_TRNDOCUMENTO; 
DELETE FROM CXC_TRNPAGO; 
DELETE FROM CXC_TRNPEDIDO; 
delete from cxc_trnresumen;
DELETE FROM CXC_TRNVARIOS; 
DELETE FROM CXP_DETCUOTA; 
delete from cxp_DetTrnCobro;
DELETE FROM CXP_DETTRNCOBRO; 
DELETE FROM CXP_ENCANTICIPO; 
DELETE FROM CXP_ENCCUOTA; 
DELETE FROM CXP_TMP_SALDOPROV;
DELETE FROM CXP_TMP_TRNCOBRO;
DELETE FROM CXP_TMPCARTERA_PROV_LN; 
DELETE FROM CXP_TMPCARTERA_PROVEEDOR; 
DELETE FROM CXP_TMPCARTPROXRNGVCMT; 
delete from cxp_tmpestadocta_pro;
DELETE FROM CXP_TMPESTADOCTA_PROV;
DELETE FROM CXP_TMPESTADOCTA_PROV; 
delete from cxp_tmpestadocta_provcuo;
DELETE FROM CXP_TMPESTADOCTA_PROVEEDOR; 
delete from cxp_tmpestadocuenta;
DELETE FROM CXP_TMPESTADOFAC_PROVEEDOR; 
delete from cxp_tmpinforme_saldos_corte;
DELETE FROM CXP_TMPPAGODOCUMENTOS; 
DELETE FROM CXP_TMPPAGOS_DIARIOS; 
DELETE FROM CXP_TMPSALDOFACPROV; 
DELETE FROM CXP_TMPSALDOPROVEEDOR; 
delete from cxp_tmpsaldoproveedores;
delete from cxp_trncobro;
DELETE FROM CXP_TRNCOBRO; 
DELETE FROM CXP_TRNCOBROREF; 
DELETE FROM CXP_TRNDETCUOTA; 
DELETE FROM CXP_TRNDEVANT; 
delete from cxp_trndocumento;
DELETE FROM CXP_TRNDOCUMENTO; 
delete from cxp_trnpago;
DELETE FROM CXP_TRNPAGO; 
delete from cxp_trnresumen;
delete from cxp_trnresumen_integra;
delete from detpresupuesto;
DELETE FROM GER_MAEBALANCEC; 
DELETE FROM GER_TMPANALISIS; 
DELETE FROM GER_TMPMAEFLUJOCAJA; 
DELETE FROM GER_TMPPRUEBA; 
DELETE FROM GER_TMPRPT_VENTASDIARIAS; 
DELETE FROM GER_TMPTRANSACCIONES; 
DELETE FROM GER_VENTAS_SERVICIOS; 
DELETE FROM INT_TMP_EXISTENCIAARTBOD; 
DELETE FROM INV_DETKARDEX; 
DELETE FROM INV_DETKARDEXVAR; 
DELETE FROM INV_DETTOMAFISICA; 
DELETE FROM INV_DETTOMAFISICAVAR; 
DELETE FROM INV_DETTOMAFVAR; 
DELETE FROM INV_DETTRANSFER; 
DELETE FROM INV_ENCKARDEX; 
DELETE FROM INV_ENCTOMAFISICA; 
DELETE FROM INV_ENCTRANSFER; 
DELETE FROM INV_MINMAX; 
DELETE FROM INV_TMP_ARTICULOGRUPO;
DELETE FROM INV_TMP_ARTICULOGRUPO; 
DELETE FROM INV_TMP_ARTICULOSMAS_VENDIDOS; 
DELETE FROM INV_TMP_COSTOS; 
DELETE FROM INV_TMP_GRAFICO; 
DELETE FROM INV_TMP_INVTOTALESDIA; 
delete from inv_tmp_items_elim;
DELETE FROM INV_TMP_KARDEX; 
DELETE FROM INV_TMP_RENTDIA; 
DELETE FROM INV_TMP_RENTMENSUAL; 
DELETE FROM INV_TMP_REPOSICION; 
DELETE FROM INV_TMP_REUNIONPROVEEDORES; 
DELETE FROM INV_TMP_TRANSFERENCIA; 
DELETE FROM INV_TMP_TRANSITO; 
DELETE FROM INV_TMPACTPRE; 
DELETE FROM INV_TMPARTDEV;
DELETE FROM INV_TMPARTDEV; 
DELETE FROM INV_TMPARTICULOS_UTILIDADES; 
DELETE FROM INV_TMPCOSTO_VENTA; 
DELETE FROM INV_TMPCOSTOS; 
commit;

DELETE FROM INV_TMPDETKARDEX; 
DELETE FROM INV_TMPENCKARDEX; 
DELETE FROM INV_TMPENCTRANSFER; 
DELETE FROM INV_TMPINVENTARIO; 
DELETE FROM INV_TMPINVENTARIO_FECHA; 
DELETE FROM INV_TMPKARDEX; 
DELETE FROM INV_TMPKARDEXES_LLL;
DELETE FROM INV_TMPKARDEXES_LLL; 
DELETE FROM INV_TMPKARDEXES_LLL_CC; 
DELETE FROM INV_TMPKARDEXES_LLL_NEG; 
DELETE FROM INV_TMPKARDEXUNICO; 
DELETE FROM INV_TMPKARDXCTACTBLE;
DELETE FROM INV_TMPMAEARTICULO_PV; 
DELETE FROM INV_TMPMAEARTPRECIO; 
DELETE FROM INV_TMPMAEUNIDAD_PV; 
DELETE FROM INV_TMPMVMTOARTCLS; 
DELETE FROM INV_TMPROTACION; 
DELETE FROM INV_TMPSTOCKMIN; 
DELETE FROM INV_TMPTOMAFISICA; 
DELETE FROM INV_TMPTRNKARDEX; 
DELETE FROM INV_TRNACTPRECIO; 
DELETE FROM INV_TRNKARDEX; 
delete from INV_TRNKARDEX_P;
DELETE FROM INV_TRNKARDEX_RESPALDO; 
DELETE FROM INV_TRNKARDEX_TMP; 
DELETE FROM INV_TRNKARDEXINI; 
DELETE FROM INV_TRNKARDEXOTR; 
DELETE FROM INV_TRNNUMTRANSFER; 
DELETE FROM INV_TRNREPOSICION; 
DELETE FROM INV_TRNREPOSICIONDET; 
delete from INV_TRNTOMAFISICA;
DELETE FROM INV_TRNTOMAFISICA; 
DELETE FROM INV_TRNVARIOSTRF; 
DELETE FROM INVINI; 
DELETE FROM MAITE$; 
DELETE FROM MANT_ANEXOSING; 
DELETE FROM MANT_DETEGR; 
DELETE FROM MANT_DETING; 
DELETE FROM MANT_DETORDTRA; 
DELETE FROM MANT_DETTRANSFER; 
DELETE FROM MANT_ENCEGR; 
DELETE FROM MANT_ENCING; 
DELETE FROM MANT_ENCORDTRA; 
DELETE FROM MANT_ENCTRANSFER; 
DELETE FROM MANT_TRNCOMREP; 
DELETE FROM NC; 
delete from nuevos_articulos;
DELETE FROM PAL_TMPTRNCOMPRA; 
DELETE FROM PLAN_TABLE; 
delete from pre_trnprepac_com;
delete from pre_trnprepac_prueba;
DELETE FROM PROD_DETORDPRO; 
DELETE FROM PROD_ENCORDPRO; 
DELETE FROM PROD_TRNARTCOSTOS; 
DELETE FROM PROD_TRNARTICULO; 
DELETE FROM PROD_TRNCOSTOINDXFECHA; 
DELETE FROM PROD_TRNCOSTOSINDIRECTOS; 
DELETE FROM PROD_TRNESTPROD; 
DELETE FROM PROD_TRNLIQUIDACION; 
DELETE FROM PRUEBA; 
DELETE FROM PRUEBA_AGVB; 
delete from prueba_n;
delete from prueba1;
delete from prueba2;
DELETE FROM PTOVTA_TMPVENTAS_CAJEROS; 
DELETE FROM PVE_TMP_CUADRECAJA;
DELETE FROM PVE_TMP_CUADRECAJA; 
DELETE FROM PVE_TMP_VENTAARTICULOS; 
DELETE FROM PVE_TMPVENTAS_CAJEROS; 
DELETE FROM RESUMEN_COD; 
DELETE FROM RESUMEN_CODC; 
DELETE FROM SACI_DETANTICIPO; 
DELETE FROM SACI_ENCANTICIPO; 
DELETE FROM SACI_MAEAUDITORIA; 
DELETE FROM SACI_MAEAUDITORIA_RESP;
DELETE FROM SACI_MAEEXPHISTORICO; 
DELETE FROM SACI_TMPREPORT; 
DELETE FROM SACI_TMPTRNRETENCION_PV; 
DELETE FROM SACI_TRNCOMISION; 
delete from saci_trnretencion;
DELETE FROM TMP_ARTICULOS; 
DELETE FROM TMP_CLIENTES; 
DELETE FROM TMP_CUENTASXCOBRAR; 
DELETE FROM TMP_CUENTASXPAGAR; 
DELETE FROM TMP_DEVOLUCIONESDINERO; 
DELETE FROM TMP_INV_INI; 
DELETE FROM TMP_PLANCUENTAS; 
DELETE FROM TMP_PROVEEDORES; 
DELETE FROM TMP_TRNCLIENTES; 
DELETE FROM TMP_TRNCXC; 
DELETE FROM TMP_TRNCXP; 
DELETE FROM TMP_TRNGRUPOSINV; 
commit;

DELETE FROM TMP_TRNINVENTARIO; 
DELETE FROM TMP_TRNPROVEEDORES; 
DELETE FROM TMP_TRNVENDEDORES; 
DELETE FROM TRAINV;
DELETE FROM VEN_AUDENCFAC; 
DELETE FROM VEN_DETCOT; 
DELETE FROM VEN_DETDVF; 
DELETE FROM VEN_DETDVF_PREVIA; 
commit;
DELETE FROM VEN_DETENT; 
DELETE FROM VEN_DETFAC; 
DELETE FROM VEN_DETFFA; 
DELETE FROM VEN_DETGRE; 
DELETE FROM VEN_DETPED; 
DELETE FROM VEN_DETPEN; 
DELETE FROM VEN_ENCCOT; 
DELETE FROM VEN_ENCDVF; 
commit;
DELETE FROM VEN_ENCDVF_PREVIA; 
commit;
DELETE FROM VEN_ENCENT; 
commit;
DELETE FROM VEN_ENCFAC; 
commit;
DELETE FROM VEN_ENCFFA; 
commit;
DELETE FROM VEN_ENCGRE; 
commit;
DELETE FROM VEN_ENCPED; 
DELETE FROM VEN_ENCPEN; 
DELETE FROM VEN_GUPCOMISION; 
DELETE FROM VEN_TMP_ARTBAJOSCOSTOS;
DELETE FROM VEN_TMP_COMISIONESVEND;
delete from ven_tmp_cuadrecaja;
DELETE FROM VEN_TMP_LISTACLIENTES;
DELETE FROM VEN_TMP_NOTAVENTA; 
DELETE FROM VEN_TMP_VENTASNETAS; 
DELETE FROM VEN_TMP_VENTASNETASMENSUALES; 
delete from ven_tmpcomisiones;
DELETE FROM VEN_TMPCONSOLIDADO;
DELETE FROM VEN_TMPCTRLNUMIMPR;
DELETE FROM VEN_TMPCUADRECAJAMCSL;
DELETE FROM VEN_TMPDETCOMVEND; 
DELETE FROM VEN_TMPDETDVF_PV; 
DELETE FROM VEN_TMPDETFAC; 
DELETE FROM VEN_TMPDETFAC_PV; 
DELETE FROM VEN_TMPENCCOMVEND; 
DELETE FROM VEN_TMPENCDVF_PV; 
DELETE FROM VEN_TMPENCFAC; 
DELETE FROM VEN_TMPENCFAC_PV; 
DELETE FROM VEN_TMPFACDIAPAG;
DELETE FROM VEN_TMPFACPEND; 
commit;

DELETE FROM VEN_TMPFACTURA;
DELETE FROM VEN_TMPFACTURA; 
DELETE FROM VEN_TMPGUIA_REMISION; 
DELETE FROM VEN_TMPMAECLIENTE_PV; 
DELETE FROM VEN_TMPMAETRANSPORT_BAL; 
DELETE FROM VEN_TMPNOTA_PEDIDO;
DELETE FROM VEN_TMPNOTA_PEDIDO; 
delete from ven_tmpnotacredito;
DELETE FROM VEN_TMPTRNFACTURAS; 
DELETE FROM VEN_TMPVENTAS_DETALLE; 
DELETE FROM VEN_TMPVENTAS_NETAS; 
DELETE FROM VEN_TMPVENTAS_TOTALES; 
DELETE FROM VEN_TMPVTAXVNDRYUNIDAD; 
DELETE FROM VEN_TRNPRECIOSPORVOL; 
DELETE FROM XXX_EXTPRECIOS; 
DELETE FROM ZZZ_BODEGA1; 
DELETE FROM ZZZ_CAMBIARFECHA; 
DELETE FROM ZZZ_CON_MAECON; 
DELETE FROM ZZZ_EXISTENCIAS; 
DELETE FROM ZZZ_FACTURAUNIDADESINC; 
DELETE FROM ZZZ_MATRIZ; 
DELETE FROM ZZZ_PLAN_CUENTAS; 
DELETE FROM ZZZ_PRECIOS;
DELETE FROM ZZZ_TRACOB; 
DELETE FROM ZZZ_TRAINV;
DELETE FROM ZZZ_TRAPAG; 
delete FROM plancuenta;
delete FROM pr;
delete FROM precios;
delete FROM saci_com_maeproveedor;
delete FROM saci_con_maecon;
delete FROM saci_cxc_trncobro;
delete FROM saci_cxp_trncobro;
delete FROM saci_inv_maearticulo;
delete FROM saci_inv_maeartprecio;
delete FROM saci_inv_maegrupo;
delete FROM saci_inv_trnkardex;
delete FROM saci_trnretencion_tmp;
delete FROM saci_ven_maecliente;
DROP TABLE ZZZ_ALICIA; 
delete FROM ANEX_IVAANULADO;
delete FROM ANEX_IVAVEN_AUX;
delete FROM ANEX_RETCOM;
delete FROM ARTSERV;
delete FROM AUXSACI_MAERLBANDE;
delete FROM AUXSACI_MAERLGRUPO;
delete FROM AUXSACI_MAERL_NEW;
delete FROM AUXSACI_MAERLPARAM;
delete FROM COM_TMPREQUISICION; 
delete FROM CON_TMP_INICIALIZARTIPDIA;
delete FROM CON_TMP_INICIALIZARTIPDIA1;
delete FROM FAC;
DELETE FROM ANEX_IVACOM;
DELETE FROM ANEX_IVAVEN;
DELETE FROM ANEX_MAECODSRI_TMP;
DELETE FROM BAN_TRNCAJ;
DELETE FROM CANTONES;
DELETE FROM COM_DETFACPRO;
DELETE FROM COM_ENCFACPRO;
DELETE FROM COM_ENCFACPRO_TMP;
DELETE FROM COM_TMP_INGRESOMERCADERIA;
DELETE FROM COM_TMP_IVA_RETENCION;
DELETE FROM COM_TMP_OBMOVPRO;
DELETE FROM COM_TMP_RPTRETENCIONES;
DELETE FROM COM_TRNCARGOS;
DELETE FROM COM_TRNFORMAPAGO;
DELETE FROM CON_DETASI_L;
DELETE FROM CON_ENCASI_L;
DELETE FROM CON_TMPBALANCEC;
DELETE FROM CXC_TMP_TRNRESUMEN;
DELETE FROM CXC_TMPABONOCLIENTE;
DELETE FROM CXC_TRNCOBRO;
DELETE FROM CXC_TRNDOCUMENTO;
DELETE FROM CXC_TRNPAGO;
DELETE FROM CXC_TRNRESUMEN;
DELETE FROM CXP_TMPESTADOCUENTA;
DELETE FROM CXP_TRNCOBRO;
DELETE FROM CXP_TRNDOCUMENTO;
DELETE FROM CXP_TRNPAGO;
DELETE FROM CXP_TRNRESUMEN;
DELETE FROM INV_TMP_ARTICULOGRUPO;
DELETE FROM INV_TMP_ITEMS_ELIM;
DELETE FROM INV_TMP_OBMOVCOM;
DELETE FROM INV_TMPINVENTARIO_FECHA;
DELETE FROM INV_TMPKARDEXES_LLL;
DELETE FROM INV_TMPTRANSFERENCIA;
DELETE FROM INV_TRNKARDEX;
DELETE FROM INV_TRNKARDEX_P;
DELETE FROM INV_TRNKARDEX_TMP;
DELETE FROM NOM_CFGCTBLRPADM;
DELETE FROM NOM_MAEPROVINCIA;
DELETE FROM NOM_MAETABLITARET;
DELETE FROM PARROQUIAS;
DELETE FROM PROVINCIAS;
DELETE FROM PRUEBA;
DELETE FROM PRUEBA_M;
DELETE FROM PRUEBA_MJ;
DELETE FROM PRUEBA_MM;
DELETE FROM PRUEBA_N;
DELETE FROM PRUEBAS_OSCAR;
DELETE FROM PVE_TMP_CUADRECAJA;
DELETE FROM REP_PRUEBA;
DELETE FROM SACI_INV_MAEBODEGA;
DELETE FROM SACI_INV_MAEUNIDAD;
DELETE FROM SACI_MAEAPLICACIONORG;
DELETE FROM SACI_MAEAUDITORIA;
DELETE FROM SACI_MAECOMISION;
DELETE FROM SACI_TRNRETENCION;
DELETE FROM SACI_TRNRETENCION_TMP;
DELETE FROM SRIFE_COMPROERROR;
DELETE FROM SRIFE_MAECOMPROBANTE;
DELETE FROM SRIFE_TRANFORMPAGO;
DELETE FROM VEN_DETFAC;
DELETE FROM VEN_ENCFAC;
DELETE FROM VEN_TMP_CUADRECAJA;
DELETE FROM VEN_TMP_FACTURA_RIDE;
DELETE FROM VEN_TMP_TRNPLAZOS;
DELETE FROM VEN_TMPFACTURA;
DELETE FROM VEN_TMPVENTAS_DETALLE;
DELETE FROM VEN_TRNPLAZOS_ACT_TMP;
update con_maetipdia set tipdia_nroactual=tipdia_nroinicial;
commit;