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='TGARANTIADOCUMENTOSENTREGADOS'); prompt Deleting TCAMPOSCONSULTABLESID... delete from tCamposConsultablesId where tablabase='TGARANTIADOCUMENTOSENTREGADOS'; prompt Loading TCAMPOSCONSULTABLESID... insert into tCamposConsultablesId values(128002,'TGARANTIADOCUMENTOSENTREGADOS','CIMAGEN',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(10)',10,0,'0'); insert into tCamposConsultablesId values(128003,'TGARANTIADOCUMENTOSENTREGADOS','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(128004,'TGARANTIADOCUMENTOSENTREGADOS','CTIPODOCUMENTOGARANTIA',5,null,null,'N','0','0','0',null,'1','0',51,'1',null,null,'0','NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(128005,'TGARANTIADOCUMENTOSENTREGADOS','FCADUCIDAD',5,null,null,'F','0','0','1',null,'1','0',null,'1',null,null,'0','DATE',7,0,'0'); insert into tCamposConsultablesId values(128006,'TGARANTIADOCUMENTOSENTREGADOS','FDESDE',5,null,null,'S','0','0','0','','1','0',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(128007,'TGARANTIADOCUMENTOSENTREGADOS','FENTREGA',5,null,null,'F','0','0','1',null,'1','0',null,'1',null,null,'0','DATE',7,0,'0'); insert into tCamposConsultablesId values(128008,'TGARANTIADOCUMENTOSENTREGADOS','FHASTA',5,null,null,'S','0','1','0','','1','0',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(128009,'TGARANTIADOCUMENTOSENTREGADOS','FPARARENOVAR',5,null,null,'F','0','0','1',null,'1','0',null,'1',null,null,'0','DATE',7,0,'0'); insert into tCamposConsultablesId values(128010,'TGARANTIADOCUMENTOSENTREGADOS','NUMERORENOVACION',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(128011,'TGARANTIADOCUMENTOSENTREGADOS','REFERENCIA',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(10)',10,0,'0'); insert into tCamposConsultablesId values(128012,'TGARANTIADOCUMENTOSENTREGADOS','SDOCUMENTOGARANTIA',5,null,null,'N','0','1','0',null,'1','0',null,'1','C','SDOCUMENTOGARANTIA','0','NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(128013,'TGARANTIADOCUMENTOSENTREGADOS','UBICACION',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(60)',60,0,'0'); insert into tCamposConsultablesId values(128014,'TGARANTIADOCUMENTOSENTREGADOS','COMENTARIOS',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(200)',200,0,'0'); insert into tCamposConsultablesId values(128015,'TGARANTIADOCUMENTOSENTREGADOS','CUSUARIO_ENTREGA',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(12)',12,0,'0'); insert into tCamposConsultablesId values(128016,'TGARANTIADOCUMENTOSENTREGADOS','FINSCRIPCION',5,null,null,'F','0','0','1',null,'1','0',null,'1',null,null,'0','DATE',7,0,'0'); insert into tCamposConsultablesId values(128017,'TGARANTIADOCUMENTOSENTREGADOS','CMONEDA_DOCUMENTO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(128018,'TGARANTIADOCUMENTOSENTREGADOS','CPERSONA_DOCUMENTO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(128019,'TGARANTIADOCUMENTOSENTREGADOS','CPERSONA_EMISOR',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(128020,'TGARANTIADOCUMENTOSENTREGADOS','CPERSONA_NOTARIA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(128021,'TGARANTIADOCUMENTOSENTREGADOS','MONTODOCUMENTO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(19,2)',19,2,'0'); insert into tCamposConsultablesId values(128022,'TGARANTIADOCUMENTOSENTREGADOS','NUMERODOCUMENTO',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(128023,'TGARANTIADOCUMENTOSENTREGADOS','NUMEROHOJA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(10)',10,0,'0'); insert into tCamposConsultablesId values(128024,'TGARANTIADOCUMENTOSENTREGADOS','NUMEROREGISTRO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(10)',10,0,'0'); insert into tCamposConsultablesId values(128025,'TGARANTIADOCUMENTOSENTREGADOS','NUMEROREPETITORIO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(10)',10,0,'0'); insert into tCamposConsultablesId values(128026,'TGARANTIADOCUMENTOSENTREGADOS','NUMEROTOMO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(10)',10,0,'0'); insert into tCamposConsultablesId values(128027,'TGARANTIADOCUMENTOSENTREGADOS','DOCUMENTOORIGINAL',5,null,null,'T','1','0','1','1','1','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(128028,'TGARANTIADOCUMENTOSENTREGADOS','NUMEROHOJAFINAL',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(10)',10,0,'0'); insert into tCamposConsultablesId values(128029,'TGARANTIADOCUMENTOSENTREGADOS','CCODIGOUBICACION',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(128030,'TGARANTIADOCUMENTOSENTREGADOS','NOTARIA',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(100)',100,0,'0'); insert into tCamposConsultablesId values(128031,'TGARANTIADOCUMENTOSENTREGADOS','CCUENTA',5,null,null,'T',null,'1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(128032,'TGARANTIADOCUMENTOSENTREGADOS','CUSUARIO_INGRESO',5,null,null,'T',null,'0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(12)',12,0,'0'); insert into tCamposConsultablesId values(128033,'TGARANTIADOCUMENTOSENTREGADOS','CUSUARIO_MODIFICACION',5,null,null,'T',null,'0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(12)',12,0,'0'); insert into tCamposConsultablesId values(128034,'TGARANTIADOCUMENTOSENTREGADOS','VERSIONCONTROL',5,null,null,'N',null,'0','1','0','1','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(128035,'TGARANTIADOCUMENTOSENTREGADOS','CUSUARIO_DEVOLUCION',5,null,null,'T',null,'0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(128036,'TGARANTIADOCUMENTOSENTREGADOS','FDEVOLUCION',5,null,null,'F',null,'0','1',null,'1','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(128037,'TGARANTIADOCUMENTOSENTREGADOS','CUSUARIO_INGRESOCUSTODIO',5,null,null,'T',null,'0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(128038,'TGARANTIADOCUMENTOSENTREGADOS','FINGRESOCUSTODIO',5,null,null,'F',null,'0','1',null,'1','0',null,'1',null,null,null,'DATE',7,0,'0'); prompt Loading TCAMPOSCONSULTABLES... insert into tCamposConsultables values('ES',128002,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 imagen del documento entregado como respaldo de una garantia'); insert into tCamposConsultables values('ES',128003,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 compania'); insert into tCamposConsultables values('ES',128004,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 tipo de documento requerido para respaldo de una garantia'); insert into tCamposConsultables values('ES',128005,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 de caducidad del documento entregado como respaldo de una garantia'); insert into tCamposConsultables values('ES',128006,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 desde la que esta vigente la informacion de referencias bancarias del documento entregado de una garantia'); insert into tCamposConsultables values('ES',128007,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 de entrega del documento de respaldo de una garantia'); insert into tCamposConsultables values('ES',128008,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 hasta la que esta vigente la informacion de referencias bancarias del documento entregado de una garantia'); insert into tCamposConsultables values('ES',128009,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 en la que se debe renovar el documento entregado para respaldo de una garantia'); insert into tCamposConsultables values('ES',128010,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 renovacion de la garantia'); insert into tCamposConsultables values('ES',128011,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'),'Referencia del documento entregado para respaldo de la garantia'); insert into tCamposConsultables values('ES',128012,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'),'Secuencia del documento entregado como respaldo de una garantia'); insert into tCamposConsultables values('ES',128013,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'),'Ubicacion del documento entregado para respaldo de una garantia'); insert into tCamposConsultables values('ES',128014,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'),'Comentarios sobre el documento'); insert into tCamposConsultables values('ES',128015,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 usuario a quien el cliente entrega el documento'); insert into tCamposConsultables values('ES',128016,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 de inscripcion del documento en el registro mercantil, de la propiedad, respectivamente'); insert into tCamposConsultables values('ES',128017,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 moneda del documento de la garantia'); insert into tCamposConsultables values('ES',128018,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 persona del documento'); insert into tCamposConsultables values('ES',128019,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 persona del emisor del documento de la garantia'); insert into tCamposConsultables values('ES',128020,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 persona de la notaria que registra el documento de la garantia'); insert into tCamposConsultables values('ES',128021,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'),'Monto nominal del documento de la garantia'); insert into tCamposConsultables values('ES',128022,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 del documento de la garantia fiduciaria'); insert into tCamposConsultables values('ES',128023,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 hoja de registro del documento de respaldo de la garantia'); insert into tCamposConsultables values('ES',128024,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 registro del documento entregado de la garantia'); insert into tCamposConsultables values('ES',128025,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 repetitorio de registro del documento de la garantia'); insert into tCamposConsultables values('ES',128026,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 tomo de registro del documento de respaldo de la garantia'); insert into tCamposConsultables values('ES',128027,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'),'Marca si el documento entregado es original o no'); insert into tCamposConsultables values('ES',128028,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 hoja final de registro del documento de respaldo de la garantia'); insert into tCamposConsultables values('ES',128029,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 ubicacion del documento ode la garantia entregada'); insert into tCamposConsultables values('ES',128030,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'),'Detalle del numero de notaria para el registro del documento'); insert into tCamposConsultables values('ES',128031,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 cuenta de la garantia'); insert into tCamposConsultables values('ES',128032,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 que ingresa '); insert into tCamposConsultables values('ES',128033,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 que modofica'); insert into tCamposConsultables values('ES',128034,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'),'Manejo de optimistic loking'); insert into tCamposConsultables values('ES',128035,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 usuario que realiza la devolucion del documento de la garantia'); insert into tCamposConsultables values('ES',128036,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 en la que se realiza la devolucion del documento de la garantia'); insert into tCamposConsultables values('ES',128037,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 usuario que registra el ingreso del documento a custodia'); insert into tCamposConsultables values('ES',128038,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 de ingreso del documento a custodia'); commit; set Define "&" set feedback on prompt Done. spool off