UFN_POSTTOGLPROCESS_MAPPLEDGEPAYMENTS

Returns the mappings for pledge payments based on the post status of the pledge.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
@POSTSTATUSCODE	tinyint	IN

Definition

Copy



CREATE function dbo.UFN_POSTTOGLPROCESS_MAPPLEDGEPAYMENTS(@ID as uniqueidentifier, @POSTSTATUSCODE as tinyint)
returns table
as
return
    select
        ID,
        SPLITTYPECODE,
        TYPE,
        REVENUETRANSACTIONTYPECODE,
        APPLICATIONCODE
    --This version of the function was used only for pledges. Passing the hardcoded pledge values from this function to _2.

    from dbo.UFN_POSTTOGLPROCESS_MAPPLEDGEPAYMENTS_2 (
        @ID,
        @POSTSTATUSCODE,
        dbo.UFN_VALID_BASICGL_INSTALLED(),
        1, --@PLEDGETRANSACTIONTYPECODE: Pledge

        2, --@SPLITAPPLICATIONTYPECODE: Pledge

        '', --@SPLITAPPLICATION. This application string still not be used for Pledge

        0 --@SPLITTYPECODE: Gift

    )