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


カラム情報
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 updated timestamp without time zone  
7 updatedby numeric(10)  
8 ad_language character varying  
9 pp_order_id numeric(10)  
10 documentno character varying(60)  
11 docstatus character(2)  
12 c_doctype_id numeric(10)  
13 org_location_id numeric(10)  
14 taxid character varying(20)  
15 m_warehouse_id numeric(10)  
16 warehouse_location_id numeric(10)  
17 documenttype character varying(60)  
18 documenttypenote character varying(2000)  
19 planner_id numeric(10)  
20 salesrep_name character varying(60)  
21 datestart timestamp without time zone  
22 datestartschedule timestamp without time zone  
23 floatafter numeric  
24 floatbefored numeric  
25 line numeric(10)  
26 lot character varying(20)  
27 serno character varying(20)  
28 c_uom_id numeric(10)  
29 s_resource_id numeric(10)  
30 pp_product_bom_id numeric(10)  
31 ad_workflow_id numeric(10)  
32 assay numeric  
33 c_orderline_id numeric(10)  
34 priorityrule character(1)  
35 qtybatchsize numeric  
36 qtybatchs numeric  
37 qtydelivered numeric  
38 qtyentered numeric  
39 qtyordered numeric  
40 dateconfirm timestamp without time zone  
41 datedelivered timestamp without time zone  
42 datefinish timestamp without time zone  
43 datefinishschedule timestamp without time zone  
44 dateordered timestamp without time zone  
45 datepromised timestamp without time zone  
46 qtyreject numeric  
47 qtyreserved numeric  
48 qtyscrap numeric  
49 yield numeric  
50 c_campaign_id numeric(10)  
51 c_project_id numeric(10)  
52 c_activity_id numeric(10)  
53 bomtype character(1)  
54 bomuse character(1)  
55 description character varying(255)  
56 help character varying(2000)  
57 m_attributesetinstance_id numeric(10)  
58 m_product_id numeric(10)  
59 name character varying(60)  
60 revision character varying(10)  
61 validfrom timestamp without time zone  
62 validto timestamp without time zone  
63 logo_id numeric(10)  


ソース
ソース 
 SELECT o.ad_client_id,
    o.ad_org_id,
    o.isactive,
    o.created,
    o.createdby,
    o.updated,
    o.updatedby,
    'en_US'::character varying AS ad_language,
    o.pp_order_id,
    o.documentno,
    o.docstatus,
    o.c_doctype_id,
    oi.c_location_id AS org_location_id,
    oi.taxid,
    o.m_warehouse_id,
    wh.c_location_id AS warehouse_location_id,
    d.printname AS documenttype,
    d.documentnote AS documenttypenote,
    o.planner_id,
    u.name AS salesrep_name,
    o.datestart,
    o.datestartschedule,
    o.floatafter,
    o.floatbefored,
    o.line,
    o.lot,
    o.serno,
    o.c_uom_id,
    o.s_resource_id,
    o.pp_product_bom_id,
    o.ad_workflow_id,
    o.assay,
    o.c_orderline_id,
    o.priorityrule,
    o.qtybatchsize,
    o.qtybatchs,
    o.qtydelivered,
    o.qtyentered,
    o.qtyordered,
    o.dateconfirm,
    o.datedelivered,
    o.datefinish,
    o.datefinishschedule,
    o.dateordered,
    o.datepromised,
    o.qtyreject,
    o.qtyreserved,
    o.qtyscrap,
    o.yield,
    o.c_campaign_id,
    o.c_project_id,
    o.c_activity_id,
    ob.bomtype,
    ob.bomuse,
    ob.description,
    ob.help,
    ob.m_attributesetinstance_id,
    ob.m_product_id,
    ob.name,
    ob.revision,
    ob.validfrom,
    ob.validto,
    COALESCE(oi.logo_id, ci.logo_id) AS logo_id
   FROM ((((((pp_order o
     JOIN c_doctype d ON ((o.c_doctype_id = d.c_doctype_id)))
     JOIN pp_order_bom ob ON ((ob.pp_order_id = o.pp_order_id)))
     JOIN m_warehouse wh ON ((o.m_warehouse_id = wh.m_warehouse_id)))
     JOIN ad_orginfo oi ON ((o.ad_org_id = oi.ad_org_id)))
     JOIN ad_clientinfo ci ON ((o.ad_client_id = ci.ad_client_id)))
     LEFT JOIN ad_user u ON ((o.planner_id = u.ad_user_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname pp_order_bom_header_v
3 viewowner adempiere
4 definition SELECT o.ad_client_id,
o.ad_org_id,
o.isactive,
o.created,
o.createdby,
o.updated,
o.updatedby,
'en_US'::character varying AS ad_language,
o.pp_order_id,
o.documentno,
o.docstatus,
o.c_doctype_id,
oi.c_location_id AS org_location_id,
oi.taxid,
o.m_warehouse_id,
wh.c_location_id AS warehouse_location_id,
d.printname AS documenttype,
d.documentnote AS documenttypenote,
o.planner_id,
u.name AS salesrep_name,
o.datestart,
o.datestartschedule,
o.floatafter,
o.floatbefored,
o.line,
o.lot,
o.serno,
o.c_uom_id,
o.s_resource_id,
o.pp_product_bom_id,
o.ad_workflow_id,
o.assay,
o.c_orderline_id,
o.priorityrule,
o.qtybatchsize,
o.qtybatchs,
o.qtydelivered,
o.qtyentered,
o.qtyordered,
o.dateconfirm,
o.datedelivered,
o.datefinish,
o.datefinishschedule,
o.dateordered,
o.datepromised,
o.qtyreject,
o.qtyreserved,
o.qtyscrap,
o.yield,
o.c_campaign_id,
o.c_project_id,
o.c_activity_id,
ob.bomtype,
ob.bomuse,
ob.description,
ob.help,
ob.m_attributesetinstance_id,
ob.m_product_id,
ob.name,
ob.revision,
ob.validfrom,
ob.validto,
COALESCE(oi.logo_id, ci.logo_id) AS logo_id
FROM ((((((pp_order o
JOIN c_doctype d ON ((o.c_doctype_id = d.c_doctype_id)))
JOIN pp_order_bom ob ON ((ob.pp_order_id = o.pp_order_id)))
JOIN m_warehouse wh ON ((o.m_warehouse_id = wh.m_warehouse_id)))
JOIN ad_orginfo oi ON ((o.ad_org_id = oi.ad_org_id)))
JOIN ad_clientinfo ci ON ((o.ad_client_id = ci.ad_client_id)))
LEFT JOIN ad_user u ON ((o.planner_id = u.ad_user_id)));