USP_DATAFORMTEMPLATE_EDIT_BATCHMEMBERSHIPDUESBATCHROW_5_V30

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SEQUENCE	int	IN
@BILLTOCONSTITUENTID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BASECURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@EXCHANGERATE	decimal(20, 8)	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	IN
@POSTSTATUSCODE	tinyint	IN
@POSTDATE	date	IN
@DUESTYPECODE	tinyint	IN
@MEMBERSHIPRECIPIENT	uniqueidentifier	IN
@RENEWALRECIPIENT	tinyint	IN
@EFFORTID	uniqueidentifier	IN
@FINDERNUMBER	nvarchar(19)	IN
@APPEALID	uniqueidentifier	IN
@CHANNELCODEID	uniqueidentifier	IN
@DATE	date	IN
@MEMBERSHIPTRANSACTIONTYPECODE	tinyint	IN
@REVENUETYPECODE	tinyint	IN
@PAYADDITIONALTONEXTINSTALLMENT	bit	IN
@PAYADDITIONALMONEYAMOUNT	money	IN
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN
@MEMBERSHIPLEVELID	uniqueidentifier	IN
@MEMBERSHIPLEVELTERMID	uniqueidentifier	IN
@MEMBERSHIPEXPIRESONDATE	date	IN
@MEMBERSHIPAMOUNT	money	IN
@MEMBERSHIPTRANSACTIONAMOUNT	money	IN
@EXISTINGMEMBERSHIPID	uniqueidentifier	IN
@MEMBERSHIPPLEDGEAMOUNT	money	IN
@CONTRIBUTORYDESIGNATIONID	uniqueidentifier	IN
@USEDISCOUNTRADIO	tinyint	IN
@DISCOUNTTYPE	uniqueidentifier	IN
@PROMOTIONCODE	nvarchar(50)	IN
@APPLIEDDISCOUNTID	uniqueidentifier	IN
@ADDDONATION	bit	IN
@DONATIONAMOUNT	money	IN
@GIVENANONYMOUSLY	bit	IN
@DONATIONOPPORTUNITYID	uniqueidentifier	IN
@DONATIONDESIGNATIONID	uniqueidentifier	IN
@DONATIONCATEGORYCODEID	uniqueidentifier	IN
@DECLINESGIFTAID	bit	IN
@PLEDGEFREQUENCYCODE	tinyint	IN
@PLEDGENUMBEROFINSTALLMENTS	int	IN
@PLEDGESTARTDATE	datetime	IN
@AUTOPAY	bit	IN
@SENDPLEDGEREMINDER	bit	IN
@CHECKDATE	UDT_FUZZYDATE	IN
@CHECKNUMBER	nvarchar(20)	IN
@REFERENCENUMBER	nvarchar(20)	IN
@REFERENCEDATE	UDT_FUZZYDATE	IN
@PAYMENTMETHODCODE	tinyint	IN
@DIRECTDEBITRESULTCODE	nvarchar(10)	IN
@DIRECTDEBITISREJECTED	bit	IN
@CONSTITUENTACCOUNTID	uniqueidentifier	IN
@REFERENCE	nvarchar(255)	IN
@AUTOMATICALLYRENEWMEMBERSHIP	bit	IN
@CREDITCARDID	uniqueidentifier	IN
@CREDITCARDNUMBER	nvarchar(20)	IN
@CREDITCARDTOKEN	uniqueidentifier	IN
@CARDHOLDERNAME	nvarchar(255)	IN
@EXPIRESON	UDT_FUZZYDATE	IN
@AUTHORIZATIONCODE	nvarchar(20)	IN
@REJECTIONMESSAGE	nvarchar(500)	IN
@CREDITTYPECODEID	uniqueidentifier	IN
@TRANSACTIONID	uniqueidentifier	IN
@PARTIALCREDITCARDNUMBER	nvarchar(4)	IN
@DONOTACKNOWLEDGE	bit	IN
@TAXDEDUCTIBLEAMOUNT	money	IN
@LETTERCODEID	uniqueidentifier	IN
@TRIBUTEID	uniqueidentifier	IN
@DONOTRECEIPT	bit	IN
@COMMENTS	nvarchar(255)	IN
@TOTALAMOUNT	money	IN
@EXISTINGMEMBERS	xml	IN
@EXISTINGCHILDREN	xml	IN
@MEMBERSHIPCARDS	xml	IN
@MEMBERSHIPRECOGNITION	xml	IN
@MEMBERSHIPPROGRAMADDON	xml	IN
@IMPORTADDON	xml	IN
@CAMPAIGNS	xml	IN
@SOLICITORS	xml	IN
@RECOGNITIONS	xml	IN
@BENEFITS	xml	IN
@PERCENTAGEBENEFITS	xml	IN
@INSTALLMENTS	xml	IN
@IMPORT	bit	IN
@NUMBEROFCHILDREN	smallint	IN
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN
@SOURCECODE	nvarchar(50)	IN
@MEMBERSHIPDECLINESGIFTAID	bit	IN
@DDISOURCECODEID	uniqueidentifier	IN
@DDISOURCEDATE	date	IN
@VENDORID	nvarchar(50)	IN
@MEMBERSHIPLEVELTYPECODEID	uniqueidentifier	IN
@CREDITCARDATTEMPTCOUNT	tinyint	IN
@NEWCONSTITUENT	xml	IN
@BBNCTRANID	int	IN
@ORIGINPAGEID	int	IN
@ORIGINPAGE	nvarchar(100)	IN
@BBNCID	int	IN
@BBISPROCESSORID	uniqueidentifier	IN
@NAMECODE	tinyint	IN
@SIMILARADDRESSCODE	tinyint	IN
@UNSIMILARADDRESSCODE	tinyint	IN
@NEWADDRESSENDDATECODE	tinyint	IN
@NEWADDRESSPRIMARYCODE	tinyint	IN
@BIRTHDATERULECODE	tinyint	IN
@DIFFERENTPHONECODE	tinyint	IN
@NEWPHONEENDDATECODE	tinyint	IN
@NEWPHONEPRIMARYCODE	tinyint	IN
@DIFFERENTEMAILCODE	tinyint	IN
@NEWEMAILENDDATECODE	tinyint	IN
@NEWEMAILPRIMARYCODE	tinyint	IN
@USEGLOBALSETTINGS	bit	IN
@CREATEHISTORICALNAMECODE	tinyint	IN
@SEPAMANDATEID	uniqueidentifier	IN
@ADDSEPAMANDATE	bit	IN
@SEPAMANDATECUSTOMIDENTIFIER	nvarchar(35)	IN
@SEPAMANDATESIGNATUREDATE	date	IN
@SEPAMANDATETYPECODE	tinyint	IN
@REQUIRECREDITCARDPROCESSING	bit	IN

