USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_8

The save procedure used by the edit dataform template "Revenue Batch Row 2 Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@TYPECODE	tinyint	IN	Revenue type
@DATE	datetime	IN	Date
@AMOUNT	money	IN	Amount
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@CHECKDATE	UDT_FUZZYDATE	IN	Check date
@CHECKNUMBER	nvarchar(20)	IN	Check number
@REFERENCEDATE	UDT_FUZZYDATE	IN	Reference date
@REFERENCENUMBER	nvarchar(20)	IN	Reference number
@CARDHOLDERNAME	nvarchar(255)	IN	Name on card
@CREDITCARDNUMBER	nvarchar(20)	IN	Card number
@CREDITTYPECODEID	uniqueidentifier	IN	Card type
@AUTHORIZATIONCODE	nvarchar(20)	IN	Authorization code
@EXPIRESON	UDT_FUZZYDATE	IN	Expires on
@ISSUER	nvarchar(100)	IN	Issuer
@NUMBEROFUNITS	decimal(20, 3)	IN	Stock number of units
@SYMBOL	nvarchar(4)	IN	Symbol
@MEDIANPRICE	decimal(19, 4)	IN	Median price
@PROPERTYSUBTYPECODEID	uniqueidentifier	IN	Property subtype
@GIFTINKINDSUBTYPECODEID	uniqueidentifier	IN	Gift-in-kind subtype
@RECEIPTAMOUNT	money	IN	Receipt amount
@DONOTRECEIPT	bit	IN	Do not receipt
@CONSTITUENTACCOUNTID	uniqueidentifier	IN	Account
@SPLITS	xml	IN	Designations
@SINGLEDESIGNATIONID	uniqueidentifier	IN	Designation
@REVENUESTREAMS	xml	IN	Revenue streams
@APPLYTOSHOWNFORCONSTITUENTID	uniqueidentifier	IN	Apply to shown for constituent
@SEQUENCE	int	IN	Sequence
@INSTALLMENTFREQUENCYCODE	tinyint	IN	Installment frequency
@INSTALLMENTSTARTDATE	datetime	IN	Installment start date
@INSTALLMENTENDDATE	datetime	IN	Installment end date
@NUMBEROFINSTALLMENTS	int	IN	No. installments
@SOLICITORS	xml	IN	Solicitors
@BENEFITS	xml	IN	Money benefits
@FINDERNUMBER	bigint	IN	Finder number
@SOURCECODE	nvarchar(60)	IN	Source code
@APPEALID	uniqueidentifier	IN	Appeal
@FINDERNUMBERISVALID	bit	IN	Finder number is valid
@USERMODIFIEDBENEFITS	bit	IN	User modified benefits
@BENEFITSWAIVED	bit	IN	User waived benefits
@POSTDATE	datetime	IN	GL post date
@POSTSTATUSCODE	tinyint	IN	GL post status
@SENDPLEDGEREMINDER	bit	IN	Send reminders
@SALEDATE	datetime	IN	Sale date
@SALEAMOUNT	money	IN	Sale amount
@BROKERFEE	money	IN	Sale fees
@SALEPOSTSTATUSCODE	tinyint	IN	Sale GL post status
@SALEPOSTDATE	datetime	IN	Sale GL post date
@NOTETITLE	nvarchar(50)	IN	Note Title
@NOTEAUTHORID	uniqueidentifier	IN	Note Author
@NOTEDATEENTERED	datetime	IN	Note Date
@NOTETYPECODEID	uniqueidentifier	IN	Note Type
@NOTETEXTNOTE	nvarchar(max)	IN	Notes
@GIVENANONYMOUSLY	bit	IN	Given anonymously
@GIVENANONYMOUSLYDEFAULTEDFORCONSTITUENTID	uniqueidentifier	IN	Given anonymously defaulted for constituent
@USERMODIFIEDRECEIPTAMOUNT	bit	IN	User modified receipt amount
@PLEDGESUBTYPEID	uniqueidentifier	IN	Pledge subtype
@REJECTIONCODEID	uniqueidentifier	IN	Rejection code
@CONSTITUENTLOOKUPID	uniqueidentifier	IN	Lookup ID
@MAILINGID	uniqueidentifier	IN	Effort
@CHANNELCODEID	uniqueidentifier	IN	Inbound channel
@INSTALLMENTS	xml	IN	Installments
@PAYMENTFORPLEDGEAMOUNT	money	IN	Payment for pledge amount
@RECOGNITIONS	xml	IN	Recognition credits
@DIDRECOGNITIONSDEFAULT	bit	IN	Did default recognition credits
@TRIBUTES	xml	IN	Tributes
@UNAPPLIEDMATCHINGGIFTSPLITS	xml	IN	Unapplied MG Split
@UNAPPLIEDMATCHINGGIFTAMOUNT	money	IN	Applied
@RECEIPTTYPECODE	tinyint	IN	Receipt type
@NEWCONSTITUENT	xml	IN	New constituent
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN	Other method
@LETTERCODEID	uniqueidentifier	IN	Letter
@ACKNOWLEDGEDATE	datetime	IN	Acknowledge date
@REFERENCE	nvarchar(255)	IN	Reference
@CATEGORYCODEID	uniqueidentifier	IN	Revenue category
@ACKNOWLEDGEEID	uniqueidentifier	IN	Acknowledgee
@APPLICATIONINFO	nvarchar(60)	IN	Application
@OTHERTYPECODEID	uniqueidentifier	IN	Other type
@OPPORTUNITYID	uniqueidentifier	IN	Opportunity
@DIRECTDEBITRESULTCODE	nvarchar(10)	IN	Result code
@LOWPRICE	decimal(19, 4)	IN	Low price
@HIGHPRICE	decimal(19, 4)	IN	High price
@NUMBEROFUNITSSOLD	decimal(20, 3)	IN	Stock sale number of units
@USERMODIFIEDNUMBEROFUNITSSOLD	bit	IN	User modified stock number of units sold
@CREDITCARDTOKEN	uniqueidentifier	IN	Credit card token
@REJECTIONMESSAGE	nvarchar(250)	IN	Rejection message
@PARTIALCREDITCARDNUMBER	nvarchar(4)	IN	Partial card number
@TAXDECLARATIONS	xml	IN	Declarations
@STANDINGORDERCONSTITUENTACCOUNTID	uniqueidentifier	IN	Standing order account
@STANDINGORDERREFERENCENUMBER	nvarchar(18)	IN	Standing order reference number
@STANDINGORDERREFERENCEDATE	UDT_FUZZYDATE	IN	Standing order reference date
@STANDINGORDERSETUP	bit	IN	Standing order has been setup
@STANDINGORDERSETUPDATE	datetime	IN	Standing order setup date
@TRANSACTIONID	uniqueidentifier	IN	Transaction ID
@ISTRANSIENTCARD	bit	IN	Is transient credit card
@DECLINESGIFTAID	bit	IN	Declines Gift Aid
@DDISOURCECODEID	uniqueidentifier	IN	DDI source
@DDISOURCEDATE	date	IN	DDI source date
@ISCOVENANT	bit	IN	Is covenant gift
@AMOUNTFORVAT	money	IN	Portion subject to VAT
@VATTAXRATEID	uniqueidentifier	IN	VAT tax rate
@VATAMOUNT	money	IN	VAT amount
@ADDITIONALAPPLICATIONSSTREAM	xml	IN	Additional applications stream
@REVENUELOOKUPID	nvarchar(100)	IN	Revenue ID
@APPLICATIONSOLICITORS	xml	IN	Application solicitors
@APPLICATIONRECOGNITIONS	xml	IN	Application recognitions
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@MATCHINGGIFTS	xml	IN
@MGGENERATED	bit	IN	MG Generated
@MGALTERED	bit	IN	MG Altered
@PAYINGPENDINGREVENUEID	uniqueidentifier	IN	Was paying pending revenue
@GIFTINKINDITEMNAME	nvarchar(100)	IN	Item name
@GIFTINKINDDISPOSITIONCODE	tinyint	IN	Disposition
@GIFTINKINDNUMBEROFUNITS	int	IN	Gift-in-kind number of units
@GIFTINKINDFAIRMARKETVALUE	money	IN	Fair market value per unit
@DIRECTDEBITISREJECTED	bit	IN	Direct debit is rejected
@PERCENTAGEBENEFITS	xml	IN	Percent benefits
@ISGIFTAIDSPONSORSHIP	bit	IN	Gift Aid sponsorship
@LOCKBOXID	uniqueidentifier	IN	Lockbox
@LOCKBOXBATCHNUMBER	nvarchar(100)	IN	Lockbox batch number
@LOCKBOXBATCHSEQUENCE	int	IN	Lockbox batch sequence
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system
@APPLICATIONBUSINESSUNITS	xml	IN	Application business units
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Transaction currency
@BASECURRENCYID	uniqueidentifier	IN	Base currency
@BASEEXCHANGERATEID	uniqueidentifier	IN	Base exchange rate
@EXCHANGERATE	decimal(20, 8)	IN	Exchange rate
@GENERATEREFERENCENUMBER	bit	IN	Automatically generate reference number
@APPLYBYPERCENT	bit	IN	Apply by
@SOURCECODEIMPORT	nvarchar(60)	IN	Source code (Import only)
@CURRENTBATCHROWID	uniqueidentifier	IN	BatchRowID
@MERCHANTACCOUNTID	uniqueidentifier	IN	Merchant account
@SETNULLBASEEXCHANGERATETOLATEST	bit	IN	Use latest base exchange rate when not specified

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_8
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier,
    @TYPECODE tinyint,
    @DATE datetime,
    @AMOUNT money,
    @PAYMENTMETHODCODE tinyint,
    @DONOTACKNOWLEDGE bit,
    @CHECKDATE dbo.UDT_FUZZYDATE,
    @CHECKNUMBER nvarchar(20),
    @REFERENCEDATE dbo.UDT_FUZZYDATE,
    @REFERENCENUMBER nvarchar(20),
    @CARDHOLDERNAME nvarchar(255),
    @CREDITCARDNUMBER nvarchar(20),
    @CREDITTYPECODEID uniqueidentifier,
    @AUTHORIZATIONCODE nvarchar(20),
    @EXPIRESON dbo.UDT_FUZZYDATE,
    @ISSUER nvarchar(100),
    @NUMBEROFUNITS decimal(20,3),
    @SYMBOL nvarchar(4),
    @MEDIANPRICE decimal(19,4),
    @PROPERTYSUBTYPECODEID uniqueidentifier,
    @GIFTINKINDSUBTYPECODEID uniqueidentifier,
    @RECEIPTAMOUNT money,
    @DONOTRECEIPT bit,
    @CONSTITUENTACCOUNTID uniqueidentifier,
    @SPLITS xml,
    @SINGLEDESIGNATIONID uniqueidentifier,
    @REVENUESTREAMS xml,
    @APPLYTOSHOWNFORCONSTITUENTID uniqueidentifier,
    @SEQUENCE int,
    @INSTALLMENTFREQUENCYCODE tinyint,
    @INSTALLMENTSTARTDATE datetime,
    @INSTALLMENTENDDATE datetime,
    @NUMBEROFINSTALLMENTS int,
    @SOLICITORS xml,
    @BENEFITS xml,
    @FINDERNUMBER bigint,
    @SOURCECODE nvarchar(60),
    @APPEALID uniqueidentifier,
    @FINDERNUMBERISVALID bit,
    @USERMODIFIEDBENEFITS bit,
    @BENEFITSWAIVED bit,
    @POSTDATE datetime,
    @POSTSTATUSCODE tinyint,
    @SENDPLEDGEREMINDER bit,
    @SALEDATE datetime,
    @SALEAMOUNT money,
    @BROKERFEE money,
    @SALEPOSTSTATUSCODE tinyint,
    @SALEPOSTDATE datetime,
    @NOTETITLE nvarchar(50),
    @NOTEAUTHORID uniqueidentifier,
    @NOTEDATEENTERED datetime,
    @NOTETYPECODEID uniqueidentifier,
    @NOTETEXTNOTE nvarchar(max),
    @GIVENANONYMOUSLY bit,
    @GIVENANONYMOUSLYDEFAULTEDFORCONSTITUENTID uniqueidentifier,
    @USERMODIFIEDRECEIPTAMOUNT bit,
    @PLEDGESUBTYPEID uniqueidentifier,
    @REJECTIONCODEID uniqueidentifier,
    @CONSTITUENTLOOKUPID uniqueidentifier,
    @MAILINGID uniqueidentifier,
    @CHANNELCODEID uniqueidentifier,
    @INSTALLMENTS xml,
    @PAYMENTFORPLEDGEAMOUNT money,
    @RECOGNITIONS xml,
    @DIDRECOGNITIONSDEFAULT bit,
    @TRIBUTES xml,
    @UNAPPLIEDMATCHINGGIFTSPLITS xml,
    @UNAPPLIEDMATCHINGGIFTAMOUNT money,
    @RECEIPTTYPECODE tinyint,
    @NEWCONSTITUENT xml,
    @OTHERPAYMENTMETHODCODEID uniqueidentifier,
    @LETTERCODEID uniqueidentifier,
    @ACKNOWLEDGEDATE datetime,
    @REFERENCE nvarchar(255),
    @CATEGORYCODEID uniqueidentifier,
    @ACKNOWLEDGEEID uniqueidentifier,
    @APPLICATIONINFO nvarchar(60),
    @OTHERTYPECODEID uniqueidentifier,
    @OPPORTUNITYID uniqueidentifier,
    @DIRECTDEBITRESULTCODE nvarchar(10),
    @LOWPRICE decimal(19,4),
    @HIGHPRICE decimal(19,4),
    @NUMBEROFUNITSSOLD decimal(20,3),
    @USERMODIFIEDNUMBEROFUNITSSOLD bit,
    @CREDITCARDTOKEN uniqueidentifier,
    @REJECTIONMESSAGE nvarchar(250),
    @PARTIALCREDITCARDNUMBER nvarchar(4),
    @TAXDECLARATIONS xml,
    @STANDINGORDERCONSTITUENTACCOUNTID uniqueidentifier,
    @STANDINGORDERREFERENCENUMBER nvarchar(18),
    @STANDINGORDERREFERENCEDATE dbo.UDT_FUZZYDATE,
    @STANDINGORDERSETUP bit,
    @STANDINGORDERSETUPDATE datetime,
    @TRANSACTIONID uniqueidentifier,
    @ISTRANSIENTCARD bit,
    @DECLINESGIFTAID bit,
    @DDISOURCECODEID uniqueidentifier,
    @DDISOURCEDATE date,
    @ISCOVENANT bit,
    @AMOUNTFORVAT money,
    @VATTAXRATEID uniqueidentifier,
    @VATAMOUNT money,
    @ADDITIONALAPPLICATIONSSTREAM xml,
    @REVENUELOOKUPID nvarchar(100),
    @APPLICATIONSOLICITORS xml,
    @APPLICATIONRECOGNITIONS xml,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @MATCHINGGIFTS xml,
    @MGGENERATED bit,
    @MGALTERED bit,
    @PAYINGPENDINGREVENUEID uniqueidentifier,
    @GIFTINKINDITEMNAME nvarchar(100),
    @GIFTINKINDDISPOSITIONCODE tinyint,
    @GIFTINKINDNUMBEROFUNITS int,
    @GIFTINKINDFAIRMARKETVALUE money,
    @DIRECTDEBITISREJECTED bit,
    @PERCENTAGEBENEFITS xml,
    @ISGIFTAIDSPONSORSHIP bit,
    @LOCKBOXID uniqueidentifier,
    @LOCKBOXBATCHNUMBER nvarchar(100),
    @LOCKBOXBATCHSEQUENCE int,
    @PDACCOUNTSYSTEMID uniqueidentifier,
    @APPLICATIONBUSINESSUNITS xml,
    @TRANSACTIONCURRENCYID uniqueidentifier,
    @BASECURRENCYID uniqueidentifier,
    @BASEEXCHANGERATEID uniqueidentifier,
    @EXCHANGERATE decimal(20,8),
    @GENERATEREFERENCENUMBER bit,
    @APPLYBYPERCENT bit,
    @SOURCECODEIMPORT nvarchar(60),
    @CURRENTBATCHROWID uniqueidentifier,
    @MERCHANTACCOUNTID uniqueidentifier,
    @SETNULLBASEEXCHANGERATETOLATEST bit
)

