UFN_DAILYSALESGENERICACTION_GETGENERICBUTTONS

CREATE function dbo.UFN_DAILYSALESGENERICACTION_GETGENERICBUTTONS 
(
    @INCLUDEINACTIVE bit = 1
)
returns table
as return
(
    select
        ID,
        TYPE,
        TYPECODE,
        ISACTIVE,
        BUTTONORDER
    from 
        dbo.DAILYSALESGENERICACTION
    where 
        TYPECODE not in (0,4,7)
        and (@INCLUDEINACTIVE = 1 or ISACTIVE = 1)
)