---Definicion de transacciones en el menu de cajas
insert into TSUBNIVELESMENUID (CSUBNIVELMENU) values (1);
insert into TSUBNIVELESMENU (CIDIOMA, CSUBNIVELMENU, FHASTA, FDESDE, DESCRIPCION) values ('ES', 1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:20:44.799000', 'dd-mm-yyyy hh24:mi:ss.ff'), 'CAJAS');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('04-07-2007 17:11:47.638263', 'dd-mm-yyyy hh24:mi:ss.ff'), 23, '06', '0585', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:25:38.794000', 'dd-mm-yyyy hh24:mi:ss.ff'), 3, '03', '0114', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:26:21.293000', 'dd-mm-yyyy hh24:mi:ss.ff'), 4, '04', '0171', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:23:13.787000', 'dd-mm-yyyy hh24:mi:ss.ff'), 1, '03', '0102', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:24:27.328000', 'dd-mm-yyyy hh24:mi:ss.ff'), 2, '04', '0123', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:29:56.401000', 'dd-mm-yyyy hh24:mi:ss.ff'), 5, '03', '0112', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:29:56.432000', 'dd-mm-yyyy hh24:mi:ss.ff'), 6, '03', '0110', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:29:56.448000', 'dd-mm-yyyy hh24:mi:ss.ff'), 7, '04', '0120', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:29:56.448000', 'dd-mm-yyyy hh24:mi:ss.ff'), 8, '03', '0128', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:29:56.463000', 'dd-mm-yyyy hh24:mi:ss.ff'), 9, '06', '0217', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:29:56.479000', 'dd-mm-yyyy hh24:mi:ss.ff'), 10, '03', '0113', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:35:33.652000', 'dd-mm-yyyy hh24:mi:ss.ff'), 11, '04', '0130', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:35:33.668000', 'dd-mm-yyyy hh24:mi:ss.ff'), 12, '03', '0138', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:35:33.683000', 'dd-mm-yyyy hh24:mi:ss.ff'), 13, '03', '0139', '01');
--insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
--values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:35:33.699000', 'dd-mm-yyyy hh24:mi:ss.ff'), 14, '04', '0388', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:35:33.714000', 'dd-mm-yyyy hh24:mi:ss.ff'), 15, '05', '0102', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:35:33.730000', 'dd-mm-yyyy hh24:mi:ss.ff'), 16, '07', '0104', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:35:33.746000', 'dd-mm-yyyy hh24:mi:ss.ff'), 17, '03', '0146', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:35:33.761000', 'dd-mm-yyyy hh24:mi:ss.ff'), 18, '06', '0219', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('31-05-2007 10:35:33.761000', 'dd-mm-yyyy hh24:mi:ss.ff'), 19, '04', '0275', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('04-07-2007 12:31:02.215776', 'dd-mm-yyyy hh24:mi:ss.ff'), 20, '06', '0336', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('04-07-2007 12:31:02.264166', 'dd-mm-yyyy hh24:mi:ss.ff'), 21, '06', '0337', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('04-07-2007 12:31:02.267431', 'dd-mm-yyyy hh24:mi:ss.ff'), 22, '06', '0572', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('24-09-2007 07:32:59.309501', 'dd-mm-yyyy hh24:mi:ss.ff'), 24, '04', '0568', '01');
insert into TSUBNIVELESMENUTRANSACCIONES (CSUBNIVELMENU, FHASTA, FDESDE, CODIGOALTERNOTRANSACCION, CSUBSISTEMA, CTRANSACCION, VERSIONTRANSACCION)
values (1, to_timestamp('31-12-2999 00:00:00.000000', 'dd-mm-yyyy hh24:mi:ss.ff'), to_timestamp('25-09-2007 11:23:06.206679', 'dd-mm-yyyy hh24:mi:ss.ff'), 25, '03', '0172', '01');