USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_7

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

Parameters

Parameter Parameter Type Mode Description
@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(4) 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(18) 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
@APPLICATIONBUSINESSUNITS xml IN
@TRANSACTIONCURRENCYID uniqueidentifier IN
@BASECURRENCYID uniqueidentifier IN
@BASEEXCHANGERATEID uniqueidentifier IN
@EXCHANGERATE decimal(20, 8) IN
@GENERATEREFERENCENUMBER bit IN
@APPLYBYPERCENT bit IN

Definition

Copy 


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_7
    (
        @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,
        @APPLYBYPERCENT bit = 0
    )
as
begin
    declare @SOURCECODEIMPORT nvarchar(60) = '';
    /* Only used for import so we just need to pass it through */

    declare @CURRENTBATCHROWID uniqueidentifier;
    declare @MERCHANTACCOUNTID uniqueidentifier;
    declare @SETNULLBASEEXCHANGERATETOLATEST bit;

      exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_2_REVENUEBATCHROW
        @ID = @ID,
        @CURRENTBATCHROWID = @CURRENTBATCHROWID output,
        @MERCHANTACCOUNTID = @MERCHANTACCOUNTID output,
        @SETNULLBASEEXCHANGERATETOLATEST = @SETNULLBASEEXCHANGERATETOLATEST output


    exec dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_8
                    @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,
                    @SOURCECODEIMPORT = @SOURCECODEIMPORT,
                    @CURRENTBATCHROWID = @CURRENTBATCHROWID,
                    @MERCHANTACCOUNTID = @MERCHANTACCOUNTID,
                    @SETNULLBASEEXCHANGERATETOLATEST = @SETNULLBASEEXCHANGERATETOLATEST;
end