30/03/2021 03:56:07  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> insertar_cotizapedidoInvalid query: ERROR:  invalid input syntax for type double precision: ""
LINE 47: ...:00:00','COLL','','0','90','100.8','100.8','1.25','','C','2'...
                                                              ^
Whole query:   
					                SELECT reset_sequencia('cxc_cotiza_pedidos','id_cotped');
					                INSERT INTO cxc_cotiza_pedidos(
											    codemp,
												numcotped,
												codproc,
												id_cliente,
												id_transp,												
												estcotped,
												id_condpago,
												id_vend,
												codmon,
												tascam,
												codsuc,
												feccotped,
												fecvencotped,
												porcdesc,
												montodesc,
												saldo,
												subtot,
												iva,
												otros,
												total,
												baseimp,
												descrip,
												coment,
												coduniadm, 
												codestpro1, 
       											codestpro2, 
												codestpro3, 
												codestpro4, 
												codestpro5, 
												estcla,												
												 
											itinerario, aero_matricula, aero_codequip,  
										    aero_vuelo, aero_aperturacompuerta, aero_cierrecompuerta, 
										    condflete, contenido, canpaqcarga, 
											peso_bruto_carga, peso_volumen_carga, peso_cobrar_carga, 
											tarifa_carga, monflete_carga,tipo_tarifa,id_aero_apl,
											consignom, consigdir, consigciu, consigrif, consigtel,
										 
																								
												fecreg,
												usureg,
												horareg
										) 
										VALUES ('0001','0000000083','PED','8229','1','EMI','9','1','USD','1940000','001','2021-03-30','2021-03-30','0.00','0','0','408370000','44387200','0','452757200','399640000','','','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','SDQ-CCS','','','3344','00:00:00','00:00:00','COLL','','0','90','100.8','100.8','1.25','','C','2','','','','','','2021-03-30','ADMINISTRADOR','03:56'); ; SELECT lastval() AS valor_id; 

30/03/2021 04:00:16  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> insertar_cotizapedidoInvalid query: ERROR:  invalid input syntax for type double precision: ""
LINE 47: ...:00:00','COLL','','0','90','100.8','100.8','1.25','','C','2'...
                                                              ^
Whole query:   
					                SELECT reset_sequencia('cxc_cotiza_pedidos','id_cotped');
					                INSERT INTO cxc_cotiza_pedidos(
											    codemp,
												numcotped,
												codproc,
												id_cliente,
												id_transp,												
												estcotped,
												id_condpago,
												id_vend,
												codmon,
												tascam,
												codsuc,
												feccotped,
												fecvencotped,
												porcdesc,
												montodesc,
												saldo,
												subtot,
												iva,
												otros,
												total,
												baseimp,
												descrip,
												coment,
												coduniadm, 
												codestpro1, 
       											codestpro2, 
												codestpro3, 
												codestpro4, 
												codestpro5, 
												estcla,												
												 
											itinerario, aero_matricula, aero_codequip,  
										    aero_vuelo, aero_aperturacompuerta, aero_cierrecompuerta, 
										    condflete, contenido, canpaqcarga, 
											peso_bruto_carga, peso_volumen_carga, peso_cobrar_carga, 
											tarifa_carga, monflete_carga,tipo_tarifa,id_aero_apl,
											consignom, consigdir, consigciu, consigrif, consigtel,
										 
																								
												fecreg,
												usureg,
												horareg
										) 
										VALUES ('0001','0000000083','PED','8229','1','EMI','9','1','USD','1940000','001','2021-03-30','2021-03-30','0.00','0','0','408370000','44387200','0','452757200','399640000','','','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','SDQ-CCS','','','3344','00:00:00','00:00:00','COLL','','0','90','100.8','100.8','1.25','','C','2','Yaranith Ricaurte','Bellomonte','Caracas','V16904412','04148774433','2021-03-30','ADMINISTRADOR','04:00'); ; SELECT lastval() AS valor_id;