USP_DATAFORMTEMPLATE_EDIT_GROUPSALESDEFAULT

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.
@DEPOSITREQUIRED	bit	IN	Deposit required
@DEPOSITTIMEVALUE	smallint	IN	Due date
@DEPOSITTIMECODE	tinyint	IN
@DEPOSITTYPECODE	tinyint	IN	Type
@DEPOSITAMOUNT	money	IN	Value
@DEPOSITPERCENT	decimal(5, 2)	IN	Value
@CONTRACTREQUIRED	bit	IN	Contract required
@CONTRACTTIMEVALUE	smallint	IN	Due date
@CONTRACTTIMECODE	tinyint	IN
@CONTRACTLETTERTEMPLATEID	uniqueidentifier	IN	Default template
@CONTRACTRESERVATIONATTACHMENTTYPECODEID	uniqueidentifier	IN	Attachment type
@FINALTIMEVALUE	smallint	IN	Balance due
@FINALTIMECODE	tinyint	IN
@FINALTIMEWITHDEPOSITCODE	tinyint	IN
@FINALTIMEWITHOUTDEPOSITCODE	tinyint	IN
@FINALCOUNTREQUIRED	bit	IN	Final count required
@FINALCOUNTTIMEVALUE	smallint	IN	Due date
@FINALCOUNTTIMECODE	tinyint	IN

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_GROUPSALESDEFAULT
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @DEPOSITREQUIRED bit,
                    @DEPOSITTIMEVALUE smallint,
                    @DEPOSITTIMECODE tinyint,
                    @DEPOSITTYPECODE tinyint,
                    @DEPOSITAMOUNT money,
                    @DEPOSITPERCENT decimal(5,2),
                    @CONTRACTREQUIRED bit,
                    @CONTRACTTIMEVALUE smallint,
                    @CONTRACTTIMECODE tinyint,
                    @CONTRACTLETTERTEMPLATEID uniqueidentifier,
                    @CONTRACTRESERVATIONATTACHMENTTYPECODEID uniqueidentifier,
                    @FINALTIMEVALUE smallint,
                    @FINALTIMECODE tinyint,
                    @FINALTIMEWITHDEPOSITCODE tinyint,
                    @FINALTIMEWITHOUTDEPOSITCODE tinyint,
                    @FINALCOUNTREQUIRED bit,
                    @FINALCOUNTTIMEVALUE smallint,
                    @FINALCOUNTTIMECODE tinyint
                )
                as

                    set nocount on;

                    declare @SECURITYDEPOSITREQUIRED bit;
                    declare @SECURITYDEPOSITTIMEVALUE smallint;
                    declare @SECURITYDEPOSITTIMECODE tinyint;
                    declare @SECURITYDEPOSITTYPECODE tinyint;
                    declare @SECURITYDEPOSITAMOUNT money;
                    declare @SECURITYDEPOSITPERCENT decimal(5,2);

                    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GROUPSALESDEFAULT
                        @ID = @ID,
                        @SECURITYDEPOSITREQUIRED = @SECURITYDEPOSITREQUIRED output,
                        @SECURITYDEPOSITTIMEVALUE = @SECURITYDEPOSITTIMEVALUE output,
                        @SECURITYDEPOSITTIMECODE = @SECURITYDEPOSITTIMECODE output,
                        @SECURITYDEPOSITTYPECODE = @SECURITYDEPOSITTYPECODE output,
                        @SECURITYDEPOSITAMOUNT = @SECURITYDEPOSITAMOUNT output,
                        @SECURITYDEPOSITPERCENT = @SECURITYDEPOSITPERCENT output

                    exec dbo.USP_DATAFORMTEMPLATE_EDIT_GROUPSALESDEFAULT_1
                        @ID,
                        @CHANGEAGENTID,
                        @DEPOSITREQUIRED,
                        @DEPOSITTIMEVALUE,
                        @DEPOSITTIMECODE,
                        @DEPOSITTYPECODE,
                        @DEPOSITAMOUNT,
                        @DEPOSITPERCENT,
                        @CONTRACTREQUIRED,
                        @CONTRACTTIMEVALUE,
                        @CONTRACTTIMECODE,
                        @CONTRACTLETTERTEMPLATEID,
                        @CONTRACTRESERVATIONATTACHMENTTYPECODEID,
                        @FINALTIMEVALUE,
                        @FINALTIMECODE,
                        @FINALTIMEWITHDEPOSITCODE,
                        @FINALTIMEWITHOUTDEPOSITCODE,
                        @FINALCOUNTREQUIRED,
                        @FINALCOUNTTIMEVALUE,
                        @FINALCOUNTTIMECODE,
                        @SECURITYDEPOSITREQUIRED,
                        @SECURITYDEPOSITTIMEVALUE,
                        @SECURITYDEPOSITTIMECODE,
                        @SECURITYDEPOSITTYPECODE,
                        @SECURITYDEPOSITAMOUNT,
                        @SECURITYDEPOSITPERCENT