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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 ad_client_id numeric(10)  
2 ad_org_id numeric(10)  
3 c_invoiceline_id numeric(10)  
4 c_invoice_id numeric(10)  
5 salesrep_id numeric(10)  
6 c_bpartner_id numeric(10)  
7 m_product_id numeric(10)  
8 documentno character varying(30)  
9 dateinvoiced timestamp without time zone  
10 dateacct timestamp without time zone  
11 issotrx character(1)  
12 docstatus character(2)  
13 linenetamt numeric  
14 linelistamt numeric  
15 linelimitamt numeric  
16 linediscountamt numeric  
17 lineoverlimitamt numeric  
18 qtyinvoiced numeric  
19 qtyentered numeric  
20 line numeric(10)  
21 c_orderline_id numeric(10)  
22 c_uom_id numeric(10)  
23 c_campaign_id numeric(10)  
24 c_project_id numeric(10)  
25 c_activity_id numeric(10)  
26 c_projectphase_id numeric(10)  
27 c_projecttask_id numeric(10)  


ソース
ソース 
 SELECT il.ad_client_id,
    il.ad_org_id,
    il.c_invoiceline_id,
    i.c_invoice_id,
    i.salesrep_id,
    i.c_bpartner_id,
    il.m_product_id,
    i.documentno,
    i.dateinvoiced,
    i.dateacct,
    i.issotrx,
    i.docstatus,
    currencyround((i.multiplier * il.linenetamt), i.c_currency_id, 'N'::character varying) AS linenetamt,
    currencyround(((i.multiplier * il.pricelist) * il.qtyinvoiced), i.c_currency_id, 'N'::character varying) AS linelistamt,
        CASE
            WHEN (COALESCE(il.pricelimit, (0)::numeric) = (0)::numeric) THEN currencyround((i.multiplier * il.linenetamt), i.c_currency_id, 'N'::character varying)
            ELSE currencyround(((i.multiplier * il.pricelimit) * il.qtyinvoiced), i.c_currency_id, 'N'::character varying)
        END AS linelimitamt,
    currencyround((((i.multiplier * il.pricelist) * il.qtyinvoiced) - il.linenetamt), i.c_currency_id, 'N'::character varying) AS linediscountamt,
        CASE
            WHEN (COALESCE(il.pricelimit, (0)::numeric) = (0)::numeric) THEN (0)::numeric
            ELSE currencyround(((i.multiplier * il.linenetamt) - (il.pricelimit * il.qtyinvoiced)), i.c_currency_id, 'N'::character varying)
        END AS lineoverlimitamt,
    il.qtyinvoiced,
    il.qtyentered,
    il.line,
    il.c_orderline_id,
    il.c_uom_id,
    il.c_campaign_id,
    il.c_project_id,
    il.c_activity_id,
    il.c_projectphase_id,
    il.c_projecttask_id
   FROM c_invoice_v i,
    c_invoiceline il
  WHERE (i.c_invoice_id = il.c_invoice_id);


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname c_invoiceline_v
3 viewowner adempiere
4 definition SELECT il.ad_client_id,
il.ad_org_id,
il.c_invoiceline_id,
i.c_invoice_id,
i.salesrep_id,
i.c_bpartner_id,
il.m_product_id,
i.documentno,
i.dateinvoiced,
i.dateacct,
i.issotrx,
i.docstatus,
currencyround((i.multiplier * il.linenetamt), i.c_currency_id, 'N'::character varying) AS linenetamt,
currencyround(((i.multiplier * il.pricelist) * il.qtyinvoiced), i.c_currency_id, 'N'::character varying) AS linelistamt,
CASE
WHEN (COALESCE(il.pricelimit, (0)::numeric) = (0)::numeric) THEN currencyround((i.multiplier * il.linenetamt), i.c_currency_id, 'N'::character varying)
ELSE currencyround(((i.multiplier * il.pricelimit) * il.qtyinvoiced), i.c_currency_id, 'N'::character varying)
END AS linelimitamt,
currencyround((((i.multiplier * il.pricelist) * il.qtyinvoiced) - il.linenetamt), i.c_currency_id, 'N'::character varying) AS linediscountamt,
CASE
WHEN (COALESCE(il.pricelimit, (0)::numeric) = (0)::numeric) THEN (0)::numeric
ELSE currencyround(((i.multiplier * il.linenetamt) - (il.pricelimit * il.qtyinvoiced)), i.c_currency_id, 'N'::character varying)
END AS lineoverlimitamt,
il.qtyinvoiced,
il.qtyentered,
il.line,
il.c_orderline_id,
il.c_uom_id,
il.c_campaign_id,
il.c_project_id,
il.c_activity_id,
il.c_projectphase_id,
il.c_projecttask_id
FROM c_invoice_v i,
c_invoiceline il
WHERE (i.c_invoice_id = il.c_invoice_id);