USP_DATAFORMTEMPLATE_VIEW_GROUPSALESDEFAULT

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

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DEPOSITREQUIRED	bit	INOUT	Reservation deposit required
@DEPOSITTIMEVALUE	smallint	INOUT	Reservation deposit due
@DEPOSITTIME	nvarchar(50)	INOUT	DEPOSITTIME
@DEPOSITTIMECODE	tinyint	INOUT	DEPOSITTIMECODE
@DEPOSITTYPE	nvarchar(50)	INOUT	Reservation deposit amount
@DEPOSITTYPECODE	tinyint	INOUT	Reservation deposit amount
@DEPOSITAMOUNT	money	INOUT	Reservation deposit amount
@DEPOSITPERCENT	decimal(5, 2)	INOUT	Reservation deposit amount
@CONTRACTREQUIRED	bit	INOUT	Contract required
@CONTRACTTIMEVALUE	smallint	INOUT	Contract due
@CONTRACTTIME	nvarchar(50)	INOUT	CONTRACTTIME
@CONTRACTTIMECODE	tinyint	INOUT	CONTRACTTIMECODE
@CONTRACTLETTERTEMPLATE	nvarchar(100)	INOUT	Default template
@CONTRACTRESERVATIONATTACHMENTTYPE	nvarchar(100)	INOUT	Attachment type
@FINALCOUNTREQUIRED	bit	INOUT	Final count required
@FINALCOUNTTIMEVALUE	smallint	INOUT	Final count due
@FINALCOUNTTIME	nvarchar(50)	INOUT	FINALCOUNTTIME
@FINALCOUNTTIMECODE	tinyint	INOUT	FINALCOUNTTIMECODE
@FINALTIMEVALUE	smallint	INOUT	Order balance due
@FINALTIME	nvarchar(50)	INOUT	FINALTIME
@FINALTIMECODE	tinyint	INOUT	FINALTIMECODE
@GROUPSALESDEFAULTID	uniqueidentifier	INOUT	GROUPSALESDEFAULTID
@SECURITYDEPOSITREQUIRED	bit	INOUT	Security deposit required
@SECURITYDEPOSITTIMEVALUE	smallint	INOUT	Security deposit due
@SECURITYDEPOSITTIME	nvarchar(50)	INOUT	SECURITYDEPOSITTIME
@SECURITYDEPOSITTIMECODE	tinyint	INOUT	SECURITYDEPOSITTIMECODE
@SECURITYDEPOSITTYPE	nvarchar(50)	INOUT	Security deposit amount
@SECURITYDEPOSITTYPECODE	tinyint	INOUT	Security deposit amount
@SECURITYDEPOSITAMOUNT	money	INOUT	Security deposit amount
@SECURITYDEPOSITPERCENT	decimal(5, 2)	INOUT	Security deposit amount

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GROUPSALESDEFAULT
            (
                @DATALOADED bit = 0 output,
                @DEPOSITREQUIRED bit = null output,
                @DEPOSITTIMEVALUE smallint = null output,
                @DEPOSITTIME nvarchar(50) = null output,
                @DEPOSITTIMECODE tinyint = null output,
                @DEPOSITTYPE nvarchar(50) = null output,
                @DEPOSITTYPECODE tinyint = null output,
                @DEPOSITAMOUNT money = null output,
                @DEPOSITPERCENT decimal(5,2) = null output,
                @CONTRACTREQUIRED bit = null output,
                @CONTRACTTIMEVALUE smallint = null output,
                @CONTRACTTIME nvarchar(50) = null output,
                @CONTRACTTIMECODE tinyint = null output,
                @CONTRACTLETTERTEMPLATE nvarchar(100) = null output,
                @CONTRACTRESERVATIONATTACHMENTTYPE nvarchar(100) = null output,
                @FINALCOUNTREQUIRED bit = null output,
                @FINALCOUNTTIMEVALUE smallint = null output,
                @FINALCOUNTTIME nvarchar(50) = null output,
                @FINALCOUNTTIMECODE tinyint = null output,
                @FINALTIMEVALUE smallint = null output,
                @FINALTIME nvarchar(50) = null output,
                @FINALTIMECODE tinyint = null output,
                @GROUPSALESDEFAULTID uniqueidentifier = null output,
                @SECURITYDEPOSITREQUIRED bit = null output,
                @SECURITYDEPOSITTIMEVALUE smallint = null output,
                @SECURITYDEPOSITTIME nvarchar(50) = null output,
                @SECURITYDEPOSITTIMECODE tinyint = null output,
                @SECURITYDEPOSITTYPE nvarchar(50) = null output,
                @SECURITYDEPOSITTYPECODE tinyint = null output,
                @SECURITYDEPOSITAMOUNT money = null output,
                @SECURITYDEPOSITPERCENT decimal(5,2) = null output
            )
            as
                set nocount on;

                set @DATALOADED = 0;

                select top 1
                    @DATALOADED = 1,
                    @DEPOSITREQUIRED = DEPOSITREQUIRED,
                    @DEPOSITTIMEVALUE = DEPOSITTIMEVALUE,
                    @DEPOSITTIME = DEPOSITTIME,
                    @DEPOSITTIMECODE = DEPOSITTIMECODE,
                    @DEPOSITTYPE = DEPOSITTYPE,
                    @DEPOSITTYPECODE = DEPOSITTYPECODE,
                    @DEPOSITAMOUNT = DEPOSITAMOUNT,
                    @DEPOSITPERCENT = DEPOSITPERCENT,
                    @CONTRACTREQUIRED = CONTRACTREQUIRED,
                    @CONTRACTTIMEVALUE = CONTRACTTIMEVALUE,
                    @CONTRACTTIME = CONTRACTTIME,
                    @CONTRACTTIMECODE = CONTRACTTIMECODE,
                    @CONTRACTLETTERTEMPLATE = dbo.UFN_LETTERTEMPLATE_GETNAME(CONTRACTLETTERTEMPLATEID),
                    @CONTRACTRESERVATIONATTACHMENTTYPE = dbo.UFN_RESERVATIONATTACHMENTTYPECODE_GETDESCRIPTION(CONTRACTRESERVATIONATTACHMENTTYPECODEID),
                    @FINALCOUNTREQUIRED = FINALCOUNTREQUIRED,
                    @FINALCOUNTTIMEVALUE = FINALCOUNTTIMEVALUE,
                    @FINALCOUNTTIME = FINALCOUNTTIME,
                    @FINALCOUNTTIMECODE = FINALCOUNTTIMECODE,
                    @FINALTIMEVALUE = FINALTIMEVALUE,
                    @FINALTIMECODE = FINALTIMECODE,
                    @FINALTIME = FINALTIME,
                    @GROUPSALESDEFAULTID = ID,
                    @SECURITYDEPOSITREQUIRED = SECURITYDEPOSITREQUIRED,
                    @SECURITYDEPOSITTIMEVALUE = SECURITYDEPOSITTIMEVALUE,
                    @SECURITYDEPOSITTIME = SECURITYDEPOSITTIME,
                    @SECURITYDEPOSITTIMECODE = SECURITYDEPOSITTIMECODE,
                    @SECURITYDEPOSITTYPE = SECURITYDEPOSITTYPE,
                    @SECURITYDEPOSITTYPECODE = SECURITYDEPOSITTYPECODE,
                    @SECURITYDEPOSITAMOUNT = SECURITYDEPOSITAMOUNT,
                    @SECURITYDEPOSITPERCENT = SECURITYDEPOSITPERCENT
                from dbo.GROUPSALESDEFAULT

                return 0;