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


カラム情報
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 dd_order_id numeric(10)  
9 c_order_id numeric(10)  
10 docstatus character(2)  
11 docaction character(2)  
12 c_doctype_id numeric(10)  
13 isapproved character(1)  
14 salesrep_id numeric(10)  
15 isdropship character(1)  
16 c_bpartner_id numeric(10)  
17 c_bp_group_id numeric(10)  
18 ad_user_id numeric(10)  
19 poreference character varying(20)  
20 issotrx character(1)  
21 c_campaign_id numeric(10)  
22 c_project_id numeric(10)  
23 c_activity_id numeric(10)  
24 dd_orderline_id numeric(10)  
25 dateordered timestamp without time zone  
26 datepromised timestamp without time zone  
27 m_product_id numeric(10)  
28 m_locator_id numeric(10)  
29 m_locatorto_id numeric(10)  
30 m_attributesetinstance_id numeric(10)  
31 productattribute character varying  
32 m_attributesetinstanceto_id numeric(10)  
33 productattributeto character varying  
34 m_attributeset_id numeric(10)  
35 m_lot_id numeric(10)  
36 guaranteedate timestamp without time zone  
37 lot character varying(40)  
38 serno character varying(40)  
39 c_uom_id numeric(10)  
40 qtyentered numeric  
41 qtyordered numeric  
42 qtyreserved numeric  
43 qtydelivered numeric  
44 confirmedqty numeric  
45 qtyintransit numeric  
46 targetqty numeric  
47 qtytodeliver numeric  
48 description character varying(255)  


ソース
ソース 
 SELECT l.ad_client_id,
    l.ad_org_id,
    l.isactive,
    l.created,
    l.createdby,
    l.updated,
    l.updatedby,
    o.dd_order_id,
    o.c_order_id,
    o.docstatus,
    o.docaction,
    o.c_doctype_id,
    o.isapproved,
    o.salesrep_id,
    o.isdropship,
    o.c_bpartner_id,
    bp.c_bp_group_id,
    o.ad_user_id,
    o.poreference,
    o.issotrx,
    l.c_campaign_id,
    l.c_project_id,
    l.c_activity_id,
    l.dd_orderline_id,
    l.dateordered,
    l.datepromised,
    l.m_product_id,
    l.m_locator_id,
    l.m_locatorto_id,
    l.m_attributesetinstance_id,
    productattribute(l.m_attributesetinstance_id) AS productattribute,
    l.m_attributesetinstanceto_id,
    productattribute(l.m_attributesetinstanceto_id) AS productattributeto,
    pasi.m_attributeset_id,
    pasi.m_lot_id,
    pasi.guaranteedate,
    pasi.lot,
    pasi.serno,
    l.c_uom_id,
    l.qtyentered,
    l.qtyordered,
    l.qtyreserved,
    l.qtydelivered,
    l.confirmedqty,
    l.qtyintransit,
    l.targetqty,
    (l.qtyordered - l.qtydelivered) AS qtytodeliver,
    l.description
   FROM ((((dd_order o
     JOIN dd_orderline l ON ((l.dd_order_id = o.dd_order_id)))
     JOIN c_bpartner bp ON ((bp.c_bpartner_id = o.c_bpartner_id)))
     LEFT JOIN m_attributesetinstance pasi ON ((l.m_attributesetinstance_id = pasi.m_attributesetinstance_id)))
     LEFT JOIN m_attributesetinstance pasito ON ((l.m_attributesetinstanceto_id = pasito.m_attributesetinstance_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_dd_orderdetail
3 viewowner adempiere
4 definition SELECT l.ad_client_id,
l.ad_org_id,
l.isactive,
l.created,
l.createdby,
l.updated,
l.updatedby,
o.dd_order_id,
o.c_order_id,
o.docstatus,
o.docaction,
o.c_doctype_id,
o.isapproved,
o.salesrep_id,
o.isdropship,
o.c_bpartner_id,
bp.c_bp_group_id,
o.ad_user_id,
o.poreference,
o.issotrx,
l.c_campaign_id,
l.c_project_id,
l.c_activity_id,
l.dd_orderline_id,
l.dateordered,
l.datepromised,
l.m_product_id,
l.m_locator_id,
l.m_locatorto_id,
l.m_attributesetinstance_id,
productattribute(l.m_attributesetinstance_id) AS productattribute,
l.m_attributesetinstanceto_id,
productattribute(l.m_attributesetinstanceto_id) AS productattributeto,
pasi.m_attributeset_id,
pasi.m_lot_id,
pasi.guaranteedate,
pasi.lot,
pasi.serno,
l.c_uom_id,
l.qtyentered,
l.qtyordered,
l.qtyreserved,
l.qtydelivered,
l.confirmedqty,
l.qtyintransit,
l.targetqty,
(l.qtyordered - l.qtydelivered) AS qtytodeliver,
l.description
FROM ((((dd_order o
JOIN dd_orderline l ON ((l.dd_order_id = o.dd_order_id)))
JOIN c_bpartner bp ON ((bp.c_bpartner_id = o.c_bpartner_id)))
LEFT JOIN m_attributesetinstance pasi ON ((l.m_attributesetinstance_id = pasi.m_attributesetinstance_id)))
LEFT JOIN m_attributesetinstance pasito ON ((l.m_attributesetinstanceto_id = pasito.m_attributesetinstance_id)));