-- Deleting TCAMPOSCONSULTABLES...                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCAJACUADRE');                                                                                                                                                                                                                                                                                                                                                                                           
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCAJACUADREDETALLE');                                                                                                                                                                                                                                                                                                                                                                                    
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TCAJACUADREID');                                                                                                                                                                                                                                                                                                                                                                                         
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TUCITRANSACCIONESDIA');                                                                                                                                                                                                                                                                                                                                                                                  
-- Deleting TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
delete from tCamposConsultablesId where tablabase='TCAJACUADRE';                                                                                                                                                                                                                                                                                                                                                                                                                                                    
delete from tCamposConsultablesId where tablabase='TCAJACUADREDETALLE';                                                                                                                                                                                                                                                                                                                                                                                                                                             
delete from tCamposConsultablesId where tablabase='TCAJACUADREID';                                                                                                                                                                                                                                                                                                                                                                                                                                                  
delete from tCamposConsultablesId where tablabase='TUCITRANSACCIONESDIA';                                                                                                                                                                                                                                                                                                                                                                                                                                           
-- Loading TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(2651001,'TUCITRANSACCIONESDIA','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(2651002,'TUCITRANSACCIONESDIA','COFICINA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                          
insert into tCamposConsultablesId values(2651003,'TUCITRANSACCIONESDIA','CPERSONA_COMPANIA',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0');                                                                                                                                                                                                                                                                                                                                 
insert into tCamposConsultablesId values(2651004,'TUCITRANSACCIONESDIA','CSUBSISTEMA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                                     
insert into tCamposConsultablesId values(2651005,'TUCITRANSACCIONESDIA','CSUCURSAL',5,null,null,'N',null,'0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                         
insert into tCamposConsultablesId values(2651006,'TUCITRANSACCIONESDIA','CTRANSACCION',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                    
insert into tCamposConsultablesId values(2651007,'TUCITRANSACCIONESDIA','CUSUARIO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(12)',12,0,'0');                                                                                                                                                                                                                                                                                                                                      
insert into tCamposConsultablesId values(2651008,'TUCITRANSACCIONESDIA','FCONTABLE',5,null,null,'F',null,'0','1',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0');                                                                                                                                                                                                                                                                                                                                              
insert into tCamposConsultablesId values(2651009,'TUCITRANSACCIONESDIA','FREAL',5,null,null,'S',null,'0','1','Systimestamp','0','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0');                                                                                                                                                                                                                                                                                                                                  
insert into tCamposConsultablesId values(2651010,'TUCITRANSACCIONESDIA','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(2651011,'TUCITRANSACCIONESDIA','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(2651012,'TUCITRANSACCIONESDIA','REVERSADA_COPIA',5,null,null,'T',null,'0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0');                                                                                                                                                                                                                                                                                                                                  
insert into tCamposConsultablesId values(2651013,'TUCITRANSACCIONESDIA','REVERSADA_DESTINO',5,null,null,'T',null,'0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0');                                                                                                                                                                                                                                                                                                                                
insert into tCamposConsultablesId values(2651014,'TUCITRANSACCIONESDIA','VALOR',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(2651015,'TUCITRANSACCIONESDIA','VERSIONTRANSACCION',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                              
insert into tCamposConsultablesId values(2651016,'TUCITRANSACCIONESDIA','REVERSO',5,null,null,'T','0','0','1','0','0','0',null,'1',null,null,'0','VARCHAR2(1)',1,0,'0');                                                                                                                                                                                                                                                                                                                                            
insert into tCamposConsultablesId values(2651017,'TUCITRANSACCIONESDIA','AUTORIZAREVERSO',5,null,null,'T',null,'0','1','0','0','0',null,'1',null,null,null,'VARCHAR2(1)',1,0,'0');                                                                                                                                                                                                                                                                                                                                  
insert into tCamposConsultablesId values(2651018,'TUCITRANSACCIONESDIA','CUSUARIO_AUTORIZA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(19)',19,0,'0');                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(2651019,'TUCITRANSACCIONESDIA','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(2651020,'TUCITRANSACCIONESDIA','DETALLEREVERSO',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(60)',60,0,'0');                                                                                                                                                                                                                                                                                                                                 
insert into tCamposConsultablesId values(647001,'TCAJACUADRE','CMONEDA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,'0','VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                                     
insert into tCamposConsultablesId values(647002,'TCAJACUADRE','COFICINA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                                      
insert into tCamposConsultablesId values(647003,'TCAJACUADRE','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(8)',8,0,'0');                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(647004,'TCAJACUADRE','CSUBSISTEMA',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                                                 
insert into tCamposConsultablesId values(647005,'TCAJACUADRE','CSUCURSAL',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                                     
insert into tCamposConsultablesId values(647006,'TCAJACUADRE','CTRANSACCION',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                                
insert into tCamposConsultablesId values(647007,'TCAJACUADRE','CUSUARIO',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,'0','VARCHAR2(12)',12,0,'0');                                                                                                                                                                                                                                                                                                                                                  
insert into tCamposConsultablesId values(647008,'TCAJACUADRE','CUSUARIO_APROBACION',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(12)',12,0,'0');                                                                                                                                                                                                                                                                                                                                       
insert into tCamposConsultablesId values(647009,'TCAJACUADRE','ESTATUSCUADRE',5,null,null,'T','1','0','0','ING','1','0',null,'1',null,null,'0','VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                              
insert into tCamposConsultablesId values(647010,'TCAJACUADRE','FCUADRE',5,null,null,'F','0','1','0',null,'1','0',null,'1',null,null,'0','DATE',7,0,'0');                                                                                                                                                                                                                                                                                                                                                            
insert into tCamposConsultablesId values(647012,'TCAJACUADRE','TOTALEFECTIVO',5,null,null,'N','0','0','0',null,'1','0',null,'1',null,null,'0','NUMBER(19,6)',19,6,'0');                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(647013,'TCAJACUADRE','VERSIONTRANSACCION',5,null,null,'T','1','0','1',null,'1','0',null,'1',null,null,'0','VARCHAR2(2)',2,0,'0');                                                                                                                                                                                                                                                                                                                                          
insert into tCamposConsultablesId values(647014,'TCAJACUADRE','FDESDE',5,null,null,'S','0','0','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0');                                                                                                                                                                                                                                                                                                                                                        
insert into tCamposConsultablesId values(647015,'TCAJACUADRE','FHASTA',5,null,null,'S','0','1','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0');                                                                                                                                                                                                                                                                                                                                                        
insert into tCamposConsultablesId values(647016,'TCAJACUADRE','VERSIONCONTROL',5,null,null,'N','0','0','1','0','1','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0');                                                                                                                                                                                                                                                                                                                                              
insert into tCamposConsultablesId values(647017,'TCAJACUADRE','RUBRO',5,null,null,'N','0','0','1',null,'1','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                                        
insert into tCamposConsultablesId values(648001,'TCAJACUADREDETALLE','CMONEDA',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,'0','VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                              
insert into tCamposConsultablesId values(648002,'TCAJACUADREDETALLE','COFICINA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                               
insert into tCamposConsultablesId values(648003,'TCAJACUADREDETALLE','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(8)',8,0,'0');                                                                                                                                                                                                                                                                                                                                      
insert into tCamposConsultablesId values(648004,'TCAJACUADREDETALLE','CSUCURSAL',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                              
insert into tCamposConsultablesId values(648005,'TCAJACUADREDETALLE','CTIPODENOMINACION',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,'0','VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                    
insert into tCamposConsultablesId values(648006,'TCAJACUADREDETALLE','CUSUARIO',5,null,null,'T','1','1','0',null,'1','0',null,'1',null,null,'0','VARCHAR2(12)',12,0,'0');                                                                                                                                                                                                                                                                                                                                           
insert into tCamposConsultablesId values(648007,'TCAJACUADREDETALLE','FCUADRE',5,null,null,'F','0','1','0',null,'1','0',null,'1',null,null,'0','DATE',7,0,'0');                                                                                                                                                                                                                                                                                                                                                     
insert into tCamposConsultablesId values(648008,'TCAJACUADREDETALLE','MONTODENOMINACION',5,null,null,'N','0','0','0',null,'1','0',null,'1',null,null,'0','NUMBER(19,6)',19,6,'0');                                                                                                                                                                                                                                                                                                                                  
insert into tCamposConsultablesId values(648009,'TCAJACUADREDETALLE','NUMERODENOMINACION',5,null,null,'N','0','0','0',null,'1','0',null,'1',null,null,'0','NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                     
insert into tCamposConsultablesId values(648010,'TCAJACUADREDETALLE','VALORDENOMINACION',5,null,null,'N','0','1','0',null,'1','0',null,'1',null,null,'0','NUMBER(19,6)',19,6,'0');                                                                                                                                                                                                                                                                                                                                  
insert into tCamposConsultablesId values(648011,'TCAJACUADREDETALLE','FDESDE',5,null,null,'S','0','0','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0');                                                                                                                                                                                                                                                                                                                                                 
insert into tCamposConsultablesId values(648012,'TCAJACUADREDETALLE','FHASTA',5,null,null,'S','0','1','0','','1','0',null,'1',null,null,null,'TIMESTAMP',11,6,'0');                                                                                                                                                                                                                                                                                                                                                 
insert into tCamposConsultablesId values(648013,'TCAJACUADREDETALLE','VERSIONCONTROL',5,null,null,'N','0','0','1','0','1','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0');                                                                                                                                                                                                                                                                                                                                       
insert into tCamposConsultablesId values(842001,'TCAJACUADREID','CMONEDA',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                                  
insert into tCamposConsultablesId values(842002,'TCAJACUADREID','COFICINA',5,null,null,'N','0','1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                                   
insert into tCamposConsultablesId values(842003,'TCAJACUADREID','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0');                                                                                                                                                                                                                                                                                                                                          
insert into tCamposConsultablesId values(842004,'TCAJACUADREID','CSUCURSAL',5,null,null,'N','0','1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                                  
insert into tCamposConsultablesId values(842005,'TCAJACUADREID','CUSUARIO',5,null,null,'T','1','1','0',null,'0','0',null,'1',null,null,null,'VARCHAR2(12)',12,0,'0');                                                                                                                                                                                                                                                                                                                                               
insert into tCamposConsultablesId values(842006,'TCAJACUADREID','FCUADRE',5,null,null,'F','0','1','0',null,'0','0',null,'1',null,null,null,'DATE',7,0,'0');                                                                                                                                                                                                                                                                                                                                                         
-- Loading TCAMPOSCONSULTABLES...                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',2651001,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',2651002,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de oficina');                                                                                                                                                                                                                                                                                             
insert into tCamposConsultables values('ES',2651003,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',2651004,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',2651005,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la sucursal');                                                                                                                                                                                                                                                                                         
insert into tCamposConsultables values('ES',2651006,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',2651007,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de usuario');                                                                                                                                                                                                                                                                                             
insert into tCamposConsultables values('ES',2651008,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 de la Transaccion');                                                                                                                                                                                                                                                                              
insert into tCamposConsultables values('ES',2651009,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 de la Transaccion');                                                                                                                                                                                                                                                                                  
insert into tCamposConsultables values('ES',2651010,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, ej Cheque');                                                                                                                                                                                                                                                                                
insert into tCamposConsultables values('ES',2651011,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 FIT');                                                                                                                                                                                                                                                                                         
insert into tCamposConsultables values('ES',2651012,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'),'Indicador de si la Transaccion fue reversada en el mensaje de copia');                                                                                                                                                                                                                                           
insert into tCamposConsultables values('ES',2651013,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'),'Indicador de si la Transaccion fue reversada en el Destino');                                                                                                                                                                                                                                                    
insert into tCamposConsultables values('ES',2651014,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 de la Transaccion');                                                                                                                                                                                                                                                                                       
insert into tCamposConsultables values('ES',2651015,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',2651016,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'),'Campo empleado por el formulario como disparador de los reversos');                                                                                                                                                                                                                                              
insert into tCamposConsultables values('ES',2651017,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'),'Indicardor si la transaccion fue autorizada para reverso');                                                                                                                                                                                                                                                      
insert into tCamposConsultables values('ES',2651018,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del usuario que autoriza el reverso');                                                                                                                                                                                                                                                                    
insert into tCamposConsultables values('ES',2651019,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',2651020,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Detalle de la transaccion utilizado para especificar el motivo del reverso');                                                                                                                                                                                                                                    
insert into tCamposConsultables values('ES',647001,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',647002,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 origen del cuadre');                                                                                                                                                                                                                                                                         
insert into tCamposConsultables values('ES',647003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de persona de la compania');                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',647004,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 de cuadre del efectivo de caja');                                                                                                                                                                                                                                         
insert into tCamposConsultables values('ES',647005,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la sucursal origen del cuadre');                                                                                                                                                                                                                                                                        
insert into tCamposConsultables values('ES',647006,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 de cuadre del efectivo de caja');                                                                                                                                                                                                                                                        
insert into tCamposConsultables values('ES',647007,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del usuario que envia la transferencia');                                                                                                                                                                                                                                                                  
insert into tCamposConsultables values('ES',647008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del usuario que recibe la transferencia');                                                                                                                                                                                                                                                                 
insert into tCamposConsultables values('ES',647009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Marca el estatus de la transaccion de cuadre de caja, ING=ingresada para aprobacion, PRO=en proceso, APR=aprobada, CER = Cerrada');                                                                                                                                                                               
insert into tCamposConsultables values('ES',647010,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha del cuadre de efectivo de caja');                                                                                                                                                                                                                                                                           
insert into tCamposConsultables values('ES',647012,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 total de efectivo en caja');                                                                                                                                                                                                                                                                                
insert into tCamposConsultables values('ES',647013,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 de cuadre del efectivo de caja');                                                                                                                                                                                                                                                       
insert into tCamposConsultables values('ES',647014,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 desde la que estan vigentes los datos registrados para el cuadre de caja');                                                                                                                                                                                                                                 
insert into tCamposConsultables values('ES',647015,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 hasta la que estan vigentes los datos registrados para el cuadre de caja');                                                                                                                                                                                                                                 
insert into tCamposConsultables values('ES',647016,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Manejo de optimistic loking');                                                                                                                                                                                                                                                                                    
insert into tCamposConsultables values('ES',647017,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Secuencia del rubro principal de la transaccion de cuadre del efectivo de caja');                                                                                                                                                                                                                                 
insert into tCamposConsultables values('ES',648001,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',648002,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 origen del cuadre');                                                                                                                                                                                                                                                                         
insert into tCamposConsultables values('ES',648003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de persona de la compania');                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',648004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la sucursal origen del cuadre');                                                                                                                                                                                                                                                                        
insert into tCamposConsultables values('ES',648005,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 denominacion');                                                                                                                                                                                                                                                                                
insert into tCamposConsultables values('ES',648006,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del usuario');                                                                                                                                                                                                                                                                                             
insert into tCamposConsultables values('ES',648007,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 transferencia de efectivo de caja');                                                                                                                                                                                                                                                                     
insert into tCamposConsultables values('ES',648008,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 en la denominacion especificada');                                                                                                                                                                                                                                                                          
insert into tCamposConsultables values('ES',648009,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 denominaciones');                                                                                                                                                                                                                                                                                       
insert into tCamposConsultables values('ES',648010,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 de la denominacion');                                                                                                                                                                                                                                                                                       
insert into tCamposConsultables values('ES',648011,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 desde la que estan vigentes los datos del detalle de denominaciones del cuadre de caja');                                                                                                                                                                                                                   
insert into tCamposConsultables values('ES',648012,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 hasta la que estan vigentes los datos del detalle de denominaciones del cuadre de caja');                                                                                                                                                                                                                   
insert into tCamposConsultables values('ES',648013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Manejo de optimistic loking');                                                                                                                                                                                                                                                                                    
insert into tCamposConsultables values('ES',842001,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',842002,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 origen del cuadre');                                                                                                                                                                                                                                                                         
insert into tCamposConsultables values('ES',842003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de persona de la compania');                                                                                                                                                                                                                                                                               
insert into tCamposConsultables values('ES',842004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la sucursal origen del cuadre');                                                                                                                                                                                                                                                                        
insert into tCamposConsultables values('ES',842005,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del usuario que envia la transferencia');                                                                                                                                                                                                                                                                  
insert into tCamposConsultables values('ES',842006,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Fecha del cuadre de efectivo de caja');                                                                                                                                                                                                                                                                           
commit;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
-- Done.