UFN_ALL_UNACKNOWLEDGED_REVENUE_EMAIL_IS_PRIORITY

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

Return

Return Type
table

Definition

Copy



            CREATE function dbo.UFN_ALL_UNACKNOWLEDGED_REVENUE_EMAIL_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 = 1