USP_DATALIST_PLANNEDGIFTPAYOUTGLDISTRIBUTION

A datalist of planned gift payout GL distribution.
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_PLANNEDGIFTPAYOUTGLDISTRIBUTION (@ID uniqueidentifier)
                as 
                    set nocount on;
                    select 
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.REVENUEID as ID,
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.ID as REVENUEGLDISTRIBUTIONID,
                        MAP.DESCRIPTION,
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.TRANSACTIONTYPE,                        
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.ACCOUNT,
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.PROJECT,
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.AMOUNT,
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.REFERENCE,
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.TRANSACTIONAMOUNT,
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.AMOUNT,
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.ORGANIZATIONAMOUNT,
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.BASECURRENCYID
                    from 
                        dbo.PLANNEDGIFTPAYOUTGLDISTRIBUTION
                    inner join 
                        dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP on PLANNEDGIFTPAYOUTGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID = MAP.ID
                    where 
                        PLANNEDGIFTPAYOUTGLDISTRIBUTION.REVENUEID = @ID
                        and PLANNEDGIFTPAYOUTGLDISTRIBUTION.OUTDATED = 0
                    order by
                        MAP.DESCRIPTION, PLANNEDGIFTPAYOUTGLDISTRIBUTION.TRANSACTIONTYPE desc;