USP_SIMPLEDATALIST_MKTASKLADDER_CURRENCYFIELDS
Returns a simple list of all money fields for a given record source.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RECORDSOURCEID | uniqueidentifier | IN | Record source ID |
| @CURRENCYID | uniqueidentifier | IN | Currency ID |
Definition
Copy
CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTASKLADDER_CURRENCYFIELDS]
(
@RECORDSOURCEID uniqueidentifier = null,
@CURRENCYID uniqueidentifier = null
)
as
set nocount on;
select distinct
[MONEYFIELDS].[OBJECTKEY] as [VALUE],
[MONEYFIELDS].[PARENTTYPE] + ' \ ' + [MONEYFIELDS].[DISPLAYNAME] as [LABEL]
from dbo.[UFN_MKTASKLADDER_GETMONEYFIELDS](@RECORDSOURCEID) as [MONEYFIELDS]
where @CURRENCYID is null or [MONEYFIELDS].[CURRENCYID] = @CURRENCYID
order by [LABEL];
return 0;