USP_DATAFORMTEMPLATE_EDIT_MISCELLANEOUSPAYMENT

Backward compatible Miscellaneous payment edit sproc.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@PAYMENTDATE	datetime	IN	Payment date
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN	Other method
@CHECKDATE	UDT_FUZZYDATE	IN	Check date
@CHECKNUMBER	nvarchar(20)	IN	Check number
@REFERENCEDATE	UDT_FUZZYDATE	IN	Reference date
@REFERENCENUMBER	nvarchar(20)	IN	Reference 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
@AMOUNT	money	IN	Amount
@POSTDATE	datetime	IN	Post date
@POSTSTATUSCODE	tinyint	IN	Post status
@DEPOSITID	uniqueidentifier	IN	Deposit

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MISCELLANEOUSPAYMENT(
                        @ID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @PAYMENTDATE datetime,
                        @PAYMENTMETHODCODE tinyint,
                        @OTHERPAYMENTMETHODCODEID uniqueidentifier,
                        @CHECKDATE dbo.UDT_FUZZYDATE,
                        @CHECKNUMBER nvarchar(20),
                        @REFERENCEDATE dbo.UDT_FUZZYDATE,
                        @REFERENCENUMBER nvarchar(20),
                        @CARDHOLDERNAME nvarchar(255),
                        @CREDITCARDNUMBER nvarchar(4),
                        @CREDITTYPECODEID uniqueidentifier,
                        @AUTHORIZATIONCODE nvarchar(20),
                        @EXPIRESON dbo.UDT_FUZZYDATE,
                        @AMOUNT money,
                        @POSTDATE datetime,
                        @POSTSTATUSCODE tinyint,
                        @DEPOSITID uniqueidentifier
                    )
                    as
      begin
                    set nocount on;    
          -- do work


            declare @BASEEXCHANGERATEID uniqueidentifier;
              declare @EXCHANGERATE decimal(20,8);

          exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MISCELLANEOUSPAYMENT
                    @ID = @ID,
                                @BASEEXCHANGERATEID=@BASEEXCHANGERATEID output,
                                @EXCHANGERATE=@EXCHANGERATE output;


                    exec dbo.USP_DATAFORMTEMPLATE_EDIT_MISCELLANEOUSPAYMENT_2
                            @ID = @ID,
                            @CURRENTAPPUSERID = @CURRENTAPPUSERID,
                            @CHANGEAGENTID = @CHANGEAGENTID,
                            @PAYMENTDATE = @PAYMENTDATE,
                            @PAYMENTMETHODCODE = @PAYMENTMETHODCODE,
                            @OTHERPAYMENTMETHODCODEID = @OTHERPAYMENTMETHODCODEID,
                            @CHECKDATE = @CHECKDATE,
                            @CHECKNUMBER = @CHECKNUMBER,
                            @REFERENCEDATE = @REFERENCEDATE,
                            @REFERENCENUMBER = @REFERENCENUMBER,
                            @CARDHOLDERNAME = @CARDHOLDERNAME,
                            @CREDITCARDNUMBER = @CREDITCARDNUMBER,
                            @CREDITTYPECODEID = @CREDITTYPECODEID,
                            @AUTHORIZATIONCODE = @AUTHORIZATIONCODE,
                            @EXPIRESON = @EXPIRESON,
                            @AMOUNT = @AMOUNT,
                            @POSTDATE = @POSTDATE,
                            @POSTSTATUSCODE = @POSTSTATUSCODE,
                            @DEPOSITID = @DEPOSITID,
                        @BASEEXCHANGERATEID=@BASEEXCHANGERATEID,
                        @EXCHANGERATE=@EXCHANGERATE;


      end