-- 06-4010 (CONSULTA DE VENCIMIENTOS DE PRÉSTAMOS)
-- TSUBSISTEMATRANSACCIONESID
INSERT INTO TSUBSISTEMATRANSACCIONESID VALUES ('06', '4010', '01', 430, '1', '0', '1', '0', NULL, NULL, NULL, NULL, '0', '0', '0', '0', '0', '0', NULL, NULL, '0', NULL, NULL, '0', '0', '0');

-- TSUBSISTEMATRANSACCIONES
INSERT INTO TSUBSISTEMATRANSACCIONES VALUES ('ES', '06', '4010', '01', fncfhasta, fncsysdate, 'CONSULTA DE VENCIMIENTOS DE PRÉSTAMOS', NULL, 0);

-- TCOMPANIATRANSACCIONES
INSERT INTO TCOMPANIATRANSACCIONES VALUES (2, '06', '4010', '01', 0);

-- TCOMPANIATRANSACCIONESPRODUCTO
INSERT INTO TCOMPANIATRANSACCIONESPRODUCTO VALUES (2, '06', '01', '101', '1', '001', '06', '4010', '01', 0);

-- TCOMPANIAROLES
INSERT INTO TCOMPANIAROLES VALUES (1, 2, '06', '4010', '01', NULL, NULL, 0);

-- TROLESHORARIO
INSERT INTO TROLESHORARIO VALUES (1,2,'06','01','101','1','001','06','4010','01','USD','N',1,FNCFHASTA,FNCSYSDATE,'0000','2359',NULL,'120601101100100401001USDN1',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'06','01','101','1','001','06','4010','01','USD','N',2,FNCFHASTA,FNCSYSDATE,'0000','2359',NULL,'120601101100100401001USDN2',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'06','01','101','1','001','06','4010','01','USD','N',3,FNCFHASTA,FNCSYSDATE,'0000','2359',NULL,'120601101100100401001USDN3',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'06','01','101','1','001','06','4010','01','USD','N',4,FNCFHASTA,FNCSYSDATE,'0000','2359',NULL,'120601101100100401001USDN4',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'06','01','101','1','001','06','4010','01','USD','N',5,FNCFHASTA,FNCSYSDATE,'0000','2359',NULL,'120601101100100401001USDN5',0);
insert into troleshorario values (1,2,'06','01','101','1','001','06','4010','01','USD','N',6,fncfhasta,fncsysdate,'0000','2359',null,'120601101100100401001USDN6',0);
insert into troleshorario values (1,2,'06','01','101','1','001','06','4010','01','USD','N',7,fncfhasta,fncsysdate,'0000','2359',null,'120601101100100401001USDN7',0);