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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_rfqresponse_id numeric(10)  
2 c_rfqresponseline_id numeric(10)  
3 c_rfqline_id numeric(10)  
4 c_rfqresponselineqty_id numeric(10)  
5 c_rfqlineqty_id numeric(10)  
6 ad_client_id numeric(10)  
7 ad_org_id numeric(10)  
8 isactive character(1)  
9 created timestamp without time zone  
10 createdby numeric(10)  
11 updated timestamp without time zone  
12 updatedby numeric(10)  
13 ad_language character varying  
14 line numeric(10)  
15 m_product_id numeric(10)  
16 m_attributesetinstance_id numeric(10)  
17 name text  
18 description character varying  
19 documentnote character varying(2000)  
20 upc character varying(30)  
21 sku character varying(30)  
22 productvalue character varying(40)  
23 help character varying(2000)  
24 dateworkstart timestamp without time zone  
25 deliverydays numeric(10)  
26 c_uom_id numeric(10)  
27 uomsymbol character varying(10)  
28 benchmarkprice numeric  
29 qty numeric  
30 price numeric  
31 discount numeric  


ソース
ソース 
 SELECT rrl.c_rfqresponse_id,
    rrl.c_rfqresponseline_id,
    rrl.c_rfqline_id,
    rq.c_rfqresponselineqty_id,
    rq.c_rfqlineqty_id,
    rrl.ad_client_id,
    rrl.ad_org_id,
    rrl.isactive,
    rrl.created,
    rrl.createdby,
    rrl.updated,
    rrl.updatedby,
    'en_US'::character varying AS ad_language,
    rl.line,
    rl.m_product_id,
    rl.m_attributesetinstance_id,
    COALESCE(((p.name)::text || (productattribute(rl.m_attributesetinstance_id))::text), (rl.description)::text) AS name,
        CASE
            WHEN (p.name IS NOT NULL) THEN rl.description
            ELSE NULL::character varying
        END AS description,
    p.documentnote,
    p.upc,
    p.sku,
    p.value AS productvalue,
    rl.help,
    rl.dateworkstart,
    rl.deliverydays,
    q.c_uom_id,
    uom.uomsymbol,
    q.benchmarkprice,
    q.qty,
    rq.price,
    rq.discount
   FROM (((((c_rfqresponselineqty rq
     JOIN c_rfqlineqty q ON ((rq.c_rfqlineqty_id = q.c_rfqlineqty_id)))
     JOIN c_uom uom ON ((q.c_uom_id = uom.c_uom_id)))
     JOIN c_rfqresponseline rrl ON ((rq.c_rfqresponseline_id = rrl.c_rfqresponseline_id)))
     JOIN c_rfqline rl ON ((rrl.c_rfqline_id = rl.c_rfqline_id)))
     LEFT JOIN m_product p ON ((rl.m_product_id = p.m_product_id)))
  WHERE ((((rq.isactive = 'Y'::bpchar) AND (q.isactive = 'Y'::bpchar)) AND (rrl.isactive = 'Y'::bpchar)) AND (rl.isactive = 'Y'::bpchar));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname c_rfqresponseline_v
3 viewowner adempiere
4 definition SELECT rrl.c_rfqresponse_id,
rrl.c_rfqresponseline_id,
rrl.c_rfqline_id,
rq.c_rfqresponselineqty_id,
rq.c_rfqlineqty_id,
rrl.ad_client_id,
rrl.ad_org_id,
rrl.isactive,
rrl.created,
rrl.createdby,
rrl.updated,
rrl.updatedby,
'en_US'::character varying AS ad_language,
rl.line,
rl.m_product_id,
rl.m_attributesetinstance_id,
COALESCE(((p.name)::text || (productattribute(rl.m_attributesetinstance_id))::text), (rl.description)::text) AS name,
CASE
WHEN (p.name IS NOT NULL) THEN rl.description
ELSE NULL::character varying
END AS description,
p.documentnote,
p.upc,
p.sku,
p.value AS productvalue,
rl.help,
rl.dateworkstart,
rl.deliverydays,
q.c_uom_id,
uom.uomsymbol,
q.benchmarkprice,
q.qty,
rq.price,
rq.discount
FROM (((((c_rfqresponselineqty rq
JOIN c_rfqlineqty q ON ((rq.c_rfqlineqty_id = q.c_rfqlineqty_id)))
JOIN c_uom uom ON ((q.c_uom_id = uom.c_uom_id)))
JOIN c_rfqresponseline rrl ON ((rq.c_rfqresponseline_id = rrl.c_rfqresponseline_id)))
JOIN c_rfqline rl ON ((rrl.c_rfqline_id = rl.c_rfqline_id)))
LEFT JOIN m_product p ON ((rl.m_product_id = p.m_product_id)))
WHERE ((((rq.isactive = 'Y'::bpchar) AND (q.isactive = 'Y'::bpchar)) AND (rrl.isactive = 'Y'::bpchar)) AND (rl.isactive = 'Y'::bpchar));