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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 pp_mrp_id numeric  
2 ad_client_id numeric(10)  
3 ad_org_id numeric(10)  
4 created timestamp without time zone  
5 createdby numeric(10)  
6 isactive character(1)  
7 isavailable character  
8 updated timestamp without time zone  
9 updatedby numeric(10)  
10 ismps character(1)  
11 name character varying  
12 description character varying  
13 c_order_id numeric  
14 c_orderline_id numeric  
15 dateordered timestamp with time zone  
16 dateconfirm timestamp with time zone  
17 datepromised timestamp with time zone  
18 datestartschedule timestamp with time zone  
19 datefinishschedule timestamp with time zone  
20 datestart timestamp with time zone  
21 datesimulation timestamp with time zone  
22 docstatus character varying  
23 m_forecast_id numeric  
24 m_forecastline_id numeric  
25 value character varying  
26 m_product_id numeric(10)  
27 m_requisition_id numeric  
28 m_requisitionline_id numeric  
29 m_warehouse_id numeric(10)  
30 pp_order_id numeric  
31 pp_order_bomline_id numeric  
32 dd_order_id numeric  
33 dd_orderline_id numeric  
34 qty numeric  
35 s_resource_id numeric(10)  
36 planner_id numeric  
37 priority character varying  
38 ordertype character varying  
39 typemrp character  
40 lowlevel numeric(10)  
41 c_bpartner_id numeric  
42 version numeric  
43 documentno character varying  


ソース
ソース 
 SELECT mrp.pp_mrp_id,
    mrp.ad_client_id,
    mrp.ad_org_id,
    mrp.created,
    mrp.createdby,
    mrp.isactive,
    mrp.isavailable,
    mrp.updated,
    mrp.updatedby,
    pp.ismps,
    mrp.name,
    mrp.description,
    mrp.c_order_id,
    mrp.c_orderline_id,
    mrp.dateordered,
    mrp.dateconfirm,
    mrp.datepromised,
    mrp.datestartschedule,
    mrp.datefinishschedule,
    mrp.datestart,
    mrp.datesimulation,
    mrp.docstatus,
    mrp.m_forecast_id,
    mrp.m_forecastline_id,
    mrp.value,
    mrp.m_product_id,
    mrp.m_requisition_id,
    mrp.m_requisitionline_id,
    mrp.m_warehouse_id,
    mrp.pp_order_id,
    mrp.pp_order_bomline_id,
    mrp.dd_order_id,
    mrp.dd_orderline_id,
    mrp.qty,
    mrp.s_resource_id,
    mrp.planner_id,
    mrp.priority,
    mrp.ordertype,
    mrp.typemrp,
    p.lowlevel,
    mrp.c_bpartner_id,
    mrp.version,
    documentno(mrp.pp_mrp_id) AS documentno
   FROM ((pp_mrp mrp
     JOIN m_product p ON ((mrp.m_product_id = p.m_product_id)))
     LEFT JOIN pp_product_planning pp ON (((pp.m_product_id = mrp.m_product_id) AND (mrp.m_warehouse_id = pp.m_warehouse_id))))
  WHERE (mrp.qty <> (0)::numeric)
