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='TCLASIFICACIONCONTABLEID'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TRANGOSCLASIFICACION'); delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TTRASPASOSESTATUS'); prompt Deleting TCAMPOSCONSULTABLESID... delete from tCamposConsultablesId where tablabase='TCLASIFICACIONCONTABLEID'; delete from tCamposConsultablesId where tablabase='TRANGOSCLASIFICACION'; delete from tCamposConsultablesId where tablabase='TTRASPASOSESTATUS'; prompt Loading TCAMPOSCONSULTABLESID... insert into tCamposConsultablesId values(2605001,'TCLASIFICACIONCONTABLEID','CCLASIFICACIONCONTABLE',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2605002,'TCLASIFICACIONCONTABLEID','CSUBSISTEMA',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2605003,'TCLASIFICACIONCONTABLEID','DIASGRACIA',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(3)',3,0,'0'); insert into tCamposConsultablesId values(2605004,'TCLASIFICACIONCONTABLEID','DIASPASOAVENCIDO',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(3)',3,0,'0'); insert into tCamposConsultablesId values(2617001,'TRANGOSCLASIFICACION','CCLASIFICACIONCONTABLE',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2617002,'TRANGOSCLASIFICACION','CESTATUSCUENTA',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2617003,'TRANGOSCLASIFICACION','CODIGOCONTABLE',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0'); insert into tCamposConsultablesId values(2617004,'TRANGOSCLASIFICACION','CODIGOPLAZO',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2617005,'TRANGOSCLASIFICACION','CSUBSISTEMA',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2617006,'TRANGOSCLASIFICACION','DIASDESDE',5,null,null,'N','0','0','0',null,'0','0',null,'1',null,null,null,'NUMBER(5)',5,0,'0'); insert into tCamposConsultablesId values(2617007,'TRANGOSCLASIFICACION','DIASHASTA',5,null,null,'N','0','0','0',null,'0','0',null,'1',null,null,null,'NUMBER(5)',5,0,'0'); insert into tCamposConsultablesId values(2617008,'TRANGOSCLASIFICACION','VERSIONCONTROL',5,null,null,'N','0','0','1','0','0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0'); insert into tCamposConsultablesId values(2617009,'TRANGOSCLASIFICACION','CESTADOOPERACION',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2915001,'TTRASPASOSESTATUS','CESTATUSCUENTA_ACTUAL',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2915002,'TTRASPASOSESTATUS','CESTATUSCUENTA_PASO',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0'); insert into tCamposConsultablesId values(2915003,'TTRASPASOSESTATUS','CSUBSISTEMA',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0'); insert into tCamposConsultablesId values(2915004,'TTRASPASOSESTATUS','ESVENCIMIENTOFUTURO',5,null,null,'T',null,'1','0','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0'); prompt Loading TCAMPOSCONSULTABLES... insert into tCamposConsultables values('ES',2605001,to_timestamp('2999-12-31 00:00:00.000000','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',2605002,to_timestamp('2999-12-31 00:00:00.000000','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',2605003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Dias de gracia para paso a vencido de la clasificacion contable'); insert into tCamposConsultables values('ES',2605004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Dias definidos para el paso de la operacion a vencido'); insert into tCamposConsultables values('ES',2617001,to_timestamp('2999-12-31 00:00:00.000000','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',2617002,to_timestamp('2999-12-31 00:00:00.000000','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 estatus de maduracion de una cuota'); insert into tCamposConsultables values('ES',2617003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Parte del codigo contable que da las bandas para la maduracion.'); insert into tCamposConsultables values('ES',2617004,to_timestamp('2999-12-31 00:00:00.000000','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 '); insert into tCamposConsultables values('ES',2617005,to_timestamp('2999-12-31 00:00:00.000000','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',2617006,to_timestamp('2999-12-31 00:00:00.000000','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 dias desde los que se considera la banda.'); insert into tCamposConsultables values('ES',2617007,to_timestamp('2999-12-31 00:00:00.000000','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 dias hasta los que se considera la banda.'); insert into tCamposConsultables values('ES',2617008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Manejo de optimistic loking'); insert into tCamposConsultables values('ES',2617009,to_timestamp('2999-12-31 00:00:00.000000','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',2915001,to_timestamp('2999-12-31 00:00:00.000000','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 actual de la cuenta'); insert into tCamposConsultables values('ES',2915002,to_timestamp('2999-12-31 00:00:00.000000','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 al cual pasa la cuenta'); insert into tCamposConsultables values('ES',2915003,to_timestamp('2999-12-31 00:00:00.000000','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',2915004,to_timestamp('2999-12-31 00:00:00.000000','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 definicion se toma para cuentas con vencimiento futuro'); commit; set Define "&" set feedback on prompt Done. spool off