USP_DATAFORMTEMPLATE_ADD_DEPOSITPAYMENTLINK

The save procedure used by the add dataform template "Deposit 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.
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@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_DEPOSITPAYMENTLINK
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @CONTEXTID uniqueidentifier,
                        @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 output, @CHANGEAGENTID, @CONTEXTID, @PAYMENTS

                    return 0