USP_DATAFORMTEMPLATE_VIEW_GROUPSALESPAYMENTDEFAULTDEPOSIT

The load procedure used by the view dataform template "Group Sales Payment Default Deposit View Form"

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.
@DEPOSITREQUIRED	bit	INOUT	Deposit required
@DEPOSITTIMEVALUE	smallint	INOUT	Deposit due
@DEPOSITTIMECODE	tinyint	INOUT	DEPOSITTIMECODE
@DEPOSITTYPECODE	tinyint	INOUT	Deposit type
@DEPOSITAMOUNT	money	INOUT	Deposit amount
@DEPOSITPERCENT	decimal(5, 2)	INOUT	Deposit amount

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GROUPSALESPAYMENTDEFAULTDEPOSIT
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @DEPOSITREQUIRED bit = null output,
                @DEPOSITTIMEVALUE smallint = null output,
                @DEPOSITTIMECODE tinyint = null output,
                @DEPOSITTYPECODE tinyint = null output,
                @DEPOSITAMOUNT money = null output,
                @DEPOSITPERCENT decimal(5,2) = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @DEPOSITREQUIRED = DEPOSITREQUIRED,
                    @DEPOSITTIMEVALUE = DEPOSITTIMEVALUE,
                    @DEPOSITTIMECODE = DEPOSITTIMECODE,
                    @DEPOSITTYPECODE = DEPOSITTYPECODE,
                    @DEPOSITAMOUNT = DEPOSITAMOUNT,
                    @DEPOSITPERCENT = DEPOSITPERCENT
                from dbo.GROUPSALESDEFAULT
                where ID = @ID

                return 0;