------------------------------------------------ 215017 - EMISION DE SOLICITUD DE PAGO DIRECTO ------------------------------------------------

delete from TCOMPANIATRANSACCIONES where CSUBSISTEMA = '21' and CTRANSACCION = '5017';;
delete from TSUBSISTEMATRANSACCIONES where CSUBSISTEMA = '21' and CTRANSACCION = '5017';
delete from TSUBSISTEMATRANSACCIONESID where CSUBSISTEMA = '21' and CTRANSACCION = '5017';

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 ('21', '5017', '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', '21', '5017', '01', FNCFHASTA, SYSDATE, 'REPORTE DE SUELDOS NOMINALES DEL ROL DE', null, 0);
insert into TCOMPANIATRANSACCIONES (CPERSONA_COMPANIA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, VERSIONCONTROL) values (2, '21', '5017', '01', 0);

delete from TCOMANDOSMANTENIMIENTO where CSUBSISTEMA = '21' and CTRANSACCION = '5017' and COMANDO = 'com.fitbank.payroll.query.CheckDatePayroll';
delete from TCOMANDOS where COMANDO = 'com.fitbank.payroll.query.CheckDatePayroll';
delete from TCOMANDOSID where COMANDO = 'com.fitbank.payroll.query.CheckDatePayroll';

insert into TCOMANDOSID (COMANDO, TIPOCOMANDO) values ('com.fitbank.payroll.query.CheckDatePayroll', 'CON');
insert into TCOMANDOS (COMANDO, TIPOCOMANDO, FHASTA, CIDIOMA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('com.fitbank.payroll.query.CheckDatePayroll', 'CON', FNCFHASTA, 'ES', SYSDATE, 'Clase que conuslta la fehca del Rol Actual', 0);
insert into TCOMANDOSMANTENIMIENTO (CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, SCOMANDO, EVENTO, COMANDO, ORDEN, USACACHE, TIPOCOMANDO, ACTIVADO, CANALESEXCLUIDOS, PARAMETRO, VERSIONCONTROL, EJECUTADOPOR) values ('21', '5017', '01', 1, 'I', 'com.fitbank.payroll.query.CheckDatePayroll', 2, '0', 'CON', '1', null, null, 0, null);


------------------------------------------------------------------------ REPORTES -------------------------------------------------------------------------

-- tformatoreporte
delete from TFORMATOREPORTE where CFORMATOREPORTE = '21_SUELDOSNOMINALES';
delete from TFORMATOREPORTE where CFORMATOREPORTE = '21_SUELDOSNOMINALES2';
delete from TFORMATOREPORTE where CFORMATOREPORTE = '21_SUELDOSNOMINALES3';

-- tformatoreporteid
delete from TFORMATOREPORTEID where CFORMATOREPORTE = '21_SUELDOSNOMINALES';
delete from TFORMATOREPORTEID where CFORMATOREPORTE = '21_SUELDOSNOMINALES2';
delete from TFORMATOREPORTEID where CFORMATOREPORTE = '21_SUELDOSNOMINALES3';

-- TFORMATOREPORTEID
insert into TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) values (2, '21_SUELDOSNOMINALES', 'Loaded from Client');
insert into TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) values (2, '21_SUELDOSNOMINALES2', 'Loaded from Client');
insert into TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) values (2, '21_SUELDOSNOMINALES3', 'Loaded from Client');

-- TFORMATOREPORTE
insert into TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('ES', 2, '21_SUELDOSNOMINALES', FNCFHASTA, SYSDATE, '21_SUELDOSNOMINALES', 0);
insert into TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('ES', 2, '21_SUELDOSNOMINALES2', FNCFHASTA, SYSDATE, '21_SUELDOSNOMINALES2', 0);
insert into TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('ES', 2, '21_SUELDOSNOMINALES3', FNCFHASTA, SYSDATE, '21_SUELDOSNOMINALES3', 0);