USP_DATAFORMTEMPLATE_ADD_DEPOSITMISCELLANEOUSPAYMENT

The save procedure used by the add dataform template "Deposit Miscellaneous Payment Add 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.
@PAYMENTSOURCE	nvarchar(100)	IN	Reference
@PAYMENTDATE	datetime	IN	Payment date
@AMOUNT	money	IN	Amount
@POSTDATE	datetime	IN	Post date
@POSTSTATUSCODE	tinyint	IN	Post status
@DEPOSITID	uniqueidentifier	IN	Deposit
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@REFERENCENUMBER	nvarchar(20)	IN	Reference number
@REFERENCEDATE	UDT_FUZZYDATE	IN	Reference date
@CHECKDATE	UDT_FUZZYDATE	IN	Check date
@CHECKNUMBER	nvarchar(20)	IN	Check number
@CARDHOLDERNAME	nvarchar(255)	IN	Name on card
@CREDITCARDNUMBER	nvarchar(4)	IN	Card number
@CREDITTYPECODEID	uniqueidentifier	IN	Card type
@AUTHORIZATIONCODE	nvarchar(20)	IN	Authorization code
@EXPIRESON	UDT_FUZZYDATE	IN	Expires on
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN	Other method
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Transaction currency
@BASEEXCHANGERATEID	uniqueidentifier	IN	Exchange rate ID
@EXCHANGERATE	decimal(20, 8)	IN	Exchange rate

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_DEPOSITMISCELLANEOUSPAYMENT
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @PAYMENTSOURCE nvarchar(100) = '',
                        @PAYMENTDATE datetime,
                        @AMOUNT money,
                        @POSTDATE datetime = null,
                        @POSTSTATUSCODE tinyint = 1,
                        @DEPOSITID uniqueidentifier = null,
                        @PAYMENTMETHODCODE tinyint,
                        @REFERENCENUMBER nvarchar(20) = '',
                        @REFERENCEDATE dbo.UDT_FUZZYDATE = '00000000',
                        @CHECKDATE dbo.UDT_FUZZYDATE = '00000000',
                        @CHECKNUMBER nvarchar(20) = '',
                        @CARDHOLDERNAME nvarchar(255) = '',
                        @CREDITCARDNUMBER nvarchar(4) = '',
                        @CREDITTYPECODEID uniqueidentifier = null,
                        @AUTHORIZATIONCODE nvarchar(20) = '',
                        @EXPIRESON dbo.UDT_FUZZYDATE = '00000000',
                        @OTHERPAYMENTMETHODCODEID uniqueidentifier = null,
                        @CONTEXTID uniqueidentifier,
                        @PDACCOUNTSYSTEMID uniqueidentifier = null,
                        @TRANSACTIONCURRENCYID uniqueidentifier = null,
                        @BASEEXCHANGERATEID uniqueidentifier = null,
                        @EXCHANGERATE decimal(20,8) = null  
                    )
                    as

                    set nocount on;

                    if @ID is null
                            set @ID = newid()

                    if @CHANGEAGENTID is null  
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                    exec dbo.USP_DATAFORMTEMPLATE_ADD_MISCELLANEOUSPAYMENT
                        @ID = @ID,
                        @CHANGEAGENTID = @CHANGEAGENTID,
                        @PAYMENTSOURCE = @PAYMENTSOURCE,
                        @PAYMENTDATE = @PAYMENTDATE,
                        @AMOUNT = @AMOUNT,
                        @POSTDATE = @POSTDATE,
                        @POSTSTATUSCODE = @POSTSTATUSCODE,
                        @DEPOSITID = @CONTEXTID,
                        @PAYMENTMETHODCODE = @PAYMENTMETHODCODE,
                        @REFERENCENUMBER = @REFERENCENUMBER,
                        @REFERENCEDATE = @REFERENCEDATE,
                        @CHECKDATE = @CHECKDATE,
                        @CHECKNUMBER = @CHECKNUMBER,
                        @CARDHOLDERNAME = @CARDHOLDERNAME,
                        @CREDITCARDNUMBER = @CREDITCARDNUMBER,
                        @CREDITTYPECODEID = @CREDITTYPECODEID,
                        @AUTHORIZATIONCODE = @AUTHORIZATIONCODE,
                        @EXPIRESON = @EXPIRESON,
                        @OTHERPAYMENTMETHODCODEID = @OTHERPAYMENTMETHODCODEID,
                        @PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
                        ,@TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID
                        ,@BASEEXCHANGERATEID = @BASEEXCHANGERATEID
                        ,@EXCHANGERATE = @EXCHANGERATE

                    return 0