USP_SIMPLEDATALIST_SALESDEPOSITTEMPLATE

Provides a list of deposit templates in a sales deposit process.

Parameters

Parameter	Parameter Type	Mode	Description
@SALESDEPOSITPROCESSID	uniqueidentifier	IN	Sales deposit process ID

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_SALESDEPOSITTEMPLATE (
                    @SALESDEPOSITPROCESSID uniqueidentifier = null
                )
                as
                    select 
                        [SALESDEPOSITTEMPLATE].[ID] as [VALUE], 
                        [SALESDEPOSITTEMPLATE].[NAME] as [LABEL]
                    from dbo.[SALESDEPOSITTEMPLATE]
                    where [SALESDEPOSITTEMPLATE].[SALESDEPOSITPROCESSID] = @SALESDEPOSITPROCESSID
                    order by [NAME]