USP_DATAFORMTEMPLATE_EDIT_PAYMENT2

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.
@DATE	datetime	IN	Date
@AMOUNT	money	IN	Amount
@RECEIPTAMOUNT	money	IN	Receipt amount
@REVENUESTREAMS	xml	IN	Revenue streams
@SOURCECODE	nvarchar(50)	IN	Source code
@APPEALID	uniqueidentifier	IN	Appeal
@BENEFITS	xml	IN	Benefits
@BENEFITSWAIVED	bit	IN	Benefits waived
@GIVENANONYMOUSLY	bit	IN	Payment is anonymous
@MAILINGID	uniqueidentifier	IN	Mailing
@CHANNELCODEID	uniqueidentifier	IN	Channel
@DONOTRECEIPT	bit	IN	Do not receipt
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@REFERENCE	nvarchar(255)	IN	Reference
@POSTSTATUSCODE	tinyint	IN	Post status
@POSTDATE	datetime	IN	Post date
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@OTHERPAYMENTMETHODCODEID	uniqueidentifier	IN	Other method
@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(4)	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	Number of units
@SYMBOL	nvarchar(25)	IN	Symbol
@MEDIANPRICE	decimal(19, 4)	IN	Median price
@GIFTINKINDSUBTYPECODEID	uniqueidentifier	IN	Subtype
@PROPERTYSUBTYPECODEID	uniqueidentifier	IN	Subtype
@CONSTITUENTACCOUNTID	uniqueidentifier	IN	Account
@DIRECTDEBITRESULTCODE	nvarchar(10)	IN	Result code
@LOWPRICE	decimal(19, 4)	IN	Low price
@HIGHPRICE	decimal(19, 4)	IN	High price

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_PAYMENT2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @DATE datetime,
    @AMOUNT money,
    @RECEIPTAMOUNT money ,
    @REVENUESTREAMS xml ,
    @SOURCECODE nvarchar(50),
    @APPEALID uniqueidentifier,
    @BENEFITS xml,
    @BENEFITSWAIVED bit,
    @GIVENANONYMOUSLY bit,
    @MAILINGID uniqueidentifier,
    @CHANNELCODEID uniqueidentifier,
    @DONOTRECEIPT bit,
    @DONOTACKNOWLEDGE bit,
    @REFERENCE nvarchar(255),
    @POSTSTATUSCODE tinyint,
    @POSTDATE datetime,
    @PAYMENTMETHODCODE tinyint,
    @OTHERPAYMENTMETHODCODEID uniqueidentifier,
    @CHECKDATE dbo.UDT_FUZZYDATE,
    @CHECKNUMBER nvarchar(20),
    @REFERENCEDATE dbo.UDT_FUZZYDATE,
    @REFERENCENUMBER nvarchar(20),
    @CARDHOLDERNAME nvarchar(255),
    @CREDITCARDNUMBER nvarchar(4),
    @CREDITTYPECODEID uniqueidentifier,
    @AUTHORIZATIONCODE nvarchar(20),
    @EXPIRESON dbo.UDT_FUZZYDATE,
    @ISSUER nvarchar(100),
    @NUMBEROFUNITS decimal(20,3),
    @SYMBOL nvarchar(25),
    @MEDIANPRICE decimal(19,4),
    @GIFTINKINDSUBTYPECODEID uniqueidentifier,
    @PROPERTYSUBTYPECODEID uniqueidentifier,
    @CONSTITUENTACCOUNTID uniqueidentifier,
    @DIRECTDEBITRESULTCODE nvarchar(10),
    @LOWPRICE decimal(19,4),
    @HIGHPRICE decimal(19,4)
)

as
    set nocount on;

    declare @GIFTINKINDITEMNAME nvarchar(100);
    declare @GIFTINKINDDISPOSITIONCODE tinyint;
    declare @GIFTINKINDNUMBEROFUNITS int;
    declare @GIFTINKINDFAIRMARKETVALUE money;
    declare @DIRECTDEBITISREJECTED bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PAYMENT2
        @ID = @ID,
        @GIFTINKINDITEMNAME = @GIFTINKINDITEMNAME output,
        @GIFTINKINDDISPOSITIONCODE = @GIFTINKINDDISPOSITIONCODE output,
        @GIFTINKINDNUMBEROFUNITS = @GIFTINKINDNUMBEROFUNITS output,
        @GIFTINKINDFAIRMARKETVALUE = @GIFTINKINDFAIRMARKETVALUE output,
        @DIRECTDEBITISREJECTED = @DIRECTDEBITISREJECTED output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_PAYMENT3
        @ID,
        @CHANGEAGENTID,
        @DATE,
        @AMOUNT,
        @RECEIPTAMOUNT,
        @REVENUESTREAMS,
        @SOURCECODE,
        @APPEALID,
        @BENEFITS,
        @BENEFITSWAIVED,
        @GIVENANONYMOUSLY,
        @MAILINGID,
        @CHANNELCODEID,
        @DONOTRECEIPT,
        @DONOTACKNOWLEDGE,
        @REFERENCE,
        @POSTSTATUSCODE,
        @POSTDATE,
        @PAYMENTMETHODCODE,
        @OTHERPAYMENTMETHODCODEID,
        @CHECKDATE,
        @CHECKNUMBER,
        @REFERENCEDATE,
        @REFERENCENUMBER,
        @CARDHOLDERNAME,
        @CREDITCARDNUMBER,
        @CREDITTYPECODEID,
        @AUTHORIZATIONCODE,
        @EXPIRESON,
        @ISSUER,
        @NUMBEROFUNITS,
        @SYMBOL,
        @MEDIANPRICE,
        @GIFTINKINDSUBTYPECODEID,
        @PROPERTYSUBTYPECODEID,
        @CONSTITUENTACCOUNTID,
        @DIRECTDEBITRESULTCODE,
        @LOWPRICE,
        @HIGHPRICE,
        @GIFTINKINDITEMNAME,
        @GIFTINKINDDISPOSITIONCODE,
        @GIFTINKINDNUMBEROFUNITS,
        @GIFTINKINDFAIRMARKETVALUE,
        @DIRECTDEBITISREJECTED

    return 0;