USP_DATAFORMTEMPLATE_ADD_NAMINGOPPORTUNITYREVENUERECOGNITION

The save procedure used by the add dataform template "Naming Opportunity Revenue Recognition Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@REVENUESPLITID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@NAMINGOPPORTUNITYID	uniqueidentifier	IN	Naming opportunity
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@CONSTITUENTNAMEFORMATID	uniqueidentifier	IN	Name format
@CUSTOMNAMEFORMAT	nvarchar(100)	IN	Custom name format
@STARTDATE	UDT_FUZZYDATE	IN	Recognition date
@ENDDATE	UDT_FUZZYDATE	IN	Recognition ends
@AMOUNT	money	IN	Recognition amount
@QUANTITY	int	IN	Quantity
@INSCRIPTION	nvarchar(max)	IN	Inscription
@SPECIALREQUEST	nvarchar(max)	IN	Special request
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_NAMINGOPPORTUNITYREVENUERECOGNITION
                    (
                        @ID uniqueidentifier output,
                        @REVENUESPLITID uniqueidentifier,
                        @NAMINGOPPORTUNITYID uniqueidentifier,
                        @CONSTITUENTID uniqueidentifier,
                        @CONSTITUENTNAMEFORMATID uniqueidentifier = null,
                        @CUSTOMNAMEFORMAT nvarchar(100) = '',
                        @STARTDATE dbo.UDT_FUZZYDATE = '00000000',
                        @ENDDATE dbo.UDT_FUZZYDATE = '00000000',
                        @AMOUNT money,
                        @QUANTITY int,
                        @INSCRIPTION nvarchar(max) = '',
                        @SPECIALREQUEST nvarchar(max) = '',
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as
                    set nocount on;

                    exec dbo.USP_NAMINGOPPORTUNITYREVENUERECOGNITION_ADD
                      @ID = @ID output,
                      @REVENUESPLITID = @REVENUESPLITID,
                      @NAMINGOPPORTUNITYID = @NAMINGOPPORTUNITYID,
                      @CONSTITUENTID = @CONSTITUENTID,
                      @CONSTITUENTNAMEFORMATID = @CONSTITUENTNAMEFORMATID,
                      @CUSTOMNAMEFORMAT = @CUSTOMNAMEFORMAT,
                      @STARTDATE = @STARTDATE,
                      @ENDDATE = @ENDDATE,
                      @AMOUNT = @AMOUNT,
                      @QUANTITY = @QUANTITY,
                      @INSCRIPTION = @INSCRIPTION,
                      @SPECIALREQUEST = @SPECIALREQUEST,
                      @CHANGEAGENTID = @CHANGEAGENTID

                    return 0;