Table a_currency
Diagram AccountsPayable 
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
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