UFN_REVENUE_GETBENEFITS_3

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_3(@REVENUEID uniqueidentifier)
            returns table
            as
            return
            (
                select 
                    REVENUEBENEFIT.[ID], 
                    REVENUEBENEFIT.[BENEFITID], 
                    REVENUEBENEFIT.[QUANTITY], 
                    REVENUEBENEFIT.[UNITVALUE], 
                    REVENUEBENEFIT.[TOTALVALUE],
                    REVENUEBENEFIT.[DETAILS], 
                    REVENUEBENEFIT.[SEQUENCE],
                    REVENUEBENEFIT.[PERCENTAPPLICABLEAMOUNT],
                    REVENUEBENEFIT.[VALUEPERCENT],
                    [BENEFIT].[USEPERCENT],
                    REVENUEBENEFIT.[BASECURRENCYID],
                    REVENUEBENEFIT.[TRANSACTIONCURRENCYID],
                    REVENUEBENEFIT.[BASEEXCHANGERATEID],
                    REVENUEBENEFIT.[ORGANIZATIONEXCHANGERATEID],
                    REVENUEBENEFIT.[TRANSACTIONTOTALVALUE],
                    REVENUEBENEFIT.[ORGANIZATIONTOTALVALUE],
                    REVENUEBENEFIT.[REVENUESPLITID]
                from 
                    dbo.REVENUEBENEFIT
                    inner join dbo.BENEFIT on REVENUEBENEFIT.BENEFITID = BENEFIT.ID
                where 
                    REVENUEID = @REVENUEID
            )