UFN_PDACCOUNTSYSTEM_DEFAULTORSYSTEM

Return

Return Type
table

Definition

Copy


CREATE function dbo.UFN_PDACCOUNTSYSTEM_DEFAULTORSYSTEM()
returns table
as return (
    select top 1
        ID,
        ALLOWGLDISTRIBUTIONS,
        CURRENCYSETID,
        DEFAULTGLACCOUNTID
    from
        dbo.PDACCOUNTSYSTEM
    where
        ISDEFAULT = 1
        or ID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'
    order by
        ISDEFAULT desc
);