USP_DATALIST_GIFTFEEGLDISTRIBUTION

Returns a list of gift fee GL distributions for a revenue transaction.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_GIFTFEEGLDISTRIBUTION
                (
                    @REVENUEID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        GIFTFEEGLDISTRIBUTION.REVENUESPLITGIFTFEEID,
                        GIFTFEEGLDISTRIBUTION.ID as GIFTFEEGLDISTRIBUTIONID,
                        MAP.DESCRIPTION,
                        GIFTFEEGLDISTRIBUTION.TRANSACTIONTYPE,                        
                        GIFTFEEGLDISTRIBUTION.ACCOUNT,
                        GIFTFEEGLDISTRIBUTION.AMOUNT,
                        GIFTFEEGLDISTRIBUTION.TRANSACTIONAMOUNT,
                        GIFTFEEGLDISTRIBUTION.AMOUNT as BASEAMOUNT,
                        GIFTFEEGLDISTRIBUTION.ORGANIZATIONAMOUNT,
                        GIFTFEEGLDISTRIBUTION.REFERENCE,
                        GIFTFEEGLDISTRIBUTION.TRANSACTIONCURRENCYID,
                        GIFTFEEGLDISTRIBUTION.BASECURRENCYID
                    from 
                        dbo.GIFTFEEGLDISTRIBUTION
                        inner join dbo.GLPAYMENTMETHODREVENUETYPEMAPPING as MAP on GIFTFEEGLDISTRIBUTION.GLPAYMENTMETHODREVENUETYPEMAPPINGID = MAP.ID
                    where 
                        GIFTFEEGLDISTRIBUTION.REVENUEID = @REVENUEID and 
                        GIFTFEEGLDISTRIBUTION.OUTDATED = 0
                    order by 
                        MAP.DESCRIPTION, 
                        GIFTFEEGLDISTRIBUTION.TRANSACTIONTYPE desc;