USP_DATAFORMTEMPLATE_EDIT_ADJUSTMENTREASONCODE_2

The save procedure used by the edit dataform template "Adjustment Reason Code Edit Form".

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN The input ID parameter indicating the ID of the record being edited.
@CODE nvarchar(10) IN Reason code
@DESCRIPTION nvarchar(50) IN Description
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the procedure.
@ISDIRECTDEBITREJECTEDDEFAULT bit IN Default for direct debit return batch rejections

Definition

Copy


CREATE procedure USP_DATAFORMTEMPLATE_EDIT_ADJUSTMENTREASONCODE_2
(
    @ID uniqueidentifier,
    @CODE nvarchar(10),
    @DESCRIPTION nvarchar(50),
    @CHANGEAGENTID uniqueidentifier = null,
    @ISDIRECTDEBITREJECTEDDEFAULT bit
)

as
  set nocount on;

    declare @ISAUCTIONIMPORTDEFAULT bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ADJUSTMENTREASONCODE
        @ID = @ID,
        @ISAUCTIONIMPORTDEFAULT = @ISAUCTIONIMPORTDEFAULT output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_ADJUSTMENTREASONCODE_3
        @ID,
        @CODE,
        @DESCRIPTION,
        @CHANGEAGENTID,
        @ISDIRECTDEBITREJECTEDDEFAULT,
        @ISAUCTIONIMPORTDEFAULT

  return 0;