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


カラム情報
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 m_product_id numeric(10)  
9 value character varying(40)  
10 name character varying(255)  
11 upc character varying(30)  
12 isbom character(1)  
13 producttype character(1)  
14 m_product_category_id numeric(10)  
15 m_costtype_id numeric(10)  
16 m_costelement_id numeric(10)  
17 costelementtype character(1)  
18 costingmethod character(1)  
19 iscalculated character(1)  
20 c_acctschema_id numeric(10)  
21 c_currency_id numeric(10)  
22 currentcostprice numeric  
23 futurecostprice numeric  
24 description character varying(255)  
25 currentcostpricell numeric  
26 futurecostpricell numeric  
27 iscostfrozen character(1)  
28 cumulatedamt numeric  
29 cumulatedqty numeric  
30 currentqty numeric  
31 m_attributesetinstance_id numeric(10)  
32 percent numeric(10)  
33 m_product_ad_org_id numeric(10)  
34 classification character varying(12)  
35 m_product_copyfrom character(1)  
36 m_product_created timestamp without time zone  
37 m_product_createdby numeric(10)  
38 c_revenuerecognition_id numeric(10)  
39 c_subscriptiontype_id numeric(10)  
40 c_taxcategory_id numeric(10)  
41 c_uom_id numeric(10)  
42 m_product_description character varying(255)  
43 descriptionurl character varying(120)  
44 discontinued character(1)  
45 discontinuedat timestamp without time zone  
46 documentnote character varying(2000)  
47 group1 character varying(255)  
48 group2 character varying(255)  
49 guaranteedays numeric(10)  
50 guaranteedaysmin numeric(10)  
51 help character varying(2000)  
52 imageurl character varying(120)  
53 m_product_isactive character(1)  
54 isdropship character(1)  
55 isexcludeautodelivery character(1)  
56 isinvoiceprintdetails character(1)  
57 ispicklistprintdetails character(1)  
58 ispurchased character(1)  
59 isselfservice character(1)  
60 issold character(1)  
61 isstocked character(1)  
62 m_product_issummary character(1)  
63 isverified character(1)  
64 iswebstorefeatured character(1)  
65 lowlevel numeric(10)  
66 m_product_m_attributeset_id numeric(10)  
67 m_product_m_attributesetinsta numeric(10)  
68 m_freightcategory_id numeric(10)  
69 m_locator_id numeric(10)  
70 m_product_processing character(1)  
71 r_mailtext_id numeric(10)  
72 m_product_salesrep_id numeric(10)  
73 s_expensetype_id numeric(10)  
74 shelfdepth numeric(10)  
75 shelfheight numeric  
76 shelfwidth numeric(10)  
77 sku character varying(30)  
78 s_resource_id numeric(10)  
79 unitsperpack numeric(10)  
80 unitsperpallet numeric  
81 m_product_updated timestamp without time zone  
82 m_product_updatedby numeric(10)  
83 versionno character varying(20)  
84 volume numeric  
85 weight numeric  
86 m_costelement_ad_org_id numeric(10)  
87 m_costelement_description character varying(255)  
88 m_costelement_isactive character(1)  
89 m_costelement_name character varying(60)  
90 c_acctschema_ad_org_id numeric(10)  
91 c_acctschema_description character varying(255)  
92 c_acctschema_name character varying(60)  


ソース
ソース 
 SELECT c.ad_client_id,
    c.ad_org_id,
    c.isactive,
    c.created,
    c.createdby,
    c.updated,
    c.updatedby,
    p.m_product_id,
    p.value,
    p.name,
    p.upc,
    p.isbom,
    p.producttype,
    p.m_product_category_id,
    c.m_costtype_id,
    ce.m_costelement_id,
    ce.costelementtype,
    ce.costingmethod,
    ce.iscalculated,
    acct.c_acctschema_id,
    acct.c_currency_id,
    c.currentcostprice,
    c.futurecostprice,
    c.description,
    c.currentcostpricell,
    c.futurecostpricell,
    c.iscostfrozen,
    c.cumulatedamt,
    c.cumulatedqty,
    c.currentqty,
    c.m_attributesetinstance_id,
    c.percent,
    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.documentnote,
    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 AS m_product_m_attributeset_id,
    p.m_attributesetinstance_id AS m_product_m_attributesetinsta,
    p.m_freightcategory_id,
    p.m_locator_id,
    p.processing AS m_product_processing,
    p.r_mailtext_id,
    p.salesrep_id AS m_product_salesrep_id,
    p.s_expensetype_id,
    p.shelfdepth,
    p.shelfheight,
    p.shelfwidth,
    p.sku,
    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,
    ce.ad_org_id AS m_costelement_ad_org_id,
    ce.description AS m_costelement_description,
    ce.isactive AS m_costelement_isactive,
    ce.name AS m_costelement_name,
    acct.ad_org_id AS c_acctschema_ad_org_id,
    acct.description AS c_acctschema_description,
    acct.name AS c_acctschema_name
   FROM (((m_cost c
     JOIN m_product p ON ((c.m_product_id = p.m_product_id)))
     JOIN m_costelement ce ON ((c.m_costelement_id = ce.m_costelement_id)))
     JOIN c_acctschema acct ON ((c.c_acctschema_id = acct.c_acctschema_id)));


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


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


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


RDBMS固有の情報
No プロパティ名 プロパティ値
1 schemaname adempiere
2 viewname rv_cost
3 viewowner adempiere
4 definition SELECT c.ad_client_id,
c.ad_org_id,
c.isactive,
c.created,
c.createdby,
c.updated,
c.updatedby,
p.m_product_id,
p.value,
p.name,
p.upc,
p.isbom,
p.producttype,
p.m_product_category_id,
c.m_costtype_id,
ce.m_costelement_id,
ce.costelementtype,
ce.costingmethod,
ce.iscalculated,
acct.c_acctschema_id,
acct.c_currency_id,
c.currentcostprice,
c.futurecostprice,
c.description,
c.currentcostpricell,
c.futurecostpricell,
c.iscostfrozen,
c.cumulatedamt,
c.cumulatedqty,
c.currentqty,
c.m_attributesetinstance_id,
c.percent,
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.documentnote,
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 AS m_product_m_attributeset_id,
p.m_attributesetinstance_id AS m_product_m_attributesetinsta,
p.m_freightcategory_id,
p.m_locator_id,
p.processing AS m_product_processing,
p.r_mailtext_id,
p.salesrep_id AS m_product_salesrep_id,
p.s_expensetype_id,
p.shelfdepth,
p.shelfheight,
p.shelfwidth,
p.sku,
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,
ce.ad_org_id AS m_costelement_ad_org_id,
ce.description AS m_costelement_description,
ce.isactive AS m_costelement_isactive,
ce.name AS m_costelement_name,
acct.ad_org_id AS c_acctschema_ad_org_id,
acct.description AS c_acctschema_description,
acct.name AS c_acctschema_name
FROM (((m_cost c
JOIN m_product p ON ((c.m_product_id = p.m_product_id)))
JOIN m_costelement ce ON ((c.m_costelement_id = ce.m_costelement_id)))
JOIN c_acctschema acct ON ((c.c_acctschema_id = acct.c_acctschema_id)));