USP_GENERATEEFTFILEPROCESS_GETPARAMETERS

Retrieves parameter settings for a given generate direct debit file process parameter set.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_GENERATEEFTFILEPROCESS_GETPARAMETERS
            (
                @ID uniqueidentifier = null
            )
            as
                set nocount on;

                select 
                    GENERATEEFTFILEPROCESS.NAME,
                    GENERATEEFTFILEPROCESS.BATCHID,
                    GENERATEEFTFILEPROCESS.BANKACCOUNTID,
                    BANKINGSYSTEM.CONDITIONSETTINGNAME BANKINGSYSTEMCONDITIONSETTINGNAME,
                    BANKACCOUNT.TRANSACTIONCURRENCYID BANKACCOUNTTRANSACTIONCURRENCYID,
                    GENERATEEFTFILEPROCESS.DATETYPECODE,
                    GENERATEEFTFILEPROCESS.DATE
                from 
                    dbo.GENERATEEFTFILEPROCESS 
                left outer join dbo.BANKACCOUNT on BANKACCOUNT.ID = GENERATEEFTFILEPROCESS.BANKACCOUNTID
                left outer join dbo.BANKINGSYSTEM on BANKINGSYSTEM.ID = BANKACCOUNT.BANKINGSYSTEMID
                where 
                    GENERATEEFTFILEPROCESS.ID = @ID;