USP_DATAFORMTEMPLATE_EDIT_REVENUEUPDATEBATCHROW

Edit revenue update batch items.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@REVENUEID	uniqueidentifier	IN	Revenue
@REVENUESPLITID	uniqueidentifier	IN	Revenue Split
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@TYPECODE	tinyint	IN	Revenue type
@DATE	datetime	IN	Date
@AMOUNT	money	IN	Amount
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@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(20)	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	Stock number of units
@SYMBOL	nvarchar(25)	IN	Symbol
@MEDIANPRICE	decimal(19, 4)	IN	Median price
@PROPERTYSUBTYPECODEID	uniqueidentifier	IN	Property subtype
@GIFTINKINDSUBTYPECODEID	uniqueidentifier	IN	Gift-in-kind subtype
@RECEIPTAMOUNT	money	IN	Receipt amount
@DONOTRECEIPT	bit	IN	Do not receipt
@CONSTITUENTACCOUNTID	uniqueidentifier	IN	Account
@SPLITS	xml	IN	Designations
@SINGLEDESIGNATIONID	uniqueidentifier	IN	Designation
@REVENUESTREAMS	xml	IN	Revenue streams
@APPLYTOSHOWNFORCONSTITUENTID	uniqueidentifier	IN	Apply to shown for constituent
@SEQUENCE	int	IN	Sequence
@INSTALLMENTFREQUENCYCODE	tinyint	IN	Installment frequency
@INSTALLMENTSTARTDATE	datetime	IN	Installment start date
@INSTALLMENTENDDATE	datetime	IN	Installment end date
@NUMBEROFINSTALLMENTS	int	IN	No. installments
@SOLICITORS	xml	IN	Solicitors
@BENEFITS	xml	IN	Money benefits
@FINDERNUMBER	bigint	IN	Finder number
@SOURCECODE	nvarchar(60)	IN	Source code
@APPEALID	uniqueidentifier	IN	Appeal
@FINDERNUMBERISVALID	bit	IN	Finder number is valid
@USERMODIFIEDBENEFITS	bit	IN	User modified benefits
@BENEFITSWAIVED	bit	IN	User waived benefits
@POSTDATE	datetime	IN	GL post date
@POSTSTATUSCODE	tinyint	IN	GL post status
@SENDPLEDGEREMINDER	bit	IN	Send reminders
@SALEDATE	datetime	IN	Sale date
@SALEAMOUNT	money	IN	Sale amount
@BROKERFEE	money	IN	Sale fees
@SALEPOSTSTATUSCODE	tinyint	IN	Sale GL post status
@SALEPOSTDATE	datetime	IN	Sale GL post date
@NOTETITLE	nvarchar(50)	IN	Note Title
@NOTEAUTHORID	uniqueidentifier	IN	Note Author
@NOTEDATEENTERED	datetime	IN	Note Date
@NOTETYPECODEID	uniqueidentifier	IN	Note Type
@NOTETEXTNOTE	nvarchar(max)	IN	Notes
@GIVENANONYMOUSLY	bit	IN	Given anonymously
@GIVENANONYMOUSLYDEFAULTEDFORCONSTITUENTID	uniqueidentifier	IN	Given anonymously defaulted for constituent
@USERMODIFIEDRECEIPTAMOUNT	bit	IN	User modified receipt amount
@PLEDGESUBTYPEID	uniqueidentifier	IN	Pledge subtype
@REJECTIONCODEID	uniqueidentifier	IN	Rejection code
@CONSTITUENTLOOKUPID	uniqueidentifier	IN	Lookup ID
@MAILINGID	uniqueidentifier	IN	Effort
@CHANNELCODEID	uniqueidentifier	IN	Inbound channel
@INSTALLMENTS	xml	IN	Installments
@PAYMENTFORPLEDGEAMOUNT	money	IN	Payment for pledge amount
@RECOGNITIONS	xml	IN	Recognition credits
@DIDRECOGNITIONSDEFAULT	bit	IN	Did default recognition credits
@TRIBUTES	xml	IN	Tributes
@UNAPPLIEDMATCHINGGIFTSPLITS	xml	IN	Unapplied MG Split
@UNAPPLIEDMATCHINGGIFTAMOUNT	money	IN	Applied
@RECEIPTTYPECODE	tinyint	IN	Receipt type
@NEWCONSTITUENT	xml	IN	New constituent
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN	Other method
@LETTERCODEID	uniqueidentifier	IN	Letter
@ACKNOWLEDGEDATE	datetime	IN	Acknowledge date
@REFERENCE	nvarchar(255)	IN	Reference
@CATEGORYCODEID	uniqueidentifier	IN	Revenue category
@ACKNOWLEDGEEID	uniqueidentifier	IN	Acknowledgee
@APPLICATIONINFO	nvarchar(60)	IN	Application
@OTHERTYPECODEID	uniqueidentifier	IN	Other type
@OPPORTUNITYID	uniqueidentifier	IN	Opportunity
@DIRECTDEBITRESULTCODE	nvarchar(10)	IN	Result code
@LOWPRICE	decimal(19, 4)	IN	Low price
@HIGHPRICE	decimal(19, 4)	IN	High price
@NUMBEROFUNITSSOLD	decimal(20, 3)	IN	Stock sale number of units
@USERMODIFIEDNUMBEROFUNITSSOLD	bit	IN	User modified stock number of units sold
@CREDITCARDTOKEN	uniqueidentifier	IN	Credit card token
@REJECTIONMESSAGE	nvarchar(250)	IN	Rejection message
@PARTIALCREDITCARDNUMBER	nvarchar(4)	IN	Partial card number
@TAXDECLARATIONS	xml	IN	Declarations
@STANDINGORDERCONSTITUENTACCOUNTID	uniqueidentifier	IN	Standing order account
@STANDINGORDERREFERENCENUMBER	nvarchar(20)	IN	Standing order reference number
@STANDINGORDERREFERENCEDATE	UDT_FUZZYDATE	IN	Standing order reference date
@STANDINGORDERSETUP	bit	IN	Standing order has been setup
@STANDINGORDERSETUPDATE	datetime	IN	Standing order setup date
@TRANSACTIONID	uniqueidentifier	IN	Transaction ID
@ISTRANSIENTCARD	bit	IN	Is transient credit card
@DECLINESGIFTAID	bit	IN	Declines Gift Aid
@DDISOURCECODEID	uniqueidentifier	IN	DDI source
@DDISOURCEDATE	date	IN	DDI source date
@ISCOVENANT	bit	IN	Is covenant gift
@AMOUNTFORVAT	money	IN	Portion subject to VAT
@VATTAXRATEID	uniqueidentifier	IN	VAT tax rate
@VATAMOUNT	money	IN	VAT amount
@ADDITIONALAPPLICATIONSSTREAM	xml	IN	Additional applications stream
@REVENUELOOKUPID	nvarchar(100)	IN	Revenue ID
@APPLICATIONSOLICITORS	xml	IN	Application solicitors
@APPLICATIONRECOGNITIONS	xml	IN	Application recognitions
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@MATCHINGGIFTS	xml	IN
@MGGENERATED	bit	IN	MG Generated
@MGALTERED	bit	IN	MG Altered
@PAYINGPENDINGREVENUEID	uniqueidentifier	IN	Was paying pending revenue
@GIFTINKINDITEMNAME	nvarchar(100)	IN	Item name
@GIFTINKINDDISPOSITIONCODE	tinyint	IN	Disposition
@GIFTINKINDNUMBEROFUNITS	int	IN	Gift-in-kind number of units
@GIFTINKINDFAIRMARKETVALUE	money	IN	Fair market value per unit
@DIRECTDEBITISREJECTED	bit	IN	Direct debit is rejected
@PERCENTAGEBENEFITS	xml	IN	Percent benefits
@ISGIFTAIDSPONSORSHIP	bit	IN	Gift Aid sponsorship
@LOCKBOXID	uniqueidentifier	IN	Lockbox
@LOCKBOXBATCHNUMBER	nvarchar(100)	IN	Lockbox batch number
@LOCKBOXBATCHSEQUENCE	int	IN	Lockbox batch sequence
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system
@ISADJUSTMENT	bit	IN	ISADJUSTMENT
@ADJUSTMENTDATE	datetime	IN	Adjustment date
@ADJUSTMENTPOSTDATE	datetime	IN	Adjustment post date
@ADJUSTMENTREASON	nvarchar(300)	IN	Adjustment details
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason
@ADJUSTMENTPOSTSTATUSCODE	tinyint	IN	Adjustment post status
@REVENUEDEVELOPMENTFUNCTIONCODEID	uniqueidentifier	IN	Revenue function
@ORIGINALAPPLICATIONINFO	nvarchar(60)	IN	ORIGINALAPPLICATIONINFO

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEUPDATEBATCHROW
(
            @ID uniqueidentifier,
            @REVENUEID uniqueidentifier,
            @REVENUESPLITID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier,
            @CONSTITUENTID uniqueidentifier,
            @TYPECODE tinyint,
            @DATE datetime,
            @AMOUNT money,                            
            @PAYMENTMETHODCODE tinyint,
            @DONOTACKNOWLEDGE bit,
            @CHECKDATE dbo.UDT_FUZZYDATE,
            @CHECKNUMBER nvarchar(20),
            @REFERENCEDATE dbo.UDT_FUZZYDATE,
            @REFERENCENUMBER nvarchar(20),
            @CARDHOLDERNAME nvarchar(255),
            @CREDITCARDNUMBER nvarchar(20),
            @CREDITTYPECODEID uniqueidentifier,
            @AUTHORIZATIONCODE nvarchar(20),
            @EXPIRESON dbo.UDT_FUZZYDATE,
            @ISSUER nvarchar(100),
            @NUMBEROFUNITS decimal(20,3),
            @SYMBOL nvarchar(25),
            @MEDIANPRICE decimal(19,4),                            
            @PROPERTYSUBTYPECODEID uniqueidentifier,
            @GIFTINKINDSUBTYPECODEID uniqueidentifier,
            @RECEIPTAMOUNT money,
            @DONOTRECEIPT bit,
            @CONSTITUENTACCOUNTID uniqueidentifier,
            @SPLITS xml,
            @SINGLEDESIGNATIONID uniqueidentifier,
            @REVENUESTREAMS xml,
            @APPLYTOSHOWNFORCONSTITUENTID uniqueidentifier,
            @SEQUENCE int,
            @INSTALLMENTFREQUENCYCODE tinyint,
            @INSTALLMENTSTARTDATE datetime,
            @INSTALLMENTENDDATE datetime,
            @NUMBEROFINSTALLMENTS int,
            @SOLICITORS xml,
            @BENEFITS xml,
            @FINDERNUMBER bigint,
            @SOURCECODE nvarchar(60),
            @APPEALID uniqueidentifier,
            @FINDERNUMBERISVALID bit,
            @USERMODIFIEDBENEFITS bit,
            @BENEFITSWAIVED bit,
            @POSTDATE datetime,
            @POSTSTATUSCODE tinyint,
            @SENDPLEDGEREMINDER bit,
            @SALEDATE datetime,
            @SALEAMOUNT money,
            @BROKERFEE money,
            @SALEPOSTSTATUSCODE tinyint,
            @SALEPOSTDATE datetime,
            @NOTETITLE nvarchar(50),
            @NOTEAUTHORID uniqueidentifier,
            @NOTEDATEENTERED datetime,
            @NOTETYPECODEID uniqueidentifier,
            @NOTETEXTNOTE nvarchar(max),
            @GIVENANONYMOUSLY bit,
            @GIVENANONYMOUSLYDEFAULTEDFORCONSTITUENTID uniqueidentifier,
            @USERMODIFIEDRECEIPTAMOUNT bit,
            @PLEDGESUBTYPEID uniqueidentifier,
            @REJECTIONCODEID uniqueidentifier,
            @CONSTITUENTLOOKUPID uniqueidentifier,
            @MAILINGID uniqueidentifier,
            @CHANNELCODEID uniqueidentifier,
            @INSTALLMENTS xml,
            @PAYMENTFORPLEDGEAMOUNT money,
            @RECOGNITIONS xml,
            @DIDRECOGNITIONSDEFAULT bit,
            @TRIBUTES xml,
            @UNAPPLIEDMATCHINGGIFTSPLITS xml,        
            @UNAPPLIEDMATCHINGGIFTAMOUNT money,
            @RECEIPTTYPECODE tinyint,
            @NEWCONSTITUENT xml,
            @OTHERPAYMENTMETHODCODEID uniqueidentifier,
            @LETTERCODEID uniqueidentifier,
            @ACKNOWLEDGEDATE datetime,
            @REFERENCE nvarchar(255),
            @CATEGORYCODEID uniqueidentifier,
            @ACKNOWLEDGEEID uniqueidentifier,
            @APPLICATIONINFO nvarchar(60),
            @OTHERTYPECODEID uniqueidentifier,
                        @OPPORTUNITYID uniqueidentifier,
            @DIRECTDEBITRESULTCODE nvarchar(10),
            @LOWPRICE decimal(19,4),
            @HIGHPRICE decimal(19,4),
            @NUMBEROFUNITSSOLD decimal(20,3),
            @USERMODIFIEDNUMBEROFUNITSSOLD bit,
            @CREDITCARDTOKEN uniqueidentifier,
            @REJECTIONMESSAGE nvarchar(250),
            -- PARTIALCREDITCARDNUMBER is used just to support import and so is only 

 -- actually used on RevenueBatchDataForm.Add.xml

            @PARTIALCREDITCARDNUMBER nvarchar(4),
            @TAXDECLARATIONS xml,
                  @STANDINGORDERCONSTITUENTACCOUNTID uniqueidentifier, 
                  @STANDINGORDERREFERENCENUMBER nvarchar(20), 
                  @STANDINGORDERREFERENCEDATE dbo.UDT_FUZZYDATE,
                  @STANDINGORDERSETUP bit,
                  @STANDINGORDERSETUPDATE datetime,
            @TRANSACTIONID uniqueidentifier,
            @ISTRANSIENTCARD bit,
            @DECLINESGIFTAID bit,
            @DDISOURCECODEID uniqueidentifier,
            @DDISOURCEDATE date,
            @ISCOVENANT bit,
            @AMOUNTFORVAT money,
            @VATTAXRATEID uniqueidentifier,
            @VATAMOUNT money,
                        @ADDITIONALAPPLICATIONSSTREAM xml,
                        @REVENUELOOKUPID nvarchar(100),
            @APPLICATIONSOLICITORS xml,
            @APPLICATIONRECOGNITIONS xml,
            @CURRENTAPPUSERID uniqueidentifier = null,
            @MATCHINGGIFTS xml,
            @MGGENERATED bit,
            @MGALTERED bit,
            @PAYINGPENDINGREVENUEID uniqueidentifier,
            @GIFTINKINDITEMNAME nvarchar(100),
            @GIFTINKINDDISPOSITIONCODE tinyint,
            @GIFTINKINDNUMBEROFUNITS int,
            @GIFTINKINDFAIRMARKETVALUE money,
            @DIRECTDEBITISREJECTED bit,
            @PERCENTAGEBENEFITS xml,
            @ISGIFTAIDSPONSORSHIP bit,
            @LOCKBOXID uniqueidentifier,
            @LOCKBOXBATCHNUMBER nvarchar(100),
            @LOCKBOXBATCHSEQUENCE int,
            @PDACCOUNTSYSTEMID uniqueidentifier,
            @ISADJUSTMENT bit,
            @ADJUSTMENTDATE datetime ,
              @ADJUSTMENTPOSTDATE datetime,
              @ADJUSTMENTREASON nvarchar(300),
              @ADJUSTMENTREASONCODEID uniqueidentifier,
              @ADJUSTMENTPOSTSTATUSCODE tinyint,
            @REVENUEDEVELOPMENTFUNCTIONCODEID uniqueidentifier,
            @ORIGINALAPPLICATIONINFO nvarchar(60)
          )
          as
            set nocount on;

            declare @RELOADRECOGNITION bit;
            declare @RELOADSOLICITORS bit;

                      exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEUPDATEBATCHROW @ID = @ID,
                                                                                           @RELOADRECOGNITION = @RELOADRECOGNITION output,
                                               @RELOADSOLICITORS = @RELOADSOLICITORS output

                      exec dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEUPDATEBATCHROW_2    @ID,
                                                                                          @REVENUEID,
                                              @REVENUESPLITID,
                                              @CHANGEAGENTID,
                                              @CONSTITUENTID,
                                              @TYPECODE,
                                              @DATE,
                                              @AMOUNT,                            
                                              @PAYMENTMETHODCODE,
                                              @DONOTACKNOWLEDGE,
                                              @CHECKDATE,
                                              @CHECKNUMBER,
                                              @REFERENCEDATE,
                                              @REFERENCENUMBER,
                                              @CARDHOLDERNAME,
                                              @CREDITCARDNUMBER,
                                              @CREDITTYPECODEID,
                                              @AUTHORIZATIONCODE,
                                              @EXPIRESON,
                                              @ISSUER,
                                              @NUMBEROFUNITS,
                                              @SYMBOL,
                                              @MEDIANPRICE,                            
                                              @PROPERTYSUBTYPECODEID,
        @GIFTINKINDSUBTYPECODEID,
                                              @RECEIPTAMOUNT,
                                              @DONOTRECEIPT,
                                              @CONSTITUENTACCOUNTID,
                                              @SPLITS,
                                              @SINGLEDESIGNATIONID,
                                              @REVENUESTREAMS,
                                              @APPLYTOSHOWNFORCONSTITUENTID,
                                              @SEQUENCE,
                                              @INSTALLMENTFREQUENCYCODE,
                                              @INSTALLMENTSTARTDATE,
                                              @INSTALLMENTENDDATE,
                                              @NUMBEROFINSTALLMENTS,
                                              @SOLICITORS,
                                              @BENEFITS,
                                              @FINDERNUMBER,
                                              @SOURCECODE,
                                              @APPEALID,
                                              @FINDERNUMBERISVALID,
                                              @USERMODIFIEDBENEFITS,
                                              @BENEFITSWAIVED,
                                              @POSTDATE,
                                              @POSTSTATUSCODE,
                                              @SENDPLEDGEREMINDER,
                                              @SALEDATE,
                                              @SALEAMOUNT,
                                              @BROKERFEE,
                                              @SALEPOSTSTATUSCODE,
                                              @SALEPOSTDATE,
                                              @NOTETITLE,
                                              @NOTEAUTHORID,
                                              @NOTEDATEENTERED,
                                              @NOTETYPECODEID,
                                              @NOTETEXTNOTE,
                                              @GIVENANONYMOUSLY,
                                              @GIVENANONYMOUSLYDEFAULTEDFORCONSTITUENTID,
                                              @USERMODIFIEDRECEIPTAMOUNT,
                                              @PLEDGESUBTYPEID,
                                              @REJECTIONCODEID,
                                              @CONSTITUENTLOOKUPID,
                                              @MAILINGID,
                                              @CHANNELCODEID,
                                              @INSTALLMENTS,
                                              @PAYMENTFORPLEDGEAMOUNT,
                                              @RECOGNITIONS,
                                              @DIDRECOGNITIONSDEFAULT,
                                              @TRIBUTES,
                                              @UNAPPLIEDMATCHINGGIFTSPLITS,        
                                              @UNAPPLIEDMATCHINGGIFTAMOUNT,
                                              @RECEIPTTYPECODE,
                                              @NEWCONSTITUENT,
                                              @OTHERPAYMENTMETHODCODEID,
                                              @LETTERCODEID,
                                              @ACKNOWLEDGEDATE,
                                              @REFERENCE,
                                              @CATEGORYCODEID,
                                              @ACKNOWLEDGEEID,
                                              @APPLICATIONINFO,
                                              @OTHERTYPECODEID,
                                              @OPPORTUNITYID,
                                              @DIRECTDEBITRESULTCODE,
         @LOWPRICE,
                                              @HIGHPRICE,
                                              @NUMBEROFUNITSSOLD,
                                              @USERMODIFIEDNUMBEROFUNITSSOLD,
                                              @CREDITCARDTOKEN,
                                              @REJECTIONMESSAGE,
                                              @PARTIALCREDITCARDNUMBER,
                                              @TAXDECLARATIONS,
                                              @STANDINGORDERCONSTITUENTACCOUNTID, 
                                              @STANDINGORDERREFERENCENUMBER, 
                                              @STANDINGORDERREFERENCEDATE,
                                              @STANDINGORDERSETUP,
                                              @STANDINGORDERSETUPDATE,
                                              @TRANSACTIONID,
                                              @ISTRANSIENTCARD,
                                              @DECLINESGIFTAID,
                                              @DDISOURCECODEID,
                                              @DDISOURCEDATE,
                                              @ISCOVENANT,
                                              @AMOUNTFORVAT,
                                              @VATTAXRATEID,
                                              @VATAMOUNT,
                                              @ADDITIONALAPPLICATIONSSTREAM,
                                              @REVENUELOOKUPID,
                                              @APPLICATIONSOLICITORS,
                                              @APPLICATIONRECOGNITIONS,
                                              @CURRENTAPPUSERID,
                                              @MATCHINGGIFTS,
                                              @MGGENERATED,
                                              @MGALTERED,
                                              @PAYINGPENDINGREVENUEID,
                                              @GIFTINKINDITEMNAME,
                                              @GIFTINKINDDISPOSITIONCODE,
                                              @GIFTINKINDNUMBEROFUNITS,
                                              @GIFTINKINDFAIRMARKETVALUE,
                                              @DIRECTDEBITISREJECTED,
                                              @PERCENTAGEBENEFITS,
                                              @ISGIFTAIDSPONSORSHIP,
                                              @LOCKBOXID,
                                              @LOCKBOXBATCHNUMBER,
                                              @LOCKBOXBATCHSEQUENCE,
                                              @PDACCOUNTSYSTEMID,
                                              @ISADJUSTMENT,
                                              @ADJUSTMENTDATE,
                                              @ADJUSTMENTPOSTDATE,
                                              @ADJUSTMENTREASON,
                                              @ADJUSTMENTREASONCODEID,
                                              @ADJUSTMENTPOSTSTATUSCODE,
                                              @REVENUEDEVELOPMENTFUNCTIONCODEID,
                                              @ORIGINALAPPLICATIONINFO,
                                              @RELOADRECOGNITION,
                                              @RELOADSOLICITORS 

                      return 0;