DELETE FROM TCOMPANIATRANSACCIONES WHERE CSUBSISTEMA = '06' AND CTRANSACCION = '2030';
DELETE FROM TSUBSISTEMATRANSACCIONES WHERE CSUBSISTEMA = '06' AND CTRANSACCION = '2030';
DELETE FROM TSUBSISTEMATRANSACCIONESID WHERE CSUBSISTEMA = '06' AND CTRANSACCION = '2030';

INSERT INTO TSUBSISTEMATRANSACCIONESID (CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, ORDENMENU, PRESENTARENMENU, INTERNA, FORMULARIOBASE, AFECTAINMOVILIZACION, CGRUPOTRANSACCION, PRESENTARENREVERSO, CNIVELMENU, LISTAVALOR, USACACHE, SUMACOMPONENTES, PROVISION, COMPLETARRUBROS, LOTEGENERICO, VERIFICANIVELSEGURIDAD, CUSUARIO_INGRESO, FINGRESO, ACUMULACONTADOR, PAGINA, ORIGENDESTINO, CONTROLAEFECTIVO, REQUIEREAUTORIZACION, EJECUTAENAUTORIZACION) VALUES ('06', '2030', '01', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO TSUBSISTEMATRANSACCIONES (CIDIOMA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, FHASTA, FDESDE, DESCRIPCION, SIGLAS, VERSIONCONTROL) VALUES ('ES', '06', '2030', '01', FNCFHASTA, SYSDATE, 'INGRESO DE COMISIÓN, CARGOS Y SEGUROS', null, 0);
INSERT INTO TCOMPANIATRANSACCIONES (CPERSONA_COMPANIA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, VERSIONCONTROL) VALUES (2, '06', '2030', '01', 0);

UPDATE TCATEGORIAS SET DESCRIPCION = UPPER(DESCRIPCION);