Definition

Copy



create procedure USP_DATAFORMTEMPLATE_EDIT_BATCHMEMBERSHIPDUESBATCHROW_5_V30
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SEQUENCE int,
    @BILLTOCONSTITUENTID uniqueidentifier,
    @TRANSACTIONCURRENCYID uniqueidentifier,
    @BASECURRENCYID uniqueidentifier,
    @BASEEXCHANGERATEID uniqueidentifier,
    @EXCHANGERATE decimal(20,8),
    @PDACCOUNTSYSTEMID uniqueidentifier,
    @POSTSTATUSCODE tinyint,
    @POSTDATE date,
    @DUESTYPECODE tinyint,
    @MEMBERSHIPRECIPIENT uniqueidentifier,
    @RENEWALRECIPIENT tinyint,
    @EFFORTID uniqueidentifier,
    @FINDERNUMBER nvarchar(19),
    @APPEALID uniqueidentifier,
    @CHANNELCODEID uniqueidentifier,
    @DATE date,
    @MEMBERSHIPTRANSACTIONTYPECODE tinyint,
    @REVENUETYPECODE tinyint,
    @PAYADDITIONALTONEXTINSTALLMENT bit,
    @PAYADDITIONALMONEYAMOUNT money,
    @MEMBERSHIPPROGRAMID uniqueidentifier,
    @MEMBERSHIPLEVELID uniqueidentifier,
    @MEMBERSHIPLEVELTERMID uniqueidentifier,
    @MEMBERSHIPEXPIRESONDATE date,
    @MEMBERSHIPAMOUNT money,
    @MEMBERSHIPTRANSACTIONAMOUNT money,
    @EXISTINGMEMBERSHIPID uniqueidentifier,
    @MEMBERSHIPPLEDGEAMOUNT money,
    @CONTRIBUTORYDESIGNATIONID uniqueidentifier,
    @USEDISCOUNTRADIO tinyint,
    @DISCOUNTTYPE uniqueidentifier,
    @PROMOTIONCODE nvarchar(50),
    @APPLIEDDISCOUNTID uniqueidentifier,
    @ADDDONATION bit,
    @DONATIONAMOUNT money,
    @GIVENANONYMOUSLY bit,
    @DONATIONOPPORTUNITYID uniqueidentifier,
    @DONATIONDESIGNATIONID uniqueidentifier,
    @DONATIONCATEGORYCODEID uniqueidentifier,
    @DECLINESGIFTAID bit,
    @PLEDGEFREQUENCYCODE tinyint,
    @PLEDGENUMBEROFINSTALLMENTS int,
    @PLEDGESTARTDATE datetime,
    @AUTOPAY bit,
    @SENDPLEDGEREMINDER bit,
    @CHECKDATE dbo.UDT_FUZZYDATE,
    @CHECKNUMBER nvarchar(20),
    @REFERENCENUMBER nvarchar(20),
    @REFERENCEDATE dbo.UDT_FUZZYDATE,
    @PAYMENTMETHODCODE tinyint,
    @DIRECTDEBITRESULTCODE nvarchar(10),
    @DIRECTDEBITISREJECTED bit,
    @CONSTITUENTACCOUNTID uniqueidentifier,
    @REFERENCE nvarchar(255),
    @AUTOMATICALLYRENEWMEMBERSHIP bit,
    @CREDITCARDID uniqueidentifier,
    @CREDITCARDNUMBER nvarchar(20),
    @CREDITCARDTOKEN uniqueidentifier,
    @CARDHOLDERNAME nvarchar(255),
    @EXPIRESON dbo.UDT_FUZZYDATE,
    @AUTHORIZATIONCODE nvarchar(20),
    @REJECTIONMESSAGE nvarchar(500),
    @CREDITTYPECODEID uniqueidentifier,
    @TRANSACTIONID uniqueidentifier,
    @PARTIALCREDITCARDNUMBER nvarchar(4),
    @DONOTACKNOWLEDGE bit,
    @TAXDEDUCTIBLEAMOUNT money,
    @LETTERCODEID uniqueidentifier,
    @TRIBUTEID uniqueidentifier,
    @DONOTRECEIPT bit,
    @COMMENTS nvarchar(255),
    @TOTALAMOUNT money,
    @EXISTINGMEMBERS xml,
    @EXISTINGCHILDREN xml,
    @MEMBERSHIPCARDS xml,
    @MEMBERSHIPRECOGNITION xml,
    @MEMBERSHIPPROGRAMADDON xml,
    @IMPORTADDON xml,
    @CAMPAIGNS xml,
    @SOLICITORS xml,
    @RECOGNITIONS xml,
    @BENEFITS xml,
    @PERCENTAGEBENEFITS xml,
    @INSTALLMENTS xml,
    @IMPORT bit,
    @NUMBEROFCHILDREN smallint,
    @OTHERPAYMENTMETHODCODEID uniqueidentifier,
    @SOURCECODE nvarchar(50),
    @MEMBERSHIPDECLINESGIFTAID bit,
    @DDISOURCECODEID uniqueidentifier,
    @DDISOURCEDATE date,
    @VENDORID nvarchar(50),
    @MEMBERSHIPLEVELTYPECODEID uniqueidentifier,
    @CREDITCARDATTEMPTCOUNT tinyint,
    @NEWCONSTITUENT xml,
    @BBNCTRANID int,
    @ORIGINPAGEID int,
    @ORIGINPAGE nvarchar(100),
    @BBNCID int,
    @BBISPROCESSORID uniqueidentifier,
    @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,
    @SEPAMANDATEID uniqueidentifier,
    @ADDSEPAMANDATE bit,
    @SEPAMANDATECUSTOMIDENTIFIER nvarchar(35),
    @SEPAMANDATESIGNATUREDATE date,
    @SEPAMANDATETYPECODE tinyint,
    @REQUIRECREDITCARDPROCESSING bit
)

