UFN_REVENUESPLIT_GETPRORATEDAMOUNT

Returns the prorate amount for a split.

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@REVENUESPLITID	uniqueidentifier	IN
@NEWAMOUNT	money	IN

Definition

Copy



            create function dbo.UFN_REVENUESPLIT_GETPRORATEDAMOUNT
            (
                @REVENUEID uniqueidentifier,
                @REVENUESPLITID uniqueidentifier,
                @NEWAMOUNT money
            )
            returns money
            as
            begin
                declare @PRORATEDAMOUNT money
                select @PRORATEDAMOUNT = AMOUNT
                from dbo.UFN_REVENUE_GETPRORATEDSPLITS(@REVENUEID, @NEWAMOUNT)
                where SOURCEREVENUESPLITID = @REVENUESPLITID

                return @PRORATEDAMOUNT
            end