USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_3

Original #3 stored procedure for saving an enhanced revenue batch row.

Parameters

Parameter	Parameter Type	Mode
@ID	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

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_3
          (
            @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(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
          )
as
begin

        declare @APPLICATIONBUSINESSUNITS xml;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_2_REVENUEBATCHROW 
                @ID = @ID,
                @APPLICATIONBUSINESSUNITS=@APPLICATIONBUSINESSUNITS output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_4
                @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,
                @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,
                @OTHERPAYMENTMETHODCODEID = @OTHERPAYMENTMETHODCODEID,
                @LETTERCODEID = @LETTERCODEID,
                @ACKNOWLEDGEDATE = @ACKNOWLEDGEDATE,
                @REFERENCE = @REFERENCE,
                @CATEGORYCODEID = @CATEGORYCODEID,
                @ACKNOWLEDGEEID = @ACKNOWLEDGEEID,
                @APPLICATIONINFO = @APPLICATIONINFO,
                @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,
                    @ADDITIONALAPPLICATIONSSTREAM = @ADDITIONALAPPLICATIONSSTREAM,
                    @REVENUELOOKUPID = @REVENUELOOKUPID,
                @APPLICATIONSOLICITORS = @APPLICATIONSOLICITORS,
                @APPLICATIONRECOGNITIONS = @APPLICATIONRECOGNITIONS,
                @CURRENTAPPUSERID = @CURRENTAPPUSERID,
                @MATCHINGGIFTS = @MATCHINGGIFTS,
                @MGGENERATED = @MGGENERATED,
                @MGALTERED = @MGALTERED,
                @PAYINGPENDINGREVENUEID = @PAYINGPENDINGREVENUEID,
                @GIFTINKINDITEMNAME = @GIFTINKINDITEMNAME,
                @GIFTINKINDDISPOSITIONCODE = @GIFTINKINDDISPOSITIONCODE,
                @GIFTINKINDNUMBEROFUNITS = @GIFTINKINDNUMBEROFUNITS,
                @GIFTINKINDFAIRMARKETVALUE = @GIFTINKINDFAIRMARKETVALUE,
                @DIRECTDEBITISREJECTED = @DIRECTDEBITISREJECTED,
                @PERCENTAGEBENEFITS = @PERCENTAGEBENEFITS,
                @ISGIFTAIDSPONSORSHIP = @ISGIFTAIDSPONSORSHIP,
                @LOCKBOXID = @LOCKBOXID,
                @LOCKBOXBATCHNUMBER = @LOCKBOXBATCHNUMBER,
                @LOCKBOXBATCHSEQUENCE = @LOCKBOXBATCHSEQUENCE,
                @PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID,
        @APPLICATIONBUSINESSUNITS=@APPLICATIONBUSINESSUNITS
end