USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_14

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_14
(
  @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(500),
  -- PARTIALCREDITCARDNUMBER is used to support import and 

  -- credit card - last 4 digits recurring gifts

  @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),
  @BBNCTRANSACTIONPROCESSORID uniqueidentifier,
  @BBNCORIGINAPPEALID uniqueidentifier,
  @BBNCTRANID int,
  @BBNCID int,
  @BBNCORIGINPAGENAME nvarchar(100),
  @BBNCORIGINPAGEID int, 
  @FINANCIALINSTITUTIONID uniqueidentifier,
  @ACCOUNTNUMBER nvarchar(50),
  @ACCOUNTTYPE tinyint,
  @ACCOUNTNAME nvarchar(100),
  @RECEIPTNUMBER nvarchar(30),
  @EMAILID int,
  @EMAILNAME nvarchar(510),
  @EMAILSUBJECT nvarchar(4000),
  @NAMECODE tinyint,
  @SIMILARADDRESSCODE tinyint,
  @UNSIMILARADDRESSCODE tinyint,
  @NEWADDRESSENDDATECODE tinyint,
  @NEWADDRESSPRIMARYCODE tinyint,
  @BIRTHDATERULECODE  tinyint,
  @DIFFERENTPHONECODE tinyint,
  @NEWPHONEENDDATECODE tinyint,
  @NEWPHONEPRIMARYCODE tinyint,
  @DIFFERENTEMAILCODE tinyint,
  @NEWEMAILENDDATECODE tinyint,
  @NEWEMAILPRIMARYCODE tinyint,
  @USEGLOBALSETTINGS bit,
  @CREATEHISTORICALNAMECODE tinyint,
  @RECEIPTSTACKSHORTNAME nvarchar(20),
  @MARKGIFTASRECEIPTED bit,
  @FIRSTPAYMENTPROCESSED nvarchar(10),
  @PAYMENTFORPLEDGERECEIPTAMOUNT money,
  @SEPAMANDATEID uniqueidentifier,
  @ADDSEPAMANDATE bit,
  @SEPAMANDATECUSTOMIDENTIFIER nvarchar(35),
  @SEPAMANDATESIGNATUREDATE date,
  @SEPAMANDATETYPECODE tinyint,
  @FINANCIALINSTITUTIONNAME nvarchar(100),
  @BANKINGSYSTEMID uniqueidentifier,
  @BRANCHNAME nvarchar(100),
  @ROUTINGNUMBER nvarchar(9),
  @SORTCODE nvarchar(6),
  @BIC nvarchar(11),
  @BANKCODE nvarchar(25),
  @INSTALLMENTAMOUNT money,
  @REQUIRECREDITCARDPROCESSING bit,
  @NOTEHTMLNOTE nvarchar(max)
)
as

  set nocount on;

  declare @IMPORT bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_2_REVENUEBATCHROW
    @ID = @ID,
    @IMPORT = @IMPORT output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_15
    @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,
    @BBNCORIGINAPPEALID,
    @BBNCTRANID,
    @BBNCID,
    @BBNCORIGINPAGENAME,
    @BBNCORIGINPAGEID, 
    @FINANCIALINSTITUTIONID,
    @ACCOUNTNUMBER,
    @ACCOUNTTYPE,
    @ACCOUNTNAME,
    @RECEIPTNUMBER,
    @EMAILID,
    @EMAILNAME,
    @EMAILSUBJECT,
    @NAMECODE,
    @SIMILARADDRESSCODE,
    @UNSIMILARADDRESSCODE,
    @NEWADDRESSENDDATECODE,
    @NEWADDRESSPRIMARYCODE,
    @BIRTHDATERULECODE,
    @DIFFERENTPHONECODE,
    @NEWPHONEENDDATECODE,
    @NEWPHONEPRIMARYCODE,
    @DIFFERENTEMAILCODE,
    @NEWEMAILENDDATECODE,
    @NEWEMAILPRIMARYCODE,
    @USEGLOBALSETTINGS,
    @CREATEHISTORICALNAMECODE,
    @RECEIPTSTACKSHORTNAME,
    @MARKGIFTASRECEIPTED,
    @FIRSTPAYMENTPROCESSED,
    @PAYMENTFORPLEDGERECEIPTAMOUNT,
    @SEPAMANDATEID,
    @ADDSEPAMANDATE,
    @SEPAMANDATECUSTOMIDENTIFIER,
    @SEPAMANDATESIGNATUREDATE,
    @SEPAMANDATETYPECODE,
    @FINANCIALINSTITUTIONNAME,
    @BANKINGSYSTEMID,
    @BRANCHNAME,
    @ROUTINGNUMBER,
    @SORTCODE,
    @BIC,
    @BANKCODE,
    @INSTALLMENTAMOUNT,
    @REQUIRECREDITCARDPROCESSING,
    @NOTEHTMLNOTE,
    @IMPORT = @IMPORT;
  return 0;