USP_SIMPLEDATALIST_PDACCOUNTSTRUCTUREITEM2
Returns a list of all defined account structure items for a system.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PDACCOUNTSYSTEMID | uniqueidentifier | IN | PDACCOUNTSYSTEMID |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTSTRUCTUREITEM2
(
@PDACCOUNTSYSTEMID uniqueidentifier
) as
select
ID as VALUE,
DESCRIPTION as LABEL
from dbo.PDACCOUNTSTRUCTURE
where SEGMENTTYPE = 3 and PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID
order by SEQUENCE