USP_DATAFORMTEMPLATE_ADD_PLEDGEWRITEOFF2

The save procedure used by the add dataform template "Pledge Write-off Add Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@REVENUEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@DATE	datetime	IN	Date
@WRITEOFFTOTALAMOUNT	money	IN	Amount
@POSTSTATUSCODE	tinyint	IN	GL post status
@POSTDATE	datetime	IN	GL post date
@REASON	nvarchar(300)	IN	Details
@INSTALLMENTS	xml	IN
@REASONCODEID	uniqueidentifier	IN	Reason code
@RECOGNITIONCREDITS	xml	IN	Recognition credits

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PLEDGEWRITEOFF2
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier,
                        @REVENUEID uniqueidentifier,
                        @DATE datetime,
                        @WRITEOFFTOTALAMOUNT money = 0,
                        @POSTSTATUSCODE tinyint = 1,
                        @POSTDATE datetime = null,
                        @REASON nvarchar(300) = null,
                        @INSTALLMENTS xml,
                        @REASONCODEID uniqueidentifier = null,
                        @RECOGNITIONCREDITS xml = null
                        )
                    as
                    begin

                        set nocount on;

                        exec USP_DATAFORMTEMPLATE_ADD_PLEDGEWRITEOFF_3
                            @ID = @ID output,
                            @CHANGEAGENTID = @CHANGEAGENTID,
                            @REVENUEID = @REVENUEID,
                            @DATE = @DATE,
                            @WRITEOFFTOTALAMOUNT = @WRITEOFFTOTALAMOUNT,
                            @POSTSTATUSCODE = @POSTSTATUSCODE,
                            @POSTDATE = @POSTDATE,
                            @REASON = @REASON,
                            @INSTALLMENTS = @INSTALLMENTS,
                            @REASONCODEID = @REASONCODEID,
                            @RECOGNITIONCREDITS = @RECOGNITIONCREDITS,
                            @BATCHID = null;

                        return 0;
                    end