USP_FINANCIALTRANSACTION_EDIT

Edit a row in the financial transaction table

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@USERDEFINEDID	nvarchar(60)	IN
@AMOUNT	money	IN
@DATE	datetime	IN
@POSTDATE	datetime	IN
@POSTSTATUSCODE	tinyint	IN
@DESCRIPTION	nvarchar(100)	IN

Definition

Copy



CREATE procedure dbo.USP_FINANCIALTRANSACTION_EDIT
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @CONSTITUENTID uniqueidentifier = null,
  @USERDEFINEDID nvarchar(60) = '',
  @AMOUNT money = 0,
  @DATE datetime = null,
  @POSTDATE datetime = null,
  @POSTSTATUSCODE tinyint = 1,
  @DESCRIPTION  nvarchar(100) = ''
) 
as

    set nocount on;

    declare @CURRENTDATE datetime

    begin try
        if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

        set @CURRENTDATE = getdate();

        update 
            dbo.FINANCIALTRANSACTION
        set
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE,
            CONSTITUENTID = @CONSTITUENTID,
            USERDEFINEDID = @USERDEFINEDID,
            TRANSACTIONAMOUNT = @AMOUNT,
            [DATE] = @DATE,
            POSTDATE = @POSTDATE,
            POSTSTATUSCODE = @POSTSTATUSCODE,
            DESCRIPTION = @DESCRIPTION
        where
            ID = @ID;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;