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


カラム情報
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  
9 c_project_id numeric(10)  
10 c_projectline_id numeric(10)  
11 line numeric(10)  
12 plannedqty numeric  
13 plannedprice numeric  
14 plannedamt numeric  
15 plannedmarginamt numeric  
16 committedamt numeric  
17 m_product_id numeric(10)  
18 name character varying(255)  
19 description character varying  
20 documentnote character varying(2000)  
21 upc character varying(30)  
22 sku character varying(30)  
23 productvalue character varying(40)  
24 m_product_category_id numeric(10)  
25 invoicedamt numeric  
26 invoicedqty numeric  
27 committedqty numeric  
28 c_order_id numeric(10)  
29 c_orderpo_id numeric(10)  
30 c_projectissue_id numeric(10)  
31 c_projectphase_id numeric(10)  
32 c_projecttask_id numeric(10)  
33 dopricing character(1)  
34 isprinted character(1)  
35 c_projectline_processed character(1)  
36 c_project_ad_org_id numeric(10)  
37 ad_user_id numeric(10)  
38 c_bpartner_id numeric(10)  
39 c_bpartner_location_id numeric(10)  
40 c_bpartnersr_id numeric(10)  
41 c_campaign_id numeric(10)  
42 c_currency_id numeric(10)  
43 c_project_committedamt numeric  
44 c_project_committedqty numeric  
45 c_project_copyfrom character(1)  
46 c_paymentterm_id numeric(10)  
47 c_phase_id numeric(10)  
48 c_projecttype_id numeric(10)  
49 c_project_created timestamp without time zone  
50 c_project_createdby numeric(10)  
51 datecontract timestamp without time zone  
52 datefinish timestamp without time zone  
53 c_project_description character varying(255)  
54 generateto character(1)  
55 c_project_invoicedamt numeric  
56 c_project_invoicedqty numeric  
57 c_project_isactive character(1)  
58 iscommitceiling character(1)  
59 iscommitment character(1)  
60 c_project_issummary character(1)  
61 m_pricelist_version_id numeric(10)  
62 m_warehouse_id numeric(10)  
63 c_project_name character varying(60)  
64 c_project_note character varying(2000)  
65 c_project_plannedamt numeric  
66 c_project_plannedmarginamt numeric  
67 c_project_plannedqty numeric  
68 poreference character varying(20)  
69 c_project_processed character(1)  
70 c_project_processing character(1)  
71 projectbalanceamt numeric  
72 projectcategory character(1)  
73 projectlinelevel character(1)  
74 projinvoicerule character(1)  
75 c_project_salesrep_id numeric(10)  
76 c_project_updated timestamp without time zone  
77 c_project_updatedby numeric(10)  
78 c_project_value character varying(40)  
79 m_product_ad_org_id numeric(10)  
80 classification character varying(12)  
81 m_product_copyfrom character(1)  
82 m_product_created timestamp without time zone  
83 m_product_createdby numeric(10)  
84 c_revenuerecognition_id numeric(10)  
85 c_subscriptiontype_id numeric(10)  
86 c_taxcategory_id numeric(10)  
87 c_uom_id numeric(10)  
88 m_product_description character varying(255)  
89 descriptionurl character varying(120)  
90 discontinued character(1)  
91 discontinuedat timestamp without time zone  
92 group1 character varying(255)  
93 group2 character varying(255)  
94 guaranteedays numeric(10)  
95 guaranteedaysmin numeric(10)  
96 help character varying(2000)  
97 imageurl character varying(120)  
98 m_product_isactive character(1)  
99 isdropship character(1)  
100 isexcludeautodelivery character(1)  
101 isinvoiceprintdetails character(1)  
102 ispicklistprintdetails character(1)  
103 ispurchased character(1)  
104 isselfservice character(1)  
105 issold character(1)  
106 isstocked character(1)  
107 m_product_issummary character(1)  
108 isverified character(1)  
109 iswebstorefeatured character(1)  
110 lowlevel numeric(10)  
111 m_attributeset_id numeric(10)  
112 m_attributesetinstance_id numeric(10)  
113 m_freightcategory_id numeric(10)  
114 m_locator_id numeric(10)  
115 m_product_m_prod_category_id numeric(10)  
116 m_product_m_product_id numeric(10)  
117 m_product_processing character(1)  
118 producttype character(1)  
119 r_mailtext_id numeric(10)  
120 m_product_salesrep_id numeric(10)  
121 s_expensetype_id numeric(10)  
122 shelfdepth numeric(10)  
123 shelfheight numeric  
124 shelfwidth numeric(10)  
125 s_resource_id numeric(10)  
126 unitsperpack numeric(10)  
127 unitsperpallet numeric  
128 m_product_updated timestamp without time zone  
129 m_product_updatedby numeric(10)  
130 versionno character varying(20)  
131 volume numeric  
132 weight numeric  


