USP_DATAFORMTEMPLATE_VIEW_DEPOSITPAYMENTDEFAULTS

The load procedure used by the view dataform template "Deposit Payment Default"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DEFAULTPAYMENTDATE	datetime	INOUT	Payment date
@DEFAULTPAYMENTAMOUNT	numeric(19, 4)	INOUT	Payment amount
@DEFAULTPAYMENTMETHOD	nvarchar(60)	INOUT	Payment method
@DEFAULTALLOWEDPAYMENTMETHODS	int	INOUT	Allowed payment methods
@OTHERPAYMENTMETHODCODE	nvarchar(100)	INOUT	Other method
@CREDITTYPECODE	nvarchar(100)	INOUT	Card type
@DEFAULTPAYMENTMETHODCODE	tinyint	INOUT	Payment method
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Payment currency

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DEPOSITPAYMENTDEFAULTS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @DEFAULTPAYMENTDATE datetime = null output,
                    @DEFAULTPAYMENTAMOUNT numeric(19, 4) = null output,
                    @DEFAULTPAYMENTMETHOD nvarchar(60) = null output,
                    @DEFAULTALLOWEDPAYMENTMETHODS integer = null output,
                    @OTHERPAYMENTMETHODCODE nvarchar(100) = null output,
                    @CREDITTYPECODE nvarchar(100)= null output
          ,@DEFAULTPAYMENTMETHODCODE tinyint = null output
          ,@TRANSACTIONCURRENCYID uniqueidentifier = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @DEFAULTPAYMENTDATE = BANKACCOUNTDEPOSIT.DEFAULTPAYMENTDATE,
                        @DEFAULTPAYMENTAMOUNT = BANKACCOUNTDEPOSIT.DEFAULTPAYMENTAMOUNT,
                        @DEFAULTPAYMENTMETHOD = BANKACCOUNTDEPOSIT.DEFAULTPAYMENTMETHOD,
            @DEFAULTPAYMENTMETHODCODE = BANKACCOUNTDEPOSIT.DEFAULTPAYMENTMETHODCODE,
                        @DEFAULTALLOWEDPAYMENTMETHODS = BANKACCOUNTDEPOSIT.DEFAULTALLOWEDPAYMENTMETHODS,
                        @OTHERPAYMENTMETHODCODE = (select DESCRIPTION from OTHERPAYMENTMETHODCODE where ID = BANKACCOUNTDEPOSIT.OTHERPAYMENTMETHODCODEID),
                        @CREDITTYPECODE = (select DESCRIPTION from CREDITTYPECODE where ID = BANKACCOUNTDEPOSIT.CREDITTYPECODEID),
            @TRANSACTIONCURRENCYID = BANKACCOUNTDEPOSIT.TRANSACTIONCURRENCYID
                    from dbo.BANKACCOUNTDEPOSIT
                    join dbo.BANKACCOUNTTRANSACTION on BANKACCOUNTTRANSACTION.ID = BANKACCOUNTDEPOSIT.ID
                    inner join dbo.BANKACCOUNT on BANKACCOUNTTRANSACTION.BANKACCOUNTID = BANKACCOUNT.ID
                    where BANKACCOUNTDEPOSIT.ID = @ID

                    return 0;