USP_DATALIST_REVENUETRIBUTES

Returns a list of tributes associated with a specified transaction.

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_REVENUETRIBUTES(@REVENUEID uniqueidentifier)
                as
                set nocount on;

                select 
                    REVENUETRIBUTE.ID,
                    TRIBUTE.ID as TRIBUTEID,
                    TRIBUTE.TRIBUTETEXT,
                    TYPE.DESCRIPTION as TRIBUTETYPE,
                    REVENUETRIBUTE.AMOUNT,
                    coalesce(REVENUETRIBUTE.AMOUNT + RTTCA.TAXCLAIMAMOUNT, REVENUETRIBUTE.AMOUNT) as GROSSAMOUNT,
                    REVENUETRIBUTE.BASECURRENCYID
                from 
                    dbo.REVENUETRIBUTE
                inner join
                    dbo.TRIBUTE on REVENUETRIBUTE.TRIBUTEID = TRIBUTE.ID
                inner join
                    dbo.TRIBUTETYPECODE TYPE on TRIBUTE.TRIBUTETYPECODEID = TYPE.ID
                left join
                    dbo.REVENUETRIBUTETAXCLAIMAMOUNT RTTCA on REVENUETRIBUTE.ID = RTTCA.ID
                where 
                    REVENUETRIBUTE.REVENUEID = @REVENUEID