USP_DATALIST_REVENUECATEGORY

Returns a list of the Revenue Categories.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	Include inactive entries

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_REVENUECATEGORY(@INCLUDEINACTIVE bit = 0)
            as
                set nocount on;

                select 
                    ID, 
                    REVENUECATEGORYNAME, 
                    ACTIVE  
                from GLREVENUECATEGORYMAPPING    
                where ACTIVE = 1 or (ACTIVE = 0 and @INCLUDEINACTIVE = 1)