USP_DATAFORMTEMPLATE_EDIT_DONATIONBATCHROW_3

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@SEQUENCE int IN
@EVENTID uniqueidentifier IN
@USERID nvarchar(100) IN
@PASSWORD nvarchar(500) IN
@LASTNAME nvarchar(100) IN
@FIRSTNAME nvarchar(100) IN
@MIDDLENAME nvarchar(100) IN
@TITLECODEID uniqueidentifier IN
@SUFFIXCODEID uniqueidentifier IN
@NICKNAME nvarchar(100) IN
@MAIDENNAME nvarchar(200) IN
@BIRTHDATE UDT_FUZZYDATE IN
@GENDERCODE int IN
@MARITALSTATUSCODEID uniqueidentifier IN
@ADDRESSTYPECODEID uniqueidentifier IN
@COUNTRYID uniqueidentifier IN
@ADDRESS nvarchar(300) IN
@CITY nvarchar(100) IN
@STATEID uniqueidentifier IN
@POSTCODE nvarchar(24) IN
@DONOTMAIL bit IN
@DONOTMAILREASONCODEID uniqueidentifier IN
@PHONETYPECODEID uniqueidentifier IN
@PHONENUMBER nvarchar(200) IN
@EMAILADDRESS UDT_EMAILADDRESS IN
@ISCOMPANYGIFT bit IN
@COMPANYNAME nvarchar(200) IN
@COMPANYURL UDT_WEBADDRESS IN
@COMPANY_ADDRESSTYPECODEID uniqueidentifier IN
@COMPANY_COUNTRYID uniqueidentifier IN
@COMPANY_ADDRESS nvarchar(300) IN
@COMPANY_CITY nvarchar(100) IN
@COMPANY_STATEID uniqueidentifier IN
@COMPANY_POSTCODE nvarchar(24) IN
@COMPANY_DONOTMAIL bit IN
@COMPANY_DONOTMAILREASONCODEID uniqueidentifier IN
@COMPANY_PHONETYPECODEID uniqueidentifier IN
@COMPANY_PHONENUMBER nvarchar(200) IN
@COMPANY_EMAILADDRESS UDT_EMAILADDRESS IN
@GIFTTYPE nvarchar(100) IN
@GIFTAMOUNT money IN
@NUMPAYMENTS int IN
@FREQUENCY nvarchar(200) IN
@AUTOINSTALLMENTS bit IN
@ANONYMOUS bit IN
@STARTDATE UDT_FUZZYDATE IN
@INFINITEGIFT bit IN
@PAYMENTMETHODCODE int IN
@CREDITCARDHOLDER nvarchar(200) IN
@CREDITCARDNUMBER nvarchar(200) IN
@CREDITCARDTYPE uniqueidentifier IN
@EXPIRATIONDATE UDT_FUZZYDATE IN
@CREDITCARDTOKEN uniqueidentifier IN
@CREDITCARDID uniqueidentifier IN
@AUTHORIZATIONCODE nvarchar(20) IN
@TRANSACTIONID uniqueidentifier IN
@REJECTIONMESSAGE nvarchar(250) IN
@TYPECODE tinyint IN
@AMOUNT money IN
@CONSTITUENTID uniqueidentifier IN
@CHECKDATE UDT_FUZZYDATE IN
@CHECKNUMBER nvarchar(40) IN
@BANKACCOUNTTYPECODE int IN
@BANKACCOUNTHOLDER nvarchar(200) IN
@BANKACCOUNTNUMBER nvarchar(200) IN
@BANKACCOUNTROUTINGCODE nvarchar(200) IN
@SAMEASPRIMARYADDRESS bit IN
@BILLING_ADDRESSTYPECODEID uniqueidentifier IN
@BILLING_COUNTRYID uniqueidentifier IN
@BILLING_ADDRESSBLOCK nvarchar(300) IN
@BILLING_CITY nvarchar(100) IN
@BILLING_STATEID uniqueidentifier IN
@BILLING_POSTCODE nvarchar(24) IN
@BILLING_STATE nvarchar(10) IN
@BILLING_COUNTRY nvarchar(4) IN
@SAVETRIBUTEEASCONSTITUENT bit IN
@SHOWTRIBUTE bit IN
@TRIBUTEFIRSTNAME nvarchar(400) IN
@TRIBUTELASTNAME nvarchar(400) IN
@TRIBUTEEMAIL UDT_EMAILADDRESS IN
@TRIBUTEADDRESS nvarchar(600) IN
@TRIBUTECITY nvarchar(200) IN
@TRIBUTEPOSTCODE nvarchar(48) IN
@TRIBUTESTATEID uniqueidentifier IN
@TRIBUTETYPECODEID uniqueidentifier IN
@TRIBUTETEXT nvarchar(500) IN
@TRIBUTEANONYMOUS bit IN
@ACKNOWLEDGEFIRSTNAME nvarchar(400) IN
@ACKNOWLEDGELASTNAME nvarchar(400) IN
@ACKNOWLEDGEEMAIL UDT_EMAILADDRESS IN
@MESSAGETOACKNOWLEDGE nvarchar(2000) IN
@RECOGNITIONCREDIT nvarchar(100) IN
@MATCHINGCOMPANYNAME nvarchar(400) IN
@MATCHINGAMOUNT money IN
@RECIPIENTGROUPID uniqueidentifier IN
@RECIPIENTREGISTRANTID uniqueidentifier IN
@RECIPIENTROLE nvarchar(200) IN
@SENDTOACKNOWLEDGE bit IN
@ORIGINALCLIENTUSERID int IN
@ORIGINALCONSTITUENTID uniqueidentifier IN
@PHONEID uniqueidentifier IN
@ADDRESSID uniqueidentifier IN
@EMAILADDRESSID uniqueidentifier IN
@ORGANIZATIONCONSTITUENTID uniqueidentifier IN
@MERCHANTACCOUNTID uniqueidentifier IN
@CHANGEAGENTID uniqueidentifier IN
@SUBSCRIBEDNEWSLETTERIDS xml IN
@SENDNOTIFICATIONS bit IN
@BNUMBER nvarchar(100) IN

