UFN_REVENUE_PAYMENT_UNLINKED

            CREATE function dbo.UFN_REVENUE_PAYMENT_UNLINKED()
            returns table
            as
            return
            (

            select JE.ID [GLTRANSACTIONID]
            from dbo.JOURNALENTRY JE
            inner join dbo.FINANCIALTRANSACTIONLINEITEM LI on LI.ID = JE.FINANCIALTRANSACTIONLINEITEMID
            inner join dbo.FINANCIALTRANSACTION F on F.ID = LI.FINANCIALTRANSACTIONID and F.TYPECODE = 0
            inner join dbo.REVENUEPAYMENTMETHOD PM on PM.REVENUEID = LI.FINANCIALTRANSACTIONID
            left join dbo.BANKACCOUNTDEPOSITPAYMENT DP on LI.FINANCIALTRANSACTIONID = DP.ID
            left join dbo.OTHERPAYMENTMETHODDETAIL OD on OD.ID = PM.ID
            left join dbo.NONDEPOSITABLEPAYMENTMETHOD ND on ND.ID = OD.OTHERPAYMENTMETHODCODEID
            where (PM.PAYMENTMETHODCODE in (0, 1, 2)
                or (PM.PAYMENTMETHODCODE = 10 and ND.ID is null))
                and DP.ID is null
                and F.DELETEDON is null


            )