USP_DATALIST_GIFTAIDGLDISTRIBUTION

Returns a list of gift aid GL distributions for a revenue transaction.
Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_GIFTAIDGLDISTRIBUTION (@ID uniqueidentifier)
                as 
                    select 
                        GIFTAIDGLDISTRIBUTION.REVENUESPLITGIFTAIDID,
                        GIFTAIDGLDISTRIBUTION.ID as GIFTAIDGLDISTRIBUTIONID,
                        MAP.DESCRIPTION,
                        GIFTAIDGLDISTRIBUTION.TRANSACTIONTYPE,                        
                        GIFTAIDGLDISTRIBUTION.ACCOUNT,
                        GIFTAIDGLDISTRIBUTION.PROJECT,
                        GIFTAIDGLDISTRIBUTION.AMOUNT,
                        GIFTAIDGLDISTRIBUTION.REFERENCE,
                        case when REVENUESPLITGIFTAIDPOSTED.ID is null then 1 else 0 end as POSTSTATUSCODE,
                        case when REVENUESPLITGIFTAIDPOSTED.ID is null then 'Not posted' else 'Posted' end as POSTSTATUS,
                        nullif(GIFTAIDGLDISTRIBUTION.TRANSACTIONAMOUNT, 0) [TRANSACTIONAMOUNT],
                        nullif(GIFTAIDGLDISTRIBUTION.AMOUNT, 0) [BASEAMOUNT],
                        nullif(GIFTAIDGLDISTRIBUTION.ORGANIZATIONAMOUNT, 0) [ORGANIZATIONAMOUNT],
                        GIFTAIDGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        GIFTAIDGLDISTRIBUTION.BASECURRENCYID
                    from 
                        dbo.GIFTAIDGLDISTRIBUTION
                        inner join dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP on GIFTAIDGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID = MAP.ID
                        inner join dbo.REVENUESPLIT on GIFTAIDGLDISTRIBUTION.REVENUESPLITGIFTAIDID = REVENUESPLIT.ID
                        left join dbo.REVENUESPLITGIFTAIDPOSTED on GIFTAIDGLDISTRIBUTION.REVENUESPLITGIFTAIDID = REVENUESPLITGIFTAIDPOSTED.ID
                    where 
                        REVENUESPLIT.REVENUEID = @ID
                        and GIFTAIDGLDISTRIBUTION.OUTDATED = 0
                    order by 
                        MAP.DESCRIPTION,GIFTAIDGLDISTRIBUTION.TRANSACTIONTYPE desc;