USP_SIMPLEDATALIST_GLREVENUECATEGORY

Returns a list of revenue categories from the GL Revenue Category Mapping table.

Parameters

Parameter	Parameter Type	Mode	Description
@INCLUDEINACTIVE	bit	IN	INCLUDEINACTIVE

Definition

Copy



                create procedure dbo.USP_SIMPLEDATALIST_GLREVENUECATEGORY
                (
                    @INCLUDEINACTIVE bit = 0
                )
                as
                    set nocount on;

                    select
                        ID as VALUE,
                        REVENUECATEGORYNAME as LABEL
                    from
                        dbo.GLREVENUECATEGORYMAPPING
                    where
                        @INCLUDEINACTIVE = 1 or ACTIVE = 1;