USP_DATAFORMTEMPLATE_EDIT_DONATIONBATCHROW_2

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

Definition

Copy 


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DONATIONBATCHROW_2 
(
    @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

)
as
begin
  set nocount on;

  declare @BNUMBER nvarchar(100);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DONATIONBATCHROW
        @ID = @ID,
        @BNUMBER = @BNUMBER output

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