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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_client_id numeric(10)  
2 ad_org_id numeric(10)  
3 c_rfq_id numeric(10)  
4 c_rfq_topic_id numeric(10)  
5 c_bpartner_id numeric(10)  
6 c_bpartner_location_id numeric(10)  
7 ad_user_id numeric(10)  
8 c_rfqresponse_id numeric(10)  
9 c_currency_id numeric(10)  
10 dateresponse timestamp without time zone  
11 dateworkstart timestamp without time zone  
12 deliverydays numeric(10)  
13 dateworkcomplete timestamp without time zone  
14 price numeric  
15 ranking numeric(10)  
16 isselfservice character(1)  
17 description character varying(255)  
18 help character varying(2000)  
19 m_product_id numeric(10)  
20 m_attributesetinstance_id numeric(10)  
21 line numeric(10)  
22 linedateworkstart timestamp without time zone  
23 linedeliverydays numeric(10)  
24 linedateworkcomplete timestamp without time zone  
25 linedescription character varying(255)  
26 linehelp character varying(2000)  
27 c_uom_id numeric(10)  
28 qty numeric  
29 benchmarkprice numeric  
30 benchmarkdifference numeric  
31 qtyprice numeric  
32 discount numeric  
33 qtyranking numeric(10)  


ソース
ソース 
 SELECT q.ad_client_id,
    q.ad_org_id,
    q.c_rfq_id,
    q.c_rfq_topic_id,
    r.c_bpartner_id,
    r.c_bpartner_location_id,
    r.ad_user_id,
    r.c_rfqresponse_id,
    r.c_currency_id,
    r.dateresponse,
    r.dateworkstart,
    r.deliverydays,
    r.dateworkcomplete,
    r.price,
    r.ranking,
    r.isselfservice,
    r.description,
    r.help,
    ql.m_product_id,
    ql.m_attributesetinstance_id,
    ql.line,
    rl.dateworkstart AS linedateworkstart,
    rl.deliverydays AS linedeliverydays,
    rl.dateworkcomplete AS linedateworkcomplete,
    rl.description AS linedescription,
    rl.help AS linehelp,
    qlq.c_uom_id,
    qlq.qty,
    qlq.benchmarkprice,
    (rlq.price - qlq.benchmarkprice) AS benchmarkdifference,
    rlq.price AS qtyprice,
    rlq.discount,
    rlq.ranking AS qtyranking
   FROM (((((c_rfq q
     JOIN c_rfqline ql ON ((q.c_rfq_id = ql.c_rfq_id)))
     JOIN c_rfqlineqty qlq ON ((ql.c_rfqline_id = qlq.c_rfqline_id)))
     JOIN c_rfqresponse r ON ((q.c_rfq_id = r.c_rfq_id)))
     JOIN c_rfqresponseline rl ON (((r.c_rfqresponse_id = rl.c_rfqresponse_id) AND (ql.c_rfqline_id = rl.c_rfqline_id))))
     JOIN c_rfqresponselineqty rlq ON (((rl.c_rfqresponseline_id = rlq.c_rfqresponseline_id) AND (qlq.c_rfqlineqty_id = rlq.c_rfqlineqty_id))))
  WHERE ((r.iscomplete = 'Y'::bpchar) AND (q.processed = 'N'::bpchar));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_c_rfqresponse
3 viewowner adempiere
4 definition SELECT q.ad_client_id,
q.ad_org_id,
q.c_rfq_id,
q.c_rfq_topic_id,
r.c_bpartner_id,
r.c_bpartner_location_id,
r.ad_user_id,
r.c_rfqresponse_id,
r.c_currency_id,
r.dateresponse,
r.dateworkstart,
r.deliverydays,
r.dateworkcomplete,
r.price,
r.ranking,
r.isselfservice,
r.description,
r.help,
ql.m_product_id,
ql.m_attributesetinstance_id,
ql.line,
rl.dateworkstart AS linedateworkstart,
rl.deliverydays AS linedeliverydays,
rl.dateworkcomplete AS linedateworkcomplete,
rl.description AS linedescription,
rl.help AS linehelp,
qlq.c_uom_id,
qlq.qty,
qlq.benchmarkprice,
(rlq.price - qlq.benchmarkprice) AS benchmarkdifference,
rlq.price AS qtyprice,
rlq.discount,
rlq.ranking AS qtyranking
FROM (((((c_rfq q
JOIN c_rfqline ql ON ((q.c_rfq_id = ql.c_rfq_id)))
JOIN c_rfqlineqty qlq ON ((ql.c_rfqline_id = qlq.c_rfqline_id)))
JOIN c_rfqresponse r ON ((q.c_rfq_id = r.c_rfq_id)))
JOIN c_rfqresponseline rl ON (((r.c_rfqresponse_id = rl.c_rfqresponse_id) AND (ql.c_rfqline_id = rl.c_rfqline_id))))
JOIN c_rfqresponselineqty rlq ON (((rl.c_rfqresponseline_id = rlq.c_rfqresponseline_id) AND (qlq.c_rfqlineqty_id = rlq.c_rfqlineqty_id))))
WHERE ((r.iscomplete = 'Y'::bpchar) AND (q.processed = 'N'::bpchar));