USP_DATALIST_TAXGLMAPPING

A datalist of all taxes and their GL mappings

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



                create procedure dbo.USP_DATALIST_TAXGLMAPPING(@CURRENTAPPUSERID uniqueidentifier = null)
                as                 
                    set nocount on;

                    select 
                        TAX.ID, 
                        TAX.[NAME] as TAXNAME,
                        MAP.ACCOUNTNUMBER,
                        MAP.PROJECTCODE,
                        'IMAGEKEY' = case when (MAP.ACCOUNTNUMBER is null or MAP.ACCOUNTNUMBER = '' 
                                        or MAP.PROJECTCODE is null or MAP.PROJECTCODE = '') then 'RES:warning' else '' end
                    from dbo.TAX
                    left join dbo.TAXGLMAPPING as MAP on TAX.ID = MAP.ID
                    order by TAX.NAME;