delete from ban_detconcil;
delete from ban_encconcil;
commit;
delete from cxc_trncobro;
delete from cxc_trnpago;
delete from cxc_trndocumento;
delete from cxc_trnresumen;
delete from saci_trnretencion;
delete from saci_trncomision;


delete from CXC_DETCUOTA;
delete from CXC_ENCCUOTA;
update CXC_MAETARJETA set con_codigo=null,con_codigocom=null,con_codigorfte=null,con_codigofiva=null;

delete from cxp_trncobro;
delete from cxp_trnpago;
delete from cxp_trndocumento;
delete from cxp_trnresumen;
delete from cxp_DetTrnCobro;
delete from saci_trnretencion;

delete from com_trncargos;
delete from COM_TRNNOTRECVAR;
delete from com_detfacpro;
delete from com_encfacpro;
delete from com_detdev;
delete from com_encdev;
delete from com_detnotrec;
delete from com_encnotrec;
delete from com_detordcom;
delete from com_encordcom;
delete from com_maeautsri;
delete from com_maeproveedor;
delete from COM_MAESERVICIO;



commit;

delete from ven_detfac;
delete from ven_encfac;
delete from ven_detped;
delete from ven_encped;
delete from ven_detdvf;
delete from ven_encdvf;
delete from ven_maeservicio;
delete from ven_maecliente;
delete from ven_maevendedor;
delete from ven_maepromocion;
delete from ven_maedscto;
delete from ven_maetransport;
delete from ven_maegrupo;


commit;

delete from INV_TRNTOMAFISICA;
delete from inv_maeartprecio;
delete from inv_trnkardex;
delete from INV_TRNKARDEX_P;
delete from inv_dettransfer;
delete from inv_enctransfer;
delete from inv_detkardex;
delete from inv_enckardex;
delete from inv_maearticulo;
delete from inv_maegrupo;
delete from inv_maeunidad;
delete from ban_maeban;
delete from ban_maecaj;
delete from ban_maecaja;
update seg_maeusuario set bod_codigo=null,bod_codigo_dev=null;
delete from inv_maebodega;



 update saci_maeretencion set con_codigo=null;
 update saci_maeretencion set con_codigo_vta=null;
 update ban_maeban set con_codigo=null;
update ban_maeban set con_codigo_2=null;
update ban_maecaj set con_codigo=null;
update saci_maecomision set con_codigo=null;

DELETE FROM CON_DETASI_L;
DELETE FROM CON_ENCASI_L;

delete from ban_trncajvar;
delete from ban_trnban;
delete from ban_trncaj;


-- delete from con_maecon;
delete from  saci_maeauditoria;

commit;