USP_SIMPLEDATALIST_PDACCOUNTSEGMENTVALUES
Returns a list of segment values.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PDACCOUNTSTRUCTUREID | uniqueidentifier | IN | Account Structure |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_PDACCOUNTSEGMENTVALUES(
@PDACCOUNTSTRUCTUREID uniqueidentifier
)
as
select
ID as VALUE,
SHORTDESCRIPTION as LABEL
from dbo.PDACCOUNTSEGMENTVALUE
where PDACCOUNTSTRUCTUREID = @PDACCOUNTSTRUCTUREID
order by SHORTDESCRIPTION