UNION
 SELECT 0 AS pp_mrp_id,
    pp.ad_client_id,
    pp.ad_org_id,
    pp.created,
    pp.createdby,
    pp.isactive,
    'Y'::bpchar AS isavailable,
    pp.updated,
    pp.updatedby,
    pp.ismps,
    NULL::character varying AS name,
    NULL::character varying AS description,
    NULL::numeric AS c_order_id,
    NULL::numeric AS c_orderline_id,
    now() AS dateordered,
    now() AS dateconfirm,
    now() AS datepromised,
    now() AS datestartschedule,
    now() AS datefinishschedule,
    now() AS datestart,
    now() AS datesimulation,
    'CO'::character varying AS docstatus,
    NULL::numeric AS m_forecast_id,
    NULL::numeric AS m_forecastline_id,
    NULL::character varying AS value,
    pp.m_product_id,
    NULL::numeric AS m_requisition_id,
    NULL::numeric AS m_requisitionline_id,
    pp.m_warehouse_id,
    NULL::numeric AS pp_order_id,
    NULL::numeric AS pp_order_bomline_id,
    NULL::numeric AS dd_order_id,
    NULL::numeric AS dd_orderline_id,
    (pp.safetystock - bomqtyonhand(pp.m_product_id, pp.m_warehouse_id, (0)::numeric)) AS qty,
    pp.s_resource_id,
    NULL::numeric AS planner_id,
    NULL::character varying AS priority,
    'STK'::character varying AS ordertype,
    'D'::bpchar AS typemrp,
    p.lowlevel,
    NULL::numeric AS c_bpartner_id,
    NULL::numeric AS version,
    'Safety Strock'::character varying AS documentno
   FROM (pp_product_planning pp
     JOIN m_product p ON ((pp.m_product_id = p.m_product_id)))
  WHERE (bomqtyonhand(pp.m_product_id, pp.m_warehouse_id, (0)::numeric) < pp.safetystock);


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_pp_mrp
3 viewowner adempiere
4 definition SELECT mrp.pp_mrp_id,
mrp.ad_client_id,
mrp.ad_org_id,
mrp.created,
mrp.createdby,
mrp.isactive,
mrp.isavailable,
mrp.updated,
mrp.updatedby,
pp.ismps,
mrp.name,
mrp.description,
mrp.c_order_id,
mrp.c_orderline_id,
mrp.dateordered,
mrp.dateconfirm,
mrp.datepromised,
mrp.datestartschedule,
mrp.datefinishschedule,
mrp.datestart,
mrp.datesimulation,
mrp.docstatus,
mrp.m_forecast_id,
mrp.m_forecastline_id,
mrp.value,
mrp.m_product_id,
mrp.m_requisition_id,
mrp.m_requisitionline_id,
mrp.m_warehouse_id,
mrp.pp_order_id,
mrp.pp_order_bomline_id,
mrp.dd_order_id,
mrp.dd_orderline_id,
mrp.qty,
mrp.s_resource_id,
mrp.planner_id,
mrp.priority,
mrp.ordertype,
mrp.typemrp,
p.lowlevel,
mrp.c_bpartner_id,
mrp.version,
documentno(mrp.pp_mrp_id) AS documentno
FROM ((pp_mrp mrp
JOIN m_product p ON ((mrp.m_product_id = p.m_product_id)))
LEFT JOIN pp_product_planning pp ON (((pp.m_product_id = mrp.m_product_id) AND (mrp.m_warehouse_id = pp.m_warehouse_id))))
WHERE (mrp.qty <> (0)::numeric)
UNION
SELECT 0 AS pp_mrp_id,
pp.ad_client_id,
pp.ad_org_id,
pp.created,
pp.createdby,
pp.isactive,
'Y'::bpchar AS isavailable,
pp.updated,
pp.updatedby,
pp.ismps,
NULL::character varying AS name,
NULL::character varying AS description,
NULL::numeric AS c_order_id,
NULL::numeric AS c_orderline_id,
now() AS dateordered,
now() AS dateconfirm,
now() AS datepromised,
now() AS datestartschedule,
now() AS datefinishschedule,
now() AS datestart,
now() AS datesimulation,
'CO'::character varying AS docstatus,
NULL::numeric AS m_forecast_id,
NULL::numeric AS m_forecastline_id,
NULL::character varying AS value,
pp.m_product_id,
NULL::numeric AS m_requisition_id,
NULL::numeric AS m_requisitionline_id,
pp.m_warehouse_id,
NULL::numeric AS pp_order_id,
NULL::numeric AS pp_order_bomline_id,
NULL::numeric AS dd_order_id,
NULL::numeric AS dd_orderline_id,
(pp.safetystock - bomqtyonhand(pp.m_product_id, pp.m_warehouse_id, (0)::numeric)) AS qty,
pp.s_resource_id,
NULL::numeric AS planner_id,
NULL::character varying AS priority,
'STK'::character varying AS ordertype,
'D'::bpchar AS typemrp,
p.lowlevel,
NULL::numeric AS c_bpartner_id,
NULL::numeric AS version,
'Safety Strock'::character varying AS documentno
FROM (pp_product_planning pp
JOIN m_product p ON ((pp.m_product_id = p.m_product_id)))
WHERE (bomqtyonhand(pp.m_product_id, pp.m_warehouse_id, (0)::numeric) < pp.safetystock);