USP_DATAFORMTEMPLATE_EDITSAVE_REVENUETRANSACTIONCHANGECONSTITUENTPOSTED_3

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.
@NEWCONSTITUENTID	uniqueidentifier	IN	New constituent
@CONSTITUENTACCOUNTID	uniqueidentifier	IN	Account
@ADJUSTMENTPOSTDATE	datetime	IN	Adjustment post date
@ADJUSTMENTDATE	datetime	IN	Adjustment date
@ADJUSTMENTREASON	nvarchar(100)	IN	Adjustment details
@RESETRECOGNITIONCREDITS	bit	IN	Recognition credit
@RESETSOLICITORS	bit	IN	Solicitors
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDITSAVE_REVENUETRANSACTIONCHANGECONSTITUENTPOSTED_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NEWCONSTITUENTID uniqueidentifier,
    @CONSTITUENTACCOUNTID uniqueidentifier,
    @ADJUSTMENTPOSTDATE datetime,
    @ADJUSTMENTDATE datetime,
    @ADJUSTMENTREASON nvarchar(100),
    @RESETRECOGNITIONCREDITS bit,
    @RESETSOLICITORS bit,
    @ADJUSTMENTREASONCODEID uniqueidentifier
)

as
  set nocount on;

    declare @RESETMATCHINGGIFTCLAIMS bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUETRANSACTIONCHANGECONSTITUENTPOSTED_3
        @ID = @ID,
        @RESETMATCHINGGIFTCLAIMS = @RESETMATCHINGGIFTCLAIMS output

  exec dbo.USP_DATAFORMTEMPLATE_EDITSAVE_REVENUETRANSACTIONCHANGECONSTITUENTPOSTED_4
        @ID,
        @CHANGEAGENTID,
        @NEWCONSTITUENTID,
        @CONSTITUENTACCOUNTID,
        @ADJUSTMENTPOSTDATE,
        @ADJUSTMENTDATE,
        @ADJUSTMENTREASON,
        @RESETRECOGNITIONCREDITS,
        @RESETSOLICITORS,
        @ADJUSTMENTREASONCODEID,
        @RESETMATCHINGGIFTCLAIMS

  return 0;