USP_SIMPLEDATALIST_MKTREVENUERECEIPT_NEXTRECEIPTNUMBER

Returns the next available receipt number for each record source.

Definition



CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTREVENUERECEIPT_NEXTRECEIPTNUMBER]
as
  set nocount on;

  select
    [ID] as [VALUE],
    dbo.[UFN_MKTREVENUERECEIPT_NEXTAVAILABLERECEIPTNUMBER]([ID]) as [LABEL]
  from dbo.[MKTGIFTRECORDSOURCE]
  where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([ID]) = 1;

  return 0;