Table currencies

Table currencies hold the display format for numbers in PhreeBooks. Currency exchange rate values are also saved in this table relative to the default currency.

Table Type: MyISAM

Field Type Default Description
currencies_id int (11) NOT NULL PRIMARY KEY - Auto-increment number for record id.
title varchar   Textual description of the currency
code char   ISO currency code
symbol_left varchar   A single character that is appended to a value left of the number
symbol_right varchar   A single character that is appended to a value right of the number
decimal_point char   Character to use to separate whole numbers from the fractional part
thousands_point char   Character to use to separate three digit groups
decimal_places char   Number of number characters to round following the decimal point character
value float   Stores the conversion value from the default currency. This value needs to be manually updated through the Setup -> Currencies screen
last_updated datetime   Time stamp of the last time the record was updated