Understanding Currency Precision

According to the ISO standard, currency precision can range from no decimals to 3 decimals. For example, U.S. dollar amounts have 2 digits to the right of the decimal; Japanese yen have none. To support this dynamic currency precision, PeopleSoft delivers all of its currency-sensitive amount fields with a standard length of 13.2; that is, 13 digits to the left of the decimal and 2 digits to the right. Optionally, with some modification, you can expand these amount fields in your system to a maximum of 15.3 digits. There is a controlled currency on the same record to control the display and processing of such amount fields.

PeopleSoft rounds all currency-sensitive amount fields to the currency precision of the controlled currency during all online or background processes. For example, in a database containing amount fields with a length of 15.3, Japanese yen are rounded to 123.000 and U.S. dollars are rounded to 123.230. The system doesn't place a nonzero amount after the decimal for a Japanese amount or after the second digit to the right of the decimal for a U.S. amount.

PeopleSoft displays the amount fields on the online pages with the proper precision. For example, it displays Japanese yen as 123 and U.S. dollars as 123.23. When entering an amount, you can't enter more than the defined precision; if you do, the system treats the entry as an online error.

PeopleCode programs and background processes round all currency-sensitive amount fields to the currency precision of the controlled currency.