テーブル情報
システム名 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_bomline_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 description character varying(255)  
10 feature character varying(30)  
11 m_product_id numeric(10)  
12 backflushgroup character varying(30)  
13 c_uom_id numeric(10)  
14 componenttype character(2)  
15 datedelivered timestamp without time zone  
16 forecast numeric  
17 help character varying(2000)  
18 iscritical character(1)  
19 issuemethod character(1)  
20 leadtimeoffset numeric(10)  
21 line numeric(10)  
22 m_attributesetinstance_id numeric(10)  
23 m_changenotice_id numeric(10)  
24 m_locator_id numeric(10)  
25 m_warehouse_id numeric(10)  
26 pp_order_bom_id numeric(10)  
27 pp_order_bomline_id numeric(10)  
28 pp_order_id numeric(10)  
29 qtydelivered numeric  
30 qtypost numeric  
31 qtyreject numeric  
32 qtyscrap numeric  
33 scrap numeric  
34 validfrom timestamp without time zone  
35 validto timestamp without time zone  
36 assay numeric  
37 ad_user_id numeric(10)  
38 qtybatchs numeric  
39 qtyrequiered numeric  
40 qtyreserved numeric  
41 qtyavailable numeric  
42 qtyonhand numeric  
43 qtybom numeric  
44 isqtypercentage character(1)  
45 qtybatch numeric  
46 qtybatchsize numeric  


ソース
ソース 
 SELECT obl.ad_client_id,
    obl.ad_org_id,
    obl.isactive,
    obl.created,
    obl.createdby,
    obl.updated,
    obl.updatedby,
    oblt.ad_language,
    oblt.description,
    obl.feature,
    obl.m_product_id,
    obl.backflushgroup,
    obl.c_uom_id,
    obl.componenttype,
    obl.datedelivered,
    obl.forecast,
    oblt.help,
    obl.iscritical,
    obl.issuemethod,
    obl.leadtimeoffset,
    obl.line,
    obl.m_attributesetinstance_id,
    obl.m_changenotice_id,
    obl.m_locator_id,
    obl.m_warehouse_id,
    obl.pp_order_bom_id,
    obl.pp_order_bomline_id,
    obl.pp_order_id,
    obl.qtydelivered,
    obl.qtypost,
    obl.qtyreject,
    obl.qtyscrap,
    obl.scrap,
    obl.validfrom,
    obl.validto,
    obl.assay,
    obl.ad_user_id,
    o.qtybatchs,
    round(obl.qtyrequiered, 4) AS qtyrequiered,
    round(bomqtyreserved(obl.m_product_id, obl.m_warehouse_id, (0)::numeric), 4) AS qtyreserved,
    round(bomqtyavailable(obl.m_product_id, obl.m_warehouse_id, (0)::numeric), 4) AS qtyavailable,
    round(bomqtyonhand(obl.m_product_id, obl.m_warehouse_id, (0)::numeric), 4) AS qtyonhand,
    round(obl.qtybom, 4) AS qtybom,
    obl.isqtypercentage,
    round(obl.qtybatch, 4) AS qtybatch,
        CASE
            WHEN (o.qtybatchs = (0)::numeric) THEN (1)::numeric
            ELSE round((obl.qtyrequiered / o.qtybatchs), 4)
        END AS qtybatchsize
   FROM ((pp_order_bomline obl
     JOIN pp_order o ON ((o.pp_order_id = obl.pp_order_id)))
     LEFT JOIN pp_order_bomline_trl oblt ON ((oblt.pp_order_bomline_id = obl.pp_order_bomline_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname pp_order_bomline_vt
3 viewowner adempiere
4 definition SELECT obl.ad_client_id,
obl.ad_org_id,
obl.isactive,
obl.created,
obl.createdby,
obl.updated,
obl.updatedby,
oblt.ad_language,
oblt.description,
obl.feature,
obl.m_product_id,
obl.backflushgroup,
obl.c_uom_id,
obl.componenttype,
obl.datedelivered,
obl.forecast,
oblt.help,
obl.iscritical,
obl.issuemethod,
obl.leadtimeoffset,
obl.line,
obl.m_attributesetinstance_id,
obl.m_changenotice_id,
obl.m_locator_id,
obl.m_warehouse_id,
obl.pp_order_bom_id,
obl.pp_order_bomline_id,
obl.pp_order_id,
obl.qtydelivered,
obl.qtypost,
obl.qtyreject,
obl.qtyscrap,
obl.scrap,
obl.validfrom,
obl.validto,
obl.assay,
obl.ad_user_id,
o.qtybatchs,
round(obl.qtyrequiered, 4) AS qtyrequiered,
round(bomqtyreserved(obl.m_product_id, obl.m_warehouse_id, (0)::numeric), 4) AS qtyreserved,
round(bomqtyavailable(obl.m_product_id, obl.m_warehouse_id, (0)::numeric), 4) AS qtyavailable,
round(bomqtyonhand(obl.m_product_id, obl.m_warehouse_id, (0)::numeric), 4) AS qtyonhand,
round(obl.qtybom, 4) AS qtybom,
obl.isqtypercentage,
round(obl.qtybatch, 4) AS qtybatch,
CASE
WHEN (o.qtybatchs = (0)::numeric) THEN (1)::numeric
ELSE round((obl.qtyrequiered / o.qtybatchs), 4)
END AS qtybatchsize
FROM ((pp_order_bomline obl
JOIN pp_order o ON ((o.pp_order_id = obl.pp_order_id)))
LEFT JOIN pp_order_bomline_trl oblt ON ((oblt.pp_order_bomline_id = obl.pp_order_bomline_id)));