USP_DATAFORMTEMPLATE_EDIT_REVENUEUPDATEBATCHROW_3

Backwards compatibility spec for USP_DATAFORMTEMPLATE_EDIT_REVENUEUPDATEBATCHROW_4

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@REVENUEID	uniqueidentifier	IN
@REVENUESPLITID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@TYPECODE	tinyint	IN
@DATE	datetime	IN
@AMOUNT	money	IN
@PAYMENTMETHODCODE	tinyint	IN
@DONOTACKNOWLEDGE	bit	IN
@CHECKDATE	UDT_FUZZYDATE	IN
@CHECKNUMBER	nvarchar(20)	IN
@REFERENCEDATE	UDT_FUZZYDATE	IN
@REFERENCENUMBER	nvarchar(20)	IN
@CARDHOLDERNAME	nvarchar(255)	IN
@CREDITCARDNUMBER	nvarchar(20)	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
@PROPERTYSUBTYPECODEID	uniqueidentifier	IN
@GIFTINKINDSUBTYPECODEID	uniqueidentifier	IN
@RECEIPTAMOUNT	money	IN
@DONOTRECEIPT	bit	IN
@CONSTITUENTACCOUNTID	uniqueidentifier	IN
@SPLITS	xml	IN
@SINGLEDESIGNATIONID	uniqueidentifier	IN
@REVENUESTREAMS	xml	IN
@APPLYTOSHOWNFORCONSTITUENTID	uniqueidentifier	IN
@SEQUENCE	int	IN
@INSTALLMENTFREQUENCYCODE	tinyint	IN
@INSTALLMENTSTARTDATE	datetime	IN
@INSTALLMENTENDDATE	datetime	IN
@NUMBEROFINSTALLMENTS	int	IN
@SOLICITORS	xml	IN
@BENEFITS	xml	IN
@FINDERNUMBER	bigint	IN
@SOURCECODE	nvarchar(60)	IN
@APPEALID	uniqueidentifier	IN
@FINDERNUMBERISVALID	bit	IN
@USERMODIFIEDBENEFITS	bit	IN
@BENEFITSWAIVED	bit	IN
@POSTDATE	datetime	IN
@POSTSTATUSCODE	tinyint	IN
@SENDPLEDGEREMINDER	bit	IN
@SALEDATE	datetime	IN
@SALEAMOUNT	money	IN
@BROKERFEE	money	IN
@SALEPOSTSTATUSCODE	tinyint	IN
@SALEPOSTDATE	datetime	IN
@NOTETITLE	nvarchar(50)	IN
@NOTEAUTHORID	uniqueidentifier	IN
@NOTEDATEENTERED	datetime	IN
@NOTETYPECODEID	uniqueidentifier	IN
@NOTETEXTNOTE	nvarchar(max)	IN
@GIVENANONYMOUSLY	bit	IN
@GIVENANONYMOUSLYDEFAULTEDFORCONSTITUENTID	uniqueidentifier	IN
@USERMODIFIEDRECEIPTAMOUNT	bit	IN
@PLEDGESUBTYPEID	uniqueidentifier	IN
@REJECTIONCODEID	uniqueidentifier	IN
@CONSTITUENTLOOKUPID	uniqueidentifier	IN
@MAILINGID	uniqueidentifier	IN
@CHANNELCODEID	uniqueidentifier	IN
@INSTALLMENTS	xml	IN
@PAYMENTFORPLEDGEAMOUNT	money	IN
@RECOGNITIONS	xml	IN
@DIDRECOGNITIONSDEFAULT	bit	IN
@TRIBUTES	xml	IN
@UNAPPLIEDMATCHINGGIFTSPLITS	xml	IN
@UNAPPLIEDMATCHINGGIFTAMOUNT	money	IN
@RECEIPTTYPECODE	tinyint	IN
@NEWCONSTITUENT	xml	IN
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN
@LETTERCODEID	uniqueidentifier	IN
@ACKNOWLEDGEDATE	datetime	IN
@REFERENCE	nvarchar(255)	IN
@CATEGORYCODEID	uniqueidentifier	IN
@ACKNOWLEDGEEID	uniqueidentifier	IN
@APPLICATIONINFO	nvarchar(60)	IN
@OTHERTYPECODEID	uniqueidentifier	IN
@OPPORTUNITYID	uniqueidentifier	IN
@DIRECTDEBITRESULTCODE	nvarchar(10)	IN
@LOWPRICE	decimal(19, 4)	IN
@HIGHPRICE	decimal(19, 4)	IN
@NUMBEROFUNITSSOLD	decimal(20, 3)	IN
@USERMODIFIEDNUMBEROFUNITSSOLD	bit	IN
@CREDITCARDTOKEN	uniqueidentifier	IN
@REJECTIONMESSAGE	nvarchar(250)	IN
@PARTIALCREDITCARDNUMBER	nvarchar(4)	IN
@TAXDECLARATIONS	xml	IN
@STANDINGORDERCONSTITUENTACCOUNTID	uniqueidentifier	IN
@STANDINGORDERREFERENCENUMBER	nvarchar(20)	IN
@STANDINGORDERREFERENCEDATE	UDT_FUZZYDATE	IN
@STANDINGORDERSETUP	bit	IN
@STANDINGORDERSETUPDATE	datetime	IN
@TRANSACTIONID	uniqueidentifier	IN
@ISTRANSIENTCARD	bit	IN
@DECLINESGIFTAID	bit	IN
@DDISOURCECODEID	uniqueidentifier	IN
@DDISOURCEDATE	date	IN
@ISCOVENANT	bit	IN
@AMOUNTFORVAT	money	IN
@VATTAXRATEID	uniqueidentifier	IN
@VATAMOUNT	money	IN
@ADDITIONALAPPLICATIONSSTREAM	xml	IN
@REVENUELOOKUPID	nvarchar(100)	IN
@APPLICATIONSOLICITORS	xml	IN
@APPLICATIONRECOGNITIONS	xml	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@MATCHINGGIFTS	xml	IN
@MGGENERATED	bit	IN
@MGALTERED	bit	IN
@PAYINGPENDINGREVENUEID	uniqueidentifier	IN
@GIFTINKINDITEMNAME	nvarchar(100)	IN
@GIFTINKINDDISPOSITIONCODE	tinyint	IN
@GIFTINKINDNUMBEROFUNITS	int	IN
@GIFTINKINDFAIRMARKETVALUE	money	IN
@DIRECTDEBITISREJECTED	bit	IN
@PERCENTAGEBENEFITS	xml	IN
@ISGIFTAIDSPONSORSHIP	bit	IN
@LOCKBOXID	uniqueidentifier	IN
@LOCKBOXBATCHNUMBER	nvarchar(100)	IN
@LOCKBOXBATCHSEQUENCE	int	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	IN
@ISADJUSTMENT	bit	IN
@ADJUSTMENTDATE	datetime	IN
@ADJUSTMENTPOSTDATE	datetime	IN
@ADJUSTMENTREASON	nvarchar(300)	IN
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN
@ADJUSTMENTPOSTSTATUSCODE	tinyint	IN
@REVENUEDEVELOPMENTFUNCTIONCODEID	uniqueidentifier	IN
@ORIGINALAPPLICATIONINFO	nvarchar(60)	IN
@RELOADRECOGNITION	bit	IN
@RELOADSOLICITORS	bit	IN
@LETTERS	xml	IN
@APPLICATIONBUSINESSUNITS	xml	IN
@NOTES	xml	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BASECURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@EXCHANGERATE	decimal(20, 8)	IN
@GENERATEREFERENCENUMBER	bit	IN
@UPDATEMATCHINGGIFTCLAIMS	tinyint	IN
@UPDATEGIFTFEES	bit	IN
@UPDATETRIBUTES	bit	IN

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEUPDATEBATCHROW_3
            (
                @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 field is no longer in use (APPLICATIONSOLICITORS is current)  

                @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 field is no longer in use (APPLICATIONRECOGNITIONS is current)              

                @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),
                @RELOADRECOGNITION bit,
                @RELOADSOLICITORS bit,
                @LETTERS xml,
                @APPLICATIONBUSINESSUNITS xml,
                @NOTES xml,
                @TRANSACTIONCURRENCYID uniqueidentifier,
                @BASECURRENCYID uniqueidentifier,
                @BASEEXCHANGERATEID uniqueidentifier,
                @EXCHANGERATE decimal(20,8),
                        @GENERATEREFERENCENUMBER bit,
                @UPDATEMATCHINGGIFTCLAIMS tinyint,
                @UPDATEGIFTFEES bit,
                @UPDATETRIBUTES bit
            )
            as
            set nocount on;

            declare @INSTALLMENTSCHEDULESEEDDATE datetime; 

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEUPDATEBATCHROW 
                @ID = @ID, 
                @INSTALLMENTSCHEDULESEEDDATE = @INSTALLMENTSCHEDULESEEDDATE output;

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEUPDATEBATCHROW_4    
                @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 field is no longer in use (APPLICATIONSOLICITORS is current)  

                @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 field is no longer in use (APPLICATIONRECOGNITIONS is current)              

                @RECOGNITIONS,
                @DIDRECOGNITIONSDEFAULT,
                @TRIBUTES,
                @UNAPPLIEDMATCHINGGIFTSPLITS,        
                @UNAPPLIEDMATCHINGGIFTAMOUNT,
                @RECEIPTTYPECODE,
                @NEWCONSTITUENT,
                @OTHERPAYMENTMETHODCODEID,
                @LETTERCODEID,
                @ACKNOWLEDGEDATE,
                @REFERENCE,
                @CATEGORYCODEID,
                @ACKNOWLEDGEEID,
                @APPLICATIONINFO,
                @OTHERTYPECODEID,
                @OPPORTUNITYID,
                @DIRECTDEBITRESULTCODE,
                @LOWPRICE,
                @HIGHPRICE,
                @NUMBEROFUNITSSOLD,
                @USERMODIFIEDNUMBEROFUNITSSOLD,
                @CREDITCARDTOKEN,
                @REJECTIONMESSAGE,
                -- PARTIALCREDITCARDNUMBER is used just to support import and so is only 

                -- actually used on RevenueBatchDataForm.Add.xml

                @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,
                @LETTERS,
                @APPLICATIONBUSINESSUNITS,
                @NOTES,
                @TRANSACTIONCURRENCYID,
                @BASECURRENCYID,
                @BASEEXCHANGERATEID,
                @EXCHANGERATE,
                @GENERATEREFERENCENUMBER,
                @UPDATEMATCHINGGIFTCLAIMS,
                @UPDATEGIFTFEES,
                @UPDATETRIBUTES,
                @INSTALLMENTSCHEDULESEEDDATE;