USP_DATALIST_PDACCOUNTSYSTEM

Returns a list of account structure systems.

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PDACCOUNTSYSTEM
(
    @CURRENTAPPUSERID uniqueidentifier = null
)
as
    set nocount on;

    select ID, 
        NAME, 
        DESCRIPTION,
        ISDEFAULT,
        dbo.UFN_PDACCOUNTSYSTEM_SITESTRING(ID) SITES,
        dbo.UFN_PDACCOUNTSYSTEM_CANDELETE(ID) CANDELETE,
        dbo.UFN_CURRENCYSET_GETNAME(CURRENCYSETID) CURRENCYSETNAME
    from dbo.PDACCOUNTSYSTEM
    where -- ISBASICGL = 1 and 

    ID in (select T1.ID from dbo.UFN_PDACCOUNTSYSTEM_GETSYSTEMIDSFORUSERONFEATURE(@CURRENTAPPUSERID,'233a7b0d-677f-47b1-8b21-fd1896305b89',2) T1)