UFN_PDACCOUNT_GETMEMBERSHIPLEVEL_2

Returns Membership Level ID for transaction being generated.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@REVENUESPLITID	uniqueidentifier	IN
@INFORMATIONSOURCECODE	tinyint	IN
@REVENUETRANSACTIONTYPECODE	tinyint	IN
@REVENUESPLITTYPECODE	tinyint	IN
@APPLICATIONCODE	tinyint	IN
@PAYMENTMETHODCODE	tinyint	IN
@DESIGNATIONID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_PDACCOUNT_GETMEMBERSHIPLEVEL_2
            (
                @REVENUEID uniqueidentifier, 
                @REVENUESPLITID uniqueidentifier, 
                @INFORMATIONSOURCECODE tinyint, -- 0 revenue tables, 1 revenue batch tables

                @REVENUETRANSACTIONTYPECODE tinyint, 
                @REVENUESPLITTYPECODE tinyint, 
                @APPLICATIONCODE tinyint, 
                @PAYMENTMETHODCODE tinyint, 
                @DESIGNATIONID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier = null
            ) returns uniqueidentifier
            As 
            begin
                return dbo.UFN_PDACCOUNT_GETMEMBERSHIPLEVEL_3(dbo.UFN_REVENUESPLITINFORMATION(@REVENUEID, @REVENUESPLITID, @INFORMATIONSOURCECODE, @CURRENTAPPUSERID));
            end