テーブル情報
システム名 http://www.as-link.com/  作成者 秦　松甫 
サブシステム名 ERPlus@iDempiere3.1_daily  作成日 2016/3/7 
スキーマ名 adempiere  更新日  
論理テーブル名   RDBMS  PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit 9.4.5 
物理テーブル名 c_currency     
備考


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_currency_id numeric(10) Yes (PK)
2 ad_client_id numeric(10) Yes
3 ad_org_id numeric(10) Yes
4 isactive character(1) Yes 'Y'
5 created timestamp without time zone Yes now()
6 createdby numeric(10) Yes
7 updated timestamp without time zone Yes now()
8 updatedby numeric(10) Yes
9 iso_code character(3) Yes
10 cursymbol character varying(10)  
11 description character varying(255) Yes
12 stdprecision numeric(10) Yes
13 costingprecision numeric(10) Yes
14 iseuro character(1) Yes 'N'
15 isemumember character(1) Yes 'N'
16 emuentrydate timestamp without time zone  
17 emurate numeric   0
18 roundofffactor numeric  
19 c_currency_uu character varying(36)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_currency_pkey c_currency_id Yes  
2 c_currency_uu_idx c_currency_uu Yes  
3 c_currencyisocode iso_code Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 c_currencyclient ad_client_id adempiere.ad_client ad_client_id
2 c_currencyorg ad_org_id adempiere.ad_org ad_org_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 c_currency_ad_role c_currency_id adempiere.ad_role c_currency_id
2 c_currency_c_acctschema c_currency_id adempiere.c_acctschema c_currency_id
3 c_currency_fact_acct c_currency_id adempiere.fact_acct c_currency_id
4 c_currencyconvrateto c_currency_id adempiere.c_conversion_rate c_currency_id_to
5 ccurrency_aassetaddition c_currency_id adempiere.a_asset_addition c_currency_id
6 ccurrency_aassetrevalentry c_currency_id adempiere.a_asset_reval_entry c_currency_id
7 ccurrency_adepreciationentry c_currency_id adempiere.a_depreciation_entry c_currency_id
8 ccurrency_adregistration c_currency_id adempiere.ad_registration c_currency_id
9 ccurrency_callocation c_currency_id adempiere.c_allocationhdr c_currency_id
10 ccurrency_cbankaccount c_currency_id adempiere.c_bankaccount c_currency_id
11 ccurrency_cbankaccountprocesso c_currency_id adempiere.c_bankaccount_processor c_currency_id
12 ccurrency_cbankstmtline c_currency_id adempiere.c_bankstatementline c_currency_id
13 ccurrency_ccashbook c_currency_id adempiere.c_cashbook c_currency_id
14 ccurrency_ccashline c_currency_id adempiere.c_cashline c_currency_id
15 ccurrency_ccommission c_currency_id adempiere.c_commission c_currency_id
16 ccurrency_ccommissiondetail c_currency_id adempiere.c_commissiondetail c_currency_id
17 ccurrency_cconversionrate c_currency_id adempiere.c_conversion_rate c_currency_id
18 ccurrency_ccountry c_currency_id adempiere.c_country c_currency_id
19 ccurrency_ccurrencyacct c_currency_id adempiere.c_currency_acct c_currency_id
20 ccurrency_ccurrencytrl c_currency_id adempiere.c_currency_trl c_currency_id
21 ccurrency_ccycle c_currency_id adempiere.c_cycle c_currency_id
22 ccurrency_cdunningrunentry c_currency_id adempiere.c_dunningrunentry c_currency_id
23 ccurrency_celementvalue c_currency_id adempiere.c_elementvalue c_currency_id
24 ccurrency_cinvoice c_currency_id adempiere.c_invoice c_currency_id
25 ccurrency_cinvoicebatch c_currency_id adempiere.c_invoicebatch c_currency_id
26 ccurrency_copportunity c_currency_id adempiere.c_opportunity c_currency_id
27 ccurrency_corder c_currency_id adempiere.c_order c_currency_id
28 ccurrency_corderline c_currency_id adempiere.c_orderline c_currency_id
29 ccurrency_cpayment c_currency_id adempiere.c_payment c_currency_id
30 ccurrency_cpaymentprocessor c_currency_id adempiere.c_paymentprocessor c_currency_id
31 ccurrency_cpaymenttransaction c_currency_id adempiere.c_paymenttransaction c_currency_id
32 ccurrency_cproject c_currency_id adempiere.c_project c_currency_id
33 ccurrency_crevenuerecplan c_currency_id adempiere.c_revenuerecognition_plan c_currency_id
34 ccurrency_crfq c_currency_id adempiere.c_rfq c_currency_id
35 ccurrency_crfqresponse c_currency_id adempiere.c_rfqresponse c_currency_id
36 ccurrency_ctaxdeclline c_currency_id adempiere.c_taxdeclarationline c_currency_id
37 ccurrency_gljournal c_currency_id adempiere.gl_journal c_currency_id
38 ccurrency_gljournalbatch c_currency_id adempiere.gl_journalbatch c_currency_id
39 ccurrency_gljournalline c_currency_id adempiere.gl_journalline c_currency_id
40 ccurrency_ibankstatement c_currency_id adempiere.i_bankstatement c_currency_id
41 ccurrency_iconvrate c_currency_id adempiere.i_conversion_rate c_currency_id
42 ccurrency_iconvrateto c_currency_id adempiere.i_conversion_rate c_currency_id_to
43 ccurrency_ifajournal c_currency_id adempiere.i_fajournal c_currency_id
44 ccurrency_igljournal c_currency_id adempiere.i_gljournal c_currency_id
45 ccurrency_iinvoice c_currency_id adempiere.i_invoice c_currency_id
46 ccurrency_iorder c_currency_id adempiere.i_order c_currency_id
47 ccurrency_ipayment c_currency_id adempiere.i_payment c_currency_id
48 ccurrency_ipricelist c_currency_id adempiere.i_pricelist c_currency_id
49 ccurrency_iproduct c_currency_id adempiere.i_product c_currency_id
50 ccurrency_mbpprice c_currency_id adempiere.m_bp_price c_currency_id
51 ccurrency_mfreight c_currency_id adempiere.m_freight c_currency_id
52 ccurrency_mpackage c_currency_id adempiere.m_package c_currency_id
53 ccurrency_mpricelist c_currency_id adempiere.m_pricelist c_currency_id
54 ccurrency_mproductpo c_currency_id adempiere.m_product_po c_currency_id
55 ccurrency_mrma c_currency_id adempiere.m_rma c_currency_id
56 ccurrency_mshippingtransaction c_currency_id adempiere.m_shippingtransaction c_currency_id
57 ccurrency_pareportcolumn c_currency_id adempiere.pa_reportcolumn c_currency_id
58 ccurrency_stimeexpenseline c_currency_id adempiere.s_timeexpenseline c_currency_id
59 ccurrency_taging c_currency_id adempiere.t_aging c_currency_id
60 ccurrency_tinventoryvalue c_currency_id adempiere.t_inventoryvalue c_currency_id


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 tablename c_currency
3 tableowner adempiere
4 tablespace
5 hasindexes True
6 hasrules False
7 hastriggers True