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


カラム情報
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 updatedby numeric(10)  
7 updated timestamp without time zone  
8 documentno character varying(60)  
9 m_product_id numeric(10)  
10 m_locator_id numeric(10)  
11 movementdate timestamp without time zone  
12 pp_order_id numeric(10)  
13 qtydelivered numeric  
14 qtyscrap numeric  
15 qtydeliveredline numeric  
16 qtyissueshouldbe numeric  
17 qtyscrapline numeric  
18 qtyissuescrapshouldbe numeric  
19 createdbyissue numeric(10)  
20 updatedbyissue numeric(10)  
21 qtytodeliver numeric  
22 differenceqty numeric  
23 issotrx character(1)  
24 dateordered timestamp without time zone  


ソース
ソース 
 SELECT DISTINCT o.ad_client_id,
    o.ad_org_id,
    o.isactive,
    o.created,
    o.createdby,
    o.updatedby,
    o.updated,
    o.documentno,
    ol.m_product_id,
    mt.m_locator_id,
    mt.movementdate,
    o.pp_order_id,
    o.qtydelivered,
    o.qtyscrap,
    ol.qtydelivered AS qtydeliveredline,
    ((o.qtydelivered * ol.qtybatch) / (100)::numeric) AS qtyissueshouldbe,
    ol.qtyscrap AS qtyscrapline,
    ((o.qtyscrap * ol.qtybatch) / (100)::numeric) AS qtyissuescrapshouldbe,
    mt.createdby AS createdbyissue,
    mt.updatedby AS updatedbyissue,
    ( SELECT sum(t.movementqty) AS sum
           FROM m_transaction t
          WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id)) AS qtytodeliver,
    ((((o.qtydelivered + o.qtyscrap) * ol.qtybatch) / (100)::numeric) + ( SELECT sum(t.movementqty) AS sum
           FROM m_transaction t
          WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id))) AS differenceqty,
    o.issotrx,
    o.dateordered
   FROM (((pp_order o
     JOIN pp_order_bomline ol ON ((ol.pp_order_id = o.pp_order_id)))
     JOIN pp_cost_collector cc ON ((cc.pp_order_bomline_id = ol.pp_order_bomline_id)))
     LEFT JOIN m_transaction mt ON ((mt.pp_cost_collector_id = cc.pp_cost_collector_id)))
  ORDER BY o.ad_client_id, o.ad_org_id, o.isactive, o.created, o.createdby, o.updatedby, o.updated, o.documentno, ol.m_product_id, mt.m_locator_id, mt.movementdate, o.pp_order_id, o.qtydelivered, o.qtyscrap, ol.qtydelivered, ((o.qtydelivered * ol.qtybatch) / (100)::numeric), ol.qtyscrap, ((o.qtyscrap * ol.qtybatch) / (100)::numeric), mt.createdby, mt.updatedby, ( SELECT sum(t.movementqty) AS sum
           FROM m_transaction t
          WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id)), ((((o.qtydelivered + o.qtyscrap) * ol.qtybatch) / (100)::numeric) + ( SELECT sum(t.movementqty) AS sum
           FROM m_transaction t
          WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id))), o.issotrx, o.dateordered;


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_pp_order_transactions
3 viewowner adempiere
4 definition SELECT DISTINCT o.ad_client_id,
o.ad_org_id,
o.isactive,
o.created,
o.createdby,
o.updatedby,
o.updated,
o.documentno,
ol.m_product_id,
mt.m_locator_id,
mt.movementdate,
o.pp_order_id,
o.qtydelivered,
o.qtyscrap,
ol.qtydelivered AS qtydeliveredline,
((o.qtydelivered * ol.qtybatch) / (100)::numeric) AS qtyissueshouldbe,
ol.qtyscrap AS qtyscrapline,
((o.qtyscrap * ol.qtybatch) / (100)::numeric) AS qtyissuescrapshouldbe,
mt.createdby AS createdbyissue,
mt.updatedby AS updatedbyissue,
( SELECT sum(t.movementqty) AS sum
FROM m_transaction t
WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id)) AS qtytodeliver,
((((o.qtydelivered + o.qtyscrap) * ol.qtybatch) / (100)::numeric) + ( SELECT sum(t.movementqty) AS sum
FROM m_transaction t
WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id))) AS differenceqty,
o.issotrx,
o.dateordered
FROM (((pp_order o
JOIN pp_order_bomline ol ON ((ol.pp_order_id = o.pp_order_id)))
JOIN pp_cost_collector cc ON ((cc.pp_order_bomline_id = ol.pp_order_bomline_id)))
LEFT JOIN m_transaction mt ON ((mt.pp_cost_collector_id = cc.pp_cost_collector_id)))
ORDER BY o.ad_client_id, o.ad_org_id, o.isactive, o.created, o.createdby, o.updatedby, o.updated, o.documentno, ol.m_product_id, mt.m_locator_id, mt.movementdate, o.pp_order_id, o.qtydelivered, o.qtyscrap, ol.qtydelivered, ((o.qtydelivered * ol.qtybatch) / (100)::numeric), ol.qtyscrap, ((o.qtyscrap * ol.qtybatch) / (100)::numeric), mt.createdby, mt.updatedby, ( SELECT sum(t.movementqty) AS sum
FROM m_transaction t
WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id)), ((((o.qtydelivered + o.qtyscrap) * ol.qtybatch) / (100)::numeric) + ( SELECT sum(t.movementqty) AS sum
FROM m_transaction t
WHERE (t.pp_cost_collector_id = cc.pp_cost_collector_id))), o.issotrx, o.dateordered;