USP_DATAFORMTEMPLATE_EDIT_PAYMENT3

Edits a payment.

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	Inbound channel
@DONOTRECEIPT	bit	IN	Do not receipt
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@REFERENCE	nvarchar(255)	IN	Reference
@POSTSTATUSCODE	tinyint	IN	Post status
@POSTDATE	datetime	IN	Post 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
@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
@GIFTINKINDITEMNAME	nvarchar(100)	IN	Item name
@GIFTINKINDDISPOSITIONCODE	tinyint	IN	Disposition
@GIFTINKINDNUMBEROFUNITS	int	IN	Number of units
@GIFTINKINDFAIRMARKETVALUE	money	IN	Fair market value per unit
@DIRECTDEBITISREJECTED	bit	IN	Rejected

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PAYMENT3
            (
                @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),
                @POSTSTATUSCODE tinyint,
                @POSTDATE 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,
                @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),
                @GIFTINKINDITEMNAME nvarchar(100),
                @GIFTINKINDDISPOSITIONCODE tinyint,
                @GIFTINKINDNUMBEROFUNITS int,
                @GIFTINKINDFAIRMARKETVALUE money,
                @DIRECTDEBITISREJECTED bit
            )
            as
            set nocount on;

            declare @PERCENTAGEBENEFITS xml;

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PAYMENT2
                @ID = @ID,
                @PERCENTAGEBENEFITS = @PERCENTAGEBENEFITS output

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_PAYMENT4
                @ID,
                @CHANGEAGENTID,
                @DATE,
                @AMOUNT,
                @RECEIPTAMOUNT,
                @REVENUESTREAMS,
                @SOURCECODE,
                @APPEALID,
                @BENEFITS,
                @BENEFITSWAIVED,
                @GIVENANONYMOUSLY,
                @MAILINGID,
                @CHANNELCODEID,
                @DONOTRECEIPT,
                @DONOTACKNOWLEDGE,
                @REFERENCE,
                @POSTSTATUSCODE,
                @POSTDATE,
                @PAYMENTMETHODCODE,
                @OTHERPAYMENTMETHODCODEID,
                @CHECKDATE,
                @CHECKNUMBER,
                @REFERENCEDATE,
                @REFERENCENUMBER,
                @CARDHOLDERNAME,
                @CREDITCARDNUMBER,
                @CREDITTYPECODEID,
                @AUTHORIZATIONCODE,
                @EXPIRESON,
                @ISSUER,
                @NUMBEROFUNITS,
                @SYMBOL,
                @MEDIANPRICE,
                @GIFTINKINDSUBTYPECODEID,
                @PROPERTYSUBTYPECODEID,
                @CONSTITUENTACCOUNTID,
                @DIRECTDEBITRESULTCODE,
                @LOWPRICE,
                @HIGHPRICE,
                @GIFTINKINDITEMNAME,
                @GIFTINKINDDISPOSITIONCODE,
                @GIFTINKINDNUMBEROFUNITS,
                @GIFTINKINDFAIRMARKETVALUE,
                @DIRECTDEBITISREJECTED,
                @PERCENTAGEBENEFITS

            return 0;