USP_SIMPLEDATALIST_ACCOUNTELEMENTDESCRIPTION
List of all account segment elements
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@PDACCOUNTSYSTEMID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_ACCOUNTELEMENTDESCRIPTION(@PDACCOUNTSYSTEMID uniqueidentifier = null) as
select
ID as VALUE,
DESCRIPTION + ' description' as LABEL
from dbo.PDACCOUNTSTRUCTURE
where ELEMENTTYPECODE = 1 and PDACCOUNTSYSTEMID = isnull(@PDACCOUNTSYSTEMID,'4B121C2C-CCE6-440D-894C-EA0DEF80D50B') and ISBASICGL = 0
order by SEGMENTSEQUENCE