UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER

Returns the recognition credits for a revenue split that is in the given row number based on sorting by recognition amount (descending).

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUESPLITID	uniqueidentifier	IN
@ROWNUMBER	int	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUESPLIT_GETRECOGNITIONCREDITBYROWNUMBER
            (
                @REVENUESPLITID uniqueidentifier,
                @ROWNUMBER int
            )
            returns table
            as
            return
            (
                select
                    RECIPIENT,
                    AMOUNT,
                    TYPE,
                    EFFECTIVEDATE
                from
                (
                    select
                        row_number() over (order by REVENUERECOGNITION.EFFECTIVEDATE, CONSTITUENT.NAME) as ROWNUMBER,
                        CONSTITUENT.NAME as RECIPIENT,
                        REVENUERECOGNITION.AMOUNT,
                        REVENUERECOGNITIONTYPECODE.DESCRIPTION as TYPE,
                        REVENUERECOGNITION.EFFECTIVEDATE
                    from dbo.REVENUERECOGNITION
                    inner join dbo.CONSTITUENT on REVENUERECOGNITION.CONSTITUENTID = CONSTITUENT.ID
                    left join dbo.REVENUERECOGNITIONTYPECODE on REVENUERECOGNITION.REVENUERECOGNITIONTYPECODEID = REVENUERECOGNITIONTYPECODE.ID
                    where REVENUERECOGNITION.REVENUESPLITID = @REVENUESPLITID
                ) as SUBQ
                where
                    ROWNUMBER = @ROWNUMBER
            )