Table of Contents

Table "Currency Exchange Rate"

ID 330
Namespace: Microsoft.Finance.Currency

Properties

Name Value
Caption Currency Exchange Rate
DataCaptionFields 1
DrillDownPageID Page Microsoft.Finance.Currency."Currency Exchange Rates"
LookupPageID Page Microsoft.Finance.Currency."Currency Exchange Rates"
DataClassification CustomerContent

Fields

Name Type Description
"Currency Code" Code[10]

Specifies the code of the currency on this line.
"Starting Date" Date

Specifies the date on which the exchange rate on this line comes into effect.
"Exchange Rate Amount" Decimal

Specifies the amounts that are used to calculate exchange rates for the currency on this line.
"Adjustment Exch. Rate Amount" Decimal

Specifies the amounts that are used to calculate exchange rates that will be used by the Adjust Exchange Rates batch job.
"Relational Currency Code" Code[10]

Specifies how you want to set up the two currencies, one of the currencies can be LCY, for which you want to register exchange rates.
"Relational Exch. Rate Amount" Decimal

Specifies the amounts that are used to calculate exchange rates for the foreign currency on this line.
"Fix Exchange Rate Amount" Enum Microsoft.Finance.Currency."Fix Exch. Rate Amount Type"

Specifies if the currency's exchange rate can be changed on invoices and journal lines.
"Relational Adjmt Exch Rate Amt" Decimal

Specifies the amounts that are used to calculate exchange rates that will be used by the Adjust Exchange Rates batch job.
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemCreatedByUserName Text[50]
SystemCreatedByFullName Text[80]
SystemModifiedByUserName Text[50]
SystemModifiedByFullName Text[80]
SystemRowVersion BigInteger

Methods

ExchangeAmtLCYToFCY

procedure ExchangeAmtLCYToFCY(Date: Date; CurrencyCode: Code[10]; Amount: Decimal; Factor: Decimal): Decimal

Parameters

Name Type Description
Date Date
CurrencyCode Code[10]
Amount Decimal
Factor Decimal

Returns

Type Description
Decimal

ExchangeAmtFCYToLCY

procedure ExchangeAmtFCYToLCY(Date: Date; CurrencyCode: Code[10]; Amount: Decimal; Factor: Decimal): Decimal

Parameters

Name Type Description
Date Date
CurrencyCode Code[10]
Amount Decimal
Factor Decimal

Returns

Type Description
Decimal

ExchangeRate

procedure ExchangeRate(Date: Date; CurrencyCode: Code[10]): Decimal

Parameters

Name Type Description
Date Date
CurrencyCode Code[10]

Returns

Type Description
Decimal

ExchangeAmtLCYToFCYOnlyFactor

procedure ExchangeAmtLCYToFCYOnlyFactor(Amount: Decimal; Factor: Decimal): Decimal

Parameters

Name Type Description
Amount Decimal
Factor Decimal

Returns

Type Description
Decimal

ExchangeAmtFCYToLCYAdjmt

procedure ExchangeAmtFCYToLCYAdjmt(Date: Date; CurrencyCode: Code[10]; Amount: Decimal; Factor: Decimal): Decimal

Parameters

Name Type Description
Date Date
CurrencyCode Code[10]
Amount Decimal
Factor Decimal

Returns

Type Description
Decimal

ExchangeRateAdjmt

procedure ExchangeRateAdjmt(Date: Date; CurrencyCode: Code[10]): Decimal

Parameters

Name Type Description
Date Date
CurrencyCode Code[10]

Returns

Type Description
Decimal

ExchangeAmount

procedure ExchangeAmount(Amount: Decimal; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; UsePostingDate: Date): Decimal

Parameters

Name Type Description
Amount Decimal
FromCurrencyCode Code[10]
ToCurrencyCode Code[10]
UsePostingDate Date

Returns

Type Description
Decimal

FindCurrency

procedure FindCurrency(Date: Date; CurrencyCode: Code[10]; CacheNo: Integer)

Parameters

Name Type Description
Date Date
CurrencyCode Code[10]
CacheNo Integer

ExchangeAmtFCYToFCY

procedure ExchangeAmtFCYToFCY(Date: Date; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; Amount: Decimal): Decimal

Parameters

Name Type Description
Date Date
FromCurrencyCode Code[10]
ToCurrencyCode Code[10]
Amount Decimal

Returns

Type Description
Decimal

ApplnExchangeAmtFCYToFCY

procedure ApplnExchangeAmtFCYToFCY(Date: Date; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; Amount: Decimal; var ExchRateFound: Boolean): Decimal

