USP_DATALIST_EXPORTDEFINITIONFILELAYOUTSUMMARY
Returns export definition file layout summary information.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EXPORTDEFINITIONID | uniqueidentifier | IN | Export definition ID |
Definition
Copy
CREATE procedure dbo.[USP_DATALIST_EXPORTDEFINITIONFILELAYOUTSUMMARY]
(
@EXPORTDEFINITIONID uniqueidentifier = null
)
as
set nocount on;
select
[MKTEXPORTDEFINITION].[NAME],
[MKTEXPORTDEFINITION].[MAILINGTYPE]
from dbo.[MKTEXPORTDEFINITION]
where [MKTEXPORTDEFINITION].[ID] = @EXPORTDEFINITIONID
and [MKTEXPORTDEFINITION].[ISSYSTEM] = 0;
return 0;