======Ventas de Inmuebles Gigared 2018  ======

Reporte muestra las ventas inmuebles bajo los codigo de Debitos 

ND000112
ND000114
ND000117

Indicado desde 2017 a hoy. 

<code>


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

</code>