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