UFN_MKTACKNOWLEDGEMENTMAILINGPROCESS_GETSTARTINGRECEIPTNUMBERS
Returns the starting receipt numbers for each record source used in the acknowledgement template.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MKTACKNOWLEDGEMENTMAILINGTEMPLATEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_MKTACKNOWLEDGEMENTMAILINGPROCESS_GETSTARTINGRECEIPTNUMBERS]
(
@MKTACKNOWLEDGEMENTMAILINGTEMPLATEID uniqueidentifier
)
returns table
as
return
select distinct
[MKTSEGMENT].[QUERYVIEWCATALOGID] as [RECORDSOURCEID],
[QUERYVIEWCATALOG].[DISPLAYNAME] as [NAME],
dbo.[UFN_MKTREVENUERECEIPT_NEXTAVAILABLERECEIPTNUMBER]([MKTSEGMENT].[QUERYVIEWCATALOGID]) as [STARTINGRECEIPTNUMBER]
from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE]
inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[SEGMENTID]
inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTSEGMENT].[QUERYVIEWCATALOGID]
where [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[ACKNOWLEDGEMENTMAILINGTEMPLATEID] = @MKTACKNOWLEDGEMENTMAILINGTEMPLATEID;