Reporte muestra las ventas inmuebles bajo los codigo de Debitos
ND000112 ND000114 ND000117
Indicado desde 2017 a hoy.
select ctatipcomp as Tipo, ctanrocomp NroComprobante, abonumero, ctafemis as Fecha, ctacoment as Detalle, impneto as Neto, impiva As Iva,ctaimpgrab as Total
from credefac where year(CTAFEMIS) >=2017
and CTATIPCOMP='ND'
and CTANROCOMP in (select CTANROCOMP from ncndtipo where TIPOCOM='ND' and CODIGODEB in ('000117','000114','000112') )
order by ctafecha asc