USP_DATALIST_MEMBERSHIPREVENUECATEGORY

            CREATE procedure dbo.USP_DATALIST_MEMBERSHIPREVENUECATEGORY
            (
                @MEMBERSHIPID uniqueidentifier
            )
            as
                set nocount on;

                -- Get default revenue category for a membership

                select top 1
                    RC.GLREVENUECATEGORYMAPPINGID
                from dbo.REVENUECATEGORY RC
                inner join dbo.MEMBERSHIPTRANSACTION MT on MT.REVENUESPLITID = RC.ID
                where MT.MEMBERSHIPID = @MEMBERSHIPID
                order by MT.TRANSACTIONDATE desc