USP_DATAFORMTEMPLATE_ADD_PAYMENTLINK

The save procedure used by the add dataform template "Payment Link Data Form".

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.
@DEPOSITID	uniqueidentifier	IN	Deposit
@PAYMENTS	xml	IN	Linked payments
@BATCHID	uniqueidentifier	IN	Batch number
@ADDEDBY	nvarchar(128)	IN	Added by
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@CARDTYPECODEID	uniqueidentifier	IN	Card type
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@REFERENCE	nvarchar(255)	IN	Reference
@POSTSTATUSCODE	tinyint	IN	Post status
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN	Other method
@APPLICATIONCODE	tinyint	IN	Application type

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PAYMENTLINK
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @DEPOSITID uniqueidentifier = null,
                        @PAYMENTS xml = null,
                        @BATCHID uniqueidentifier = null,
                        @ADDEDBY nvarchar(128) = null,
                        @PAYMENTMETHODCODE tinyint = null,
                        @CARDTYPECODEID uniqueidentifier = null,
                        @STARTDATE datetime = null,
                        @ENDDATE datetime = null,
                        @REFERENCE nvarchar(255) = null,
                        @POSTSTATUSCODE tinyint = null,
                        @OTHERPAYMENTMETHODCODEID uniqueidentifier = null,
                        @APPLICATIONCODE tinyint = null
                    )
                    as

                    set nocount on;

                    exec dbo.USP_LINKPAYMENTSTODEPOSIT @ID, @CHANGEAGENTID, @DEPOSITID, @PAYMENTS
                    set @ID = @DEPOSITID;
                    return 0;