UFN_PDACCOUNT_GETMERCHANDISEDEPARTMENT_3

            create function dbo.UFN_PDACCOUNT_GETMERCHANDISEDEPARTMENT_3
            (
                @REVENUESPLITINFORMATION xml
            )
            returns uniqueidentifier
            as begin
                declare @MERCHANDISEDEPARTMENTID uniqueidentifier;

                select @MERCHANDISEDEPARTMENTID = MERCHANDISEPRODUCT.MERCHANDISEDEPARTMENTID
                from dbo.UFN_REVENUESPLITINFORMATION_FROMITEMLISTXML(@REVENUESPLITINFORMATION) as REVENUESPLITINFORMATION
                    inner join dbo.MERCHANDISEPRODUCTINSTANCE 
                        on MERCHANDISEPRODUCTINSTANCE.ID = REVENUESPLITINFORMATION.ORDERMERCHANDISEPRODUCTINSTANCEID
                inner join dbo.MERCHANDISEPRODUCT 
                    on MERCHANDISEPRODUCT.ID = MERCHANDISEPRODUCTINSTANCE.MERCHANDISEPRODUCTID;

                return @MERCHANDISEDEPARTMENTID;
            end