UFN_ACCOUNTCODE_GETMETADATA

Returns a table with metadata for all account codes

Return

Return Type
table

Definition

Copy


CREATE function dbo.UFN_ACCOUNTCODE_GETMETADATA()
returns table
as 
    return
    select
        ID, 
        dbo.UFN_GETCATEGORYNAMEFROMID(ID) as CATEGORY,
        dbo.UFN_GETSUBCATEGORYNAMEFROMID(ID) as SUBCATEGORY, 
        (dbo.UFN_GETCATEGORYBALANCEFROMID(ID)) as BALANCETYPE,
        CONTRAACCOUNT as ISCONTRA
    from dbo.ACCOUNTCODE