テーブル情報
システム名 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 
物理テーブル名 m_inout_lineconfirm_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 m_inoutlineconfirm_id numeric(10)  
10 m_inoutconfirm_id numeric(10)  
11 targetqty numeric  
12 confirmedqty numeric  
13 differenceqty numeric  
14 scrappedqty numeric  
15 description character varying(255)  
16 processed character(1)  
17 m_inout_id numeric(10)  
18 m_inoutline_id numeric(10)  
19 line numeric(10)  
20 m_product_id numeric(10)  
21 movementqty numeric  
22 uomsymbol character varying(10)  
23 qtybackordered numeric  
24 name character varying(255)  
25 shipdescription character varying  
26 documentnote character varying(2000)  
27 upc character varying(30)  
28 sku character varying(30)  
29 productvalue character varying(40)  
30 m_locator_id numeric(10)  
31 m_warehouse_id numeric(10)  
32 x character varying(60)  
33 y character varying(60)  
34 z character varying(60)  
35 m_attributesetinstance_id numeric(10)  
36 m_attributeset_id numeric(10)  
37 serno character varying(40)  
38 lot character varying(40)  
39 m_lot_id numeric(10)  
40 guaranteedate timestamp without time zone  


ソース
ソース
 SELECT iolc.ad_client_id,
iolc.ad_org_id,
iolc.isactive,
iolc.created,
iolc.createdby,
iolc.updated,
iolc.updatedby,
uom.ad_language,
iolc.m_inoutlineconfirm_id,
iolc.m_inoutconfirm_id,
iolc.targetqty,
iolc.confirmedqty,
iolc.differenceqty,
iolc.scrappedqty,
iolc.description,
iolc.processed,
iol.m_inout_id,
iol.m_inoutline_id,
iol.line,
p.m_product_id,
iol.movementqty,
uom.uomsymbol,
(ol.qtyordered - ol.qtydelivered) AS qtybackordered,
COALESCE(COALESCE(pt.name, p.name), iol.description) AS name,
CASE
WHEN (COALESCE(pt.name, p.name) IS NOT NULL) THEN iol.description
ELSE NULL::character varying
END AS shipdescription,
COALESCE(pt.documentnote, p.documentnote) AS documentnote,
p.upc,
p.sku,
p.value AS productvalue,
iol.m_locator_id,
l.m_warehouse_id,
l.x,
l.y,
l.z,
iol.m_attributesetinstance_id,
asi.m_attributeset_id,
asi.serno,
asi.lot,
asi.m_lot_id,
asi.guaranteedate
FROM (((((((m_inoutlineconfirm iolc
JOIN m_inoutline iol ON ((iolc.m_inoutline_id = iol.m_inoutline_id)))
JOIN c_uom_trl uom ON ((iol.c_uom_id = uom.c_uom_id)))
LEFT JOIN m_product p ON ((iol.m_product_id = p.m_product_id)))
LEFT JOIN m_product_trl pt ON (((iol.m_product_id = pt.m_product_id) AND ((uom.ad_language)::text = (pt.ad_language)::text))))
LEFT JOIN m_attributesetinstance asi ON ((iol.m_attributesetinstance_id = asi.m_attributesetinstance_id)))
LEFT JOIN m_locator l ON ((iol.m_locator_id = l.m_locator_id)))
LEFT JOIN c_orderline ol ON ((iol.c_orderline_id = ol.c_orderline_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname m_inout_lineconfirm_vt
3 viewowner adempiere
4 definition SELECT iolc.ad_client_id,
iolc.ad_org_id,
iolc.isactive,
iolc.created,
iolc.createdby,
iolc.updated,
iolc.updatedby,
uom.ad_language,
iolc.m_inoutlineconfirm_id,
iolc.m_inoutconfirm_id,
iolc.targetqty,
iolc.confirmedqty,
iolc.differenceqty,
iolc.scrappedqty,
iolc.description,
iolc.processed,
iol.m_inout_id,
iol.m_inoutline_id,
iol.line,
p.m_product_id,
iol.movementqty,
uom.uomsymbol,
(ol.qtyordered - ol.qtydelivered) AS qtybackordered,
COALESCE(COALESCE(pt.name, p.name), iol.description) AS name,
CASE
WHEN (COALESCE(pt.name, p.name) IS NOT NULL) THEN iol.description
ELSE NULL::character varying
END AS shipdescription,
COALESCE(pt.documentnote, p.documentnote) AS documentnote,
p.upc,
p.sku,
p.value AS productvalue,
iol.m_locator_id,
l.m_warehouse_id,
l.x,
l.y,
l.z,
iol.m_attributesetinstance_id,
asi.m_attributeset_id,
asi.serno,
asi.lot,
asi.m_lot_id,
asi.guaranteedate
FROM (((((((m_inoutlineconfirm iolc
JOIN m_inoutline iol ON ((iolc.m_inoutline_id = iol.m_inoutline_id)))
JOIN c_uom_trl uom ON ((iol.c_uom_id = uom.c_uom_id)))
LEFT JOIN m_product p ON ((iol.m_product_id = p.m_product_id)))
LEFT JOIN m_product_trl pt ON (((iol.m_product_id = pt.m_product_id) AND ((uom.ad_language)::text = (pt.ad_language)::text))))
LEFT JOIN m_attributesetinstance asi ON ((iol.m_attributesetinstance_id = asi.m_attributesetinstance_id)))
LEFT JOIN m_locator l ON ((iol.m_locator_id = l.m_locator_id)))
LEFT JOIN c_orderline ol ON ((iol.c_orderline_id = ol.c_orderline_id)));