27/04/2021 06:00:02 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: 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','1','FACTURA','55399','000001','1','1','1','7','1','VES','1','DEV','0006','0006','2012-06-30','2012-06-30','0.00','0','0','21259.52','2551.14','0','23810.66','21259.52','','','CXCFAC','----------','-------------------------','-------------------------','-------------------------','-------------------------','-------------------------','-','1','0','0','0','','0','','0','','','','00:00:00','00:00:00','2021-04-27','ADMINISTRADOR','06:00'); ; SELECT lastval() AS valor_id;
27/04/2021 06:02:03 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR-> Error en valida datos comprobante
27/04/2021 06:26:58 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR-> Error en valida datos comprobante
27/04/2021 06:29:26 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR-> Error en valida datos comprobante