UFN_QUERY_GLACCOUNT

CREATE function [UFN_QUERY_GLACCOUNT](@ACCOUNTSYSTEMID uniqueidentifier)
returns table
as
return
select
    T1.ID,
    T1.ACCOUNTNUMBER,
    T1.ACCOUNTDESCRIPTION,
    (SELECT CATEGORYNAME FROM DBO.PDCATEGORYDEFINITION WHERE PDCATEGORYDEFINITION.ID = PDCATEGORYDEFINITIONID) CATEGORY,
    T1.ACCOUNTALIAS
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 T1.PDACCOUNTSYSTEMID = @ACCOUNTSYSTEMID
    and T4.PDACCOUNTSYSTEMID = @ACCOUNTSYSTEMID