| id |
integer |
Yes |
Yes |
nextval('currencies_id_seq'::regclass) |
|
| code |
character varying(3) |
No |
No |
|
Currency code |
| country |
character varying(60) |
No |
No |
|
Currency country |
| currency_desc |
character varying(60) |
No |
No |
|
Currency name |
| units_name |
character varying(15) |
No |
No |
|
Unit name |
| fractions_name |
character varying(15) |
No |
No |
|
Fractions name |
| symbol |
character varying(3) |
No |
No |
|
Symbol used for currency |
| decimal_point_symbol |
character varying(1) |
No |
No |
|
Decimal point type used |
| thousands_separator |
character varying(1) |
No |
No |
|
Thousands separator |
| decimal_places |
smallint |
No |
No |
|
How many decimal places to use |
| symbol_position |
character varying(1) |
No |
No |
|
Symbol position, prefix or suffix |
| sell_price_rounding |
smallint |
No |
No |
|
Number of decimals to set the selling rate to |
| selling_conversion |
boolean |
No |
No |
|
Conversion factor from the base rate |
| exchange_rate_method |
character varying(1) |
Yes |
No |
'/'::character varying |
Method used for the conversion / = Direct * = Indirect |
| rate_type |
character varying(1) |
Yes |
No |
'F'::character varying |
Rate type used F = Fixed B = Buy/Sell |
| cheque_date_format |
smallint |
No |
No |
|
How the date is to be formated when printing checks |
| cheque_text |
boolean |
No |
No |
|
|
| gain_loss_gl_acct |
character varying(24) |
No |
No |
|
GL account used when posting gain/loss on currency |
| buy_rate |
numeric(13,7) |
Yes |
No |
1 |
The buy rate |
| indirect_buy_rate |
numeric(13,7) |
Yes |
No |
1 |
Indirect buy rate |
| sell_rate |
numeric(13,7) |
Yes |
No |
1 |
Sell rate |
| indirect_sell_rate |
numeric(13,7) |
Yes |
No |
1 |
Indirect sell rate |
| fixed_rate |
numeric(13,7) |
Yes |
No |
1 |
Fixed rate |
| indirect_fixed_rate |
numeric(13,7) |
Yes |
No |
1 |
Indirect fixed rate |
| last_year_rate01 |
numeric(13,7) |
No |
No |
|
Last year rate period 1 |
| last_year_rate02 |
numeric(13,7) |
No |
No |
|
Last year rate period 2 |
| last_year_rate03 |
numeric(13,7) |
No |
No |
|
Last year rate period 3 |
| last_year_rate04 |
numeric(13,7) |
No |
No |
|
Last year rate period 4 |
| last_year_rate05 |
numeric(13,7) |
No |
No |
|
Last year rate period 5 |
| last_year_rate06 |
numeric(13,7) |
No |
No |
|
Last year rate period 6 |
| last_year_rate07 |
numeric(13,7) |
No |
No |
|
Last year rate period 7 |
| last_year_rate08 |
numeric(13,7) |
No |
No |
|
Last year rate period 8 |
| last_year_rate09 |
numeric(13,7) |
No |
No |
|
Last year rate period 9 |
| last_year_rate10 |
numeric(13,7) |
No |
No |
|
Last year rate period 10 |
| last_year_rate11 |
numeric(13,7) |
No |
No |
|
Last year rate period 11 |
| last_year_rate12 |
numeric(13,7) |
No |
No |
|
Last year rate period 12 |
| last_year_rate13 |
numeric(13,7) |
No |
No |
|
Last year rate period 13 |
| this_year_rate01 |
numeric(13,7) |
No |
No |
|
This year rate period 1 |
| this_year_rate02 |
numeric(13,7) |
No |
No |
|
This year rate period 2 |
| this_year_rate03 |
numeric(13,7) |
No |
No |
|
This year rate period 3 |
| this_year_rate04 |
numeric(13,7) |
No |
No |
|
This year rate period 4 |
| this_year_rate05 |
numeric(13,7) |
No |
No |
|
This year rate period 5 |
| this_year_rate06 |
numeric(13,7) |
No |
No |
|
This year rate period 6 |
| this_year_rate07 |
numeric(13,7) |
No |
No |
|
This year rate period 7 |
| this_year_rate08 |
numeric(13,7) |
No |
No |
|
This year rate period 8 |
| this_year_rate09 |
numeric(13,7) |
No |
No |
|
This year rate period 9 |
| this_year_rate10 |
numeric(13,7) |
No |
No |
|
This year rate period 10 |
| this_year_rate11 |
numeric(13,7) |
No |
No |
|
This year rate period 11 |
| this_year_rate12 |
numeric(13,7) |
No |
No |
|
This year rate period 12 |
| this_year_rate13 |
numeric(13,7) |
No |
No |
|
This year rate period 13 |
| next_year_rate01 |
numeric(13,7) |
No |
No |
|
next year rate period 1 |
| next_year_rate02 |
numeric(13,7) |
No |
No |
|
This year rate period 2 |
| next_year_rate03 |
numeric(13,7) |
No |
No |
|
This year rate period 3 |
| next_year_rate04 |
numeric(13,7) |
No |
No |
|
This year rate period 4 |
| next_year_rate05 |
numeric(13,7) |
No |
No |
|
This year rate period 5 |
| next_year_rate06 |
numeric(13,7) |
No |
No |
|
This year rate period 6 |
| next_year_rate07 |
numeric(13,7) |
No |
No |
|
This year rate period 7 |
| next_year_rate08 |
numeric(13,7) |
No |
No |
|
This year rate period 8 |
| next_year_rate09 |
numeric(13,7) |
No |
No |
|
This year rate period 9 |
| next_year_rate10 |
numeric(13,7) |
No |
No |
|
This year rate period 10 |
| next_year_rate11 |
numeric(13,7) |
No |
No |
|
This year rate period 11 |
| next_year_rate12 |
numeric(13,7) |
No |
No |
|
This year rate period 12 |
| next_year_rate13 |
numeric(13,7) |
No |
No |
|
This year rate period 13 |
| sell_price_level01 |
boolean |
No |
No |
|
Set customer to this sell level when creating new customer set at this currency |
| sell_price_level02 |
boolean |
No |
No |
|
|
| sell_price_level03 |
boolean |
No |
No |
|
|
| sell_price_level04 |
boolean |
No |
No |
|
|
| sell_price_level05 |
boolean |
No |
No |
|
|
| sell_price_level06 |
boolean |
No |
No |
|
|
| sell_price_level07 |
boolean |
No |
No |
|
|
| sell_price_level08 |
boolean |
No |
No |
|
|
| sell_price_level09 |
boolean |
No |
No |
|
|
| sell_price_level10 |
boolean |
No |
No |
|
|
| sell_price_level11 |
boolean |
No |
No |
|
|
| sell_price_level12 |
boolean |
No |
No |
|
|
| sell_price_level13 |
boolean |
No |
No |
|
|
| sell_price_level14 |
boolean |
No |
No |
|
|
| sell_price_level15 |
boolean |
No |
No |
|
|
| sell_price_level16 |
boolean |
No |
No |
|
|
| sell_price_level17 |
boolean |
No |
No |
|
|
| sell_price_level18 |
boolean |
No |
No |
|
|
| sell_price_level19 |
boolean |
No |
No |
|
|
| sell_price_level20 |
boolean |
No |
No |
|
|
| sell_price_level21 |
boolean |
No |
No |
|
|
| sell_price_level22 |
boolean |
No |
No |
|
|
| sell_price_level23 |
boolean |
No |
No |
|
|
| sell_price_level24 |
boolean |
No |
No |
|
|
| sell_price_level25 |
boolean |
No |
No |
|
|
| sell_price_level26 |
boolean |
No |
No |
|
|
| sell_price_level27 |
boolean |
No |
No |
|
|
| sell_price_level28 |
boolean |
No |
No |
|
|
| sell_price_level29 |
boolean |
No |
No |
|
|
| sell_price_level30 |
boolean |
No |
No |
|
|
| _dbversion |
integer |
No |
No |
|
|
| _created |
timestamp without time zone |
No |
No |
|
|
| _created_by |
character varying(3) |
No |
No |
|
|
| _modified |
timestamp without time zone |
No |
No |
|
|
| _modified_by |
character varying(3) |
No |
No |
|
|