USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_6

Original #6 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(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(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
@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(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
@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
@APPLICATIONBUSINESSUNITS	xml	IN	Application business units
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Transaction currency
@BASECURRENCYID	uniqueidentifier	IN	Base currency
@BASEEXCHANGERATEID	uniqueidentifier	IN	Base exchange rate
@EXCHANGERATE	decimal(20, 8)	IN	Exchange rate
@GENERATEREFERENCENUMBER	bit	IN	Automatically generate reference number

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_6
    (
        @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(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),
        @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(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,
        @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,
        @APPLICATIONBUSINESSUNITS xml,
        @TRANSACTIONCURRENCYID uniqueidentifier,
        @BASECURRENCYID uniqueidentifier,
        @BASEEXCHANGERATEID uniqueidentifier,
        @EXCHANGERATE decimal(20,8),
        @GENERATEREFERENCENUMBER bit
    )
as
begin
    declare @APPLYBYPERCENT bit = 0;

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

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_7
                    @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,
                    @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID,
                    @BASECURRENCYID = @BASECURRENCYID,
                    @BASEEXCHANGERATEID = @BASEEXCHANGERATEID,
                    @EXCHANGERATE = @EXCHANGERATE,
                    @GENERATEREFERENCENUMBER = @GENERATEREFERENCENUMBER,
          @APPLYBYPERCENT= @APPLYBYPERCENT;
end