delete tmovimientos;
delete tsaldos;
delete tsaldosfvalor;
delete ttransaccionrubros;
delete tcategoriasdetalle;
delete tcategorias;
delete ttransaccionprovisiones;
delete tcategoriasid;
delete tprefijoestatuscuenta;
delete testatusmaduracion;
delete testatusmaduracionid;
delete testatuscuenta;
delete trangosmaduracion;
delete ttiposmaduracion;
update tcuenta set ctipomaduracion=null;
delete ttiposmaduracionid;
delete tprefijocodcontablesec;
delete tprefijo;
update tcuenta set prefijo=null;
delete tprefijoplazos;
delete tprefijoid;
delete ttransaccionrubros;
delete troleshorario where csubsistema in ('03','04') and ctransaccion>'0999';
delete tcompaniaroles where csubsistema in ('03','04') and ctransaccion>'0999';
delete tcompaniatransaccioneshorario where csubsistema in ('03','04') and ctransaccion>'0999';
delete tcompaniatransaccionesproducto where csubsistema in ('03','04') and ctransaccion>'0999';
delete tformatoxml where csubsistema in ('03','04') and ctransaccion>'0999';
delete tcompaniatransacciones where csubsistema in ('03','04') and ctransaccion>'0999';
delete tsubsistematransacciones where csubsistema in ('03','04') and ctransaccion>'0999';
delete tsubsistematransaccionesid where csubsistema in ('03','04') and ctransaccion>'0999';