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
c_acctschema.c_currency_id c_currency_c_acctschema R
c_bankaccount.c_currency_id ccurrency_cbankaccount R
c_bankstatementline.c_currency_id ccurrency_cbankstmtline 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_elementvalue.c_currency_id ccurrency_celementvalue R
c_invoice.c_currency_id ccurrency_cinvoice 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_project.c_currency_id ccurrency_cproject 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_inventory.c_currency_id ccurrency_minventory R
m_pricelist.c_currency_id ccurrency_mpricelist R
m_product_po.c_currency_id ccurrency_mproductpo R
The Currency for this record
ad_client_id numeric 10 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:48 +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

Close relationships  within of separation: