USP_DATALIST_FEETAX

Lists taxes assigned to a fee.

Parameters

Parameter	Parameter Type	Mode	Description
@FEEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@INCLUDEINACTIVE	bit	IN	Include inactive

Definition

Copy



                create procedure dbo.USP_DATALIST_FEETAX
                (
                    @FEEID uniqueidentifier,
                    @INCLUDEINACTIVE bit = 0
                )
                as
                    set nocount on;

                    select
                        FEETAX.ID,
                        TAX.NAME,
                        TAX.TOTALTAX,
                        TAX.ISACTIVE,
                        TAX.[DESCRIPTION]
                    from
                        dbo.FEETAX
                    left join
                        dbo.TAX on FEETAX.TAXID = TAX.ID
                    where
                        FEEID = @FEEID and
                        (@INCLUDEINACTIVE = 1 or TAX.ISACTIVE = 1)
                    order by
                        TAX.NAME;

                    return 0;