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='TCLASESEMPRESAID'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TJURIDICOINFORMACIONBASICA'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TTIPOSEMPRESAID'); prompt Deleting TCAMPOSCONSULTABLESID... delete from tCamposConsultablesId where tablabase='TCLASESEMPRESAID'; delete from tCamposConsultablesId where tablabase='TJURIDICOINFORMACIONBASICA'; delete from tCamposConsultablesId where tablabase='TTIPOSEMPRESAID'; prompt Loading TCAMPOSCONSULTABLESID... insert into tCamposConsultablesId values(143001,'TJURIDICOINFORMACIONBASICA','CANTIDADEMPLEADOS',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(5)',5,0,'0'); insert into tCamposConsultablesId values(143002,'TJURIDICOINFORMACIONBASICA','CCLASEEMPRESA',5,null,null,'T','1','0','1',null,'1','0',16,'1',null,null,'0','VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(143003,'TJURIDICOINFORMACIONBASICA','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(143004,'TJURIDICOINFORMACIONBASICA','CTIPOEMPRESA',5,null,null,'T','1','0','1',null,'1','0',54,'1',null,null,'0','VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(143005,'TJURIDICOINFORMACIONBASICA','CTIPOINSTITUCION',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(143006,'TJURIDICOINFORMACIONBASICA','FCONSTITUCION',5,null,null,'F','0','0','1',null,'1','0',null,'1',null,null,'0','DATE',7,0,'0'); insert into tCamposConsultablesId values(143007,'TJURIDICOINFORMACIONBASICA','FDESDE',5,null,null,'S','0','0','0','','1','0',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(143008,'TJURIDICOINFORMACIONBASICA','FHASTA',5,null,null,'S','0','1','0','','1','0',null,'1',null,null,'0','TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(143009,'TJURIDICOINFORMACIONBASICA','NUMEROPATRONAL',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(18)',18,0,'0'); insert into tCamposConsultablesId values(143010,'TJURIDICOINFORMACIONBASICA','REGISTROMERCANTIL',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(18)',18,0,'0'); insert into tCamposConsultablesId values(143011,'TJURIDICOINFORMACIONBASICA','CAPITALSUSCRITO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(143012,'TJURIDICOINFORMACIONBASICA','LIMITACIONESESTATUTARIAS',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(2000)',2000,0,'0'); insert into tCamposConsultablesId values(143013,'TJURIDICOINFORMACIONBASICA','LIMITACIONESLEGALES',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(2000)',2000,0,'0'); insert into tCamposConsultablesId values(143014,'TJURIDICOINFORMACIONBASICA','OBJETIVOSOCIAL',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(2000)',2000,0,'0'); insert into tCamposConsultablesId values(143015,'TJURIDICOINFORMACIONBASICA','REPRESENTACIONLEGAL',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(2000)',2000,0,'0'); insert into tCamposConsultablesId values(143016,'TJURIDICOINFORMACIONBASICA','CESTATUSESTADOFINANCIERO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(143017,'TJURIDICOINFORMACIONBASICA','CVENTAANUAL',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(143018,'TJURIDICOINFORMACIONBASICA','CAPITALSOCIALORIGINAL',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,'0','NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(143019,'TJURIDICOINFORMACIONBASICA','CODIGOINSTITUCION',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(10)',10,0,'0'); insert into tCamposConsultablesId values(143020,'TJURIDICOINFORMACIONBASICA','CODIGOINSTITUCIONACH',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(10)',10,0,'0'); insert into tCamposConsultablesId values(143021,'TJURIDICOINFORMACIONBASICA','RUTATRANSITO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(143022,'TJURIDICOINFORMACIONBASICA','CCALIFICACIONRIESGO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(143023,'TJURIDICOINFORMACIONBASICA','CPERSONA_CALIFICADORA',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(143024,'TJURIDICOINFORMACIONBASICA','CAPITALPAGADO',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(143025,'TJURIDICOINFORMACIONBASICA','PERCEPCIONADMINISTRACION',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(143026,'TJURIDICOINFORMACIONBASICA','PERCEPCIONNEGOCIO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(143027,'TJURIDICOINFORMACIONBASICA','CONTRATOCOLECTIVO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(143028,'TJURIDICOINFORMACIONBASICA','HISTORIAEMPRESA',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(2000)',2000,0,'0'); insert into tCamposConsultablesId values(143029,'TJURIDICOINFORMACIONBASICA','SINDICATO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(143030,'TJURIDICOINFORMACIONBASICA','CODIGOINSTITUCIONBC',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(10)',10,0,'0'); insert into tCamposConsultablesId values(143031,'TJURIDICOINFORMACIONBASICA','CUENTABANCOINSTITUCION',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(143032,'TJURIDICOINFORMACIONBASICA','NUMEROTURNOS',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(143033,'TJURIDICOINFORMACIONBASICA','VENTASESTIMADAS',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(143034,'TJURIDICOINFORMACIONBASICA','CTIPOCLIENTE',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(143035,'TJURIDICOINFORMACIONBASICA','EXPUESTORIESGO',5,null,null,'T',null,'0','1','0','1','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(143036,'TJURIDICOINFORMACIONBASICA','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(143037,'TJURIDICOINFORMACIONBASICA','CFRECUENCIA_REUNION',5,null,null,'N',null,'0','1',null,'1','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(143038,'TJURIDICOINFORMACIONBASICA','DIAREUNION',5,null,null,'N',null,'0','1',null,'1','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(311001,'TTIPOSEMPRESAID','CTIPOEMPRESA',5,null,null,'T','1','1','0',null,'0','0',54,'1',null,null,'0','VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(311002,'TTIPOSEMPRESAID','NOAPLICA',5,null,null,'T','1','0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(311003,'TTIPOSEMPRESAID','MICROEMPRESA',5,null,null,'T',null,'0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(36001,'TCLASESEMPRESAID','CCLASEEMPRESA',5,null,null,'T','1','1','0',null,'0','0',16,'1',null,null,'0','VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(36002,'TCLASESEMPRESAID','MICROEMPRESA',5,null,null,'T',null,'0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); prompt Loading TCAMPOSCONSULTABLES... insert into tCamposConsultables values('ES',143001,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 empleados vigentes de la empresa'); insert into tCamposConsultables values('ES',143002,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 clase de empresa para personas juridicas'); insert into tCamposConsultables values('ES',143003,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',143004,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 empresa de una persona juridica'); insert into tCamposConsultables values('ES',143005,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 institucion financiera'); insert into tCamposConsultables values('ES',143006,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 constitucion de luna persona juridica'); insert into tCamposConsultables values('ES',143007,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 basica de una persona juridica'); insert into tCamposConsultables values('ES',143008,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 basica de una persona juridica'); insert into tCamposConsultables values('ES',143009,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 patronal de una persona juridica'); insert into tCamposConsultables values('ES',143010,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 registro mercantil de una persona juridica'); insert into tCamposConsultables values('ES',143011,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 de capital suscrito por la persona juridica'); insert into tCamposConsultables values('ES',143012,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'),'Informacion sobre las limitaciones estatutarias de la persona juridica'); insert into tCamposConsultables values('ES',143013,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'),'Informacion sobre las limitaciones legales de la persona juridica'); insert into tCamposConsultables values('ES',143014,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'),'Informacion del objetivo social de la persona juridica'); insert into tCamposConsultables values('ES',143015,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'),'Informacion de la representacion legal de la persona juridica'); insert into tCamposConsultables values('ES',143016,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 estatus del estado financiero de la persona juridica'); insert into tCamposConsultables values('ES',143017,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 promedio de ventas anuales en rangos de personas juridicas'); insert into tCamposConsultables values('ES',143018,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 del capital social original de una persona juridica'); insert into tCamposConsultables values('ES',143019,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 institucion externo para la entidad reportante'); insert into tCamposConsultables values('ES',143020,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 institucion ACH para manejo de transferencias externas'); insert into tCamposConsultables values('ES',143021,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 ruta transito asociado a la institucion externa'); insert into tCamposConsultables values('ES',143022,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 calificacion de riesgo de la persona juridica'); insert into tCamposConsultables values('ES',143023,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 calificadora de riesgo'); insert into tCamposConsultables values('ES',143024,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 de capital pagado de la persona juridica'); insert into tCamposConsultables values('ES',143025,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'),'Informacion de la percepcion de la administracion de la persona juridica M = Muy Buena, B = Buena, D = Deficiente y L = Malo.'); insert into tCamposConsultables values('ES',143026,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'),'Informacion de la percepcion del negocio de la persona juridica: M = Muy Buena, B = Buena, D = Deficiente y L = Malo.'); insert into tCamposConsultables values('ES',143027,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 la empresa tiene contrato colectivo con sus empleados o no'); insert into tCamposConsultables values('ES',143028,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'),'Informacion de la historia de la persona juridica'); insert into tCamposConsultables values('ES',143029,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 la empresa tiene sindicato o no'); insert into tCamposConsultables values('ES',143030,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 institucion dada por el Banco Central'); insert into tCamposConsultables values('ES',143031,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 institucion en el organismo de control o Banco Central'); insert into tCamposConsultables values('ES',143032,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 turnos por horas de los empleados de la persona juridica'); insert into tCamposConsultables values('ES',143033,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'),'Promedio de ventas anuales estimadas de personas juridicas'); insert into tCamposConsultables values('ES',143034,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 los tipos de cliente de una persona juridica'); insert into tCamposConsultables values('ES',143035,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 la persona juridica esta expuesta o no a riesgo crediticio y cambiario'); insert into tCamposConsultables values('ES',143036,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',143037,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 frecuencia en la que se realizaran las reuniones para el grupo de microcredito'); insert into tCamposConsultables values('ES',143038,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'),'Define el dia en que se realizaran las reuniones para el grupo de microcredito'); insert into tCamposConsultables values('ES',311001,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 empresa de una persona juridica'); insert into tCamposConsultables values('ES',311002,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 codigo no aplica 1 a una persona juridica o si aplica 0'); insert into tCamposConsultables values('ES',311003,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 tipo de empresa corresponde a micro empresas o no'); insert into tCamposConsultables values('ES',36001,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 clase de empresa para personas juridicas'); insert into tCamposConsultables values('ES',36002,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 codigo de clase de la empresa corresponde a micro empresas o no'); commit; set Define "&" set feedback on prompt Done. spool off