UFN_TAX_GETTAXITEMS

This function returns tax items for a given tax ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TAXID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_TAX_GETTAXITEMS
        (
            @TAXID uniqueidentifier
        )
        returns table
        as return
            select
                TAXITEM.ID,
                TAXENTITYCODEID,
                PERCENTAGE
            from
                dbo.TAXITEM
            inner join dbo.TAXENTITYCODE on
                TAXENTITYCODE.ID = TAXITEM.TAXENTITYCODEID
            where
                TAXID=@TAXID and
                TAXENTITYCODE.ACTIVE = 1;