USP_SIMPLEDATALIST_PDACCOUNTSTRUCTUREITEM
Returns a list of all defined account structure items.
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTSTRUCTUREITEM as
select
ID as VALUE,
DESCRIPTION as LABEL
from dbo.PDACCOUNTSTRUCTURE
where SEGMENTTYPE = 3
and PDACCOUNTSYSTEMID='4B121C2C-CCE6-440D-894C-EA0DEF80D50B'
order by SEQUENCE