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='TCODIGOSCOMENTARIO'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCODIGOSCOMENTARIOID'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCUENTACOMENTARIOS'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TPERSONACOMENTARIOS'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TTIPOSCOMENTARIO'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TTIPOSCOMENTARIOID'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='VPERSONACOMENTARIOS'); prompt Deleting TCAMPOSCONSULTABLESID... delete from tCamposConsultablesId where tablabase='TCODIGOSCOMENTARIO'; delete from tCamposConsultablesId where tablabase='TCODIGOSCOMENTARIOID'; delete from tCamposConsultablesId where tablabase='TCUENTACOMENTARIOS'; delete from tCamposConsultablesId where tablabase='TPERSONACOMENTARIOS'; delete from tCamposConsultablesId where tablabase='TTIPOSCOMENTARIO'; delete from tCamposConsultablesId where tablabase='TTIPOSCOMENTARIOID'; delete from tCamposConsultablesId where tablabase='VPERSONACOMENTARIOS'; prompt Loading TCAMPOSCONSULTABLESID... insert into tCamposConsultablesId values(2921001,'TTIPOSCOMENTARIO','CIDIOMA',5,null,null,'T',null,'1','0',null,'1','1',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2921002,'TTIPOSCOMENTARIO','CTIPOCOMENTARIO',5,null,null,'T',null,'1','0',null,'1','1',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2921003,'TTIPOSCOMENTARIO','DESCRIPCION',5,null,null,'T','1','0','0',null,'1','1',null,'1',null,null,null,'VARCHAR2(30)',30,0,'0'); insert into tCamposConsultablesId values(2921004,'TTIPOSCOMENTARIO','FDESDE',5,null,null,'S',null,'0','0','','1','1',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2921005,'TTIPOSCOMENTARIO','FHASTA',5,null,null,'S',null,'1','0','','1','1',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2921006,'TTIPOSCOMENTARIO','VERSIONCONTROL',5,null,null,'N',null,'0','1','0','1','1',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2922001,'TTIPOSCOMENTARIOID','CTIPOCOMENTARIO',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(490001,'TCODIGOSCOMENTARIO','CCODIGOCOMENTARIO',5,null,null,'T','1','1','0',null,'1','1',null,'1',null,null,'0','VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(490002,'TCODIGOSCOMENTARIO','CIDIOMA',5,null,null,'T','1','1','0',null,'1','1',null,'1',null,null,'0','VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(490003,'TCODIGOSCOMENTARIO','DESCRIPCION',5,null,null,'T','1','0','0',null,'1','1',null,'1',null,null,'0','VARCHAR2(30)',30,0,'0'); insert into tCamposConsultablesId values(490004,'TCODIGOSCOMENTARIO','FDESDE',5,null,null,'S','0','0','0','','1','1',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(490005,'TCODIGOSCOMENTARIO','FHASTA',5,null,null,'S','0','1','0','','1','1',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(490006,'TCODIGOSCOMENTARIO','TEXTOCOMENTARIO',5,null,null,'T','0','0','1',null,'1','1',null,'1',null,null,null,'VARCHAR2(2000)',2000,0,'0'); insert into tCamposConsultablesId values(490008,'TCODIGOSCOMENTARIO','VERSIONCONTROL',5,null,null,'N','0','0','1','0','1','1',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(490009,'TCODIGOSCOMENTARIO','CTIPOCOMENTARIO',5,null,null,'T',null,'1','0',null,'1','1',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(491001,'TCODIGOSCOMENTARIOID','CCODIGOCOMENTARIO',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,'0','VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(491002,'TCODIGOSCOMENTARIOID','CTIPOCOMENTARIO',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(492001,'TCUENTACOMENTARIOS','CCUENTA',5,null,null,'T','0','1','0',null,'1','0',null,'1',null,null,'0','VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(492002,'TCUENTACOMENTARIOS','CCODIGOCOMENTARIO',5,null,null,'T','0','0','0',null,'1','0',null,'1',null,null,'0','VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(492003,'TCUENTACOMENTARIOS','COMENTARIO',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(2000)',2000,0,'0'); insert into tCamposConsultablesId values(492004,'TCUENTACOMENTARIOS','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(492005,'TCUENTACOMENTARIOS','CUSUARIO',5,null,null,'T','1','0','0',null,'1','0',null,'1',null,null,'0','VARCHAR2(12)',12,0,'0'); insert into tCamposConsultablesId values(492006,'TCUENTACOMENTARIOS','FCADUCIDAD',5,null,null,'F','0','0','1',null,'1','0',null,'1',null,null,'0','DATE',7,0,'0'); insert into tCamposConsultablesId values(492007,'TCUENTACOMENTARIOS','FDESDE',5,null,null,'S','0','0','0','','1','0',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(492008,'TCUENTACOMENTARIOS','FHASTA',5,null,null,'S','0','1','0','','1','0',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(492009,'TCUENTACOMENTARIOS','FINGRESO',5,null,null,'F','0','0','0',null,'1','0',null,'1',null,null,'0','DATE',7,0,'0'); insert into tCamposConsultablesId values(492010,'TCUENTACOMENTARIOS','SCOMENTARIO',5,null,null,'N','0','1','0',null,'1','0',null,'1','C','SCOMENTARIO','0','NUMBER(5)',5,0,'0'); insert into tCamposConsultablesId values(492012,'TCUENTACOMENTARIOS','ESTADOCOMENTARIO',5,null,null,'T','1','0','1','ING','1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(492014,'TCUENTACOMENTARIOS','VERSIONCONTROL',5,null,null,'N','0','0','1','0','1','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(492015,'TCUENTACOMENTARIOS','CTIPOCOMENTARIO',5,null,null,'T',null,'0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(493001,'TPERSONACOMENTARIOS','CCODIGOCOMENTARIO',5,null,null,'T','1','0','0',null,'1','0',null,'1',null,null,'0','VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(493002,'TPERSONACOMENTARIOS','COMENTARIO',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(2000)',2000,0,'0'); insert into tCamposConsultablesId values(493003,'TPERSONACOMENTARIOS','CPERSONA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(493004,'TPERSONACOMENTARIOS','CUSUARIO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(12)',12,0,'0'); insert into tCamposConsultablesId values(493005,'TPERSONACOMENTARIOS','FCADUCIDAD',5,null,null,'F','0','0','1',null,'1','0',null,'1',null,null,'0','DATE',7,0,'0'); insert into tCamposConsultablesId values(493006,'TPERSONACOMENTARIOS','FDESDE',5,null,null,'S','0','0','0','','1','0',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(493007,'TPERSONACOMENTARIOS','FHASTA',5,null,null,'S','0','1','0','','1','0',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(493008,'TPERSONACOMENTARIOS','FINGRESO',5,null,null,'F','0','0','0',null,'1','0',null,'1',null,null,'0','DATE',7,0,'0'); insert into tCamposConsultablesId values(493009,'TPERSONACOMENTARIOS','SCOMENTARIO',5,null,null,'N','0','1','0',null,'1','0',null,'1','C','SCOMENTARIO','0','NUMBER(5)',5,0,'0'); insert into tCamposConsultablesId values(493011,'TPERSONACOMENTARIOS','ESTADOCOMENTARIO',5,null,null,'T','1','0','1','ING','1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(493012,'TPERSONACOMENTARIOS','CONTADORALERTA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(493014,'TPERSONACOMENTARIOS','VERSIONCONTROL',5,null,null,'N','0','0','1','0','1','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(493015,'TPERSONACOMENTARIOS','ACUMULADOALERTA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(493016,'TPERSONACOMENTARIOS','CTIPOCOMENTARIO',5,null,null,'T',null,'0','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(668001,'VPERSONACOMENTARIOS','CCODIGOCOMENTARIO',5,null,null,'T','0','0','0',null,'1','1',null,'1',null,null,'0','VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(668002,'VPERSONACOMENTARIOS','CIDIOMA',5,null,null,'T','0','0','0',null,'1','1',null,'1',null,null,'0','VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(668003,'VPERSONACOMENTARIOS','CPERSONA',5,null,null,'N','0','1','0',null,'1','1',null,'1',null,null,'0','NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(668004,'VPERSONACOMENTARIOS','DESCRIPCIONCOMENTARIO',5,null,null,'T','1','0','0',null,'1','1',null,'1',null,null,'0','VARCHAR2(30)',30,0,'0'); insert into tCamposConsultablesId values(668005,'VPERSONACOMENTARIOS','FCADUCIDAD',5,null,null,'F','0','0','1',null,'1','1',null,'1',null,null,'0','DATE',7,0,'0'); insert into tCamposConsultablesId values(668006,'VPERSONACOMENTARIOS','TEXTOCOMENTARIO',5,null,null,'T','0','0','1',null,'1','1',null,'1',null,null,'0','VARCHAR2(2000)',2000,0,'0'); insert into tCamposConsultablesId values(668008,'VPERSONACOMENTARIOS','FHASTA',5,null,null,'S','0','0','0','','1','1',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(668009,'VPERSONACOMENTARIOS','CCUENTA',5,null,null,'T','0','1','1',null,'1','1',null,'1',null,null,null,'CHAR(1)',1,0,'0'); insert into tCamposConsultablesId values(668010,'VPERSONACOMENTARIOS','ESTADOCOMENTARIO',5,null,null,'T','0','0','1',null,'1','1',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(668011,'VPERSONACOMENTARIOS','CUSUARIO',5,null,null,'T','0','1','1',null,'1','1',null,'1',null,null,null,'VARCHAR2(12)',12,0,'0'); insert into tCamposConsultablesId values(668012,'VPERSONACOMENTARIOS','FINGRESO',5,null,null,'F','0','0','0',null,'1','1',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(668013,'VPERSONACOMENTARIOS','SECUENCIA',5,null,null,'N','0','1','1',null,'1','1',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); prompt Loading TCAMPOSCONSULTABLES... insert into tCamposConsultables values('ES',2921001,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 idioma'); insert into tCamposConsultables values('ES',2921002,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'),'Tipos de comentario que clasifican a los codigos de comentario en Internos, Externos, Reclamos, Cobranzas, Mercadeo.'); insert into tCamposConsultables values('ES',2921003,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'),'Descripcion del codigo identificativo de comentarios'); insert into tCamposConsultables values('ES',2921004,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 descripcion del codigo identificativo de comentarios'); insert into tCamposConsultables values('ES',2921005,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 descripcion del codigo identificativo de comentarios'); insert into tCamposConsultables values('ES',2921006,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',2922001,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'),'Tipos de comentario que clasifican a los codigos de comentario en Internos, Externos, Reclamos, Mercadeo.'); insert into tCamposConsultables values('ES',490001,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 identificativo del comentario de personas y operaciones'); insert into tCamposConsultables values('ES',490002,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 idioma'); insert into tCamposConsultables values('ES',490003,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'),'Descripcion del codigo identificativo de comentarios'); insert into tCamposConsultables values('ES',490004,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 descripcion del codigo identificativo de comentarios'); insert into tCamposConsultables values('ES',490005,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 descripcion del codigo identificativo de comentarios'); insert into tCamposConsultables values('ES',490006,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 asociado al codigo de comentarios'); insert into tCamposConsultables values('ES',490008,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',490009,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'),'Tipos de comentario que clasifican a los codigos de comentario en Internos, Externos, Reclamos, Mercadeo.'); insert into tCamposConsultables values('ES',491001,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 identificativo del comentario'); insert into tCamposConsultables values('ES',491002,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'),'Tipos de comentario que clasifican a los codigos de comentario en Internos, Externos, Reclamos, Mercadeo.'); insert into tCamposConsultables values('ES',492001,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'); insert into tCamposConsultables values('ES',492002,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 identificativo del comentario'); insert into tCamposConsultables values('ES',492003,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'),'Comentario sobre la cuenta'); insert into tCamposConsultables values('ES',492004,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 compania'); insert into tCamposConsultables values('ES',492005,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 ingresa o modifica el comentario'); insert into tCamposConsultables values('ES',492006,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 comentario'); insert into tCamposConsultables values('ES',492007,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 estan vigentes el comentario sobre la cuenta'); insert into tCamposConsultables values('ES',492008,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 estan vigentes el comentario sobre la cuenta'); insert into tCamposConsultables values('ES',492009,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 comentario'); insert into tCamposConsultables values('ES',492010,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 comentario sobre la cuenta'); insert into tCamposConsultables values('ES',492012,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'),'Estado del Comentario ING=Ingresado,ANU=Anulado,IMP=Impreso'); insert into tCamposConsultables values('ES',492014,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',492015,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'),'Tipos de comentario que clasifican a los codigos de comentario en Internos, Externos, Reclamos, Mercadeo.'); insert into tCamposConsultables values('ES',493001,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 identificativo del comentario'); insert into tCamposConsultables values('ES',493002,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'),'Comentario sobre la persona'); insert into tCamposConsultables values('ES',493003,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 persona'); insert into tCamposConsultables values('ES',493004,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',493005,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 comentario'); insert into tCamposConsultables values('ES',493006,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 estan vigentes el comentario sobre la persona'); insert into tCamposConsultables values('ES',493007,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 estan vigentes el comentario sobre la persona'); insert into tCamposConsultables values('ES',493008,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 comentario'); insert into tCamposConsultables values('ES',493009,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 comentario sobre la persona natural o juridica'); insert into tCamposConsultables values('ES',493011,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'),'Estado del Comentario ING=Ingresado,ANU=Anulado,IMP=Impreso'); insert into tCamposConsultables values('ES',493012,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'),'Contador de alertas cuando el mensaje es repetitivo'); insert into tCamposConsultables values('ES',493014,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',493015,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'),'Valor acumulado al presentar la alerta'); insert into tCamposConsultables values('ES',493016,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'),'Tipos de comentario que clasifican a los codigos de comentario en Internos, Externos, Mercadeo.'); insert into tCamposConsultables values('ES',668001,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 identificativo del comentario de personas y operaciones'); insert into tCamposConsultables values('ES',668002,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 idioma'); insert into tCamposConsultables values('ES',668003,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 persona'); insert into tCamposConsultables values('ES',668004,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'),'Descripcion del codigo identificativo de comentarios'); insert into tCamposConsultables values('ES',668005,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 comentario'); insert into tCamposConsultables values('ES',668006,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 comentario'); insert into tCamposConsultables values('ES',668008,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 estan vigentes el comentario sobre la persona'); insert into tCamposConsultables values('ES',668009,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'); insert into tCamposConsultables values('ES',668010,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'),'Estado del Comentario ING=Ingresado,ANU=Anulado,IMP=Impreso'); insert into tCamposConsultables values('ES',668011,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',668012,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 comentario'); insert into tCamposConsultables values('ES',668013,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 consecutivo del registro'); commit; set Define "&" set feedback on prompt Done. spool off