USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHROW_9

Original stored procedure for saving an enhanced revenue batch row.

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.
@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(100)	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	Number of units
@SYMBOL	nvarchar(4)	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
@MGMATCHINGCONSTITUENTID	uniqueidentifier	IN	MG Matching constituent
@MGDATE	datetime	IN	MG Date
@MGAMOUNT	money	IN	MG Amount
@MGPOSTDATE	datetime	IN	MG Post date
@MGPOSTSTATUSCODE	tinyint	IN	MG Post status
@MGCONDITIONID	uniqueidentifier	IN	Matching gift condition ID
@MGSPLITS	xml	IN	MG Splits
@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
@MGRELATIONSHIPID	uniqueidentifier	IN	Relationship
@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
@APPLICATIONCODE	tinyint	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	Sale number of units
@USERMODIFIEDNUMBEROFUNITSSOLD	bit	IN	User modified 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(18)	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
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@PERCENTAGEBENEFITS	xml	IN	Percent benefits
@ISGIFTAIDSPONSORSHIP	bit	IN	Gift Aid sponsorship

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHROW_9
            (
                @ID 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(100),
                @CREDITCARDNUMBER nvarchar(20),
                @CREDITTYPECODEID uniqueidentifier,
                @AUTHORIZATIONCODE nvarchar(20),
                @EXPIRESON dbo.UDT_FUZZYDATE,
                @ISSUER nvarchar(100),
                @NUMBEROFUNITS decimal(20,3),
                @SYMBOL nvarchar(4),
                @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),
                @MGMATCHINGCONSTITUENTID uniqueidentifier,
                @MGDATE datetime,
                @MGAMOUNT money,
                @MGPOSTDATE datetime,
                @MGPOSTSTATUSCODE tinyint,
                @MGCONDITIONID uniqueidentifier,
                @MGSPLITS xml,
                @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,
                @MGRELATIONSHIPID uniqueidentifier,
                @OTHERPAYMENTMETHODCODEID uniqueidentifier,
                @LETTERCODEID uniqueidentifier,
                @ACKNOWLEDGEDATE datetime,
                @REFERENCE nvarchar(255),
                @CATEGORYCODEID uniqueidentifier,
                @ACKNOWLEDGEEID uniqueidentifier,
                @APPLICATIONCODE tinyint,
                @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(18), 
                @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,
                @CURRENTAPPUSERID uniqueidentifier = null,
                @PERCENTAGEBENEFITS xml,
                @ISGIFTAIDSPONSORSHIP bit
            )
            as
            begin
                declare @GENERATEREFERENCENUMBER bit;

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEBATCHROW_8 
                        @ID = @ID,
                        @GENERATEREFERENCENUMBER = @GENERATEREFERENCENUMBER output;

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEBATCHROW_10
                        @ID = @ID,
                        @CHANGEAGENTID = @CHANGEAGENTID,
                        @CONSTITUENTID = @CONSTITUENTID,
                        @TYPECODE = @TYPECODE,
                        @DATE = @DATE,
                        @AMOUNT = @AMOUNT,                            
                        @PAYMENTMETHODCODE = @PAYMENTMETHODCODE,
                        @DONOTACKNOWLEDGE = @DONOTACKNOWLEDGE,
                        @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,                            
                        @PROPERTYSUBTYPECODEID = @PROPERTYSUBTYPECODEID,
                        @GIFTINKINDSUBTYPECODEID = @GIFTINKINDSUBTYPECODEID,
                        @RECEIPTAMOUNT = @RECEIPTAMOUNT,
                        @DONOTRECEIPT = @DONOTRECEIPT,
                        @CONSTITUENTACCOUNTID = @CONSTITUENTACCOUNTID,
                        @SPLITS = @SPLITS,
                        @SINGLEDESIGNATIONID = @SINGLEDESIGNATIONID,
                        @REVENUESTREAMS = @REVENUESTREAMS,
                        @APPLYTOSHOWNFORCONSTITUENTID = @APPLYTOSHOWNFORCONSTITUENTID,
                        @SEQUENCE = @SEQUENCE,
                        @INSTALLMENTFREQUENCYCODE = @INSTALLMENTFREQUENCYCODE,
                        @INSTALLMENTSTARTDATE = @INSTALLMENTSTARTDATE,
                        @INSTALLMENTENDDATE = @INSTALLMENTENDDATE,
                        @NUMBEROFINSTALLMENTS = @NUMBEROFINSTALLMENTS,
                        @SOLICITORS = @SOLICITORS,
                        @BENEFITS = @BENEFITS,
                        @FINDERNUMBER = @FINDERNUMBER,
                        @SOURCECODE = @SOURCECODE,
                        @APPEALID = @APPEALID,
                        @FINDERNUMBERISVALID = @FINDERNUMBERISVALID,
                        @USERMODIFIEDBENEFITS = @USERMODIFIEDBENEFITS,
                        @BENEFITSWAIVED = @BENEFITSWAIVED,
                        @POSTDATE = @POSTDATE,
                        @POSTSTATUSCODE = @POSTSTATUSCODE,
                        @SENDPLEDGEREMINDER = @SENDPLEDGEREMINDER,
                        @SALEDATE = @SALEDATE,
                        @SALEAMOUNT = @SALEAMOUNT,
                        @BROKERFEE = @BROKERFEE,
                        @SALEPOSTSTATUSCODE = @SALEPOSTSTATUSCODE,
                        @SALEPOSTDATE = @SALEPOSTDATE,
                        @NOTETITLE = @NOTETITLE,
                        @NOTEAUTHORID = @NOTEAUTHORID,
                        @NOTEDATEENTERED = @NOTEDATEENTERED,
                        @NOTETYPECODEID = @NOTETYPECODEID,
                        @NOTETEXTNOTE = @NOTETEXTNOTE,
            @MGMATCHINGCONSTITUENTID=@MGMATCHINGCONSTITUENTID,
            @MGDATE= @MGDATE,
            @MGAMOUNT = @MGAMOUNT,
            @MGPOSTDATE = @MGPOSTDATE,
            @MGPOSTSTATUSCODE = @MGPOSTSTATUSCODE,
            @MGCONDITIONID = @MGCONDITIONID,
            @MGSPLITS = @MGSPLITS,
                        @GIVENANONYMOUSLY = @GIVENANONYMOUSLY,
                        @GIVENANONYMOUSLYDEFAULTEDFORCONSTITUENTID = @GIVENANONYMOUSLYDEFAULTEDFORCONSTITUENTID,
                        @USERMODIFIEDRECEIPTAMOUNT = @USERMODIFIEDRECEIPTAMOUNT,
                        @PLEDGESUBTYPEID = @PLEDGESUBTYPEID,
                        @REJECTIONCODEID = @REJECTIONCODEID,
                        @CONSTITUENTLOOKUPID = @CONSTITUENTLOOKUPID,
                        @MAILINGID = @MAILINGID,
                        @CHANNELCODEID = @CHANNELCODEID,
                        @INSTALLMENTS = @INSTALLMENTS,
                        @PAYMENTFORPLEDGEAMOUNT = @PAYMENTFORPLEDGEAMOUNT,
                        @RECOGNITIONS = @RECOGNITIONS,
                        @DIDRECOGNITIONSDEFAULT = @DIDRECOGNITIONSDEFAULT,
                        @TRIBUTES = @TRIBUTES,
                        @UNAPPLIEDMATCHINGGIFTSPLITS = @UNAPPLIEDMATCHINGGIFTSPLITS,        
                        @UNAPPLIEDMATCHINGGIFTAMOUNT = @UNAPPLIEDMATCHINGGIFTAMOUNT,
                        @RECEIPTTYPECODE = @RECEIPTTYPECODE,
                        @NEWCONSTITUENT = @NEWCONSTITUENT,
            @MGRELATIONSHIPID = @MGRELATIONSHIPID,
                        @OTHERPAYMENTMETHODCODEID = @OTHERPAYMENTMETHODCODEID,
                        @LETTERCODEID = @LETTERCODEID,
                        @ACKNOWLEDGEDATE = @ACKNOWLEDGEDATE,
                        @REFERENCE = @REFERENCE,
                        @CATEGORYCODEID = @CATEGORYCODEID,
                        @ACKNOWLEDGEEID = @ACKNOWLEDGEEID,
                        @APPLICATIONCODE = @APPLICATIONCODE,
                        @OTHERTYPECODEID = @OTHERTYPECODEID,
                        @OPPORTUNITYID = @OPPORTUNITYID,
                        @DIRECTDEBITRESULTCODE = @DIRECTDEBITRESULTCODE,
                        @LOWPRICE = @LOWPRICE,
                        @HIGHPRICE = @HIGHPRICE,
                        @NUMBEROFUNITSSOLD = @NUMBEROFUNITSSOLD,
                        @USERMODIFIEDNUMBEROFUNITSSOLD = @USERMODIFIEDNUMBEROFUNITSSOLD,
                        @CREDITCARDTOKEN = @CREDITCARDTOKEN,
                        @REJECTIONMESSAGE = @REJECTIONMESSAGE,
                        -- PARTIALCREDITCARDNUMBER is used just to support import and so is only 

                        -- actually used on RevenueBatchDataForm.Add.xml

                        @PARTIALCREDITCARDNUMBER = @PARTIALCREDITCARDNUMBER,
                        @TAXDECLARATIONS = @TAXDECLARATIONS,
                        @STANDINGORDERCONSTITUENTACCOUNTID = @STANDINGORDERCONSTITUENTACCOUNTID, 
                        @STANDINGORDERREFERENCENUMBER = @STANDINGORDERREFERENCENUMBER, 
                        @STANDINGORDERREFERENCEDATE = @STANDINGORDERREFERENCEDATE,
                        @STANDINGORDERSETUP = @STANDINGORDERSETUP,
                        @STANDINGORDERSETUPDATE = @STANDINGORDERSETUPDATE,
                        @TRANSACTIONID = @TRANSACTIONID,
                        @ISTRANSIENTCARD = @ISTRANSIENTCARD,
                        @DECLINESGIFTAID = @DECLINESGIFTAID,
                        @DDISOURCECODEID = @DDISOURCECODEID,
                        @DDISOURCEDATE = @DDISOURCEDATE,
                        @ISCOVENANT = @ISCOVENANT,
                        @AMOUNTFORVAT = @AMOUNTFORVAT,
                        @VATTAXRATEID = @VATTAXRATEID,
                        @VATAMOUNT = @VATAMOUNT,
                        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
                        @PERCENTAGEBENEFITS = @PERCENTAGEBENEFITS,
                        @ISGIFTAIDSPONSORSHIP = @ISGIFTAIDSPONSORSHIP,
                        @GENERATEREFERENCENUMBER = @GENERATEREFERENCENUMBER
            end