as
  set nocount on;

    declare @APPEALIDFORIMPORT uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_2_REVENUEBATCHROW
        @ID = @ID,
        @APPEALIDFORIMPORT = @APPEALIDFORIMPORT output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_2_REVENUEBATCHROW_9
        @ID,
        @CHANGEAGENTID,
        @CONSTITUENTID,
        @TYPECODE,
        @DATE,
        @AMOUNT,
        @PAYMENTMETHODCODE,
        @DONOTACKNOWLEDGE,
        @CHECKDATE,
        @CHECKNUMBER,
        @REFERENCEDATE,
        @REFERENCENUMBER,
        @CARDHOLDERNAME,
        @CREDITCARDNUMBER,
        @CREDITTYPECODEID,
        @AUTHORIZATIONCODE,
        @EXPIRESON,
        @ISSUER,
        @NUMBEROFUNITS,
        @SYMBOL,
        @MEDIANPRICE,
        @PROPERTYSUBTYPECODEID,
        @GIFTINKINDSUBTYPECODEID,
        @RECEIPTAMOUNT,
        @DONOTRECEIPT,
        @CONSTITUENTACCOUNTID,
        @SPLITS,
        @SINGLEDESIGNATIONID,
        @REVENUESTREAMS,
        @APPLYTOSHOWNFORCONSTITUENTID,
        @SEQUENCE,
        @INSTALLMENTFREQUENCYCODE,
        @INSTALLMENTSTARTDATE,
        @INSTALLMENTENDDATE,
        @NUMBEROFINSTALLMENTS,
        @SOLICITORS,
        @BENEFITS,
        @FINDERNUMBER,
        @SOURCECODE,
        @APPEALID,
        @FINDERNUMBERISVALID,
        @USERMODIFIEDBENEFITS,
        @BENEFITSWAIVED,
        @POSTDATE,
        @POSTSTATUSCODE,
        @SENDPLEDGEREMINDER,
        @SALEDATE,
        @SALEAMOUNT,
        @BROKERFEE,
        @SALEPOSTSTATUSCODE,
        @SALEPOSTDATE,
        @NOTETITLE,
        @NOTEAUTHORID,
        @NOTEDATEENTERED,
        @NOTETYPECODEID,
        @NOTETEXTNOTE,
        @GIVENANONYMOUSLY,
        @GIVENANONYMOUSLYDEFAULTEDFORCONSTITUENTID,
        @USERMODIFIEDRECEIPTAMOUNT,
        @PLEDGESUBTYPEID,
        @REJECTIONCODEID,
        @CONSTITUENTLOOKUPID,
        @MAILINGID,
        @CHANNELCODEID,
        @INSTALLMENTS,
        @PAYMENTFORPLEDGEAMOUNT,
        @RECOGNITIONS,
        @DIDRECOGNITIONSDEFAULT,
        @TRIBUTES,
        @UNAPPLIEDMATCHINGGIFTSPLITS,
        @UNAPPLIEDMATCHINGGIFTAMOUNT,
        @RECEIPTTYPECODE,
        @NEWCONSTITUENT,
        @OTHERPAYMENTMETHODCODEID,
        @LETTERCODEID,
        @ACKNOWLEDGEDATE,
        @REFERENCE,
        @CATEGORYCODEID,
        @ACKNOWLEDGEEID,
        @APPLICATIONINFO,
        @OTHERTYPECODEID,
        @OPPORTUNITYID,
        @DIRECTDEBITRESULTCODE,
        @LOWPRICE,
        @HIGHPRICE,
        @NUMBEROFUNITSSOLD,
        @USERMODIFIEDNUMBEROFUNITSSOLD,
        @CREDITCARDTOKEN,
        @REJECTIONMESSAGE,
        @PARTIALCREDITCARDNUMBER,
        @TAXDECLARATIONS,
        @STANDINGORDERCONSTITUENTACCOUNTID,
        @STANDINGORDERREFERENCENUMBER,
        @STANDINGORDERREFERENCEDATE,
        @STANDINGORDERSETUP,
        @STANDINGORDERSETUPDATE,
        @TRANSACTIONID,
        @ISTRANSIENTCARD,
        @DECLINESGIFTAID,
        @DDISOURCECODEID,
        @DDISOURCEDATE,
        @ISCOVENANT,
        @AMOUNTFORVAT,
        @VATTAXRATEID,
        @VATAMOUNT,
        @ADDITIONALAPPLICATIONSSTREAM,
        @REVENUELOOKUPID,
        @APPLICATIONSOLICITORS,
        @APPLICATIONRECOGNITIONS,
        @CURRENTAPPUSERID,
        @MATCHINGGIFTS,
        @MGGENERATED,
        @MGALTERED,
        @PAYINGPENDINGREVENUEID,
        @GIFTINKINDITEMNAME,
        @GIFTINKINDDISPOSITIONCODE,
        @GIFTINKINDNUMBEROFUNITS,
        @GIFTINKINDFAIRMARKETVALUE,
        @DIRECTDEBITISREJECTED,
        @PERCENTAGEBENEFITS,
        @ISGIFTAIDSPONSORSHIP,
        @LOCKBOXID,
        @LOCKBOXBATCHNUMBER,
        @LOCKBOXBATCHSEQUENCE,
        @PDACCOUNTSYSTEMID,
        @APPLICATIONBUSINESSUNITS,
        @TRANSACTIONCURRENCYID,
        @BASECURRENCYID,
        @BASEEXCHANGERATEID,
        @EXCHANGERATE,
        @GENERATEREFERENCENUMBER,
        @APPLYBYPERCENT,
        @SOURCECODEIMPORT,
        @CURRENTBATCHROWID,
        @MERCHANTACCOUNTID,
        @SETNULLBASEEXCHANGERATETOLATEST,
        @APPEALIDFORIMPORT

  return 0;