Definition

Copy 


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DONATIONBATCHROW_3
(
    @ID uniqueidentifier,
    @SEQUENCE int,
    @EVENTID uniqueidentifier,
    @USERID nvarchar(100),
    @PASSWORD nvarchar(500),
    @LASTNAME nvarchar(100),
    @FIRSTNAME nvarchar(100),
    @MIDDLENAME nvarchar(100),
    @TITLECODEID uniqueidentifier,
    @SUFFIXCODEID uniqueidentifier,
    @NICKNAME nvarchar(100),
    @MAIDENNAME nvarchar(200),
    @BIRTHDATE UDT_FUZZYDATE,
    @GENDERCODE int,
    @MARITALSTATUSCODEID uniqueidentifier,
    @ADDRESSTYPECODEID uniqueidentifier,
    @COUNTRYID uniqueidentifier,
    @ADDRESS nvarchar(300),
    @CITY nvarchar(100),
    @STATEID uniqueidentifier,
    @POSTCODE nvarchar(24),
    @DONOTMAIL bit,
    @DONOTMAILREASONCODEID uniqueidentifier,
    @PHONETYPECODEID uniqueidentifier,
    @PHONENUMBER nvarchar(200),
    @EMAILADDRESS UDT_EMAILADDRESS,
    @ISCOMPANYGIFT bit,
    @COMPANYNAME nvarchar(200),
    @COMPANYURL UDT_WEBADDRESS,
    @COMPANY_ADDRESSTYPECODEID uniqueidentifier,
    @COMPANY_COUNTRYID uniqueidentifier,
    @COMPANY_ADDRESS nvarchar(300),
    @COMPANY_CITY nvarchar(100),
    @COMPANY_STATEID uniqueidentifier,
    @COMPANY_POSTCODE nvarchar(24),
    @COMPANY_DONOTMAIL bit,
    @COMPANY_DONOTMAILREASONCODEID uniqueidentifier,
    @COMPANY_PHONETYPECODEID uniqueidentifier,
    @COMPANY_PHONENUMBER nvarchar(200),
    @COMPANY_EMAILADDRESS UDT_EMAILADDRESS,
    @GIFTTYPE nvarchar(100),
    @GIFTAMOUNT money,
    @NUMPAYMENTS int,
    @FREQUENCY nvarchar(200),
    @AUTOINSTALLMENTS bit,
    @ANONYMOUS bit,
    @STARTDATE UDT_FUZZYDATE,
    @INFINITEGIFT bit,
    @PAYMENTMETHODCODE int,
    @CREDITCARDHOLDER nvarchar(200),
    @CREDITCARDNUMBER nvarchar(200),
    @CREDITCARDTYPE uniqueidentifier,
    @EXPIRATIONDATE UDT_FUZZYDATE,
    @CREDITCARDTOKEN uniqueidentifier,
    @CREDITCARDID uniqueidentifier,
    @AUTHORIZATIONCODE nvarchar(20),
    @TRANSACTIONID uniqueidentifier,
    @REJECTIONMESSAGE nvarchar(250),
    @TYPECODE tinyint,
    @AMOUNT money,
    @CONSTITUENTID uniqueidentifier,
    @CHECKDATE UDT_FUZZYDATE,
    @CHECKNUMBER nvarchar(40),
    @BANKACCOUNTTYPECODE int,
    @BANKACCOUNTHOLDER nvarchar(200),
    @BANKACCOUNTNUMBER nvarchar(200),
    @BANKACCOUNTROUTINGCODE nvarchar(200),
    @SAMEASPRIMARYADDRESS bit,
    @BILLING_ADDRESSTYPECODEID uniqueidentifier,
    @BILLING_COUNTRYID uniqueidentifier,
    @BILLING_ADDRESSBLOCK nvarchar(300),
    @BILLING_CITY nvarchar(100),
    @BILLING_STATEID uniqueidentifier,
    @BILLING_POSTCODE nvarchar(24),
    @BILLING_STATE nvarchar(10),
    @BILLING_COUNTRY nvarchar(4),
    @SAVETRIBUTEEASCONSTITUENT bit,
    @SHOWTRIBUTE bit,
    @TRIBUTEFIRSTNAME nvarchar(400),
    @TRIBUTELASTNAME nvarchar(400),
    @TRIBUTEEMAIL UDT_EMAILADDRESS,
    @TRIBUTEADDRESS nvarchar(600),
    @TRIBUTECITY nvarchar(200),
    @TRIBUTEPOSTCODE nvarchar(48),
    @TRIBUTESTATEID uniqueidentifier,
    @TRIBUTETYPECODEID uniqueidentifier,
    @TRIBUTETEXT nvarchar(500),
    @TRIBUTEANONYMOUS bit,
    @ACKNOWLEDGEFIRSTNAME nvarchar(400),
    @ACKNOWLEDGELASTNAME nvarchar(400),
    @ACKNOWLEDGEEMAIL UDT_EMAILADDRESS,
    @MESSAGETOACKNOWLEDGE nvarchar(2000),
    @RECOGNITIONCREDIT nvarchar(100),
    @MATCHINGCOMPANYNAME nvarchar(400),
    @MATCHINGAMOUNT money,
    @RECIPIENTGROUPID uniqueidentifier,
    @RECIPIENTREGISTRANTID uniqueidentifier,
    @RECIPIENTROLE nvarchar(200),
    @SENDTOACKNOWLEDGE bit,
    @ORIGINALCLIENTUSERID integer,
    @ORIGINALCONSTITUENTID uniqueidentifier,
    @PHONEID uniqueidentifier,
    @ADDRESSID uniqueidentifier,
    @EMAILADDRESSID uniqueidentifier,
    @ORGANIZATIONCONSTITUENTID uniqueidentifier,
    @MERCHANTACCOUNTID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = NULL,
    @SUBSCRIBEDNEWSLETTERIDS xml,
    @SENDNOTIFICATIONS bit,
    @BNUMBER nvarchar(100) 
)
as
begin
    set nocount on;

    declare @VENDORID nvarchar(50) = ''
    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DONATIONBATCHROW
        @ID = @ID,
        @VENDORID = @VENDORID output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_DONATIONBATCHROW_4
        @ID,
        @SEQUENCE,
        @EVENTID,
        @USERID,
        @PASSWORD,
        @LASTNAME,
        @FIRSTNAME,
        @MIDDLENAME,
        @TITLECODEID,
        @SUFFIXCODEID,
        @NICKNAME,
        @MAIDENNAME,
        @BIRTHDATE,
        @GENDERCODE,
        @MARITALSTATUSCODEID,
        @ADDRESSTYPECODEID,
        @COUNTRYID,
        @ADDRESS,
        @CITY,
        @STATEID,
        @POSTCODE,
        @DONOTMAIL,
        @DONOTMAILREASONCODEID,
        @PHONETYPECODEID,
        @PHONENUMBER,
        @EMAILADDRESS,
        @ISCOMPANYGIFT,
        @COMPANYNAME,
        @COMPANYURL,
        @COMPANY_ADDRESSTYPECODEID,
        @COMPANY_COUNTRYID,
        @COMPANY_ADDRESS,
        @COMPANY_CITY,
        @COMPANY_STATEID,
        @COMPANY_POSTCODE,
        @COMPANY_DONOTMAIL,
        @COMPANY_DONOTMAILREASONCODEID,
        @COMPANY_PHONETYPECODEID,
        @COMPANY_PHONENUMBER,
        @COMPANY_EMAILADDRESS,
        @GIFTTYPE,
        @GIFTAMOUNT,
        @NUMPAYMENTS,
        @FREQUENCY,
        @AUTOINSTALLMENTS,
        @ANONYMOUS,
        @STARTDATE,
        @INFINITEGIFT,
        @PAYMENTMETHODCODE,
        @CREDITCARDHOLDER,
        @CREDITCARDNUMBER,
        @CREDITCARDTYPE,
        @EXPIRATIONDATE,
        @CREDITCARDTOKEN,
        @CREDITCARDID,
        @AUTHORIZATIONCODE,
        @TRANSACTIONID,
        @REJECTIONMESSAGE,
        @TYPECODE,
        @AMOUNT,
        @CONSTITUENTID,
        @CHECKDATE,
        @CHECKNUMBER,
        @BANKACCOUNTTYPECODE,
        @BANKACCOUNTHOLDER,
        @BANKACCOUNTNUMBER,
        @BANKACCOUNTROUTINGCODE,
        @SAMEASPRIMARYADDRESS,
        @BILLING_ADDRESSTYPECODEID,
        @BILLING_COUNTRYID,
        @BILLING_ADDRESSBLOCK,
        @BILLING_CITY,
        @BILLING_STATEID,
        @BILLING_POSTCODE,
        @BILLING_STATE,
        @BILLING_COUNTRY,
        @SAVETRIBUTEEASCONSTITUENT ,
        @SHOWTRIBUTE ,
        @TRIBUTEFIRSTNAME,
        @TRIBUTELASTNAME,
        @TRIBUTEEMAIL,
        @TRIBUTEADDRESS,
        @TRIBUTECITY,
        @TRIBUTEPOSTCODE,
        @TRIBUTESTATEID,
        @TRIBUTETYPECODEID,
        @TRIBUTETEXT,
        @TRIBUTEANONYMOUS,
        @ACKNOWLEDGEFIRSTNAME,
        @ACKNOWLEDGELASTNAME,
        @ACKNOWLEDGEEMAIL,
        @MESSAGETOACKNOWLEDGE,
        @RECOGNITIONCREDIT,
        @MATCHINGCOMPANYNAME,
        @MATCHINGAMOUNT,
        @RECIPIENTGROUPID,
        @RECIPIENTREGISTRANTID,
        @RECIPIENTROLE,
        @SENDTOACKNOWLEDGE,
        @ORIGINALCLIENTUSERID,
        @ORIGINALCONSTITUENTID,
        @PHONEID,
        @ADDRESSID,
        @EMAILADDRESSID,
        @ORGANIZATIONCONSTITUENTID,
        @MERCHANTACCOUNTID,
        @CHANGEAGENTID,
        @SUBSCRIBEDNEWSLETTERIDS,
        @SENDNOTIFICATIONS,
        @BNUMBER,
        @VENDORID
end