USP_DATALIST_GIFTAIDDISQUALIFICATIONRULESNOSITES_2

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_2
                (
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

          select -- Credit card types

            GIFTAIDDISQUALIFIEDBYCREDITCARDTYPE.ID,
            'Payment method' as BASEDON,
            'Credit card type' as SELECTEDCRITERIA,
            CREDITTYPECODE.DESCRIPTION as SUBCRITERIA

            from
              dbo.GIFTAIDDISQUALIFIEDBYCREDITCARDTYPE
            inner join dbo.CREDITTYPECODE
              on CREDITTYPECODE.ID = GIFTAIDDISQUALIFIEDBYCREDITCARDTYPE.ID

          UNION ALL

          select -- Payment method types

            GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD.ID,
            'Payment method' as BASEDON,
            GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD.DESCRIPTION as SELECTEDCRITERIA,
            '' as SUBCRITERIA

            from
                dbo.GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD
            where GIFTAIDDISQUALIFIEDBYPAYMENTMETHOD.PAYMENTMETHOD <> 10 -- other payment method


          UNION ALL

          select --Other payment method types

            GIFTAIDDISQUALIFIEDBYOTHERPAYMENTTYPE.ID,
            'Payment method' as BASEDON,
            'Other payment method' as SELECTEDCRITERIA,
            OTHERPAYMENTMETHODCODE.DESCRIPTION as SUBCRITERIA

            from
                dbo.GIFTAIDDISQUALIFIEDBYOTHERPAYMENTTYPE
            inner join dbo.OTHERPAYMENTMETHODCODE 
              on OTHERPAYMENTMETHODCODE.ID = GIFTAIDDISQUALIFIEDBYOTHERPAYMENTTYPE.ID

          UNION ALL

          select -- Revenue categories

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

          order by
            BASEDON, SELECTEDCRITERIA, SUBCRITERIA