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
);