USP_DATAFORMTEMPLATE_EDIT_REVENUEUPDATEBATCHROW_6

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEUPDATEBATCHROW_6
          (
            @ID uniqueidentifier,
            @REVENUEID uniqueidentifier,
            @REVENUESPLITID 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(25),
            @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 field is no longer in use (APPLICATIONSOLICITORS is current)  

            @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 field is no longer in use (APPLICATIONRECOGNITIONS is current)              

            @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 is used just to support import and so is only 

            -- actually used on RevenueBatchDataForm.Add.xml

            @PARTIALCREDITCARDNUMBER nvarchar(4),
            @TAXDECLARATIONS xml,
                  @STANDINGORDERCONSTITUENTACCOUNTID uniqueidentifier, 
                  @STANDINGORDERREFERENCENUMBER nvarchar(20), 
                  @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,
            @ISADJUSTMENT bit,
            @ADJUSTMENTDATE datetime ,
            @ADJUSTMENTPOSTDATE datetime,
            @ADJUSTMENTREASON nvarchar(300),
            @ADJUSTMENTREASONCODEID uniqueidentifier,
            @ADJUSTMENTPOSTSTATUSCODE tinyint,
            @REVENUEDEVELOPMENTFUNCTIONCODEID uniqueidentifier,
            @ORIGINALAPPLICATIONINFO nvarchar(60),
            @RELOADRECOGNITION bit,
            @RELOADSOLICITORS bit,
            @LETTERS xml,
            @APPLICATIONBUSINESSUNITS xml,
            @NOTES xml,
            @TRANSACTIONCURRENCYID uniqueidentifier,
            @BASECURRENCYID uniqueidentifier,
            @BASEEXCHANGERATEID uniqueidentifier,
            @EXCHANGERATE decimal(20,8),
            @GENERATEREFERENCENUMBER bit,
            @UPDATEMATCHINGGIFTCLAIMS tinyint,
            @UPDATEGIFTFEES bit,
            @UPDATETRIBUTES bit,
            @INSTALLMENTSCHEDULESEEDDATE datetime,
            @APPLYBYPERCENT bit,
            @ADJPAYMENT_DATE datetime,
            @ADJPAYMENT_POSTDATE datetime,
            @ADJPAYMENT_REASONCODEID uniqueidentifier,
            @ADJPAYMENT_DETAILS nvarchar(255)
          )
          as
            set nocount on;

            declare @SALE_LOWPRICE decimal(19,4);
              declare @SALE_MEDIANPRICE decimal(19,4);
              declare @SALE_HIGHPRICE decimal(19,4);

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEUPDATEBATCHROW
                  @ID = @ID,
                  @SALE_LOWPRICE = @SALE_LOWPRICE output,
                  @SALE_MEDIANPRICE = @SALE_MEDIANPRICE output,
                  @SALE_HIGHPRICE = @SALE_HIGHPRICE output

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_REVENUEUPDATEBATCHROW_7
                  @ID,
                  @REVENUEID,
                  @REVENUESPLITID,
                  @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 field is no longer in use (APPLICATIONSOLICITORS is current)

                  @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 field is no longer in use (APPLICATIONRECOGNITIONS is current)

                  @RECOGNITIONS,
                  @DIDRECOGNITIONSDEFAULT,
                  @TRIBUTES,
                  @UNAPPLIEDMATCHINGGIFTSPLITS,
                  @UNAPPLIEDMATCHINGGIFTAMOUNT,
                  @RECEIPTTYPECODE,
                  @NEWCONSTITUENT,
                  @OTHERPAYMENTMETHODCODEID,
                  @LETTERCODEID,
                  @ACKNOWLEDGEDATE,
                  @REFERENCE,
                  @CATEGORYCODEID,
                  @ACKNOWLEDGEEID,
                  @APPLICATIONINFO,
                  @OTHERTYPECODEID,
                  @OPPORTUNITYID,
                  @DIRECTDEBITRESULTCODE,
                  @LOWPRICE,
                  @HIGHPRICE,
                  @NUMBEROFUNITSSOLD,
                  @USERMODIFIEDNUMBEROFUNITSSOLD,
                  @CREDITCARDTOKEN,
                  @REJECTIONMESSAGE,
                  --PARTIALCREDITCARDNUMBER is used just to support import and so is only

                  --actually used on RevenueBatchDataForm.Add.xml

                  @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,
                  @ISADJUSTMENT,
                  @ADJUSTMENTDATE,
                  @ADJUSTMENTPOSTDATE,
                  @ADJUSTMENTREASON,
                  @ADJUSTMENTREASONCODEID,
                  @ADJUSTMENTPOSTSTATUSCODE,
                  @REVENUEDEVELOPMENTFUNCTIONCODEID,
                  @ORIGINALAPPLICATIONINFO,
                  @RELOADRECOGNITION,
                  @RELOADSOLICITORS,
                  @LETTERS,
                  @APPLICATIONBUSINESSUNITS,
                  @NOTES,
                  @TRANSACTIONCURRENCYID,
                  @BASECURRENCYID,
                  @BASEEXCHANGERATEID,
                  @EXCHANGERATE,
                  @GENERATEREFERENCENUMBER,
                  @UPDATEMATCHINGGIFTCLAIMS,
                  @UPDATEGIFTFEES,
                  @UPDATETRIBUTES,
                  @INSTALLMENTSCHEDULESEEDDATE,
                  @APPLYBYPERCENT,
                  @ADJPAYMENT_DATE,
                  @ADJPAYMENT_POSTDATE,
                  @ADJPAYMENT_REASONCODEID,
                  @ADJPAYMENT_DETAILS,
              @SALE_LOWPRICE,
              @SALE_MEDIANPRICE,
              @SALE_HIGHPRICE

  return 0;