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