USP_DATALIST_RESOURCETAX

Lists taxes assigned to a supply/equipment resource.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_RESOURCETAX
                (
                    @RESOURCEID uniqueidentifier,
                    @INCLUDEINACTIVE bit = 0
                )
                as
                    set nocount on;

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

                    return 0;