ソース
ソース
 SELECT pl.ad_client_id,
pl.ad_org_id,
pl.isactive,
pl.created,
pl.createdby,
pl.updated,
pl.updatedby,
'en_US'::character varying AS ad_language,
pj.c_project_id,
pl.c_projectline_id,
pl.line,
pl.plannedqty,
pl.plannedprice,
pl.plannedamt,
pl.plannedmarginamt,
pl.committedamt,
pl.m_product_id,
COALESCE(p.name, pl.description) AS name,
CASE
WHEN (p.name IS NOT NULL) THEN pl.description
ELSE NULL::character varying
END AS description,
p.documentnote,
p.upc,
p.sku,
p.value AS productvalue,
pl.m_product_category_id,
pl.invoicedamt,
pl.invoicedqty,
pl.committedqty,
pl.c_order_id,
pl.c_orderpo_id,
pl.c_projectissue_id,
pl.c_projectphase_id,
pl.c_projecttask_id,
pl.dopricing,
pl.isprinted,
pl.processed AS c_projectline_processed,
pj.ad_org_id AS c_project_ad_org_id,
pj.ad_user_id,
pj.c_bpartner_id,
pj.c_bpartner_location_id,
pj.c_bpartnersr_id,
pj.c_campaign_id,
pj.c_currency_id,
pj.committedamt AS c_project_committedamt,
pj.committedqty AS c_project_committedqty,
pj.copyfrom AS c_project_copyfrom,
pj.c_paymentterm_id,
pj.c_phase_id,
pj.c_projecttype_id,
pj.created AS c_project_created,
pj.createdby AS c_project_createdby,
pj.datecontract,
pj.datefinish,
pj.description AS c_project_description,
pj.generateto,
pj.invoicedamt AS c_project_invoicedamt,
pj.invoicedqty AS c_project_invoicedqty,
pj.isactive AS c_project_isactive,
pj.iscommitceiling,
pj.iscommitment,
pj.issummary AS c_project_issummary,
pj.m_pricelist_version_id,
pj.m_warehouse_id,
pj.name AS c_project_name,
pj.note AS c_project_note,
pj.plannedamt AS c_project_plannedamt,
pj.plannedmarginamt AS c_project_plannedmarginamt,
pj.plannedqty AS c_project_plannedqty,
pj.poreference,
pj.processed AS c_project_processed,
pj.processing AS c_project_processing,
pj.projectbalanceamt,
pj.projectcategory,
pj.projectlinelevel,
pj.projinvoicerule,
pj.salesrep_id AS c_project_salesrep_id,
pj.updated AS c_project_updated,
pj.updatedby AS c_project_updatedby,
pj.value AS c_project_value,
p.ad_org_id AS m_product_ad_org_id,
p.classification,
p.copyfrom AS m_product_copyfrom,
p.created AS m_product_created,
p.createdby AS m_product_createdby,
p.c_revenuerecognition_id,
p.c_subscriptiontype_id,
p.c_taxcategory_id,
p.c_uom_id,
p.description AS m_product_description,
p.descriptionurl,
p.discontinued,
p.discontinuedat,
p.group1,
p.group2,
p.guaranteedays,
p.guaranteedaysmin,
p.help,
p.imageurl,
p.isactive AS m_product_isactive,
p.isdropship,
p.isexcludeautodelivery,
p.isinvoiceprintdetails,
p.ispicklistprintdetails,
p.ispurchased,
p.isselfservice,
p.issold,
p.isstocked,
p.issummary AS m_product_issummary,
p.isverified,
p.iswebstorefeatured,
p.lowlevel,
p.m_attributeset_id,
p.m_attributesetinstance_id,
p.m_freightcategory_id,
p.m_locator_id,
p.m_product_category_id AS m_product_m_prod_category_id,
p.m_product_id AS m_product_m_product_id,
p.processing AS m_product_processing,
p.producttype,
p.r_mailtext_id,
p.salesrep_id AS m_product_salesrep_id,
p.s_expensetype_id,
p.shelfdepth,
p.shelfheight,
p.shelfwidth,
p.s_resource_id,
p.unitsperpack,
p.unitsperpallet,
p.updated AS m_product_updated,
p.updatedby AS m_product_updatedby,
p.versionno,
p.volume,
p.weight
FROM ((c_projectline pl
JOIN c_project pj ON ((pl.c_project_id = pj.c_project_id)))
LEFT JOIN m_product p ON ((pl.m_product_id = p.m_product_id)))
WHERE (pl.isprinted = 'Y'::bpchar);


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname c_project_details_v
3 viewowner adempiere
4 definition SELECT pl.ad_client_id,
pl.ad_org_id,
pl.isactive,
pl.created,
pl.createdby,
pl.updated,
pl.updatedby,
'en_US'::character varying AS ad_language,
pj.c_project_id,
pl.c_projectline_id,
pl.line,
pl.plannedqty,
pl.plannedprice,
pl.plannedamt,
pl.plannedmarginamt,
pl.committedamt,
pl.m_product_id,
COALESCE(p.name, pl.description) AS name,
CASE
WHEN (p.name IS NOT NULL) THEN pl.description
ELSE NULL::character varying
END AS description,
p.documentnote,
p.upc,
p.sku,
p.value AS productvalue,
pl.m_product_category_id,
pl.invoicedamt,
pl.invoicedqty,
pl.committedqty,
pl.c_order_id,
pl.c_orderpo_id,
pl.c_projectissue_id,
pl.c_projectphase_id,
pl.c_projecttask_id,
pl.dopricing,
pl.isprinted,
pl.processed AS c_projectline_processed,
pj.ad_org_id AS c_project_ad_org_id,
pj.ad_user_id,
pj.c_bpartner_id,
pj.c_bpartner_location_id,
pj.c_bpartnersr_id,
pj.c_campaign_id,
pj.c_currency_id,
pj.committedamt AS c_project_committedamt,
pj.committedqty AS c_project_committedqty,
pj.copyfrom AS c_project_copyfrom,
pj.c_paymentterm_id,
pj.c_phase_id,
pj.c_projecttype_id,
pj.created AS c_project_created,
pj.createdby AS c_project_createdby,
pj.datecontract,
pj.datefinish,
pj.description AS c_project_description,
pj.generateto,
pj.invoicedamt AS c_project_invoicedamt,
pj.invoicedqty AS c_project_invoicedqty,
pj.isactive AS c_project_isactive,
pj.iscommitceiling,
pj.iscommitment,
pj.issummary AS c_project_issummary,
pj.m_pricelist_version_id,
pj.m_warehouse_id,
pj.name AS c_project_name,
pj.note AS c_project_note,
pj.plannedamt AS c_project_plannedamt,
pj.plannedmarginamt AS c_project_plannedmarginamt,
pj.plannedqty AS c_project_plannedqty,
pj.poreference,
pj.processed AS c_project_processed,
pj.processing AS c_project_processing,
pj.projectbalanceamt,
pj.projectcategory,
pj.projectlinelevel,
pj.projinvoicerule,
pj.salesrep_id AS c_project_salesrep_id,
pj.updated AS c_project_updated,
pj.updatedby AS c_project_updatedby,
pj.value AS c_project_value,
p.ad_org_id AS m_product_ad_org_id,
p.classification,
p.copyfrom AS m_product_copyfrom,
p.created AS m_product_created,
p.createdby AS m_product_createdby,
p.c_revenuerecognition_id,
p.c_subscriptiontype_id,
p.c_taxcategory_id,
p.c_uom_id,
p.description AS m_product_description,
p.descriptionurl,
p.discontinued,
p.discontinuedat,
p.group1,
p.group2,
p.guaranteedays,
p.guaranteedaysmin,
p.help,
p.imageurl,
p.isactive AS m_product_isactive,
p.isdropship,
p.isexcludeautodelivery,
p.isinvoiceprintdetails,
p.ispicklistprintdetails,
p.ispurchased,
p.isselfservice,
p.issold,
p.isstocked,
p.issummary AS m_product_issummary,
p.isverified,
p.iswebstorefeatured,
p.lowlevel,
p.m_attributeset_id,
p.m_attributesetinstance_id,
p.m_freightcategory_id,
p.m_locator_id,
p.m_product_category_id AS m_product_m_prod_category_id,
p.m_product_id AS m_product_m_product_id,
p.processing AS m_product_processing,
p.producttype,
p.r_mailtext_id,
p.salesrep_id AS m_product_salesrep_id,
p.s_expensetype_id,
p.shelfdepth,
p.shelfheight,
p.shelfwidth,
p.s_resource_id,
p.unitsperpack,
p.unitsperpallet,
p.updated AS m_product_updated,
p.updatedby AS m_product_updatedby,
p.versionno,
p.volume,
p.weight
FROM ((c_projectline pl
JOIN c_project pj ON ((pl.c_project_id = pj.c_project_id)))
LEFT JOIN m_product p ON ((pl.m_product_id = p.m_product_id)))
WHERE (pl.isprinted = 'Y'::bpchar);