13/03/2022 12:27:19 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** ERROR-> VALIDACIÓN DE DATOS: Faltan la datos de la moneda para configurar la conversión
13/03/2022 12:28:29 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_cxc_c_reportes
METODO: ConsultaScgResumenIngreso
ERROR->
Invalid query: ERROR: invalid input syntax for type date: "--"
LINE 27: WHERE scg.fecha BETWEEN '--' AND '--'
^
Whole query:
SELECT sc_cuenta,
MAX(denominacion) AS denominacion,
round(sum(CASE WHEN debhab = 'D' THEN monto ELSE 0 END)::numeric,2) as debe,
round(sum(CASE WHEN debhab = 'H' THEN monto ELSE 0 END)::numeric,2) as haber,
round(sum(CASE WHEN debhab = 'D' THEN monto ELSE -monto END)::numeric,2) as saldo
FROM
(
SELECT trim(scg.sc_cuenta) as sc_cuenta,
cta.denominacion,
scg.debhab,
round(sum(scg.monto)::numeric,2) as monto
FROM cxc_dt_scg scg
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = scg.codemp
AND mc.nromovcob = scg.nromovcob
AND mc.id_doc = scg.id_doc
AND mc.tipdoc = scg.tipdoc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
INNER JOIN sigesp_moneda m ON m.codmon=mc.codmon
INNER JOIN cxc_sucursales suc ON suc.codemp = mc.codemp
AND suc.codsuc = mc.codsuc
LEFT JOIN scg_cuentas cta ON cta.sc_cuenta = scg.sc_cuenta
WHERE scg.fecha BETWEEN '--' AND '--'
AND mc.tipdoc NOT IN ('RET')
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
GROUP BY 1,2,3
UNION
SELECT trim(scg.sc_cuenta) as sc_cuenta,
cta.denominacion,
scg.debhab,
round(sum(scg.monto)::numeric,2) as monto
FROM cxc_dt_scg scg
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = scg.codemp
AND mc.nromovcob = scg.nromovcob
AND mc.id_doc = scg.id_doc
AND mc.tipdoc = scg.tipdoc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
INNER JOIN sigesp_moneda m ON m.codmon=mc.codmon
INNER JOIN cxc_sucursales suc ON suc.codemp = mc.codemp
AND suc.codsuc = mc.codsuc
LEFT JOIN scg_cuentas cta ON cta.sc_cuenta = scg.sc_cuenta
WHERE scg.fecha BETWEEN '--' AND '--'
AND scg.tipdoc = 'RET'
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
GROUP BY 1,2,3
UNION
SELECT trim(scg.sc_cuenta) as sc_cuenta,
cta.denominacion,
(CASE WHEN debhab = 'D' THEN 'H' ELSE 'D' END) AS debhab,
round(sum(scg.monto)::numeric,2) as monto
FROM cxc_dt_scg scg
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = scg.codemp
AND mc.nromovcob = scg.nromovcob
AND mc.id_doc = scg.id_doc
AND mc.tipdoc = scg.tipdoc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
INNER JOIN sigesp_moneda m ON m.codmon=mc.codmon
INNER JOIN cxc_sucursales suc ON suc.codemp = mc.codemp
AND suc.codsuc = mc.codsuc
LEFT JOIN scg_cuentas cta ON cta.sc_cuenta = scg.sc_cuenta
WHERE mc.fecanucob BETWEEN '--' AND '--'
AND mc.estmovcob = 'ANU'
AND mc.tipdoc NOT IN ('RET')
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
GROUP BY 1,2,3
UNION
SELECT trim(scg.sc_cuenta) as sc_cuenta,
cta.denominacion,
(CASE WHEN debhab = 'D' THEN 'H' ELSE 'D' END) AS debhab,
round(sum(scg.monto)::numeric,2) as monto
FROM cxc_dt_scg scg
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = scg.codemp
AND mc.nromovcob = scg.nromovcob
AND mc.id_doc = scg.id_doc
AND mc.tipdoc = scg.tipdoc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
INNER JOIN sigesp_moneda m ON m.codmon=mc.codmon
INNER JOIN cxc_sucursales suc ON suc.codemp = mc.codemp
AND suc.codsuc = mc.codsuc
LEFT JOIN scg_cuentas cta ON cta.sc_cuenta = scg.sc_cuenta
WHERE mc.fecanucob BETWEEN '--' AND '--'
AND mc.estmovcob = 'ANU'
AND scg.tipdoc = 'RET'
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
GROUP BY 1,2,3
ORDER BY 1,2,3
) AS cmp
GROUP BY 1
ORDER BY 1
13/03/2022 13:47:31 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: ConsultaAnticipoInvalid query: ERROR: column da.fecdec does not exist
LINE 24: AND da.fecdec BETWEEN '2021-01-01' AND '2021-12-...
^
HINT: Perhaps you meant to reference the column "da.fecdesc".
Whole query: SELECT
a.codemp, a.idant, a.id_cliente, a.nroant, a.nroproy, a.nrocontrato,
a.scg_cuenta_ant,
a.fecant, a.conant, a.porant, a.codmon,
a.tascam AS tascam,
round(a.monant::numeric,8) as monant,
a.estant,
a.fecanuant,
a.conanuant, a.fecregant, a.usuregant, a.horaregant,
a.nroing, a.codsucres,
a.codcajres, a.resing, a.codmonref, a.tascamref,
cl.*,mo.*,e.*,
round((
a.monant
-
( SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND da.fecdec BETWEEN '2021-01-01' AND '2021-12-31'
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
AND estdesc='P'
)
)::numeric,8) AS saldo_ant,
(
SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND da.fecdec BETWEEN '2021-01-01' AND '2021-12-31'
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
AND estdesc='P'
) AS ant_apl
FROM cxc_anticipos a INNER JOIN cxc_clientes cl ON cl.id_cliente = a.id_cliente
INNER JOIN cxc_estanticipo e ON e.estant = a.estant
LEFT JOIN sigesp_moneda mo ON a.codmon = mo.codmon
LEFT JOIN cxc_ingresos ing ON ing.codsuc = a.codsucres
AND ing.codcaj = a.codcajres
AND ing.nroing = a.resing
WHERE a.conant ILIKE('%%')
AND a.codmon = 'VES' AND a.fecant BETWEEN '2021-01-01' AND '2021-12-31' AND (a.fecanuant > '2021-12-31' OR a.fecanuant IS NULL OR a.fecanuant ='1900-01-01' ) AND (ing.aero_ticket='' OR ing.aero_ticket IS NULL) AND ing.id_fact_ticket=0
ORDER BY a.codmon,a.id_cliente, a.nroant
13/03/2022 14:20:18 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: ConsultaAnticipoInvalid query: ERROR: column ing.codsucres does not exist
LINE 65: AND mc.codsuc = ing.codsucres
^
HINT: Perhaps you meant to reference the column "a.codsucres" or the column "ing.codsuc".
Whole query: SELECT
a.codemp, a.idant, a.id_cliente, a.nroant, a.nroproy, a.nrocontrato,
a.scg_cuenta_ant,
a.fecant, a.conant, a.porant, a.codmon,
a.tascam AS tascam,
round(a.monant::numeric,8) as monant,
a.estant,
a.fecanuant,
a.conanuant, a.fecregant, a.usuregant, a.horaregant,
a.nroing, a.codsucres,
a.codcajres, a.resing, a.codmonref, a.tascamref,
cl.*,mo.*,e.*,
round((
a.monant
-
( SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = da.codemp
AND mc.nromovcob = da.nromovcob
AND mc.id_doc = da.id_fact
AND mc.tipdoc = 'FACT'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND da.fecdesc BETWEEN '2021-01-01' AND '2021-12-31'
AND (mc.fecanucob > '2021-12-31' OR mc.fecanucob IS NULL OR mc.fecanucob ='1900-01-01' )
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
/*AND estdesc='P'*/
)
)::numeric,8) AS saldo_ant,
(
SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = da.codemp
AND mc.nromovcob = da.nromovcob
AND mc.id_doc = da.id_fact
AND mc.tipdoc = 'FACT'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND da.fecdesc BETWEEN '2021-01-01' AND '2021-12-31'
AND (mc.fecanucob > '2021-12-31' OR mc.fecanucob IS NULL OR mc.fecanucob ='1900-01-01' )
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
/*AND estdesc='P'*/
) AS ant_apl
FROM cxc_anticipos a INNER JOIN cxc_clientes cl ON cl.id_cliente = a.id_cliente
INNER JOIN cxc_estanticipo e ON e.estant = a.estant
LEFT JOIN sigesp_moneda mo ON a.codmon = mo.codmon
LEFT JOIN cxc_ingresos ing ON ing.codsuc = a.codsucres
AND ing.codcaj = a.codcajres
AND ing.nroing = a.resing
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = a.codemp
AND mc.id_doc = a.idant
AND mc.tipdoc = 'ANTI'
AND mc.codsuc = ing.codsucres
AND mc.codcaj = ing.codcajres
AND mc.nroing = ing.resing
WHERE a.conant ILIKE('%%')
AND a.codmon = 'VES' AND a.fecant BETWEEN '2021-01-01' AND '2021-12-31' AND (a.fecanuant > '2021-12-31' OR a.fecanuant IS NULL OR a.fecanuant ='1900-01-01' ) AND (ing.aero_ticket='' OR ing.aero_ticket IS NULL) AND ing.id_fact_ticket=0
ORDER BY a.codmon,a.id_cliente, a.nroant
13/03/2022 14:20:36 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: ConsultaAnticipoInvalid query: ERROR: column ing.resing does not exist
LINE 67: AND mc.nroing = ing.resing ...
^
Whole query: SELECT
a.codemp, a.idant, a.id_cliente, a.nroant, a.nroproy, a.nrocontrato,
a.scg_cuenta_ant,
a.fecant, a.conant, a.porant, a.codmon,
a.tascam AS tascam,
round(a.monant::numeric,8) as monant,
a.estant,
a.fecanuant,
a.conanuant, a.fecregant, a.usuregant, a.horaregant,
a.nroing, a.codsucres,
a.codcajres, a.resing, a.codmonref, a.tascamref,
cl.*,mo.*,e.*,
round((
a.monant
-
( SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = da.codemp
AND mc.nromovcob = da.nromovcob
AND mc.id_doc = da.id_fact
AND mc.tipdoc = 'FACT'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND da.fecdesc BETWEEN '2021-01-01' AND '2021-12-31'
AND (mc.fecanucob > '2021-12-31' OR mc.fecanucob IS NULL OR mc.fecanucob ='1900-01-01' )
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
/*AND estdesc='P'*/
)
)::numeric,8) AS saldo_ant,
(
SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = da.codemp
AND mc.nromovcob = da.nromovcob
AND mc.id_doc = da.id_fact
AND mc.tipdoc = 'FACT'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND da.fecdesc BETWEEN '2021-01-01' AND '2021-12-31'
AND (mc.fecanucob > '2021-12-31' OR mc.fecanucob IS NULL OR mc.fecanucob ='1900-01-01' )
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
/*AND estdesc='P'*/
) AS ant_apl
FROM cxc_anticipos a INNER JOIN cxc_clientes cl ON cl.id_cliente = a.id_cliente
INNER JOIN cxc_estanticipo e ON e.estant = a.estant
LEFT JOIN sigesp_moneda mo ON a.codmon = mo.codmon
LEFT JOIN cxc_ingresos ing ON ing.codsuc = a.codsucres
AND ing.codcaj = a.codcajres
AND ing.nroing = a.resing
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = a.codemp
AND mc.id_doc = a.idant
AND mc.tipdoc = 'ANTI'
AND mc.codsuc = ing.codsuc
AND mc.codcaj = ing.codcaj
AND mc.nroing = ing.resing
WHERE a.conant ILIKE('%%')
AND a.codmon = 'VES' AND a.fecant BETWEEN '2021-01-01' AND '2021-12-31' AND (a.fecanuant > '2021-12-31' OR a.fecanuant IS NULL OR a.fecanuant ='1900-01-01' ) AND (ing.aero_ticket='' OR ing.aero_ticket IS NULL) AND ing.id_fact_ticket=0
ORDER BY a.codmon,a.id_cliente, a.nroant
13/03/2022 14:29:36 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR *****
ERROR->
CLASE: covensol_cxc_cuentasxcobrar
METODO: ConsultaAnticipoInvalid query: ERROR: missing FROM-clause entry for table "mc"
LINE 62: INNER JOIN cxc_dt_movcobro mca ON mc.codemp = a....
^
Whole query: SELECT
a.codemp, a.idant, a.id_cliente, a.nroant, a.nroproy, a.nrocontrato,
a.scg_cuenta_ant,
a.fecant, a.conant, a.porant, a.codmon,
a.tascam AS tascam,
round(a.monant::numeric,8) as monant,
a.estant,
a.fecanuant,
a.conanuant, a.fecregant, a.usuregant, a.horaregant,
a.nroing, a.codsucres,
a.codcajres, a.resing, a.codmonref, a.tascamref,
cl.*,mo.*,e.*,
round((
a.monant
-
( SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = da.codemp
AND mc.nromovcob = da.nromovcob
AND mc.id_doc = da.id_fact
AND mc.tipdoc = 'FACT'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND mc.fecmovcob BETWEEN '2021-01-01' AND '2021-12-31'
AND (mc.fecanucob > '2021-12-31' OR mc.fecanucob IS NULL OR mc.fecanucob ='1900-01-01' )
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
/*AND estdesc='P'*/
)
)::numeric,8) AS saldo_ant,
(
SELECT COALESCE(sum((da.montodesc/f.tascam)*ant.tascam),0)
FROM cxc_dt_anticipos da
INNER JOIN cxc_anticipos ant ON da.codemp = ant.codemp
AND da.id_cliente = ant.id_cliente
AND da.nroant = ant.nroant
AND ant.estant!='ANU'
INNER JOIN cxc_dt_movcobro mc ON mc.codemp = da.codemp
AND mc.nromovcob = da.nromovcob
AND mc.id_doc = da.id_fact
AND mc.tipdoc = 'FACT'
INNER JOIN cxc_factura f ON f.id_fact = da.id_fact
WHERE da.codemp=a.codemp
AND mc.fecmovcob BETWEEN '2021-01-01' AND '2021-12-31'
AND (mc.fecanucob > '2021-12-31' OR mc.fecanucob IS NULL OR mc.fecanucob ='1900-01-01' )
AND da.id_cliente=a.id_cliente
AND da.nroant=a.nroant
/*AND estdesc='P'*/
) AS ant_apl
FROM cxc_anticipos a INNER JOIN cxc_clientes cl ON cl.id_cliente = a.id_cliente
INNER JOIN cxc_estanticipo e ON e.estant = a.estant
INNER JOIN sigesp_moneda mo ON a.codmon = mo.codmon
INNER JOIN cxc_ingresos ing ON ing.codsuc = a.codsucres
AND ing.codcaj = a.codcajres
AND ing.nroing = a.resing
INNER JOIN cxc_dt_movcobro mca ON mc.codemp = a.codemp
AND mca.id_doc = a.idant
AND mca.tipdoc = 'ANTI'
AND mca.codsuc = ing.codsuc
AND mca.codcaj = ing.codcaj
AND mca.nroing = ing.nroing
WHERE a.conant ILIKE('%%')
AND a.codmon = 'VES' AND a.fecant BETWEEN '2021-01-01' AND '2021-12-31' AND (a.fecanuant > '2021-12-31' OR a.fecanuant IS NULL OR a.fecanuant ='1900-01-01' ) AND (ing.aero_ticket='' OR ing.aero_ticket IS NULL) AND ing.id_fact_ticket=0
ORDER BY a.codmon,a.id_cliente, a.nroant
13/03/2022 15:30:46 ***** 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_scg_dt_c_sigesp_cm_sigesp_c" on table "scg_dt_cmp"
DETAIL: Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCANC, C-0001-0001037304-04, 2021-06-04, ---, -------------------------) is still referenced from table "scg_dt_cmp".
Whole query: DELETE FROM sigesp_cmp WHERE codemp = '0001' AND procede='CXCANC' AND comprobante='C-0001-0001037304-04' AND fecha='2021-06-04' AND codban='---' AND ctaban='-------------------------'
13/03/2022 15:40:57 ***** 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_scg_dt_c_sigesp_cm_sigesp_c" on table "scg_dt_cmp"
DETAIL: Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCANC, C-0001-0001037304-04, 2021-06-04, ---, -------------------------) is still referenced from table "scg_dt_cmp".
Whole query: DELETE FROM sigesp_cmp WHERE codemp = '0001' AND procede='CXCANC' AND comprobante='C-0001-0001037304-04' AND fecha='2021-06-04' AND codban='---' AND ctaban='-------------------------'
13/03/2022 15:41:23 ***** 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_scg_dt_c_sigesp_cm_sigesp_c" on table "scg_dt_cmp"
DETAIL: Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCANC, C-0001-0001037304-04, 2021-06-04, ---, -------------------------) is still referenced from table "scg_dt_cmp".
Whole query: DELETE FROM sigesp_cmp WHERE codemp = '0001' AND procede='CXCANC' AND comprobante='C-0001-0001037304-04' AND fecha='2021-06-04' AND codban='---' AND ctaban='-------------------------'
13/03/2022 15:43:40 ***** 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_scg_dt_c_sigesp_cm_sigesp_c" on table "scg_dt_cmp"
DETAIL: Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCANC, C-0001-0001037304-04, 2021-06-04, ---, -------------------------) is still referenced from table "scg_dt_cmp".
Whole query: DELETE FROM sigesp_cmp WHERE codemp = '0001' AND procede='CXCANC' AND comprobante='C-0001-0001037304-04' AND fecha='2021-06-04' AND codban='---' AND ctaban='-------------------------'
13/03/2022 15:46:12 ***** 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_scg_dt_c_sigesp_cm_sigesp_c" on table "scg_dt_cmp"
DETAIL: Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCANC, C-0001-0001037304-04, 2021-06-04, ---, -------------------------) is still referenced from table "scg_dt_cmp".
Whole query: DELETE FROM sigesp_cmp WHERE codemp = '0001' AND procede='CXCANC' AND comprobante='C-0001-0001037304-04' AND fecha='2021-06-04' AND codban='---' AND ctaban='-------------------------'
13/03/2022 15:59:23 ***** 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_scg_dt_c_sigesp_cm_sigesp_c" on table "scg_dt_cmp"
DETAIL: Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCANC, C-0001-0001037304-04, 2021-06-04, ---, -------------------------) is still referenced from table "scg_dt_cmp".
Whole query: DELETE FROM sigesp_cmp WHERE codemp = '0001' AND procede='CXCANC' AND comprobante='C-0001-0001037304-04' AND fecha='2021-06-04' AND codban='---' AND ctaban='-------------------------'
13/03/2022 16:00:34 ***** 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_scg_dt_c_sigesp_cm_sigesp_c" on table "scg_dt_cmp"
DETAIL: Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCANC, C-0001-0001037304-04, 2021-06-04, ---, -------------------------) is still referenced from table "scg_dt_cmp".
Whole query: DELETE FROM sigesp_cmp WHERE codemp = '0001' AND procede='CXCANC' AND comprobante='C-0001-0001037304-04' AND fecha='2021-06-04' AND codban='---' AND ctaban='-------------------------'
13/03/2022 16:03:17 ***** 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_scg_dt_c_sigesp_cm_sigesp_c" on table "scg_dt_cmp"
DETAIL: Key (codemp, procede, comprobante, fecha, codban, ctaban)=(0001, CXCANC, C-0001-0001037304-04, 2021-06-04, ---, -------------------------) is still referenced from table "scg_dt_cmp".
Whole query: DELETE FROM sigesp_cmp WHERE codemp = '0001' AND procede='CXCANC' AND comprobante='C-0001-0001037304-04' AND fecha='2021-06-04' AND codban='---' AND ctaban='-------------------------'
13/03/2022 22:14:22 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_cxc_c_reportes
METODO: ConsultaMovimientosIngreso
ERROR->
Invalid query: ERROR: missing FROM-clause entry for table "uadm"
LINE 23: uadm.sigunicosto,
^
Whole query:
SELECT tipmov,
id_cliente,
nombre_cliente,
codsuc,
codcaj,
coduniejesuc,
nroing,
fecmov,
nromovcob,
tipdoc,
id_doc,
numdoc,
codforpag,
codmon,
abrmon,
denmon,
denforpag,
conanucob,
sigsuc,
usureg,
codcliente,
uadm.sigunicosto,
obscob,
codban,
ctaban,
moncobtot,
moncobret,
moncobant,
moncobnc,
moncobotros,
moncobfon
FROM
(
SELECT
'COB FACT' AS tipmov,
c.id_cliente AS id_cliente,
c.nombre_cliente AS nombre_cliente,
mc.codsuc AS codsuc,
mc.codcaj AS codcaj,
suc.coduniejesuc AS coduniejesuc,
mc.nroing AS nroing,
mc.fecmovcob AS fecmov,
mc.nromovcob AS nromovcob,
mc.tipdoc AS tipdoc,
mc.id_doc AS id_doc,
f.numfact AS numdoc,
mc.codforpag AS codforpag,
f.codmon AS codmon,
mo.abrmon AS abrmon,
mo.denmon AS denmon,
fp.denforpag AS denforpag,
mc.conanucob AS conanucob,
suc.sigsuc as sigsuc,
mc.usureg AS usureg,
c.codcliente AS codcliente,
uadm.sigunicosto,
mc.obscob AS obscob,
mc.codban AS codban,
mc.ctaban AS ctaban,
(monmovcob/f.tascam) as moncobtot,
(moncobret/f.tascam) as moncobret,
(moncobant/f.tascam) as moncobant,
(moncobnc/f.tascam) as moncobnc,
(moncobotros/f.tascam) as moncobotros,
(moncobfon/f.tascam) as moncobfon
FROM cxc_dt_movcobro mc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_factura f ON f.codemp = mc.codemp
AND f.id_fact = mc.id_doc
LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp
AND suc.codsuc = f.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp
AND caj.codsuc = f.codsuc
AND caj.codcaj = f.codcaj
LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
INNER JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
WHERE mc.fecmovcob BETWEEN '2021-12-27' AND '2021-12-31'
AND mc.tipdoc='FACT'
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND mc.codmon = 'VES' AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
UNION ALL
SELECT
'ANU COB FACT' AS tipmov,
c.id_cliente AS id_cliente,
c.nombre_cliente AS nombre_cliente,
mc.codsuc AS codsuc,
mc.codcaj AS codcaj,
suc.coduniejesuc AS coduniejesuc,
mc.nroing AS nroing,
mc.fecanucob AS fecmov,
mc.nromovcob AS nromovcob,
mc.tipdoc AS tipdoc,
mc.id_doc AS id_doc,
f.numfact AS numdoc,
mc.codforpag AS codforpag,
f.codmon AS codmon,
mo.abrmon AS abrmon,
mo.denmon AS denmon,
fp.denforpag AS denforpag,
mc.conanucob AS conanucob,
suc.sigsuc as sigsuc,
mc.usureganu AS usureg,
c.codcliente AS codcliente,
uadm.sigunicosto,
mc.obscob AS obscob,
mc.codban AS codban,
mc.ctaban AS ctaban,
-(monmovcob/f.tascam) as moncobtot,
-(moncobret/f.tascam) as moncobret,
-(moncobant/f.tascam) as moncobant,
-(moncobnc/f.tascam) as moncobnc,
-(moncobotros/f.tascam) as moncobotros,
-(moncobfon/f.tascam) as moncobfon
FROM cxc_dt_movcobro mc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_factura f ON f.codemp = mc.codemp
AND f.id_fact = mc.id_doc
LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp
AND suc.codsuc = f.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp
AND caj.codsuc = f.codsuc
AND caj.codcaj = f.codcaj
LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
INNER JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
WHERE mc.fecanucob BETWEEN '2021-12-27' AND '2021-12-31'
AND mc.estmovcob='ANU'
AND tipdoc='FACT'
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND mc.codmon = 'VES' AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
UNION ALL
SELECT
'COB ANT' AS tipmov,
c.id_cliente AS id_cliente,
c.nombre_cliente AS nombre_cliente,
mc.codsuc AS codsuc,
mc.codcaj AS codcaj,
suc.coduniejesuc AS coduniejesuc,
mc.nroing AS nroing,
mc.fecmovcob AS fecmov,
mc.nromovcob AS nromovcob,
mc.tipdoc AS tipdoc,
mc.id_doc AS id_doc,
a.nroant AS numdoc,
mc.codforpag AS codforpag,
mc.codmon AS codmon,
mo.abrmon AS abrmon,
mo.denmon AS denmon,
fp.denforpag AS denforpag,
mc.conanucob AS conanucob,
suc.sigsuc as sigsuc,
mc.usureg AS usureg,
c.codcliente AS codcliente,
uadm.sigunicosto,
mc.obscob AS obscob,
mc.codban AS codban,
mc.ctaban AS ctaban,
(monmovcob/mc.tascam) as moncobtot,
(moncobret/mc.tascam) as moncobret,
(moncobant/mc.tascam) as moncobant,
(moncobnc/mc.tascam) as moncobnc,
(moncobotros/mc.tascam) as moncobotros,
(moncobfon/mc.tascam) as moncobfon
FROM cxc_dt_movcobro mc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_anticipos a ON a.codemp = mc.codemp
AND a.idant = mc.id_doc
INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
LEFT JOIN cxc_sucursales suc ON suc.codemp = i.codemp
AND suc.codsuc = i.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = i.codemp
AND caj.codsuc = i.codsuc
AND caj.codcaj = i.codcaj
LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
WHERE mc.fecmovcob BETWEEN '2021-12-27' AND '2021-12-31'
AND mc.tipdoc='ANTI'
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND mc.codmon = 'VES' AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
UNION ALL
SELECT
'ANU COB ANT' AS tipmov,
c.id_cliente AS id_cliente,
c.nombre_cliente AS nombre_cliente,
mc.codsuc AS codsuc,
mc.codcaj AS codcaj,
suc.coduniejesuc AS coduniejesuc,
mc.nroing AS nroing,
mc.fecanucob AS fecmov,
mc.nromovcob AS nromovcob,
mc.tipdoc AS tipdoc,
mc.id_doc AS id_doc,
a.nroant AS numdoc,
mc.codforpag AS codforpag,
mc.codmon AS codmon,
mo.abrmon AS abrmon,
mo.denmon AS denmon,
fp.denforpag AS denforpag,
mc.conanucob AS conanucob,
suc.sigsuc as sigsuc,
mc.usureganu AS usureg,
c.codcliente AS codcliente,
uadm.sigunicosto,
mc.obscob AS obscob,
mc.codban AS codban,
mc.ctaban AS ctaban,
-(monmovcob/mc.tascam) as moncobtot,
-(moncobret/mc.tascam) as moncobret,
-(moncobant/mc.tascam) as moncobant,
-(moncobnc/mc.tascam) as moncobnc,
-(moncobotros/mc.tascam) as moncobotros,
-(moncobfon/mc.tascam) as moncobfon
FROM cxc_dt_movcobro mc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_anticipos a ON a.codemp = mc.codemp
AND a.idant = mc.id_doc
INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
LEFT JOIN cxc_sucursales suc ON suc.codemp = i.codemp
AND suc.codsuc = i.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = i.codemp
AND caj.codsuc = i.codsuc
AND caj.codcaj = i.codcaj
LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
WHERE mc.fecanucob BETWEEN '2021-12-27' AND '2021-12-31'
AND mc.tipdoc='ANTI'
AND mc.estmovcob='ANU'
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND mc.codmon = 'VES' AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
ORDER BY 14,8,4,5,7
) AS cmp
13/03/2022 22:36:41 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE: covensol_cxc_c_reportes
METODO: ConsultaMovimientosIngreso
ERROR->
Invalid query: ERROR: syntax error at or near "AND"
LINE 281: AND (cmp.tipdoc IN ('ANTI') OR moncobant!=0) ORDER...
^
Whole query:
SELECT tipmov,
id_cliente,
nombre_cliente,
codsuc,
codcaj,
coduniejesuc,
nroing,
fecmov,
nromovcob,
tipdoc,
id_doc,
numdoc,
codforpag,
codmon,
abrmon,
denmon,
denforpag,
conanucob,
sigsuc,
usureg,
codcliente,
sigunicosto,
obscob,
codban,
ctaban,
moncobtot,
moncobret,
moncobant,
moncobnc,
moncobotros,
moncobfon
FROM
(
SELECT
'COB FACT' AS tipmov,
c.id_cliente AS id_cliente,
c.nombre_cliente AS nombre_cliente,
mc.codsuc AS codsuc,
mc.codcaj AS codcaj,
suc.coduniejesuc AS coduniejesuc,
mc.nroing AS nroing,
mc.fecmovcob AS fecmov,
mc.nromovcob AS nromovcob,
mc.tipdoc AS tipdoc,
mc.id_doc AS id_doc,
f.numfact AS numdoc,
mc.codforpag AS codforpag,
f.codmon AS codmon,
mo.abrmon AS abrmon,
mo.denmon AS denmon,
fp.denforpag AS denforpag,
mc.conanucob AS conanucob,
suc.sigsuc as sigsuc,
mc.usureg AS usureg,
c.codcliente AS codcliente,
uadm.sigunicosto,
mc.obscob AS obscob,
mc.codban AS codban,
mc.ctaban AS ctaban,
(monmovcob/f.tascam) as moncobtot,
(moncobret/f.tascam) as moncobret,
(moncobant/f.tascam) as moncobant,
(moncobnc/f.tascam) as moncobnc,
(moncobotros/f.tascam) as moncobotros,
(moncobfon/f.tascam) as moncobfon
FROM cxc_dt_movcobro mc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_factura f ON f.codemp = mc.codemp
AND f.id_fact = mc.id_doc
LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp
AND suc.codsuc = f.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp
AND caj.codsuc = f.codsuc
AND caj.codcaj = f.codcaj
LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
INNER JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
WHERE mc.fecmovcob BETWEEN '2021-12-21' AND '2021-12-26'
AND mc.tipdoc='FACT'
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND mc.codmon = 'VES' AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
UNION ALL
SELECT
'ANU COB FACT' AS tipmov,
c.id_cliente AS id_cliente,
c.nombre_cliente AS nombre_cliente,
mc.codsuc AS codsuc,
mc.codcaj AS codcaj,
suc.coduniejesuc AS coduniejesuc,
mc.nroing AS nroing,
mc.fecanucob AS fecmov,
mc.nromovcob AS nromovcob,
mc.tipdoc AS tipdoc,
mc.id_doc AS id_doc,
f.numfact AS numdoc,
mc.codforpag AS codforpag,
f.codmon AS codmon,
mo.abrmon AS abrmon,
mo.denmon AS denmon,
fp.denforpag AS denforpag,
mc.conanucob AS conanucob,
suc.sigsuc as sigsuc,
mc.usureganu AS usureg,
c.codcliente AS codcliente,
uadm.sigunicosto,
mc.obscob AS obscob,
mc.codban AS codban,
mc.ctaban AS ctaban,
-(monmovcob/f.tascam) as moncobtot,
-(moncobret/f.tascam) as moncobret,
-(moncobant/f.tascam) as moncobant,
-(moncobnc/f.tascam) as moncobnc,
-(moncobotros/f.tascam) as moncobotros,
-(moncobfon/f.tascam) as moncobfon
FROM cxc_dt_movcobro mc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_factura f ON f.codemp = mc.codemp
AND f.id_fact = mc.id_doc
LEFT JOIN cxc_sucursales suc ON suc.codemp = f.codemp
AND suc.codsuc = f.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = f.codemp
AND caj.codsuc = f.codsuc
AND caj.codcaj = f.codcaj
LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
INNER JOIN cxc_clientes c ON c.id_cliente = f.id_cliente
INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
WHERE mc.fecanucob BETWEEN '2021-12-21' AND '2021-12-26'
AND mc.estmovcob='ANU'
AND tipdoc='FACT'
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND mc.codmon = 'VES' AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
UNION ALL
SELECT
'COB ANT' AS tipmov,
c.id_cliente AS id_cliente,
c.nombre_cliente AS nombre_cliente,
mc.codsuc AS codsuc,
mc.codcaj AS codcaj,
suc.coduniejesuc AS coduniejesuc,
mc.nroing AS nroing,
mc.fecmovcob AS fecmov,
mc.nromovcob AS nromovcob,
mc.tipdoc AS tipdoc,
mc.id_doc AS id_doc,
a.nroant AS numdoc,
mc.codforpag AS codforpag,
mc.codmon AS codmon,
mo.abrmon AS abrmon,
mo.denmon AS denmon,
fp.denforpag AS denforpag,
mc.conanucob AS conanucob,
suc.sigsuc as sigsuc,
mc.usureg AS usureg,
c.codcliente AS codcliente,
uadm.sigunicosto,
mc.obscob AS obscob,
mc.codban AS codban,
mc.ctaban AS ctaban,
(monmovcob/mc.tascam) as moncobtot,
(moncobret/mc.tascam) as moncobret,
(moncobant/mc.tascam) as moncobant,
(moncobnc/mc.tascam) as moncobnc,
(moncobotros/mc.tascam) as moncobotros,
(moncobfon/mc.tascam) as moncobfon
FROM cxc_dt_movcobro mc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_anticipos a ON a.codemp = mc.codemp
AND a.idant = mc.id_doc
INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
LEFT JOIN cxc_sucursales suc ON suc.codemp = i.codemp
AND suc.codsuc = i.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = i.codemp
AND caj.codsuc = i.codsuc
AND caj.codcaj = i.codcaj
LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
INNER JOIN cxc_tipo_clientes tc ON tc.id_tipo_cliente = c.id_tipo_cliente
INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
WHERE mc.fecmovcob BETWEEN '2021-12-21' AND '2021-12-26'
AND mc.tipdoc='ANTI'
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND mc.codmon = 'VES' AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
UNION ALL
SELECT
'ANU COB ANT' AS tipmov,
c.id_cliente AS id_cliente,
c.nombre_cliente AS nombre_cliente,
mc.codsuc AS codsuc,
mc.codcaj AS codcaj,
suc.coduniejesuc AS coduniejesuc,
mc.nroing AS nroing,
mc.fecanucob AS fecmov,
mc.nromovcob AS nromovcob,
mc.tipdoc AS tipdoc,
mc.id_doc AS id_doc,
a.nroant AS numdoc,
mc.codforpag AS codforpag,
mc.codmon AS codmon,
mo.abrmon AS abrmon,
mo.denmon AS denmon,
fp.denforpag AS denforpag,
mc.conanucob AS conanucob,
suc.sigsuc as sigsuc,
mc.usureganu AS usureg,
c.codcliente AS codcliente,
uadm.sigunicosto,
mc.obscob AS obscob,
mc.codban AS codban,
mc.ctaban AS ctaban,
-(monmovcob/mc.tascam) as moncobtot,
-(moncobret/mc.tascam) as moncobret,
-(moncobant/mc.tascam) as moncobant,
-(moncobnc/mc.tascam) as moncobnc,
-(moncobotros/mc.tascam) as moncobotros,
-(moncobfon/mc.tascam) as moncobfon
FROM cxc_dt_movcobro mc
INNER JOIN cxc_ingresos i ON i.codemp = mc.codemp
AND i.codsuc = mc.codsuc
AND i.codcaj = mc.codcaj
AND i.nroing = mc.nroing
INNER JOIN cxc_anticipos a ON a.codemp = mc.codemp
AND a.idant = mc.id_doc
INNER JOIN cxc_clientes c ON c.id_cliente = i.id_cliente
LEFT JOIN cxc_sucursales suc ON suc.codemp = i.codemp
AND suc.codsuc = i.codsuc
LEFT JOIN cxc_cajas caj ON caj.codemp = i.codemp
AND caj.codsuc = i.codsuc
AND caj.codcaj = i.codcaj
LEFT JOIN spg_unidadadministrativa uadm ON uadm.coduniadm = suc.coduniejesuc
INNER JOIN sigesp_moneda mo ON mo.codmon = mc.codmon
INNER JOIN cxc_formapago fp ON fp.codforpag = mc.codforpag
WHERE mc.fecanucob BETWEEN '2021-12-21' AND '2021-12-26'
AND mc.tipdoc='ANTI'
AND mc.estmovcob='ANU'
AND mc.codsuc IN (
SELECT pint.codintper
FROM sss_permisos_internos pint
WHERE pint.codemp='0001'
AND pint.codusu='ADMINISTRADOR'
AND pint.codsis='CXC'
AND trim(pint.codintper)=trim(i.codsuc)
)
AND mc.codmon = 'VES' AND (i.aero_ticket='' OR i.aero_ticket IS NULL) AND i.id_fact_ticket=0
ORDER BY 14,8,4,5,7
) AS cmp
AND (cmp.tipdoc IN ('ANTI') OR moncobant!=0) ORDER BY 14,10,1,8,4,5,7