USP_DATAFORMTEMPLATE_PRELOAD_ADD_RECONCILEMATCHINGGIFT

The load procedure used by the edit dataform template "Reconcile Matching Gift Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUESPLITID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent ID
@CONSTITUENTNAME	nvarchar(255)	INOUT	Constituent name
@AMOUNT	money	INOUT	Amount to apply
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT
@PAYMENTDATE	date	INOUT
@BASECURRENCYID	uniqueidentifier	INOUT
@BASEEXCHANGERATEID	uniqueidentifier	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_RECONCILEMATCHINGGIFT
                    (
                        @REVENUESPLITID uniqueidentifier,
                        @CONSTITUENTID uniqueidentifier = null output,
                        @CONSTITUENTNAME nvarchar(255) = null output,
                        @AMOUNT money = null output,
            @TRANSACTIONCURRENCYID uniqueidentifier = null output,
            @PAYMENTDATE date = null output,
            @BASECURRENCYID uniqueidentifier = null output,
            @BASEEXCHANGERATEID uniqueidentifier = null output
                    )
                    as 
                    set nocount on;

                    select    @CONSTITUENTID = CONSTITUENT.ID,
                            @CONSTITUENTNAME = CONSTITUENT.NAME,
                            @AMOUNT = REVENUESPLIT.TRANSACTIONAMOUNT - (select coalesce(sum(dbo.UFN_CURRENCY_CONVERTINVERSE(AMOUNT,APPLICATIONEXCHANGERATEID)), 0) from dbo.INSTALLMENTSPLITPAYMENT where PAYMENTID = @REVENUESPLITID),
              @TRANSACTIONCURRENCYID = REVENUESPLIT.TRANSACTIONCURRENCYID,
              @PAYMENTDATE = REVENUE.DATE,
              @BASECURRENCYID = REVENUESPLIT.BASECURRENCYID,
              @BASEEXCHANGERATEID = REVENUESPLIT.BASEEXCHANGERATEID
                        from dbo.REVENUESPLIT 
                        inner join dbo.REVENUE on REVENUE.ID = REVENUESPLIT.REVENUEID
                        inner join dbo.CONSTITUENT on REVENUE.CONSTITUENTID = CONSTITUENT.ID
                        where
                            REVENUESPLIT.ID = @REVENUESPLITID

                    return 0;