USP_DATALIST_SALESMETHODMARKETINGCONFIGURATION

Returns data about marketing configuration for a sales method.

Parameters

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

Definition

Copy


            CREATE procedure dbo.USP_DATALIST_SALESMETHODMARKETINGCONFIGURATION(@CONTEXTID uniqueidentifier)
            as
                set nocount on;

                select    
                    ID,    
                    'ZIP/postal code' NAME,
                    CAPTUREMARKETINGINFO ISACTIVE
                from dbo.SALESMETHODMARKETINGCONFIGURATION
                where ID = @CONTEXTID