UFN_SALESORDER_GETMERCHANDISETOTAL

CREATE function dbo.UFN_SALESORDER_GETMERCHANDISETOTAL
        (
            @SALESORDERID uniqueidentifier
        )
        returns money
        as begin
            declare @MERCHANDISETOTAL money            

            select 
                @MERCHANDISETOTAL = coalesce(
                    (
                        select
                            sum(coalesce([SALESORDERITEM].[TOTAL], 0)) - coalesce(sum([SALESORDERITEMITEMDISCOUNT].[AMOUNT]),0.0)
                        from dbo.[SALESORDERITEM]
                        left join dbo.[SALESORDERITEMITEMDISCOUNT]
                            on [SALESORDERITEMITEMDISCOUNT].[SALESORDERITEMID] = [SALESORDERITEM].[ID]
                        where
                            [SALESORDERITEM].[SALESORDERID] = @SALESORDERID and
                            [SALESORDERITEM].[TYPECODE] = 14
                    ), 0)

      -- Add merchandise fees when implemented

            -- Subtract merchandise discounts when implemented


            return @MERCHANDISETOTAL;
        end