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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_client_id numeric(10)  
2 ad_org_id numeric(10)  
3 c_acctschema_id numeric(10)  
4 dateacct timestamp with time zone  
5 account_id numeric(10)  
6 postingtype character(1)  
7 m_product_id numeric(10)  
8 c_bpartner_id numeric(10)  
9 c_project_id numeric(10)  
10 ad_orgtrx_id numeric(10)  
11 c_salesregion_id numeric(10)  
12 c_activity_id numeric(10)  
13 c_campaign_id numeric(10)  
14 c_locto_id numeric(10)  
15 c_locfrom_id numeric(10)  
16 user1_id numeric(10)  
17 user2_id numeric(10)  
18 gl_budget_id numeric(10)  
19 amtacctdr numeric  
20 amtacctcr numeric  
21 qty numeric  
22 createdby numeric  
23 created timestamp without time zone  
24 updatedby numeric  
25 updated timestamp without time zone  
26 isactive character  
27 c_subacct_id numeric  
28 userelement1_id numeric(10)  
29 userelement2_id numeric(10)  
30 c_projectphase_id numeric  
31 c_projecttask_id numeric  


ソース
ソース 
 SELECT a.ad_client_id,
    a.ad_org_id,
    a.c_acctschema_id,
    trunc((a.dateacct)::timestamp with time zone) AS dateacct,
    a.account_id,
    a.postingtype,
    a.m_product_id,
    a.c_bpartner_id,
    a.c_project_id,
    a.ad_orgtrx_id,
    a.c_salesregion_id,
    a.c_activity_id,
    a.c_campaign_id,
    a.c_locto_id,
    a.c_locfrom_id,
    a.user1_id,
    a.user2_id,
    a.gl_budget_id,
    COALESCE(sum(a.amtacctdr), (0)::numeric) AS amtacctdr,
    COALESCE(sum(a.amtacctcr), (0)::numeric) AS amtacctcr,
    COALESCE(sum(a.qty), (0)::numeric) AS qty,
    max(a.createdby) AS createdby,
    max(a.created) AS created,
    max(a.updatedby) AS updatedby,
    max(a.updated) AS updated,
    max(a.isactive) AS isactive,
    max(a.c_subacct_id) AS c_subacct_id,
    a.userelement1_id,
    a.userelement2_id,
    max(a.c_projectphase_id) AS c_projectphase_id,
    max(a.c_projecttask_id) AS c_projecttask_id
   FROM fact_acct a
  GROUP BY a.ad_client_id, a.ad_org_id, a.c_acctschema_id, trunc((a.dateacct)::timestamp with time zone), a.account_id, a.postingtype, a.m_product_id, a.c_bpartner_id, a.c_project_id, a.ad_orgtrx_id, a.c_salesregion_id, a.c_activity_id, a.c_campaign_id, a.c_locto_id, a.c_locfrom_id, a.user1_id, a.user2_id, a.userelement1_id, a.userelement2_id, a.gl_budget_id;


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname fact_acct_balance
3 viewowner adempiere
4 definition SELECT a.ad_client_id,
a.ad_org_id,
a.c_acctschema_id,
trunc((a.dateacct)::timestamp with time zone) AS dateacct,
a.account_id,
a.postingtype,
a.m_product_id,
a.c_bpartner_id,
a.c_project_id,
a.ad_orgtrx_id,
a.c_salesregion_id,
a.c_activity_id,
a.c_campaign_id,
a.c_locto_id,
a.c_locfrom_id,
a.user1_id,
a.user2_id,
a.gl_budget_id,
COALESCE(sum(a.amtacctdr), (0)::numeric) AS amtacctdr,
COALESCE(sum(a.amtacctcr), (0)::numeric) AS amtacctcr,
COALESCE(sum(a.qty), (0)::numeric) AS qty,
max(a.createdby) AS createdby,
max(a.created) AS created,
max(a.updatedby) AS updatedby,
max(a.updated) AS updated,
max(a.isactive) AS isactive,
max(a.c_subacct_id) AS c_subacct_id,
a.userelement1_id,
a.userelement2_id,
max(a.c_projectphase_id) AS c_projectphase_id,
max(a.c_projecttask_id) AS c_projecttask_id
FROM fact_acct a
GROUP BY a.ad_client_id, a.ad_org_id, a.c_acctschema_id, trunc((a.dateacct)::timestamp with time zone), a.account_id, a.postingtype, a.m_product_id, a.c_bpartner_id, a.c_project_id, a.ad_orgtrx_id, a.c_salesregion_id, a.c_activity_id, a.c_campaign_id, a.c_locto_id, a.c_locfrom_id, a.user1_id, a.user2_id, a.userelement1_id, a.userelement2_id, a.gl_budget_id;