Description:
Unit of money for various countries.
|
| PRIMARY KEY |
|
a_currency_code_c
varchar (16) NOT NULL |
This defines which currency is being used
| |
|
|
a_currency_name_c
varchar (64) NOT NULL |
This is the name of the currency
| |
|
a_currency_symbol_c
varchar (8) NOT NULL |
This is the symbol used to show a currency. Eg $US or £
| |
|
p_country_code_c
varchar (8) NOT NULL |
Country code
| p_country |
|
a_display_format_c
varchar (40) default: '->>>,>>>,>>>,>>9.99' NOT NULL |
The format in which to display and accept input on a currency (decimal values)
| |
|
a_in_emu_l
boolean default: '0' NOT NULL |
Indicates whether currency is part of the european exchange rate mechanism/ European Monetary Union
| |
|
s_date_created_d
date default: CURRENT_DATE |
The date the record was created.
| |
|
s_created_by_c
varchar (20) |
User ID of who created this record.
| s_user |
|
s_date_modified_d
date |
The date the record was modified.
| |
|
s_modified_by_c
varchar (20) |
User ID of who last modified this record.
| s_user |
|
s_modification_id_t
timestamp default: CURRENT_TIMESTAMP |
This identifies the current version of the record.
| |
FOREIGN KEY
a_currency_fk1: p_country_code_c => p_country
a_currency_fkcr: s_created_by_c => s_user
a_currency_fkmd: s_modified_by_c => s_user
|
REFERENCED BY
p_publication_cost,
a_ledger,
a_ledger,
a_corporate_exchange_rate,
a_corporate_exchange_rate,
a_daily_exchange_rate,
a_daily_exchange_rate,
a_currency_language,
a_ar_article_price,
a_ar_discount,
p_data_label,
p_unit,
p_venue,
a_account,
a_ep_statement,
a_recurring_journal,
a_recurring_transaction,
a_recurring_transaction,
a_recurring_gift_batch,
a_gift_batch,
a_journal,
a_journal,
a_ap_supplier,
a_ar_invoice,
a_ar_invoice_detail,
pm_general_application,
um_unit_cost,
pc_conference |
|