UFN_REVENUESPLITBUSINESSUNIT_GETBUSINESSUNITS

Returns business units for an revenue split.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUESPLITID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_REVENUESPLITBUSINESSUNIT_GETBUSINESSUNITS(@REVENUESPLITID uniqueidentifier)
returns table
as return
            select
                ID,
        BUSINESSUNITCODEID,
        AMOUNT
            from
                dbo.REVENUESPLITBUSINESSUNIT
            where
                REVENUESPLITID = @REVENUESPLITID;