USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_11

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(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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_11
(
  @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
)
as
begin
    set nocount on;

    declare @VENDORID nvarchar(50) = '';
    declare @CLIENTAPPLICENSEID nvarchar(100);

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_2_REVENUEBATCHROW
        @ID = @ID,
        @VENDORID = @VENDORID output,
        @CLIENTAPPLICENSEID = @CLIENTAPPLICENSEID output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_12
        @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 = @VENDORID,
    @CLIENTAPPLICENSEID = @CLIENTAPPLICENSEID;
    return 0;
end