USP_DATAFORMTEMPLATE_EDIT_PAYMENT6

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
@POSTSTATUSCODE	tinyint	IN
@POSTDATE	datetime	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
@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
@ADJUSTMATCHINGGIFTCLAIMS	tinyint	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@UPDATEGIFTFEEOPTION	tinyint	IN
@UPDATETRIBUTEOPTION	tinyint	IN
@VALIDATETRIBUTES	bit	IN
@SALE_SALEDATE	datetime	IN
@SALE_SALEAMOUNT	money	IN
@SALE_BROKERFEES	money	IN
@SALE_GLPOSTDATE	datetime	IN
@SALE_GLPOSTSTATUS	tinyint	IN
@SALE_LOWPRICE	decimal(19, 4)	IN
@SALE_MEDIANPRICE	decimal(19, 4)	IN
@SALE_HIGHPRICE	decimal(19, 4)	IN
@SEPAMANDATEID	uniqueidentifier	IN
@BATCHROWID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PAYMENT6
                (
                    @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,
                    @PERCENTAGEBENEFITS xml,
                    @BASEEXCHANGERATEID uniqueidentifier = null,
                    @EXCHANGERATE decimal(20,8) = null,
                    @ADJUSTMATCHINGGIFTCLAIMS tinyint = null,
                    @CURRENTAPPUSERID uniqueidentifier = null,
                    @UPDATEGIFTFEEOPTION tinyint = null,
                    @UPDATETRIBUTEOPTION tinyint = null,
                    @VALIDATETRIBUTES bit = null,
                    @SALE_SALEDATE datetime = null,
                    @SALE_SALEAMOUNT money = null,
                    @SALE_BROKERFEES money = null,
                    @SALE_GLPOSTDATE datetime = null,
                    @SALE_GLPOSTSTATUS tinyint = null,
                    @SALE_LOWPRICE decimal(19,4) = 0,
                    @SALE_MEDIANPRICE decimal(19,4) = 0,
                    @SALE_HIGHPRICE decimal(19,4) = 0,
                    @SEPAMANDATEID uniqueidentifier = null,
                    @BATCHROWID uniqueidentifier = null
                )
                as
                set nocount on;

                declare @NUMBEROFUNITSSOLD decimal(20,3);
                select @NUMBEROFUNITSSOLD = NUMBEROFUNITSSOLD from dbo.BATCHREVENUE where ID = @BATCHROWID;

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_PAYMENT7
                    @ID = @ID,
                    @CHANGEAGENTID = @CHANGEAGENTID,
                    @DATE = @DATE,
                    @AMOUNT = @AMOUNT,
                    @RECEIPTAMOUNT = @RECEIPTAMOUNT,
                    @REVENUESTREAMS = @REVENUESTREAMS,
                    @SOURCECODE = @SOURCECODE,
                    @APPEALID = @APPEALID,
                    @BENEFITS = @BENEFITS,
                    @BENEFITSWAIVED = @BENEFITSWAIVED,
                    @GIVENANONYMOUSLY = @GIVENANONYMOUSLY,
                    @MAILINGID = @MAILINGID,
                    @CHANNELCODEID = @CHANNELCODEID,
                    @DONOTRECEIPT = @DONOTRECEIPT,
                    @DONOTACKNOWLEDGE = @DONOTACKNOWLEDGE,
                    @REFERENCE = @REFERENCE,
                    @POSTSTATUSCODE = @POSTSTATUSCODE,
                    @POSTDATE = @POSTDATE,
                    @PAYMENTMETHODCODE = @PAYMENTMETHODCODE,
                    @OTHERPAYMENTMETHODCODEID = @OTHERPAYMENTMETHODCODEID,
                    @CHECKDATE = @CHECKDATE,
                    @CHECKNUMBER = @CHECKNUMBER,
                    @REFERENCEDATE = @REFERENCEDATE,
                    @REFERENCENUMBER = @REFERENCENUMBER,
                    @CARDHOLDERNAME = @CARDHOLDERNAME,
                    @CREDITCARDNUMBER = @CREDITCARDNUMBER,
                    @CREDITTYPECODEID = @CREDITTYPECODEID,
                    @AUTHORIZATIONCODE = @AUTHORIZATIONCODE,
                    @EXPIRESON = @EXPIRESON,
                    @ISSUER = @ISSUER,
                    @NUMBEROFUNITS = @NUMBEROFUNITS,
                    @SYMBOL = @SYMBOL,
                    @MEDIANPRICE = @MEDIANPRICE,
                    @GIFTINKINDSUBTYPECODEID = @GIFTINKINDSUBTYPECODEID,
                    @PROPERTYSUBTYPECODEID = @PROPERTYSUBTYPECODEID,
                    @CONSTITUENTACCOUNTID = @CONSTITUENTACCOUNTID,
                    @DIRECTDEBITRESULTCODE = @DIRECTDEBITRESULTCODE,
                    @LOWPRICE = @LOWPRICE,
                    @HIGHPRICE = @HIGHPRICE,
                    @GIFTINKINDITEMNAME = @GIFTINKINDITEMNAME,
                    @GIFTINKINDDISPOSITIONCODE = @GIFTINKINDDISPOSITIONCODE,
                    @GIFTINKINDNUMBEROFUNITS = @GIFTINKINDNUMBEROFUNITS,
                    @GIFTINKINDFAIRMARKETVALUE = @GIFTINKINDFAIRMARKETVALUE,
                    @DIRECTDEBITISREJECTED = @DIRECTDEBITISREJECTED,
                    @PERCENTAGEBENEFITS = @PERCENTAGEBENEFITS,
                    @BASEEXCHANGERATEID = @BASEEXCHANGERATEID,
                    @EXCHANGERATE = @EXCHANGERATE,
                    @ADJUSTMATCHINGGIFTCLAIMS = @ADJUSTMATCHINGGIFTCLAIMS,
                    @CURRENTAPPUSERID = @CURRENTAPPUSERID,   
                    @UPDATEGIFTFEEOPTION = @UPDATEGIFTFEEOPTION,
                    @UPDATETRIBUTEOPTION = @UPDATETRIBUTEOPTION,
                    @VALIDATETRIBUTES = @VALIDATETRIBUTES,
                    @SALE_SALEDATE = @SALE_SALEDATE,
                    @SALE_SALEAMOUNT = @SALE_SALEAMOUNT,
                    @SALE_BROKERFEES = @SALE_BROKERFEES,
                    @SALE_GLPOSTDATE = @SALE_GLPOSTDATE,
                    @SALE_GLPOSTSTATUS = @SALE_GLPOSTSTATUS,
                    @SALE_LOWPRICE = @SALE_LOWPRICE,
                    @SALE_MEDIANPRICE = @SALE_MEDIANPRICE,
                    @SALE_HIGHPRICE = @SALE_HIGHPRICE,
                    @SEPAMANDATEID = @SEPAMANDATEID,
                    @BATCHROWID = @BATCHROWID,
                    @NUMBEROFUNITSSOLD = @NUMBEROFUNITSSOLD;

                return 0;