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


カラム情報
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 ad_language character varying(6)  
9 c_project_id numeric(10)  
10 value character varying(40)  
11 projectname character varying(60)  
12 description character varying(255)  
13 note character varying(2000)  
14 issummary character(1)  
15 projectcategory character(1)  
16 org_location_id numeric(10)  
17 taxid character varying(20)  
18 c_projecttype_id numeric(10)  
19 projecttypename character varying(60)  
20 c_phase_id numeric(10)  
21 projectphasename character varying(60)  
22 salesrep_id numeric(10)  
23 salesrep_name character varying  
24 c_bpartner_id numeric(10)  
25 bpvalue character varying(40)  
26 bptaxid character varying(20)  
27 naics character(6)  
28 duns character(11)  
29 bpgreeting character varying(60)  
30 name character varying(120)  
31 name2 character varying(60)  
32 bpcontactgreeting character varying(60)  
33 title character varying(40)  
34 phone character varying(40)  
35 contactname text  
36 c_location_id numeric(10)  
37 referenceno character varying(40)  
38 paymentterm character varying(60)  
39 paymenttermnote character varying(2000)  
40 poreference character varying(20)  
41 c_currency_id numeric(10)  
42 m_pricelist_version_id numeric(10)  
43 c_campaign_id numeric(10)  
44 plannedamt numeric  
45 plannedqty numeric  
46 plannedmarginamt numeric  
47 invoicedamt numeric  
48 invoicedqty numeric  
49 projectbalanceamt numeric  
50 iscommitment character(1)  
51 committedamt numeric  
52 committedqty numeric  
53 datecontract timestamp without time zone  
54 datefinish timestamp without time zone  
55 iscommitceiling character(1)  
56 m_warehouse_id numeric(10)  
57 logo_id numeric(10)  
58 ad_user_id numeric(10)  
59 c_bpartner_location_id numeric(10)  
60 copyfrom character(1)  
61 c_project_c_paymentterm_id numeric(10)  
62 generateto character(1)  
63 c_project_processed character(1)  
64 c_project_processing character(1)  
65 projectlinelevel character(1)  
66 projinvoicerule character(1)  
67 c_bp_acqusitioncost numeric  
68 c_bp_actuallifetimevalue numeric  
69 c_bp_ad_language character varying(6)  
70 c_bp_ad_orgbp_id numeric(10)  
71 c_bp_ad_org_id numeric(10)  
72 c_bp_bpartner_parent_id numeric(10)  
73 c_bp_c_bp_group_id numeric(10)  
74 c_bp_c_dunning_id numeric(10)  
75 c_bp_c_greeting_id numeric(10)  
76 c_bp_c_invoiceschedule_id numeric(10)  
77 c_bp_c_paymentterm_id numeric(10)  
78 c_bp_created timestamp without time zone  
79 c_bp_createdby numeric(10)  
80 c_bp_c_taxgroup_id numeric(10)  
81 c_bp_deliveryrule character(1)  
82 c_bp_deliveryviarule character(1)  
83 c_bp_description character varying(255)  
84 c_bp_dunninggrace date  
85 c_bp_firstsale timestamp without time zone  
86 c_bp_flatdiscount numeric  
87 c_bp_freightcostrule character(1)  
88 c_bp_invoicerule character(1)  
89 c_bp_isactive character(1)  
90 c_bp_iscustomer character(1)  
91 c_bp_isdiscountprinted character(1)  
92 c_bp_isemployee character(1)  
93 c_bp_ismanufacturer character(1)  
94 c_bp_isonetime character(1)  
95 c_bp_ispotaxexempt character(1)  
96 c_bp_isprospect character(1)  
97 c_bp_issalesrep character(1)  
98 c_bp_issummary character(1)  
99 c_bp_istaxexempt character(1)  
100 c_bp_isvendor character(1)  
101 c_bp_logo_id numeric(10)  
102 c_bp_m_discountschema_id numeric(10)  
103 c_bp_m_pricelist_id numeric(10)  
104 c_bp_numberemployees numeric(10)  
105 c_bp_paymentrule character(1)  
106 c_bp_paymentrulepo character(1)  
107 c_bp_po_discountschema_id numeric(10)  
108 c_bp_po_paymentterm_id numeric(10)  
109 c_bp_po_pricelist_id numeric(10)  
110 c_bp_poreference character varying(20)  
111 c_bp_potentiallifetimevalue numeric  
112 c_bp_rating character(1)  
113 c_bp_salesrep_id numeric(10)  
114 c_bp_salesvolume numeric(10)  
115 c_bp_sendemail character(1)  
116 c_bp_shareofcustomer numeric(10)  
117 c_bp_shelflifeminpct numeric(10)  
118 c_bp_so_creditlimit numeric  
119 c_bp_socreditstatus character(1)  
120 c_bp_so_creditused numeric  
121 c_bp_so_description character varying(255)  
122 c_bp_totalopenbalance numeric  
123 c_bp_updated timestamp without time zone  
124 c_bp_updatedby numeric(10)  
125 c_bp_url character varying(120)  
126 ad_orginfo_ad_org_id numeric(10)  
127 ad_orgtype_id numeric(10)  
128 c_calendar_id numeric(10)  
129 ad_orginfo_created timestamp without time zone  
130 ad_orginfo_createdby numeric(10)  
131 dropship_warehouse_id numeric(10)  
132 ad_orginfo_duns character(11)  
133 ad_orginfo_email character varying(60)  
134 ad_orginfo_fax character varying(40)  
135 ad_orginfo_isactive character(1)  
136 ad_orginfo_m_warehouse_id numeric(10)  
137 parent_org_id numeric(10)  
138 ad_orginfo_phone character varying(40)  
139 ad_orginfo_phone2 character varying(40)  
140 receiptfootermsg character varying(1023)  
141 supervisor_id numeric(10)  
142 ad_orginfo_updated timestamp without time zone  
143 ad_orginfo_updatedby numeric(10)  
144 c_projecttype_ad_org_id numeric(10)  
145 c_projecttype_description character varying(255)  
146 c_projecttype_help character varying(2000)  
147 c_projecttype_isactive character(1)  
148 c_projecttype_projectcategory character(1)  
149 c_phase_ad_org_id numeric(10)  
150 c_phase_c_phase_id numeric(10)  
151 c_phase_c_projecttype_id numeric(10)  
152 c_phase_description character varying(255)  
153 c_phase_help character varying(2000)  
154 c_phase_isactive character(1)  
155 c_phase_m_product_id numeric(10)  
156 c_phase_seqno numeric(10)  
157 standardqty numeric  
158 salesrep_ad_org_id numeric(10)  
159 salesrep_ad_orgtrx_id numeric(10)  
160 salesrep_ad_birthday timestamp without time zone  
161 salesrep_c_bpartner_id numeric(10)  
162 salesrep_c_bp_location_id numeric(10)  
163 salesrep_c_greeting_id numeric(10)  
164 salesrep_comments character varying(2000)  
165 salesrep_created timestamp without time zone  
166 salesrep_createdby numeric(10)  
167 salesrep_description character varying(255)  
168 salesrep_email character varying(60)  
169 salesrep_fax character varying(40)  
170 salesrep_isactive character(1)  
171 salesrep_lastcontact timestamp without time zone  
172 salesrep_lastresult character varying(255)  
173 salesrep_phone character varying(40)  
174 salesrep_phone2 character varying(40)  
175 salesrep_supervisor_id numeric(10)  
176 salesrep_title character varying(40)  
177 salesrep_updated timestamp without time zone  
178 salesrep_updatedby numeric(10)  
179 salesrep_value character varying(40)  
180 salesrep_bp_acqusitioncost numeric  
181 salesrep_bp_actuallifevalue numeric  
182 salesrep_bp_ad_language character varying(6)  
183 salesrep_bp_ad_orgbp_id numeric(10)  
184 salesrep_bp_ad_org_id numeric(10)  
185 salesrep_bp_bpartner_parent_id numeric(10)  
186 salesrep_bp_c_bp_group_id numeric(10)  
187 salesrep_bp_c_dunning_id numeric(10)  
188 salesrep_bp_c_greeting_id numeric(10)  
189 salesrep_bp_c_invoicesched_id numeric(10)  
190 salesrep_bp_c_paymentterm_id numeric(10)  
191 salesrep_bp_created timestamp without time zone  
192 salesrep_bp_createdby numeric(10)  
193 salesrep_bp_c_taxgroup_id numeric(10)  
194 salesrep_bp_deliveryrule character(1)  
195 salesrep_bp_deliveryviarule character(1)  
196 salesrep_bp_description character varying(255)  
197 salesrep_bp_dunninggrace date  
198 salesrep_bp_duns character(11)  
199 salesrep_bp_firstsale timestamp without time zone  
200 salesrep_bp_flatdiscount numeric  
201 salesrep_bp_freightcostrule character(1)  
202 salesrep_bp_invoicerule character(1)  
203 salesrep_bp_isactive character(1)  
204 salesrep_bp_iscustomer character(1)  
205 salesrep_bp_isdiscountprinted character(1)  
206 salesrep_bp_isemployee character(1)  
207 salesrep_bp_ismanufacturer character(1)  
208 salesrep_bp_isonetime character(1)  
209 salesrep_bp_ispotaxexempt character(1)  
210 salesrep_bp_isprospect character(1)  
211 salesrep_bp_issalesrep character(1)  
212 salesrep_bp_issummary character(1)  
213 salesrep_bp_istaxexempt character(1)  
214 salesrep_bp_isvendor character(1)  
215 salesrep_bp_logo_id numeric(10)  
216 salesrep_bp_m_discountschm_id numeric(10)  
217 salesrep_bp_m_pricelist_id numeric(10)  
218 salesrep_bp_naics character(6)  
219 salesrep_bp_name2 character varying(60)  
220 salesrep_bp_numberemployees numeric(10)  
221 salesrep_bp_paymentrule character(1)  
222 salesrep_bp_paymentrulepo character(1)  
223 salesrep_bp_po_discountschm_id numeric(10)  
224 salesrep_bp_po_paymentterm_id numeric(10)  
225 salesrep_bp_po_pricelist_id numeric(10)  
226 salesrep_bp_poreference character varying(20)  
227 salesrep_bp_potentiallifevalue numeric  
228 salesrep_bp_rating character(1)  
229 salesrep_bp_referenceno character varying(40)  
230 salesrep_bp_salesrep_id numeric(10)  
231 salesrep_bp_salesvolume numeric(10)  
232 salesrep_bp_sendemail character(1)  
233 salesrep_bp_shareofcustomer numeric(10)  
234 salesrep_bp_shelflifeminpct numeric(10)  
235 salesrep_bp_so_creditlimit numeric  
236 salesrep_bp_socreditstatus character(1)  
237 salesrep_bp_so_creditused numeric  
238 salesrep_bp_so_description character varying(255)  
239 salesrep_bp_taxid character varying(20)  
240 salesrep_bp_totalopenbalance numeric  
241 salesrep_bp_updated timestamp without time zone  
242 salesrep_bp_updatedby numeric(10)  
243 salesrep_bp_url character varying(120)  
244 salesrep_bp_value character varying(40)  
245 c_greeting_ad_org_id numeric(10)  
246 c_greeting_isactive character(1)  
247 isfirstnameonly character(1)  
248 c_greeting_name character varying(60)  
249 ad_user_ad_org_id numeric(10)  
250 ad_user_ad_orgtrx_id numeric(10)  
251 ad_user_ad_birthday timestamp without time zone  
252 ad_user_c_bpartner_id numeric(10)  
253 ad_user_c_bpartner_location_id numeric(10)  
254 ad_user_c_greeting_id numeric(10)  
255 ad_user_comments character varying(2000)  
256 ad_user_created timestamp without time zone  
257 ad_user_createdby numeric(10)  
258 ad_user_description character varying(255)  
259 ad_user_email character varying(60)  
260 ad_user_fax character varying(40)  
261 ad_user_isactive character(1)  
262 ad_user_lastcontact timestamp without time zone  
263 ad_user_lastresult character varying(255)  
264 ad_user_phone2 character varying(40)  
265 ad_user_supervisor_id numeric(10)  
266 ad_user_updated timestamp without time zone  
267 ad_user_updatedby numeric(10)  
268 ad_user_value character varying(40)  
269 c_user_greeting_ad_org_id numeric(10)  
270 c_user_greeting_c_greeting_id numeric(10)  
271 c_user_greeting_isactive character(1)  
272 c_user_greeting_isfnameonly character(1)  
273 c_user_greeting_name character varying(60)  
274 c_bp_location_ad_org_id numeric(10)  
275 c_bp_location_c_bpartner_id numeric(10)  
276 c_bp_location_created timestamp without time zone  
277 c_bp_location_createdby numeric(10)  
278 c_salesregion_id numeric(10)  
279 c_bp_location_fax character varying(40)  
280 c_bp_location_isactive character(1)  
281 isbillto character(1)  
282 isdn character varying(40)  
283 ispayfrom character(1)  
284 isremitto character(1)  
285 isshipto character(1)  
286 c_bp_location_name character varying(60)  
287 c_bp_location_phone character varying(40)  
288 c_bp_location_phone2 character varying(40)  
289 c_bp_location_updated timestamp without time zone  
290 c_bp_location_updatedby numeric(10)  
291 c_paymentterm_ad_org_id numeric(10)  
292 afterdelivery character(1)  
293 c_paymentterm_c_paymentterm_id numeric(10)  
294 c_paymentterm_description character varying(255)  
295 discount numeric  
296 discount2 numeric  
297 discountdays numeric(10)  
298 discountdays2 numeric(10)  
299 fixmonthcutoff numeric(10)  
300 fixmonthday numeric(10)  
301 fixmonthoffset numeric(10)  
302 gracedays numeric(10)  
303 c_paymentterm_isactive character(1)  
304 isdefault character(1)  
305 isduefixed character(1)  
306 isnextbusinessday character(1)  
307 isvalid character(1)  
308 netday character(1)  
309 netdays numeric(10)  
310 paymenttermusage character(1)  
311 c_paymentterm_value character varying(40)  


