Objects/Tables/Table 330 Currency Exchange Rate
Table 330 Currency Exchange Rate in 24
Jonas Paprotka, Base Application 24.5.23489.36097, checked
- App
- Base Application
- Namespace
- Microsoft.Finance.Currency
Fields, 8Keys, 1Procedures, 14Events, 5
Versions171819202122232425262728latest
Source29
Fields, 8
| Id | Name | Type | Obsolete |
|---|
| 1 | Currency Code | Code[10] | - |
| 2 | Starting Date | Date | - |
| 3 | Exchange Rate Amount | Decimal | - |
| 4 | Adjustment Exch. Rate Amount | Decimal | - |
| 5 | Relational Currency Code | Code[10] | - |
| 6 | Relational Exch. Rate Amount | Decimal | - |
| 7 | Fix Exchange Rate Amount | Option | - |
| 8 | Relational Adjmt Exch Rate Amt | Decimal | - |
Keys, 1
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Currency Code, Starting Date | - |
Procedures, 14
| Name | Parameters | Returns | Access | Obsolete |
|---|
| ExchangeAmtLCYToFCY | (Date, Code[10], Decimal, Decimal) | Decimal | public | - |
| ExchangeAmtFCYToLCY | (Date, Code[10], Decimal, Decimal) | Decimal | public | - |
| ExchangeRate | (Date, Code[10]) | Decimal | public | - |
| ExchangeAmtLCYToFCYOnlyFactor | (Decimal, Decimal) | Decimal | public | - |
| ExchangeAmtFCYToLCYAdjmt | (Date, Code[10], Decimal, Decimal) | Decimal | public | - |
| ExchangeRateAdjmt | (Date, Code[10]) | Decimal | public | - |
| ExchangeAmount | (Decimal, Code[10], Code[10], Date) | Decimal | public | - |
| FindCurrency | (Date, Code[10], Integer) | | public | - |
| ExchangeAmtFCYToFCY | (Date, Code[10], Code[10], Decimal) | Decimal | public | - |
| ApplnExchangeAmtFCYToFCY | (Date, Code[10], Code[10], Decimal, var Boolean) | Decimal | public | - |
| GetCurrentCurrencyFactor | (Code[10]) | Decimal | public | - |
| GetLastestExchangeRate | (Code[10], var Date, var Decimal) | | public | - |
| CurrencyExchangeRateExist | (Code[10], Date) | Boolean | public | - |
| SetCurrentCurrencyFactor | (Code[10], Decimal) | | public | - |
Events, 5
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnExchangeAmtFCYToLCYOnAfterSetRelationalExchRateAmount | (var Record Currency Exchange Rate) | - |
| Integration event | OnAfterFindCurrency | (var Record Currency Exchange Rate, var Record Currency Exchange Rate, Date, Code[10], Integer) | - |
| Integration event | OnFindCurrencyOnAfterCalcShouldUseCache | (var Record Currency Exchange Rate, Integer, var Boolean) | - |
| Integration event | OnFindCurrencyOnAfterCurrencyExchRate2SetFilters | (var Record Currency Exchange Rate, Code[10], Date, var Record Currency Exchange Rate) | - |
| Integration event | OnExchangeRateOnAfterSetRelationalExchRateAmount | (var Record Currency Exchange Rate) | - |