USP_DATAFORMTEMPLATE_EDIT_PAYMENTADJUST6

Updates a posted payment.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DATE	datetime	IN
@AMOUNT	money	IN
@RECEIPTAMOUNT	money	IN
@REVENUESTREAMS	xml	IN
@SOURCECODE	nvarchar(50)	IN
@APPEALID	uniqueidentifier	IN
@BENEFITS	xml	IN
@BENEFITSWAIVED	bit	IN
@GIVENANONYMOUSLY	bit	IN
@MAILINGID	uniqueidentifier	IN
@CHANNELCODEID	uniqueidentifier	IN
@DONOTRECEIPT	bit	IN
@DONOTACKNOWLEDGE	bit	IN
@REFERENCE	nvarchar(255)	IN
@ADJUSTMENTDATE	datetime	IN
@ADJUSTMENTPOSTDATE	datetime	IN
@ADJUSTMENTREASON	nvarchar(300)	IN
@PAYMENTMETHODCODE	tinyint	IN
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN
@CHECKDATE	UDT_FUZZYDATE	IN
@CHECKNUMBER	nvarchar(20)	IN
@REFERENCEDATE	UDT_FUZZYDATE	IN
@REFERENCENUMBER	nvarchar(20)	IN
@CARDHOLDERNAME	nvarchar(255)	IN
@CREDITCARDNUMBER	nvarchar(4)	IN
@CREDITTYPECODEID	uniqueidentifier	IN
@AUTHORIZATIONCODE	nvarchar(20)	IN
@EXPIRESON	UDT_FUZZYDATE	IN
@ISSUER	nvarchar(100)	IN
@NUMBEROFUNITS	decimal(20, 3)	IN
@SYMBOL	nvarchar(25)	IN
@MEDIANPRICE	decimal(19, 4)	IN
@GIFTINKINDSUBTYPECODEID	uniqueidentifier	IN
@PROPERTYSUBTYPECODEID	uniqueidentifier	IN
@CONSTITUENTACCOUNTID	uniqueidentifier	IN
@DIRECTDEBITRESULTCODE	nvarchar(10)	IN
@LOWPRICE	decimal(19, 4)	IN
@HIGHPRICE	decimal(19, 4)	IN
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN
@ADJUSTMENTPOSTSTATUSCODE	tinyint	IN
@GIFTINKINDITEMNAME	nvarchar(100)	IN
@GIFTINKINDDISPOSITIONCODE	tinyint	IN
@GIFTINKINDNUMBEROFUNITS	int	IN
@GIFTINKINDFAIRMARKETVALUE	money	IN
@DIRECTDEBITISREJECTED	bit	IN
@PERCENTAGEBENEFITS	xml	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@EXCHANGERATE	decimal(20, 8)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@ADJUSTMATCHINGGIFTCLAIMS	tinyint	IN
@UPDATEGIFTFEEOPTION	tinyint	IN
@UPDATETRIBUTEOPTION	tinyint	IN
@VALIDATETRIBUTES	bit	IN
@DEPOSITID	uniqueidentifier	IN
@SEPAMANDATEID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PAYMENTADJUST6
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @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,
                @GIFTINKINDITEMNAME nvarchar(100),
                @GIFTINKINDDISPOSITIONCODE tinyint,
                @GIFTINKINDNUMBEROFUNITS int,
                @GIFTINKINDFAIRMARKETVALUE money,
                @DIRECTDEBITISREJECTED bit,
                @PERCENTAGEBENEFITS xml,
                @BASEEXCHANGERATEID uniqueidentifier = null,
                @EXCHANGERATE decimal(20,8) = null,
                @CURRENTAPPUSERID uniqueidentifier = null,
                @ADJUSTMATCHINGGIFTCLAIMS tinyint = null,
                @UPDATEGIFTFEEOPTION tinyint = null,
                @UPDATETRIBUTEOPTION tinyint = null,
                @VALIDATETRIBUTES bit = null,
                @DEPOSITID uniqueidentifier = null,
                @SEPAMANDATEID uniqueidentifier = null
            )
            as
            begin
            set nocount on;

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_PAYMENTADJUST7
                @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
                ,@GIFTINKINDITEMNAME
                ,@GIFTINKINDDISPOSITIONCODE
                ,@GIFTINKINDNUMBEROFUNITS
                ,@GIFTINKINDFAIRMARKETVALUE
                ,@DIRECTDEBITISREJECTED
                ,@PERCENTAGEBENEFITS
                ,@BASEEXCHANGERATEID
                ,@EXCHANGERATE
                ,@CURRENTAPPUSERID
                ,@ADJUSTMATCHINGGIFTCLAIMS
                ,@UPDATEGIFTFEEOPTION
                ,@UPDATETRIBUTEOPTION
                ,@VALIDATETRIBUTES
                ,@DEPOSITID
                ,@SEPAMANDATEID

            end