Table 330 Currency Exchange Rate

Base Application, Microsoft.Finance.Currency

Fields 8 in 29.0, US

1Currency CodeCode[10]17-29
2Starting DateDate17-29
3Exchange Rate AmountDecimal17-29
4Adjustment Exch. Rate AmountDecimal17-29
5Relational Currency CodeCode[10]17-29
6Relational Exch. Rate AmountDecimal17-29
7Fix Exchange Rate AmountEnum "Fix Exch. Rate Amount Type"17-29changed in 25
8Relational Adjmt Exch Rate AmtDecimal17-29

Events 13 in 29.0, US

[IntegrationEvent] OnExchangeAmtFCYToLCYOnAfterSetRelationalExchRateAmount(var CurrencyExchangeRate: Record "Currency Exchange Rate")17-29
[IntegrationEvent] OnAfterFindCurrency(var CurrencyExchangeRate: Record "Currency Exchange Rate"; var CurrencyExchangeRateArray: array[2] of Record "Currency Exchange Rate"; Date: Date; CurrencyCode: Code[10]; CacheNo: Integer)new in 18
[IntegrationEvent] OnFindCurrencyOnAfterCalcShouldUseCache(var CurrencyExchangeRate: Record "Currency Exchange Rate"; CacheNo: Integer; var ShouldUseCache: Boolean)new in 18
[IntegrationEvent] OnFindCurrencyOnAfterCurrencyExchRate2SetFilters(var CurrencyExchRate2: Record "Currency Exchange Rate"; CurrencyCode: Code[10]; Date: Date; var CurrencyExchangeRate: Record "Currency Exchange Rate")new in 21
[IntegrationEvent] OnExchangeRateOnAfterSetRelationalExchRateAmount(var CurrencyExchangeRate: Record "Currency Exchange Rate")new in 23
[IntegrationEvent] OnFindCurrency2OnAfterCurrencyExchRate3SetFilters(var CurrencyExchRate3: Record "Currency Exchange Rate"; CurrencyCode: Code[10]; Date: Date; var CurrencyExchangeRate: Record "Currency Exchange Rate")new in 25
[IntegrationEvent] 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)new in 29

All 13 events

Public procedures 14 in 29.0, US

ExchangeAmtLCYToFCY(Date: Date; CurrencyCode: Code[10]; Amount: Decimal; Factor: Decimal): Decimal17-29
ExchangeAmtFCYToLCY(Date: Date; CurrencyCode: Code[10]; Amount: Decimal; Factor: Decimal): Decimal17-29
ExchangeRate(Date: Date; CurrencyCode: Code[10]): Decimal17-29
ExchangeAmtLCYToFCYOnlyFactor(Amount: Decimal; Factor: Decimal): Decimal17-29
ExchangeAmtFCYToLCYAdjmt(Date: Date; CurrencyCode: Code[10]; Amount: Decimal; Factor: Decimal): Decimal17-29
ExchangeRateAdjmt(Date: Date; CurrencyCode: Code[10]): Decimal17-29

All 14 procedures

Trigger events 10

OnBeforeInsertEvent(var Rec: Record "Currency Exchange Rate"; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record "Currency Exchange Rate"; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record "Currency Exchange Rate"; var xRec: Record "Currency Exchange Rate"; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record "Currency Exchange Rate"; var xRec: Record "Currency Exchange Rate"; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record "Currency Exchange Rate"; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record "Currency Exchange Rate"; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record "Currency Exchange Rate"; var xRec: Record "Currency Exchange Rate"; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record "Currency Exchange Rate"; var xRec: Record "Currency Exchange Rate"; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record "Currency Exchange Rate"; var xRec: Record "Currency Exchange Rate"; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record "Currency Exchange Rate"; var xRec: Record "Currency Exchange Rate"; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 7 in 29.0

List17181920212223242526272829
Fields1
Events42117
[IntegrationEvent] 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)new in 29
added
[IntegrationEvent] 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)new in 29
added
[IntegrationEvent] 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)new in 29
added
[IntegrationEvent] 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)new in 29
added
[IntegrationEvent] 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)new in 29
added
[IntegrationEvent] OnBeforeGetLatestExchangeRate(var CurrencyExchangeRate: Record "Currency Exchange Rate"; CurrencyCode: Code[10]; var Date: Date; var Amount: Decimal; var IsHandled: Boolean)new in 29
added

All 7 changes in 29.0, US