テーブル情報
システム名 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_elementvalue     
備考


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_elementvalue_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 value character varying(40) Yes
10 name character varying(120) Yes
11 description character varying(255)  
12 accounttype character(1) Yes
13 accountsign character(1) Yes
14 isdoccontrolled character(1)   'N'
15 c_element_id numeric(10) Yes
16 issummary character(1) Yes 'N'
17 validfrom timestamp without time zone  
18 validto timestamp without time zone  
19 postactual character(1) Yes 'Y'
20 postbudget character(1) Yes 'Y'
21 postencumbrance character(1) Yes 'Y'
22 poststatistical character(1) Yes 'Y'
23 isbankaccount character(1)   'N'
24 c_bankaccount_id numeric(10)  
25 isforeigncurrency character(1)   'N'
26 c_currency_id numeric(10)  
27 c_elementvalue_uu character varying(36)   NULL
28 isdetailbpartner character(1) Yes 'N'
29 isdetailproduct character(1) Yes 'N'
30 bpartnertype character(1)   NULL


インデックス情報
No インデックス名 カラムリスト ユニーク 備考
1 c_elementvalue_name name    
2 c_elementvalue_pkey c_elementvalue_id Yes  
3 c_elementvalue_uu_idx c_elementvalue_uu Yes  
4 c_elementvalue_value c_element_id,value Yes  


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト
1 adclient_celementvalue ad_client_id adempiere.ad_client ad_client_id
2 adorg_celementvalue ad_org_id adempiere.ad_org ad_org_id
3 cbankaccount_celementvalue c_bankaccount_id adempiere.c_bankaccount c_bankaccount_id
4 ccurrency_celementvalue c_currency_id adempiere.c_currency c_currency_id
5 celement_celementvalue c_element_id adempiere.c_element c_element_id


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト
1 account_factacctsummary c_elementvalue_id adempiere.fact_acct_summary account_id
2 account_gljournalline c_elementvalue_id adempiere.gl_journalline account_id
3 account_ifajournal c_elementvalue_id adempiere.i_fajournal account_id
4 celemenrvalueuser1_cinvline c_elementvalue_id adempiere.c_invoiceline user1_id
5 celemenrvalueuser1_corderline c_elementvalue_id adempiere.c_orderline user1_id
6 celemenrvalueuser1_minoutline c_elementvalue_id adempiere.m_inoutline user1_id
7 celemenrvalueuser2_cinvline c_elementvalue_id adempiere.c_invoiceline user2_id
8 celemenrvalueuser2_corder c_elementvalue_id adempiere.c_order user2_id
9 celemenrvalueuser2_corderline c_elementvalue_id adempiere.c_orderline user2_id
10 celemenrvalueuser2_minoutline c_elementvalue_id adempiere.m_inoutline user2_id
11 celementvalue_caschemaelement c_elementvalue_id adempiere.c_acctschema_element c_elementvalue_id
12 celementvalue_cevaluetrl c_elementvalue_id adempiere.c_elementvalue_trl c_elementvalue_id
13 celementvalue_csubacct c_elementvalue_id adempiere.c_subacct c_elementvalue_id
14 celementvalue_factacct c_elementvalue_id adempiere.fact_acct account_id
15 celementvalue_glfundrestr c_elementvalue_id adempiere.gl_fundrestriction c_elementvalue_id
16 celementvalue_ielementvalue c_elementvalue_id adempiere.i_elementvalue c_elementvalue_id
17 celementvalue_ireportline c_elementvalue_id adempiere.i_reportline c_elementvalue_id
18 celementvalue_paratioelement c_elementvalue_id adempiere.pa_ratioelement account_id
19 celementvalue_pareportcolumn c_elementvalue_id adempiere.pa_reportcolumn c_elementvalue_id
20 celementvalue_pareportsource c_elementvalue_id adempiere.pa_reportsource c_elementvalue_id
21 celementvalue_qssjournalgenera c_elementvalue_id adempiere.gl_journalgeneratorsource c_elementvalue_id
22 celementvalueaccount_vc c_elementvalue_id adempiere.c_validcombination account_id
23 celementvalueadjustcr_qssjourn c_elementvalue_id adempiere.gl_journalgenerator c_elementvalueadjustcr_id
24 celementvalueadjustdr_qssjourn c_elementvalue_id adempiere.gl_journalgenerator c_elementvalueadjustdr_id
25 celementvaluecr_qssjournalgene c_elementvalue_id adempiere.gl_journalgeneratorline c_elementvaluecr_id
26 celementvaluedr_qssjournalgene c_elementvalue_id adempiere.gl_journalgeneratorline c_elementvaluedr_id
27 celementvalueu1_cinvoicebline c_elementvalue_id adempiere.c_invoicebatchline user1_id
28 celementvalueu2_cinvoicebline c_elementvalue_id adempiere.c_invoicebatchline user2_id
29 celementvalueuser1_ccash c_elementvalue_id adempiere.c_cash user1_id
30 celementvalueuser1_cinvoice c_elementvalue_id adempiere.c_invoice user1_id
31 celementvalueuser1_corder c_elementvalue_id adempiere.c_order user1_id
32 celementvalueuser1_cpayment c_elementvalue_id adempiere.c_payment user1_id
33 celementvalueuser1_factacct c_elementvalue_id adempiere.fact_acct user1_id
34 celementvalueuser1_minout c_elementvalue_id adempiere.m_inout user1_id
35 celementvalueuser1_minvent c_elementvalue_id adempiere.m_inventory user1_id
36 celementvalueuser1_mmove c_elementvalue_id adempiere.m_movement user1_id
37 celementvalueuser1_mprod c_elementvalue_id adempiere.m_production user1_id
38 celementvalueuser1_vc c_elementvalue_id adempiere.c_validcombination user1_id
39 celementvalueuser2_ccash c_elementvalue_id adempiere.c_cash user2_id
40 celementvalueuser2_cinvoice c_elementvalue_id adempiere.c_invoice user2_id
41 celementvalueuser2_cpayment c_elementvalue_id adempiere.c_payment user2_id
42 celementvalueuser2_factacct c_elementvalue_id adempiere.fact_acct user2_id
43 celementvalueuser2_minout c_elementvalue_id adempiere.m_inout user2_id
44 celementvalueuser2_minvent c_elementvalue_id adempiere.m_inventory user2_id
45 celementvalueuser2_mmove c_elementvalue_id adempiere.m_movement user2_id
46 celementvalueuser2_mprod c_elementvalue_id adempiere.m_production user2_id
47 celementvalueuser2_vc c_elementvalue_id adempiere.c_validcombination user2_id
48 celvalueaccount_igljournal c_elementvalue_id adempiere.i_gljournal account_id
49 celvalueuser2_igljournal c_elementvalue_id adempiere.i_gljournal user2_id
50 cevalueacct_gldist c_elementvalue_id adempiere.gl_distribution account_id
51 cevalueacct_gldistline c_elementvalue_id adempiere.gl_distributionline account_id
52 cevalueparent_ielementvalue c_elementvalue_id adempiere.i_elementvalue parentelementvalue_id
53 cevalueuser1_gldist c_elementvalue_id adempiere.gl_distribution user1_id
54 cevalueuser1_gldistline c_elementvalue_id adempiere.gl_distributionline user1_id
55 cevalueuser1_igljournal c_elementvalue_id adempiere.i_gljournal user1_id
56 cevalueuser2_gldist c_elementvalue_id adempiere.gl_distribution user2_id
57 cevalueuser2_gldistline c_elementvalue_id adempiere.gl_distributionline user2_id
58 user1_ccashplan c_elementvalue_id adempiere.c_cashplan user1_id
59 user1_ccashplanline c_elementvalue_id adempiere.c_cashplanline user1_id
60 user1_cpaymenttransaction c_elementvalue_id adempiere.c_paymenttransaction user1_id
61 user1_ddorder c_elementvalue_id adempiere.dd_order user1_id
62 user1_ddorderline c_elementvalue_id adempiere.dd_orderline user1_id
63 user1_factacctsummary c_elementvalue_id adempiere.fact_acct_summary user1_id
64 user1_gljournalline c_elementvalue_id adempiere.gl_journalline user1_id
65 user1_hrconceptacct c_elementvalue_id adempiere.hr_concept_acct user1_id
66 user1_hrmovement c_elementvalue_id adempiere.hr_movement user1_id
67 user1_ifajournal c_elementvalue_id adempiere.i_fajournal user1_id
68 user1_pporder c_elementvalue_id adempiere.pp_order user1_id
69 user2_ccashplan c_elementvalue_id adempiere.c_cashplan user2_id
70 user2_ccashplanline c_elementvalue_id adempiere.c_cashplanline user2_id
71 user2_cpaymenttransaction c_elementvalue_id adempiere.c_paymenttransaction user2_id
72 user2_ddorder c_elementvalue_id adempiere.dd_order user2_id
73 user2_ddorderline c_elementvalue_id adempiere.dd_orderline user2_id
74 user2_factacctsummary c_elementvalue_id adempiere.fact_acct_summary user2_id
75 user2_gljournalline c_elementvalue_id adempiere.gl_journalline user2_id
76 user2_hrmovement c_elementvalue_id adempiere.hr_movement user2_id
77 user2_ifajournal c_elementvalue_id adempiere.i_fajournal user2_id
78 user2_pporder c_elementvalue_id adempiere.pp_order user2_id


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