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