USP_DATAFORMTEMPLATE_EDITSAVE_REVENUETRANSACTIONCHANGECONSTITUENTPOSTED_4

The save procedure used by the edit dataform template "Revenue Transaction Change Constituent Posted Edit Form 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
@RESETMATCHINGGIFTCLAIMS	bit	IN	Matching gift claims
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



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

as
  set nocount on;

    declare @SEPAMANDATEID uniqueidentifier;

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

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

  return 0;