spool DatosCamposParcial.log set Define "!" set feedback off set define off prompt Deleting TCAMPOSCONSULTABLES... delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TLOGMENSAJES'); prompt Deleting TCAMPOSCONSULTABLESID... delete from tCamposConsultablesId where tablabase='TLOGMENSAJES'; prompt Loading TCAMPOSCONSULTABLESID... insert into tCamposConsultablesId values(2670001,'TLOGMENSAJES','CCANAL',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2670002,'TLOGMENSAJES','CODIGORESULTADO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(80)',80,0,'0'); insert into tCamposConsultablesId values(2670003,'TLOGMENSAJES','CSUBSISTEMA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2670004,'TLOGMENSAJES','CTRANSACCION',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2670005,'TLOGMENSAJES','ESTADO',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2670006,'TLOGMENSAJES','FCONTABLE',5,null,null,'F',null,'0','0',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2670007,'TLOGMENSAJES','FINANCIERO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2670008,'TLOGMENSAJES','FREAL',5,null,null,'S',null,'0','0','Systimestamp ','0','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2670009,'TLOGMENSAJES','NUMEROMENSAJE',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(30)',30,0,'0'); insert into tCamposConsultablesId values(2670010,'TLOGMENSAJES','RESULTADO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(250)',250,0,'0'); insert into tCamposConsultablesId values(2670011,'TLOGMENSAJES','TIEMPO',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2670012,'TLOGMENSAJES','TIPOMENSAJE',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2670013,'TLOGMENSAJES','VERSIONTRANSACCION',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2670014,'TLOGMENSAJES','CUSUARIO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(12)',12,0,'0'); insert into tCamposConsultablesId values(2670015,'TLOGMENSAJES','CCUENTA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(40)',40,0,'0'); insert into tCamposConsultablesId values(2670016,'TLOGMENSAJES','CPERSONA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2670017,'TLOGMENSAJES','CPERSONA_COMPANIA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2670018,'TLOGMENSAJES','CTERMINAL',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2670019,'TLOGMENSAJES','ARCHIVO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(120)',120,0,'0'); insert into tCamposConsultablesId values(2670020,'TLOGMENSAJES','SESION',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(50)',50,0,'0'); insert into tCamposConsultablesId values(2670021,'TLOGMENSAJES','INFORMACIONADICIONAL',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(250)',250,0,'0'); prompt Loading TCAMPOSCONSULTABLES... insert into tCamposConsultables values('ES',2670001,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del canal en el que se origina la transaccion'); insert into tCamposConsultables values('ES',2670002,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la salida'); insert into tCamposConsultables values('ES',2670003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del subsistema de la transaccion'); insert into tCamposConsultables values('ES',2670004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la transaccion'); insert into tCamposConsultables values('ES',2670005,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indicador del estado del mensaje (FIT, COM, TER)'); insert into tCamposConsultables values('ES',2670006,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha contable de la transaccion'); insert into tCamposConsultables values('ES',2670007,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el mensaje es un procesamiento Financiero'); insert into tCamposConsultables values('ES',2670008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha real de la transaccion'); insert into tCamposConsultables values('ES',2670009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Numero de mensaje de FIT'); insert into tCamposConsultables values('ES',2670010,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Texto del mensaje de error'); insert into tCamposConsultables values('ES',2670011,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Tiempo de respuesta'); insert into tCamposConsultables values('ES',2670012,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indicador del tipo de mensaje SIG = sign on, FRM = financiero, MAN = mantenimiento, CON = consulta, REP = reporte, IMG = imagen, ESC = escaner'); insert into tCamposConsultables values('ES',2670013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Version de la transaccion'); insert into tCamposConsultables values('ES',2670014,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de usuario'); insert into tCamposConsultables values('ES',2670015,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de cuenta que puede ser externa en tal caso no existe la integridad referencial'); insert into tCamposConsultables values('ES',2670016,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Persona'); insert into tCamposConsultables values('ES',2670017,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Compania'); insert into tCamposConsultables values('ES',2670018,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Terminal'); insert into tCamposConsultables values('ES',2670019,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Ruta del Archivo que origina la Transaccion.'); insert into tCamposConsultables values('ES',2670020,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Token de la sesion'); insert into tCamposConsultables values('ES',2670021,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Registra informacion adicional del mensaje para auditoria'); commit; set Define "&" set feedback on prompt Done. spool off