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


カラム情報
No 論理名 物理名 データ型 Not Null デフォルト 備考
1 c_invoice_id numeric(10)  
2 ad_client_id numeric(10)  
3 ad_org_id numeric(10)  
4 isactive character(1)  
5 created timestamp without time zone  
6 createdby numeric(10)  
7 updated timestamp without time zone  
8 updatedby numeric(10)  
9 issotrx character(1)  
10 documentno character varying(30)  
11 docstatus character(2)  
12 docaction character(2)  
13 isprinted character(1)  
14 isdiscountprinted character(1)  
15 processing character(1)  
16 processed character(1)  
17 istransferred character(1)  
18 ispaid character(1)  
19 c_doctype_id numeric(10)  
20 c_doctypetarget_id numeric(10)  
21 c_order_id numeric(10)  
22 description character varying(255)  
23 isapproved character(1)  
24 salesrep_id numeric(10)  
25 dateinvoiced timestamp without time zone  
26 dateprinted timestamp without time zone  
27 dateacct timestamp without time zone  
28 c_bpartner_id numeric(10)  
29 c_bpartner_location_id numeric(10)  
30 ad_user_id numeric(10)  
31 c_bp_group_id numeric(10)  
32 poreference character varying(20)  
33 dateordered timestamp without time zone  
34 c_currency_id numeric(10)  
35 c_conversiontype_id numeric(10)  
36 paymentrule character(1)  
37 c_paymentterm_id numeric(10)  
38 m_pricelist_id numeric(10)  
39 c_campaign_id numeric(10)  
40 c_project_id numeric(10)  
41 c_activity_id numeric(10)  
42 ispayschedulevalid character(1)  
43 invoicecollectiontype character(1)  
44 c_country_id numeric(10)  
45 c_region_id numeric(10)  
46 postal character varying(10)  
47 city character varying(60)  
48 c_charge_id numeric(10)  
49 chargeamt numeric  
50 totallines numeric  
51 grandtotal numeric  
52 multiplier integer  
53 c_invoice_ad_orgtrx_id numeric(10)  
54 c_invoice_c_conversiontype_id numeric(10)  
55 c_dunninglevel_id numeric(10)  
56 c_payment_id numeric(10)  
57 c_invoice_dateordered timestamp without time zone  
58 dunninggrace date  
59 generateto character(1)  
60 isindispute character(1)  
61 c_invoice_ispayschedulevalid character(1)  
62 c_invoice_isselfservice character(1)  
63 istaxincluded character(1)  
64 m_rma_id numeric(10)  
65 posted character(1)  
66 processedon numeric  
67 ref_invoice_id numeric(10)  
68 reversal_id numeric(10)  
69 sendemail character(1)  
70 user1_id numeric(10)  
71 user2_id numeric(10)  
72 c_bp_acqusitioncost numeric  
73 c_bp_actuallifetimevalue numeric  
74 c_bp_ad_language character varying(6)  
75 c_bp_ad_orgbp_id numeric(10)  
76 c_bp_ad_org_id numeric(10)  
77 c_bp_bpartner_parent_id numeric(10)  
78 c_bp_c_dunning_id numeric(10)  
79 c_bp_c_greeting_id numeric(10)  
80 c_bp_c_invoiceschedule_id numeric(10)  
81 c_bp_c_paymentterm_id numeric(10)  
82 c_bp_created timestamp without time zone  
83 c_bp_createdby numeric(10)  
84 c_bp_c_taxgroup_id numeric(10)  
85 c_bp_deliveryrule character(1)  
86 c_bp_deliveryviarule character(1)  
87 c_bp_description character varying(255)  
88 c_bp_dunninggrace date  
89 c_bp_duns character(11)  
90 c_bp_firstsale timestamp without time zone  
91 c_bp_flatdiscount numeric  
92 c_bp_freightcostrule character(1)  
93 c_bp_invoicerule character(1)  
94 c_bp_isactive character(1)  
95 c_bp_iscustomer character(1)  
96 c_bp_isdiscountprinted character(1)  
97 c_bp_isemployee character(1)  
98 c_bp_ismanufacturer character(1)  
99 c_bp_isonetime character(1)  
100 c_bp_ispotaxexempt character(1)  
101 c_bp_isprospect character(1)  
102 c_bp_issalesrep character(1)  
103 c_bp_issummary character(1)  
104 c_bp_istaxexempt character(1)  
105 c_bp_isvendor character(1)  
106 c_bp_logo_id numeric(10)  
107 c_bp_m_discountschema_id numeric(10)  
108 c_bp_m_pricelist_id numeric(10)  
109 c_bp_naics character(6)  
110 c_bp_name character varying(120)  
111 c_bp_name2 character varying(60)  
112 c_bp_numberemployees numeric(10)  
113 c_bp_paymentrule character(1)  
114 c_bp_paymentrulepo character(1)  
115 c_bp_po_discountschema_id numeric(10)  
116 c_bp_po_paymentterm_id numeric(10)  
117 c_bp_po_pricelist_id numeric(10)  
118 c_bp_poreference character varying(20)  
119 c_bp_potentiallifetimevalue numeric  
120 c_bp_rating character(1)  
121 c_bp_referenceno character varying(40)  
122 c_bp_salesrep_id numeric(10)  
123 c_bp_salesvolume numeric(10)  
124 c_bp_sendemail character(1)  
125 c_bp_shareofcustomer numeric(10)  
126 c_bp_shelflifeminpct numeric(10)  
127 c_bp_so_creditlimit numeric  
128 c_bp_socreditstatus character(1)  
129 c_bp_so_creditused numeric  
130 c_bp_so_description character varying(255)  
131 taxid character varying(20)  
132 c_bp_totalopenbalance numeric  
133 c_bp_updated timestamp without time zone  
134 c_bp_updatedby numeric(10)  
135 c_bp_url character varying(120)  
136 c_bp_value character varying(40)  
137 c_bp_location_ad_org_id numeric(10)  
138 c_bp_location_c_bpartner_id numeric(10)  
139 c_bp_location_c_location_id numeric(10)  
140 c_bp_location_created timestamp without time zone  
141 c_bp_location_createdby numeric(10)  
142 c_salesregion_id numeric(10)  
143 c_bp_location_fax character varying(40)  
144 c_bp_location_isactive character(1)  
145 isbillto character(1)  
146 isdn character varying(40)  
147 ispayfrom character(1)  
148 isremitto character(1)  
149 isshipto character(1)  
150 c_bp_location_name character varying(60)  
151 c_bp_location_phone character varying(40)  
152 c_bp_location_phone2 character varying(40)  
153 c_bp_location_updated timestamp without time zone  
154 c_bp_location_updatedby numeric(10)  
155 address1 character varying(60)  
156 address2 character varying(60)  
157 address3 character varying(60)  
158 address4 character varying(60)  
159 c_location_ad_org_id numeric(10)  
160 c_city_id numeric(10)  
161 c_location_created timestamp without time zone  
162 c_location_createdby numeric(10)  
163 c_location_isactive character(1)  
164 postal_add character varying(10)  
165 regionname character varying(40)  
166 c_location_updated timestamp without time zone  
167 c_location_updatedby numeric(10)  


