USP_SIMPLEDATALIST_DATAELEMENT

List of values for specified accounting element.

Parameters

Parameter	Parameter Type	Mode	Description
@SEQUENCE	tinyint	IN	SEQUENCE
@INCLUDEDESCRIPTION	bit	IN	INCLUDEDESCRIPTION
@SEGMENTCOLUMN	tinyint	IN	SEGMENTCOLUMN
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	PDACCOUNTSYSTEMID

Definition

Copy



                CREATE procedure dbo.USP_SIMPLEDATALIST_DATAELEMENT(@SEQUENCE tinyint = null, @INCLUDEDESCRIPTION bit = 0, @SEGMENTCOLUMN tinyint = null, @PDACCOUNTSYSTEMID uniqueidentifier = null) as
        begin
          if @PDACCOUNTSYSTEMID is null
            set @PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'

                    select 
                        PDACCOUNTSEGMENTVALUE.ID as VALUE, 
                        PDACCOUNTSEGMENTVALUE.SHORTDESCRIPTION + case @INCLUDEDESCRIPTION when 0 then '' else ' - ' + PDACCOUNTSEGMENTVALUE.DESCRIPTION end as LABEL
                    from dbo.PDACCOUNTSEGMENTVALUE
                    inner join dbo.PDACCOUNTSTRUCTURE on PDACCOUNTSTRUCTURE.ID = PDACCOUNTSEGMENTVALUE.PDACCOUNTSTRUCTUREID
                    where (PDACCOUNTSTRUCTURE.SEQUENCE = @SEQUENCE or @SEQUENCE is null)
          and (PDACCOUNTSTRUCTURE.SEGMENTCOLUMN = @SEGMENTCOLUMN or @SEGMENTCOLUMN is null)
          and PDACCOUNTSTRUCTURE.PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and PDACCOUNTSTRUCTURE.ISBASICGL = 0
                    order by LABEL
        end