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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_client_id numeric(10)  
2 ad_org_id numeric(10)  
3 isactive text  
4 created timestamp without time zone  
5 createdby numeric(10)  
6 updated timestamp without time zone  
7 updatedby numeric(10)  
8 m_product_id numeric(10)  
9 m_pricelist_version_id numeric(10)  
10 m_warehouse_id numeric(10)  
11 value character varying(40)  
12 name character varying(255)  
13 upc character varying(30)  
14 sku character varying(30)  
15 c_uom_id numeric(10)  
16 uomsymbol character varying(10)  
17 pricelist numeric  
18 pricestd numeric  
19 margin numeric  
20 pricelimit numeric  
21 warehousename character varying(60)  
22 qtyavailable numeric  
23 qtyonhand numeric  
24 qtyreserved numeric  
25 qtyordered numeric  
26 isinstanceattribute character  


ソース
ソース 
 SELECT w.ad_client_id,
    w.ad_org_id,
        CASE
            WHEN (p.discontinued = 'N'::bpchar) THEN 'Y'::text
            ELSE 'N'::text
        END AS isactive,
    pr.created,
    pr.createdby,
    pr.updated,
    pr.updatedby,
    p.m_product_id,
    pr.m_pricelist_version_id,
    w.m_warehouse_id,
    p.value,
    p.name,
    p.upc,
    p.sku,
    uom.c_uom_id,
    uom.uomsymbol,
    bompricelist(p.m_product_id, pr.m_pricelist_version_id) AS pricelist,
    bompricestd(p.m_product_id, pr.m_pricelist_version_id) AS pricestd,
    (bompricestd(p.m_product_id, pr.m_pricelist_version_id) - bompricelimit(p.m_product_id, pr.m_pricelist_version_id)) AS margin,
    bompricelimit(p.m_product_id, pr.m_pricelist_version_id) AS pricelimit,
    w.name AS warehousename,
    bomqtyavailable(p.m_product_id, w.m_warehouse_id, (0)::numeric) AS qtyavailable,
    bomqtyonhand(p.m_product_id, w.m_warehouse_id, (0)::numeric) AS qtyonhand,
    bomqtyreserved(p.m_product_id, w.m_warehouse_id, (0)::numeric) AS qtyreserved,
    bomqtyordered(p.m_product_id, w.m_warehouse_id, (0)::numeric) AS qtyordered,
    COALESCE(pa.isinstanceattribute, 'N'::bpchar) AS isinstanceattribute
   FROM ((((m_product p
     JOIN m_productprice pr ON ((p.m_product_id = pr.m_product_id)))
     JOIN c_uom uom ON ((p.c_uom_id = uom.c_uom_id)))
     LEFT JOIN m_attributeset pa ON ((p.m_attributeset_id = pa.m_attributeset_id)))
     JOIN m_warehouse w ON ((p.ad_client_id = w.ad_client_id)))
  WHERE ((((p.issummary = 'N'::bpchar) AND (p.isactive = 'Y'::bpchar)) AND (pr.isactive = 'Y'::bpchar)) AND (w.isactive = 'Y'::bpchar));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_warehouseprice
3 viewowner adempiere
4 definition SELECT w.ad_client_id,
w.ad_org_id,
CASE
WHEN (p.discontinued = 'N'::bpchar) THEN 'Y'::text
ELSE 'N'::text
END AS isactive,
pr.created,
pr.createdby,
pr.updated,
pr.updatedby,
p.m_product_id,
pr.m_pricelist_version_id,
w.m_warehouse_id,
p.value,
p.name,
p.upc,
p.sku,
uom.c_uom_id,
uom.uomsymbol,
bompricelist(p.m_product_id, pr.m_pricelist_version_id) AS pricelist,
bompricestd(p.m_product_id, pr.m_pricelist_version_id) AS pricestd,
(bompricestd(p.m_product_id, pr.m_pricelist_version_id) - bompricelimit(p.m_product_id, pr.m_pricelist_version_id)) AS margin,
bompricelimit(p.m_product_id, pr.m_pricelist_version_id) AS pricelimit,
w.name AS warehousename,
bomqtyavailable(p.m_product_id, w.m_warehouse_id, (0)::numeric) AS qtyavailable,
bomqtyonhand(p.m_product_id, w.m_warehouse_id, (0)::numeric) AS qtyonhand,
bomqtyreserved(p.m_product_id, w.m_warehouse_id, (0)::numeric) AS qtyreserved,
bomqtyordered(p.m_product_id, w.m_warehouse_id, (0)::numeric) AS qtyordered,
COALESCE(pa.isinstanceattribute, 'N'::bpchar) AS isinstanceattribute
FROM ((((m_product p
JOIN m_productprice pr ON ((p.m_product_id = pr.m_product_id)))
JOIN c_uom uom ON ((p.c_uom_id = uom.c_uom_id)))
LEFT JOIN m_attributeset pa ON ((p.m_attributeset_id = pa.m_attributeset_id)))
JOIN m_warehouse w ON ((p.ad_client_id = w.ad_client_id)))
WHERE ((((p.issummary = 'N'::bpchar) AND (p.isactive = 'Y'::bpchar)) AND (pr.isactive = 'Y'::bpchar)) AND (w.isactive = 'Y'::bpchar));