USP_DATAFORMTEMPLATE_ADD_RECURRINGGIFTWRITEOFF_PRELOAD

The load procedure used by the edit dataform template "Recurring Gift Write-off Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PASTDUE	money	INOUT	Past due
@INSTALLMENTS	xml	INOUT
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RECURRINGGIFTWRITEOFF_PRELOAD
(
    @REVENUEID uniqueidentifier,
    @PASTDUE money = null output,
    @INSTALLMENTS xml = null output,
    @TRANSACTIONCURRENCYID uniqueidentifier = null output
)
as
    set nocount on;

    declare @CURRENTDATE date = getdate();

    set @PASTDUE = dbo.UFN_RECURRINGGIFT_GETPASTDUEAMOUNT_2(@REVENUEID,@CURRENTDATE,0)

    set @INSTALLMENTS =
        (
            select 
                ID, 
                DATE,
                STATUSCODE STATUS,
                TRANSACTIONAMOUNT as AMOUNT,
                BALANCE,
                WRITEOFFAMOUNT,
                TRANSACTIONCURRENCYID
            from
                dbo.UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS_2(@REVENUEID) WRITEOFFINSTALLMENT
            where DATE <= @CURRENTDATE                
            order by
                WRITEOFFINSTALLMENT.DATE,
                WRITEOFFINSTALLMENT.ID
            for xml raw('ITEM'),type,elements,root('INSTALLMENTS'),BINARY BASE64
        );

    select
        @TRANSACTIONCURRENCYID = REVENUE.TRANSACTIONCURRENCYID
    from
        dbo.REVENUE
    where
        REVENUE.ID = @REVENUEID;

    return 0;