UFN_OPPORTUNITYDESIGNATION_CONVERTAMOUNTSINXML

Fills in multicurrency fields in the given opportunity designation splits XML.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode
@DESIGNATION	xml	IN
@BASECURRENCYID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@DATE	datetime	IN

Definition

Copy



CREATE function dbo.UFN_OPPORTUNITYDESIGNATION_CONVERTAMOUNTSINXML(
  @DESIGNATION xml,
  @BASECURRENCYID uniqueidentifier,
  @TRANSACTIONCURRENCYID uniqueidentifier,
  @BASEEXCHANGERATEID uniqueidentifier,
  @DATE datetime
)
returns xml
as begin

  return (
    select
      ID,
      DESIGNATIONID,
      AMOUNT,
      TRANSACTIONAMOUNT,
      ORGANIZATIONAMOUNT,
      SEQUENCE,
      CONSTITUENTID,
      CONSTITUENTNAME,
      @BASECURRENCYID [BASECURRENCYID],
      @TRANSACTIONCURRENCYID [TRANSACTIONCURRENCYID],
      @BASEEXCHANGERATEID [BASEEXCHANGERATEID],
      ORGANIZATIONEXCHANGERATEID [ORGANIZATIONEXCHANGERATEID],
      FUNDINGMETHODCODEID,
      CATEGORYCODEID,
      TYPECODEID,
      USECODEID      
    from (
      select
        ID,
        DESIGNATIONID,
        AMOUNT [TRANSACTIONAMOUNT],
        CURRENCYVALUES.BASEAMOUNT [AMOUNT],
        CURRENCYVALUES.ORGANIZATIONAMOUNT,
        SEQUENCE,
        CONSTITUENTID,
        CONSTITUENTNAME,
        CURRENCYVALUES.ORGANIZATIONEXCHANGERATEID,
        FUNDINGMETHODCODEID,
        CATEGORYCODEID,
        TYPECODEID,
        USECODEID
      from
        dbo.UFN_OPPORTUNITY_DESIGNATION_2_FROMITEMLISTXML(@DESIGNATION)
      cross apply
        dbo.UFN_CURRENCY_GETCURRENCYVALUES(AMOUNT, @DATE, @BASECURRENCYID, @BASEEXCHANGERATEID, @TRANSACTIONCURRENCYID) CURRENCYVALUES
    ) DESIGNATION
    for xml raw('ITEM'),type,elements,root('DESIGNATION'),BINARY BASE64
  )

end