USP_DATALIST_GLACCOUNT

                CREATE procedure USP_DATALIST_GLACCOUNT
                (
                @ACCOUNTCODE nvarchar(8) = '',
                @DESCRIPTION nvarchar(100) = ''
                )
                as
                    set nocount on;

                    select
                        T1.ID,
                        T1.ACCOUNTNUMBER,
                        T1.ACCOUNTDESCRIPTION,
                        (SELECT CATEGORYNAME FROM DBO.PDCATEGORYDEFINITION WHERE PDCATEGORYDEFINITION.ID = PDCATEGORYDEFINITIONID) CATEGORY
                        from GLACCOUNT T1
                    inner join PDACCOUNTSEGMENT T2 on T1.ID=T2.GLACCOUNTID 
                    inner join PDACCOUNTSEGMENTVALUE T3 on T2.PDACCOUNTSEGMENTVALUEID = T3.ID 
                    inner join PDACCOUNTSTRUCTURE T4 on T4.ID =T3.PDACCOUNTSTRUCTUREID 
                    where 
                        SEGMENTTYPE = 1
                    and 
                        T3.SHORTDESCRIPTION like @ACCOUNTCODE + '%'
                    and
                        T1.ACCOUNTDESCRIPTION like '%' + @DESCRIPTION + '%'
                    and 
                        T1.PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'

                    order by T1.ACCOUNTNUMBER