04/10/2021 00:44:40  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>VALIDACIÓN DE DATOS:</b><br> Faltan el id de la empresa.		           			    
							<br><b>METODO:</b> ConsultaTelefonosClienteEmp 

04/10/2021 18:40:31  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <b>CLASE:</b> covensol_reconv_c_reconversion <br><b>METODO:</b> ProcesarReconversionScg <br><b>ERROR:</b><br>Invalid query: ERROR:  column "tascamscgref" does not exist
LINE 29:        WHERE tascamscgref!=1;   
                      ^
HINT:  Perhaps you meant to reference the column "scg_dt_cmp.tascamscg".
Whole query: 
		        		   
						UPDATE scg_cuentas
						   SET asignado=asignado/1000000,	   
							   enero=enero/1000000,
							   febrero=febrero/1000000,
							   marzo=marzo/1000000,
							   abril=abril/1000000,
							   mayo=mayo/1000000,
							   junio=junio/1000000,
							   julio=julio/1000000,
							   agosto=agosto/1000000,
							   septiembre=septiembre/1000000,
							   octubre=octubre/1000000,
							   noviembre=noviembre/1000000,
							   diciembre=diciembre/1000000;
						   
							
						
						UPDATE scg_dt_cmp
						   SET monto=monto/1000000;
						
						UPDATE scg_dt_cmp
						   SET tascamscg=tascamscg/1000000
						 WHERE tascamscg!=1;
						   
						UPDATE scg_dt_cmp
						   SET tascamscgref=tascamscgref/1000000
						 WHERE tascamscgref!=1;   
							
							
						UPDATE scg_dtmp_cmp
						   SET monto=monto/1000000;
							
							
						UPDATE scg_pc_reporte
						   SET    asignado=asignado/1000000,
								  enero=enero/1000000,
								  febrero=febrero/1000000,
								  marzo=marzo/1000000,
								  abril=abril/1000000,
								  mayo=mayo/1000000,
								  junio=junio/1000000,
								  julio=julio/1000000,
								  agosto=agosto/1000000,
								  septiembre=septiembre/1000000,
								  octubre=octubre/1000000,
								  noviembre=noviembre/1000000,
								  diciembre=diciembre/1000000,		  
								  saldo_real_ant=saldo_real_ant/1000000,
								  saldo_apro=saldo_apro/1000000,
								  saldo_mod=saldo_mod/1000000,
								  saldo_real_ant_enero=saldo_real_ant_enero/1000000,
								  saldo_real_ant_febrero=saldo_real_ant_febrero/1000000,
								  saldo_real_ant_marzo=saldo_real_ant_marzo/1000000,
								  saldo_real_ant_abril=saldo_real_ant_abril/1000000,
								  saldo_real_ant_mayo=saldo_real_ant_mayo/1000000,
								  saldo_real_ant_junio=saldo_real_ant_junio/1000000,
								  saldo_real_ant_julio=saldo_real_ant_julio/1000000,
								  saldo_real_ant_agosto=saldo_real_ant_agosto/1000000,
								  saldo_real_ant_septiembre=saldo_real_ant_septiembre/1000000,
								  saldo_real_ant_octubre=saldo_real_ant_octubre/1000000,
								  saldo_real_ant_noviembre=saldo_real_ant_noviembre/1000000,
								  saldo_real_ant_diciembre=saldo_real_ant_diciembre/1000000;
							
							
							
						UPDATE scg_pc_reporte_ant
						   SET asignado=asignado/1000000,	   
							   enero=enero/1000000,
							   febrero=febrero/1000000,
							   marzo=marzo/1000000,
							   abril=abril/1000000,
							   mayo=mayo/1000000,
							   junio=junio/1000000,
							   julio=julio/1000000,
							   agosto=agosto/1000000,
							   septiembre=septiembre/1000000,
							   octubre=octubre/1000000,
							   noviembre=noviembre/1000000,
							   diciembre=diciembre/1000000;
						
						UPDATE scg_saldos
						   SET debe_mes=debe_mes/1000000,
							   haber_mes=haber_mes/1000000;
						
						UPDATE scg_saldos_consolida
						   SET debe_mes=debe_mes/1000000,
							   haber_mes=haber_mes/1000000;

				
				
				

04/10/2021 21:07:40  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_CRE_38_2021 ERROR->Invalid query: ERROR:  column "tascam" of relation "cre_solicitud" does not exist
Whole query:        
								ALTER TABLE cre_solicitud ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_solicitud ALTER COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_solicitud ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_solicitud ADD COLUMN tascamref double precision DEFAULT 1;
							    
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_anticipos ALTER COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_anticipos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_anticipos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_movcobro ALTER COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_movcobro ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_movcobro ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_ingresos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_ingresos ALTER COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_ingresos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_ingresos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_prestamo ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo ALTER COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_prestamo ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_amortizacion ALTER COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_amortizacion ALTER COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_conceptos ALTER COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascamref double precision DEFAULT 1;
												
																										   
						

04/10/2021 21:08:39  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_CRE_38_2021 ERROR->Invalid query: ERROR:  type "set" does not exist
LINE 3: ...      ALTER TABLE cre_solicitud ADD COLUMN tascam SET DEFAUL...
                                                             ^
Whole query:        
								ALTER TABLE cre_solicitud ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_solicitud ADD COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_solicitud ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_solicitud ADD COLUMN tascamref double precision DEFAULT 1;
							    
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_anticipos ADD COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_anticipos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_anticipos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_movcobro ADD COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_movcobro ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_movcobro ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_ingresos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_ingresos ADD COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_ingresos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_ingresos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_prestamo ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo ADD COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_prestamo ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascam SET DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascamref double precision DEFAULT 1;
												
																										   
						

