UFN_PDACCOUNT_GETMERCHANDISEDEPARTMENT_2

Returns the merchandise department of the merchandise product instance on a given revenue split.

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_GETMERCHANDISEDEPARTMENT_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_GETMERCHANDISEDEPARTMENT_3(dbo.UFN_REVENUESPLITINFORMATION(@REVENUEID, @REVENUESPLITID, @INFORMATIONSOURCECODE, @CURRENTAPPUSERID));
            end