USP_DATAFORMTEMPLATE_EDIT_BATCHMEMBERSHIPDUESBATCHROW_4

Parameters

Parameter Parameter Type Mode Description
@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(100) 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

Definition

Copy 


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHMEMBERSHIPDUESBATCHROW_4
(
    @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,        -- 0 = Add, 1 = Renew, 2 = Pay, 3 = Upgrade

    @REVENUETYPECODE tinyint,                      -- 0 = Pay in full, 1 = Pay first/next installment, 2 = Pledge

    @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(100),
    @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,       -- Temporary workaround for children not being implemented in 2012 Q1

    @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
)
as
set nocount on;

declare @SEPAMANDATEID uniqueidentifier;
declare @ADDSEPAMANDATE bit;
declare @SEPAMANDATECUSTOMIDENTIFIER nvarchar(35);
declare @SEPAMANDATESIGNATUREDATE date;
declare @SEPAMANDATETYPECODE tinyint;


exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHMEMBERSHIPDUESBATCHROW
    @ID = @ID,
    @SEPAMANDATEID = @SEPAMANDATEID output,
    @ADDSEPAMANDATE = @ADDSEPAMANDATE output,
    @SEPAMANDATECUSTOMIDENTIFIER = @SEPAMANDATECUSTOMIDENTIFIER output,
    @SEPAMANDATESIGNATUREDATE = @SEPAMANDATESIGNATUREDATE output,
    @SEPAMANDATETYPECODE = @SEPAMANDATETYPECODE output

exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHMEMBERSHIPDUESBATCHROW_5
    @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,       -- Temporary workaround for children not being implemented in 2012 Q1

    @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

return 0;