USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_12

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
@SOURCECODEIMPORT nvarchar(60) IN
@CURRENTBATCHROWID uniqueidentifier IN
@MERCHANTACCOUNTID uniqueidentifier IN
@SETNULLBASEEXCHANGERATETOLATEST bit IN
@APPEALIDFORIMPORT uniqueidentifier IN
@SALE_LOWPRICE decimal(19, 4) IN
@SALE_MEDIANPRICE decimal(19, 4) IN
@SALE_HIGHPRICE decimal(19, 4) IN
@CREDITCARDATTEMPTCOUNT tinyint IN
@VENDORID nvarchar(50) IN
@CLIENTAPPLICENSEID nvarchar(100) IN

Definition

Copy 


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_12
(
  @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,
  @SOURCECODEIMPORT nvarchar(60),
  @CURRENTBATCHROWID uniqueidentifier,
  @MERCHANTACCOUNTID uniqueidentifier,
  @SETNULLBASEEXCHANGERATETOLATEST bit,
  @APPEALIDFORIMPORT uniqueidentifier,
  @SALE_LOWPRICE decimal(19,4),
  @SALE_MEDIANPRICE decimal(19,4),
  @SALE_HIGHPRICE decimal(19,4),
  @CREDITCARDATTEMPTCOUNT tinyint,
  @VENDORID nvarchar(50),
  @CLIENTAPPLICENSEID nvarchar(100)
)
as
begin
  set nocount on;

  declare @BBNCTRANSACTIONPROCESSORID uniqueidentifier;
  declare @BBNCORIGINAPPEALID uniqueidentifier;
  declare @BBNCTRANID int;
  declare @BBNCID int;
  declare @BBNCORIGINPAGENAME nvarchar(100);
  declare @BBNCORIGINPAGEID int; 
  declare @FINANCIALINSTITUTIONID uniqueidentifier;
  declare @ACCOUNTNUMBER nvarchar(17);
  declare @ACCOUNTTYPE tinyint;
  declare @ACCOUNTNAME nvarchar(100);
  declare @RECEIPTNUMBER nvarchar(10);
  declare @EMAILID int;
  declare @EMAILNAME nvarchar(510);
  declare @EMAILSUBJECT nvarchar(4000);
  declare @NAMECODE tinyint;
  declare @SIMILARADDRESSCODE tinyint;
  declare @UNSIMILARADDRESSCODE tinyint;
  declare @NEWADDRESSENDDATECODE tinyint;
  declare @NEWADDRESSPRIMARYCODE tinyint;
  declare @BIRTHDATERULECODE  tinyint;
  declare @DIFFERENTPHONECODE tinyint;
  declare @NEWPHONEENDDATECODE tinyint;
  declare @NEWPHONEPRIMARYCODE tinyint;
  declare @DIFFERENTEMAILCODE tinyint;
  declare @NEWEMAILENDDATECODE tinyint;
  declare @NEWEMAILPRIMARYCODE tinyint;
  declare @USEGLOBALSETTINGS bit;
  declare @CREATEHISTORICALNAMECODE tinyint;
  declare @RECEIPTSTACKSHORTNAME nvarchar(20);
  declare @MARKGIFTASRECEIPTED bit;
  declare @FIRSTPAYMENTPROCESSED nvarchar(10);
  declare @PAYMENTFORPLEDGERECEIPTAMOUNT money;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_2_REVENUEBATCHROW
        @ID = @ID,
    @BBNCTRANSACTIONPROCESSORID = @BBNCTRANSACTIONPROCESSORID output,
    @BBNCORIGINAPPEALID = @BBNCORIGINAPPEALID output,
    @BBNCTRANID = @BBNCTRANID output,
    @BBNCID = @BBNCID output,
    @BBNCORIGINPAGENAME = @BBNCORIGINPAGENAME output,
    @BBNCORIGINPAGEID = @BBNCORIGINPAGEID output, 
    @FINANCIALINSTITUTIONID = @FINANCIALINSTITUTIONID output,
    @ACCOUNTNUMBER = @ACCOUNTNUMBER output,
    @ACCOUNTTYPE = @ACCOUNTTYPE output,
    @ACCOUNTNAME = @ACCOUNTNAME output,
    @RECEIPTNUMBER = @RECEIPTNUMBER output,
    @EMAILID = @EMAILID output,
    @EMAILNAME = @EMAILNAME output,
    @EMAILSUBJECT = @EMAILSUBJECT output,
    @NAMECODE = @NAMECODE output,
    @SIMILARADDRESSCODE = @SIMILARADDRESSCODE output,
    @UNSIMILARADDRESSCODE = @UNSIMILARADDRESSCODE output,
    @NEWADDRESSENDDATECODE = @NEWADDRESSENDDATECODE output,
    @NEWADDRESSPRIMARYCODE = @NEWADDRESSPRIMARYCODE output,
    @BIRTHDATERULECODE  = @BIRTHDATERULECODE output,
    @DIFFERENTPHONECODE = @DIFFERENTPHONECODE output,
    @NEWPHONEENDDATECODE = @NEWPHONEENDDATECODE output,
    @NEWPHONEPRIMARYCODE = @NEWPHONEPRIMARYCODE output,
    @DIFFERENTEMAILCODE = @DIFFERENTEMAILCODE output,
    @NEWEMAILENDDATECODE = @NEWEMAILENDDATECODE output,
    @NEWEMAILPRIMARYCODE = @NEWEMAILPRIMARYCODE output,
    @USEGLOBALSETTINGS = @USEGLOBALSETTINGS output,
    @CREATEHISTORICALNAMECODE = @CREATEHISTORICALNAMECODE output,
    @RECEIPTSTACKSHORTNAME = @RECEIPTSTACKSHORTNAME output,
    @MARKGIFTASRECEIPTED = @MARKGIFTASRECEIPTED output,
    @FIRSTPAYMENTPROCESSED = @FIRSTPAYMENTPROCESSED output,
    @PAYMENTFORPLEDGERECEIPTAMOUNT = @PAYMENTFORPLEDGERECEIPTAMOUNT output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_13
        @ID,
        @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,
        @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,
        @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,
        @APPLICATIONBUSINESSUNITS,
        @TRANSACTIONCURRENCYID,
        @BASECURRENCYID,
        @BASEEXCHANGERATEID,
        @EXCHANGERATE,
        @GENERATEREFERENCENUMBER,
        @APPLYBYPERCENT,
        @SOURCECODEIMPORT,
        @CURRENTBATCHROWID,
        @MERCHANTACCOUNTID,
        @SETNULLBASEEXCHANGERATETOLATEST,
        @APPEALIDFORIMPORT,
        @SALE_LOWPRICE,
        @SALE_MEDIANPRICE,
        @SALE_HIGHPRICE,
        @CREDITCARDATTEMPTCOUNT,
        @VENDORID,
    @CLIENTAPPLICENSEID,
    @BBNCTRANSACTIONPROCESSORID = @BBNCTRANSACTIONPROCESSORID,
    @BBNCORIGINAPPEALID = @BBNCORIGINAPPEALID,
    @BBNCTRANID = @BBNCTRANID,
    @BBNCID = @BBNCID,
    @BBNCORIGINPAGENAME = @BBNCORIGINPAGENAME,
    @BBNCORIGINPAGEID = @BBNCORIGINPAGEID, 
    @FINANCIALINSTITUTIONID = @FINANCIALINSTITUTIONID,
    @ACCOUNTNUMBER = @ACCOUNTNUMBER,
    @ACCOUNTTYPE = @ACCOUNTTYPE,
    @ACCOUNTNAME = @ACCOUNTNAME,
    @RECEIPTNUMBER = @RECEIPTNUMBER,
    @EMAILID = @EMAILID,
    @EMAILNAME = @EMAILNAME,
    @EMAILSUBJECT = @EMAILSUBJECT,
    @NAMECODE = @NAMECODE,
    @SIMILARADDRESSCODE = @SIMILARADDRESSCODE,
    @UNSIMILARADDRESSCODE = @UNSIMILARADDRESSCODE,
    @NEWADDRESSENDDATECODE = @NEWADDRESSENDDATECODE,
    @NEWADDRESSPRIMARYCODE = @NEWADDRESSPRIMARYCODE,
    @BIRTHDATERULECODE  = @BIRTHDATERULECODE,
    @DIFFERENTPHONECODE = @DIFFERENTPHONECODE,
    @NEWPHONEENDDATECODE = @NEWPHONEENDDATECODE,
    @NEWPHONEPRIMARYCODE = @NEWPHONEPRIMARYCODE,
    @DIFFERENTEMAILCODE = @DIFFERENTEMAILCODE,
    @NEWEMAILENDDATECODE = @NEWEMAILENDDATECODE,
    @NEWEMAILPRIMARYCODE = @NEWEMAILPRIMARYCODE,
    @USEGLOBALSETTINGS = @USEGLOBALSETTINGS,
    @CREATEHISTORICALNAMECODE = @CREATEHISTORICALNAMECODE,
    @RECEIPTSTACKSHORTNAME = @RECEIPTSTACKSHORTNAME,
    @MARKGIFTASRECEIPTED = @MARKGIFTASRECEIPTED,
    @FIRSTPAYMENTPROCESSED = @FIRSTPAYMENTPROCESSED,
    @PAYMENTFORPLEDGERECEIPTAMOUNT = @PAYMENTFORPLEDGERECEIPTAMOUNT;
  return 0;    
end;