UFN_REVENUEBATCH_GETRECOGNITIONS

Returns all recognition credits for a given revenue detail record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUEBATCH_GETRECOGNITIONS
            (
                @BATCHREVENUEID uniqueidentifier
            )
            returns table
            AS            
            return 
            (
                select 
                    BATCHREVENUERECOGNITION.[ID],
                    [CONSTITUENTID],
                    [AMOUNT],
                    [EFFECTIVEDATE],
                    [REVENUERECOGNITIONTYPECODEID],
                    REVENUERECOGNITIONTYPECODE.DESCRIPTION as RECOGNITIONTYPE,
                    BATCHREVENUERECOGNITION.REVENUERECOGNITIONID
                from dbo.BATCHREVENUERECOGNITION
                left join dbo.REVENUERECOGNITIONTYPECODE on BATCHREVENUERECOGNITION.REVENUERECOGNITIONTYPECODEID = REVENUERECOGNITIONTYPECODE.ID
                where BATCHREVENUEID = @BATCHREVENUEID
            )