USP_FINANCIALTRANSACTIONSCHEDULE_UPDATE

Edit a row in the financial transaction schedule table

Parameters

Parameter	Parameter Type	Mode
@FINANCIALTRANSACTIONID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@AMOUNT	money	IN
@DUEDATE	datetime	IN

Definition

Copy



CREATE procedure dbo.USP_FINANCIALTRANSACTIONSCHEDULE_UPDATE
(
  @FINANCIALTRANSACTIONID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @AMOUNT money = 0,
  @DUEDATE datetime = null
) 
as

    set nocount on;

    declare @CURRENTDATE datetime


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

    set @CURRENTDATE = getdate();

  if (select COUNT(*) from dbo.FINANCIALTRANSACTIONSCHEDULE where FINANCIALTRANSACTIONID = @FINANCIALTRANSACTIONID and DELETED = 0) = 1      
      update 
          dbo.FINANCIALTRANSACTIONSCHEDULE
      set
          CHANGEDBYID = @CHANGEAGENTID,
          DATECHANGED = @CURRENTDATE,
          AMOUNT = @AMOUNT,
      DUEDATE = @DUEDATE
      where
          FINANCIALTRANSACTIONID = @FINANCIALTRANSACTIONID and DELETED = 0;

    return 0;