-- Deleting TCAMPOSCONSULTABLES... delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TMOVIMIENTOS'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TSALDOS'); -- Deleting TCAMPOSCONSULTABLESID... delete from tCamposConsultablesId where tablabase='TMOVIMIENTOS'; delete from tCamposConsultablesId where tablabase='TSALDOS'; -- Loading TCAMPOSCONSULTABLESID... insert into tCamposConsultablesId values(2524001,'TMOVIMIENTOS','CATEGORIA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0'); insert into tCamposConsultablesId values(2524002,'TMOVIMIENTOS','CCANAL',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2524003,'TMOVIMIENTOS','CCONCEPTO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2524004,'TMOVIMIENTOS','CCONCEPTOCONTABLE',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2524005,'TMOVIMIENTOS','CCUENTA',5,null,null,'T','0','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(2524007,'TMOVIMIENTOS','CGRUPOBALANCE',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2524009,'TMOVIMIENTOS','CIMAGENDOCUMENTO',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(10)',10,0,'0'); insert into tCamposConsultablesId values(2524010,'TMOVIMIENTOS','CMONEDA_CUENTA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2524011,'TMOVIMIENTOS','CMONEDA_OFICIAL',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2524012,'TMOVIMIENTOS','CODIGOCONTABLE',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2524013,'TMOVIMIENTOS','CODIGODEPOSITO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(10)',10,0,'0'); insert into tCamposConsultablesId values(2524014,'TMOVIMIENTOS','CODIGOPLAZO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2524015,'TMOVIMIENTOS','COFICINA_CUENTA',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2524016,'TMOVIMIENTOS','CPERSONA_CLIENTE',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2524017,'TMOVIMIENTOS','CPERSONA_COMPANIA',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2524019,'TMOVIMIENTOS','CPERSONA_TRANSACCION',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2524021,'TMOVIMIENTOS','CSUBSISTEMA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2524022,'TMOVIMIENTOS','CSUBSISTEMA_ORIGEN',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2524023,'TMOVIMIENTOS','CSUBSISTEMA_TRANSACCION',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2524024,'TMOVIMIENTOS','CSUCURSAL_CUENTA',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2524025,'TMOVIMIENTOS','CTERMINAL',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2524027,'TMOVIMIENTOS','CTIPOPERSONA',5,null,null,'T','0','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2524028,'TMOVIMIENTOS','CTRANSACCION',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2524029,'TMOVIMIENTOS','CTRANSACCION_ORIGEN',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2524030,'TMOVIMIENTOS','CUSUARIO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(12)',12,0,'0'); insert into tCamposConsultablesId values(2524031,'TMOVIMIENTOS','CUSUARIO_AUTORIZADOR',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(12)',12,0,'0'); insert into tCamposConsultablesId values(2524032,'TMOVIMIENTOS','DEBITOCREDITO',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2524033,'TMOVIMIENTOS','DETALLE',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(500)',500,0,'0'); insert into tCamposConsultablesId values(2524034,'TMOVIMIENTOS','FAPPSERVER',5,null,null,'S','0','0','0','','0','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2524035,'TMOVIMIENTOS','FCONTABLE',5,null,null,'F','0','0','0',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2524037,'TMOVIMIENTOS','FPAGO',5,null,null,'F','0','0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2524038,'TMOVIMIENTOS','FREAL',5,null,null,'S','0','0','0','SYSTIMESTAMP ','0','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0'); insert into tCamposConsultablesId values(2524039,'TMOVIMIENTOS','FVENCIMIENTO',5,null,null,'F','0','0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2524040,'TMOVIMIENTOS','IDENTIFICACION',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(18)',18,0,'0'); insert into tCamposConsultablesId values(2524041,'TMOVIMIENTOS','MODO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2524042,'TMOVIMIENTOS','NUMERODOCUMENTO',5,null,null,'T','0','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2524043,'TMOVIMIENTOS','NUMEROMENSAJE',5,null,null,'T','0','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(30)',30,0,'0'); insert into tCamposConsultablesId values(2524044,'TMOVIMIENTOS','NUMEROMENSAJE_REVERSO',5,null,null,'T','0','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(30)',30,0,'0'); insert into tCamposConsultablesId values(2524046,'TMOVIMIENTOS','PARTICION',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0'); insert into tCamposConsultablesId values(2524047,'TMOVIMIENTOS','PROVISIONA',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2524048,'TMOVIMIENTOS','REVERSO',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2524049,'TMOVIMIENTOS','RUBRO',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2524050,'TMOVIMIENTOS','STRANSACCION',5,null,null,'N','0','1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2524051,'TMOVIMIENTOS','SUBCUENTA',5,null,null,'N','0','0','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2524055,'TMOVIMIENTOS','VALORMONEDACUENTA',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2524056,'TMOVIMIENTOS','VALORMONEDAOFICIAL',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2524057,'TMOVIMIENTOS','VERSIONTRANSACCION',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2524058,'TMOVIMIENTOS','VERSIONTRANSACCION_ORIGEN',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2524059,'TMOVIMIENTOS','NUMEROCOMPROBANTE',5,null,null,'T','0','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(30)',30,0,'0'); insert into tCamposConsultablesId values(2524062,'TMOVIMIENTOS','COFICINA_ORIGEN',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2524063,'TMOVIMIENTOS','CSUCURSAL_ORIGEN',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2524064,'TMOVIMIENTOS','CTIPOSALDOCATEGORIA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2524065,'TMOVIMIENTOS','CCALIFICACIONRIESGO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2524067,'TMOVIMIENTOS','CSECTORECONOMICO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0'); insert into tCamposConsultablesId values(2524069,'TMOVIMIENTOS','CCLASIFICACIONCONTABLE',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2524070,'TMOVIMIENTOS','CESTATUSCUENTA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2524071,'TMOVIMIENTOS','CMONEDA_MOVIMIENTO',5,null,null,'T','0','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2524072,'TMOVIMIENTOS','COTIZACION',5,null,null,'N','0','0','0',null,'0','0',null,'1',null,null,null,'NUMBER(12,7)',12,7,'0'); insert into tCamposConsultablesId values(2524073,'TMOVIMIENTOS','CTIPOCAMBIO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2524074,'TMOVIMIENTOS','FVALOR',5,null,null,'F','0','0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2524075,'TMOVIMIENTOS','ORIGENDESTINO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2524076,'TMOVIMIENTOS','VALORMONEDAMOVIMIENTO',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); insert into tCamposConsultablesId values(2524077,'TMOVIMIENTOS','IDENTIFICACIONBENEFICIARIO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(2524078,'TMOVIMIENTOS','NOMBREBENEFICIARIO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(80)',80,0,'0'); insert into tCamposConsultablesId values(2524079,'TMOVIMIENTOS','VALORCALCULOTARIFARIO',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(2524080,'TMOVIMIENTOS','CGRUPOPRODUCTO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2524081,'TMOVIMIENTOS','CPRODUCTO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2524082,'TMOVIMIENTOS','NUMERODOCUMENTOFINAL',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2524083,'TMOVIMIENTOS','CCODIGOUSUARIO',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(6)',6,0,'0'); insert into tCamposConsultablesId values(2524084,'TMOVIMIENTOS','FPROCESO',5,null,null,'F',null,'0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2524085,'TMOVIMIENTOS','CTIPODOCUMENTOPERSONA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0'); insert into tCamposConsultablesId values(2524086,'TMOVIMIENTOS','CTIPOIDENTIFICACION',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2524087,'TMOVIMIENTOS','SSUBCUENTA',5,null,null,'N',null,'0','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2524088,'TMOVIMIENTOS','CAREA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2524089,'TMOVIMIENTOS','FPROCESOCOMPENSACION',5,null,null,'F',null,'0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2524090,'TMOVIMIENTOS','FPROCESOCUADRE',5,null,null,'F',null,'0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2524091,'TMOVIMIENTOS','REVERSOFECHAVALOR',5,null,null,'T',null,'0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2524092,'TMOVIMIENTOS','VALORPLANILLA',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(2524093,'TMOVIMIENTOS','CESTADOOPERACION',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2524094,'TMOVIMIENTOS','CAPITALREDUCIDO',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(2566001,'TSALDOS','CATEGORIA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0'); insert into tCamposConsultablesId values(2566002,'TSALDOS','CCUENTA',5,null,null,'T','0','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0'); insert into tCamposConsultablesId values(2566004,'TSALDOS','CGRUPOBALANCE',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2566006,'TSALDOS','CMONEDA_CUENTA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2566007,'TSALDOS','CMONEDA_OFICIAL',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2566008,'TSALDOS','CODIGOCONTABLE',5,null,null,'T','1','0','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0'); insert into tCamposConsultablesId values(2566009,'TSALDOS','CODIGOPLAZO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2566010,'TSALDOS','CPERSONA_CLIENTE',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2566012,'TSALDOS','CSUBSISTEMA',5,null,null,'T','1','0','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2566013,'TSALDOS','FCONTABLEDESDE',5,null,null,'F','0','0','0',null,'1','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2566014,'TSALDOS','FCONTABLEHASTA',5,null,null,'F','0','0','0',null,'1','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2566015,'TSALDOS','FVENCIMIENTO',5,null,null,'F','0','0','1',null,'1','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2566016,'TSALDOS','PARTICION',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0'); insert into tCamposConsultablesId values(2566017,'TSALDOS','PROVISIONA',5,null,null,'T','1','0','0',null,'1','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2566018,'TSALDOS','SALDOMONEDACUENTA',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(2566019,'TSALDOS','SALDOMONEDAOFICIAL',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(2566020,'TSALDOS','SUBCUENTA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2566024,'TSALDOS','CTIPOSALDOCATEGORIA',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2566025,'TSALDOS','PRINCIPAL',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2566026,'TSALDOS','PROVISIONDIA',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(2566027,'TSALDOS','PROVISIONDIAOFICIAL',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(2566028,'TSALDOS','CSUCURSAL',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2566029,'TSALDOS','CPRODUCTO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2566030,'TSALDOS','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0'); insert into tCamposConsultablesId values(2566031,'TSALDOS','COFICINA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2566032,'TSALDOS','CGRUPOPRODUCTO',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2566033,'TSALDOS','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(2566034,'TSALDOS','AJUSTEINTERESOFICIAL',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(2566035,'TSALDOS','AJUSTEINTERES',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(2566038,'TSALDOS','CCLASIFICACIONCONTABLE',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2566039,'TSALDOS','CESTATUSCUENTA',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2566040,'TSALDOS','CUSUARIO',5,null,null,'T','0','0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(12)',12,0,'0'); insert into tCamposConsultablesId values(2566041,'TSALDOS','FINICIO',5,null,null,'F',null,'0','1',null,'1','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2566042,'TSALDOS','MONTODESCARGAPROVISION',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(2566043,'TSALDOS','CIERREDIACONTABLE',5,null,null,'T',null,'0','0','0','1','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); insert into tCamposConsultablesId values(2566044,'TSALDOS','FDESDE',5,null,null,'F',null,'0','0',null,'1','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2566045,'TSALDOS','FHASTA',5,null,null,'F',null,'1','0',null,'1','0',null,'1',null,null,null,'DATE',7,0,'0'); insert into tCamposConsultablesId values(2566046,'TSALDOS','SSUBCUENTA',5,null,null,'N',null,'1','0',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0'); insert into tCamposConsultablesId values(2566047,'TSALDOS','TASADIA',5,null,null,'N',null,'0','1',null,'1','0',null,'1',null,null,null,'NUMBER(16,12)',16,12,'0'); insert into tCamposConsultablesId values(2566048,'TSALDOS','SALDOPLANILLA',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(2566049,'TSALDOS','CAGRUPACIONCONTABLE',5,null,null,'T',null,'0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0'); insert into tCamposConsultablesId values(2566050,'TSALDOS','SALDOCIERREMONEDACUENTA',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(2566051,'TSALDOS','SALDOCIERREMONEDAOFICIAL',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(2566052,'TSALDOS','CESTADOOPERACION',5,null,null,'T',null,'0','1',null,'1','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2566053,'TSALDOS','CAPITALREDUCIDO',5,null,null,'N',null,'0','1',null,'1','0',null,'1',null,null,null,'NUMBER(19,6)',19,6,'0'); -- Loading TCAMPOSCONSULTABLES... insert into tCamposConsultables values('ES',2524001,to_timestamp('2999-12-31 00:00:00.000000','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 categoria. '); insert into tCamposConsultables values('ES',2524002,to_timestamp('2999-12-31 00:00:00.000000','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 canal.'); insert into tCamposConsultables values('ES',2524003,to_timestamp('2999-12-31 00:00:00.000000','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 concepto del movimiento.'); insert into tCamposConsultables values('ES',2524004,to_timestamp('2999-12-31 00:00:00.000000','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 concepto contable. '); insert into tCamposConsultables values('ES',2524005,to_timestamp('2999-12-31 00:00:00.000000','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',2524007,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2524009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de imagen del documento asociado a una transaccion.'); insert into tCamposConsultables values('ES',2524010,to_timestamp('2999-12-31 00:00:00.000000','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 moneda de la cuenta.'); insert into tCamposConsultables values('ES',2524011,to_timestamp('2999-12-31 00:00:00.000000','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 moneda oficial o local.'); insert into tCamposConsultables values('ES',2524012,to_timestamp('2999-12-31 00:00:00.000000','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 que afecta el movimiento.'); insert into tCamposConsultables values('ES',2524013,to_timestamp('2999-12-31 00:00:00.000000','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 deposito codificado'); insert into tCamposConsultables values('ES',2524014,to_timestamp('2999-12-31 00:00:00.000000','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 plazo o vencimiento de la cuota, utilizado para maduracion de cuotas.'); insert into tCamposConsultables values('ES',2524015,to_timestamp('2999-12-31 00:00:00.000000','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 oficiana de la cuenta'); insert into tCamposConsultables values('ES',2524016,to_timestamp('2999-12-31 00:00:00.000000','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 a la que pertenece la cuenta.'); insert into tCamposConsultables values('ES',2524017,to_timestamp('2999-12-31 00:00:00.000000','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 de la categoria. '); insert into tCamposConsultables values('ES',2524019,to_timestamp('2999-12-31 00:00:00.000000','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 que realiza la transaccion. '); insert into tCamposConsultables values('ES',2524021,to_timestamp('2999-12-31 00:00:00.000000','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 subsistema al que pertece la cuenta.'); insert into tCamposConsultables values('ES',2524022,to_timestamp('2999-12-31 00:00:00.000000','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 subsistema de la transaccion origen.'); insert into tCamposConsultables values('ES',2524023,to_timestamp('2999-12-31 00:00:00.000000','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 subsistema de la transaccion'); insert into tCamposConsultables values('ES',2524024,to_timestamp('2999-12-31 00:00:00.000000','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 sucursal de la cuenta'); insert into tCamposConsultables values('ES',2524025,to_timestamp('2999-12-31 00:00:00.000000','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 terminal. '); insert into tCamposConsultables values('ES',2524027,to_timestamp('2999-12-31 00:00:00.000000','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 persona que califica al documento'); insert into tCamposConsultables values('ES',2524028,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la transaccion'); insert into tCamposConsultables values('ES',2524029,to_timestamp('2999-12-31 00:00:00.000000','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 transaccionorigen. '); insert into tCamposConsultables values('ES',2524030,to_timestamp('2999-12-31 00:00:00.000000','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',2524031,to_timestamp('2999-12-31 00:00:00.000000','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 autoriza el movimiento'); insert into tCamposConsultables values('ES',2524032,to_timestamp('2999-12-31 00:00:00.000000','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 una transaccion es de debito o credito.'); insert into tCamposConsultables values('ES',2524033,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Detalle adicional del movimiento'); insert into tCamposConsultables values('ES',2524034,to_timestamp('2999-12-31 00:00:00.000000','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 del servidor de aplicaciones en el que realizo una transaccion'); insert into tCamposConsultables values('ES',2524035,to_timestamp('2999-12-31 00:00:00.000000','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 en la que se ejecuta una transaccion.'); insert into tCamposConsultables values('ES',2524037,to_timestamp('2999-12-31 00:00:00.000000','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 del ultimo pago de una cuota'); insert into tCamposConsultables values('ES',2524038,to_timestamp('2999-12-31 00:00:00.000000','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 del servidor de base de datos en la que se realizo una transaccion.'); insert into tCamposConsultables values('ES',2524039,to_timestamp('2999-12-31 00:00:00.000000','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 una cuota o del saldo de una categoria.'); insert into tCamposConsultables values('ES',2524040,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Identificacion de la persona que realiza el movimiento.'); insert into tCamposConsultables values('ES',2524041,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Modo de la transaccion Normal o Imperativa.'); insert into tCamposConsultables values('ES',2524042,to_timestamp('2999-12-31 00:00:00.000000','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. '); insert into tCamposConsultables values('ES',2524043,to_timestamp('2999-12-31 00:00:00.000000','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'); insert into tCamposConsultables values('ES',2524044,to_timestamp('2999-12-31 00:00:00.000000','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 movimiento reversado .'); insert into tCamposConsultables values('ES',2524046,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'yyyyymm de la fecha contable del movimiento '); insert into tCamposConsultables values('ES',2524047,to_timestamp('2999-12-31 00:00:00.000000','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 categoria contable provisiona interes'); insert into tCamposConsultables values('ES',2524048,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el movimiento se ejecuto en modo normal o reverso. '); insert into tCamposConsultables values('ES',2524049,to_timestamp('2999-12-31 00:00:00.000000','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 de rubro dentro de la transaccion.'); insert into tCamposConsultables values('ES',2524050,to_timestamp('2999-12-31 00:00:00.000000','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 de transaccion para el numero de mensaje'); insert into tCamposConsultables values('ES',2524051,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2524055,to_timestamp('2999-12-31 00:00:00.000000','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 en la moneda de la cuenta.'); insert into tCamposConsultables values('ES',2524056,to_timestamp('2999-12-31 00:00:00.000000','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 en moneda oficial. '); insert into tCamposConsultables values('ES',2524057,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Version de la transaccion'); insert into tCamposConsultables values('ES',2524058,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Version de transaccion origen.'); insert into tCamposConsultables values('ES',2524059,to_timestamp('2999-12-31 00:00:00.000000','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 comprobante contable'); insert into tCamposConsultables values('ES',2524062,to_timestamp('2999-12-31 00:00:00.000000','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 origen del movimiento.'); insert into tCamposConsultables values('ES',2524063,to_timestamp('2999-12-31 00:00:00.000000','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 sucursal origen del movimiento.'); insert into tCamposConsultables values('ES',2524064,to_timestamp('2999-12-31 00:00:00.000000','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 categoria SAL (Saldos de cuentas), ACC (provisiones)'); insert into tCamposConsultables values('ES',2524065,to_timestamp('2999-12-31 00:00:00.000000','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',2524067,to_timestamp('2999-12-31 00:00:00.000000','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 sector economico como: 1005 = BANCA'); insert into tCamposConsultables values('ES',2524069,to_timestamp('2999-12-31 00:00:00.000000','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 clasificacion contable de los productos, ejemplo Prestamos, microcredito, comercial consumo, hipotecario. '); insert into tCamposConsultables values('ES',2524070,to_timestamp('2999-12-31 00:00:00.000000','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 estatus contable de cuenta'); insert into tCamposConsultables values('ES',2524071,to_timestamp('2999-12-31 00:00:00.000000','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 moneda origen o destino del movimiento'); insert into tCamposConsultables values('ES',2524072,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Cotizacion de la moneda aplicada al movimiento.'); insert into tCamposConsultables values('ES',2524073,to_timestamp('2999-12-31 00:00:00.000000','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 cambio'); insert into tCamposConsultables values('ES',2524074,to_timestamp('2999-12-31 00:00:00.000000','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 valor del movimiento'); insert into tCamposConsultables values('ES',2524075,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el movimiento es de O=origen o D=destino para aplicar las cotizaciones de compra y venta'); insert into tCamposConsultables values('ES',2524076,to_timestamp('2999-12-31 00:00:00.000000','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 en la moneda origen o destino'); insert into tCamposConsultables values('ES',2524077,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Identificacion del beneficiario'); insert into tCamposConsultables values('ES',2524078,to_timestamp('2999-12-31 00:00:00.000000','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 del beneficiario'); insert into tCamposConsultables values('ES',2524079,to_timestamp('2999-12-31 00:00:00.000000','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 en la moneda de la cuenta correspondiente al calculado segun el tarifario'); insert into tCamposConsultables values('ES',2524080,to_timestamp('2999-12-31 00:00:00.000000','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 producto de la cuenta'); insert into tCamposConsultables values('ES',2524081,to_timestamp('2999-12-31 00:00:00.000000','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 producto de la cuenta'); insert into tCamposConsultables values('ES',2524082,to_timestamp('2999-12-31 00:00:00.000000','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 final utilizado para los rangos de cheques en la anulacion'); insert into tCamposConsultables values('ES',2524083,to_timestamp('2999-12-31 00:00:00.000000','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 unico numerico de usuario'); insert into tCamposConsultables values('ES',2524084,to_timestamp('2999-12-31 00:00:00.000000','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 proceso contable para el movimiento'); insert into tCamposConsultables values('ES',2524085,to_timestamp('2999-12-31 00:00:00.000000','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 documento asociado a la persona que realiza el movimiento.'); insert into tCamposConsultables values('ES',2524086,to_timestamp('2999-12-31 00:00:00.000000','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 identificacion de una persona'); insert into tCamposConsultables values('ES',2524087,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Consecutivo por subcuenta'); insert into tCamposConsultables values('ES',2524088,to_timestamp('2999-12-31 00:00:00.000000','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 area: cre = credito, ope=operaciones, etc'); insert into tCamposConsultables values('ES',2524089,to_timestamp('2999-12-31 00:00:00.000000','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 proceso a la que corresponde la compensacion de cajeros automaticos'); insert into tCamposConsultables values('ES',2524090,to_timestamp('2999-12-31 00:00:00.000000','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 proceso a la que corresponde el cuadre de cajas'); insert into tCamposConsultables values('ES',2524091,to_timestamp('2999-12-31 00:00:00.000000','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 el movimiento en el cual se realizo una entrada reversiva, en el caso de prestamos se trata de un pago reversado con fecha valor'); insert into tCamposConsultables values('ES',2524092,to_timestamp('2999-12-31 00:00:00.000000','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 deposito realizado por concepto de sueldos al cual no se aplica el impuesto a la circulacion '); insert into tCamposConsultables values('ES',2524093,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigos del estado de la operacion de credito'); insert into tCamposConsultables values('ES',2524094,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Capital reducido en la moneda de la cuenta'); insert into tCamposConsultables values('ES',2566001,to_timestamp('2999-12-31 00:00:00.000000','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 categoria. '); insert into tCamposConsultables values('ES',2566002,to_timestamp('2999-12-31 00:00:00.000000','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 auxiiar'); insert into tCamposConsultables values('ES',2566004,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2566006,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2566007,to_timestamp('2999-12-31 00:00:00.000000','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 local o oficial.'); insert into tCamposConsultables values('ES',2566008,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2566009,to_timestamp('2999-12-31 00:00:00.000000','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 plazo o vencimiento de la cuota, utilizado para maduracion de cuotas.'); insert into tCamposConsultables values('ES',2566010,to_timestamp('2999-12-31 00:00:00.000000','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 a la que pertenece la cuneta.'); insert into tCamposConsultables values('ES',2566012,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2566013,to_timestamp('2999-12-31 00:00:00.000000','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 desde la cual esta vigente el saldo de una cuenta, categoria, subcuenta.'); insert into tCamposConsultables values('ES',2566014,to_timestamp('2999-12-31 00:00:00.000000','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 hasta la cual esta vigente el saldo de una cuenta, categoria, subcuenta.'); insert into tCamposConsultables values('ES',2566015,to_timestamp('2999-12-31 00:00:00.000000','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 del saldo en una categoria.'); insert into tCamposConsultables values('ES',2566016,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'yyyyymm de la fecha contable hasta del movimiento '); insert into tCamposConsultables values('ES',2566017,to_timestamp('2999-12-31 00:00:00.000000','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 categoria contable provisiona interes'); insert into tCamposConsultables values('ES',2566018,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2566019,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Saldos fecha valor utilizado en calculo de intereses.'); insert into tCamposConsultables values('ES',2566020,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2566024,to_timestamp('2999-12-31 00:00:00.000000','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 categoria SAL (Saldos de cuentas), ACC (provisiones)'); insert into tCamposConsultables values('ES',2566025,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Indica si el saldo de la cuenta se obtiene de esta categoria grupo balance'); insert into tCamposConsultables values('ES',2566026,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Provision diaria en moneda de la cuenta'); insert into tCamposConsultables values('ES',2566027,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Provision en moneda local o nacional'); insert into tCamposConsultables values('ES',2566028,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2566029,to_timestamp('2999-12-31 00:00:00.000000','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 producto'); insert into tCamposConsultables values('ES',2566030,to_timestamp('2999-12-31 00:00:00.000000','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',2566031,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2566032,to_timestamp('2999-12-31 00:00:00.000000','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 productos'); insert into tCamposConsultables values('ES',2566033,to_timestamp('2999-12-31 00:00:00.000000','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 personas juridicas'); insert into tCamposConsultables values('ES',2566034,to_timestamp('2999-12-31 00:00:00.000000','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 a ajustar en la provision en trasacciones fecha valor en moneda local'); insert into tCamposConsultables values('ES',2566035,to_timestamp('2999-12-31 00:00:00.000000','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 a ajustar en la provision en trasacciones fecha valor'); insert into tCamposConsultables values('ES',2566038,to_timestamp('2999-12-31 00:00:00.000000','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 clasificacion contable de los productos, ejemplo Prestamos, microcredito, comercial consumo, hipotecario. '); insert into tCamposConsultables values('ES',2566039,to_timestamp('2999-12-31 00:00:00.000000','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 estatus contable de cuenta'); insert into tCamposConsultables values('ES',2566040,to_timestamp('2999-12-31 00:00:00.000000','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 actualiza el saldo de la cuenta'); insert into tCamposConsultables values('ES',2566041,to_timestamp('2999-12-31 00:00:00.000000','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 inicio de la autorizacion de credito para sobregiros en el subsistema de captaciones a la vista o de una cuota en el subsistema de colocaciones'); insert into tCamposConsultables values('ES',2566042,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Monto que se descarga de la provision en la fecha contable, cuando se realiza un pago o un cambio de categoria contable'); insert into tCamposConsultables values('ES',2566043,to_timestamp('2999-12-31 00:00:00.000000','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 el registro como saldo final de la fecha contable hasta'); insert into tCamposConsultables values('ES',2566044,to_timestamp('2999-12-31 00:00:00.000000','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 desde la cual esta vigente el saldo de una cuenta, categoria, subcuenta.'); insert into tCamposConsultables values('ES',2566045,to_timestamp('2999-12-31 00:00:00.000000','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 hasta la cual esta vigente el saldo de una cuenta, categoria, subcuenta.'); insert into tCamposConsultables values('ES',2566046,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Consecutivo por subcuenta'); insert into tCamposConsultables values('ES',2566047,to_timestamp('2999-12-31 00:00:00.000000','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 diaria que se aplica al calculo del interes'); insert into tCamposConsultables values('ES',2566048,to_timestamp('2999-12-31 00:00:00.000000','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 los depositos realizados por concepto de sueldos al cual no se aplica el impuesto de circulacion'); insert into tCamposConsultables values('ES',2566049,to_timestamp('2999-12-31 00:00:00.000000','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 agrupacion contable de cuenta.'); insert into tCamposConsultables values('ES',2566050,to_timestamp('2999-12-31 00:00:00.000000','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 al momento del cierre del ejercicio contable en la moneda de la cuenta'); insert into tCamposConsultables values('ES',2566051,to_timestamp('2999-12-31 00:00:00.000000','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 al momento del cierre del ejercicio contable en la moneda oficial'); insert into tCamposConsultables values('ES',2566052,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigos del estado de la operacion de credito'); insert into tCamposConsultables values('ES',2566053,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Capital reducido en la moneda de la cuenta'); commit; -- Done.