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


カラム情報
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 c_bpartner_id numeric(10)  
9 value character varying(40)  
10 name character varying(120)  
11 name2 character varying(60)  
12 description character varying(255)  
13 issummary character(1)  
14 c_bp_group_id numeric(10)  
15 isonetime character(1)  
16 isprospect character(1)  
17 isvendor character(1)  
18 iscustomer character(1)  
19 isemployee character(1)  
20 issalesrep character(1)  
21 referenceno character varying(40)  
22 duns character(11)  
23 url character varying(120)  
24 ad_language character varying(6)  
25 taxid character varying(20)  
26 istaxexempt character(1)  
27 c_invoiceschedule_id numeric(10)  
28 rating character(1)  
29 salesvolume numeric(10)  
30 numberemployees numeric(10)  
31 naics character(6)  
32 firstsale timestamp without time zone  
33 acqusitioncost numeric  
34 potentiallifetimevalue numeric  
35 actuallifetimevalue numeric  
36 shareofcustomer numeric(10)  
37 paymentrule character(1)  
38 so_creditlimit numeric  
39 so_creditused numeric  
40 so_creditavailable numeric  
41 c_paymentterm_id numeric(10)  
42 m_pricelist_id numeric(10)  
43 m_discountschema_id numeric(10)  
44 c_dunning_id numeric(10)  
45 isdiscountprinted character(1)  
46 so_description character varying(255)  
47 poreference character varying(20)  
48 paymentrulepo character(1)  
49 po_pricelist_id numeric(10)  
50 po_discountschema_id numeric(10)  
51 po_paymentterm_id numeric(10)  
52 documentcopies numeric(10)  
53 c_greeting_id numeric(10)  
54 invoicerule character(1)  
55 deliveryrule character(1)  
56 freightcostrule character(1)  
57 deliveryviarule character(1)  
58 salesrep_id numeric(10)  
59 sendemail character(1)  
60 bpartner_parent_id numeric(10)  
61 invoice_printformat_id numeric(10)  
62 socreditstatus character(1)  
63 shelflifeminpct numeric(10)  
64 ad_orgbp_id numeric(10)  
65 flatdiscount numeric  
66 totalopenbalance numeric  
67 ad_user_id numeric(10)  
68 contactname character varying(60)  
69 contactdescription character varying(255)  
70 email character varying(60)  
71 supervisor_id numeric(10)  
72 emailuser character varying(60)  
73 bpcontactgreeting numeric(10)  
74 title character varying(40)  
75 comments character varying(2000)  
76 phone character varying(40)  
77 phone2 character varying(40)  
78 fax character varying(40)  
79 lastcontact timestamp without time zone  
80 lastresult character varying(255)  
81 birthday timestamp without time zone  
82 ad_orgtrx_id numeric(10)  
83 emailverify character varying(40)  
84 ldapuser character varying(60)  
85 emailverifydate timestamp without time zone  
86 notificationtype character(1)  
87 c_bpartner_location_id numeric(10)  
88 postal character varying(10)  
89 city character varying(60)  
90 address1 character varying(60)  
91 address2 character varying(60)  
92 address3 character varying(60)  
93 c_region_id numeric(10)  
94 regionname character varying  
95 c_country_id numeric(10)  
96 countryname character varying(60)  
97 c_bp_c_taxgroup_id numeric(10)  
98 c_bp_dunninggrace date  
99 c_bp_ismanufacturer character(1)  
100 c_bp_ispotaxexempt character(1)  
101 c_bp_logo_id numeric(10)  
102 c_bp_location_ad_org_id numeric(10)  
103 c_bp_location_c_bpartner_id numeric(10)  
104 c_bp_location_c_location_id numeric(10)  
105 c_bp_location_created timestamp without time zone  
106 c_bp_location_createdby numeric(10)  
107 c_bp_location_salesregion_id numeric(10)  
108 c_bp_location_fax character varying(40)  
109 c_bp_location_isactive character(1)  
110 c_bp_location_isbillto character(1)  
111 c_bp_location_isdn character varying(40)  
112 c_bp_location_ispayfrom character(1)  
113 c_bp_location_isremitto character(1)  
114 c_bp_location_isshipto character(1)  
115 c_bp_location_name character varying(60)  
116 c_bp_location_phone character varying(40)  
117 c_bp_location_phone2 character varying(40)  
118 c_bp_location_updated timestamp without time zone  
119 c_bp_location_updatedby numeric(10)  
120 ad_user_ad_org_id numeric(10)  
121 ad_user_c_bpartner_id numeric(10)  
122 ad_user_c_bpartner_location_id numeric(10)  
123 ad_user_created timestamp without time zone  
124 ad_user_createdby numeric(10)  
125 ad_user_isactive character(1)  
126 ad_user_updated timestamp without time zone  
127 ad_user_updatedby numeric(10)  
128 ad_user_value character varying(40)  
129 address4 character varying(60)  
130 c_location_ad_org_id numeric(10)  
131 c_city_id numeric(10)  
132 c_location_id numeric(10)  
133 c_location_created timestamp without time zone  
134 c_location_createdby numeric(10)  
135 c_location_isactive character(1)  
136 postal_add character varying(10)  
137 c_location_updated timestamp without time zone  
138 c_location_updatedby numeric(10)  
139 c_region_ad_org_id numeric(10)  
140 c_region_c_country_id numeric(10)  
141 c_region_description character varying(255)  
142 c_region_isactive character(1)  
143 isdefault character(1)  
144 c_country_ad_language character varying(6)  
145 c_country_c_currency_id numeric(10)  
146 countrycode character(2)  
147 c_country_description character varying(255)  
148 c_country_isactive character(1)  


