USP_DATAFORMTEMPLATE_EDIT_PAYMENTADJUST3

Procedure to adjust a posted payment (for backwards compatibility).

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DATE	datetime	IN	Date
@AMOUNT	money	IN	Amount
@RECEIPTAMOUNT	money	IN	Receipt amount
@REVENUESTREAMS	xml	IN	Revenue streams
@SOURCECODE	nvarchar(50)	IN	Source code
@APPEALID	uniqueidentifier	IN	Appeal
@BENEFITS	xml	IN	Benefits
@BENEFITSWAIVED	bit	IN	Benefits waived
@GIVENANONYMOUSLY	bit	IN	Payment is anonymous
@MAILINGID	uniqueidentifier	IN	Mailing
@CHANNELCODEID	uniqueidentifier	IN	Channel
@DONOTRECEIPT	bit	IN	Do not receipt
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@REFERENCE	nvarchar(255)	IN	Reference
@ADJUSTMENTDATE	datetime	IN	Adjustment date
@ADJUSTMENTPOSTDATE	datetime	IN	Adjustment post date
@ADJUSTMENTREASON	nvarchar(300)	IN	Adjustment details
@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
@ISSUER	nvarchar(100)	IN	Issuer
@NUMBEROFUNITS	decimal(20, 3)	IN	Number of units
@SYMBOL	nvarchar(25)	IN	Symbol
@MEDIANPRICE	decimal(19, 4)	IN	Median price
@GIFTINKINDSUBTYPECODEID	uniqueidentifier	IN	Subtype
@PROPERTYSUBTYPECODEID	uniqueidentifier	IN	Subtype
@CONSTITUENTACCOUNTID	uniqueidentifier	IN	Account
@DIRECTDEBITRESULTCODE	nvarchar(10)	IN	Result code
@LOWPRICE	decimal(19, 4)	IN	Low price
@HIGHPRICE	decimal(19, 4)	IN	High price
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason
@ADJUSTMENTPOSTSTATUSCODE	tinyint	IN

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PAYMENTADJUST3
                        (
                            @ID uniqueidentifier,
                            @CHANGEAGENTID uniqueidentifier = null,
                            @DATE datetime,
                            @AMOUNT money,
                            @RECEIPTAMOUNT money ,
                            @REVENUESTREAMS xml ,
                            @SOURCECODE nvarchar(50),
                            @APPEALID uniqueidentifier,
                            @BENEFITS xml,
                            @BENEFITSWAIVED bit,
                            @GIVENANONYMOUSLY bit,
                            @MAILINGID uniqueidentifier,
                            @CHANNELCODEID uniqueidentifier,
                            @DONOTRECEIPT bit,
                            @DONOTACKNOWLEDGE bit,
                            @REFERENCE nvarchar(255),
                            @ADJUSTMENTDATE datetime,
                            @ADJUSTMENTPOSTDATE datetime,
                            @ADJUSTMENTREASON nvarchar(300),
                            @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,
                            @ISSUER nvarchar(100),
                            @NUMBEROFUNITS decimal(20,3),
                            @SYMBOL nvarchar(25),
                            @MEDIANPRICE decimal(19,4),
                            @GIFTINKINDSUBTYPECODEID uniqueidentifier,
                            @PROPERTYSUBTYPECODEID uniqueidentifier,
                            @CONSTITUENTACCOUNTID uniqueidentifier,
                            @DIRECTDEBITRESULTCODE nvarchar(10),
                            @LOWPRICE decimal(19,4),
                            @HIGHPRICE decimal(19,4),
                            @ADJUSTMENTREASONCODEID uniqueidentifier,
              @ADJUSTMENTPOSTSTATUSCODE tinyint = 0
                        )
                        as
            begin

                  exec dbo.USP_USP_DATAFORMTEMPLATE_EDITLOAD_PAYMENTADJUST3
                      @ID = @ID

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_PAYMENTADJUST4
                  @ID,
                                @CHANGEAGENTID,
                                @DATE,
                                @AMOUNT,
                                @RECEIPTAMOUNT,
                                @REVENUESTREAMS,
                                @SOURCECODE,
                                @APPEALID,
                                @BENEFITS,
                                @BENEFITSWAIVED,
                                @GIVENANONYMOUSLY,
                                @MAILINGID,
                                @CHANNELCODEID,
                                @DONOTRECEIPT,
                                @DONOTACKNOWLEDGE,
                                @REFERENCE,
                                @ADJUSTMENTDATE,
                                @ADJUSTMENTPOSTDATE,
                                @ADJUSTMENTREASON,
                                @PAYMENTMETHODCODE,
                                @OTHERPAYMENTMETHODCODEID,
                                @CHECKDATE,
                                @CHECKNUMBER,
                                @REFERENCEDATE,
                                @REFERENCENUMBER,
                                @CARDHOLDERNAME,
                                @CREDITCARDNUMBER,
                                @CREDITTYPECODEID,
                                @AUTHORIZATIONCODE,
                                @EXPIRESON,
                                @ISSUER,
                                @NUMBEROFUNITS,
                                @SYMBOL,
                                @MEDIANPRICE,
                                @GIFTINKINDSUBTYPECODEID,
                                @PROPERTYSUBTYPECODEID,
                                @CONSTITUENTACCOUNTID,
                                @DIRECTDEBITRESULTCODE,
                                @LOWPRICE,
                                @HIGHPRICE,
                                @ADJUSTMENTREASONCODEID,
                  @ADJUSTMENTPOSTSTATUSCODE 


            end