USP_SIMPLEDATALIST_BYACCOUNTSTRUCTURE_DATAELEMENT

List of accounting element values for the specified account structure.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_SIMPLEDATALIST_BYACCOUNTSTRUCTURE_DATAELEMENT(@GLACCOUNTSTRUCTUREID uniqueidentifier, @CURRENTAPPUSERID uniqueidentifier) as
begin
  if dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1
      select 
          PDACCOUNTSEGMENTVALUE.ID as VALUE, 
          PDACCOUNTSEGMENTVALUE.SHORTDESCRIPTION as LABEL,
          PDACCOUNTSEGMENTVALUE.DESCRIPTION as DESCRIPTION
      from dbo.PDACCOUNTSEGMENTVALUE
      where PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID = @GLACCOUNTSTRUCTUREID
      order by PDACCOUNTSEGMENTVALUE.SHORTDESCRIPTION, PDACCOUNTSEGMENTVALUE.DESCRIPTION
    else
    /* Only elements which this user is assigned can be selected */
      select
          PDACCOUNTSEGMENTVALUE.ID as VALUE, 
          PDACCOUNTSEGMENTVALUE.SHORTDESCRIPTION as LABEL,
          PDACCOUNTSEGMENTVALUE.DESCRIPTION as DESCRIPTION
      from dbo.PDACCOUNTSEGMENTVALUE
      inner join dbo.UFN_ACCOUNTINGELEMENT_ELEMENTSFORUSER(@CURRENTAPPUSERID) V1 on V1.ELEMENTID = PDACCOUNTSEGMENTVALUE.ID
      where PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID = @GLACCOUNTSTRUCTUREID
      order by PDACCOUNTSEGMENTVALUE.SHORTDESCRIPTION, PDACCOUNTSEGMENTVALUE.DESCRIPTION
end