USP_DATALIST_GIFTAIDDISQUALIFICATIONRULESNOSITES

Returns a list of Gift Aid disqualification rules that are not site sensitive.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_GIFTAIDDISQUALIFICATIONRULESNOSITES
                (
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        GIFTAIDDISQUALIFIEDBYCREDITCARDTYPE.ID,
                        'Credit card type' as BASEDON,
                        CREDITTYPECODE.DESCRIPTION as SELECTEDCRITERIA
                    from
                        dbo.GIFTAIDDISQUALIFIEDBYCREDITCARDTYPE
                        inner join dbo.CREDITTYPECODE on CREDITTYPECODE.ID = GIFTAIDDISQUALIFIEDBYCREDITCARDTYPE.ID

                    UNION ALL

                    select
                        GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD.ID,
                        'Payment method' as BASEDON,
                        GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD.DESCRIPTION as SELECTEDCRITERIA
                    from
                        dbo.GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD

                    UNION ALL

                    select
                        GIFTAIDDISQUALIFIEDBYREVENUECATEGORY.ID,
                        'Revenue category' as BASEDON,
                        GLREVENUECATEGORYMAPPING.REVENUECATEGORYNAME as SELECTEDCRITERIA
                    from
                        dbo.GIFTAIDDISQUALIFIEDBYREVENUECATEGORY
                        inner join dbo.GLREVENUECATEGORYMAPPING on GLREVENUECATEGORYMAPPING.ID = GIFTAIDDISQUALIFIEDBYREVENUECATEGORY.ID

                    order by
                        BASEDON, SELECTEDCRITERIA