テーブル情報
システム名 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 
物理テーブル名 dd_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 dd_order_id numeric(10)  
10 c_order_id numeric(10)  
11 issotrx character(1)  
12 documentno character varying(30)  
13 docstatus character(2)  
14 c_doctype_id numeric(10)  
15 c_bpartner_id numeric(10)  
16 bpvalue character varying(40)  
17 bptaxid character varying(20)  
18 naics character(6)  
19 duns character(11)  
20 org_location_id numeric(10)  
21 taxid character varying(20)  
22 m_warehouse_id numeric(10)  
23 warehouse_location_id numeric(10)  
24 documenttype character varying(60)  
25 documenttypenote character varying(2000)  
26 salesrep_id numeric(10)  
27 salesrep_name character varying  
28 dateordered timestamp without time zone  
29 datepromised timestamp without time zone  
30 bpgreeting character varying(60)  
31 name character varying(120)  
32 name2 character varying(60)  
33 bpcontactgreeting character varying(60)  
34 title character varying(40)  
35 phone character varying(40)  
36 contactname text  
37 c_location_id numeric(10)  
38 postal text  
39 referenceno character varying(40)  
40 description character varying(255)  
41 poreference character varying(20)  
42 c_charge_id numeric(10)  
43 chargeamt numeric  
44 volume numeric  
45 weight numeric  
46 c_campaign_id numeric(10)  
47 c_project_id numeric(10)  
48 c_activity_id numeric(10)  
49 m_shipper_id numeric(10)  
50 deliveryrule character(1)  
51 deliveryviarule character(1)  
52 priorityrule character(1)  
53 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.dd_order_id,
    o.c_order_id,
    o.issotrx,
    o.documentno,
    o.docstatus,
    o.c_doctype_id,
    o.c_bpartner_id,
    bp.value AS bpvalue,
    bp.taxid AS bptaxid,
    bp.naics,
    bp.duns,
    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.salesrep_id,
    COALESCE(ubp.name, u.name) AS salesrep_name,
    o.dateordered,
    o.datepromised,
    bpg.greeting AS bpgreeting,
    bp.name,
    bp.name2,
    bpcg.greeting AS bpcontactgreeting,
    bpc.title,
    bpc.phone,
    NULLIF((bpc.name)::text, (bp.name)::text) AS contactname,
    bpl.c_location_id,
    ((l.postal)::text || (l.postal_add)::text) AS postal,
    bp.referenceno,
    o.description,
    o.poreference,
    o.c_charge_id,
    o.chargeamt,
    o.volume,
    o.weight,
    o.c_campaign_id,
    o.c_project_id,
    o.c_activity_id,
    o.m_shipper_id,
    o.deliveryrule,
    o.deliveryviarule,
    o.priorityrule,
    COALESCE(oi.logo_id, ci.logo_id) AS logo_id
   FROM ((((((((((((dd_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 c_bpartner bp ON ((o.c_bpartner_id = bp.c_bpartner_id)))
     LEFT JOIN c_greeting_trl bpg ON (((bp.c_greeting_id = bpg.c_greeting_id) AND ((dt.ad_language)::text = (bpg.ad_language)::text))))
     JOIN c_bpartner_location bpl ON ((o.c_bpartner_location_id = bpl.c_bpartner_location_id)))
     JOIN c_location l ON ((bpl.c_location_id = l.c_location_id)))
     LEFT JOIN ad_user bpc ON ((o.ad_user_id = bpc.ad_user_id)))
     LEFT JOIN c_greeting_trl bpcg ON (((bpc.c_greeting_id = bpcg.c_greeting_id) AND ((dt.ad_language)::text = (bpcg.ad_language)::text))))
     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.salesrep_id = u.ad_user_id)))
     LEFT JOIN c_bpartner ubp ON ((u.c_bpartner_id = ubp.c_bpartner_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname dd_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.dd_order_id,
o.c_order_id,
o.issotrx,
o.documentno,
o.docstatus,
o.c_doctype_id,
o.c_bpartner_id,
bp.value AS bpvalue,
bp.taxid AS bptaxid,
bp.naics,
bp.duns,
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.salesrep_id,
COALESCE(ubp.name, u.name) AS salesrep_name,
o.dateordered,
o.datepromised,
bpg.greeting AS bpgreeting,
bp.name,
bp.name2,
bpcg.greeting AS bpcontactgreeting,
bpc.title,
bpc.phone,
NULLIF((bpc.name)::text, (bp.name)::text) AS contactname,
bpl.c_location_id,
((l.postal)::text || (l.postal_add)::text) AS postal,
bp.referenceno,
o.description,
o.poreference,
o.c_charge_id,
o.chargeamt,
o.volume,
o.weight,
o.c_campaign_id,
o.c_project_id,
o.c_activity_id,
o.m_shipper_id,
o.deliveryrule,
o.deliveryviarule,
o.priorityrule,
COALESCE(oi.logo_id, ci.logo_id) AS logo_id
FROM ((((((((((((dd_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 c_bpartner bp ON ((o.c_bpartner_id = bp.c_bpartner_id)))
LEFT JOIN c_greeting_trl bpg ON (((bp.c_greeting_id = bpg.c_greeting_id) AND ((dt.ad_language)::text = (bpg.ad_language)::text))))
JOIN c_bpartner_location bpl ON ((o.c_bpartner_location_id = bpl.c_bpartner_location_id)))
JOIN c_location l ON ((bpl.c_location_id = l.c_location_id)))
LEFT JOIN ad_user bpc ON ((o.ad_user_id = bpc.ad_user_id)))
LEFT JOIN c_greeting_trl bpcg ON (((bpc.c_greeting_id = bpcg.c_greeting_id) AND ((dt.ad_language)::text = (bpcg.ad_language)::text))))
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.salesrep_id = u.ad_user_id)))
LEFT JOIN c_bpartner ubp ON ((u.c_bpartner_id = ubp.c_bpartner_id)));