-- Deleting TCAMPOSCONSULTABLES...                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCUENTACONTADORPAGOS');                                                                                                                                                                                                                                                                                                                                                                                  
-- Deleting TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
delete from tCamposConsultablesId where tablabase='TCUENTACONTADORPAGOS';                                                                                                                                                                                                                                                                                                                                                                                                                                           
-- Loading TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(2927001,'TCUENTACONTADORPAGOS','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(2927002,'TCUENTACONTADORPAGOS','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(2927003,'TCUENTACONTADORPAGOS','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(2927004,'TCUENTACONTADORPAGOS','NUMEROPAGOS',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                       
-- Loading TCAMPOSCONSULTABLES...                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',2927001,to_timestamp('2999-12-31 00:00:00.000000','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',2927002,to_timestamp('2999-12-31 00:00:00.000000','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',2927003,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2927004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Contador de pagos consecutivos realizados a tiempo');                                                                                                                                                                                                                                                            
commit;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
-- Done.