USP_DATAFORMTEMPLATE_EDIT_GENERATEEFTFILEPROCESS_1_2

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.
@NAME	nvarchar(100)	IN	Process name
@DESCRIPTION	nvarchar(255)	IN	Process description
@DATETYPECODE	tinyint	IN	Financial processing date
@DATE	datetime	IN	Specific date
@SPONSORINGINSTITUTIONID	uniqueidentifier	IN	Sponsoring institution
@BANKACCOUNTID	uniqueidentifier	IN	Bank account
@IMMEDIATEDESTINATIONNAME	nvarchar(23)	IN	Immediate destination
@CREATECREDITOFFSETTRANSACTION	bit	IN	Create credit offset transaction
@BATCHID	uniqueidentifier	IN	Batch number
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@CUTOFFDATE	datetime	IN	Specific date
@BATCHTEMPLATEID	uniqueidentifier	IN	Payment batch design
@TRANSACTIONTYPECODE	tinyint	IN	Transaction types
@OWNERID	uniqueidentifier	IN	Payment batch owner
@DUEDATETYPECODE	tinyint	IN	Payments due on or before
@DAYSAFTER	int	IN	Days after
@FINDAYSAFTER	int	IN	Days after

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_GENERATEEFTFILEPROCESS_1_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @DATETYPECODE tinyint,
    @DATE datetime,
    @SPONSORINGINSTITUTIONID uniqueidentifier,
    @BANKACCOUNTID uniqueidentifier,
    @IMMEDIATEDESTINATIONNAME nvarchar(23),
    @CREATECREDITOFFSETTRANSACTION bit,
    @BATCHID uniqueidentifier,
    @IDSETREGISTERID uniqueidentifier,
    @CUTOFFDATE datetime,
    @BATCHTEMPLATEID uniqueidentifier,
    @TRANSACTIONTYPECODE tinyint,
    @OWNERID uniqueidentifier,
    @DUEDATETYPECODE tinyint,
    @DAYSAFTER integer,
    @FINDAYSAFTER integer
)

as
  set nocount on;

    declare @CONSOLIDATEPAYMENTS bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GENERATEEFTFILEPROCESS_1_2
        @ID = @ID,
        @CONSOLIDATEPAYMENTS = @CONSOLIDATEPAYMENTS output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_GENERATEEFTFILEPROCESS_1_3
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @DATETYPECODE,
        @DATE,
        @SPONSORINGINSTITUTIONID,
        @BANKACCOUNTID,
        @IMMEDIATEDESTINATIONNAME,
        @CREATECREDITOFFSETTRANSACTION,
        @BATCHID,
        @IDSETREGISTERID,
        @CUTOFFDATE,
        @BATCHTEMPLATEID,
        @TRANSACTIONTYPECODE,
        @OWNERID,
        @DUEDATETYPECODE,
        @DAYSAFTER,
        @FINDAYSAFTER,
        @CONSOLIDATEPAYMENTS

  return 0;