-- Parametrización transacción 14-5002 (REPORTE DE ACTIVOS FIJOS DADOS DE BAJA)
-- TSUBSISTEMATRANSACCIONESID
INSERT INTO TSUBSISTEMATRANSACCIONESID VALUES ('14', '5002', '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', '14', '5002', '01', fncfhasta(), sysdate, 'Reportes de Activos Fijos', NULL, 0);

-- TCOMPANIATRANSACCIONES
INSERT INTO TCOMPANIATRANSACCIONES VALUES (2, '14', '5002', '01', 0);

-- TCOMPANIATRANSACCIONESPRODUCTO
INSERT INTO TCOMPANIATRANSACCIONESPRODUCTO VALUES (2, '14', '00', '000', '1', '002', '14', '5002', '01', 0);

-- TCOMPANIAROLES
INSERT INTO TCOMPANIAROLES VALUES (1, 2, '14', '5002', '01', NULL, NULL, 0);

-- TROLESHORARIO
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5002','01','USD','N',1,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500201USDN1',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5002','01','USD','N',2,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500201USDN2',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5002','01','USD','N',3,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500201USDN3',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5002','01','USD','N',4,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500201USDN4',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5002','01','USD','N',5,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500201USDN5',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5002','01','USD','N',6,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500201USDN6',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5002','01','USD','N',7,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500201USDN7',0);


-- Parametrización transacción 14-5003 (REPORTE DE ACTIVOS FIJOS POR OFICINA)
-- TSUBSISTEMATRANSACCIONESID
INSERT INTO TSUBSISTEMATRANSACCIONESID VALUES ('14', '5003', '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', '14', '5003', '01', fncfhasta(), sysdate, 'Reportes de Activos Fijos', NULL, 0);

-- TCOMPANIATRANSACCIONES
INSERT INTO TCOMPANIATRANSACCIONES VALUES (2, '14', '5003', '01', 0);

-- TCOMPANIATRANSACCIONESPRODUCTO
INSERT INTO TCOMPANIATRANSACCIONESPRODUCTO VALUES (2, '14', '00', '000', '1', '002', '14', '5003', '01', 0);

-- TCOMPANIAROLES
INSERT INTO TCOMPANIAROLES VALUES (1, 2, '14', '5003', '01', NULL, NULL, 0);

-- TROLESHORARIO
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5003','01','USD','N',1,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500301USDN1',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5003','01','USD','N',2,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500301USDN2',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5003','01','USD','N',3,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500301USDN3',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5003','01','USD','N',4,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500301USDN4',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5003','01','USD','N',5,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500301USDN5',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5003','01','USD','N',6,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500301USDN6',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5003','01','USD','N',7,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500301USDN7',0);


-- Parametrización transacción 14-5004 (REPORTE TOTALES ACTIVOS FIJOS)
-- TSUBSISTEMATRANSACCIONESID
INSERT INTO TSUBSISTEMATRANSACCIONESID VALUES ('14', '5004', '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', '14', '5004', '01', fncfhasta(), sysdate, 'Reportes de Activos Fijos', NULL, 0);

-- TCOMPANIATRANSACCIONES
INSERT INTO TCOMPANIATRANSACCIONES VALUES (2, '14', '5004', '01', 0);

-- TCOMPANIATRANSACCIONESPRODUCTO
INSERT INTO TCOMPANIATRANSACCIONESPRODUCTO VALUES (2, '14', '00', '000', '1', '002', '14', '5004', '01', 0);

-- TCOMPANIAROLES
INSERT INTO TCOMPANIAROLES VALUES (1, 2, '14', '5004', '01', NULL, NULL, 0);

-- TROLESHORARIO
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5004','01','USD','N',1,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500401USDN1',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5004','01','USD','N',2,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500401USDN2',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5004','01','USD','N',3,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500401USDN3',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5004','01','USD','N',4,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500401USDN4',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5004','01','USD','N',5,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500401USDN5',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5004','01','USD','N',6,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500401USDN6',0);
INSERT INTO TROLESHORARIO VALUES (1,2,'14','00','000','1','002','14','5004','01','USD','N',7,FNCFHASTA,SYSDATE,'0000','2359',NULL,'121400000100214500401USDN7',0);