UFN_OPPORTUNITYAMOUNTBRACKET_CONVERTAMOUNTSINXML

Fills in multicurrency fields in the given brackets XML.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode
@OPPORTUNITYAMOUNTBRACKETS	xml	IN
@BASECURRENCYID	uniqueidentifier	IN
@ORGANIZATIONEXCHANGERATEID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_OPPORTUNITYAMOUNTBRACKET_CONVERTAMOUNTSINXML(
  @OPPORTUNITYAMOUNTBRACKETS xml,
  @BASECURRENCYID uniqueidentifier,
  @ORGANIZATIONEXCHANGERATEID uniqueidentifier
)
returns xml
as begin

  declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

    return (
    select
      ID,
      NAME,
      LOWERLIMIT,
      ORGANIZATIONLOWERLIMIT,
      @BASECURRENCYID [BASECURRENCYID],
      @ORGANIZATIONEXCHANGERATEID [ORGANIZATIONEXCHANGERATEID]
    from (
      select
        ID,
        NAME,
        LOWERLIMIT,
        case 
          when @BASECURRENCYID <> @ORGANIZATIONCURRENCYID then 
            dbo.UFN_CURRENCY_CONVERT(LOWERLIMIT, @ORGANIZATIONEXCHANGERATEID)
          else 
            LOWERLIMIT
        end ORGANIZATIONLOWERLIMIT
      from
        dbo.UFN_OPPORTUNITYAMOUNTBRACKET_GETBRACKETS_2_FROMITEMLISTXML(@OPPORTUNITYAMOUNTBRACKETS)
    ) OPPORTUNITYAMOUNTBRACKETS
    for xml raw('ITEM'),type,elements,root('OPPORTUNITYAMOUNTBRACKETS'),BINARY BASE64
  )
end