as
  set nocount on;

    declare @PAYOTHERAMOUNT money;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHMEMBERSHIPDUESBATCHROW
        @ID = @ID,
        @PAYOTHERAMOUNT = @PAYOTHERAMOUNT output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHMEMBERSHIPDUESBATCHROW_6
        @ID,
        @CURRENTAPPUSERID,
        @CHANGEAGENTID,
        @SEQUENCE,
        @BILLTOCONSTITUENTID,
        @TRANSACTIONCURRENCYID,
        @BASECURRENCYID,
        @BASEEXCHANGERATEID,
        @EXCHANGERATE,
        @PDACCOUNTSYSTEMID,
        @POSTSTATUSCODE,
        @POSTDATE,
        @DUESTYPECODE,
        @MEMBERSHIPRECIPIENT,
        @RENEWALRECIPIENT,
        @EFFORTID,
        @FINDERNUMBER,
        @APPEALID,
        @CHANNELCODEID,
        @DATE,
        @MEMBERSHIPTRANSACTIONTYPECODE,
        @REVENUETYPECODE,
        @PAYADDITIONALTONEXTINSTALLMENT,
        @PAYADDITIONALMONEYAMOUNT,
        @MEMBERSHIPPROGRAMID,
        @MEMBERSHIPLEVELID,
        @MEMBERSHIPLEVELTERMID,
        @MEMBERSHIPEXPIRESONDATE,
        @MEMBERSHIPAMOUNT,
        @MEMBERSHIPTRANSACTIONAMOUNT,
        @EXISTINGMEMBERSHIPID,
        @MEMBERSHIPPLEDGEAMOUNT,
        @CONTRIBUTORYDESIGNATIONID,
        @USEDISCOUNTRADIO,
        @DISCOUNTTYPE,
        @PROMOTIONCODE,
        @APPLIEDDISCOUNTID,
        @ADDDONATION,
        @DONATIONAMOUNT,
        @GIVENANONYMOUSLY,
        @DONATIONOPPORTUNITYID,
        @DONATIONDESIGNATIONID,
        @DONATIONCATEGORYCODEID,
        @DECLINESGIFTAID,
        @PLEDGEFREQUENCYCODE,
        @PLEDGENUMBEROFINSTALLMENTS,
        @PLEDGESTARTDATE,
        @AUTOPAY,
        @SENDPLEDGEREMINDER,
        @CHECKDATE,
        @CHECKNUMBER,
        @REFERENCENUMBER,
        @REFERENCEDATE,
        @PAYMENTMETHODCODE,
        @DIRECTDEBITRESULTCODE,
        @DIRECTDEBITISREJECTED,
        @CONSTITUENTACCOUNTID,
        @REFERENCE,
        @AUTOMATICALLYRENEWMEMBERSHIP,
        @CREDITCARDID,
        @CREDITCARDNUMBER,
        @CREDITCARDTOKEN,
        @CARDHOLDERNAME,
        @EXPIRESON,
        @AUTHORIZATIONCODE,
        @REJECTIONMESSAGE,
        @CREDITTYPECODEID,
        @TRANSACTIONID,
        @PARTIALCREDITCARDNUMBER,
        @DONOTACKNOWLEDGE,
        @TAXDEDUCTIBLEAMOUNT,
        @LETTERCODEID,
        @TRIBUTEID,
        @DONOTRECEIPT,
        @COMMENTS,
        @TOTALAMOUNT,
        @EXISTINGMEMBERS,
        @EXISTINGCHILDREN,
        @MEMBERSHIPCARDS,
        @MEMBERSHIPRECOGNITION,
        @MEMBERSHIPPROGRAMADDON,
        @IMPORTADDON,
        @CAMPAIGNS,
        @SOLICITORS,
        @RECOGNITIONS,
        @BENEFITS,
        @PERCENTAGEBENEFITS,
        @INSTALLMENTS,
        @IMPORT,
        @NUMBEROFCHILDREN,
        @OTHERPAYMENTMETHODCODEID,
        @SOURCECODE,
        @MEMBERSHIPDECLINESGIFTAID,
        @DDISOURCECODEID,
        @DDISOURCEDATE,
        @VENDORID,
        @MEMBERSHIPLEVELTYPECODEID,
        @CREDITCARDATTEMPTCOUNT,
        @NEWCONSTITUENT,
        @BBNCTRANID,
        @ORIGINPAGEID,
        @ORIGINPAGE,
        @BBNCID,
        @BBISPROCESSORID,
        @NAMECODE,
        @SIMILARADDRESSCODE,
        @UNSIMILARADDRESSCODE,
        @NEWADDRESSENDDATECODE,
        @NEWADDRESSPRIMARYCODE,
        @BIRTHDATERULECODE,
        @DIFFERENTPHONECODE,
        @NEWPHONEENDDATECODE,
        @NEWPHONEPRIMARYCODE,
        @DIFFERENTEMAILCODE,
        @NEWEMAILENDDATECODE,
        @NEWEMAILPRIMARYCODE,
        @USEGLOBALSETTINGS,
        @CREATEHISTORICALNAMECODE,
        @SEPAMANDATEID,
        @ADDSEPAMANDATE,
        @SEPAMANDATECUSTOMIDENTIFIER,
        @SEPAMANDATESIGNATUREDATE,
        @SEPAMANDATETYPECODE,
        @REQUIRECREDITCARDPROCESSING,
        @PAYOTHERAMOUNT

  return 0;