UFN_DEPOSITDIFFERENCE

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@CURRENTAMOUNT	money	IN
@PREVIOUSAMOUNT	money	IN
@FIRSTEXCHANGERATEID	uniqueidentifier	IN
@SECONDEXCHANGERATEID	uniqueidentifier	IN
@THIRDEXCHANGERATEID	uniqueidentifier	IN

Definition

Copy



create function UFN_DEPOSITDIFFERENCE (
  @CURRENTAMOUNT money
  ,@PREVIOUSAMOUNT money
  ,@FIRSTEXCHANGERATEID uniqueidentifier
  ,@SECONDEXCHANGERATEID uniqueidentifier 
  ,@THIRDEXCHANGERATEID uniqueidentifier
) 
returns money 
begin
  return 
    isnull( 
      dbo.UFN_DEPOSIT_CURRENCYCONVERT(        
        dbo.UFN_DEPOSIT_CURRENCYCONVERT(        
          dbo.UFN_DEPOSIT_CURRENCYCONVERT(@CURRENTAMOUNT
              ,@FIRSTEXCHANGERATEID) 
            ,@SECONDEXCHANGERATEID)
          ,@THIRDEXCHANGERATEID)
      , 0)
    - isnull( 
      dbo.UFN_DEPOSIT_CURRENCYCONVERT(        
        dbo.UFN_DEPOSIT_CURRENCYCONVERT(        
          dbo.UFN_DEPOSIT_CURRENCYCONVERT(@PREVIOUSAMOUNT
              ,@FIRSTEXCHANGERATEID) 
            ,@SECONDEXCHANGERATEID)
          ,@THIRDEXCHANGERATEID)
      , 0)
  ;
end