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='TRESIDENCIACODIGOCONTABLE');                                                                                                                                                                                                                                                                                                                                                                             
prompt Deleting TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
delete from tCamposConsultablesId where tablabase='TRESIDENCIACODIGOCONTABLE';                                                                                                                                                                                                                                                                                                                                                                                                                                      
prompt Loading TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(2923001,'TRESIDENCIACODIGOCONTABLE','CODIGOCONTABLE',5,null,null,'T','1','0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                              
insert into tCamposConsultablesId values(2923002,'TRESIDENCIACODIGOCONTABLE','CRESIDENCIA',5,null,null,'T',null,'1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                
insert into tCamposConsultablesId values(2923003,'TRESIDENCIACODIGOCONTABLE','VERSIONCONTROL',5,null,null,'N',null,'0','1','0','0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0');                                                                                                                                                                                                                                                                                                                              
prompt Loading TCAMPOSCONSULTABLES...                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',2923001,to_timestamp('2999-12-31 00:00:00.000000','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 asociado al tipo de empresa');                                                                                                                                                                                                                                                                   
insert into tCamposConsultables values('ES',2923002,to_timestamp('2999-12-31 00:00:00.000000','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 residencia');                                                                                                                                                                                                                                                                                          
insert into tCamposConsultables values('ES',2923003,to_timestamp('2999-12-31 00:00:00.000000','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');                                                                                                                                                                                                                                                                                   
commit;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
set Define "&"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
set feedback on                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
prompt Done.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
spool off