USP_DATALIST_SALESDEPOSITPROCESS_SALESDEPOSITTEMPLATE

Lists sales deposit templates defined within the sales deposit process.

Parameters

Parameter	Parameter Type	Mode	Description
@SALESDEPOSITPROCESSID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_SALESDEPOSITPROCESS_SALESDEPOSITTEMPLATE
            (
                @SALESDEPOSITPROCESSID uniqueidentifier
            )
            as
                set nocount on;

                select 
                    [SALESDEPOSITTEMPLATE].[ID],
                    [SALESDEPOSITTEMPLATE].[NAME],
                    dbo.UFN_BANKACCOUNT_GETACCOUNTNAME([SALESDEPOSITTEMPLATE].[BANKACCOUNTID]) as [ACCOUNTNAME],
                    (
                    select dbo.UDA_BUILDLIST([SDTPM].[PAYMENTMETHOD]) 
                        from (select distinct [PAYMENTMETHOD], [SALESDEPOSITTEMPLATEID] from dbo.[SALESDEPOSITTEMPLATEPAYMENTMETHOD]) as [SDTPM]
                        where [SDTPM].[SALESDEPOSITTEMPLATEID] = [SALESDEPOSITTEMPLATE].[ID]
                    ) as [PAYMENTMETHODS],
                    [SALESDEPOSITTEMPLATE].[POSTSTATUS],
                    [SALESDEPOSITTEMPLATE].[REFERENCE]
                from dbo.[SALESDEPOSITTEMPLATE]
                where [SALESDEPOSITTEMPLATE].[SALESDEPOSITPROCESSID] = @SALESDEPOSITPROCESSID