USP_DATAFORMTEMPLATE_PRELOAD_ADD_PAYMENTBYTRANSACTIONPOSTED

The load procedure used by the edit dataform template "Payment Add by Transaction Posted Form"

Parameters

Parameter	Parameter Type	Mode	Description
@TRANSACTIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTID	uniqueidentifier	INOUT
@PAYMENTMETHODCODE	tinyint	INOUT	Payment method
@REVENUESTREAMS	xml	INOUT	Revenue streams
@SINGLEDESIGNATIONID	uniqueidentifier	INOUT	Designation
@TRANSACTIONAMOUNT	money	INOUT	Transaction amount
@ALLOWGIFT	bit	INOUT	Allow gift

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PAYMENTBYTRANSACTIONPOSTED
                (                                        
                    @TRANSACTIONID uniqueidentifier,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @PAYMENTMETHODCODE tinyint = null output,
                    @REVENUESTREAMS xml = null output,
                    @SINGLEDESIGNATIONID uniqueidentifier = null output,
                    @TRANSACTIONAMOUNT money = null output,
                    @ALLOWGIFT bit = null output
                )
                as
                set nocount on;

                set @ALLOWGIFT = 1;

                select @CONSTITUENTID = CONSTITUENTID,
                        @PAYMENTMETHODCODE = REVENUEPAYMENTMETHOD.PAYMENTMETHODCODE,
                        @TRANSACTIONAMOUNT = sum(REVENUE.AMOUNT)
                from dbo.REVENUE 
                inner join dbo.REVENUEPAYMENTMETHOD on REVENUE.ID = REVENUEPAYMENTMETHOD.REVENUEID
                where REVENUE.ID = @TRANSACTIONID
                group by CONSTITUENTID, REVENUEPAYMENTMETHOD.PAYMENTMETHODCODE;

                set @ALLOWGIFT = 1;

                set @REVENUESTREAMS = dbo.UFN_CONSTITUENT_GETREVENUESTREAMS_TOITEMLISTXML(@CONSTITUENTID);

                return 0;