UFN_REVENUE_GETBENEFITS

Returns all benefits for a given revenue record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUE_GETBENEFITS(@REVENUEID uniqueidentifier)
            returns table
            as
            return
            (
                select 
                    [LI].[ID], 
                    RBEX.[BENEFITID], 
                    isnull(cast(LI.QUANTITY as Int), 0) as [QUANTITY], 
                    [LI].[UNITVALUE], 
                    QUANTITY * UNITVALUE as [TOTALVALUE],
                    isnull(Left(LI.DESCRIPTION,255),'') as [DETAILS], 
                    LI.[SEQUENCE] 
                from dbo.FINANCIALTRANSACTIONLINEITEM as [LI]
        inner join dbo.REVENUEBENEFIT_EXT RBEX on RBEX.ID = LI.ID
                where LI.ID = @REVENUEID
            )