USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNT_2

The save procedure used by the edit dataform template "Bank Account Edit Form".

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.
@ACCOUNTNAME	nvarchar(100)	IN	Account name
@ACCOUNTNUMBER	nvarchar(19)	IN	Account number
@ROUTINGNUMBER	nvarchar(9)	IN	Routing number
@ACCOUNTTYPECODE	tinyint	IN	Account type
@MINIMUMBALANCE	decimal(19, 4)	IN	Minimum balance
@DEFAULTCASHACCOUNTTYPECODE	tinyint	IN	Default cash account type
@GLACCOUNTID	uniqueidentifier	IN	Account
@PDACCOUNTSEGMENTVALUEID	uniqueidentifier	IN	Account code
@USERNUMBER	nvarchar(24)	IN	User number
@CLIENTNAME	nvarchar(100)	IN	Client name
@SORTCODE	nvarchar(6)	IN	Sort code
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Currency

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNT_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @ACCOUNTNAME nvarchar(100),
    @ACCOUNTNUMBER nvarchar(19),
    @ROUTINGNUMBER nvarchar(9),
    @ACCOUNTTYPECODE tinyint,
    @MINIMUMBALANCE decimal(19, 4),
    @DEFAULTCASHACCOUNTTYPECODE tinyint,
    @GLACCOUNTID uniqueidentifier,
    @PDACCOUNTSEGMENTVALUEID uniqueidentifier,
    @USERNUMBER nvarchar(24),
    @CLIENTNAME nvarchar(100),
    @SORTCODE nvarchar(6),
    @PDACCOUNTSYSTEMID uniqueidentifier,
    @TRANSACTIONCURRENCYID uniqueidentifier
)

as
  set nocount on;

    declare @BANKINGSYSTEMID uniqueidentifier;
    declare @BIC nvarchar(11);
    declare @BANKCODE nvarchar(25);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BANKACCOUNT
        @ID = @ID,
        @BANKINGSYSTEMID = @BANKINGSYSTEMID output,
        @BIC = @BIC output,
        @BANKCODE = @BANKCODE output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNT_3
        @ID,
        @CHANGEAGENTID,
        @ACCOUNTNAME,
        @ACCOUNTNUMBER,
        @ROUTINGNUMBER,
        @ACCOUNTTYPECODE,
        @MINIMUMBALANCE,
        @DEFAULTCASHACCOUNTTYPECODE,
        @GLACCOUNTID,
        @PDACCOUNTSEGMENTVALUEID,
        @USERNUMBER,
        @CLIENTNAME,
        @SORTCODE,
        @PDACCOUNTSYSTEMID,
        @TRANSACTIONCURRENCYID,
        @BANKINGSYSTEMID,
        @BIC,
        @BANKCODE

  return 0;