USP_DATALIST_RECONCILE_APPLIEDTOMULTIPLECLAIMS

This datalist displays claims applied to matching gift payment.

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_RECONCILE_APPLIEDTOMULTIPLECLAIMS
                (
                    @ID uniqueidentifier
                )
                as
                set nocount on;

                select 
                        REVENUE.ID,
                        CONSTITUENT.NAME,
                        REVENUE.AMOUNT,
                        INSTALLMENTPAYMENT.AMOUNT,
                        REVENUE.DATE,
                        dbo.UDA_BUILDLIST(distinct DESIGNATION.NAME),
                        REVENUE.BASECURRENCYID
                    from dbo.INSTALLMENTPAYMENT
                    inner join dbo.REVENUE
                        on INSTALLMENTPAYMENT.PLEDGEID = REVENUE.ID
                    inner join dbo.REVENUESPLIT
                        on INSTALLMENTPAYMENT.PAYMENTID = REVENUESPLIT.ID
                    inner join dbo.DESIGNATION
                        on REVENUESPLIT.DESIGNATIONID = DESIGNATION.ID
                    inner join dbo.CONSTITUENT
                        on REVENUE.CONSTITUENTID = CONSTITUENT.ID
                    where REVENUESPLIT.REVENUEID = @ID
                    group by REVENUE.ID, CONSTITUENT.NAME, REVENUE.AMOUNT, INSTALLMENTPAYMENT.AMOUNT, REVENUE.DATE, REVENUE.BASECURRENCYID