UFN_FEETAX_GETTAXES

This function returns a fee's taxes given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@FEEID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_FEETAX_GETTAXES
        (
            @FEEID uniqueidentifier
        )
            returns table
            as return
                select
                    FEETAX.ID,
                    FEETAX.TAXID,
                    TAX.NAME
                from
                    dbo.FEETAX
                left join
                    dbo.TAX on FEETAX.TAXID = TAX.ID
                where
                    TAX.ISACTIVE = 1 and
                    FEETAX.FEEID = @FEEID;