UFN_ALL_UNACKNOWLEDGED_REVENUE_MAIL_IS_PRIORITY

Returns all revenue records that have not been acknowledged and the constituent has a mail preference of mail.

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_ALL_UNACKNOWLEDGED_REVENUE_MAIL_IS_PRIORITY()
            returns table

            as return

            select distinct REVENUETABLE.ID 
                from dbo.UFN_REVENUE_NOTACKNOWLEDGED() as REVENUETABLE
                inner join dbo.REVENUE on REVENUE.ID = REVENUETABLE.ID
                inner join dbo.CONSTITUENT on CONSTITUENT.ID = REVENUE.CONSTITUENTID
                inner join dbo.MAILPREFERENCE on MAILPREFERENCE.CONSTITUENTID = CONSTITUENT.ID
                where MAILPREFERENCE.SENDMAIL = 1
                    and DELIVERYMETHODCODE = 0