04/10/2021 21:09:14  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_CRE_38_2021 ERROR->Invalid query: ERROR:  syntax error at or near "DEFAULT"
LINE 3: ...      ALTER TABLE cre_solicitud ADD COLUMN tascam DEFAULT 1;
                                                             ^
Whole query:        
								ALTER TABLE cre_solicitud ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_solicitud ADD COLUMN tascam DEFAULT 1;
								ALTER TABLE cre_solicitud ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_solicitud ADD COLUMN tascamref double precision DEFAULT 1;
							    
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_anticipos ADD COLUMN tascam DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_anticipos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_anticipos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_movcobro ADD COLUMN tascam DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_movcobro ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_movcobro ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_ingresos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_ingresos ADD COLUMN tascam DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_ingresos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_ingresos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_prestamo ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo ADD COLUMN tascam DEFAULT 1;
								ALTER TABLE cre_prestamo ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascam DEFAULT 1;
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascam DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascam DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascamref double precision DEFAULT 1;
												
																										   
						

04/10/2021 21:10:01  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_CRE_38_2021 ERROR->Invalid query: ERROR:  column "codmon" of relation "cre_dt_anticipos" already exists
Whole query:        
								ALTER TABLE cre_solicitud ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_solicitud ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_solicitud ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_solicitud ADD COLUMN tascamref double precision DEFAULT 1;
							    
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_anticipos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_anticipos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_anticipos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_movcobro ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_movcobro ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_movcobro ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_ingresos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_ingresos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_ingresos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_ingresos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_prestamo ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascamref double precision DEFAULT 1;
												
																										   
						

04/10/2021 21:10:39  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_CRE_38_2021 ERROR->Invalid query: ERROR:  column "tascam" of relation "cre_dt_anticipos" already exists
Whole query:        
								ALTER TABLE cre_solicitud ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_solicitud ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_solicitud ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_solicitud ADD COLUMN tascamref double precision DEFAULT 1;
							    
								/*ALTER TABLE cre_dt_anticipos ADD COLUMN codmon character varying(4) DEFAULT 'VES';*/
			                    ALTER TABLE cre_dt_anticipos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_anticipos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_anticipos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_movcobro ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_movcobro ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_movcobro ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_ingresos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_ingresos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_ingresos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_ingresos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_prestamo ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascamref double precision DEFAULT 1;
												
																										   
						

04/10/2021 21:10:56  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_CRE_38_2021 ERROR->Invalid query: ERROR:  column "codmon" of relation "cre_dt_movcobro" already exists
Whole query:        
								ALTER TABLE cre_solicitud ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_solicitud ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_solicitud ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_solicitud ADD COLUMN tascamref double precision DEFAULT 1;
							    
								/*ALTER TABLE cre_dt_anticipos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_anticipos ADD COLUMN tascam double precision DEFAULT 1;*/
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_anticipos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_anticipos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_movcobro ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_movcobro ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_movcobro ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_ingresos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_ingresos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_ingresos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_ingresos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_prestamo ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascamref double precision DEFAULT 1;
												
																										   
						

04/10/2021 21:11:15  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_CRE_38_2021 ERROR->Invalid query: ERROR:  column "tascam" of relation "cre_dt_movcobro" already exists
Whole query:        
								ALTER TABLE cre_solicitud ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_solicitud ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_solicitud ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_solicitud ADD COLUMN tascamref double precision DEFAULT 1;
							    
								/*ALTER TABLE cre_dt_anticipos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_anticipos ADD COLUMN tascam double precision DEFAULT 1;*/
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_anticipos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_anticipos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								/*ALTER TABLE cre_dt_movcobro ADD COLUMN codmon character varying(4) DEFAULT 'VES';*/
			                    ALTER TABLE cre_dt_movcobro ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_movcobro ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_movcobro ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_ingresos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_ingresos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_ingresos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_ingresos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_prestamo ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascamref double precision DEFAULT 1;
												
																										   
						

04/10/2021 21:11:38  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_CRE_38_2021 ERROR->Invalid query: ERROR:  column "codmon" of relation "cre_ingresos" already exists
Whole query:        
								ALTER TABLE cre_solicitud ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_solicitud ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_solicitud ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_solicitud ADD COLUMN tascamref double precision DEFAULT 1;
							    
								/*ALTER TABLE cre_dt_anticipos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_anticipos ADD COLUMN tascam double precision DEFAULT 1;*/
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_anticipos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_anticipos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_anticipos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								/*ALTER TABLE cre_dt_movcobro ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_dt_movcobro ADD COLUMN tascam double precision DEFAULT 1;*/
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_dt_movcobro ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_dt_movcobro ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_dt_movcobro ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_ingresos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_ingresos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_ingresos ADD COLUMN tascamref double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN codmontransac character varying(4);
								ALTER TABLE cre_ingresos ADD COLUMN tascamtransac double precision DEFAULT 1;
								ALTER TABLE cre_ingresos ADD COLUMN moningtransac double precision DEFAULT 0;
								
								ALTER TABLE cre_prestamo ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_amortizacion ADD COLUMN tascamref double precision DEFAULT 1;
								
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmon character varying(4) DEFAULT 'VES';
			                    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascam double precision DEFAULT 1;
								ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN codmonref character varying(4);
							    ALTER TABLE cre_prestamo_dt_conceptos ADD COLUMN tascamref double precision DEFAULT 1;