UFN_POSTTOGLPROCESS_MAPPLEDGEPAYMENTS_2

CREATE function dbo.UFN_POSTTOGLPROCESS_MAPPLEDGEPAYMENTS_2 (
    @PLEDGEID as uniqueidentifier, 
    @PLEDGEPOSTSTATUSCODE as tinyint,
    @BASICGLISINSTALLED bit,
    @PLEDGETRANSACTIONTYPECODE tinyint,
    @SPLITAPPLICATIONTYPECODE tinyint,
    @SPLITAPPLICATION nvarchar(100),
    @SPLITTYPECODE tinyint
)
returns table
as
return
    select 
        @PLEDGEID as ID,
        201 as SPLITTYPECODE,
        'Pledge Payment for non-bookable pledges' as TYPE,
        201 as REVENUETRANSACTIONTYPECODE,
        201 as APPLICATIONCODE
    where @PLEDGETRANSACTIONTYPECODE = 1 and @PLEDGEPOSTSTATUSCODE = 2 and @BASICGLISINSTALLED = 1 --Non-Bookable Pledge


    union all

    select 
        @PLEDGEID as ID,
        0 as SPLITTYPECODE,
        'Pledge Payment for bookable pledges' as TYPE,
        0 as REVENUETRANSACTIONTYPECODE,
        2 as APPLICATIONCODE
    where @PLEDGETRANSACTIONTYPECODE = 1 and @PLEDGEPOSTSTATUSCODE <> 2 and @BASICGLISINSTALLED = 1 --Bookable Pledge


    union all

    select 
        @PLEDGEID as ID,
        @SPLITTYPECODE as SPLITTYPECODE,
        @SPLITAPPLICATION as TYPE,
        0 as REVENUETRANSACTIONTYPECODE,
        case when @SPLITAPPLICATIONTYPECODE = 19 then 203 end as APPLICATIONCODE --Membership Installment Plan application to Bookable form. Nulling other types since they are not expected values.

    where @PLEDGETRANSACTIONTYPECODE = 15 and @PLEDGEPOSTSTATUSCODE in (0, 1) --Bookable Membership Installment Plan


    union all

    select 
        @PLEDGEID as ID,
        @SPLITTYPECODE as SPLITTYPECODE,
        @SPLITAPPLICATION as TYPE,
        0 as REVENUETRANSACTIONTYPECODE,
        @SPLITAPPLICATIONTYPECODE as APPLICATIONCODE
    where @PLEDGETRANSACTIONTYPECODE = 15 and @PLEDGEPOSTSTATUSCODE = 2 --Non-Bookable Membership Installment Plan