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='TAT10INTERMEDIA'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TAT10RUBROS'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TAT10RUBROSID'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCONSULTASEXTERNAS'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCUENTAINTERESDIARIO'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TESTADOCUENTA'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TREPORTEDATOSDIARIO'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TSALDOSCONTABLESDIARIO'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TSALDOSMONEDACUENTADIARIO'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TSALDOSMONEDAOFICIALDIARIO'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TSENTENCIACONSULTA'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TTIPOSPLANTILLAREPORTES'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TTIPOSPLANTILLAREPORTESID'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TVARIABLESEXTERNASDEFINICION'); prompt Deleting TCAMPOSCONSULTABLESID... delete from tCamposConsultablesId where tablabase='TAT10INTERMEDIA'; delete from tCamposConsultablesId where tablabase='TAT10RUBROS'; delete from tCamposConsultablesId where tablabase='TAT10RUBROSID'; delete from tCamposConsultablesId where tablabase='TCONSULTASEXTERNAS'; delete from tCamposConsultablesId where tablabase='TCUENTAINTERESDIARIO'; delete from tCamposConsultablesId where tablabase='TESTADOCUENTA'; delete from tCamposConsultablesId where tablabase='TREPORTEDATOSDIARIO'; delete from tCamposConsultablesId where tablabase='TSALDOSCONTABLESDIARIO'; delete from tCamposConsultablesId where tablabase='TSALDOSMONEDACUENTADIARIO'; delete from tCamposConsultablesId where tablabase='TSALDOSMONEDAOFICIALDIARIO'; delete from tCamposConsultablesId where tablabase='TSENTENCIACONSULTA'; delete from tCamposConsultablesId where tablabase='TTIPOSPLANTILLAREPORTES'; delete from tCamposConsultablesId where tablabase='TTIPOSPLANTILLAREPORTESID'; delete from tCamposConsultablesId where tablabase='TVARIABLESEXTERNASDEFINICION'; prompt Loading TCAMPOSCONSULTABLESID... insert into tCamposConsultablesId values(2693001,'TESTADOCUENTA','CCUENTA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(2693002,'TESTADOCUENTA','DESCRIPCIONTRANSACCION',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(60)',60,0,'0'); insert into tCamposConsultablesId values(2693003,'TESTADOCUENTA','FCONTABLE',5,null,null,'F',null,'0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2693004,'TESTADOCUENTA','FREAL',5,null,null,'S',null,'0','1','','0','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2693005,'TESTADOCUENTA','NUMERODOCUMENTO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2693006,'TESTADOCUENTA','SALDO',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2693007,'TESTADOCUENTA','VALORCREDITOCUENTA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2693008,'TESTADOCUENTA','VALORDEBITOCUENTA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2693009,'TESTADOCUENTA','CPERSONA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2693010,'TESTADOCUENTA','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(2693011,'TESTADOCUENTA','SECUENCIA',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(10)',10,0,'0'); insert into tCamposConsultablesId values(2693012,'TESTADOCUENTA','SALDOBLOQUEADO',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2693013,'TESTADOCUENTA','SALDODIFERIDO',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2693014,'TESTADOCUENTA','SALDODISPONIBLE',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2693015,'TESTADOCUENTA','SALDOFECHA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2693016,'TESTADOCUENTA','SALDOPIGNORADO',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2693017,'TESTADOCUENTA','SALDOPROMEDIOMENSUAL',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2929001,'TAT10INTERMEDIA','BANCORELACION',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(20)',20,0,'0'); insert into tCamposConsultablesId values(2929002,'TAT10INTERMEDIA','CALIFICACIONRIESGO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2929003,'TAT10INTERMEDIA','CODIGOCONTABLE',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2929004,'TAT10INTERMEDIA','CUPON',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(10)',10,0,'0'); insert into tCamposConsultablesId values(2929005,'TAT10INTERMEDIA','FADQUISICION',5,null,null,'F',null,'0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2929006,'TAT10INTERMEDIA','FCONTABLE',5,null,null,'F',null,'0','0',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2929007,'TAT10INTERMEDIA','FEMISION',5,null,null,'F',null,'0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2929008,'TAT10INTERMEDIA','FVENCIMIENTO',5,null,null,'F',null,'0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2929009,'TAT10INTERMEDIA','GARANTE',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(50)',50,0,'0'); insert into tCamposConsultablesId values(2929010,'TAT10INTERMEDIA','INTERESPORCOBRAR',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(2929011,'TAT10INTERMEDIA','LOCALIDAD',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2929012,'TAT10INTERMEDIA','LUGAR',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(2929013,'TAT10INTERMEDIA','NOMBRECUENTA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(60)',60,0,'0'); insert into tCamposConsultablesId values(2929014,'TAT10INTERMEDIA','OBLIGACION',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(30)',30,0,'0'); insert into tCamposConsultablesId values(2929015,'TAT10INTERMEDIA','SALDOLIBROS',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(2929016,'TAT10INTERMEDIA','SALDOMERCADO',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(2929017,'TAT10INTERMEDIA','SALDONOMINAL',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(2929018,'TAT10INTERMEDIA','SUBSISTEMA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2929019,'TAT10INTERMEDIA','TASA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(10,6)',10,6,'0'); insert into tCamposConsultablesId values(2929020,'TAT10INTERMEDIA','TICKER',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(40)',40,0,'0'); insert into tCamposConsultablesId values(2930001,'TAT10RUBROS','CAT10RUBRO',5,null,null,'T',null,'1','0',null,'1','1',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0'); insert into tCamposConsultablesId values(2930002,'TAT10RUBROS','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(2930003,'TAT10RUBROS','DESCRIPCION',5,null,null,'T','1','0','0',null,'1','1',null,'1',null,null,null,'VARCHAR2(150)',150,0,'0'); insert into tCamposConsultablesId values(2930004,'TAT10RUBROS','FDESDE',5,null,null,'S',null,'0','0','','1','1',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2930005,'TAT10RUBROS','FHASTA',5,null,null,'S',null,'1','0','','1','1',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2930006,'TAT10RUBROS','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(2931001,'TAT10RUBROSID','CAT10RUBRO',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0'); insert into tCamposConsultablesId values(2932001,'TCONSULTASEXTERNAS','CCODIGOCONSULTA',5,null,null,'T',null,'1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2932002,'TCONSULTASEXTERNAS','CONSULTA',5,null,null,'T',null,'0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(4000)',4000,0,'0'); insert into tCamposConsultablesId values(2932003,'TCONSULTASEXTERNAS','CPERSONA_COMPANIA',5,null,null,'N',null,'1','0',null,'1','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2932004,'TCONSULTASEXTERNAS','FDESDE',5,null,null,'S',null,'0','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2932005,'TCONSULTASEXTERNAS','FHASTA',5,null,null,'S',null,'1','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2932006,'TCONSULTASEXTERNAS','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(2933001,'TCUENTAINTERESDIARIO','CCUENTA',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(2933002,'TCUENTAINTERESDIARIO','CMONEDA_OFICIAL',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2933003,'TCUENTAINTERESDIARIO','CPERSONA_COMPANIA',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2933004,'TCUENTAINTERESDIARIO','FCONTABLE',5,null,null,'F',null,'1','0',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2933005,'TCUENTAINTERESDIARIO','SALDOINTERES',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(2934001,'TREPORTEDATOSDIARIO','COLUMNA',5,null,null,'N',null,'0','0',null,'0','0',null,'1',null,null,null,'NUMBER(3)',3,0,'0'); insert into tCamposConsultablesId values(2934002,'TREPORTEDATOSDIARIO','CTIPOPLANTILLAREPORTE',5,null,null,'N',null,'0','0',null,'0','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(2934003,'TREPORTEDATOSDIARIO','DATO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1000)',1000,0,'0'); insert into tCamposConsultablesId values(2934004,'TREPORTEDATOSDIARIO','FCONTABLE',5,null,null,'F',null,'0','0',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2934005,'TREPORTEDATOSDIARIO','FILA',5,null,null,'N',null,'0','0',null,'0','0',null,'1',null,null,null,'NUMBER(10)',10,0,'0'); insert into tCamposConsultablesId values(2934006,'TREPORTEDATOSDIARIO','FORMATO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2934007,'TREPORTEDATOSDIARIO','OCULTAR',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2934008,'TREPORTEDATOSDIARIO','RESULTADO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2934009,'TREPORTEDATOSDIARIO','TIPODATO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2934010,'TREPORTEDATOSDIARIO','TITULO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2935001,'TSALDOSCONTABLESDIARIO','CODIGOCONTABLE',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2935002,'TSALDOSCONTABLESDIARIO','CPERSONA_COMPANIA',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2935003,'TSALDOSCONTABLESDIARIO','CSUCURSAL',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2935004,'TSALDOSCONTABLESDIARIO','CTIPOSALDOCATEGORIA',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2935005,'TSALDOSCONTABLESDIARIO','FCONTABLE',5,null,null,'F',null,'1','0',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2935006,'TSALDOSCONTABLESDIARIO','SALDO',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(2936001,'TSALDOSMONEDACUENTADIARIO','CCUENTA',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(2936002,'TSALDOSMONEDACUENTADIARIO','CGRUPOBALANCE',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2936003,'TSALDOSMONEDACUENTADIARIO','CMONEDA',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2936004,'TSALDOSMONEDACUENTADIARIO','CODIGOCONTABLE',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2936005,'TSALDOSMONEDACUENTADIARIO','COFICINA',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2936006,'TSALDOSMONEDACUENTADIARIO','CPERSONA_COMPANIA',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2936007,'TSALDOSMONEDACUENTADIARIO','CSUCURSAL',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2936008,'TSALDOSMONEDACUENTADIARIO','CTIPOSALDOCATEGORIA',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2936009,'TSALDOSMONEDACUENTADIARIO','FCONTABLE',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2936010,'TSALDOSMONEDACUENTADIARIO','SALDO',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(2936011,'TSALDOSMONEDACUENTADIARIO','SUBCUENTA',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2937001,'TSALDOSMONEDAOFICIALDIARIO','CCUENTA',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(2937002,'TSALDOSMONEDAOFICIALDIARIO','CGRUPOBALANCE',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2937003,'TSALDOSMONEDAOFICIALDIARIO','CMONEDA_OFICIAL',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2937004,'TSALDOSMONEDAOFICIALDIARIO','CODIGOCONTABLE',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2937005,'TSALDOSMONEDAOFICIALDIARIO','COFICINA',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2937006,'TSALDOSMONEDAOFICIALDIARIO','CPERSONA_COMPANIA',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2937007,'TSALDOSMONEDAOFICIALDIARIO','CSUCURSAL',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2937008,'TSALDOSMONEDAOFICIALDIARIO','CTIPOSALDOCATEGORIA',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2937009,'TSALDOSMONEDAOFICIALDIARIO','FCONTABLE',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2937010,'TSALDOSMONEDAOFICIALDIARIO','SALDO',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(2937011,'TSALDOSMONEDAOFICIALDIARIO','SUBCUENTA',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2938001,'TSENTENCIACONSULTA','CSENTENCIACONSULTA',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(30)',30,0,'0'); insert into tCamposConsultablesId values(2938002,'TSENTENCIACONSULTA','NOMBRE',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(200)',200,0,'0'); insert into tCamposConsultablesId values(2938003,'TSENTENCIACONSULTA','SENTENCIA',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'CLOB(4000)',4000,0,'0'); insert into tCamposConsultablesId values(2939001,'TTIPOSPLANTILLAREPORTES','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(2939002,'TTIPOSPLANTILLAREPORTES','CTIPOPLANTILLAREPORTE',5,null,null,'N',null,'1','0',null,'1','1',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(2939003,'TTIPOSPLANTILLAREPORTES','DESCRIPCION',5,null,null,'T','1','0','0',null,'1','1',null,'1',null,null,null,'VARCHAR2(150)',150,0,'0'); insert into tCamposConsultablesId values(2939004,'TTIPOSPLANTILLAREPORTES','FDESDE',5,null,null,'S',null,'0','0','','1','1',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2939005,'TTIPOSPLANTILLAREPORTES','FHASTA',5,null,null,'S',null,'1','0','','1','1',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2939006,'TTIPOSPLANTILLAREPORTES','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(2940001,'TTIPOSPLANTILLAREPORTESID','CTIPOPLANTILLAREPORTE',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(2941001,'TVARIABLESEXTERNASDEFINICION','CCODIGOVARIABLE',5,null,null,'T',null,'1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2941002,'TVARIABLESEXTERNASDEFINICION','CPERSONA_COMPANIA',5,null,null,'N',null,'1','0',null,'1','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2941003,'TVARIABLESEXTERNASDEFINICION','FDESDE',5,null,null,'S',null,'0','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2941004,'TVARIABLESEXTERNASDEFINICION','FHASTA',5,null,null,'S',null,'1','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2941005,'TVARIABLESEXTERNASDEFINICION','VALOR',5,null,null,'N',null,'0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2941006,'TVARIABLESEXTERNASDEFINICION','VERSIONCONTROL',5,null,null,'N',null,'0','1','0','1','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); prompt Loading TCAMPOSCONSULTABLES... insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693001,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 (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693002,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'),'Decripcion de la transaccion'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693003,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 del estado de cuenta'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693004,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 del movimiento'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693005,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 documento de la transaccion'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693006,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'),'Saldo de la cuenta'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693007,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 movimiento de credito'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693008,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 movimiento de debito'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693009,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'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693010,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 del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693011,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 consecutivo para el reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693012,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'),'Saldo Bloqueado'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693013,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'),'Saldo Diferido'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693014,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'),'Saldo disponible'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693015,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'),'Saldo a la Fecha'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693016,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'),'Saldo Pignorado'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2693017,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'),'Saldo Promedio Mensual'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929001,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'),'Banco relacionado con la operacion reportada'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929002,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'),'Calificacion de riesgo del banco relacioneado'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929003,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 contable'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929004,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 cupon de la operacion'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929005,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 adquisicion de la operacion reportada'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929006,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 del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929007,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 emision de la operacion reportada'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929008,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 vencimiento de la operacion reportada'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929009,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'),'Garante'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929010,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'),'Intereses por cobrar sobre la operacion reportada'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929011,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'),'Localidad'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929012,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'),'Lugar de la operacion'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929013,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'),'Nombre de la cuenta'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929014,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'),'Obligacion principal'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929015,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'),'Saldo en libros'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929016,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'),'Saldo del mercado'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929017,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'),'Saldo nominal'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929018,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'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929019,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'),'Tasa de la operacion reportada'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2929020,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 adicional'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2930001,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 rubro utilizado en el reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2930002,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 (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2930003,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 codigo de rubro utilizado en el reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2930004,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 codigo de rubro utilizado en el reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2930005,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 codigo de rubro utilizado en el reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2930006,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 locking.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2931001,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 rubro utilizado en el reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2932001,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 consulta externa'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2932002,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'),'Contiene el query de la consulta'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2932003,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 (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2932004,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 la consulta externa esta vigente'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2932005,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 la consulta externa esta vigente'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2932006,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 locking.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2933001,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 (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2933002,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 oficial'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2933003,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 a la que pertenece la cuenta, puede ser externa o compania licenciada'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2933004,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 a la que corresponde el saldo de intereses'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2933005,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'),'Saldo de interes de la cuenta en la moneda oficial'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2934001,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 columna de la matriz del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2934002,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 plantilla del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2934003,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'),'Contenido de la posicion de la matriz del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2934004,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 del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2934005,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 fila de la matriz del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2934006,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'),'Formato en el que se presenta el contenido de la posicion'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2934007,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 se debe ocultar la posicion'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2934008,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 posicion es el resultado final del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2934009,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'),'Tipo de dato del contenido de la posicion'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2934010,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'),'Titulo del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2935001,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 cuenta contable'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2935002,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 (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2935003,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 sucursal'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2935004,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 saldo de la categorķa SAL (Saldos de cuentas), ACC (provisiones)'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2935005,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 del saldo'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2935006,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'),'Saldo del codigo contable en la fecha'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2936001,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 producto o auxiliar'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2936002,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 grupo de balance'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2936003,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 de la cuenta.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2936004,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 contable.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2936005,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 oficina'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2936006,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 compania a la que pertenece la cuenta.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2936007,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 sucursal'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2936008,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 saldo de la categorķa SAL (Saldos de cuentas), ACC (provisiones)'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2936009,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 del saldo en la moneda de la cuenta.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2936010,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'),'Saldo en moneda de la cuenta.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2936011,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 subcuenta.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2937001,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 producto o auxiliar'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2937002,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 grupo de balance'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2937003,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 oficial'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2937004,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 contable.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2937005,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 oficina'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2937006,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 compania a la que pertenece la cuenta.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2937007,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 sucursal'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2937008,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 saldo de la categorķa SAL (Saldos de cuentas), ACC (provisiones)'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2937009,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 del saldo en la moneda de la cuenta.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2937010,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'),'Saldo en moneda de la cuenta.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2937011,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 subcuenta.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2938001,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 sentencia de consulta del proceso'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2938002,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'),'Nombre de la sentencia de consulta del proceso'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2938003,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'),'Sentencia utilizada para el proceso'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2939001,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 (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2939002,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 plantilla del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2939003,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 del tipo de plantilla del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2939004,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 del tipo de plantilla del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2939005,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 del tipo de plantilla del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2939006,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 locking.'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2940001,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 plantilla del reporte'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2941001,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 Variable Externa'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2941002,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 (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2941003,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 el valor de la variable esta vigente'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2941004,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 el valor de la variable esta vigente'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2941005,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 la variable externa'); insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2941006,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 locking.'); commit; set Define "&" set feedback on prompt Done. spool off