ソース
ソース 
 SELECT bp.ad_client_id,
    bp.ad_org_id,
    bp.isactive,
    bp.created,
    bp.createdby,
    bp.updated,
    bp.updatedby,
    bp.c_bpartner_id,
    bp.value,
    bp.name,
    bp.name2,
    bp.description,
    bp.issummary,
    bp.c_bp_group_id,
    bp.isonetime,
    bp.isprospect,
    bp.isvendor,
    bp.iscustomer,
    bp.isemployee,
    bp.issalesrep,
    bp.referenceno,
    bp.duns,
    bp.url,
    bp.ad_language,
    bp.taxid,
    bp.istaxexempt,
    bp.c_invoiceschedule_id,
    bp.rating,
    bp.salesvolume,
    bp.numberemployees,
    bp.naics,
    bp.firstsale,
    bp.acqusitioncost,
    bp.potentiallifetimevalue,
    bp.actuallifetimevalue,
    bp.shareofcustomer,
    bp.paymentrule,
    bp.so_creditlimit,
    bp.so_creditused,
    (bp.so_creditused - bp.so_creditlimit) AS so_creditavailable,
    bp.c_paymentterm_id,
    bp.m_pricelist_id,
    bp.m_discountschema_id,
    bp.c_dunning_id,
    bp.isdiscountprinted,
    bp.so_description,
    bp.poreference,
    bp.paymentrulepo,
    bp.po_pricelist_id,
    bp.po_discountschema_id,
    bp.po_paymentterm_id,
    bp.documentcopies,
    bp.c_greeting_id,
    bp.invoicerule,
    bp.deliveryrule,
    bp.freightcostrule,
    bp.deliveryviarule,
    bp.salesrep_id,
    bp.sendemail,
    bp.bpartner_parent_id,
    bp.invoice_printformat_id,
    bp.socreditstatus,
    bp.shelflifeminpct,
    bp.ad_orgbp_id,
    bp.flatdiscount,
    bp.totalopenbalance,
    c.ad_user_id,
    c.name AS contactname,
    c.description AS contactdescription,
    c.email,
    c.supervisor_id,
    c.emailuser,
    c.c_greeting_id AS bpcontactgreeting,
    c.title,
    c.comments,
    c.phone,
    c.phone2,
    c.fax,
    c.lastcontact,
    c.lastresult,
    c.birthday,
    c.ad_orgtrx_id,
    c.emailverify,
    c.ldapuser,
    c.emailverifydate,
    c.notificationtype,
    l.c_bpartner_location_id,
    a.postal,
    a.city,
    a.address1,
    a.address2,
    a.address3,
    a.c_region_id,
    COALESCE(r.name, a.regionname) AS regionname,
    a.c_country_id,
    cc.name AS countryname,
    bp.c_taxgroup_id AS c_bp_c_taxgroup_id,
    bp.dunninggrace AS c_bp_dunninggrace,
    bp.ismanufacturer AS c_bp_ismanufacturer,
    bp.ispotaxexempt AS c_bp_ispotaxexempt,
    bp.logo_id AS c_bp_logo_id,
    l.ad_org_id AS c_bp_location_ad_org_id,
    l.c_bpartner_id AS c_bp_location_c_bpartner_id,
    l.c_location_id AS c_bp_location_c_location_id,
    l.created AS c_bp_location_created,
    l.createdby AS c_bp_location_createdby,
    l.c_salesregion_id AS c_bp_location_salesregion_id,
    l.fax AS c_bp_location_fax,
    l.isactive AS c_bp_location_isactive,
    l.isbillto AS c_bp_location_isbillto,
    l.isdn AS c_bp_location_isdn,
    l.ispayfrom AS c_bp_location_ispayfrom,
    l.isremitto AS c_bp_location_isremitto,
    l.isshipto AS c_bp_location_isshipto,
    l.name AS c_bp_location_name,
    l.phone AS c_bp_location_phone,
    l.phone2 AS c_bp_location_phone2,
    l.updated AS c_bp_location_updated,
    l.updatedby AS c_bp_location_updatedby,
    c.ad_org_id AS ad_user_ad_org_id,
    c.c_bpartner_id AS ad_user_c_bpartner_id,
    c.c_bpartner_location_id AS ad_user_c_bpartner_location_id,
    c.created AS ad_user_created,
    c.createdby AS ad_user_createdby,
    c.isactive AS ad_user_isactive,
    c.updated AS ad_user_updated,
    c.updatedby AS ad_user_updatedby,
    c.value AS ad_user_value,
    a.address4,
    a.ad_org_id AS c_location_ad_org_id,
    a.c_city_id,
    a.c_location_id,
    a.created AS c_location_created,
    a.createdby AS c_location_createdby,
    a.isactive AS c_location_isactive,
    a.postal_add,
    a.updated AS c_location_updated,
    a.updatedby AS c_location_updatedby,
    r.ad_org_id AS c_region_ad_org_id,
    r.c_country_id AS c_region_c_country_id,
    r.description AS c_region_description,
    r.isactive AS c_region_isactive,
    r.isdefault,
    cc.ad_language AS c_country_ad_language,
    cc.c_currency_id AS c_country_c_currency_id,
    cc.countrycode,
    cc.description AS c_country_description,
    cc.isactive AS c_country_isactive
   FROM (((((c_bpartner bp
     LEFT JOIN c_bpartner_location l ON (((bp.c_bpartner_id = l.c_bpartner_id) AND (l.isactive = 'Y'::bpchar))))
     LEFT JOIN ad_user c ON ((((bp.c_bpartner_id = c.c_bpartner_id) AND ((c.c_bpartner_location_id IS NULL) OR (c.c_bpartner_location_id = l.c_bpartner_location_id))) AND (c.isactive = 'Y'::bpchar))))
     LEFT JOIN c_location a ON ((l.c_location_id = a.c_location_id)))
     LEFT JOIN c_region r ON ((a.c_region_id = r.c_region_id)))
     JOIN c_country cc ON ((a.c_country_id = cc.c_country_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_bpartner
3 viewowner adempiere
4 definition SELECT bp.ad_client_id,
bp.ad_org_id,
bp.isactive,
bp.created,
bp.createdby,
bp.updated,
bp.updatedby,
bp.c_bpartner_id,
bp.value,
bp.name,
bp.name2,
bp.description,
bp.issummary,
bp.c_bp_group_id,
bp.isonetime,
bp.isprospect,
bp.isvendor,
bp.iscustomer,
bp.isemployee,
bp.issalesrep,
bp.referenceno,
bp.duns,
bp.url,
bp.ad_language,
bp.taxid,
bp.istaxexempt,
bp.c_invoiceschedule_id,
bp.rating,
bp.salesvolume,
bp.numberemployees,
bp.naics,
bp.firstsale,
bp.acqusitioncost,
bp.potentiallifetimevalue,
bp.actuallifetimevalue,
bp.shareofcustomer,
bp.paymentrule,
bp.so_creditlimit,
bp.so_creditused,
(bp.so_creditused - bp.so_creditlimit) AS so_creditavailable,
bp.c_paymentterm_id,
bp.m_pricelist_id,
bp.m_discountschema_id,
bp.c_dunning_id,
bp.isdiscountprinted,
bp.so_description,
bp.poreference,
bp.paymentrulepo,
bp.po_pricelist_id,
bp.po_discountschema_id,
bp.po_paymentterm_id,
bp.documentcopies,
bp.c_greeting_id,
bp.invoicerule,
bp.deliveryrule,
bp.freightcostrule,
bp.deliveryviarule,
bp.salesrep_id,
bp.sendemail,
bp.bpartner_parent_id,
bp.invoice_printformat_id,
bp.socreditstatus,
bp.shelflifeminpct,
bp.ad_orgbp_id,
bp.flatdiscount,
bp.totalopenbalance,
c.ad_user_id,
c.name AS contactname,
c.description AS contactdescription,
c.email,
c.supervisor_id,
c.emailuser,
c.c_greeting_id AS bpcontactgreeting,
c.title,
c.comments,
c.phone,
c.phone2,
c.fax,
c.lastcontact,
c.lastresult,
c.birthday,
c.ad_orgtrx_id,
c.emailverify,
c.ldapuser,
c.emailverifydate,
c.notificationtype,
l.c_bpartner_location_id,
a.postal,
a.city,
a.address1,
a.address2,
a.address3,
a.c_region_id,
COALESCE(r.name, a.regionname) AS regionname,
a.c_country_id,
cc.name AS countryname,
bp.c_taxgroup_id AS c_bp_c_taxgroup_id,
bp.dunninggrace AS c_bp_dunninggrace,
bp.ismanufacturer AS c_bp_ismanufacturer,
bp.ispotaxexempt AS c_bp_ispotaxexempt,
bp.logo_id AS c_bp_logo_id,
l.ad_org_id AS c_bp_location_ad_org_id,
l.c_bpartner_id AS c_bp_location_c_bpartner_id,
l.c_location_id AS c_bp_location_c_location_id,
l.created AS c_bp_location_created,
l.createdby AS c_bp_location_createdby,
l.c_salesregion_id AS c_bp_location_salesregion_id,
l.fax AS c_bp_location_fax,
l.isactive AS c_bp_location_isactive,
l.isbillto AS c_bp_location_isbillto,
l.isdn AS c_bp_location_isdn,
l.ispayfrom AS c_bp_location_ispayfrom,
l.isremitto AS c_bp_location_isremitto,
l.isshipto AS c_bp_location_isshipto,
l.name AS c_bp_location_name,
l.phone AS c_bp_location_phone,
l.phone2 AS c_bp_location_phone2,
l.updated AS c_bp_location_updated,
l.updatedby AS c_bp_location_updatedby,
c.ad_org_id AS ad_user_ad_org_id,
c.c_bpartner_id AS ad_user_c_bpartner_id,
c.c_bpartner_location_id AS ad_user_c_bpartner_location_id,
c.created AS ad_user_created,
c.createdby AS ad_user_createdby,
c.isactive AS ad_user_isactive,
c.updated AS ad_user_updated,
c.updatedby AS ad_user_updatedby,
c.value AS ad_user_value,
a.address4,
a.ad_org_id AS c_location_ad_org_id,
a.c_city_id,
a.c_location_id,
a.created AS c_location_created,
a.createdby AS c_location_createdby,
a.isactive AS c_location_isactive,
a.postal_add,
a.updated AS c_location_updated,
a.updatedby AS c_location_updatedby,
r.ad_org_id AS c_region_ad_org_id,
r.c_country_id AS c_region_c_country_id,
r.description AS c_region_description,
r.isactive AS c_region_isactive,
r.isdefault,
cc.ad_language AS c_country_ad_language,
cc.c_currency_id AS c_country_c_currency_id,
cc.countrycode,
cc.description AS c_country_description,
cc.isactive AS c_country_isactive
FROM (((((c_bpartner bp
LEFT JOIN c_bpartner_location l ON (((bp.c_bpartner_id = l.c_bpartner_id) AND (l.isactive = 'Y'::bpchar))))
LEFT JOIN ad_user c ON ((((bp.c_bpartner_id = c.c_bpartner_id) AND ((c.c_bpartner_location_id IS NULL) OR (c.c_bpartner_location_id = l.c_bpartner_location_id))) AND (c.isactive = 'Y'::bpchar))))
LEFT JOIN c_location a ON ((l.c_location_id = a.c_location_id)))
LEFT JOIN c_region r ON ((a.c_region_id = r.c_region_id)))
JOIN c_country cc ON ((a.c_country_id = cc.c_country_id)));