Parameters

Name Type Description
Date Date
FromCurrencyCode Code[10]
ToCurrencyCode Code[10]
Amount Decimal
ExchRateFound Boolean

Returns

Type Description
Decimal

GetCurrentCurrencyFactor

procedure GetCurrentCurrencyFactor(CurrencyCode: Code[10]): Decimal

Parameters

Name Type Description
CurrencyCode Code[10]

Returns

Type Description
Decimal

GetLastestExchangeRate

procedure GetLastestExchangeRate(CurrencyCode: Code[10]; var Date: Date; var Amt: Decimal)

Parameters

Name Type Description
CurrencyCode Code[10]
Date Date
Amt Decimal

CurrencyExchangeRateExist

procedure CurrencyExchangeRateExist(CurrencyCode: Code[10]; Date: Date): Boolean

Parameters

Name Type Description
CurrencyCode Code[10]
Date Date

Returns

Type Description
Boolean

SetCurrentCurrencyFactor

procedure SetCurrentCurrencyFactor(CurrencyCode: Code[10]; CurrencyFactor: Decimal)

Parameters

Name Type Description
CurrencyCode Code[10]
CurrencyFactor Decimal

Events

OnAfterFindCurrency

[IntegrationEvent(False,False)]
local procedure OnAfterFindCurrency(var CurrencyExchangeRate: Record "Currency Exchange Rate"; var CurrencyExchangeRateArray: array[2] of Record "Currency Exchange Rate"; Date: Date; CurrencyCode: Code[10]; CacheNo: Integer)

Parameters

Name Type Description
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"
CurrencyExchangeRateArray array[2] of Record "Currency Exchange Rate"
Date Date
CurrencyCode Code[10]
CacheNo Integer

OnExchangeAmtFCYToLCYOnAfterSetRelationalExchRateAmount

[IntegrationEvent(False,False)]
local procedure OnExchangeAmtFCYToLCYOnAfterSetRelationalExchRateAmount(var CurrencyExchangeRate: Record "Currency Exchange Rate")

Parameters

Name Type Description
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"

OnFindCurrencyOnAfterCalcShouldUseCache

[IntegrationEvent(False,False)]
local procedure OnFindCurrencyOnAfterCalcShouldUseCache(var CurrencyExchangeRate: Record "Currency Exchange Rate"; CacheNo: Integer; var ShouldUseCache: Boolean)

Parameters

Name Type Description
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"
CacheNo Integer
ShouldUseCache Boolean

OnFindCurrencyOnAfterCurrencyExchRate2SetFilters

[IntegrationEvent(False,False)]
local procedure OnFindCurrencyOnAfterCurrencyExchRate2SetFilters(var CurrencyExchRate2: Record "Currency Exchange Rate"; CurrencyCode: Code[10]; Date: Date; var CurrencyExchangeRate: Record "Currency Exchange Rate")

Parameters

Name Type Description
CurrencyExchRate2 Table Microsoft.Finance.Currency."Currency Exchange Rate"
CurrencyCode Code[10]
Date Date
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"

OnExchangeRateOnAfterSetRelationalExchRateAmount

[IntegrationEvent(False,False)]
local procedure OnExchangeRateOnAfterSetRelationalExchRateAmount(var CurrencyExchangeRate: Record "Currency Exchange Rate")

Parameters

Name Type Description
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"

OnFindCurrency2OnAfterCurrencyExchRate3SetFilters

[IntegrationEvent(False,False)]
local procedure OnFindCurrency2OnAfterCurrencyExchRate3SetFilters(var CurrencyExchRate3: Record "Currency Exchange Rate"; CurrencyCode: Code[10]; Date: Date; var CurrencyExchangeRate: Record "Currency Exchange Rate")

Parameters

Name Type Description
CurrencyExchRate3 Table Microsoft.Finance.Currency."Currency Exchange Rate"
CurrencyCode Code[10]
Date Date
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"

OnBeforeExchangeAmtLCYToFCY

[IntegrationEvent(False,False)]
local procedure OnBeforeExchangeAmtLCYToFCY(var CurrencyExchangeRate: Record "Currency Exchange Rate"; Date: Date; CurrencyCode: Code[10]; var Amount: Decimal; Factor: Decimal; var RelExchangeRateAmt: Decimal; var ExchangeRateAmt: Decimal; var RelCurrencyCode: Code[10]; FixExchangeRateAmt: Enum "Fix Exch. Rate Amount Type"; var IsHandled: Boolean)

Parameters

