USP_DATAFORMTEMPLATE_EDIT_BATCHMEMBERSHIPDUESBATCHROW_3

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

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHMEMBERSHIPDUESBATCHROW_3
                (
                    @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,
                    --@NEWEVENTREGISTRATION bit,

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

                declare @CREDITCARDATTEMPTCOUNT uniqueidentifier;

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

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHMEMBERSHIPDUESBATCHROW_4
                    @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

                return 0;