delete from tcompaniatransacciones where csubsistema='02' and ctransaccion='4106';
delete from tsubsistematransacciones where csubsistema='02' and ctransaccion='4106';
delete from tsubsistematransaccionesid where csubsistema='02' and ctransaccion='4106';
delete from tcompaniatransacciones where csubsistema='02' and ctransaccion='4107';
delete from tsubsistematransacciones where csubsistema='02' and ctransaccion='4107';
delete from tsubsistematransaccionesid where csubsistema='02' and ctransaccion='4107';

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 ('02', '4106', '01', 0, '1', '0', '1', '0', null, null, '0201', null, '0', null, '0', '0', null, null, null, null, null, null, null, null, null, '0');
insert into TSUBSISTEMATRANSACCIONES (CIDIOMA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, FHASTA, FDESDE, DESCRIPCION, SIGLAS, VERSIONCONTROL) values ('ES', '02', '4106', '01', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2012-03-27 16:15:48', 'SEGMENTACIÓN DE PERSONAS NATURALES', null, 0);
insert into TCOMPANIATRANSACCIONES (CPERSONA_COMPANIA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, VERSIONCONTROL) values (2, '02', '4106', '01', 0);
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 ('02', '4107', '01', 0, '1', '0', '1', '0', null, null, '0206', null, '0', null, '0', '0', null, null, null, null, null, null, null, null, null, '0');
insert into TSUBSISTEMATRANSACCIONES (CIDIOMA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, FHASTA, FDESDE, DESCRIPCION, SIGLAS, VERSIONCONTROL) values ('ES', '02', '4107', '01', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2012-03-28 12:47:15', 'SEGMENTACIÓN DE PERSONAS JURIDICAS', null, 0);
insert into TCOMPANIATRANSACCIONES (CPERSONA_COMPANIA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, VERSIONCONTROL) values (2, '02', '4107', '01', 0);



delete from tformatoreportejasper where cformatoreporte IN('SEGPNATURALES','SEGPJURIDICOS');
delete from tformatoreporte  where cformatoreporte  IN('SEGPNATURALES','SEGPJURIDICOS');
delete from tformatoreporteid  where cformatoreporte  IN('SEGPNATURALES','SEGPJURIDICOS');

insert into TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) values (2, 'SEGPJURIDICOS', null);
insert into TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) values (2, 'SEGPNATURALES', null);
insert into TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('ES', 2, 'SEGPJURIDICOS', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2012-04-09 17:05:20', 'SEGMENTACION PERSONAS JURIDICAS', 1);
insert into TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('ES', 2, 'SEGPNATURALES', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2012-04-09 17:05:20', 'SEGMENTACION PERSONAS NATURALES', 0);