-- 215001 REPORTE DE INGRESOS, EGRESOS Y PROVISIONES DEL ROL ACTUAL
delete from TCOMPANIATRANSACCIONES where CSUBSISTEMA = '21' and CTRANSACCION = '5001';
delete from TSUBSISTEMATRANSACCIONES where CSUBSISTEMA = '21' and CTRANSACCION = '5001';
delete from TSUBSISTEMATRANSACCIONESID where CSUBSISTEMA = '21' and CTRANSACCION = '5001';

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', '5001', '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', '5001', '01', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2013-03-24 11:33:37', 'REPORTE DE INGRESOS, EGRESOS Y PROVISIONES DEL ROL ACTUAL', null, 0);
insert into TCOMPANIATRANSACCIONES (CPERSONA_COMPANIA, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION, VERSIONCONTROL) values (2, '21', '5001', '01', 0);

-- Reportes
delete from TFORMATOREPORTE where CPERSONA_COMPANIA = 2 and CFORMATOREPORTE = '21_HEADER';
delete from TFORMATOREPORTEID where CPERSONA_COMPANIA = 2 and CFORMATOREPORTE = '21_HEADER';
delete from TFORMATOREPORTE where CPERSONA_COMPANIA = 2 and CFORMATOREPORTE = '21_ROLINGRESOSEGRESOS';
delete from TFORMATOREPORTEID where CPERSONA_COMPANIA = 2 and CFORMATOREPORTE = '21_ROLINGRESOSEGRESOS';
delete from TFORMATOREPORTE where CPERSONA_COMPANIA = 2 and CFORMATOREPORTE = '21_ROLPROVISIONES';
delete from TFORMATOREPORTEID where CPERSONA_COMPANIA = 2 and CFORMATOREPORTE = '21_ROLPROVISIONES';
delete from TFORMATOREPORTE where CPERSONA_COMPANIA = 2 and CFORMATOREPORTE = '21_ROL_ING_EGR_CONDENSADO';
delete from TFORMATOREPORTEID where CPERSONA_COMPANIA = 2 and CFORMATOREPORTE = '21_ROL_ING_EGR_CONDENSADO';
delete from TFORMATOREPORTE where CPERSONA_COMPANIA = 2 and CFORMATOREPORTE = '21_ROLPROVISIONES_CONDENSADO';
delete from TFORMATOREPORTEID where CPERSONA_COMPANIA = 2 and CFORMATOREPORTE = '21_ROLPROVISIONES_CONDENSADO';

insert into TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) values (2, '21_HEADER', 'Loaded from Client');
insert into TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('ES', 2, '21_HEADER', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2013-01-31 14:34:21', '21_HEADER', 0);
insert into TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) values (2, '21_ROLINGRESOSEGRESOS', 'Loaded from Client');
insert into TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('ES', 2, '21_ROLINGRESOSEGRESOS', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2012-07-12 16:38:34', 'REPORTE DE INGRESOS Y EGRESOS DEL RON ACTUAL', 1);
insert into TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) values (2, '21_ROLPROVISIONES', 'Loaded from Client');
insert into TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('ES', 2, '21_ROLPROVISIONES', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2013-01-31 14:34:21', 'REPORTE DE PROVISIONES DEL ROL ACTUAL', 0);
insert into TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) values (2, '21_ROL_ING_EGR_CONDENSADO', 'Loaded from Client');
insert into TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('ES', 2, '21_ROL_ING_EGR_CONDENSADO', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2013-01-31 14:34:21', 'REPORTE TOTALIZADO DE INGRESOS Y EGRESOS DEL RON ACTUAL', 0);
insert into TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE, RUTAREPORTE) values (2, '21_ROLPROVISIONES_CONDENSADO', 'Loaded from Client');
insert into TFORMATOREPORTE (CIDIOMA, CPERSONA_COMPANIA, CFORMATOREPORTE, FHASTA, FDESDE, DESCRIPCION, VERSIONCONTROL) values ('ES', 2, '21_ROLPROVISIONES_CONDENSADO', TIMESTAMP '2999-12-31 00:00:00', TIMESTAMP '2013-01-31 14:34:21', 'REPORTE TOTALIZADO DE PROVISIONES DEL ROL ACTUAL', 0);