292Currencies
ISO 4217 currencies. One of them is the base currency that rates are quoted in.
Try it
Money formatting
Symbol + rounding to each currency's decimal_places (JPY and KRW have none)AUD
A$1,234,567.89
CNY
Β₯1,234,567.89
EUR
β¬1,234,567.89
GBP
Β£1,234,567.89
HKD
HK$1,234,567.89
JPY
Β₯1,234,568
KRW
β©1,234,568
SGD
S$1,234,567.89
THB
ΰΈΏ1,234,567.89
USD
$1,234,567.89
| # | Code | Name | Symbol | Decimals | Base currency | Status | |
|---|---|---|---|---|---|---|---|
| 9 | AUD | Australian Dollar | A$ | 2 | Active | βοΈ | |
| 6 | CNY | Chinese Yuan | Β₯ | 2 | Active | βοΈ | |
| 3 | EUR | Euro | β¬ | 2 | Active | βοΈ | |
| 5 | GBP | Pound Sterling | Β£ | 2 | Active | βοΈ | |
| 8 | HKD | Hong Kong Dollar | HK$ | 2 | Active | βοΈ | |
| 4 | JPY | Japanese Yen | Β₯ | 0 | Active | βοΈ | |
| 10 | KRW | Korean Won | β© | 0 | Active | βοΈ | |
| 7 | SGD | Singapore Dollar | S$ | 2 | Active | βοΈ | |
| 1 | THB | Thai Baht | ΰΈΏ | 2 | β | Active | βοΈ |
| 2 | USD | US Dollar | $ | 2 | Active | βοΈ |
Showing 1β10 of 10
π Learn: how this master is built table currency
Key points
- Filtered unique index: CREATE UNIQUE INDEX ... ON currency(base_currency) WHERE base_currency = 1.
- decimal_places decides rounding: JPY 0, THB 2.
Code
- Entity
domain/Currency.java- Repository
repo/CurrencyRepository.java- Definition
MasterRegistry: "currencies"- Page / form
web/MasterController.java- Try-it panel
templates/tools/currency-format.html- REST API
GET /api/masters/currencies
SQL to try in SSMS (database MasterDataLabDB)
SELECT code, symbol, decimal_places FROM currency WHERE base_currency = 1;