09/04/2021 01:21:22  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> insertar_documentoInvalid query: ERROR:  invalid input syntax for integer: "false"
LINE 13: ...------------------------','-','APLDO','0','0','0','false','2...
                                                              ^
Whole query:   LOCK TABLE cxc_documento IN ACCESS EXCLUSIVE MODE;
					                SELECT reset_sequencia('cxc_documento','id_doc');
					                INSERT INTO cxc_documento(
											    codemp, codsuc, codcaj, codtipdoc, numdoc, coddoc, numcont_doc, id_fact, 
												estdoccxc,codmon_doc, tascam_doc, tipopecont, fecdoc, porcdesc_doc, montodesc_doc, 
												saldo_doc, subtot_doc, iva_doc, otros_doc, baseimp_doc, total_doc, 
												descripdoc, nummov_doc, numorddes_doc, procedoc, coduniadm, codestpro1, 
												codestpro2, codestpro3, codestpro4, codestpro5, estcla,formpagdoc, 
												id_fact_tercero, id_cliente_tercero,noafecdoc,noapllibven_doc,	
												fecreg, 
												usureg, horareg
										) 
										VALUES ('0001','0001','0001','NC','000001','000001','','36','P','USD','1812462.92','DEV','2021-04-09','0.00','0','0','1812462920','289994067.2','0','1812462920','2102456987.2','','','','CXCDOC','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','APLDO','0','0','0','false','2021-04-09','ADMINISTRADOR','01:21'); ; SELECT lastval() AS valor_id; 

09/04/2021 01:38:50  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->sigesp_int MÉTODO->uf_sigesp_delete_comprobante ERROR->Invalid query: ERROR:  update or delete on table "sigesp_cmp" violates foreign key constraint "fk_spi_dt_c_sigesp_cm_sigesp_c" on table "spi_dt_cmp"
DETAIL:  Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCCRE, NC-0001-0000000000001, 2021-04-09, ---, -------------------------) is still referenced from table "spi_dt_cmp".
Whole query: DELETE FROM sigesp_cmp  WHERE codemp = '0001'    AND procede='CXCCRE'    AND comprobante='NC-0001-0000000000001'    AND fecha='2021-04-09'   AND codban='---'   AND ctaban='-------------------------'

09/04/2021 01:43:08  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->sigesp_int MÉTODO->uf_sigesp_delete_comprobante ERROR->Invalid query: ERROR:  update or delete on table "sigesp_cmp" violates foreign key constraint "fk_spi_dt_c_sigesp_cm_sigesp_c" on table "spi_dt_cmp"
DETAIL:  Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCCRE, NC-0001-0000000000001, 2021-04-09, ---, -------------------------) is still referenced from table "spi_dt_cmp".
Whole query: DELETE FROM sigesp_cmp  WHERE codemp = '0001'    AND procede='CXCCRE'    AND comprobante='NC-0001-0000000000001'    AND fecha='2021-04-09'   AND codban='---'   AND ctaban='-------------------------'

09/04/2021 01:45:50  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->sigesp_int MÉTODO->uf_sigesp_delete_comprobante ERROR->Invalid query: ERROR:  update or delete on table "sigesp_cmp" violates foreign key constraint "fk_spi_dt_c_sigesp_cm_sigesp_c" on table "spi_dt_cmp"
DETAIL:  Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCCRE, NC-0001-0000000000001, 2021-04-09, ---, -------------------------) is still referenced from table "spi_dt_cmp".
Whole query: DELETE FROM sigesp_cmp  WHERE codemp = '0001'    AND procede='CXCCRE'    AND comprobante='NC-0001-0000000000001'    AND fecha='2021-04-09'   AND codban='---'   AND ctaban='-------------------------'