ソース
ソース 
 SELECT i.c_invoice_id,
    i.ad_client_id,
    i.ad_org_id,
    i.isactive,
    i.created,
    i.createdby,
    i.updated,
    i.updatedby,
    i.issotrx,
    i.documentno,
    i.docstatus,
    i.docaction,
    i.isprinted,
    i.isdiscountprinted,
    i.processing,
    i.processed,
    i.istransferred,
    i.ispaid,
    i.c_doctype_id,
    i.c_doctypetarget_id,
    i.c_order_id,
    i.description,
    i.isapproved,
    i.salesrep_id,
    i.dateinvoiced,
    i.dateprinted,
    i.dateacct,
    i.c_bpartner_id,
    i.c_bpartner_location_id,
    i.ad_user_id,
    b.c_bp_group_id,
    i.poreference,
    i.dateordered,
    i.c_currency_id,
    i.c_conversiontype_id,
    i.paymentrule,
    i.c_paymentterm_id,
    i.m_pricelist_id,
    i.c_campaign_id,
    i.c_project_id,
    i.c_activity_id,
    i.ispayschedulevalid,
    i.invoicecollectiontype,
    loc.c_country_id,
    loc.c_region_id,
    loc.postal,
    loc.city,
    i.c_charge_id,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.chargeamt * ((-1))::numeric)
            ELSE i.chargeamt
        END AS chargeamt,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.totallines * ((-1))::numeric)
            ELSE i.totallines
        END AS totallines,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.grandtotal * ((-1))::numeric)
            ELSE i.grandtotal
        END AS grandtotal,
        CASE
            WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (-1)
            ELSE 1
        END AS multiplier,
    i.ad_orgtrx_id AS c_invoice_ad_orgtrx_id,
    i.c_conversiontype_id AS c_invoice_c_conversiontype_id,
    i.c_dunninglevel_id,
    i.c_payment_id,
    i.dateordered AS c_invoice_dateordered,
    i.dunninggrace,
    i.generateto,
    i.isindispute,
    i.ispayschedulevalid AS c_invoice_ispayschedulevalid,
    i.isselfservice AS c_invoice_isselfservice,
    i.istaxincluded,
    i.m_rma_id,
    i.posted,
    i.processedon,
    i.ref_invoice_id,
    i.reversal_id,
    i.sendemail,
    i.user1_id,
    i.user2_id,
    b.acqusitioncost AS c_bp_acqusitioncost,
    b.actuallifetimevalue AS c_bp_actuallifetimevalue,
    b.ad_language AS c_bp_ad_language,
    b.ad_orgbp_id AS c_bp_ad_orgbp_id,
    b.ad_org_id AS c_bp_ad_org_id,
    b.bpartner_parent_id AS c_bp_bpartner_parent_id,
    b.c_dunning_id AS c_bp_c_dunning_id,
    b.c_greeting_id AS c_bp_c_greeting_id,
    b.c_invoiceschedule_id AS c_bp_c_invoiceschedule_id,
    b.c_paymentterm_id AS c_bp_c_paymentterm_id,
    b.created AS c_bp_created,
    b.createdby AS c_bp_createdby,
    b.c_taxgroup_id AS c_bp_c_taxgroup_id,
    b.deliveryrule AS c_bp_deliveryrule,
    b.deliveryviarule AS c_bp_deliveryviarule,
    b.description AS c_bp_description,
    b.dunninggrace AS c_bp_dunninggrace,
    b.duns AS c_bp_duns,
    b.firstsale AS c_bp_firstsale,
    b.flatdiscount AS c_bp_flatdiscount,
    b.freightcostrule AS c_bp_freightcostrule,
    b.invoicerule AS c_bp_invoicerule,
    b.isactive AS c_bp_isactive,
    b.iscustomer AS c_bp_iscustomer,
    b.isdiscountprinted AS c_bp_isdiscountprinted,
    b.isemployee AS c_bp_isemployee,
    b.ismanufacturer AS c_bp_ismanufacturer,
    b.isonetime AS c_bp_isonetime,
    b.ispotaxexempt AS c_bp_ispotaxexempt,
    b.isprospect AS c_bp_isprospect,
    b.issalesrep AS c_bp_issalesrep,
    b.issummary AS c_bp_issummary,
    b.istaxexempt AS c_bp_istaxexempt,
    b.isvendor AS c_bp_isvendor,
    b.logo_id AS c_bp_logo_id,
    b.m_discountschema_id AS c_bp_m_discountschema_id,
    b.m_pricelist_id AS c_bp_m_pricelist_id,
    b.naics AS c_bp_naics,
    b.name AS c_bp_name,
    b.name2 AS c_bp_name2,
    b.numberemployees AS c_bp_numberemployees,
    b.paymentrule AS c_bp_paymentrule,
    b.paymentrulepo AS c_bp_paymentrulepo,
    b.po_discountschema_id AS c_bp_po_discountschema_id,
    b.po_paymentterm_id AS c_bp_po_paymentterm_id,
    b.po_pricelist_id AS c_bp_po_pricelist_id,
    b.poreference AS c_bp_poreference,
    b.potentiallifetimevalue AS c_bp_potentiallifetimevalue,
    b.rating AS c_bp_rating,
    b.referenceno AS c_bp_referenceno,
    b.salesrep_id AS c_bp_salesrep_id,
    b.salesvolume AS c_bp_salesvolume,
    b.sendemail AS c_bp_sendemail,
    b.shareofcustomer AS c_bp_shareofcustomer,
    b.shelflifeminpct AS c_bp_shelflifeminpct,
    b.so_creditlimit AS c_bp_so_creditlimit,
    b.socreditstatus AS c_bp_socreditstatus,
    b.so_creditused AS c_bp_so_creditused,
    b.so_description AS c_bp_so_description,
    b.taxid,
    b.totalopenbalance AS c_bp_totalopenbalance,
    b.updated AS c_bp_updated,
    b.updatedby AS c_bp_updatedby,
    b.url AS c_bp_url,
    b.value AS c_bp_value,
    bpl.ad_org_id AS c_bp_location_ad_org_id,
    bpl.c_bpartner_id AS c_bp_location_c_bpartner_id,
    bpl.c_location_id AS c_bp_location_c_location_id,
    bpl.created AS c_bp_location_created,
    bpl.createdby AS c_bp_location_createdby,
    bpl.c_salesregion_id,
    bpl.fax AS c_bp_location_fax,
    bpl.isactive AS c_bp_location_isactive,
    bpl.isbillto,
    bpl.isdn,
    bpl.ispayfrom,
    bpl.isremitto,
    bpl.isshipto,
    bpl.name AS c_bp_location_name,
    bpl.phone AS c_bp_location_phone,
    bpl.phone2 AS c_bp_location_phone2,
    bpl.updated AS c_bp_location_updated,
    bpl.updatedby AS c_bp_location_updatedby,
    loc.address1,
    loc.address2,
    loc.address3,
    loc.address4,
    loc.ad_org_id AS c_location_ad_org_id,
    loc.c_city_id,
    loc.created AS c_location_created,
    loc.createdby AS c_location_createdby,
    loc.isactive AS c_location_isactive,
    loc.postal_add,
    loc.regionname,
    loc.updated AS c_location_updated,
    loc.updatedby AS c_location_updatedby
   FROM ((((c_invoice i
     JOIN c_doctype d ON ((i.c_doctype_id = d.c_doctype_id)))
     JOIN c_bpartner b ON ((i.c_bpartner_id = b.c_bpartner_id)))
     JOIN c_bpartner_location bpl ON ((i.c_bpartner_location_id = bpl.c_bpartner_location_id)))
     JOIN c_location loc ON ((bpl.c_location_id = loc.c_location_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_c_invoice
3 viewowner adempiere
4 definition SELECT i.c_invoice_id,
i.ad_client_id,
i.ad_org_id,
i.isactive,
i.created,
i.createdby,
i.updated,
i.updatedby,
i.issotrx,
i.documentno,
i.docstatus,
i.docaction,
i.isprinted,
i.isdiscountprinted,
i.processing,
i.processed,
i.istransferred,
i.ispaid,
i.c_doctype_id,
i.c_doctypetarget_id,
i.c_order_id,
i.description,
i.isapproved,
i.salesrep_id,
i.dateinvoiced,
i.dateprinted,
i.dateacct,
i.c_bpartner_id,
i.c_bpartner_location_id,
i.ad_user_id,
b.c_bp_group_id,
i.poreference,
i.dateordered,
i.c_currency_id,
i.c_conversiontype_id,
i.paymentrule,
i.c_paymentterm_id,
i.m_pricelist_id,
i.c_campaign_id,
i.c_project_id,
i.c_activity_id,
i.ispayschedulevalid,
i.invoicecollectiontype,
loc.c_country_id,
loc.c_region_id,
loc.postal,
loc.city,
i.c_charge_id,
CASE
WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.chargeamt * ((-1))::numeric)
ELSE i.chargeamt
END AS chargeamt,
CASE
WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.totallines * ((-1))::numeric)
ELSE i.totallines
END AS totallines,
CASE
WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (i.grandtotal * ((-1))::numeric)
ELSE i.grandtotal
END AS grandtotal,
CASE
WHEN ((charat((d.docbasetype)::character varying, 3))::text = 'C'::text) THEN (-1)
ELSE 1
END AS multiplier,
i.ad_orgtrx_id AS c_invoice_ad_orgtrx_id,
i.c_conversiontype_id AS c_invoice_c_conversiontype_id,
i.c_dunninglevel_id,
i.c_payment_id,
i.dateordered AS c_invoice_dateordered,
i.dunninggrace,
i.generateto,
i.isindispute,
i.ispayschedulevalid AS c_invoice_ispayschedulevalid,
i.isselfservice AS c_invoice_isselfservice,
i.istaxincluded,
i.m_rma_id,
i.posted,
i.processedon,
i.ref_invoice_id,
i.reversal_id,
i.sendemail,
i.user1_id,
i.user2_id,
b.acqusitioncost AS c_bp_acqusitioncost,
b.actuallifetimevalue AS c_bp_actuallifetimevalue,
b.ad_language AS c_bp_ad_language,
b.ad_orgbp_id AS c_bp_ad_orgbp_id,
b.ad_org_id AS c_bp_ad_org_id,
b.bpartner_parent_id AS c_bp_bpartner_parent_id,
b.c_dunning_id AS c_bp_c_dunning_id,
b.c_greeting_id AS c_bp_c_greeting_id,
b.c_invoiceschedule_id AS c_bp_c_invoiceschedule_id,
b.c_paymentterm_id AS c_bp_c_paymentterm_id,
b.created AS c_bp_created,
b.createdby AS c_bp_createdby,
b.c_taxgroup_id AS c_bp_c_taxgroup_id,
b.deliveryrule AS c_bp_deliveryrule,
b.deliveryviarule AS c_bp_deliveryviarule,
b.description AS c_bp_description,
b.dunninggrace AS c_bp_dunninggrace,
b.duns AS c_bp_duns,
b.firstsale AS c_bp_firstsale,
b.flatdiscount AS c_bp_flatdiscount,
b.freightcostrule AS c_bp_freightcostrule,
b.invoicerule AS c_bp_invoicerule,
b.isactive AS c_bp_isactive,
b.iscustomer AS c_bp_iscustomer,
b.isdiscountprinted AS c_bp_isdiscountprinted,
b.isemployee AS c_bp_isemployee,
b.ismanufacturer AS c_bp_ismanufacturer,
b.isonetime AS c_bp_isonetime,
b.ispotaxexempt AS c_bp_ispotaxexempt,
b.isprospect AS c_bp_isprospect,
b.issalesrep AS c_bp_issalesrep,
b.issummary AS c_bp_issummary,
b.istaxexempt AS c_bp_istaxexempt,
b.isvendor AS c_bp_isvendor,
b.logo_id AS c_bp_logo_id,
b.m_discountschema_id AS c_bp_m_discountschema_id,
b.m_pricelist_id AS c_bp_m_pricelist_id,
b.naics AS c_bp_naics,
b.name AS c_bp_name,
b.name2 AS c_bp_name2,
b.numberemployees AS c_bp_numberemployees,
b.paymentrule AS c_bp_paymentrule,
b.paymentrulepo AS c_bp_paymentrulepo,
b.po_discountschema_id AS c_bp_po_discountschema_id,
b.po_paymentterm_id AS c_bp_po_paymentterm_id,
b.po_pricelist_id AS c_bp_po_pricelist_id,
b.poreference AS c_bp_poreference,
b.potentiallifetimevalue AS c_bp_potentiallifetimevalue,
b.rating AS c_bp_rating,
b.referenceno AS c_bp_referenceno,
b.salesrep_id AS c_bp_salesrep_id,
b.salesvolume AS c_bp_salesvolume,
b.sendemail AS c_bp_sendemail,
b.shareofcustomer AS c_bp_shareofcustomer,
b.shelflifeminpct AS c_bp_shelflifeminpct,
b.so_creditlimit AS c_bp_so_creditlimit,
b.socreditstatus AS c_bp_socreditstatus,
b.so_creditused AS c_bp_so_creditused,
b.so_description AS c_bp_so_description,
b.taxid,
b.totalopenbalance AS c_bp_totalopenbalance,
b.updated AS c_bp_updated,
b.updatedby AS c_bp_updatedby,
b.url AS c_bp_url,
b.value AS c_bp_value,
bpl.ad_org_id AS c_bp_location_ad_org_id,
bpl.c_bpartner_id AS c_bp_location_c_bpartner_id,
bpl.c_location_id AS c_bp_location_c_location_id,
bpl.created AS c_bp_location_created,
bpl.createdby AS c_bp_location_createdby,
bpl.c_salesregion_id,
bpl.fax AS c_bp_location_fax,
bpl.isactive AS c_bp_location_isactive,
bpl.isbillto,
bpl.isdn,
bpl.ispayfrom,
bpl.isremitto,
bpl.isshipto,
bpl.name AS c_bp_location_name,
bpl.phone AS c_bp_location_phone,
bpl.phone2 AS c_bp_location_phone2,
bpl.updated AS c_bp_location_updated,
bpl.updatedby AS c_bp_location_updatedby,
loc.address1,
loc.address2,
loc.address3,
loc.address4,
loc.ad_org_id AS c_location_ad_org_id,
loc.c_city_id,
loc.created AS c_location_created,
loc.createdby AS c_location_createdby,
loc.isactive AS c_location_isactive,
loc.postal_add,
loc.regionname,
loc.updated AS c_location_updated,
loc.updatedby AS c_location_updatedby
FROM ((((c_invoice i
JOIN c_doctype d ON ((i.c_doctype_id = d.c_doctype_id)))
JOIN c_bpartner b ON ((i.c_bpartner_id = b.c_bpartner_id)))
JOIN c_bpartner_location bpl ON ((i.c_bpartner_location_id = bpl.c_bpartner_location_id)))
JOIN c_location loc ON ((bpl.c_location_id = loc.c_location_id)));