Name Type Description
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"
Date Date
CurrencyCode Code[10]
Amount Decimal
Factor Decimal
RelExchangeRateAmt Decimal
ExchangeRateAmt Decimal
RelCurrencyCode Code[10]
FixExchangeRateAmt Enum Microsoft.Finance.Currency."Fix Exch. Rate Amount Type"
IsHandled Boolean

OnBeforeExchangeAmtFCYToLCY

[IntegrationEvent(False,False)]
local procedure OnBeforeExchangeAmtFCYToLCY(var CurrencyExchangeRate: Record "Currency Exchange Rate"; Date: Date; CurrencyCode: Code[10]; var Amount: Decimal; Factor: Decimal; UseAdjmtAmounts: Boolean; var RelExchangeRateAmt: Decimal; var ExchangeRateAmt: Decimal; var RelCurrencyCode: Code[10]; FixExchangeRateAmt: Enum "Fix Exch. Rate Amount Type"; var IsHandled: Boolean)

Parameters

Name Type Description
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"
Date Date
CurrencyCode Code[10]
Amount Decimal
Factor Decimal
UseAdjmtAmounts Boolean
RelExchangeRateAmt Decimal
ExchangeRateAmt Decimal
RelCurrencyCode Code[10]
FixExchangeRateAmt Enum Microsoft.Finance.Currency."Fix Exch. Rate Amount Type"
IsHandled Boolean

OnBeforeExchangeRate

[IntegrationEvent(False,False)]
local procedure OnBeforeExchangeRate(var CurrencyExchangeRate: Record "Currency Exchange Rate"; Date: Date; CurrencyCode: Code[10]; var CurrencyFactor: Decimal; UseAdjmtAmounts: Boolean; var RelExchangeRateAmt: Decimal; var ExchangeRateAmt: Decimal; var RelCurrencyCode: Code[10]; var IsHandled: Boolean)

Parameters

Name Type Description
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"
Date Date
CurrencyCode Code[10]
CurrencyFactor Decimal
UseAdjmtAmounts Boolean
RelExchangeRateAmt Decimal
ExchangeRateAmt Decimal
RelCurrencyCode Code[10]
IsHandled Boolean

OnBeforeExchangeAmtFCYToFCY

[IntegrationEvent(False,False)]
local procedure OnBeforeExchangeAmtFCYToFCY(var CurrencyExchangeRate: Record "Currency Exchange Rate"; Date: Date; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; var Amount: Decimal; CurrencyExchRate3: array[3] of Record "Currency Exchange Rate"; var IsHandled: Boolean)

Parameters

Name Type Description
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"
Date Date
FromCurrencyCode Code[10]
ToCurrencyCode Code[10]
Amount Decimal
CurrencyExchRate3 array[3] of Record "Currency Exchange Rate"
IsHandled Boolean

OnBeforeApplnExchangeAmtFCYToFCY

[IntegrationEvent(False,False)]
local procedure OnBeforeApplnExchangeAmtFCYToFCY(var CurrencyExchangeRate: Record "Currency Exchange Rate"; Date: Date; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; var Amount: Decimal; var ExchRateFound: Boolean; CurrencyExchRate3: array[3] of Record "Currency Exchange Rate"; var IsHandled: Boolean)

Parameters

Name Type Description
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"
Date Date
FromCurrencyCode Code[10]
ToCurrencyCode Code[10]
Amount Decimal
ExchRateFound Boolean
CurrencyExchRate3 array[3] of Record "Currency Exchange Rate"
IsHandled Boolean

OnBeforeGetLatestExchangeRate

[IntegrationEvent(False,False)]
local procedure OnBeforeGetLatestExchangeRate(var CurrencyExchangeRate: Record "Currency Exchange Rate"; CurrencyCode: Code[10]; var Date: Date; var Amount: Decimal; var IsHandled: Boolean)

Parameters

Name Type Description
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"
CurrencyCode Code[10]
Date Date
Amount Decimal
IsHandled Boolean

OnBeforeSetCurrentCurrencyFactor

[IntegrationEvent(False,False)]
local procedure OnBeforeSetCurrentCurrencyFactor(var CurrencyExchangeRate: Record "Currency Exchange Rate"; CurrencyCode: Code[10]; CurrencyFactor: Decimal; var IsHandled: Boolean)

Parameters

Name Type Description
CurrencyExchangeRate Table Microsoft.Finance.Currency."Currency Exchange Rate"
CurrencyCode Code[10]
CurrencyFactor Decimal
IsHandled Boolean

See also