21/02/2021 17:20:39 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaMovBcoAsocTrannsac
ERROR->
Invalid query: ERROR: syntax error at or near "ORDER"
LINE 33: ORDER BY m.fecmov, m.numdoc
^
Whole query:
SELECT m.*,
b.*, c.*,
mbco.codban, mbco.ctaban, mbco.numdoc, mbco.codope, mbco.estmov, mbco.cod_pro, mbco.ced_bene,
mbco.tipo_destino, mbco.codconmov, mbco.fecmov, mbco.conmov, mbco.nomproben, mbco.monto, mbco.estbpd,
estcon, estcobing, esttra, chevau, estimpche, monobjret, monret,
procede, comprobante, fecha, id_mco, emicheproc, emicheced, emichenom,
emichefec, estmovint, codusu, codopeidb, aliidb, feccon, estreglib,
numcarord, numpolcon, coduniadmsig, codbansig, fecordpagsig,
tipdocressig, numdocressig, estmodordpag, codfuefin, forpagsig,
medpagsig, codestprosig, nrocontrolop, fechaconta, fechaanula,
conanu, estant, docant, monamo, numordpagmin, codtipfon, estserext,
estmovcob, numconint, estapribs, estxmlibs, codper, codperi,
tranoreglib, estcondoc, fecenvfir, fecenvcaj, benefalt, codmon, tascam,
nroestcta, nromovestcta, facturado, cxc_id_fact, cxc_codsuc,
cxc_codcaj, cxc_nroing, cxc_tipdoc, cxc_id_doc, cxc_nromovcob,
codmonref, tascamref
FROM aero_ctlage_movbaco_asoc m
LEFT JOIN scb_movbco mbco ON m.codemp=b.codemp
AND m.codban=b.codban
AND m.ctaban=c.ctaban
AND m.numdoc=c.numdoc
AND m.codope=c.codope
AND m.estmov=c.estmov
LEFT JOIN scb_banco b ON m.codemp=b.codemp
AND m.codban=b.codban
LEFT JOIN scb_ctabanco c ON m.codemp=c.codemp
AND m.codban=c.codban
AND m.ctaban=c.ctaban
WHERE m.codemp='0001'
AND m.codemisor='PA196300'
AND m.nrotransage='3';
ORDER BY m.fecmov, m.numdoc
21/02/2021 17:21:22 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaMovBcoAsocTrannsac
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "b"
LINE 19: LEFT JOIN scb_movbco mbco ON m.codemp=b.codemp
^
Whole query:
SELECT m.*,
b.*, c.*,
mbco.codban, mbco.ctaban, mbco.numdoc, mbco.codope, mbco.estmov, mbco.cod_pro, mbco.ced_bene,
mbco.tipo_destino, mbco.codconmov, mbco.fecmov, mbco.conmov, mbco.nomproben, mbco.monto, mbco.estbpd,
estcon, estcobing, esttra, chevau, estimpche, monobjret, monret,
procede, comprobante, fecha, id_mco, emicheproc, emicheced, emichenom,
emichefec, estmovint, codusu, codopeidb, aliidb, feccon, estreglib,
numcarord, numpolcon, coduniadmsig, codbansig, fecordpagsig,
tipdocressig, numdocressig, estmodordpag, codfuefin, forpagsig,
medpagsig, codestprosig, nrocontrolop, fechaconta, fechaanula,
conanu, estant, docant, monamo, numordpagmin, codtipfon, estserext,
estmovcob, numconint, estapribs, estxmlibs, codper, codperi,
tranoreglib, estcondoc, fecenvfir, fecenvcaj, benefalt, codmon, tascam,
nroestcta, nromovestcta, facturado, cxc_id_fact, cxc_codsuc,
cxc_codcaj, cxc_nroing, cxc_tipdoc, cxc_id_doc, cxc_nromovcob,
codmonref, tascamref
FROM aero_ctlage_movbaco_asoc m
LEFT JOIN scb_movbco mbco ON m.codemp=b.codemp
AND m.codban=b.codban
AND m.ctaban=c.ctaban
AND m.numdoc=c.numdoc
AND m.codope=c.codope
AND m.estmov=c.estmov
LEFT JOIN scb_banco b ON m.codemp=b.codemp
AND m.codban=b.codban
LEFT JOIN scb_ctabanco c ON m.codemp=c.codemp
AND m.codban=c.codban
AND m.ctaban=c.ctaban
WHERE m.codemp='0001'
AND m.codemisor='PA196300'
AND m.nrotransage='3';
21/02/2021 17:22:04 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaMovBcoAsocTrannsac
ERROR->
Invalid query: ERROR: column reference "codmon" is ambiguous
LINE 14: ...eglib, estcondoc, fecenvfir, fecenvcaj, benefalt, codmon, ta...
^
Whole query:
SELECT m.*,
b.*, c.*,
mbco.codban, mbco.ctaban, mbco.numdoc, mbco.codope, mbco.estmov, mbco.cod_pro, mbco.ced_bene,
mbco.tipo_destino, mbco.codconmov, mbco.fecmov, mbco.conmov, mbco.nomproben, mbco.monto, mbco.estbpd,
estcon, estcobing, esttra, chevau, estimpche, monobjret, monret,
procede, comprobante, fecha, id_mco, emicheproc, emicheced, emichenom,
emichefec, estmovint, codusu, codopeidb, aliidb, feccon, estreglib,
numcarord, numpolcon, coduniadmsig, codbansig, fecordpagsig,
tipdocressig, numdocressig, estmodordpag, codfuefin, forpagsig,
medpagsig, codestprosig, nrocontrolop, fechaconta, fechaanula,
conanu, estant, docant, monamo, numordpagmin, codtipfon, estserext,
estmovcob, numconint, estapribs, estxmlibs, codper, codperi,
tranoreglib, estcondoc, fecenvfir, fecenvcaj, benefalt, codmon, tascam,
nroestcta, nromovestcta, facturado, cxc_id_fact, cxc_codsuc,
cxc_codcaj, cxc_nroing, cxc_tipdoc, cxc_id_doc, cxc_nromovcob,
codmonref, tascamref
FROM aero_ctlage_movbaco_asoc m
LEFT JOIN scb_movbco mbco ON mbco.codemp=m.codemp
AND mbco.codban=m.codban
AND mbco.ctaban=m.ctaban
AND mbco.numdoc=m.numdoc
AND mbco.codope=m.codope
AND mbco.estmov=m.estmov
LEFT JOIN scb_banco b ON m.codemp=b.codemp
AND m.codban=b.codban
LEFT JOIN scb_ctabanco c ON m.codemp=c.codemp
AND m.codban=c.codban
AND m.ctaban=c.ctaban
WHERE m.codemp='0001'
AND m.codemisor='PA196300'
AND m.nrotransage='3';
21/02/2021 19:20:32 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaMovBcoAsocTrannsac
ERROR->
Invalid query: ERROR: column m.cod_pro does not exist
LINE 34: ... LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro ...
^
Whole query:
SELECT m.*,
b.*, c.*,
mbco.codban, mbco.ctaban, mbco.numdoc, mbco.codope, mbco.estmov, mbco.cod_pro, mbco.ced_bene,
mbco.tipo_destino, mbco.codconmov, mbco.fecmov, mbco.conmov, mbco.nomproben, mbco.monto AS monlocal, mbco.estbpd,
estcon, estcobing, esttra, chevau, estimpche, monobjret, monret,
procede, comprobante, fecha, id_mco, emicheproc, emicheced, emichenom,
emichefec, estmovint, codusu, codopeidb, aliidb, feccon, estreglib,
numcarord, numpolcon, coduniadmsig, codbansig, fecordpagsig,
tipdocressig, numdocressig, estmodordpag, codfuefin, forpagsig,
medpagsig, codestprosig, nrocontrolop, fechaconta, fechaanula,
conanu, estant, docant, monamo, numordpagmin, codtipfon, estserext,
estmovcob, numconint, estapribs, estxmlibs, codper, codperi,
tranoreglib, estcondoc, fecenvfir, fecenvcaj, benefalt,
nroestcta, nromovestcta, facturado, cxc_id_fact, cxc_codsuc,
cxc_codcaj, cxc_nroing, cxc_tipdoc, cxc_id_doc, cxc_nromovcob,
mbco.codmonref, mbco.tascamref,
(CASE WHEN m.tipo_destino='P' THEN cod_pro||' - '||nompro
WHEN m.tipo_destino='B' THEN ced_bene||' - '||denpro
ELSE ''
END) AS infprobene
FROM aero_ctlage_movbaco_asoc m
LEFT JOIN scb_movbco mbco ON mbco.codemp=m.codemp
AND mbco.codban=m.codban
AND mbco.ctaban=m.ctaban
AND mbco.numdoc=m.numdoc
AND mbco.codope=m.codope
AND mbco.estmov=m.estmov
LEFT JOIN scb_banco b ON m.codemp=b.codemp
AND m.codban=b.codban
LEFT JOIN scb_ctabanco c ON m.codemp=c.codemp
AND m.codban=c.codban
AND m.ctaban=c.ctaban
LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
WHERE m.codemp='0001'
AND m.codemisor='89500375'
AND m.nrotransage='3';
21/02/2021 19:23:29 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaDetalleTransacCta
ERROR->
Invalid query: ERROR: column reference "cod_pro" is ambiguous
LINE 8: (CASE WHEN m.tipo_destino='P' THEN cod_pro||' - '||n...
^
Whole query: SELECT m.*,
tc.*,
c.denconcepage, c.codtipconcepage, c.sigconcepage, c.codmon AS codmonconcep,
c.monconcepage, c.recargacred, c.abonodeuda,
e.codemisor, e.denemisor, e.tipemisor, e.localidad, e.ref_kiu, e.rptagt,
e.ref_interfaz, e.codcencostemi, e.id_tipemisor, e.canal_emisor, e.id_periodicidad, e.ageemi,
e.estage, e.codmoncreage, e.limitecredage, e.diascredage, e.id_loc,
(CASE WHEN m.tipo_destino='P' THEN cod_pro||' - '||nompro
WHEN m.tipo_destino='B' THEN ced_bene||' - '||denpro
ELSE ''
END) AS infprobene
FROM aero_ctlage_dt_transacciones m
INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
INNER JOIN aero_ctlage_concepto c ON c.codconcepage=m.codconcepage
INNER JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
WHERE m.codemp='0001'
AND m.codemisor='89500375'
AND m.nrotransage='3';
21/02/2021 19:23:30 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaDetalleTransacCta
ERROR->
Invalid query: ERROR: column reference "cod_pro" is ambiguous
LINE 8: (CASE WHEN m.tipo_destino='P' THEN cod_pro||' - '||n...
^
Whole query: SELECT m.*,
tc.*,
c.denconcepage, c.codtipconcepage, c.sigconcepage, c.codmon AS codmonconcep,
c.monconcepage, c.recargacred, c.abonodeuda,
e.codemisor, e.denemisor, e.tipemisor, e.localidad, e.ref_kiu, e.rptagt,
e.ref_interfaz, e.codcencostemi, e.id_tipemisor, e.canal_emisor, e.id_periodicidad, e.ageemi,
e.estage, e.codmoncreage, e.limitecredage, e.diascredage, e.id_loc,
(CASE WHEN m.tipo_destino='P' THEN cod_pro||' - '||nompro
WHEN m.tipo_destino='B' THEN ced_bene||' - '||denpro
ELSE ''
END) AS infprobene
FROM aero_ctlage_dt_transacciones m
INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
INNER JOIN aero_ctlage_concepto c ON c.codconcepage=m.codconcepage
INNER JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
WHERE m.codemp='0001'
AND m.codemisor='89500375'
AND m.nrotransage='3';
21/02/2021 19:24:08 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaDetalleTransacCta
ERROR->
Invalid query: ERROR: column "denpro" does not exist
LINE 9: ... WHEN m.tipo_destino='B' THEN m.ced_bene||' - '||denpro
^
HINT: Perhaps you meant to reference the column "pro.dirpro" or the column "pro.telpro".
Whole query: SELECT m.*,
tc.*,
c.denconcepage, c.codtipconcepage, c.sigconcepage, c.codmon AS codmonconcep,
c.monconcepage, c.recargacred, c.abonodeuda,
e.codemisor, e.denemisor, e.tipemisor, e.localidad, e.ref_kiu, e.rptagt,
e.ref_interfaz, e.codcencostemi, e.id_tipemisor, e.canal_emisor, e.id_periodicidad, e.ageemi,
e.estage, e.codmoncreage, e.limitecredage, e.diascredage, e.id_loc,
(CASE WHEN m.tipo_destino='P' THEN m.cod_pro||' - '||nompro
WHEN m.tipo_destino='B' THEN m.ced_bene||' - '||denpro
ELSE ''
END) AS infprobene
FROM aero_ctlage_dt_transacciones m
INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
INNER JOIN aero_ctlage_concepto c ON c.codconcepage=m.codconcepage
INNER JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
WHERE m.codemp='0001'
AND m.codemisor='89500375'
AND m.nrotransage='3';
21/02/2021 19:24:09 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaDetalleTransacCta
ERROR->
Invalid query: ERROR: column "denpro" does not exist
LINE 9: ... WHEN m.tipo_destino='B' THEN m.ced_bene||' - '||denpro
^
HINT: Perhaps you meant to reference the column "pro.dirpro" or the column "pro.telpro".
Whole query: SELECT m.*,
tc.*,
c.denconcepage, c.codtipconcepage, c.sigconcepage, c.codmon AS codmonconcep,
c.monconcepage, c.recargacred, c.abonodeuda,
e.codemisor, e.denemisor, e.tipemisor, e.localidad, e.ref_kiu, e.rptagt,
e.ref_interfaz, e.codcencostemi, e.id_tipemisor, e.canal_emisor, e.id_periodicidad, e.ageemi,
e.estage, e.codmoncreage, e.limitecredage, e.diascredage, e.id_loc,
(CASE WHEN m.tipo_destino='P' THEN m.cod_pro||' - '||nompro
WHEN m.tipo_destino='B' THEN m.ced_bene||' - '||denpro
ELSE ''
END) AS infprobene
FROM aero_ctlage_dt_transacciones m
INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
INNER JOIN aero_ctlage_concepto c ON c.codconcepage=m.codconcepage
INNER JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
WHERE m.codemp='0001'
AND m.codemisor='89500375'
AND m.nrotransage='3';
21/02/2021 19:25:59 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaDetalleTransacCta
ERROR->
Invalid query: ERROR: column "denpro" does not exist
LINE 9: ... WHEN m.tipo_destino='B' THEN m.ced_bene||' - '||denpro
^
HINT: Perhaps you meant to reference the column "pro.dirpro" or the column "pro.telpro".
Whole query: SELECT m.*,
tc.*,
c.denconcepage, c.codtipconcepage, c.sigconcepage, c.codmon AS codmonconcep,
c.monconcepage, c.recargacred, c.abonodeuda,
e.codemisor, e.denemisor, e.tipemisor, e.localidad, e.ref_kiu, e.rptagt,
e.ref_interfaz, e.codcencostemi, e.id_tipemisor, e.canal_emisor, e.id_periodicidad, e.ageemi,
e.estage, e.codmoncreage, e.limitecredage, e.diascredage, e.id_loc,
(CASE WHEN m.tipo_destino='P' THEN m.cod_pro||' - '||nombene
WHEN m.tipo_destino='B' THEN m.ced_bene||' - '||denpro
ELSE ''
END) AS infprobene
FROM aero_ctlage_dt_transacciones m
INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
INNER JOIN aero_ctlage_concepto c ON c.codconcepage=m.codconcepage
INNER JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
WHERE m.codemp='0001'
AND m.codemisor='89500375'
AND m.nrotransage='3';
21/02/2021 19:26:07 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_soa_c_aero
METODO: ConsultaDetalleTransacCta
ERROR->
Invalid query: ERROR: column "denpro" does not exist
LINE 9: ... WHEN m.tipo_destino='B' THEN m.ced_bene||' - '||denpro
^
HINT: Perhaps you meant to reference the column "pro.dirpro" or the column "pro.telpro".
Whole query: SELECT m.*,
tc.*,
c.denconcepage, c.codtipconcepage, c.sigconcepage, c.codmon AS codmonconcep,
c.monconcepage, c.recargacred, c.abonodeuda,
e.codemisor, e.denemisor, e.tipemisor, e.localidad, e.ref_kiu, e.rptagt,
e.ref_interfaz, e.codcencostemi, e.id_tipemisor, e.canal_emisor, e.id_periodicidad, e.ageemi,
e.estage, e.codmoncreage, e.limitecredage, e.diascredage, e.id_loc,
(CASE WHEN m.tipo_destino='P' THEN m.cod_pro||' - '||nombene
WHEN m.tipo_destino='B' THEN m.ced_bene||' - '||denpro
ELSE ''
END) AS infprobene
FROM aero_ctlage_dt_transacciones m
INNER JOIN aero_emisores e ON e.codemisor=m.codemisor
INNER JOIN aero_ctlage_concepto c ON c.codconcepage=m.codconcepage
INNER JOIN aero_ctlage_tipconcepto tc ON tc.codtipconcepage=c.codtipconcepage
LEFT JOIN rpc_proveedor pro ON pro.cod_pro = m.cod_pro AND m.tipo_destino='P'
LEFT JOIN rpc_beneficiario ben ON ben.ced_bene = m.ced_bene AND m.tipo_destino='B'
WHERE m.codemp='0001'
AND m.codemisor='89500375'
AND m.nrotransage='2';