Table idempiere11.adempiere.c_currency
The Currency for this record

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_currency_id numeric 10
a_asset_addition.c_currency_id ccurrency_aassetaddition R
a_asset_reval_entry.c_currency_id ccurrency_aassetrevalentry R
a_depreciation_entry.c_currency_id ccurrency_adepreciationentry R
ad_registration.c_currency_id ccurrency_adregistration R
ad_role.c_currency_id c_currency_ad_role R
c_acctschema.c_currency_id c_currency_c_acctschema R
c_allocationhdr.c_currency_id ccurrency_callocation R
c_bankaccount.c_currency_id ccurrency_cbankaccount R
c_bankaccount_processor.c_currency_id ccurrency_cbankaccountprocesso R
c_bankstatementline.c_currency_id ccurrency_cbankstmtline R
c_banktransfer.from_c_currency_id fromccurrency_cbanktransfer R
c_banktransfer.to_c_currency_id toccurrency_cbanktransfer R
c_cashbook.c_currency_id ccurrency_ccashbook R
c_cashline.c_currency_id ccurrency_ccashline R
c_commission.c_currency_id ccurrency_ccommission R
c_commissiondetail.c_currency_id ccurrency_ccommissiondetail R
c_conversion_rate.c_currency_id ccurrency_cconversionrate R
c_conversion_rate.c_currency_id_to c_currencyconvrateto R
c_country.c_currency_id ccurrency_ccountry R
c_currency_acct.c_currency_id ccurrency_ccurrencyacct C
c_currency_trl.c_currency_id ccurrency_ccurrencytrl C
c_cycle.c_currency_id ccurrency_ccycle R
c_dunningrunentry.c_currency_id ccurrency_cdunningrunentry R
c_elementvalue.c_currency_id ccurrency_celementvalue R
c_invoice.c_currency_id ccurrency_cinvoice R
c_invoicebatch.c_currency_id ccurrency_cinvoicebatch R
c_opportunity.c_currency_id ccurrency_copportunity R
c_order.c_currency_id ccurrency_corder R
c_orderline.c_currency_id ccurrency_corderline R
c_payment.c_currency_id ccurrency_cpayment R
c_paymentprocessor.c_currency_id ccurrency_cpaymentprocessor R
c_paymenttransaction.c_currency_id ccurrency_cpaymenttransaction R
c_project.c_currency_id ccurrency_cproject R
c_revenuerecognition_plan.c_currency_id ccurrency_crevenuerecplan R
c_rfq.c_currency_id ccurrency_crfq R
c_rfqresponse.c_currency_id ccurrency_crfqresponse R
c_taxdeclarationline.c_currency_id ccurrency_ctaxdeclline R
fact_acct.c_currency_id c_currency_fact_acct R
gl_journal.c_currency_id ccurrency_gljournal R
gl_journalbatch.c_currency_id ccurrency_gljournalbatch R
gl_journalline.c_currency_id ccurrency_gljournalline R
i_bankstatement.c_currency_id ccurrency_ibankstatement N
i_conversion_rate.c_currency_id ccurrency_iconvrate N
i_conversion_rate.c_currency_id_to ccurrency_iconvrateto N
i_fajournal.c_currency_id ccurrency_ifajournal R
i_fixedasset.c_currency_id ccurrency_ifixedasset R
i_gljournal.c_currency_id ccurrency_igljournal N
i_invoice.c_currency_id ccurrency_iinvoice N
i_order.c_currency_id ccurrency_iorder N
i_payment.c_currency_id ccurrency_ipayment R
i_pricelist.c_currency_id ccurrency_ipricelist R
i_product.c_currency_id ccurrency_iproduct N
m_bp_price.c_currency_id ccurrency_mbpprice R
m_freight.c_currency_id ccurrency_mfreight R
m_inventory.c_currency_id ccurrency_minventory R
m_package.c_currency_id ccurrency_mpackage R
m_pricelist.c_currency_id ccurrency_mpricelist R
m_product_po.c_currency_id ccurrency_mproductpo R
m_rma.c_currency_id ccurrency_mrma R
m_shippingtransaction.c_currency_id ccurrency_mshippingtransaction R
pa_reportcolumn.c_currency_id ccurrency_pareportcolumn R
s_timeexpenseline.c_currency_id ccurrency_stimeexpenseline R
t_aging.c_currency_id ccurrency_taging C
t_inventoryvalue.c_currency_id ccurrency_tinventoryvalue C
The Currency for this record
ad_client_id numeric 10
ad_client.ad_client_id c_currencyclient R
Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id c_currencyorg R
Organizational entity within tenant
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
iso_code bpchar 3 Three letter ISO 4217 Code of the Currency
cursymbol varchar 10  √  null Symbol of the currency (opt used for printing only)
description varchar 255 Optional short description of the record
stdprecision numeric 10 Rule for rounding calculated amounts
costingprecision numeric 10 Rounding used costing calculations
iseuro bpchar 1 'N'::bpchar This currency is the Euro
isemumember bpchar 1 'N'::bpchar This currency is member if the European Monetary Union
emuentrydate timestamp 29,6  √  null Date when the currency joined / will join the EMU
emurate numeric 0  √  0 Official rate to the Euro
roundofffactor numeric 0  √  null Used to Round Off Payment Amount
c_currency_uu varchar 36  √  NULL::character varying C_Currency_UU

Table contained 175 rows at 2024-01-03 13:44 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_currency_id Primary key Asc c_currency_pkey
c_currency_uu Must be unique Asc c_currency_uu_idx
iso_code Must be unique Asc c_currencyisocode


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.