USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIP_PAYMENT

The load procedure used by the edit dataform template "Sponsorship Payment Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@CONSTITUENTID	uniqueidentifier	INOUT	Sponsor
@CONSTITUENTNAME	nvarchar(255)	INOUT	Sponsor
@REVENUEID	uniqueidentifier	INOUT
@STARTDATE	datetime	INOUT	Next transaction date
@ENDDATE	datetime	INOUT	Ending on
@AMOUNT	money	INOUT	Amount
@REFERENCE	nvarchar(20)	INOUT	Reference
@SPLITS	xml	INOUT	Designations
@FREQUENCYCODE	tinyint	INOUT	Frequency
@SENDREMINDER	bit	INOUT	Send reminders
@NEXTINSTALLMENTID	uniqueidentifier	INOUT
@LASTACTIVITYDATE	date	INOUT
@EDITSTARTDATE	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIP_PAYMENT(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @CONSTITUENTID uniqueidentifier = null output,
    @CONSTITUENTNAME nvarchar(255) = null output,
    @REVENUEID uniqueidentifier = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output,
    @AMOUNT money = null output,
    @REFERENCE nvarchar(20) = null output,
    @SPLITS xml = null output,
    @FREQUENCYCODE tinyint = null output,
    @SENDREMINDER bit = null output,
    @NEXTINSTALLMENTID uniqueidentifier = null output,
    @LASTACTIVITYDATE date = null output,
    @EDITSTARTDATE bit = null output
)
as
    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFT_2
        @ID = @ID,
        @DATALOADED = @DATALOADED output,
        @TSLONG = @TSLONG output,
        @CONSTITUENTID = @CONSTITUENTID output,
        @CONSTITUENTNAME = @CONSTITUENTNAME output,
        @REVENUEID = @REVENUEID output,
        @STARTDATE = @STARTDATE output,
        @ENDDATE = @ENDDATE output,
        @AMOUNT = @AMOUNT output,
        @REFERENCE = @REFERENCE output,
        @SPLITS = @SPLITS output,
        @FREQUENCYCODE = @FREQUENCYCODE output,
        @SENDREMINDER = @SENDREMINDER output,
        @NEXTINSTALLMENTID = @NEXTINSTALLMENTID output,
        @LASTACTIVITYDATE = @LASTACTIVITYDATE output,
        @EDITSTARTDATE = @EDITSTARTDATE output

    return 0;