Error query pagos efectuados reconciliacion

[Nelson183]

Buenos dias

tengo el siguiente query para ver los pagos efectuados por reconciliación pero me trae las Notas Credito, que metodo podria utilizar para no traes dichas notas

SELECT P3."DocDate" as "Fecha Factura", P3."DocNum", P3."CardName", P1."ReconDate" as "Fecha Pago", P1."CreateDate", P1."ReconNum",
P2."ReconSum" AS "Monto"
FROM OITR P1 
INNER JOIN ITR1 P2 ON P1."ReconNum"=P2."ReconNum" 
INNER JOIN OINV P3 ON P2."SrcObjAbs"=P3."DocEntry"
WHERE P2."SrcObjTyp"='13'
AND P3."CardCode" LIKE '%%CL%%'
AND MONTH(P3."DocDate") = MONTH(P1."ReconDate") AND YEAR(P3."DocDate") = YEAR(P1."ReconDate")
AND P3."DocDate" >= [%0] AND P3."DocDate" <= [%1]

Agradezco su ayuda

[Dark_katt]

Buenas tardes, podrías probar de esta manera

@Nelson183

SELECT P3."DocDate" as "Fecha Factura", P3."DocNum", P3."CardName", P1."ReconDate" as "Fecha Pago", P1."CreateDate", P1."ReconNum",
P2."ReconSum" AS "Monto"
FROM OITR P1 
INNER JOIN ITR1 P2 ON P1."ReconNum"=P2."ReconNum" and P2."SrcObjTyp"='13'
INNER JOIN OINV P3 ON P2."SrcObjAbs"=P3."DocEntry"
WHERE P3."CardCode" LIKE '%%CL%%' and P1."ReconType" = 0 and P1."ReconJEId" > 0
AND MONTH(P3."DocDate") = MONTH(P1."ReconDate") AND YEAR(P3."DocDate") = YEAR(P1."ReconDate")
AND P3."DocDate" >= [%0] AND P3."DocDate" <= [%1]