USP_SIMPLEDATALIST_REVENUEUPDATEBATCH_LETTER

Returns a list of revenue letters or tribute letters depending on the letter type.
Parameters

Parameter	Parameter Type	Mode	Description
@LETTERTYPE	bit	IN
Definition

Copy


CREATE procedure dbo.USP_SIMPLEDATALIST_REVENUEUPDATEBATCH_LETTER(@LETTERTYPE bit = 0) 
as
   if @LETTERTYPE = 0
   begin
                    select 
            LETTERCODE.ID as VALUE,
                        LETTERCODE.NAME as LABEL
                    from
                        dbo.LETTERCODE
                        left outer join dbo.[EXPORTDEFINITION] on [EXPORTDEFINITION].[ID] = [LETTERCODE].[EXPORTDEFINITIONID]
                        left outer join dbo.[RECORDTYPE] on [RECORDTYPE].[ID] = [EXPORTDEFINITION].[RECORDTYPEID]
                    where
                        ISACTIVE = 1
                        and LETTERCODE.ISSYSTEM = 0
                        and 
            (
              IDSETREGISTERID is not null
                          or 
                          (
                [LETTERCODE].[EXPORTDEFINITIONID] is not null 
                and 
                dbo.[UFN_MKTEXPORTDEFINITION_GETMAILINGTYPECODEFROMRECORDTYPE]([RECORDTYPE].[NAME]) in (1, 5)
              )
            )
                    order by
                        LETTERCODE.NAME;
    end
    if @LETTERTYPE = 1
    begin
              select 
                        ID as VALUE,
                        NAME as LABEL
                    from
                        dbo.TRIBUTELETTERCODE
                    where
                        ISACTIVE = 1
                    order by
                        NAME;
    end