USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTADJUSTMENT

Edit an existing bank account adjustment.

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.
@ADJUSTMENTDATE	datetime	IN	Adjustment date
@AMOUNT	decimal(19, 4)	IN	Amount
@REFERENCE	nvarchar(100)	IN	Reference
@POSTSTATUSCODE	tinyint	IN	Post status
@POSTDATE	datetime	IN	Post date

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTADJUSTMENT (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @ADJUSTMENTDATE datetime,
                        @AMOUNT decimal(19,4),
                        @REFERENCE nvarchar(100),
                        @POSTSTATUSCODE tinyint,
                        @POSTDATE datetime
)
as
begin
  declare @BASEEXCHANGERATEID uniqueidentifier;
    declare @EXCHANGERATE decimal(20,8);
  declare @TRANSFERBASEEXCHANGERATEID uniqueidentifier;
  declare @TRANSFEREXCHANGERATE decimal(20,8);
  declare @TRANSFERBANKACCOUNTBASEEXCHANGERATEID uniqueidentifier;
  declare @TRANSFERBANKACCOUNTEXCHANGERATE decimal(20,8);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BANKACCOUNTADJUSTMENT
    @ID=@ID
    ,@BASEEXCHANGERATEID = @BASEEXCHANGERATEID output
        ,@EXCHANGERATE = @EXCHANGERATE output
    ,@TRANSFERBASEEXCHANGERATEID = @TRANSFERBASEEXCHANGERATEID output
    ,@TRANSFEREXCHANGERATE = @TRANSFEREXCHANGERATE output
    ,@TRANSFERBANKACCOUNTBASEEXCHANGERATEID = @TRANSFERBANKACCOUNTBASEEXCHANGERATEID output
    ,@TRANSFERBANKACCOUNTEXCHANGERATE = @TRANSFERBANKACCOUNTEXCHANGERATE output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTADJUSTMENT2
    @ID
        ,@CHANGEAGENTID
        ,@ADJUSTMENTDATE
    ,@AMOUNT
        ,@REFERENCE
        ,@POSTSTATUSCODE
        ,@POSTDATE
    ,@BASEEXCHANGERATEID
        ,@EXCHANGERATE
    ,@TRANSFERBASEEXCHANGERATEID
    ,@TRANSFEREXCHANGERATE
    ,@TRANSFERBANKACCOUNTBASEEXCHANGERATEID
    ,@TRANSFERBANKACCOUNTEXCHANGERATE    
end