USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTDEPOSIT

Edit an existing bank account deposit.

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.
@REFERENCE	nvarchar(100)	IN	Reference
@DEPOSITDATE	datetime	IN	Deposit date
@POSTSTATUSCODE	tinyint	IN	Post status
@POSTDATE	datetime	IN	Post date
@PROJECTEDNUMBEROFPAYMENTS	int	IN	Number of payments
@PROJECTEDAMOUNT	numeric(19, 4)	IN	Amount
@STATUSCODE	tinyint	IN	Status

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTDEPOSIT (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @REFERENCE nvarchar(100),
    @DEPOSITDATE datetime,
    @POSTSTATUSCODE tinyint,
    @POSTDATE datetime,
    @PROJECTEDNUMBEROFPAYMENTS int,
    @PROJECTEDAMOUNT numeric(19,4),
    @STATUSCODE tinyint
)
as
begin
    declare @TRANSACTIONCURRENCYID uniqueidentifier;
  declare @TRANSACTIONEXCHANGERATEID uniqueidentifier;
  declare @TRANSACTIONEXCHANGERATE decimal(20,8);
    declare @BASEEXCHANGERATEID uniqueidentifier;
    declare @BASEEXCHANGERATE decimal(20,8);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BANKACCOUNTDEPOSIT 
    @ID=@ID
    ,@TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output
    ,@TRANSACTIONEXCHANGERATEID = @TRANSACTIONEXCHANGERATEID output
    ,@TRANSACTIONEXCHANGERATE = @TRANSACTIONEXCHANGERATE output
    ,@BASEEXCHANGERATEID = @BASEEXCHANGERATEID output
    ,@BASEEXCHANGERATE = @BASEEXCHANGERATE output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTDEPOSIT2
    @ID
      ,@CHANGEAGENTID
      ,@REFERENCE
      ,@DEPOSITDATE 
      ,@POSTSTATUSCODE 
      ,@POSTDATE 
      ,@PROJECTEDNUMBEROFPAYMENTS 
      ,@PROJECTEDAMOUNT
      ,@STATUSCODE
    ,@TRANSACTIONCURRENCYID 
    ,@TRANSACTIONEXCHANGERATEID 
    ,@TRANSACTIONEXCHANGERATE 
    ,@BASEEXCHANGERATEID 
    ,@BASEEXCHANGERATE 
end