UFN_SALESORDER_GETAVAILABLEMANUALDISCOUNTSMEMBERSHIPPROMOS

CREATE function dbo.UFN_SALESORDER_GETAVAILABLEMANUALDISCOUNTSMEMBERSHIPPROMOS
(
    @SALESORDERID uniqueidentifier
)
returns table
as return
    select
        '0-' + cast(ID as nvarchar(36)) as ID,
        NAME,
        DISCOUNTTYPECODE,
        CALCULATIONTYPECODE,
        APPLIESTO,                    
        VALUE,
        NUMBERTOPURCHASE,
        NUMBERTODISCOUNT,
        DESCRIPTION,
        APPLIESTOCODE,
        MINVALUE,
        MAXVALUE
    from dbo.UFN_SALESORDER_GETAVAILABLEMANUALDISCOUNTS(@SALESORDERID)

    union all

    select 
        '1-' + cast(ID as nvarchar(36)) as VALUE, 
        NAME,
        PROMOTIONTYPECODE as DISCOUNTTYPECODE,
        DISCOUNTCALCULATIONTYPECODE as CALCULATIONTYPECODE,
        EXTENSIONCALCULATIONTYPE as APPLIESTO,
        case PROMOTIONTYPECODE
            when 1 then EXTENSIONVALUE
            else case DISCOUNTCALCULATIONTYPECODE
                    when 0 then AMOUNT
                    else [PERCENT]
                 end
        end as VALUE,
        0 as NUMBERTOPURCHASE,
        0 as NUMBERTODISCOUNT,
        DESCRIPTION,
        -1 as APPLIESTOCODE,
        0 as MINVALUE,
        0 as MAXVALUE
    from dbo.MEMBERSHIPPROMO
    where 
        ISACTIVE = 1 and
        APPLICATIONTYPECODE = 0