09/04/2021 01:49:24  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->sigesp_int MÉTODO->uf_sigesp_delete_comprobante ERROR->Invalid query: ERROR:  update or delete on table "sigesp_cmp" violates foreign key constraint "fk_spi_dt_c_sigesp_cm_sigesp_c" on table "spi_dt_cmp"
DETAIL:  Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCCRE, NC-0001-0000000000001, 2021-04-09, ---, -------------------------) is still referenced from table "spi_dt_cmp".
Whole query: DELETE FROM sigesp_cmp  WHERE codemp = '0001'    AND procede='CXCCRE'    AND comprobante='NC-0001-0000000000001'    AND fecha='2021-04-09'   AND codban='---'   AND ctaban='-------------------------'

09/04/2021 01:54:23  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  ERROR-> El Movimiento ya existe 

09/04/2021 01:54:23  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  Error al registrar movimiento contable

09/04/2021 03:05:30  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->sigesp_int MÉTODO->uf_sigesp_delete_comprobante ERROR->Invalid query: ERROR:  update or delete on table "sigesp_cmp" violates foreign key constraint "fk_spi_dt_c_sigesp_cm_sigesp_c" on table "spi_dt_cmp"
DETAIL:  Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCCRE, NC-0001-0000000000001, 2021-04-09, ---, -------------------------) is still referenced from table "spi_dt_cmp".
Whole query: DELETE FROM sigesp_cmp  WHERE codemp = '0001'    AND procede='CXCCRE'    AND comprobante='NC-0001-0000000000001'    AND fecha='2021-04-09'   AND codban='---'   AND ctaban='-------------------------'

09/04/2021 03:11:53  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->sigesp_int MÉTODO->uf_sigesp_delete_comprobante ERROR->Invalid query: ERROR:  update or delete on table "sigesp_cmp" violates foreign key constraint "fk_spi_dt_c_sigesp_cm_sigesp_c" on table "spi_dt_cmp"
DETAIL:  Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCCRE, NC-0001-0000000000001, 2021-04-09, ---, -------------------------) is still referenced from table "spi_dt_cmp".
Whole query: DELETE FROM sigesp_cmp  WHERE codemp = '0001'    AND procede='CXCCRE'    AND comprobante='NC-0001-0000000000001'    AND fecha='2021-04-09'   AND codban='---'   AND ctaban='-------------------------'

09/04/2021 03:57:01  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  <br><b>ERROR-></b><br><b>CLASE:</b> covensol_cxc_cuentasxcobrar <br><b>METODO:</b> insertar_facturaInvalid query: ERROR:  column "noapllibven_fac" of relation "cxc_factura" does not exist
LINE 47:             noapllibven_fac,
                     ^
Whole query: 
					                SELECT reset_sequencia('cxc_factura','id_fact');
					                INSERT INTO cxc_factura(
											    codemp,
												tipopeneg,
												numfact,
												codproceso,   
												numcont,
												codfact,
												id_cliente,
												id_transp,												
												id_estfact,
												id_condpago,
												id_vend,
												codmon,
												tascam, 
												tipopecont,
												codsuc,
												codcaj,
												fecfact,
												fecvenc,
												porcdesc,
												montodesc,
												saldo,
												subtot,
												iva,
												otros,
												total,
												baseimp,
												descripfact,
												comentadifact,
												procefac,
												codunieje, 
												codestpro1, 
       											codestpro2, 
												codestpro3, 
												codestpro4, 
												codestpro5, 
												estcla,
												devengado,
												cobrado,
												cxchist,
												id_cliente_doc,
												codsuccli,
												noafecfact,
												codseriefac,
												noapllibven_fac,
												aero_matricula, 
												aero_codequip,  
										        aero_vuelo, 
												aero_aperturacompuerta, 
												aero_cierrecompuerta,
												
												fecreg,
												usureg,
												horareg
										) 
										VALUES ('0001','STD','14948','FACTURA','','014948','8229','1','1','2','1','USD','2000000','DEV','001','001','2021-04-09','2021-04-09','0.00','0','0','2000000000','320000000','0','2320000000','2000000000','','','CXCFAC','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','1','0','0','0','','0','A','1','','','','00:00:00','00:00:00','2021-04-09','ADMINISTRADOR','03:57'); ; SELECT lastval() AS valor_id;