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


カラム情報
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(6)  
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 description character varying(510)  
29 m_product_id numeric(10)  
30 m_attributesetinstance_id numeric(10)  
31 c_uom_id numeric(10)  
32 s_resource_id numeric(10)  
33 pp_product_bom_id numeric(10)  
34 ad_workflow_id numeric(10)  
35 assay numeric  
36 c_orderline_id numeric(10)  
37 priorityrule character(1)  
38 qtybatchsize numeric  
39 qtybatchs numeric  
40 qtydelivered numeric  
41 qtyentered numeric  
42 qtyordered numeric  
43 dateconfirm timestamp without time zone  
44 datedelivered timestamp without time zone  
45 datefinish timestamp without time zone  
46 datefinishschedule timestamp without time zone  
47 dateordered timestamp without time zone  
48 datepromised timestamp without time zone  
49 qtyreject numeric  
50 qtyreserved numeric  
51 qtyscrap numeric  
52 yield numeric  
53 c_campaign_id numeric(10)  
54 c_project_id numeric(10)  
55 c_activity_id numeric(10)  
56 user1_id numeric(10)  
57 user2_id numeric(10)  
58 ad_orgtrx_id numeric(10)  
59 c_doctypetarget_id numeric(10)  
60 scheduletype character varying(1)  
61 isapproved character(1)  
62 docaction character(2)  
63 posted character(1)  
64 isprinted character(1)  
65 ordertype character varying(1)  
66 logo_id numeric(10)  


ソース
ソース 
 SELECT o.ad_client_id,
    o.ad_org_id,
    o.isactive,
    o.created,
    o.createdby,
    o.updated,
    o.updatedby,
    dt.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,
    dt.printname AS documenttype,
    dt.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.description,
    o.m_product_id,
    o.m_attributesetinstance_id,
    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,
    o.user1_id,
    o.user2_id,
    o.ad_orgtrx_id,
    o.c_doctypetarget_id,
    o.scheduletype,
    o.isapproved,
    o.docaction,
    o.posted,
    o.isprinted,
    o.ordertype,
    COALESCE(oi.logo_id, ci.logo_id) AS logo_id
   FROM (((((pp_order o
     JOIN c_doctype_trl dt ON ((o.c_doctype_id = dt.c_doctype_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_header_vt
3 viewowner adempiere
4 definition SELECT o.ad_client_id,
o.ad_org_id,
o.isactive,
o.created,
o.createdby,
o.updated,
o.updatedby,
dt.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,
dt.printname AS documenttype,
dt.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.description,
o.m_product_id,
o.m_attributesetinstance_id,
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,
o.user1_id,
o.user2_id,
o.ad_orgtrx_id,
o.c_doctypetarget_id,
o.scheduletype,
o.isapproved,
o.docaction,
o.posted,
o.isprinted,
o.ordertype,
COALESCE(oi.logo_id, ci.logo_id) AS logo_id
FROM (((((pp_order o
JOIN c_doctype_trl dt ON ((o.c_doctype_id = dt.c_doctype_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)));