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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_client_id numeric(10)  
2 ad_org_id numeric(10)  
3 isactive character(1)  
4 created timestamp without time zone  
5 createdby numeric(10)  
6 updated timestamp without time zone  
7 updatedby numeric(10)  
8 c_cycle_id numeric(10)  
9 cyclename character varying(60)  
10 c_currency_id numeric(10)  
11 c_cyclestep_id numeric(10)  
12 cyclestepname character varying(60)  
13 seqno numeric(10)  
14 relativeweight numeric  
15 c_phase_id numeric(10)  
16 projectphasename character varying(60)  
17 c_projecttype_id numeric(10)  
18 projecttypename character varying(60)  
19 projectvalue character varying(40)  
20 projectname character varying(60)  
21 description character varying(255)  
22 note character varying(2000)  
23 c_bpartner_id numeric(10)  
24 c_bpartner_location_id numeric(10)  
25 ad_user_id numeric(10)  
26 poreference character varying(20)  
27 salesrep_id numeric(10)  
28 m_warehouse_id numeric(10)  
29 projectcategory character(1)  
30 datecontract timestamp without time zone  
31 datefinish timestamp without time zone  
32 iscommitment character(1)  
33 iscommitceiling character(1)  
34 committedqty numeric  
35 committedamt numeric  
36 plannedqty numeric  
37 plannedamt numeric  
38 plannedmarginamt numeric  
39 invoicedamt numeric  
40 invoicedqty numeric  
41 projectbalanceamt numeric  


ソース
ソース 
 SELECT p.ad_client_id,
    p.ad_org_id,
    p.isactive,
    p.created,
    p.createdby,
    p.updated,
    p.updatedby,
    c.c_cycle_id,
    c.name AS cyclename,
    c.c_currency_id,
    cs.c_cyclestep_id,
    cs.name AS cyclestepname,
    cs.seqno,
    cs.relativeweight,
    pp.c_phase_id,
    pp.name AS projectphasename,
    pt.c_projecttype_id,
    pt.name AS projecttypename,
    p.value AS projectvalue,
    p.name AS projectname,
    p.description,
    p.note,
    p.c_bpartner_id,
    p.c_bpartner_location_id,
    p.ad_user_id,
    p.poreference,
    p.salesrep_id,
    p.m_warehouse_id,
    p.projectcategory,
    p.datecontract,
    p.datefinish,
    p.iscommitment,
    p.iscommitceiling,
    (p.committedqty * cs.relativeweight) AS committedqty,
    (currencyconvert(p.committedamt, p.c_currency_id, c.c_currency_id, getdate(), (0)::numeric, p.ad_client_id, p.ad_org_id) * cs.relativeweight) AS committedamt,
    (p.plannedqty * cs.relativeweight) AS plannedqty,
    (currencyconvert(p.plannedamt, p.c_currency_id, c.c_currency_id, getdate(), (0)::numeric, p.ad_client_id, p.ad_org_id) * cs.relativeweight) AS plannedamt,
    (currencyconvert(p.plannedmarginamt, p.c_currency_id, c.c_currency_id, getdate(), (0)::numeric, p.ad_client_id, p.ad_org_id) * cs.relativeweight) AS plannedmarginamt,
    (currencyconvert(p.invoicedamt, p.c_currency_id, c.c_currency_id, getdate(), (0)::numeric, p.ad_client_id, p.ad_org_id) * cs.relativeweight) AS invoicedamt,
    (p.invoicedqty * cs.relativeweight) AS invoicedqty,
    (currencyconvert(p.projectbalanceamt, p.c_currency_id, c.c_currency_id, getdate(), (0)::numeric, p.ad_client_id, p.ad_org_id) * cs.relativeweight) AS projectbalanceamt
   FROM (((((c_cycle c
     JOIN c_cyclestep cs ON ((c.c_cycle_id = cs.c_cycle_id)))
     JOIN c_cyclephase cp ON ((cs.c_cyclestep_id = cp.c_cyclestep_id)))
     JOIN c_phase pp ON ((cp.c_phase_id = pp.c_phase_id)))
     JOIN c_project p ON ((cp.c_phase_id = p.c_phase_id)))
     JOIN c_projecttype pt ON ((p.c_projecttype_id = pt.c_projecttype_id)));


インデックス情報
No インデックス名 カラムリスト ユニーク 備考


外部キー情報
No 外部キー名 カラムリスト 参照先 参照先カラムリスト


外部キー情報(PK側)
No 外部キー名 カラムリスト 参照元 参照元カラムリスト


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_projectcycle
3 viewowner adempiere
4 definition SELECT p.ad_client_id,
p.ad_org_id,
p.isactive,
p.created,
p.createdby,
p.updated,
p.updatedby,
c.c_cycle_id,
c.name AS cyclename,
c.c_currency_id,
cs.c_cyclestep_id,
cs.name AS cyclestepname,
cs.seqno,
cs.relativeweight,
pp.c_phase_id,
pp.name AS projectphasename,
pt.c_projecttype_id,
pt.name AS projecttypename,
p.value AS projectvalue,
p.name AS projectname,
p.description,
p.note,
p.c_bpartner_id,
p.c_bpartner_location_id,
p.ad_user_id,
p.poreference,
p.salesrep_id,
p.m_warehouse_id,
p.projectcategory,
p.datecontract,
p.datefinish,
p.iscommitment,
p.iscommitceiling,
(p.committedqty * cs.relativeweight) AS committedqty,
(currencyconvert(p.committedamt, p.c_currency_id, c.c_currency_id, getdate(), (0)::numeric, p.ad_client_id, p.ad_org_id) * cs.relativeweight) AS committedamt,
(p.plannedqty * cs.relativeweight) AS plannedqty,
(currencyconvert(p.plannedamt, p.c_currency_id, c.c_currency_id, getdate(), (0)::numeric, p.ad_client_id, p.ad_org_id) * cs.relativeweight) AS plannedamt,
(currencyconvert(p.plannedmarginamt, p.c_currency_id, c.c_currency_id, getdate(), (0)::numeric, p.ad_client_id, p.ad_org_id) * cs.relativeweight) AS plannedmarginamt,
(currencyconvert(p.invoicedamt, p.c_currency_id, c.c_currency_id, getdate(), (0)::numeric, p.ad_client_id, p.ad_org_id) * cs.relativeweight) AS invoicedamt,
(p.invoicedqty * cs.relativeweight) AS invoicedqty,
(currencyconvert(p.projectbalanceamt, p.c_currency_id, c.c_currency_id, getdate(), (0)::numeric, p.ad_client_id, p.ad_org_id) * cs.relativeweight) AS projectbalanceamt
FROM (((((c_cycle c
JOIN c_cyclestep cs ON ((c.c_cycle_id = cs.c_cycle_id)))
JOIN c_cyclephase cp ON ((cs.c_cyclestep_id = cp.c_cyclestep_id)))
JOIN c_phase pp ON ((cp.c_phase_id = pp.c_phase_id)))
JOIN c_project p ON ((cp.c_phase_id = p.c_phase_id)))
JOIN c_projecttype pt ON ((p.c_projecttype_id = pt.c_projecttype_id)));