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 ('01', '9101', '01', 0, '1', '0', '1', '0', null, null, null, '0', '0', null, '0', '0', null, null, null, null, null, null, null, null, '0', '0');
insert into TSUBSISTEMATRANSACCIONES (CIDIOMA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, FHASTA, FDESDE, DESCRIPCION, SIGLAS, VERSIONCONTROL) values ('ES', '01', '9101', '01', '2999-12-31 00:00:00.000000', '2010-09-09 10:51:47.238000', 'Lista de Valores COMEX', null, 0);
insert into TCOMPANIATRANSACCIONES (CPERSONA_COMPANIA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, VERSIONCONTROL) values (2, '01', '9101', '01', 0);

delete from tcomandosmantenimiento where csubsistema = '01' and ctransaccion = '9101' and comando = 'com.fitbank.comex.query.ListCorrespondentBankAddress';
delete from tcomandosid where comando = 'com.fitbank.comex.query.ListCorrespondentBankAddress' and tipocomando = 'CON';

insert into tcomandosid (comando, tipocomando) values ('com.fitbank.comex.query.ListCorrespondentBankAddress','CON');
Insert into TCOMANDOSMANTENIMIENTO (CSUBSISTEMA,CTRANSACCION,VERSIONTRANSACCION,SCOMANDO,EVENTO,COMANDO,ORDEN,USACACHE,TIPOCOMANDO,ACTIVADO,CANALESEXCLUIDOS,PARAMETRO,VERSIONCONTROL) values
('01','9101','01',1,'I','com.fitbank.comex.query.ListCorrespondentBankAddress',1,'0','CON','1',null,null,0);

delete from tcomandosmantenimiento where csubsistema = '10' and ctransaccion = '2012' and comando = 'com.fitbank.comex.query.ObtainCorrespondentBankAddress';
delete from tcomandosid where comando = 'com.fitbank.comex.query.ObtainCorrespondentBankAddress' and tipocomando = 'CON';

insert into tcomandosid (comando, tipocomando) values ('com.fitbank.comex.query.ObtainCorrespondentBankAddress','CON');
Insert into TCOMANDOSMANTENIMIENTO (CSUBSISTEMA,CTRANSACCION,VERSIONTRANSACCION,SCOMANDO,EVENTO,COMANDO,ORDEN,USACACHE,TIPOCOMANDO,ACTIVADO,CANALESEXCLUIDOS,PARAMETRO,VERSIONCONTROL) values
('10','2012','01',1,'I','com.fitbank.comex.query.ObtainCorrespondentBankAddress',1,'0','CON','1',null,null,0);