ソース
ソース
 SELECT p.ad_client_id,
p.ad_org_id,
p.isactive,
p.created,
p.createdby,
p.updated,
p.updatedby,
ptt.ad_language,
p.c_project_id,
p.value,
p.name AS projectname,
p.description,
p.note,
p.issummary,
p.projectcategory,
oi.c_location_id AS org_location_id,
oi.taxid,
p.c_projecttype_id,
pjt.name AS projecttypename,
p.c_phase_id,
pjp.name AS projectphasename,
p.salesrep_id,
COALESCE(ubp.name, u.name) AS salesrep_name,
p.c_bpartner_id,
bp.value AS bpvalue,
bp.taxid AS bptaxid,
bp.naics,
bp.duns,
bpgt.greeting AS bpgreeting,
bp.name,
bp.name2,
bpcgt.greeting AS bpcontactgreeting,
bpc.title,
bpc.phone,
NULLIF((bpc.name)::text, (bp.name)::text) AS contactname,
bpl.c_location_id,
bp.referenceno,
ptt.name AS paymentterm,
ptt.documentnote AS paymenttermnote,
p.poreference,
p.c_currency_id,
p.m_pricelist_version_id,
p.c_campaign_id,
p.plannedamt,
p.plannedqty,
p.plannedmarginamt,
p.invoicedamt,
p.invoicedqty,
p.projectbalanceamt,
p.iscommitment,
p.committedamt,
p.committedqty,
p.datecontract,
p.datefinish,
p.iscommitceiling,
p.m_warehouse_id,
COALESCE(oi.logo_id, ci.logo_id) AS logo_id,
p.ad_user_id,
p.c_bpartner_location_id,
p.copyfrom,
p.c_paymentterm_id AS c_project_c_paymentterm_id,
p.generateto,
p.processed AS c_project_processed,
p.processing AS c_project_processing,
p.projectlinelevel,
p.projinvoicerule,
bp.acqusitioncost AS c_bp_acqusitioncost,
bp.actuallifetimevalue AS c_bp_actuallifetimevalue,
bp.ad_language AS c_bp_ad_language,
bp.ad_orgbp_id AS c_bp_ad_orgbp_id,
bp.ad_org_id AS c_bp_ad_org_id,
bp.bpartner_parent_id AS c_bp_bpartner_parent_id,
bp.c_bp_group_id AS c_bp_c_bp_group_id,
bp.c_dunning_id AS c_bp_c_dunning_id,
bp.c_greeting_id AS c_bp_c_greeting_id,
bp.c_invoiceschedule_id AS c_bp_c_invoiceschedule_id,
bp.c_paymentterm_id AS c_bp_c_paymentterm_id,
bp.created AS c_bp_created,
bp.createdby AS c_bp_createdby,
bp.c_taxgroup_id AS c_bp_c_taxgroup_id,
bp.deliveryrule AS c_bp_deliveryrule,
bp.deliveryviarule AS c_bp_deliveryviarule,
bp.description AS c_bp_description,
bp.dunninggrace AS c_bp_dunninggrace,
bp.firstsale AS c_bp_firstsale,
bp.flatdiscount AS c_bp_flatdiscount,
bp.freightcostrule AS c_bp_freightcostrule,
bp.invoicerule AS c_bp_invoicerule,
bp.isactive AS c_bp_isactive,
bp.iscustomer AS c_bp_iscustomer,
bp.isdiscountprinted AS c_bp_isdiscountprinted,
bp.isemployee AS c_bp_isemployee,
bp.ismanufacturer AS c_bp_ismanufacturer,
bp.isonetime AS c_bp_isonetime,
bp.ispotaxexempt AS c_bp_ispotaxexempt,
bp.isprospect AS c_bp_isprospect,
bp.issalesrep AS c_bp_issalesrep,
bp.issummary AS c_bp_issummary,
bp.istaxexempt AS c_bp_istaxexempt,
bp.isvendor AS c_bp_isvendor,
bp.logo_id AS c_bp_logo_id,
bp.m_discountschema_id AS c_bp_m_discountschema_id,
bp.m_pricelist_id AS c_bp_m_pricelist_id,
bp.numberemployees AS c_bp_numberemployees,
bp.paymentrule AS c_bp_paymentrule,
bp.paymentrulepo AS c_bp_paymentrulepo,
bp.po_discountschema_id AS c_bp_po_discountschema_id,
bp.po_paymentterm_id AS c_bp_po_paymentterm_id,
bp.po_pricelist_id AS c_bp_po_pricelist_id,
bp.poreference AS c_bp_poreference,
bp.potentiallifetimevalue AS c_bp_potentiallifetimevalue,
bp.rating AS c_bp_rating,
bp.salesrep_id AS c_bp_salesrep_id,
bp.salesvolume AS c_bp_salesvolume,
bp.sendemail AS c_bp_sendemail,
bp.shareofcustomer AS c_bp_shareofcustomer,
bp.shelflifeminpct AS c_bp_shelflifeminpct,
bp.so_creditlimit AS c_bp_so_creditlimit,
bp.socreditstatus AS c_bp_socreditstatus,
bp.so_creditused AS c_bp_so_creditused,
bp.so_description AS c_bp_so_description,
bp.totalopenbalance AS c_bp_totalopenbalance,
bp.updated AS c_bp_updated,
bp.updatedby AS c_bp_updatedby,
bp.url AS c_bp_url,
oi.ad_org_id AS ad_orginfo_ad_org_id,
oi.ad_orgtype_id,
oi.c_calendar_id,
oi.created AS ad_orginfo_created,
oi.createdby AS ad_orginfo_createdby,
oi.dropship_warehouse_id,
oi.duns AS ad_orginfo_duns,
oi.email AS ad_orginfo_email,
oi.fax AS ad_orginfo_fax,
oi.isactive AS ad_orginfo_isactive,
oi.m_warehouse_id AS ad_orginfo_m_warehouse_id,
oi.parent_org_id,
oi.phone AS ad_orginfo_phone,
oi.phone2 AS ad_orginfo_phone2,
oi.receiptfootermsg,
oi.supervisor_id,
oi.updated AS ad_orginfo_updated,
oi.updatedby AS ad_orginfo_updatedby,
pjt.ad_org_id AS c_projecttype_ad_org_id,
pjt.description AS c_projecttype_description,
pjt.help AS c_projecttype_help,
pjt.isactive AS c_projecttype_isactive,
pjt.projectcategory AS c_projecttype_projectcategory,
pjp.ad_org_id AS c_phase_ad_org_id,
pjp.c_phase_id AS c_phase_c_phase_id,
pjp.c_projecttype_id AS c_phase_c_projecttype_id,
pjp.description AS c_phase_description,
pjp.help AS c_phase_help,
pjp.isactive AS c_phase_isactive,
pjp.m_product_id AS c_phase_m_product_id,
pjp.seqno AS c_phase_seqno,
pjp.standardqty,
u.ad_org_id AS salesrep_ad_org_id,
u.ad_orgtrx_id AS salesrep_ad_orgtrx_id,
u.birthday AS salesrep_ad_birthday,
u.c_bpartner_id AS salesrep_c_bpartner_id,
u.c_bpartner_location_id AS salesrep_c_bp_location_id,
u.c_greeting_id AS salesrep_c_greeting_id,
u.comments AS salesrep_comments,
u.created AS salesrep_created,
u.createdby AS salesrep_createdby,
u.description AS salesrep_description,
u.email AS salesrep_email,
u.fax AS salesrep_fax,
u.isactive AS salesrep_isactive,
u.lastcontact AS salesrep_lastcontact,
u.lastresult AS salesrep_lastresult,
u.phone AS salesrep_phone,
u.phone2 AS salesrep_phone2,
u.supervisor_id AS salesrep_supervisor_id,
u.title AS salesrep_title,
u.updated AS salesrep_updated,
u.updatedby AS salesrep_updatedby,
u.value AS salesrep_value,
ubp.acqusitioncost AS salesrep_bp_acqusitioncost,
ubp.actuallifetimevalue AS salesrep_bp_actuallifevalue,
ubp.ad_language AS salesrep_bp_ad_language,
ubp.ad_orgbp_id AS salesrep_bp_ad_orgbp_id,
ubp.ad_org_id AS salesrep_bp_ad_org_id,
ubp.bpartner_parent_id AS salesrep_bp_bpartner_parent_id,
ubp.c_bp_group_id AS salesrep_bp_c_bp_group_id,
ubp.c_dunning_id AS salesrep_bp_c_dunning_id,
ubp.c_greeting_id AS salesrep_bp_c_greeting_id,
ubp.c_invoiceschedule_id AS salesrep_bp_c_invoicesched_id,
ubp.c_paymentterm_id AS salesrep_bp_c_paymentterm_id,
ubp.created AS salesrep_bp_created,
ubp.createdby AS salesrep_bp_createdby,
ubp.c_taxgroup_id AS salesrep_bp_c_taxgroup_id,
ubp.deliveryrule AS salesrep_bp_deliveryrule,
ubp.deliveryviarule AS salesrep_bp_deliveryviarule,
ubp.description AS salesrep_bp_description,
ubp.dunninggrace AS salesrep_bp_dunninggrace,
ubp.duns AS salesrep_bp_duns,
ubp.firstsale AS salesrep_bp_firstsale,
ubp.flatdiscount AS salesrep_bp_flatdiscount,
ubp.freightcostrule AS salesrep_bp_freightcostrule,
ubp.invoicerule AS salesrep_bp_invoicerule,
ubp.isactive AS salesrep_bp_isactive,
ubp.iscustomer AS salesrep_bp_iscustomer,
ubp.isdiscountprinted AS salesrep_bp_isdiscountprinted,
ubp.isemployee AS salesrep_bp_isemployee,
ubp.ismanufacturer AS salesrep_bp_ismanufacturer,
ubp.isonetime AS salesrep_bp_isonetime,
ubp.ispotaxexempt AS salesrep_bp_ispotaxexempt,
ubp.isprospect AS salesrep_bp_isprospect,
ubp.issalesrep AS salesrep_bp_issalesrep,
ubp.issummary AS salesrep_bp_issummary,
ubp.istaxexempt AS salesrep_bp_istaxexempt,
ubp.isvendor AS salesrep_bp_isvendor,
ubp.logo_id AS salesrep_bp_logo_id,
ubp.m_discountschema_id AS salesrep_bp_m_discountschm_id,
ubp.m_pricelist_id AS salesrep_bp_m_pricelist_id,
ubp.naics AS salesrep_bp_naics,
ubp.name2 AS salesrep_bp_name2,
ubp.numberemployees AS salesrep_bp_numberemployees,
ubp.paymentrule AS salesrep_bp_paymentrule,
ubp.paymentrulepo AS salesrep_bp_paymentrulepo,
ubp.po_discountschema_id AS salesrep_bp_po_discountschm_id,
ubp.po_paymentterm_id AS salesrep_bp_po_paymentterm_id,
ubp.po_pricelist_id AS salesrep_bp_po_pricelist_id,
ubp.poreference AS salesrep_bp_poreference,
ubp.potentiallifetimevalue AS salesrep_bp_potentiallifevalue,
ubp.rating AS salesrep_bp_rating,
ubp.referenceno AS salesrep_bp_referenceno,
ubp.salesrep_id AS salesrep_bp_salesrep_id,
ubp.salesvolume AS salesrep_bp_salesvolume,
ubp.sendemail AS salesrep_bp_sendemail,
ubp.shareofcustomer AS salesrep_bp_shareofcustomer,
ubp.shelflifeminpct AS salesrep_bp_shelflifeminpct,
ubp.so_creditlimit AS salesrep_bp_so_creditlimit,
ubp.socreditstatus AS salesrep_bp_socreditstatus,
ubp.so_creditused AS salesrep_bp_so_creditused,
ubp.so_description AS salesrep_bp_so_description,
ubp.taxid AS salesrep_bp_taxid,
ubp.totalopenbalance AS salesrep_bp_totalopenbalance,
ubp.updated AS salesrep_bp_updated,
ubp.updatedby AS salesrep_bp_updatedby,
ubp.url AS salesrep_bp_url,
ubp.value AS salesrep_bp_value,
bpgt.ad_org_id AS c_greeting_ad_org_id,
bpgt.isactive AS c_greeting_isactive,
bpg.isfirstnameonly,
bpgt.name AS c_greeting_name,
bpc.ad_org_id AS ad_user_ad_org_id,
bpc.ad_orgtrx_id AS ad_user_ad_orgtrx_id,
bpc.birthday AS ad_user_ad_birthday,
bpc.c_bpartner_id AS ad_user_c_bpartner_id,
bpc.c_bpartner_location_id AS ad_user_c_bpartner_location_id,
bpc.c_greeting_id AS ad_user_c_greeting_id,
bpc.comments AS ad_user_comments,
bpc.created AS ad_user_created,
bpc.createdby AS ad_user_createdby,
bpc.description AS ad_user_description,
bpc.email AS ad_user_email,
bpc.fax AS ad_user_fax,
bpc.isactive AS ad_user_isactive,
bpc.lastcontact AS ad_user_lastcontact,
bpc.lastresult AS ad_user_lastresult,
bpc.phone2 AS ad_user_phone2,
bpc.supervisor_id AS ad_user_supervisor_id,
bpc.updated AS ad_user_updated,
bpc.updatedby AS ad_user_updatedby,
bpc.value AS ad_user_value,
bpcgt.ad_org_id AS c_user_greeting_ad_org_id,
bpcgt.c_greeting_id AS c_user_greeting_c_greeting_id,
bpcgt.isactive AS c_user_greeting_isactive,
bpcg.isfirstnameonly AS c_user_greeting_isfnameonly,
bpcgt.name AS c_user_greeting_name,
bpl.ad_org_id AS c_bp_location_ad_org_id,
bpl.c_bpartner_id AS c_bp_location_c_bpartner_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,
ptt.ad_org_id AS c_paymentterm_ad_org_id,
pt.afterdelivery,
pt.c_paymentterm_id AS c_paymentterm_c_paymentterm_id,
ptt.description AS c_paymentterm_description,
pt.discount,
pt.discount2,
pt.discountdays,
pt.discountdays2,
pt.fixmonthcutoff,
pt.fixmonthday,
pt.fixmonthoffset,
pt.gracedays,
ptt.isactive AS c_paymentterm_isactive,
pt.isdefault,
pt.isduefixed,
pt.isnextbusinessday,
pt.isvalid,
pt.netday,
pt.netdays,
pt.paymenttermusage,
pt.value AS c_paymentterm_value
FROM (((((((((((((((c_project p
LEFT JOIN c_bpartner bp ON ((p.c_bpartner_id = bp.c_bpartner_id)))
JOIN ad_orginfo oi ON ((p.ad_org_id = oi.ad_org_id)))
JOIN ad_clientinfo ci ON ((p.ad_client_id = ci.ad_client_id)))
LEFT JOIN c_paymentterm pt ON ((p.c_paymentterm_id = pt.c_paymentterm_id)))
LEFT JOIN c_paymentterm_trl ptt ON ((p.c_paymentterm_id = ptt.c_paymentterm_id)))
LEFT JOIN c_projecttype pjt ON ((p.c_projecttype_id = pjt.c_projecttype_id)))
LEFT JOIN c_phase pjp ON ((p.c_phase_id = pjp.c_phase_id)))
LEFT JOIN ad_user u ON ((p.salesrep_id = u.ad_user_id)))
LEFT JOIN c_bpartner ubp ON ((u.c_bpartner_id = ubp.c_bpartner_id)))
LEFT JOIN c_greeting bpg ON ((bp.c_greeting_id = bpg.c_greeting_id)))
LEFT JOIN c_greeting_trl bpgt ON ((bp.c_greeting_id = bpgt.c_greeting_id)))
LEFT JOIN ad_user bpc ON ((p.ad_user_id = bpc.ad_user_id)))
LEFT JOIN c_greeting bpcg ON ((bpc.c_greeting_id = bpcg.c_greeting_id)))
LEFT JOIN c_greeting_trl bpcgt ON ((bpc.c_greeting_id = bpcgt.c_greeting_id)))
LEFT JOIN c_bpartner_location bpl ON ((p.c_bpartner_location_id = bpl.c_bpartner_location_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname c_project_header_vt
3 viewowner adempiere
4 definition SELECT p.ad_client_id,
p.ad_org_id,
p.isactive,
p.created,
p.createdby,
p.updated,
p.updatedby,
ptt.ad_language,
p.c_project_id,
p.value,
p.name AS projectname,
p.description,
p.note,
p.issummary,
p.projectcategory,
oi.c_location_id AS org_location_id,
oi.taxid,
p.c_projecttype_id,
pjt.name AS projecttypename,
p.c_phase_id,
pjp.name AS projectphasename,
p.salesrep_id,
COALESCE(ubp.name, u.name) AS salesrep_name,
p.c_bpartner_id,
bp.value AS bpvalue,
bp.taxid AS bptaxid,
bp.naics,
bp.duns,
bpgt.greeting AS bpgreeting,
bp.name,
bp.name2,
bpcgt.greeting AS bpcontactgreeting,
bpc.title,
bpc.phone,
NULLIF((bpc.name)::text, (bp.name)::text) AS contactname,
bpl.c_location_id,
bp.referenceno,
ptt.name AS paymentterm,
ptt.documentnote AS paymenttermnote,
p.poreference,
p.c_currency_id,
p.m_pricelist_version_id,
p.c_campaign_id,
p.plannedamt,
p.plannedqty,
p.plannedmarginamt,
p.invoicedamt,
p.invoicedqty,
p.projectbalanceamt,
p.iscommitment,
p.committedamt,
p.committedqty,
p.datecontract,
p.datefinish,
p.iscommitceiling,
p.m_warehouse_id,
COALESCE(oi.logo_id, ci.logo_id) AS logo_id,
p.ad_user_id,
p.c_bpartner_location_id,
p.copyfrom,
p.c_paymentterm_id AS c_project_c_paymentterm_id,
p.generateto,
p.processed AS c_project_processed,
p.processing AS c_project_processing,
p.projectlinelevel,
p.projinvoicerule,
bp.acqusitioncost AS c_bp_acqusitioncost,
bp.actuallifetimevalue AS c_bp_actuallifetimevalue,
bp.ad_language AS c_bp_ad_language,
bp.ad_orgbp_id AS c_bp_ad_orgbp_id,
bp.ad_org_id AS c_bp_ad_org_id,
bp.bpartner_parent_id AS c_bp_bpartner_parent_id,
bp.c_bp_group_id AS c_bp_c_bp_group_id,
bp.c_dunning_id AS c_bp_c_dunning_id,
bp.c_greeting_id AS c_bp_c_greeting_id,
bp.c_invoiceschedule_id AS c_bp_c_invoiceschedule_id,
bp.c_paymentterm_id AS c_bp_c_paymentterm_id,
bp.created AS c_bp_created,
bp.createdby AS c_bp_createdby,
bp.c_taxgroup_id AS c_bp_c_taxgroup_id,
bp.deliveryrule AS c_bp_deliveryrule,
bp.deliveryviarule AS c_bp_deliveryviarule,
bp.description AS c_bp_description,
bp.dunninggrace AS c_bp_dunninggrace,
bp.firstsale AS c_bp_firstsale,
bp.flatdiscount AS c_bp_flatdiscount,
bp.freightcostrule AS c_bp_freightcostrule,
bp.invoicerule AS c_bp_invoicerule,
bp.isactive AS c_bp_isactive,
bp.iscustomer AS c_bp_iscustomer,
bp.isdiscountprinted AS c_bp_isdiscountprinted,
bp.isemployee AS c_bp_isemployee,
bp.ismanufacturer AS c_bp_ismanufacturer,
bp.isonetime AS c_bp_isonetime,
bp.ispotaxexempt AS c_bp_ispotaxexempt,
bp.isprospect AS c_bp_isprospect,
bp.issalesrep AS c_bp_issalesrep,
bp.issummary AS c_bp_issummary,
bp.istaxexempt AS c_bp_istaxexempt,
bp.isvendor AS c_bp_isvendor,
bp.logo_id AS c_bp_logo_id,
bp.m_discountschema_id AS c_bp_m_discountschema_id,
bp.m_pricelist_id AS c_bp_m_pricelist_id,
bp.numberemployees AS c_bp_numberemployees,
bp.paymentrule AS c_bp_paymentrule,
bp.paymentrulepo AS c_bp_paymentrulepo,
bp.po_discountschema_id AS c_bp_po_discountschema_id,
bp.po_paymentterm_id AS c_bp_po_paymentterm_id,
bp.po_pricelist_id AS c_bp_po_pricelist_id,
bp.poreference AS c_bp_poreference,
bp.potentiallifetimevalue AS c_bp_potentiallifetimevalue,
bp.rating AS c_bp_rating,
bp.salesrep_id AS c_bp_salesrep_id,
bp.salesvolume AS c_bp_salesvolume,
bp.sendemail AS c_bp_sendemail,
bp.shareofcustomer AS c_bp_shareofcustomer,
bp.shelflifeminpct AS c_bp_shelflifeminpct,
bp.so_creditlimit AS c_bp_so_creditlimit,
bp.socreditstatus AS c_bp_socreditstatus,
bp.so_creditused AS c_bp_so_creditused,
bp.so_description AS c_bp_so_description,
bp.totalopenbalance AS c_bp_totalopenbalance,
bp.updated AS c_bp_updated,
bp.updatedby AS c_bp_updatedby,
bp.url AS c_bp_url,
oi.ad_org_id AS ad_orginfo_ad_org_id,
oi.ad_orgtype_id,
oi.c_calendar_id,
oi.created AS ad_orginfo_created,
oi.createdby AS ad_orginfo_createdby,
oi.dropship_warehouse_id,
oi.duns AS ad_orginfo_duns,
oi.email AS ad_orginfo_email,
oi.fax AS ad_orginfo_fax,
oi.isactive AS ad_orginfo_isactive,
oi.m_warehouse_id AS ad_orginfo_m_warehouse_id,
oi.parent_org_id,
oi.phone AS ad_orginfo_phone,
oi.phone2 AS ad_orginfo_phone2,
oi.receiptfootermsg,
oi.supervisor_id,
oi.updated AS ad_orginfo_updated,
oi.updatedby AS ad_orginfo_updatedby,
pjt.ad_org_id AS c_projecttype_ad_org_id,
pjt.description AS c_projecttype_description,
pjt.help AS c_projecttype_help,
pjt.isactive AS c_projecttype_isactive,
pjt.projectcategory AS c_projecttype_projectcategory,
pjp.ad_org_id AS c_phase_ad_org_id,
pjp.c_phase_id AS c_phase_c_phase_id,
pjp.c_projecttype_id AS c_phase_c_projecttype_id,
pjp.description AS c_phase_description,
pjp.help AS c_phase_help,
pjp.isactive AS c_phase_isactive,
pjp.m_product_id AS c_phase_m_product_id,
pjp.seqno AS c_phase_seqno,
pjp.standardqty,
u.ad_org_id AS salesrep_ad_org_id,
u.ad_orgtrx_id AS salesrep_ad_orgtrx_id,
u.birthday AS salesrep_ad_birthday,
u.c_bpartner_id AS salesrep_c_bpartner_id,
u.c_bpartner_location_id AS salesrep_c_bp_location_id,
u.c_greeting_id AS salesrep_c_greeting_id,
u.comments AS salesrep_comments,
u.created AS salesrep_created,
u.createdby AS salesrep_createdby,
u.description AS salesrep_description,
u.email AS salesrep_email,
u.fax AS salesrep_fax,
u.isactive AS salesrep_isactive,
u.lastcontact AS salesrep_lastcontact,
u.lastresult AS salesrep_lastresult,
u.phone AS salesrep_phone,
u.phone2 AS salesrep_phone2,
u.supervisor_id AS salesrep_supervisor_id,
u.title AS salesrep_title,
u.updated AS salesrep_updated,
u.updatedby AS salesrep_updatedby,
u.value AS salesrep_value,
ubp.acqusitioncost AS salesrep_bp_acqusitioncost,
ubp.actuallifetimevalue AS salesrep_bp_actuallifevalue,
ubp.ad_language AS salesrep_bp_ad_language,
ubp.ad_orgbp_id AS salesrep_bp_ad_orgbp_id,
ubp.ad_org_id AS salesrep_bp_ad_org_id,
ubp.bpartner_parent_id AS salesrep_bp_bpartner_parent_id,
ubp.c_bp_group_id AS salesrep_bp_c_bp_group_id,
ubp.c_dunning_id AS salesrep_bp_c_dunning_id,
ubp.c_greeting_id AS salesrep_bp_c_greeting_id,
ubp.c_invoiceschedule_id AS salesrep_bp_c_invoicesched_id,
ubp.c_paymentterm_id AS salesrep_bp_c_paymentterm_id,
ubp.created AS salesrep_bp_created,
ubp.createdby AS salesrep_bp_createdby,
ubp.c_taxgroup_id AS salesrep_bp_c_taxgroup_id,
ubp.deliveryrule AS salesrep_bp_deliveryrule,
ubp.deliveryviarule AS salesrep_bp_deliveryviarule,
ubp.description AS salesrep_bp_description,
ubp.dunninggrace AS salesrep_bp_dunninggrace,
ubp.duns AS salesrep_bp_duns,
ubp.firstsale AS salesrep_bp_firstsale,
ubp.flatdiscount AS salesrep_bp_flatdiscount,
ubp.freightcostrule AS salesrep_bp_freightcostrule,
ubp.invoicerule AS salesrep_bp_invoicerule,
ubp.isactive AS salesrep_bp_isactive,
ubp.iscustomer AS salesrep_bp_iscustomer,
ubp.isdiscountprinted AS salesrep_bp_isdiscountprinted,
ubp.isemployee AS salesrep_bp_isemployee,
ubp.ismanufacturer AS salesrep_bp_ismanufacturer,
ubp.isonetime AS salesrep_bp_isonetime,
ubp.ispotaxexempt AS salesrep_bp_ispotaxexempt,
ubp.isprospect AS salesrep_bp_isprospect,
ubp.issalesrep AS salesrep_bp_issalesrep,
ubp.issummary AS salesrep_bp_issummary,
ubp.istaxexempt AS salesrep_bp_istaxexempt,
ubp.isvendor AS salesrep_bp_isvendor,
ubp.logo_id AS salesrep_bp_logo_id,
ubp.m_discountschema_id AS salesrep_bp_m_discountschm_id,
ubp.m_pricelist_id AS salesrep_bp_m_pricelist_id,
ubp.naics AS salesrep_bp_naics,
ubp.name2 AS salesrep_bp_name2,
ubp.numberemployees AS salesrep_bp_numberemployees,
ubp.paymentrule AS salesrep_bp_paymentrule,
ubp.paymentrulepo AS salesrep_bp_paymentrulepo,
ubp.po_discountschema_id AS salesrep_bp_po_discountschm_id,
ubp.po_paymentterm_id AS salesrep_bp_po_paymentterm_id,
ubp.po_pricelist_id AS salesrep_bp_po_pricelist_id,
ubp.poreference AS salesrep_bp_poreference,
ubp.potentiallifetimevalue AS salesrep_bp_potentiallifevalue,
ubp.rating AS salesrep_bp_rating,
ubp.referenceno AS salesrep_bp_referenceno,
ubp.salesrep_id AS salesrep_bp_salesrep_id,
ubp.salesvolume AS salesrep_bp_salesvolume,
ubp.sendemail AS salesrep_bp_sendemail,
ubp.shareofcustomer AS salesrep_bp_shareofcustomer,
ubp.shelflifeminpct AS salesrep_bp_shelflifeminpct,
ubp.so_creditlimit AS salesrep_bp_so_creditlimit,
ubp.socreditstatus AS salesrep_bp_socreditstatus,
ubp.so_creditused AS salesrep_bp_so_creditused,
ubp.so_description AS salesrep_bp_so_description,
ubp.taxid AS salesrep_bp_taxid,
ubp.totalopenbalance AS salesrep_bp_totalopenbalance,
ubp.updated AS salesrep_bp_updated,
ubp.updatedby AS salesrep_bp_updatedby,
ubp.url AS salesrep_bp_url,
ubp.value AS salesrep_bp_value,
bpgt.ad_org_id AS c_greeting_ad_org_id,
bpgt.isactive AS c_greeting_isactive,
bpg.isfirstnameonly,
bpgt.name AS c_greeting_name,
bpc.ad_org_id AS ad_user_ad_org_id,
bpc.ad_orgtrx_id AS ad_user_ad_orgtrx_id,
bpc.birthday AS ad_user_ad_birthday,
bpc.c_bpartner_id AS ad_user_c_bpartner_id,
bpc.c_bpartner_location_id AS ad_user_c_bpartner_location_id,
bpc.c_greeting_id AS ad_user_c_greeting_id,
bpc.comments AS ad_user_comments,
bpc.created AS ad_user_created,
bpc.createdby AS ad_user_createdby,
bpc.description AS ad_user_description,
bpc.email AS ad_user_email,
bpc.fax AS ad_user_fax,
bpc.isactive AS ad_user_isactive,
bpc.lastcontact AS ad_user_lastcontact,
bpc.lastresult AS ad_user_lastresult,
bpc.phone2 AS ad_user_phone2,
bpc.supervisor_id AS ad_user_supervisor_id,
bpc.updated AS ad_user_updated,
bpc.updatedby AS ad_user_updatedby,
bpc.value AS ad_user_value,
bpcgt.ad_org_id AS c_user_greeting_ad_org_id,
bpcgt.c_greeting_id AS c_user_greeting_c_greeting_id,
bpcgt.isactive AS c_user_greeting_isactive,
bpcg.isfirstnameonly AS c_user_greeting_isfnameonly,
bpcgt.name AS c_user_greeting_name,
bpl.ad_org_id AS c_bp_location_ad_org_id,
bpl.c_bpartner_id AS c_bp_location_c_bpartner_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,
ptt.ad_org_id AS c_paymentterm_ad_org_id,
pt.afterdelivery,
pt.c_paymentterm_id AS c_paymentterm_c_paymentterm_id,
ptt.description AS c_paymentterm_description,
pt.discount,
pt.discount2,
pt.discountdays,
pt.discountdays2,
pt.fixmonthcutoff,
pt.fixmonthday,
pt.fixmonthoffset,
pt.gracedays,
ptt.isactive AS c_paymentterm_isactive,
pt.isdefault,
pt.isduefixed,
pt.isnextbusinessday,
pt.isvalid,
pt.netday,
pt.netdays,
pt.paymenttermusage,
pt.value AS c_paymentterm_value
FROM (((((((((((((((c_project p
LEFT JOIN c_bpartner bp ON ((p.c_bpartner_id = bp.c_bpartner_id)))
JOIN ad_orginfo oi ON ((p.ad_org_id = oi.ad_org_id)))
JOIN ad_clientinfo ci ON ((p.ad_client_id = ci.ad_client_id)))
LEFT JOIN c_paymentterm pt ON ((p.c_paymentterm_id = pt.c_paymentterm_id)))
LEFT JOIN c_paymentterm_trl ptt ON ((p.c_paymentterm_id = ptt.c_paymentterm_id)))
LEFT JOIN c_projecttype pjt ON ((p.c_projecttype_id = pjt.c_projecttype_id)))
LEFT JOIN c_phase pjp ON ((p.c_phase_id = pjp.c_phase_id)))
LEFT JOIN ad_user u ON ((p.salesrep_id = u.ad_user_id)))
LEFT JOIN c_bpartner ubp ON ((u.c_bpartner_id = ubp.c_bpartner_id)))
LEFT JOIN c_greeting bpg ON ((bp.c_greeting_id = bpg.c_greeting_id)))
LEFT JOIN c_greeting_trl bpgt ON ((bp.c_greeting_id = bpgt.c_greeting_id)))
LEFT JOIN ad_user bpc ON ((p.ad_user_id = bpc.ad_user_id)))
LEFT JOIN c_greeting bpcg ON ((bpc.c_greeting_id = bpcg.c_greeting_id)))
LEFT JOIN c_greeting_trl bpcgt ON ((bpc.c_greeting_id = bpcgt.c_greeting_id)))
LEFT JOIN c_bpartner_location bpl ON ((p.c_bpartner_location_id = bpl.c_bpartner_location_id)));