USP_DATALIST_ASKLADDERMONEYFIELDS

Displays a list of all money fields associated with a given query view catalog and tables related by record type.

Parameters

Parameter	Parameter Type	Mode	Description
@QUERYVIEWCATALOGID	uniqueidentifier	IN	Query view catalog
@CURRENCYID	uniqueidentifier	IN	Currency ID

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_ASKLADDERMONEYFIELDS]
(
  @QUERYVIEWCATALOGID uniqueidentifier,
  @CURRENCYID uniqueidentifier = null
)
as
  set nocount on;

  select
    [RECORDTYPE],
    [PARENTTYPE],
    [NAME],
    [DISPLAYNAME],
    [OBJECTNAME],
    [OBJECTTYPE],
    [PRIMARYKEYFIELD],
    [OBJECTKEY]
  from dbo.[UFN_MKTASKLADDER_GETMONEYFIELDS](@QUERYVIEWCATALOGID) as [MONEYFIELDS]
  where @CURRENCYID is null or [MONEYFIELDS].[CURRENCYID] = @CURRENCYID;

  return 0;