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

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', '5046', '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', '5046', '01', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2013-10-30 11:49:17', 'GENERACIÓN DE ESTRUCTURA SB250', null, 0);
INSERT INTO TCOMPANIATRANSACCIONES (CPERSONA_COMPANIA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, VERSIONCONTROL) VALUES (2, '06', '5046', '01', 0);
|
DELETE FROM TFORMATOREPORTEJASPER WHERE CFORMATOREPORTE='06_SB250B';
DELETE FROM TFORMATOREPORTE WHERE CFORMATOREPORTE='06_SB250B';
DELETE FROM TFORMATOREPORTEID WHERE CFORMATOREPORTE='06_SB250B';

INSERT INTO TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) VALUES (2, '06_SB250B', 'Loaded from Client');
INSERT INTO TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) VALUES ('ES', 2, '06_SB250B', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2013-10-30 11:49:08', 'ESTRUCTURA SB250B', 0);