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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 m_product_id numeric(10)  
2 m_locator_id numeric(10)  
3 ad_client_id numeric(10)  
4 ad_org_id numeric(10)  
5 isactive character(1)  
6 created timestamp without time zone  
7 createdby numeric(10)  
8 updated timestamp without time zone  
9 updatedby numeric(10)  
10 qtyonhand numeric  
11 qtyreserved numeric  
12 qtyordered numeric  
13 datelastinventory timestamp without time zone  
14 m_attributesetinstance_id numeric(10)  
15 m_storage_uu character varying(36)  
16 datematerialpolicy timestamp without time zone  


ソース
ソース 
 SELECT s.m_product_id,
    s.m_locator_id,
    s.ad_client_id,
    s.ad_org_id,
    s.isactive,
    s.created,
    s.createdby,
    s.updated,
    s.updatedby,
    s.qtyonhand,
    0 AS qtyreserved,
    0 AS qtyordered,
    s.datelastinventory,
    s.m_attributesetinstance_id,
    s.m_storageonhand_uu AS m_storage_uu,
    s.datematerialpolicy
   FROM m_storageonhand s
UNION ALL
 SELECT sr.m_product_id,
    w.m_reservelocator_id AS m_locator_id,
    sr.ad_client_id,
    sr.ad_org_id,
    sr.isactive,
    sr.created,
    sr.createdby,
    sr.updated,
    sr.updatedby,
    0 AS qtyonhand,
    sr.qty AS qtyreserved,
    0 AS qtyordered,
    sr.datelastinventory,
    sr.m_attributesetinstance_id,
    sr.m_storagereservation_uu AS m_storage_uu,
    NULL::timestamp without time zone AS datematerialpolicy
   FROM (m_storagereservation sr
     JOIN m_warehouse w ON ((sr.m_warehouse_id = w.m_warehouse_id)))
  WHERE ((sr.issotrx = 'Y'::bpchar) AND (sr.qty <> (0)::numeric))
UNION ALL
 SELECT so.m_product_id,
    w.m_reservelocator_id AS m_locator_id,
    so.ad_client_id,
    so.ad_org_id,
    so.isactive,
    so.created,
    so.createdby,
    so.updated,
    so.updatedby,
    0 AS qtyonhand,
    0 AS qtyreserved,
    so.qty AS qtyordered,
    so.datelastinventory,
    so.m_attributesetinstance_id,
    so.m_storagereservation_uu AS m_storage_uu,
    NULL::timestamp without time zone AS datematerialpolicy
   FROM (m_storagereservation so
     JOIN m_warehouse w ON ((so.m_warehouse_id = w.m_warehouse_id)))
  WHERE ((so.issotrx = 'N'::bpchar) AND (so.qty <> (0)::numeric));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname m_storage
3 viewowner adempiere
4 definition SELECT s.m_product_id,
s.m_locator_id,
s.ad_client_id,
s.ad_org_id,
s.isactive,
s.created,
s.createdby,
s.updated,
s.updatedby,
s.qtyonhand,
0 AS qtyreserved,
0 AS qtyordered,
s.datelastinventory,
s.m_attributesetinstance_id,
s.m_storageonhand_uu AS m_storage_uu,
s.datematerialpolicy
FROM m_storageonhand s
UNION ALL
SELECT sr.m_product_id,
w.m_reservelocator_id AS m_locator_id,
sr.ad_client_id,
sr.ad_org_id,
sr.isactive,
sr.created,
sr.createdby,
sr.updated,
sr.updatedby,
0 AS qtyonhand,
sr.qty AS qtyreserved,
0 AS qtyordered,
sr.datelastinventory,
sr.m_attributesetinstance_id,
sr.m_storagereservation_uu AS m_storage_uu,
NULL::timestamp without time zone AS datematerialpolicy
FROM (m_storagereservation sr
JOIN m_warehouse w ON ((sr.m_warehouse_id = w.m_warehouse_id)))
WHERE ((sr.issotrx = 'Y'::bpchar) AND (sr.qty <> (0)::numeric))
UNION ALL
SELECT so.m_product_id,
w.m_reservelocator_id AS m_locator_id,
so.ad_client_id,
so.ad_org_id,
so.isactive,
so.created,
so.createdby,
so.updated,
so.updatedby,
0 AS qtyonhand,
0 AS qtyreserved,
so.qty AS qtyordered,
so.datelastinventory,
so.m_attributesetinstance_id,
so.m_storagereservation_uu AS m_storage_uu,
NULL::timestamp without time zone AS datematerialpolicy
FROM (m_storagereservation so
JOIN m_warehouse w ON ((so.m_warehouse_id = w.m_warehouse_id)))
WHERE ((so.issotrx = 'N'::bpchar) AND (so.qty <> (0)::numeric));