-- Deleting TCAMPOSCONSULTABLES...                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='GTCHEQUERASIMPRIMIR');                                                                                                                                                                                                                                                                                                                                                                                    
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='GTESTADOCUENTA');                                                                                                                                                                                                                                                                                                                                                                                         
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='GTESTADOCUENTACREDITOVISTA');                                                                                                                                                                                                                                                                                                                                                                             
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='GTROLESHORARIO');                                                                                                                                                                                                                                                                                                                                                                                 
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCHEQUERASIMPRIMIR');                                                                                                                                                                                                                                                                                                                                                                                    
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='TESTADOCUENTACREDITOVISTA');                                                                                                                                                                                                                                                                                                                                                                             
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TROLESHORARIOTEMPORAL');                                                                                                                                                                                                                                                                                                                                                                                 
-- Deleting TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
delete from tCamposConsultablesId where tablabase='TCHEQUERASIMPRIMIR';                                                                                                                                                                                                                                                                                                                                                                                                                                             
delete from tCamposConsultablesId where tablabase='TESTADOCUENTA';                                                                                                                                                                                                                                                                                                                                                                                                                                                  
delete from tCamposConsultablesId where tablabase='TESTADOCUENTACREDITOVISTA';                                                                                                                                                                                                                                                                                                                                                                                                                                      
delete from tCamposConsultablesId where tablabase='TROLESHORARIOTEMPORAL';                                                                                                                                                                                                                                                                                                                                                                                                                                          
delete from tCamposConsultablesId where tablabase='GTCHEQUERASIMPRIMIR';                                                                                                                                                                                                                                                                                                                                                                                                                                             
delete from tCamposConsultablesId where tablabase='GTESTADOCUENTA';                                                                                                                                                                                                                                                                                                                                                                                                                                                  
delete from tCamposConsultablesId where tablabase='GTESTADOCUENTACREDITOVISTA';                                                                                                                                                                                                                                                                                                                                                                                                                                      
delete from tCamposConsultablesId where tablabase='GTROLESHORARIO';                                                                                                                                                                                                                                                                                                                                                                                                                                          
-- Loading TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(2687001,'TCHEQUERASIMPRIMIR','CANTIDAD',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0');                                                                                                                                                                                                                                                                                                                                          
insert into tCamposConsultablesId values(2687002,'TCHEQUERASIMPRIMIR','CCUENTA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(17)',17,0,'0');                                                                                                                                                                                                                                                                                                                                         
insert into tCamposConsultablesId values(2687003,'TCHEQUERASIMPRIMIR','CMODELOCHEQUERA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0');                                                                                                                                                                                                                                                                                                                                   
insert into tCamposConsultablesId values(2687004,'TCHEQUERASIMPRIMIR','COFICINA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                          
insert into tCamposConsultablesId values(2687005,'TCHEQUERASIMPRIMIR','CRUZADO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0');                                                                                                                                                                                                                                                                                                                                           
insert into tCamposConsultablesId values(2687006,'TCHEQUERASIMPRIMIR','ELABORARSINPIN',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                                    
insert into tCamposConsultablesId values(2687007,'TCHEQUERASIMPRIMIR','NOMBREOFICINA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(24)',24,0,'0');                                                                                                                                                                                                                                                                                                                                    
insert into tCamposConsultablesId values(2687008,'TCHEQUERASIMPRIMIR','NUMEROFINAL',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(8)',8,0,'0');                                                                                                                                                                                                                                                                                                                                       
insert into tCamposConsultablesId values(2687009,'TCHEQUERASIMPRIMIR','NUMEROINICIAL',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(8)',8,0,'0');                                                                                                                                                                                                                                                                                                                                     
insert into tCamposConsultablesId values(2687010,'TCHEQUERASIMPRIMIR','PIN',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(16)',16,0,'0');                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(2687011,'TCHEQUERASIMPRIMIR','PRIMERALINEAPERSONAL',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(30)',30,0,'0');                                                                                                                                                                                                                                                                                                                            
insert into tCamposConsultablesId values(2687012,'TCHEQUERASIMPRIMIR','RUTATRANSITO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(8)',8,0,'0');                                                                                                                                                                                                                                                                                                                                      
insert into tCamposConsultablesId values(2687013,'TCHEQUERASIMPRIMIR','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(2687014,'TCHEQUERASIMPRIMIR','SEGUNDALINEAPERSONAL',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(30)',30,0,'0');                                                                                                                                                                                                                                                                                                                            
insert into tCamposConsultablesId values(2687015,'TCHEQUERASIMPRIMIR','TALONARIO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0');                                                                                                                                                                                                                                                                                                                                         
insert into tCamposConsultablesId values(2687016,'TCHEQUERASIMPRIMIR','TIPOREGISTRO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0');                                                                                                                                                                                                                                                                                                                                      
insert into tCamposConsultablesId values(2687018,'TCHEQUERASIMPRIMIR','CMONEDA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                           
insert into tCamposConsultablesId values(2687019,'TCHEQUERASIMPRIMIR','CODIGOCUENTAEXTENDIDA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(14)',14,0,'0');                                                                                                                                                                                                                                                                                                                            
insert into tCamposConsultablesId values(2687020,'TCHEQUERASIMPRIMIR','CONSTANTEFNALIZACION',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0');                                                                                                                                                                                                                                                                                                                              
insert into tCamposConsultablesId values(2687021,'TCHEQUERASIMPRIMIR','NUMEROCHEQUERAS',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(5)',5,0,'0');                                                                                                                                                                                                                                                                                                                                     
insert into tCamposConsultablesId values(2687022,'TCHEQUERASIMPRIMIR','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(2687023,'TCHEQUERASIMPRIMIR','RUTATRANSITOBANCO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0');                                                                                                                                                                                                                                                                                                                                 
insert into tCamposConsultablesId values(2687024,'TCHEQUERASIMPRIMIR','RUTATRANSITOEXTENDIDA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(9)',9,0,'0');                                                                                                                                                                                                                                                                                                                             
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(2756001,'TESTADOCUENTACREDITOVISTA','CAPITAL',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(2756002,'TESTADOCUENTACREDITOVISTA','CCUENTA',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0');                                                                                                                                                                                                                                                                                                                                  
insert into tCamposConsultablesId values(2756003,'TESTADOCUENTACREDITOVISTA','CCUENTA_PREFERENCIAL',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0');                                                                                                                                                                                                                                                                                                                     
insert into tCamposConsultablesId values(2756004,'TESTADOCUENTACREDITOVISTA','CPERSONA_COMPANIA',5,null,null,'N',null,'0','0',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0');                                                                                                                                                                                                                                                                                                                            
insert into tCamposConsultablesId values(2756005,'TESTADOCUENTACREDITOVISTA','FCOBRO',5,null,null,'F',null,'0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0');                                                                                                                                                                                                                                                                                                                                            
insert into tCamposConsultablesId values(2756006,'TESTADOCUENTACREDITOVISTA','IMPUESTOS',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(2756007,'TESTADOCUENTACREDITOVISTA','INTERES',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(2756008,'TESTADOCUENTACREDITOVISTA','LINEACREDITO',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(2756009,'TESTADOCUENTACREDITOVISTA','PAGOMINIMO',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(2756010,'TESTADOCUENTACREDITOVISTA','PAGOS',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(2756011,'TESTADOCUENTACREDITOVISTA','SALDODISPONIBLE',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(2756012,'TESTADOCUENTACREDITOVISTA','SALDODISPONIBLEACTUAL',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(2756013,'TESTADOCUENTACREDITOVISTA','SALDORETENIDO',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(2756014,'TESTADOCUENTACREDITOVISTA','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(2756015,'TESTADOCUENTACREDITOVISTA','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(2769001,'TROLESHORARIOTEMPORAL','CESTATUSCUENTA',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                 
insert into tCamposConsultablesId values(2769002,'TROLESHORARIOTEMPORAL','CGRUPOPRODUCTO',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                                 
insert into tCamposConsultablesId values(2769003,'TROLESHORARIOTEMPORAL','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(2769004,'TROLESHORARIOTEMPORAL','CPERSONA_COMPANIA',5,null,null,'N',null,'0','0',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0');                                                                                                                                                                                                                                                                                                                                
insert into tCamposConsultablesId values(2769005,'TROLESHORARIOTEMPORAL','CPRODUCTO',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                      
insert into tCamposConsultablesId values(2769006,'TROLESHORARIOTEMPORAL','CROL',5,null,null,'N',null,'0','0',null,'0','0',null,'1',null,null,null,'NUMBER(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(2769007,'TROLESHORARIOTEMPORAL','CSUBSISTEMA',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                                    
insert into tCamposConsultablesId values(2769008,'TROLESHORARIOTEMPORAL','CSUBSISTEMA_TRANSACCION',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                        
insert into tCamposConsultablesId values(2769009,'TROLESHORARIOTEMPORAL','CTIPOBANCA',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0');                                                                                                                                                                                                                                                                                                                                     
insert into tCamposConsultablesId values(2769010,'TROLESHORARIOTEMPORAL','CTIPOHORARIO',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0');                                                                                                                                                                                                                                                                                                                                   
insert into tCamposConsultablesId values(2769011,'TROLESHORARIOTEMPORAL','CTRANSACCION',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                   
insert into tCamposConsultablesId values(2769012,'TROLESHORARIOTEMPORAL','DIASEMANA',5,null,null,'N',null,'0','0',null,'0','0',null,'1',null,null,null,'NUMBER(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                                        
insert into tCamposConsultablesId values(2769013,'TROLESHORARIOTEMPORAL','HORADESDE',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'CHAR(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                          
insert into tCamposConsultablesId values(2769014,'TROLESHORARIOTEMPORAL','HORAHASTA',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'CHAR(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                          
insert into tCamposConsultablesId values(2769015,'TROLESHORARIOTEMPORAL','MONTOMAXIMO',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(2769016,'TROLESHORARIOTEMPORAL','VERSIONTRANSACCION',5,null,null,'T',null,'0','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(2769017,'TROLESHORARIOTEMPORAL','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(2769018,'TROLESHORARIOTEMPORAL','SECUENCIA',5,null,null,'N',null,'1','0',null,'0','0',null,'1',null,null,null,'NUMBER(10)',10,0,'0');                                                                                                                                                                                                                                                                                                                                      
-- Loading TCAMPOSCONSULTABLES...                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',2687001,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Cantidad de cheque en la chequera');                                                                                                                                                                                                                                                                             
insert into tCamposConsultables values('ES',2687002,to_timestamp('2999-12-31 00:00:00.000000','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 cuenta de la chequera');                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',2687003,to_timestamp('2999-12-31 00:00:00.000000','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 modelo de la chequera');                                                                                                                                                                                                                                                                              
insert into tCamposConsultables values('ES',2687004,to_timestamp('2999-12-31 00:00:00.000000','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 oficina');                                                                                                                                                                                                                                                                                          
insert into tCamposConsultables values('ES',2687005,to_timestamp('2999-12-31 00:00:00.000000','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 son cheques cruzados');                                                                                                                                                                                                                                                                                
insert into tCamposConsultables values('ES',2687006,to_timestamp('2999-12-31 00:00:00.000000','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 chequera se elabora sin PIN');                                                                                                                                                                                                                                                                      
insert into tCamposConsultables values('ES',2687007,to_timestamp('2999-12-31 00:00:00.000000','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 oficina de la cuenta');                                                                                                                                                                                                                                                                             
insert into tCamposConsultables values('ES',2687008,to_timestamp('2999-12-31 00:00:00.000000','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 final de cheque en la chequera');                                                                                                                                                                                                                                                                         
insert into tCamposConsultables values('ES',2687009,to_timestamp('2999-12-31 00:00:00.000000','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 inicial de cheque en la chequera');                                                                                                                                                                                                                                                                       
insert into tCamposConsultables values('ES',2687010,to_timestamp('2999-12-31 00:00:00.000000','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 personalizacion');                                                                                                                                                                                                                                                                                     
insert into tCamposConsultables values('ES',2687011,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Primera linea personalizacion de la chequera');                                                                                                                                                                                                                                                                  
insert into tCamposConsultables values('ES',2687012,to_timestamp('2999-12-31 00:00:00.000000','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 ruta transito del cheque');                                                                                                                                                                                                                                                                         
insert into tCamposConsultables values('ES',2687013,to_timestamp('2999-12-31 00:00:00.000000','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 consecutivo del registro');                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',2687014,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Segunda linea personalizacion de la chequera');                                                                                                                                                                                                                                                                  
insert into tCamposConsultables values('ES',2687015,to_timestamp('2999-12-31 00:00:00.000000','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 chequera tiene talonario');                                                                                                                                                                                                                                                                         
insert into tCamposConsultables values('ES',2687016,to_timestamp('2999-12-31 00:00:00.000000','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 registro del reporte');                                                                                                                                                                                                                                                                                  
insert into tCamposConsultables values('ES',2687018,to_timestamp('2999-12-31 00:00:00.000000','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');                                                                                                                                                                                                                                                                                           
insert into tCamposConsultables values('ES',2687019,to_timestamp('2999-12-31 00:00:00.000000','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 extendida');                                                                                                                                                                                                                                                                                    
insert into tCamposConsultables values('ES',2687020,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Constante de finalizacion');                                                                                                                                                                                                                                                                                     
insert into tCamposConsultables values('ES',2687021,to_timestamp('2999-12-31 00:00:00.000000','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 chequeras solicitadas');                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',2687022,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2687023,to_timestamp('2999-12-31 00:00:00.000000','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 ruta transito del Banco');                                                                                                                                                                                                                                                                          
insert into tCamposConsultables values('ES',2687024,to_timestamp('2999-12-31 00:00:00.000000','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 ruta transito extendida');                                                                                                                                                                                                                                                                             
insert into tCamposConsultables 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 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 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 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 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 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 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 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 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 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 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 values('ES',2756001,to_timestamp('2999-12-31 00:00:00.000000','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 minimo a pagar');                                                                                                                                                                                                                                                                                        
insert into tCamposConsultables values('ES',2756002,to_timestamp('2999-12-31 00:00:00.000000','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 de credito en vista');                                                                                                                                                                                                                                                                       
insert into tCamposConsultables values('ES',2756003,to_timestamp('2999-12-31 00:00:00.000000','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 corriente preferencial');                                                                                                                                                                                                                                                                    
insert into tCamposConsultables values('ES',2756004,to_timestamp('2999-12-31 00:00:00.000000','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');                                                                                                                                                                                                                                                                                            
insert into tCamposConsultables values('ES',2756005,to_timestamp('2999-12-31 00:00:00.000000','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 cobro de la linea de credito');                                                                                                                                                                                                                                                                         
insert into tCamposConsultables values('ES',2756006,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Impuesto minimo a pagar');                                                                                                                                                                                                                                                                                       
insert into tCamposConsultables values('ES',2756007,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Interes minimo a pagar');                                                                                                                                                                                                                                                                                        
insert into tCamposConsultables values('ES',2756008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Linea de credito aprobada');                                                                                                                                                                                                                                                                                     
insert into tCamposConsultables values('ES',2756009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Miinimo a pagar');                                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',2756010,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Abonos realizados ');                                                                                                                                                                                                                                                                                            
insert into tCamposConsultables values('ES',2756011,to_timestamp('2999-12-31 00:00:00.000000','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 inicial del estado de cuenta');                                                                                                                                                                                                                                                                 
insert into tCamposConsultables values('ES',2756012,to_timestamp('2999-12-31 00:00:00.000000','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 final del estado de cuenta');                                                                                                                                                                                                                                                                   
insert into tCamposConsultables values('ES',2756013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Depositos no efectivizados');                                                                                                                                                                                                                                                                                    
insert into tCamposConsultables values('ES',2756014,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2756015,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2769001,to_timestamp('2999-12-31 00:00:00.000000','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 de cuenta');                                                                                                                                                                                                                                                                                   
insert into tCamposConsultables values('ES',2769002,to_timestamp('2999-12-31 00:00:00.000000','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',2769003,to_timestamp('2999-12-31 00:00:00.000000','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');                                                                                                                                                                                                                                                                                              
insert into tCamposConsultables values('ES',2769004,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2769005,to_timestamp('2999-12-31 00:00:00.000000','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',2769006,to_timestamp('2999-12-31 00:00:00.000000','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 rol de usuario por compania');                                                                                                                                                                                                                                                                        
insert into tCamposConsultables values('ES',2769007,to_timestamp('2999-12-31 00:00:00.000000','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',2769008,to_timestamp('2999-12-31 00:00:00.000000','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 de la transaccion');                                                                                                                                                                                                                                                                       
insert into tCamposConsultables values('ES',2769009,to_timestamp('2999-12-31 00:00:00.000000','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 banca');                                                                                                                                                                                                                                                                                      
insert into tCamposConsultables values('ES',2769010,to_timestamp('2999-12-31 00:00:00.000000','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 horario');                                                                                                                                                                                                                                                                                    
insert into tCamposConsultables values('ES',2769011,to_timestamp('2999-12-31 00:00:00.000000','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',2769012,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Dia de la semana de un horario definido para el rol');                                                                                                                                                                                                                                                           
insert into tCamposConsultables values('ES',2769013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Hora desde del horario de un rol en un dia de la semana');                                                                                                                                                                                                                                                       
insert into tCamposConsultables values('ES',2769014,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Hora hasta del horario de un rol en un dia de la semana');                                                                                                                                                                                                                                                       
insert into tCamposConsultables values('ES',2769015,to_timestamp('2999-12-31 00:00:00.000000','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 maximo permitido para la realizacion de una transaccion en un horario');                                                                                                                                                                                                                                   
insert into tCamposConsultables values('ES',2769016,to_timestamp('2999-12-31 00:00:00.000000','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',2769017,to_timestamp('2999-12-31 00:00:00.000000','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 values('ES',2769018,to_timestamp('2999-12-31 00:00:00.000000','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');                                                                                                                                                                                                                                                                         
commit;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
-- Done.