USP_DATAFORMTEMPLATE_EDIT_RECEIPTINGPROCESS_4

Backwards compatibility procedure for USP_DATAFORMTEMPLATE_EDIT_RECEIPTINGPROCESS_5

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@DESCRIPTION	nvarchar(255)	IN	Description
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	IN	Selection type
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@MARKRECEIPTED	bit	IN	Mark revenue 'Receipted' when process completes
@BUSINESSPROCESSVIEWID	uniqueidentifier	IN	Output format
@LETTERFILE	varbinary	IN	File
@LETTERFILENAME	nvarchar(255)	IN	Word template
@DISPLAYEDLETTERFILENAME	nvarchar(255)	IN	File
@LETTERFILECHANGED	bit	IN	Letter file changed?
@LABELFILE	varbinary	IN	Label File
@LABELFILENAME	nvarchar(255)	IN	Label File
@DISPLAYEDLABELFILENAME	nvarchar(255)	IN	Label file
@LABELFILECHANGED	bit	IN	Label File changed?
@RECEIPTDATETYPECODE	tinyint	IN	Receipt date
@RECEIPTDATE	datetime	IN	Receipt date
@EXCLUSIONDATETYPECODE	tinyint	IN	Consider exclusions as of
@EXCLUSIONASOFDATE	datetime	IN	Consider exclusions as of
@EXCLUDEDECEASED	bit	IN	Exclude deceased constituents
@EXCLUDEINACTIVE	bit	IN	Exclude inactive constituents
@EXCLUSIONS	xml	IN	Exclusions
@CUSTOMPARAMETERDATAFORMITEM	xml	IN
@RECEIPTTYPECODE	tinyint	IN	Receipt type
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@EXPORTDEFINITIONID	uniqueidentifier	IN	Export definition
@RECEIPTSTACKID	uniqueidentifier	IN	Receipt Stack
@RERECEIPTSAMENUMBER	bit	IN	Include re-receipt payments that use the same receipt number
@RERECEIPTNEWNUMBER	bit	IN	Include re-receipt payments that receive a new receipt number
@DUPLICATENUMBERACTIONCODE	tinyint	IN	If new receipt ID is a duplicate
@STARTINGNUMBERCREATESGAPACTIONCODE	tinyint	IN	If new receipt ID leaves a gap

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RECEIPTINGPROCESS_4
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,                
                @NAME nvarchar(100), 
                @IDSETREGISTERID uniqueidentifier,
                @DESCRIPTION nvarchar(255), 
                @CREATEOUTPUTIDSET bit,
                @OUTPUTIDSETRECORDTYPEID uniqueidentifier,
                @OUTPUTIDSETNAME nvarchar(100), 
                @OVERWRITEOUTPUTIDSET bit,
                @MARKRECEIPTED bit,        
                @BUSINESSPROCESSVIEWID uniqueidentifier,
                @LETTERFILE varbinary(max),
                @LETTERFILENAME nvarchar(255),
                @DISPLAYEDLETTERFILENAME nvarchar(255),
                @LETTERFILECHANGED bit,
                @LABELFILE varbinary(max),
                @LABELFILENAME nvarchar(255),
                @DISPLAYEDLABELFILENAME nvarchar(255),
                @LABELFILECHANGED bit,
                @RECEIPTDATETYPECODE tinyint,
                @RECEIPTDATE datetime,
                @EXCLUSIONDATETYPECODE tinyint,
                @EXCLUSIONASOFDATE datetime,
                @EXCLUDEDECEASED bit,
                @EXCLUDEINACTIVE bit,
                @EXCLUSIONS xml,
                @CUSTOMPARAMETERDATAFORMITEM xml,
                @RECEIPTTYPECODE tinyint,
                @CURRENTAPPUSERID uniqueidentifier = null,
                @EXPORTDEFINITIONID uniqueidentifier,
                @RECEIPTSTACKID uniqueidentifier,
                @RERECEIPTSAMENUMBER bit,
                @RERECEIPTNEWNUMBER bit,
                @DUPLICATENUMBERACTIONCODE tinyint,
                @STARTINGNUMBERCREATESGAPACTIONCODE tinyint
            )
            as
            set nocount on;

            declare @SITEID uniqueidentifier = null;

            begin try
                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECEIPTINGPROCESS_2 @ID = @ID, @SITEID = @SITEID output;

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_RECEIPTINGPROCESS_5
                    @ID, @CHANGEAGENTID, @NAME, @IDSETREGISTERID, @DESCRIPTION, @CREATEOUTPUTIDSET, @OUTPUTIDSETRECORDTYPEID,
                    @OUTPUTIDSETNAME, @OVERWRITEOUTPUTIDSET, @MARKRECEIPTED, @BUSINESSPROCESSVIEWID, @LETTERFILE, @LETTERFILENAME,
                    @DISPLAYEDLETTERFILENAME, @LETTERFILECHANGED, @LABELFILE, @LABELFILENAME, @DISPLAYEDLABELFILENAME, 
                    @LABELFILECHANGED, @RECEIPTDATETYPECODE, @RECEIPTDATE, @EXCLUSIONDATETYPECODE, @EXCLUSIONASOFDATE,
                    @EXCLUDEDECEASED, @EXCLUDEINACTIVE, @EXCLUSIONS, @CUSTOMPARAMETERDATAFORMITEM, @RECEIPTTYPECODE,
                    @CURRENTAPPUSERID, @EXPORTDEFINITIONID, @RECEIPTSTACKID, @RERECEIPTSAMENUMBER, @RERECEIPTNEWNUMBER,
                    @DUPLICATENUMBERACTIONCODE, @STARTINGNUMBERCREATESGAPACTIONCODE,
                    @SITEID;
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;